{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Bienvenue","Annee","Septembre","Octobre","Novembre","Decembre","Janvier","Fevrier","Mars","Mai","Juin","Juillet","Aout","Codage"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":9,"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":"Bienvenue","index":0,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,13],[3,1,4,13]]}
[]
[null,{"$f":"NOW()","v":"2021-11-02T16:44:02.590"},null,null,null,null,null,null,null,null,{"$f":"NOW()","v":44502.697252199076}]
[]
[null,"Récapitulatif des comptes"]

{"sheet":"Annee","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,8,14,9],[1,3,1,4],[1,5,1,6],[1,2,2,2],[1,8,1,9],[5,8,5,9],[9,8,9,9],[13,8,13,9]]}
[]
[null,null,"MOIS","ESPECES",null,"BANQUE",null,null,"ESPECES"]
[null,null,null,"CREDIT","DEBIT","CREDIT","DEBIT",null,"CREDIT","DEBIT"]
[null,null,"Septembre",{"$f":"OFFSET(Octobre!F5,,)","v":1300},null,null,null,null,{"$f":"SUM(D4:D15)","v":1300},{"$f":"SUM(E4:E15)","v":0}]
[null,null,"Octobre"]
[null,null,"Novembre",null,null,null,null,null,"BANQUE"]
[null,null,"Décembre",null,null,null,null,null,"CREDIT","DEBIT"]
[null,null,"Janvier",null,null,null,null,null,{"$f":"SUM(F4:F15)","v":0},{"$f":"SUM(G4:G15)","v":0}]
[null,null,"Février"]
[null,null,"Mars",null,null,null,null,null,"TOTAL"]
[null,null,"Avril",null,null,null,null,null,"CREDIT","DEBIT"]
[null,null,"Mai",null,null,null,null,null,{"$f":"SUM(I4+I8)","v":1300},{"$f":"SUM(J4+J8)","v":0}]
[null,null,"Juin"]
[null,null,"Juillet",null,null,null,null,null,"DISPONIBLE"]
[null,null,"Août",null,null,null,null,null,{"$f":"I12-J12","v":1300}]

{"sheet":"Septembre","index":2,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,6,1,8],[1,3,1,5],[1,1,2,1],[1,2,2,2],[1,9,2,9]]}
[null,"    COMPTES   \"Septembre\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,1000,"     Solde saison 2019 / 2020",null,1000,{"$f":"IFERROR($F5+$I5,\"\")","v":2000}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":1000},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":1000},{"$f":"IFERROR($F6+$I6,\"\")","v":2000}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B7<>\"\",F6+D7-E7,0)","v":1000},null,null,{"$f":"IF($B7<>\"\",I6+G7-H7,0)","v":1000},{"$f":"IFERROR($F7+$I7,\"\")","v":2000}]

{"sheet":"Octobre","index":3,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,2,9]]}
[null,"    COMPTES   \"Octobre\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,1300,"     Solde saison 2019 / 2020",null,1000,{"$f":"IFERROR($F5+$I5,\"\")","v":2300}]
[null,"2021-10-21",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":1300},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":1000},{"$f":"IFERROR($F6+$I6,\"\")","v":2300}]

{"sheet":"Novembre","index":4,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,2,9]]}
[null,"    COMPTES  \"Novembre\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,0,"     Solde saison 2019 / 2020",null,0,{"$f":"IFERROR($F5+$I5,\"\")","v":0}]
[null,"2021-10-21",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":0},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":0},{"$f":"IFERROR($F6+$I6,\"\")","v":0}]

{"sheet":"Decembre","index":5,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,2,9]]}
[null,"    COMPTES   \"Décembre\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,0,"     Solde saison 2019 / 2020",null,0,{"$f":"IFERROR($F5+$I5,\"\")","v":0}]
[null,"2021-10-21",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":0},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":0},{"$f":"IFERROR($F6+$I6,\"\")","v":0}]

{"sheet":"Janvier","index":6,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,2,9]]}
[null,"    COMPTES   \"Janvier\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,0,"     Solde saison 2019 / 2020",null,0,{"$f":"IFERROR($F5+$I5,\"\")","v":0}]
[null,"2021-10-21",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":0},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":0},{"$f":"IFERROR($F6+$I6,\"\")","v":0}]

{"sheet":"Fevrier","index":7,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,2,9]]}
[null,"    COMPTES   \"Février\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,0,"     Solde saison 2019 / 2020",null,0,{"$f":"IFERROR($F5+$I5,\"\")","v":0}]
[null,"2021-10-21",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":0},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":0},{"$f":"IFERROR($F6+$I6,\"\")","v":0}]

{"sheet":"Mars","index":8,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,2,9]]}
[null,"    COMPTES  \"Mars\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,0,"     Solde saison 2019 / 2020",null,0,{"$f":"IFERROR($F5+$I5,\"\")","v":0}]
[null,"2021-10-21",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":0},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":0},{"$f":"IFERROR($F6+$I6,\"\")","v":0}]

{"sheet":"Mai","index":9,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,2,9]]}
[null,"    COMPTES   \"Mai\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,0,"     Solde saison 2019 / 2020",null,0,{"$f":"IFERROR($F5+$I5,\"\")","v":0}]
[null,"2021-10-21",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":0},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":0},{"$f":"IFERROR($F6+$I6,\"\")","v":0}]

{"sheet":"Juin","index":10,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,2,9]]}
[null,"    COMPTES   \"Juin\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,0,"     Solde saison 2019 / 2020",null,0,{"$f":"IFERROR($F5+$I5,\"\")","v":0}]
[null,"2021-10-21",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":0},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":0},{"$f":"IFERROR($F6+$I6,\"\")","v":0}]

{"sheet":"Juillet","index":11,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,2,9]]}
[null,"    COMPTES   \"Juillet\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,0,"     Solde saison 2019 / 2020",null,0,{"$f":"IFERROR($F5+$I5,\"\")","v":0}]
[null,"2021-10-21",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":0},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":0},{"$f":"IFERROR($F6+$I6,\"\")","v":0}]

{"sheet":"Aout","index":12,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,2,9]]}
[null,"    COMPTES   \"Août\""]
[null,"DATE","LIBELLE","  ESPECES",null,null,"BANQUE",null,null,"TOTAL"]
[null,null,null,"CREDIT","DEBIT","SOLDE","CREDIT","DEBIT","SOLDE"]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9"]
[null,null,null,"    Solde saison 2019 / 2020",null,0,"     Solde saison 2019 / 2020",null,0,{"$f":"IFERROR($F5+$I5,\"\")","v":0}]
[null,"2021-10-21",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":0},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":0},{"$f":"IFERROR($F6+$I6,\"\")","v":0}]

{"sheet":"Codage","index":13,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,1,5,9],[9,1,9,9],[13,1,13,9]]}
[]
[null,"Date","Libellé","Crédit","Débit","Solde","Crédit","Débit","Solde","Total"]
[null,-2,null,-1,"Clic",null,3,4]
[null,-5,null,-3,-2,null,"Clic",1]
[null,-6,null,-4,-3,null,-1,"Clic"]
[]
[null,-2,null,"Clic",1,null,3,4]
[null,-5,null,-3,-2,null,"Clic",1]
[null,-6,null,-4,-3,null,-1,"Clic"]
[]
[null,-2,null,"Clic",1,null,3,4]
[null,-3,null,-1,"Clic",null,2]
[null,-6,null,-4,-3,null,-1,"Clic"]
[]
[null,-2,null,"Clic",1,null,3,4]
[null,-3,null,-1,"Clic",null,2,3]
[null,-5,null,-3,-2,null,"Clic",1]