{"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":1,"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":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"COMPTABILISATION","MODE PAIEMENT","TIERS"]
["JOURS MENS.","JOURS TRIM.","PAIEMENT","TIERS","CATEGORIE","MONTANT"," ","C. PORT D","Carte","Unico"]
[1,null,"Vir recu","ARCO","RETRAITE",750,null,"C. PORT C","Cheque","Geant"]
[5,null,"Prel","UNEO","MUTUELLE",-100,null,"DEPENSES","Prel","Carrefour"]
[10,null,"Vir recu","CRAM","RETRAITE",1200,null,"DIVERS","Vir emis","Marche Fermier"]
[10,null,"Prel","A.L.M.","EAUX",-40,null,"REC DIV","Retrait","Bontemps"]
[15,null,"Prel","T.P.","T.HABI",-100,null," ","TIP","Lutz"]
[15,null,"Prel","T.P.","T.FONC",-110,null,null,"Vers","Amazon"]
[15,null,"Prel","T.P.","IMP.REV",-350,null,null,"Depot cheque","Dr Dupont"]
[20,null,"Prel","ENGIE","GAZ-ELEC",-120,null,null,"Vir recu","Poste"]
[" ",27,"Prel","ST CHRIST","ASS.VOIT",-95]
[]
[]
[]
[]
[]
[]
["L'échéance trimsertrielle est le 27 du premier mois de chaque trimestre"]

