{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["AIDE","ECHEANCIER","THERMIDOR","JANVIER","FEVRIER","MARS","AVRIL","MAI","JUIN","JUILLET","AOUT","SEPTEMBRE","OCTOBRE","NOVEMBRE","DECEMBRE"],"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":"AIDE","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["TIERS","CATEGORIE","MONTANT","JOUR"]
[]
["UNEO","MUTUELLE",100,5]
["A.L.M.","EAUX",40,10]
["TRESOR PUBLIC","T.HABITATION",100,15]
["ENGIE","T.FONCIERE",110,15]
["ST CHRISTOPHE","IMP.REVENUS",350,15]
["ENGIE","GAZ-ELECT.",120,20]
["ARCO","RETRAITE",750,1]
["CRAM","RETRAITE",1200,10]
[]
[]
["Mode d'emploi"]
["Tous les mois sont créés. Il n'y a plus qu'à entrer la date en colonne A. Si c'est une iopération programmée, elle devrait s'afficher. Si c'est une dépense (ou entrée), non programmée"]
["  il suffit de remplir les cases concernées et les formules seront annulées dans les cellules concernées."]
["Rappel : ",null,null,null,null,null," "]
["en cas d'insertion de lignes supplémentaires, ne pas oublier de recopier les formules qui se trouvent dans les colonnes O et P"]
["ne jamais effacer les formules quelqu'elles soient."]
["en cas de changement de valeur , voir fléche bleue ci-dessus !!!"]
[]
["Nota :"]
["Je t'ai fait une macro qui ouvre directement ton fichier sur le mois en cours et sur la première ligne vide en colonne A. Si tu n'en veux pas il suffite de la supprimer. Son nom : sub auto_open"]
[]
["Conseil :",null,null," "]
["Garde la feuille \"THERMIDOR\", pour conserver les formules intactes, en cas de mauvaise manip !!!"]

{"sheet":"ECHEANCIER","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,4],[11,0,11,4]]}
["DEPENSES",null,null,null,null,"Nouveau jour"]
["JOUR MENS.","JOUR TRIMEST.","TIERS","CATEGORIE","MONTANT"]
[5,null,"UNEO","MUTUELLE",100,5]
[10,null,"A.L.M.","EAU",40,11]
[15,null,"TRESOR PUBLIC","T. HABITATION",100,14]
[15,null,"TRESOR PUBLIC","T. FONCIERE",110,15]
[15,null,"TRESOR PUBLIC","IMP. REVENUS",350,16]
[20,null,"ENGIE","GAZ-ELECT.",120,20]
[null,10,"ST CHRISTOPHE","ASS. VOITURE",95]
[]
[]
["RECETTES"]
["JOUR MENS.","JOUR TRIMEST.","TIERS","CATEGORIE","MONTANT"]
[1,null,"ARCO","RETRAITE",750,1]
[10,null,"CRAM","RETRAITE",1200,10]
[]
[]
[]
[]
[]
[]
["L'échéance trimestrielle est le 10 du premier mois de chaque trimestre"]

{"sheet":"THERMIDOR","index":2,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[1,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":"C"},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":"ARCO"},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":"RETRAITE"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":750},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":750},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[5,{"$f":"IF(A6=\"\",\"\",IF($A6=1,\"C\",IF($A6=10,\"C\",\"D\")))","v":"D"},null,"UNEO",{"$f":"IF(A6=\"\",\"\",IF($A6=1,\"RETRAITE\",IF($A6=5,\"MUTUELLE\",IF($A6=10,\"RETRAITE\",IF($A6=11,\"EAUX\",IF($A6=14,\"T.HABITATION\",IF($A6=15,\"T. FONCIERE\",IF($A6=16,\"IMP. REVENUS\",IF($A6=20,\"GAZ-ELECT.\")))))))))","v":"MUTUELLE"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":100},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":100}]
[10,"C",null,"CRAM","RETRAITE",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":1200},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,1200,""]
[14,{"$f":"IF(A8=\"\",\"\",IF($A8=1,\"C\",IF($A8=10,\"C\",\"D\")))","v":"D"},null,"TRESOR PUBLIC",{"$f":"IF(A8=\"\",\"\",IF($A8=1,\"RETRAITE\",IF($A8=5,\"MUTUELLE\",IF($A8=10,\"RETRAITE\",IF($A8=11,\"EAUX\",IF($A8=14,\"T.HABITATION\",IF($A8=15,\"T. FONCIERE\",IF($A8=16,\"IMP. REVENUS\",IF($A8=20,\"GAZ-ELECT.\")))))))))","v":"T.HABITATION"},{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":100},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",100]
[15,"D",null,"TRESOR PUBLIC","T. FONCIERE",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":110},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",110]
[16,"D",null,"TRESOR PUBLIC","IMP. REVENUS",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":350},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",350]
[20,"D",null,"ENGIE","GAZ-ELECT.",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":120},null,"",120]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":9450},{"$f":"SUM(P4:P12)","v":780}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":8670},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"JANVIER","index":3,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"FEVRIER","index":4,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"MARS","index":5,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"AVRIL","index":6,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"MAI","index":7,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"JUIN","index":8,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"JUILLET","index":9,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"AOUT","index":10,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"SEPTEMBRE","index":11,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"OCTOBRE","index":12,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"NOVEMBRE","index":13,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]

{"sheet":"DECEMBRE","index":14,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,0,13],[1,8,1,10],[1,14,1,15]]}
[null,null,null,null,null,"CATEGORIE"]
["JOURS","CREDIT/","MODE","TIERS","CATEGORIE",null,null,null,"TRESOR PUBLIC",null,null,null,null,null,"SOLDE"]
[null,"DEBIT","PAIEMENT",null,null,"RETRAITE","DIVERS","MUTUELLE","T.HABITATION","T.FONCIERE","IMP.REVENUS","EAUX","GAZ-ELECT.","VOITURE ","CREDIT","DEBIT"]
["REPORT",null,null," ",null," ",null,null,null,null,null,null,null,null,7500]
[null,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"C\",IF($A5=10,\"C\",\"D\")))","v":""},null,{"$f":"IF($A5=\"\",\"\",IF($A5=1,\"ARCO\",IF($A5=5,\"UNEO\",IF($A5=10,\"CRAM\",IF($A5=11,\"ALM\",IF($A5=14,\"TRESOR PUBLIC\",IF($A5=15,\"TRESOR PUBLIC\",IF($A5=16,\"TRESOR PUBLIC\",IF($A5=20,\"ENGIE\")))))))))","v":""},{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"RETRAITE\",IF($A5=5,\"MUTUELLE\",IF($A5=10,\"RETRAITE\",IF($A5=11,\"EAUX\",IF($A5=14,\"T.HABITATION\",IF($A5=15,\"T. FONCIERE\",IF($A5=16,\"IMP. REVENUS\",IF($A5=20,\"GAZ-ELECT.\")))))))))","v":""},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$14,IF($A5=10,ECHEANCIER!$E$15,IF($E5<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A5=5,$E5=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A5=14,$E5=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A5=15,$E5=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A5=16,$E5=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A5=11,$E5=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A5=20,$D5=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,{"$f":"IF($B5=\"C\",SUM($F5:$N5),\"\")","v":""},{"$f":"IF($B5=\"d\",SUM($F5:$N5),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$14,IF($A6=10,ECHEANCIER!$E$15,IF($E6<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A6=5,$E6=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A6=14,$E6=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A6=15,$E6=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A6=16,$E6=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A6=11,$E6=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A6=20,$D6=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",{"$f":"IF($B6=\"d\",SUM($F6:$N6),\"\")","v":""}]
[null,"",null,"","",{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$14,IF($A7=10,ECHEANCIER!$E$15,IF($E7<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A7=5,$E7=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A7=14,$E7=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A7=15,$E7=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A7=16,$E7=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A7=11,$E7=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A7=20,$D7=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$14,IF($A8=10,ECHEANCIER!$E$15,IF($E8<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A8=5,$E8=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A8=14,$E8=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A8=15,$E8=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A8=16,$E8=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A8=11,$E8=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A8=20,$D8=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$14,IF($A9=10,ECHEANCIER!$E$15,IF($E9<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A9=5,$E9=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A9=14,$E9=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A9=15,$E9=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A9=16,$E9=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A9=11,$E9=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A9=20,$D9=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$14,IF($A10=10,ECHEANCIER!$E$15,IF($E10<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A10=5,$E10=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A10=14,$E10=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A10=15,$E10=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A10=16,$E10=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A10=11,$E10=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A10=20,$D10=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$14,IF($A11=10,ECHEANCIER!$E$15,IF($E11<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A11=5,$E11=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A11=14,$E11=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A11=15,$E11=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A11=16,$E11=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A11=11,$E11=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A11=20,$D11=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
[null,"",null,"","",{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$14,IF($A12=10,ECHEANCIER!$E$15,IF($E12<>\"retraite\",\"\"))))","v":""},null,{"$f":"IF(AND($A12=5,$E12=\"MUTUELLE\"),ECHEANCIER!$E$3,\"\")","v":""},{"$f":"IF(AND($A12=14,$E12=\"T.HABITATION\"),ECHEANCIER!$E$5,\"\")","v":""},{"$f":"IF(AND($A12=15,$E12=\"T. FONCIERE\"),ECHEANCIER!$E$6,\"\")","v":""},{"$f":"IF(AND($A12=16,$E12=\"IMP. REVENUS\"),ECHEANCIER!$E$7,\"\")","v":""},{"$f":"IF(AND($A12=11,$E12=\"EAUX\"),ECHEANCIER!$E$4,\"\")","v":""},{"$f":"IF(AND($A12=20,$D12=\"Engie\"),ECHEANCIER!$E$8,\"\")","v":""},null,"",""]
["S/TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O12)","v":7500},{"$f":"SUM(P4:P12)","v":0}," "]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13>P13,O13-P13,\"\")","v":7500},{"$f":"IF(P13>O13,P13-O13,\"\")","v":""}," "]