{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Lisez-moi","Service Extrascolaire","Service Accueil Adolescents","Service Périscolaire Mixte","Identification","Insee","Feuil1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":31,"comments":3,"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":"Lisez-moi","index":0,"n_rows":94,"n_cols":1,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
["Lisez-moi"]
[]
["Ce fichier va vous permettre de déclarer vos données d'activité actualisées 2018 pour votre ALSH"]
[]
["Ce fichier est conçu pour prendre en compte tous les types de services :"]
[]
[" - Périscolaire MIXTE (Hors TAP + TAP)"]
[" - Extrascolaire "]
[" - Accueil Adolescents"]
[]
["Il est fortement conseillé de sauvegarder ce fichier après chaque modification, avec le format suivant :"]
["nom de l'équipement/type déclaration/version.xls"]
[]
["1) Pour compléter votre déclaration actualisée 2018, vous devez en premier lieu choisir le service proposé par votre équipement"]
[]
[]
["2) Choisissez votre type de service entre :"]
[]
["● Mon service Périscolaire Mixte"]
["● Mon service Extrascolaire"]
["● Mon service Accueil Adolescents"]
[]
[]
["3) Chaque feuille de calcul est composée de 5 parties:"]
[]
["A) - Identification du partenaire"]
["B) - Lieux d'implantation du service"]
["C) - Déclaration des données d'activité"]
["D) - Zone \"Commentaires\""]
["E) - Validation de la déclaration de données avant transmission à la Caf"]
[]
[]
["A) - Identification du partenaire (lignes 4 à 12)"]
["Toutes les informations de cette partie sont à compléter par vos soins"]
[]
[" - Ligne 2 : Activité actualisée à fin  (à choisir avec la flèche dans la cellule H1 entre Mars - Juin - Septembre - Octobre - Novembre)"]
[" - Ligne 4 : Gestionnaire (votre nom de gestionnaire tel que connu par votre caf)"]
[" - Ligne 6 : Equipement (équipement qui propose le service - nom de l'équipement tel que connu par votre caf)"]
[" - Ligne 6 : Dossier n° (référence de votre dossier à la caf. Cette information est présente sur les courriers de la caf)"]
[" - Ligne 8 : Code postal de la commune de l'équipement (à sélectionner avec la flèche à droite dans la cellule C8)"]
[" - Ligne 10 : Commune de l'équipement (à sélectionner avec la flèche dans la cellule C10)"]
[" - Ligne 12 : Code Insee de la commune de l'équipement (incrémenté automatiquement)"]
[" - Ligne 12 : Taux de régime conventionné "]
[]
[]
["B) - Lieux d'implantation du service (lignes 16 à 51) et (lignes 118 à 153 pour \"Périscolaire mixte\")"]
[]
[" - Lignes 18 à 47 : Enregistrement des lieux d'implantation (+ lignes 120 à 149 pour \"Périscolaire mixte\")"]
["* Définition d'un lieu d'implantation : voir infobulle ligne 16 (+ ligne 118 pour \"Périscolaire mixte\")"]
[]
["Précisez, sur les lignes 18 à 47, pour chacun des lieux répondant à la définition de l'infobulle : (+ lignes 120 à 149 pour \"Périscolaire mixte\")"]
[" - l'adresse du lieu d'implantation"]
[" - le code postal de la commune du lieu d'implantation (à sélectionner avec la flèche à droite dans la cellule)"]
[" - la commune du lieu d'implantation (à sélectionner avec la flèche à droite dans la cellule)"]
[" - le code Insee de cette commune (incrémenté automatiquement)"]
[]
["NB: pour le Service \"Accueil adolescents\", il faut préciser pour chacun des lieux, si l'activité proposée est : "]
[" - \"Conventionné Accueil Jeunes\" "]
[" - ou \"Déclaré ALSH\" (= tranche d'âge 12-17 ans déclarée \"Extrascolaire\" ou \"Périscolaire\" et qui fait l'objet d'un projet pédagogique spécifique)"]
["Si un même lieu d'implantation propose les 2 types d'activité, il faut créer 2 fois le lieu d'implantation."]
[]
[" - Ligne 51 : Total des lieux d'implantation (+ ligne 153 pour \"Périscolaire mixte\")"]
["Les cellules de cette ligne sont complétées automatiquement en fonction de l'information inscrite dans la cellule C12 (code Insee de "]
["commune de l'équipement et cellules H18 à H47 (codes Insee des communes d'implantation de tous les lieux d'implantation) + cellules H120 à H149"]
[]
[]
["C) - Déclaration des données d'activité (lignes 65 à 98) et (lignes 168 à 201 pour \"Périscolaire mixte\")"]
[]
[" - Ligne 65 : Déclaration par lieu d'implantation (+ ligne 168 pour \"Périscolaire mixte\")"]
["La cellule E65 (+ cellule E168 pour \"Périscolaire mixte\") est complétée automatiquement avec le nombre de lieux d'implantation pour lesquels "]
["il est attendu des données d'activité "]
[]
[" - Lignes 68 à 97 : Déclaration des données d'activité par lieu d'implantation (+ lignes 171 à 200 pour \"Périscolaire mixte\")"]
["Les cellules G à J de ce tableau sont à renseigner avec les données d'activité tous régimes confondus "]
[]
[" - Ligne 98 : les totaux sont générés automatiquement par l'utilitaire (+ ligne 201 pour \"Périscolaire mixte\")"]
[]
[]
["Des contrôles sont intégrés pour s'assurer :"]
[" - qu'il y a des données d'activité (ligne 103 et ligne 206 pour \"Périscolaire mixte\") pour tous les lieux d'implantation déclarés (lignes 18 à 47 et"]
[" lignes 120 à 149 pour \"Périscolaire mixte\")"]
[]
[]
["D) - Zone \"Commentaires\""]
[" - Lignes 108 à 118 (lignes 211 à 221 pour \"Périscolaire mixte\") "]
[]
[]
["E) - Validation de la déclaration de données avant transmission à la Caf"]
[]
["Avant de transmettre le formulaire à la caf, pensez à valider vos informations en complétant le tableau situé :"]
[]
[]
[" - ligne 122  pour l' \"Extrascolaire\" et l' \"Accueil Adolescents\""]
[" - ligne 225 pour le \"Périscolaire Mixte\""]

{"sheet":"Service Extrascolaire","index":1,"n_rows":134,"n_cols":10,"rows_kept":134,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,5,0,7],[65,6,65,7],[65,8,65,9],[124,4,125,4],[57,1,57,2],[133,4,134,6],[21,4,21,6],[22,0,22,2],[22,4,22,6],[23,0,23,2],[23,4,23,6],[19,4,19,6],[20,0,20,2],[20,4,20,6],[24,0,24,2],[19,0,19,2],[54,1,54,6],[55,1,55,6],[51,1,51,2],[52,1,52,2],[56,1,56,2],[25,0,25,2],[53,1,53,6],[135,4,137,6],[123,1,123,3],[124,0,125,0],[124,1,125,3],[124,5,125,7],[131,0,131,3],[9,0,9,1],[3,1,3,6],[5,1,5,5],[9,2,9,6],[11,0,11,1],[6,6,6,7],[7,0,7,1],[11,4,11,5],[18,0,18,2],[18,4,18,6],[15,0,15,7],[16,0,16,2],[16,4,16,6],[17,0,17,2],[17,4,17,6],[24,4,24,6],[21,0,21,2],[130,0,130,3],[34,0,34,2],[42,0,42,2],[43,0,43,2],[42,4,42,6],[50,2,50,3],[44,0,44,2],[45,0,45,2],[46,0,46,2],[38,0,38,2],[39,0,39,2],[49,2,49,3],[49,4,49,5],[49,6,49,7],[40,0,40,2],[41,0,41,2],[38,4,38,6],[39,4,39,6],[40,4,40,6],[41,4,41,6],[50,6,50,7],[43,4,43,6],[44,4,44,6],[45,4,45,6],[46,4,46,6],[25,4,25,6],[26,0,26,2],[27,0,27,2],[28,0,28,2],[36,0,36,2],[37,0,37,2],[29,0,29,2],[29,4,29,6],[30,0,30,2],[30,4,30,6],[31,0,31,2],[31,4,31,6],[32,0,32,2],[32,4,32,6],[33,0,33,2],[33,4,33,6],[26,4,26,6],[27,4,27,6],[35,0,35,2],[28,4,28,6],[36,4,36,6],[37,4,37,6],[34,4,34,6],[35,4,35,6],[49,0,49,1],[50,0,50,1],[50,4,50,5],[75,0,75,1],[76,0,76,1],[77,0,77,1],[78,0,78,1],[65,2,66,3],[67,2,67,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[74,2,74,3],[79,0,79,1],[80,0,80,1],[81,0,81,1],[64,0,64,1],[59,0,59,9],[61,0,61,9],[65,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[62,0,62,5],[62,6,62,7],[75,2,75,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[81,2,81,3],[84,2,84,3],[85,2,85,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[82,0,82,1],[83,0,83,1],[84,0,84,1],[85,0,85,1],[86,0,86,1],[87,0,87,1],[88,0,88,1],[82,2,82,3],[83,2,83,3],[108,0,117,9],[107,1,107,9],[89,2,89,3],[90,2,90,3],[91,2,91,3],[92,2,92,3],[93,2,93,3],[94,2,94,3],[95,2,95,3],[96,2,96,3],[97,0,97,3],[91,0,91,1],[92,0,92,1],[93,0,93,1],[94,0,94,1],[95,0,95,1],[96,0,96,1],[89,0,89,1],[90,0,90,1]]}
["ALSH EXTRASCOLAIRE",null,null,null,null,"ACTIVITE 2018 ACTUALISEE A FIN"]
[null,null,null,null,null,null,null,"SEPTEMBRE"]
[]
["GESTIONNAIRE",{"$f":"IF($H$6=\"\",\"\",VLOOKUP(H6,Identification!A2:G83,2))","v":""}]
[]
["EQUIPEMENT",{"$f":"IF($H$6=\"\",\"\",VLOOKUP(H6,Identification!A2:G83,3))","v":""},null,null,null,null,"DOSSIER N°"]
[]
["Code Postal de la commune de l'équipement"]
[]
["COMMUNE DE L'EQUIPEMENT"]
[]
["Code Insee de la commune",null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,resultat,3))","v":""},null,"Taux RG conventionné",null,0.99]
[]
[]
[]
["LIEUX D'IMPLANTATION"]
["Adresse",null,null,"Code postal","Commune",null,null,"Code Insee commune"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D18=Insee!$B$1:$B$38001)*(E18=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D19=Insee!$B$1:$B$38001)*(E19=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D20=Insee!$B$1:$B$38001)*(E20=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D21=Insee!$B$1:$B$38001)*(E21=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D22=Insee!$B$1:$B$38001)*(E22=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D23=Insee!$B$1:$B$38001)*(E23=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D24=Insee!$B$1:$B$38001)*(E24=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D25=Insee!$B$1:$B$38001)*(E25=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D26=Insee!$B$1:$B$38001)*(E26=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D27=Insee!$B$1:$B$38001)*(E27=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D28=Insee!$B$1:$B$38001)*(E28=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D29=Insee!$B$1:$B$38001)*(E29=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D30=Insee!$B$1:$B$38001)*(E30=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D31=Insee!$B$1:$B$38001)*(E31=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D32=Insee!$B$1:$B$38001)*(E32=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D33=Insee!$B$1:$B$38001)*(E33=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D34=Insee!$B$1:$B$38001)*(E34=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D35=Insee!$B$1:$B$38001)*(E35=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D36=Insee!$B$1:$B$38001)*(E36=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D37=Insee!$B$1:$B$38001)*(E37=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D38=Insee!$B$1:$B$38001)*(E38=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D39=Insee!$B$1:$B$38001)*(E39=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D40=Insee!$B$1:$B$38001)*(E40=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D41=Insee!$B$1:$B$38001)*(E41=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D42=Insee!$B$1:$B$38001)*(E42=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D43=Insee!$B$1:$B$38001)*(E43=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D44=Insee!$B$1:$B$38001)*(E44=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D45=Insee!$B$1:$B$38001)*(E45=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D46=Insee!$B$1:$B$38001)*(E46=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D47=Insee!$B$1:$B$38001)*(E47=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[]
[]
["Total lieux d'implantation",null,"Sur la commune de l'équipement",null,"Sur des communes autres que celle de l'équipement",null,"Nombre de communes différentes dans le dossier"]
[{"$f":"IF(COUNTA(A18:A47)>0,COUNTA(A18:A47),\"-\")","v":"-"},null,{"$f":"COUNTIF(H18:H47,C12)","v":0},null,{"$f":"IF(A51=\"-\",\" \",A51-C51)","v":" "},null,{"$f":"SUM(IF(FREQUENCY(H18:H47,H18:H47)>0,1))-1","v":0}]
["N° dossier",{"$f":"H6","v":0}]
["Année",2018]
["Gestionnaire",{"$f":"B4","v":""}]
["Commune",{"$f":"C10","v":0}]
["Structure",{"$f":"B6","v":""}]
["Nature de l'aide","PS ALSH"]
["Type de pièce","Formulaire national ACTUALISE"]
[]
["DONNEES D'ACTIVITE ACTUALISEES 2018"]
[]
["DECLARATION PAR LIEU D'IMPLANTATION"]
[]
[]
["NB LIEUX D'IMPLANTATION",null,{"$f":"IF(G51=\"-\",\"-\",A51)","v":"-"}]
["Lieux d'implantation",null,"Communes",null,"ACTIVITE REELLE A FIN",{"$f":"$H$2","v":"SEPTEMBRE"},"ACTIVITE PREVISIONNELLE D'OCTOBRE A DECEMBRE",null,"TOTAL DE L'ACTIVITE SUR TOUTE L'ANNEE"]
[null,null,null,null,"ACTES REALISES","ACTES FACTURES","ACTES REALISES","ACTES FACTURES","ACTES REALISES","ACTES FACTURES"]
[{"$f":"IF(A18>\" \",A18,\" \")","v":" "},null,{"$f":"IF(E18>\" \",E18,\" \")","v":" "},null,null,null,null,null,{"$f":"E68+G68","v":0},{"$f":"F68+H68","v":0}]
[" ",null,{"$f":"IF(E19>\" \",E19,\" \")","v":" "},null,null,null,null,null,{"$f":"E69+G69","v":0},{"$f":"F69+H69","v":0}]
[" ",null,{"$f":"IF(E20>\" \",E20,\" \")","v":" "},null,null,null,null,null,{"$f":"E70+G70","v":0},0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,{"$f":"E78+G78","v":0},{"$f":"F78+H78","v":0}]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,{"$f":"E91+G91","v":0},0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[{"$f":"IF(A47>\" \",A47,\" \")","v":" "},null,{"$f":"IF(E47>\" \",E47,\" \")","v":" "},null,null,null,null,null,0,0]
["TOTAUX",null,null,null,{"$f":"SUM(E68:E97)","v":0},{"$f":"SUM(F68:F97)","v":0},0,0,{"$f":"SUM(I68:I97)","v":0},{"$f":"SUM(J68:J97)","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(I68:I97,\">0\")","v":0}]
[]
[]
[]
[{"$f":"IF(C65=\"-\",\" \",IF(F99=C65,\" \",\"Il n'y a pas concordance entre le nombre de lieux d'implantation à renseigner (E65) et le nombre de lieux d'implantation complétés\"))","v":" "}]
[]
[]
[]
[]
["Commentaires :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SI ENVOI PAR COURRIER => A COMPLETER AVANT DE TRANSMETTRE A LA CAF"]
[]
[null," (NOM et Prénom)",null,null,null,null,"(Maire, Président, autre à préciser*)"]
["Je soussigné ",null,null,null,"en qualité de "]
[]
[]
[null,"la Commune ","de l'EPCI","de l'association ","de la fédération","du CCAS","du CE"]
[]
[]
["                certifie l'exactitude des informations communiquées"]
[]
[]
[null,"Date :",null,null," cachet et signature de la personne habilitée"]

{"sheet":"Service Accueil Adolescents","index":2,"n_rows":137,"n_cols":11,"rows_kept":137,"cut":false,"hidden":false,"merged":[[65,10,66,10],[136,4,137,6],[49,6,49,7],[45,4,45,6],[45,0,45,2],[46,0,46,2],[50,2,50,3],[49,0,49,1],[138,4,140,6],[126,0,127,0],[126,1,127,3],[126,4,127,4],[126,5,127,7],[125,1,125,3],[133,0,133,3],[129,1,129,6],[49,4,49,5],[50,6,50,7],[51,1,51,2],[52,1,52,2],[53,1,53,6],[54,1,54,6],[55,1,55,6],[56,1,56,2],[62,6,62,7],[0,0,0,3],[0,5,0,7],[43,0,43,2],[44,0,44,2],[42,0,42,2],[37,0,37,2],[37,4,37,6],[22,0,22,2],[38,4,38,6],[41,0,41,2],[40,4,40,6],[41,4,41,6],[42,4,42,6],[43,4,43,6],[44,4,44,6],[16,4,16,6],[36,0,36,2],[36,4,36,6],[34,0,34,2],[34,4,34,6],[6,6,6,7],[3,1,3,6],[5,1,5,5],[18,0,18,2],[18,4,18,6],[7,0,7,1],[9,0,9,1],[9,2,9,6],[11,0,11,1],[11,4,11,5],[24,4,24,6],[25,0,25,2],[25,4,25,6],[23,0,23,2],[23,4,23,6],[15,0,15,7],[17,0,17,2],[17,4,17,6],[21,0,21,2],[21,4,21,6],[19,0,19,2],[19,4,19,6],[20,0,20,2],[20,4,20,6],[16,0,16,2],[22,4,22,6],[35,4,35,6],[26,4,26,6],[27,0,27,2],[27,4,27,6],[24,0,24,2],[26,0,26,2],[50,4,50,5],[50,0,50,1],[38,0,38,2],[46,4,46,6],[39,0,39,2],[40,0,40,2],[39,4,39,6],[49,2,49,3],[30,0,30,2],[30,4,30,6],[31,0,31,2],[31,4,31,6],[32,0,32,2],[32,4,32,6],[33,0,33,2],[33,4,33,6],[28,0,28,2],[28,4,28,6],[72,0,72,1],[72,2,72,3],[73,0,73,1],[73,2,73,3],[74,0,74,1],[74,2,74,3],[74,4,74,5],[74,6,74,7],[67,0,67,1],[67,2,67,3],[68,0,68,1],[68,2,68,3],[69,0,69,1],[69,2,69,3],[70,0,70,1],[70,2,70,3],[71,0,71,1],[71,2,71,3],[68,6,68,7],[29,0,29,2],[29,4,29,6],[35,0,35,2],[73,4,73,5],[73,6,73,7],[73,8,73,9],[75,0,75,1],[75,2,75,3],[76,0,76,1],[76,2,76,3],[70,4,70,5],[70,6,70,7],[70,8,70,9],[71,4,71,5],[71,6,71,7],[71,8,71,9],[72,4,72,5],[72,6,72,7],[72,8,72,9],[65,6,66,7],[65,8,66,9],[67,4,67,5],[68,4,68,5],[67,6,67,7],[80,0,80,1],[80,2,80,3],[81,0,81,1],[81,2,81,3],[82,0,82,1],[82,2,82,3],[83,0,83,1],[83,2,83,3],[84,0,84,1],[67,8,67,9],[68,8,68,9],[69,4,69,5],[69,6,69,7],[69,8,69,9],[74,8,74,9],[75,4,75,5],[75,6,75,7],[75,8,75,9],[76,4,76,5],[76,6,76,7],[76,8,76,9],[77,4,77,5],[77,6,77,7],[77,8,77,9],[78,4,78,5],[78,6,78,7],[78,8,78,9],[84,4,84,5],[84,6,84,7],[84,8,84,9],[79,8,79,9],[80,8,80,9],[81,8,81,9],[82,8,82,9],[83,8,83,9],[88,6,88,7],[88,8,88,9],[89,4,89,5],[89,6,89,7],[89,8,89,9],[90,4,90,5],[90,6,90,7],[90,8,90,9],[85,4,85,5],[85,6,85,7],[85,8,85,9],[86,4,86,5],[86,6,86,7],[86,8,86,9],[87,4,87,5],[87,6,87,7],[87,8,87,9],[97,4,97,5],[97,6,97,7],[97,8,97,9],[65,4,65,5],[66,4,66,5],[94,4,94,5],[94,6,94,7],[94,8,94,9],[95,4,95,5],[95,6,95,7],[95,8,95,9],[96,4,96,5],[96,6,96,7],[96,8,96,9],[91,4,91,5],[91,6,91,7],[91,8,91,9],[92,4,92,5],[92,6,92,7],[92,8,92,9],[93,4,93,5],[93,6,93,7],[93,8,93,9],[88,4,88,5],[65,0,66,1],[65,2,66,3],[92,0,92,1],[87,0,87,1],[87,2,87,3],[88,0,88,1],[88,2,88,3],[89,0,89,1],[89,2,89,3],[90,0,90,1],[90,2,90,3],[91,0,91,1],[91,2,91,3],[86,0,86,1],[86,2,86,3],[84,2,84,3],[85,0,85,1],[85,2,85,3],[77,0,77,1],[77,2,77,3],[78,0,78,1],[78,2,78,3],[79,0,79,1],[79,2,79,3],[107,1,107,9],[108,0,117,9],[97,0,97,3],[59,0,59,9],[61,0,61,9],[92,2,92,3],[93,0,93,1],[93,2,93,3],[94,0,94,1],[94,2,94,3],[95,0,95,1],[95,2,95,3],[96,0,96,1],[96,2,96,3],[79,4,79,5],[79,6,79,7],[80,4,80,5],[80,6,80,7],[81,4,81,5],[81,6,81,7],[82,4,82,5],[82,6,82,7],[83,4,83,5],[83,6,83,7]]}
["ALSH ACCUEIL ADOLESCENTS",null,null,null,null,"ACTIVITE 2018 ACTUALISEE A FIN"]
[null,null,null,null,null,null,null,"SEPTEMBRE"]
[]
["GESTIONNAIRE",{"$f":"IF($H$6=\"\",\"\",VLOOKUP(H6,Identification!A151:G174,2))","v":""}]
[]
["EQUIPEMENT",{"$f":"IF($H$6=\"\",\"\",VLOOKUP(H6,Identification!A151:G174,3))","v":""},null,null,null,null,"DOSSIER N°"]
[]
["Code Postal de la commune de l'équipement"]
[]
["COMMUNE DE L'EQUIPEMENT"]
[]
["Code Insee de la commune",null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,resultat,3))","v":""},null,"Taux RG conventionné",null,0.99]
[]
[]
[]
["LIEUX D'IMPLANTATION"]
["Adresse",null,null,"Code postal","Commune",null,null,"Code Insee commune","Type accueil adolescents"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D18=Insee!$B$1:$B$38001)*(E18=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D19=Insee!$B$1:$B$38001)*(E19=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D20=Insee!$B$1:$B$38001)*(E20=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D21=Insee!$B$1:$B$38001)*(E21=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D22=Insee!$B$1:$B$38001)*(E22=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D23=Insee!$B$1:$B$38001)*(E23=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D24=Insee!$B$1:$B$38001)*(E24=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D25=Insee!$B$1:$B$38001)*(E25=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D26=Insee!$B$1:$B$38001)*(E26=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D27=Insee!$B$1:$B$38001)*(E27=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D28=Insee!$B$1:$B$38001)*(E28=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D29=Insee!$B$1:$B$38001)*(E29=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D30=Insee!$B$1:$B$38001)*(E30=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D31=Insee!$B$1:$B$38001)*(E31=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D32=Insee!$B$1:$B$38001)*(E32=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D33=Insee!$B$1:$B$38001)*(E33=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D34=Insee!$B$1:$B$38001)*(E34=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D35=Insee!$B$1:$B$38001)*(E35=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D36=Insee!$B$1:$B$38001)*(E36=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D37=Insee!$B$1:$B$38001)*(E37=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D38=Insee!$B$1:$B$38001)*(E38=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D39=Insee!$B$1:$B$38001)*(E39=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D40=Insee!$B$1:$B$38001)*(E40=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D41=Insee!$B$1:$B$38001)*(E41=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D42=Insee!$B$1:$B$38001)*(E42=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D43=Insee!$B$1:$B$38001)*(E43=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D44=Insee!$B$1:$B$38001)*(E44=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D45=Insee!$B$1:$B$38001)*(E45=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D46=Insee!$B$1:$B$38001)*(E46=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D47=Insee!$B$1:$B$38001)*(E47=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0},"???"]
[]
[]
["Total lieux d'implantation",null,"Sur la commune de l'équipement",null,"Sur des communes autres que celle de l'équipement",null,"Nombre de communes différentes dans le dossier"]
[{"$f":"IF(COUNTA(A18:A47)>0,COUNTA(A18:A47),\"-\")","v":"-"},null,{"$f":"COUNTIF(H18:H47,C12)","v":0},null,{"$f":"IF(A51=\"-\",\" \",A51-C51)","v":" "},null,{"$f":"SUM(IF(FREQUENCY(H18:H47,H18:H47)>0,1))-1","v":0}]
["N° dossier",{"$f":"H6","v":0}]
["Année",2018]
["Gestionnaire",{"$f":"B4","v":""}]
["Commune",{"$f":"C10","v":0}]
["Structure",{"$f":"B6","v":""}]
["Nature de l'aide","PS ALSH"]
["Type de pièce","Formulaire national ACTUALISE"]
[]
["DONNEES D'ACTIVITE ACTUALISEES 2018"]
[]
["DECLARATION PAR LIEU D'IMPLANTATION"]
[]
[]
["NB LIEUX D'IMPLANTATION",null,{"$f":"IF(G51=\"-\",\"-\",A51)","v":"-"}]
["Lieux d'implantation",null,"Communes",null,"TOTAL DES ACTES REALISES A FIN",null,"TOTAL DES ACTES REALISES PREVISIONNELS D'OCTOBRE A DECEMBRE",null,"TOTAL DES ACTES REALISES SUR TOUTE L'ANNEE",null,"Type accueil adolescents"]
[null,null,null,null,{"$f":"$H$2","v":"SEPTEMBRE"}]
[{"$f":"IF(A18>\" \",A18,\" \")","v":" "},null,{"$f":"IF(E18>\" \",E18,\" \")","v":" "},null,null,null,null,null,{"$f":"E68+G68","v":0},null,{"$f":"I18","v":"???"}]
[" ",null,{"$f":"IF(E19>\" \",E19,\" \")","v":" "},null,null,null,null,null,{"$f":"E69+G69","v":0},null,{"$f":"I19","v":"???"}]
[" ",null,{"$f":"IF(E20>\" \",E20,\" \")","v":" "},null,null,null,null,null,{"$f":"E70+G70","v":0},null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,{"$f":"E80+G80","v":0},null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null," ",null,null,null,null,null,0,null,"???"]
[" ",null,{"$f":"IF(E47>\" \",E47,\" \")","v":" "},null,null,null,null,null,{"$f":"E97+G97","v":0},null,"???"]
["TOTAUX",null,null,null,{"$f":"SUM(E68:E97)","v":0},null,0,null,0]
[null,null,null,null,null,{"$f":"COUNTIF(I68:I97,\">0\")","v":0}]
[]
[]
[]
[{"$f":"IF(C65=\"-\",\" \",IF(F99=C65,\" \",\"Il n'y a pas concordance entre le nombre de lieux d'implantation à renseigner (E65) et le nombre de lieux d'implantation complétés\"))","v":" "}]
[]
[]
[]
[]
["Commentaires :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SI ENVOI PAR COURRIER => A COMPLETER AVANT DE TRANSMETTRE A LA CAF"]
[]
[]
[null," (NOM et Prénom)",null,null,null,null,"(Maire, Président, autre à préciser*)"]
["Je soussigné ",null,null,null,"en qualité de "]
[]
[]
[null,"(Cochez la case correspondant à vos statuts)"]
[null,"la Commune ","de l'EPCI","de l'association ","de la fédération","du CCAS","du CE"]
[]
[]
["                certifie l'exactitude des informations communiquées"]
[]
[]
[null,"Date :",null,null," cachet et signature de la personne habilitée"]

{"sheet":"Service Périscolaire Mixte","index":3,"n_rows":240,"n_cols":10,"rows_kept":240,"cut":false,"hidden":false,"merged":[[27,0,27,2],[27,4,27,6],[39,0,39,2],[9,0,9,1],[9,2,9,6],[11,0,11,1],[11,4,11,5],[15,0,15,7],[38,4,38,6],[29,0,29,2],[29,4,29,6],[30,0,30,2],[30,4,30,6],[31,0,31,2],[31,4,31,6],[32,0,32,2],[32,4,32,6],[33,0,33,2],[33,4,33,6],[65,8,65,9],[168,6,168,7],[168,8,168,9],[16,0,16,2],[16,4,16,6],[17,0,17,2],[17,4,17,6],[18,0,18,2],[18,4,18,6],[28,0,28,2],[28,4,28,6],[34,0,34,2],[34,4,34,6],[35,0,35,2],[35,4,35,6],[25,0,25,2],[25,4,25,6],[36,0,36,2],[36,4,36,6],[37,0,37,2],[37,4,37,6],[38,0,38,2],[26,0,26,2],[26,4,26,6],[0,0,0,3],[0,5,0,7],[22,0,22,2],[22,4,22,6],[23,0,23,2],[23,4,23,6],[24,0,24,2],[24,4,24,6],[19,0,19,2],[19,4,19,6],[20,0,20,2],[20,4,20,6],[21,0,21,2],[21,4,21,6],[3,1,3,6],[5,1,5,5],[6,6,6,7],[7,0,7,1],[42,0,42,2],[42,4,42,6],[43,0,43,2],[43,4,43,6],[44,0,44,2],[44,4,44,6],[39,4,39,6],[40,0,40,2],[40,4,40,6],[41,0,41,2],[41,4,41,6],[45,0,45,2],[45,4,45,6],[46,0,46,2],[46,4,46,6],[49,0,49,1],[49,2,49,3],[49,4,49,5],[49,6,49,7],[71,0,71,1],[71,2,71,3],[54,1,54,6],[55,1,55,6],[56,1,56,2],[59,0,59,9],[61,0,61,9],[62,6,62,7],[50,0,50,1],[50,2,50,3],[50,4,50,5],[50,6,50,7],[51,1,51,2],[52,1,52,2],[53,1,53,6],[65,6,65,7],[75,0,75,1],[75,2,75,3],[76,0,76,1],[76,2,76,3],[65,0,66,1],[65,2,66,3],[67,0,67,1],[67,2,67,3],[68,0,68,1],[68,2,68,3],[69,0,69,1],[69,2,69,3],[70,0,70,1],[70,2,70,3],[73,0,73,1],[73,2,73,3],[74,0,74,1],[74,2,74,3],[72,0,72,1],[72,2,72,3],[77,0,77,1],[77,2,77,3],[79,0,79,1],[79,2,79,3],[80,0,80,1],[80,2,80,3],[78,0,78,1],[78,2,78,3],[81,0,81,1],[81,2,81,3],[82,0,82,1],[82,2,82,3],[85,2,85,3],[117,0,117,7],[118,0,118,2],[118,4,118,6],[112,0,112,7],[83,0,83,1],[83,2,83,3],[84,0,84,1],[84,2,84,3],[85,0,85,1],[86,0,86,1],[86,2,86,3],[87,0,87,1],[87,2,87,3],[88,0,88,1],[88,2,88,3],[89,0,89,1],[89,2,89,3],[90,0,90,1],[90,2,90,3],[91,0,91,1],[91,2,91,3],[123,4,123,6],[124,4,124,6],[124,0,124,2],[125,0,125,2],[125,4,125,6],[119,0,119,2],[119,4,119,6],[120,4,120,6],[120,0,120,2],[121,4,121,6],[122,0,122,2],[122,4,122,6],[121,0,121,2],[126,4,126,6],[127,0,127,2],[127,4,127,6],[128,4,128,6],[134,0,134,2],[134,4,134,6],[138,0,138,2],[138,4,138,6],[139,0,139,2],[139,4,139,6],[129,4,129,6],[130,0,130,2],[130,4,130,6],[131,0,131,2],[131,4,131,6],[132,0,132,2],[132,4,132,6],[133,0,133,2],[133,4,133,6],[236,0,236,3],[239,4,240,6],[241,4,243,6],[228,1,228,3],[229,0,230,0],[229,1,230,3],[229,4,230,4],[229,5,230,7],[232,1,232,6],[140,4,140,6],[135,0,135,2],[135,4,135,6],[136,0,136,2],[136,4,136,6],[144,0,144,2],[144,4,144,6],[145,0,145,2],[145,4,145,6],[137,4,137,6],[137,0,137,2],[146,4,146,6],[141,0,141,2],[141,4,141,6],[142,0,142,2],[142,4,142,6],[143,0,143,2],[143,4,143,6],[152,0,152,1],[152,2,152,3],[152,4,152,5],[152,6,152,7],[147,0,147,2],[147,4,147,6],[148,0,148,2],[148,4,148,6],[151,0,151,1],[151,2,151,3],[151,4,151,5],[151,6,151,7],[165,6,165,7],[162,0,162,9],[164,0,164,9],[168,0,169,1],[168,2,169,3],[170,0,170,1],[170,2,170,3],[171,0,171,1],[171,2,171,3],[92,0,92,1],[92,2,92,3],[93,0,93,1],[93,2,93,3],[94,0,94,1],[94,2,94,3],[95,0,95,1],[95,2,95,3],[96,0,96,1],[96,2,96,3],[188,2,188,3],[97,0,97,3],[174,0,174,1],[174,2,174,3],[175,0,175,1],[175,2,175,3],[176,0,176,1],[176,2,176,3],[129,0,129,2],[172,0,172,1],[172,2,172,3],[173,0,173,1],[173,2,173,3],[146,0,146,2],[140,0,140,2],[128,0,128,2],[126,0,126,2],[123,0,123,2],[195,2,195,3],[196,0,196,1],[196,2,196,3],[197,0,197,1],[197,2,197,3],[177,0,177,1],[177,2,177,3],[178,0,178,1],[178,2,178,3],[179,0,179,1],[179,2,179,3],[180,0,180,1],[180,2,180,3],[181,0,181,1],[181,2,181,3],[184,0,184,1],[184,2,184,3],[185,0,185,1],[185,2,185,3],[186,0,186,1],[186,2,186,3],[187,0,187,1],[187,2,187,3],[188,0,188,1],[210,1,210,9],[211,0,220,9],[198,0,198,1],[198,2,198,3],[199,0,199,1],[182,0,182,1],[182,2,182,3],[183,0,183,1],[183,2,183,3],[199,2,199,3],[200,0,200,3],[189,0,189,1],[189,2,189,3],[190,0,190,1],[190,2,190,3],[191,0,191,1],[191,2,191,3],[192,0,192,1],[192,2,192,3],[193,0,193,1],[193,2,193,3],[194,0,194,1],[194,2,194,3],[195,0,195,1]]}
["ALSH PERISCOLAIRE HORS TAP",null,null,null,null,"ACTIVITE 2018 ACTUALISEE A FIN"]
[null,null,null,null,null,null,null,"SEPTEMBRE"]
[]
["GESTIONNAIRE",{"$f":"IF($H$6=\"\",\"\",VLOOKUP(H6,Identification!A84:G150,2))","v":""}]
[]
["EQUIPEMENT",{"$f":"IF($H$6=\"\",\"\",VLOOKUP(H6,Identification!A84:G150,3))","v":""},null,null,null,null,"DOSSIER N°"]
[]
["Code Postal de la commune de l'équipement",null,"?????"]
[]
["COMMUNE DE L'EQUIPEMENT"]
[]
["Code Insee de la commune",null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(C10,resultat,3))","v":""},null,"Taux RG conventionné",null,0.99]
[]
[]
[]
["LIEUX D'IMPLANTATION"]
["Adresse",null,null,"Code postal","Commune",null,null,"Code Insee commune"]
[null,null,null,"?????",null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D18=Insee!$B$1:$B$38001)*(E18=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":"Code INSEE"}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D19=Insee!$B$1:$B$38001)*(E19=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D20=Insee!$B$1:$B$38001)*(E20=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D21=Insee!$B$1:$B$38001)*(E21=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D22=Insee!$B$1:$B$38001)*(E22=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D23=Insee!$B$1:$B$38001)*(E23=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D24=Insee!$B$1:$B$38001)*(E24=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D25=Insee!$B$1:$B$38001)*(E25=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D26=Insee!$B$1:$B$38001)*(E26=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D27=Insee!$B$1:$B$38001)*(E27=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D28=Insee!$B$1:$B$38001)*(E28=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D29=Insee!$B$1:$B$38001)*(E29=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D30=Insee!$B$1:$B$38001)*(E30=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D31=Insee!$B$1:$B$38001)*(E31=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D32=Insee!$B$1:$B$38001)*(E32=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D33=Insee!$B$1:$B$38001)*(E33=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D34=Insee!$B$1:$B$38001)*(E34=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D35=Insee!$B$1:$B$38001)*(E35=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D36=Insee!$B$1:$B$38001)*(E36=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D37=Insee!$B$1:$B$38001)*(E37=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D38=Insee!$B$1:$B$38001)*(E38=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D39=Insee!$B$1:$B$38001)*(E39=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D40=Insee!$B$1:$B$38001)*(E40=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D41=Insee!$B$1:$B$38001)*(E41=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D42=Insee!$B$1:$B$38001)*(E42=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D43=Insee!$B$1:$B$38001)*(E43=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D44=Insee!$B$1:$B$38001)*(E44=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D45=Insee!$B$1:$B$38001)*(E45=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D46=Insee!$B$1:$B$38001)*(E46=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D47=Insee!$B$1:$B$38001)*(E47=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[]
[]
["Total lieux d'implantation",null,"Sur la commune de l'équipement",null,"Sur des communes autres que celle de l'équipement",null,"Nombre de communes différentes dans le dossier"]
[{"$f":"IF(COUNTA(A18:A47)>0,COUNTA(A18:A47),\"-\")","v":"-"},null,{"$f":"COUNTIF(H18:H47,C12)","v":0},null,{"$f":"IF(A51=\"-\",\" \",A51-C51)","v":" "},null,{"$f":"SUM(IF(FREQUENCY(H18:H47,H18:H47)>0,1))-1","v":0}]
["N° dossier",{"$f":"H6","v":0}]
["Année",2018]
["Gestionnaire",{"$f":"B4","v":""}]
["Commune",{"$f":"C10","v":0}]
["Structure",{"$f":"B6","v":""}]
["Nature de l'aide","PS ALSH"]
["Type de pièce","Formulaire national ACTUALISE"]
[]
["DONNEES D'ACTIVITE ACTUALISEES 2018 ALSH PERISCOLAIRE HORS TAP"]
[]
["DECLARATION PAR LIEU D'IMPLANTATION"]
[]
[]
["NB LIEUX D'IMPLANTATION",null,{"$f":"IF(G51=\"-\",\"-\",A51)","v":"-"}]
["Lieux d'implantation",null,"Communes",null,"ACTIVITE REELLE A FIN",{"$f":"$H$2","v":"SEPTEMBRE"},"ACTIVITE PREVISIONNELLE D'OCTOBRE A DECEMBRE",null,"TOTAL DE L'ACTIVITE SUR TOUTE L'ANNEE"]
[null,null,null,null,"ACTES REALISES","ACTES FACTURES","ACTES REALISES","ACTES FACTURES","ACTES REALISES","ACTES FACTURES"]
[{"$f":"IF(A18>\" \",A18,\" \")","v":" "},null,{"$f":"IF(E18>\" \",E18,\" \")","v":" "},null,null,null,null,null,{"$f":"E68+G68","v":0},{"$f":"F68+H68","v":0}]
[" ",null,{"$f":"IF(E19>\" \",E19,\" \")","v":" "},null,null,null,null,null,{"$f":"E69+G69","v":0},{"$f":"F69+H69","v":0}]
[" ",null,{"$f":"IF(E20>\" \",E20,\" \")","v":" "},null,null,null,null,null,{"$f":"E70+G70","v":0},0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,{"$f":"E85+G85","v":0},{"$f":"F85+H85","v":0}]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,{"$f":"E91+G91","v":0},0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null,{"$f":"IF(E47>\" \",E47,\" \")","v":" "},null,null,null,null,null,0,0]
["TOTAUX",null,null,null,{"$f":"SUM(E68:E97)","v":0},{"$f":"SUM(F68:F97)","v":0},{"$f":"SUM(G68:G97)","v":0},0,0,0]
[null,null,{"$f":"COUNTIF(I68:I97,\">0\")","v":0}]
[]
[]
[]
[{"$f":"IF(C65=\"-\",\" \",IF(C99=C65,\" \",\"Il n'y a pas concordance entre le nombre de lieux d'implantation à renseigner (E65) et le nombre de lieux d'implantation complétés\"))","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ALSH PERISCOLAIRE TAP - ACTUALISE 2018"]
[]
[]
[]
[]
["LIEUX D'IMPLANTATION"]
["Adresse",null,null,"Code postal","Commune",null,null,"Code Insee commune"]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D120=Insee!$B$1:$B$38001)*(E120=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D121=Insee!$B$1:$B$38001)*(E121=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D122=Insee!$B$1:$B$38001)*(E122=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D123=Insee!$B$1:$B$38001)*(E123=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D124=Insee!$B$1:$B$38001)*(E124=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D125=Insee!$B$1:$B$38001)*(E125=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D126=Insee!$B$1:$B$38001)*(E126=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D127=Insee!$B$1:$B$38001)*(E127=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D128=Insee!$B$1:$B$38001)*(E128=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D129=Insee!$B$1:$B$38001)*(E129=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D130=Insee!$B$1:$B$38001)*(E130=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D131=Insee!$B$1:$B$38001)*(E131=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D132=Insee!$B$1:$B$38001)*(E132=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D133=Insee!$B$1:$B$38001)*(E133=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D134=Insee!$B$1:$B$38001)*(E134=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D135=Insee!$B$1:$B$38001)*(E135=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D136=Insee!$B$1:$B$38001)*(E136=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D137=Insee!$B$1:$B$38001)*(E137=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D138=Insee!$B$1:$B$38001)*(E138=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D139=Insee!$B$1:$B$38001)*(E139=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D140=Insee!$B$1:$B$38001)*(E140=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D141=Insee!$B$1:$B$38001)*(E141=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D142=Insee!$B$1:$B$38001)*(E142=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D143=Insee!$B$1:$B$38001)*(E143=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D144=Insee!$B$1:$B$38001)*(E144=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D145=Insee!$B$1:$B$38001)*(E145=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D146=Insee!$B$1:$B$38001)*(E146=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D147=Insee!$B$1:$B$38001)*(E147=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D148=Insee!$B$1:$B$38001)*(E148=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"INDEX(Insee!$C$1:$C$38001,MAX(IF((D149=Insee!$B$1:$B$38001)*(E149=Insee!$A$1:$A$38001),ROW(Insee!$C$1:$C$38001),0)))","v":0}]
[]
[]
["Total lieux d'implantation",null,"Sur la commune de l'équipement",null,"Sur des communes autres que celle de l'équipement",null,"Nombre de communes différentes dans le dossier"]
[{"$f":"IF(COUNTA(A120:A149)>0,COUNTA(A120:A149),\"-\")","v":"-"},null,{"$f":"COUNTIF(H120:H149,C12)","v":0},null,{"$f":"IF(A153=\"-\",\" \",A153-C153)","v":" "},null,{"$f":"SUM(IF(FREQUENCY(H120:H149,H120:H149)>0,1))-1","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DONNEES D'ACTIVITE ACTUALISEES 2018 ALSH PERISCOLAIRE TAP"]
[]
["DECLARATION PAR LIEU D'IMPLANTATION"]
[]
[]
[" NB LIEUX D'IMPLANTATION",null,{"$f":"IF(G153=\"-\",\"-\",A153)","v":"-"}]
["Lieux d'implantation",null,"Communes",null,"ACTIVITE REELLE A FIN",{"$f":"$H$2","v":"SEPTEMBRE"},"ACTIVITE PREVISIONNELLE D'OCTOBRE A DECEMBRE",null,"TOTAL DE L'ACTIVITE SUR TOUTE L'ANNEE"]
[null,null,null,null,"ACTES REALISES","ACTES FACTURES","ACTES REALISES","ACTES FACTURES","ACTES REALISES","ACTES FACTURES"]
[{"$f":"IF(A120>\" \",A120,\" \")","v":" "},null,{"$f":"IF(E120>\" \",E120,\" \")","v":" "},null,null,null,null,null,{"$f":"E171+G171","v":0},{"$f":"F171+H171","v":0}]
[{"$f":"IF(A121>\" \",A121,\" \")","v":" "},null,{"$f":"IF(E121>\" \",E121,\" \")","v":" "},null,null,null,null,null,{"$f":"E172+G172","v":0},{"$f":"F172+H172","v":0}]
[{"$f":"IF(A122>\" \",A122,\" \")","v":" "},null,{"$f":"IF(E122>\" \",E122,\" \")","v":" "},null,null,null,null,null,{"$f":"E173+G173","v":0},{"$f":"F173+H173","v":0}]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,{"$f":"E185+G185","v":0},{"$f":"F185+H185","v":0}]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
[" ",null," ",null,null,null,null,null,0,0]
["TOTAUX",null,null,null,{"$f":"SUM(E171:E200)","v":0},0,0,0,0,0]
[null,null,{"$f":"COUNTIF(I171:I200,\">0\")","v":0}]
[]
[]
[]
[{"$f":"IF(C168=\"-\",\" \",IF(C202=C168,\" \",\"Il n'y a pas concordance entre le nombre de lieux d'implantation à renseigner (E168) et le nombre de lieux d'implantation complétés\"))","v":" "}]
[]
[]
[]
[]
["Commentaires :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SI ENVOI PAR COURRIER => A COMPLETER AVANT DE TRANSMETTRE A LA CAF"]
[]
[]
[null," (NOM et Prénom)",null,null,null,null,"(Maire, Président, autre à préciser*)"]
["Je soussigné ",null,null,null,"en qualité de "]
[]
[]
[null,"(Cochez la case correspondant à vos statuts)"]
[null,"la Commune ","de l'EPCI","de l'association ","de la fédération","du CCAS","du CE"]
[]
[]
["                certifie l'exactitude des informations communiquées"]
[]
[]
[null,"Date :",null,null," cachet et signature de la personne habilitée"]

