{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["1er sans Formule","Budget effectif simple","Budget effectif détaillé","Budget aide sociale","Budget aides privées","ME OP Ind.","ME OP Couple","Budget créanciers","Budget de gestion","Sous-budget santé","Sous budget maison","Etat des dettes","Capacité remboursement","Plan désendettement","Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":2,"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":"1er sans Formule","index":0,"n_rows":102,"n_cols":7,"rows_kept":102,"cut":false,"hidden":false,"merged":[[68,0,68,1],[69,0,69,1],[65,0,65,1],[101,5,101,6],[101,0,101,4],[86,0,86,1],[88,5,88,6],[88,0,88,4],[90,0,90,1],[99,0,99,1],[98,0,98,1],[97,0,97,1],[96,0,96,1],[95,0,95,1],[94,0,94,1],[93,0,93,1],[92,0,92,1],[91,0,91,1],[79,0,79,1],[84,0,84,1],[83,0,83,1],[82,0,82,1],[81,0,81,1],[80,0,80,1],[71,0,71,1],[77,0,77,1],[76,0,76,1],[75,0,75,1],[74,0,74,1],[73,0,73,1],[72,0,72,1],[48,0,48,1],[56,0,56,1],[64,0,64,1],[63,0,63,1],[62,0,62,1],[61,0,61,1],[60,0,60,1],[59,0,59,1],[58,0,58,1],[57,0,57,1],[53,0,53,1],[52,0,52,1],[51,0,51,1],[50,0,50,1],[49,0,49,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[47,0,47,1],[46,0,46,1],[42,0,42,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[27,0,27,1],[24,0,24,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[25,0,25,1],[26,0,26,1],[0,0,0,6],[11,0,11,6],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1]]}
["Revenus"]
[]
[null,null,"Mensuel","Trimestriel","Semestriel","Annuel","Moyenne"]
["Revenu net  + 13e salaire"]
["Revenu net partenaire"]
["Allocations familiales"]
["Pension alimentaire"]
["Contributions enfants majeurs"]
["Autres revenus"]
["Total revenus"]
[]
["Dépenses"]
[]
["Habitat",null,"Mensuel","Trimestrie","Semestriel","Annuel","Moyenne"]
["Loyer"]
["Charges"]
["Electricité "]
["Eau"]
["Taxes déchets"]
["Equipement mobilier"]
["Caution (Swisscaution,…)"]
["Décompte charges"]
[]
[]
["Communication"]
["Radio, TV, Billag, téléréseau"]
["Téléphone fix, internet"]
["Natel"]
[]
["Impôts et assurances"]
["Impôts cantonal"]
["Impôt fédéral direct"]
["Taxe militaire"]
["Taxes non-pompier"]
["Ass. Perte de gain maladie privée"]
["Caisse-maladie"]
["Cotisations AVS non actifs"]
["Association professionnelle"]
["Assurance ménage +RC"]
["Protection juridique"]
[]
[]
["Entretien"]
["Pension alimentaire"]
["Nourriture"]
["Produits ménagers"]
["Repas à l'exétérieur"]
["Frais de garde enfants"]
["Participation soins + franchise"]
["Dentiste, opticien"]
["Vêtements, chaussures"]
["Coiffeur, manucure"]
["Animaux (taxes, vaccins, nourriture)"]
["Equipement  ménager"]
[]
[]
["Loisirs"]
["Sorties, loisirs, sports"]
["Activités extra scol."]
["Cadeaux"]
["Revues cotisations diverses associations"]
["Invitations à domicile"]
["Argent de poche"]
["Cigarettes"]
["Jeu d'argent, boissons alcoolisées"]
["Vacances"]
[]
[null,"Formation"]
["Frais de perfectionnement"]
["Frais instruction enfants (écolage)"]
[]
["Voiture et transports"]
["Assurances + plaques auto"]
["Parking"]
["Essence"]
["Voiture : service, répar., pneus"]
["Transports publics"]
["Leasing"]
[]
["Epargne"]
["Epargne enfants"]
["Epargne vacances"]
["Epargne imprévus"]
["Epargne formation"]
["Epargne 3e pilier"]
[]
["Divers"]
[]
["Total dépenses"]
[]
["Dettes"]
["Cartes de crédit"]
["Paiements acomptes "]
["Arrangements factures en retard"]
["Amortissement hypothécaire"]
["Remboursement crédits"]
["Société de recouvrement"]
["Cession de salaire"]
["Découverts bancaires"]
["Office des poursuites"]
[]
["Montant disponible"]

{"sheet":"Budget effectif simple","index":1,"n_rows":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":false,"merged":[[54,0,54,3]]}
["Budget mensuel effectif"]
[]
[]
["Nom, prénom",null,null,"Domicile",null,"Nbre pers.",null,"Date"]
[]
[]
[]
["Revenus"]
[]
["Revenu net mensuel *",null,null,"* (sans le 13ème salaire)"]
["Revenu net mensuel partenaire *"]
["Pension, contrib. entretien"]
["Autres revenus",null,null,null,null,null,null,{"$f":"SUM(F10:F13)","v":0}]
[]
["Total revenus",null,null,null,null,null,null,{"$f":"SUM(F10:F13)","v":0}]
[]
[]
["Dépenses"]
[]
["Entretien"]
["Vêtements, chaussures"]
["Eau, électricité (sauf charges)"]
["Déplacements (sauf travail)"]
["Téléphone, radio, TV"]
["Loisirs, cadeaux"]
["Argent de poche",null,null,null,null,null,null,{"$f":"SUM(F20:F26)","v":0}]
[]
["Loyer + charges"]
["Caisse-maladie"]
["Participation / franchise"]
["Repas à l'extérieur"]
["Déplacements professionnels"]
["Garde d'enfants, droit de visite"]
["Pension, contrib. entretien"]
["Autres assurances"]
["Impôts"]
["Vacances, formation"]
["Divers, imprévus"]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(F28:F40)","v":0}]
[]
[]
["Leasing"]
["Assurances + plaques auto"]
["Réparation",null,null,null,null,null,null,{"$f":"SUM(F43:F45)","v":0}]
[]
["Office des poursuites"]
["Remboursement crédit"]
["Cession, saisie"]
[null,null,null,null,null,null,null,{"$f":"SUM(F47:F50)","v":0}]
[]
["Total dépenses",null,null,null,null,null,null,{"$f":"SUM(H20:H50)","v":0}]
[]
[]
["Résultat",null,null,null,null,null,null,{"$f":"H15-H52","v":0}]
[]
[]
[]
["Répartition du 13ème salaire"]
[]
["13ème salaire",null,null,null,null,null,null,{"$f":"F61/12","v":0}]
["13ème salaire partenaire",null,null,null,null,null,null,{"$f":"F62/12","v":0}]
[]
["Total mensuel 13ème **",null,null,null,null,null,null,{"$f":"SUM(H61:H62)","v":0}]
[]
[]
[null,null,null,"** (13ème salaire non comptabilisé dans le budget effectif)"]

{"sheet":"Budget effectif détaillé","index":2,"n_rows":108,"n_cols":7,"rows_kept":108,"cut":false,"hidden":false,"merged":[[72,0,72,1],[73,0,73,1],[69,0,69,1],[107,0,107,5],[9,0,9,1],[103,0,103,1],[102,0,102,1],[101,0,101,1],[100,0,100,1],[99,0,99,1],[98,0,98,1],[97,0,97,1],[96,0,96,1],[95,0,95,1],[47,0,47,1],[60,0,60,1],[8,0,8,1],[7,0,7,1],[6,0,6,1],[94,0,94,1],[92,0,92,5],[90,0,90,1],[88,0,88,1],[87,0,87,1],[86,0,86,1],[81,0,81,1],[65,0,65,1],[64,0,64,1],[63,0,63,1],[50,0,50,1],[49,0,49,1],[48,0,48,1],[5,0,5,1],[4,0,4,1],[85,0,85,1],[84,0,84,1],[83,0,83,1],[10,0,10,1],[75,0,75,1],[80,0,80,1],[79,0,79,1],[78,0,78,1],[77,0,77,1],[76,0,76,1],[62,0,62,1],[68,0,68,1],[67,0,67,1],[66,0,66,1],[61,0,61,1],[57,0,57,1],[56,0,56,1],[55,0,55,1],[54,0,54,1],[53,0,53,1],[52,0,52,1],[51,0,51,1],[27,0,27,1],[46,0,46,1],[42,0,42,1],[41,0,41,1],[40,0,40,1],[39,0,39,1],[36,0,36,1],[35,0,35,1],[34,0,34,1],[33,0,33,1],[45,0,45,1],[38,0,38,1],[37,0,37,1],[105,0,105,5],[32,0,32,1],[0,0,0,6],[12,0,12,6],[16,0,16,1],[24,0,24,1],[23,0,23,1],[22,0,22,1],[21,0,21,1],[20,0,20,1],[19,0,19,1],[18,0,18,1],[17,0,17,1],[30,0,30,1],[29,0,29,1],[28,0,28,1]]}
["Revenus"]
[]
[null,null,"Mensuel","Trimestriel","Semestriel","Annuel","Moyenne"]
[]
["Revenu net  + 13e salaire",null,null,null,null,null,{"$f":"C5+D5/3+E5/6+F5/12","v":0}]
["Revenu net partenaire",null,null,null,null,null,0]
["Allocations familiales",null,null,null,null,null,0]
["Pension alimentaire",null,null,null,null,null,0]
["Contributions enfants majeurs",null,null,null,null,null,0]
["Autres revenus",null,null,null,null,null,0]
["Total revenus",null,{"$f":"SUM(C5:C10)","v":0},{"$f":"SUM(D5:D10)","v":0},{"$f":"SUM(E5:E10)","v":0},{"$f":"SUM(F5:F10)","v":0},{"$f":"(C11*12+D11*4+E11*2+F11)/12","v":0}]
[]
["Dépenses"]
[]
[null,null,"Mensuel","Trimestriel","Semestriel","Annuel","Moyenne"]
[]
["Habitat",null,{"$f":"SUM(G18:G25)","v":0}]
["Loyer",null,null,null,null,null,{"$f":"C18+D18/3+E18/6+F18/12","v":0}]
["Charges",null,null,null,null,null,{"$f":"C19+D19/3+E19/6+F19/12","v":0}]
["Electricité ",null,null,null,null,null,0]
["Eau",null,null,null,null,null,0]
["Taxes déchets",null,null,null,null,null,0]
["Equipement mobilier",null,null,null,null,null,0]
["Caution (Swisscaution,…)",null,null,null,null,null,0]
["Décompte charges",null,null,null,null,null,0]
[]
[]
["Communication",null,{"$f":"SUM(G29:G31)","v":0}]
["Radio, TV, Billag, téléréseau",null,null,null,null,null,{"$f":"C29+D29/3+E29/6+F29/12","v":0}]
["Téléphone fixe, internet",null,null,null,null,null,{"$f":"C30+D30/3+E30/6+F30/12","v":0}]
["Natel",null,null,null,null,null,{"$f":"C31+D31/3+E31/6+F31/12","v":0}]
[]
["Impôts et assurances",null,{"$f":"SUM(G34:G43)","v":0}]
["Impôts cantonal",null,null,null,null,null,{"$f":"C34+D34/3+E34/6+F34/12","v":0}]
["Impôt fédéral direct",null,null,null,null,null,0]
["Taxe militaire",null,null,null,null,null,0]
["Taxes non-pompier",null,null,null,null,null,0]
["Ass. Perte de gain maladie privée",null,null,null,null,null,0]
["Caisse-maladie",null,null,null,null,null,0]
["Cotisations AVS non actifs",null,null,null,null,null,0]
["Association professionnelle",null,null,null,null,null,0]
["Assurance ménage +RC",null,null,null,null,null,0]
["Protection juridique",null,null,null,null,null,0]
[]
[]
["Entretien",null,{"$f":"SUM(G47:G58)","v":0}]
["Pension alimentaire",null,null,null,null,null,{"$f":"C47+D47/3+E47/6+F47/12","v":0}]
["Nourriture",null,null,null,null,null,0]
["Produits ménagers et lessiverie",null,null,null,null,null,0]
["Repas à l'extérieur",null,null,null,null,null,0]
["Garde enfants",null,null,null,null,null,0]
["Exercice droit de visite",null,null,null,null,null,0]
["Participation soins + franchise",null,null,null,null,null,0]
["Dentiste, opticien",null,null,null,null,null,0]
["Vêtements, chaussures",null,null,null,null,null,0]
["Coiffeur, manucure",null,null,null,null,null,0]
["Animaux (taxes, vaccins, nourriture)",null,null,null,null,null,0]
["Equipement ménager",null,null,null,null,null,0]
[]
[]
["Loisirs",null,{"$f":"SUM(G62:G69)","v":0}]
["Sorties, loisirs, sports",null,null,null,null,null,{"$f":"C62+D62/3+E62/6+F62/12","v":0}]
["Activités extra scol.",null,null,null,null,null,0]
["Cadeaux",null,null,null,null,null,0]
["Revues,cotisations diverses associations",null,null,null,null,null,0]
["Invitations à domicile",null,null,null,null,null,0]
["Argent de poche",null,null,null,null,null,0]
["Cigarettes",null,null,null,null,null,0]
["Jeu d'argent, boissons alcoolisées",null,null,null,null,null,0]
["Vacances",null,null,null,null,null,{"$f":"C70+D70/3+E70/6+F70/12","v":0}]
[]
[null,"Formation",{"$f":"G73+G74","v":0}]
["Frais de perfectionnement professionnels",null,null,null,null,null,{"$f":"C73+D73/3+E73/6+F73/12","v":0}]
["Frais instruction enfants (écolage)",null,null,null,null,null,{"$f":"C74+D74/3+E74/6+F74/12","v":0}]
[]
["Voiture et transports",null,{"$f":"SUM(G77:G82)","v":0}]
["Assurances + plaques auto",null,null,null,null,null,{"$f":"C77+D77/3+E77/6+F77/12","v":0}]
["Parking",null,null,null,null,null,0]
["Essence",null,null,null,null,null,0]
["Voiture : service, répar., pneus",null,null,null,null,null,0]
["Transports publics",null,null,null,null,null,0]
["Leasing",null,null,null,null,null,0]
[]
["Epargne",null,{"$f":"SUM(G85:G89)","v":0}]
["Epargne enfants",null,null,null,null,null,{"$f":"C85+D85/3+E85/6+F85/12","v":0}]
["Epargne vacances",null,null,null,null,null,{"$f":"C86+D86/3+E86/6+F86/12","v":0}]
["Epargne imprévus",null,null,null,null,null,{"$f":"C87+D87/3+E87/6+F87/12","v":0}]
["Epargne formation",null,null,null,null,null,{"$f":"C88+D88/3+E88/6+F88/12","v":0}]
["Epargne 3e pilier",null,null,null,null,null,{"$f":"C89+D89/3+E89/6+F89/12","v":0}]
[]
["Divers",null,null,null,null,null,{"$f":"C91+D91/3+E91/6+F91/12","v":0}]
[]
["Total dépenses courantes",null,null,null,null,null,{"$f":"SUM(G18:G91)","v":0}]
[]
["Dettes",null,{"$f":"SUM(G96:G104)","v":0}]
["Cartes de crédit",null,null,null,null,null,{"$f":"C96+D96/3+E96/6+F96/12","v":0}]
["Paiements acomptes ",null,null,null,null,null,{"$f":"C97+D97/3+E97/6+F97/12","v":0}]
["Arrangements factures en retard",null,null,null,null,null,0]
["Amortissement hypothécaire",null,null,null,null,null,0]
["Remboursement crédits",null,null,null,null,null,0]
["Société de recouvrement",null,null,null,null,null,0]
["Cession de salaire",null,null,null,null,null,0]
["Découverts bancaires",null,null,null,null,null,0]
["Office des poursuites",null,null,null,null,null,0]
[]
["Total dépenses ",null,null,null,null,null,{"$f":"G93+C95","v":0}]
[]
["Montant disponible",null,null,null,null,null,{"$f":"G11-G106","v":0}]

{"sheet":"Budget aide sociale","index":3,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,0,4,1],[0,0,0,7],[38,0,38,5],[7,0,7,7],[19,0,19,7],[3,0,3,1]]}
["Calcul du minimum vital social"]
[]
[]
["Nom, prénom",null,null,"Domicile",null,"Nbre pers.",null,"Date"]
[null,null,null,null,null,{"$f":"'Budget de gestion'!$E$5","v":0}]
[]
[]
["Revenus"]
[]
["Revenu net mensuel *",null,null,"* (sans le 13ème salaire)",null,{"$f":"'Budget effectif détaillé'!C5","v":0}]
["Revenu net mensuel partenaire *",null,null,null,null,{"$f":"'Budget effectif détaillé'!C6","v":0}]
["Pension, contrib. entretien",null,null,null,null,{"$f":"'Budget effectif détaillé'!C8","v":0}]
["Autres revenus",null,null,null,null,{"$f":"'Budget effectif détaillé'!G10","v":0},null,{"$f":"SUM(F10:F13)","v":0}]
[]
["Franchise s/ revenu",null,null,"nbre de bénéficiaires (fr. 400.-)",null,{"$f":"B15*400","v":0}]
["Franch. s/ revenu apprentis",null,null,"nbre de bénéficiaires (fr. 150.-)",null,{"$f":"B16*150","v":0},null,{"$f":"F15+F16","v":0}]
[]
["Total revenus",null,null,null,null,null,null,{"$f":"H13-H16","v":0}]
[]
["Minimum vital social"]
[]
["Forfait pour l'entretien + 25 ans",null,null,"nbre de pers. dans le ménage",null,{"$f":"IF(B22=1,986,IF(B22=2,1509,IF(B22=3,1834,IF(B22=4,2110,IF(B22=5,2386,IF(B22=6,2582,IF(B22=7,2912,0)))))))","v":0},null,{"$f":"F22+F23","v":0}]
["Forfait pour l'entretien - 25 ans",null,null,"nbre de pers. dans le ménage",null,{"$f":"IF(B23=1,788.8,IF(B23=2,1207,IF(B23=3,1467.2,IF(B23=4,1688,IF(B23=5,2386,IF(B23=6,2068,IF(B23=7,2329.6,0)))))))","v":0}]
["Suppl. d'intégration normal",null,null,"nbre de bénéficiaires (fr. 250.-)",null,{"$f":"B24*200","v":0}]
["Suppl. d'intégration normal",null,null,"nbre de bénéficiaires (fr. 150.-)",null,{"$f":"B25*150","v":0},null,{"$f":"IF(SUM(F24:F25)<850,(SUM(F24:F25)),IF(SUM(F24:F25)>=850,850))","v":0}]
[]
["Frais de logement",null,null,null,null,{"$f":"'Budget effectif détaillé'!G18+'Budget effectif détaillé'!G19","v":0}]
["Caisse-maladie",null,null,"pris en charge par le subside cantonal",null,{"$f":"'Budget effectif détaillé'!C39","v":0}]
["Participation / franchise/dentiste/opticien",null,null,null,null,{"$f":"'Budget effectif détaillé'!G53+'Budget effectif détaillé'!G54","v":0}]
["Repas à l'extérieur",null,null,"nbre de repas",null,{"$f":"B30*8","v":0}]
["Frais de déplacement rprofessionnels reconnus ( à remplir)"]
["Garde d'enfants / écolage",null,null,null,null,{"$f":"'Budget effectif détaillé'!G51","v":0}]
["Frais de perfectionnement",null,null,null,null,{"$f":"'Budget effectif détaillé'!G73","v":0}]
["Exercice droit de visite",null,null,null,null,{"$f":"'Budget effectif détaillé'!G52","v":0},null,{"$f":"SUM(F27:F34)","v":0}]
[]
["Total minimum vital social",null,null,null,null,null,null,{"$f":"H22+H25+H34","v":0}]
[]
[]
["Résultat",null,null,null,null,null,null,{"$f":"H18-H36","v":0}]

{"sheet":"Budget aides privées","index":4,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[4,0,4,1],[51,0,51,5],[0,0,0,7],[3,0,3,1],[19,0,19,1]]}
["Budget mensuel effectif"]
[]
[]
["Nom, prénom",null,null,"Domicile",null,"Nbre pers.",null,"Date"]
[{"$f":"'Budget aide sociale'!A5:B5","v":0},null,null,{"$f":"'Budget aide sociale'!D5","v":0},null,{"$f":"'Budget aide sociale'!F5","v":0},null,{"$f":"'Budget aide sociale'!H5","v":0}]
[]
["Revenus"]
[]
["Revenu net mensuel *",null,null,"* (sans le 13ème salaire)",null,{"$f":"'Budget aide sociale'!F10","v":0}]
["Revenu net mensuel partenaire *",null,null,null,null,{"$f":"'Budget aide sociale'!F11","v":0}]
["Pension, contrib. entretien",null,null,null,null,{"$f":"'Budget aide sociale'!F12","v":0}]
["Autres revenus",null,null,null,null,{"$f":"'Budget aide sociale'!F13","v":0},null,{"$f":"SUM(F9:F12)","v":0}]
[]
["Total revenus",null,null,null,null,null,null,{"$f":"SUM(F9:F12)","v":0}]
[]
["Dépenses"]
[]
["Nourriture",null,null,null,null,{"$f":"'Budget effectif détaillé'!G48","v":0}]
["Vêtements, chaussures",null,null,null,null,{"$f":"'Budget effectif détaillé'!G55","v":0}]
["Produits ménagers et lessiverie",null,null,null,null,{"$f":"'Budget effectif détaillé'!G49","v":0}]
["Eau, électricité (sauf charges)",null,null,null,null,{"$f":"'Budget effectif détaillé'!G20+'Budget effectif détaillé'!G21","v":0}]
["Déplacements (sauf travail)"]
["Téléphone, radio, TV",null,null,null,null,{"$f":"'Budget effectif détaillé'!G29+'Budget effectif détaillé'!G30+'Budget effectif détaillé'!G31","v":0}]
["Loisirs, cadeaux",null,null,null,null,{"$f":"'Budget effectif détaillé'!G62+'Budget effectif détaillé'!G64","v":0}]
["Argent de poche",null,null,null,null,{"$f":"'Budget effectif détaillé'!G67","v":0},null,{"$f":"SUM(F18:F25)","v":0}]
[]
["Loyer + charges",null,null,null,null,{"$f":"'Budget effectif détaillé'!G18+'Budget effectif détaillé'!G19","v":0}]
["Caisse-maladie",null,null,null,null,{"$f":"'Budget effectif détaillé'!C39","v":0}]
["Participation / franchise/dentiste/opticien",null,null,null,null,{"$f":"'Budget aide sociale'!F29+'Budget effectif détaillé'!G54","v":0}]
["Repas à l'extérieur",null,null,null,null,{"$f":"'Budget effectif détaillé'!G50","v":0}]
["Déplacements professionnels"]
["Garde d'enfants, droit de visite",null,null,null,null,{"$f":"'Budget aide sociale'!F34+'Budget aide sociale'!F32","v":0}]
["Pension, contrib. entretien",null,null,null,null,{"$f":"'Budget effectif détaillé'!G47","v":0}]
["Autres assurances",null,null,null,null,{"$f":"'Budget effectif détaillé'!G40+'Budget effectif détaillé'!G42","v":0}]
["Impôts",null,null,null,null,{"$f":"'Budget effectif détaillé'!G34+'Budget effectif détaillé'!G35","v":0}]
["Perfectionnement"]
["Divers, imprévus",null,null,null,null,{"$f":"'Budget effectif détaillé'!G91","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(F27:F38)","v":0}]
[]
[]
["Leasing",null,null,null,null,{"$f":"'Budget effectif détaillé'!C82","v":0}]
["Assurances + plaques auto",null,null,null,null,{"$f":"'Budget effectif détaillé'!G77","v":0}]
["Entretien et réparation",null,null,null,null,{"$f":"'Budget effectif détaillé'!G80","v":0},null,{"$f":"SUM(F41:F43)","v":0}]
[]
["Office des poursuites"]
["Remboursement crédits"]
["Cession, saisie"]
[null,null,null,null,null,null,null,{"$f":"SUM(F45:F48)","v":0}]
[]
["Total dépenses",null,null,null,null,null,null,{"$f":"SUM(H18:H48)","v":0}]
[]
["Résultat",null,null,null,null,null,null,{"$f":"H14-H50","v":0}]

{"sheet":"ME OP Ind.","index":5,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,7],[40,0,40,5],[3,0,3,1],[4,0,4,1],[41,0,41,5]]}
["ME OP adulte seul / non qualifié"]
[]
[]
["Nom, prénom",null,null,"Domicile",null,"Nbre pers.",null,"Date"]
[{"$f":"'Budget aide sociale'!A5:B5","v":0},null,null,{"$f":"'Budget aide sociale'!D5","v":0},null,{"$f":"'Budget aide sociale'!F5","v":0},null,{"$f":"'Budget aide sociale'!H5","v":0}]
[]
[null,1,null,"unité",null,null,null,"montant"]
[]
[]
["Revenus mensuels"]
[]
["Revenu net mensuel *",null,null,"* (sans le 13ème salaire)",null,{"$f":"'Budget aide sociale'!F10","v":0}]
["Pension, contrib. entretien",null,null,null,null,{"$f":"'Budget aide sociale'!F12","v":0}]
["Autres revenus mensuels",null,null,null,null,{"$f":"'Budget aide sociale'!F13","v":0},null,{"$f":"SUM(F12:F14)","v":0}]
[]
["Total revenus mensuels",null,null,null,null,null,null,{"$f":"SUM(F12:F14)","v":0}]
["13e salaire"]
["Minimum d'existence"]
[]
["Montant de base","*",null,"néant",null,{"$f":"IF(F21=1,0,IF(F21=2,1200,IF(F21=3,1350,IF(F21=4,1700))))","v":0}]
[null,null,null,"débiteur vivant seul",null,1]
[null,null,null,"débiteur seul avec obligation soutien"]
[null,null,null,"couple"]
[null,null,null,"nbre enfants jusqu'à 10 ans",null,{"$f":"B24*400","v":0}]
[null,null,null,"nbre enfants de + 10 ans",null,{"$f":"B25*600","v":0}]
["Besoins alimentaires accrus",null,null,"journées de travail",null,{"$f":"B26*5.5","v":0}]
["Usure des vêtements",null,null,null,null,{"$f":"'Budget effectif détaillé'!G17+'Budget effectif détaillé'!G18","v":0}]
["Loyer + frais de charges",null,null,null,null,{"$f":"'Budget effectif détaillé'!G18+'Budget effectif détaillé'!G19","v":0}]
["Cotisations sociales",null,null,null,null,{"$f":"'Budget effectif détaillé'!G39","v":0}]
["Soins médicaux/participations/franchises/ dentiste/opticien",null,null,null,null,{"$f":"'Budget effectif détaillé'!G53+'Budget effectif détaillé'!G54","v":0}]
["Repas à l'extérieur",null,null,"nbre de repas",null,{"$f":"B31*11","v":0}]
["Frais de déplacement professionnels reconnus",null,null,null,null,{"$f":"B32*11","v":0}]
["Contribution d'assistance",null,null,null,null,{"$f":"'Budget effectif détaillé'!G47","v":0}]
["Frais d'instruction enfants",null,null,null,null,{"$f":"'Budget effectif détaillé'!G74","v":0}]
["Location / leasing objets de stricte nécessité",null,null,null,null,{"$f":"'Budget effectif détaillé'!G82","v":0}]
["Exercice droit de visite",null,null,null,null,{"$f":"'Budget effectif détaillé'!G52","v":0}]
["Divers",null,null,null,null,{"$f":"'Budget effectif détaillé'!G53","v":0},null,{"$f":"SUM(F27:F37)","v":0}]
[]
["Total minimum d'existence",null,null,null,null,null,null,{"$f":"F20+F24+F25+F26+F28+F29+F30+F31+F32+F33+F35+F34+F36+F37","v":0}]
[]
["Saisie mensuelle",null,null,null,null,null,null,{"$f":"H16-H39","v":0}]
["Saisie du 13ème salaire",null,null,null,null,null,null,{"$f":"F17*0.6","v":0}]

