{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":[">","Total","BDD","<","Histo","Temp"],"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":">","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Total","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,3,20,4]]}
[null,"Boissons","Vendues","Gratuits","Total \nBoissons","Recette","Nombre"]
[null,"Bière Blonde",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B2,Histo!D:D,\">0\")","v":6},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B2,Histo!D:D,0)","v":0},{"$f":"C2+D2","v":6},{"$f":"C2*1","v":6},{"$f":"C2+D2","v":6}]
[null,"Bière Brune",{"$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,0)","v":0},{"$f":"C3+D3","v":0},{"$f":"C3*1.2","v":0},{"$f":"C3+D3","v":0}]
[null,"Bière S-Alcool",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B4,Histo!D:D,\">0\")","v":1},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B4,Histo!D:D,0)","v":0},1,{"$f":"C4*1","v":1},1]
[null,"Perrier",{"$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,0)","v":0},0,{"$f":"C5*1","v":0},0]
[null,"Coca Cola",{"$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,0)","v":0},0,0,0]
[null,"Orangina",{"$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,0)","v":0},0,0,0]
[null,"Schewppes",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B8,Histo!D:D,\">0\")","v":2},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B8,Histo!D:D,0)","v":0},2,2,2]
[null,"Oasis",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B9,Histo!D:D,\">0\")","v":3},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B9,Histo!D:D,0)","v":0},3,3,3]
[null,"Jus d'Ananas",{"$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,0)","v":0},0,0,0]
[null,"Eau",{"$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,0)","v":0},0,{"$f":"C11*0.8","v":0},0]
[null,"Café",{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B12,Histo!D:D,\">0\")","v":3},{"$f":"SUMIFS(Histo!B:B,Histo!C:C,Total!B12,Histo!D:D,0)","v":0},3,{"$f":"C12*0.5","v":1.5},3]
[null,"Thé",{"$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,0)","v":0},0,{"$f":"C13*0.5","v":0},0]
[null,"Soupe",{"$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,0)","v":0},0,{"$f":"C14*0.5","v":0},0]
[null,"Chocolat",{"$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,0)","v":0},0,{"$f":"C15*0.5","v":0},0]
[null,"Thé Glacé",{"$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,0)","v":0},0,{"$f":"C16*1","v":0},0]
[null,"Vin Rouge",{"$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,0)","v":0},{"$f":"C17+D17","v":0},{"$f":"C17*0.5","v":0},0]
[]
[]
[]
[null,null,null,"Total Boissons Payées",null,{"$f":"SUM(F2:F20)","v":13.5}]

{"sheet":"BDD","index":2,"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,"Café",0.5]
[12,"Thé",0.5]
[13,"Soupe",0.8]
[14,"Chocolat",0.8]
[15,"Thé Glacé",1]
[16,"Vin Rouge",0.5]

{"sheet":"<","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Histo","index":4,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Date","Quantitée","Articles","Total"]
["07:27:19",2,"Schewppes",2]
["07:27:23",1,"Bière Blonde",1]
["13:46:32",2,"Bière Blonde",2]
["13:46:35",3,"Oasis",3]
["13:48:34",1,"Bière S-Alcool",1]
["13:48:38",3,"Café",1.5]
["13:48:46",3,"Bière Blonde",3]

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