{"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","2016-06-01",null,null,null,null,7500]
[1,{"$f":"B4","v":"2016-06-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":750},{"$f":"SUM(G4)+SUM(F5)","v":8250},{"$f":"IF($E5=\"RETRAITE\",$F5,0)","v":750},{"$f":"IF($A5=\"\",\"\",IF($E5=\"MUTUELLE\",$F5,IF($E5=\"EAUX\",$F5,IF($E5=\"T.HABI\",$F5,(IF($E5=\"T.FONC\",$F5,(IF($E5=\"IMP.REV\",$F5,(IF($E5=\"GAZ-ELEC\",$F5,(IF($E5=\"ASS.VOIT\",$F5,0))))))))))))","v":0},{"$f":"IF($A5=\"\",\"\",IF($AE5=\"MUTUELLE\",$F$5,(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":""},null,null," "]
[2,{"$f":"B4+1","v":"2016-06-02"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":-100},{"$f":"SUM(G5)+SUM(F6)","v":8150},{"$f":"IF($E6=\"RETRAITE\",$F6,0)","v":0},-100,{"$f":"IF($A6=\"\",\"\",IF($E6=\"MUTUELLE\",$F6,(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":-100}]
[3,{"$f":"B4+9","v":"2016-06-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":0},8150,0,0,{"$f":"F7","v":0}]
[4,{"$f":"B4+9","v":"2016-06-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":0},8150,0,0,0]
[5,{"$f":"B4+14","v":"2016-06-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":0},8150,0,0,0]
[6,{"$f":"B4+14","v":"2016-06-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":0},8150,0,0,0]
[7,{"$f":"B4+14","v":"2016-06-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":0},8150,0,0,0]
[8,{"$f":"B4+19","v":"2016-06-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":0},8150,0,0,0]
[9,{"$f":"B5+26","v":"2016-06-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$11,\"\")","v":-95},8055,0,-95,-95,{"$f":"IF($E13=\"C. PORT C\",$F13,0)","v":0},{"$f":"IF($E13=\"C. PORT D\",$F13,0)","v":0},{"$f":"IF($E13=\"DIVERS\",$F13,0)","v":0}]
[10,1,"Vir recu","Carrefour","REC DIV",40,8095,null,{"$f":"IF($E14=\"REC DIV\",$F14,0)","v":40},{"$f":"IF($E14=\"DEPENSES\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT C\",$F14,0)","v":0},{"$f":"IF($E14=\"C. PORT D\",$F14,0)","v":0},{"$f":"IF($E14=\"DIVERS\",$F14,0)","v":0}]
[11,2,"Cheque","Lutz","C. PORT D",-135,7960,null,{"$f":"IF($E15=\"REC DIV\",$F15,0)","v":0},0,0,-135,0]
[12,2,"Vir recu","Lutz","C. PORT C",650,8610,null,0,0,650,0,0]
[13,3,"Retrait","Poste","DEPENSES",-500,8110,null,0,-500,0,0,0]
[14,4,"Cheque","Bontemps","DEPENSES",-90,{"$f":"SUM(G17)+SUM(F18)","v":8020},null,0,-90,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},8020,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,8020,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,8020]
[null,null,null,null,null,null,8020]
[null,null,null,null,null,null,8020]
["TOTAL MOIS",null,null,null,null,{"$f":"SUM(F5:F23)","v":520},null,{"$f":"SUM(H5:H23)","v":750},{"$f":"SUM(I5:I23)","v":-155},{"$f":"SUM(J5:J23)","v":-785},650,-135,0]
["SOUS TOTAL"," ",null,null,null,null,{"$f":"G23","v":8020},{"$f":"H24+H4","v":750},{"$f":"I24+I4","v":-155},{"$f":"J24+J4","v":-785},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":0}]
["TOTAL",null,null,null,null,null,null,{"$f":"H25+I25","v":595},null,{"$f":"J24+J4","v":-785},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":0}," "]

{"sheet":"JANVIER","index":2,"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":"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","2016-01-01",null,null,null,null,7500]
[1,{"$f":"B4","v":"2016-01-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":750},{"$f":"SUM(G4)+SUM(F5)","v":8250},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-01-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":-100},{"$f":"SUM(G5)+SUM(F6)","v":8150},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"IF($A6=\"\",\"\",IF($E6=\"MUTUELLE\",$F6,IF($E6=\"EAUX\",$F6,IF($E6=\"T.HABI\",$F6,(IF($E6=\"T.FONC\",$F6,(IF($E6=\"IMP.REV\",$F6,(IF($E6=\"GAZ-ELEC\",$F6,(IF($E6=\"ASS.VOIT\",$F6,0))))))))))))","v":-100}]
[3,{"$f":"B4+9","v":"2016-01-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":1200},9350,{"$f":"F7","v":1200},null,{"$f":"IF($A7=\"\",\"\",IF($E7=\"MUTUELLE\",$F7,IF($E7=\"EAUX\",$F7,IF($E7=\"T.HABI\",$F7,(IF($E7=\"T.FONC\",$F7,(IF($E7=\"IMP.REV\",$F7,(IF($E7=\"GAZ-ELEC\",$F7,(IF($E7=\"ASS.VOIT\",$F7,0))))))))))))","v":0}]
[4,{"$f":"B4+9","v":"2016-01-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":-40},9310,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,-40]
[5,{"$f":"B4+14","v":"2016-01-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":-100},9210,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,{"$f":"B4+14","v":"2016-01-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":-110},9100,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,{"$f":"B4+14","v":"2016-01-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":-350},8750,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,{"$f":"B4+19","v":"2016-01-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":-120},8630,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"B5+26","v":"2016-01-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$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=\"DIVERS\",$F13,0)","v":0}]
[10,1,"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=\"DIVERS\",$F14,0)","v":0}]
[11,2,"Cheque","Lutz","C. PORT CHARGES",-135,8440,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,-135,0]
[12,2,"Vir recu","Lutz","C. PORT LOYER",650,9090,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,650,0,0]
[13,3,"Retrait","Poste","DIVERS",-500,8590,null,0,0,0,0,-500]
[14,4,"Carte","Bontemps","DEPENSES",90,{"$f":"SUM(G17)+SUM(F18)","v":8680},null,0,90,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},8680,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,8680,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,8680]
[null,null,null,null,null,null,8680]
[null,null,null,null,null,null,8680]
["TOTAL MOIS",null,null,null,null,{"$f":"SUM(F5:F23)","v":1180},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,{"$f":"G23","v":8680},{"$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,null,{"$f":"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":[[1,5,1,6],[1,7,1,8]]}
[{"$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","2016-02-01",null,null,null,null,{"$f":"JANVIER!G25","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":"B4","v":"2016-02-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":750},{"$f":"SUM(G4)+SUM(F5)","v":9430},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-02-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":-100},{"$f":"SUM(G5)+SUM(F6)","v":9330},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"IF($A6=\"\",\"\",IF($E6=\"MUTUELLE\",$F6,IF($E6=\"EAUX\",$F6,IF($E6=\"T.HABI\",$F6,(IF($E6=\"T.FONC\",$F6,(IF($E6=\"IMP.REV\",$F6,(IF($E6=\"GAZ-ELEC\",$F6,(IF($E6=\"ASS.VOIT\",$F6,0))))))))))))","v":-100}]
[3,{"$f":"B4+9","v":"2016-02-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":1200},10530,{"$f":"F7","v":1200},null,{"$f":"IF($A7=\"\",\"\",IF($E7=\"MUTUELLE\",$F7,IF($E7=\"EAUX\",$F7,IF($E7=\"T.HABI\",$F7,(IF($E7=\"T.FONC\",$F7,(IF($E7=\"IMP.REV\",$F7,(IF($E7=\"GAZ-ELEC\",$F7,(IF($E7=\"ASS.VOIT\",$F7,0))))))))))))","v":0}]
[4,{"$f":"B4+9","v":"2016-02-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":-40},10490,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,-40]
[5,{"$f":"B4+14","v":"2016-02-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":-100},10390,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,{"$f":"B4+14","v":"2016-02-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":-110},10280,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,{"$f":"B4+14","v":"2016-02-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":-350},9930,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,{"$f":"B4+19","v":"2016-02-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":-120},9810,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"B5+26","v":"2016-02-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$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=\"DIVERS\",$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=\"DIVERS\",$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,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":9810},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},9810,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,9810,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,9810]
[null,null,null,null,null,null,9810]
[null,null,null,null,null,null,9810]
["TOTAL MOIS",null,null,null,null,{"$f":"SUM(F5:F23)","v":1130},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,{"$f":"G23","v":9810},{"$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,null,{"$f":"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":[[1,5,1,6],[1,7,1,8]]}
[{"$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","2016-03-01",null,null,null,null,{"$f":"FEVRIER!G25","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":"B4","v":"2016-03-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":750},{"$f":"SUM(G4)+SUM(F5)","v":10560},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-03-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":-100},{"$f":"SUM(G5)+SUM(F6)","v":10460},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"IF($A6=\"\",\"\",IF($E6=\"MUTUELLE\",$F6,IF($E6=\"EAUX\",$F6,IF($E6=\"T.HABI\",$F6,(IF($E6=\"T.FONC\",$F6,(IF($E6=\"IMP.REV\",$F6,(IF($E6=\"GAZ-ELEC\",$F6,(IF($E6=\"ASS.VOIT\",$F6,0))))))))))))","v":-100}]
[3,{"$f":"B4+9","v":"2016-03-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":1200},11660,{"$f":"F7","v":1200},null,{"$f":"IF($A7=\"\",\"\",IF($E7=\"MUTUELLE\",$F7,IF($E7=\"EAUX\",$F7,IF($E7=\"T.HABI\",$F7,(IF($E7=\"T.FONC\",$F7,(IF($E7=\"IMP.REV\",$F7,(IF($E7=\"GAZ-ELEC\",$F7,(IF($E7=\"ASS.VOIT\",$F7,0))))))))))))","v":0}]
[4,{"$f":"B4+9","v":"2016-03-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":-40},11620,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,-40]
[5,{"$f":"B4+14","v":"2016-03-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":-100},11520,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,{"$f":"B4+14","v":"2016-03-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":-110},11410,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,{"$f":"B4+14","v":"2016-03-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":-350},11060,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,{"$f":"B4+19","v":"2016-03-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":-120},10940,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"B5+26","v":"2016-03-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$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=\"DIVERS\",$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=\"DIVERS\",$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,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":10940},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},{"$f":"SUM(G18)+SUM(F19)","v":10940},null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,10940,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,10940]
[null,null,null,null,null,null,10940]
[null,null,null,null,null,null,10940]
["TOTAL MOIS",null,null,null,null,{"$f":"SUM(F5:F23)","v":1130},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,{"$f":"G23","v":10940},{"$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,null,{"$f":"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":[[1,5,1,6],[1,7,1,8]]}
[{"$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","2016-04-01",null,null,null,null,{"$f":"MARS!G25","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":"B4","v":"2016-04-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":750},{"$f":"SUM(G4)+SUM(F5)","v":11690},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-04-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":-100},{"$f":"SUM(G5)+SUM(F6)","v":11590},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"IF($A6=\"\",\"\",IF($E6=\"MUTUELLE\",$F6,IF($E6=\"EAUX\",$F6,IF($E6=\"T.HABI\",$F6,(IF($E6=\"T.FONC\",$F6,(IF($E6=\"IMP.REV\",$F6,(IF($E6=\"GAZ-ELEC\",$F6,(IF($E6=\"ASS.VOIT\",$F6,0))))))))))))","v":-100}]
[3,{"$f":"B4+9","v":"2016-04-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":1200},12790,{"$f":"F7","v":1200},null,{"$f":"IF($A7=\"\",\"\",IF($E7=\"MUTUELLE\",$F7,IF($E7=\"EAUX\",$F7,IF($E7=\"T.HABI\",$F7,(IF($E7=\"T.FONC\",$F7,(IF($E7=\"IMP.REV\",$F7,(IF($E7=\"GAZ-ELEC\",$F7,(IF($E7=\"ASS.VOIT\",$F7,0))))))))))))","v":0}]
[4,{"$f":"B4+9","v":"2016-04-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":-40},12750,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,-40]
[5,{"$f":"B4+14","v":"2016-04-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":-100},12650,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,{"$f":"B4+14","v":"2016-04-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":-110},12540,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,{"$f":"B4+14","v":"2016-04-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":-350},12190,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,{"$f":"B4+19","v":"2016-04-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":-120},12070,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"B5+26","v":"2016-04-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$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=\"DIVERS\",$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=\"DIVERS\",$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,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":11975},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},{"$f":"SUM(G18)+SUM(F19)","v":11975},null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,11975,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,11975]
[null,null,null,null,null,null,11975]
[null,null,null,null,null,null,11975]
["TOTAL MOIS",null,null,null,null,{"$f":"SUM(F5:F23)","v":1035},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,{"$f":"G23","v":11975},{"$f":"H24+H4","v":7800},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-3380},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,null,{"$f":"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":[[1,5,1,6],[1,7,1,8]]}
[{"$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","2016-05-01",null,null,null,null,{"$f":"AVRIL!G25","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":"B4","v":"2016-05-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":750},{"$f":"SUM(G4)+SUM(F5)","v":12725},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-05-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":-100},{"$f":"SUM(G5)+SUM(F6)","v":12625},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"IF($A6=\"\",\"\",IF($E6=\"MUTUELLE\",$F6,IF($E6=\"EAUX\",$F6,IF($E6=\"T.HABI\",$F6,(IF($E6=\"T.FONC\",$F6,(IF($E6=\"IMP.REV\",$F6,(IF($E6=\"GAZ-ELEC\",$F6,(IF($E6=\"ASS.VOIT\",$F6,0))))))))))))","v":-100}]
[3,{"$f":"B4+9","v":"2016-05-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":1200},13825,{"$f":"F7","v":1200},null,{"$f":"IF($A7=\"\",\"\",IF($E7=\"MUTUELLE\",$F7,IF($E7=\"EAUX\",$F7,IF($E7=\"T.HABI\",$F7,(IF($E7=\"T.FONC\",$F7,(IF($E7=\"IMP.REV\",$F7,(IF($E7=\"GAZ-ELEC\",$F7,(IF($E7=\"ASS.VOIT\",$F7,0))))))))))))","v":0}]
[4,{"$f":"B4+9","v":"2016-05-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":-40},13785,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,-40]
[5,{"$f":"B4+14","v":"2016-05-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":-100},13685,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,-100]
[6,{"$f":"B4+14","v":"2016-05-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":-110},13575,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,-110]
[7,{"$f":"B4+14","v":"2016-05-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":-350},13225,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,-350]
[8,{"$f":"B4+19","v":"2016-05-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":-120},13105,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,-120]
[9,{"$f":"B5+26","v":"2016-05-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$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=\"DIVERS\",$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=\"DIVERS\",$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,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":13105},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},{"$f":"SUM(G18)+SUM(F19)","v":13105},null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13105,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13105]
[null,null,null,null,null,null,13105]
[null,null,null,null,null,null,13105]
["TOTAL MOIS",null,null,null,null,{"$f":"SUM(F5:F23)","v":1130},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,{"$f":"G23","v":13105},{"$f":"H24+H4","v":9750},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-4200},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,null,{"$f":"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":[[1,5,1,6],[1,7,1,8]]}
[{"$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","2016-06-01",null,null,null,null,{"$f":"MAI!G25","v":13105},{"$f":"MAI!H25","v":9750},{"$f":"MAI!I25","v":40},{"$f":"MAI!J25","v":-4200},{"$f":"MAI!K25","v":650},{"$f":"MAI!L25","v":-135},{"$f":"MAI!M25","v":-500}]
[1,{"$f":"B4","v":"2016-06-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":750},{"$f":"SUM(G4)+SUM(F5)","v":13855},{"$f":"F5","v":750},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+1","v":"2016-06-02"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":-100},{"$f":"SUM(G5)+SUM(F6)","v":13755},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"IF($A6=\"\",\"\",IF($E6=\"MUTUELLE\",$F6,IF($E6=\"EAUX\",$F6,IF($E6=\"T.HABI\",$F6,(IF($E6=\"T.FONC\",$F6,(IF($E6=\"IMP.REV\",$F6,(IF($E6=\"GAZ-ELEC\",$F6,(IF($E6=\"ASS.VOIT\",$F6,0))))))))))))","v":-100}]
[3,{"$f":"B4+9","v":"2016-06-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":0},13755,{"$f":"F7","v":0},null,{"$f":"IF($A7=\"\",\"\",IF($E7=\"MUTUELLE\",$F7,IF($E7=\"EAUX\",$F7,IF($E7=\"T.HABI\",$F7,(IF($E7=\"T.FONC\",$F7,(IF($E7=\"IMP.REV\",$F7,(IF($E7=\"GAZ-ELEC\",$F7,(IF($E7=\"ASS.VOIT\",$F7,0))))))))))))","v":0}]
[4,{"$f":"B4+9","v":"2016-06-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":0},13755,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,0]
[5,{"$f":"B4+14","v":"2016-06-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":0},13755,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,0]
[6,{"$f":"B4+14","v":"2016-06-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":0},13755,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,0]
[7,{"$f":"B4+14","v":"2016-06-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":0},13755,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,0]
[8,{"$f":"B4+19","v":"2016-06-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":0},13755,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,0]
[9,{"$f":"B5+26","v":"2016-06-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$11,\"\")","v":""},13755,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=\"DIVERS\",$F13,0)","v":0}]
[null,null,null,null,null,null,13755,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=\"DIVERS\",$F14,0)","v":0}]
[null,null,null,null,null,null,13755,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13755,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13755,null,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":13755},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},{"$f":"SUM(G18)+SUM(F19)","v":13755},null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13755,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13755]
[null,null,null,null,null,null,13755]
[null,null,null,null,null,null,13755]
["TOTAL MOIS",null,null,null,null,{"$f":"SUM(F5:F23)","v":650},null,{"$f":"SUM(H5:H23)","v":750},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":-100},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,{"$f":"G23","v":13755},{"$f":"H24+H4","v":10500},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-4300},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,null,{"$f":"H25+I25","v":10540},null,{"$f":"J24+J4","v":-4300},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"JUILLET","index":8,"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":"JUILLET"}]
["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","2016-07-01",null,null,null,null,{"$f":"JUIN!G25","v":13755},{"$f":"JUIN!H25","v":10500},{"$f":"JUIN!I25","v":40},{"$f":"JUIN!J25","v":-4300},{"$f":"JUIN!K25","v":650},{"$f":"JUIN!L25","v":-135},{"$f":"JUIN!M25","v":-500}]
[1,{"$f":"B4","v":"2016-07-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":0},{"$f":"SUM(G4)+SUM(F5)","v":13755},{"$f":"F5","v":0},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-07-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":0},{"$f":"SUM(G5)+SUM(F6)","v":13755},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F6","v":0}]
[3,{"$f":"B4+9","v":"2016-07-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":0},13755,{"$f":"F7","v":0},null,{"$f":"F7","v":0}]
[4,{"$f":"B4+9","v":"2016-07-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":0},13755,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,0]
[5,{"$f":"B4+14","v":"2016-07-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":0},13755,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,0]
[6,{"$f":"B4+14","v":"2016-07-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":0},13755,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,0]
[7,{"$f":"B4+14","v":"2016-07-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":0},13755,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,0]
[8,{"$f":"B4+19","v":"2016-07-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":0},13755,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,0]
[9,{"$f":"B5+26","v":"2016-07-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$11,\"\")","v":-95},13660,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=\"DIVERS\",$F13,0)","v":0}]
[null,null,null,null,null,null,13660,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=\"DIVERS\",$F14,0)","v":0}]
[null,null,null,null,null,null,13660,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13660,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13660,null,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":13660},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},{"$f":"SUM(G18)+SUM(F19)","v":13660},null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13660,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13660]
[null,null,null,null,null,null,13660]
[null,null,null,null,null,null,13660]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":0},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":-95},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,{"$f":"G23","v":13660},{"$f":"H24+H4","v":10500},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-4395},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,null,{"$f":"H25+I25","v":10540},null,{"$f":"J24+J4","v":-4395},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"AOUT","index":9,"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":"AOUT"}]
["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","2016-08-01",null,null,null,null,{"$f":"JUILLET!G25","v":13660},{"$f":"JUILLET!H25","v":10500},{"$f":"JUILLET!I25","v":40},{"$f":"JUILLET!J25","v":-4395},{"$f":"JUILLET!K25","v":650},{"$f":"JUILLET!L25","v":-135},{"$f":"JUILLET!M25","v":-500}]
[1,{"$f":"B4","v":"2016-08-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":0},{"$f":"SUM(G4)+SUM(F5)","v":13660},{"$f":"F5","v":0},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-08-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":0},{"$f":"SUM(G5)+SUM(F6)","v":13660},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F6","v":0}]
[3,{"$f":"B4+9","v":"2016-08-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":0},13660,{"$f":"F7","v":0},null,{"$f":"F7","v":0}]
[4,{"$f":"B4+9","v":"2016-08-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":0},13660,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,0]
[5,{"$f":"B4+14","v":"2016-08-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":0},13660,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,0]
[6,{"$f":"B4+14","v":"2016-08-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":0},13660,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,0]
[7,{"$f":"B4+14","v":"2016-08-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":0},13660,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,0]
[8,{"$f":"B4+19","v":"2016-08-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":0},13660,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,0]
[9,{"$f":"B5+26","v":"2016-08-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$11,\"\")","v":""},13660,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=\"DIVERS\",$F13,0)","v":0}]
[null,null,null,null,null,null,13660,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=\"DIVERS\",$F14,0)","v":0}]
[null,null,null,null,null,null,13660,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13660,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13660,null,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":13660},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},{"$f":"SUM(G18)+SUM(F19)","v":13660},null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13660,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13660]
[null,null,null,null,null,null,13660]
[null,null,null,null,null,null,13660]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":0},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":0},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,{"$f":"G23","v":13660},{"$f":"H24+H4","v":10500},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-4395},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,null,{"$f":"H25+I25","v":10540},null,{"$f":"J24+J4","v":-4395},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"SEPTEMBRE","index":10,"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":"SEPTEMBRE"}]
["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","2016-09-01",null,null,null,null,{"$f":"AOUT!G25","v":13660},{"$f":"AOUT!H25","v":10500},{"$f":"AOUT!I25","v":40},{"$f":"AOUT!J25","v":-4395},{"$f":"AOUT!K25","v":650},{"$f":"AOUT!L25","v":-135},{"$f":"AOUT!M25","v":-500}]
[1,{"$f":"B4","v":"2016-09-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":0},{"$f":"SUM(G4)+SUM(F5)","v":13660},{"$f":"F5","v":0},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-09-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":0},{"$f":"SUM(G5)+SUM(F6)","v":13660},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F6","v":0}]
[3,{"$f":"B4+9","v":"2016-09-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":0},13660,{"$f":"F7","v":0},null,{"$f":"F7","v":0}]
[4,{"$f":"B4+9","v":"2016-09-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":0},13660,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,0]
[5,{"$f":"B4+14","v":"2016-09-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":0},13660,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,0]
[6,{"$f":"B4+14","v":"2016-09-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":0},13660,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,0]
[7,{"$f":"B4+14","v":"2016-09-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":0},13660,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,0]
[8,{"$f":"B4+19","v":"2016-09-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":0},13660,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,0]
[9,{"$f":"B5+26","v":"2016-09-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$11,\"\")","v":""},13660,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=\"DIVERS\",$F13,0)","v":0}]
[null,null,null,null,null,null,13660,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=\"DIVERS\",$F14,0)","v":0}]
[null,null,null,null,null,null,13660,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13660,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13660,null,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":13660},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},13660,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13660,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13660]
[null,null,null,null,null,null,13660]
[null,null,null,null,null,null,13660]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":0},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":0},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,{"$f":"G23","v":13660},{"$f":"H24+H4","v":10500},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-4395},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,null,{"$f":"H25+I25","v":10540},null,{"$f":"J24+J4","v":-4395},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"OCTOBRE","index":11,"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":"OCTOBRE"}]
["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","2016-10-01",null,null,null,null,{"$f":"SEPTEMBRE!G25","v":13660},{"$f":"SEPTEMBRE!H25","v":10500},{"$f":"SEPTEMBRE!I25","v":40},{"$f":"SEPTEMBRE!J25","v":-4395},{"$f":"SEPTEMBRE!K25","v":650},{"$f":"SEPTEMBRE!L25","v":-135},{"$f":"SEPTEMBRE!M25","v":-500}]
[1,{"$f":"B4","v":"2016-10-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":0},{"$f":"SUM(G4)+SUM(F5)","v":13660},{"$f":"F5","v":0},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-10-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":0},{"$f":"SUM(G5)+SUM(F6)","v":13660},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F6","v":0}]
[3,{"$f":"B4+9","v":"2016-10-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":0},13660,{"$f":"F7","v":0},null,{"$f":"F7","v":0}]
[4,{"$f":"B4+9","v":"2016-10-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":0},13660,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,0]
[5,{"$f":"B4+14","v":"2016-10-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":0},13660,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,0]
[6,{"$f":"B4+14","v":"2016-10-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":0},13660,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,0]
[7,{"$f":"B4+14","v":"2016-10-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":0},13660,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,0]
[8,{"$f":"B4+19","v":"2016-10-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":0},13660,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,0]
[9,{"$f":"B5+26","v":"2016-10-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$11,\"\")","v":-95},13565,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=\"DIVERS\",$F13,0)","v":0}]
[null,null,null,null,null,null,13565,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=\"DIVERS\",$F14,0)","v":0}]
[null,null,null,null,null,null,13565,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13565,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13565,null,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":13565},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},13565,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13565,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13565]
[null,null,null,null,null,null,13565]
[null,null,null,null,null,null,13565]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":0},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":-95},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,{"$f":"G23","v":13565},{"$f":"H24+H4","v":10500},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-4490},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,null,{"$f":"H25+I25","v":10540},null,{"$f":"J24+J4","v":-4490},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"NOVEMBRE","index":12,"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":"NOVEMBRE"}]
["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","2016-11-01",null,null,null,null,{"$f":"OCTOBRE!G25","v":13565},{"$f":"OCTOBRE!H25","v":10500},{"$f":"OCTOBRE!I25","v":40},{"$f":"OCTOBRE!J25","v":-4490},{"$f":"OCTOBRE!K25","v":650},{"$f":"OCTOBRE!L25","v":-135},{"$f":"OCTOBRE!M25","v":-500}]
[1,{"$f":"B4","v":"2016-11-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":0},{"$f":"SUM(G4)+SUM(F5)","v":13565},{"$f":"F5","v":0},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-11-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":0},{"$f":"SUM(G5)+SUM(F6)","v":13565},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F6","v":0}]
[3,{"$f":"B4+9","v":"2016-11-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":0},13565,{"$f":"F7","v":0},null,{"$f":"F7","v":0}]
[4,{"$f":"B4+9","v":"2016-11-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":0},13565,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,0]
[5,{"$f":"B4+14","v":"2016-11-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":0},13565,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,0]
[6,{"$f":"B4+14","v":"2016-11-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":0},13565,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,0]
[7,{"$f":"B4+14","v":"2016-11-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":0},13565,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,0]
[8,{"$f":"B4+19","v":"2016-11-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":0},13565,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,0]
[9,{"$f":"B5+26","v":"2016-11-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$11,\"\")","v":""},13565,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=\"DIVERS\",$F13,0)","v":0}]
[null,null,null,null,null,null,13565,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=\"DIVERS\",$F14,0)","v":0}]
[null,null,null,null,null,null,13565,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13565,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13565,null,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":13565},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},13565,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13565,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13565]
[null,null,null,null,null,null,13565]
[null,null,null,null,null,null,13565]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":0},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":0},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,{"$f":"G23","v":13565},{"$f":"H24+H4","v":10500},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-4490},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,null,{"$f":"H25+I25","v":10540},null,{"$f":"J24+J4","v":-4490},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