{"sheet":"Identification","index":4,"n_rows":174,"n_cols":7,"rows_kept":174,"cut":false,"hidden":true,"merged":[]}
["NUMERO DOSSIER","RAISON SOCIALE GESTIONNAIRE","NOM EQUIPEMENT","SERVICE","CODE POSTAL EQUIPEMENT","COMMUNE EQUIPEMENT","CODE INSEE COMMUNE"]
[200100001,"ASSOC CLAAC","Centre de Loisirs de Parilly","Extrascolaire","37500","CHINON","37072"]
[200100003,"ASSOC FAMILIALE AMBILLOU","Centre de Loisirs d'Ambillou","Extrascolaire","37340","AMBILLOU","37002"]
[200100007,"MAIRIE DE CHAMBRAY LES TOURS","Centre de Loisirs La Pinède","Extrascolaire","37170","CHAMBRAY LES TOURS","37050"]
[200100031,"MAIRIE DE TOURS","Centre de Loisirs La Charpraie","Extrascolaire","37170","CHAMBRAY LES TOURS","37050"]
[200100082,"MAIRIE DE NOUZILLY","Ctre Loisirs P'tites Canailles","Extrascolaire","37380","NOUZILLY","37175"]
[200100087,"MAIRIE DE ST CYR SUR LOIRE","Extra Mairie Saint Cyr","Extrascolaire","37390","METTRAY","37152"]
[200100109,"MAIRIE DE ST ANTOINE DU ROCHER","Ctre Loisirs St Antoine Rocher","Extrascolaire","37360","SAINT ANTOINE DU ROCHER","37206"]
[200200047,"MAIRIE DE CERELLES","Extra Mairie Cerelles","Extrascolaire","37390","CERELLES","37047"]
[200300310,"ASSOC FAMILLES RURALES DU RIDELLOIS","Centre de Loisirs Mermoz","Extrascolaire","37190","AZAY LE RIDEAU","37014"]
[200400119,"ASSOC SCOUTS ET GUIDES DE FRANCE","Ctre Loisirs Grpe Notre Dame","Extrascolaire","37000","TOURS","37261"]
[200400256,"MAIRIE DE PARCAY MESLAY","Ctre de Loisirs Parçay Meslay","Extrascolaire","37210","PARCAY MESLAY","37179"]
[200400258,"ASSOC REGARDS D ENFANCE","Ctre Loisirs Regards d'Enfance","Extrascolaire","37360","ROUZIERS DE TOURAINE","37204"]
[200500180,"ASSOC SCOUTS ET GUIDES DE FRANCE","Ctre Loisirs Grpe12 Christ Roi","Extrascolaire","37100","TOURS","37261"]
[200600006,"ASSOC SCOUTS ET GUIDES DE FRANCE","Centre de Loisirs Tours Sud","Extrascolaire","37250","MONTBAZON","37154"]
[200800017,"MAIRIE DE JOUE LES TOURS","Ctre Loisirs Stage Multisports","Extrascolaire","37300","JOUE LES TOURS","37122"]
[200800068,"CCAS LA RICHE","Centre de Loisirs TOT'AIME","Extrascolaire","37520","LA RICHE","37195"]
[200900547,"ASSOC BONJOUR LA RECRE","Ctre Loisirs Bonjour La Recré","Extrascolaire","37360","BEAUMONT LOUESTAULT","37021"]
[200900549,"ASSOC LE PETIT PAUSAILLEUR","Ctre de Loisirs Pt Pausailleur","Extrascolaire","37210","VOUVRAY","37281"]
[201100149,"ASSOC UFCV ORLEANS","Centre de Loisirs de Saunay","Extrascolaire","37110","SAUNAY","37240"]
[201100153,"ASSOC UFCV ORLEANS","Centre de Loisirs d'Auzouer","Extrascolaire","37110","AUZOUER EN TOURAINE","37010"]
[201100311,"ASSOC UFCV ORLEANS","Centre de Loisirs Villedomer","Extrascolaire","37110","VILLEDOMER","37276"]
[201200180,"MAIRIE DE LA MEMBROLLE SUR CHOISILLE","Centre de Loisirs la Membrolle","Extrascolaire","37390","MEMBROLLE SUR CHOISILLE","37151"]
[201300011,"COMMUNAUTE DE CNES BLERE VAL DE CHER","Extra Bléré Val de Cher","Extrascolaire","37150","BLERE","37027"]
[201300151,"ASSOC BUL DE MOMES","Extra Nature Prioriterre","Extrascolaire","37400","LUSSAULT SUR LOIRE","37138"]
[201300158,"ASSOC FAMILLES RURALES DU RIDELLOIS","Centre Loisirs B.Vallée Indre","Extrascolaire","37190","RIVARENNES","37200"]
[201400389,"ASSOC FAMILLES RURALES DU RIDELLOIS","Centre de Loisirs de Vallères","Extrascolaire","37190","VALLERES","37264"]
[201400390,"ASSOC MILLE ET UNE PATTES","Centre de Loisirs de Sache","Extrascolaire","37190","SACHE","37205"]
[201400391,"ASSOC MILLE ET UNE PATTES","Centre de Loisirs de Thilouze","Extrascolaire","37260","THILOUZE","37257"]
[201400394,"ASSOC FAMILLES RURALES DE ST PATERNE RACAN","Extra Assoc St Paterne","Extrascolaire","37370","SAINT PATERNE RACAN","37231"]
[201400431,"ASSOC FED REG DES MJC","Centre de Loisirs de Chançay","Extrascolaire","37210","CHANCAY","37052"]
[201400453,"MAIRIE DE MORAND","Ctre Loisirs Morand","Extrascolaire","37110","MORAND","37160"]
[201400458,"ASSOC VOYAGEURS 37","Centre de Loisirs Voyageurs 37","Extrascolaire","37210","PARCAY MESLAY","37179"]
[201400461,"ASSOC POUR L ANIMATION DE MONTLOUIS","Centre de Loisirs de Montlouis","Extrascolaire","37270","MONTLOUIS SUR LOIRE","37156"]
[201400466,"ASSOC ECLAIREUSES ET ECLAIREURS UNIONISTES DE FRANCE","Centre de Loisirs Eclaireurs","Extrascolaire","37000","TOURS","37261"]
[201400472,"ASSOC BUL DE MOMES","Ctre Loisirs P'tites Bouilles","Extrascolaire","37530","SAINT OUEN LES VIGNES","37230"]
[201400475,"ASSOC CENTRE CHARLES PEGUY MJC AMBOISE","Ctre de Loisirs Charles Péguy","Extrascolaire","37400","AMBOISE","37003"]
[201400476,"ASSOC ALIPES","Centre de Loisirs ALIPES","Extrascolaire","37510","SAVONNIERES","37243"]
[201400478,"ASSOC FAMILLES RURALES DE CORMERY","Centre de Loisirs La Farandole","Extrascolaire","37320","CORMERY","37083"]
[201400481,"ASSOC FAMILLES RURALES ST MICHEL SUR LOIRE ET SES ENVIRONS","Centre de Loisirs Arc en Ciel","Extrascolaire","37130","COTEAUX SUR LOIRE","37232"]
[201400489,"ASSOC MILLE ET UNE PATTES","Ctre Loisirs Mille Une Pattes","Extrascolaire","37190","VILLAINES LES ROCHERS","37271"]
[201400493,"ASSOC JOCONDIENNE DU CENTRE SOCIAL VALLEE VIOLETTE","Centre Loisirs CS V Violette","Extrascolaire","37300","JOUE LES TOURS","37122"]
[201400496,"ASSOC CLSH LE MAIL ENCHANTE  CHEDIGNY","Ctre Loisirs Le Mail Enchanté","Extrascolaire","37310","CHEDIGNY","37066"]
[201400497,"ASSOC FAMILLES RURALES DE FERRIERE SUR BEAULIEU","Centre de Loisirs AFR Ferrière","Extrascolaire","37600","FERRIERE SUR BEAULIEU","37108"]
[201400498,"ASSOC FAMILIALE FONDETTES","Centre de Loisirs la Momerie","Extrascolaire","37230","FONDETTES","37109"]
[201400500,"ASSOC PATACLOU","Centre de Loisirs Pataclou","Extrascolaire","37360","SONZAY","37249"]
[201400503,"ASSOC HABITUS","Extra Assoc Habitus","Extrascolaire","37330","CHATEAU LA VALLIERE","37062"]
[201400505,"ASSOC PETITS DROLES","Ctre Loisirs les Petits Drôles","Extrascolaire","37600","SAINT JEAN SAINT GERMAIN","37222"]
[201400506,"ASSOC CLUB LOISIRS ET CULTURE ATHEE SUR CHER","Centre de Loisirs Club Culture","Extrascolaire","37270","ATHEE SUR CHER","37008"]
[201400507,"ASSOC CAMILLE CLAUDEL LA VILLE AUX DAMES","Ctre Loisirs Camille Claudel","Extrascolaire","37700","VILLE AUX DAMES","37273"]
[201400509,"MAIRIE DE CHANCEAUX SUR CHOISILLE","Centre Loisirs Ecole Primaire","Extrascolaire","37390","CHANCEAUX SUR CHOISILLE","37054"]
[201400510,"ASSOC PUZZLE","Ctre Loisirs La clé des champs","Extrascolaire","37310","REIGNAC SUR INDRE","37192"]
[201400511,"MAIRIE DE CHATEAU RENAULT","Centre Loisirs Chateaurenault","Extrascolaire","37110","CHATEAU RENAULT","37063"]
[201400512,"MAIRIE DE LOCHES","Centre de Loisirs M Aquilon","Extrascolaire","37600","LOCHES","37132"]
[201400515,"MAIRIE DE ROCHECORBON","Extra Mairie Rochecorbon","Extrascolaire","37210","ROCHECORBON","37203"]
[201400517,"MAIRIE DE LUYNES","Extra Mairie Luynes","Extrascolaire","37230","LUYNES","37139"]
[201400522,"ASSOC FAMILLES RURALES TAUXIGNY","Centre Loisirs AFR Tauxigny","Extrascolaire","37310","TAUXIGNY","37254"]
[201400539,"ASSOC PUZZLE","Centre de Loisirs de Chambourg","Extrascolaire","37310","CHAMBOURG SUR INDRE","37049"]
[201400578,"ACCUEIL LOISIRS SANS HEBERGEMENT \"LES BAMBINS DE PREVERT\"","Ctre Loisirs Neuillé Pt Pierre","Extrascolaire","37360","NEUILLE PONT PIERRE","37167"]
[201600067,"ASSOC LEO LAGRANGE","Centre de Loisirs de Bléré","Extrascolaire","37150","BLERE","37027"]
[201700066,"ASSOC SCOUTS ET GUIDES DE FRANCE","Ctre de Loisirs St Martin Sud","Extrascolaire","37800","MAILLE","37142"]
[201700138,"MAIRIE DE ST ETIENNE DE CHIGNY","Ctre Loisirs la Petite Récrée","Extrascolaire","37230","SAINT ETIENNE DE CHIGNY","37217"]
[201800048,"ASSOC LEO LAGRANGE","Extra Léo Lagrange Tours","Extrascolaire","37200","TOURS","37261"]
[201800050,"ASSOC SOCIO CULTURELLE COURTELINE","Extra Assoc Courteline","Extrascolaire","37000","TOURS","37261"]
[201800052,"ASSOC USAGERS CENTRE SOCIAL GIRAUDEAU","Extra Assoc Giraudeau","Extrascolaire","37000","TOURS","37261"]
[201800054,"CHARLOTTE LOISIRS","Extra Charlotte Loisirs Tours","Extrascolaire","37100","TOURS","37261"]
[201800068,"MAIRIE DE NOTRE DAME D'OE","Extra Mairie Notre Dame d'Oe","Extrascolaire","37390","NOTRE DAME D'OE","37172"]
[201800070,"MAIRIE DE ST AVERTIN","Extra Mairie Saint Avertin","Extrascolaire","37550","SAINT AVERTIN","37208"]
[201800072,"MAIRIE DE ST PIERRE DES CORPS","Extra Mairie SPDC","Extrascolaire","37700","SAINT PIERRE DES CORPS","37233"]
[201800075,"MAIRIE DE JOUE LES TOURS","Extra Mairie Joué les Tours","Extrascolaire","37300","JOUE LES TOURS","37122"]
[201800080,"COMMUNAUTE DE CNES TOURAINE EST VALLEES","Extra Touraine Est Vallées","Extrascolaire","37270","MONTLOUIS SUR LOIRE","37156"]
[201800082,"COMMUNAUTE DE CNES TOURAINE VALLEE DE L INDRE","Extra Touraine Vallée Indre","Extrascolaire","37250","SORIGNY","37250"]
[201800085,"ASSOC PATRONAGE LAIQUE ST PIERRE","Extra Assoc Patronage Laique","Extrascolaire","37700","SAINT PIERRE DES CORPS","37233"]
[201800087,"ASSOC TOURANGELLE DES CENTRES SOCIAUX","Extra Assoc ATCS","Extrascolaire","37300","JOUE LES TOURS","37122"]
[201800088,"ASSOC VIVRE ENSEMBLE AUX RIVES DU CHER","Extra Assoc VERC","Extrascolaire","37000","TOURS","37261"]
[201800089,"CENTRE COMMUNAL D ACTION SOCIALE","Extra CCAS Joué les Tours","Extrascolaire","37300","JOUE LES TOURS","37122"]
[201800095,"COMMUNAUTE DE CNES CHINON VIENNE ET LOIRE","Extra Chinon Vienne et Loire","Extrascolaire","37420","AVOINE","37011"]
[201800099,"COMMUNAUTE DE CNES DU VAL D AMBOISE","Extra Val d'Amboise","Extrascolaire","37530","NAZELLES NEGRON","37163"]
[201800100,"COMMUNAUTE DE CNES LOCHES SUD TOURAINE","Extra Loches Sud Touraine","Extrascolaire","37600","LOCHES","37132"]
[201800102,"ASSOC CENTRE SOCIAL DE LA DOUVE","Extra Assoc CS La Douve","Extrascolaire","37130","LANGEAIS","37123"]
[201800103,"ASSOC GESTION CENTRE SOCIAL JULES VERNE","Extra Assoc CS Jules Verne","Extrascolaire","37510","BALLAN MIRE","37018"]
[201800105,"COMMUNAUTE DE CNES TOURAINE VAL DE VIENNE","Extra Touraine Val de Vienne","Extrascolaire","37800","NOUATRE","37174"]
[201800106,"COMMUNAUTE DE CNES TOURAINE OUEST VAL DE LOIRE","Extra Touraine Ouest Val Loire","Extrascolaire","37340","CLERE LES PINS","37081"]
[200100006,"ASSOC FAMILLES RURALES BEAULIEU LES LOCHES","Péri Beaulieu les Loches","Périscolaire","37600","BEAULIEU LES LOCHES","37020"]
[201100416,"MAIRIE DE L ILE BOUCHARD","Centre de Loisirs Périscolaire","Périscolaire","37220","L ILE BOUCHARD","37119"]
[201300251,"ASSOC FAMILLES RURALES TAUXIGNY","Péri AFR Tauxigny","Périscolaire","37310","TAUXIGNY","37254"]
[201300252,"ASSOC FAMILLES RURALES DE FERRIERE SUR BEAULIEU","Péri La Ribambelle","Périscolaire","37600","FERRIERE SUR BEAULIEU","37108"]
[201300261,"MAIRIE DE CHANCEAUX SUR CHOISILLE","Péri Mairie Chanceaux","Périscolaire","37390","CHANCEAUX SUR CHOISILLE","37054"]
[201300262,"ASSOC CAMILLE CLAUDEL LA VILLE AUX DAMES","Ctre Loisirs Péri C Claudel","Périscolaire","37700","VILLE AUX DAMES","37273"]
[201300263,"ASSOC PETITS DROLES","Péri Assoc Les Petits Droles","Périscolaire","37600","SAINT JEAN SAINT GERMAIN","37222"]
[201300266,"MAIRIE DE MONNAIE","Péri Mairie  Monnaie","Périscolaire","37380","MONNAIE","37153"]
[201300267,"ASSOC PUZZLE","Péri Assoc Puzzle","Périscolaire","37310","REIGNAC SUR INDRE","37192"]
[201300270,"MAIRIE DE CHATEAU RENAULT","Péri Mairie Château Renault","Périscolaire","37110","CHATEAU RENAULT","37063"]
[201300271,"ASSOC CLSH LE MAIL ENCHANTE  CHEDIGNY","Ctre Loisirs Péri Mail Enchant","Périscolaire","37310","CHEDIGNY","37066"]
[201300272,"ASSOC CLUB LOISIRS ET CULTURE ATHEE SUR CHER","Péri Assoc Club Culture","Périscolaire","37270","ATHEE SUR CHER","37008"]
[201300273,"ASSOC JOCONDIENNE DU CENTRE SOCIAL VALLEE VIOLETTE","Ctre Loisirs Péri CS VViolette","Périscolaire","37300","JOUE LES TOURS","37122"]
[201300275,"MAIRIE DE LUYNES","Péri Mairie Luynes","Périscolaire","37230","LUYNES","37139"]
[201300277,"MAIRIE DE ROCHECORBON","Péri Mairie Rochecorbon","Périscolaire","37210","ROCHECORBON","37203"]
[201300279,"MAIRIE DE NAZELLES NEGRON","Ctre Loisirs Péri Denise Gence","Périscolaire","37530","NAZELLES NEGRON","37163"]
[201300283,"ASSOC CENTRE CHARLES PEGUY MJC AMBOISE","Ctre Loisirs Péri C. Péguy","Périscolaire","37400","AMBOISE","37003"]
[201300288,"ASSOC BUL DE MOMES","Ctre Loisirs Péri Pts Bouilles","Périscolaire","37530","SAINT OUEN LES VIGNES","37230"]
[201300289,"ASSOC MILLE ET UNE PATTES","Péri Assoc 1001 Pattes","Périscolaire","37190","VILLAINES LES ROCHERS","37271"]
[201300290,"MAIRIE DE REUGNY","Péri Mairie Reugny","Périscolaire","37380","REUGNY","37194"]
[201300292,"ASSOC POUR L ANIMATION DE MONTLOUIS","Péri CSC La Passerelle","Périscolaire","37270","MONTLOUIS SUR LOIRE","37156"]
[201300293,"ASSOC VOYAGEURS 37","Ctre Loisirs Péri Voyageurs 37","Périscolaire","37210","PARCAY MESLAY","37179"]
[201300294,"MAIRIE DE MORAND","Ctre Loisirs Péri Morand","Périscolaire","37110","MORAND","37160"]
[201300301,"ASSOC FAMILLES RURALES DE CORMERY","Péri La Farandole","Périscolaire","37320","CORMERY","37083"]
[201300302,"ASSOC ALIPES","Péri Assoc Alipes","Périscolaire","37510","SAVONNIERES","37243"]
[201300321,"ASSOC CENTRE SOCIAL DE LA DOUVE","Ctre Loisirs Péri Enfants","Périscolaire","37130","LANGEAIS","37123"]
[201300322,"ASSOC PATACLOU","Péri Assoc Pataclou","Périscolaire","37360","SONZAY","37249"]
[201300323,"ASSOC FAMILIALE FONDETTES","Péri La Momerie","Périscolaire","37230","FONDETTES","37109"]
[201300327,"ASSOC FAMILLES RURALES ST MICHEL SUR LOIRE ET SES ENVIRONS","Péri Arc en Ciel","Périscolaire","37130","COTEAUX SUR LOIRE","37232"]
[201300410,"ASSOC ADPEP 37 SIEGE","Ctre Loisirs Péri de Richelieu","Périscolaire","37120","RICHELIEU","37196"]
[201400395,"ASSOC FAMILLES RURALES DE ST PATERNE RACAN","Péri Assoc St Paterne Racan","Périscolaire","37370","NEUVY LE ROI","37170"]
[201400474,"MAIRIE DE SEMBLANCAY","Péri Mairie Semblancay","Périscolaire","37360","SEMBLANCAY","37245"]
[201400490,"MAIRIE DE MONTRESOR","Ctre Loisirs Péri de Montrésor","Périscolaire","37460","MONTRESOR","37157"]
[201400538,"MAIRIE DE VOUVRAY","Péri Mairie Vouvray","Périscolaire","37210","VOUVRAY","37281"]
[201500146,"MAIRIE DE DESCARTES","Ctre Loisirs Péri Descartes","Périscolaire","37160","descartes","37115"]
[201500153,"MAIRIE DE PARCAY MESLAY","Ctre Loisirs Péri de Parcay","Périscolaire","37210","PARCAY MESLAY","37179"]
[201500161,"SI DES ECOLES PRIMAIRES DU VAL DE VIENNE","Ctre Loisirs Péri de Nouatre","Périscolaire","37800","NOUATRE","37174"]
[201500312,"ASSOC ADPEP 37 SIEGE","Ctre Loisirs Péri Cinq Mars","Périscolaire","37130","CINQ MARS LA PILE","37077"]
[201500359,"MAIRIE DE BLERE","Péri Mairie Bléré","Périscolaire","37150","BLERE","37027"]
[201500460,"ASSOC FAMILLES RURALES DU RIDELLOIS","Péri Valleres","Périscolaire","37190","VALLERES","37264"]
[201500464,"ASSOC ADPEP 37 SIEGE","Ctre Loisirs Péri Cérelles","Périscolaire","37390","CERELLES","37047"]
[201500495,"MAIRIE DE NOUZILLY","Péri Mairie Nouzilly","Périscolaire","37380","NOUZILLY","37175"]
[201600269,"MAIRIE DE NOIZAY","Ctre Loisirs Péri de Noizay","Périscolaire","37210","NOIZAY","37171"]
[201600270,"ASSOC ADPEP 37 SIEGE","Ctre Loisirs Péri St Roch","Périscolaire","37390","SAINT ROCH","37237"]
[201700035,"ASSOC ADPEP 37 SIEGE","Ctre Loisirs Péri Champigny","Périscolaire","37120","CHAMPIGNY SUR VEUDE","37051"]
[201700244,"ASSOC FAMILLES RURALES DE ST PATERNE RACAN","Ctre Loisirs Péri St Paterne","Périscolaire","37370","SAINT PATERNE RACAN","37231"]
[201800049,"ASSOC LEO LAGRANGE","Péri Léo Lagrange Tours","Périscolaire","37200","TOURS","37261"]
[201800051,"ASSOC SOCIO CULTURELLE COURTELINE","Péri Assoc Courteline","Périscolaire","37000","TOURS","37261"]
[201800053,"ASSOC USAGERS CENTRE SOCIAL GIRAUDEAU","Péri Assoc Giraudeau","Périscolaire","37000","TOURS","37261"]
[201800055,"CHARLOTTE LOISIRS","Péri Charlotte Loisirs Tours","Périscolaire","37100","TOURS","37261"]
[201800063,"MAIRIE D AMBOISE","Péri Mairie Amboise","Périscolaire","37400","AMBOISE","37003"]
[201800064,"MAIRIE DE BALLAN MIRE","Péri Mairie Ballan Miré","Périscolaire","37510","BALLAN MIRE","37018"]
[201800065,"MAIRIE DE CHAMBRAY LES TOURS","Péri Mairie Chambray les Tours","Périscolaire","37170","CHAMBRAY LES TOURS","37050"]
[201800066,"MAIRIE DE LA RICHE","Péri Mairie La Riche","Périscolaire","37520","LA RICHE","37195"]
[201800067,"MAIRIE DE LOCHES","Péri Mairie Loches","Périscolaire","37600","LOCHES","37132"]
[201800069,"MAIRIE DE NOTRE DAME D'OE","Péri Mairie Notre Dame d'Oe","Périscolaire","37390","NOTRE DAME D'OE","37172"]
[201800071,"MAIRIE DE ST AVERTIN","Péri Mairie Saint Avertin","Périscolaire","37550","SAINT AVERTIN","37208"]
[201800073,"MAIRIE DE ST PIERRE DES CORPS","Péri Mairie SPDC","Périscolaire","37700","SAINT PIERRE DES CORPS","37233"]
[201800074,"MAIRIE DE STE MAURE DE TOURAINE","Péri Mairie Ste Maure de Tne","Périscolaire","37800","SAINTE MAURE DE TOURAINE","37226"]
[201800076,"MAIRIE DE JOUE LES TOURS","Péri Mairie Joué les Tours","Périscolaire","37300","JOUE LES TOURS","37122"]
[201800081,"COMMUNAUTE DE CNES TOURAINE EST VALLEES","Péri Touraine Est Vallées","Périscolaire","37270","MONTLOUIS SUR LOIRE","37156"]
[201800083,"COMMUNAUTE DE CNES TOURAINE VALLEE DE L INDRE","Péri Touraine Vallée Indre","Périscolaire","37250","SORIGNY","37250"]
[201800086,"ASSOC PATRONAGE LAIQUE ST PIERRE","Péri Assoc Patronage Laique","Périscolaire","37700","SAINT PIERRE DES CORPS","37233"]
[201800090,"CENTRE COMMUNAL D ACTION SOCIALE","Péri CCAS Joué les Tours","Périscolaire","37300","JOUE LES TOURS","37122"]
[201800093,"ASSOC FAMILLES RURALES DU RIDELLOIS","Péri Assoc du Ridellois","Périscolaire","37190","AZAY LE RIDEAU","37014"]
[201800096,"COMMUNAUTE DE CNES CHINON VIENNE ET LOIRE","Péri Chinon Vienne et Loire","Périscolaire","37420","AVOINE","37011"]
[201800101,"COMMUNAUTE DE CNES LOCHES SUD TOURAINE","Péri Loches Sud Touraine","Périscolaire","37600","LOCHES","37132"]
[201400455,"ASSOC PUZZLE","Acc Ados Assoc Puzzle","Accueil Adolescents","37310","REIGNAC","37192"]
[201700034,"ASSOC LEO LAGRANGE","Acc Ados Léo Lagrange Bléré","Accueil Adolescents","37150","BLERE","37027"]
[201800084,"COMMUNAUTE DE CNES TOURAINE VALLEE DE L INDRE","Acc Ados Touraine Vallée Indre","Accueil Adolescents","37250","SORIGNY","37250"]
[201800195,"ASSOC CAMILLE CLAUDEL LA VILLE AUX DAMES","Acc Ados Assoc Camille Claudel","Accueil Adolescents","37700","VILLE AUX DAMES","37273"]
[201800196,"ASSOC CENTRE CULTUREL ET D ANIMATION DE L AUBRIERE","Acc Ados Espace Jeunes","Accueil Adolescents","37230","FONDETTES","37109"]
[201800197,"ASSOC CENTRE SOCIAL DE LA DOUVE","Acc Ados Assoc CS La Douve","Accueil Adolescents","37130","LANGEAIS","37123"]
[201800198,"ASSOC CLUB LOISIRS ET CULTURE ATHEE SUR CHER","Acc Ados Assoc Club Culture","Accueil Adolescents","37270","ATHEE SUR CHER","37008"]
[201800199,"ASSOC FED REG DES MJC","Acc Ados Fed Regionale des MJC","Accueil Adolescents","37380","REUGNY","37194"]
[201800200,"ASSOC GESTION CENTRE SOCIAL JULES VERNE","Acc Ados Assoc CS Jules Verne","Accueil Adolescents","37510","BALLAN MIRE","37018"]
[201800201,"ASSOC SOCIO CULTURELLE COURTELINE","Acc Ados Assoc Courteline","Accueil Adolescents","37000","TOURS","37261"]
[201800202,"CCAS LA RICHE","Acc Ados CCAS La Riche","Accueil Adolescents","37520","LA RICHE","37195"]
[201800203,"COMMUNAUTE DE CNES CHINON VIENNE ET LOIRE","Acc Ados Chinon Vienne & Loire","Accueil Adolescents","37500","CINAIS","37076"]
[201800205,"COMMUNAUTE DE CNES DE GATINE CHOISILLES PAYS DE RACAN","Acc Ados Cté de Cnes GCPR","Accueil Adolescents","37360","SAINT ANTOINE DU ROCHER","37206"]
[201800206,"COMMUNAUTE DE CNES LOCHES SUD TOURAINE","Acc Ados Loches Sud Touraine","Accueil Adolescents","37600","LOCHES","37132"]
[201800207,"COMMUNAUTE DE CNES TOURAINE EST VALLEES","Acc Ados Touraine Est Vallées","Accueil Adolescents","37270","VERETZ","37267"]
[201800208,"COMMUNAUTE DE CNES TOURAINE OUEST VAL DE LOIRE","Acc Ados Tne Ouest Val Loire","Accueil Adolescents","37140","BOURGUEIL","37031"]
[201800209,"COMMUNAUTE DE CNES TOURAINE VAL DE VIENNE","Acc Ados Touraine Val Vienne","Accueil Adolescents","37800","SAINTE MAURE DE TOURAINE","37226"]
[201800210,"MAIRIE DE CHANCEAUX SUR CHOISILLE","Acc Ados Mairie Chanceaux","Accueil Adolescents","37390","CHANCEAUX SUR CHOISILLE","37054"]
[201800211,"MAIRIE DE CHATEAU RENAULT","Acc Ados Château Renault","Accueil Adolescents","37110","CHATEAU RENAULT","37063"]
[201800212,"MAIRIE DE JOUE LES TOURS","Acc Ados Mairie Joué les Tours","Accueil Adolescents","37300","JOUE LES TOURS","37122"]
[201800213,"MAIRIE DE LUYNES","Acc Ados Mairie de Luynes","Accueil Adolescents","37230","LUYNES","37139"]
[201800214,"MAIRIE DE NOTRE DAME D'OE","Acc Ados Mairie Notre Dame Oe","Accueil Adolescents","37390","NOTRE DAME D'OE","37172"]
[201800215,"MAIRIE DE ST AVERTIN","Acc Ados Mairie Saint Avertin","Accueil Adolescents","37551","SAINT AVERTIN","37208"]
[201800216,"MAIRIE DE ST CYR SUR LOIRE","Acc Ados Mairie Saint Cyr","Accueil Adolescents","37540","SAINT CYR SUR LOIRE","37214"]

