{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Menu","Modèle","Ingrédients","001","002"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":3,"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":"Menu","index":0,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,3,1,5]]}
["Macros"]
["A",null,null,{"$f":"IF('001'!B3=\"\",\"\",'001'!B3)","v":"Blanquette de veau"}]
[]
["B",null,null,{"$f":"IF('002'!B3=\"\",\"\",'002'!B3)","v":""},null,null,null,null,null,"Modèle"]
[]
["CC",null,null,"=SI('003'!B3=\"\";\"\";'003'!B3)"]
[]
["D"]
[]
["E"]
[]
["F"]
[]
["G",null,null,"=SI('007'!B3=\"\";\"\";'007'!B3)"]
[]
["H"]
[]
["I"]
[]
["J"]
[]
["K"]
[]
["L"]
[]
["M",null,null,null,null,null,null,"NE RIEN MODIFIER !"]
[]
["N"]
[]
["O"]

{"sheet":"Modèle","index":1,"n_rows":198,"n_cols":11,"rows_kept":198,"cut":false,"hidden":false,"merged":[[15,2,15,5],[15,6,15,8],[12,2,12,5],[12,6,12,8],[13,2,13,5],[13,6,13,8],[14,2,14,5],[14,6,14,8],[23,6,23,8],[16,2,16,5],[16,6,16,8],[17,2,17,5],[17,6,17,8],[18,6,18,8],[18,2,18,5],[20,6,20,8],[22,1,22,8],[20,1,20,5],[1,5,1,6],[1,7,1,8],[11,2,11,5],[11,6,11,8],[2,7,2,8],[1,1,1,4],[2,1,2,4],[4,2,4,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8],[9,5,9,8]]}
[]
[null,"Nom du plat",null,null,null,"Tps passé",null,"Nb portions"]
["V 7"]
[null,null,{"$f":"IF(C8>1,C9,(C8*60)+C9)","v":0},{"$f":"IF(D8>1,D9,(D8*60)+D9)","v":0},{"$f":"IF(E8>1,E9,(E8*60)+E9)","v":0},{"$f":"IF(F3>1,G3,(F3*60)+G3)","v":0},null,{"$f":"IF(F8>1,F9,(F8*60)+F9)","v":0}]
[null,null,"Matériels utilisés"]
[null,null,"Four","Micro-onde","Robot","Yaourtière"]
[null,"Kw",2.2999999999999998,0.8,0.9,0.6]
[null,"Heures"]
[null,"Minutes"]
[null,"Coût",{"$f":"IF(C8=\"\",\"\",((B13*C7*C4)/H3))","v":""},{"$f":"IF(D8=\"\",\"\",((B13*D7*D4)/H3))","v":""},{"$f":"IF(E8=\"\",\"\",((B13*E7*E4)/H3))","v":""},{"$f":"IF(F8=\"\",\"\",((B13*F7*F4)/H3))","v":""}]
[]
[null,"Prix du Kw/h",{"$f":"\"Total prix de revient des \"&H3&\" portions\"","v":"Total prix de revient des  portions"},null,null,null,{"$f":"IF(H3=\"\",\"\",SUM(H26:H195))","v":""}]
[null,0.14499999999999999,"Prix de revient unitaire avant autres coûts denrées",null,null,null,{"$f":"IF(H3=\"\",\"\",G12/H3)","v":""},null,null,null,"=> F25/I3"]
[null,null,"Coût du temps passé pour une portion",null,null,null,{"$f":"IF(H3=\"\",\"\",(IF(G3=\"\",\"\",((B16/60)*F4)/H3)))","v":""},null,null,null,"=> fixe"]
[null,"Prix horaire","Coût en énergie pour une portion",null,null,null,{"$f":"IF(H3=\"\",\"\",(SUM(C10:I10)/H3))","v":""},null,null,null,"=> fixe"]
[null,9.76,"Prix de revient unitaire TOTAL",null,null,null,{"$f":"IF(G13=\"\",\"\",SUM(G13:G15))","v":""},null,null,null,"=> K11"]
[null,null,"Prix de vente",null,null,null,{"$f":"IF(G16=\"\",\"\",(G16+(G16*25%)))","v":""},null,null,"<= 25% de marge"]
[null,null,"Ratio sur Prix de vente",null,null,null,{"$f":"IF(G16=\"\",\"\",G16/G17)","v":""},null,null,null,"=> somme G26 à G30"]
[null,null,"Marge brute",null,null,null,{"$f":"IF(G16=\"\",\"\",G17-G16)","v":""},null,null,null,"Le Modèle ne doit pas être modifié."]
[null,null,null,null,null,null,null,null,null,null,"=> G32/G33 pourcentage entre prix de revient et prix de vente"]
[null,"Conversion en temps",null,null,null,null,{"$f":"IF(G16=\"\",\"\",IF(E22>0.9,(1&\" h \"&(H22-60)&\" mn\"),(0&\" h \"&(H22)&\" mn\")))","v":""}]
[null,null,null,{"$f":"IF(G16=\"\",\"\",G16/B16)","v":""},{"$f":"IF(G16=\"\",\"\",ROUND(D22,1))","v":""},null,null,{"$f":"IF(G16=\"\",\"\",60*E22)","v":""}]
[null,"Ingrédients",null,null,null,null,null,null,null,null,"=> G32- G31"]
[null,"Genre","Denrées","Conditionnement","Prix d'Achat ","Qté","P.R."]
[null,null,null,null,null,null,null,null,null,null,"=> G35- G36   marge - frais production"]
[null,"Asaisonnement","ail","kg",7.99,null,null,{"$f":"IF(F26=\"\",\"\",E26*F26)","v":""}]
[null,"Asaisonnement","arôme naturel","g",3.9,null,null,""]
[null,"Fruit","banane","kg",1.99,null,null,""]
[null,"Asaisonnement","Beurre","Kg",4,null,null,""]
[null,"Asaisonnement","beurre","kg",7.28,null,null,""]
[null,"Boisson","boisson canette ","pce",0.5,null,null,""]
[null,"Asaisonnement","Bouquet garni","Pièce",0.02,null,null,""]
[null,"Fromage","bûche chèvre ","kg",10.53,null,null,""]
[null,"Légume","Carottes fraiches","Kg",0.6,null,null,""]
[null,"Légume","Céleri branche frais","Kg",1.45,null,null,""]
[null,null,"Champignons de Paris frais","Kg",2.6,null,null,""]
[null,null,"chocolat ","kg",9.27,null,null,""]
[null,"Fruit","Citron","Kg",1.8,null,null,""]
[null,"Asaisonnement","Clous de girofle","Pièce",0.01,null,null,""]
[null,"Légume","courgette","kg",1.99,null,null,""]
[null,"Laitage","Crème épaisse","Litre",2.5,null,null,""]
[null,"Laitage","crème liquide entière","l",3.85,null,null,""]
[null,"Fromage","Emmental","kg",10.5,null,null,""]
[null,"Viande","Epaule de veau ","Kg",11,null,null,""]
[null,null,"Farine","Kg",2.7,null,null,""]
[null,null,"farine","kg",0.8,null,null,""]
[null,null,"ferments","4 sachets",3.61,null,null,""]
[null,"Fruit","fève tonka","kg",280,null,null,""]
[null,"Fruit","grenade","kg",4.99,null,null,""]
[null,"Asaisonnement","Gros sel","P.M",0.01,null,null,""]
[null,"Viande","jambon blanc","kg",15.95,null,null,""]
[null,"Laitage","lait","litre",0.89,null,null,""]
[null,"Laitage","lait","l",0.92,null,null,""]
[null,null,"lardons","kg",13.2,null,null,""]
[null,null,"maïzena","kg",3.63,null,null,""]
[null,null,"maïzena","kg",7.28,null,null,""]
[null,"Fruit","melon ","kg",4.99,null,null,""]
[null,null,"œuf","pce",0.24,null,null,{"$f":"IF(F58=\"\",\"\",E58*F58)","v":""}]
[null,null,"œuf","pce",0.24,null,null,""]
[null,null,"Œufs frais","Pièce",0.15,null,null,""]
[null,"Asaisonnement","oignon","kg",1.99,null,null,""]
[null,"Asaisonnement","Oignons frais","Kg",0.55000000000000004,null,null,""]
[null,"Fruit","orange","kg",2.5,null,null,""]
[null,"Accompagnement","Pain","1/5 baguette",0.2,null,null,""]
[null,"Fruit","papaye","kg",3.99,null,null,""]
[null,"Fromage","parmesan","kg",25.2,null,null,""]
[null,"Légume","patate douce","kg",2.99,null,null,""]
[null,null,"pâtes","kg",2.5,null,null,""]
[null,"Asaisonnement","Petits oignons frais","Kg",2.1,null,null,""]
[null,"Légume","Poireaux frais","Kg",1.6,null,null,""]
[null,"Légume","poivron","kg",2.99,null,null,""]
[null,"Légume","pulpe de tomate","kg",4.5,null,null,""]
[null,"Légume","riz","kg",2.36,null,null,""]
[null,"Légume","Riz haut de gamme","Kg",6,null,null,""]
[null,"Légume","riz pour risotto","kg",3.76,null,null,""]
[null,"Légume","salade","kg",1.5,null,null,""]
[null,"Poisson","saumon fumé","kg",33.93,null,null,""]
[null,"Asaisonnement","Sel fin, poivre blanc","P.M",0.01,null,null,""]
[null,null,"sucre",null,0.89,null,null,""]
[null,null,"sucre","kg",1.32,null,null,""]
[null,null,"Sucre semoule","P.M",null,null,null,""]
[null,"Légume","tomate","kg",2.99,null,null,""]
[null,"Boisson","vin blanc","l",2.57,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,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F90=\"\",\"\",E90*F90)","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F122=\"\",\"\",E122*F122)","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F154=\"\",\"\",E154*F154)","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F186=\"\",\"\",E186*F186)","v":""}]
[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,""]
[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,""]

