{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Listes","Feuil1","Donnees","Graphique"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":15,"comments":0,"pivot_tables":1},"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":"Listes","index":0,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Pays",null,"Ville",null,null,null,null,null,null,"Gerance"]
["Tous",null,"Toutes",null,null,null,null,null,null,"Toutes","Gerance1","Gerance2","Gerance3"]
["France",null,"Paris",null,"Pays","Tous","France","Espagne",null,"Gerance1","Gerance1 / Magasin1","Gerance2 / Magasin1","Gerance3 / Magasin1"]
["Espagne",null,"Barcelone",null,"Ville","Toutes","Paris","Barcelone",null,"Gerance2","Gerance1 / Magasin2","Gerance2 / Magasin2","Gerance3 / Magasin2"]
[null,null,"Madrid",null,null,null,null,"Madrid",null,"Gerance3","Gerance1 / Magasin3","Gerance2 / Magasin3","Gerance3 / Magasin3"]
[null,null,null,null,null,null,null,null,null,null,"Gerance1 / Magasin4","Gerance2 / Magasin4","Gerance3 / Magasin4"]
[null,null,null,null,null,null,null,null,null,null,"Gerance1 / Magasin5","Gerance2 / Magasin5","Gerance3 / Magasin5"]
[null,null,null,null,null,null,null,null,null,null,"Gerance1 / Magasin6","Gerance2 / Magasin6","Gerance3 / Magasin6"]
[null,null,null,null,null,null,null,null,null,null,"Gerance1 / Magasin7",null,"Gerance3 / Magasin7"]
[null,null,null,null,null,null,null,null,null,null,"Gerance1 / Magasin8",null,"Gerance3 / Magasin8"]
[null,null,null,null,null,null,null,null,null,null,"Gerance1 / Magasin9",null,"Gerance3 / Magasin9"]
[null,null,null,null,null,null,null,null,null,null,"Gerance1 / Magasin10",null,"Gerance3 / Magasin10"]
[null,null,null,null,null,null,null,null,null,null,"Gerance1 / Magasin11",null,"Gerance3 / Magasin11"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gerance3 / Magasin12"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gerance3 / Magasin13"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gerance3 / Magasin14"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gerance3 / Magasin15"]

