{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Synthèse","Audine","Galls","Doeuf","Braltar","Ogne","Hocket"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Synthèse","index":0,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5]]}
[null,"Bonbache.fr","Bonbache.fr/Excel",null,"Bonbache.fr/ExcelVBA",null,"Livres Excel"]
[]
[null,null,null,"Nom","Total Ventes"]
[null,null,null,{"$f":"IF(ROWS($1:2)<=COUNTA(NomF),HYPERLINK(INDEX(NomF,ROWS($1:2))&\"!A1\",INDEX(MID(NomF,FIND(\"]\",NomF)+1,100),ROWS($1:2))),\"\")","v":"Audine"}]
[null,null,null,{"$f":"IF(ROWS($1:3)<=COUNTA(NomF),HYPERLINK(INDEX(NomF,ROWS($1:3))&\"!A1\",INDEX(MID(NomF,FIND(\"]\",NomF)+1,100),ROWS($1:3))),\"\")","v":"Galls"}]
[null,null,null,{"$f":"IF(ROWS($1:4)<=COUNTA(NomF),HYPERLINK(INDEX(NomF,ROWS($1:4))&\"!A1\",INDEX(MID(NomF,FIND(\"]\",NomF)+1,100),ROWS($1:4))),\"\")","v":"Doeuf"}]
[null,null,null,{"$f":"IF(ROWS($1:5)<=COUNTA(NomF),HYPERLINK(INDEX(NomF,ROWS($1:5))&\"!A1\",INDEX(MID(NomF,FIND(\"]\",NomF)+1,100),ROWS($1:5))),\"\")","v":"Braltar"}]
[null,null,null,{"$f":"IF(ROWS($1:6)<=COUNTA(NomF),HYPERLINK(INDEX(NomF,ROWS($1:6))&\"!A1\",INDEX(MID(NomF,FIND(\"]\",NomF)+1,100),ROWS($1:6))),\"\")","v":"Ogne"}]
[null,null,null,{"$f":"IF(ROWS($1:7)<=COUNTA(NomF),HYPERLINK(INDEX(NomF,ROWS($1:7))&\"!A1\",INDEX(MID(NomF,FIND(\"]\",NomF)+1,100),ROWS($1:7))),\"\")","v":"Hocket"}]
[null,null,null,{"$f":"IF(ROWS($1:8)<=COUNTA(NomF),HYPERLINK(INDEX(NomF,ROWS($1:8))&\"!A1\",INDEX(MID(NomF,FIND(\"]\",NomF)+1,100),ROWS($1:8))),\"\")","v":""},{"$f":"IF(D10<>\"\",INDEX(INDIRECT(\"'\"&D10&\"'!A1:Z50\"),MIN(IF(INDIRECT(\"'\"&D10&\"'!A1:Z50\")=\"Total Qte\",ROW(INDIRECT(\"'\"&D10&\"'!A1:Z50\")))),MIN(IF(INDIRECT(\"'\"&D10&\"'!A1:Z50\")=\"Total Qte\",COLUMN(INDIRECT(\"'\"&D10&\"'!A1:Z50\"))))+1),\"\")","v":""}]
[null,null,null,{"$f":"IF(ROWS($1:9)<=COUNTA(NomF),HYPERLINK(INDEX(NomF,ROWS($1:9))&\"!A1\",INDEX(MID(NomF,FIND(\"]\",NomF)+1,100),ROWS($1:9))),\"\")","v":""},{"$f":"IF(D11<>\"\",INDEX(INDIRECT(\"'\"&D11&\"'!A1:Z50\"),MIN(IF(INDIRECT(\"'\"&D11&\"'!A1:Z50\")=\"Total Qte\",ROW(INDIRECT(\"'\"&D11&\"'!A1:Z50\")))),MIN(IF(INDIRECT(\"'\"&D11&\"'!A1:Z50\")=\"Total Qte\",COLUMN(INDIRECT(\"'\"&D11&\"'!A1:Z50\"))))+1),\"\")","v":""}]
[null,null,null,{"$f":"IF(ROWS($1:10)<=COUNTA(NomF),HYPERLINK(INDEX(NomF,ROWS($1:10))&\"!A1\",INDEX(MID(NomF,FIND(\"]\",NomF)+1,100),ROWS($1:10))),\"\")","v":""},{"$f":"IF(D12<>\"\",INDEX(INDIRECT(\"'\"&D12&\"'!A1:Z50\"),MIN(IF(INDIRECT(\"'\"&D12&\"'!A1:Z50\")=\"Total Qte\",ROW(INDIRECT(\"'\"&D12&\"'!A1:Z50\")))),MIN(IF(INDIRECT(\"'\"&D12&\"'!A1:Z50\")=\"Total Qte\",COLUMN(INDIRECT(\"'\"&D12&\"'!A1:Z50\"))))+1),\"\")","v":""}]
[null,null,null,{"$f":"IF(ROWS($1:11)<=COUNTA(NomF),HYPERLINK(INDEX(NomF,ROWS($1:11))&\"!A1\",INDEX(MID(NomF,FIND(\"]\",NomF)+1,100),ROWS($1:11))),\"\")","v":""},{"$f":"IF(D13<>\"\",INDEX(INDIRECT(\"'\"&D13&\"'!A1:Z50\"),MIN(IF(INDIRECT(\"'\"&D13&\"'!A1:Z50\")=\"Total Qte\",ROW(INDIRECT(\"'\"&D13&\"'!A1:Z50\")))),MIN(IF(INDIRECT(\"'\"&D13&\"'!A1:Z50\")=\"Total Qte\",COLUMN(INDIRECT(\"'\"&D13&\"'!A1:Z50\"))))+1),\"\")","v":""}]

