{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Récapitulatif","Bordereau","Banque","Contrôle"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Récapitulatif","index":0,"n_rows":33,"n_cols":53,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,11,0,12],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[0,13,0,14],[0,15,0,16],[0,17,0,18],[0,19,0,20],[0,21,0,22],[0,23,0,24],[0,25,0,26],[0,27,0,28],[0,29,0,30],[0,31,0,32],[0,33,0,34],[0,35,0,36],[0,37,0,38],[0,39,0,40],[0,41,0,42],[0,43,0,44],[0,45,0,46],[0,47,0,48],[0,49,0,50],[0,51,0,52]]}
[null,"Art Floral",null,"Goûters",null,"Trianon Opéra",null,"Trianon Wal",null,"Durbuy",null,"Bruxelles",null,"Moselle",null,"Cologne",null,"Cotisations",null,"Repas OCT",null,"Diner Noël",null,"Anniversaires",null,"Journal",null,"Décès",null,"Achat matériel",null,"Frais bancaires",null,"Transfert",null,"Versement Caisse",null,"Subsides",null,"Caisse JML",null,"Divers",null,"Cotisations 2023",null,"Total Extrait",null,"Nouveau Solde Extrait",null,"Caisse JML",null,"Activ.26"]
["Totaux  =>",{"$f":"SUM(Tableau1[])","v":500},{"$f":"SUM(Tableau2[])","v":500},{"$f":"SUM(Tableau3[])","v":605},{"$f":"SUM(Tableau4[])","v":525},{"$f":"SUM(Tableau5[])","v":250},{"$f":"SUM(Tableau6[])","v":250},{"$f":"SUM(Tableau7[])","v":45},{"$f":"SUM(Tableau8[])","v":0},{"$f":"SUM(Tableau710[])","v":0},{"$f":"SUM(Tableau811[])","v":0},{"$f":"SUM(Tableau712[])","v":0},{"$f":"SUM(Tableau813[])","v":0},{"$f":"SUM(Tableau714[])","v":0},{"$f":"SUM(Tableau815[])","v":0},{"$f":"SUM(Tableau716[])","v":0},{"$f":"SUM(Tableau817[])","v":0},{"$f":"SUM(Tableau718[])","v":275},{"$f":"SUM(Tableau819[])","v":0},{"$f":"SUM(Tableau720[])","v":0},{"$f":"SUM(Tableau821[])","v":0},{"$f":"SUM(Tableau722[])","v":0},{"$f":"SUM(Tableau823[])","v":0},{"$f":"SUM(Tableau724[])","v":0},{"$f":"SUM(Tableau825[])","v":0},{"$f":"SUM(Tableau726[])","v":0},{"$f":"SUM(Tableau827[])","v":0},{"$f":"SUM(Tableau728[])","v":0},{"$f":"SUM(Tableau829[])","v":0},{"$f":"SUM(Tableau730[])","v":0},{"$f":"SUM(Tableau831[])","v":0},{"$f":"SUM(Tableau732[])","v":0},{"$f":"SUM(Tableau833[])","v":0},{"$f":"SUM(Tableau73234[])","v":0},{"$f":"SUM(Tableau83335[])","v":0},{"$f":"SUM(Tableau73236[])","v":0},{"$f":"SUM(Tableau83337[])","v":0},{"$f":"SUM(Tableau73238[])","v":0},{"$f":"SUM(Tableau83339[])","v":0},{"$f":"SUM(Tableau73240[])","v":0},{"$f":"SUM(Tableau83341[])","v":0},{"$f":"SUM(Tableau73242[])","v":0},{"$f":"SUM(Tableau83343[])","v":0},{"$f":"SUM(Tableau73244[])","v":0},{"$f":"SUM(Tableau83345[])","v":0},{"$f":"SUM(Tableau73246[])","v":0},{"$f":"SUM(Tableau83347[])","v":0},{"$f":"SUM(Tableau73248[])","v":0},{"$f":"SUM(Tableau83349[])","v":0},{"$f":"SUM(Tableau73250[])","v":0},{"$f":"SUM(Tableau83351[])","v":0},{"$f":"SUM(Tableau73252[])","v":0},{"$f":"SUM(Tableau83353[])","v":0}]
["Dénominations","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses","Recettes","Dépenses"]
[]
["Acompte car voyage",null,500]
["voyage client 1",50]
["voyage client 2",50]
["voyage client 3",50,null,null,null,250]
["voyage client 4",50]
["voyage client 5",50]
["voyage client 6",50]
["voyage client 7",50]
["voyage client 8",50]
["voyage client 9",50]
["voyage client 10",50]
["achat frites Georgette",null,null,null,120]
["achat Mayo Georgette",null,null,null,85]
["achat huiles Georgette",null,null,null,140]
["achat viande Georgette",null,null,null,180]
["Souper client 1",null,null,55,null,null,null,45]
["Souper client 2",null,null,55]
["Souper client 3",null,null,55]
["Souper client 4",null,null,55]
["Souper client 5",null,null,55]
["Souper client 6",null,null,55]
["Souper client 7",null,null,55]
["Souper client 8",null,null,55]
["Souper client 9",null,null,55]
["Souper client 10",null,null,55]
["Souper client 11",null,null,55]
["Eneo Liège",null,null,null,null,null,250]
["Eneo Cotisations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,275]
["versement banque"]

{"sheet":"Bordereau","index":1,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[8,1,8,4],[10,1,10,4],[7,53,7,54],[7,55,7,56],[7,57,7,58],[7,29,7,30],[7,31,7,32],[7,33,7,34],[7,35,7,36],[7,37,7,38],[7,39,7,40],[7,21,7,22],[7,23,7,24],[7,25,7,26],[7,27,7,28],[0,0,0,6],[2,1,2,2],[7,59,7,60],[7,41,7,42],[7,43,7,44],[7,45,7,46],[7,47,7,48],[7,49,7,50],[7,51,7,52]]}
["Bordereau des entrées et sorties"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Liste des activités"]
["Activité :","Art Floral",null,null,"Numéro : ",null,null,null,null,null,null,null,null,"Art Floral"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Goûters"]
["Montant +",120,"en plus",null,null,null,null,null,null,null,null,null,null,"Trianon Opéra"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Trianon Wal"]
["Montant -",null,"en moins",null,null,null,null,null,null,null,null,null,null,"Durbuy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bruxelles"]
["Raison :","frais car",null,null,null,null,null,null,null,null,null,null,null,"Moselle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cologne"]
["Nom :","Transcar ABC",null,null,null,null,null,null,null,null,null,null,null,"Cotisations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Repas OCT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Diner Noël"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Anniversaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Journal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Décès"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Achat matériel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Frais bancaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Transfert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Versement Caisse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subsides"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Caisse JML"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Divers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cotisations 2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Extrait"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nouveau Solde Extrait"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Caisse JML"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Activ.26"]

{"sheet":"Banque","index":2,"n_rows":134,"n_cols":6,"rows_kept":134,"cut":false,"hidden":false,"merged":[]}
[]
["Date","Extrait n°","Dénomination","Débit(-)","Crédit(+)","Solde"]
["2022-11-30",14,"Payement ABC",100,null,{"$f":"E3-D3","v":-100}]
["2022-11-30",15,"Cotisation KOUSEN",null,35,{"$f":"IF(AND(D4=\"\",E4=\"\"),\"\",F3+E4-D4)","v":-65}]
[null,15,"Cotisation Machin",null,35,{"$f":"IF(AND(D5=\"\",E5=\"\"),\"\",F4+E5-D5)","v":-30}]
[null,16,"Cotisation Truc",null,35,5]
["2022-12-01",17,"cotisation Albert",null,35,40]
[null,18,"Trianon Client 5",null,45,85]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(AND(D69=\"\",E69=\"\"),\"\",F68+E69-D69)","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(AND(D133=\"\",E133=\"\"),\"\",F132+E133-D133)","v":""}]
[null,null,null,null,null,""]

{"sheet":"Contrôle","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Total des recettes : ",null,{"$f":"SUM(Récapitulatif!B2,Récapitulatif!D2,Récapitulatif!F2,Récapitulatif!H2,Récapitulatif!J2,Récapitulatif!L2)","v":1400}]
[null,null,"Total des dépenses :",null,{"$f":"SUM(Récapitulatif!C2,Récapitulatif!E2,Récapitulatif!G2,Récapitulatif!I2,Récapitulatif!K2,Récapitulatif!M2)","v":1275}]
[]
[null,null,"Solde ",null,{"$f":"E6-E7","v":125}]
[]
[]
[null,null,"Argent en caisse :",null,40]
[null,null,"Banque :",null,{"$f":"LOOKUP(9^9,Banque!F:F)","v":85}]
[]
[]
[null,null,"Contrôle :",null,{"$f":"IF((E12+E13)=E9,\"OK\",\"ERREUR\")","v":"OK"}]