{"sheet":"Insee","index":5,"n_rows":280,"n_cols":15,"rows_kept":280,"cut":false,"hidden":true,"merged":[]}
["Commune","Code Postal","Code INSEE","CP Sans Doublon","Commune","Code Postal","Commune","Code Postal","Code INSEE",null,"Commune","Code Postal","Commune","Code Postal","Code INSEE"]
["?????","?????","?????","?????",null,"?????","?????","?????","?????",null,null,{"$f":"LOOKUP(9^9,'[2]Périscolaire Mixte'!D18:D48)","v":{"$error":"#N/A"}}]
["ABILLY",37160,37001,37000]
["AMBILLOU",37340,37002,37100]
["AMBOISE",37400,37003,37110]
["ANCHE",37500,37004,37120]
["ANTOGNY-LE-TILLAC",37800,37005,37130]
["ARTANNES-SUR-INDRE",37260,37006,37140]
["ASSAY",37120,37007,37150]
["ATHEE-SUR-CHER",37270,37008,37160]
["AUTRECHE",37110,37009,37170]
["AUZOUER-EN-TOURAINE",37110,37010,37190]
["AVOINE",37420,37011,37200]
["AVON-LES-ROCHES",37220,37012,37210]
["AVRILLE-LES-PONCEAUX",37340,37013,37220]
["AZAY-LE-RIDEAU",37190,37014,37230]
["AZAY-SUR-CHER",37270,37015,37240]
["AZAY-SUR-INDRE",37310,37016,37250]
["BALLAN-MIRE",37510,37018,37260]
["BARROU",37350,37019,37270]
["BEAULIEU-LES-LOCHES",37600,37020,37290]
["BEAUMONT-EN-VERON",37420,37022,37300]
["BEAUMONT-LOUESTAULT",37360,37021,37310]
["BEAUMONT-LOUESTAULT",37370,37021,37320]
["BEAUMONT-VILLAGE",37460,37023,37330]
["BENAIS",37140,37024,37340]
["BERTHENAY",37510,37025,37350]
["BETZ-LE-CHATEAU",37600,37026,37360]
["BLERE",37150,37027,37370]
["BOSSAY-SUR-CLAISE",37290,37028,37380]
["BOSSEE",37240,37029,37390]
["BOURGUEIL",37140,37031,37400]
["BOURNAN",37240,37032,37420]
["BOUSSAY",37290,37033,37460]
["BRASLOU",37120,37034,37500]
["BRAYE-SOUS-FAYE",37120,37035,37510]
["BRAYE-SUR-MAULNE",37330,37036,37520]
["BRECHES",37330,37037,37530]
["BREHEMONT",37130,37038,37540]
["BRIDORE",37600,37039,37550]
["BRIZAY",37220,37040,37600]
["BUEIL-EN-TOURAINE",37370,37041,37700]
["BUXEUIL",37160,86042,37800]
["CANDES-SAINT-MARTIN",37500,37042]
["CANGEY",37530,37043]
["CERE-LA-RONDE",37460,37046]
["CERELLES",37390,37047]
["CHAMBON",37290,37048]
["CHAMBOURG-SUR-INDRE",37310,37049]
["CHAMBRAY-LES-TOURS",37170,37050]
["CHAMPIGNY-SUR-VEUDE",37120,37051]
["CHANCAY",37210,37052]
["CHANCEAUX-PRES-LOCHES",37600,37053]
["CHANCEAUX-SUR-CHOISILLE",37390,37054]
["CHANNAY-SUR-LATHAN",37330,37055]
["CHARENTILLY",37390,37059]
["CHARGE",37530,37060]
["CHARNIZAY",37290,37061]
["CHATEAU-LA-VALLIERE",37330,37062]
["CHATEAU-RENAULT",37110,37063]
["CHAUMUSSAY",37350,37064]
["CHAVEIGNES",37120,37065]
["CHEDIGNY",37310,37066]
["CHEILLE",37190,37067]
["CHEMILLE-SUR-DEME",37370,37068]
["CHEMILLE-SUR-INDROIS",37460,37069]
["CHENONCEAUX",37150,37070]
["CHEZELLES",37220,37071]
["CHINON",37500,37072]
["CHISSEAUX",37150,37073]
["CHOUZE-SUR-LOIRE",37140,37074]
["CIGOGNE",37310,37075]
["CINAIS",37500,37076]
["CINQ-MARS-LA-PILE",37130,37077]
["CIRAN",37240,37078]
["CIVRAY-DE-TOURAINE",37150,37079]
["CIVRAY-SUR-ESVES",37160,37080]
["CLERE-LES-PINS",37340,37081]
["CONTINVOIR",37340,37082]
["CORMERY",37320,37083]
["COTEAUX-SUR-LOIRE",37130,37232]
["COTEAUX-SUR-LOIRE",37140,37232]
["COUESMES",37330,37084]
["COURCAY",37310,37085]
["COURCELLES-DE-TOURAINE",37330,37086]
["COURCOUE",37120,37087]
["COUZIERS",37500,37088]
["CRAVANT-LES-COTEAUX",37500,37089]
["CRISSAY-SUR-MANSE",37220,37090]
["CROTELLES",37380,37092]
["CROUZILLES",37220,37093]
["CUSSAY",37240,37094]
["DAME-MARIE-LES-BOIS",37110,37095]
["DESCARTES",37160,37115]
["DIERRE",37150,37096]
["DOLUS-LE-SEC",37310,37097]
["DRACHE",37800,37098]
["DRUYE",37190,37099]
["EPEIGNE-LES-BOIS",37150,37100]
["EPEIGNE-SUR-DEME",37370,37101]
["ESVES-LE-MOUTIER",37240,37103]
["ESVRES",37320,37104]
["FAYE-LA-VINEUSE",37120,37105]
["FERRIERE-LARCON",37350,37107]
["FERRIERE-SUR-BEAULIEU",37600,37108]
["FONDETTES",37230,37109]
["FRANCUEIL",37150,37110]
["GENILLE",37460,37111]
["GIZEUX",37340,37112]
["HOMMES",37340,37117]
["HUISMES",37420,37118]
["JAULNAY",37120,37121]
["JOUE-LES-TOURS",37300,37122]
["LA CELLE-GUENAND",37350,37044]
["LA CELLE-SAINT-AVANT",37160,37045]
["LA CHAPELLE-AUX-NAUX",37130,37056]
["LA CHAPELLE-BLANCHE-SAINT-MARTIN",37240,37057]
["LA CHAPELLE-SUR-LOIRE",37140,37058]
["LA CROIX-EN-TOURAINE",37150,37091]
["LA FERRIERE",37110,37106]
["LA GUERCHE",37350,37114]
["LA MEMBROLLE-SUR-CHOISILLE",37390,37151]
["LA RICHE",37520,37195]
["LA ROCHE-CLERMAULT",37500,37202]
["LA TOUR-SAINT-GELIN",37120,37260]
["LA VILLE-AUX-DAMES",37700,37273]
["LANGEAIS",37130,37123]
["LARCAY",37270,37124]
["LE BOULAY",37110,37030]
["LE GRAND-PRESSIGNY",37350,37113]
["LE LIEGE",37460,37127]
["LE LOUROUX",37240,37136]
["LE PETIT-PRESSIGNY",37350,37184]
["LEMERE",37120,37125]
["LERNE",37500,37126]
["LES HERMITES",37110,37116]
["LIGNIERES-DE-TOURAINE",37130,37128]
["LIGRE",37500,37129]
["LIGUEIL",37240,37130]
["L'ILE-BOUCHARD",37220,37119]
["LIMERAY",37530,37131]
["LOCHES",37600,37132]
["LOCHE-SUR-INDROIS",37460,37133]
["LOUANS",37320,37134]
["LUBLE",37330,37137]
["LUSSAULT-SUR-LOIRE",37400,37138]
["LUYNES",37230,37139]
["LUZE",37120,37140]
["LUZILLE",37150,37141]
["MAILLE",37800,37142]
["MANTHELAN",37240,37143]
["MARCAY",37500,37144]
["MARCE-SUR-ESVES",37160,37145]
["MARCILLY-SUR-MAULNE",37330,37146]
["MARCILLY-SUR-VIENNE",37800,37147]
["MARIGNY-MARMANDE",37120,37148]
["MARRAY",37370,37149]
["MAZIERES-DE-TOURAINE",37130,37150]
["METTRAY",37390,37152]
["MONNAIE",37380,37153]
["MONTBAZON",37250,37154]
["MONTHODON",37110,37155]
["MONTLOUIS-SUR-LOIRE",37270,37156]
["MONTRESOR",37460,37157]
["MONTREUIL-EN-TOURAINE",37530,37158]
["MONTS",37260,37159]
["MORAND",37110,37160]
["MOSNES",37530,37161]
["MOUZAY",37600,37162]
["NAZELLES-NEGRON",37530,37163]
["NEUIL",37190,37165]
["NEUILLE-LE-LIERRE",37380,37166]
["NEUILLE-PONT-PIERRE",37360,37167]
["NEUILLY-LE-BRIGNON",37160,37168]
["NEUVILLE-SUR-BRENNE",37110,37169]
["NEUVY-LE-ROI",37370,37170]
["NOIZAY",37210,37171]
["NOTRE-DAME-D'OE",37390,37172]
["NOUANS-LES-FONTAINES",37460,37173]
["NOUATRE",37800,37174]
["NOUZILLY",37380,37175]
["NOYANT-DE-TOURAINE",37800,37176]
["ORBIGNY",37460,37177]
["PANZOULT",37220,37178]
["PARCAY-MESLAY",37210,37179]
["PARCAY-SUR-VIENNE",37220,37180]
["PAULMY",37350,37181]
["PERNAY",37230,37182]
["PERRUSSON",37600,37183]
["POCE-SUR-CISSE",37530,37185]
["PONT-DE-RUAN",37260,37186]
["PORTS",37800,37187]
["POUZAY",37800,37188]
["PREUILLY-SUR-CLAISE",37290,37189]
["PUSSIGNY",37800,37190]
["RAZINES",37120,37191]
["REIGNAC-SUR-INDRE",37310,37192]
["RESTIGNE",37140,37193]
["REUGNY",37380,37194]
["RICHELIEU",37120,37196]
["RIGNY-USSE",37420,37197]
["RILLE",37340,37198]
["RILLY-SUR-VIENNE",37220,37199]
["RIVARENNES",37190,37200]
["RIVIERE",37500,37201]
["ROCHECORBON",37210,37203]
["ROUZIERS-DE-TOURAINE",37360,37204]
["SACHE",37190,37205]
["SAINT-ANTOINE-DU-ROCHER",37360,37206]
["SAINT-AUBIN-LE-DEPEINT",37370,37207]
["SAINT-AVERTIN",37550,37208]
["SAINT-BAULD",37310,37209]
["SAINT-BENOIT-LA-FORET",37500,37210]
["SAINT-BRANCHS",37320,37211]
["SAINT-CHRISTOPHE-SUR-LE-NAIS",37370,37213]
["SAINT-CYR-SUR-LOIRE",37540,37214]
["SAINTE-CATHERINE-DE-FIERBOIS",37800,37212]
["SAINTE-MAURE-DE-TOURAINE",37800,37226]
["SAINT-EPAIN",37800,37216]
["SAINT-ETIENNE-DE-CHIGNY",37230,37217]
["SAINT-FLOVIER",37600,37218]
["SAINT-GENOUPH",37510,37219]
["SAINT-GERMAIN-SUR-VIENNE",37500,37220]
["SAINT-HIPPOLYTE",37600,37221]
["SAINT-JEAN-SAINT-GERMAIN",37600,37222]
["SAINT-LAURENT-DE-LIN",37330,37223]
["SAINT-LAURENT-EN-GATINES",37380,37224]
["SAINT-MARTIN-LE-BEAU",37270,37225]
["SAINT-NICOLAS-DE-BOURGUEIL",37140,37228]
["SAINT-NICOLAS-DES-MOTETS",37110,37229]
["SAINT-OUEN-LES-VIGNES",37530,37230]
["SAINT-PATERNE-RACAN",37370,37231]
["SAINT-PIERRE-DES-CORPS",37700,37233]
["SAINT-QUENTIN-SUR-INDROIS",37310,37234]
["SAINT-REGLE",37530,37236]
["SAINT-ROCH",37390,37237]
["SAINT-SENOCH",37600,37238]
["SAUNAY",37110,37240]
["SAVIGNE-SUR-LATHAN",37340,37241]
["SAVIGNY-EN-VERON",37420,37242]
["SAVONNIERES",37510,37243]
["SAZILLY",37220,37244]
["SEMBLANCAY",37360,37245]
["SENNEVIERES",37600,37246]
["SEPMES",37800,37247]
["SEUILLY",37500,37248]
["SONZAY",37360,37249]
["SORIGNY",37250,37250]
["SOUVIGNE",37330,37251]
["SOUVIGNY-DE-TOURAINE",37530,37252]
["SUBLAINES",37310,37253]
["TAUXIGNY",37310,37254]
["TAVANT",37220,37255]
["THENEUIL",37220,37256]
["THILOUZE",37260,37257]
["THIZAY",37500,37258]
["TOURNON-SAINT-PIERRE",37290,37259]
["TOURS",37000,37261]
["TOURS",37100,37261]
["TOURS",37200,37261]
["TROGUES",37220,37262]
["TRUYES",37320,37263]
["VALLERES",37190,37264]
["VARENNES",37600,37265]
["VEIGNE",37250,37266]
["VERETZ",37270,37267]
["VERNEUIL-LE-CHATEAU",37120,37268]
["VERNEUIL-SUR-INDRE",37600,37269]
["VERNOU-SUR-BRENNE",37210,37270]
["VILLAINES-LES-ROCHERS",37190,37271]
["VILLANDRY",37510,37272]
["VILLEBOURG",37370,37274]
["VILLEDOMAIN",37460,37275]
["VILLEDOMER",37110,37276]
["VILLELOIN-COULANGE",37460,37277]
["VILLEPERDUE",37260,37278]
["VILLIERS-AU-BOUIN",37330,37279]
["VOU",37240,37280]
["VOUVRAY",37210,37281]
["YZEURES-SUR-CREUSE",37290,37282]

{"sheet":"Feuil1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}