{"sheet":"Ingrédients","index":2,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Code (?)","Ingrédients","Fournisseur","Conditionnement","Prix HT"]
[]
[]
[null,"Carottes fraiches","FRUITS & LEGUMES","Kg",0.6]
[null,"Oignons frais","FRUITS & LEGUMES","Kg",0.55000000000000004,null,"Copier/Coller des 4 cellules correspondantes"]
[null,"Clous de girofle","EPICERIE","Pièce",0.01,null,"dans la fiche technique  "]
[null,"Poireaux frais","FRUITS & LEGUMES","Kg",1.6]
[null,"Céleri branche frais","FRUITS & LEGUMES","Kg",1.45]
[null,"Bouquet garni","FRUITS & LEGUMES","Pièce",0.02]
[null,"Beurre","BOF","Kg",4]
[null,"Farine","EPICERIE","Kg",2.7]
[null,"Crème épaisse","BOF","Litre",2.5]
[null,"Œufs frais","BOF","Pièce",0.15]
[null,"Champignons de Paris frais","FRUITS & LEGUMES","Kg",2.6]
[null,"Citron","FRUITS & LEGUMES","Kg",1.8]
[null,"Petits oignons frais","FRUITS & LEGUMES","Kg",2.1]
[null,"Sucre semoule","EPICERIE","P.M"]
[null,"Gros sel","EPICERIE","P.M"]
[null,"Sel fin, poivre blanc","EPICERIE","P.M"]
[null,"Riz haut de gamme","EPICERIE","Kg",6]
[]
[]
[null,"beurre",null,"kg",7.28]
[null,"bûche chèvre ",null,"kg",10.53]
[null,"chocolat ",null,"kg",9.27]
[null,"crème liquide entière",null,"l",3.85]
[null,"Emmental",null,"kg",10.5]
[null,"farine",null,"kg",0.8]
[null,"lait",null,"l",0.92]
[null,"lardons",null,"kg",13.2]
[null,"maïzena",null,"kg",7.28]
[null,"œuf",null,"pce",0.24]
[null,"parmesan",null,"kg",25.2]
[null,"pâtes",null,"kg",2.5]
[null,"pulpe de tomate",null,"kg",4.5]
[null,"riz",null,"kg",2.36]
[null,"riz pour risotto",null,"kg",3.76]
[null,"sucre",null,"kg",1.32]
[null,"vin blanc",null,"l",2.57]
[null,"jambon blanc",null,"kg",15.95]
[null,"courgette",null,"kg",1.99]
[null,"poivron",null,"kg",2.99]
[null,"tomate",null,"kg",2.99]
[null,"oignon",null,"kg",1.99]
[null,"ail",null,"kg",7.99]
[null,"patate douce",null,"kg",2.99]
[null,"banane",null,"kg",1.99]
[null,"grenade",null,"kg",4.99]
[null,"papaye",null,"kg",3.99]
[null,"orange",null,"kg",2.5]
[null,"saumon fumé",null,"kg",33.93]
[null,"melon ",null,"kg",4.99]
[null,"salade",null,"kg",1.5]
[null,"maïzena",null,"kg",3.63]
[]
[null,"boisson canette ",null,"pce",0.5]

{"sheet":"001","index":3,"n_rows":198,"n_cols":11,"rows_kept":198,"cut":false,"hidden":false,"merged":[[11,2,11,5],[11,6,11,8],[1,1,1,4],[1,5,1,6],[1,7,1,8],[2,1,2,4],[2,7,2,8],[4,2,4,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8],[9,5,9,8],[12,2,12,5],[12,6,12,8],[13,2,13,5],[13,6,13,8],[14,2,14,5],[14,6,14,8],[23,6,23,8],[15,2,15,5],[15,6,15,8],[16,2,16,5],[16,6,16,8],[17,2,17,5],[17,6,17,8],[18,2,18,5],[18,6,18,8],[20,1,20,5],[20,6,20,8],[22,1,22,8]]}
[]
[null,"Nom du plat",null,null,null,"Tps passé",null,"Nb portions"]
["V 7","Blanquette de veau",null,null,null,0,45,10]
[null,null,{"$f":"IF(C8>1,C9,(C8*60)+C9)","v":0},{"$f":"IF(D8>1,D9,(D8*60)+D9)","v":10},{"$f":"IF(E8>1,E9,(E8*60)+E9)","v":25},{"$f":"IF(F3>1,G3,(F3*60)+G3)","v":45},null,{"$f":"IF(F8>1,F9,(F8*60)+F9)","v":0}]
[null,null,"Matériels utilisés"]
[null,null,"Four","Micro-onde","Robot","Yaourtière"]
[null,"Kw",3,0.8,0.9,0.02]
[null,"Heures",null,0,0]
[null,"Minutes",null,10,25]
[null,"Coût",{"$f":"IF(C8=\"\",\"\",((B13*C7*C4)/H3))","v":""},{"$f":"IF(D8=\"\",\"\",((B13*D7*D4)/H3))","v":0.11599999999999999},{"$f":"IF(E8=\"\",\"\",((B13*E7*E4)/H3))","v":0.32625000000000004},{"$f":"IF(F8=\"\",\"\",((B13*F7*F4)/H3))","v":""}]
[]
[null,"Prix du Kw/h",{"$f":"\"Total prix de revient des \"&H3&\" portions\"","v":"Total prix de revient des 10 portions"},null,null,null,{"$f":"IF(H3=\"\",\"\",SUM(H26:H240))","v":30.616249999999997}]
[null,0.14499999999999999,"Prix de revient unitaire avant autres coûts denrées",null,null,null,{"$f":"IF(H3=\"\",\"\",G12/H3)","v":3.0616249999999998},null,null,null,"=> F25/I3"]
[null,null,"Coût du temps passé pour une portion",null,null,null,{"$f":"IF(H3=\"\",\"\",(IF(G3=\"\",\"\",((B16/60)*F4)/H3)))","v":0.73199999999999998},null,null,null,"=> fixe"]
[null,"Prix horaire","Coût en énergie pour une portion",null,null,null,{"$f":"IF(H3=\"\",\"\",(SUM(C10:I10)/H3))","v":4.4225E-2},null,null,null,"=> fixe"]
[null,9.76,"Prix de revient unitaire TOTAL",null,null,null,{"$f":"IF(G13=\"\",\"\",SUM(G13:G15))","v":3.8378499999999995},null,null,null,"=> K11"]
[null,null,"Prix de vente",null,null,null,{"$f":"IF(G16=\"\",\"\",(G16+(G16*25%)))","v":4.7973124999999994},null,null,"<= 25% de marge"]
[null,null,"Ratio sur Prix de vente",null,null,null,{"$f":"IF(G16=\"\",\"\",G16/G17)","v":0.8},null,null,null,"=> somme G26 à G30"]
[null,null,"Marge brute",null,null,null,{"$f":"IF(G16=\"\",\"\",G17-G16)","v":0.95946249999999988},null,null,null,"Le Modèle ne doit pas être modifié."]
[null,null,null,null,null,null,null,null,null,null,"=> G32/G33 pourcentage entre prix de revient et prix de vente"]
[null,"Conversion en temps",null,null,null,null,{"$f":"IF(G16=\"\",\"\",IF(E22>0.9,(1&\" h \"&(H22-60)&\" mn\"),(0&\" h \"&(H22)&\" mn\")))","v":"0 h 24 mn"}]
[null,null,null,{"$f":"IF(G16=\"\",\"\",G16/B16)","v":0.39322233606557372},{"$f":"IF(G16=\"\",\"\",ROUND(D22,1))","v":0.4},null,null,{"$f":"IF(G16=\"\",\"\",60*E22)","v":24}]
[null,"Ingrédients",null,null,null,null,null,null,null,null,"=> G32- G31"]
[null,"Genre","Denrées","Conditionnement","Prix d'Achat ","Qté","P.R."]
[null,null,null,null,null,null,null,null,null,null,"=> G35- G36   marge - frais production"]
[null,"Asaisonnement","ail","kg",7.99,null,null,{"$f":"IF(F26=\"\",\"\",E26*F26)","v":""}]
[null,"Asaisonnement","arôme naturel","g",3.9,null,null,""]
[null,"Fruit","banane","kg",1.99,null,null,""]
[null,"Asaisonnement","Beurre","Kg",4,0.125,null,0.5]
[null,"Asaisonnement","beurre","kg",7.28,null,null,""]
[null,"Asaisonnement","beurre","kg",7.28,null,null,""]
[null,"Boisson","boisson canette ","pce",0.5,null,null,""]
[null,"Asaisonnement","Bouquet garni","Pièce",0.02,1,null,0.02]
[null,"Fromage","bûche chèvre ","kg",10.53,null,null,""]
[null,"Légume","Carottes fraiches","Kg",0.6,0.25,null,0.15]
[null,"Légume","Céleri branche frais","Kg",1.45,0.125,null,0.18124999999999999]
[null,null,"Champignons de Paris frais","Kg",2.6,0.25,null,0.65]
[null,null,"chocolat ","kg",9.27,null,null,""]
[null,"Fruit","Citron","Kg",1.8,1,null,1.8]
[null,"Asaisonnement","Clous de girofle","Pièce",0.01,2,null,0.02]
[null,"Légume","courgette","kg",1.99,null,null,""]
[null,"Laitage","Crème épaisse","Litre",2.5,0.25,null,0.625]
[null,"Laitage","crème liquide entière","l",3.85,null,null,""]
[null,"Fromage","Emmental","kg",10.5,null,null,""]
[null,"Viande","Epaule de veau ","Kg",11,2,null,22]
[null,null,"farine","kg",0.8,null,null,""]
[null,null,"Farine","Kg",2.7,7.4999999999999997E-2,null,0.20250000000000001]
[null,null,"ferments","4 sachets",3.61,null,null,""]
[null,"Fruit","fève tonka","kg",280,null,null,""]
[null,"Fruit","grenade","kg",4.99,null,null,""]
[null,"Asaisonnement","Gros sel","P.M",0.01,null,null,""]
[null,"Viande","jambon blanc","kg",15.95,null,null,""]
[null,"Laitage","lait","litre",0.89,null,null,""]
[null,"Laitage","lait","l",0.92,null,null,""]
[null,null,"lardons","kg",13.2,null,null,""]
[null,null,"maïzena","kg",3.63,null,null,""]
[null,null,"maïzena","kg",7.28,null,null,""]
[null,"Fruit","melon ","kg",4.99,null,null,{"$f":"IF(F58=\"\",\"\",E58*F58)","v":""}]
[null,null,"œuf","pce",0.24,null,null,""]
[null,null,"œuf","pce",0.24,null,null,""]
[null,null,"Œufs frais","Pièce",0.15,2,null,0.3]
[null,"Asaisonnement","oignon","kg",1.99,null,null,""]
[null,"Asaisonnement","Oignons frais","Kg",0.55000000000000004,0.25,null,0.13750000000000001]
[null,"Fruit","orange","kg",2.5,null,null,""]
[null,"Accompagnement","Pain","1/5 baguette",0.2,null,null,""]
[null,"Fruit","papaye","kg",3.99,null,null,""]
[null,"Fromage","parmesan","kg",25.2,null,null,""]
[null,"Légume","patate douce","kg",2.99,null,null,""]
[null,null,"pâtes","kg",2.5,null,null,""]
[null,"Asaisonnement","Petits oignons frais","Kg",2.1,0.3,null,0.63]
[null,"Légume","Poireaux frais","Kg",1.6,0.25,null,0.4]
[null,"Légume","poivron","kg",2.99,null,null,""]
[null,"Légume","pulpe de tomate","kg",4.5,null,null,""]
[null,"Légume","riz","kg",2.36,null,null,""]
[null,"Légume","Riz haut de gamme","Kg",6,0.5,null,3]
[null,"Légume","riz pour risotto","kg",3.76,null,null,""]
[null,"Légume","salade","kg",1.5,null,null,""]
[null,"Poisson","saumon fumé","kg",33.93,null,null,""]
[null,"Asaisonnement","Sel fin, poivre blanc","P.M",0.01,null,null,""]
[null,null,"sucre",null,0.89,null,null,""]
[null,null,"sucre","kg",1.32,null,null,""]
[null,null,"sucre","kg",1.32,null,null,""]
[null,null,"Sucre semoule","P.M",null,null,null,""]
[null,"Légume","tomate","kg",2.99,null,null,""]
[null,"Boisson","vin blanc","l",2.57,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,"eau","Test",0.2,null,null,""]
[null,null,"abat","Test",1.25,null,null,""]
[null,null,"Bière","Test",1.5,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F90=\"\",\"\",E90*F90)","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F122=\"\",\"\",E122*F122)","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F154=\"\",\"\",E154*F154)","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F186=\"\",\"\",E186*F186)","v":""}]
[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,""]
[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,""]

