{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Référentiels","Accueil","SP","MP","Produits"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Référentiels","index":0,"n_rows":148,"n_cols":12,"rows_kept":148,"cut":false,"hidden":false,"merged":[]}
["Code catégorie","Nom catégorie","Code produit","Nom produit","Code jour","Nom jour","Code conditionnement","Nom conditionnement","Code destination","Nom destination","Code à modifier","Nom à modifier"]
["CC01","DMR","DMR01","Pomme","CJ01","Dimanche midi","CC01","1 bocal ou 1 boîte pour 1 repas","CD01","Menus journaliers","LCÀM01","Non"]
["CC02","DS","DS01","Pomme","CJ02","Dimanche midi et soir","CC02","1 boîte de six œufs. 3 œufs pour 1 repas","CD02","Menus midi retraite","LCÀM02","Oui"]
["CC03","DWE","DWE01","Ananas","CJ03","Dimanche soir","CC03","1 boîte ou 1 pot pour 1 repas","CD03","Menus viandes weekend"]
["CC04","LMR","DWE02","Autres fruits","CJ04","Lundi à dimanche soirs","CC04","1 boîte pour 1 repas"]
["CC05","LSLM","DWE03","Avocats","CJ05","Lundi à vendredi midis","CC05","1 boîte pour 2 repas"]
["CC06","LSMJ","DWE04","Bananes","CJ06","lundi à vendredi soirs","CC06","1 botte ou 1 sachet pour 1 repas"]
["CC07","LSV","DWE05","Clémentines","CJ07","Lundi et mardi soirs","CC07","1 botte ou 1 sachet pour 2 repas"]
["CC08","LWED","DWE06","Crème","CJ08","Mercredi et jeudi soirs","CC08","1 morceau de 400 grammes (Leclerc) pour 3 repas"]
["CC09","LWES","DWE07","Dattes","CJ09","Samedi et dimanche midis","CC09","1 morceau de 500 grammes pour 5 repas"]
["CC10","OBSE","DWE08","Figues","CJ10","Samedi et dimanche midis et soirs","CC10","1 pack de 4 pots pour le week-end. 1 pot pour 1 repas"]
["CC11","PC","DWE09","Fromage blanc","CJ11","Samedi midi et soir","CC11","1 pack de 6 pots. 3 pots pour 1 repas"]
["CC12","PVWE","DWE10","Fruits au sirop","CJ12","Vendredi soir","CC12","1 paquet pour 1 repas"]
["CC13","VMR","DWE11","Fruits de saison",null,null,"CC13","1 paquet pour 2 repas"]
["CC14","VS","DWE12","Gâteau de riz",null,null,"CC14","1 paquet pour 2 repas. 1 ou 2 saucisses pour 1 repas"]
["CC15","VWE","DWE13","Gâteau de semoule",null,null,"CC15","1 paquet pour 4 repas"]
[null,null,"DWE14","Gâteaux samedi dimanche",null,null,"CC16","1 sachet de 2 kilogrammes. 1 pomme pour 1 repas"]
[null,null,"DWE15","Mousse au chocolat",null,null,"CC17","1 sachet pour 2 repas"]
[null,null,"DWE16","Oranges",null,null,"CC18","1 sachet pour 4 repas"]
[null,null,"DWE17","Petits suisses",null,null,"CC19","1 tranche pour 1 repas"]
[null,null,"DWE18","Pruneaux",null,null,"CC20","1 tranche pour 2 repas"]
[null,null,"DWE19","Riz au lait",null,null,"CC21","125 grammes pour 1 repas"]
[null,null,"DWE20","Tapioca",null,null,"CC22","20 frites pour 1 repas"]
[null,null,"DWE21","Yaourts",null,null,"CC23","25 grammes pour 1 repas"]
[null,null,"DWE22","Tapioca",null,null,"CC24","3 tranches pour 1 repas"]
[null,null,"DWE23","Yaourts",null,null,"CC25","5 cuillères pour 1 repas"]
[null,null,"LMR01","Asperges",null,null,"CC26","Unité : 1 branche pour 1 repas"]
[null,null,"LMR02","Avocat",null,null,"CC27","Unité : 1 morceau pour 2 repas"]
[null,null,"LMR03","Carottes",null,null,"CC28","Unité : 1 pour 1 repas"]
[null,null,"LMR04","Céleri",null,null,"CC29","Unité : 1 pour 2 repas"]
[null,null,"LMR05","Champignons",null,null,"CC30","Unité : 1 pour 4 repas"]
[null,null,"LMR06","Concombre",null,null,"CC31","Unité : 1 tête pour 1 repas"]
[null,null,"LMR07","Couscous",null,null,"CC32","Unité : 2 à 4 pour 1 repas"]
[null,null,"LMR08","Maïs",null,null,"CC33","Unité : 2 pour 1 repas"]
[null,null,"LMR09","Pâtes à la sauce tomates"]
[null,null,"LMR10","Pâtes au beurre"]
[null,null,"LMR11","Poireau"]
[null,null,"LMR12","Pomme de terre"]
[null,null,"LMR13","Purée"]
[null,null,"LMR14","Radis"]
[null,null,"LMR15","Riz"]
[null,null,"LMR16","Salade"]
[null,null,"LMR17","Tomates"]
[null,null,"LSLM01","Cassoulet"]
[null,null,"LSLM02","Choucroute"]
[null,null,"LSLM03","Chou-fleur"]
[null,null,"LSLM04","Choux de Bruxelles"]
[null,null,"LSLM05","Couscous"]
[null,null,"LSLM06","Endives"]
[null,null,"LSLM07","Haricots verts"]
[null,null,"LSLM08","Maïs"]
[null,null,"LSLM09","Paella"]
[null,null,"LSLM10","Poireau"]
[null,null,"LSLM11","Pomme de terre"]
[null,null,"LSLM12","Purée"]
[null,null,"LSLM13","Quenelles"]
[null,null,"LSLM14","Riz"]
[null,null,"LSMJ01","Macédoine de légumes"]
[null,null,"LSMJ02","Petits pois"]
[null,null,"LSMJ03","Petits pois et jeunes carottes"]
[null,null,"LSMJ04","Ratatouille"]
[null,null,"LSMJ05","Raviolis"]
[null,null,"LSMJ06","Tomates pelées"]
[null,null,"LSV01","Asperges"]
[null,null,"LSV02","Avocat"]
[null,null,"LSV03","Betterave rouge"]
[null,null,"LSV04","Carottes"]
[null,null,"LSV05","Céleri"]
[null,null,"LSV06","Champignons"]
[null,null,"LSV07","Concombre"]
[null,null,"LSV08","Radis"]
[null,null,"LSV09","Salade"]
[null,null,"LSV10","Salsifis"]
[null,null,"LSV11","Tomates "]
[null,null,"LWED01","Asperges"]
[null,null,"LWED02","Chips"]
[null,null,"LWED03","Frites"]
[null,null,"LWED04","Haricots verts"]
[null,null,"LWES01","Pâtes à la sauce tomates"]
[null,null,"LWES02","Pâtes au beurre"]
[null,null,"LWES03","Pâtes au fromage râpé"]
[null,null,"O01","Armistice du 11 novembre 1918"]
[null,null,"O02","Ascension"]
[null,null,"O03","Assomption"]
[null,null,"O04","Fête du travail"]
[null,null,"O05","Fête nationale"]
[null,null,"O06","Jour de l'an"]
[null,null,"O07","Lundi de Pâques"]
[null,null,"O08","Lundi de Pentecôte"]
[null,null,"O09","Noël"]
[null,null,"O10","Pâques"]
[null,null,"O11","Pentecôte"]
[null,null,"O12","Toussaint"]
[null,null,"O13","Victoire du 08 mai 1945"]
[null,null,"PC01","Janvier"]
[null,null,"PC02","Février"]
[null,null,"PC03","Mars"]
[null,null,"PC04","Avril"]
[null,null,"PC05","Mai"]
[null,null,"PC06","Juin"]
[null,null,"PC07","Juillet"]
[null,null,"PC08","Août"]
[null,null,"PC09","Septembre"]
[null,null,"PC10","Octobre"]
[null,null,"PC11","Novembre"]
[null,null,"PC12","Décembre"]
[null,null,"PVWE01","Viande weekend premier semestre"]
[null,null,"PVWE02","Viande weekend deuxième semestre"]
[null,null,"VMR01","Rôti d'agneau"]
[null,null,"VMR02","Rôti de bœuf"]
[null,null,"VMR03","Rôti de cheval"]
[null,null,"VMR04","Rôti de porc"]
[null,null,"VMR05","Rôti de veau"]
[null,null,"VS01","Bifteck haché de bœuf"]
[null,null,"VS02","Bifteck haché de cheval"]
[null,null,"VS03","Bifteck haché de veau"]
[null,null,"VS04","Bouchée à la reine"]
[null,null,"VS05","Boudin"]
[null,null,"VS06","Cervelas"]
[null,null,"VS07","Cœur"]
[null,null,"VS08","Croque-monsieur"]
[null,null,"VS09","Foie"]
[null,null,"VS10","Fromage de tête"]
[null,null,"VS11","Jambon"]
[null,null,"VS12","Jambonneau"]
[null,null,"VS13","Mortadelle"]
[null,null,"VS14","Œufs"]
[null,null,"VS15","Pizza"]
[null,null,"VS16","Poisson"]
[null,null,"VS17","Quiche lorraine"]
[null,null,"VS18","Roulade à la pistache"]
[null,null,"VS19","Roulé au fromage"]
[null,null,"VS20","Salami"]
[null,null,"VS21","Saucisses"]
[null,null,"VS22","Saucisson"]
[null,null,"VS23","Tête persillée"]
[null,null,"VS24","Tête roulée"]
[null,null,"VS25","Thon"]
[null,null,"VS26","Viande cassoulet"]
[null,null,"VS27","Viande choucroute"]
[null,null,"VS28","Viande paella"]
[null,null,"VWE01","Agneau"]
[null,null,"VWE02","Bœuf"]
[null,null,"VWE03","Cheval"]
[null,null,"VWE04","Dinde"]
[null,null,"VWE05","Poisson"]
[null,null,"VWE06","Porc"]
[null,null,"VWE07","Veau"]