{"sheet":"ME OP Couple","index":6,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[34,5,34,7],[35,5,35,7],[36,5,36,7],[37,5,37,7],[39,5,39,7],[32,5,32,7],[33,5,33,7],[0,0,0,7],[3,0,3,1],[4,0,4,1],[24,5,24,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[20,5,20,7],[28,5,28,7],[29,5,29,7],[30,5,30,7],[31,5,31,7]]}
["Calcul du minimum d'existence OP couple marié ou concubin qualifiés"]
[]
[]
["Nom, prénom",null,null,"Domicile",null,"Nbre pers.",null,"Date"]
[{"$f":"'Budget aide sociale'!A5:B5","v":0},null,null,{"$f":"'Budget aide sociale'!D5","v":0},null,{"$f":"'Budget aide sociale'!F5","v":0},null,{"$f":"'Budget aide sociale'!H5","v":0}]
[]
[null,1,null,"unité",null,null,null,"montant"]
[]
[]
["Revenus mensuels",null,null,null,null,"Conjoint 1",null,"Conjoint 2"]
[]
["Revenu net mensuel *",null,null,"* (sans le 13ème salaire)"]
["Pension, contrib. entretien"]
["Autres revenus mensuels"]
[]
["Total revenus mensuels",null,null,{"$f":"F16+H16","v":0},null,{"$f":"SUM(F12:F14)","v":0},{"$f":"SUM(G12:G14)","v":0},{"$f":"SUM(H12:H14)","v":0}]
["Taux % de participation aux besoins",null,null,{"$f":"H17+F17","v":{"$error":"#DIV/0!"}},null,{"$f":"100*F16/D16","v":{"$error":"#DIV/0!"}},null,{"$f":"100*H16/D16","v":{"$error":"#DIV/0!"}}]
["13e salaire",null,null,null,null,null,3200]
["Minimum d'existence"]
[]
["Montant de base","*",null,"néant",null,{"$f":"IF(F22=1,0,IF(F22=2,1200,IF(F22=3,1350,IF(F22=4,1700))))","v":0}]
[null,null,null,"débiteur vivant seul",null,1]
[null,null,null,"débiteur seul avec obligation soutien"]
[null,null,null,"couple"]
[null,null,null,"nbre enfants jusqu'à 10 ans",null,{"$f":"B25*400","v":0}]
[null,null,null,"nbre enfants de + 10 ans",null,{"$f":"B26*600","v":0}]
["Besoins alimentaires accrus",null,null,"journées de travail",null,{"$f":"B27*5.5","v":0}]
["Usure des vêtements",null,null,null,null,{"$f":"'Budget effectif détaillé'!G17+'Budget effectif détaillé'!G18","v":0}]
["Loyer + frais de charges"]
["Cotisations sociales",null,null,null,null,{"$f":"'Budget effectif détaillé'!G39","v":0}]
["Soins médicaux/participations/franchises/ dentiste/opticien",null,null,null,null,{"$f":"'Budget effectif détaillé'!G53+'Budget effectif détaillé'!G54","v":0}]
["Repas à l'extérieur",null,null,"nbre de repas",null,{"$f":"B32*11","v":0}]
["Frais de déplacement professionnels reconnus",null,null,null,null,{"$f":"B33*11","v":0}]
["Contribution d'assistance",null,null,null,null,{"$f":"'Budget effectif détaillé'!G47","v":0}]
["Frais d'instruction enfants",null,null,null,null,{"$f":"'Budget effectif détaillé'!G74","v":0}]
["Location / leasing objets de stricte nécessité",null,null,null,null,{"$f":"'Budget effectif détaillé'!G82","v":0}]
["Exercice droit de visite",null,null,null,null,{"$f":"'Budget effectif détaillé'!G52","v":0}]
["Divers",null,null,null,null,{"$f":"'Budget effectif détaillé'!G53","v":0}]
[]
["Total minimum d'existence",null,null,null,null,{"$f":"F21+F25+F26+F27+F28+F29+F30+F31+F32+F33+F34+F35+F36+F37+F38","v":0}]
["Participation de chaque conjoint",null,null,null,null,{"$f":"F40*F17/100","v":{"$error":"#DIV/0!"}},null,{"$f":"F40*H17/100","v":{"$error":"#DIV/0!"}}]
[]
["Saisie mensuelle",null,null,null,null,{"$f":"F16-F41","v":{"$error":"#DIV/0!"}},{"$f":"G16-G41","v":0},{"$error":"#DIV/0!"}]
["Saisie 13e ",null,null,null,null,{"$f":"F18*0.6","v":0},null,{"$f":"H18*0.6","v":0}]

