{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Collecteur","Prévision","Transfert","Entrée","infos","Bdd","janvier 2016"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":48,"comments":1,"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":"Collecteur","index":0,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,7,1,8],[1,11,1,13],[1,5,1,6]]}
[null,null,null,"oi",null,{"$f":"Entrée!B12","v":"2017-01-18"},{"$f":"Entrée!B11","v":"2017-01-18"},{"$f":"Entrée!B13","v":0},{"$f":"Entrée!B14","v":0},{"$f":"IF(Entrée!B15=\"\",\"\",Entrée!B15)","v":""},{"$f":"IF(Entrée!B16=\"\",\"\",Entrée!B16)","v":""},{"$f":"Entrée!B18","v":0},{"$f":"Entrée!B19","v":0},{"$f":"Entrée!B20","v":0}]
[null,null,null,null,"Filtre","Classer",null,"Fin en cours",null,"Début mois en cours","Début mois précédent","Retour à Entrée"]
[null,null,null,null,"effacer",null,null,null,null,{"$f":"Entrée!D11","v":0},null,{"$f":"SUBTOTAL(9,C_deb)","v":0},{"$f":"SUBTOTAL(9,C_cre)","v":0}]
[null,null,null,null,{"$f":"SUMPRODUCT((C_fin=\"OK/CB\")*(C_deb-C_cre))","v":0},"Date application","Date \nd'entrée","Type de paiement","Catégorie","Rubrique","Libellé","Débit","Crédit","Statut"]
[null,null,null,null,null,"2016-12-19","2016-12-19"]
[null,null,null,null,null,"2017-01-31","2016-12-20","CBM","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-31","2016-12-20","CBP","Soins","Divers"]
[null,null,null,null,null,"2017-01-31","2016-12-22","CBM","Quotidien","Coiffeur"]
[null,null,null,null,null,"2017-01-31","2016-12-22","CBM","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-31","2016-12-23","CBP","Divers","sorties"]
[null,null,null,null,null,"2017-01-31","2016-12-24","CBP","Divers","Cadeaux"]
[null,null,null,null,null,"2017-01-31","2016-12-26","CBM","Divers","Cadeaux"]
[null,null,null,null,null,"2017-01-31","2016-12-27","CBP","Divers","Cadeaux"]
[null,null,null,null,null,"2017-01-31","2016-12-27","CBM","Divers","Equipements"]
[null,null,null,null,null,"2017-01-31","2016-12-29","CBP","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-31","2016-12-29","CBP","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-31","2016-12-29","CBP","Quotidien","Essence"]
[null,null,null,null,null,"2017-01-31","2016-12-29","CBM","Soins","Divers"]
[null,null,null,null,null,"2017-01-31","2016-12-30","CBM","Divers","Equipements"]
[null,null,null,null,null,"2017-01-31","2016-12-30","CBM","Divers","Equipements"]
[null,null,null,null,null,"2017-01-31","2016-12-30","CBP","Quotidien","Sortie / Loisir"]
[null,null,null,null,null,"2017-01-31","2016-12-31","CBM","Quotidien","Sortie / Loisir"]
[null,null,null,null,null,"2017-01-31","2016-12-31","CBM","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-31","2017-01-03","CBP","Quotidien","Sortie / Loisir",null,null,null,null,null,{"$f":"SUMIF(O:O,\"CE\",L:L)","v":0}]
[null,null,null,null,null,"2017-01-04","2017-01-04","CHQ","Budgeté","Cadeaux"]
[null,null,null,null,null,"2017-01-04","2017-01-04","CBM","Quotidien","Retrait liquide"]
[null,null,null,null,null,"2017-01-31","2017-01-05","CBP","Quotidien","Essence"]
[null,null,null,null,null,"2017-01-31","2017-01-05","CBM","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-31","2017-01-05","CBM","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-09","2017-01-09","VIR","Retraite","Cram P"]
[null,null,null,null,null,"2017-01-09","2017-01-09","VIR","Retraite","Cram M"]
[null,null,null,null,null,"2017-01-10","2017-01-10","PRV","Assurance","Maison"]
[null,null,null,null,null,"2017-01-10","2017-01-10","PRV","Assurance","Santé"]
[null,null,null,null,null,"2017-01-10","2017-01-10","PRV","Assurance","Voiture"]
[null,null,null,null,null,"2017-01-10","2017-01-10","PRV","Télécom.","Internet + tèl"]
[null,null,null,null,null,"2017-01-31","2017-01-11","CBM","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-31","2017-01-12","CBM","Quotidien","Coiffeur"]
[null,null,null,null,null,"2017-01-31","2017-01-12","CBM","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-31","2017-01-12","CBM","Soins","Remboursé M"]
[null,null,null,null,null,"2017-01-31","2017-01-13","CBM","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-31","2017-01-13","CBM","Quotidien","Courses"]
[null,null,null,null,null,"2017-01-15","2017-01-15","PRV","Crédit","Maison"]
[null,null,null,null,null,"2017-01-05","2017-01-15","PRV","Crédit","Voiture"]
[null,null,null,null,null,"2017-01-15","2017-01-15","PRV","Impots","Locaux"]
[null,null,null,null,null,"2017-01-15","2017-01-15","PRV","Impots","Fonciers"]
[null,null,null,null,null,"2017-01-15","2017-01-15","PRV","Impots","Revenus"]
[null,null,null,null,null,"2017-01-16","2017-01-16","VIR","Epargne","Assurance  retraite"]
[null,null,null,null,null,"2017-01-31","2017-01-17","CBM","Divers","Cadeaux"]
[null,null,null,null,null,"2017-01-20","2017-01-20","PRV/CB","Quotidien","Sortie / Loisir"]
[null,null,null,null,null,"2017-01-30","2017-01-30","PRV","Energie","Electricité"]
[null,null,null,null,null,"2017-01-31","2017-01-31","PRV","Energie","Gaz"]
[null,null,null,null,null,"2017-01-31","2017-01-31","PRV","Frais_banque","Fil banque"]
[null,null,null,null,null,"2017-01-31","2017-01-31","PRV","Pension ","Ex"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Prévision","index":1,"n_rows":500,"n_cols":26,"rows_kept":500,"cut":false,"hidden":false,"merged":[[6,8,7,8],[6,9,7,9],[0,5,0,7],[1,1,2,2],[1,0,2,0],[6,5,7,5],[6,6,7,6],[6,7,7,7],[5,1,5,2],[3,1,3,2],[4,1,4,2]]}
["2017-01-01",null,null,null,null,"INFORMATION DU MOIS AFFICHE",null,null,{"$f":"_xlfn.DAYS(AU,DATE(YEAR(A1),1,1))","v":17}]
["SELECTION DU MOIS","janvier"]
[null,null,null,null,null,"Epargne","Livret A","Livret retraite"]
["Premier semestre","Classer",null,null,null,"Etat 1/1/16"]
["Deuxiéme semestre","plein écran ctrl p",null,null,null,"Etat en cours"]
["Affichage cumuls","retour entrée",null,null,null,"Prev année",{"$f":"SUM(O29:Z29)","v":0}]
["Liste budgeté","Date ","Prévu","Réalisé",null,"Conso. du mois","Rubrique","Prévisions","moyenne année \n(réel)","moyenne année\n(Prévisions)",null,null,null,null,{"$f":"EOMONTH(DATE(YEAR($A$1),COLUMN(A1),1),0)","v":"2017-01-31"},{"$f":"EOMONTH(DATE(YEAR($A$1),COLUMN(B1),1),0)","v":"2017-02-28"},"2017-03-31","2017-04-30","2017-05-31","2017-06-30","2017-07-31","2017-08-31","2017-09-30","2017-10-31","2017-11-30","2017-12-31"]
[null,null,null,{"$f":"IF(A8=\"\",\"\",SUMIF(C_lib,\"*\"&A8&\"*\",C_deb))","v":""},{"$f":"IF(AND(MONTH($B8)=MONTH(AU),YEAR($B8)=YEAR(AU)),MAX($E$7:E7)+1,0)","v":0},null,null,null,null,null,null,null,null,null,"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
[null,null,null,"",{"$f":"IF(AND(MONTH($B9)=MONTH(AU),YEAR($B9)=YEAR(AU)),MAX($E$7:E8)+1,0)","v":0},{"$f":"ROUND(SUMPRODUCT((MONTH(C_enr)=MONTH(A1))*(YEAR(C_enr)=YEAR(A1))*(C_cat=\"Quotidien\")*(C_cre-C_deb))/IF(AU<EOMONTH(A1,0),DAY(AU),DAY(EOMONTH(A1,0))),2)","v":0},"TX jour",{"$f":"INDEX(O9:Z9,MONTH($A$1))","v":0},{"$f":"ROUND(SUMPRODUCT((YEAR(C_enr)=YEAR(A1))*(C_cat=\"Quotidien\")*(C_cre-C_deb))/_xlfn.DAYS(AU,DATE(YEAR(A1),1,1)),1)","v":0},{"$f":"ROUND(SUM(O9:Z9)/12,1)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B10)=MONTH(AU),YEAR($B10)=YEAR(AU)),MAX($E$7:E9)+1,0)","v":0},{"$f":"IF(TODAY()<A1,\"\",SUMPRODUCT((C_enr<A1)*(C_cre-C_deb)))","v":0},"Solde début",{"$f":"INDEX(O10:Z10,MONTH($A$1))","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B11)=MONTH(AU),YEAR($B11)=YEAR(AU)),MAX($E$7:E10)+1,0)","v":0},{"$f":"IF(TODAY()<A1,\"\",SUMPRODUCT((C_app<=EOMONTH($A$1,0))*(C_cre-C_deb)))","v":0},"Solde réel ",{"$f":"INDEX(O11:Z11,MONTH($A$1))","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B12)=MONTH(AU),YEAR($B12)=YEAR(AU)),MAX($E$7:E11)+1,0)","v":0},{"$f":"IF(TODAY()<A1,\"\",F10+F13)","v":0},"Solde complet ",{"$f":"INDEX(O12:Z12,MONTH($A$1))","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B13)=MONTH(AU),YEAR($B13)=YEAR(AU)),MAX($E$7:E12)+1,0)","v":0},{"$f":"SUM(F15:F27)","v":0},"Bilan mensuel ",{"$f":"INDEX(O13:Z13,MONTH($A$1))","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B14)=MONTH(AU),YEAR($B14)=YEAR(AU)),MAX($E$7:E13)+1,0)","v":0},"réparittion par rubrique",null,null,"Cumul année (réel)","cumul année (prévisions)"]
[null,null,null,"",{"$f":"IF(AND(MONTH($B15)=MONTH(AU),YEAR($B15)=YEAR(AU)),MAX($E$7:E14)+1,0)","v":0},{"$f":"SUMPRODUCT((C_cat=$G15)*(MONTH(C_enr)=MONTH($A$1))*(YEAR(C_enr)=YEAR($A$1))*(C_cre-C_deb))","v":0},"Assurance",{"$f":"INDIRECT(ADDRESS(ROW(),MONTH($A$1)+14,))","v":0},{"$f":"SUMPRODUCT((YEAR(C_enr)=YEAR($A$1))*(C_cat=G15)*(C_cre-C_deb))","v":0},{"$f":"SUM(O15:Z15)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B16)=MONTH(AU),YEAR($B16)=YEAR(AU)),MAX($E$7:E15)+1,0)","v":0},{"$f":"SUMPRODUCT((C_cat=$G16)*(MONTH(C_enr)=MONTH($A$1))*(YEAR(C_enr)=YEAR($A$1))*(C_cre-C_deb))","v":0},"Budgeté",{"$f":"-SUMPRODUCT((MONTH(B8:B120)=MONTH($A$1))*(C8:C120))","v":0},0,{"$f":"SUM(O16:Z16)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B17)=MONTH(AU),YEAR($B17)=YEAR(AU)),MAX($E$7:E16)+1,0)","v":0},0,"Crédit",{"$f":"INDIRECT(ADDRESS(ROW(),MONTH($A$1)+14,))","v":0},0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B18)=MONTH(AU),YEAR($B18)=YEAR(AU)),MAX($E$7:E17)+1,0)","v":0},0,"Divers",{"$f":"INDIRECT(ADDRESS(ROW(),MONTH($A$1)+14,))","v":0},0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B19)=MONTH(AU),YEAR($B19)=YEAR(AU)),MAX($E$7:E18)+1,0)","v":0},0,"Energie",0,0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B20)=MONTH(AU),YEAR($B20)=YEAR(AU)),MAX($E$7:E19)+1,0)","v":0},0,"Epargne",0,0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B21)=MONTH(AU),YEAR($B21)=YEAR(AU)),MAX($E$7:E20)+1,0)","v":0},0,"Frais_banque",0,0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B22)=MONTH(AU),YEAR($B22)=YEAR(AU)),MAX($E$7:E21)+1,0)","v":0},0,"Impots",0,0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B23)=MONTH(AU),YEAR($B23)=YEAR(AU)),MAX($E$7:E22)+1,0)","v":0},0,"Pension ",0,0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B24)=MONTH(AU),YEAR($B24)=YEAR(AU)),MAX($E$7:E23)+1,0)","v":0},{"$f":"SUMPRODUCT((C_cat=$G24)*(MONTH(C_enr)=MONTH($A$1))*(YEAR(C_enr)=YEAR($A$1))*(C_cre-C_deb))","v":0},"Retraite",{"$f":"INDIRECT(ADDRESS(ROW(),MONTH($A$1)+14,))","v":0},0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B25)=MONTH(AU),YEAR($B25)=YEAR(AU)),MAX($E$7:E24)+1,0)","v":0},0,"Soins",0,0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B26)=MONTH(AU),YEAR($B26)=YEAR(AU)),MAX($E$7:E25)+1,0)","v":0},0,"Télécom.",0,0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B27)=MONTH(AU),YEAR($B27)=YEAR(AU)),MAX($E$7:E26)+1,0)","v":0},0,"Quotidien",{"$f":"DAY(EOMONTH(DATE(YEAR(AU),MONTH($A$1),1),0))*-H9","v":0},0,0]
[null,null,null,"",{"$f":"IF(AND(MONTH($B28)=MONTH(AU),YEAR($B28)=YEAR(AU)),MAX($E$7:E27)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B29)=MONTH(AU),YEAR($B29)=YEAR(AU)),MAX($E$7:E28)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B30)=MONTH(AU),YEAR($B30)=YEAR(AU)),MAX($E$7:E29)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B31)=MONTH(AU),YEAR($B31)=YEAR(AU)),MAX($E$7:E30)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B32)=MONTH(AU),YEAR($B32)=YEAR(AU)),MAX($E$7:E31)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B33)=MONTH(AU),YEAR($B33)=YEAR(AU)),MAX($E$7:E32)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B34)=MONTH(AU),YEAR($B34)=YEAR(AU)),MAX($E$7:E33)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B35)=MONTH(AU),YEAR($B35)=YEAR(AU)),MAX($E$7:E34)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B36)=MONTH(AU),YEAR($B36)=YEAR(AU)),MAX($E$7:E35)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B37)=MONTH(AU),YEAR($B37)=YEAR(AU)),MAX($E$7:E36)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B38)=MONTH(AU),YEAR($B38)=YEAR(AU)),MAX($E$7:E37)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B39)=MONTH(AU),YEAR($B39)=YEAR(AU)),MAX($E$7:E38)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B40)=MONTH(AU),YEAR($B40)=YEAR(AU)),MAX($E$7:E39)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B41)=MONTH(AU),YEAR($B41)=YEAR(AU)),MAX($E$7:E40)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B42)=MONTH(AU),YEAR($B42)=YEAR(AU)),MAX($E$7:E41)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B43)=MONTH(AU),YEAR($B43)=YEAR(AU)),MAX($E$7:E42)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B44)=MONTH(AU),YEAR($B44)=YEAR(AU)),MAX($E$7:E43)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B45)=MONTH(AU),YEAR($B45)=YEAR(AU)),MAX($E$7:E44)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B46)=MONTH(AU),YEAR($B46)=YEAR(AU)),MAX($E$7:E45)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B47)=MONTH(AU),YEAR($B47)=YEAR(AU)),MAX($E$7:E46)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B48)=MONTH(AU),YEAR($B48)=YEAR(AU)),MAX($E$7:E47)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B49)=MONTH(AU),YEAR($B49)=YEAR(AU)),MAX($E$7:E48)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B50)=MONTH(AU),YEAR($B50)=YEAR(AU)),MAX($E$7:E49)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B51)=MONTH(AU),YEAR($B51)=YEAR(AU)),MAX($E$7:E50)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B52)=MONTH(AU),YEAR($B52)=YEAR(AU)),MAX($E$7:E51)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B53)=MONTH(AU),YEAR($B53)=YEAR(AU)),MAX($E$7:E52)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B54)=MONTH(AU),YEAR($B54)=YEAR(AU)),MAX($E$7:E53)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B55)=MONTH(AU),YEAR($B55)=YEAR(AU)),MAX($E$7:E54)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B56)=MONTH(AU),YEAR($B56)=YEAR(AU)),MAX($E$7:E55)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B57)=MONTH(AU),YEAR($B57)=YEAR(AU)),MAX($E$7:E56)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B58)=MONTH(AU),YEAR($B58)=YEAR(AU)),MAX($E$7:E57)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B59)=MONTH(AU),YEAR($B59)=YEAR(AU)),MAX($E$7:E58)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B60)=MONTH(AU),YEAR($B60)=YEAR(AU)),MAX($E$7:E59)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B61)=MONTH(AU),YEAR($B61)=YEAR(AU)),MAX($E$7:E60)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B62)=MONTH(AU),YEAR($B62)=YEAR(AU)),MAX($E$7:E61)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B63)=MONTH(AU),YEAR($B63)=YEAR(AU)),MAX($E$7:E62)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B64)=MONTH(AU),YEAR($B64)=YEAR(AU)),MAX($E$7:E63)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B65)=MONTH(AU),YEAR($B65)=YEAR(AU)),MAX($E$7:E64)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B66)=MONTH(AU),YEAR($B66)=YEAR(AU)),MAX($E$7:E65)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B67)=MONTH(AU),YEAR($B67)=YEAR(AU)),MAX($E$7:E66)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B68)=MONTH(AU),YEAR($B68)=YEAR(AU)),MAX($E$7:E67)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B69)=MONTH(AU),YEAR($B69)=YEAR(AU)),MAX($E$7:E68)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B70)=MONTH(AU),YEAR($B70)=YEAR(AU)),MAX($E$7:E69)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B71)=MONTH(AU),YEAR($B71)=YEAR(AU)),MAX($E$7:E70)+1,0)","v":0}]
[null,null,null,{"$f":"IF(A72=\"\",\"\",SUMIF(C_lib,\"*\"&A72&\"*\",C_deb))","v":""},{"$f":"IF(AND(MONTH($B72)=MONTH(AU),YEAR($B72)=YEAR(AU)),MAX($E$7:E71)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B73)=MONTH(AU),YEAR($B73)=YEAR(AU)),MAX($E$7:E72)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B74)=MONTH(AU),YEAR($B74)=YEAR(AU)),MAX($E$7:E73)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B75)=MONTH(AU),YEAR($B75)=YEAR(AU)),MAX($E$7:E74)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B76)=MONTH(AU),YEAR($B76)=YEAR(AU)),MAX($E$7:E75)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B77)=MONTH(AU),YEAR($B77)=YEAR(AU)),MAX($E$7:E76)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B78)=MONTH(AU),YEAR($B78)=YEAR(AU)),MAX($E$7:E77)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B79)=MONTH(AU),YEAR($B79)=YEAR(AU)),MAX($E$7:E78)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B80)=MONTH(AU),YEAR($B80)=YEAR(AU)),MAX($E$7:E79)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B81)=MONTH(AU),YEAR($B81)=YEAR(AU)),MAX($E$7:E80)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B82)=MONTH(AU),YEAR($B82)=YEAR(AU)),MAX($E$7:E81)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B83)=MONTH(AU),YEAR($B83)=YEAR(AU)),MAX($E$7:E82)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B84)=MONTH(AU),YEAR($B84)=YEAR(AU)),MAX($E$7:E83)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B85)=MONTH(AU),YEAR($B85)=YEAR(AU)),MAX($E$7:E84)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B86)=MONTH(AU),YEAR($B86)=YEAR(AU)),MAX($E$7:E85)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B87)=MONTH(AU),YEAR($B87)=YEAR(AU)),MAX($E$7:E86)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B88)=MONTH(AU),YEAR($B88)=YEAR(AU)),MAX($E$7:E87)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B89)=MONTH(AU),YEAR($B89)=YEAR(AU)),MAX($E$7:E88)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B90)=MONTH(AU),YEAR($B90)=YEAR(AU)),MAX($E$7:E89)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B91)=MONTH(AU),YEAR($B91)=YEAR(AU)),MAX($E$7:E90)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B92)=MONTH(AU),YEAR($B92)=YEAR(AU)),MAX($E$7:E91)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B93)=MONTH(AU),YEAR($B93)=YEAR(AU)),MAX($E$7:E92)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B94)=MONTH(AU),YEAR($B94)=YEAR(AU)),MAX($E$7:E93)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B95)=MONTH(AU),YEAR($B95)=YEAR(AU)),MAX($E$7:E94)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B96)=MONTH(AU),YEAR($B96)=YEAR(AU)),MAX($E$7:E95)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B97)=MONTH(AU),YEAR($B97)=YEAR(AU)),MAX($E$7:E96)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B98)=MONTH(AU),YEAR($B98)=YEAR(AU)),MAX($E$7:E97)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B99)=MONTH(AU),YEAR($B99)=YEAR(AU)),MAX($E$7:E98)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B100)=MONTH(AU),YEAR($B100)=YEAR(AU)),MAX($E$7:E99)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B101)=MONTH(AU),YEAR($B101)=YEAR(AU)),MAX($E$7:E100)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B102)=MONTH(AU),YEAR($B102)=YEAR(AU)),MAX($E$7:E101)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B103)=MONTH(AU),YEAR($B103)=YEAR(AU)),MAX($E$7:E102)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B104)=MONTH(AU),YEAR($B104)=YEAR(AU)),MAX($E$7:E103)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B105)=MONTH(AU),YEAR($B105)=YEAR(AU)),MAX($E$7:E104)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B106)=MONTH(AU),YEAR($B106)=YEAR(AU)),MAX($E$7:E105)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B107)=MONTH(AU),YEAR($B107)=YEAR(AU)),MAX($E$7:E106)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B108)=MONTH(AU),YEAR($B108)=YEAR(AU)),MAX($E$7:E107)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B109)=MONTH(AU),YEAR($B109)=YEAR(AU)),MAX($E$7:E108)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B110)=MONTH(AU),YEAR($B110)=YEAR(AU)),MAX($E$7:E109)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B111)=MONTH(AU),YEAR($B111)=YEAR(AU)),MAX($E$7:E110)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B112)=MONTH(AU),YEAR($B112)=YEAR(AU)),MAX($E$7:E111)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B113)=MONTH(AU),YEAR($B113)=YEAR(AU)),MAX($E$7:E112)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B114)=MONTH(AU),YEAR($B114)=YEAR(AU)),MAX($E$7:E113)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B115)=MONTH(AU),YEAR($B115)=YEAR(AU)),MAX($E$7:E114)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B116)=MONTH(AU),YEAR($B116)=YEAR(AU)),MAX($E$7:E115)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B117)=MONTH(AU),YEAR($B117)=YEAR(AU)),MAX($E$7:E116)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B118)=MONTH(AU),YEAR($B118)=YEAR(AU)),MAX($E$7:E117)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B119)=MONTH(AU),YEAR($B119)=YEAR(AU)),MAX($E$7:E118)+1,0)","v":0}]
[null,null,null,"",{"$f":"IF(AND(MONTH($B120)=MONTH(AU),YEAR($B120)=YEAR(AU)),MAX($E$7:E119)+1,0)","v":0}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(A136=\"\",\"\",SUMIF(C_lib,\"*\"&A136&\"*\",C_deb))","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(A200=\"\",\"\",SUMIF(C_lib,\"*\"&A200&\"*\",C_deb))","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(A264=\"\",\"\",SUMIF(C_lib,\"*\"&A264&\"*\",C_deb))","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(A328=\"\",\"\",SUMIF(C_lib,\"*\"&A328&\"*\",C_deb))","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(A392=\"\",\"\",SUMIF(C_lib,\"*\"&A392&\"*\",C_deb))","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(A456=\"\",\"\",SUMIF(C_lib,\"*\"&A456&\"*\",C_deb))","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]

{"sheet":"Transfert","index":2,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
["Date application","Date \nd'entrée","Type","Catégorie","Rubrique","Libellé","Débit","Crédit","Statut",{"$f":"Entrée!I10&\" \"&YEAR(AU)","v":" 2017"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"SH"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"RE"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"RE"]
[]
[null,null,null,null,null,null,null,null,null,"RE"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"CE"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"RE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"RE"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"RE"]

{"sheet":"Entrée","index":3,"n_rows":212,"n_cols":13,"rows_kept":212,"cut":false,"hidden":false,"merged":[[25,3,25,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[1,0,1,1],[1,2,1,3],[1,4,1,5],[8,0,8,1],[18,8,19,8],[19,3,19,4]]}
["init mensuel",null,null,null,null,null,"init mensuel"]
["DONNEES CALENDAIRES",null,"ETAT du MOIS EN COURS",null,"CONTROLE INTERMEDIAIRE",null,"Rappel des mensuels",null,"NAVIGATION"]
[null,null,null,null,null,null,{"$f":"Bdd!D2","v":"impots locaux"},null,"Collecteur"]
["Aujourd'hui",{"$f":"TODAY()","v":"2017-01-18"},"Solde complet",{"$f":"SUM(C_cre)-SUM(C_deb)","v":0},"Date",null,{"$f":"Bdd!D3","v":"impots fonciers "},null,"Prévisions"]
["N° semaine  / N° du Jour",{"$f":"\"Semaine \"&WEEKNUM(AU,2)-1&\"  /  \"&DATEDIF(DATE(YEAR(AU),1,1),TODAY(),\"d\")+1&\"°  jour\"","v":"Semaine 3  /  18°  jour"},"Solde en cours",{"$f":"SUMPRODUCT((C_app<=AU)*(C_cre-C_deb))","v":0},"Etat Banque",null,{"$f":"Bdd!D4","v":"impots revenus"}]
["Mois",{"$f":"UPPER(TEXT(AU,\"MMMM\"))","v":"JANVIER"},{"$f":"IF(TODAY()<=DATE(YEAR(AU),MONTH(AU),15),\"Solde estimé au 15\",\"Solde complet à fin de mois\")","v":"Solde complet à fin de mois"},{"$f":"SUMPRODUCT((C_app<=DATE(YEAR(AU),MONTH(AU),15))*(C_cre-C_deb))","v":0},"CB déduite Banque",null,{"$f":"Bdd!D5","v":"crédit maison"}]
["Date limite CB en cours",{"$f":"INDEX(B_lcb,MONTH(AU))","v":"2017-01-20"},null,null,"Solde Banque à date",{"$f":"IF(F4=\"\",\"\",F5-F6)","v":""},{"$f":"Bdd!D6","v":"crédit voiture"}]
[null,null,"Solde équivalent relevé",{"$f":"SUMPRODUCT((C_stat=\"pointé\")*(C_cre-C_deb))","v":0},"applicable fin mois",{"$f":"IF(F4=\"\",\"\",SUMIF(C_fin,\"Affect\",C_cre)-SUMIF(C_fin,\"Affect\",C_deb))","v":""},{"$f":"Bdd!D7","v":"assurance maison"},null,"EDITION DU MOIS"]
["ENREGISTREMENT",null,"CB prélevées",{"$f":"SUMPRODUCT((C_typ=\"PRV/CB\")*(MONTH(C_app)=MONTH(AU))*(YEAR(C_app)=YEAR(AU))*(C_rub<>\"Retrait liquide\")*(C_deb))","v":0},"sld fin mois",{"$f":"IF(F7=\"\",\"\",F7+F8)","v":""},{"$f":"Bdd!D8","v":"assurance santé"},null,"Choisir le mois"]
[null,null,"CBM appliquées fin mois",{"$f":"SUMPRODUCT((C_typ=\"CBM\")*(MONTH(C_app)=MONTH(AU))*(YEAR(C_app)=YEAR(AU))*(C_rub<>\"Retrait liquide\")*(C_rub<>\"CB directe\")*(C_deb))","v":0},null,null,{"$f":"Bdd!D9","v":"assurance voiture"}]
["Date d'entrée","2017-01-18","CBP appliquées fin mois",{"$f":"SUMPRODUCT((C_typ=\"CBP\")*(MONTH(C_app)=MONTH(AU))*(YEAR(C_app)=YEAR(AU))*(C_rub<>\"Retrait liquide\")*(C_rub<>\"CB directe\")*(C_deb))","v":0},"BILAN ANNEE >",2017,{"$f":"Bdd!D10","v":"Carte bleue M"},null,"EDITER",null,null,null," "]
["Date d'application",{"$f":"IF(OR(B15=\"CB directe\",B15=\"Télépéage\"),B11,IF(AND(LEFT(B13,2)=\"CB\",B15<>\"Retrait liquide\",B11>=C_lcb),EOMONTH(AU,1),IF(AND(LEFT(B13,2)=\"CB\",B15<>\"Retrait liquide\"),EOMONTH(AU,0),B11)))","v":"2017-01-18"},"Cumul appliqué fin mois",{"$f":"D10+D11","v":0},"Rentrées ",{"$f":"SUMPRODUCT((YEAR(C_enr)=$F$11)*(C_cre))","v":0},{"$f":"Bdd!D11","v":"Carte bleue P"}]
["Type d'opération",null,"Cumul différés",{"$f":"SUMPRODUCT((C_app>EOMONTH(AU,0))*(C_deb))","v":0},"Sorties",{"$f":"SUMPRODUCT((YEAR(C_enr)=$F$11)*(C_deb))","v":0},{"$f":"Bdd!D12","v":"Fil banque"},null,"AFFICHAGE"]
["Catégorie",null,null,null,null,null,{"$f":"Bdd!D13","v":"compte vie"},null,"plein écran (ctrl e)"]
["Rubrique",null,"TX/J prévisionnel",{"$f":"-INDEX(Prévision!O9:Z9,MONTH(AU))","v":0},"TX/J (année en cours)",{"$f":"ABS(ROUND(SUMPRODUCT((YEAR(C_enr)=YEAR(AU))*(C_cat=\"Quotidien\")*(C_cre-C_deb))/DATEDIF(DATE(YEAR(AU)-1,12,31),TODAY(),\"d\"),2))","v":0},{"$f":"Bdd!D14","v":"Arcco M"},null,"Outils (ctrl o)"]
["libellé",null,"TX/J réel",{"$f":"ROUND(SUMPRODUCT((YEAR(C_enr)=YEAR(AU))*(MONTH(C_enr)=MONTH(AU))*(C_cat=\"Quotidien\")*(C_cre-C_deb))/DAY(AU),2)","v":0},null,null,{"$f":"Bdd!D15","v":"Arcco P"}]
[null,null,"Ecart Jour",{"$f":"D16-D15","v":0},"Sortie épargne",{"$f":"SUMPRODUCT((YEAR(C_enr)=YEAR(AU))*(LEFT(C_rub,6)=\"Livret\")*(C_cre))","v":0},{"$f":"Bdd!D16","v":"Cram M"},null,"Sauvegarde (ctrl s)"]
["Débit",null,"Ecart période",{"$f":"D17*DAY(AU)","v":0},"Entrée épargne",{"$f":"SUMPRODUCT((YEAR(C_enr)=YEAR(AU))*(LEFT(C_rub,6)=\"Livret\")*(C_deb))","v":0},{"$f":"Bdd!D17","v":"Cram P"}]
["Crédit",null,null,null,null,null,{"$f":"Bdd!D18","v":"Agirc"},null,"VALIDER"]
["Etat",null,"Codes budgetés du mois",{"$f":"IFERROR(INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A1),Prévision!$E$8:$E$120,0),1)&\" prèv: \"&(INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A1),Prévision!$E$8:$E$120,0),3))&\"  / affect: \"&SUMIF(C_lib,\"*\"&INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A1),Prévision!$E$8:$E$120,0),1)&\"*\",C_deb),\"\")","v":""},null,null,{"$f":"Bdd!D19","v":"Gan"}]
[null,null,null,{"$f":"IFERROR(INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A2),Prévision!$E$8:$E$120,0),1)&\" prèv: \"&(INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A2),Prévision!$E$8:$E$120,0),3))&\"  / affect: \"&SUMIF(C_lib,\"*\"&INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A2),Prévision!$E$8:$E$120,0),1)&\"*\",C_deb),\"\")","v":""},null,null,{"$f":"Bdd!D20","v":"AGF1"}]
["recherche de montants >",null,"+",{"$f":"IFERROR(INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A3),Prévision!$E$8:$E$120,0),1)&\" prèv: \"&(INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A3),Prévision!$E$8:$E$120,0),3))&\"  / affect: \"&SUMIF(C_lib,\"*\"&INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A3),Prévision!$E$8:$E$120,0),1)&\"*\",C_deb),\"\")","v":""},null,null,{"$f":"Bdd!D21","v":"AGF2"}]
[null,{"$f":"IFERROR(VLOOKUP(B22,Bdd!D2:E26,2,0),\"\")","v":""},"-",{"$f":"IFERROR(INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A4),Prévision!$E$8:$E$120,0),1)&\" prèv: \"&(INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A4),Prévision!$E$8:$E$120,0),3))&\"  / affect: \"&SUMIF(C_lib,\"*\"&INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A4),Prévision!$E$8:$E$120,0),1)&\"*\",C_deb),\"\")","v":""},null,null,{"$f":"Bdd!D22","v":"Pension"}]
[null,null,null,{"$f":"IFERROR(INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A5),Prévision!$E$8:$E$120,0),1)&\" prèv: \"&(INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A5),Prévision!$E$8:$E$120,0),3))&\"  / affect: \"&SUMIF(C_lib,\"*\"&INDEX(Prévision!$A$8:$E$120,MATCH(ROW(A5),Prévision!$E$8:$E$120,0),1)&\"*\",C_deb),\"\")","v":""},null,null,{"$f":"Bdd!D23","v":"Gaz"}]
["Prévu depuis LAP vers CCP",{"$f":"IF(INDEX(Prévision!$O$20:$Z$20,,MONTH(AU))>600,INDEX(Prévision!$O$20:$Z$20,,MONTH(AU))-600,\"\")","v":""},null,null,null,null,{"$f":"Bdd!D24","v":"Electricité"}]
["Prévu depuis CCP vers LAP",{"$f":"IF(INDEX(Prévision!$O$20:$Z$20,,MONTH(AU))<Bdd!E27,ABS(Bdd!$E$27-INDEX(Prévision!$O$20:$Z$20,,MONTH(AU))),\"\")","v":""},"Vinci estimée en cours",null,null,null,"Télécom"]
["Etat LAP",{"$f":"Prévision!G5","v":0},"dernier N° de chéque ",{"$f":"MAX(IF(ISNUMBER(RIGHT(C_lib,7)*1),RIGHT(C_lib,7)*1))","v":0},null,null,"depuis LAP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"compte vie"]

{"sheet":"infos","index":4,"n_rows":59,"n_cols":1,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["le fichier s'ouvre sur la feuille entrée"]
["la feuille Bdd est normalement masquée et contient les informations nécessaires à la gestion de l'ensemble des données"]
[]
["feuille entrée"]
["le navigateur à droite permet"]
["d'aller d'une feuille à l'autre"]
["d'afficher les outils en déprotègeant la feuille ou (ctrl o)"]
["ou d'afficher plein écran en la protègeant ou (ctrtl e)"]
["l'enregistrement sans effacer le plein écran (bouton sauvegarde ou crtl s)"]
["l'édition du mois choisi via le menu déroulant et le bouton EDITER (généralement en fin de mois) voir exemple avec feuille janvier 2016 éditée et nommée automatiquement)"]
[]
["le bouton orange autorise l'enregsitrement des données entrées dans les tableaux (mais uniquement si les éléments sont conformes)"]
["le bouton alors passe en vert et affiche VALIDER, sinon un message de refus apparait"]
[]
["la colonne G liste des \"mensuels\" permet d'afficher en bas à gauche les montants mensuels de chaque rubrique de la liste"]
["dans les deux cellules \"Recherche de montants\" en bas à gauche dans lesquelles s'affichent le libellé et le montant (s'il est documenté en Bdd)"]
["lorsqu'on clique sur son nom. Un clic sur le + ou le - affecte ce montants aux cases débits ou crédits au dessus"]
["chaque montant mensuel une fois affiché, passe en rouge dans la liste et une croix s'affiche à droite du nom (pour éviter d'en oublier en début de mois)"]
["un clic tout en haut de la liste remet l'affichage à 0"]
[]
["E et F donne des infos sut l'état des comptes annuels"]
["F4 à F10 servent à la comparaison avec le relevé banquaire transmis par la banque"]
[]
["C et D affichent les différentes situations du compte , carte bleu différé, etc…"]
[]
["la partie basse de C et D affcihent pour mémoire les montants \"budgeté\" prévisible"]
["chaque ligne affiche:"]
["le libellé, le montant prévu inscrit en colonne A,B,C,D de Prévision, et à la suite, le montant réel affecté"]
[]
["B4 à B7, infos sur le calendrier"]
["B11 et B12 date d'enregsitrement, par défaut date du jour en haut qui s'affiche à l'ouverture du fichier et qui est modifiable au clavier (il n'y a pas de formule)"]
[]
["B13 à B16, affectationdes rubriques, avec menu déroulant en cascade pour catégorie et rubrique et entrée libre au clavier pour libellé (facultatif)"]
[]
["B18 et B19 montant en crédit ou en débit selon le cas"]
["B20 pour signaler une entrée \"provisoire\" si le montant n'est pas définitif (sera ressortie dans collecteur par MFC en jaune)"]
["B25 à B27 gestion de l'épargne (quand il y en a)"]
[]
["Feuille Collecteur"]
["la feuille récupère les entrées de l'année complète, elle ne contient aucune formule"]
["la barre de titre permet la navigation et l'affichage"]
["soit des 10 dernières lignes"]
["soit depuis la début du mois en cours"]
["soit depuis le début du mois précéent"]
["le bouton filtrer permet l'affichage ou l'effacement du filtre lorsque le fichier est en plein écran"]
["classer permet de classer selon les dates d'entrée, (en cas de modification directe sur la feuille)mais cei se fait automatiquement par défaut à chaque validation depuis \"entrée\""]
["la colonne Statut permet un pointage de recoupement avec les relevés banquaires mensuels"]
["la colonne Type de paiement passe en orange si elle annonce un chèque (CHQ) et que le N° n'est pas inscrit à la fin du libellé"]
[]
["Feuille Prévision"]
["a voir + tard si besoin, permet un prévisionnel mensuel sur l'année et la liste des postes \"imprévus\"  à budgeter"]
["le retour à la feuille entrée se fait pas rdouble clic sur la case \"retour entrée\""]
[]
["Feuille BDD"]
["contient les informations permettant l'alimentation des listes et l'affichage des montants \"répétitifs\" et les manipsd pour les différentes fonctions"]
["cette feuille est normalement masquée"]
[]
["Il exdiste une feuille Transfert masquée qui sert seulemnt à l'édition du mois"]

{"sheet":"Bdd","index":5,"n_rows":27,"n_cols":43,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["champ","adresse","nom","rubrique","mensuel","annuel (Info)",null,null,null,"Adresses diverses",null,"ANNEE EN COURS >",2017,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date CB",1,2,3,4,5,6,7,8,9,10,11,12]
["Feuille Bdd",null,null,"impots locaux",null,null,null,null,null,"Fin en cours",{"$f":"COUNTIF(Collecteur!F:F,\"<>\")-10","v":42},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-01-20","Quotidien","Divers","Budgeté","Soins","Impots","Crédit","Energie","Epargne","Frais_banque","Retraite","Télécom.","Pension ","Assurance","Carte brico","SFC","janvier"]
["Date CB","AA",null,"impots fonciers ",null,null,null,null,null,"Début mois en cours",{"$f":"MATCH(YEAR(AU)&MONTH(AU),YEAR(C_enr)&MONTH(C_enr),0)+4","v":24},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-20",null,null,null,null,null,null,null,null,null,null,null,null,null,"Virement","VIR","février"]
["CATEGORIE","AB2:AN2","List_C","impots revenus",null,null,null,null,null,"Début mois précédent",{"$f":"MATCH(DATE(YEAR(AU),MONTH(AU)-1,1),C_enr,0)+4","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-03-20","Courses","Retrait liquide","Divers","Remboursé P","Locaux","Maison","Eau","Livret sup M","Fil banque","Cram M","Internet + tèl","Ex","Maison","Chèque","CHQ","mars"]
["RUBRIQUE","AB3:AN11","Selon titre List_C","crédit maison",null,null,null,null,null,"Champ mois édition",{"$f":"ADDRESS(MATCH(DATE(B_AN,MATCH(Entrée!I10,B_edit_M,0),1),C_enr,0)+4,6,,,\"Collecteur\")&\":\"&ADDRESS(MATCH(EOMONTH(DATE(B_AN,MATCH(Entrée!I10,B_edit_M,0),1),0)+1,C_enr,0)+3,15)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-04-20","Retrait liquide","Equipements","Sorties","Remboursé M","Fonciers","Voiture","Gaz","Livret sup P","CB","Cram P",null,null,"Voiture","Prélévement","PRV","avril"]
["TYPE PAIEMENT","AO:AP","Type","crédit voiture",null,null,null,null,null,"Adresse collage",{"$f":"ADDRESS(COUNTIF(Collecteur!F:F,\"<>\")+3,6,,,\"Collecteur\")","v":"Collecteur!$F$55"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-05-20","Sortie / Loisir","Cadeaux","Cadeaux","Divers","Revenus",null,"Electricité","Livret A P","Vie","Arcco M",null,null,"Santé","Titre","TIP","mai"]
["LISTE MENSUEL","D",null,"assurance maison",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-06-20","Coiffeur","Rentrées","Equipement","Remboursement SS",null,null,null,"Assurance  retraite","Frais divers","Arcco P",null,null,null,"CB M","CBM","juin"]
["LISTE MOIS","AQ1:AQ12","Edit_M","assurance santé",null,null,null,null,null,"Autorisation enregistrement",{"$f":"IF(COUNTIF(K9:K14,\"KO\"),\"KO\",\"OK\")","v":"KO"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-07-20","Essence","Imprévu","Travaux","Remboursement Mut",null,null,null,null,null,"Agirc",null,null,null,"CB P","CBP","juillet"]
["ADRESSEDIVERSES","J:K",null,"assurance voiture",null,null,null,null,null,"Date d'enregistrement",{"$f":"IF(Entrée!B11=\"\",\"KO\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-21","CB directe","Voiture","Retrait liquide",null,null,null,null,null,null,"Gan",null,null,null,"Prélévement sur CBP","PRV/CB","août"]
["Fin en cours","K2","FC","Carte bleue M",null,null,null,null,null,"Type d'opération",{"$f":"IF(Entrée!B13=\"\",\"KO\",\"\")","v":"KO"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-20",null,"CB directe","CB directe",null,null,null,null,null,null,"AGF 1",null,null,null,"Retrait liquide","RET","septembre"]
["Début mois en cours","K3","DMC","Carte bleue P",null,null,null,null,null,"Catégorie",{"$f":"IF(Entrée!B14=\"\",\"KO\",\"\")","v":"KO"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-20",null,"sorties",null,null,null,null,null,null,null,"AGF 2",null,null,null,null,null,"octobre"]
["Début mois précédent","K4","DMCA","Fil banque",null,null,null,null,null,"Rubrique",{"$f":"IF(Entrée!B15=\"\",\"KO\",\"\")","v":"KO"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"novembre"]
["Champ mois édition","K5","CHM","compte vie",null,null,null,null,null,"libellé","non obligatoire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"décembre"]
["Adresse collage","K6","Coll","Arcco M",null,null,null,null,null,"Valeur",{"$f":"IF(AND(Entrée!B19=\"\",Entrée!B18=\"\"),\"KO\",\"\")","v":"KO"}]
[null,null,null,"Arcco P"]
["Feuille Collecteur",null,null,"Cram M",null,null,null,null,null,"Autorisation edition",{"$f":"IF(ISERROR(B_CHM),\"KO\",\"OK\")","v":"KO"}]
["Montant crédit","L5:L10000","C_cre","Cram P"]
["Montant débit","M5:M10000","C_ceb","Agirc"]
["Date enregistrement","G5:G10000","C_enr","Gan"]
["Date application","F5:F10000","C_app","AGF1"]
["Type paiement","H5:H10000","C_typ","AGF2"]
["Statut","N5:N10000","C_stat","Pension"]
[null,null,null,"Gaz"]
["Feuille Prévision",null,null,"Electricité"]
[null,null,null,"Télécom"]
[null,null,null,"depuis lap"]
[null,null,null,"mensuel depuis lap"]

{"sheet":"janvier 2016","index":6,"n_rows":98,"n_cols":10,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Date application","Date \nd'entrée","Type","Catégorie","Rubrique","Libellé","Débit","Crédit","Statut",{"$f":"Entrée!I10&\" \"&YEAR(AU)","v":" 2017"}]
["2016-01-01","2016-01-01"]
["2016-01-31","2016-01-01","CBP","Divers","Cadeaux"]
["2016-01-31","2016-01-01","CBP","Divers","Equipements"]
["2016-01-31","2016-01-01","CBP","Divers","Imprévu"]
["2016-01-31","2016-01-01","CBP","Divers","Equipements"]
["2016-01-31","2016-01-01","CBM","Divers","Cadeaux"]
["2016-01-31","2016-01-01","CBM","Divers","Cadeaux"]
["2016-01-01","2016-01-01","PRV","Frais_banque","Fil banque"]
["2016-01-31","2016-01-01","CBP","Quotidien","Courses"]
["2016-01-31","2016-01-01","CBP","Quotidien","Courses"]
["2016-01-31","2016-01-01","CBM","Quotidien","Courses"]
["2016-01-31","2016-01-01","CBP","Quotidien","Coiffeur"]
["2016-01-31","2016-01-01","CBM","Quotidien","Courses"]
["2016-01-31","2016-01-01","CBM","Quotidien","Courses"]
["2016-01-31","2016-01-01","CBP","Quotidien","Sortie / Loisir"]
["2016-01-31","2016-01-01","CBP","Quotidien","Courses"]
["2016-01-31","2016-01-01","CBP","Quotidien","Courses"]
["2016-01-31","2016-01-01","CBP","Quotidien","Essence"]
["2016-01-31","2016-01-01","CBM","Quotidien","Courses"]
["2016-01-31","2016-01-01","CBM","Quotidien","Courses"]
["2016-01-31","2016-01-01","H","Quotidien","Courses"]
["2016-01-31","2016-01-01","CBM","Quotidien","Essence"]
["2016-01-31","2016-01-01","CBP","Quotidien","Sortie / Loisir"]
["2016-01-31","2016-01-01","CBM","Soins","Divers"]
["2016-01-31","2016-01-01","CBM","Soins","Remboursé M"]
["2016-01-31","2016-01-01","CBP","Soins","Divers"]
["2016-01-31","2016-01-02","CBM","Quotidien","Sortie / Loisir"]
["2016-01-31","2016-01-03","CBP","Divers","Cadeaux"]
["2016-01-31","2016-01-03","CBP","Quotidien","Sortie / Loisir"]
["2016-01-04","2016-01-04","CHQ","Budgeté","Cadeaux"]
["2016-01-04","2016-01-04","CHQ","Budgeté","Cadeaux"]
["2016-01-04","2016-01-04","CHQ","Budgeté","Cadeaux"]
["2016-01-04","2016-01-04","CHQ","Budgeté","Cadeaux"]
["2016-01-04","2016-01-04","PRV","Frais_banque","CB"]
["2016-01-31","2016-01-04","CBM","Quotidien","Courses"]
["2016-01-04","2016-01-04","VIR","Retraite","Arcco M"]
["2016-01-04","2016-01-04","VIR","Retraite","Arcco P"]
["2016-01-04","2016-01-04","VIR","Retraite","Agirc"]
["2016-01-05","2016-01-05","PRV","Crédit","Voiture"]
["2016-01-05","2016-01-05","CHQ","Divers","Imprévu"]
["2016-01-31","2016-01-05","CBM","Soins","Remboursé M"]
["2016-01-31","2016-01-06","CBM","Soins","Remboursé M"]
["2016-01-07","2016-01-07","CHQ","Divers","Equipements"]
["2016-01-31","2016-01-07","CBM","Quotidien","Coiffeur"]
["2016-01-31","2016-01-08","CBP","Quotidien","Essence"]
["2016-01-31","2016-01-08","CBM","Quotidien","Courses"]
["2016-01-31","2016-01-08","CBM","Quotidien","Courses"]
["2016-01-31","2016-01-08","CBM","Quotidien","Courses"]
["2016-01-31","2016-01-08","CBM","Soins","Remboursé M"]
["2016-01-31","2016-01-09","CBM","Quotidien","Courses"]
["2016-01-09","2016-01-09","VIR","Retraite","Cram P"]
["2016-01-09","2016-01-09","VIR","Retraite","Cram M"]
["2016-01-04","2016-01-10","VIR","Assurance","Maison"]
["2016-01-04","2016-01-10","PRV","Assurance","Voiture"]
["2016-01-04","2016-01-10","PRV","Assurance","Santé"]
["2016-01-31","2016-01-10","CBP","Divers","Equipements"]
["2016-01-31","2016-01-11","CBM","Soins","Remboursé M"]
["2016-01-31","2016-01-11","CBM","Soins","Remboursé M"]
["2016-01-31","2016-01-11","CBM","Soins","Remboursé M"]
["2016-01-31","2016-01-12","CBP","Budgeté","Imprévu"]
["2016-01-12","2016-01-12","VIR","Soins","Remboursement SS"]
["2016-01-31","2016-01-14","CBM","Quotidien","Courses"]
["2016-01-14","2016-01-14","VIR","Soins","Remboursement SS"]
["2016-01-14","2016-01-14","VIR","Soins","Remboursement SS"]
["2016-01-15","2016-01-15","PRV","Crédit","Maison"]
["2016-01-15","2016-01-15","PRV","Impots","Locaux"]
["2016-01-15","2016-01-15","PRV","Impots","Fonciers"]
["2016-01-15","2016-01-15","PRV","Impots","Revenus"]
["2016-01-15","2016-01-15","PRV","Télécom.","Internet + tèl"]
["2016-01-16","2016-01-16","VIR","Epargne","Assurance  retraite"]
["2016-01-16","2016-01-16","VIR","Soins","Remboursement SS"]
["2016-01-16","2016-01-16","VIR","Soins","Remboursement Mut"]
["2016-02-29","2016-01-20","CBP","Divers","Equipements"]
["2016-02-29","2016-01-20","CBP","Divers","Equipements"]
["2016-02-29","2016-01-20","CBP","Divers","Cadeaux"]
["2016-01-20","2016-01-20","PRV","Quotidien","Sortie / Loisir"]
["2016-02-29","2016-01-20","CBM","Quotidien","Courses"]
["2016-02-29","2016-01-20","CBM","Quotidien","Courses"]
["2016-02-29","2016-01-21","CBP","Quotidien","Courses"]
["2016-02-29","2016-01-21","CBP","Quotidien","Courses"]
["2016-01-21","2016-01-21","CBP","Quotidien","Retrait liquide"]
["2016-01-21","2016-01-21","VIR","Soins","Remboursement Mut"]
["2016-02-29","2016-01-22","CBM","Quotidien","Courses"]
["2016-01-22","2016-01-22","VIR","Soins","Remboursement Mut"]
["2016-02-29","2016-01-24","CBP","Divers","Cadeaux"]
["2016-01-24","2016-01-24","CHQ","Divers","Cadeaux"]
["2016-01-25","2016-01-25","VIR","Epargne","Livret A P"]
["2016-02-29","2016-01-25","CBM","Quotidien","Courses"]
["2016-02-29","2016-01-28","CBM","Quotidien","Coiffeur"]
["2016-02-29","2016-01-28","CBM","Quotidien","Courses"]
["2016-02-29","2016-01-28","CBM","Soins","Divers"]
["2016-02-29","2016-01-29","CBM","Quotidien","Courses"]
["2016-02-29","2016-01-29","CBM","Quotidien","Courses"]
["2016-01-30","2016-01-30","PRV","Energie","Gaz"]
["2016-01-30","2016-01-30","PRV","Energie","Electricité"]
["2016-02-29","2016-01-30","CBM","Quotidien","Courses"]
["2016-01-31","2016-01-31","PRV","Pension ","Ex"]