{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Banque","Achats","Caisse"],"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":"Banque","index":0,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Classeur Banque"]
[]
["N° Extrait Banque","Date","Nature","Destination","Recette +","Dépense -","Solde","colonne à remplir",null,null,null,null,null,null,null,"Destinations"]
[null,null,"report mois précédent",null,9500,null,{"$f":"E4","v":9500},null,null,"L'argent de la Communauté Française arrive sur le compte en banque",null,null,null,null,null,"Achats"]
[1,"2024-09-12","transfert vers carte achats","Achats",null,500,{"$f":"IF(AND(E5=\"\",F5=\"\"),\"\",G4+E5-F5)","v":9000},"X",null,"de là, il est dispatché vers la carte achats, la caisse et les opérations bancaires",null,null,null,null,null,"Caisse"]
[{"$f":"IF(B6=\"\",\"\",A5+1)","v":2},"2024-09-13","transfert vers caisse","Caisse",500,300,{"$f":"IF(AND(E6=\"\",F6=\"\"),\"\",G5+E6-F6)","v":9200},null,null,"habituelles.",null,null,null,null,null,"Banque"]
[{"$f":"IF(B7=\"\",\"\",A6+1)","v":3},"2024-09-14","Electricité","Banque",null,250,8950,null,null,"Donc, ici, chaque montant en banque sera \"justifié\" par une destination"]
[4,"2024-09-15","loyer","Banque",null,1250,7700,null,null,"soit Banque,Caisse ou Achats"]
[5,"2024-09-16","caisse","Caisse",null,300,7400]
[6,"2024-09-16","caisse","Caisse",null,250,7150]
[7,"2024-09-17","Tft carte Achats","Achats",null,375,6775,"X"]
[8,"2024-09-18","Tft carte Achats","Achats",null,400,6375,"X"]
[9,"2024-09-19","Tft carte Achats","Achats",null,100,6275,"X"]
[10,"2024-09-20","Tft carte Achats","Achats",null,200,6075,"X"]
[11,"2024-09-21","Tft carte Achats","Achats",null,300,5775,"X"]
[12,"2024-09-22","Tft carte Achats","Achats",null,400,5375,"X"]
[13,"2024-09-23","Tft carte Achats","Achats",null,120,5255,"X"]
[14,"2024-09-24","Tft carte Achats","Achats",null,140,5115,"X"]
[15,"2024-09-25","Tft carte Achats","Achats",null,160,4955,"X"]
[16,"2024-09-24","Tft carte Achats","Achats",null,180,4775,"X"]
[17,"2024-09-12","Tft carte Achats","Achats",null,125.5,4649.5,"X"]
[18,"2024-08-31","Tft carte Achats","Achats",null,148.75,4500.75,"X"]
[19,"2024-08-19","Tft carte Achats","Achats",null,190.22,4310.53,"X"]
[20,"2024-08-20","Transfert Caisse","Caisse",null,1000,3310.5299999999997]
[21,"2024-08-21","Transfert Caisse","Caisse",null,1210,2100.5299999999997]
[22,"2024-08-22","Transfert Caisse","Caisse",null,1420,680.52999999999975]
[23,"2024-08-23","Transfert Caisse","Caisse",null,630,50.529999999999745]
["",null,null,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(K31=\"\",L31=\"\"),\"\",Caisse!F30+K31-L31)","v":""}]
[null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"IF(AND(K32=\"\",L32=\"\"),\"\",M31+K32-L32)","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,""]

{"sheet":"Achats","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Classeur Carte Achats"]
[]
["N° Extrait Achats","Date","Nature","Recette +","Dépense -","Solde"]
[null,null,"report mois précédent",null,500,514]
[1,"2024-09-12","approv. Carte",500,375,{"$f":"IF(AND(D5=\"\",E5=\"\"),\"\",F4+D5-E5)","v":639}]
[null,null,null,null,400,{"$f":"IF(AND(D6=\"\",E6=\"\"),\"\",F5+D6-E6)","v":239}]
[null,null,null,null,500,{"$f":"IF(AND(D7=\"\",E7=\"\"),\"\",F6+D7-E7)","v":-261}]
[null,null,null,null,375,-636]
[null,null,null,null,400,-1036]
[null,null,null,null,100,-1136]
[null,null,null,null,200,-1336]
[null,null,null,null,300,-1636]
[null,null,null,null,400,-2036]
[null,null,null,null,500,-2536]
[null,null,null,null,375,-2911]
[null,null,null,null,400,-3311]
[null,null,null,null,100,-3411]
[null,null,null,null,200,-3611]
[null,null,null,null,300,-3911]
[null,null,null,null,400,-4311]
[null,null,null,null,120,-4431]
[null,null,null,null,140,-4571]
[null,null,null,null,160,-4731]
[null,null,null,null,180,-4911]
[null,null,null,null,125.5,-5036.5]
[null,null,null,null,148.75,-5185.25]
[null,null,null,null,190.22,-5375.47]
[null,null,null,null,null,""]

{"sheet":"Caisse","index":2,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Compte CAISSE"]
[]
["N° Extrait Caisse","Date","Nature","Recette +","Dépense -","Solde"]
[null,null,"report mois précédent",null,null,216]
[1,"2024-09-13","Approv. Caisse",300,null,{"$f":"IF(AND(D5=\"\",E5=\"\"),\"\",F4+D5-E5)","v":516}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]