{"sheet":"DECEMBRE","index":13,"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":"DECEMBRE"}]
["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","2016-12-01",null,null,null,null,{"$f":"NOVEMBRE!G25","v":13565},{"$f":"NOVEMBRE!H25","v":10500},{"$f":"NOVEMBRE!I25","v":40},{"$f":"NOVEMBRE!J25","v":-4490},{"$f":"NOVEMBRE!K25","v":650},{"$f":"NOVEMBRE!L25","v":-135},{"$f":"NOVEMBRE!M25","v":-500}]
[1,{"$f":"B4","v":"2016-12-01"},{"$f":"ECHEANCIER!C3","v":"Vir recu"},{"$f":"ECHEANCIER!D3","v":"ARCO"},{"$f":"ECHEANCIER!E3","v":"RETRAITE"},{"$f":"IF($B5<=TODAY(),ECHEANCIER!$F3,0)","v":0},{"$f":"SUM(G4)+SUM(F5)","v":13565},{"$f":"F5","v":0},null,{"$f":"IF($A5=\"\",\"\",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":""},null,null," "]
[2,{"$f":"B4+4","v":"2016-12-05"},{"$f":"ECHEANCIER!C4","v":"Prel"},{"$f":"ECHEANCIER!D4","v":"UNEO"},{"$f":"ECHEANCIER!E4","v":"MUTUELLE"},{"$f":"IF($B6<=TODAY(),ECHEANCIER!$F4,0)","v":0},{"$f":"SUM(G5)+SUM(F6)","v":13565},{"$f":"IF($A6=\"\",\"\",IF($A6=1,ECHEANCIER!$E$3,IF($A6=3,ECHEANCIER!$E$5,IF($A6<>\"RETRAITE\",\"\"))))","v":""},null,{"$f":"F6","v":0}]
[3,{"$f":"B4+9","v":"2016-12-10"},{"$f":"ECHEANCIER!C5","v":"Vir recu"},{"$f":"ECHEANCIER!D5","v":"CRAM"},{"$f":"ECHEANCIER!E5","v":"RETRAITE"},{"$f":"IF($B7<=TODAY(),ECHEANCIER!$F5,0)","v":0},13565,{"$f":"F7","v":0},null,{"$f":"F7","v":0}]
[4,{"$f":"B4+9","v":"2016-12-10"},{"$f":"ECHEANCIER!C6","v":"Prel"},{"$f":"ECHEANCIER!D6","v":"A.L.M."},{"$f":"ECHEANCIER!E6","v":"EAUX"},{"$f":"IF($B8<=TODAY(),ECHEANCIER!$F6,0)","v":0},13565,{"$f":"IF($A8=\"\",\"\",IF($A8=1,ECHEANCIER!$E$3,IF($A8=3,ECHEANCIER!$E$5,IF($A8<>\"RETRAITE\",\"\"))))","v":""},null,0]
[5,{"$f":"B4+14","v":"2016-12-15"},{"$f":"ECHEANCIER!C7","v":"Prel"},{"$f":"ECHEANCIER!D7","v":"T.P."},{"$f":"ECHEANCIER!E7","v":"T.HABI"},{"$f":"IF($B9<=TODAY(),ECHEANCIER!$F7,0)","v":0},13565,{"$f":"IF($A9=\"\",\"\",IF($A9=1,ECHEANCIER!$E$3,IF($A9=3,ECHEANCIER!$E$5,IF($A9<>\"RETRAITE\",\"\"))))","v":""},null,0]
[6,{"$f":"B4+14","v":"2016-12-15"},{"$f":"ECHEANCIER!C8","v":"Prel"},{"$f":"ECHEANCIER!D8","v":"T.P."},{"$f":"ECHEANCIER!E8","v":"T.FONC"},{"$f":"IF($B10<=TODAY(),ECHEANCIER!$F8,0)","v":0},13565,{"$f":"IF($A10=\"\",\"\",IF($A10=1,ECHEANCIER!$E$3,IF($A10=3,ECHEANCIER!$E$5,IF($A10<>\"RETRAITE\",\"\"))))","v":""},null,0]
[7,{"$f":"B4+14","v":"2016-12-15"},{"$f":"ECHEANCIER!C9","v":"Prel"},{"$f":"ECHEANCIER!D9","v":"T.P."},{"$f":"ECHEANCIER!E9","v":"IMP.REV"},{"$f":"IF($B11<=TODAY(),ECHEANCIER!$F9,0)","v":0},13565,{"$f":"IF($A11=\"\",\"\",IF($A11=1,ECHEANCIER!$E$3,IF($A11=3,ECHEANCIER!$E$5,IF($A11<>\"RETRAITE\",\"\"))))","v":""},null,0]
[8,{"$f":"B4+19","v":"2016-12-20"},{"$f":"ECHEANCIER!C10","v":"Prel"},{"$f":"ECHEANCIER!D10","v":"ENGIE"},{"$f":"ECHEANCIER!E10","v":"GAZ-ELEC"},{"$f":"IF($B12<=TODAY(),ECHEANCIER!$F10,0)","v":0},13565,{"$f":"IF($A12=\"\",\"\",IF($A12=1,ECHEANCIER!$E$3,IF($A12=3,ECHEANCIER!$E$5,IF($A12<>\"RETRAITE\",\"\"))))","v":""},null,0]
[9,{"$f":"B5+26","v":"2016-12-27"},{"$f":"ECHEANCIER!C11","v":"Prel"},{"$f":"ECHEANCIER!D11","v":"ST CHRIST"},{"$f":"ECHEANCIER!E11","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!$F$11,\"\")","v":""},13565,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=\"DIVERS\",$F13,0)","v":0}]
[null,null,null,null,null,null,13565,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=\"DIVERS\",$F14,0)","v":0}]
[null,null,null,null,null,null,13565,null,{"$f":"IF($E15=\"RECETTES DIVERSES\",$F15,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13565,null,{"$f":"IF($E16=\"RECETTES DIVERSES\",$F16,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,13565,null,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G17)+SUM(F18)","v":13565},null,0,0,0,0,0]
[null," ",null,null,null,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},13565,null,0,{"$f":"IF($A19=\"\",\"\",IF($A19=2,ECHEANCIER!$E$4,IF($A19=4,ECHEANCIER!$E$6,IF($A19=5,ECHEANCIER!$E$7,IF($A19=6,ECHEANCIER!$E$8,IF($A19=7,ECHEANCIER!$E$9,IF($A19=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13565,null,0,{"$f":"IF($A20=\"\",\"\",IF($A20=2,ECHEANCIER!$E$4,IF($A20=4,ECHEANCIER!$E$6,IF($A20=5,ECHEANCIER!$E$7,IF($A20=6,ECHEANCIER!$E$8,IF($A20=7,ECHEANCIER!$E$9,IF($A20=8,ECHEANCIER!$E$10,\"\")))))))","v":""},0,0,0]
[null,null,null,null,null,null,13565]
[null,null,null,null,null,null,13565]
[null,null,null,null,null,null,13565]
["TOTAL MOIS",null,null,null,null,null,null,{"$f":"SUM(H5:H23)","v":0},{"$f":"SUM(I5:I23)","v":0},{"$f":"SUM(J5:J23)","v":0},0,0,0]
["SOUS TOTAL"," ",null,null,null,null,{"$f":"G23","v":13565},{"$f":"H24+H4","v":10500},{"$f":"I24+I4","v":40},{"$f":"J24+J4","v":-4490},{"$f":"K24+K4","v":650},-135,{"$f":"M24+M4","v":-500}]
["TOTAL",null,null,null,null,null,null,{"$f":"H25+I25","v":10540},null,{"$f":"J24+J4","v":-4490},{"$f":"SUM(K25:L25)","v":515},null,{"$f":"M24+M4","v":-500}," "]

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