{"sheet":"002","index":4,"n_rows":198,"n_cols":11,"rows_kept":198,"cut":false,"hidden":false,"merged":[[11,2,11,5],[11,6,11,8],[1,1,1,4],[1,5,1,6],[1,7,1,8],[2,1,2,4],[2,7,2,8],[4,2,4,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8],[9,5,9,8],[12,2,12,5],[12,6,12,8],[13,2,13,5],[13,6,13,8],[14,2,14,5],[14,6,14,8],[23,6,23,8],[15,2,15,5],[15,6,15,8],[16,2,16,5],[16,6,16,8],[17,2,17,5],[17,6,17,8],[18,2,18,5],[18,6,18,8],[20,1,20,5],[20,6,20,8],[22,1,22,8]]}
[]
[null,"Nom du plat",null,null,null,"Tps passé",null,"Nb portions"]
["V 7"]
[null,null,{"$f":"IF(C8>1,C9,(C8*60)+C9)","v":0},{"$f":"IF(D8>1,D9,(D8*60)+D9)","v":0},{"$f":"IF(E8>1,E9,(E8*60)+E9)","v":0},{"$f":"IF(F3>1,G3,(F3*60)+G3)","v":0},null,{"$f":"IF(F8>1,F9,(F8*60)+F9)","v":0}]
[null,null,"Matériels utilisés"]
[null,null,"Four","Micro-onde","Robot","Yaourtière"]
[null,"Kw",3,0.8,0.9,0.02]
[null,"Heures"]
[null,"Minutes"]
[null,"Coût",{"$f":"IF(C8=\"\",\"\",((B13*C7*C4)/H3))","v":""},{"$f":"IF(D8=\"\",\"\",((B13*D7*D4)/H3))","v":""},{"$f":"IF(E8=\"\",\"\",((B13*E7*E4)/H3))","v":""},{"$f":"IF(F8=\"\",\"\",((B13*F7*F4)/H3))","v":""}]
[]
[null,"Prix du Kw/h",{"$f":"\"Total prix de revient des \"&H3&\" portions\"","v":"Total prix de revient des  portions"},null,null,null,{"$f":"IF(H3=\"\",\"\",SUM(H26:H195))","v":""}]
[null,0.14499999999999999,"Prix de revient unitaire avant autres coûts denrées",null,null,null,{"$f":"IF(H3=\"\",\"\",G12/H3)","v":""},null,null,null,"=> F25/I3"]
[null,null,"Coût du temps passé pour une portion",null,null,null,{"$f":"IF(H3=\"\",\"\",(IF(G3=\"\",\"\",((B16/60)*F4)/H3)))","v":""},null,null,null,"=> fixe"]
[null,"Prix horaire","Coût en énergie pour une portion",null,null,null,{"$f":"IF(H3=\"\",\"\",(SUM(C10:I10)/H3))","v":""},null,null,null,"=> fixe"]
[null,9.76,"Prix de revient unitaire TOTAL",null,null,null,{"$f":"IF(G13=\"\",\"\",SUM(G13:G15))","v":""},null,null,null,"=> K11"]
[null,null,"Prix de vente",null,null,null,{"$f":"IF(G16=\"\",\"\",(G16+(G16*25%)))","v":""},null,null,"<= 25% de marge"]
[null,null,"Ratio sur Prix de vente",null,null,null,{"$f":"IF(G16=\"\",\"\",G16/G17)","v":""},null,null,null,"=> somme G26 à G30"]
[null,null,"Marge brute",null,null,null,{"$f":"IF(G16=\"\",\"\",G17-G16)","v":""},null,null,null,"Le Modèle ne doit pas être modifié."]
[null,null,null,null,null,null,null,null,null,null,"=> G32/G33 pourcentage entre prix de revient et prix de vente"]
[null,"Conversion en temps",null,null,null,null,{"$f":"IF(G16=\"\",\"\",IF(E22>0.9,(1&\" h \"&(H22-60)&\" mn\"),(0&\" h \"&(H22)&\" mn\")))","v":""}]
[null,null,null,{"$f":"IF(G16=\"\",\"\",G16/B16)","v":""},{"$f":"IF(G16=\"\",\"\",ROUND(D22,1))","v":""},null,null,{"$f":"IF(G16=\"\",\"\",60*E22)","v":""}]
[null,"Ingrédients",null,null,null,null,null,null,null,null,"=> G32- G31"]
[null,"Genre","Denrées","Conditionnement","Prix d'Achat ","Qté","P.R."]
[null,null,null,null,null,null,null,null,null,null,"=> G35- G36   marge - frais production"]
[null,"Fromage","bûche chèvre ","kg",10.53,null,null,{"$f":"IF(F26=\"\",\"\",E26*F26)","v":""}]
[null,"Asaisonnement","Gros sel","P.M",0.01,null,null,""]
[null,null,"Champignons de Paris frais","Kg",2.6,null,null,""]
[null,"Laitage","Crème épaisse","Litre",2.5,null,null,""]
[null,"Asaisonnement","Clous de girofle","Pièce",0.01,null,null,""]
[null,"Asaisonnement","arôme naturel","g",3.9,null,null,""]
[null,"Viande","Epaule de veau ","Kg",11,null,null,""]
[null,"Asaisonnement","beurre","kg",7.28,null,null,""]
[null,"Laitage","lait","l",0.92,null,null,""]
[null,null,"ferments","4 sachets",3.61,null,null,""]
[null,"Asaisonnement","ail","kg",7.99,null,null,""]
[null,"Fruit","banane","kg",1.99,null,null,""]
[null,"Asaisonnement","Beurre","Kg",4,null,null,""]
[null,"Boisson","boisson canette ","pce",0.5,null,null,""]
[null,"Asaisonnement","Bouquet garni","Pièce",0.02,null,null,""]
[null,"Légume","Carottes fraiches","Kg",0.6,null,null,""]
[null,"Légume","Céleri branche frais","Kg",1.45,null,null,""]
[null,null,"chocolat ","kg",9.27,null,null,""]
[null,"Fruit","Citron","Kg",1.8,null,null,""]
[null,"Légume","courgette","kg",1.99,null,null,""]
[null,"Laitage","crème liquide entière","l",3.85,null,null,""]
[null,"Fromage","Emmental","kg",10.5,null,null,""]
[null,null,"Farine","Kg",2.7,null,null,""]
[null,null,"farine","kg",0.8,null,null,""]
[null,"Fruit","fève tonka","kg",280,null,null,""]
[null,"Fruit","grenade","kg",4.99,null,null,""]
[null,"Viande","jambon blanc","kg",15.95,null,null,""]
[null,"Laitage","lait","litre",0.89,null,null,""]
[null,null,"lardons","kg",13.2,null,null,""]
[null,null,"maïzena","kg",3.63,null,null,""]
[null,null,"maïzena","kg",7.28,null,null,""]
[null,"Fruit","melon ","kg",4.99,null,null,""]
[null,null,"œuf","pce",0.24,null,null,{"$f":"IF(F58=\"\",\"\",E58*F58)","v":""}]
[null,null,"œuf","pce",0.24,null,null,""]
[null,null,"Œufs frais","Pièce",0.15,null,null,""]
[null,"Asaisonnement","oignon","kg",1.99,null,null,""]
[null,"Asaisonnement","Oignons frais","Kg",0.55000000000000004,null,null,""]
[null,"Fruit","orange","kg",2.5,null,null,""]
[null,"Accompagnement","Pain","1/5 baguette",0.2,null,null,""]
[null,"Fruit","papaye","kg",3.99,null,null,""]
[null,"Fromage","parmesan","kg",25.2,null,null,""]
[null,"Légume","patate douce","kg",2.99,null,null,""]
[null,null,"pâtes","kg",2.5,null,null,""]
[null,"Asaisonnement","Petits oignons frais","Kg",2.1,null,null,""]
[null,"Légume","Poireaux frais","Kg",1.6,null,null,""]
[null,"Légume","poivron","kg",2.99,null,null,""]
[null,"Légume","pulpe de tomate","kg",4.5,null,null,""]
[null,"Légume","riz","kg",2.36,null,null,""]
[null,"Légume","Riz haut de gamme","Kg",6,null,null,""]
[null,"Légume","riz pour risotto","kg",3.76,null,null,""]
[null,"Légume","salade","kg",1.5,null,null,""]
[null,"Poisson","saumon fumé","kg",33.93,null,null,""]
[null,"Asaisonnement","Sel fin, poivre blanc","P.M",0.01,null,null,""]
[null,null,"sucre",null,0.89,null,null,""]
[null,null,"sucre","kg",1.32,null,null,""]
[null,null,"Sucre semoule","P.M",null,null,null,""]
[null,"Légume","tomate","kg",2.99,null,null,""]
[null,"Boisson","vin blanc","l",2.57,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,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F90=\"\",\"\",E90*F90)","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F122=\"\",\"\",E122*F122)","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F154=\"\",\"\",E154*F154)","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F186=\"\",\"\",E186*F186)","v":""}]
[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,""]
[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,""]