{"sheet":"Feuil1","index":1,"n_rows":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Étiquettes de lignes","Somme de Ventes","Somme de Achats"]
["Espagne",4203.9347319999988,2414.3152680000012]
["Barcelone",766.65895399999988,228.84104600000012]
["Gerance1",233,90]
["Gerance1 / Magasin1",90,-90]
["Gerance1 / Magasin10",143,180]
["Gerance2",2,6.3333333333333339]
["Gerance2 / Magasin1",1,7.3333333333333339]
["Gerance2 / Magasin5",1,-1]
["Gerance3",531.65895399999988,132.50771266666678]
["Gerance3 / Magasin1",0,0]
["Gerance3 / Magasin13",13.404429999999998,-1.73776333333333]
["Gerance3 / Magasin14",109.89957,33.850430000000003]
["Gerance3 / Magasin15",407.65495399999986,91.928379333333453]
["Gerance3 / Magasin5",0.7,8.4666666666666668]
["Madrid",3437.2757779999988,2185.4742220000012]
["Gerance1",505,1379]
["Gerance1 / Magasin11",500,1292]
["Gerance1 / Magasin2",5,87]
["Gerance2",1101.4263959999996,416.49027066666713]
["Gerance2 / Magasin2",601.42639599999961,25.240270666667016]
["Gerance2 / Magasin5",500,391.25000000000011]
["Gerance3",1830.8493819999992,389.98395133333406]
["Gerance3 / Magasin12",1583.8493819999992,314.48395133333406]
["Gerance3 / Magasin2",247,75.5]
["France",3512.8662929999991,5323.9949328253979]
["Paris",3512.8662929999991,5323.9949328253979]
["Gerance1",1615.4150099999999,4147.2795491587303]
["Gerance1 / Magasin3",5.1200100000000006,86.879989999999992]
["Gerance1 / Magasin4",600,1189.9999999999998]
["Gerance1 / Magasin5",800,2070.9999999999995]
["Gerance1 / Magasin6",3,-3]
["Gerance1 / Magasin7",205,748.69455915873073]
["Gerance1 / Magasin8",0.1,55.9]
["Gerance1 / Magasin9",2.1949999999999998,-2.1949999999999998]
["Gerance2",1234,244.75000000000037]
["Gerance2 / Magasin3",1100,249.58333333333371]
["Gerance2 / Magasin4",132,-2.8333333333333428]
["Gerance2 / Magasin6",2,-2]
["Gerance3",663.45128299999988,931.96538366666664]
["Gerance3 / Magasin10",446.82377299999979,246.09289366666673]
["Gerance3 / Magasin11",74.896079999999984,11.770586666666688]
["Gerance3 / Magasin3",0,0]
["Gerance3 / Magasin4",46,572.74999999999989]
["Gerance3 / Magasin5",15,182.08333333333331]
["Gerance3 / Magasin6",0.73142999999999991,-0.73142999999999991]
["Gerance3 / Magasin7",26,-26]
["Gerance3 / Magasin8",14,-14]
["Gerance3 / Magasin9",40,-40]
["Vide"]
["(vide)"]
["(vide)"]
["(vide)"]
["(vide)"]
["(vide)"]
["(vide)"]
["(vide)"]
["Total général",7716.8010249999988,7738.3102008253982]

{"sheet":"Donnees","index":2,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Pays","Ville","Gerance","Magasin","Ventes","Achats","Total"]
["Espagne","Barcelone","Gerance1","Gerance1 / Magasin1",90,-90,{"$f":"SUBTOTAL(9,E2:E9999)","v":7716.8010249999979},{"$f":"SUBTOTAL(9,F2:F9999)","v":7738.3102008253982}]
["Espagne","Madrid","Gerance1","Gerance1 / Magasin2",5,87]
["France","Paris","Gerance1","Gerance1 / Magasin3",5.1200100000000006,86.879989999999992]
["France","Paris","Gerance1","Gerance1 / Magasin4",600,1189.9999999999998]
["France","Paris","Gerance1","Gerance1 / Magasin5",800,2070.9999999999995]
["France","Paris","Gerance1","Gerance1 / Magasin6",3,-3]
["France","Paris","Gerance1","Gerance1 / Magasin7",205,748.69455915873073]
["France","Paris","Gerance1","Gerance1 / Magasin8",0.1,55.9]
["France","Paris","Gerance1","Gerance1 / Magasin9",2.1949999999999998,-2.1949999999999998]
["Espagne","Barcelone","Gerance1","Gerance1 / Magasin10",143,180]
["Espagne","Madrid","Gerance1","Gerance1 / Magasin11",500,1292]
["Espagne","Barcelone","Gerance2","Gerance2 / Magasin1",1,7.3333333333333339]
["Espagne","Madrid","Gerance2","Gerance2 / Magasin2",601.42639599999961,25.240270666667016]
["France","Paris","Gerance2","Gerance2 / Magasin3",1100,249.58333333333371]
["France","Paris","Gerance2","Gerance2 / Magasin4",132,-2.8333333333333428]
["Espagne","Madrid","Gerance2","Gerance2 / Magasin5",500,391.25000000000011]
["Espagne","Barcelone","Gerance2","Gerance2 / Magasin5",1,-1]
["France","Paris","Gerance2","Gerance2 / Magasin6",2,-2]
["Espagne","Barcelone","Gerance3","Gerance3 / Magasin1",0,0]
["Espagne","Madrid","Gerance3","Gerance3 / Magasin2",247,75.5]
["France","Paris","Gerance3","Gerance3 / Magasin3",0,0]
["France","Paris","Gerance3","Gerance3 / Magasin4",46,572.74999999999989]
["France","Paris","Gerance3","Gerance3 / Magasin5",15,182.08333333333331]
["France","Paris","Gerance3","Gerance3 / Magasin6",0.73142999999999991,-0.73142999999999991]
["France","Paris","Gerance3","Gerance3 / Magasin7",26,-26]
["France","Paris","Gerance3","Gerance3 / Magasin8",14,-14]
["France","Paris","Gerance3","Gerance3 / Magasin9",40,-40]
["France","Paris","Gerance3","Gerance3 / Magasin10",446.82377299999979,246.09289366666673]
["France","Paris","Gerance3","Gerance3 / Magasin11",74.896079999999984,11.770586666666688]
["Espagne","Madrid","Gerance3","Gerance3 / Magasin12",1583.8493819999992,314.48395133333406]
["Espagne","Barcelone","Gerance3","Gerance3 / Magasin13",13.404429999999998,-1.73776333333333]
["Espagne","Barcelone","Gerance3","Gerance3 / Magasin5",0.7,8.4666666666666668]
["Espagne","Barcelone","Gerance3","Gerance3 / Magasin14",109.89957,33.850430000000003]
["Espagne","Barcelone","Gerance3","Gerance3 / Magasin15",407.65495399999986,91.928379333333453]
["Vide"]

{"sheet":"Graphique","index":3,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,5,2,6],[2,8,2,10]]}
[null,1,1,null,null,0,null,null,0]
[]
["Pays","Tous","   Ville","Paris","Gerance","Gerance1",null,"Magasin"]