{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Synthese","Janvier","Février","Mars","Avril","Mai","Juin","Septembre","Octobre"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Synthese","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,2,0,3]]}
[null,"Bonbache.fr","Bonbache.fr/Excel",null,"Bonbache.fr/ExcelVBA",null,"Livres Excel"]
[]
[null,null,null,"Sommaire","Recap"]
[null,null,null,{"$f":"IF(ROWS($1:2)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:2)),\"\")","v":"Janvier"},{"$f":"IFERROR(INDIRECT(D4&\"!C2\"),\"\")","v":304367}]
[null,null,null,{"$f":"IF(ROWS($1:3)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:3)),\"\")","v":"Février"},{"$f":"IFERROR(INDIRECT(D5&\"!C2\"),\"\")","v":251824}]
[null,null,null,{"$f":"IF(ROWS($1:4)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:4)),\"\")","v":"Mars"},291449]
[null,null,null,{"$f":"IF(ROWS($1:5)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:5)),\"\")","v":"Avril"},241735]
[null,null,null,{"$f":"IF(ROWS($1:6)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:6)),\"\")","v":"Mai"},272184]
[null,null,null,{"$f":"IF(ROWS($1:7)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:7)),\"\")","v":"Juin"},374230]
[null,null,null,{"$f":"IF(ROWS($1:8)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:8)),\"\")","v":"Septembre"},364561]
[null,null,null,{"$f":"IF(ROWS($1:9)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:9)),\"\")","v":"Octobre"},470819]
[null,null,null,{"$f":"IF(ROWS($1:10)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:10)),\"\")","v":""},""]
[null,null,null,{"$f":"IF(ROWS($1:11)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:11)),\"\")","v":""},""]
[null,null,null,{"$f":"IF(ROWS($1:12)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:12)),\"\")","v":""},""]
[null,null,null,{"$f":"IF(ROWS($1:13)<=COUNTA(nomF),INDEX(MID(nomF,FIND(\"]\",nomF)+1,100),ROWS($1:13)),\"\")","v":""},""]

{"sheet":"Janvier","index":1,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[{"$f":"HYPERLINK(\"[sommaire-automatique.xlsm]Synthese!A1\",\"Sommaire\")","v":"Sommaire"}]
[null,"Total",{"$f":"SUM(C5:C35)","v":304367}]
[]
[null,"Date","CA"]
[null,"2021-01-01",6323]
[null,"2021-01-02",13214]
[null,"2021-01-03",5956]
[null,"2021-01-04",9474]
[null,"2021-01-05",8666]
[null,"2021-01-06",12844]
[null,"2021-01-07",8006]
[null,"2021-01-08",9846]
[null,"2021-01-09",13167]
[null,"2021-01-10",14101]
[null,"2021-01-11",4920]
[null,"2021-01-12",11556]
[null,"2021-01-13",3337]
[null,"2021-01-14",11647]
[null,"2021-01-15",9380]
[null,"2021-01-16",4468]
[null,"2021-01-17",12184]
[null,"2021-01-18",4387]
[null,"2021-01-19",7320]
[null,"2021-01-20",8834]
[null,"2021-01-21",14221]
[null,"2021-01-22",12966]
[null,"2021-01-23",12784]
[null,"2021-01-24",12921]
[null,"2021-01-25",14906]
[null,"2021-01-26",11330]
[null,"2021-01-27",12090]
[null,"2021-01-28",14099]
[null,"2021-01-29",7995]
[null,"2021-01-30",3908]
[null,"2021-01-31",7517]

{"sheet":"Février","index":2,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[{"$f":"HYPERLINK(\"[sommaire-automatique.xlsm]Synthese!A1\",\"Sommaire\")","v":"Sommaire"}]
[null,"Total",{"$f":"SUM(C5:C32)","v":251824}]
[]
[null,"Date","CA"]
[null,"2021-02-01",3484]
[null,"2021-02-02",9092]
[null,"2021-02-03",10049]
[null,"2021-02-04",14452]
[null,"2021-02-05",7159]
[null,"2021-02-06",8480]
[null,"2021-02-07",11665]
[null,"2021-02-08",14427]
[null,"2021-02-09",13635]
[null,"2021-02-10",6154]
[null,"2021-02-11",13722]
[null,"2021-02-12",14608]
[null,"2021-02-13",7195]
[null,"2021-02-14",8693]
[null,"2021-02-15",2886]
[null,"2021-02-16",5262]
[null,"2021-02-17",8517]
[null,"2021-02-18",14975]
[null,"2021-02-19",5785]
[null,"2021-02-20",6355]
[null,"2021-02-21",12598]
[null,"2021-02-22",10566]
[null,"2021-02-23",2757]
[null,"2021-02-24",2832]
[null,"2021-02-25",10067]
[null,"2021-02-26",8538]
[null,"2021-02-27",7017]
[null,"2021-02-28",10854]

{"sheet":"Mars","index":3,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[{"$f":"HYPERLINK(\"[sommaire-automatique.xlsm]Synthese!A1\",\"Sommaire\")","v":"Sommaire"}]
[null,"Total",{"$f":"SUM(C5:C35)","v":291449}]
[]
[null,"Date","CA"]
[null,"2021-03-01",13210]
[null,"2021-03-02",11591]
[null,"2021-03-03",14187]
[null,"2021-03-04",12249]
[null,"2021-03-05",14060]
[null,"2021-03-06",10703]
[null,"2021-03-07",11662]
[null,"2021-03-08",7624]
[null,"2021-03-09",8201]
[null,"2021-03-10",7073]
[null,"2021-03-11",4132]
[null,"2021-03-12",9270]
[null,"2021-03-13",9223]
[null,"2021-03-14",12085]
[null,"2021-03-15",5772]
[null,"2021-03-16",8190]
[null,"2021-03-17",8485]
[null,"2021-03-18",13097]
[null,"2021-03-19",10104]
[null,"2021-03-20",4209]
[null,"2021-03-21",5069]
[null,"2021-03-22",6095]
[null,"2021-03-23",3669]
[null,"2021-03-24",13953]
[null,"2021-03-25",4702]
[null,"2021-03-26",7909]
[null,"2021-03-27",5191]
[null,"2021-03-28",13297]
[null,"2021-03-29",10649]
[null,"2021-03-30",14736]
[null,"2021-03-31",11052]

{"sheet":"Avril","index":4,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[{"$f":"HYPERLINK(\"[sommaire-automatique.xlsm]Synthese!A1\",\"Sommaire\")","v":"Sommaire"}]
[null,"Total",{"$f":"SUM(C5:C34)","v":241735}]
[]
[null,"Date","CA"]
[null,"2021-04-01",4335]
[null,"2021-04-02",13720]
[null,"2021-04-03",3166]
[null,"2021-04-04",6928]
[null,"2021-04-05",12708]
[null,"2021-04-06",14781]
[null,"2021-04-07",14520]
[null,"2021-04-08",10353]
[null,"2021-04-09",4795]
[null,"2021-04-10",8647]
[null,"2021-04-11",2777]
[null,"2021-04-12",7661]
[null,"2021-04-13",7028]
[null,"2021-04-14",11161]
[null,"2021-04-15",10207]
[null,"2021-04-16",11983]
[null,"2021-04-17",8490]
[null,"2021-04-18",4417]
[null,"2021-04-19",4125]
[null,"2021-04-20",10369]
[null,"2021-04-21",10771]
[null,"2021-04-22",13595]
[null,"2021-04-23",10912]
[null,"2021-04-24",5540]
[null,"2021-04-25",3308]
[null,"2021-04-26",10360]
[null,"2021-04-27",2542]
[null,"2021-04-28",7483]
[null,"2021-04-29",2536]
[null,"2021-04-30",2517]

{"sheet":"Mai","index":5,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[{"$f":"HYPERLINK(\"[sommaire-automatique.xlsm]Synthese!A1\",\"Sommaire\")","v":"Sommaire"}]
[null,"Total",{"$f":"SUM(C5:C35)","v":272184}]
[]
[null,"Date","CA"]
[null,"2021-05-01",3291]
[null,"2021-05-02",7738]
[null,"2021-05-03",3432]
[null,"2021-05-04",9065]
[null,"2021-05-05",12146]
[null,"2021-05-06",3228]
[null,"2021-05-07",4954]
[null,"2021-05-08",11427]
[null,"2021-05-09",13729]
[null,"2021-05-10",15410]
[null,"2021-05-11",12339]
[null,"2021-05-12",4735]
[null,"2021-05-13",3552]
[null,"2021-05-14",13927]
[null,"2021-05-15",11015]
[null,"2021-05-16",7777]
[null,"2021-05-17",14622]
[null,"2021-05-18",11263]
[null,"2021-05-19",4581]
[null,"2021-05-20",11750]
[null,"2021-05-21",4241]
[null,"2021-05-22",4480]
[null,"2021-05-23",3303]
[null,"2021-05-24",7730]
[null,"2021-05-25",3156]
[null,"2021-05-26",8271]
[null,"2021-05-27",10065]
[null,"2021-05-28",13943]
[null,"2021-05-29",14194]
[null,"2021-05-30",10113]
[null,"2021-05-31",12707]

{"sheet":"Juin","index":6,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[{"$f":"HYPERLINK(\"[sommaire-automatique.xlsm]Synthese!A1\",\"Sommaire\")","v":"Sommaire"}]
[null,"Total",{"$f":"SUM(C5:C34)","v":374230}]
[]
[null,"Date","CA"]
[null,"2021-06-01",16141]
[null,"2021-06-02",8542]
[null,"2021-06-03",13742]
[null,"2021-06-04",8757]
[null,"2021-06-05",15070]
[null,"2021-06-06",19674]
[null,"2021-06-07",7630]
[null,"2021-06-08",10764]
[null,"2021-06-09",5369]
[null,"2021-06-10",15482]
[null,"2021-06-11",10344]
[null,"2021-06-12",6227]
[null,"2021-06-13",9147]
[null,"2021-06-14",18674]
[null,"2021-06-15",14980]
[null,"2021-06-16",14000]
[null,"2021-06-17",12531]
[null,"2021-06-18",13980]
[null,"2021-06-19",7130]
[null,"2021-06-20",19612]
[null,"2021-06-21",10730]
[null,"2021-06-22",13249]
[null,"2021-06-23",14194]
[null,"2021-06-24",15455]
[null,"2021-06-25",11918]
[null,"2021-06-26",6572]
[null,"2021-06-27",8219]
[null,"2021-06-28",11788]
[null,"2021-06-29",16168]
[null,"2021-06-30",18141]

{"sheet":"Septembre","index":7,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[{"$f":"HYPERLINK(\"[sommaire-automatique.xlsm]Synthese!A1\",\"Sommaire\")","v":"Sommaire"}]
[null,"Total",{"$f":"SUM(C5:C34)","v":364561}]
[]
[null,"Date","CA"]
[null,"2021-06-01",16141]
[null,"2021-06-02",8542]
[null,"2021-06-03",13742]
[null,"2021-06-04",8757]
[null,"2021-06-05",15070]
[null,"2021-06-06",19674]
[null,"2021-06-07",7630]
[null,"2021-06-08",10764]
[null,"2021-06-09",5369]
[null,"2021-06-10",15482]
[null,"2021-06-11",10344]
[null,"2021-06-12",6227]
[null,"2021-06-13",9147]
[null,"2021-06-14",9005]
[null,"2021-06-15",14980]
[null,"2021-06-16",14000]
[null,"2021-06-17",12531]
[null,"2021-06-18",13980]
[null,"2021-06-19",7130]
[null,"2021-06-20",19612]
[null,"2021-06-21",10730]
[null,"2021-06-22",13249]
[null,"2021-06-23",14194]
[null,"2021-06-24",15455]
[null,"2021-06-25",11918]
[null,"2021-06-26",6572]
[null,"2021-06-27",8219]
[null,"2021-06-28",11788]
[null,"2021-06-29",16168]
[null,"2021-06-30",18141]

{"sheet":"Octobre","index":8,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[{"$f":"HYPERLINK(\"[sommaire-automatique.xlsm]Synthese!A1\",\"Sommaire\")","v":"Sommaire"}]
[null,"Total",{"$f":"SUM(C5:C34)","v":470819}]
[]
[null,"Date","CA"]
[null,"2021-06-01",16141]
[null,"2021-06-02",8542]
[null,"2021-06-03",120000]
[null,"2021-06-04",8757]
[null,"2021-06-05",15070]
[null,"2021-06-06",19674]
[null,"2021-06-07",7630]
[null,"2021-06-08",10764]
[null,"2021-06-09",5369]
[null,"2021-06-10",15482]
[null,"2021-06-11",10344]
[null,"2021-06-12",6227]
[null,"2021-06-13",9147]
[null,"2021-06-14",9005]
[null,"2021-06-15",14980]
[null,"2021-06-16",14000]
[null,"2021-06-17",12531]
[null,"2021-06-18",13980]
[null,"2021-06-19",7130]
[null,"2021-06-20",19612]
[null,"2021-06-21",10730]
[null,"2021-06-22",13249]
[null,"2021-06-23",14194]
[null,"2021-06-24",15455]
[null,"2021-06-25",11918]
[null,"2021-06-26",6572]
[null,"2021-06-27",8219]
[null,"2021-06-28",11788]
[null,"2021-06-29",16168]
[null,"2021-06-30",18141]