{"sheet":"Accueil","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"DMR"]
[]
[null,null,"DMR"]

{"sheet":"SP","index":2,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Numéro création",{"$f":"MAX(IF(TabRéfProduits[Code produit]=$B$6,TabRéfProduits[Numéro création]))+1","v":2}]
["Code catégorie","CC01"]
["Nom catégorie",{"$f":"IFERROR(INDEX(Nom_catégorie,MATCH($B$4,Code_catégorie,0)),\"-\")","v":"DMR"}]
["Code produit","DMR01"]
["Nom produit",{"$f":"IFERROR(INDEX(Nom_produit,MATCH($B$6,Code_produit,0)),\"-\")","v":"Pomme"}]
["Code jour","CJ05"]
["Nom jour",{"$f":"IFERROR(INDEX(Nom_jour,MATCH($B$8,Code_jour,0)),\"-\")","v":"Lundi à vendredi midis"}]
["Code conditionnement","CC16"]
["Nom conditionnement",{"$f":"IFERROR(INDEX(Nom_conditionnement,MATCH($B$10,Code_conditionnement,0)),\"-\")","v":"1 sachet de 2 kilogrammes. 1 pomme pour 1 repas"}]
["Code destination","CD02"]
["Nom destination",{"$f":"IFERROR(INDEX(Nom_destination,MATCH($B$12,Code_destination,0)),\"-\")","v":"Menus midi retraite"}]
["Code à modifier","LCÀM02"]
["Nom à modifier",{"$f":"IFERROR(INDEX(Nom_à_modifier,MATCH($B$14,Code_à_modifier,0)),\"-\")","v":"Oui"}]
["Date création","2019-08-12"]

{"sheet":"MP","index":3,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Numéro création"]
["Code catégorie"]
["Nom catégorie"]
["Code produit"]
["Nom produit"]
["Code jour"]
["Nom jour"]
["Code conditionnement"]
["Nom conditionnement"]
["Code destination"]
["Nom destination"]
["Code à modifier"]
["Nom à modifier"]
["Date création"]

{"sheet":"Produits","index":4,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Intitulé","Numéro création","Code catégorie","Nom catégorie","Code produit","Nom produit","Code jour","Nom jour","Code conditionnement","Nom conditionnement","Code destination","Nom destination","Code à modifier","Nom à modifier","Date création"]
[{"$f":"TEXT(TabRéfProduits[Code produit],\"0000\") & \"-\" & TabRéfProduits[Numéro création]","v":"0000-"}]
["DWE01-1",1,"CC03","DWE","DWE01","Ananas","CJ10","Samedi et dimanche midis et soirs","CC30","Unité : 1 pour 4 repas","CD01","Menus journaliers","LCÀM02","Oui","2019-08-12"]
["DMR01-1",1,"CC01","DMR","DMR01","Pomme","CJ05","Lundi à vendredi midis","CC16","1 sachet de 2 kilogrammes. 1 pomme pour 1 repas","CD02","Menus midi retraite","LCÀM02","Oui","2019-08-12"]