{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["budget mensuel moyen (1)"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"budget mensuel moyen (1)","index":0,"n_rows":74,"n_cols":10,"rows_kept":74,"merged":[[0,0,0,9]]}
["BUDGET MENSUEL MOYEN EFFECTIF (1)"]
["Personne(s) : ",{"$nulls":4},"Période:"]
[]
[]
[]
["REVENUS",{"$nulls":3},"Mensuel","Trimestriel","Semestriel","Annuel","Mensuel moyen aujourd'hui","Mensuel moyen à la retraite"]
["Revenu Monsieur",{"$nulls":7},{"$f":"E7+F7/3+G7/6+H7/12","v":{"v":0,"d":"0.00"}}]
["Revenu Madame",{"$nulls":7},{"$f":"E8+F8/3+G8/6+H8/12","v":{"v":0,"d":"0.00"}}]
["Autres (Indemnités journalières, etc.)",{"$nulls":7},{"$f":"E9+F9/3+G9/6+H9/12","v":{"v":0,"d":"0.00"}}]
["Revenus accessoires/autres gains",{"$nulls":7},{"$f":"E10+F10/3+G10/6+H10/12","v":{"v":0,"d":"0.00"}}]
["Total des revenus :",{"$nulls":3},{"$f":"SUM(E7:E10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F7:F10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G7:G10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H10)","v":{"v":0,"d":"0.00"}},{"$f":"E11+F11/3+G11/6+H11/12","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J7:J10)","v":{"v":0,"d":"0.00"}}]
[]
["DEPENSES",{"$nulls":3},"Dépenses  ou factures mensuelles","Dépenses ou factures trimestrielles","Dépenses ou factures semestrielles","** Dépenses ou facture annuelles","Mensuel moyen aujourd'hui","Mensuel moyen à la retraite"]
["LOGEMENT"]
["Loyer ",{"$nulls":7},{"$f":"E15+F15/3+G15/6+H15/12","v":{"v":0,"d":"0.00"}}]
["Hypothèque 1 (rang) ",{"$nulls":7},{"$f":"E16+F16/3+G16/6+H16/12","v":{"v":0,"d":"0.00"}}]
["Hypothèque 2 (intérêts)",{"$nulls":7},{"$f":"E17+F17/3+G17/6+H17/12","v":{"v":0,"d":"0.00"}}]
["Alarme Protectas",{"$nulls":7},{"$f":"E18+F18/3+G18/6+H18/12","v":{"v":0,"d":"0.00"}}]
["Entretien canalisations",{"$nulls":7},{"$f":"E19+F19/3+G19/6+H19/12","v":{"v":0,"d":"0.00"}}]
["Entretien chaudière",{"$nulls":7},{"$f":"E20+F20/3+G20/6+H20/12","v":{"v":0,"d":"0.00"}}]
["Divers",{"$nulls":7},{"$f":"E21+F21/3+G21/6+H21/12","v":{"v":0,"d":"0.00"}}]
["MENAGE"]
["Nourriture, ménage (lessive, …)",{"$nulls":7},{"$f":"E23+F23/3+G23/6+H23/12","v":{"v":0,"d":"0.00"}}]
["Soins corporels, …",{"$nulls":7},{"$f":"E24+F24/3+G24/6+H24/12","v":{"v":0,"d":"0.00"}}]
["Habits",{"$nulls":7},{"$f":"E25+F25/3+G25/6+H25/12","v":{"v":0,"d":"0.00"}}]
["Coiffeur",{"$nulls":7},{"$f":"E26+F26/3+G26/6+H26/12","v":{"v":0,"d":"0.00"}}]
["Electricité / gaz / eau SIG",{"$nulls":7},{"$f":"E27+F27/3+G27/6+H27/12","v":{"v":0,"d":"0.00"}}]
["Téléphones (fixe et natel)",{"$nulls":7},{"$f":"E28+F28/3+G28/6+H28/12","v":{"v":0,"d":"0.00"}}]
["Taxes radio-TV (Billag)",{"$nulls":7},{"$f":"E29+F29/3+G29/6+H29/12","v":{"v":0,"d":"0.00"}}]
["Téléréseau TéléLancy",{"$nulls":7},{"$f":"E30+F30/3+G30/6+H30/12","v":{"v":0,"d":"0.00"}}]
["Abonnement Internet",{"$nulls":7},{"$f":"E31+F31/3+G31/6+H31/12","v":{"v":0,"d":"0.00"}}]
["Divers",{"$nulls":7},{"$f":"E32+F32/3+G32/6+H32/12","v":{"v":0,"d":"0.00"}}]
["ASSURANCES"]
["Prime d'assurance maladie Monsieur",{"$nulls":7},{"$f":"E34+F34/3+G34/6+H34/12","v":{"v":0,"d":"0.00"}}]
["Prime d'assurance maladie Madame",{"$nulls":7},{"$f":"E35+F35/3+G35/6+H35/12","v":{"v":0,"d":"0.00"}}]
["Participation aux frais médicaux (franchise + frais)",{"$nulls":7},{"$f":"E36+F36/3+G36/6+H36/12","v":{"v":0,"d":"0.00"}}]
["Dentiste",{"$nulls":7},{"$f":"E37+F37/3+G37/6+H37/12","v":{"v":0,"d":"0.00"}}]
["Ass. responsabilité civile ",{"$nulls":7},{"$f":"E38+F38/3+G38/6+H38/12","v":{"v":0,"d":"0.00"}}]
["Ass. ménage",{"$nulls":7},{"$f":"E39+F39/3+G39/6+H39/12","v":{"v":0,"d":"0.00"}}]
["Ass. Bâtiment",{"$nulls":7},{"$f":"E40+F40/3+G40/6+H40/12","v":{"v":0,"d":"0.00"}}]
["Ass. RC Auto",{"$nulls":7},{"$f":"E41+F41/3+G41/6+H41/12","v":{"v":0,"d":"0.00"}}]
["Ass. RC Moto",{"$nulls":7},{"$f":"E42+F42/3+G42/6+H42/12","v":{"v":0,"d":"0.00"}}]
["Divers",{"$nulls":7},{"$f":"E43+F43/3+G43/6+H43/12","v":{"v":0,"d":"0.00"}}]
["TRANSPORTS / VEHICULES"]
["Voiture (impôts, vignette) ",{"$nulls":7},{"$f":"E45+F45/3+G45/6+H45/12","v":{"v":0,"d":"0.00"}}]
["Moto (impôts) ",{"$nulls":7},{"$f":"E46+F46/3+G46/6+H46/12","v":{"v":0,"d":"0.00"}}]
["Voiture (services, réparations, pneus) ",{"$nulls":7},{"$f":"E47+F47/3+G47/6+H47/12","v":{"v":0,"d":"0.00"}}]
["Voiture (essence) ",{"$nulls":7},{"$f":"E48+F48/3+G48/6+H48/12","v":{"v":0,"d":"0.00"}}]
["Transports publics (tram, bus, train)",{"$nulls":7},{"$f":"E49+F49/3+G49/6+H49/12","v":{"v":0,"d":"0.00"}}]
["Divers",{"$nulls":7},{"$f":"E50+F50/3+G50/6+H50/12","v":{"v":0,"d":"0.00"}}]
["Loisirs ","LOISIRS"]
["Vacances",{"$nulls":7},{"$f":"E52+F52/3+G52/6+H52/12","v":{"v":0,"d":"0.00"}}]
["Journaux, revues, TRIBUNE DE GENEVE",{"$nulls":7},{"$f":"E53+F53/3+G53/6+H53/12","v":{"v":0,"d":"0.00"}}]
["Animaux domestiques (aliments, vétérinaire)",{"$nulls":7},{"$f":"E54+F54/3+G54/6+H54/12","v":{"v":0,"d":"0.00"}}]
["Location-leasing d'objets (télé, ordinateur, frigo, etc.)",{"$nulls":7},{"$f":"E55+F55/3+G55/6+H55/12","v":{"v":0,"d":"0.00"}}]
["Sports",{"$nulls":7},{"$f":"E56+F56/3+G56/6+H56/12","v":{"v":0,"d":"0.00"}}]
["Autres",{"$nulls":7},{"$f":"E57+F57/3+G57/6+H57/12","v":{"v":0,"d":"0.00"}}]
["IMPOTS"]
["Impôt cantonal (revenu et fortune) ",{"$nulls":7},{"$f":"E59+F59/3+G59/6+H59/12","v":{"v":0,"d":"0.00"}}]
["Impôt communal (revenu et fortune)",{"$nulls":7},{"$f":"E60+F60/3+G60/6+H60/12","v":{"v":0,"d":"0.00"}}]
["Impôt fédéral direct ",{"$nulls":7},{"$f":"E61+F61/3+G61/6+H61/12","v":{"v":0,"d":"0.00"}}]
["Total dépenses courantes",{"$nulls":3},{"$f":"SUM(E15:E61)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F15:F61)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G15:G61)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H15:H61)","v":{"v":0,"d":"0.00"}},{"$f":"E62+F62/3+G62/6+H62/12","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J15:J61)","v":{"v":0,"d":"0.00"}}]
[]
["Remboursement des dettes",{"$nulls":3},"Mensuel","Trimestriel","Semestriel","Annuel","Mensuel moyen aujourd'hui","Mensuel moyen à la retraite"]
["Remboursement crédit personnel",{"$nulls":7},{"$f":"E65+F65/3+G65/6+H65/12","v":{"v":0,"d":"0.00"}}]
["Remboursement carte de crédit",{"$nulls":7},{"$f":"E66+F66/3+G66/6+H66/12","v":{"v":0,"d":"0.00"}}]
["Remboursement factures diverses",{"$nulls":7},{"$f":"E67+F67/3+G67/6+H67/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"$f":"E68+F68/3+G68/6+H68/12","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"$f":"E69+F69/3+G69/6+H69/12","v":{"v":0,"d":"0.00"}}]
["Total des  mensualités des dettes :",{"$nulls":3},{"$f":"SUM(E65:E69)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F65:F69)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G65:G69)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H65:H69)","v":{"v":0,"d":"0.00"}},{"$f":"E70+F70/3+G70/6+H70/12","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J65:J69)","v":{"v":0,"d":"0.00"}}]
[]
["Total des dépenses (dépense courantes + dettes)",{"$nulls":3},{"$f":"SUM(E70+E62)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F70+F62)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G70+G62)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H70+H62)","v":{"v":0,"d":"0.00"}},{"$f":"E72+F72/3+G72/6+H72/12","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J70,J62)","v":{"v":0,"d":"0.00"}}]
[]
["Solde :",{"$nulls":7},{"$f":"I11-I72","v":{"v":0,"d":"0.00"}},{"$f":"J11-J72","v":{"v":0,"d":"0.00"}}]