{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["ECHEANCIER","MODELE","JANVIER","FEVRIER","MARS","AVRIL","MAI","JUIN","JUILLET","AOUT","SEPTEMBRE","OCTOBRE","NOVEMBRE","DECEMBRE","Feuil4"],"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":"ECHEANCIER","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"COMPTABILISATION","MODE PAIEMENT","TIERS"]
["N° SAISIE","JOURS MENS.","JOURS TRIM.","PAIEMENT","TIERS","CATEGORIE","MONTANT"," ","C. PORT D","Carte","Unico"]
[1,1,null,"Vir recu","ARCO","RETRAITE",750,null,"C. PORT C","Cheque","Geant"]
[2,5,null,"Prel","UNEO","MUTUELLE",-100,null,"DEPENSES","Prel","Carrefour"]
[3,10,null,"Vir recu","CRAM","RETRAITE",1200,null,"DIVERS","Vir emis","Marche Fermier"]
[4,10,null,"Prel","A.L.M.","EAUX",-40,null,"REC DIV","Retrait","Bontemps"]
[5,15,null,"Prel","T.P.","T.HABI",-100,null," ","TIP","Lutz"]
[6,15,null,"Prel","T.P.","T.FONC",-110,null,null,"Vers","Amazon"]
[7,15,null,"Prel","T.P.","IMP.REV",-350,null,null,"Depot cheque","Dr Dupont"]
[8,20,null,"Prel","ENGIE","GAZ-ELEC",-120,null,null,"Vir recu","Poste"]
[9," ",27,"Prel","ST CHRIST","ASS.VOIT",-95]
[]
[]
[]
[]
[]
[]
[null,"L'échéance trimsertrielle est le 27 du premier mois de chaque trimestre"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"MODELE","index":1,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,7,1,8]]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"MODELE"}]
["N° SAISIE","JOURS","MODE","TIERS","CATEGORIE","BANQUE POSTALE",null,"RECETTES",null,"DEPENSES","C. PORT"," ","DIVERS"]
[null,null,"PAIEMENT",null,null,"DEBIT/CREDIT","SOLDE","RETRAITE","DIVERSES",null,"LOYER","CHARGES"," "]
["REPORT",null,null,null,null,null,7500]
[1,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"1\",IF($A5=2,\"5\",IF($A5=3,\"10\",IF($A5=4,\"10\",IF($A5=5,\"15\",IF($A5=6,\"15\",IF($A5=7,\"15\",IF($A5=8,\"20\",\"\")))))))))","v":"1"},{"$f":"IF($A5=1,ECHEANCIER!$D$3,IF($A5=3,ECHEANCIER!$D$3,IF($A8=4,ECHEANCIER!$D$4,IF($A8=5,ECHEANCIER!$D$4,IF($A8=6,ECHEANCIER!$D$4,IF($A8=7,ECHEANCIER!$D$4,IF($A8=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$3,IF($A5=3,ECHEANCIER!$E$3,IF($A5=2,ECHEANCIER!$E$4,IF($A5=4,ECHEANCIER!$E$6,IF($A5=5,ECHEANCIER!$E$7,IF($A5=6,ECHEANCIER!$E$8,IF($A5=7,ECHEANCIER!$E$9,IF($A5=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A5=\"\",\"\",IF($A5=1,ECHEANCIER!$F$3,IF($A5=3,ECHEANCIER!$F$3,IF($A5=2,ECHEANCIER!$F$4,IF($A5=4,ECHEANCIER!$F$6,IF($A5=5,ECHEANCIER!$F$7,IF($A5=6,ECHEANCIER!$F$8,IF($A5=7,ECHEANCIER!$F$9,IF($A5=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"RETRAITE"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$G$3,IF($A5=3,ECHEANCIER!$G$5,IF($A5<>\"RETRAITE\",\"\"))))","v":750},{"$f":"SUM(G4)+SUM(F5)","v":8250},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",IF($A5=2,ECHEANCIER!$G$4,IF($A5=4,ECHEANCIER!$G$6,IF($A5=5,ECHEANCIER!$G$7,IF($A5=6,ECHEANCIER!$G$8,IF($A5=7,ECHEANCIER!$G$9,IF($A5=8,ECHEANCIER!$G$10,\"\")))))))","v":""},null,null," "]
[3,"10",{"$f":"IF($A6=1,ECHEANCIER!$D$3,IF($A6=3,ECHEANCIER!$D$3,IF($A9=4,ECHEANCIER!$D$4,IF($A9=5,ECHEANCIER!$D$4,IF($A9=6,ECHEANCIER!$D$4,IF($A9=7,ECHEANCIER!$D$4,IF($A9=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$3,IF($A6=2,ECHEANCIER!$E$4,IF($A6=4,ECHEANCIER!$E$6,IF($A6=5,ECHEANCIER!$E$7,IF($A6=6,ECHEANCIER!$E$8,IF($A6=7,ECHEANCIER!$E$9,IF($A6=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A6=\"\",\"\",IF($A6=1,ECHEANCIER!$F$3,IF($A6=3,ECHEANCIER!$F$3,IF($A6=2,ECHEANCIER!$F$4,IF($A6=4,ECHEANCIER!$F$6,IF($A6=5,ECHEANCIER!$F$7,IF($A6=6,ECHEANCIER!$F$8,IF($A6=7,ECHEANCIER!$F$9,IF($A6=8,ECHEANCIER!$F$10)))))))))","v":"RETRAITE"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$G$3,IF($A6=3,ECHEANCIER!$G$5,IF($A6<>\"RETRAITE\",\"\"))))","v":1200},{"$f":"SUM(G5)+SUM(F6)","v":9450},{"$f":"F6","v":1200},null,{"$f":"IF($A6=\"\",\"\",IF($A6=2,ECHEANCIER!$G$4,IF($A6=4,ECHEANCIER!$G$6,IF($A6=5,ECHEANCIER!$G$7,IF($A6=6,ECHEANCIER!$G$8,IF($A6=7,ECHEANCIER!$G$9,IF($A6=8,ECHEANCIER!$G$10,\"\")))))))","v":""}]
[2,"5",{"$f":"IF($A7=1,ECHEANCIER!$D$3,IF($A7=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$3,IF($A7=3,ECHEANCIER!$E$3,IF($A7=2,ECHEANCIER!$E$4,IF($A7=4,ECHEANCIER!$E$6,IF($A7=5,ECHEANCIER!$E$7,IF($A7=6,ECHEANCIER!$E$8,IF($A7=7,ECHEANCIER!$E$9,IF($A7=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"UNEO"},{"$f":"IF(A7=\"\",\"\",IF($A7=1,ECHEANCIER!$F$3,IF($A7=3,ECHEANCIER!$F$3,IF($A7=2,ECHEANCIER!$F$4,IF($A7=4,ECHEANCIER!$F$6,IF($A7=5,ECHEANCIER!$F$7,IF($A7=6,ECHEANCIER!$F$8,IF($A7=7,ECHEANCIER!$F$9,IF($A7=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"MUTUELLE"},{"$f":"IF($A7=\"\",\"\",IF($A7=2,ECHEANCIER!$G$4,IF($A7=4,ECHEANCIER!$G$6,IF($A7=5,ECHEANCIER!$G$7,IF($A7=6,ECHEANCIER!$G$8,IF($A7=7,ECHEANCIER!$G$9,IF($A7=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},9350,{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$G$3,IF($A7=3,ECHEANCIER!$G$5,IF($A7<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F7","v":-100}]
[4,"10",{"$f":"IF($A8=1,ECHEANCIER!$D$3,IF($A8=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$3,IF($A8=2,ECHEANCIER!$E$4,IF($A8=4,ECHEANCIER!$E$6,IF($A8=5,ECHEANCIER!$E$7,IF($A8=6,ECHEANCIER!$E$8,IF($A8=7,ECHEANCIER!$E$9,IF($A8=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"A.L.M."},{"$f":"IF(A8=\"\",\"\",IF($A8=1,ECHEANCIER!$F$3,IF($A8=3,ECHEANCIER!$F$3,IF($A8=2,ECHEANCIER!$F$4,IF($A8=4,ECHEANCIER!$F$6,IF($A8=5,ECHEANCIER!$F$7,IF($A8=6,ECHEANCIER!$F$8,IF($A8=7,ECHEANCIER!$F$9,IF($A8=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"EAUX"},{"$f":"IF($A8=\"\",\"\",IF($A8=2,ECHEANCIER!$G$4,IF($A8=4,ECHEANCIER!$G$6,IF($A8=5,ECHEANCIER!$G$7,IF($A8=6,ECHEANCIER!$G$8,IF($A8=7,ECHEANCIER!$G$9,IF($A8=8,ECHEANCIER!$G$10,\"\")))))))","v":-40},9310,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$G$3,IF($A8=3,ECHEANCIER!$G$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F8","v":-40}]
[5,"15",{"$f":"IF($A9=1,ECHEANCIER!$D$3,IF($A9=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$3,IF($A9=2,ECHEANCIER!$E$4,IF($A9=4,ECHEANCIER!$E$6,IF($A9=5,ECHEANCIER!$E$7,IF($A9=6,ECHEANCIER!$E$8,IF($A9=7,ECHEANCIER!$E$9,IF($A9=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A9=\"\",\"\",IF($A9=1,ECHEANCIER!$F$3,IF($A9=3,ECHEANCIER!$F$3,IF($A9=2,ECHEANCIER!$F$4,IF($A9=4,ECHEANCIER!$F$6,IF($A9=5,ECHEANCIER!$F$7,IF($A9=6,ECHEANCIER!$F$8,IF($A9=7,ECHEANCIER!$F$9,IF($A9=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.HABI"},{"$f":"IF($A9=\"\",\"\",IF($A9=2,ECHEANCIER!$G$4,IF($A9=4,ECHEANCIER!$G$6,IF($A9=5,ECHEANCIER!$G$7,IF($A9=6,ECHEANCIER!$G$8,IF($A9=7,ECHEANCIER!$G$9,IF($A9=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},9210,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$G$3,IF($A9=3,ECHEANCIER!$G$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,"15",{"$f":"IF($A10=1,ECHEANCIER!$D$3,IF($A10=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$3,IF($A10=2,ECHEANCIER!$E$4,IF($A10=4,ECHEANCIER!$E$6,IF($A10=5,ECHEANCIER!$E$7,IF($A10=6,ECHEANCIER!$E$8,IF($A10=7,ECHEANCIER!$E$9,IF($A10=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A10=\"\",\"\",IF($A10=1,ECHEANCIER!$F$3,IF($A10=3,ECHEANCIER!$F$3,IF($A10=2,ECHEANCIER!$F$4,IF($A10=4,ECHEANCIER!$F$6,IF($A10=5,ECHEANCIER!$F$7,IF($A10=6,ECHEANCIER!$F$8,IF($A10=7,ECHEANCIER!$F$9,IF($A10=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.FONC"},{"$f":"IF($A10=\"\",\"\",IF($A10=2,ECHEANCIER!$G$4,IF($A10=4,ECHEANCIER!$G$6,IF($A10=5,ECHEANCIER!$G$7,IF($A10=6,ECHEANCIER!$G$8,IF($A10=7,ECHEANCIER!$G$9,IF($A10=8,ECHEANCIER!$G$10,\"\")))))))","v":-110},9100,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$G$3,IF($A10=3,ECHEANCIER!$G$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,"15",{"$f":"IF($A11=1,ECHEANCIER!$D$3,IF($A11=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$3,IF($A11=2,ECHEANCIER!$E$4,IF($A11=4,ECHEANCIER!$E$6,IF($A11=5,ECHEANCIER!$E$7,IF($A11=6,ECHEANCIER!$E$8,IF($A11=7,ECHEANCIER!$E$9,IF($A11=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A11=\"\",\"\",IF($A11=1,ECHEANCIER!$F$3,IF($A11=3,ECHEANCIER!$F$3,IF($A11=2,ECHEANCIER!$F$4,IF($A11=4,ECHEANCIER!$F$6,IF($A11=5,ECHEANCIER!$F$7,IF($A11=6,ECHEANCIER!$F$8,IF($A11=7,ECHEANCIER!$F$9,IF($A11=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"IMP.REV"},{"$f":"IF($A11=\"\",\"\",IF($A11=2,ECHEANCIER!$G$4,IF($A11=4,ECHEANCIER!$G$6,IF($A11=5,ECHEANCIER!$G$7,IF($A11=6,ECHEANCIER!$G$8,IF($A11=7,ECHEANCIER!$G$9,IF($A11=8,ECHEANCIER!$G$10,\"\")))))))","v":-350},8750,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$G$3,IF($A11=3,ECHEANCIER!$G$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,"20",{"$f":"IF($A12=1,ECHEANCIER!$D$3,IF($A12=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4,IF($A12=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$3,IF($A12=2,ECHEANCIER!$E$4,IF($A12=4,ECHEANCIER!$E$6,IF($A12=5,ECHEANCIER!$E$7,IF($A12=6,ECHEANCIER!$E$8,IF($A12=7,ECHEANCIER!$E$9,IF($A12=8,ECHEANCIER!$E$10,IF($A12=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ENGIE"},{"$f":"IF(A12=\"\",\"\",IF($A12=1,ECHEANCIER!$F$3,IF($A12=3,ECHEANCIER!$F$3,IF($A12=2,ECHEANCIER!$F$4,IF($A12=4,ECHEANCIER!$F$6,IF($A12=5,ECHEANCIER!$F$7,IF($A12=6,ECHEANCIER!$F$8,IF($A12=7,ECHEANCIER!$F$9,IF($A12=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"GAZ-ELEC"},{"$f":"IF($A12=\"\",\"\",IF($A12=2,ECHEANCIER!$G$4,IF($A12=4,ECHEANCIER!$G$6,IF($A12=5,ECHEANCIER!$G$7,IF($A12=6,ECHEANCIER!$G$8,IF($A12=7,ECHEANCIER!$G$9,IF($A12=8,ECHEANCIER!$G$10,\"\")))))))","v":-120},8630,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$G$3,IF($A12=3,ECHEANCIER!$G$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"IF(A13=\"\",\"\",IF($A13=1,\"1\",IF($A13=2,\"5\",IF($A13=3,\"10\",IF($A13=4,\"10\",IF($A13=5,\"15\",IF($A13=6,\"15\",IF($A13=7,\"15\",IF($A13=8,\"20\",IF($A13=9,\"27\",\"\"))))))))))","v":"27"},{"$f":"IF($A13=1,ECHEANCIER!$D$3,IF($A13=3,ECHEANCIER!$D$3,IF($A13=4,ECHEANCIER!$D$4,IF($A13=5,ECHEANCIER!$D$4,IF($A13=6,ECHEANCIER!$D$4,IF($A13=7,ECHEANCIER!$D$4,IF($A13=8,ECHEANCIER!$D$4,IF($A13=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A13=\"\",\"\",IF($A13=1,ECHEANCIER!$E$3,IF($A13=3,ECHEANCIER!$E$3,IF($A13=2,ECHEANCIER!$E$4,IF($A13=4,ECHEANCIER!$E$6,IF($A13=5,ECHEANCIER!$E$7,IF($A13=6,ECHEANCIER!$E$8,IF($A13=7,ECHEANCIER!$E$9,IF($A13=8,ECHEANCIER!$E$10,IF($A13=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ST CHRIST"},{"$f":"+IF($A13=9,\"ass.voit\")","v":"ass.voit"},{"$f":"IF(AND($A13=9,$E13=\"ASS.VOIT\",OR($A$1=\"modele\",$A$1=\"avril\",$A$1=\"juillet\",$A$1=\"octobre\")),ECHEANCIER!$G$11,\"\")","v":-95},8535,null,null,-95,{"$f":"IF($E13=\"C. PORT LOYER\",$F13,0)","v":0},{"$f":"IF($E13=\"C. PORT CHARGES\",$F13,0)","v":0},{"$f":"IF($E13=\"MOUVEMENTS\",$F13,0)","v":0}]
[10,25,null,"Carrefour","RECETTES DIVERSES",40,8575,null,{"$f":"IF($E14=\"RECETTES DIVERSES\",$F14,0)","v":40},{"$f":"IF($E14=\"DEPENSES\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT LOYER\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT CHARGES\",$F14,0)","v":0},{"$f":"IF($E14=\"MOUVEMENTS\",$F14,0)","v":0}]
[11,26,null,"Lutz","C. PORT CHARGES",-135,8440,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,-135,0]
[12,26,null,"Lutz","C. PORT LOYER",650,9090,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,650,0,0]
[13,29,null,"Poste","DIVERS",-500,8590,null,0,0,0,0,{"$f":"IF($E17=\"DIVERS\",$F17,0)","v":-500}]
[" ",null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":8590},null,0,0,0,0,0]
[" "," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},8590,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,8590,null,0,{"$f":"F20","v":0},0,0,0]
[]
[]
[]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":1950},{"$f":"SUM(I5:I23)","v":40},{"$f":"SUM(J5:J23)","v":-915},650,-135,-500]
["SOUS TOTAL"," ",null,null,null,null,null,{"$f":"H24+H4","v":1950},{"$f":"I24+I4","v":40},null,{"$f":"K24+K4","v":650},-135]
["TOTAL",null,null,null,null,null,{"$f":"G20","v":8590},{"$f":"SUM(H25:I25)","v":1990},null,{"$f":"J24+J4","v":-915},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"JANVIER","index":2,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"JANVIER"}]
["N° SAISIE","JOURS","MODE","TIERS","CATEGORIE","BANQUE POSTALE",null,"RECETTES",null,"DEPENSES","C. PORT"," ","DIVERS"]
[null,null,"PAIEMENT",null,null,"DEBIT/CREDIT","SOLDE","RETRAITE","DIVERSES",null,"LOYER","CHARGES"," "]
["REPORT",null,null,null,null,null,7500]
[1,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"1\",IF($A5=2,\"5\",IF($A5=3,\"10\",IF($A5=4,\"10\",IF($A5=5,\"15\",IF($A5=6,\"15\",IF($A5=7,\"15\",IF($A5=8,\"20\",\"\")))))))))","v":"1"},{"$f":"IF($A5=1,ECHEANCIER!$D$3,IF($A5=3,ECHEANCIER!$D$3,IF($A8=4,ECHEANCIER!$D$4,IF($A8=5,ECHEANCIER!$D$4,IF($A8=6,ECHEANCIER!$D$4,IF($A8=7,ECHEANCIER!$D$4,IF($A8=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$3,IF($A5=3,ECHEANCIER!$E$3,IF($A5=2,ECHEANCIER!$E$4,IF($A5=4,ECHEANCIER!$E$6,IF($A5=5,ECHEANCIER!$E$7,IF($A5=6,ECHEANCIER!$E$8,IF($A5=7,ECHEANCIER!$E$9,IF($A5=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A5=\"\",\"\",IF($A5=1,ECHEANCIER!$F$3,IF($A5=3,ECHEANCIER!$F$3,IF($A5=2,ECHEANCIER!$F$4,IF($A5=4,ECHEANCIER!$F$6,IF($A5=5,ECHEANCIER!$F$7,IF($A5=6,ECHEANCIER!$F$8,IF($A5=7,ECHEANCIER!$F$9,IF($A5=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"RETRAITE"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$G$3,IF($A5=3,ECHEANCIER!$G$5,IF($A5<>\"RETRAITE\",\"\"))))","v":750},{"$f":"SUM(G4)+SUM(F5)","v":8250},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",IF($A5=2,ECHEANCIER!$G$4,IF($A5=4,ECHEANCIER!$G$6,IF($A5=5,ECHEANCIER!$G$7,IF($A5=6,ECHEANCIER!$G$8,IF($A5=7,ECHEANCIER!$G$9,IF($A5=8,ECHEANCIER!$G$10,\"\")))))))","v":""},null,null," "]
[3,"10",{"$f":"IF($A6=1,ECHEANCIER!$D$3,IF($A6=3,ECHEANCIER!$D$3,IF($A9=4,ECHEANCIER!$D$4,IF($A9=5,ECHEANCIER!$D$4,IF($A9=6,ECHEANCIER!$D$4,IF($A9=7,ECHEANCIER!$D$4,IF($A9=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$3,IF($A6=2,ECHEANCIER!$E$4,IF($A6=4,ECHEANCIER!$E$6,IF($A6=5,ECHEANCIER!$E$7,IF($A6=6,ECHEANCIER!$E$8,IF($A6=7,ECHEANCIER!$E$9,IF($A6=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A6=\"\",\"\",IF($A6=1,ECHEANCIER!$F$3,IF($A6=3,ECHEANCIER!$F$3,IF($A6=2,ECHEANCIER!$F$4,IF($A6=4,ECHEANCIER!$F$6,IF($A6=5,ECHEANCIER!$F$7,IF($A6=6,ECHEANCIER!$F$8,IF($A6=7,ECHEANCIER!$F$9,IF($A6=8,ECHEANCIER!$F$10)))))))))","v":"RETRAITE"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$G$3,IF($A6=3,ECHEANCIER!$G$5,IF($A6<>\"RETRAITE\",\"\"))))","v":1200},{"$f":"SUM(G5)+SUM(F6)","v":9450},{"$f":"F6","v":1200},null,{"$f":"IF($A6=\"\",\"\",IF($A6=2,ECHEANCIER!$G$4,IF($A6=4,ECHEANCIER!$G$6,IF($A6=5,ECHEANCIER!$G$7,IF($A6=6,ECHEANCIER!$G$8,IF($A6=7,ECHEANCIER!$G$9,IF($A6=8,ECHEANCIER!$G$10,\"\")))))))","v":""}]
[2,"5",{"$f":"IF($A7=1,ECHEANCIER!$D$3,IF($A7=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$3,IF($A7=3,ECHEANCIER!$E$3,IF($A7=2,ECHEANCIER!$E$4,IF($A7=4,ECHEANCIER!$E$6,IF($A7=5,ECHEANCIER!$E$7,IF($A7=6,ECHEANCIER!$E$8,IF($A7=7,ECHEANCIER!$E$9,IF($A7=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"UNEO"},{"$f":"IF(A7=\"\",\"\",IF($A7=1,ECHEANCIER!$F$3,IF($A7=3,ECHEANCIER!$F$3,IF($A7=2,ECHEANCIER!$F$4,IF($A7=4,ECHEANCIER!$F$6,IF($A7=5,ECHEANCIER!$F$7,IF($A7=6,ECHEANCIER!$F$8,IF($A7=7,ECHEANCIER!$F$9,IF($A7=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"MUTUELLE"},{"$f":"IF($A7=\"\",\"\",IF($A7=2,ECHEANCIER!$G$4,IF($A7=4,ECHEANCIER!$G$6,IF($A7=5,ECHEANCIER!$G$7,IF($A7=6,ECHEANCIER!$G$8,IF($A7=7,ECHEANCIER!$G$9,IF($A7=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},9350,{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$G$3,IF($A7=3,ECHEANCIER!$G$5,IF($A7<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F7","v":-100}]
[4,"10",{"$f":"IF($A8=1,ECHEANCIER!$D$3,IF($A8=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$3,IF($A8=2,ECHEANCIER!$E$4,IF($A8=4,ECHEANCIER!$E$6,IF($A8=5,ECHEANCIER!$E$7,IF($A8=6,ECHEANCIER!$E$8,IF($A8=7,ECHEANCIER!$E$9,IF($A8=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"A.L.M."},{"$f":"IF(A8=\"\",\"\",IF($A8=1,ECHEANCIER!$F$3,IF($A8=3,ECHEANCIER!$F$3,IF($A8=2,ECHEANCIER!$F$4,IF($A8=4,ECHEANCIER!$F$6,IF($A8=5,ECHEANCIER!$F$7,IF($A8=6,ECHEANCIER!$F$8,IF($A8=7,ECHEANCIER!$F$9,IF($A8=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"EAUX"},{"$f":"IF($A8=\"\",\"\",IF($A8=2,ECHEANCIER!$G$4,IF($A8=4,ECHEANCIER!$G$6,IF($A8=5,ECHEANCIER!$G$7,IF($A8=6,ECHEANCIER!$G$8,IF($A8=7,ECHEANCIER!$G$9,IF($A8=8,ECHEANCIER!$G$10,\"\")))))))","v":-40},9310,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$G$3,IF($A8=3,ECHEANCIER!$G$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F8","v":-40}]
[5,"15",{"$f":"IF($A9=1,ECHEANCIER!$D$3,IF($A9=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$3,IF($A9=2,ECHEANCIER!$E$4,IF($A9=4,ECHEANCIER!$E$6,IF($A9=5,ECHEANCIER!$E$7,IF($A9=6,ECHEANCIER!$E$8,IF($A9=7,ECHEANCIER!$E$9,IF($A9=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A9=\"\",\"\",IF($A9=1,ECHEANCIER!$F$3,IF($A9=3,ECHEANCIER!$F$3,IF($A9=2,ECHEANCIER!$F$4,IF($A9=4,ECHEANCIER!$F$6,IF($A9=5,ECHEANCIER!$F$7,IF($A9=6,ECHEANCIER!$F$8,IF($A9=7,ECHEANCIER!$F$9,IF($A9=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.HABI"},{"$f":"IF($A9=\"\",\"\",IF($A9=2,ECHEANCIER!$G$4,IF($A9=4,ECHEANCIER!$G$6,IF($A9=5,ECHEANCIER!$G$7,IF($A9=6,ECHEANCIER!$G$8,IF($A9=7,ECHEANCIER!$G$9,IF($A9=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},9210,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$G$3,IF($A9=3,ECHEANCIER!$G$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,"15",{"$f":"IF($A10=1,ECHEANCIER!$D$3,IF($A10=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$3,IF($A10=2,ECHEANCIER!$E$4,IF($A10=4,ECHEANCIER!$E$6,IF($A10=5,ECHEANCIER!$E$7,IF($A10=6,ECHEANCIER!$E$8,IF($A10=7,ECHEANCIER!$E$9,IF($A10=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A10=\"\",\"\",IF($A10=1,ECHEANCIER!$F$3,IF($A10=3,ECHEANCIER!$F$3,IF($A10=2,ECHEANCIER!$F$4,IF($A10=4,ECHEANCIER!$F$6,IF($A10=5,ECHEANCIER!$F$7,IF($A10=6,ECHEANCIER!$F$8,IF($A10=7,ECHEANCIER!$F$9,IF($A10=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.FONC"},{"$f":"IF($A10=\"\",\"\",IF($A10=2,ECHEANCIER!$G$4,IF($A10=4,ECHEANCIER!$G$6,IF($A10=5,ECHEANCIER!$G$7,IF($A10=6,ECHEANCIER!$G$8,IF($A10=7,ECHEANCIER!$G$9,IF($A10=8,ECHEANCIER!$G$10,\"\")))))))","v":-110},9100,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$G$3,IF($A10=3,ECHEANCIER!$G$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,"15",{"$f":"IF($A11=1,ECHEANCIER!$D$3,IF($A11=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$3,IF($A11=2,ECHEANCIER!$E$4,IF($A11=4,ECHEANCIER!$E$6,IF($A11=5,ECHEANCIER!$E$7,IF($A11=6,ECHEANCIER!$E$8,IF($A11=7,ECHEANCIER!$E$9,IF($A11=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A11=\"\",\"\",IF($A11=1,ECHEANCIER!$F$3,IF($A11=3,ECHEANCIER!$F$3,IF($A11=2,ECHEANCIER!$F$4,IF($A11=4,ECHEANCIER!$F$6,IF($A11=5,ECHEANCIER!$F$7,IF($A11=6,ECHEANCIER!$F$8,IF($A11=7,ECHEANCIER!$F$9,IF($A11=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"IMP.REV"},{"$f":"IF($A11=\"\",\"\",IF($A11=2,ECHEANCIER!$G$4,IF($A11=4,ECHEANCIER!$G$6,IF($A11=5,ECHEANCIER!$G$7,IF($A11=6,ECHEANCIER!$G$8,IF($A11=7,ECHEANCIER!$G$9,IF($A11=8,ECHEANCIER!$G$10,\"\")))))))","v":-350},8750,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$G$3,IF($A11=3,ECHEANCIER!$G$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,"20",{"$f":"IF($A12=1,ECHEANCIER!$D$3,IF($A12=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4,IF($A12=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$3,IF($A12=2,ECHEANCIER!$E$4,IF($A12=4,ECHEANCIER!$E$6,IF($A12=5,ECHEANCIER!$E$7,IF($A12=6,ECHEANCIER!$E$8,IF($A12=7,ECHEANCIER!$E$9,IF($A12=8,ECHEANCIER!$E$10,IF($A12=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ENGIE"},{"$f":"IF(A12=\"\",\"\",IF($A12=1,ECHEANCIER!$F$3,IF($A12=3,ECHEANCIER!$F$3,IF($A12=2,ECHEANCIER!$F$4,IF($A12=4,ECHEANCIER!$F$6,IF($A12=5,ECHEANCIER!$F$7,IF($A12=6,ECHEANCIER!$F$8,IF($A12=7,ECHEANCIER!$F$9,IF($A12=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"GAZ-ELEC"},{"$f":"IF($A12=\"\",\"\",IF($A12=2,ECHEANCIER!$G$4,IF($A12=4,ECHEANCIER!$G$6,IF($A12=5,ECHEANCIER!$G$7,IF($A12=6,ECHEANCIER!$G$8,IF($A12=7,ECHEANCIER!$G$9,IF($A12=8,ECHEANCIER!$G$10,\"\")))))))","v":-120},8630,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$G$3,IF($A12=3,ECHEANCIER!$G$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"IF(A13=\"\",\"\",IF($A13=1,\"1\",IF($A13=2,\"5\",IF($A13=3,\"10\",IF($A13=4,\"10\",IF($A13=5,\"15\",IF($A13=6,\"15\",IF($A13=7,\"15\",IF($A13=8,\"20\",IF($A13=9,\"27\",\"\"))))))))))","v":"27"},{"$f":"IF($A13=1,ECHEANCIER!$D$3,IF($A13=3,ECHEANCIER!$D$3,IF($A13=4,ECHEANCIER!$D$4,IF($A13=5,ECHEANCIER!$D$4,IF($A13=6,ECHEANCIER!$D$4,IF($A13=7,ECHEANCIER!$D$4,IF($A13=8,ECHEANCIER!$D$4,IF($A13=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A13=\"\",\"\",IF($A13=1,ECHEANCIER!$E$3,IF($A13=3,ECHEANCIER!$E$3,IF($A13=2,ECHEANCIER!$E$4,IF($A13=4,ECHEANCIER!$E$6,IF($A13=5,ECHEANCIER!$E$7,IF($A13=6,ECHEANCIER!$E$8,IF($A13=7,ECHEANCIER!$E$9,IF($A13=8,ECHEANCIER!$E$10,IF($A13=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ST CHRIST"},{"$f":"+IF($A13=9,\"ass.voit\")","v":"ass.voit"},{"$f":"IF(AND($A13=9,$E13=\"ASS.VOIT\",OR($A$1=\"modele\",$A$1=\"janvier\",$A$1=\"avril\",$A$1=\"juillet\",$A$1=\"octobre\")),ECHEANCIER!$G$11,\"\")","v":-95},8535,null,null,-95,{"$f":"IF($E13=\"C. PORT LOYER\",$F13,0)","v":0},{"$f":"IF($E13=\"C. PORT CHARGES\",$F13,0)","v":0},{"$f":"IF($E13=\"MOUVEMENTS\",$F13,0)","v":0}]
[10,25,"Vir recu","Carrefour","RECETTES DIVERSES",40,8575,null,{"$f":"IF($E14=\"RECETTES DIVERSES\",$F14,0)","v":40},{"$f":"IF($E14=\"DEPENSES\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT LOYER\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT CHARGES\",$F14,0)","v":0},{"$f":"IF($E14=\"MOUVEMENTS\",$F14,0)","v":0}]
[11,26,"Cheque","Lutz","C. PORT CHARGES",-135,8440,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,-135,0]
[12,26,"Vir recu","Lutz","C. PORT LOYER",650,9090,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,650,0,0]
[13,29,"Retrait","Poste","DIVERS",-500,8590,null,0,0,0,0,{"$f":"IF($E17=\"DIVERS\",$F17,0)","v":-500}]
[14,30,"Carte","Bontemps","DEPENSES",90,{"$f":"SUM(G17)+SUM(F18)","v":8680},null,0,90,0,0,0]
[" "," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},8680,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,8680,null,0,{"$f":"F20","v":0},0,0,0]
[]
[]
[]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":1950},{"$f":"SUM(I5:I23)","v":40},{"$f":"SUM(J5:J23)","v":-825},650,-135,-500]
["SOUS TOTAL"," ",null,null,null,null,null,{"$f":"H24+H4","v":1950},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-825},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,{"$f":"G20","v":8680},{"$f":"SUM(H25:I25)","v":1990},null,{"$f":"J24+J4","v":-825},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"FEVRIER","index":3,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"FEVRIER"}]
["N° SAISIE","JOURS","MODE","TIERS","CATEGORIE","BANQUE POSTALE",null,"RECETTES",null,"DEPENSES","C. PORT"," ","DIVERS"]
[null,null,"PAIEMENT",null,null,"DEBIT/CREDIT","SOLDE","RETRAITE","DIVERSES",null,"LOYER","CHARGES"," "]
["REPORT",null,null,null,null,null,{"$f":"JANVIER!G26","v":8680},{"$f":"JANVIER!H25","v":1950},{"$f":"JANVIER!I25","v":40},{"$f":"JANVIER!J25","v":-825},{"$f":"JANVIER!K25","v":650},{"$f":"JANVIER!L25","v":-135},{"$f":"JANVIER!M25","v":-500}]
[1,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"1\",IF($A5=2,\"5\",IF($A5=3,\"10\",IF($A5=4,\"10\",IF($A5=5,\"15\",IF($A5=6,\"15\",IF($A5=7,\"15\",IF($A5=8,\"20\",\"\")))))))))","v":"1"},{"$f":"IF($A5=1,ECHEANCIER!$D$3,IF($A5=3,ECHEANCIER!$D$3,IF($A8=4,ECHEANCIER!$D$4,IF($A8=5,ECHEANCIER!$D$4,IF($A8=6,ECHEANCIER!$D$4,IF($A8=7,ECHEANCIER!$D$4,IF($A8=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$3,IF($A5=3,ECHEANCIER!$E$3,IF($A5=2,ECHEANCIER!$E$4,IF($A5=4,ECHEANCIER!$E$6,IF($A5=5,ECHEANCIER!$E$7,IF($A5=6,ECHEANCIER!$E$8,IF($A5=7,ECHEANCIER!$E$9,IF($A5=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A5=\"\",\"\",IF($A5=1,ECHEANCIER!$F$3,IF($A5=3,ECHEANCIER!$F$3,IF($A5=2,ECHEANCIER!$F$4,IF($A5=4,ECHEANCIER!$F$6,IF($A5=5,ECHEANCIER!$F$7,IF($A5=6,ECHEANCIER!$F$8,IF($A5=7,ECHEANCIER!$F$9,IF($A5=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"RETRAITE"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$G$3,IF($A5=3,ECHEANCIER!$G$5,IF($A5<>\"RETRAITE\",\"\"))))","v":750},{"$f":"SUM(G4)+SUM(F5)","v":9430},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",IF($A5=2,ECHEANCIER!$G$4,IF($A5=4,ECHEANCIER!$G$6,IF($A5=5,ECHEANCIER!$G$7,IF($A5=6,ECHEANCIER!$G$8,IF($A5=7,ECHEANCIER!$G$9,IF($A5=8,ECHEANCIER!$G$10,\"\")))))))","v":""},null,null," "]
[3,"10",{"$f":"IF($A6=1,ECHEANCIER!$D$3,IF($A6=3,ECHEANCIER!$D$3,IF($A9=4,ECHEANCIER!$D$4,IF($A9=5,ECHEANCIER!$D$4,IF($A9=6,ECHEANCIER!$D$4,IF($A9=7,ECHEANCIER!$D$4,IF($A9=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$3,IF($A6=2,ECHEANCIER!$E$4,IF($A6=4,ECHEANCIER!$E$6,IF($A6=5,ECHEANCIER!$E$7,IF($A6=6,ECHEANCIER!$E$8,IF($A6=7,ECHEANCIER!$E$9,IF($A6=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A6=\"\",\"\",IF($A6=1,ECHEANCIER!$F$3,IF($A6=3,ECHEANCIER!$F$3,IF($A6=2,ECHEANCIER!$F$4,IF($A6=4,ECHEANCIER!$F$6,IF($A6=5,ECHEANCIER!$F$7,IF($A6=6,ECHEANCIER!$F$8,IF($A6=7,ECHEANCIER!$F$9,IF($A6=8,ECHEANCIER!$F$10)))))))))","v":"RETRAITE"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$G$3,IF($A6=3,ECHEANCIER!$G$5,IF($A6<>\"RETRAITE\",\"\"))))","v":1200},{"$f":"SUM(G5)+SUM(F6)","v":10630},{"$f":"F6","v":1200},null,{"$f":"IF($A6=\"\",\"\",IF($A6=2,ECHEANCIER!$G$4,IF($A6=4,ECHEANCIER!$G$6,IF($A6=5,ECHEANCIER!$G$7,IF($A6=6,ECHEANCIER!$G$8,IF($A6=7,ECHEANCIER!$G$9,IF($A6=8,ECHEANCIER!$G$10,\"\")))))))","v":""}]
[2,"5",{"$f":"IF($A7=1,ECHEANCIER!$D$3,IF($A7=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$3,IF($A7=3,ECHEANCIER!$E$3,IF($A7=2,ECHEANCIER!$E$4,IF($A7=4,ECHEANCIER!$E$6,IF($A7=5,ECHEANCIER!$E$7,IF($A7=6,ECHEANCIER!$E$8,IF($A7=7,ECHEANCIER!$E$9,IF($A7=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"UNEO"},{"$f":"IF(A7=\"\",\"\",IF($A7=1,ECHEANCIER!$F$3,IF($A7=3,ECHEANCIER!$F$3,IF($A7=2,ECHEANCIER!$F$4,IF($A7=4,ECHEANCIER!$F$6,IF($A7=5,ECHEANCIER!$F$7,IF($A7=6,ECHEANCIER!$F$8,IF($A7=7,ECHEANCIER!$F$9,IF($A7=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"MUTUELLE"},{"$f":"IF($A7=\"\",\"\",IF($A7=2,ECHEANCIER!$G$4,IF($A7=4,ECHEANCIER!$G$6,IF($A7=5,ECHEANCIER!$G$7,IF($A7=6,ECHEANCIER!$G$8,IF($A7=7,ECHEANCIER!$G$9,IF($A7=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},10530,{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$G$3,IF($A7=3,ECHEANCIER!$G$5,IF($A7<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F7","v":-100}]
[4,"10",{"$f":"IF($A8=1,ECHEANCIER!$D$3,IF($A8=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$3,IF($A8=2,ECHEANCIER!$E$4,IF($A8=4,ECHEANCIER!$E$6,IF($A8=5,ECHEANCIER!$E$7,IF($A8=6,ECHEANCIER!$E$8,IF($A8=7,ECHEANCIER!$E$9,IF($A8=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"A.L.M."},{"$f":"IF(A8=\"\",\"\",IF($A8=1,ECHEANCIER!$F$3,IF($A8=3,ECHEANCIER!$F$3,IF($A8=2,ECHEANCIER!$F$4,IF($A8=4,ECHEANCIER!$F$6,IF($A8=5,ECHEANCIER!$F$7,IF($A8=6,ECHEANCIER!$F$8,IF($A8=7,ECHEANCIER!$F$9,IF($A8=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"EAUX"},{"$f":"IF($A8=\"\",\"\",IF($A8=2,ECHEANCIER!$G$4,IF($A8=4,ECHEANCIER!$G$6,IF($A8=5,ECHEANCIER!$G$7,IF($A8=6,ECHEANCIER!$G$8,IF($A8=7,ECHEANCIER!$G$9,IF($A8=8,ECHEANCIER!$G$10,\"\")))))))","v":-40},10490,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$G$3,IF($A8=3,ECHEANCIER!$G$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F8","v":-40}]
[5,"15",{"$f":"IF($A9=1,ECHEANCIER!$D$3,IF($A9=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$3,IF($A9=2,ECHEANCIER!$E$4,IF($A9=4,ECHEANCIER!$E$6,IF($A9=5,ECHEANCIER!$E$7,IF($A9=6,ECHEANCIER!$E$8,IF($A9=7,ECHEANCIER!$E$9,IF($A9=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A9=\"\",\"\",IF($A9=1,ECHEANCIER!$F$3,IF($A9=3,ECHEANCIER!$F$3,IF($A9=2,ECHEANCIER!$F$4,IF($A9=4,ECHEANCIER!$F$6,IF($A9=5,ECHEANCIER!$F$7,IF($A9=6,ECHEANCIER!$F$8,IF($A9=7,ECHEANCIER!$F$9,IF($A9=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.HABI"},{"$f":"IF($A9=\"\",\"\",IF($A9=2,ECHEANCIER!$G$4,IF($A9=4,ECHEANCIER!$G$6,IF($A9=5,ECHEANCIER!$G$7,IF($A9=6,ECHEANCIER!$G$8,IF($A9=7,ECHEANCIER!$G$9,IF($A9=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},10390,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$G$3,IF($A9=3,ECHEANCIER!$G$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,"15",{"$f":"IF($A10=1,ECHEANCIER!$D$3,IF($A10=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$3,IF($A10=2,ECHEANCIER!$E$4,IF($A10=4,ECHEANCIER!$E$6,IF($A10=5,ECHEANCIER!$E$7,IF($A10=6,ECHEANCIER!$E$8,IF($A10=7,ECHEANCIER!$E$9,IF($A10=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A10=\"\",\"\",IF($A10=1,ECHEANCIER!$F$3,IF($A10=3,ECHEANCIER!$F$3,IF($A10=2,ECHEANCIER!$F$4,IF($A10=4,ECHEANCIER!$F$6,IF($A10=5,ECHEANCIER!$F$7,IF($A10=6,ECHEANCIER!$F$8,IF($A10=7,ECHEANCIER!$F$9,IF($A10=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.FONC"},{"$f":"IF($A10=\"\",\"\",IF($A10=2,ECHEANCIER!$G$4,IF($A10=4,ECHEANCIER!$G$6,IF($A10=5,ECHEANCIER!$G$7,IF($A10=6,ECHEANCIER!$G$8,IF($A10=7,ECHEANCIER!$G$9,IF($A10=8,ECHEANCIER!$G$10,\"\")))))))","v":-110},10280,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$G$3,IF($A10=3,ECHEANCIER!$G$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,"15",{"$f":"IF($A11=1,ECHEANCIER!$D$3,IF($A11=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$3,IF($A11=2,ECHEANCIER!$E$4,IF($A11=4,ECHEANCIER!$E$6,IF($A11=5,ECHEANCIER!$E$7,IF($A11=6,ECHEANCIER!$E$8,IF($A11=7,ECHEANCIER!$E$9,IF($A11=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A11=\"\",\"\",IF($A11=1,ECHEANCIER!$F$3,IF($A11=3,ECHEANCIER!$F$3,IF($A11=2,ECHEANCIER!$F$4,IF($A11=4,ECHEANCIER!$F$6,IF($A11=5,ECHEANCIER!$F$7,IF($A11=6,ECHEANCIER!$F$8,IF($A11=7,ECHEANCIER!$F$9,IF($A11=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"IMP.REV"},{"$f":"IF($A11=\"\",\"\",IF($A11=2,ECHEANCIER!$G$4,IF($A11=4,ECHEANCIER!$G$6,IF($A11=5,ECHEANCIER!$G$7,IF($A11=6,ECHEANCIER!$G$8,IF($A11=7,ECHEANCIER!$G$9,IF($A11=8,ECHEANCIER!$G$10,\"\")))))))","v":-350},9930,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$G$3,IF($A11=3,ECHEANCIER!$G$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,"20",{"$f":"IF($A12=1,ECHEANCIER!$D$3,IF($A12=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4,IF($A12=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$3,IF($A12=2,ECHEANCIER!$E$4,IF($A12=4,ECHEANCIER!$E$6,IF($A12=5,ECHEANCIER!$E$7,IF($A12=6,ECHEANCIER!$E$8,IF($A12=7,ECHEANCIER!$E$9,IF($A12=8,ECHEANCIER!$E$10,IF($A12=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ENGIE"},{"$f":"IF(A12=\"\",\"\",IF($A12=1,ECHEANCIER!$F$3,IF($A12=3,ECHEANCIER!$F$3,IF($A12=2,ECHEANCIER!$F$4,IF($A12=4,ECHEANCIER!$F$6,IF($A12=5,ECHEANCIER!$F$7,IF($A12=6,ECHEANCIER!$F$8,IF($A12=7,ECHEANCIER!$F$9,IF($A12=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"GAZ-ELEC"},{"$f":"IF($A12=\"\",\"\",IF($A12=2,ECHEANCIER!$G$4,IF($A12=4,ECHEANCIER!$G$6,IF($A12=5,ECHEANCIER!$G$7,IF($A12=6,ECHEANCIER!$G$8,IF($A12=7,ECHEANCIER!$G$9,IF($A12=8,ECHEANCIER!$G$10,\"\")))))))","v":-120},9810,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$G$3,IF($A12=3,ECHEANCIER!$G$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"IF(A13=\"\",\"\",IF($A13=1,\"1\",IF($A13=2,\"5\",IF($A13=3,\"10\",IF($A13=4,\"10\",IF($A13=5,\"15\",IF($A13=6,\"15\",IF($A13=7,\"15\",IF($A13=8,\"20\",IF($A13=9,\"27\",\"\"))))))))))","v":"27"},{"$f":"IF($A13=1,ECHEANCIER!$D$3,IF($A13=3,ECHEANCIER!$D$3,IF($A13=4,ECHEANCIER!$D$4,IF($A13=5,ECHEANCIER!$D$4,IF($A13=6,ECHEANCIER!$D$4,IF($A13=7,ECHEANCIER!$D$4,IF($A13=8,ECHEANCIER!$D$4,IF($A13=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A13=\"\",\"\",IF($A13=1,ECHEANCIER!$E$3,IF($A13=3,ECHEANCIER!$E$3,IF($A13=2,ECHEANCIER!$E$4,IF($A13=4,ECHEANCIER!$E$6,IF($A13=5,ECHEANCIER!$E$7,IF($A13=6,ECHEANCIER!$E$8,IF($A13=7,ECHEANCIER!$E$9,IF($A13=8,ECHEANCIER!$E$10,IF($A13=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ST CHRIST"},{"$f":"+IF($A13=9,\"ass.voit\")","v":"ass.voit"},{"$f":"IF(AND($A13=9,$E13=\"ASS.VOIT\",OR($A$1=\"janvier\",$A$1=\"avril\",$A$1=\"juillet\",$A$1=\"octobre\")),ECHEANCIER!$G$11,\"\")","v":""},9810,null,null,"",{"$f":"IF($E13=\"C. PORT LOYER\",$F13,0)","v":0},{"$f":"IF($E13=\"C. PORT CHARGES\",$F13,0)","v":0},{"$f":"IF($E13=\"MOUVEMENTS\",$F13,0)","v":0}]
[null,null,null,null,null,null,9810,null,{"$f":"IF($E14=\"RECETTES DIVERSES\",$F14,0)","v":0},{"$f":"IF($E14=\"DEPENSES\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT LOYER\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT CHARGES\",$F14,0)","v":0},{"$f":"IF($E14=\"MOUVEMENTS\",$F14,0)","v":0}]
[null,null,null,null,null,null,9810,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,9810,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,9810,null,0,0,0,0,{"$f":"IF($E17=\"DIVERS\",$F17,0)","v":0}]
[" ",null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":9810},null,0,0,0,0,0]
[" "," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},9810,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,9810,null,0,{"$f":"F20","v":0},0,0,0]
[]
[]
[]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":1950},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":-820},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,null,{"$f":"H24+H4","v":3900},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-1645},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,{"$f":"G20","v":9810},{"$f":"SUM(H25:I25)","v":3940},null,{"$f":"J24+J4","v":-1645},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"MARS","index":4,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"MARS"}]
["N° SAISIE","JOURS","MODE","TIERS","CATEGORIE","BANQUE POSTALE",null,"RECETTES",null,"DEPENSES","C. PORT"," ","DIVERS"]
[null,null,"PAIEMENT",null,null,"DEBIT/CREDIT","SOLDE","RETRAITE","DIVERSES",null,"LOYER","CHARGES"," "]
["REPORT",null,null,null,null,null,{"$f":"FEVRIER!G26","v":9810},{"$f":"FEVRIER!H25","v":3900},{"$f":"FEVRIER!I25","v":40},{"$f":"FEVRIER!J25","v":-1645},{"$f":"FEVRIER!K25","v":650},{"$f":"FEVRIER!L25","v":-135},{"$f":"FEVRIER!M25","v":-500}]
[1,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"1\",IF($A5=2,\"5\",IF($A5=3,\"10\",IF($A5=4,\"10\",IF($A5=5,\"15\",IF($A5=6,\"15\",IF($A5=7,\"15\",IF($A5=8,\"20\",\"\")))))))))","v":"1"},{"$f":"IF($A5=1,ECHEANCIER!$D$3,IF($A5=3,ECHEANCIER!$D$3,IF($A8=4,ECHEANCIER!$D$4,IF($A8=5,ECHEANCIER!$D$4,IF($A8=6,ECHEANCIER!$D$4,IF($A8=7,ECHEANCIER!$D$4,IF($A8=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$3,IF($A5=3,ECHEANCIER!$E$3,IF($A5=2,ECHEANCIER!$E$4,IF($A5=4,ECHEANCIER!$E$6,IF($A5=5,ECHEANCIER!$E$7,IF($A5=6,ECHEANCIER!$E$8,IF($A5=7,ECHEANCIER!$E$9,IF($A5=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A5=\"\",\"\",IF($A5=1,ECHEANCIER!$F$3,IF($A5=3,ECHEANCIER!$F$3,IF($A5=2,ECHEANCIER!$F$4,IF($A5=4,ECHEANCIER!$F$6,IF($A5=5,ECHEANCIER!$F$7,IF($A5=6,ECHEANCIER!$F$8,IF($A5=7,ECHEANCIER!$F$9,IF($A5=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"RETRAITE"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$G$3,IF($A5=3,ECHEANCIER!$G$5,IF($A5<>\"RETRAITE\",\"\"))))","v":750},{"$f":"SUM(G4)+SUM(F5)","v":10560},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",IF($A5=2,ECHEANCIER!$G$4,IF($A5=4,ECHEANCIER!$G$6,IF($A5=5,ECHEANCIER!$G$7,IF($A5=6,ECHEANCIER!$G$8,IF($A5=7,ECHEANCIER!$G$9,IF($A5=8,ECHEANCIER!$G$10,\"\")))))))","v":""},null,null," "]
[3,"10",{"$f":"IF($A6=1,ECHEANCIER!$D$3,IF($A6=3,ECHEANCIER!$D$3,IF($A9=4,ECHEANCIER!$D$4,IF($A9=5,ECHEANCIER!$D$4,IF($A9=6,ECHEANCIER!$D$4,IF($A9=7,ECHEANCIER!$D$4,IF($A9=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$3,IF($A6=2,ECHEANCIER!$E$4,IF($A6=4,ECHEANCIER!$E$6,IF($A6=5,ECHEANCIER!$E$7,IF($A6=6,ECHEANCIER!$E$8,IF($A6=7,ECHEANCIER!$E$9,IF($A6=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A6=\"\",\"\",IF($A6=1,ECHEANCIER!$F$3,IF($A6=3,ECHEANCIER!$F$3,IF($A6=2,ECHEANCIER!$F$4,IF($A6=4,ECHEANCIER!$F$6,IF($A6=5,ECHEANCIER!$F$7,IF($A6=6,ECHEANCIER!$F$8,IF($A6=7,ECHEANCIER!$F$9,IF($A6=8,ECHEANCIER!$F$10)))))))))","v":"RETRAITE"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$G$3,IF($A6=3,ECHEANCIER!$G$5,IF($A6<>\"RETRAITE\",\"\"))))","v":1200},{"$f":"SUM(G5)+SUM(F6)","v":11760},{"$f":"F6","v":1200},null,{"$f":"IF($A6=\"\",\"\",IF($A6=2,ECHEANCIER!$G$4,IF($A6=4,ECHEANCIER!$G$6,IF($A6=5,ECHEANCIER!$G$7,IF($A6=6,ECHEANCIER!$G$8,IF($A6=7,ECHEANCIER!$G$9,IF($A6=8,ECHEANCIER!$G$10,\"\")))))))","v":""}]
[2,"5",{"$f":"IF($A7=1,ECHEANCIER!$D$3,IF($A7=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$3,IF($A7=3,ECHEANCIER!$E$3,IF($A7=2,ECHEANCIER!$E$4,IF($A7=4,ECHEANCIER!$E$6,IF($A7=5,ECHEANCIER!$E$7,IF($A7=6,ECHEANCIER!$E$8,IF($A7=7,ECHEANCIER!$E$9,IF($A7=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"UNEO"},{"$f":"IF(A7=\"\",\"\",IF($A7=1,ECHEANCIER!$F$3,IF($A7=3,ECHEANCIER!$F$3,IF($A7=2,ECHEANCIER!$F$4,IF($A7=4,ECHEANCIER!$F$6,IF($A7=5,ECHEANCIER!$F$7,IF($A7=6,ECHEANCIER!$F$8,IF($A7=7,ECHEANCIER!$F$9,IF($A7=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"MUTUELLE"},{"$f":"IF($A7=\"\",\"\",IF($A7=2,ECHEANCIER!$G$4,IF($A7=4,ECHEANCIER!$G$6,IF($A7=5,ECHEANCIER!$G$7,IF($A7=6,ECHEANCIER!$G$8,IF($A7=7,ECHEANCIER!$G$9,IF($A7=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},11660,{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$G$3,IF($A7=3,ECHEANCIER!$G$5,IF($A7<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F7","v":-100}]
[4,"10",{"$f":"IF($A8=1,ECHEANCIER!$D$3,IF($A8=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$3,IF($A8=2,ECHEANCIER!$E$4,IF($A8=4,ECHEANCIER!$E$6,IF($A8=5,ECHEANCIER!$E$7,IF($A8=6,ECHEANCIER!$E$8,IF($A8=7,ECHEANCIER!$E$9,IF($A8=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"A.L.M."},{"$f":"IF(A8=\"\",\"\",IF($A8=1,ECHEANCIER!$F$3,IF($A8=3,ECHEANCIER!$F$3,IF($A8=2,ECHEANCIER!$F$4,IF($A8=4,ECHEANCIER!$F$6,IF($A8=5,ECHEANCIER!$F$7,IF($A8=6,ECHEANCIER!$F$8,IF($A8=7,ECHEANCIER!$F$9,IF($A8=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"EAUX"},{"$f":"IF($A8=\"\",\"\",IF($A8=2,ECHEANCIER!$G$4,IF($A8=4,ECHEANCIER!$G$6,IF($A8=5,ECHEANCIER!$G$7,IF($A8=6,ECHEANCIER!$G$8,IF($A8=7,ECHEANCIER!$G$9,IF($A8=8,ECHEANCIER!$G$10,\"\")))))))","v":-40},11620,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$G$3,IF($A8=3,ECHEANCIER!$G$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F8","v":-40}]
[5,"15",{"$f":"IF($A9=1,ECHEANCIER!$D$3,IF($A9=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$3,IF($A9=2,ECHEANCIER!$E$4,IF($A9=4,ECHEANCIER!$E$6,IF($A9=5,ECHEANCIER!$E$7,IF($A9=6,ECHEANCIER!$E$8,IF($A9=7,ECHEANCIER!$E$9,IF($A9=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A9=\"\",\"\",IF($A9=1,ECHEANCIER!$F$3,IF($A9=3,ECHEANCIER!$F$3,IF($A9=2,ECHEANCIER!$F$4,IF($A9=4,ECHEANCIER!$F$6,IF($A9=5,ECHEANCIER!$F$7,IF($A9=6,ECHEANCIER!$F$8,IF($A9=7,ECHEANCIER!$F$9,IF($A9=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.HABI"},{"$f":"IF($A9=\"\",\"\",IF($A9=2,ECHEANCIER!$G$4,IF($A9=4,ECHEANCIER!$G$6,IF($A9=5,ECHEANCIER!$G$7,IF($A9=6,ECHEANCIER!$G$8,IF($A9=7,ECHEANCIER!$G$9,IF($A9=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},11520,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$G$3,IF($A9=3,ECHEANCIER!$G$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,"15",{"$f":"IF($A10=1,ECHEANCIER!$D$3,IF($A10=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$3,IF($A10=2,ECHEANCIER!$E$4,IF($A10=4,ECHEANCIER!$E$6,IF($A10=5,ECHEANCIER!$E$7,IF($A10=6,ECHEANCIER!$E$8,IF($A10=7,ECHEANCIER!$E$9,IF($A10=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A10=\"\",\"\",IF($A10=1,ECHEANCIER!$F$3,IF($A10=3,ECHEANCIER!$F$3,IF($A10=2,ECHEANCIER!$F$4,IF($A10=4,ECHEANCIER!$F$6,IF($A10=5,ECHEANCIER!$F$7,IF($A10=6,ECHEANCIER!$F$8,IF($A10=7,ECHEANCIER!$F$9,IF($A10=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.FONC"},{"$f":"IF($A10=\"\",\"\",IF($A10=2,ECHEANCIER!$G$4,IF($A10=4,ECHEANCIER!$G$6,IF($A10=5,ECHEANCIER!$G$7,IF($A10=6,ECHEANCIER!$G$8,IF($A10=7,ECHEANCIER!$G$9,IF($A10=8,ECHEANCIER!$G$10,\"\")))))))","v":-110},11410,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$G$3,IF($A10=3,ECHEANCIER!$G$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,"15",{"$f":"IF($A11=1,ECHEANCIER!$D$3,IF($A11=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$3,IF($A11=2,ECHEANCIER!$E$4,IF($A11=4,ECHEANCIER!$E$6,IF($A11=5,ECHEANCIER!$E$7,IF($A11=6,ECHEANCIER!$E$8,IF($A11=7,ECHEANCIER!$E$9,IF($A11=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A11=\"\",\"\",IF($A11=1,ECHEANCIER!$F$3,IF($A11=3,ECHEANCIER!$F$3,IF($A11=2,ECHEANCIER!$F$4,IF($A11=4,ECHEANCIER!$F$6,IF($A11=5,ECHEANCIER!$F$7,IF($A11=6,ECHEANCIER!$F$8,IF($A11=7,ECHEANCIER!$F$9,IF($A11=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"IMP.REV"},{"$f":"IF($A11=\"\",\"\",IF($A11=2,ECHEANCIER!$G$4,IF($A11=4,ECHEANCIER!$G$6,IF($A11=5,ECHEANCIER!$G$7,IF($A11=6,ECHEANCIER!$G$8,IF($A11=7,ECHEANCIER!$G$9,IF($A11=8,ECHEANCIER!$G$10,\"\")))))))","v":-350},11060,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$G$3,IF($A11=3,ECHEANCIER!$G$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,"20",{"$f":"IF($A12=1,ECHEANCIER!$D$3,IF($A12=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4,IF($A12=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$3,IF($A12=2,ECHEANCIER!$E$4,IF($A12=4,ECHEANCIER!$E$6,IF($A12=5,ECHEANCIER!$E$7,IF($A12=6,ECHEANCIER!$E$8,IF($A12=7,ECHEANCIER!$E$9,IF($A12=8,ECHEANCIER!$E$10,IF($A12=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ENGIE"},{"$f":"IF(A12=\"\",\"\",IF($A12=1,ECHEANCIER!$F$3,IF($A12=3,ECHEANCIER!$F$3,IF($A12=2,ECHEANCIER!$F$4,IF($A12=4,ECHEANCIER!$F$6,IF($A12=5,ECHEANCIER!$F$7,IF($A12=6,ECHEANCIER!$F$8,IF($A12=7,ECHEANCIER!$F$9,IF($A12=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"GAZ-ELEC"},{"$f":"IF($A12=\"\",\"\",IF($A12=2,ECHEANCIER!$G$4,IF($A12=4,ECHEANCIER!$G$6,IF($A12=5,ECHEANCIER!$G$7,IF($A12=6,ECHEANCIER!$G$8,IF($A12=7,ECHEANCIER!$G$9,IF($A12=8,ECHEANCIER!$G$10,\"\")))))))","v":-120},10940,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$G$3,IF($A12=3,ECHEANCIER!$G$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"IF(A13=\"\",\"\",IF($A13=1,\"1\",IF($A13=2,\"5\",IF($A13=3,\"10\",IF($A13=4,\"10\",IF($A13=5,\"15\",IF($A13=6,\"15\",IF($A13=7,\"15\",IF($A13=8,\"20\",IF($A13=9,\"27\",\"\"))))))))))","v":"27"},{"$f":"IF($A13=1,ECHEANCIER!$D$3,IF($A13=3,ECHEANCIER!$D$3,IF($A13=4,ECHEANCIER!$D$4,IF($A13=5,ECHEANCIER!$D$4,IF($A13=6,ECHEANCIER!$D$4,IF($A13=7,ECHEANCIER!$D$4,IF($A13=8,ECHEANCIER!$D$4,IF($A13=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A13=\"\",\"\",IF($A13=1,ECHEANCIER!$E$3,IF($A13=3,ECHEANCIER!$E$3,IF($A13=2,ECHEANCIER!$E$4,IF($A13=4,ECHEANCIER!$E$6,IF($A13=5,ECHEANCIER!$E$7,IF($A13=6,ECHEANCIER!$E$8,IF($A13=7,ECHEANCIER!$E$9,IF($A13=8,ECHEANCIER!$E$10,IF($A13=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ST CHRIST"},{"$f":"+IF($A13=9,\"ass.voit\")","v":"ass.voit"},{"$f":"IF(AND($A13=9,$E13=\"ASS.VOIT\",OR($A$1=\"janvier\",$A$1=\"avril\",$A$1=\"juillet\",$A$1=\"octobre\")),ECHEANCIER!$G$11,\"\")","v":""},10940,null,null,"",{"$f":"IF($E13=\"C. PORT LOYER\",$F13,0)","v":0},{"$f":"IF($E13=\"C. PORT CHARGES\",$F13,0)","v":0},{"$f":"IF($E13=\"MOUVEMENTS\",$F13,0)","v":0}]
[null,null,null,null,null,null,10940,null,{"$f":"IF($E14=\"RECETTES DIVERSES\",$F14,0)","v":0},{"$f":"IF($E14=\"DEPENSES\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT LOYER\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT CHARGES\",$F14,0)","v":0},{"$f":"IF($E14=\"MOUVEMENTS\",$F14,0)","v":0}]
[null,null,null,null,null,null,10940,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,10940,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,10940,null,0,0,0,0,{"$f":"IF($E17=\"DIVERS\",$F17,0)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":10940},null,0,0,0,0,0]
[" "," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},10940,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,10940,null,0,{"$f":"F20","v":0},0,0,0]
[]
[]
[]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":1950},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":-820},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,null,{"$f":"H24+H4","v":5850},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-2465},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,{"$f":"G20","v":10940},{"$f":"SUM(H25:I25)","v":5890},null,{"$f":"J24+J4","v":-2465},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"AVRIL","index":5,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"AVRIL"}]
["N° SAISIE","JOURS","MODE","TIERS","CATEGORIE","BANQUE POSTALE",null,"RECETTES",null,"DEPENSES","C. PORT"," ","DIVERS"]
[null,null,"PAIEMENT",null,null,"DEBIT/CREDIT","SOLDE","RETRAITE","DIVERSES",null,"LOYER","CHARGES"," "]
["REPORT",null,null,null,null,null,{"$f":"MARS!G26","v":10940},{"$f":"MARS!H25","v":5850},{"$f":"MARS!I25","v":40},{"$f":"MARS!J25","v":-2465},{"$f":"MARS!K25","v":650},{"$f":"MARS!L25","v":-135},{"$f":"MARS!M25","v":-500}]
[1,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"1\",IF($A5=2,\"5\",IF($A5=3,\"10\",IF($A5=4,\"10\",IF($A5=5,\"15\",IF($A5=6,\"15\",IF($A5=7,\"15\",IF($A5=8,\"20\",\"\")))))))))","v":"1"},{"$f":"IF($A5=1,ECHEANCIER!$D$3,IF($A5=3,ECHEANCIER!$D$3,IF($A8=4,ECHEANCIER!$D$4,IF($A8=5,ECHEANCIER!$D$4,IF($A8=6,ECHEANCIER!$D$4,IF($A8=7,ECHEANCIER!$D$4,IF($A8=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$3,IF($A5=3,ECHEANCIER!$E$3,IF($A5=2,ECHEANCIER!$E$4,IF($A5=4,ECHEANCIER!$E$6,IF($A5=5,ECHEANCIER!$E$7,IF($A5=6,ECHEANCIER!$E$8,IF($A5=7,ECHEANCIER!$E$9,IF($A5=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A5=\"\",\"\",IF($A5=1,ECHEANCIER!$F$3,IF($A5=3,ECHEANCIER!$F$3,IF($A5=2,ECHEANCIER!$F$4,IF($A5=4,ECHEANCIER!$F$6,IF($A5=5,ECHEANCIER!$F$7,IF($A5=6,ECHEANCIER!$F$8,IF($A5=7,ECHEANCIER!$F$9,IF($A5=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"RETRAITE"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$G$3,IF($A5=3,ECHEANCIER!$G$5,IF($A5<>\"RETRAITE\",\"\"))))","v":750},{"$f":"SUM(G4)+SUM(F5)","v":11690},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",IF($A5=2,ECHEANCIER!$G$4,IF($A5=4,ECHEANCIER!$G$6,IF($A5=5,ECHEANCIER!$G$7,IF($A5=6,ECHEANCIER!$G$8,IF($A5=7,ECHEANCIER!$G$9,IF($A5=8,ECHEANCIER!$G$10,\"\")))))))","v":""},null,null," "]
[3,"10",{"$f":"IF($A6=1,ECHEANCIER!$D$3,IF($A6=3,ECHEANCIER!$D$3,IF($A9=4,ECHEANCIER!$D$4,IF($A9=5,ECHEANCIER!$D$4,IF($A9=6,ECHEANCIER!$D$4,IF($A9=7,ECHEANCIER!$D$4,IF($A9=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$3,IF($A6=2,ECHEANCIER!$E$4,IF($A6=4,ECHEANCIER!$E$6,IF($A6=5,ECHEANCIER!$E$7,IF($A6=6,ECHEANCIER!$E$8,IF($A6=7,ECHEANCIER!$E$9,IF($A6=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A6=\"\",\"\",IF($A6=1,ECHEANCIER!$F$3,IF($A6=3,ECHEANCIER!$F$3,IF($A6=2,ECHEANCIER!$F$4,IF($A6=4,ECHEANCIER!$F$6,IF($A6=5,ECHEANCIER!$F$7,IF($A6=6,ECHEANCIER!$F$8,IF($A6=7,ECHEANCIER!$F$9,IF($A6=8,ECHEANCIER!$F$10)))))))))","v":"RETRAITE"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$G$3,IF($A6=3,ECHEANCIER!$G$5,IF($A6<>\"RETRAITE\",\"\"))))","v":1200},{"$f":"SUM(G5)+SUM(F6)","v":12890},{"$f":"F6","v":1200},null,{"$f":"IF($A6=\"\",\"\",IF($A6=2,ECHEANCIER!$G$4,IF($A6=4,ECHEANCIER!$G$6,IF($A6=5,ECHEANCIER!$G$7,IF($A6=6,ECHEANCIER!$G$8,IF($A6=7,ECHEANCIER!$G$9,IF($A6=8,ECHEANCIER!$G$10,\"\")))))))","v":""}]
[2,"5",{"$f":"IF($A7=1,ECHEANCIER!$D$3,IF($A7=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$3,IF($A7=3,ECHEANCIER!$E$3,IF($A7=2,ECHEANCIER!$E$4,IF($A7=4,ECHEANCIER!$E$6,IF($A7=5,ECHEANCIER!$E$7,IF($A7=6,ECHEANCIER!$E$8,IF($A7=7,ECHEANCIER!$E$9,IF($A7=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"UNEO"},{"$f":"IF(A7=\"\",\"\",IF($A7=1,ECHEANCIER!$F$3,IF($A7=3,ECHEANCIER!$F$3,IF($A7=2,ECHEANCIER!$F$4,IF($A7=4,ECHEANCIER!$F$6,IF($A7=5,ECHEANCIER!$F$7,IF($A7=6,ECHEANCIER!$F$8,IF($A7=7,ECHEANCIER!$F$9,IF($A7=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"MUTUELLE"},{"$f":"IF($A7=\"\",\"\",IF($A7=2,ECHEANCIER!$G$4,IF($A7=4,ECHEANCIER!$G$6,IF($A7=5,ECHEANCIER!$G$7,IF($A7=6,ECHEANCIER!$G$8,IF($A7=7,ECHEANCIER!$G$9,IF($A7=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},12790,{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$G$3,IF($A7=3,ECHEANCIER!$G$5,IF($A7<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F7","v":-100}]
[4,"10",{"$f":"IF($A8=1,ECHEANCIER!$D$3,IF($A8=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$3,IF($A8=2,ECHEANCIER!$E$4,IF($A8=4,ECHEANCIER!$E$6,IF($A8=5,ECHEANCIER!$E$7,IF($A8=6,ECHEANCIER!$E$8,IF($A8=7,ECHEANCIER!$E$9,IF($A8=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"A.L.M."},{"$f":"IF(A8=\"\",\"\",IF($A8=1,ECHEANCIER!$F$3,IF($A8=3,ECHEANCIER!$F$3,IF($A8=2,ECHEANCIER!$F$4,IF($A8=4,ECHEANCIER!$F$6,IF($A8=5,ECHEANCIER!$F$7,IF($A8=6,ECHEANCIER!$F$8,IF($A8=7,ECHEANCIER!$F$9,IF($A8=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"EAUX"},{"$f":"IF($A8=\"\",\"\",IF($A8=2,ECHEANCIER!$G$4,IF($A8=4,ECHEANCIER!$G$6,IF($A8=5,ECHEANCIER!$G$7,IF($A8=6,ECHEANCIER!$G$8,IF($A8=7,ECHEANCIER!$G$9,IF($A8=8,ECHEANCIER!$G$10,\"\")))))))","v":-40},12750,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$G$3,IF($A8=3,ECHEANCIER!$G$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F8","v":-40}]
[5,"15",{"$f":"IF($A9=1,ECHEANCIER!$D$3,IF($A9=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$3,IF($A9=2,ECHEANCIER!$E$4,IF($A9=4,ECHEANCIER!$E$6,IF($A9=5,ECHEANCIER!$E$7,IF($A9=6,ECHEANCIER!$E$8,IF($A9=7,ECHEANCIER!$E$9,IF($A9=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A9=\"\",\"\",IF($A9=1,ECHEANCIER!$F$3,IF($A9=3,ECHEANCIER!$F$3,IF($A9=2,ECHEANCIER!$F$4,IF($A9=4,ECHEANCIER!$F$6,IF($A9=5,ECHEANCIER!$F$7,IF($A9=6,ECHEANCIER!$F$8,IF($A9=7,ECHEANCIER!$F$9,IF($A9=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.HABI"},{"$f":"IF($A9=\"\",\"\",IF($A9=2,ECHEANCIER!$G$4,IF($A9=4,ECHEANCIER!$G$6,IF($A9=5,ECHEANCIER!$G$7,IF($A9=6,ECHEANCIER!$G$8,IF($A9=7,ECHEANCIER!$G$9,IF($A9=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},12650,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$G$3,IF($A9=3,ECHEANCIER!$G$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,"15",{"$f":"IF($A10=1,ECHEANCIER!$D$3,IF($A10=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$3,IF($A10=2,ECHEANCIER!$E$4,IF($A10=4,ECHEANCIER!$E$6,IF($A10=5,ECHEANCIER!$E$7,IF($A10=6,ECHEANCIER!$E$8,IF($A10=7,ECHEANCIER!$E$9,IF($A10=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A10=\"\",\"\",IF($A10=1,ECHEANCIER!$F$3,IF($A10=3,ECHEANCIER!$F$3,IF($A10=2,ECHEANCIER!$F$4,IF($A10=4,ECHEANCIER!$F$6,IF($A10=5,ECHEANCIER!$F$7,IF($A10=6,ECHEANCIER!$F$8,IF($A10=7,ECHEANCIER!$F$9,IF($A10=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.FONC"},{"$f":"IF($A10=\"\",\"\",IF($A10=2,ECHEANCIER!$G$4,IF($A10=4,ECHEANCIER!$G$6,IF($A10=5,ECHEANCIER!$G$7,IF($A10=6,ECHEANCIER!$G$8,IF($A10=7,ECHEANCIER!$G$9,IF($A10=8,ECHEANCIER!$G$10,\"\")))))))","v":-110},12540,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$G$3,IF($A10=3,ECHEANCIER!$G$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,"15",{"$f":"IF($A11=1,ECHEANCIER!$D$3,IF($A11=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$3,IF($A11=2,ECHEANCIER!$E$4,IF($A11=4,ECHEANCIER!$E$6,IF($A11=5,ECHEANCIER!$E$7,IF($A11=6,ECHEANCIER!$E$8,IF($A11=7,ECHEANCIER!$E$9,IF($A11=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A11=\"\",\"\",IF($A11=1,ECHEANCIER!$F$3,IF($A11=3,ECHEANCIER!$F$3,IF($A11=2,ECHEANCIER!$F$4,IF($A11=4,ECHEANCIER!$F$6,IF($A11=5,ECHEANCIER!$F$7,IF($A11=6,ECHEANCIER!$F$8,IF($A11=7,ECHEANCIER!$F$9,IF($A11=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"IMP.REV"},{"$f":"IF($A11=\"\",\"\",IF($A11=2,ECHEANCIER!$G$4,IF($A11=4,ECHEANCIER!$G$6,IF($A11=5,ECHEANCIER!$G$7,IF($A11=6,ECHEANCIER!$G$8,IF($A11=7,ECHEANCIER!$G$9,IF($A11=8,ECHEANCIER!$G$10,\"\")))))))","v":-350},12190,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$G$3,IF($A11=3,ECHEANCIER!$G$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,"20",{"$f":"IF($A12=1,ECHEANCIER!$D$3,IF($A12=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4,IF($A12=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$3,IF($A12=2,ECHEANCIER!$E$4,IF($A12=4,ECHEANCIER!$E$6,IF($A12=5,ECHEANCIER!$E$7,IF($A12=6,ECHEANCIER!$E$8,IF($A12=7,ECHEANCIER!$E$9,IF($A12=8,ECHEANCIER!$E$10,IF($A12=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ENGIE"},{"$f":"IF(A12=\"\",\"\",IF($A12=1,ECHEANCIER!$F$3,IF($A12=3,ECHEANCIER!$F$3,IF($A12=2,ECHEANCIER!$F$4,IF($A12=4,ECHEANCIER!$F$6,IF($A12=5,ECHEANCIER!$F$7,IF($A12=6,ECHEANCIER!$F$8,IF($A12=7,ECHEANCIER!$F$9,IF($A12=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"GAZ-ELEC"},{"$f":"IF($A12=\"\",\"\",IF($A12=2,ECHEANCIER!$G$4,IF($A12=4,ECHEANCIER!$G$6,IF($A12=5,ECHEANCIER!$G$7,IF($A12=6,ECHEANCIER!$G$8,IF($A12=7,ECHEANCIER!$G$9,IF($A12=8,ECHEANCIER!$G$10,\"\")))))))","v":-120},12070,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$G$3,IF($A12=3,ECHEANCIER!$G$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"IF(A13=\"\",\"\",IF($A13=1,\"1\",IF($A13=2,\"5\",IF($A13=3,\"10\",IF($A13=4,\"10\",IF($A13=5,\"15\",IF($A13=6,\"15\",IF($A13=7,\"15\",IF($A13=8,\"20\",IF($A13=9,\"27\",\"\"))))))))))","v":"27"},{"$f":"IF($A13=1,ECHEANCIER!$D$3,IF($A13=3,ECHEANCIER!$D$3,IF($A13=4,ECHEANCIER!$D$4,IF($A13=5,ECHEANCIER!$D$4,IF($A13=6,ECHEANCIER!$D$4,IF($A13=7,ECHEANCIER!$D$4,IF($A13=8,ECHEANCIER!$D$4,IF($A13=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A13=\"\",\"\",IF($A13=1,ECHEANCIER!$E$3,IF($A13=3,ECHEANCIER!$E$3,IF($A13=2,ECHEANCIER!$E$4,IF($A13=4,ECHEANCIER!$E$6,IF($A13=5,ECHEANCIER!$E$7,IF($A13=6,ECHEANCIER!$E$8,IF($A13=7,ECHEANCIER!$E$9,IF($A13=8,ECHEANCIER!$E$10,IF($A13=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ST CHRIST"},{"$f":"+IF($A13=9,\"ass.voit\")","v":"ass.voit"},{"$f":"IF(AND($A13=9,$E13=\"ASS.VOIT\",OR($A$1=\"janvier\",$A$1=\"avril\",$A$1=\"juillet\",$A$1=\"octobre\")),ECHEANCIER!$G$11,\"\")","v":-95},11975,null,null,-95,{"$f":"IF($E13=\"C. PORT LOYER\",$F13,0)","v":0},{"$f":"IF($E13=\"C. PORT CHARGES\",$F13,0)","v":0},{"$f":"IF($E13=\"MOUVEMENTS\",$F13,0)","v":0}]
[null,null,null,null,null,null,11975,null,{"$f":"IF($E14=\"RECETTES DIVERSES\",$F14,0)","v":0},{"$f":"IF($E14=\"DEPENSES\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT LOYER\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT CHARGES\",$F14,0)","v":0},{"$f":"IF($E14=\"MOUVEMENTS\",$F14,0)","v":0}]
[null,null,null,null,null,null,11975,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,11975,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,11975,null,0,0,0,0,{"$f":"IF($E17=\"DIVERS\",$F17,0)","v":0}]
[" ",null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":11975},null,0,0,0,0,0]
[" "," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},11975,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,11975,null,0,{"$f":"F20","v":0},0,0,0]
[]
[]
[]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":1950},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":-915},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,null,{"$f":"H24+H4","v":7800},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-3380},650,{"$f":"L24+L4","v":-135},{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,{"$f":"G20","v":11975},{"$f":"SUM(H25:I25)","v":7840},null,{"$f":"J24+J4","v":-3380},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"MAI","index":6,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"MAI"}]
["N° SAISIE","JOURS","MODE","TIERS","CATEGORIE","BANQUE POSTALE",null,"RECETTES",null,"DEPENSES","C. PORT"," ","DIVERS"]
[null,null,"PAIEMENT",null,null,"DEBIT/CREDIT","SOLDE","RETRAITE","DIVERSES",null,"LOYER","CHARGES"," "]
["REPORT",null,null,null,null,null,{"$f":"AVRIL!G26","v":11975},{"$f":"AVRIL!H25","v":7800},{"$f":"AVRIL!I25","v":40},{"$f":"AVRIL!J25","v":-3380},{"$f":"AVRIL!K25","v":650},{"$f":"AVRIL!L25","v":-135},{"$f":"AVRIL!M25","v":-500}]
[1,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"1\",IF($A5=2,\"5\",IF($A5=3,\"10\",IF($A5=4,\"10\",IF($A5=5,\"15\",IF($A5=6,\"15\",IF($A5=7,\"15\",IF($A5=8,\"20\",\"\")))))))))","v":"1"},{"$f":"IF($A5=1,ECHEANCIER!$D$3,IF($A5=3,ECHEANCIER!$D$3,IF($A8=4,ECHEANCIER!$D$4,IF($A8=5,ECHEANCIER!$D$4,IF($A8=6,ECHEANCIER!$D$4,IF($A8=7,ECHEANCIER!$D$4,IF($A8=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$3,IF($A5=3,ECHEANCIER!$E$3,IF($A5=2,ECHEANCIER!$E$4,IF($A5=4,ECHEANCIER!$E$6,IF($A5=5,ECHEANCIER!$E$7,IF($A5=6,ECHEANCIER!$E$8,IF($A5=7,ECHEANCIER!$E$9,IF($A5=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A5=\"\",\"\",IF($A5=1,ECHEANCIER!$F$3,IF($A5=3,ECHEANCIER!$F$3,IF($A5=2,ECHEANCIER!$F$4,IF($A5=4,ECHEANCIER!$F$6,IF($A5=5,ECHEANCIER!$F$7,IF($A5=6,ECHEANCIER!$F$8,IF($A5=7,ECHEANCIER!$F$9,IF($A5=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"RETRAITE"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$G$3,IF($A5=3,ECHEANCIER!$G$5,IF($A5<>\"RETRAITE\",\"\"))))","v":750},{"$f":"SUM(G4)+SUM(F5)","v":12725},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",IF($A5=2,ECHEANCIER!$G$4,IF($A5=4,ECHEANCIER!$G$6,IF($A5=5,ECHEANCIER!$G$7,IF($A5=6,ECHEANCIER!$G$8,IF($A5=7,ECHEANCIER!$G$9,IF($A5=8,ECHEANCIER!$G$10,\"\")))))))","v":""},null,null," "]
[3,"10",{"$f":"IF($A6=1,ECHEANCIER!$D$3,IF($A6=3,ECHEANCIER!$D$3,IF($A9=4,ECHEANCIER!$D$4,IF($A9=5,ECHEANCIER!$D$4,IF($A9=6,ECHEANCIER!$D$4,IF($A9=7,ECHEANCIER!$D$4,IF($A9=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$3,IF($A6=2,ECHEANCIER!$E$4,IF($A6=4,ECHEANCIER!$E$6,IF($A6=5,ECHEANCIER!$E$7,IF($A6=6,ECHEANCIER!$E$8,IF($A6=7,ECHEANCIER!$E$9,IF($A6=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A6=\"\",\"\",IF($A6=1,ECHEANCIER!$F$3,IF($A6=3,ECHEANCIER!$F$3,IF($A6=2,ECHEANCIER!$F$4,IF($A6=4,ECHEANCIER!$F$6,IF($A6=5,ECHEANCIER!$F$7,IF($A6=6,ECHEANCIER!$F$8,IF($A6=7,ECHEANCIER!$F$9,IF($A6=8,ECHEANCIER!$F$10)))))))))","v":"RETRAITE"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$G$3,IF($A6=3,ECHEANCIER!$G$5,IF($A6<>\"RETRAITE\",\"\"))))","v":1200},{"$f":"SUM(G5)+SUM(F6)","v":13925},{"$f":"F6","v":1200},null,{"$f":"IF($A6=\"\",\"\",IF($A6=2,ECHEANCIER!$G$4,IF($A6=4,ECHEANCIER!$G$6,IF($A6=5,ECHEANCIER!$G$7,IF($A6=6,ECHEANCIER!$G$8,IF($A6=7,ECHEANCIER!$G$9,IF($A6=8,ECHEANCIER!$G$10,\"\")))))))","v":""}]
[2,"5",{"$f":"IF($A7=1,ECHEANCIER!$D$3,IF($A7=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$3,IF($A7=3,ECHEANCIER!$E$3,IF($A7=2,ECHEANCIER!$E$4,IF($A7=4,ECHEANCIER!$E$6,IF($A7=5,ECHEANCIER!$E$7,IF($A7=6,ECHEANCIER!$E$8,IF($A7=7,ECHEANCIER!$E$9,IF($A7=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"UNEO"},{"$f":"IF(A7=\"\",\"\",IF($A7=1,ECHEANCIER!$F$3,IF($A7=3,ECHEANCIER!$F$3,IF($A7=2,ECHEANCIER!$F$4,IF($A7=4,ECHEANCIER!$F$6,IF($A7=5,ECHEANCIER!$F$7,IF($A7=6,ECHEANCIER!$F$8,IF($A7=7,ECHEANCIER!$F$9,IF($A7=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"MUTUELLE"},{"$f":"IF($A7=\"\",\"\",IF($A7=2,ECHEANCIER!$G$4,IF($A7=4,ECHEANCIER!$G$6,IF($A7=5,ECHEANCIER!$G$7,IF($A7=6,ECHEANCIER!$G$8,IF($A7=7,ECHEANCIER!$G$9,IF($A7=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},13825,{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$G$3,IF($A7=3,ECHEANCIER!$G$5,IF($A7<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F7","v":-100}]
[4,"10",{"$f":"IF($A8=1,ECHEANCIER!$D$3,IF($A8=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$3,IF($A8=2,ECHEANCIER!$E$4,IF($A8=4,ECHEANCIER!$E$6,IF($A8=5,ECHEANCIER!$E$7,IF($A8=6,ECHEANCIER!$E$8,IF($A8=7,ECHEANCIER!$E$9,IF($A8=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"A.L.M."},{"$f":"IF(A8=\"\",\"\",IF($A8=1,ECHEANCIER!$F$3,IF($A8=3,ECHEANCIER!$F$3,IF($A8=2,ECHEANCIER!$F$4,IF($A8=4,ECHEANCIER!$F$6,IF($A8=5,ECHEANCIER!$F$7,IF($A8=6,ECHEANCIER!$F$8,IF($A8=7,ECHEANCIER!$F$9,IF($A8=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"EAUX"},{"$f":"IF($A8=\"\",\"\",IF($A8=2,ECHEANCIER!$G$4,IF($A8=4,ECHEANCIER!$G$6,IF($A8=5,ECHEANCIER!$G$7,IF($A8=6,ECHEANCIER!$G$8,IF($A8=7,ECHEANCIER!$G$9,IF($A8=8,ECHEANCIER!$G$10,\"\")))))))","v":-40},13785,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$G$3,IF($A8=3,ECHEANCIER!$G$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F8","v":-40}]
[5,"15",{"$f":"IF($A9=1,ECHEANCIER!$D$3,IF($A9=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$3,IF($A9=2,ECHEANCIER!$E$4,IF($A9=4,ECHEANCIER!$E$6,IF($A9=5,ECHEANCIER!$E$7,IF($A9=6,ECHEANCIER!$E$8,IF($A9=7,ECHEANCIER!$E$9,IF($A9=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A9=\"\",\"\",IF($A9=1,ECHEANCIER!$F$3,IF($A9=3,ECHEANCIER!$F$3,IF($A9=2,ECHEANCIER!$F$4,IF($A9=4,ECHEANCIER!$F$6,IF($A9=5,ECHEANCIER!$F$7,IF($A9=6,ECHEANCIER!$F$8,IF($A9=7,ECHEANCIER!$F$9,IF($A9=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.HABI"},{"$f":"IF($A9=\"\",\"\",IF($A9=2,ECHEANCIER!$G$4,IF($A9=4,ECHEANCIER!$G$6,IF($A9=5,ECHEANCIER!$G$7,IF($A9=6,ECHEANCIER!$G$8,IF($A9=7,ECHEANCIER!$G$9,IF($A9=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},13685,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$G$3,IF($A9=3,ECHEANCIER!$G$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,"15",{"$f":"IF($A10=1,ECHEANCIER!$D$3,IF($A10=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$3,IF($A10=2,ECHEANCIER!$E$4,IF($A10=4,ECHEANCIER!$E$6,IF($A10=5,ECHEANCIER!$E$7,IF($A10=6,ECHEANCIER!$E$8,IF($A10=7,ECHEANCIER!$E$9,IF($A10=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A10=\"\",\"\",IF($A10=1,ECHEANCIER!$F$3,IF($A10=3,ECHEANCIER!$F$3,IF($A10=2,ECHEANCIER!$F$4,IF($A10=4,ECHEANCIER!$F$6,IF($A10=5,ECHEANCIER!$F$7,IF($A10=6,ECHEANCIER!$F$8,IF($A10=7,ECHEANCIER!$F$9,IF($A10=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.FONC"},{"$f":"IF($A10=\"\",\"\",IF($A10=2,ECHEANCIER!$G$4,IF($A10=4,ECHEANCIER!$G$6,IF($A10=5,ECHEANCIER!$G$7,IF($A10=6,ECHEANCIER!$G$8,IF($A10=7,ECHEANCIER!$G$9,IF($A10=8,ECHEANCIER!$G$10,\"\")))))))","v":-110},13575,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$G$3,IF($A10=3,ECHEANCIER!$G$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,"15",{"$f":"IF($A11=1,ECHEANCIER!$D$3,IF($A11=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$3,IF($A11=2,ECHEANCIER!$E$4,IF($A11=4,ECHEANCIER!$E$6,IF($A11=5,ECHEANCIER!$E$7,IF($A11=6,ECHEANCIER!$E$8,IF($A11=7,ECHEANCIER!$E$9,IF($A11=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A11=\"\",\"\",IF($A11=1,ECHEANCIER!$F$3,IF($A11=3,ECHEANCIER!$F$3,IF($A11=2,ECHEANCIER!$F$4,IF($A11=4,ECHEANCIER!$F$6,IF($A11=5,ECHEANCIER!$F$7,IF($A11=6,ECHEANCIER!$F$8,IF($A11=7,ECHEANCIER!$F$9,IF($A11=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"IMP.REV"},{"$f":"IF($A11=\"\",\"\",IF($A11=2,ECHEANCIER!$G$4,IF($A11=4,ECHEANCIER!$G$6,IF($A11=5,ECHEANCIER!$G$7,IF($A11=6,ECHEANCIER!$G$8,IF($A11=7,ECHEANCIER!$G$9,IF($A11=8,ECHEANCIER!$G$10,\"\")))))))","v":-350},13225,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$G$3,IF($A11=3,ECHEANCIER!$G$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,"20",{"$f":"IF($A12=1,ECHEANCIER!$D$3,IF($A12=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4,IF($A12=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$3,IF($A12=2,ECHEANCIER!$E$4,IF($A12=4,ECHEANCIER!$E$6,IF($A12=5,ECHEANCIER!$E$7,IF($A12=6,ECHEANCIER!$E$8,IF($A12=7,ECHEANCIER!$E$9,IF($A12=8,ECHEANCIER!$E$10,IF($A12=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ENGIE"},{"$f":"IF(A12=\"\",\"\",IF($A12=1,ECHEANCIER!$F$3,IF($A12=3,ECHEANCIER!$F$3,IF($A12=2,ECHEANCIER!$F$4,IF($A12=4,ECHEANCIER!$F$6,IF($A12=5,ECHEANCIER!$F$7,IF($A12=6,ECHEANCIER!$F$8,IF($A12=7,ECHEANCIER!$F$9,IF($A12=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"GAZ-ELEC"},{"$f":"IF($A12=\"\",\"\",IF($A12=2,ECHEANCIER!$G$4,IF($A12=4,ECHEANCIER!$G$6,IF($A12=5,ECHEANCIER!$G$7,IF($A12=6,ECHEANCIER!$G$8,IF($A12=7,ECHEANCIER!$G$9,IF($A12=8,ECHEANCIER!$G$10,\"\")))))))","v":-120},13105,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$G$3,IF($A12=3,ECHEANCIER!$G$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"IF(A13=\"\",\"\",IF($A13=1,\"1\",IF($A13=2,\"5\",IF($A13=3,\"10\",IF($A13=4,\"10\",IF($A13=5,\"15\",IF($A13=6,\"15\",IF($A13=7,\"15\",IF($A13=8,\"20\",IF($A13=9,\"27\",\"\"))))))))))","v":"27"},{"$f":"IF($A13=1,ECHEANCIER!$D$3,IF($A13=3,ECHEANCIER!$D$3,IF($A13=4,ECHEANCIER!$D$4,IF($A13=5,ECHEANCIER!$D$4,IF($A13=6,ECHEANCIER!$D$4,IF($A13=7,ECHEANCIER!$D$4,IF($A13=8,ECHEANCIER!$D$4,IF($A13=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A13=\"\",\"\",IF($A13=1,ECHEANCIER!$E$3,IF($A13=3,ECHEANCIER!$E$3,IF($A13=2,ECHEANCIER!$E$4,IF($A13=4,ECHEANCIER!$E$6,IF($A13=5,ECHEANCIER!$E$7,IF($A13=6,ECHEANCIER!$E$8,IF($A13=7,ECHEANCIER!$E$9,IF($A13=8,ECHEANCIER!$E$10,IF($A13=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ST CHRIST"},{"$f":"+IF($A13=9,\"ass.voit\")","v":"ass.voit"},{"$f":"IF(AND($A13=9,$E13=\"ASS.VOIT\",OR($A$1=\"janvier\",$A$1=\"avril\",$A$1=\"juillet\",$A$1=\"octobre\")),ECHEANCIER!$G$11,\"\")","v":""},13105,null,null,"",{"$f":"IF($E13=\"C. PORT LOYER\",$F13,0)","v":0},{"$f":"IF($E13=\"C. PORT CHARGES\",$F13,0)","v":0},{"$f":"IF($E13=\"MOUVEMENTS\",$F13,0)","v":0}]
[null,null,null,null,null,null,13105,null,{"$f":"IF($E14=\"RECETTES DIVERSES\",$F14,0)","v":0},{"$f":"IF($E14=\"DEPENSES\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT LOYER\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT CHARGES\",$F14,0)","v":0},{"$f":"IF($E14=\"MOUVEMENTS\",$F14,0)","v":0}]
[null,null,null,null,null,null,13105,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13105,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13105,null,0,0,0,0,{"$f":"IF($E17=\"DIVERS\",$F17,0)","v":0}]
[" ",null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":13105},null,0,0,0,0,0]
[" "," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},13105,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13105,null,0,{"$f":"F20","v":0},0,0,0]
[]
[]
[]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":1950},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":-820},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,null,{"$f":"H24+H4","v":9750},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-4200},650,{"$f":"L24+L4","v":-135},-500]
["TOTAL",null,null,null,null,null,{"$f":"G20","v":13105},{"$f":"SUM(H25:I25)","v":9790},null,{"$f":"J24+J4","v":-4200},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"JUIN","index":7,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"JUIN"}]
["N° SAISIE","JOURS","MODE","TIERS","CATEGORIE","BANQUE POSTALE",null,"RECETTES",null,"DEPENSES","C. PORT"," ","DIVERS"]
[null,null,"PAIEMENT",null,null,"DEBIT/CREDIT","SOLDE","RETRAITE","DIVERSES",null,"LOYER","CHARGES"," "]
["REPORT",null,null,null,null,null,{"$f":"AVRIL!G26","v":11975},{"$f":"AVRIL!H25","v":7800},{"$f":"AVRIL!I25","v":40},{"$f":"AVRIL!J25","v":-3380},{"$f":"AVRIL!K25","v":650},{"$f":"AVRIL!L25","v":-135},{"$f":"AVRIL!M25","v":-500}]
[1,{"$f":"IF(A5=\"\",\"\",IF($A5=1,\"1\",IF($A5=2,\"5\",IF($A5=3,\"10\",IF($A5=4,\"10\",IF($A5=5,\"15\",IF($A5=6,\"15\",IF($A5=7,\"15\",IF($A5=8,\"20\",\"\")))))))))","v":"1"},{"$f":"IF($A5=1,ECHEANCIER!$D$3,IF($A5=3,ECHEANCIER!$D$3,IF($A8=4,ECHEANCIER!$D$4,IF($A8=5,ECHEANCIER!$D$4,IF($A8=6,ECHEANCIER!$D$4,IF($A8=7,ECHEANCIER!$D$4,IF($A8=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$E$3,IF($A5=3,ECHEANCIER!$E$3,IF($A5=2,ECHEANCIER!$E$4,IF($A5=4,ECHEANCIER!$E$6,IF($A5=5,ECHEANCIER!$E$7,IF($A5=6,ECHEANCIER!$E$8,IF($A5=7,ECHEANCIER!$E$9,IF($A5=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A5=\"\",\"\",IF($A5=1,ECHEANCIER!$F$3,IF($A5=3,ECHEANCIER!$F$3,IF($A5=2,ECHEANCIER!$F$4,IF($A5=4,ECHEANCIER!$F$6,IF($A5=5,ECHEANCIER!$F$7,IF($A5=6,ECHEANCIER!$F$8,IF($A5=7,ECHEANCIER!$F$9,IF($A5=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"RETRAITE"},{"$f":"IF($A5=\"\",\"\",IF($A5=1,ECHEANCIER!$G$3,IF($A5=3,ECHEANCIER!$G$5,IF($A5<>\"RETRAITE\",\"\"))))","v":750},{"$f":"SUM(G4)+SUM(F5)","v":12725},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",IF($A5=2,ECHEANCIER!$G$4,IF($A5=4,ECHEANCIER!$G$6,IF($A5=5,ECHEANCIER!$G$7,IF($A5=6,ECHEANCIER!$G$8,IF($A5=7,ECHEANCIER!$G$9,IF($A5=8,ECHEANCIER!$G$10,\"\")))))))","v":""},null,null," "]
[3,"10",{"$f":"IF($A6=1,ECHEANCIER!$D$3,IF($A6=3,ECHEANCIER!$D$3,IF($A9=4,ECHEANCIER!$D$4,IF($A9=5,ECHEANCIER!$D$4,IF($A9=6,ECHEANCIER!$D$4,IF($A9=7,ECHEANCIER!$D$4,IF($A9=8,ECHEANCIER!$D$4)))))))","v":"Vir recu"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$3,IF($A6=2,ECHEANCIER!$E$4,IF($A6=4,ECHEANCIER!$E$6,IF($A6=5,ECHEANCIER!$E$7,IF($A6=6,ECHEANCIER!$E$8,IF($A6=7,ECHEANCIER!$E$9,IF($A6=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"ARCO"},{"$f":"IF(A6=\"\",\"\",IF($A6=1,ECHEANCIER!$F$3,IF($A6=3,ECHEANCIER!$F$3,IF($A6=2,ECHEANCIER!$F$4,IF($A6=4,ECHEANCIER!$F$6,IF($A6=5,ECHEANCIER!$F$7,IF($A6=6,ECHEANCIER!$F$8,IF($A6=7,ECHEANCIER!$F$9,IF($A6=8,ECHEANCIER!$F$10)))))))))","v":"RETRAITE"},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$G$3,IF($A6=3,ECHEANCIER!$G$5,IF($A6<>\"RETRAITE\",\"\"))))","v":1200},{"$f":"SUM(G5)+SUM(F6)","v":13925},{"$f":"F6","v":1200},null,{"$f":"IF($A6=\"\",\"\",IF($A6=2,ECHEANCIER!$G$4,IF($A6=4,ECHEANCIER!$G$6,IF($A6=5,ECHEANCIER!$G$7,IF($A6=6,ECHEANCIER!$G$8,IF($A6=7,ECHEANCIER!$G$9,IF($A6=8,ECHEANCIER!$G$10,\"\")))))))","v":""}]
[2,"5",{"$f":"IF($A7=1,ECHEANCIER!$D$3,IF($A7=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$E$3,IF($A7=3,ECHEANCIER!$E$3,IF($A7=2,ECHEANCIER!$E$4,IF($A7=4,ECHEANCIER!$E$6,IF($A7=5,ECHEANCIER!$E$7,IF($A7=6,ECHEANCIER!$E$8,IF($A7=7,ECHEANCIER!$E$9,IF($A7=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"UNEO"},{"$f":"IF(A7=\"\",\"\",IF($A7=1,ECHEANCIER!$F$3,IF($A7=3,ECHEANCIER!$F$3,IF($A7=2,ECHEANCIER!$F$4,IF($A7=4,ECHEANCIER!$F$6,IF($A7=5,ECHEANCIER!$F$7,IF($A7=6,ECHEANCIER!$F$8,IF($A7=7,ECHEANCIER!$F$9,IF($A7=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"MUTUELLE"},{"$f":"IF($A7=\"\",\"\",IF($A7=2,ECHEANCIER!$G$4,IF($A7=4,ECHEANCIER!$G$6,IF($A7=5,ECHEANCIER!$G$7,IF($A7=6,ECHEANCIER!$G$8,IF($A7=7,ECHEANCIER!$G$9,IF($A7=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},13825,{"$f":"IF($A7=\"\",\"\",IF($A7=1,ECHEANCIER!$G$3,IF($A7=3,ECHEANCIER!$G$5,IF($A7<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F7","v":-100}]
[4,"10",{"$f":"IF($A8=1,ECHEANCIER!$D$3,IF($A8=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$3,IF($A8=2,ECHEANCIER!$E$4,IF($A8=4,ECHEANCIER!$E$6,IF($A8=5,ECHEANCIER!$E$7,IF($A8=6,ECHEANCIER!$E$8,IF($A8=7,ECHEANCIER!$E$9,IF($A8=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"A.L.M."},{"$f":"IF(A8=\"\",\"\",IF($A8=1,ECHEANCIER!$F$3,IF($A8=3,ECHEANCIER!$F$3,IF($A8=2,ECHEANCIER!$F$4,IF($A8=4,ECHEANCIER!$F$6,IF($A8=5,ECHEANCIER!$F$7,IF($A8=6,ECHEANCIER!$F$8,IF($A8=7,ECHEANCIER!$F$9,IF($A8=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"EAUX"},{"$f":"IF($A8=\"\",\"\",IF($A8=2,ECHEANCIER!$G$4,IF($A8=4,ECHEANCIER!$G$6,IF($A8=5,ECHEANCIER!$G$7,IF($A8=6,ECHEANCIER!$G$8,IF($A8=7,ECHEANCIER!$G$9,IF($A8=8,ECHEANCIER!$G$10,\"\")))))))","v":-40},13785,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$G$3,IF($A8=3,ECHEANCIER!$G$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F8","v":-40}]
[5,"15",{"$f":"IF($A9=1,ECHEANCIER!$D$3,IF($A9=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$3,IF($A9=2,ECHEANCIER!$E$4,IF($A9=4,ECHEANCIER!$E$6,IF($A9=5,ECHEANCIER!$E$7,IF($A9=6,ECHEANCIER!$E$8,IF($A9=7,ECHEANCIER!$E$9,IF($A9=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A9=\"\",\"\",IF($A9=1,ECHEANCIER!$F$3,IF($A9=3,ECHEANCIER!$F$3,IF($A9=2,ECHEANCIER!$F$4,IF($A9=4,ECHEANCIER!$F$6,IF($A9=5,ECHEANCIER!$F$7,IF($A9=6,ECHEANCIER!$F$8,IF($A9=7,ECHEANCIER!$F$9,IF($A9=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.HABI"},{"$f":"IF($A9=\"\",\"\",IF($A9=2,ECHEANCIER!$G$4,IF($A9=4,ECHEANCIER!$G$6,IF($A9=5,ECHEANCIER!$G$7,IF($A9=6,ECHEANCIER!$G$8,IF($A9=7,ECHEANCIER!$G$9,IF($A9=8,ECHEANCIER!$G$10,\"\")))))))","v":-100},13685,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$G$3,IF($A9=3,ECHEANCIER!$G$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,"15",{"$f":"IF($A10=1,ECHEANCIER!$D$3,IF($A10=3,ECHEANCIER!$D$3,IF($A10=4,ECHEANCIER!$D$4,IF($A10=5,ECHEANCIER!$D$4,IF($A10=6,ECHEANCIER!$D$4,IF($A10=7,ECHEANCIER!$D$4,IF($A10=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$3,IF($A10=2,ECHEANCIER!$E$4,IF($A10=4,ECHEANCIER!$E$6,IF($A10=5,ECHEANCIER!$E$7,IF($A10=6,ECHEANCIER!$E$8,IF($A10=7,ECHEANCIER!$E$9,IF($A10=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A10=\"\",\"\",IF($A10=1,ECHEANCIER!$F$3,IF($A10=3,ECHEANCIER!$F$3,IF($A10=2,ECHEANCIER!$F$4,IF($A10=4,ECHEANCIER!$F$6,IF($A10=5,ECHEANCIER!$F$7,IF($A10=6,ECHEANCIER!$F$8,IF($A10=7,ECHEANCIER!$F$9,IF($A10=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"T.FONC"},{"$f":"IF($A10=\"\",\"\",IF($A10=2,ECHEANCIER!$G$4,IF($A10=4,ECHEANCIER!$G$6,IF($A10=5,ECHEANCIER!$G$7,IF($A10=6,ECHEANCIER!$G$8,IF($A10=7,ECHEANCIER!$G$9,IF($A10=8,ECHEANCIER!$G$10,\"\")))))))","v":-110},13575,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$G$3,IF($A10=3,ECHEANCIER!$G$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,"15",{"$f":"IF($A11=1,ECHEANCIER!$D$3,IF($A11=3,ECHEANCIER!$D$3,IF($A11=4,ECHEANCIER!$D$4,IF($A11=5,ECHEANCIER!$D$4,IF($A11=6,ECHEANCIER!$D$4,IF($A11=7,ECHEANCIER!$D$4,IF($A11=8,ECHEANCIER!$D$4)))))))","v":"Prel"},{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$3,IF($A11=2,ECHEANCIER!$E$4,IF($A11=4,ECHEANCIER!$E$6,IF($A11=5,ECHEANCIER!$E$7,IF($A11=6,ECHEANCIER!$E$8,IF($A11=7,ECHEANCIER!$E$9,IF($A11=8,ECHEANCIER!$E$10,\"\"\"\")))))))))","v":"T.P."},{"$f":"IF(A11=\"\",\"\",IF($A11=1,ECHEANCIER!$F$3,IF($A11=3,ECHEANCIER!$F$3,IF($A11=2,ECHEANCIER!$F$4,IF($A11=4,ECHEANCIER!$F$6,IF($A11=5,ECHEANCIER!$F$7,IF($A11=6,ECHEANCIER!$F$8,IF($A11=7,ECHEANCIER!$F$9,IF($A11=8,\"ECHEANCIER!$E$10;\"\"\")))))))))","v":"IMP.REV"},{"$f":"IF($A11=\"\",\"\",IF($A11=2,ECHEANCIER!$G$4,IF($A11=4,ECHEANCIER!$G$6,IF($A11=5,ECHEANCIER!$G$7,IF($A11=6,ECHEANCIER!$G$8,IF($A11=7,ECHEANCIER!$G$9,IF($A11=8,ECHEANCIER!$G$10,\"\")))))))","v":-350},13225,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$G$3,IF($A11=3,ECHEANCIER!$G$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,"20",{"$f":"IF($A12=1,ECHEANCIER!$D$3,IF($A12=3,ECHEANCIER!$D$3,IF($A12=4,ECHEANCIER!$D$4,IF($A12=5,ECHEANCIER!$D$4,IF($A12=6,ECHEANCIER!$D$4,IF($A12=7,ECHEANCIER!$D$4,IF($A12=8,ECHEANCIER!$D$4,IF($A12=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$3,IF($A12=2,ECHEANCIER!$E$4,IF($A12=4,ECHEANCIER!$E$6,IF($A12=5,ECHEANCIER!$E$7,IF($A12=6,ECHEANCIER!$E$8,IF($A12=7,ECHEANCIER!$E$9,IF($A12=8,ECHEANCIER!$E$10,IF($A12=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ENGIE"},{"$f":"IF(A12=\"\",\"\",IF($A12=1,ECHEANCIER!$F$3,IF($A12=3,ECHEANCIER!$F$3,IF($A12=2,ECHEANCIER!$F$4,IF($A12=4,ECHEANCIER!$F$6,IF($A12=5,ECHEANCIER!$F$7,IF($A12=6,ECHEANCIER!$F$8,IF($A12=7,ECHEANCIER!$F$9,IF($A12=8,ECHEANCIER!$F$10,\"\"\"\")))))))))","v":"GAZ-ELEC"},{"$f":"IF($A12=\"\",\"\",IF($A12=2,ECHEANCIER!$G$4,IF($A12=4,ECHEANCIER!$G$6,IF($A12=5,ECHEANCIER!$G$7,IF($A12=6,ECHEANCIER!$G$8,IF($A12=7,ECHEANCIER!$G$9,IF($A12=8,ECHEANCIER!$G$10,\"\")))))))","v":-120},13105,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$G$3,IF($A12=3,ECHEANCIER!$G$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"IF(A13=\"\",\"\",IF($A13=1,\"1\",IF($A13=2,\"5\",IF($A13=3,\"10\",IF($A13=4,\"10\",IF($A13=5,\"15\",IF($A13=6,\"15\",IF($A13=7,\"15\",IF($A13=8,\"20\",IF($A13=9,\"27\",\"\"))))))))))","v":"27"},{"$f":"IF($A13=1,ECHEANCIER!$D$3,IF($A13=3,ECHEANCIER!$D$3,IF($A13=4,ECHEANCIER!$D$4,IF($A13=5,ECHEANCIER!$D$4,IF($A13=6,ECHEANCIER!$D$4,IF($A13=7,ECHEANCIER!$D$4,IF($A13=8,ECHEANCIER!$D$4,IF($A13=9,ECHEANCIER!$D$11))))))))","v":"Prel"},{"$f":"IF($A13=\"\",\"\",IF($A13=1,ECHEANCIER!$E$3,IF($A13=3,ECHEANCIER!$E$3,IF($A13=2,ECHEANCIER!$E$4,IF($A13=4,ECHEANCIER!$E$6,IF($A13=5,ECHEANCIER!$E$7,IF($A13=6,ECHEANCIER!$E$8,IF($A13=7,ECHEANCIER!$E$9,IF($A13=8,ECHEANCIER!$E$10,IF($A13=9,ECHEANCIER!$E$11,\"\"\"\"))))))))))","v":"ST CHRIST"},{"$f":"+IF($A13=9,\"ass.voit\")","v":"ass.voit"},{"$f":"IF(AND($A13=9,$E13=\"ASS.VOIT\",OR($A$1=\"janvier\",$A$1=\"avril\",$A$1=\"juillet\",$A$1=\"octobre\")),ECHEANCIER!$G$11,\"\")","v":""},13105,null,null,"",{"$f":"IF($E13=\"C. PORT LOYER\",$F13,0)","v":0},{"$f":"IF($E13=\"C. PORT CHARGES\",$F13,0)","v":0},{"$f":"IF($E13=\"MOUVEMENTS\",$F13,0)","v":0}]
[null,null,null,null,null,null,13105,null,{"$f":"IF($E14=\"RECETTES DIVERSES\",$F14,0)","v":0},{"$f":"IF($E14=\"DEPENSES\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT LOYER\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT CHARGES\",$F14,0)","v":0},{"$f":"IF($E14=\"MOUVEMENTS\",$F14,0)","v":0}]
[null,null,null,null,null,null,13105,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13105,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13105,null,0,0,0,0,{"$f":"IF($E17=\"DIVERS\",$F17,0)","v":0}]
[" ",null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":13105},null,0,0,0,0,0]
[" "," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},13105,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$G$4,IF($A19=4,ECHEANCIER!$G$6,IF($A19=5,ECHEANCIER!$G$7,IF($A19=6,ECHEANCIER!$G$8,IF($A19=7,ECHEANCIER!$G$9,IF($A19=8,ECHEANCIER!$G$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13105,null,0,{"$f":"F20","v":0},0,0,0]
[]
[]
[]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":1950},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":-820},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,null,{"$f":"H24+H4","v":9750},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-4200},650,{"$f":"L24+L4","v":-135},-500]
["TOTAL",null,null,null,null,null,{"$f":"G20","v":13105},{"$f":"SUM(H25:I25)","v":9790},null,{"$f":"J24+J4","v":-4200},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"JUILLET","index":8,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"JUILLET"}]

{"sheet":"AOUT","index":9,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"AOUT"}]

{"sheet":"SEPTEMBRE","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"SEPTEMBRE"}]

{"sheet":"OCTOBRE","index":11,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"OCTOBRE"}]

{"sheet":"NOVEMBRE","index":12,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"NOVEMBRE"}]

{"sheet":"DECEMBRE","index":13,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"DECEMBRE"}]

{"sheet":"Feuil4","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}