{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["catégorie","ACHAT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":36,"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":"catégorie","index":0,"n_rows":14,"n_cols":20,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Catégorie du Produit",null,null,"Boissons_chaudes","P1","Desserts_et_Laitages","p2","drogueries","p3","Fromages","p4","Légumes_et_Salades","p5","Soupes","p6","etc","etc"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Thé",0.5,"beurre doux",0.75,"Adoucissant",0.6,"Buche St Maure chèvre",0.4,"ail",0.7,"Tomates vermicelles déshydraté"]
[null,null,null,"infusions",{"$f":"E3+1","v":1.5},"beurre salé",{"$f":"G3+0.4","v":1.1499999999999999},"Après rasage",{"$f":"I3+0.3","v":0.89999999999999991},"camembert",{"$f":"K3+0.6","v":1},"artichaut ",{"$f":"M3+0.6","v":1.2999999999999998},"Pot au Feu vermicelles déshydraté"]
[null,null,null,"Café en grains",{"$f":"E4+1","v":2.5},"crème aux œufs",{"$f":"G4+0.4","v":1.5499999999999998},"déo d'intérieur",{"$f":"I4+0.3","v":1.2},"Conté",{"$f":"K4+0.6","v":1.6},"Brocoli",1.9,"Forestière Champignons Oignons déshydraté",null,null," "]
[null,null,null,"café moulu",3.5,"Crème Caramel",1.9499999999999997,"cirage blanc",1.5,"carré frais Gervais",2.2000000000000002,"aubergine kg",2.5,"Paysanne aux légumes lard déshydraté",null,null,null,null,null," "]
[null,null,null,"chocolat en poudre ",4.5,"crème feuilleté chocolat ",2.3499999999999996,"cirage marron",1.8,"Emmenthal",2.8000000000000003,"Carotte fane",3.1," 9 légumes",null,null,null,null,null," "]
[" ",null,null,null,null,null,null,"cirage noir",2.1,null,null,"carottes",null,"Petit poids Pancetta"]
[" ",null,null,null,null,null,null,null,null,null,null,"concombre"]
[" ",null,null,null,"les prix sont tous faux mise à jour si le tableau fonction ",null,null,null,null,null,null,"courgettes"]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,"il y a sur le classeur existant beaucoup plus de colonne et de Produit"]

{"sheet":"ACHAT","index":1,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,null,null," "]
[null,null,null,null,"actuellement je sais faire",null,"Je souhaite indiquer le prix de chaque produits",null,null,null,null,null," "]
[null,null,null,null,null,null,"qui changerait à chaque modification du produit acheté"]
[]
[null,null,null,null,"CATEGORIE","PRODUIT","Prix"]
[null,null,null,null,"Boissons_chaudes","Thé",{"$f":"IFERROR(VLOOKUP(F6,OFFSET(catégorie!$D:$D,,(MATCH(E6,catégorie!$1:$1,0)-4),,2),2,FALSE),\"\")","v":0.5}]
[null,null,null,null,"Desserts_et_Laitages","beurre doux",{"$f":"IFERROR(VLOOKUP(F7,OFFSET(catégorie!$D:$D,,(MATCH(E7,catégorie!$1:$1,0)-4),,2),2,FALSE),\"\")","v":0.75}]
[null,null,null,null,"Desserts_et_Laitages","beurre salé",{"$f":"IFERROR(VLOOKUP(F8,OFFSET(catégorie!$D:$D,,(MATCH(E8,catégorie!$1:$1,0)-4),,2),2,FALSE),\"\")","v":1.1499999999999999}]
[null,null,null,null,"drogueries","cirage blanc",{"$f":"IFERROR(VLOOKUP(F9,OFFSET(catégorie!$D:$D,,(MATCH(E9,catégorie!$1:$1,0)-4),,2),2,FALSE),\"\")","v":1.5}]
[null,null,null,null,"drogueries",null,{"$f":"IFERROR(VLOOKUP(F10,OFFSET(catégorie!$D:$D,,(MATCH(E10,catégorie!$1:$1,0)-4),,2),2,FALSE),\"\")","v":""},null,null,null,null,null," "]
[null,null,null,null,"Fromages","Emmenthal",{"$f":"IFERROR(VLOOKUP(F11,OFFSET(catégorie!$D:$D,,(MATCH(E11,catégorie!$1:$1,0)-4),,2),2,FALSE),\"\")","v":2.8000000000000003}]
[null,null,null,null,"Fromages","camembert",{"$f":"IFERROR(VLOOKUP(F12,OFFSET(catégorie!$D:$D,,(MATCH(E12,catégorie!$1:$1,0)-4),,2),2,FALSE),\"\")","v":1}]
[null,null,null,null,"Légumes_et_Salades","Poireau",{"$f":"IFERROR(VLOOKUP(F13,OFFSET(catégorie!$D:$D,,(MATCH(E13,catégorie!$1:$1,0)-4),,2),2,FALSE),\"\")","v":""}]
[null,null,null,null,"Légumes_et_Salades","courgettes",{"$f":"IFERROR(VLOOKUP(F14,OFFSET(catégorie!$D:$D,,(MATCH(E14,catégorie!$1:$1,0)-4),,2),2,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F15,OFFSET(catégorie!$D:$D,,(MATCH(E15,catégorie!$1:$1,0)-4),,2),2,FALSE),\"\")","v":""}]
[null,null,null,null,null,"Total",{"$f":"SUM(G6:G15)","v":7.7}]
[]
[null,null,null,null,"Faire un total des produits à acheter pour éviter le dépassement du budget aloué."]
[]
[null,null,null,null,null,null,null,"MERCI D'AVANCE"]