{"sheet":"Budget créanciers","index":7,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,7],[40,0,40,5],[3,0,3,1],[4,0,4,1]]}
["Budget assainissement (OP élargi)"]
[]
[]
["Nom, prénom",null,null,"Domicile",null,"Nbre pers.",null,"Date"]
[{"$f":"'Budget aide sociale'!A5:B5","v":0},null,null,{"$f":"'Budget aide sociale'!D5","v":0},null,{"$f":"'Budget aide sociale'!F5","v":0},null,{"$f":"'Budget aide sociale'!H5","v":0}]
[]
["Revenus"]
[]
["Revenu net mensuel *",null,null,"* (sans le 13ème salaire)",null,{"$f":"'Budget aide sociale'!F10","v":0}]
["Revenu net mensuel partenaire *",null,null,null,null,{"$f":"'Budget aide sociale'!F11","v":0}]
["Pension, contrib. entretien",null,null,null,null,{"$f":"'Budget aide sociale'!F12","v":0}]
["Autres revenus",null,null,null,null,{"$f":"'Budget aide sociale'!F13","v":0},null,{"$f":"SUM(F9:F12)","v":0}]
[]
["Total revenus",null,null,null,null,null,null,{"$f":"SUM(F9:F12)","v":0}]
[]
["Dépenses"]
[]
["Montant de base","*",null,"néant",null,{"$f":"IF(F19=1,0,IF(F19=2,1200,IF(F19=3,1350,IF(F19=4,1700))))","v":0}]
[null,null,null,"débiteur vivant seul",null,1]
[null,null,null,"débiteur seul avec obligation soutien"]
[null,null,null,"couple"]
[null,null,null,"nbre enfants jusqu'à 10 ans",null,{"$f":"B22*400","v":0}]
[null,null,null,"nbre enfants de + 10 ans",null,{"$f":"B23*600","v":0}]
["Besoins alimentaires accrus",null,null,"journées de travail",null,{"$f":"B24*5.5","v":0}]
["Usure des vêtements",null,null,null,null,{"$f":"'Budget effectif détaillé'!G17+'Budget effectif détaillé'!G18","v":0}]
["Loyer + charges",null,null,null,null,{"$f":"'Budget effectif détaillé'!G18+'Budget effectif détaillé'!G19","v":0}]
["Cotisations sociales",null,null,null,null,{"$f":"'Budget effectif détaillé'!G39","v":0}]
["Impôts",null,null,null,null,{"$f":"'Budget effectif détaillé'!G34+'Budget effectif détaillé'!G35","v":0}]
["Autres assurances",null,null,null,null,{"$f":"'Budget effectif détaillé'!G38+'Budget effectif détaillé'!G40+'Budget effectif détaillé'!G42+'Budget effectif détaillé'!G43","v":0}]
["Soins médicaux/participations/franchise/dentiste/opticien",null,null,null,null,{"$f":"'Budget effectif détaillé'!G53+'Budget effectif détaillé'!G54","v":0}]
["Repas à l'extérieur",null,null,"nbre de repas",null,{"$f":"B31*11","v":0}]
["Frais de déplacement"]
["Contribution d'assistance",null,null,null,null,{"$f":"'Budget effectif détaillé'!G47","v":0}]
["Frais d'instruction enfants",null,null,null,null,{"$f":"'Budget effectif détaillé'!G74","v":0}]
["Paiements acomptes / leasing",null,null,null,null,{"$f":"'Budget effectif détaillé'!G82","v":0}]
["Exercice droit de visite",null,null,null,null,{"$f":"'Budget effectif détaillé'!G52","v":0}]
["Divers",null,null,null,null,null,null,{"$f":"SUM(F25:F37)","v":0}]
[]
["Total dépenses",null,null,null,null,null,null,{"$f":"F18+F22+F27+F23+F24+F26+F28+F29+F30+F31+F32+F33+F34+F35+F36+F37","v":0}]
[]
["Résultat",null,null,null,null,null,null,{"$f":"H14-H39","v":0}]
[]
["* concubin sans enfants communs et propres enfants chez ex: 1100"]
["concubin avec ses propres enfants et pas enfant commun: 1250"]
["concubins avec enfants en commun = couple"]

