{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Variables","Base"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Variables","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Mois",null,null,"Année"]
[]
["Janvier",1,null,2018]
["Fevrier",2,null,2019]
["Mars",3,null,2020]
["Avril",4,null,2021]
["Mai",5,null,2022]
["Juin",6,null,2023]
["Juillet",7,null,2024]
["Aout",8,null,2025]
["Septembre",9,null,2026]
["Octobre",10,null,2027]
["Novembre",11,null,2028]
["Decembre",12,null,2029]
[null,null,null,2030]
[null,null,null,2031]
[null,null,null,2032]
[null,null,null,2033]
[null,null,null,2034]
[null,null,null,2035]
[null,null,null,2036]
[null,null,null,2037]
[null,null,null,2038]
[null,null,null,2039]
[null,null,null,2040]
[null,null,null,2041]
[null,null,null,2042]
[null,null,null,2043]
[null,null,null,2044]
[null,null,null,2045]

{"sheet":"Base","index":1,"n_rows":117,"n_cols":7,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Compte bilan:","1er champs"]
[null,null,null,"Nom institut:","2eme champs"]
[null,null,null,"Projet:","3eme champs"]
[null,null,null,"Responsable:","4eme champs"]
[null,null,null,"Periode:"]
[]
["N°\njustificatif","Date","Libellé","Nature comptable\n(facultative)","Doit\n(dépenses)","Avoir\n(encaissement)","Solde"]
[]
[null,null,"Solde à nouveau",null,null,null,0]
[1,null,null,null,null,null,{"$f":"+G9-E10+F10","v":0}]
[{"$f":"IF(B11>0,COUNTA(A$10:OFFSET(A11,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,{"$f":"+G10-E11+F11","v":0}]
[{"$f":"IF(B12>0,COUNTA(A$10:OFFSET(A12,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B13>0,COUNTA(A$10:OFFSET(A13,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B14>0,COUNTA(A$10:OFFSET(A14,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B15>0,COUNTA(A$10:OFFSET(A15,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B16>0,COUNTA(A$10:OFFSET(A16,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B17>0,COUNTA(A$10:OFFSET(A17,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B18>0,COUNTA(A$10:OFFSET(A18,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B19>0,COUNTA(A$10:OFFSET(A19,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B20>0,COUNTA(A$10:OFFSET(A20,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B21>0,COUNTA(A$10:OFFSET(A21,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B22>0,COUNTA(A$10:OFFSET(A22,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B23>0,COUNTA(A$10:OFFSET(A23,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B24>0,COUNTA(A$10:OFFSET(A24,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B25>0,COUNTA(A$10:OFFSET(A25,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B26>0,COUNTA(A$10:OFFSET(A26,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B27>0,COUNTA(A$10:OFFSET(A27,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B28>0,COUNTA(A$10:OFFSET(A28,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B29>0,COUNTA(A$10:OFFSET(A29,-1,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[null,null,null,"Totaux",{"$f":"SUM(E10:E29)","v":0},{"$f":"SUM(F10:F29)","v":0}]
[null,null,"Solde vérifé le :"]
[null,null,"Visa du caissier :"]
[null,null,"Visa du responsable :",null,null,{"$f":"IF(G33<0,\"Solde négatif non admis !\",\" \")","v":" "},{"$f":"+G9-E30+F30","v":0}]
[]
["N°\njustificatif","Date","Libellé","Nature comptable\n(facultative)","Débit \n(dépenses)","Crédit\n(encaissement)","Solde"]
[]
[null,null,"Solde reporté",null,null,null,{"$f":"G29","v":0}]
[{"$f":"IF(B38>0,COUNTA(A$10:OFFSET(A38,-9,0))+A$10,\" \")","v":" "},null,null,null,null,null,{"$f":"+G37-E38+F38","v":0}]
[{"$f":"IF(B39>0,COUNTA(A$10:OFFSET(A39,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B40>0,COUNTA(A$10:OFFSET(A40,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B41>0,COUNTA(A$10:OFFSET(A41,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B42>0,COUNTA(A$10:OFFSET(A42,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B43>0,COUNTA(A$10:OFFSET(A43,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B44>0,COUNTA(A$10:OFFSET(A44,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B45>0,COUNTA(A$10:OFFSET(A45,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B46>0,COUNTA(A$10:OFFSET(A46,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B47>0,COUNTA(A$10:OFFSET(A47,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B48>0,COUNTA(A$10:OFFSET(A48,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B49>0,COUNTA(A$10:OFFSET(A49,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B50>0,COUNTA(A$10:OFFSET(A50,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B51>0,COUNTA(A$10:OFFSET(A51,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B52>0,COUNTA(A$10:OFFSET(A52,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B53>0,COUNTA(A$10:OFFSET(A53,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B54>0,COUNTA(A$10:OFFSET(A54,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B55>0,COUNTA(A$10:OFFSET(A55,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B56>0,COUNTA(A$10:OFFSET(A56,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B57>0,COUNTA(A$10:OFFSET(A57,-2,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[null,null,null,"Totaux",{"$f":"SUM(E38:E57)","v":0},{"$f":"SUM(F38:F57)","v":0}]
[null,null,"Solde vérifé le :"]
[null,null,"Visa du caissier :"]
[null,null,"Visa du responsable :",null,null,{"$f":"IF(G61<0,\"Solde négatif non admis !\",\" \")","v":" "},{"$f":"+G37-E58+F58","v":0}]
[]
["N°\njustificatif","Date","Libellé","Nature comptable\n(facultative)","Débit \n(dépenses)","Crédit\n(encaissement)","Solde"]
[]
[null,null,"Solde reporté",null,null,null,{"$f":"G57","v":0}]
[{"$f":"IF(B66>0,COUNTA(A$10:OFFSET(A66,-10,0))+A$10,\" \")","v":" "},null,null,null,null,null,{"$f":"+G65-E66+F66","v":0}]
[{"$f":"IF(B67>0,COUNTA(A$10:OFFSET(A67,-9,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B68>0,COUNTA(A$10:OFFSET(A68,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B69>0,COUNTA(A$10:OFFSET(A69,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B70>0,COUNTA(A$10:OFFSET(A70,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B71>0,COUNTA(A$10:OFFSET(A71,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B72>0,COUNTA(A$10:OFFSET(A72,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B73>0,COUNTA(A$10:OFFSET(A73,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B74>0,COUNTA(A$10:OFFSET(A74,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B75>0,COUNTA(A$10:OFFSET(A75,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B76>0,COUNTA(A$10:OFFSET(A76,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B77>0,COUNTA(A$10:OFFSET(A77,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B78>0,COUNTA(A$10:OFFSET(A78,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B79>0,COUNTA(A$10:OFFSET(A79,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B80>0,COUNTA(A$10:OFFSET(A80,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B81>0,COUNTA(A$10:OFFSET(A81,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B82>0,COUNTA(A$10:OFFSET(A82,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B83>0,COUNTA(A$10:OFFSET(A83,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B84>0,COUNTA(A$10:OFFSET(A84,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B85>0,COUNTA(A$10:OFFSET(A85,-3,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[null,null,null,"Totaux",{"$f":"SUM(E66:E85)","v":0},{"$f":"SUM(F66:F85)","v":0}]
[null,null,"Solde vérifé le :"]
[null,null,"Visa du caissier :"]
[null,null,"Visa du responsable :",null,null,{"$f":"IF(G89<0,\"Solde négatif non admis !\",\" \")","v":" "},{"$f":"+G65-E86+F86","v":0}]
[]
["N°\njustificatif","Date","Libellé","Nature comptable\n(facultative)","Débit \n(dépenses)","Crédit\n(encaissement)","Solde"]
[]
[null,null,"Solde reporté",null,null,null,{"$f":"G85","v":0}]
[{"$f":"IF(B94>0,COUNTA(A$10:OFFSET(A94,-11,0))+A$10,\" \")","v":" "},null,null,null,null,null,{"$f":"+G93-E94+F94","v":0}]
[{"$f":"IF(B95>0,COUNTA(A$10:OFFSET(A95,-11,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B96>0,COUNTA(A$10:OFFSET(A96,-11,0))+A$10,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B97>0,COUNTA(A$10:OFFSET(A97,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B98>0,COUNTA(A$10:OFFSET(A98,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B99>0,COUNTA(A$10:OFFSET(A99,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B100>0,COUNTA(A$10:OFFSET(A100,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B101>0,COUNTA(A$10:OFFSET(A101,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B102>0,COUNTA(A$10:OFFSET(A102,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B103>0,COUNTA(A$10:OFFSET(A103,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B104>0,COUNTA(A$10:OFFSET(A104,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B105>0,COUNTA(A$10:OFFSET(A105,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B106>0,COUNTA(A$10:OFFSET(A106,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B107>0,COUNTA(A$10:OFFSET(A107,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B108>0,COUNTA(A$10:OFFSET(A108,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B109>0,COUNTA(A$10:OFFSET(A109,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B110>0,COUNTA(A$10:OFFSET(A110,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B111>0,COUNTA(A$10:OFFSET(A111,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B112>0,COUNTA(A$10:OFFSET(A112,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[{"$f":"IF(B113>0,COUNTA(A$10:OFFSET(A113,-3,0))+A$9,\" \")","v":" "},null,null,null,null,null,0]
[null,null,null,"Totaux",{"$f":"SUM(E94:E113)","v":0},{"$f":"SUM(F94:F113)","v":0}]
[null,null,"Solde vérifé le :"]
[null,null,"Visa du caissier :"]
[null,null,"Visa du responsable :",null,null,{"$f":"IF(G117<0,\"Solde négatif non admis !\",\" \")","v":" "},{"$f":"+G93-E114+F114","v":0}]