{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Référentiels produits","Accueil produits","Création produits","BD produits","Modification produits","Accueil menus","Saisie MMR","Menus MMR","Modifier MMR","Saisie MJ","Menus MJ","Modifier MJ","Saisie menus VMWE","Menus VMWE","Modifier VMWE","BD menus","Quantités desserts","Quantités légumes","Quantités viandes","Jours féries"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":52,"comments":1,"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 produits","index":0,"n_rows":32,"n_cols":47,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Catégorie","Destination","Nature",null,"Jours",null,"Code DMR","Nom DMR",null,"Code DS","Nom DS",null,"Code DWE","Nom DWE",null,"Code LMR","Nom LMR",null,"Code LSLM","Nom LSLM",null,"Code LSMJ","Nom LSMJ",null,"Code LSV","Nom LSV",null,"Code LWED","Nom LWED",null,"Code LWES","Nom LWES",null,"Code VMR","Nom VMR",null,"Code VMWE","Nom VMWE",null,"Code VS","Nom VS",null,"Conditionnement",null,"Nom jour",null,"Mois"]
["DMR","Aliments midi retraite","Aliments midi retraite dessert",null,"Dimanche midi",null,"DMR01","Pomme",null,"DS01","Pomme",null,"DWE01","Ananas",null,"LMR01","Asperges",null,"LSLM01","Cassoulet",null,"LSMJ01","Macédoine de légumes",null,"LSV01","Asperges",null,"LWED01","Asperges",null,"LWES01","Pâtes à la sauce tomates",null,"VMR01","Rôti d'agneau",null,"VMWE01","Agneau",null,"VS01","Bifteck haché de bœuf",null,"1 bocal pour 1 repas (asperges)",null,"01",null,"Janvier"]
["DS","Aliments journaliers","Aliments journaliers dessert",null,"Dimanche midi et soir",null,null,null,null,null,null,null,"DWE02","Autres fruits",null,"LMR02","Avocat",null,"LSLM02","Choucroute",null,"LSMJ02","Petits pois",null,"LSV02","Avocat",null,"LWED02","Chips",null,"LWES02","Pâtes au beurre",null,"VMR02","Rôti de bœuf",null,"VMWE02","Bœuf",null,"VS02","Bifteck haché de cheval",null,"1 boîte de 6 œufs (3 œufs par repas)",null,"02",null,"Février"]
["DWE","Aliments weekend","Aliments weekend desserts",null,"Dimanche soir",null,null,null,null,null,null,null,"DWE03","Avocats",null,"LMR03","Carottes",null,"LSLM03","Chou-fleur",null,"LSMJ03","Petits pois et jeunes carottes",null,"LSV03","Betterave rouge",null,"LWED03","Frites",null,"LWES03","Pâtes au fromage râpé",null,"VMR03","Rôti de cheval",null,"VMWE03","Cheval",null,"VS03","Bifteck haché de veau",null,"1 boîte pour 1 repas",null,"03",null,"Mars"]
["LMR","Aliments midi retraite","Aliments midi retraite légumes",null,"Lundi à dimanche soirs",null,null,null,null,null,null,null,"DWE04","Bananes",null,"LMR04","Céleri",null,"LSLM04","Choux de Bruxelles",null,"LSMJ04","Ratatouille",null,"LSV04","Carottes",null,"LWED04","Haricots verts",null,null,null,null,"VMR04","Rôti de porc",null,"VMWE04","Dinde",null,"VS04","Bouch2e à la reine",null,"1 boîte pour 2 repas",null,"04",null,"Avril"]
["LSLM","Aliments journaliers","Aliments journaliers légumes lundi mardi",null,"Lundi à vendredi midis",null,null,null,null,null,null,null,"DWE05","Clémentines",null,"LMR05","Champignons",null,"LSLM05","Couscous",null,"LSMJ05","Raviolis",null,"LSV05","Céleri",null,null,null,null,null,null,null,"VMR05","Rôti de veau",null,"VMWE05","Poisson",null,"VS05","Boudin",null,"1 botte ou 1 sachet pour 1 repas (radis)",null,"05",null,"Mai"]
["LSMJ","Aliments journaliers","Aliments journaliers légumes mercredi jeudi",null,"Lundi à vendredi soirs",null,null,null,null,null,null,null,"DWE06","Crème",null,"LMR06","Concombre",null,"LSLM06","Endives",null,"LSMJ06","Tomates pelées",null,"LSV06","Champignons",null,null,null,null,null,null,null,null,null,null,"VMWE06","Porc",null,"VS06","Cervelas",null,"1 botte ou 1 sachet pour 2 repas (radis)",null,"06",null,"Juin"]
["LSV","Aliments journaliers","Aliments journaliers légumes vendredi",null,"Lundi et mardi soirs",null,null,null,null,null,null,null,"DWE07","Dattes",null,"LMR07","Couscous",null,"LSLM07","Haricots verts",null,null,null,null,"LSV07","Concombre",null,null,null,null,null,null,null,null,null,null,"VMWE07","Veau",null,"VS07","Cœur",null,"1 morceau de 500 grammes pour 5 repas (VMR)",null,"07",null,"Juillet"]
["LWED","Aliments weekend","Aliments weekend légumes dimanche",null,"Mercredi et jeudi soirs",null,null,null,null,null,null,null,"DWE08","Figues",null,"LMR08","Maïs",null,"LSLM08","Maïs",null,null,null,null,"LSV08","Radis",null,null,null,null,null,null,null,null,null,null,null,null,null,"VS08","Croque-monsieur",null,"1 pack de 4 pots pour le weekend. 1 pot par repas",null,"08",null,"Août"]
["LWES","Aliments weekend","Aliments weekend légumes samedi",null,"Samedi et dimanche midis",null,null,null,null,null,null,null,"DWE09","Fromage blanc",null,"LMR09","Pâtes à la sauce tomates",null,"LSLM09","Paella",null,null,null,null,"LSV09","Salade",null,null,null,null,null,null,null,null,null,null,null,null,null,"VS09","Foie",null,"1 pack de 6 pots, 3 pots par repas (petits suisses)",null,"09",null,"Septembre"]
["VMR","Aliments midi retraite","Aliments midi retraite viandes",null,"Samedi et dimanche midis et soirs",null,null,null,null,null,null,null,"DWE10","Fruits au sirop",null,"LMR10","Pâtes au beurre",null,"LSLM10","Poireau",null,null,null,null,"LSV10","Salsifis",null,null,null,null,null,null,null,null,null,null,null,null,null,"VS10","Fromage de tête",null,"1 paquet pour 1 repas",null,"10",null,"Octobre"]
["VMWE","Aliments weekend","Aliments weekend viandes",null,"Samedi midi et soir",null,null,null,null,null,null,null,"DWE11","Fruits de saison",null,"LMR11","Poireau",null,"LSLM11","Pomme de terre",null,null,null,null,"LSV11","Tomates",null,null,null,null,null,null,null,null,null,null,null,null,null,"VS11","Jambon",null,"1 paquet pour 2 repas",null,"11",null,"Novembre"]
["VS","Aliments journaliers","Aliments journaliers viandes",null,"Vendredi soir",null,null,null,null,null,null,null,"DWE12","Gâteau de riz",null,"LMR12","Pomme de terre",null,"LSLM12","Purée",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS12","Jambonneau",null,"1 paquet pour 4 repas (dattes, figues, pruneaux)",null,"12",null,"Décembre"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DWE13","Gâteau de semoule",null,"LMR13","Purée",null,"LSLM13","Quenelles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS13","Mortadelle",null,"1 paquet pour 5 repas (betterave rouge)",null,"13"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DWE14","Gâteaux samedi dimanche",null,"LMR14","Radis",null,"LSLM14","Riz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS14","Œufs",null,"1 sachet de 2000 grammes, 1 pomme par repas",null,"14"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DWE15","Mousse au chocolat",null,"LMR15","Riz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS15","Pizza",null,"1 sachet pour 2 repas",null,"15"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DWE16","Oranges",null,"LMR16","Salade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS16","Poisson",null,"1 sachet pour 4 repas",null,"16"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DWE17","Petits suisses",null,"LMR17","Tomates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS17","Quiche lorraine",null,"1 tranche pour 1 repas VMWE)",null,"17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DWE18","Pruneaux",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS18","Roulade à la pistache",null,"1 tranche pour 2 repas (tête persillée)",null,"18"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DWE19","Riz au lait",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS19","Roulé au fromage",null,"125 grammes pour 1 repas (bifteck haché de cheval)",null,"19"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DWE20","Tapioca",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS20","Salami",null,"20 frites pour 1 repas",null,"20"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DWE21","Yaourts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS21","Saucisses",null,"25 grammes pour 1 repas (couscous, purée, riz)",null,"21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS22","Saucisson",null,"3 tranches pour 1 repas",null,"22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS23","Tête persillée",null,"5 cuillères pour 1 repas (pâtes)",null,"23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS24","Tête roulée",null,"Unité : 1 branche par repas (céleri)",null,"24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS25","Thon",null,"Unité : 1 morceau pour 1 repas",null,"25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS26","Viande cassoulet",null,"Unité : 1 pour 1 repas",null,"26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS27","Viande choucroute",null,"Unité : 1 pour 2 repas",null,"27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VS28","Viande paella",null,"Unité : 1 pour 4 repas (ananas)",null,"28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unité : 1 têtepar repas (ou pack de 3 tête : salade",null,"29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unité : 2 à 4 par repas",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unité : 2 pour 1 repas (carottes, tomates)",null,"31"]

{"sheet":"Accueil produits","index":1,"n_rows":126,"n_cols":6,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
["Accueil produits.",null,null,null,"Open","Save"]
[null,null,null,null,"2021-03-13T16:22:23","2021-03-12T21:56:17"]
[null,null,null,null,"2021-03-13T21:31:01","2021-03-13T16:44:11"]
[null,null,null,null,"2021-03-14T20:09:28","2021-03-13T17:01:06"]
[null,null,null,null,"2021-03-15T16:01:33","2021-03-13T17:05:56"]
[null,null,null,null,"2021-03-15T16:27:21","2021-03-13T17:32:47"]
[null,null,null,null,"2021-03-15T16:36:59","2021-03-13T17:39:26"]
[null,null,null,null,"2021-03-15T21:17:39","2021-03-13T17:42:05"]
[null,null,null,null,"2021-03-16T20:55:26","2021-03-13T18:43:04"]
[null,null,null,null,"2021-03-16T21:36:30","2021-03-13T20:17:41"]
[null,null,null,null,"2021-03-17T14:59:16","2021-03-13T20:17:52"]
[null,null,null,null,"2021-03-17T18:53:10","2021-03-13T20:35:52"]
[null,null,null,null,"2021-03-17T21:56:20","2021-03-13T20:44:17"]
[null,null,null,null,"2021-03-17T22:23:05","2021-03-13T20:50:56"]
[null,null,null,null,"2021-03-18T16:27:39","2021-03-13T21:00:52"]
[null,null,null,null,"2021-03-18T16:32:25","2021-03-13T21:07:15"]
[null,null,null,null,"2021-03-18T18:27:36","2021-03-13T21:41:48"]
[null,null,null,null,"2021-03-19T17:49:13","2021-03-14T20:21:11"]
[null,null,null,null,"2021-03-19T19:57:09","2021-03-14T21:17:18"]
[null,null,"                      ",null,"2021-03-20T21:07:08","2021-03-15T16:28:50"]
[null,null,null,null,"2021-03-21T14:32:39","2021-03-15T16:37:04"]
[null,null,null,null,"2021-03-21T14:53:34","2021-03-15T16:44:36"]
[null,null,null,null,"2021-03-21T15:15:23","2021-03-15T18:30:13"]
[null,null,null,null,"2021-03-21T16:17:18","2021-03-15T21:17:53"]
[null,null,null,null,"2021-03-21T18:54:45","2021-03-15T21:21:18"]
[null,null,null,null,"2021-03-21T23:01:32","2021-03-15T21:37:49"]
[null,null,null,null,"2021-03-22T16:47:17","2021-03-15T21:43:42"]
[null,null,null,null,"2021-03-22T20:25:43","2021-03-15T21:51:32"]
[null,null,null,null,"2021-03-23T21:11:55","2021-03-15T21:56:40"]
[null,null,null,null,"2021-03-23T21:52:34","2021-03-15T22:04:36"]
[null,null,null,null,"2021-03-24T16:01:00","2021-03-15T22:11:12"]
[null,null,null,null,"2021-03-25T16:49:19","2021-03-16T21:36:36"]
[null,null,null,null,"2021-03-26T19:46:26","2021-03-16T21:45:11"]
[null,null,null,null,"2021-03-26T22:06:43","2021-03-16T22:05:47"]
[null,null,null,null,"2021-03-27T17:32:28","2021-03-17T15:31:01"]
[null,null,null,null,"2021-03-28T14:38:27","2021-03-17T15:31:38"]
[null,null,null,null,"2021-03-28T21:25:59","2021-03-17T15:35:13"]
[null,null,null,null,"2021-03-29T16:09:01","2021-03-17T15:39:05"]
[null,null,null,null,"2021-03-29T21:51:35","2021-03-17T15:41:34"]
[null,null,null,null,"2021-03-30T14:13:38","2021-03-17T15:43:13"]
[null,null,null,null,"2021-03-30T22:23:58","2021-03-17T15:53:06"]
[null,null,null,null,"2021-03-31T11:34:49","2021-03-17T15:57:23"]
[null,null,null,null,null,"2021-03-17T16:00:19"]
[null,null,null,null,null,"2021-03-17T16:03:36"]
[null,null,null,null,null,"2021-03-17T16:07:36"]
[null,null,null,null,null,"2021-03-17T16:09:13"]
[null,null,null,null,null,"2021-03-17T16:11:57"]
[null,null,null,null,null,"2021-03-17T16:21:13"]
[null,null,null,null,null,"2021-03-17T16:21:31"]
[null,null,null,null,null,"2021-03-17T16:32:30"]
[null,null,null,null,null,"2021-03-17T20:37:33"]
[null,null,null,null,null,"2021-03-17T20:45:30"]
[null,null,null,null,null,"2021-03-17T21:12:15"]
[null,null,null,null,null,"2021-03-17T21:55:56"]
[null,null,null,null,null,"2021-03-17T21:59:43"]
[null,null,null,null,null,"2021-03-17T22:23:13"]
[null,null,null,null,null,"2021-03-18T16:31:59"]
[null,null,null,null,null,"2021-03-18T16:38:04"]
[null,null,null,null,null,"2021-03-18T16:38:58"]
[null,null,null,null,null,"2021-03-18T21:14:28"]
[null,null,null,null,null,"2021-03-18T21:25:54"]
[null,null,null,null,null,"2021-03-18T21:36:39"]
[null,null,null,null,null,"2021-03-18T22:08:58"]
[null,null,null,null,null,"2021-03-18T22:21:22"]
[null,null,null,null,null,"2021-03-19T19:57:40"]
[null,null,null,null,null,"2021-03-19T20:00:56"]
[null,null,null,null,null,"2021-03-19T20:08:34"]
[null,null,null,null,null,"2021-03-19T20:13:56"]
[null,null,null,null,null,"2021-03-19T20:14:34"]
[null,null,null,null,null,"2021-03-19T20:24:46"]
[null,null,null,null,null,"2021-03-19T20:28:14"]
[null,null,null,null,null,"2021-03-19T20:54:30"]
[null,null,null,null,null,"2021-03-19T22:10:19"]
[null,null,null,null,null,"2021-03-19T22:13:36"]
[null,null,null,null,null,"2021-03-20T22:44:50"]
[null,null,null,null,null,"2021-03-20T23:05:03"]
[null,null,null,null,null,"2021-03-20T23:12:55"]
[null,null,null,null,null,"2021-03-21T14:49:47"]
[null,null,null,null,null,"2021-03-21T14:50:44"]
[null,null,null,null,null,"2021-03-21T15:07:54"]
[null,null,null,null,null,"2021-03-21T15:11:53"]
[null,null,null,null,null,"2021-03-21T16:08:25"]
[null,null,null,null,null,"2021-03-21T16:08:47"]
[null,null,null,null,null,"2021-03-21T16:20:56"]
[null,null,null,null,null,"2021-03-21T17:59:45"]
[null,null,null,null,null,"2021-03-21T18:31:47"]
[null,null,null,null,null,"2021-03-21T22:15:04"]
[null,null,null,null,null,"2021-03-21T22:17:40"]
[null,null,null,null,null,"2021-03-21T22:37:41"]
[null,null,null,null,null,"2021-03-21T22:45:20"]
[null,null,null,null,null,"2021-03-21T22:49:22"]
[null,null,null,null,null,"2021-03-21T23:05:43"]
[null,null,null,null,null,"2021-03-22T18:55:30"]
[null,null,null,null,null,"2021-03-22T21:46:58"]
[null,null,null,null,null,"2021-03-23T22:24:30"]
[null,null,null,null,null,"2021-03-23T22:26:05"]
[null,null,null,null,null,"2021-03-23T22:26:40"]
[null,null,null,null,null,"2021-03-23T22:38:06"]
[null,null,null,null,null,"2021-03-24T16:32:59"]
[null,null,null,null,null,"2021-03-25T17:06:40"]
[null,null,null,null,null,"2021-03-25T17:08:34"]
[null,null,null,null,null,"2021-03-25T17:29:12"]
[null,null,null,null,null,"2021-03-26T19:47:01"]
[null,null,null,null,null,"2021-03-26T22:07:49"]
[null,null,null,null,null,"2021-03-26T22:10:36"]
[null,null,null,null,null,"2021-03-26T22:11:27"]
[null,null,null,null,null,"2021-03-27T17:46:51"]
[null,null,null,null,null,"2021-03-27T21:45:35"]
[null,null,null,null,null,"2021-03-27T22:21:30"]
[null,null,null,null,null,"2021-03-28T14:42:47"]
[null,null,null,null,null,"2021-03-28T15:15:56"]
[null,null,null,null,null,"2021-03-28T15:19:48"]
[null,null,null,null,null,"2021-03-28T15:34:24"]
[null,null,null,null,null,"2021-03-28T15:54:13"]
[null,null,null,null,null,"2021-03-28T15:58:40"]
[null,null,null,null,null,"2021-03-28T21:29:47"]
[null,null,null,null,null,"2021-03-28T21:30:18"]
[null,null,null,null,null,"2021-03-29T17:24:08"]
[null,null,null,null,null,"2021-03-29T21:59:47"]
[null,null,null,null,null,"2021-03-30T19:54:41"]
[null,null,null,null,null,"2021-03-30T21:40:45"]
[null,null,null,null,null,"2021-03-30T21:51:37"]
[null,null,null,null,null,"2021-03-30T22:01:37"]
[null,null,null,null,null,"2021-03-30T22:19:01"]
[null,null,null,null,null,"2021-03-30T22:35:29"]
[null,null,null,null,null,"2021-03-31T11:43:02"]

{"sheet":"Création produits","index":2,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Création produits."]
[]
["Numéro création",{"$f":"MAX(IF(TabBDProduits[Catégorie]=CelCPCatégorie,TabBDProduits[Numéro création]))+1","v":2}]
["Catégorie","DMR"]
["Nature",{"$f":"IFERROR(VLOOKUP(CelCPCatégorie,TabCA[],3,FALSE),\"\")","v":"Aliments midi retraite dessert"}]
["Code produit","DMR01"]
["Nom produit",{"$f":"IFERROR(VLOOKUP(CelCPCodeProduit,INDIRECT(\"Tab\"&CelCPCatégorie),2,FALSE),\"-\")","v":"Pomme"}]
["Conditionnement","1 sachet de 2000 grammes, 1 pomme par repas"]
["Jour","Lundi à vendredi midis"]
["Quantité par jour",1]
["Destination",{"$f":"IFERROR(VLOOKUP(CelCPCatégorie,TabCA[],2,FALSE),\"\")","v":"Aliments midi retraite"}]
["À modifier","Oui"]
["Date création",{"$f":"TODAY()","v":"2021-03-31"}]
[]
[]
[]
[]
[]
[]
[]
["Légende des couleurs"]
[]
[null,"À renseigner"]
[null,"Formule, ne pas modifier"]

{"sheet":"BD produits","index":3,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Intitulé","Numéro création","Catégorie","Nature","Code produit","Nom produit","Conditionnement","Jour","Quantité par jour","Destination","À modifier","Date création"]
["DMR01-1",1,"DMR","Aliments midi retraite dessert","DMR01","Pomme","1 sachet de 2000 grammes, 1 pomme par repas","Lundi à vendredi midis",1,"Aliments midi retraite","Oui","2021-03-27"]
["DS01-1",1,"DS","Aliments journaliers dessert","DS01","Pomme","1 sachet de 2000 grammes, 1 pomme par repas","Lundi à dimanche soirs",1,"Aliments journaliers","Oui","2021-03-26"]

{"sheet":"Modification produits","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Modification produits",null,null,"Légende des couleurs"]
[]
["Numéro création",2,null,null,"À renseigner"]
["Catégorie","DWE",null,null,"Formule, ne pas modifier"]
["Nature","Aliments weekend desserts"]
["Code produit","DWE03"]
["Nom produit",{"$f":"IFERROR(VLOOKUP(CelMPCodeProduit,INDIRECT(\"Tab\"&CelMPCatégorie),2,FALSE),\"\")","v":"Avocats"}]
["Conditionnement","Unité : 1 branche par repas (céleri)"]
["Jour","Samedi et dimanche midis et soirs"]
["Quantité par jour",2]
["Destination",{"$f":"IFERROR(VLOOKUP(CelMPCatégorie,TabCA[],2,FALSE),\"\")","v":"Aliments weekend"}]
["À modifier","Oui"]
["Date modification","2021-03-23"]

{"sheet":"Accueil menus","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[2021]

{"sheet":"Saisie MMR","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Menus MMR","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Modifier MMR","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Saisie MJ","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Menus MJ","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Modifier MJ","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Saisie menus VMWE","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Menus VMWE","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Modifier VMWE","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BD menus","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Quantités desserts","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Quantités légumes","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Quantités viandes","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Jours féries","index":19,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["Jours fériés et fêtes",{"$f":"'Accueil menus'!$A$1","v":2021}]
["Jour de l'an",{"$f":"DATE(B2,1,1)","v":"2021-01-01"}]
["Pâques",{"$f":"DATE(YEAR(B3),3,29.56+0.979*MOD(204-11*MOD(YEAR(B3),19),30)-WEEKDAY(DATE(YEAR(B3),3,28.56+0.979*MOD(204-11*MOD(YEAR(B3),19),30))))","v":"2021-04-04"}]
["Lundi de pâques",{"$f":"B4+1","v":"2021-04-05"}]
["Fête du travail",{"$f":"DATE(B2,5,1)","v":"2021-05-01"}]
["Victoire 1945",{"$f":"DATE(B2,5,8)","v":"2021-05-08"}]
["Jeudi de l'Ascension",{"$f":"B5+38","v":"2021-05-13"}]
["Pentecôte",{"$f":"B4+49","v":"2021-05-23"}]
["Lundi de Pentecôte",{"$f":"B9+1","v":"2021-05-24"}]
["Fête nationale",{"$f":"DATE(B2,7,14)","v":"2021-07-14"}]
["Assomption",{"$f":"DATE(B2,8,15)","v":"2021-08-15"}]
["Toussaint",{"$f":"DATE(B2,11,1)","v":"2021-11-01"}]
["Armistice 1918",{"$f":"DATE(B2,11,11)","v":"2021-11-11"}]
["Noël",{"$f":"DATE(B2,12,25)","v":"2021-12-25"}]
[]
[null,"Samedi"]
[null,"Dimanche"]