{"sheet":"Budget de gestion","index":8,"n_rows":82,"n_cols":33,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,8,0,31],[3,0,3,1],[4,0,4,1],[74,0,74,5],[6,30,6,31],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,14,6,15],[6,16,6,17],[6,18,6,19],[6,20,6,21],[6,22,6,23],[6,24,6,25],[6,26,6,27],[6,28,6,29],[62,0,62,1],[63,0,63,1],[64,0,64,1],[66,0,66,1],[30,0,30,1],[72,0,72,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1]]}
["Budget mensuel gestion (OP élargie sous une autre forme ) + dépenses",null,null,null,null,null,null,null,"Tableau des revenus et dépenses"]
[]
[]
["Nom, prénom",null,null,"Domicile",null,"Nbre pers.",null,"Date"]
[{"$f":"'Budget aide sociale'!A5:B5","v":0},null,null,{"$f":"'Budget aide sociale'!D5","v":0},null,{"$f":"'Budget aide sociale'!F5","v":0},null,{"$f":"'Budget aide sociale'!H5","v":0}]
[]
[null,null,null,null,null,null,null,null,"Janvier",null,"Février",null,"Mars",null,"Avril",null,"Mai",null,"Juin",null,"Juillet",null,"Août ",null,"Septembre",null,"Octobre",null,"Novembre",null,"Décembre",null,"Contrôle budget"]
["Revenus",null,null,null,null,null,null,null,"Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. ","Cpte courant","Cpte périod. "]
[null,null,null,null,"Mensuel","Annuel","Moyenne",null,"Revenus"]
["Revenu net ",null,null,null,{"$f":"'Budget effectif détaillé'!C5","v":0},{"$f":"'Budget effectif détaillé'!F5","v":0},{"$f":"E10+F10/12","v":0}]
["Revenu net mensuel partenaire *",null,null,null,{"$f":"'Budget effectif détaillé'!C6","v":0},{"$f":"'Budget effectif détaillé'!F6","v":0},{"$f":"E11+F11/12","v":0}]
["Pension, contrib. entretien",null,null,null,{"$f":"'Budget effectif détaillé'!C8+'Budget effectif détaillé'!C9","v":0},{"$f":"'Budget effectif détaillé'!F8+'Budget effectif détaillé'!F9","v":0},{"$f":"E12+F12/12","v":0}]
["Autres revenus",null,null,null,{"$f":"'Budget effectif détaillé'!C7+'Budget effectif détaillé'!C10","v":0},{"$f":"'Budget effectif détaillé'!F7+'Budget effectif détaillé'!F10","v":0},{"$f":"E13+F13/12","v":0}]
["Total revenus",null,null,null,{"$f":"SUM(E10:E13)","v":0},{"$f":"SUM(F10:F13)","v":0},{"$f":"SUM(G10:G13)","v":0}]
[]
["Dépenses",null,null,null,"Mensuel","Annuel","Moyenne"]
[]
["Factures mensuelles: budget =",null,null,{"$f":"SUM(G19:G24)","v":0},null,null,null,null,"Totaux mensuels des factures mensuelles payées",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solde"]
["Loyer + charges",null,null,null,{"$f":"'Budget effectif détaillé'!C18+'Budget effectif détaillé'!C19","v":0},null,{"$f":"E19","v":0},"Loyer + charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G19*12-I19-K19-M19-O19-Q19-S19-U19-W19-Y19-AA19-AC19-AE19","v":0}]
["Téléphone, internet, câble",null,null,null,{"$f":"'Budget effectif détaillé'!C30+'Budget effectif détaillé'!C31","v":0},null,{"$f":"E20","v":0},"Téléphone, internet, câble",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G20*12-I20-K20-M20-O20-Q20-S20-U20-W20-Y20-AA20-AC20-AE20","v":0}]
["Pension alimentaires",null,null,null,{"$f":"'Budget effectif détaillé'!C47","v":0},null,0,"Pension alimentaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Frais de garde enfants et écolage",null,null,null,{"$f":"'Budget effectif détaillé'!C51","v":0},null,0,"Frais de garde enfants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Caisse-maladie",null,null,null,{"$f":"'Budget effectif détaillé'!C39","v":0},null,0,"Caisse-maladie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Impôt cantonal",null,null,null,{"$f":"'Budget effectif détaillé'!C34","v":0},null,0,"Impôts cantonal",null,null,null,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,"Total",{"$f":"SUM(I19:I24)","v":0},null,{"$f":"SUM(K19:K24)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,null,null,null,null,null,null,null,"Totaux mensuels des factures périodiques payées"]
["Factures périodiques, budget =",null,null,{"$f":"SUM(G29:G48)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solde"]
["Vêtements, chaussures",null,null,null,null,{"$f":"'Budget effectif détaillé'!G55","v":0},{"$f":"F29/12","v":0},"Vêtements, chaussures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F29-J29-L29-N29-P29-R29-T29-V29-X29-Z29-AB29-AD29-AF29","v":0}]
["Coiffeur",null,null,null,null,{"$f":"'Budget effectif détaillé'!G56","v":0},{"$f":"F30/12","v":0},"Coiffeur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F30-J30-L30-N30-P30-R30-T30-V30-X30-Z30-AB30-AD30-AF30","v":0}]
["Garde enfants et écolage",null,null,null,null,{"$f":"'Budget effectif détaillé'!G51","v":0},0,"Frais d'instruction enfants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Dentiste, opticien",null,null,null,null,{"$f":"'Budget effectif détaillé'!G54","v":0},0,"Dentiste, opticien",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Participation / franchise",null,null,null,null,{"$f":"'Budget effectif détaillé'!G53","v":0},0,"Participation / franchise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Combustible ou décompte charges",null,null,null,null,{"$f":"'Budget effectif détaillé'!G25","v":0},0,"Combustible / décompte charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Electricité ",null,null,null,null,{"$f":"'Budget effectif détaillé'!G20","v":0},0,"Electricité ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Eau",null,null,null,null,{"$f":"'Budget effectif détaillé'!G21","v":0},0,"Eau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Radio, TV",null,null,null,null,{"$f":"'Budget effectif détaillé'!G29","v":0},0,"Radio, TV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Taxe déchets",null,null,null,null,{"$f":"'Budget effectif détaillé'!G22","v":0},0,"Taxe déchets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Taxe pompiers + militaire",null,null,null,null,{"$f":"'Budget effectif détaillé'!G36+'Budget effectif détaillé'!G37","v":0},0,"Taxe pompiers + militaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Autres assurances (ménage + caution)",null,null,null,null,{"$f":"'Budget effectif détaillé'!G42","v":0},0,"Autres assurances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Impôt fédéral direct",null,null,null,null,{"$f":"'Budget effectif détaillé'!G35","v":0},0,"Impôt fédéral direct",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Assurances + plaques auto",null,null,null,null,{"$f":"'Budget effectif détaillé'!G77","v":0},0,"Assurances + plaques auto",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Réparations, services, pneus",null,null,null,null,{"$f":"'Budget effectif détaillé'!G80","v":0},0,"Réparations, services, pneus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cadeaux",null,null,null,null,{"$f":"'Budget effectif détaillé'!G64","v":0},0,"Cadeaux",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Vacances",null,null,null,null,{"$f":"'Budget effectif détaillé'!G70","v":0},0,"Vacances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Formation",null,null,null,null,{"$f":"'Budget effectif détaillé'!G73+'Budget effectif détaillé'!G74","v":0},0,"Formation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Revues, abonnements, cotisations",null,null,null,null,{"$f":"'Budget effectif détaillé'!G65","v":0},0,"Revues, abonn., cotisations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Divers, imprévus",null,null,null,null,{"$f":"'Budget effectif détaillé'!G91","v":0},0,"Divers, imprévus",null,null,null,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,"Total",null,{"$f":"SUM(J29:J48)","v":0},null,{"$f":"SUM(L29:L48)","v":0},null,{"$f":"SUM(N29:N48)","v":0},null,{"$f":"SUM(P29:P48)","v":0},null,{"$f":"SUM(R29:R48)","v":0},null,{"$f":"SUM(T29:T48)","v":0},null,{"$f":"SUM(V29:V48)","v":0},null,{"$f":"SUM(X29:X48)","v":0},null,{"$f":"SUM(Z29:Z48)","v":0},null,{"$f":"SUM(AB29:AB48)","v":0},null,{"$f":"SUM(AD29:AD48)","v":0},null,{"$f":"SUM(AF29:AF48)","v":0}]
[]
["Dépenses courantes, budget =",null,null,{"$f":"SUM(G52:G61)","v":0},null,null,null,null,"Totaux mensuels des dépenses courantes effectuées"]
["Nourriture",null,null,null,{"$f":"'Budget effectif détaillé'!C48","v":0},null,{"$f":"E52","v":0},"Nourriture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G52*12-I52-K52-M52-O52-Q52-S52-U52-W52-Y52-AA52-AC52-AE52","v":0}]
["Produits ménagers, sacs ordures taxés",null,null,null,{"$f":"'Budget effectif détaillé'!C49","v":0},null,{"$f":"E53","v":0},"Prod. ménagers, sacs taxés",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Repas à l'extérieur",null,null,null,{"$f":"'Budget effectif détaillé'!C50","v":0},null,0,"Repas à l'extérieur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transports publics",null,null,null,{"$f":"'Budget effectif détaillé'!C81","v":0},null,0,"Transports publics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Essence",null,null,null,{"$f":"'Budget effectif détaillé'!C79","v":0},null,0,"Essence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Loisirs, sorties",null,null,null,{"$f":"'Budget effectif détaillé'!C62","v":0},null,0,"Loisirs, sorties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Invitations",null,null,null,{"$f":"'Budget effectif détaillé'!C66","v":0},null,0,"Invitations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Argent de poche",null,null,null,{"$f":"'Budget effectif détaillé'!C67","v":0},null,0,"Argent de poche",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cigarettes",null,null,null,{"$f":"'Budget effectif détaillé'!C68","v":0},null,0,"Cigarettes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Animaux",null,null,null,{"$f":"'Budget effectif détaillé'!C57","v":0},null,0,"Animaux",null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,0]
["Dettes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cartes de crédit",null,null,null,{"$f":"'Budget effectif détaillé'!C96","v":0},null,0,"Cartes de crédit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Paiements acomptes ",null,null,null,{"$f":"'Budget effectif détaillé'!C97","v":0},null,0,"Paiements acomptes ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Equipements (électroménager, Hifi, mobilier)",null,null,null,{"$f":"'Budget effectif détaillé'!C58","v":0},null,0,"Equipement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Arrangements factures en retard",null,null,null,{"$f":"'Budget effectif détaillé'!C98","v":0},null,0,"Arrange. factures en retard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Amortissement hypothécaire",null,null,null,{"$f":"'Budget effectif détaillé'!C99","v":0},null,0,"Amortissement hypothécaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Remboursement crédits",null,null,null,{"$f":"'Budget effectif détaillé'!C100","v":0},null,0,"Remboursement crédits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Société de recouvrement",null,null,null,{"$f":"'Budget effectif détaillé'!C101","v":0},null,0,"Société de recouvrement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cession de salaire",null,null,null,{"$f":"'Budget effectif détaillé'!C102","v":0},null,0,"Cession de salaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Découverts bancaires",null,null,null,{"$f":"'Budget effectif détaillé'!C103","v":0},null,0,"Découverts bancaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Office des poursuites",null,null,null,{"$f":"'Budget effectif détaillé'!C104","v":0},null,0,"Office des poursuites",null,null,null,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,"Total",{"$f":"SUM(I52:I73)","v":0},null,{"$f":"SUM(K52:K73)","v":0},null,{"$f":"SUM(M52:M73)","v":0},null,{"$f":"SUM(O52:O73)","v":0},null,{"$f":"SUM(Q52:Q73)","v":0},null,{"$f":"SUM(S52:S73)","v":0},null,{"$f":"SUM(U52:U73)","v":0},null,{"$f":"SUM(W52:W73)","v":0},null,{"$f":"SUM(Y52:Y73)","v":0},null,{"$f":"SUM(AA52:AA73)","v":0},null,{"$f":"SUM(AC52:AC73)","v":0},null,{"$f":"SUM(AE52:AE73)","v":0}]
["Total dépenses",null,null,null,null,null,{"$f":"SUM(G19:G61)","v":0}]
["Alimentation du compte destiné aux factures périodiques"]
["13ème salaire",null,null,null,null,{"$f":"F14","v":0},{"$f":"F77","v":0}]
["Acomptes mensuels",null,null,null,{"$f":"(D28-F14)/12","v":0},null,{"$f":"E78*12","v":0}]
[]
["Total ",null,null,null,null,null,{"$f":"SUM(G77:G78)","v":0}]
[]
["Disponible",null,null,null,null,null,{"$f":"G14-G75","v":0}]

{"sheet":"Sous-budget santé","index":9,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,2,1,6],[1,11,1,13],[2,2,2,3],[2,4,2,6],[2,11,2,13],[3,11,3,13],[3,14,4,14],[4,2,4,4],[4,11,4,13],[5,3,5,4],[5,11,5,13],[6,3,6,4],[6,11,6,13],[7,3,7,4],[7,11,7,13],[8,3,8,4],[8,11,8,13],[9,3,9,4],[9,11,9,13],[10,3,10,4],[10,11,10,13],[11,3,11,4],[11,11,11,13],[12,3,12,4],[12,11,12,13],[13,3,13,4],[13,11,13,13],[14,3,14,4],[14,11,14,13],[15,3,15,4],[15,11,15,13],[16,3,16,4],[16,11,16,13],[17,3,17,4],[17,11,17,13],[18,3,18,4],[18,11,18,13],[23,12,23,13],[24,12,24,13],[19,3,19,6],[19,11,19,13],[21,12,21,13],[22,12,22,13]]}
[]
[null,null,"Sous-budget santé",null,null,null,null,"Frs / mois","Fréquence / an","Est calculé","Est calculé","Date"]
[null,null,null,null,null,null,null,null,null,"Montant / an","Montant / mois"]
[]
[null,null,"Dépenses",null,null,null,null,null,null,null,null,"Commentaires"]
[null,null,null,"Assurance maladie de base époux",null,null,null,null,12,{"$f":"IF(H6>0,ROUND(H6*I6,0),\" \")","v":" "},{"$f":"IF(H6>0,ROUND(H6*I6/12,1),\" \")","v":" "}]
[null,null,null,"Assurance maladie complémentaire époux",null,null,null,null,12," "," "]
[null,null,null,"Assurance maladie de base épouse",null,null,null,null,12," "," "]
[null,null,null,"Assurance maladie complémentaire épouse",null,null,null,null,12," "," "]
[null,null,null,"Assurance maladie de base enfant 1",null,null,null,null,12," "," "]
[null,null,null,"Aussurance maladie complémentaire enfant 1",null,null,null,null,12," "," "]
[null,null,null,"Aussurance maladie de base enfant 2",null,null,null,null,12," "," "]
[null,null,null,"Assurance maladie complémentaire enfant 2",null,null,null,null,12," "," "]
[null,null,null,"Coûts supp. sans couverture par la caisse-maladie ",null,null,null,null,1," "," "]
[null,null,null,"Franchise demandée par la caisse-maladie",null,null,null,null,1," "," "]
[null,null,null,"Participation demandée par la caisse-maladie",null,null,null,null,1," "," "]
[null,null,null,"Traitement dentaire",null,null,null,null,1," "," "]
[null,null,null,"frais d'opticien",null,null,null,null,1," "," "]
[null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,"Total des dépenses",null,null,null,null,null,{"$f":"ROUNDUP(SUM(J6:J19),0)","v":0},{"$f":"SUM(K6:K19)","v":0}]

