{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"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":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Le 01/01/2022",null,null,null,null,"Le 31/02/2022"]
[null,"N client ","client","Montant ",null,null,"N client ","client","Montant "]
[null,234567,"MED",277476,null,null,932505,"THOMAS ",58702]
[null,876543,"SARA",4668,null,null,234567,"MED",126486]
[null,987654,"LUCIE",864,null,null,876543,"SARA",6435]
[null,65587,"JEAN",7576,null,null,987654,"LUCIE",764]
[null,5678790,"CARLIN",7659,null,null,65587,"JEAN",3576]
[null,786979,"MARIE",65988,null,null,76998,"CARLA",1256876]
[null,76998,"CARLA",4656876,null,null,5678790,"CARLIN",9532]
[null,685879,"JEAN",76587,null,null,786979,"MARIE",65988]
[null,5476890,"HENRI",68587,null,null,432656,"ROBERT",52466]
[null,6759879,"Maurice",765987,null,null,532982,"LAMIA",45373]
[null,76978,"KATRINE",8079,null,null,685879,"JEAN",36587]
[null,532982,"LAMIA",457,null,null,5476890,"HENRI",84535]
[null,null,null,null,null,null,6759879,"Maurice",765987]
[null,null,null,null,null,null,76978,"KATRINE",2574]

{"sheet":"Feuil2","index":1,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,11,18,11],[19,11,20,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cette macro ne vas pas fonctionner coectement si je demande à Excel d'ajouer 2 colonnes et les nommées selon le mois d'Avril ou Mai…."]
[null,"Tableau des Ecarts Mensuels"]
[]
[null,"N client ","Montant Janvier","Variation1","Montant Fevrier","Variation 2","Montant Mars","Variation3","Total des Montants"]
[null,234567,277476,{"$f":"C7","v":277476},null,null,null,null,{"$f":"SUM(C7,E7)","v":277476}]
[null,876543,4668,{"$f":"C8","v":4668},null,null,null,null,{"$f":"SUM(C8,E8)","v":4668}]
[null,987654,864,864,null,null,null,null,864]
[null,65587,7576,7576,null,null,null,null,7576,null,null,"***Doublons: les anciens comptes dans Janvier sont aussi dans le tableau de janvier , "]
[null,5678790,7659,7659,null,null,null,null,7659,null,null,"il faut alors mettre dans la même ligne du compte le montant de janvier dans sa cellule, et le montant de Fevrier dans sa cellue."]
[null,786979,65988,65988,null,null,null,null,65988]
[null,76998,4656876,4656876,null,null,null,null,4656876]
[null,685879,76587,76587,null,null,null,null,76587]
[null,5476890,68587,68587,null,null,null,null,68587,null,null,null,"N client ","Montant Janvier","Variation1","Montant Fevrier","Variation 2","Total des Montants"]
[null,6759879,765987,765987,null,null,null,null,765987,null,null,"Anciens Comptes dans janvier et fevrier",234567,277476,{"$f":"N16","v":277476},126486,{"$f":"P16-N16","v":-150990},{"$f":"SUM(N16,P16)","v":403962}]
[null,76978,8079,8079,null,null,null,null,8079,null,null,null,876543,4668,{"$f":"N17","v":4668},6435,{"$f":"P17-N17","v":1767},{"$f":"SUM(N17,P17)","v":11103}]
[null,532982,457,457,null,null,null,null,457,null,null,null,987654,864,864,764,-100,1628]
["Données Fevrier",932505,null,0,58702,null,null,null,58702,null,null,null,65587,7576,7576,3576,-4000,11152]
[null,234567,null,0,126486,null,null,null,126486,null,null,"Nouveau Comptes apparus dans Fevrier",932505,null,0,58702,58702,58702]
[null,876543,null,0,6435,null,null,null,6435,null,null,null,432656,null,0,52466,52466,52466]
[null,987654,null,0,764,null,null,null,764]
[null,65587,null,0,3576,null,null,null,3576]
[null,76998,null,0,1256876,null,null,null,1256876]
[null,5678790,null,0,9532,null,null,null,9532]
[null,786979,null,0,65988,null,null,null,65988]
[null,432656,null,0,52466,null,null,null,52466]
[null,532982,null,0,45373,null,null,null,45373]
[null,685879,null,0,36587,null,null,null,36587]
[null,5476890,null,0,84535,null,null,null,84535]
[null,6759879,null,0,765987,null,null,null,765987]
[null,76978,null,0,2574,null,null,null,2574]