{"sheet":"Audine","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5]]}
[null,"Bonbache.fr","Bonbache.fr/Excel",null,"Bonbache.fr/ExcelVBA",null,"Livres Excel"]
[]
[null,null,"Article","Nb. Ventes"]
[null,null,"Ar001",85]
[null,null,"Ar002",49]
[null,null,"Ar003",65]
[null,null,"Ar004",44]
[null,null,"Ar005",43]
[null,null,"Ar006",47]
[null,null,"Ar007",85]
[null,null,"Ar008",74]
[null,null,"Ar009",77]
[null,null,"Ar010",21]
[]
[null,null,"Total Qte",{"$f":"SUM(D4:D13)","v":590}]

{"sheet":"Galls","index":2,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5]]}
[null,"Bonbache.fr","Bonbache.fr/Excel",null,"Bonbache.fr/ExcelVBA",null,"Livres Excel"]
[]
[null,null,null,null,null,"Article","Nb. Ventes"]
[null,null,null,null,null,"Ar001",45]
[null,null,null,null,null,"Ar002",88]
[null,null,null,null,null,"Ar003",37]
[null,null,null,null,null,"Ar004",20]
[null,null,null,null,null,"Ar008",35]
[null,null,null,null,null,"Ar009",32]
[null,null,null,null,null,"Ar010",67]
[]
[null,null,null,null,null,"Total Qte",{"$f":"SUM(G1:G10)","v":324}]

{"sheet":"Doeuf","index":3,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5]]}
[null,"Bonbache.fr","Bonbache.fr/Excel",null,"Bonbache.fr/ExcelVBA",null,"Livres Excel"]
[]
[]
[]
[]
[null,"Article","Nb. Ventes",null,null," "]
[null,"Ar001",65]
[null,"Ar002",99]
[null,"Ar003",32]
[null,"Ar004",79]
[null,"Ar005",26]
[null,"Ar006",97]
[null,"Ar007",61]
[null,"Ar008",28]
[null,"Ar009",85]
[null,"Ar010",60]
[]
[null,"Total Qte",{"$f":"SUM(C7:C16)","v":632}]

{"sheet":"Braltar","index":4,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5]]}
[null,"Bonbache.fr","Bonbache.fr/Excel",null,"Bonbache.fr/ExcelVBA",null,"Livres Excel"]
[]
[null,null,null,null,"Article","Nb. Ventes"]
[null,null,null,null,"Ar001",24]
[null,null,null,null,"Ar009",92]
[null,null,null,null,"Ar010",91]
[]
[null,null,null,null,"Total Qte",{"$f":"SUM(F4:F6)","v":207}]

{"sheet":"Ogne","index":5,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5]]}
[null,"Bonbache.fr","Bonbache.fr/Excel",null,"Bonbache.fr/ExcelVBA",null,"Livres Excel"]
[]
[null,null,null,null,null,null,null,null,"Article","Nb. Ventes"]
[null,null,null,null,null,null,null,null,"Ar001",40]
[null,null,null,null,null,null,null,null,"Ar002",62]
[null,null,null,null,null,null,null,null,"Ar005",91]
[null,null,null,null,null,null,null,null,"Ar006",18]
[null,null,null,null,null,null,null,null,"Ar007",61]
[null,null,null,null,null,null,null,null,"Ar008",30]
[null,null,null,null,null,null,null,null,"Ar010",99]
[]
[null,null,null,null,null,null,null,null,"Total Qte",{"$f":"SUM(J4:J10)","v":401}]

{"sheet":"Hocket","index":6,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5]]}
[null,"Bonbache.fr","Bonbache.fr/Excel",null,"Bonbache.fr/ExcelVBA",null,"Livres Excel"]
[]
[null,null,"Article","Nb. Ventes"]
[null,null,"Ar001",31]
[null,null,"Ar002",35]
[null,null,"Ar003",86]
[null,null,"Ar004",11]
[null,null,"Ar005",9]
[null,null,"Ar006",12]
[null,null,"Ar007",79]
[null,null,"Ar008",99]
[null,null,"Ar009",54]
[null,null,"Ar010",79]
[]
[null,null,"Total Qte",{"$f":"SUM(D4:D13)","v":495}]