{"sheet":"Sous budget maison","index":10,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,2,1,6],[1,11,1,13],[2,2,2,3],[2,4,2,6],[2,11,2,13],[3,14,4,14],[4,2,4,4],[4,11,4,13],[6,3,6,4],[6,11,6,13],[5,3,5,4],[5,11,5,13],[3,3,3,4],[3,11,3,13],[13,11,13,13],[14,11,14,13],[14,3,14,4],[15,3,15,4],[15,11,15,13],[13,3,13,4],[9,11,9,13],[10,11,10,13],[11,11,11,13],[12,11,12,13],[12,3,12,4],[23,11,23,13],[16,11,16,13],[17,3,17,4],[17,11,17,13],[18,11,18,13],[19,3,19,4],[19,11,19,13],[16,3,16,4],[26,12,26,13],[27,12,27,13],[28,12,28,13],[8,3,8,4],[8,11,8,13],[9,3,9,4],[10,3,10,4],[11,3,11,4],[25,12,25,13],[20,11,20,13],[20,3,20,4],[21,3,21,4],[21,11,21,13],[22,3,22,4],[22,11,22,13],[23,3,23,6]]}
[]
[null,null,"Budget maison détaillé",null,null,null,null,"Montant annuel ","Fréquence durant l'année","calculé","Calculé","Date"]
[null,null,null,null,null,null,null,null,null,"Montant par an","Montant par mois"]
[]
[null,null,"Charges",null,null,null,null,null,null,null,null,"Commentaires, recommandations, buts"]
[null,null,null,"1. Hypothèque ",null,null,null,null,null,{"$f":"IF(H6>0,ROUND(H6*I6,0),\" \")","v":" "},{"$f":"IF(H6>0,ROUND(H6*I6/12,1),\" \")","v":" "}]
[null,null,null,"2. Hypothèque",null,null,null,null,null,{"$f":"IF(H7>0,ROUND(H7*I7,0),\" \")","v":" "},{"$f":"IF(H7>0,ROUND(H7*I7/12,1),\" \")","v":" "}]
[null,null,null,"Amortissement",null,null,null,null,null,{"$f":"IF(H8>0,ROUND(H8*I8,0),\" \")","v":" "}]
[null,null,null,"Crédit de rénovation",null,null,null,null,null,{"$f":"IF(H9>0,ROUND(H9*I9,0),\" \")","v":" "}," "]
[null,null,null,"Eau, eaux usées",null,null,null,null,null," "," "]
[null,null,null,"Assurance immobilière bris de verre, dégâts d'eau",null,null,null,null,null,{"$f":"IF(H11>0,ROUND(H11*I11,0),\" \")","v":" "}," "]
[null,null,null,"Assurance cantonale incendie",null,null,null,null,null," "," "]
[null,null,null,"Entretien courant  du jardin et du bâtiment",null,null,null,null,null," "," "]
[null,null,null,"Chauffage",null,null,null,null,null," ",{"$f":"IF(H14>0,ROUND(H14*I14/12,1),\" \")","v":" "}]
[null,null,null,"Ramonage, entretien chaudière",null,null,null,null,null," ",{"$f":"IF(H15>0,ROUND(H15*I15/12,1),\" \")","v":" "}]
[null,null,null,"Taxe immobilière et taxe cadastrale",null,null,null,null,null," ",{"$f":"IF(H16>0,ROUND(H16*I16/12,1),\" \")","v":" "}]
[null,null,null,"Fonds de rénovation et améliorations",null,null,null,null,null," ",{"$f":"IF(H17>0,ROUND(H17*I17/12,1),\" \")","v":" "}]
[null,null,null,"Primes d'assurance (décès, invalidité, perte de gain)",null,null,null,null,null," ",{"$f":"IF(H18>0,ROUND(H18*I18/12,1),\" \")","v":" "}]
[null,null,null,"Fiduciaire",null,null,null,null,null," "," "]
[null,null,null,"Divers",null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H23>0,ROUND(H23*I23,0),\" \")","v":" "}," "]
[null,null,null,"Total Charges",null,null,null,null,null,{"$f":"ROUNDUP(SUM(J6:J23),0)","v":0},{"$f":"SUM(K6:K23)","v":0}]

