{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Feuille 1","Exemple AI + PC","Exemple Aide sociale"],"not_rendered":{"external_links":1,"defined_names":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Feuille 1","index":0,"n_rows":45,"n_cols":4,"rows_kept":45,"merged":[[0,0,0,3],[6,1,6,2],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,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],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,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],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,3],[45,0,48,3]],"flags":["formulas_cached_only"]}
["BUDGET ANNUEL, MENSUEL"]
[]
["ANNEE :",null,"Etabli : "]
[]
["Nom :   "]
["Prénom:"]
["Adresse :"]
[]
["REVENUS",null,"Annuel","Mensuel"]
["Salaire",null,{"v":0,"d":"0.00"}]
[null,null,{"v":0,"d":"0.00"}]
["AI / AVS",null,{"v":0,"d":"0.00"}]
["SUVA",null,{"v":0,"d":"0.00"}]
["LPP",null,{"v":0,"d":"0.00"}]
[null,null,{"v":0,"d":"0.00"}]
["PC",null,{"v":0,"d":"0.00"}]
[null,null,{"v":0,"d":"0.00"}]
["ALFA",null,{"v":0,"d":"0.00"}]
[null,null,{"v":0,"d":"0.00"}]
[null,null,{"v":0,"d":"0.00"}]
["TOTAL REVENUS",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["DEPENSES"]
["Entretien, argent de poche",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Vêtements",null,{"v":0,"d":"0.00"}]
["Loyer",null,{"v":0,"d":"0.00"}]
["Institution",null,{"v":0,"d":"0.00"}]
["Electricité",null,{"v":0,"d":"0.00"}]
["Téléphone ",null,{"v":0,"d":"0.00"}]
["Radio/TV (Billag)",null,{"v":0,"d":"0.00"}]
["ACTV",null,{"v":0,"d":"0.00"}]
["Caisse-maladie : Lamal (après déduction)",null,{"v":0,"d":"0.00"}]
["Caisse-maladie : LCA",null,{"v":0,"d":"0.00"}]
["Caisse-maladie : participation",null,{"v":0,"d":"0.00"}]
["Assurance ménage + RC",null,{"v":0,"d":"0.00"}]
["Cotisations AVS",null,{"v":0,"d":"0.00"}]
["Impôts ",null,{"v":0,"d":"0.00"}]
["IFD",null,{"v":0,"d":"0.00"}]
["Transports",null,{"v":0,"d":"0.00"}]
[null,null,{"v":0,"d":"0.00"}]
["Divers",null,{"v":0,"d":"0.00"}]
[null,null,{"v":0,"d":"0.00"}]
[null,null,{"v":0,"d":"0.00"}]
["TOTAL DEPENSES",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["DISPONIBLE",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Remarques"]

{"sheet":"Exemple AI + PC","index":1,"n_rows":42,"n_cols":4,"rows_kept":42,"flags":["formulas_cached_only"]}
["SSR - DELEMONT BUDGET"]
[]
["ANNEE 2013","dès 01.10.2013"]
[]
[]
["Nom et prénom : ","Tél. "]
["Adresse :","AVS No "]
["Nombre de personne : 1","Né le "]
[]
[]
[null,"budget annuel","budget mensuel"]
[]
["REVENUS"]
[]
["Rente AI (dès 01.01.2013) ",{"v":0,"d":"0.00"},{"v":1909,"d":"1,909.00"}]
["PC  (décision du 20.9.13)",{"v":0,"d":"0.00"},{"v":481,"d":"481.00"},"(dès 1.5.13)"]
[]
["TOTAL REVENU",{"v":0,"d":"0.00"},{"v":2390,"d":"2,390.00"}]
["DEPENSES"]
["Entretien hebdomadaire (200.00)",{"v":10400,"d":"10,400.00"},{"v":866.7,"d":"866.70"}]
["Loyer (charges comprises)",{"v":9000,"d":"9,000.00"},{"v":750,"d":"750.00"}]
["Electricité (FMB)",{"v":600,"d":"600.00"},{"v":50,"d":"50.00"}]
["Téléphone fixe et portable (Swisscom et Sunrise)",{"v":600,"d":"600.00"},{"v":50,"d":"50.00"},"25,25 mens. Swisscom"]
["Radio /TV : Billag (p.m. 450.40)  - exempté",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"exempté"]
["EBL ",null,23.85]
["Mutuel Ass(base : CHF 370,00) subside total",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"risque acc.inclus"]
["Caisse-maladie : participations",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["RC et assurance ménage La Mobilière ","p.m. 266,80",22.25]
["Cotisations AVS (p.m. 487,00 par année)",null,{"v":40.6,"d":"40.60"}]
["Impôts (cant & comm) - s/taxation 2012 : 651.50",null,{"v":55,"d":"55.00"}]
["IFD s/taxation 2012 : Fr. 56,95",null,{"v":5,"d":"5.00"}]
["Abonnement général CFF (2'200.00)",{"v":2200.2,"d":"2,200.20"},183.35,"éch. 3.2.2013"]
["Entretien AF (autorisation env. CHF 450.00 trim.)",{"v":1800,"d":"1,800.00"},{"v":150,"d":"150.00"}]
["Commune de  (taxe pour ordures)",{"v":75,"d":"75.00"},6.25]
["Rémunération tuteur (2'000.00 sur 24 mois)",{"v":1000.1999999999999,"d":"1,000.20"},83.35]
["TOTAL DEPENSES",{"v":25675.4,"d":"25,675.40"},{"v":2286.35,"d":"2,286.35"}]
["DISPONIBLE",{"v":-25675.4,"d":"-25,675.40"},{"v":103.65000000000009,"d":"103.65"}]
[]
["Remarques :"]
[]
[]
["Delémont, le 1er octobre 2013"]

{"sheet":"Exemple Aide sociale","index":2,"n_rows":48,"n_cols":4,"rows_kept":48,"flags":["formulas_cached_only"]}
["SSR - DELEMONT BUDGET"]
[]
["ANNEE 2013","dès 01.10.2013"]
[]
[]
["Nom et prénom : "]
["Adresse : ","Tél. "]
["Nombre de personne : 1"]
[]
[]
[null,null,"budget mensuel"]
[]
["REVENUS"]
[]
["Rente AI ",null,{"v":0,"d":"0.00"}]
["Rente PC",null,{"v":0,"d":"0.00"}]
["Salaire ","impôt source déduit (10%)",{"v":0,"d":"0.00"}]
["Caisse de chômage UNIA",null,{"v":0,"d":"0.00"}]
["Aide sociale ",{"v":986,"d":"986.00"},{"v":986,"d":"986.00"}]
["Aide sociale (logement)",{"v":720,"d":"720.00"},{"v":720,"d":"720.00"}]
["Aide sociale (supplément d'intégration)",{"v":250,"d":"250.00"},{"v":0,"d":"0.00"}]
["Aide sociale (minimal d'intégration)","p.m. 100.00",{"v":0,"d":"0.00"}]
["TOTAL REVENU",{"v":1956,"d":"1,956.00"},{"v":1706,"d":"1,706.00"}]
["DEPENSES"]
["Entretien + argent de poche + tél. ",null,{"v":740,"d":"740.00"}]
["Loyer (charges comprises)",null,{"v":720,"d":"720.00"}]
["Loyer (place de parc)",null,{"v":10,"d":"10.00"}]
["Electricité et eau (SI Delémont) - décompte charges","p.m. 60.00",{"v":60,"d":"60.00"}]
["Radio /TV : Billag (CHF 115,50 trim.) ","p.m. 462.40",38.55]
["EBL (dès 01.01.2012)  71,55 trim.","p.m. 286,20",23.85]
["Mutuel No (subside total)-couv.acc.incluse","p.m. 381,05",{"v":0,"d":"0.00"}]
["Caisse-maladie : participations","p.m. 60.00",{"v":0,"d":"0.00"},"AIS"]
["Caisse-maladie : complémentaires",null,{"v":0,"d":"0.00"}]
["Ass.-mén. + RC Bâloise (CHF 295.20 p.a. soit 24,55 mens.) ","p.m.",{"v":0,"d":"0.00"},"AIS"]
["Cotisations AVS (p.m. 492.00 par année) - pm 41,00 mens.","p.m.",{"v":0,"d":"0.00"},"AIS"]
["Impôts cantonaux (y. c. ordures mén) année précédente ",null,{"v":0,"d":"0.00"}]
["Office des poursuites ",null,{"v":100,"d":"100.00"},"fin : 31.12.2013"]
["Renouvellement permis B (103.00 par année)",null,{"v":8.5,"d":"8.50"}]
["Taxe des ordures ","p.m. 72.00",{"v":6,"d":"6.00"}]
[]
["TOTAL DEPENSES",null,{"v":1706.8999999999999,"d":"1,706.90"}]
["DISPONIBLE",null,{"v":-0.8999999999998636,"d":"-0.90"}]
[]
["Remarques :"]
[]
[]
[]
["Delémont, le 7 octobre 2013"]