{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Feuil1","ingredients","sous recette","vierge"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"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":"Feuil1","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Feuil1"]
["vierge"]
["test"]
["Creme patissière classic"]
["Frangipanne pomme"]
["autr"]

{"sheet":"ingredients","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Article","prixht","fournisseur"]
["beurre",3.5,"rtbr"]
["sucre",6,"rivbj"]
["œuf",8]
["grty",1,"rotgb"]
["gtyuh",2,"robk"]
["okjogj",3,"rgtbok"]
["depijroitjgbv",4,"yuk"]
["rpgbrp,",5,"roçgkb"]

{"sheet":"sous recette","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sous recette","prix revient ht","famille"]
["frangipanne ",null,"tgt"]
["g",null,"tgt"]
["t",null,"tgt"]
["y",null,"tgt"]
["u",null,"gt"]
["i",null,"gt"]
["o",null,"gt"]
["o",null,"gt"]
["yt",null,"iu"]

{"sheet":"vierge","index":3,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[25,0,47,4],[4,0,4,4],[22,0,22,1],[23,0,23,1],[23,2,23,4],[24,0,24,4]]}
[]
[]
[]
[{"$f":"A2*G23","v":0},{"$f":"B2*G23","v":0},{"$f":"C2*G23","v":0},{"$f":"D2*G23","v":0},{"$f":"E2*G23","v":0}]
[{"$f":"RIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\"),1))","v":"vierge"}]
["Ingrédients",{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":{"$error":"#VALUE!"}},"Recette de base","Recette pour 1kg","Recette pour production"]
[null,{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,{"$f":"IFERROR(C7/F7+(C7/F7)*F24,0)","v":0},{"$f":"H7*D7","v":0},{"$f":"C23","v":0},{"$f":"IFERROR(B7*D7,0)","v":0},{"$f":"A2*A3+C2*C3+D2*D3+E2*E3","v":0}]
[null,{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,{"$f":"IFERROR(C8/F8+(C8/F8)*F25,0)","v":0},{"$f":"H8*D8","v":0},{"$f":"F7","v":0},{"$f":"IFERROR(B8*D8,0)","v":0},{"$f":"H7","v":0}]
[null,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,{"$f":"F8","v":0},0,{"$f":"H8","v":0}]
[null,{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
[null,{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,OFFSET([1]base_de_donnée!$A$1:$B$1,0,0,COUNTA([1]base_de_donnée!$A:$B)-1),2,FALSE))","v":""},null,0,0,0,0,0]
["Total",null,{"$f":"SUM(C7:C22)","v":0},{"$f":"SUM(D7:D22)","v":0},{"$f":"SUM(E7:E22)","v":0},null,{"$f":"SUM(G7:G22)","v":0}]
["Perte",null,null,null,null,{"$f":"C24","v":0}]
["Procédé de fabrication",null,null,null,null,{"$f":"F24","v":0}]
[null,null,null,null,null,{"$f":"F25","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]