{"sheet":"Etat des dettes","index":11,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,7],[47,0,47,2],[2,2,2,3],[3,2,3,3]]}
["Etat des dettes"]
[]
[null,null,"Nom, prénom",null,null,"Domicile","Nbre pers.","Date"]
[null,null,null,null,null,null,null,{"$f":"'Budget aide sociale'!J4","v":0}]
[]
[]
["Retards  ( pas aux poursuites) ",null,null,{"$f":"SUM(D8:D15)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Emprunts et crédits (pas aux poursuites) ",null,null,{"$f":"SUM(D18:D25)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Poursuites",null,{"$f":"SUM(D28:D35)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ADB",null,null,{"$f":"SUM(D38:D45)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,null,{"$f":"+D37+D27+D17+D7","v":0}]

{"sheet":"Capacité remboursement","index":12,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,7],[3,0,3,1],[4,0,4,1]]}
["Capacité de remboursement"]
[]
[]
["Nom, prénom",null,null,"Domicile",null,"Nbre pers.",null,"Date"]
[{"$f":"'Budget aide sociale'!A5:B5","v":0},null,null,{"$f":"'Budget aide sociale'!D5","v":0},null,{"$f":"'Budget aide sociale'!F5","v":0},null,{"$f":"'Budget aide sociale'!H5","v":0}]
[]
[]
["Budget courant"]
[]
["Revenus",null,null,null,null,{"$f":"'Budget de gestion'!$G$14","v":0}]
["Ajout 13ème salaire",null,null,null,null,{"$f":"'Budget de gestion'!$G$80","v":0},null,{"$f":"SUM(F10:F11)","v":0}]
[]
["Dépenses",null,null,null,null,"./.",null,{"$f":"'Budget effectif détaillé'!G93","v":0}]
[]
["Solde mensuel disponible",null,null,"(ce montant doit être positif)",null,null,null,{"$f":"H11-H13","v":0}]
[]
[]
["Etat des dettes"]
[]
["Retards",null,null,null,null,{"$f":"'Etat des dettes'!$D$7","v":0}]
["Emprunts, crédits",null,null,null,null,{"$f":"'Etat des dettes'!D17","v":0}]
["Poursuites",null,null,null,null,{"$f":"'Etat des dettes'!D27","v":0}]
["Adb",null,null,null,null,{"$f":"'Etat des dettes'!D37","v":0}]
[]
[]
["Montant total des dettes",null,null,null,null,null,null,{"$f":"SUM(F20:F24)","v":0}]
[]
[]
["Calcul de la capacité de remboursement"]
[]
["Montant total des dettes",null,null,null,null,null,null,{"$f":"H26","v":0}]
[]
["Solde mensuel disponible",null,null,null,null,"÷",null,{"$f":"H15","v":0}]
[]
["Nombre de mensualités",null,null,"(le résultat ne doit pas dépasser 36 mois)",null,null,null,{"$f":"H31/H33","v":{"$error":"#DIV/0!"}}]
[]
[]
["Réduction à obtenir en cas de dépassement de délai (> 36 mois)"]
[]
["Montant total des dettes",null,null,null,null,null,null,{"$f":"H26","v":0}]
[]
["Solde disponible sur 36 mois",null,null,null,null,null,null,{"$f":"H15*36","v":0}]
[]
["Pourcentage de couverture",null,null,null,null,null,null,{"$f":"IF(H35>36,H42/H26,1)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Plan désendettement","index":13,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,7],[3,1,3,5],[5,8,5,9],[6,8,6,9],[7,8,7,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[27,8,27,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9]]}
["PLAN DE DESENDETTEMENT"]
["situation au :"]
[]
["Nom  :"]
[]
[null,"Montant","%","nouvel","somme ","demande ","Total proposé",null,"Suite"]
[null,"de la","du","acompte","mensuelle","du","pour",null,"donnée à"]
["Créanciers","dette","Total","mensuel","arrondie","créancier","36 mois",null,"l'assainissement"]
[]
[]
[null,null,{"$f":"SUM(100*B11/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C11)","v":{"$error":"#DIV/0!"}},null," ",{"$f":"SUM(E11*36)","v":0}]
[null,null,{"$f":"SUM(100*B12/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C12)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(E12*36)","v":0}]
[null,null,{"$f":"SUM(100*B13/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C13)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B14/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C14)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B15/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C15)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B16/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C16)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B17/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C17)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B18/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C18)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B19/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C19)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B20/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C20)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B21/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C21)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B22/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C22)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B23/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C23)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B24/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C24)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B25/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C25)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B26/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C26)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null,{"$f":"SUM(100*B27/B29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Capacité remboursement'!$H$42/100*C27)","v":{"$error":"#DIV/0!"}},null,null,0]
[null,null," "," ",null,null," "]
["Total     ",{"$f":"SUM(B11:B28)","v":0},{"$f":"SUM(C11:C28)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(E11:E28)","v":0},{"$f":"SUM(F11:F28)","v":0},{"$f":"SUM(G11:G28)","v":0},null,"Total de l'assainissement"]
[null,null,null,"Mensualité",null,null,{"$f":"SUM(G29*100/B29)","v":{"$error":"#DIV/0!"}},null,"Part payée en % "]
["Date de la dernière déclaration fiscale :",null,null,"pour",null,null,null,null,"du montant total"]
[null,null,null,"assainissement",null,null,null,null,"Remise accordée en % "]
[]
[null,null,null,"Mensualité pour assain. arrondie",null,null,{"$f":"SUM(E29)","v":0},null,"pour l'assainissement"]
[null,null,null,"supplément pour impôts courants"]
[null,null,null,"Coût du mandat"]
[null,null,null,"Total à verser",null,null,{"$f":"SUM(G34:G36)","v":0}]

{"sheet":"Feuil1","index":14,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,13],[2,2,2,12],[3,2,3,12],[4,2,4,12],[15,2,15,4]]}
["Détermination du minimum d'existence / Art. 93 LP."]
[]
["Débiteur"]
["Employeur"]
["Profession"]
[]
[]
[null,null,null,null,null,null,null,"Débiteur",null,null,"Conjoint",null,null,"Commun"]
[]
["Revenu net par mois",null,null,null,null,null,"fr.",2500,null,"fr.",8000,null,"fr.",{"$f":"SUM(H10:K10)","v":10500}]
["% des revenus",null,null,null,null,null," ",{"$f":"H10/N10","v":0.23809523809523808},null," ",{"$f":"K10/N10","v":0.76190476190476186},null," ",{"$f":"SUM(H11:K11)","v":1}]
[]
[]
["Minimum d'existence"]
[]
[1,"Débiteur-couple","(1200.-/1350.-/1700.-)",null,null,null,"fr.",850,null,"fr.",850,null,"fr.",{"$f":"SUM(H16:K18)","v":1700}]
[2,"Enfants",null,null,"Nbre",null,null,null,null,null,null,null,null," "]
[null,"00 - 10 ans","fr.",400,null,null,"fr.",{"$f":"SUM(E18*D18)","v":0},null,"fr.",null,null,"fr.",{"$f":"SUM(H18:K18)","v":0}]
[null,"10 ans et plus","fr.",600,null,null,"fr.",{"$f":"SUM(E19*D19)","v":0},null,"fr.",null,null,"fr.",{"$f":"SUM(H19:K19)","v":0}]
[3,"Loyer",null,null,null,null,"fr.",1000,null,"fr.",1000,null,"fr.",{"$f":"SUM(H20:K20)","v":2000}]
[4,"Chauffage",null,null,null,null,"fr.",null,null,"fr.",null,null,"fr.",0]
[5,"Caisse-maladie et accident",null,null,null,null,"fr.",300,null,"fr.",300,null,"fr.",600]
[6,"Surplus de nourriture indispensable",null,null,null,null,"fr.",null,null,"fr.",null,null,"fr.",{"$f":"SUM(H23:K23)","v":0}]
[7,"Repas au dehors",null,null,null,null,"fr."," ",null,"fr.",null,null,"fr.",0]
[8,"Usure rapide des vêtements",null,null,null,null,"fr.",null,null,"fr.",null,null,"fr.",0]
[9,"Déplacements au lieu de travail",null,null,null,null,"fr."," ",null,"fr.",null,null,"fr.",0]
[10,"Frais d'instruction des enfants",null,null,null,null,"fr.",null,null,"fr.",null,null,"fr.",0]
[11,"Paiement ou location d'objets  ",null,null,null,null,"fr.",null,null,"fr.",null,null,"fr.",0]
[null,"de stricte nécessité",null,null,null,null,"fr.",null,null,"fr.",null,null,"fr.",0]
[12,"Dépenses pour frais médicaux",null,null,null,null,"fr.",null,null,"fr.",null,null,"fr.",0]
[13,"Entretien et/ou pension alimentaire",null,null,null,null,"fr."," ",null,"fr.",null,null,"fr.",0]
[14,"Frais divers",null,null,null,null,"fr.",null,null,"fr."," ",null,"fr.",0]
[15,null,null,null,null,null,"fr."," ",null,"fr."," ",null,"fr.",0]
[16,null,null,null,null,null,"fr."," ",null,"fr.",null,null,"fr.",0]
[]
[]
[null,"Total",null,null,null,null,"fr.",{"$f":"SUM(H16:H34)","v":2150},null,"fr.",{"$f":"SUM(K16:K34)","v":2150},null,"fr.",{"$f":"SUM(H37:K37)","v":4300}]
[]
[]
[null,"Minimum vital proportionnel",null,null,null,null,"fr.",{"$f":"N37*H11","v":1023.8095238095237},null,"fr.",{"$f":"N37*K11","v":3276.1904761904761},null," "," "]
[]
[]
[null,"Quotité saisissable",null,null,null,null,"fr.",{"$f":"H10-H40","v":1476.1904761904761},null,"fr.",{"$f":"K10-K40","v":4723.8095238095239}]
[]
[]
[null,"Date :"]