{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Mois","Aide","Impôts","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total année"],"not_rendered":{"charts":39,"images":122,"macros":1,"external_links":0,"defined_names":13,"comments":13,"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":"Mois","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Aide","index":1,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[15,15,18,17],[36,7,39,9],[8,2,11,3],[19,2,22,3],[30,2,33,3],[14,7,17,9],[25,7,28,9]]}
[]
[null,null,"Merci de lire avant de commencer."]
[]
[null,null,"Pour commencer cliquez sur le bouton Menu ci-dessous."]
[]
[]
[]
[]
[null,null,"Pour pouvoir cliquer de nouveau ici cliquer sur le bouton \"Retourner à l'application\""]
[]
[]
[]
[]
[]
[null,null,"Identique à celui-ci :",null,null,null,null,"Le sommaire sert à sélectionner le mois souhaité, a avoir un aperçu des dépenses et revenus de l'année."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ces boutons à bascules servent à masquer ou non le détail de chaque catégorie."]
[]
[]
[]
[null,null,"Pour enregistrer vos modifications cliquer sur la disquette"]
[]
[]
[]
[]
[]
[null,null,"Identique à celui-ci :",null,null,null,null,"L'onglet paramètres impôts sert à calculer vos impôts basique."]
[]
[]
[]
[]
[null,null,"Pour quitter le fichier et enregistrer cliquer sur le bouton éteindre"]
[]
[]
[]
[]
[]
[null,null,"Identique à celui-ci :",null,null,null,null,"L'onglet Remise à zéro sert à effacer les champs que vous avait remplis ; très utile lors d'une nouvelle année."]

{"sheet":"Impôts","index":2,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,12,0,13],[40,0,40,1],[9,1,9,2],[7,1,7,2],[11,1,11,2],[13,1,13,2],[1,9,1,10],[3,9,3,10],[4,9,4,10],[32,0,32,1],[36,0,36,1]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Tranche d'impôts 2015",null,null,"Calcul",null,"Décote"]
[null,"Champs à remplir",null,null,null,null,null,null,null,"CSG et CRDS non déductible",null,0,9690,0,0,0,null,1135]
[null,"Pour calculer plus précisément vôtre impôts sur le revenu",null,null,null,null,null,null,null,2.4E-2,5.0000000000000001E-3,1,26764,0.14000000000000001,1,{"$f":"IF(AND(E37>M2,E37<M3),((E37-M2)*N3),0)","v":0},null,1870]
[null,"Veuillez remplir ces quelques champs",null,null,null,null,null,null,null,"base calcul CSG/ CRDS :",null,2,71754,0.3,2,{"$f":"IF(AND(E37>M3,E37<M4),(((E37-M3)*N4)+((M3-M2)*N3)),0)","v":0},null,{"$f":"IF(G8<>0,2,1)","v":1},{"$f":"IF(AND(R4=1,P8<R2),R2-P8,IF(AND(R4=2,P8<R3),R3-P8,0))","v":1135}]
[null,null,null,null,null,null,null,null,null,0.98250000000000004,null,3,151956,0.41,3,{"$f":"IF(AND(E37>M4,E37<M5),(((M3-M2)*N3)+((M4-M3)*N4)+(E37-M4)*N5),0)","v":0}]
[null,null,null,null,"Salaire 1",null,"Salaire 2",null,null,null,null,4,{"$f":"CONCATENATE(\"plus de \",M5)","v":"plus de 151956"},0.45,4,{"$f":"IF(E37>M5,((M3-M2)*N3)+((M4-M3)*N4)+((M5-M4)*N5)+((E37-M5)*N6),0)","v":0}]
[]
[null,"Salaire brut pour un mois :",null,null,1500,null,null,{"$f":"E8+G8","v":1500},null,null,null,"Tranche",{"$f":"IF(AND(E37>M2,E37<M3),1,IF(AND(E37>M3,E37<M4),2,IF(AND(E37>M4,E37<M5),3,IF(E37>M5,4,0))))","v":0},null,null,{"$f":"SUM(P2:P6)","v":0}]
[]
[null,"Salaire net pour le même mois :",null,null,1171.3499999999999,null,null,{"$f":"+E10+G10","v":1171.3499999999999},null,null,null,null,null,{"$f":"IF(P8-S4<=0,0,IF(AND(R4=1,P8<R2,P8>S4),P8-S4,IF(AND(R4=2,P8<R3,P8>S4),P8-S4,P8)))","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nb part  cas particuliers :",{"$f":"IF(P11<>\"\",R11,+P12+O14)","v":"Seulement numérique"},null,"Seulement numérique",null,{"$f":"IF(ISERR(P11*1),\"Seulement numérique\",P11*1)","v":"Seulement numérique"}]
[null,"Taux de retenu mensuel :",null,null,{"$f":"1-(H10/H8)","v":0.21910000000000007},null,null,null,null,null,null,null,"Nombre de parents :",null,{"$f":"IF(P10=\"Célibataire\",1,IF(P10=\"Marié/Pacsé\",2,0))","v":0},{"$f":"IF(O12=0,1,O12*1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nombre d'enfants :",null,0,{"$f":"O13*1","v":0}]
[null,"Salaire / mois",null,null,"Brut",null,{"$f":"CONCATENATE(\"Brut à \",J5)","v":"Brut à 0,9825"},null,"CSG","CRDS","Total ",null,null,null,{"$f":"P13/2","v":0}]
[]
[null,"Janvier",{"$f":"Janvier!E6+Janvier!E12","v":0},null,{"$f":"C16/(1-$E$12)","v":0},null,{"$f":"E16*$J$5","v":0},null,{"$f":"G16*$J$3","v":0},{"$f":"G16*$K$3","v":0},{"$f":"+I16+J16","v":0},null,"Nb part cas général :",{"$f":"IF(N11=\"Seulement numérique\",+P12+O14,1)","v":1}]
[null,"Février",{"$f":"Février!E6+Février!E12","v":0},null,{"$f":"C17/$E$12","v":0},null,0,null,0,0,{"$f":"+I17+J17","v":0}]
[null,"Mars",{"$f":"Mars!E6+Mars!E12","v":0},null,0,null,0,null,0,0,0]
[null,"Avril",{"$f":"Avril!E6+Avril!E12","v":0},null,0,null,0,null,0,0,0]
[null,"Mai",{"$f":"Mai!E6+Mai!E12","v":0},null,0,null,0,null,0,0,0]
[null,"Juin",{"$f":"Juin!E6+Juin!E12","v":0},null,0,null,0,null,0,0,0]
[null,"Juillet",{"$f":"Juillet!E6+Juillet!E12","v":0},null,0,null,0,null,0,0,0]
[null,"Août",{"$f":"Août!E6+Août!E12","v":0},null,0,null,0,null,0,0,0]
[null,"Septembre",{"$f":"Septembre!E6+Septembre!E12","v":0},null,0,null,0,null,0,0,0]
[null,"Octobre",{"$f":"Octobre!E6+Octobre!E12","v":0},null,0,null,0,null,0,0,0]
[null,"Novembre",{"$f":"Novembre!E6+Novembre!E12","v":0},null,0,null,0,null,0,0,0]
[null,"Décembre",{"$f":"Décembre!E6+Décembre!E12","v":0},null,0,null,0,null,0,0,0]
[]
[null,"Total annuel :",{"$f":"SUM(C16:C27)","v":0},null,{"$f":"SUM(E16:E27)","v":0},null,{"$f":"SUM(G16:G27)","v":0},null,{"$f":"SUM(I16:I27)","v":0},{"$f":"SUM(J16:J27)","v":0},{"$f":"SUM(K16:K27)","v":0}]
[]
[null,"Total imposable :",{"$f":"(C29+K29)","v":0},{"$f":"TRUNC(C31,2)","v":0}]
[]
["Déduction forfaitaire 10 % :",null,{"$f":"C31*0.1","v":0}]
[]
[null,"Frais réel :",{"$f":"IF(D35=\"\",0,D35*1)","v":0},"0"]
[null,{"$f":"IF(D36=\"\",0,D36*1)","v":0},{"$f":"IF(AND(C35<>\"\",C35<>0),C35,C33)","v":0},""]
["Total imposable retenu :",null,{"$f":"(C31-C36)+B36-B38","v":0},"",{"$f":"C37/N16","v":0}]
[null,{"$f":"IF(D37=\"\",0,D37*1)","v":0}]
[null,"Total impôt :",{"$f":"N10","v":0}]
[]
["Si crédit d'impôt antérieur :",null,{"$f":"IF(D41=\"\",0,D41*1)","v":0},""]
[]
[null,"Total impôt dû :",{"$f":"P8-C41","v":0}]
[null,null,{"$f":"TRUNC(C43,0)","v":0}]
[null,null,{"$f":"C44","v":0}]

{"sheet":"Janvier","index":3,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[3,1,3,3],[47,2,47,3],[53,2,53,3],[60,2,60,3],[67,2,67,3],[58,2,58,3],[24,1,24,3],[26,2,26,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[72,2,72,3],[77,2,77,3],[87,1,87,3],[89,1,89,3],[93,1,93,3],[91,1,91,3],[82,2,82,3]]}
[null,null,"Tableau de bord du mois de Janvier"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,"Madame",null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,"Monsieur",null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,"Madame",null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,"Monsieur",null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,"Assurance maladie",null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,"Ventes diverses",null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,"Mutuelles",null,""]
[null,null,4,"Primes non impos",null,""]
[null,null,5,"Cadeaux",null,""]
[null,null,6,"Autres",null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,"Maison",null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,"Voiture",null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,"Consommation",null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,"Maison",null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,"Voiture Mr",null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,"Voiture Madame",null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,"Adultes",null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,"Enfants",null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,"Gaz",null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,"Electricité",null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,"EAU",null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,"Internet",null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,"Téléphones",null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,"Tél enfants",null,""]
[null,null,4,"Autres abonements",null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,"Sur le revenu",null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,"Taxe habitation",null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,"Taxe foncière",null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,"Courses",null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,"Vêtements",null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,"Imprévu(s)",null,""]
[null,null,4,"Divers",null,""]
[null,null,5,"Autres dépenses",null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,"Essence",null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,"Entret/Réparation",null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,"Autres dépenses",null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,"Restaurants",null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,"Soirées",null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,"Autres sorties",null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,"Ecole(s)",null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,"Vêtements",null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,"Autres dépenses",null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,null,null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,null,null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,null,null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Janvier :"]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Janvier :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Février","index":4,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3],[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3]]}
[null,null,"Tableau de bord du mois de Février"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Février :",null,null,{"$f":"Janvier!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Février :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Mars","index":5,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du mois de Mars"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Mars :",null,null,{"$f":"Février!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Mars :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Avril","index":6,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du mois de Avril"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Avril :",null,null,{"$f":"Mars!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Avril :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Mai","index":7,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du mois de Mai"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Mai :",null,null,{"$f":"Avril!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Mai :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Juin","index":8,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du mois de Juin"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Juin :",null,null,{"$f":"Mai!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Juin :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Juillet","index":9,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du mois de Juillet"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Juillet :",null,null,{"$f":"Juin!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Juillet :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Août","index":10,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du mois de Août"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Août :",null,null,{"$f":"Juillet!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Août :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Septembre","index":11,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du mois de Septembre"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Septembre :",null,null,{"$f":"Août!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Septembre :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Octobre","index":12,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du mois de Octobre"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Octobre :",null,null,{"$f":"Septembre!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Octobre :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Novembre","index":13,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du mois de Novembre"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Novembre :",null,null,{"$f":"Octobre!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Novembre :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Décembre","index":14,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,1,87,3],[89,1,89,3],[91,1,91,3],[93,1,93,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du mois de Décembre"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},null,{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},null,{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},null,{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},null,{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},null,{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},null,{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},null,""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},null,""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},null,""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},null,{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},null,{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},null,{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},null,{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},null,{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},null,{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},null,""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},null,{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},null,{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},null,{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},null,{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},null,""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},null,{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},null,{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},null,""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},null,""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},null,{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},null,{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},null,""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},null,{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},null,{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},null,""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},null,""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},null,""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},null,{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},null,{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},null,""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},null,{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},null,{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},null,{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},null,{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},null,{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},null,""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},null,{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},null,{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},null,""]
[]
[null,"Reste à la fin du mois :",null,null,{"$f":"E4-E25","v":0}]
[]
[null,"Solde compte bancaire au 1er Décembre :",null,null,{"$f":"Novembre!$E$94","v":0}]
[]
[null,"Placement du mois :"]
[]
[null,"Solde du compte bancaire à fin Décembre :",null,null,{"$f":"+E90+E88-E92","v":0}]

