{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Explications","Affichage de travail","Informations","Factures","Décompte","Barème aide"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Explications","index":0,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[[35,0,36,0],[26,0,33,0],[19,0,24,0]]}
["Service dentaire scolaire"]
["Aide au financement des soins dentaires"]
["Explications pour l'utilisation de ce fichier"]
[]
[]
["Remarques générales"]
[]
["Ce fichier contient des macros permettant d'automatiser la création du décompte. Pour un fonctionnement optimal, veuillez vérifier que l'activation des macros"]
["est permise dans Excel en allant dans : menu \"Outils\", puis \"Macros\", \"Sécurité\", activer \"Niveau de sécurité moyen\"."]
[]
["Les deux premières lignes des onglets \"Informations\" et \"Factures\" sont des lignes d'exemple."]
[]
["Les onglets \"Informations\" et \"Factures\" contiennent 50 lignes. Pour créer de nouvelles lignes, sélectionner, avec le bouton droit de la souris, une des lignes du"]
["tableau (qui ne doit contenir aucune données), choisir \"Copier\"; puis cliquer à nouveau sur le bouton droit de la souris en étant positionner sur la dernière ligne"]
["du tableau et choisir \"Insérer les cellules copiées\"."]
[]
["Organisation du fichier"]
[]
["Onglet","Remarques"]
["Informations","Permet d'entrer, par ligne, les données concernant les parents et chaque enfant nécessitant des soins dentaires soumis à l'aide au financement."]
[null,"Le champ \"Année/Cas\" doit être unique pour chaque groupe \"Parents/enfant\". Ce numéro est à reproduire dans l'onglet \"Factures\"."]
[null,"Lors de l'entrée de la date de naissance, s'assurer que l'enfant est âgé de 4 ans à 16 ans révolus."]
[null,"Pour les cases de la rubrique \"Soins dentaires\", taper \"O\" (la lettre O) pour \"Oui\" dans la case corespondante et laisser vide les autres cases."]
[null,"Attention : ne saisir qu'une fois le groupe \"parents/tel enfant\", c'est-à-dire si une famille (Dupont) est composée de 2 enfants (Luc et Jean), saisir"]
[null," deux lignes en indiquant, sur la 1ère ligne \"Dupont/Luc\" (1er enfant des Dupont) et sur la seconde \"Dupont/Jean\" (2e enfant des Dupont)."]
[]
["Factures","La colonne \"Nom/prénom parents\" est remplie automatiquement dès qu'un numéro de cas est entré en allant récupérer les données dans l'onglet"]
[null,"\"Informations\". Il permet de contrôler que le numéro de cas est le bon."]
[null,"Dans les case \"Assurance accident / RC\", et \"Couverture maladie complémentaire\", taper \"O\" pour \"Oui\" ou \"N\" pour \"Non\"."]
[null,"Concernant les champs \"Couverture en %\" et \"Couverture Monant\", n'en saisir qu'un seul (si vous en saisissez deux, le second sera ignoré)."]
[null,"Pour la rubrique \"Situation des parents\", si le champ \"RDU\" est saisi, ne rien saisir dans les champs \"Enfants\", \"Revenu net\" et \"Fortune nette\"."]
[null,"Si le champ \"RDU\" est vide, saisir les données des zones \"Enfants\", \"Revenu imposable\" et \"Fortune nette\" même si zéro."]
[null,"Si le contribuable est taxé à zéro, indiquer dans le champ \"RDU\" : 0.001."]
[null,"Les champs de la rubrique \"Calcul de l'aide\" (couleur verte) ne doivent pas être touchés car ils contiennent des formules."]
[]
["Décompte","Cliquer sur le bouton \"Effacer\" pour supprimer les données variables du décompte."]
[null,"Ce décompte est automatiquement rempli en cliquant sur le bouton \"Décompte\" de l'onglet \"Factures\" (dans la cellule E1)."]
[]
["Edition des décomptes"]
[]
["Pour éditer un décompte concernant une facture, il faut :"]
["1)  ","rechercher le numéro du cas dans l'onglet \"Informations\","]
["2)  ","sélectionner l'onglet \"Facture\","]
["3)  ","se positionner sur la ligne correspondant à la facture concernée par le calcul de l'aide."]
["4)  ","cliquer sur le bouton \"Décompte\" situé dans la cellule E1"]

