{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Récapitulatif","Bordereau","Banque","Caisse","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":3,"n_cols":55,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,45,0,46],[0,47,0,48],[0,49,0,50],[0,51,0,52],[0,53,0,54],[0,35,0,36],[0,37,0,38],[0,39,0,40],[0,41,0,42],[0,43,0,44],[0,25,0,26],[0,27,0,28],[0,29,0,30],[0,31,0,32],[0,33,0,34],[0,15,0,16],[0,17,0,18],[0,19,0,20],[0,21,0,22],[0,23,0,24],[0,13,0,14],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[0,11,0,12]]}
[null,null,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"]
[null,null,"Totaux  =>",{"$f":"SUM(D$4:D$9964)","v":0},{"$f":"SUM(E$4:E$9964)","v":0},{"$f":"SUM(F$4:F$9964)","v":0},{"$f":"SUM(G$4:G$9964)","v":0},{"$f":"SUM(H$4:H$9964)","v":0},{"$f":"SUM(I$4:I$9964)","v":0},{"$f":"SUM(J$4:J$9964)","v":0},{"$f":"SUM(K$4:K$9964)","v":0},{"$f":"SUM(L$4:L$9964)","v":0},{"$f":"SUM(M$4:M$9964)","v":0},{"$f":"SUM(N$4:N$9964)","v":0},{"$f":"SUM(O$4:O$9964)","v":0},{"$f":"SUM(P$4:P$9964)","v":0},{"$f":"SUM(Q$4:Q$9964)","v":0},{"$f":"SUM(R$4:R$9964)","v":0},{"$f":"SUM(S$4:S$9964)","v":0},{"$f":"SUM(T$4:T$9964)","v":0},{"$f":"SUM(U$4:U$9964)","v":0},{"$f":"SUM(V$4:V$9964)","v":0},{"$f":"SUM(W$4:W$9964)","v":0},{"$f":"SUM(X$4:X$9964)","v":0},{"$f":"SUM(Y$4:Y$9964)","v":0},{"$f":"SUM(Z$4:Z$9964)","v":0},{"$f":"SUM(AA$4:AA$9964)","v":0},{"$f":"SUM(AB$4:AB$9964)","v":0},{"$f":"SUM(AC$4:AC$9964)","v":0},{"$f":"SUM(AD$4:AD$9964)","v":0},{"$f":"SUM(AE$4:AE$9964)","v":0},{"$f":"SUM(AF$4:AF$9964)","v":0},{"$f":"SUM(AG$4:AG$9964)","v":0},{"$f":"SUM(AH$4:AH$9964)","v":0},{"$f":"SUM(AI$4:AI$9964)","v":0},{"$f":"SUM(AJ$4:AJ$9964)","v":0},{"$f":"SUM(AK$4:AK$9964)","v":0},{"$f":"SUM(AL$4:AL$9964)","v":0},{"$f":"SUM(AM$4:AM$9964)","v":0},{"$f":"SUM(AN$4:AN$9964)","v":0},{"$f":"SUM(AO$4:AO$9964)","v":0},{"$f":"SUM(AP$4:AP$9964)","v":0},{"$f":"SUM(AQ$4:AQ$9964)","v":0},{"$f":"SUM(AR$4:AR$9964)","v":0},{"$f":"SUM(AS$4:AS$9964)","v":0},{"$f":"SUM(AT$4:AT$9964)","v":0},{"$f":"SUM(AU$4:AU$9964)","v":0},{"$f":"SUM(AV$4:AV$9964)","v":0},{"$f":"SUM(AW$4:AW$9964)","v":0},{"$f":"SUM(AX$4:AX$9964)","v":0},{"$f":"SUM(AY$4:AY$9964)","v":0},{"$f":"SUM(AZ$4:AZ$9964)","v":0},{"$f":"SUM(BA$4:BA$9964)","v":0},{"$f":"SUM(BB$4:BB$9964)","v":0},{"$f":"SUM(BC$4:BC$9964)","v":0}]
["N° ORDRE","Raison","Nom","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"]

{"sheet":"Bordereau","index":1,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[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],[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]]}
["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":[]}
[null,null,"BANQUE"]
["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":"Caisse","index":3,"n_rows":134,"n_cols":6,"rows_kept":134,"cut":false,"hidden":false,"merged":[]}
[null,null,"CAISSE"]
["Date","Extrait n°","Dénomination","Débit(-)","Crédit(+)","Solde"]
["2022-11-30",0,"report 2022",null,null,245]
["2022-11-30",1,"Cotisation René",null,15,{"$f":"IF(AND(D4=\"\",E4=\"\"),\"\",F3+E4-D4)","v":260}]
[null,2,"Boucherie Evrard ( Souper 11/11)",198,null,{"$f":"IF(AND(D5=\"\",E5=\"\"),\"\",F4+E5-D5)","v":62}]
[null,null,null,null,null,""]
["2022-12-01",null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,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":4,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Total des recettes : ",null,{"$f":"SUM(Récapitulatif!D2,Récapitulatif!F2,Récapitulatif!H2,Récapitulatif!J2,Récapitulatif!L2,Récapitulatif!N2)","v":0}]
[null,null,"Total des dépenses :",null,{"$f":"SUM(Récapitulatif!E2,Récapitulatif!G2,Récapitulatif!I2,Récapitulatif!K2,Récapitulatif!M2,Récapitulatif!O2)","v":0}]
[]
[null,null,"Solde ",null,{"$f":"E6-E7","v":0}]
[]
[]
[null,null,"Argent en caisse :",null,{"$f":"LOOKUP(9^9,Caisse!F:F)","v":62}]
[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":"ERREUR"}]