{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Total","BDD","Histo","Temp","Stock"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Total","index":0,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,3,19,4],[19,8,19,10],[0,8,0,9]]}
[null,null,null,null,null,null,null,null,"Le:18/10/2018"]
[null,"Boissons","Vendues","Gratuits","Total \nBoissons","Recette","Nombre",null,"Vendues","Gratuits","Total \nBoissons","Recette","Nombre"]
[null,"Bière Blonde",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B3,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B3,Histo!D:D,\"\")","v":0},{"$f":"C3+D3","v":0},{"$f":"C3*1","v":0},{"$f":"C3+D3","v":0},null,0,0,0,0,0]
[null,"Bière Brune",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B4,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B4,Histo!D:D,\"\")","v":0},{"$f":"C4+D4","v":0},{"$f":"C4*1.2","v":0},{"$f":"C4+D4","v":0},null,0,0,0,0,0]
[null,"Bière S-Alcool",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B5,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B5,Histo!D:D,\"\")","v":0},0,{"$f":"C5*1","v":0},0,null,0,0,0,0,0]
[null,"Perrier",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B6,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B6,Histo!D:D,\"\")","v":0},0,{"$f":"C6*1","v":0},0,null,0,0,0,0,0]
[null,"Coca Cola",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B7,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B7,Histo!D:D,\"\")","v":0},0,0,0,null,0,0,0,0,0]
[null,"Orangina",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B8,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B8,Histo!D:D,\"\")","v":0},0,0,0,null,0,0,0,0,0]
[null,"Schewppes",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B9,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B9,Histo!D:D,\"\")","v":0},0,0,0,null,0,0,0,0,0]
[null,"Oasis",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B10,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B10,Histo!D:D,\"\")","v":0},0,0,0,null,0,0,0,0,0]
[null,"Jus d'Ananas",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B11,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B11,Histo!D:D,\"\")","v":0},0,0,0,null,0,0,0,0,0]
[null,"Eau",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B12,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B12,Histo!D:D,\"\")","v":0},0,{"$f":"C12*0.8","v":0},0,null,0,0,0,0,0]
[null,"Thé Glacé",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B13,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B13,Histo!D:D,\"\")","v":0},0,{"$f":"C13*1","v":0},0,null,0,0,0,0,0]
[null,"Thé",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B14,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B14,Histo!D:D,\"\")","v":0},0,{"$f":"C14*0.5","v":0},0,null,0,0,0,0,0]
[null,"Soupe",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B15,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B15,Histo!D:D,\"\")","v":0},0,{"$f":"C15*0.5","v":0},0,null,0,0,0,0,0]
[null,"Chocolat",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B16,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B16,Histo!D:D,\"\")","v":0},0,{"$f":"C16*0.5","v":0},0,null,0,0,0,0,0]
[null,"Café",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B17,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B17,Histo!D:D,\"\")","v":0},0,{"$f":"C17*0.5","v":0},0,null,0,0,0,0,0]
[null,"Cappucino",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B18,Histo!D:D,\">0\")","v":0},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B18,Histo!D:D,\"\")","v":0},{"$f":"C18+D18","v":0},{"$f":"C18*0.8","v":0},0,null,0,0,0,0,0]
[]
[null,null,null,"Total Boissons Payées",null,{"$f":"SUM(F3:F18)","v":0},null,null,"Total Boissons Payées",null,null,{"$f":"SUM(L3:L18)","v":0}]

{"sheet":"BDD","index":1,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Num_Article","Désignation","Prix"]
[1,"Bière Blonde",1]
[2,"Bière Brune",1.2]
[3,"Bière S-Alcool",1]
[4,"Perrier",1]
[5,"Coca Cola",1]
[6,"Orangina",1]
[7,"Schewppes",1]
[8,"Oasis",1]
[9,"Jus d'Ananas",1]
[10,"Eau",0.8]
[11,"Thé Glacé",1]
[12,"Thé",0.5]
[13,"Soupe",0.8]
[14,"Chocolat",0.8]
[15,"Café",5]
[16,"Cappucino",0.8]

{"sheet":"Histo","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Date","Quantitée","Articles","Total"]
[null,null,null,null,null,"Bière Blonde",{"$f":"SUMIFS($B$2:$B$250,$C$2:$C$250,F2)","v":0}]
[null,null,null,null,null,"Bière Brune",{"$f":"SUMIFS($B$2:$B$250,$C$2:$C$250,F3)","v":0}]
[null,null,null,null,null,"Bière S-Alcool",0]
[null,null,null,null,null,"Perrier",0]
[null,null,null,null,null,"Coca Cola",0]
[null,null,null,null,null,"Orangina",0]
[null,null,null,null,null,"Schewppes",0]
[null,null,null,null,null,"Oasis",0]
[null,null,null,null,null,"Jus d'Ananas",0]
[null,null,null,null,null,"Eau",0]
[null,null,null,null,null,"Café",0]
[null,null,null,null,null,"Thé",0]
[null,null,null,null,null,"Soupe",0]
[null,null,null,null,null,"Chocolat",0]
[null,null,null,null,null,"Thé Glacé",0]
[null,null,null,null,null,"Cappucino",0]

{"sheet":"Temp","index":3,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Date","Quantitée","Articles","Total"]

{"sheet":"Stock","index":4,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Boissons","Stock initial","Entrées","Sorties","Stock final"]
["Bière Blonde",36,null,4,{"$f":"IF(A2=\"\",\"\",B2+C2-D2)","v":32}]
["Bière Brune",0,null,2,{"$f":"IF(A3=\"\",\"\",B3+C3-D3)","v":-2}]
["Bière S-Alcool",5,null,0,5]
["Perrier",23,null,0,23]
["Coca Cola",16,null,0,16]
["Orangina",29,null,0,29]
["Schewppes",12,null,4,8]
["Oasis",14,null,3,11]
["Jus d'Ananas",20,null,0,20]
["Eau",10,null,5,5]
["Thé Glacé",20,null,0,20]
[null,"",null,0,""]
[null,"",null,0,""]
[null,"",null,0,""]
[null,null,null,0,""]
[null,null,null,0,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]