{"sheet":"Affichage de travail","index":1,"n_rows":54,"n_cols":2,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Service dentaire scolaire"]
["Modes d'affichage des onglets \"Informations\" et \"Factures\""]
["Conseils pour l'utilisation des onglets \"Informations\" et \"Factures\""]
[]
["Dans chacun des deux onglets \"Informations\" et \"Factures\", il est nécessaire d'entrer des données relatives à chaque cas d'aide au financement des soins dentaires"]
[]
["Excel offre deux façons d'entrer les données dans ces deux onglets:"]
[]
[1,"Dans l'affichage normal, chaque ligne correspondant à un enregistrement"]
[]
[2,"Dans l'affichage \"Formulaire\", sous forme d'une colonne par enregistrement"]
[null,"Pour cette seconde solution, il faut utiliser la commande \"Formulaires\" du menu \"Données\""]
[]
[]
[]
[]
[]
[]
[]
["Pour ce faire, il faut:"]
[]
[1,"Se positionner sur une cellule de"]
[null,"l'enregistrement à compléter ou à modifier"]
[]
[]
[]
[2,"Ouvrir le menu \"Données\" en haut de l'écran et "]
[null,"et cliquer sur la commande \"Formulaire…\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,"Remplir les cases qui se présentent dans une colonne"]
[]
[]
[4,"Pour ajouter une ligne dans le tableau (nouveau cas)"]
[null,"il suffit de cliquer sur le bouton \"Nouvelle\""]
[]
[]
[6,"Pour supprimer un enregistrement (ligne)"]
[null,"il suffit de cliquer sur le bouton \"Supprimer\""]
[]
[]
[6,"Pour passer d'un enregistrement à l'autre"]
[null,"il suffit de cliquer sur le bouton \"Précédente\" ou \"Suivante\""]
[]
[]
["Attention : pour les zones en %, saisir 0.4 pour 40%."]

{"sheet":"Informations","index":2,"n_rows":54,"n_cols":19,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"Parent(s) concerné(s)",null,null,null,null,null,null,"Enfant soigné",null,null,"Soins dentaires",null,null,null,null,"Calendrier"]
[]
["Année / \nNo cas","Nom","Prénom","Adresse","NPA","Localité","Téléphone","Courriel","Nom","Prénom","Naissance","Dentiste","Traitement\northodont.","Soins ordin.\ncoûteux\n(dès Fr. 1'000.-)","Accord dentiste\nconfiance","Soins ordin.\n(< Fr. 1'000.-)","Début soins","Fin soins\n(prévue)","Fin soins\n(effective)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Nombre de cas : \" & COUNTA(A4:A53)","v":"Nombre de cas : 0"}]

{"sheet":"Factures","index":3,"n_rows":65,"n_cols":21,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,11,2,13],[2,4,2,7],[2,2,2,3],[2,8,2,9]]}
[null,null,"Facture de soins",null,null,null,null,null,null,null,null,"Situation des parents",null,null,"Calcul de l'aide communale"]
[]
[null,null,"Facture",null,"Couverture assurance",null,null,null,"Couverture financière",null,"Taxation","Selon avis antérieur"]
["Année / \nNo cas","Nom/prénom\nparents","Date\nfacture","Montant\nfacture","Assurance\naccid. / RC","Couverture\nmal. compl.","Nom assurance","Adresse assurance","En %","Montant","Revenu déterm. unique (RDU)","Enfants","Revenu imposable","Fortune nette","Revenu déterminant","Taux de l'aide","Montant aide maximale","Participation tiers","Total aide et tiers","Surindemni-sation","Aide accordée"]
[null,{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A5,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A5<>\"\",IF(K5<>\"\",K5,M5+IF(N5=\"\",\"\",INT(N5/15))+IF(L5<3,IF(OR(L5=0,L5=\"\"),0,-4000*L5),-8000+((L5-2)*-6000))),0)","v":0},{"$f":"IF(A5<>\"\",VLOOKUP(O5,'Barème aide'!$A$5:$B$17,2),0)","v":0},{"$f":"IF(A5<>\"\",INT(((D5*P5/2)*20)+0.5)/20,0)","v":0},{"$f":"IF(SUM(I5:J5)=0,0,IF(OR(I5>0,I5<>\"\"),INT(((I5*D5)*20)+0.5)/20,J5))","v":0},{"$f":"SUM(Q5,R5)","v":0},{"$f":"IF(SUM(S5-D5)>0,SUM(S5-D5),0)","v":0},{"$f":"IF(Q5=\"\",0,INT(((Q5-T5)*20)+0.5)/20)","v":0}]
[null,{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A6,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A6<>\"\",VLOOKUP(O6,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A7,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A7<>\"\",VLOOKUP(O7,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A8,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A8<>\"\",VLOOKUP(O8,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A9,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A9<>\"\",VLOOKUP(O9,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A10,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A10<>\"\",VLOOKUP(O10,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A11,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A11<>\"\",VLOOKUP(O11,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A12,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A12<>\"\",VLOOKUP(O12,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A13,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A13<>\"\",VLOOKUP(O13,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A14,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A14<>\"\",VLOOKUP(O14,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A15,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A15<>\"\",VLOOKUP(O15,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A16,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A16<>\"\",VLOOKUP(O16,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A17,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A17<>\"\",VLOOKUP(O17,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A18,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A18<>\"\",VLOOKUP(O18,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A19,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A19<>\"\",VLOOKUP(O19,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A20,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A20<>\"\",VLOOKUP(O20,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A21,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A21<>\"\",VLOOKUP(O21,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A22,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A22<>\"\",VLOOKUP(O22,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A23,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A23<>\"\",VLOOKUP(O23,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A24,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A24<>\"\",VLOOKUP(O24,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A25,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A25<>\"\",VLOOKUP(O25,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A26,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A26<>\"\",VLOOKUP(O26,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A27,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A27<>\"\",VLOOKUP(O27,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A28,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A28<>\"\",VLOOKUP(O28,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A29,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A29<>\"\",VLOOKUP(O29,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A30,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A30<>\"\",VLOOKUP(O30,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A31,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A31<>\"\",VLOOKUP(O31,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A32,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A32<>\"\",VLOOKUP(O32,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A33,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A33<>\"\",VLOOKUP(O33,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A34,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A34<>\"\",VLOOKUP(O34,'Barème aide'!$A$5:$B$17,2),0)","v":0},{"$f":"IF(A34<>\"\",INT(((D34*P34/2)*20)+0.5)/20,0)","v":0},{"$f":"IF(SUM(I34:J34)=0,0,IF(OR(I34>0,I34<>\"\"),INT(((I34*D34)*20)+0.5)/20,J34))","v":0},0,{"$f":"IF(SUM(S34-D34)>0,SUM(S34-D34),0)","v":0},0]
[null,{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A35,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A35<>\"\",VLOOKUP(O35,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A36,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A36<>\"\",VLOOKUP(O36,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A37,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A37<>\"\",VLOOKUP(O37,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A38,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A38<>\"\",VLOOKUP(O38,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A39,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A39<>\"\",VLOOKUP(O39,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A40,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A40<>\"\",VLOOKUP(O40,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A41,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A41<>\"\",VLOOKUP(O41,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A42,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A42<>\"\",VLOOKUP(O42,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A43,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A43<>\"\",VLOOKUP(O43,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A44,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A44<>\"\",VLOOKUP(O44,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A45,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A45<>\"\",VLOOKUP(O45,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A46=\"\",\"\",VLOOKUP(A46,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A46,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A46<>\"\",VLOOKUP(O46,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A47=\"\",\"\",VLOOKUP(A47,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A47,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A47<>\"\",VLOOKUP(O47,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,{"$f":"IF(Q47=\"\",0,INT(((Q47-T47)*20)+0.5)/20)","v":0}]
[null,{"$f":"IF(A48=\"\",\"\",VLOOKUP(A48,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A48,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A48<>\"\",VLOOKUP(O48,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A49=\"\",\"\",VLOOKUP(A49,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A49,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A49<>\"\",IF(K49<>\"\",K49,M49+IF(N49=\"\",\"\",INT(N49/15))+IF(L49<3,IF(OR(L49=0,L49=\"\"),0,-4000*L49),-8000+((L49-2)*-6000))),0)","v":0},{"$f":"IF(A49<>\"\",VLOOKUP(O49,'Barème aide'!$A$5:$B$17,2),0)","v":0},{"$f":"IF(A49<>\"\",INT(((D49*P49/2)*20)+0.5)/20,0)","v":0},{"$f":"IF(SUM(I49:J49)=0,0,IF(OR(I49>0,I49<>\"\"),INT(((I49*D49)*20)+0.5)/20,J49))","v":0},{"$f":"SUM(Q49,R49)","v":0},{"$f":"IF(SUM(S49-D49)>0,SUM(S49-D49),0)","v":0},{"$f":"IF(Q49=\"\",0,INT(((Q49-T49)*20)+0.5)/20)","v":0}]
[null,{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A50,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A50<>\"\",IF(K50<>\"\",K50,M50+IF(N50=\"\",\"\",INT(N50/15))+IF(L50<3,IF(OR(L50=0,L50=\"\"),0,-4000*L50),-8000+((L50-2)*-6000))),0)","v":0},{"$f":"IF(A50<>\"\",VLOOKUP(O50,'Barème aide'!$A$5:$B$17,2),0)","v":0},{"$f":"IF(A50<>\"\",INT(((D50*P50/2)*20)+0.5)/20,0)","v":0},{"$f":"IF(SUM(I50:J50)=0,0,IF(OR(I50>0,I50<>\"\"),INT(((I50*D50)*20)+0.5)/20,J50))","v":0},{"$f":"SUM(Q50,R50)","v":0},{"$f":"IF(SUM(S50-D50)>0,SUM(S50-D50),0)","v":0},{"$f":"IF(Q50=\"\",0,INT(((Q50-T50)*20)+0.5)/20)","v":0}]
[null,{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A51,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A51<>\"\",VLOOKUP(O51,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A52=\"\",\"\",VLOOKUP(A52,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A52,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A52<>\"\",VLOOKUP(O52,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A53=\"\",\"\",VLOOKUP(A53,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A53,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A53<>\"\",VLOOKUP(O53,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A54=\"\",\"\",VLOOKUP(A54,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A54,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A54<>\"\",VLOOKUP(O54,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A55=\"\",\"\",VLOOKUP(A55,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A55,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A55<>\"\",VLOOKUP(O55,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A56=\"\",\"\",VLOOKUP(A56,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A56,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A56<>\"\",VLOOKUP(O56,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A57=\"\",\"\",VLOOKUP(A57,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A57,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A57<>\"\",VLOOKUP(O57,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A58=\"\",\"\",VLOOKUP(A58,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A58,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A58<>\"\",VLOOKUP(O58,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A59=\"\",\"\",VLOOKUP(A59,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A59,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A59<>\"\",VLOOKUP(O59,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A60=\"\",\"\",VLOOKUP(A60,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A60,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A60<>\"\",VLOOKUP(O60,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A61=\"\",\"\",VLOOKUP(A61,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A61,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A61<>\"\",VLOOKUP(O61,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A62=\"\",\"\",VLOOKUP(A62,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A62,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A62<>\"\",VLOOKUP(O62,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(A63=\"\",\"\",VLOOKUP(A63,Informations!$A$4:$B$52,2,FALSE)& \" \" & VLOOKUP(A63,Informations!$A$4:$C$52,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(A63<>\"\",VLOOKUP(O63,'Barème aide'!$A$5:$B$17,2),0)","v":0},0,0,0,0,0]
[]
[{"$f":"\"Nombre de factures : \" & COUNTA(A5:A64)","v":"Nombre de factures : 0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total de l'aide accordée",{"$f":"SUM(IF($U$5:$U$63>=30,$U$5:$U$63,0))","v":0}]

{"sheet":"Décompte","index":4,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Service dentaire scolaire",null,null,null,null,null,{"$f":"TODAY()","v":"2019-02-04"}]
["Aide au financement des soins dentaires"]
[]
["Parent(s) concerné(s)"]
[]
[]
[]
["Enfant soigné"]
[]
["Soins dentaires"]
[]
[]
["Calendrier","Date début des soins:",null,null,"Date prévue pour fin des soins:"]
[null,"(1ère visite chez le dentiste soignant)",null,null,"Date effective de fin des soins:"]
[]
[]
["Facture de soins","Nom du dentiste traitant"]
[]
[null,"Date de la facture",null,null,"(joindre une copie de la facture)"]
[]
[null,"Montant de la facture"]
[]
[]
[]
[]
[]
[null,"Nom de l'assurance"]
[null,"Adresse de l'assurance"]
[]
[null,"Taux de couverture",null,null,"(joindre une copie de la décision)"]
[]
["Situation des parents"]
[]
[]
[]
[]
["Le/la soussigné-e certifie que les informations ci-dessus"]
["sont correctes et complètes"]
[]
["Calcul de l'aide communale"]
[]
[null,"Revenu déterminant",null,null,"Taux de l'aide maximum"]
[]
[null,"Montant de la facture",null,null,"Montant aide maximale"]
[]
[null,null,null,null,"Couverture par un tiers (assur.)"]
[]
[null,null,null,null,"Total aide maximale + tiers"]
[]
[null,null,null,null,"Surindemnisation"]
[]
[]
[null,{"$f":"IF(G53<0,\"   Montant en faveur de la Commune (en CHF)\",\"   Montant de l'aide accordée (en CHF)\")","v":"   Montant de l'aide accordée (en CHF)"}]
[]
[null,null,null,null,null,null,"Il n'est pas versé d'aide au financement des soins, lorsque le montant de l'aide pour un traitement"]
[null,null,null,null,null,null,"complet est inférieur à Fr. 30.- (art. 17 de l'Ordonnance concernant le service dentaire scolaire)"]
[]
["Annexes :"]

{"sheet":"Barème aide","index":5,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Barème pour l'attribution"]
["d'une aide au financement"]
[]
["Revenu déterminant\njusqu'à","Taux de\nl'aide"]
[-1000000,1]
[0,1]
[33000,1]
[33001,0.9]
[36001,0.8]
[39001,0.7]
[42001,0.6]
[45001,0.5]
[48001,0.4]
[51001,0.3]
[54001,0.2]
[57001,0.1]
[60001,0]