{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Accueil","Recap",">","Histo","Temp","BDD","<"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"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":"Accueil","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Recap","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,5,11,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[0,5,0,8],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[2,5,2,6]]}
[null,null,null,null,null,"DATE"]
[null,null,null,null,null,"Du","2016-02-11","Au","2017-01-23"]
[null,null,null,null,null,"Articles",null,"Quantité","Recette"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SUMIFS(Quantite,Lesdates,\">=\"&$G$2,Lesdates,\"<=\"&$I$2,Articles,$F4),\"\")","v":""},{"$f":"IFERROR(SUMIFS(Total,Lesdates,\">=\"&$G$2,Lesdates,\"<=\"&$I$2,Articles,$F4),\"\")","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,"Total",null,{"$f":"SUM($H$4:$H$11)","v":0},{"$f":"SUM($I$4:$I$11)","v":0}]

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

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

{"sheet":"Temp","index":4,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[[11,0,11,3]]}
["Date","Client","Quantitée","Articles","mode paiement","Prix total"]

{"sheet":"BDD","index":5,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[40,3,48,3],[49,3,65,3],[1,3,8,3],[13,3,20,3],[22,3,27,3],[28,3,31,3]]}
["Num_Article","Désignation","Prix",null,"Moyen de Paiement"]
[1,"Tomate c",1,null,"Cash"]
[2,"Tomate Ronde",2,null,"CB"]
[3,"Tomate Cerise",3,null,"Chèque"]
[4,"Concombre",4,null,"Ardoise"]
[5,"Poivron",5]
[6,"Piment",6]
[7,"Courgette",7]
[8,"Melon 1",8]
[9,"Melon 2",9]
[10,"Melon 3",10]
[11,null,11]
[12,"Chou Vert",12]
[13,"Romanesco",13]
[14,"Chou rouge",14]
[15,"Brocoli",15]
[16,"Libre 3",2002]
[17,"Libre 2",2001]
[18,"Libre 1",2000]
[19,"Chou Fleur",16]
[20,"Bruxelles",17]
[21]
[22,"Libre 4",18]
[23,"Ail",19]
[24,"Libre 8",50]
[25,"Libre 7",40]
[26,"Libre 6",30]
[27,"Libre 5",20]
[28,"Echalotte",21]
[29,"Oignon",22]
[30,"Echalotte Grise",23]
[31,"Oignon rouge",24]
[32,"Blette",100]
[33,"Celeri Branche",101]
[34,"Epinard",102]
[35,"Libre 20",103]
[36,"Libre 21",104]
[37,"Libre 22",105]
[38,"Libre 23",106]
[39,"Libre 24",107]
[40,"Patisson",26]
[41,"Potiron",27]
[42,"Libre 13",900]
[43,"Libre 12",800]
[44,"Libre 11",700]
[45,"Libre 10",600]
[46,"Libre 9",500]
[47,"Butternut",450]
[48,"Potimarron",28]
[49,"Betterave",29]
[50,"Carotte",30]
[51,"Celeri Rave",31]
[52,"Fenouil",32]
[53,"Navet",33]
[54,"Libre 15",1001]
[55,"Libre 16",1002]
[56,"Libre 14",1000]
[57,"Radis Rouge",34]
[58,"Libre 25",1.2]
[59,"Libre 26",2.4]
[60,"Libre 27",3.3]
[61,"Libre 28",2.5]
[62,"Libre 29",2.4]
[63,"Libre 30",2.2000000000000002]
[64,"Libre 31",5.4]
[65,"Libre 32",8.1999999999999993]

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