{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Accueil","Résultat final - PowerQuery","Résultat final manuel"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":4,"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":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Utilisation de PowerQuery"]

{"sheet":"Résultat final - PowerQuery","index":1,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Produit","Pays","Région","Ville","Année","Mois","CA","Unités vendues"]
["Produit 1","France","Région Sud","Marseille",2017,9,175,150]
["Produit 2","France","Région Sud","Marseille",2017,9,179,128]
["Produit 3","France","Région Sud","Marseille",2017,9,145,193]
["Produit 4","France","Région Sud","Marseille",2017,9,171,108]
["Produit 5","France","Région Sud","Marseille",2017,9,165,165]
["Produit 6","France","Région Sud","Marseille",2017,9,183,180]
["Produit 7","France","Région Sud","Marseille",2017,9,197,128]
["Produit 8","France","Région Sud","Marseille",2017,9,111,104]
["Produit 9","France","Région Sud","Marseille",2017,9,162,175]
["Produit 10","France","Région Sud","Marseille",2017,9,140,113]
["Produit 11","France","Région Sud","Marseille",2017,9,146,133]
["Produit 12","France","Région Sud","Marseille",2017,9,132,130]
["Produit 13","France","Région Sud","Marseille",2017,9,178,139]
["Produit 1","France","Région Sud","Nice",2017,9,157,187]
["Produit 2","France","Région Sud","Nice",2017,9,163,198]
["Produit 3","France","Région Sud","Nice",2017,9,104,147]
["Produit 4","France","Région Sud","Nice",2017,9,133,102]
["Produit 5","France","Région Sud","Nice",2017,9,107,109]
["Produit 6","France","Région Sud","Nice",2017,9,131,184]
["Produit 7","France","Région Sud","Nice",2017,9,151,108]
["Produit 8","France","Région Sud","Nice",2017,9,139,127]
["Produit 9","France","Région Sud","Nice",2017,9,118,164]
["Produit 10","France","Région Sud","Nice",2017,9,170,178]
["Produit 11","France","Région Sud","Nice",2017,9,125,193]
["Produit 12","France","Région Sud","Nice",2017,9,176,169]
["Produit 13","France","Région Sud","Nice",2017,9,176,139]
["Produit 1","France","Région Sud","Toulon",2017,9,170,127]
["Produit 2","France","Région Sud","Toulon",2017,9,182,117]
["Produit 3","France","Région Sud","Toulon",2017,9,116,129]
["Produit 4","France","Région Sud","Toulon",2017,9,106,121]
["Produit 5","France","Région Sud","Toulon",2017,9,156,106]
["Produit 6","France","Région Sud","Toulon",2017,9,122,120]
["Produit 7","France","Région Sud","Toulon",2017,9,194,146]
["Produit 8","France","Région Sud","Toulon",2017,9,101,137]
["Produit 9","France","Région Sud","Toulon",2017,9,189,109]
["Produit 10","France","Région Sud","Toulon",2017,9,120,174]
["Produit 11","France","Région Sud","Toulon",2017,9,182,145]
["Produit 12","France","Région Sud","Toulon",2017,9,100,105]
["Produit 13","France","Région Sud","Toulon",2017,9,166,192]
["Produit 1","France","Région Sud","Toulouse",2017,9,195,199]
["Produit 2","France","Région Sud","Toulouse",2017,9,199,135]
["Produit 3","France","Région Sud","Toulouse",2017,9,178,125]
["Produit 4","France","Région Sud","Toulouse",2017,9,109,186]
["Produit 5","France","Région Sud","Toulouse",2017,9,116,141]
["Produit 6","France","Région Sud","Toulouse",2017,9,177,110]
["Produit 7","France","Région Sud","Toulouse",2017,9,126,174]
["Produit 8","France","Région Sud","Toulouse",2017,9,143,112]
["Produit 9","France","Région Sud","Toulouse",2017,9,104,180]
["Produit 10","France","Région Sud","Toulouse",2017,9,159,180]
["Produit 11","France","Région Sud","Toulouse",2017,9,105,186]
["Produit 12","France","Région Sud","Toulouse",2017,9,171,110]
["Produit 13","France","Région Sud","Toulouse",2017,9,179,119]

{"sheet":"Résultat final manuel","index":2,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Produit","Pays","Région","Ville","Année","Mois","CA","Unités vendues"]
["Produit 1","France","Région Hauts de France","Lille",2016,8,2903,999999999]
["Produit 2","France","Région Hauts de France","Lille",2016,8,3193,2873]
["Produit 3","France","Région Hauts de France","Lille",2016,8,2887,2995]
["Produit 4","France","Région Hauts de France","Lille",2016,8,2936,3451]
["Produit 5","France","Région Hauts de France","Lille",2016,8,3082,2505]
["Produit 6","France","Région Hauts de France","Lille",2016,8,3134,3310]
["Produit 7","France","Région Hauts de France","Lille",2016,8,2588,3445]
["Produit 8","France","Région Hauts de France","Lille",2016,8,3197,3395]
["Produit 9","France","Région Hauts de France","Lille",2016,8,2700,3185]
["Produit 10","France","Région Hauts de France","Lille",2016,8,3485,2725]
["Produit 11","France","Région Hauts de France","Lille",2016,8,3399,3066]
["Produit 12","France","Région Hauts de France","Lille",2016,8,3275,3181]
["Produit 13","France","Région Hauts de France","Lille",2016,8,3150,2868]
["Produit 1","France","Région Hauts de France","Lomme",2016,8,2691,3418]
["Produit 2","France","Région Hauts de France","Lomme",2016,8,3485,3471]
["Produit 3","France","Région Hauts de France","Lomme",2016,8,2906,2736]
["Produit 4","France","Région Hauts de France","Lomme",2016,8,2528,3251]
["Produit 5","France","Région Hauts de France","Lomme",2016,8,2689,3471]
["Produit 6","France","Région Hauts de France","Lomme",2016,8,3184,3169]
["Produit 7","France","Région Hauts de France","Lomme",2016,8,3050,2942]
["Produit 8","France","Région Hauts de France","Lomme",2016,8,2999,3009]
["Produit 9","France","Région Hauts de France","Lomme",2016,8,3282,2529]
["Produit 10","France","Région Hauts de France","Lomme",2016,8,3217,2850]
["Produit 11","France","Région Hauts de France","Lomme",2016,8,3314,3059]
["Produit 12","France","Région Hauts de France","Lomme",2016,8,2825,3494]
["Produit 13","France","Région Hauts de France","Lomme",2016,8,3447,3423]
["Produit 1","France","Région Hauts de France","Tourcoing",2016,8,2732,3462]
["Produit 2","France","Région Hauts de France","Tourcoing",2016,8,3483,2779]
["Produit 3","France","Région Hauts de France","Tourcoing",2016,8,3046,3177]
["Produit 4","France","Région Hauts de France","Tourcoing",2016,8,2712,2949]
["Produit 5","France","Région Hauts de France","Tourcoing",2016,8,3307,3056]
["Produit 6","France","Région Hauts de France","Tourcoing",2016,8,2839,3020]
["Produit 7","France","Région Hauts de France","Tourcoing",2016,8,2588,3399]
["Produit 8","France","Région Hauts de France","Tourcoing",2016,8,3098,2516]
["Produit 9","France","Région Hauts de France","Tourcoing",2016,8,2967,3255]
["Produit 10","France","Région Hauts de France","Tourcoing",2016,8,3436,2740]
["Produit 11","France","Région Hauts de France","Tourcoing",2016,8,2950,3110]
["Produit 12","France","Région Hauts de France","Tourcoing",2016,8,2742,3225]
["Produit 13","France","Région Hauts de France","Tourcoing",2016,8,3362,3398]