{"sheet":"Total année","index":15,"n_rows":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":false,"merged":[[89,1,89,3],[91,1,91,3],[58,2,58,3],[60,2,60,3],[67,2,67,3],[72,2,72,3],[77,2,77,3],[82,2,82,3],[53,2,53,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[15,2,15,3],[24,1,24,3],[26,2,26,3],[28,2,28,3],[33,2,33,3],[38,2,38,3],[42,2,42,3],[47,2,47,3]]}
[null,null,"Tableau de bord du total de l'année"]
[]
[]
[null,"Revenu ",null,null,{"$f":"+E6+E12+E16","v":0}]
[]
[null,null,"Salaire principal",null,{"$f":"SUM(E9:E10)","v":0},{"$f":"IF(E6<>0,E6/$E$4,\"\")","v":""}]
[null,null,null,"Intitulés","Montants"]
[]
[null,null,1,{"$f":"IF(Janvier!D9=\"\",\"\",Janvier!D9)","v":"Madame"},{"$f":"+Janvier!E9+Février!E9+Mars!E9+Avril!E9+Mai!E9+Juin!E9+Juillet!E9+Août!E9+Septembre!E9+Octobre!E9+Novembre!E9+Décembre!E9","v":0},{"$f":"IF(AND(E9<>\"\",E9<>0),E9/$E$6,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D10=\"\",\"\",Janvier!D10)","v":"Monsieur"},{"$f":"+Janvier!E10+Février!E10+Mars!E10+Avril!E10+Mai!E10+Juin!E10+Juillet!E10+Août!E10+Septembre!E10+Octobre!E10+Novembre!E10+Décembre!E10","v":0},{"$f":"IF(AND(E10<>\"\",E10<>0),E10/$E$6,\"\")","v":""}]
[]
[null,null,"Prime (imposable)",null,{"$f":"SUM(E13:E14)","v":0},{"$f":"IF(E12<>0,E12/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D13=\"\",\"\",Janvier!D13)","v":"Madame"},{"$f":"+Janvier!E13+Février!E13+Mars!E13+Avril!E13+Mai!E13+Juin!E13+Juillet!E13+Août!E13+Septembre!E13+Octobre!E13+Novembre!E13+Décembre!E13","v":0},{"$f":"IF(AND(E13<>\"\",E13<>0),E13/$E$12,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D14=\"\",\"\",Janvier!D14)","v":"Monsieur"},{"$f":"+Janvier!E14+Février!E14+Mars!E14+Avril!E14+Mai!E14+Juin!E14+Juillet!E14+Août!E14+Septembre!E14+Octobre!E14+Novembre!E14+Décembre!E14","v":0},{"$f":"IF(AND(E14<>\"\",E14<>0),E14/$E$12,\"\")","v":""}]
[]
[null,null,"Autres revenus",null,{"$f":"SUM(E17:E22)","v":0},{"$f":"IF(E16<>0,E16/$E$4,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D17=\"\",\"\",Janvier!D17)","v":"Assurance maladie"},{"$f":"+Janvier!E17+Février!E17+Mars!E17+Avril!E17+Mai!E17+Juin!E17+Juillet!E17+Août!E17+Septembre!E17+Octobre!E17+Novembre!E17+Décembre!E17","v":0},{"$f":"IF(AND(E17<>\"\",E17<>0),E17/$E$16,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D18=\"\",\"\",Janvier!D18)","v":"Ventes diverses"},{"$f":"+Janvier!E18+Février!E18+Mars!E18+Avril!E18+Mai!E18+Juin!E18+Juillet!E18+Août!E18+Septembre!E18+Octobre!E18+Novembre!E18+Décembre!E18","v":0},{"$f":"IF(AND(E18<>\"\",E18<>0),E18/$E$16,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D19=\"\",\"\",Janvier!D19)","v":"Mutuelles"},{"$f":"+Janvier!E19+Février!E19+Mars!E19+Avril!E19+Mai!E19+Juin!E19+Juillet!E19+Août!E19+Septembre!E19+Octobre!E19+Novembre!E19+Décembre!E19","v":0},""]
[null,null,4,{"$f":"IF(Janvier!D20=\"\",\"\",Janvier!D20)","v":"Primes non impos"},{"$f":"+Janvier!E20+Février!E20+Mars!E20+Avril!E20+Mai!E20+Juin!E20+Juillet!E20+Août!E20+Septembre!E20+Octobre!E20+Novembre!E20+Décembre!E20","v":0},""]
[null,null,5,{"$f":"IF(Janvier!D21=\"\",\"\",Janvier!D21)","v":"Cadeaux"},{"$f":"+Janvier!E21+Février!E21+Mars!E21+Avril!E21+Mai!E21+Juin!E21+Juillet!E21+Août!E21+Septembre!E21+Octobre!E21+Novembre!E21+Décembre!E21","v":0},""]
[null,null,6,{"$f":"IF(Janvier!D22=\"\",\"\",Janvier!D22)","v":"Autres"},{"$f":"+Janvier!E22+Février!E22+Mars!E22+Avril!E22+Mai!E22+Juin!E22+Juillet!E22+Août!E22+Septembre!E22+Octobre!E22+Novembre!E22+Décembre!E22","v":0},{"$f":"IF(AND(E22<>\"\",E22<>0),E22/$E$16,\"\")","v":""}]
[]
[]
[null,"Dépenses",null,null,{"$f":"+E27+E59","v":0}]
[]
[null,null,"Fixes",null,{"$f":"+E29+E34+E39+E43+E48+E54","v":0}]
[]
[null,null,"Loyers / Crédits",null,{"$f":"SUM(E30:E32)","v":0},{"$f":"IF(E29<>0,E29/$E$27,\"\")","v":""},{"$f":"IF(AND(E29<>0,E6<>0),E29/($E$6+$E$12),\"\")","v":""},"Loyer / salaire(s)"]
[null,null,1,{"$f":"IF(Janvier!D30=\"\",\"\",Janvier!D30)","v":"Maison"},{"$f":"+Janvier!E30+Février!E30+Mars!E30+Avril!E30+Mai!E30+Juin!E30+Juillet!E30+Août!E30+Septembre!E30+Octobre!E30+Novembre!E30+Décembre!E30","v":0},{"$f":"IF(AND(E30<>\"\",E30<>0),E30/$E$29,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D31=\"\",\"\",Janvier!D31)","v":"Voiture"},{"$f":"+Janvier!E31+Février!E31+Mars!E31+Avril!E31+Mai!E31+Juin!E31+Juillet!E31+Août!E31+Septembre!E31+Octobre!E31+Novembre!E31+Décembre!E31","v":0},{"$f":"IF(AND(E31<>\"\",E31<>0),E31/$E$29,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D32=\"\",\"\",Janvier!D32)","v":"Consommation"},{"$f":"+Janvier!E32+Février!E32+Mars!E32+Avril!E32+Mai!E32+Juin!E32+Juillet!E32+Août!E32+Septembre!E32+Octobre!E32+Novembre!E32+Décembre!E32","v":0},{"$f":"IF(AND(E32<>\"\",E32<>0),E32/$E$29,\"\")","v":""}]
[]
[null,null,"Assurances",null,{"$f":"SUM(E35:E37)","v":0},{"$f":"IF(E34<>0,E34/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D35=\"\",\"\",Janvier!D35)","v":"Maison"},{"$f":"+Janvier!E35+Février!E35+Mars!E35+Avril!E35+Mai!E35+Juin!E35+Juillet!E35+Août!E35+Septembre!E35+Octobre!E35+Novembre!E35+Décembre!E35","v":0},{"$f":"IF(AND(E35<>\"\",E35<>0),E35/$E$34,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D36=\"\",\"\",Janvier!D36)","v":"Voiture Mr"},{"$f":"+Janvier!E36+Février!E36+Mars!E36+Avril!E36+Mai!E36+Juin!E36+Juillet!E36+Août!E36+Septembre!E36+Octobre!E36+Novembre!E36+Décembre!E36","v":0},{"$f":"IF(AND(E36<>\"\",E36<>0),E36/$E$34,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D37=\"\",\"\",Janvier!D37)","v":"Voiture Madame"},{"$f":"+Janvier!E37+Février!E37+Mars!E37+Avril!E37+Mai!E37+Juin!E37+Juillet!E37+Août!E37+Septembre!E37+Octobre!E37+Novembre!E37+Décembre!E37","v":0},""]
[]
[null,null,"Mutuelle",null,{"$f":"SUM(E40:E41)","v":0},{"$f":"IF(E39<>0,E39/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D40=\"\",\"\",Janvier!D40)","v":"Adultes"},{"$f":"+Janvier!E40+Février!E40+Mars!E40+Avril!E40+Mai!E40+Juin!E40+Juillet!E40+Août!E40+Septembre!E40+Octobre!E40+Novembre!E40+Décembre!E40","v":0},{"$f":"IF(AND(E40<>\"\",E40<>0),E40/$E$39,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D41=\"\",\"\",Janvier!D41)","v":"Enfants"},{"$f":"+Janvier!E41+Février!E41+Mars!E41+Avril!E41+Mai!E41+Juin!E41+Juillet!E41+Août!E41+Septembre!E41+Octobre!E41+Novembre!E41+Décembre!E41","v":0},{"$f":"IF(AND(E41<>\"\",E41<>0),E41/$E$39,\"\")","v":""}]
[]
[null,null,"Énergie",null,{"$f":"SUM(E44:E46)","v":0},{"$f":"IF(E43<>0,E43/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D44=\"\",\"\",Janvier!D44)","v":"Gaz"},{"$f":"+Janvier!E44+Février!E44+Mars!E44+Avril!E44+Mai!E44+Juin!E44+Juillet!E44+Août!E44+Septembre!E44+Octobre!E44+Novembre!E44+Décembre!E44","v":0},{"$f":"IF(AND(E44<>\"\",E44<>0),E44/$E$43,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D45=\"\",\"\",Janvier!D45)","v":"Electricité"},{"$f":"+Janvier!E45+Février!E45+Mars!E45+Avril!E45+Mai!E45+Juin!E45+Juillet!E45+Août!E45+Septembre!E45+Octobre!E45+Novembre!E45+Décembre!E45","v":0},{"$f":"IF(AND(E45<>\"\",E45<>0),E45/$E$43,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D46=\"\",\"\",Janvier!D46)","v":"EAU"},{"$f":"+Janvier!E46+Février!E46+Mars!E46+Avril!E46+Mai!E46+Juin!E46+Juillet!E46+Août!E46+Septembre!E46+Octobre!E46+Novembre!E46+Décembre!E46","v":0},""]
[]
[null,null,"Forfait / Divers",null,{"$f":"SUM(E49:E52)","v":0},{"$f":"IF(E48<>0,E48/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D49=\"\",\"\",Janvier!D49)","v":"Internet"},{"$f":"+Janvier!E49+Février!E49+Mars!E49+Avril!E49+Mai!E49+Juin!E49+Juillet!E49+Août!E49+Septembre!E49+Octobre!E49+Novembre!E49+Décembre!E49","v":0},{"$f":"IF(AND(E49<>\"\",E49<>0),E49/$E$48,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D50=\"\",\"\",Janvier!D50)","v":"Téléphones"},{"$f":"+Janvier!E50+Février!E50+Mars!E50+Avril!E50+Mai!E50+Juin!E50+Juillet!E50+Août!E50+Septembre!E50+Octobre!E50+Novembre!E50+Décembre!E50","v":0},{"$f":"IF(AND(E50<>\"\",E50<>0),E50/$E$48,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D51=\"\",\"\",Janvier!D51)","v":"Tél enfants"},{"$f":"+Janvier!E51+Février!E51+Mars!E51+Avril!E51+Mai!E51+Juin!E51+Juillet!E51+Août!E51+Septembre!E51+Octobre!E51+Novembre!E51+Décembre!E51","v":0},""]
[null,null,4,{"$f":"IF(Janvier!D52=\"\",\"\",Janvier!D52)","v":"Autres abonements"},{"$f":"+Janvier!E52+Février!E52+Mars!E52+Avril!E52+Mai!E52+Juin!E52+Juillet!E52+Août!E52+Septembre!E52+Octobre!E52+Novembre!E52+Décembre!E52","v":0},""]
[]
[null,null,"Impôts",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"IF(E54<>0,E54/$E$27,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D55=\"\",\"\",Janvier!D55)","v":"Sur le revenu"},{"$f":"+Janvier!E55+Février!E55+Mars!E55+Avril!E55+Mai!E55+Juin!E55+Juillet!E55+Août!E55+Septembre!E55+Octobre!E55+Novembre!E55+Décembre!E55","v":0},{"$f":"IF(AND(E55<>\"\",E55<>0),E55/$E$54,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D56=\"\",\"\",Janvier!D56)","v":"Taxe habitation"},{"$f":"+Janvier!E56+Février!E56+Mars!E56+Avril!E56+Mai!E56+Juin!E56+Juillet!E56+Août!E56+Septembre!E56+Octobre!E56+Novembre!E56+Décembre!E56","v":0},{"$f":"IF(AND(E56<>\"\",E56<>0),E56/$E$54,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D57=\"\",\"\",Janvier!D57)","v":"Taxe foncière"},{"$f":"+Janvier!E57+Février!E57+Mars!E57+Avril!E57+Mai!E57+Juin!E57+Juillet!E57+Août!E57+Septembre!E57+Octobre!E57+Novembre!E57+Décembre!E57","v":0},""]
[]
[null,null,"Variables",null,{"$f":"+E61+E68+E73+E78+E83","v":0}]
[]
[null,null,"Dépenses courantes",null,{"$f":"SUM(E62:E66)","v":0},{"$f":"IF(E61<>0,E61/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D62=\"\",\"\",Janvier!D62)","v":"Courses"},{"$f":"+Janvier!E62+Février!E62+Mars!E62+Avril!E62+Mai!E62+Juin!E62+Juillet!E62+Août!E62+Septembre!E62+Octobre!E62+Novembre!E62+Décembre!E62","v":0},{"$f":"IF(AND(E62<>\"\",E62<>0),E62/$E$61,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D63=\"\",\"\",Janvier!D63)","v":"Vêtements"},{"$f":"+Janvier!E63+Février!E63+Mars!E63+Avril!E63+Mai!E63+Juin!E63+Juillet!E63+Août!E63+Septembre!E63+Octobre!E63+Novembre!E63+Décembre!E63","v":0},{"$f":"IF(AND(E63<>\"\",E63<>0),E63/$E$61,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D64=\"\",\"\",Janvier!D64)","v":"Imprévu(s)"},{"$f":"+Janvier!E64+Février!E64+Mars!E64+Avril!E64+Mai!E64+Juin!E64+Juillet!E64+Août!E64+Septembre!E64+Octobre!E64+Novembre!E64+Décembre!E64","v":0},""]
[null,null,4,{"$f":"IF(Janvier!D65=\"\",\"\",Janvier!D65)","v":"Divers"},{"$f":"+Janvier!E65+Février!E65+Mars!E65+Avril!E65+Mai!E65+Juin!E65+Juillet!E65+Août!E65+Septembre!E65+Octobre!E65+Novembre!E65+Décembre!E65","v":0},""]
[null,null,5,{"$f":"IF(Janvier!D66=\"\",\"\",Janvier!D66)","v":"Autres dépenses"},{"$f":"+Janvier!E66+Février!E66+Mars!E66+Avril!E66+Mai!E66+Juin!E66+Juillet!E66+Août!E66+Septembre!E66+Octobre!E66+Novembre!E66+Décembre!E66","v":0},""]
[]
[null,null,"Transports, véhicules",null,{"$f":"SUM(E69:E71)","v":0},{"$f":"IF(E68<>0,E68/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D69=\"\",\"\",Janvier!D69)","v":"Essence"},{"$f":"+Janvier!E69+Février!E69+Mars!E69+Avril!E69+Mai!E69+Juin!E69+Juillet!E69+Août!E69+Septembre!E69+Octobre!E69+Novembre!E69+Décembre!E69","v":0},{"$f":"IF(AND(E69<>\"\",E69<>0),E69/$E$68,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D70=\"\",\"\",Janvier!D70)","v":"Entret/Réparation"},{"$f":"+Janvier!E70+Février!E70+Mars!E70+Avril!E70+Mai!E70+Juin!E70+Juillet!E70+Août!E70+Septembre!E70+Octobre!E70+Novembre!E70+Décembre!E70","v":0},{"$f":"IF(AND(E70<>\"\",E70<>0),E70/$E$68,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D71=\"\",\"\",Janvier!D71)","v":"Autres dépenses"},{"$f":"+Janvier!E71+Février!E71+Mars!E71+Avril!E71+Mai!E71+Juin!E71+Juillet!E71+Août!E71+Septembre!E71+Octobre!E71+Novembre!E71+Décembre!E71","v":0},""]
[]
[null,null,"Sorties / hobbies",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"IF(E73<>0,E73/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D74=\"\",\"\",Janvier!D74)","v":"Restaurants"},{"$f":"+Janvier!E74+Février!E74+Mars!E74+Avril!E74+Mai!E74+Juin!E74+Juillet!E74+Août!E74+Septembre!E74+Octobre!E74+Novembre!E74+Décembre!E74","v":0},{"$f":"IF(AND(E74<>\"\",E74<>0),E74/$E$73,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D75=\"\",\"\",Janvier!D75)","v":"Soirées"},{"$f":"+Janvier!E75+Février!E75+Mars!E75+Avril!E75+Mai!E75+Juin!E75+Juillet!E75+Août!E75+Septembre!E75+Octobre!E75+Novembre!E75+Décembre!E75","v":0},{"$f":"IF(AND(E75<>\"\",E75<>0),E75/$E$73,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D76=\"\",\"\",Janvier!D76)","v":"Autres sorties"},{"$f":"+Janvier!E76+Février!E76+Mars!E76+Avril!E76+Mai!E76+Juin!E76+Juillet!E76+Août!E76+Septembre!E76+Octobre!E76+Novembre!E76+Décembre!E76","v":0},{"$f":"IF(AND(E76<>\"\",E76<>0),E76/$E$73,\"\")","v":""}]
[]
[null,null,"Enfants",null,{"$f":"SUM(E79:E81)","v":0},{"$f":"IF(E78<>0,E78/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D79=\"\",\"\",Janvier!D79)","v":"Ecole(s)"},{"$f":"+Janvier!E79+Février!E79+Mars!E79+Avril!E79+Mai!E79+Juin!E79+Juillet!E79+Août!E79+Septembre!E79+Octobre!E79+Novembre!E79+Décembre!E79","v":0},{"$f":"IF(AND(E79<>\"\",E79<>0),E79/$E$78,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D80=\"\",\"\",Janvier!D80)","v":"Vêtements"},{"$f":"+Janvier!E80+Février!E80+Mars!E80+Avril!E80+Mai!E80+Juin!E80+Juillet!E80+Août!E80+Septembre!E80+Octobre!E80+Novembre!E80+Décembre!E80","v":0},{"$f":"IF(AND(E80<>\"\",E80<>0),E80/$E$78,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D81=\"\",\"\",Janvier!D81)","v":"Autres dépenses"},{"$f":"+Janvier!E81+Février!E81+Mars!E81+Avril!E81+Mai!E81+Juin!E81+Juillet!E81+Août!E81+Septembre!E81+Octobre!E81+Novembre!E81+Décembre!E81","v":0},""]
[]
[null,null,"Autres dépenses",null,{"$f":"SUM(E84:E86)","v":0},{"$f":"IF(E83<>0,E83/$E$59,\"\")","v":""}]
[null,null,1,{"$f":"IF(Janvier!D84=\"\",\"\",Janvier!D84)","v":""},{"$f":"+Janvier!E84+Février!E84+Mars!E84+Avril!E84+Mai!E84+Juin!E84+Juillet!E84+Août!E84+Septembre!E84+Octobre!E84+Novembre!E84+Décembre!E84","v":0},{"$f":"IF(AND(E84<>\"\",E84<>0),E84/$E$83,\"\")","v":""}]
[null,null,2,{"$f":"IF(Janvier!D85=\"\",\"\",Janvier!D85)","v":""},{"$f":"+Janvier!E85+Février!E85+Mars!E85+Avril!E85+Mai!E85+Juin!E85+Juillet!E85+Août!E85+Septembre!E85+Octobre!E85+Novembre!E85+Décembre!E85","v":0},{"$f":"IF(AND(E85<>\"\",E85<>0),E85/$E$83,\"\")","v":""}]
[null,null,3,{"$f":"IF(Janvier!D86=\"\",\"\",Janvier!D86)","v":""},{"$f":"+Janvier!E86+Février!E86+Mars!E86+Avril!E86+Mai!E86+Juin!E86+Juillet!E86+Août!E86+Septembre!E86+Octobre!E86+Novembre!E86+Décembre!E86","v":0},""]
[]
[]
[]
[null,"Solde compte bancaire à fin Décembre :",null,null,{"$f":"Décembre!$E$94","v":0}]
[]
[null,"Placement sur l'année :",null,null,{"$f":"+Janvier!E92+Février!E92+Mars!E92+Avril!E92+Mai!E92+Juin!E92+Juillet!E92+Août!$E$92+Septembre!$E$92+Octobre!$E$92+Novembre!$E$92+Décembre!E92","v":0}]