{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Accueil","Profils et liens","Mon budget","Mes Enveloppes","Budgets types","Enveloppes-types","Comparaisons","Budget annuel","Annuel à imprimer","Feuille à imprimer","Données"],"not_rendered":{"charts":4,"images":47,"macros":1,"external_links":0,"defined_names":11,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":58,"n_cols":16,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,1,58,6],[45,5,49,5],[36,4,40,4],[8,1,12,1],[18,2,22,2],[28,3,32,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zoom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[]
[]
[]
[]
[]
[null,1,null,null,null,"D'abord, vous répartissez l'argent que vous avez à disposition dans les dix petites enveloppes."]
[]
[null,null,null,null,null,"Renseignez-vous pour obtenir les prix les plus justes pour vos dépenses. "]
[null,null,null,null,null,"La feuille \"Profils et liens\" peut vous aider si vous êtes connectés à Internet."]
[]
[null,null,null,null,null,"L'argent qui reste dans la grande enveloppe est épargné."]
[]
[]
[null,null,null,null,null,null,"La deuxième étape consiste à saisir de façon détaillée, dans les cases grises de la feuille"]
[null,null,null,null,null,null,"\"Mon budget\", les montants que vous avez alloués à chaque poste."]
[null,null,2]
[null,null,null,null,null,null,"     Deux possibilités : ",null,null," - Vous activez le bouton \"Revenu donné\" et vous entrez le montant à disposition dans"]
[null,null,null,null,null,null,null,null,null,"   la première case grise. Dans ce cas, l'épargne est constituée par l'argent non dépensé."]
[]
[null,null,null,null,null,null,null,null,null," - Vous n'activez pas le bouton \"Revenu donné\". Dans ce cas, le montant"]
[null,null,null,null,null,null,null,null,null,"   à disposition est le montant dépensé."]
[]
[]
[null,null,null,null,null,null,null,"Ensuite, il vous faut comparer le contenu de vos enveloppes avec"]
[null,null,null,null,null,null,null,"celles de l'écran \"Mes Enveloppes\"."]
[null,null,null,3]
[null,null,null,null,null,null,null,"Analysez la réalité économique visualisée par les enveloppes (et le graphique) et réfléchissez"]
[null,null,null,null,null,null,null,"à son incidence sur votre avenir."]
[null,null,null,null,null,null,null,"Vous pouvez encore procéder à quelques ajustements…"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"La quatrième étape vous permettra de confronter votre"]
[null,null,null,null,4,null,null,null,"propre budget à  un budget type proche de votre situation."]
[]
[null,null,null,null,null,null,null,null,"Le but du jeu étant de s'approcher le plus possible d'un budget type; le gagnant "]
[null,null,null,null,null,null,null,null,"sera celui qui aura le moins d'écart avec le budget proposé, donc le plus petit score. "]
[null,null,null,null,null,null,null,null,"Cliquer sur le bouton \"Voir le score\" de la feuille \"Budgets types\""]
[null,null,null,null,null,null,null,null,"après avoir activé la comparaison avec son budget."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Lors de la  dernière étape vous devrez reprendre votre budget mensuel "]
[null,null,null,null,null,5,null,null,null,null,"et l'organiser cette fois sur 12 mois."]
[]
[null,null,null,null,null,null,null,null,null,null,"C'est l'occasion de distinguer les dépenses fixes, mensuelles ou non, "]
[null,null,null,null,null,null,null,null,null,null,"des dépenses variables plus ou moins prévisibles."]
[]
[null,null,null,null,null,null,null,null,null,null,"Attention, le bouton \"Voir l'événement de l'année\" va vous imposer"]
[null,null,null,null,null,null,null,null,null,null,"des contraintes inattendues !"]
[]
[]
[]
[]
[]
[null,"  © Yvan Péguiron / Iconomix - octobre 2010 - version 5.6"]

{"sheet":"Profils et liens","index":1,"n_rows":38,"n_cols":29,"rows_kept":38,"cut":false,"hidden":false,"merged":[[34,6,35,10],[37,6,38,10],[34,2,35,2],[37,2,38,2],[1,19,32,26],[24,11,24,12],[28,6,29,10],[31,6,32,10],[28,2,29,2],[31,2,32,2],[4,1,4,7],[1,1,3,2],[24,1,24,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,"Profil des familles du jeu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nom des Pictures"]
[null,null,null,{"$f":"Données!F30","v":"Logement"},{"$f":"Données!G30","v":"Voiture"},{"$f":"Données!H30","v":"Enfants"},{"$f":"Données!I30","v":"Revenu net"},{"$f":"Données!J30","v":"Revenu brut"},"Fiche salaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Picture 49"]
[null,{"$f":"Données!A32","v":1},{"$f":"Données!C32","v":"  Jeune célibataire"},{"$f":"Données!F32","v":"2 pièces"},{"$f":"Données!G32","v":"non"},{"$f":"Données!H32","v":"non"},{"$f":"Données!I32","v":4730},{"$f":"Données!J32","v":5400},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Picture 69"]
[null,{"$f":"Données!A33","v":2},{"$f":"Données!C33","v":"  Famille monoparentale"},{"$f":"Données!F33","v":"2 pièces"},{"$f":"Données!G33","v":"non"},{"$f":"Données!H33","v":"12 ans"},{"$f":"Données!I33","v":5050},{"$f":"Données!J33","v":5600},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Picture 77"]
[null,{"$f":"Données!A34","v":3},{"$f":"Données!C34","v":"  Couple de seniors"},{"$f":"Données!F34","v":"3 pièces"},{"$f":"Données!G34","v":"non"},{"$f":"Données!H34","v":"non"},{"$f":"Données!I34","v":6390},{"$f":"Données!J34","v":6390},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Picture 52"]
[null,{"$f":"Données!A35","v":4},{"$f":"Données!C35","v":"  Couple modeste"},{"$f":"Données!F35","v":"2 1/2 pièces"},{"$f":"Données!G35","v":"non"},{"$f":"Données!H35","v":"non"},{"$f":"Données!I35","v":5830},{"$f":"Données!J35","v":6700},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Picture 53"]
[null,{"$f":"Données!A36","v":5},{"$f":"Données!C36","v":"  Famille avec 2 petits enfants"},{"$f":"Données!F36","v":"4 pièces"},{"$f":"Données!G36","v":"1 petite"},{"$f":"Données!H36","v":"4 et 8 ans"},{"$f":"Données!I36","v":7220},{"$f":"Données!J36","v":7900},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Picture 54"]
[null,{"$f":"Données!A37","v":6},{"$f":"Données!C37","v":"  Famille avec 2 grands enfants"},{"$f":"Données!F37","v":"4 1/2 pièces"},{"$f":"Données!G37","v":"1 moyenne"},{"$f":"Données!H37","v":"14 et 17 ans"},{"$f":"Données!I37","v":8740},{"$f":"Données!J37","v":9500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Picture 55"]
[null,{"$f":"Données!A38","v":7},{"$f":"Données!C38","v":"  Famille classe moyenne sup."},{"$f":"Données!F38","v":"5 pièces"},{"$f":"Données!G38","v":"1 grande"},{"$f":"Données!H38","v":"10 et 15 ans"},{"$f":"Données!I38","v":11020},{"$f":"Données!J38","v":12000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Picture 56"]
[null,{"$f":"Données!A39","v":8},{"$f":"Données!C39","v":"  Famille avec Villa"},{"$f":"Données!F39","v":"villa 6 pièces"},{"$f":"Données!G39","v":"2 voitures"},{"$f":"Données!H39","v":"8, 13, 16 ans"},{"$f":"Données!I39","v":12130},{"$f":"Données!J39","v":13000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Picture 57"]
[null,{"$f":"Données!A40","v":9},{"$f":"Données!C40","v":"  Jeune couple non marié, 1 enfant"},{"$f":"Données!F40","v":"3 1/2 pièces"},{"$f":"Données!G40","v":"1 voit, 1 moto"},{"$f":"Données!H40","v":"1 an"},{"$f":"Données!I40","v":7410},{"$f":"Données!J40","v":8200},null,null,null,{"$f":"'Feuille à imprimer'!J35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Picture 58"]
[null,{"$f":"Données!A41","v":10},{"$f":"Données!C41","v":"  Célibataire - exemple Raiffeisen"},{"$f":"Données!F41","v":"2 pièces"},{"$f":"Données!G41","v":"1 moyenne"},{"$f":"Données!H41","v":"non"},{"$f":"Données!I41","v":5200},{"$f":"Données!J41","v":5960},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Picture 76"]
[null,{"$f":"Données!A42","v":11},{"$f":"Données!C42","v":"  Couple d'indépendants - 1 enfant"},{"$f":"Données!F42","v":"3 1/2 pièces"},{"$f":"Données!G42","v":"1 moyenne"},{"$f":"Données!H42","v":"6 ans"},{"$f":"Données!I42","v":9470},{"$f":"Données!J42","v":10525}]
[null,null,{"$f":"Données!C43","v":"   "},{"$f":"Données!F43","v":0},{"$f":"Données!G43","v":0},{"$f":"Données!H43","v":0},{"$f":"Données!I43","v":""},{"$f":"Données!J43","v":""}]
[null,null,{"$f":"Données!C44","v":"  Moyenne suisse* (ménage  2,23 pers.)"},{"$f":"Données!F44","v":"3 pièces"},{"$f":"Données!G44","v":"1 moyenne"},{"$f":"Données!H44","v":"1,23 enf."},{"$f":"Données!I44","v":7654},{"$f":"Données!J44","v":8492},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"choix :",{"$f":"VLOOKUP(N1,AB6:AC17,2)","v":{"$error":"#N/A"}}]
[null,null,"*selon T20.02.01.06 / bfs.admin.ch (Enquête sur le budget des ménages - OFS 2007)"]
[]
[]
[]
[]
[null,"      Liens pour renseignements"]
[]
[]
[]
[null,null,"Prix des logements en Suisse",null,null,null,"http://www.immostreet.ch/"]
[]
[]
[null,null,"Primes d'assurances ",null,null,null,"http://fr.comparis.ch/"]
[]
[]
[null,null,"Simulateur fiscal pour tous les cantons suisses",null,null,null,"http://www.estv2.admin.ch/f/dienstleistungen/steuerrechner/steuerrechner.htm"]
[]
[]
[null,null,"Calculateur de salaires de l'Union Syndicale Suisse",null,null,null,"http://www.lohnrechner.ch/index.F.html"]

{"sheet":"Mon budget","index":2,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[[7,11,10,13],[44,1,44,5],[46,3,46,5],[50,1,50,5],[49,0,49,1],[11,7,12,7],[14,7,15,7],[21,7,22,7],[26,7,27,7],[29,7,31,7],[51,1,51,5],[48,1,48,6],[43,1,43,2],[4,1,4,5],[9,1,9,2],[8,3,10,3],[42,0,42,1],[33,7,34,7],[36,7,39,7],[42,7,43,7],[0,1,0,6],[1,1,1,6],[2,1,2,6],[3,1,3,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[null,"Saisie du budget personnel",null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Recettes nettes"]
[null,"Total",{"$f":"IF(D7>0,\"CHF\",\"\")","v":""},{"$f":"SUM(D12:D44)","v":0},null,{"$f":"IF(P1=FALSE,\"\",IF(D7=0,\"                                          Entrez le montant du revenu mensuel !\",\"\"))","v":""},null,{"$f":"SUM(H11:H43)","v":0},{"$f":"IF(F7=\"\",SUM(I11:I43),\"\")","v":0},null,null,null,{"$f":"SUM(D12:D44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Budget en mémoire"]
[null,null,{"$f":"IF(D9>0,\"CHF\",\"\")","v":""}]
[null,"Dépenses mensuelles"]
[null,null,{"$f":"IF(D11>0,\"CHF\",\"\")","v":""}]
[1,"Logement",{"$f":"IF(D12>0,\"CHF\",\"\")","v":""},null,null,"loyer + charges (chauffage)",null,{"$f":"D12+D13","v":0},{"$f":"IF(H12=0,0,H12/$H$7)","v":0},null,"Logement"]
[null,null,{"$f":"IF(D13>0,\"CHF\",\"\")","v":""},null,null,"électricité / gaz",null,null,{"$f":"IF(H13=0,0,H13/$H$7)","v":0}]
[null,null,null,null,null,null,null,null,0]
[2,"Assurances",{"$f":"IF(D15>0,\"CHF\",\"\")","v":""},null,null,"maladie / accident (couverture de base) / charges sociales pour les indépendants",null,{"$f":"SUM(D15:D16)","v":0},0,null,"Assurances"]
[null,null,{"$f":"IF(D16>0,\"CHF\",\"\")","v":""},null,null,"assurance incendie, ménage et responsabilité civile"]
[null,null,null,null,null,null,null,null,0]
[3,"Impôts",{"$f":"IF(D18>0,\"CHF\",\"\")","v":""},null,null,"(la charge fiscale varie en fonction du canton)",null,{"$f":"D18","v":0},0,null,"Impôts"]
[null,null,null,null,null,null,null,null,0]
[4,"Alimentation",{"$f":"IF(D20>0,\"CHF\",\"\")","v":""},null,null,"nourriture / boissons",null,{"$f":"D20","v":0},0,null,"Alimentation"]
[null,null,null,null,null,null,null,null,0]
[5,"Ménage",{"$f":"IF(D22>0,\"CHF\",\"\")","v":""},null,null,"produits de lavage et de nettoyage / produits pour le corps / taxes / frais postaux",null,{"$f":"D22+D23","v":0},0,null,"Ménage"]
[null,null,{"$f":"IF(D23>0,\"CHF\",\"\")","v":""},null,null,"équipement ménager - réparations",null,null,0]
[null,null,null,null,null,null,null,null,0]
[6,"Habillement",{"$f":"IF(D25>0,\"CHF\",\"\")","v":""},null,null,"habillement / pressing / chaussures",null,{"$f":"D25","v":0},0,null,"Habillement"]
[null,null,null,null,null,null,null,null,0]
[7,"Transports",{"$f":"IF(D27>0,\"CHF\",\"\")","v":""},null,null,"transports publics",null,{"$f":"D27+D28","v":0},0,null,"Transports"]
[null,null,{"$f":"IF(D28>0,\"CHF\",\"\")","v":""},null,null,"voiture (taxes / assurances / carburant / entretien) - sans amortissement",null,null,0]
[null,null,null,null,null,null,null,null,0]
[8,"Abonnements",{"$f":"IF(D30>0,\"CHF\",\"\")","v":""},null,null,"presse / cotisations",null,{"$f":"D30+D31+D32","v":0},0,null,"Abonnements"]
[null,null,{"$f":"IF(D31>0,\"CHF\",\"\")","v":""},null,null,"téléphone / radio / télévision",null,null,0]
[null,null,{"$f":"IF(D32>0,\"CHF\",\"\")","v":""},null,null,"fomation / écolage / camps",null,null,0]
[null,null,null,null,null,null,null,null,0]
[9,"Dép. personnelles",{"$f":"IF(D34>0,\"CHF\",\"\")","v":""},null,null,"soins corporels / coiffeur / argent de poche / cigarettes / alcool",null,{"$f":"SUM(D34:D35)","v":0},0,null,"Dép. perso."]
[null,null,{"$f":"IF(D35>0,\"CHF\",\"\")","v":""},null,null,"loisirs / culture / sport"]
[null,null,null,null,null,null,null,null,0]
[10,"Divers",{"$f":"IF(D37>0,\"CHF\",\"\")","v":""},null,null,"franchise / médecin / dentiste / opticien",null,{"$f":"D37+D38+D39+D40","v":0},0,null,"Divers"]
[null,null,{"$f":"IF(D38>0,\"CHF\",\"\")","v":""},null,null,"cadeaux",null,null,0]
[null,null,{"$f":"IF(D39>0,\"CHF\",\"\")","v":""},null,null,"achats / restauration / vacances / imprévus",null,null,0]
[null,null,{"$f":"IF(D40>0,\"CHF\",\"\")","v":""},null,null,"autres",null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
["Solde/Prévoyance",null,{"$f":"IF(D43>0,\"CHF\",\"\")","v":""},null,null,"prévoyance 3e pilier / épargne forcée",null,{"$f":"D43+D44","v":0},0,null,"Prévoyance"]
[null,{"$f":"IF(D44<0,\"Pas possible !\",IF(D44>0,\"CHF\",\"\"))","v":""},null,null,null,{"$f":"IF(P1=TRUE,\"reste pour l'épargne\",\"épargne\")","v":"épargne"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M12:M44)","v":0}]
[{"$f":"IF(M45=0,\"\",\"      1 budget en mémoire\")","v":""}]
[null,{"$f":"IF(M45=0,\"\",\"voir : Ctrl + m\")","v":""},null,{"$f":"B49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"cacher : Ctrl + m"]
[]
["      Exemple Ctrl + E"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M45>0,\"Remettre budget mémorisé\",IF(D7=0,\"\",\"Mémoriser ce budget\"))","v":""},"<- Texte"]
[{"$f":"Accueil!B58","v":"  © Yvan Péguiron / Iconomix - octobre 2010 - version 5.6"}]

{"sheet":"Mes Enveloppes","index":3,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,0,22,1],[1,18,1,19],[0,1,0,9],[19,8,19,9],[20,8,20,9],[18,6,18,8],[16,6,16,8],[17,6,17,8]]}
[null,"Mon budget"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mon budget "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"graphique","budget",null,"graphique","budget"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,true,true]
[null,null,{"$f":"'Mon budget'!B12","v":"Logement"},null,{"$f":"'Mon budget'!B15","v":"Assurances"},null,{"$f":"'Mon budget'!B18","v":"Impôts"},null,{"$f":"'Mon budget'!B20","v":"Alimentation"},null,null,null,null,null,null,null,null,null,"Logement",{"$f":"C8","v":0},null,"Logement",{"$f":"C9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assurances",{"$f":"E8","v":0},null,"Assurances",{"$f":"E9","v":0}]
[null,null,{"$f":"'Mon budget'!H12","v":0},null,{"$f":"'Mon budget'!H15","v":0},null,{"$f":"'Mon budget'!H18","v":0},null,{"$f":"'Mon budget'!H20","v":0},null,null,null,null,null,null,null,null,null,"Impôts",{"$f":"G8","v":0},null,"Impôts",{"$f":"G9","v":0}]
[null,null,{"$f":"'Budgets types'!E12","v":0},null,{"$f":"'Budgets types'!E15","v":0},null,{"$f":"'Budgets types'!E18","v":0},null,{"$f":"'Budgets types'!E20","v":0},null,null,null,null,null,null,null,null,null,"Alimentation",{"$f":"I8","v":0},null,"Alimentation",{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ménage",{"$f":"C13","v":0},null,"Ménage",{"$f":"C14","v":0}]
[null,null,{"$f":"'Mon budget'!B22","v":"Ménage"},null,{"$f":"'Mon budget'!B25","v":"Habillement"},null,{"$f":"'Mon budget'!B27","v":"Transports"},null,{"$f":"'Mon budget'!B30","v":"Abonnements"},null,null,null,null,null,null,null,null,null,"Habillement",{"$f":"E13","v":0},null,"Habillement",{"$f":"E14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transports",{"$f":"G13","v":0},null,"Transports",{"$f":"G14","v":0}]
[null,null,{"$f":"'Mon budget'!H22","v":0},null,{"$f":"'Mon budget'!H25","v":0},null,{"$f":"'Mon budget'!H27","v":0},null,{"$f":"'Mon budget'!H30","v":0},null,null,null,null,null,null,null,null,null,"Abonnements",{"$f":"I13","v":0},null,"Abonnements",{"$f":"I14","v":0}]
[null,null,{"$f":"'Budgets types'!E22","v":0},null,{"$f":"'Budgets types'!E25","v":0},null,{"$f":"'Budgets types'!E27","v":0},null,{"$f":"'Budgets types'!E30","v":0},null,null,null,null,null,null,null,null,null,"Dép. personnelles",{"$f":"C18","v":0},null,"Dép. personnelles",{"$f":"C19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Divers",{"$f":"E18","v":0},null,"Divers",{"$f":"E19","v":0}]
[null,null,{"$f":"'Mon budget'!B34","v":"Dép. personnelles"},null,{"$f":"'Mon budget'!B37","v":"Divers"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Epargne",{"$f":"G18","v":0},null,"Epargne",{"$f":"G19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(T6:T16)","v":0},null,"Total",{"$f":"SUM(W6:W16)","v":0}]
[null,null,{"$f":"'Mon budget'!H34","v":0},null,{"$f":"'Mon budget'!H37","v":0},null,{"$f":"'Mon budget'!H43","v":0}]
[null,null,{"$f":"'Budgets types'!E34","v":0},null,{"$f":"'Budgets types'!E37","v":0},null,{"$f":"'Budgets types'!E43","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Mon budget'!D7","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Budgets types'!D7","v":0}]
[]
["En vert : ",null,{"$f":"VLOOKUP('Budgets types'!$R$10,Titres,2)","v":"  "}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(T5=FALSE,\"Contrôle visuel\",\"&\"&C23)","v":"Contrôle visuel"},null,null,null,null,null,{"$f":"IF(I20=0,\"\",IF(I21=0,\"Revenu net\",\"Revenus nets\"))","v":""}]

{"sheet":"Budgets types","index":4,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[[52,1,52,5],[48,1,48,6],[49,1,49,6],[50,1,50,5],[51,1,51,5],[36,4,39,4],[42,4,43,4],[44,1,44,4],[46,1,46,5],[47,1,47,5],[11,4,12,4],[14,4,15,4],[21,4,22,4],[26,4,27,4],[29,4,31,4],[33,4,34,4],[33,1,34,1],[0,1,0,6],[1,1,1,6],[2,1,2,6],[3,1,3,6],[1,7,4,9],[4,1,4,5],[29,5,31,5],[33,5,34,5],[36,5,39,5],[42,5,43,5],[11,5,12,5],[14,5,15,5],[21,5,22,5],[26,5,27,5],[29,11,31,11],[33,11,34,11],[36,11,39,11],[42,11,43,11],[11,11,12,11],[14,11,15,11],[21,11,22,11],[26,11,27,11],[21,9,22,9],[21,10,22,10],[26,9,27,9],[26,10,27,10],[11,9,12,9],[11,10,12,10],[14,9,15,9],[14,10,15,10],[36,9,39,9],[36,10,39,10],[42,9,43,9],[42,10,43,10],[29,9,31,9],[29,10,31,10],[33,9,34,9],[33,10,34,10]]}
[]
[null,null,null,null,null,null,null,"Comparaison avec mon budget"]
[]
[null,{"$f":"VLOOKUP(R10,Titres,2)","v":"  "}]
[]
[null,"Revenus nets"]
[null,"Total",{"$f":"IF(D7>0,\"CHF\",\"\")","v":""},{"$f":"SUM(D12:D44)","v":0},null,null,null,null,{"$f":"'Mon budget'!D7","v":0}]
[]
[null,null,{"$f":"IF(D9>0,\"CHF\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Comparaison",false]
[null,"Dépenses","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Choix",1,"dif. Abs."]
[null,null,"",null,null,null,null,null,null,null,{"$f":"'Mon budget'!H11","v":0},null,{"$f":"'Mon budget'!I11","v":0}]
[1,"Logement","",null,{"$f":"SUM(D12:D13)","v":0},{"$f":"IF(E12=0,\"\",E12/$D$7)","v":""},"loyer + charges (chauffage)",{"$f":"IF(I12>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D12","v":0},{"$f":"SUM(I12:I13)","v":0},{"$f":"IF(J12=0,0,J12/$I$7)","v":0},"Logement",null,null,null,null,"Enveloppes",false,{"$f":"ABS(F12-K12)*100","v":{"$error":"#VALUE!"}}]
[null,null,"",null,null,null,"électricité / gaz",{"$f":"IF(I13>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D13","v":0}]
[null,null,"",null,null,null,null,{"$f":"IF(I14>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D14","v":0}]
[2,"Assurances","",null,{"$f":"SUM(D15:D16)","v":0},{"$f":"IF(E15=0,\"\",E15/$D$7)","v":""},"maladie / accident / charges sociales pour les indépendants",{"$f":"IF(I15>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D15","v":0},{"$f":"SUM(I15:I16)","v":0},{"$f":"IF(J15=0,0,J15/$I$7)","v":0},"Assurances",null,null,null,null,null,null,{"$f":"ABS(F15-K15)*100","v":{"$error":"#VALUE!"}}]
[null,null,"",null,null,null,"assurance incendie, ménage et responsabilité civile",{"$f":"IF(I16>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D16","v":0}]
[null,null,"",null,null,null,null,{"$f":"IF(I17>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D17","v":0}]
[3,"Impôts","",null,{"$f":"D18","v":0},{"$f":"IF(E18=0,\"\",E18/$D$7)","v":""},"(la charge fiscale varie en fonction du canton)","",{"$f":"'Mon budget'!D18","v":0},{"$f":"I18","v":0},{"$f":"IF(J18=0,0,J18/$I$7)","v":0},"Impôts",null,null,null,null,null,null,{"$f":"ABS(F18-K18)*100","v":{"$error":"#VALUE!"}}]
[null,null,"",null,null,null,null,"",{"$f":"'Mon budget'!D19","v":0}]
[4,"Alimentation","",null,{"$f":"D20","v":0},{"$f":"IF(E20=0,\"\",E20/$D$7)","v":""},"nourriture / boissons","",{"$f":"'Mon budget'!D20","v":0},{"$f":"I20","v":0},{"$f":"IF(J20=0,0,J20/$I$7)","v":0},"Alimentation",null,null,null,null,null,null,{"$f":"ABS(F20-K20)*100","v":{"$error":"#VALUE!"}}]
[null,null,"",null,null,null,null,"",{"$f":"'Mon budget'!D21","v":0}]
[5,"Ménage","",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"IF(E22=0,\"\",E22/$D$7)","v":""},"produits de nettoyage / produits pour le corps / taxes / frais postaux","",{"$f":"'Mon budget'!D22","v":0},{"$f":"SUM(I22:I23)","v":0},{"$f":"IF(J22=0,0,J22/$I$7)","v":0},"Ménage",null,null,null,null,null,null,{"$f":"ABS(F22-K22)*100","v":{"$error":"#VALUE!"}}]
[null,null,"",null,null,null,"équipement ménager - réparations","",{"$f":"'Mon budget'!D23","v":0}]
[null,null,"",null,null,null,null,"",{"$f":"'Mon budget'!D24","v":0}]
[6,"Habillement","",null,{"$f":"D25","v":0},{"$f":"IF(E25=0,\"\",E25/$D$7)","v":""},"habillement / pressing / chaussures","",{"$f":"'Mon budget'!D25","v":0},{"$f":"I25","v":0},{"$f":"IF(J25=0,0,J25/$I$7)","v":0},"Habillement",null,null,null,null,null,null,{"$f":"ABS(F25-K25)*100","v":{"$error":"#VALUE!"}}]
[null,null,"",null,null,null,null,"",{"$f":"'Mon budget'!D26","v":0}]
[7,"Transports","",null,{"$f":"SUM(D27:D28)","v":0},{"$f":"IF(E27=0,\"\",E27/$D$7)","v":""},"transports publics","",{"$f":"'Mon budget'!D27","v":0},{"$f":"SUM(I27:I28)","v":0},{"$f":"IF(J27=0,0,J27/$I$7)","v":0},"Transports",null,null,null,null,null,null,{"$f":"ABS(F27-K27)*100","v":{"$error":"#VALUE!"}}]
[null,null,"",null,null,null,"voiture (taxes / assurances / carburant / entretien) - sans amortissement","",{"$f":"'Mon budget'!D28","v":0}]
[null,null,"",null,null,null,null,"",{"$f":"'Mon budget'!D29","v":0}]
[8,"Abonnements","",null,{"$f":"SUM(D30:D32)","v":0},{"$f":"IF(E30=0,\"\",E30/$D$7)","v":""},"presse / cotisations","",{"$f":"'Mon budget'!D30","v":0},{"$f":"SUM(I30:I32)","v":0},{"$f":"IF(J30=0,0,J30/$I$7)","v":0},"Abonnements",null,null,null,null,null,null,{"$f":"ABS(F30-K30)*100","v":{"$error":"#VALUE!"}}]
[null,null,"",null,null,null,"téléphone / radio / télévision","",{"$f":"'Mon budget'!D31","v":0}]
[null,null,"",null,null,null,"fomation / écolage / camps","",{"$f":"'Mon budget'!D32","v":0}]
[null,null,"",null,null,null,null,"",{"$f":"'Mon budget'!D33","v":0}]
[9,"Dépenses personnelles","",null,{"$f":"SUM(D34:D35)","v":0},{"$f":"IF(E34=0,\"\",E34/$D$7)","v":""},"soins corporels / coiffeur / argent de poche / cigarettes / alcool","",{"$f":"'Mon budget'!D34","v":0},{"$f":"SUM(I34:I35)","v":0},{"$f":"IF(J34=0,0,J34/$I$7)","v":0},"Dépenses personnelles",null,null,null,null,null,null,{"$f":"ABS(F34-K34)*100","v":{"$error":"#VALUE!"}}]
[null,null,"",null,null,null,"loisirs / culture / sport","",{"$f":"'Mon budget'!D35","v":0}]
[null,null,"",null,null,null,null,{"$f":"IF(I36>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D36","v":0}]
[10,"Divers","",null,{"$f":"SUM(D37:D40)","v":0},{"$f":"IF(E37=0,\"\",E37/$D$7)","v":""},"franchise / médecin / dentiste / opticien",{"$f":"IF(I37>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D37","v":0},{"$f":"SUM(I37:I40)","v":0},{"$f":"IF(J37=0,0,J37/$I$7)","v":0},"Divers",null,null,null,null,null,null,{"$f":"ABS(F37-K37)*100","v":{"$error":"#VALUE!"}}]
[null,null,"",null,null,null,"cadeaux",{"$f":"IF(I38>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D38","v":0}]
[null,null,"",null,null,null,"achats / restauration / vacances / imprévus",{"$f":"IF(I39>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D39","v":0}]
[null,null,"",null,null,null,null,{"$f":"IF(I40>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D40","v":0},null,null,null,null,null,null,null,null,null,{"$f":"ABS(F43-K43)*100","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,{"$f":"'Mon budget'!D41","v":0}]
[null,null,"",null,null,null,null,{"$f":"IF(I42>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D42","v":0}]
["Solde/Prévoyance",null,"",null,{"$f":"SUM(D43:D44)","v":0},{"$f":"IF(E43=0,\"\",E43/$D$7)","v":""},"prévoyance 3e pilier / épargne forcée",{"$f":"IF(I43>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D43","v":0},{"$f":"SUM(I43:I44)","v":0},{"$f":"IF(J43=0,0,J43/$I$7)","v":0},"Solde",null,null,null,null,null,null,{"$f":"ROUND(SUM(S12:S40),0)","v":{"$error":"#VALUE!"}},{"$f":"SUM(T12:T37)","v":0}]
[null,null,"",null,null,null,{"$f":"IF(P1=TRUE,\"reste pour l'épargne\",\"épargne\")","v":"épargne"},{"$f":"IF(I44>0,\"CHF\",\"\")","v":""},{"$f":"'Mon budget'!D44","v":0}]
[null,{"$f":"IF(R10=1,\"Choisir un budget type ici\",\"\")","v":"Choisir un budget type ici"}]

{"sheet":"Enveloppes-types","index":5,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":true,"merged":[[20,8,20,9],[16,6,16,8],[17,6,17,8],[0,1,0,9],[19,8,19,9],[18,6,18,8]]}
[null,{"$f":"'Budgets types'!B4","v":"  "}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,{"$f":"'Budgets types'!B12","v":"Logement"},null,{"$f":"'Budgets types'!B15","v":"Assurances"},null,{"$f":"'Budgets types'!B18","v":"Impôts"},null,{"$f":"'Budgets types'!B20","v":"Alimentation"},null,null,null,null,null,null,null,null,null,"Logement",{"$f":"C8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assurances",{"$f":"E8","v":0}]
[null,null,{"$f":"'Budgets types'!E12","v":0},null,{"$f":"'Budgets types'!E15","v":0},null,{"$f":"'Budgets types'!E18","v":0},null,{"$f":"'Budgets types'!E20","v":0},null,null,null,null,null,null,null,null,null,"Impôts",{"$f":"G8","v":0}]
[null,null,{"$f":"'Mes Enveloppes'!C8","v":0},null,{"$f":"'Mes Enveloppes'!E8","v":0},null,{"$f":"'Mes Enveloppes'!G8","v":0},null,{"$f":"'Mes Enveloppes'!I8","v":0},null,null,null,null,null,null,null,null,null,"Alimentation",{"$f":"I8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ménage",{"$f":"C13","v":0}]
[null,null,{"$f":"'Budgets types'!B22","v":"Ménage"},null,{"$f":"'Budgets types'!B25","v":"Habillement"},null,{"$f":"'Budgets types'!B27","v":"Transports"},null,{"$f":"'Budgets types'!B30","v":"Abonnements"},null,null,null,null,null,null,null,null,null,"Habillement",{"$f":"E13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transports",{"$f":"G13","v":0}]
[null,null,{"$f":"'Budgets types'!E22","v":0},null,{"$f":"'Budgets types'!E25","v":0},null,{"$f":"'Budgets types'!E27","v":0},null,{"$f":"'Budgets types'!E30","v":0},null,null,null,null,null,null,null,null,null,"Abonnements",{"$f":"I13","v":0}]
[null,null,{"$f":"'Mes Enveloppes'!C13","v":0},null,{"$f":"'Mes Enveloppes'!E13","v":0},null,{"$f":"'Mes Enveloppes'!G13","v":0},null,{"$f":"'Mes Enveloppes'!I13","v":0},null,null,null,null,null,null,null,null,null,"Dép. personnelles",{"$f":"C18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Divers",{"$f":"E18","v":0}]
[null,null,{"$f":"'Budgets types'!B34","v":"Dépenses personnelles"},null,{"$f":"'Budgets types'!B37","v":"Divers"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Epargne",{"$f":"G18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(T6:T16)","v":0}]
[null,null,{"$f":"'Budgets types'!E34","v":0},null,{"$f":"'Budgets types'!E37","v":0},null,{"$f":"'Budgets types'!E43","v":0}]
[null,null,{"$f":"'Mes Enveloppes'!C18","v":0},null,{"$f":"'Mes Enveloppes'!E18","v":0},null,{"$f":"'Mes Enveloppes'!G18:I18","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Budgets types'!D7","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Mes Enveloppes'!I20:J20","v":0}]
[]
[null,"En vert : ",{"$f":"'Mes Enveloppes'!B1","v":"Mon budget"}]

{"sheet":"Comparaisons","index":6,"n_rows":29,"n_cols":26,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"R1-1","v":0}]
[null,"Budget type A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"R2-1","v":0}]
[null,"Budget type B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,1)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,1)","v":{"$error":"#N/A"}},null,"Choix pourcent",1]
[null,"Revenus",null,null,"Logement",null,null,"Assurances",null,null,"Impôts",null,null,null,null,null,null,"Logement",{"$f":"HLOOKUP($S$1,Table,2)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",SUM(S6:S7))","v":""},"Logement",{"$f":"HLOOKUP($S$2,Table,2)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",SUM(V6:V7))","v":""}]
[null,{"$f":"T28","v":""},null,null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T6,T6/$B$7))","v":""},null,null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T8,T8/$B$7))","v":""},null,null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T10,T10/$B$7))","v":""},null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,3)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,3)","v":{"$error":"#N/A"}}]
[null,{"$f":"W28","v":""},null,null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W6,W6/$B$8))","v":""},null,null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W8,W8/$B$8))","v":""},null,null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W10,W10/$B$8))","v":""},null,null,null,null,null,null,"Assurances",{"$f":"HLOOKUP($S$1,Table,4)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",SUM(S8:S9))","v":""},"Assurances",{"$f":"HLOOKUP($S$2,Table,4)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",SUM(V8:V9))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,5)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,5)","v":{"$error":"#N/A"}}]
[null,"Alimentation",null,null,"Ménage",null,null,"Habillement",null,null,"Transports",null,null,null,null,null,null,"Impôts",{"$f":"HLOOKUP($S$1,Table,6)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",S10)","v":""},"Impôts",{"$f":"HLOOKUP($S$2,Table,6)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",V10)","v":""}]
[null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T11,T11/$B$7))","v":""},null,null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T12,T12/$B$7))","v":""},null,null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T14,T14/$B$7))","v":""},null,null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T15,T15/$B$7))","v":""},null,null,null,null,null,null,"Alimentation",{"$f":"HLOOKUP($S$1,Table,7)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",S11)","v":""},"Alimentation",{"$f":"HLOOKUP($S$2,Table,7)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",V11)","v":""}]
[null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W11,W11/$B$8))","v":""},null,null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W12,W12/$B$8))","v":""},null,null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W14,W14/$B$8))","v":""},null,null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W15,W15/$B$8))","v":""},null,null,null,null,null,null,"Ménage",{"$f":"HLOOKUP($S$1,Table,8)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",SUM(S12:S13))","v":""},"Ménage",{"$f":"HLOOKUP($S$2,Table,8)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",SUM(V12:V13))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,9)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,9)","v":{"$error":"#N/A"}}]
[null,"Abonnements",null,null,"Dép. personnelles",null,null,"Divers",null,null,null,null,null,null,null,null,null,"Habillement",{"$f":"HLOOKUP($S$1,Table,10)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",S14)","v":""},"Habillement",{"$f":"HLOOKUP($S$2,Table,10)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",V14)","v":""}]
[null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T17,T17/$B$7))","v":""},null,null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T20,T20/$B$7))","v":""},null,null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T22,T22/$B$7))","v":""},null,null,"Epargne",null,null,null,null,null,null,"Transports",{"$f":"HLOOKUP($S$1,Table,11)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",SUM(S15:S16))","v":""},"Transports",{"$f":"HLOOKUP($S$2,Table,11)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",SUM(V15:V16))","v":""}]
[null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W17,W17/$B$8))","v":""},null,null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W20,W20/$B$8))","v":""},null,null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W22,W22/$B$8))","v":""},null,null,{"$f":"IF($B$7=\"\",\"\",IF($Y$5=1,T26,T26/$B$7))","v":""},null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,12)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,12)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$8=\"\",\"\",IF($Y$5=1,W26,W26/$B$8))","v":""},null,null,null,null,null,null,"Abonnements",{"$f":"HLOOKUP($S$1,Table,13)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",SUM(S17:S19))","v":""},"Abonnements",{"$f":"HLOOKUP($S$2,Table,13)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",SUM(V17:V19))","v":""},"choix zone sensible","A = 1","Variable pour A18:A29"]
[{"$f":"IF($S$1=Z18,\"A\",IF($S$2=Z18,\"B\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,14)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,14)","v":{"$error":"#N/A"}},null,{"$f":"IF(A18<>\"\",Z18+1,0)","v":0},{"$f":"IF(X18=$R$1,1,0)","v":0},1]
[{"$f":"IF($S$1=Z19,\"A\",IF($S$2=Z19,\"B\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,15)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,15)","v":{"$error":"#N/A"}},null,{"$f":"IF(A19<>\"\",Z19+1,0)","v":0},{"$f":"IF(X19=$R$1,1,0)","v":0},2]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dépenses personnelles",{"$f":"HLOOKUP($S$1,Table,16)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",SUM(S20:S21))","v":""},"Dépenses personnelles",{"$f":"HLOOKUP($S$2,Table,16)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",SUM(V20:V21))","v":""},0,0,3]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,17)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,17)","v":{"$error":"#N/A"}},null,0,0,4]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Divers",{"$f":"HLOOKUP($S$1,Table,18)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",SUM(S22:S25))","v":""},"Divers",{"$f":"HLOOKUP($S$2,Table,18)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",SUM(V22:V25))","v":""},0,0,5]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,19)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,19)","v":{"$error":"#N/A"}},null,0,0,6]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,20)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,20)","v":{"$error":"#N/A"}},null,0,0,7]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,21)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,21)","v":{"$error":"#N/A"}},null,0,0,8]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,22)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",SUM(S26:S27))","v":""},null,{"$f":"HLOOKUP($S$2,Table,22)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",SUM(V26:V27))","v":""},0,0,9]
["",null,null,null,null,null,null,{"$f":"IF(COUNTIF(A18:A29,\"A\")=0,\"cliquez ci-contre !\",\"\")","v":"cliquez ci-contre !"},null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($S$1,Table,23)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($S$2,Table,23)","v":{"$error":"#N/A"}},null,0,0,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S6:S27)","v":{"$error":"#N/A"}},{"$f":"IF($S$1=0,\"\",SUM(T6:T27))","v":""},null,{"$f":"SUM(V6:V27)","v":{"$error":"#N/A"}},{"$f":"IF($S$2=0,\"\",SUM(W6:W27))","v":""},0,0,11]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,13]

{"sheet":"Budget annuel","index":7,"n_rows":81,"n_cols":64,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,8,4,15],[78,4,78,6],[49,3,49,6],[9,1,9,3],[44,1,44,8],[46,6,46,8],[33,1,34,1],[79,4,79,6],[80,4,80,6],[50,1,50,8],[51,4,51,6],[5,1,5,3],[6,1,6,3],[12,40,39,40],[12,33,39,33],[12,34,39,34],[12,35,39,35],[12,36,39,36],[12,37,39,37],[12,38,39,38],[12,39,39,39],[48,21,49,21],[42,29,48,31],[12,29,39,29],[12,30,39,30],[12,31,39,31],[12,32,39,32]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choix couleur",36,"36 =jaune, 40 = orange"]
[]
[]
[null,null,{"$f":"IF(Z10<2,\"Mon budget\",VLOOKUP(Z10,Titres,2))","v":"Mon budget"}," "]
[]
[null," Revenus nets",null,null,"annuel",null,"mensuel"]
[null,"Total-- ",null,null,{"$f":"G7*12","v":0},null,{"$f":"SUM(G12:G44)","v":0},0,"janvier","février","mars","avril","mai","juin","juillet","août","septembre","octobre","novembre","décembre",null,"Total"]
[]
[]
[null," Dépenses mensuelles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,null,null,"Cartes événements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exemple "]
[]
[null,"Logement",null,"loyer + charges (chauffage)",{"$f":"G12*12","v":0},null,{"$f":"'Mon budget'!D12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I12:T12)","v":0},null,{"$f":"E12-V12","v":0},"M",null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,null,null,null,null,null,null,null,null,null,1950,1950,1950,1950,1950,1950,1950,1950,1950,2430,1950,1950]
[null,null,null,"électricité / gaz",{"$f":"G13*12","v":0},null,{"$f":"'Mon budget'!D13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I13:T13)","v":0},null,{"$f":"E13-V13","v":0},"M",null,null,null,null,"Un traitement de dentiste est en cours. La note finale attendue pour septembre devrait s’élever à CHF 2'500.-. Le dentiste est prêt à recevoir des acomptes à ma convenance si je ne souhaite pas payer en une seule fois.","Le contrôle périodique de la voiture est prévu en mai. Le garagiste a estimé les travaux pour la mise en conformité du véhicule à  1’800.-.","En remplissant la déclaration fiscale, je constate que les acomptes que j’ai déjà payés pour les impôts cantonaux et fédéraux sont insuffisants. Un versement supplémentaire de CHF 800.- va s’imposer.","L’hiver a été particulièrement froid et les acomptes provisionnels de chauffages versés particulièrement bas. Prévoir une différence à payer fin septembre équivalant à un demi loyer.","Afin d’éviter une augmentation de prime nous n’avons pas annoncé à l’assurance un petit accrochage. Les frais de réparation au véhicule tiers s’élèvent à CHF 600.- à payer en février. Les réparations à ma voiture attendront l’été. Elles sont estimées à CHF 800.-.","L’augmentation du prix de l’électricité laisse à penser que les acomptes versés ne seront pas suffisants. Les décomptes annuels tombent au 30 juin et l’on s’attend à un complément à payer de CHF 400.-.","Notre cuisine n’est pas «agencée » et le lave-vaisselle\nnous appartient. Hors mis le fait que cet appareil d’une ancienne génération est dévoreur d’énergie, son état général calamiteux nous pousse à prévoir son remplacement dans l’année. Prévoir CHF 1'200.- à cet effet.","En montant les pneus d’hiver, le garagiste nous a montré que les indicateurs d'usure sur les pneus d’été étaient à fleur de bande de roulement. Il faudra donc changer les 4 roues au printemps. Compter CHF 520.- pour 4 pneus, montage compris.","L’année à venir sera marquée par un anniversaire important et symbolique. Pour cette occasion, le 11 novembre exactement, je projette l’achat d'un bijou valant le 20% de mon salaire mensel comme cadeau.","Dans le cadre de la formation continue interne à l’entreprise, je me suis inscrit à un cours-séminaire de 15 jours en Angleterre, du 15 au 30 juillet. Le prix est fixé à 1'400 €, voyage compris. L’entreprise participe pour 50%.","L’opération subie récemment a coûté CHF 15'000.-. Le 10% de ce montant est à ma charge et je devrais le rembourser à l’assurance avant l’été.","Notre téléviseur, après 10 ans de loyaux services donne des signes d’usure. L’image se déforme et le réparateur a déclaré le tube cathodique irréparable. Nous avons accepté son offre de remplacement valable 6 mois pour un modèle à CHF 1200.-.",null,null,null,null,null,null,null,null,null,null,null,null,280,null,280,null,280,null,540,null,280,null,280]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Assurances",null,"maladie / accident / (+ ch. soc. indépendants)",0,null,{"$f":"'Mon budget'!D15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,850,850,850,850,850,850,850,850,850,850,850,850]
[null,null,null,"assurance incendie, ménage et responsabilité civile",0,null,{"$f":"'Mon budget'!D16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,670,null,null,null,null,null,670,null,340]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Impôts",null,"(la charge fiscale varie en fonction du canton)",0,null,{"$f":"'Mon budget'!D18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1400,1400,1400,1400,1400,1400,1400,1400,2600,1400,1400,1400]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Alimentation",null,"nourriture / boissons",0,null,{"$f":"'Mon budget'!D20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1100,1100,1500,1100,1100,1100,1100,1100,1100,1100,1200,1800]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Ménage",null,"produits de lavage et de nettoyage / prod. corps / taxes",0,null,{"$f":"'Mon budget'!D22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,400,400,400,400,400,400,400,400,400,400,400]
[null,null,null,"équipement ménager - réparations",0,null,{"$f":"'Mon budget'!D23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,null,null,300,null,null,1000,null,300]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Habillement",null,"habillement / pressing / chaussures",0,null,{"$f":"'Mon budget'!D25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,null,null,400,null,null,400,null,800,200]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Transports",null,"transports publics",0,null,{"$f":"'Mon budget'!D27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20,20,20,20,20,20,20,20,20,20,20]
[null,null,null,"voiture (taxes / assurances / carburant / entretien) ",0,null,{"$f":"'Mon budget'!D28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1140,250,250,250,1200,250,300,300,250,800,250,1000]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Abonnements",null,"presse / cotisations",0,null,{"$f":"'Mon budget'!D30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,420]
[null,null,null,"téléphone / radio / télévision",0,null,{"$f":"'Mon budget'!D31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,180,180,180,180,180,180,180,180,180,180,180]
[null,null,null,"fomation / écolage / camps",0,null,{"$f":"'Mon budget'!D32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,null,400,null,null,null,null,400]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Dépenses personnelles",null,"soins corporels / coiffeur / argent de poche / cigarettes",0,null,{"$f":"'Mon budget'!D34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,200,200,200,200,200,200,200,200,200,200,200]
[null,null,null,"loisirs / culture / sport",0,null,{"$f":"'Mon budget'!D35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,600,200,200,800,200,200,200,200,200,200,300]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Divers",null,"franchise / médecin / dentiste / opticien",0,null,{"$f":"'Mon budget'!D37","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,null,null,1000]
[null,null,null,"cadeaux",0,null,{"$f":"'Mon budget'!D38","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,null,null,null,150,50,null,null,null,null,200]
[null,null,null,"achats / restauration / vacances / imprévus",0,null,{"$f":"'Mon budget'!D39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,50,50,300,50,50,800,800,50,50,100,50]
[null,null,null,"autres",0,null,{"$f":"'Mon budget'!D40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,100,100,100,100,100,100,100,100,100,100,100]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,{"$f":"'Mon budget'!D42","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,3]
[null,"Prévoyance",null,"prévoyance 3e pilier / épargne forcée",0,null,{"$f":"'Mon budget'!D43","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,{"$f":"HLOOKUP(AD42,AD12:AO40,2)","v":"En remplissant la déclaration fiscale, je constate que les acomptes que j’ai déjà payés pour les impôts cantonaux et fédéraux sont insuffisants. Un versement supplémentaire de CHF 800.- va s’imposer."}]
[null,{"$f":"IF(G44<0,\"Pas possible !\",\"\")","v":""},null,{"$f":"IF(S1=TRUE,\"reste pour l'épargne\",\"épargne\")","v":"épargne"},0,null,{"$f":"'Mon budget'!D44","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,120,120,120,120,120,120,120,120,120,120,120]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I12:I44)","v":0},{"$f":"SUM(J12:J44)","v":0},0,0,{"$f":"SUM(M12:M44)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(V12:V44)","v":0}]
[null,null,null,null,null,null,{"$f":"B49","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Imprimer cette feuille"]
[null,null,null,"Réserve en début d'année :",null,null,null,null,1]
[]
[null,null,null,"Copier une autre donnée :","Trésorerie ->",null,null,null,{"$f":"$G$7-I46+I50","v":1},{"$f":"I52+$G$7-J46","v":1},1,1,1,1,1,1,1,1,1,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Tableau résumé",null,null,null,null,{"$f":"LEFT(I7,4)","v":"janv"},{"$f":"LEFT(J7,3)","v":"fév"},{"$f":"LEFT(K7,4)","v":"mars"},{"$f":"LEFT(L7,3)","v":"avr"},"mai","juin","juil","août","sept",{"$f":"LEFT(R7,3)","v":"oct"},{"$f":"LEFT(S7,3)","v":"nov"},{"$f":"LEFT(T7,3)","v":"déc"}]
[null,null,null,null,"Revenus",null,null,null,{"$f":"$E$7/12","v":0},{"$f":"$E$7/12","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dépenses",null,null,null,{"$f":"I46","v":0},{"$f":"J46","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Annuel à imprimer","index":8,"n_rows":47,"n_cols":22,"rows_kept":47,"cut":false,"hidden":true,"merged":[[9,1,9,3],[45,1,45,8],[5,1,5,3]]}
[]
[]
[]
[]
[]
[null,"Revenus nets",null,null,"annuel",null,"mensuel"]
[null,"Total",null,{"$f":"'Budget annuel'!E7","v":0},{"$f":"G7*12","v":0},null,null,null,"janvier","février","mars","avril","mai","juin","juillet","août","septembre","octobre","novembre","décembre",null,"Total"]
[]
[]
[null,"Dépenses mensuelles"]
[]
[null,"Logement",null,"loyer + charges (chauffage)",{"$f":"G12*12","v":0},null,null,null,{"$f":"'Budget annuel'!I12","v":0},{"$f":"'Budget annuel'!J12","v":0},{"$f":"'Budget annuel'!K12","v":0},{"$f":"'Budget annuel'!L12","v":0},{"$f":"'Budget annuel'!M12","v":0},{"$f":"'Budget annuel'!N12","v":0},{"$f":"'Budget annuel'!O12","v":0},{"$f":"'Budget annuel'!P12","v":0},{"$f":"'Budget annuel'!Q12","v":0},{"$f":"'Budget annuel'!R12","v":0},{"$f":"'Budget annuel'!S12","v":0},{"$f":"'Budget annuel'!T12","v":0},null,{"$f":"SUM(I12:T12)","v":0}]
[null,null,null,"électricité / gaz",{"$f":"G13*12","v":0},null,null,null,{"$f":"'Budget annuel'!I13","v":0},{"$f":"'Budget annuel'!J13","v":0},{"$f":"'Budget annuel'!K13","v":0},{"$f":"'Budget annuel'!L13","v":0},{"$f":"'Budget annuel'!M13","v":0},{"$f":"'Budget annuel'!N13","v":0},{"$f":"'Budget annuel'!O13","v":0},{"$f":"'Budget annuel'!P13","v":0},{"$f":"'Budget annuel'!Q13","v":0},{"$f":"'Budget annuel'!R13","v":0},{"$f":"'Budget annuel'!S13","v":0},{"$f":"'Budget annuel'!T13","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Assurances",null,"maladie / accident ",{"$f":"G15*12","v":0},null,null,null,{"$f":"'Budget annuel'!I15","v":0},{"$f":"'Budget annuel'!J15","v":0},{"$f":"'Budget annuel'!K15","v":0},{"$f":"'Budget annuel'!L15","v":0},{"$f":"'Budget annuel'!M15","v":0},{"$f":"'Budget annuel'!N15","v":0},{"$f":"'Budget annuel'!O15","v":0},{"$f":"'Budget annuel'!P15","v":0},{"$f":"'Budget annuel'!Q15","v":0},{"$f":"'Budget annuel'!R15","v":0},{"$f":"'Budget annuel'!S15","v":0},{"$f":"'Budget annuel'!T15","v":0},null,0]
[null,null,null,"assurance incendie, ménage et RC",{"$f":"G16*12","v":0},null,null,null,{"$f":"'Budget annuel'!I16","v":0},{"$f":"'Budget annuel'!J16","v":0},{"$f":"'Budget annuel'!K16","v":0},{"$f":"'Budget annuel'!L16","v":0},{"$f":"'Budget annuel'!M16","v":0},{"$f":"'Budget annuel'!N16","v":0},{"$f":"'Budget annuel'!O16","v":0},{"$f":"'Budget annuel'!P16","v":0},{"$f":"'Budget annuel'!Q16","v":0},{"$f":"'Budget annuel'!R16","v":0},{"$f":"'Budget annuel'!S16","v":0},{"$f":"'Budget annuel'!T16","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Impôts",null,"(la charge fiscale varie en fonction du canton)",{"$f":"G18*12","v":0},null,null,null,{"$f":"'Budget annuel'!I18","v":0},{"$f":"'Budget annuel'!J18","v":0},{"$f":"'Budget annuel'!K18","v":0},{"$f":"'Budget annuel'!L18","v":0},{"$f":"'Budget annuel'!M18","v":0},{"$f":"'Budget annuel'!N18","v":0},{"$f":"'Budget annuel'!O18","v":0},{"$f":"'Budget annuel'!P18","v":0},{"$f":"'Budget annuel'!Q18","v":0},{"$f":"'Budget annuel'!R18","v":0},{"$f":"'Budget annuel'!S18","v":0},{"$f":"'Budget annuel'!T18","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Alimentation",null,"nourriture / boissons",{"$f":"G20*12","v":0},null,null,null,{"$f":"'Budget annuel'!I20","v":0},{"$f":"'Budget annuel'!J20","v":0},{"$f":"'Budget annuel'!K20","v":0},{"$f":"'Budget annuel'!L20","v":0},{"$f":"'Budget annuel'!M20","v":0},{"$f":"'Budget annuel'!N20","v":0},{"$f":"'Budget annuel'!O20","v":0},{"$f":"'Budget annuel'!P20","v":0},{"$f":"'Budget annuel'!Q20","v":0},{"$f":"'Budget annuel'!R20","v":0},{"$f":"'Budget annuel'!S20","v":0},{"$f":"'Budget annuel'!T20","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Ménage",null,"prod. lavage et nettoyage / prod. corps / taxes",{"$f":"G22*12","v":0},null,null,null,{"$f":"'Budget annuel'!I22","v":0},{"$f":"'Budget annuel'!J22","v":0},{"$f":"'Budget annuel'!K22","v":0},{"$f":"'Budget annuel'!L22","v":0},{"$f":"'Budget annuel'!M22","v":0},{"$f":"'Budget annuel'!N22","v":0},{"$f":"'Budget annuel'!O22","v":0},{"$f":"'Budget annuel'!P22","v":0},{"$f":"'Budget annuel'!Q22","v":0},{"$f":"'Budget annuel'!R22","v":0},{"$f":"'Budget annuel'!S22","v":0},{"$f":"'Budget annuel'!T22","v":0},null,0]
[null,null,null,"équipement ménager - réparations",{"$f":"G23*12","v":0},null,null,null,{"$f":"'Budget annuel'!I23","v":0},{"$f":"'Budget annuel'!J23","v":0},{"$f":"'Budget annuel'!K23","v":0},{"$f":"'Budget annuel'!L23","v":0},{"$f":"'Budget annuel'!M23","v":0},{"$f":"'Budget annuel'!N23","v":0},{"$f":"'Budget annuel'!O23","v":0},{"$f":"'Budget annuel'!P23","v":0},{"$f":"'Budget annuel'!Q23","v":0},{"$f":"'Budget annuel'!R23","v":0},{"$f":"'Budget annuel'!S23","v":0},{"$f":"'Budget annuel'!T23","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Habillement",null,"habillement / pressing / chaussures",{"$f":"G25*12","v":0},null,null,null,{"$f":"'Budget annuel'!I25","v":0},{"$f":"'Budget annuel'!J25","v":0},{"$f":"'Budget annuel'!K25","v":0},{"$f":"'Budget annuel'!L25","v":0},{"$f":"'Budget annuel'!M25","v":0},{"$f":"'Budget annuel'!N25","v":0},{"$f":"'Budget annuel'!O25","v":0},{"$f":"'Budget annuel'!P25","v":0},{"$f":"'Budget annuel'!Q25","v":0},{"$f":"'Budget annuel'!R25","v":0},{"$f":"'Budget annuel'!S25","v":0},{"$f":"'Budget annuel'!T25","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Transports",null,"transports publics",{"$f":"G27*12","v":0},null,null,null,{"$f":"'Budget annuel'!I27","v":0},{"$f":"'Budget annuel'!J27","v":0},{"$f":"'Budget annuel'!K27","v":0},{"$f":"'Budget annuel'!L27","v":0},{"$f":"'Budget annuel'!M27","v":0},{"$f":"'Budget annuel'!N27","v":0},{"$f":"'Budget annuel'!O27","v":0},{"$f":"'Budget annuel'!P27","v":0},{"$f":"'Budget annuel'!Q27","v":0},{"$f":"'Budget annuel'!R27","v":0},{"$f":"'Budget annuel'!S27","v":0},{"$f":"'Budget annuel'!T27","v":0},null,0]
[null,null,null,"voiture (taxes / assurances / carburant / frais) ",{"$f":"G28*12","v":0},null,null,null,{"$f":"'Budget annuel'!I28","v":0},{"$f":"'Budget annuel'!J28","v":0},{"$f":"'Budget annuel'!K28","v":0},{"$f":"'Budget annuel'!L28","v":0},{"$f":"'Budget annuel'!M28","v":0},{"$f":"'Budget annuel'!N28","v":0},{"$f":"'Budget annuel'!O28","v":0},{"$f":"'Budget annuel'!P28","v":0},{"$f":"'Budget annuel'!Q28","v":0},{"$f":"'Budget annuel'!R28","v":0},{"$f":"'Budget annuel'!S28","v":0},{"$f":"'Budget annuel'!T28","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Abonnements",null,"presse / cotisations",{"$f":"G30*12","v":0},null,null,null,{"$f":"'Budget annuel'!I30","v":0},{"$f":"'Budget annuel'!J30","v":0},{"$f":"'Budget annuel'!K30","v":0},{"$f":"'Budget annuel'!L30","v":0},{"$f":"'Budget annuel'!M30","v":0},{"$f":"'Budget annuel'!N30","v":0},{"$f":"'Budget annuel'!O30","v":0},{"$f":"'Budget annuel'!P30","v":0},{"$f":"'Budget annuel'!Q30","v":0},{"$f":"'Budget annuel'!R30","v":0},{"$f":"'Budget annuel'!S30","v":0},{"$f":"'Budget annuel'!T30","v":0},null,0]
[null,null,null,"téléphone / radio / télévision",{"$f":"G31*12","v":0},null,null,null,{"$f":"'Budget annuel'!I31","v":0},{"$f":"'Budget annuel'!J31","v":0},{"$f":"'Budget annuel'!K31","v":0},{"$f":"'Budget annuel'!L31","v":0},{"$f":"'Budget annuel'!M31","v":0},{"$f":"'Budget annuel'!N31","v":0},{"$f":"'Budget annuel'!O31","v":0},{"$f":"'Budget annuel'!P31","v":0},{"$f":"'Budget annuel'!Q31","v":0},{"$f":"'Budget annuel'!R31","v":0},{"$f":"'Budget annuel'!S31","v":0},{"$f":"'Budget annuel'!T31","v":0},null,0]
[null,null,null,"fomation / écolage / camps",{"$f":"G32*12","v":0},null,null,null,{"$f":"'Budget annuel'!I32","v":0},{"$f":"'Budget annuel'!J32","v":0},{"$f":"'Budget annuel'!K32","v":0},{"$f":"'Budget annuel'!L32","v":0},{"$f":"'Budget annuel'!M32","v":0},{"$f":"'Budget annuel'!N32","v":0},{"$f":"'Budget annuel'!O32","v":0},{"$f":"'Budget annuel'!P32","v":0},{"$f":"'Budget annuel'!Q32","v":0},{"$f":"'Budget annuel'!R32","v":0},{"$f":"'Budget annuel'!S32","v":0},{"$f":"'Budget annuel'!T32","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Dép. personnelles",null,"soins corporels / coiffeur / argent de poche",{"$f":"G34*12","v":0},null,null,null,{"$f":"'Budget annuel'!I34","v":0},{"$f":"'Budget annuel'!J34","v":0},{"$f":"'Budget annuel'!K34","v":0},{"$f":"'Budget annuel'!L34","v":0},{"$f":"'Budget annuel'!M34","v":0},{"$f":"'Budget annuel'!N34","v":0},{"$f":"'Budget annuel'!O34","v":0},{"$f":"'Budget annuel'!P34","v":0},{"$f":"'Budget annuel'!Q34","v":0},{"$f":"'Budget annuel'!R34","v":0},{"$f":"'Budget annuel'!S34","v":0},{"$f":"'Budget annuel'!T34","v":0},null,0]
[null,null,null,"loisirs / culture / sport",{"$f":"G35*12","v":0},null,null,null,{"$f":"'Budget annuel'!I35","v":0},{"$f":"'Budget annuel'!J35","v":0},{"$f":"'Budget annuel'!K35","v":0},{"$f":"'Budget annuel'!L35","v":0},{"$f":"'Budget annuel'!M35","v":0},{"$f":"'Budget annuel'!N35","v":0},{"$f":"'Budget annuel'!O35","v":0},{"$f":"'Budget annuel'!P35","v":0},{"$f":"'Budget annuel'!Q35","v":0},{"$f":"'Budget annuel'!R35","v":0},{"$f":"'Budget annuel'!S35","v":0},{"$f":"'Budget annuel'!T35","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Divers",null,"franchise / médecin / dentiste / opticien",{"$f":"G37*12","v":0},null,null,null,{"$f":"'Budget annuel'!I37","v":0},{"$f":"'Budget annuel'!J37","v":0},{"$f":"'Budget annuel'!K37","v":0},{"$f":"'Budget annuel'!L37","v":0},{"$f":"'Budget annuel'!M37","v":0},{"$f":"'Budget annuel'!N37","v":0},{"$f":"'Budget annuel'!O37","v":0},{"$f":"'Budget annuel'!P37","v":0},{"$f":"'Budget annuel'!Q37","v":0},{"$f":"'Budget annuel'!R37","v":0},{"$f":"'Budget annuel'!S37","v":0},{"$f":"'Budget annuel'!T37","v":0},null,0]
[null,null,null,"cadeaux",{"$f":"G38*12","v":0},null,null,null,{"$f":"'Budget annuel'!I38","v":0},{"$f":"'Budget annuel'!J38","v":0},{"$f":"'Budget annuel'!K38","v":0},{"$f":"'Budget annuel'!L38","v":0},{"$f":"'Budget annuel'!M38","v":0},{"$f":"'Budget annuel'!N38","v":0},{"$f":"'Budget annuel'!O38","v":0},{"$f":"'Budget annuel'!P38","v":0},{"$f":"'Budget annuel'!Q38","v":0},{"$f":"'Budget annuel'!R38","v":0},{"$f":"'Budget annuel'!S38","v":0},{"$f":"'Budget annuel'!T38","v":0},null,0]
[null,null,null,"achats / restauration / vacances / imprévus",{"$f":"G39*12","v":0},null,null,null,{"$f":"'Budget annuel'!I39","v":0},{"$f":"'Budget annuel'!J39","v":0},{"$f":"'Budget annuel'!K39","v":0},{"$f":"'Budget annuel'!L39","v":0},{"$f":"'Budget annuel'!M39","v":0},{"$f":"'Budget annuel'!N39","v":0},{"$f":"'Budget annuel'!O39","v":0},{"$f":"'Budget annuel'!P39","v":0},{"$f":"'Budget annuel'!Q39","v":0},{"$f":"'Budget annuel'!R39","v":0},{"$f":"'Budget annuel'!S39","v":0},{"$f":"'Budget annuel'!T39","v":0},null,0]
[null,null,null,"autres",{"$f":"G40*12","v":0},null,null,null,{"$f":"'Budget annuel'!I40","v":0},{"$f":"'Budget annuel'!J40","v":0},{"$f":"'Budget annuel'!K40","v":0},{"$f":"'Budget annuel'!L40","v":0},{"$f":"'Budget annuel'!M40","v":0},{"$f":"'Budget annuel'!N40","v":0},{"$f":"'Budget annuel'!O40","v":0},{"$f":"'Budget annuel'!P40","v":0},{"$f":"'Budget annuel'!Q40","v":0},{"$f":"'Budget annuel'!R40","v":0},{"$f":"'Budget annuel'!S40","v":0},{"$f":"'Budget annuel'!T40","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Prévoyance",null,"prévoyance 3e pilier / épargne forcée",{"$f":"G43*12","v":0},null,null,null,{"$f":"'Budget annuel'!I43","v":0},{"$f":"'Budget annuel'!J43","v":0},{"$f":"'Budget annuel'!K43","v":0},{"$f":"'Budget annuel'!L43","v":0},{"$f":"'Budget annuel'!M43","v":0},{"$f":"'Budget annuel'!N43","v":0},{"$f":"'Budget annuel'!O43","v":0},{"$f":"'Budget annuel'!P43","v":0},{"$f":"'Budget annuel'!Q43","v":0},{"$f":"'Budget annuel'!R43","v":0},{"$f":"'Budget annuel'!S43","v":0},{"$f":"'Budget annuel'!T43","v":0},null,0]
[null,{"$f":"IF(G44<0,\"Pas possible !\",\"\")","v":""},null,{"$f":"IF(S1=TRUE,\"reste pour l'épargne\",\"épargne\")","v":"épargne"},{"$f":"G44*12","v":0},null,null,null,{"$f":"'Budget annuel'!I44","v":0},{"$f":"'Budget annuel'!J44","v":0},{"$f":"'Budget annuel'!K44","v":0},{"$f":"'Budget annuel'!L44","v":0},{"$f":"'Budget annuel'!M44","v":0},{"$f":"'Budget annuel'!N44","v":0},{"$f":"'Budget annuel'!O44","v":0},{"$f":"'Budget annuel'!P44","v":0},{"$f":"'Budget annuel'!Q44","v":0},{"$f":"'Budget annuel'!R44","v":0},{"$f":"'Budget annuel'!S44","v":0},{"$f":"'Budget annuel'!T44","v":0},null,0]
[]
[]
[null,null,null,"Total",null,null,null,null,{"$f":"SUM(I12:I44)","v":0},{"$f":"SUM(J12:J44)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(I47:T47)","v":0}]

{"sheet":"Feuille à imprimer","index":9,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[4,1,4,5],[9,1,9,2],[51,1,51,5],[48,1,48,6],[49,1,49,6],[0,3,1,5],[44,1,44,5],[46,3,46,5],[50,1,50,5],[43,1,43,2],[2,1,2,6],[3,1,3,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[]
[null,"Revenus nets"]
[null,"Total",{"$f":"IF(D7>0,\"CHF\",\"\")","v":""},null,null,{"$f":"IF(P1=FALSE,\"\",IF(D7=0,\"                                          Entrez le montant des recettes mensuelles !\",\"\"))","v":""},null,{"$f":"SUM(H11:H43)","v":0},{"$f":"SUM(I11:I43)","v":0}]
[]
[null,null,{"$f":"IF(D9>0,\"CHF\",\"\")","v":""}]
[null,"Dépenses mensuelles"]
[null,null,{"$f":"IF(D11>0,\"CHF\",\"\")","v":""}]
[1,"Logement",{"$f":"IF(D12>0,\"CHF\",\"\")","v":""},null,null,"loyer + charges (chauffage)",null,null,{"$f":"IF(H12=0,0,H12/$H$7)","v":0}]
[null,null,{"$f":"IF(D13>0,\"CHF\",\"\")","v":""},null,null,"électricité / gaz",null,null,{"$f":"IF(H13=0,0,H13/$H$7)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H14=0,0,H14/$H$7)","v":0}]
[2,"Assurances",{"$f":"IF(D15>0,\"CHF\",\"\")","v":""},null,null,"maladie / accident (couverture de base) / charges sociales pour les indépendants",null,null,{"$f":"IF(H15=0,0,H15/$H$7)","v":0}]
[null,null,null,null,null,"assurance incendie, ménage et responsabilité civile"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H17=0,0,H17/$H$7)","v":0}]
[3,"Impôts",{"$f":"IF(D18>0,\"CHF\",\"\")","v":""},null,null,"(la charge fiscale varie en fonction du canton)",null,null,0]
[null,null,null,null,null,null,null,null,0]
[4,"Alimentation",{"$f":"IF(D20>0,\"CHF\",\"\")","v":""},null,null,"nourriture / boissons",null,null,0]
[null,null,null,null,null,null,null,null,0]
[5,"Ménage",{"$f":"IF(D22>0,\"CHF\",\"\")","v":""},null,null,"produits de lavage et de nettoyage / produits pour le corps / taxes / frais postaux",null,null,0]
[null,null,{"$f":"IF(D23>0,\"CHF\",\"\")","v":""},null,null,"équipement ménager - réparations",null,null,0]
[null,null,null,null,null,null,null,null,0]
[6,"Habillement",{"$f":"IF(D25>0,\"CHF\",\"\")","v":""},null,null,"habillement / pressing / chaussures",null,null,0]
[null,null,null,null,null,null,null,null,0]
[7,"Transports",{"$f":"IF(D27>0,\"CHF\",\"\")","v":""},null,null,"transports publics",null,null,0]
[null,null,{"$f":"IF(D28>0,\"CHF\",\"\")","v":""},null,null,"voiture (taxes / assurances / carburant / entretien) - sans amortissement",null,null,0]
[null,null,null,null,null,null,null,null,0]
[8,"Abonnements",{"$f":"IF(D30>0,\"CHF\",\"\")","v":""},null,null,"presse / cotisations",null,null,0]
[null,null,{"$f":"IF(D31>0,\"CHF\",\"\")","v":""},null,null,"téléphone / radio / télévision",null,null,0]
[null,null,{"$f":"IF(D32>0,\"CHF\",\"\")","v":""},null,null,"fomation / écolage / camps",null,null,0]
[null,null,null,null,null,null,null,null,0]
[9,"Dép. personnelles",{"$f":"IF(D34>0,\"CHF\",\"\")","v":""},null,null,"soins corporels / coiffeur / argent de poche / cigarettes / alcool",null,null,0]
[null,null,null,null,null,"loisirs / culture / sport"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H36=0,0,H36/$H$7)","v":0}]
[10,"Divers",{"$f":"IF(D37>0,\"CHF\",\"\")","v":""},null,null,"franchise / médecin / dentiste / opticien",null,null,0]
[null,null,{"$f":"IF(D38>0,\"CHF\",\"\")","v":""},null,null,"cadeaux",null,null,0]
[null,null,{"$f":"IF(D39>0,\"CHF\",\"\")","v":""},null,null,"achats / restauration / vacances / imprévus",null,null,0]
[null,null,{"$f":"IF(D40>0,\"CHF\",\"\")","v":""},null,null,"autres",null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
["Solde","Prévoyance",{"$f":"IF(D43>0,\"CHF\",\"\")","v":""},null,null,"prévoyance 3e pilier / épargne forcée",null,null,0]
[null,{"$f":"IF(D44<0,\"Pas possible !\",\"\")","v":""},null,null,null,{"$f":"IF(P1=TRUE,\"reste pour l'épargne\",\"épargne\")","v":"épargne"}]
[]
[]
[null,null,null,{"$f":"B49","v":0}]
[]
[]
[]
[]
[]
["© Yvan Péguiron - HEP Lausanne - janvier 2009"]

{"sheet":"Données","index":10,"n_rows":47,"n_cols":17,"rows_kept":47,"cut":false,"hidden":true,"merged":[[29,0,29,4]]}
[null,null,"menu",1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[{"$f":"COUNT(E4:M4)","v":9},null,null,null,"single","mono","seniors","couple","famille","famille +","classe moy.","villa","non marié","Raiffeisen","Indépend.","Libre","moyenne CH"]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[1,null,"loyer + charges ",null,1100,1230,1400,1440,1700,1900,2300,2600,1800,1200,1380,null,1300]
[2,null,"électricité / gaz",null,50,60,80,80,100,110,150,300,100,40,75,null,82]
[3,null,"maladie / accident ",null,360,470,700,700,950,950,1000,1100,850,350,850,null,625]
[4,null,"ass. incendie / RC",null,40,50,100,80,90,100,150,200,90,30,550,null,187]
[5,null,"charge fiscale ",null,800,500,850,540,750,1100,1700,1800,1250,850,1076,null,1000]
[6,null,"nourriture / boissons",null,450,800,820,1050,1200,1400,1600,1700,1000,550,934,null,730]
[7,null,"produits de lavage ",null,100,150,150,200,180,190,200,250,200,100,175,null,163]
[8,null,"équipement ménager ",null,50,80,50,50,100,120,150,300,100,50,120,null,169]
[9,null," habillement",null,180,190,180,320,280,350,400,400,260,150,260,null,225]
[10,null,"(transports publics)",null,80,100,250,120,40,60,null,40,null,null,20,null,70]
[11,null," voiture (taxes / assurances)",null,null,null,null,null,350,470,650,800,600,500,605,null,651]
[12,null,"presse / cotisations",null,40,50,80,50,60,80,90,100,50,30,35,null,50]
[13,null,"téléphone / radio / télévision",null,120,150,130,150,150,170,180,180,120,188,180,null,176]
[14,null,"fomation / écolage / camps",null,50,100,null,80,100,200,300,320,80,null,55,null,79]
[15,null,"soins /coiffeur / poche",null,100,100,250,150,180,200,300,300,180,350,525,null,286]
[16,null,"loisirs / culture / sport",null,270,180,200,200,220,300,400,400,200,220,480,null,429]
[17,null,"franchise / médecin / dentiste",null,50,120,250,120,120,150,200,200,150,50,260,null,200]
[18,null,"cadeaux",null,60,80,200,50,80,100,150,150,80,30,55,null,50]
[19,null,"imprévus / vacances / achats",null,510,270,250,200,250,300,400,500,150,350,215,null,541]
[20,null,"autres",null,null,130,200,null,150,200,200,290,50,50,240,null,83]
[21,null,"prévoyance 3e pilier",null,120,140,null,50,null,80,100,100,null,null,1130,null,106]
[22,null,"épargne",null,200,100,250,200,170,210,400,100,100,112,250,null,452]
[23]
[24,null,"Texte divers",null,null,"frais enfants",null,null,"frais enfants","frais enfants","frais enfants","jardin"]
[]
[null,null,null,null,{"$f":"SUM(E4:E25)","v":4730},5050,6390,5830,7220,8740,11020,12130,7410,5200,{"$f":"SUM(O4:O25)","v":9470},null,{"$f":"SUM(Q4:Q25)","v":7654}]
["Titres",null,null,null,null,"Logement","Voiture","Enfants","Revenu net","Revenu brut",null,null,null,"sans 13e","LPP yc",null,"salaire net"]
[null,1,"  ",null,null,null,null,null,null,null,null,null,null,"sans 13e","OFS T12B",null," + 838 Ch. soc."]
[1,2,"  Jeune célibataire",null,null,"2 pièces","non","non",{"$f":"E29","v":4730},5400,null,null,null,null,null,null," + 838 Ch. soc."]
[2,3,"  Famille monoparentale",null,null,"2 pièces","non","12 ans",{"$f":"F29","v":5050},5600]
[3,4,"  Couple de seniors",null,null,"3 pièces","non","non",{"$f":"G29","v":6390},6390]
[4,5,"  Couple modeste",null,null,"2 1/2 pièces","non","non",{"$f":"H29","v":5830},6700]
[5,6,"  Famille avec 2 petits enfants",null,null,"4 pièces","1 petite","4 et 8 ans",{"$f":"I29","v":7220},7900]
[6,7,"  Famille avec 2 grands enfants",null,null,"4 1/2 pièces","1 moyenne","14 et 17 ans",{"$f":"J29","v":8740},9500]
[7,8,"  Famille classe moyenne sup.",null,null,"5 pièces","1 grande","10 et 15 ans",{"$f":"K29","v":11020},12000]
[8,9,"  Famille avec Villa",null,null,"villa 6 pièces","2 voitures","8, 13, 16 ans",{"$f":"L29","v":12130},13000]
[9,10,"  Jeune couple non marié, 1 enfant",null,null,"3 1/2 pièces","1 voit, 1 moto","1 an",{"$f":"4390+3020","v":7410},8200]
[10,11,"  Célibataire - exemple Raiffeisen",null,null,"2 pièces","1 moyenne","non",{"$f":"N29","v":5200},5960]
[11,12,"  Couple d'indépendants - 1 enfant",null,null,"3 1/2 pièces","1 moyenne","6 ans",{"$f":"O29","v":9470},10525]
[12,13,"   ",null,null,null,null,null,{"$f":"IF(P29=0,\"\",P29)","v":""},{"$f":"IF(P29=0,\"\",P29/84.49*100)","v":""}]
[13,14,"  Moyenne suisse* (ménage  2,23 pers.)",null,null,"3 pièces","1 moyenne","1,23 enf.",{"$f":"Q29","v":7654},{"$f":"Q29+838","v":8492}]
[]
[]
["*selon T20.02.01.06 / bfs.admin.ch (Enquête sur le budget des ménages) - OFS 2007"]