{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"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":"Feuil1","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["client","facture","date","montant","type",null,100,100,100,100,100]
[1,201501,"2015-01-01",100,"f",null,200,200,200,200,200]
[2,201502,"2015-01-02",200,"f",null,300,300,300,300,300]
[3,201503,"2015-01-03",300,"a",null,400,400,400,400,400]
[4,201504,"2015-01-04",400,"a",null,500,500,500,500,500]
[5,201505,"2015-01-05",500,"a",null,600,600,600,600,600]
[6,201506,"2015-01-06",600,"f",null,700,700,700,700,700]
[7,201507,"2015-01-07",700,"f",null,800,800,800,800,800]
[8,201508,"2015-01-08",800,"a",null,900,900,900,900,900]
[9,201509,"2015-01-09",900,"a",null,1000,1000,1000,1000,1000]
[10,201510,"2015-01-10",1000,"a",null,1100,1100,1100,1100,1100]
[11,201511,"2015-01-11",1100,"f",null,1200,1200,1200,1200,1200]
[12,201512,"2015-01-12",1200,"f","mini",1300,1300,1300,1300,1300]
[13,201513,"2015-01-13",1300,"f",190,1400,1400,1400,1400,1400]
[14,201514,"2015-01-14",1400,"f","maxi",1500,1500,1500,1500,1500]
[0,null,null,null,null,1400]
[null,null,"somme factures",{"$f":"SUMIF(E2:E15,\"f\",D2:D15)","v":6600},null,"somme entre mini et maxi"]
[null,null,"somme avoirs",{"$f":"SUMIF(E2:E15,\"a\",D2:D15)","v":3900},null,{"$f":"SUMIFS(G1:K15,G1:K15,\">=\"&F14,G1:K15,\"<=\"&F16)","v":52000}]
[null,null,null,null,null,"somme < mini et > maxi"]
[null,null,null,null,null,{"$f":"SUMIF(G1:K15,\"<\"&F14)+SUMIF(G1:K15,\">\"&F16)","v":8000}]
[null,null,null,null,"coef","somme avec coef"]
[null,null,null,null,1.1000000000000001,{"$f":"F20+F18*E22","v":65200.000000000007}]

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

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