{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Bienvenue","RecapAnnuel","Septembre","Octobre","Novembre","Decembre","Janvier","Fevrier","Mars","Avril","Mai","Juin","Juillet","Aout","Treizieme","Codage"],"not_rendered":{"charts":0,"images":4,"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":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,1,5,3]]}
[null,"tata"]
[null,"Récapitulatif des comptes de l'année",null,null,null,null,null,"2020/2021"]
[]
[null,"tata",null,null,null,"ESPECES","BANQUE"]
[null,"Report de l'exercice précédent                    ",null,null,null,300,300]
[null,"Soit un total de",null,null,null,{"$f":"F5+G5","v":600}]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]
[null,"tata"]

{"sheet":"RecapAnnuel","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,5,1,7],[2,3,2,4]]}
[]
[null,null,"Récapitulatif de l'année",null,{"$f":"OFFSET(Bienvenue!H2,,)","v":"2020/2021"}]
[null,null,null,"SOLDES"]
[null,null,"MOIS","ESPECES","BANQUE"]
[null,null,"Colonne1","Colonne2","Colonne3","500,00 €"]
[null,null,"Septembre",{"$f":"OFFSET(Octobre!F5,,)","v":310},{"$f":"OFFSET(Octobre!I5,,)","v":300}]
[null,null,"Octobre",{"$f":"OFFSET(Novembre!F5,,)","v":310},{"$f":"OFFSET(Novembre!I5,,)","v":300}]
[null,null,"Novembre",{"$f":"OFFSET(Decembre!F5,,)","v":310},{"$f":"OFFSET(Decembre!I5,,)","v":300}]
[null,null,"Décembre",{"$f":"OFFSET(Janvier!F5,,)","v":310},{"$f":"OFFSET(Janvier!I5,,)","v":300}]
[null,null,"Janvier",{"$f":"OFFSET(Fevrier!F5,,)","v":310},{"$f":"OFFSET(Fevrier!I5,,)","v":300}]
[null,null,"Février",{"$f":"OFFSET(Mars!F5,,)","v":310},{"$f":"OFFSET(Mars!I5,,)","v":300}]
[null,null,"Mars",{"$f":"OFFSET(Avril!F5,,)","v":310},{"$f":"OFFSET(Avril!I5,,)","v":300}]
[null,null,"Avril",{"$f":"OFFSET(Mai!F5,,)","v":310},{"$f":"OFFSET(Mai!I5,,)","v":300}]
[null,null,"Mai",{"$f":"OFFSET(Juin!F5,,)","v":310},{"$f":"OFFSET(Juin!I5,,)","v":300}]
[null,null,"Juin",{"$f":"OFFSET(Juillet!F5,,)","v":310},{"$f":"OFFSET(Juillet!I5,,)","v":300}]
[null,null,"Juillet",{"$f":"OFFSET(Aout!F5,,)","v":310},{"$f":"OFFSET(Aout!I5,,)","v":300}]
[null,null,"Août",{"$f":"OFFSET(Treizieme!F5,,)","v":0},{"$f":"OFFSET(Treizieme!I5,,)","v":0}]

{"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]]}
[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 année prédédente",null,300,250,null,300,{"$f":"SUM(Tableau132[[#This Row],[Colonne5]]+Tableau132[[#This Row],[Colonne8]])","v":600}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":300},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau132[[#This Row],[Colonne5]]+Tableau132[[#This Row],[Colonne8]])","v":600}]
[null,"2021-10-29",null,10,null,{"$f":"IF($B7<>\"\",F6+D7-E7,0)","v":310},null,null,{"$f":"IF($B7<>\"\",I6+G7-H7,0)","v":300},{"$f":"SUM(Tableau132[[#This Row],[Colonne5]]+Tableau132[[#This Row],[Colonne8]])","v":610}]

{"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]]}
[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 mois Septembre",null,310,"         Solde mois Septembre",null,300,{"$f":"SUM(Tableau13[[#This Row],[Colonne5]]+Tableau13[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau13[[#This Row],[Colonne5]]+Tableau13[[#This Row],[Colonne8]])","v":610}]

{"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]]}
[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 mois Octobre",null,310,"         Solde mois Octobre",null,300,{"$f":"SUM(Tableau134[[#This Row],[Colonne5]]+Tableau134[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau134[[#This Row],[Colonne5]]+Tableau134[[#This Row],[Colonne8]])","v":610}]

{"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]]}
[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 mois Novembre",null,310,"         Solde mois Novembre",null,300,{"$f":"SUM(Tableau135[[#This Row],[Colonne5]]+Tableau135[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau135[[#This Row],[Colonne5]]+Tableau135[[#This Row],[Colonne8]])","v":610}]

{"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]]}
[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 mois Décembre",null,310,"         Solde mois Décembre",null,300,{"$f":"SUM(Tableau136[[#This Row],[Colonne5]]+Tableau136[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau136[[#This Row],[Colonne5]]+Tableau136[[#This Row],[Colonne8]])","v":610}]

{"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]]}
[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 mois Janvier",null,310,"         Solde mois Janvier",null,300,{"$f":"SUM(Tableau137[[#This Row],[Colonne5]]+Tableau137[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau137[[#This Row],[Colonne5]]+Tableau137[[#This Row],[Colonne8]])","v":610}]

{"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]]}
[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 mois Février",null,310,"         Solde mois Février",null,300,{"$f":"SUM(Tableau138[[#This Row],[Colonne5]]+Tableau138[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau138[[#This Row],[Colonne5]]+Tableau138[[#This Row],[Colonne8]])","v":610}]

{"sheet":"Avril","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]]}
[null,"    COMPTES   \"Avril\""]
[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 mois Mars",null,310,"         Solde mois Mars",null,300,{"$f":"SUM(Tableau1313[[#This Row],[Colonne5]]+Tableau1313[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau1313[[#This Row],[Colonne5]]+Tableau1313[[#This Row],[Colonne8]])","v":610}]

{"sheet":"Mai","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]]}
[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 mois Mars",null,310,"         Solde mois Mars",null,300,{"$f":"SUM(Tableau1315[[#This Row],[Colonne5]]+Tableau1315[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau1315[[#This Row],[Colonne5]]+Tableau1315[[#This Row],[Colonne8]])","v":610}]

{"sheet":"Juin","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]]}
[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 mois Mai",null,310,"         Solde mois Mai",null,300,{"$f":"SUM(Tableau1317[[#This Row],[Colonne5]]+Tableau1317[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau1317[[#This Row],[Colonne5]]+Tableau1317[[#This Row],[Colonne8]])","v":610}]

{"sheet":"Juillet","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]]}
[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 mois Juin",null,310,"         Solde mois Juin",null,300,{"$f":"SUM(Tableau1318[[#This Row],[Colonne5]]+Tableau1318[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau1318[[#This Row],[Colonne5]]+Tableau1318[[#This Row],[Colonne8]])","v":610}]

{"sheet":"Aout","index":13,"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]]}
[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 mois Juillet",null,310,"         Solde mois Juillet",null,300,{"$f":"SUM(Tableau1319[[#This Row],[Colonne5]]+Tableau1319[[#This Row],[Colonne8]])","v":610}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":310},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":300},{"$f":"SUM(Tableau1319[[#This Row],[Colonne5]]+Tableau1319[[#This Row],[Colonne8]])","v":610}]

{"sheet":"Treizieme","index":14,"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]]}
[null,"    COMPTES   \"Treizième\""]
[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 mois Août",null,0,"         Solde mois Août",null,0,{"$f":"SUM(Tableau1320[[#This Row],[Colonne5]]+Tableau1320[[#This Row],[Colonne8]])","v":0}]
[null,"2021-10-29",null,null,null,{"$f":"IF($B6<>\"\",F5+D6-E6,0)","v":0},null,null,{"$f":"IF($B6<>\"\",I5+G6-H6,0)","v":0},{"$f":"SUM(Tableau1320[[#This Row],[Colonne5]]+Tableau1320[[#This Row],[Colonne8]])","v":0}]

{"sheet":"Codage","index":15,"n_rows":17,"n_cols":13,"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,-3,null,-1,"Clic",null,3,4,null,null,null,null,"Somme"]
[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]