{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Calcul de l'aide communale"],"not_rendered":{"images":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Calcul de l'aide communale","index":0,"n_rows":52,"n_cols":3,"rows_kept":52,"merged":[[0,0,0,2],[3,1,3,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Calculette de l'aide communale"]
[]
[]
[null,"Consigne : modifier chacune des trois cellules de couleur verte pour calculer l'aide dans votre situation"]
[]
[null,"Résultat = cellule de couleur jaune"]
[]
[null,"Montant de la facture totale du dentiste",500]
[]
[null,"Contribution de l'assureur-maladie",250]
[]
[null,"RDU (revenu déterminant unique) selon l'avis de taxation définitive de l'avant-dernière année fiscale ",{"v":39000,"d":"39,000"}]
[]
[null,"Taux de participation communale sur la moitié de la facture du dentiste : ",{"v":0.8,"d":"80%"}]
[]
[1,"Contribution communale (sous réserve de surindemnisation et du montant minimal)",200]
[]
[null,"Contribution communale tenant compte d'une surindemnisation et du montant minimal *",200]
[]
[null,"*  selon les articles 16 et 17 de l'ordonnance concernant le service dentaire, le taux d'aide s'applique"]
[null,"à la moitié des frais de soins et l'aide est réduite en cas de surindemnisation (addition de la contribution"]
[null,"de l'assurance-maladie et de l'aide communale). En outre il n'est pas versé d'aide lorsque le montant"]
[null,"de celle-ci est inférieur à 30 francs."]
[]
[null,"Revenu déterminant de à","Taux de l'aide"]
[null,"0 - 33'000",{"v":1,"d":"100%"}]
[null,"33'001 - 36'000",{"v":0.9,"d":"90%"}]
[null,"36'001 - 39'000",{"v":0.8,"d":"80%"}]
[null,"39'001 - 42'000",{"v":0.7,"d":"70%"}]
[null,"42'001 - 45'000",{"v":0.6,"d":"60%"}]
[null,"45'001 - 48'000",{"v":0.5,"d":"50%"}]
[null,"48'001 - 51'000",{"v":0.4,"d":"40%"}]
[null,"51'001 - 54'000",{"v":0.3,"d":"30%"}]
[null,"54'001 - 57'000",{"v":0.2,"d":"20%"}]
[null,"57'001 - 60'000",{"v":0.1,"d":"10%"}]
[null,"supérieur à 60'000",{"v":0,"d":"0%"}]
[]
[]
[null,"Revenu déterminant jusqu'à","Taux de\nl'aide"]
[null,{"v":-1000000,"d":"-1,000,000"},{"v":1,"d":"100%"}]
[null,0,{"v":1,"d":"100%"}]
[null,{"v":33000,"d":"33,000"},{"v":1,"d":"100%"}]
[null,{"v":33001,"d":"33,001"},{"v":0.9,"d":"90%"}]
[null,{"v":36001,"d":"36,001"},{"v":0.8,"d":"80%"}]
[null,{"v":39001,"d":"39,001"},{"v":0.7,"d":"70%"}]
[null,{"v":42001,"d":"42,001"},{"v":0.6,"d":"60%"}]
[null,{"v":45001,"d":"45,001"},{"v":0.5,"d":"50%"}]
[null,{"v":48001,"d":"48,001"},{"v":0.4,"d":"40%"}]
[null,{"v":51001,"d":"51,001"},{"v":0.3,"d":"30%"}]
[null,{"v":54001,"d":"54,001"},{"v":0.2,"d":"20%"}]
[null,{"v":57001,"d":"57,001"},{"v":0.1,"d":"10%"}]
[null,{"v":60001,"d":"60,001"},{"v":0,"d":"0%"}]