{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["ACCUEIL","COORDONNEES DES STRUCTURES","COMITÉS ORGANISATEURS","DROITS D'INSCRIPTION","JUVENILE 1","JUVENILE 2","JUNIOR 1","JUNIOR 2","YOUTH","ADULTE","DUO_YOUTH","DUO ADULTE","GROUPE JUVENILE","GROUPE JUNIOR","GROUPE YOUTH","GROUPE ADULTE","FEUIL1"],"not_rendered":{"charts":0,"images":10,"macros":0,"external_links":3,"defined_names":4,"comments":0,"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":"ACCUEIL","index":0,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[33,1,33,12],[35,1,35,12],[19,0,19,4],[29,0,29,12],[30,1,30,12],[31,1,31,12],[32,1,32,12],[20,8,20,9],[13,0,13,7],[14,0,15,12],[12,6,12,8],[11,0,11,12],[16,0,16,4],[16,5,16,10],[7,0,7,12],[3,0,3,12],[9,0,9,12],[10,0,10,12],[12,0,12,5]]}
[]
[]
[]
["Madame, Monsieur,"]
[]
[{"$f":"CONCATENATE(\"Vous souhaitez vous inscrire à un championnat sélectif du Championnat de France de Danse Jazz : \",'COORDONNEES DES STRUCTURES'!$C$7,'COORDONNEES DES STRUCTURES'!$D$7)","v":"Vous souhaitez vous inscrire à un championnat sélectif du Championnat de France de Danse Jazz : 2023 / 2024"},null,null,null,null,null,null,null,2023,{"$f":"\"/\"& I6+1","v":"/2024"}]
[null,null,null,null,null,null,null,null,"Pour changer l'année sportive modifier cette date"]
["ATTENTION : AVANT TOUTE INSCRIPTION CHAQUE PARTICIPANT DOIT AVOIR LA LICENCE FEDERAL B : ( 21,00 euros)"]
[]
["Pour toute inscription, vous devez renseigner tous les onglets du présent fichier"]
["Les renseignements erronés vous suivrons pendant tout le parcours sélectif"]
["L'onglet coordonnées des structures doit être rempli correctement\nLa validation est obligatoire(elle bloque les paiements)\nLors des inscription les noms,prénoms et dates de naissance sont nécessaires au bon fonctionnement du programme "]
["Une fois complèté, vous devez nous le renvoyer par retour de mail à : ",null,null,null,null,null," champion.jazz@ffdanse.fr "]
[]
["En parallèle, vous devez expédier par courrier un chèque du montant des droits d'inscription calculés sur l'onglet \"droits d'inscription\" à l'adresse  du comité régional auquel vous êtes rattaché  voir sur l'onglet \"adresse des comités organisateurs\""]
[]
["Les variations imposées sont a charger sur le site :",null,null,null,null," ffdanse.fr/index.php/danse-artistique/reglements-et-inscriptions"]
[]
[]
["Vous avez besoin  d’une aide, d’un renseignement ? "]
["Nous vous répondrons très rapidement si vous adressez vos questions au mail suivant :",null,null,null,null,null,null,null,"champion.jazz@ffdanse.fr"]
[]
["Bien Cordialement"]
[]
["Fédération Française de Danse"]
["20 rue Saint Lazare"]
["75009 PARIS"]
[]
[]
["Suivi logiciel"]
["2017-09-16","supression  senior et mise a jour années"]
["2017-10-10","nouvelle mise en forme des inscriptions pour les professeurs"]
["2017-10-12","suppression cases inutiles"]
["2017-10-16","Finalisation textes"]
["2018-03-22","Reprise presentation et calcul des inscriptions"]
["1608/2019","mise a jour sur nouveau reglement 2020"]
["2019-09-12","Modification page accueil"]
["2020-10-07","nouveau logo mise a jour annee, changement titre youth adultes: variation personnelle"]
["2020-12-11","mise a jour des comites organisateurs"]
["2022-01-26","Mis presence soliste dans groupe"]
["2022-10-19","mise a jour suite au reglement 2022/2023"]

{"sheet":"COORDONNEES DES STRUCTURES","index":1,"n_rows":132,"n_cols":13,"rows_kept":132,"cut":false,"hidden":false,"merged":[[38,10,39,10],[25,1,25,8],[29,3,30,3],[28,3,28,6],[31,3,31,6],[32,3,32,6],[29,4,30,5],[26,1,26,8],[27,1,27,8],[1,0,1,8],[3,0,3,8],[5,0,5,8],[6,0,6,1],[8,0,8,8],[2,9,2,10],[16,0,16,8],[17,0,23,0],[10,0,10,8],[11,3,11,8],[12,3,12,8],[13,0,13,8],[14,0,15,1]]}
[]
["FEDERATION FRANÇAISE DE DANSE"]
[null,null,null,null,null,null,null,null,null,"nb danseurs"]
[{"$f":"CONCATENATE(\"FICHE D'ENGAGEMENT \",C7,D7)","v":"FICHE D'ENGAGEMENT 2023 / 2024"},null,null,null,null,null,null,null,null,"Juvenile1",{"$f":"'JUVENILE 1'!A4","v":0}]
[null,null,null,null,null,null,null,null,null,"Juvenile2",{"$f":"'JUVENILE 2'!A4","v":0}]
["CHAMPIONNAT DE FRANCE DE DANSE JAZZ",null,null,null,null,null,null,null,null,"Junior 1",{"$f":"'JUNIOR 1'!A4","v":0}]
["Année sportive : ",null,{"$f":"ACCUEIL!I6","v":2023},{"$f":"CONCATENATE(\" / \",C7+1)","v":" / 2024"},null,null,null,null,null,"Junior 2",{"$f":"'JUNIOR 2'!A4","v":0}]
[null,null,null,null,null,null,null,null,null,"Youth",{"$f":"YOUTH!A4","v":0}]
["NOTAS IMPORTANTS : \n\nLa structure est en charge de transmettre toutes les informations nécessaires aux candidats qu'elle inscrit.\nLa structure devra obligatoirement assurer l'encadrement des candidats qu'elle inscrit lors du concours.\n\n",null,null,null,null,null,null,null,null,"Adulte",{"$f":"ADULTE!A4","v":0}]
[null,null,null,null,null,null,null,null,null,"Duo youth",{"$f":"DUO_YOUTH!AB3","v":0},null,"BRETAGNE"]
["INFORMATIONS STRUCTURE",null,null,null,null,null,null,null,null,"Duo adultes",{"$f":"'DUO ADULTE'!AB3","v":0},null,"PAYS-DE-LA- LOIRE"]
["N° Affiliation","Département","Région","Nom de la Structure,  (si licence individuelle: marquer LICENCE INDIVIDUELLE)",null,null,null,null,null,"Groupe juvenile",{"$f":"'GROUPE JUVENILE'!AC3","v":0},null,"NOUVELLE-AQUITAINE"]
[null,null,null,null,null,null,null,null,null,"groupe junior",{"$f":"'GROUPE JUNIOR'!AC3","v":0},null,"OCCITANIE"]
["INFORMATIONS PERSONNE RESPONSABLE DE L'ENGAGEMENT",null,null,null,null,null,null,null,null,"groupe youth",{"$f":"'GROUPE YOUTH'!AC3","v":0},null,"PROVENCE-ALPES-CÔTE-D'AZUR"]
[null,null,"Prénom","Nom","Adresse courrier","CP","Ville","E-Mail","Téléphone Mobile ou fixe","groupe adulte",{"$f":"'GROUPE ADULTE'!AC3","v":0},null,"GRAND-EST"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BOURGOGNE-FRANCHE-COMTE"]
["SOLO : INFORMATIONS PROFESSEURS / CHOREGRAPHES ",null,null,null,null,null,null,null,null,"total danseur",{"$f":"SUM(K4:K15)","v":0},null,"AUVERGNE-RHÔNE-ALPES"]
[null,"Categorie","Prénom","Nom","Adresse courrier","CP","Ville","E-Mail","Téléphone Mobile ou fixe",null,null,null,"NORMANDIE"]
[null,"Juvénile 1",null,null,null,null,null,null,null,null,null,null,"HAUTS-DE-FRANCE"]
[null,"Juvénile 2",null,null,null,null,null,null,null,null,null,null,"CENTRE-VAL-DE-LOIRE"]
[null,"Junior 1",null,null,null,null,null,null,null,null,null,null,"ILE-DE-FRANCE"]
[null,"junior 2",null,null,null,null,null,null,null,null,null,null,"DOM-TOM"]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,"Ain (01)"]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,"Aisne (02)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Allier (03)"]
[null,"ATTENTION Valider votre fichier",null,null,null,null,null,null,null,{"$f":"IF(J33=TRUE,\"OUI\",\"NON\")","v":"NON"}]
[null,{"$f":"CONCATENATE(\"Votre stucture a pris connaissance du REGLEMENT DES CHAMPIONNATS DE DANSE JAZZ -  \", $C$7, $D$7,\" , elle s'engage à le respecter\")","v":"Votre stucture a pris connaissance du REGLEMENT DES CHAMPIONNATS DE DANSE JAZZ -  2023 / 2024 , elle s'engage à le respecter"},null,null,null,null,null,null,null,null,null,null,"Alpes-de-Haute-Provence (04)"]
[null,"Les informations rentrées dans ce fichier vous suivront pendant tout le parcours selectif",null,null,null,null,null,null,null,{"$f":"IF(C16<>\"\",TRUE,FALSE)","v":false},"prenom",null,"Hautes-Alpes (05)"]
[null,"Danseurs participant individuellement à une ou plusieurs épreuves",{"$f":"IF(J28<>\"\",\"Prénom responsable présent\",\"Prénom responsable manquant\")","v":"Prénom responsable présent"},"Ces informations sont obligatoires, la validation de votre fichier sera faite  quand toutes les données seront en vert",null,null,null,null,null,{"$f":"IF(D16<>\"\",TRUE,FALSE)","v":false},"nom"]
[null,{"$f":"K17","v":0},{"$f":"IF(J29=TRUE,\"Nom responsable présent\",\"Nom responsable manquant\")","v":"Nom responsable manquant"},{"$f":"IF($J$39=1,\"FICHIER NON VALIDABLE\",IF(J39=2,\"FICHIER VALIDABLE\",IF(J39=3,\"FICHIER VALIDÉ SANS PARTICIPANTS\",\"FICHIER VALIDÉ AVEC PARTICIPANT\")))","v":"FICHIER NON VALIDABLE"},{"$f":"IF(J33=TRUE,IF(AND(J28,J29),CONCATENATE(C16, \" \",D16, \"  certifie  avoir lu  et approuvé le règlement et assure que les données de ce document y sont conformes\"),\"\"),\"\")","v":""},null,{"$f":"IF(J33=TRUE,\"VOUS POUVEZ VALIDER          cliquer ci dessous\",\"\")","v":""},null,null,{"$f":"IF(D13<>\"\",TRUE,FALSE)","v":false},"ecole",null,"Alpes Maritimes (06)"]
[null,null,{"$f":"IF(J30=TRUE,\"Nom stucture présent\",\"Nom structure manquant\")","v":"Nom structure manquant"},{"$f":"IF($J$34=FALSE,\"FICHIER NON VALIDÉ\",IF($B$30=0,\"FICHIER VALIDÉ SANS PARTICIPANTS\",\"FICHIER VALIDÉ\"))","v":"FICHIER NON VALIDÉ"},null,null,null,null,null,{"$f":"IF(C13<>\"\",TRUE,FALSE)","v":false},"region",null,"Ardèche (07)"]
[null,null,{"$f":"IF(J31=TRUE,\"Nom Région présent\",\"Nom Région manquant\")","v":"Nom Région manquant"},null,null,null,null,null,null,{"$f":"IF(B13<>\"\",TRUE,FALSE)","v":false},"departement"]
[null,null,{"$f":"IF(J32=TRUE,\"Nom Département présent\",\"Nom Département manquant\")","v":"Nom Département manquant"},null,null,null,null,null,null,{"$f":"AND(J28,J29,J30,J31,J32)","v":false},"conformite",null,"Ardennes (08)"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G31=\"OUI\",TRUE,FALSE)","v":false},"validation",null,"Ariège (09)"]
[null,null,null,null,null,null,null,null,null,{"$f":"AND(J30,J31,J32,J33,J34)","v":false},"general",null,"Aube (10)"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B30>0,TRUE,FALSE)","v":false},"participants",null,"Aude (11)"]
[null,null,null,null,null,null,null,null,null,{"$f":"AND(J35,J36)","v":false},"general et participants",null,"Aveyron (12)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bouches-du-Rhône (13)"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($J$33=FALSE,1,IF(J34=FALSE,2,IF(J37=FALSE,3,4)))","v":1},"texte validation",null,"Calvados (14)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cantal (15)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Charente (16)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Charente-Maritime  (17)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cher (18)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Corrèze (19)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Corse-du-Sud (2A)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Haute Corse (2B)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Côte-d'Or (21)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Côtes d'Armor (22)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Creuse (23)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Dordogne (24)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Doubs (25)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Drôme (26)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Eure (27)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Eure-et-Loir (28)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Finistère (29)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gard (30)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Haute Garonne (31)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gers (32)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gironde (33)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hérault (34)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ille-et-Vilaine (35)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Indre (36)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Indre-et-Loire (37)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Isère (38)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jura (39)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Landes (40)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Loir-et-Cher (41)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Loire (42)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Haute Loire (43)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Loire Atlantique (44)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Loiret (45)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lot (46)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lot-et-Garonne (47)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lozère (48)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Maine-et-Loire (49)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Manche (50)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Marne (51)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Haute Marne (52)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mayenne (53)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Meurthe-et-Moselle (54)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Meuse (55)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Morbihan (56)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Moselle (57)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nièvre (58)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nord (59)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oise (60)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Orne (61)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pas-de-Calais (62)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Puy-de-Dôme (63)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pyrénées Atlantiques (64)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hautes Pyrénées (65)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pyrénées Orientales (66)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bas-Rhin (67)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Haut-Rhin (68)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rhône (69)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Haute Saône (70)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Saône-et-Loire (71)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sarthe (72)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Savoie (73)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Haute Savoie (74)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Paris (75)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Seine Maritime (76)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Seine-et-Marne  (77)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Yvelines (78)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Deux-Sèvres (79)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Somme (80)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tarn (81)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tarn-et-Garonne (82)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Var (83)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vaucluse (84)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vendée (85)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vienne (86)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Haute Vienne (87)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vosges (88)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Yonne (89)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Territoire de Belfort (90)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Essonne (91)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hauts-de-Seine (92)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Seine-St-Denis (93)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Val-de-Marne (94)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Val-D'Oise (95)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Guadeloupe (971)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Martinique (972)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Guyane (973)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"La Réunion (974)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Saint Pierre et Miquelon(975)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mayotte (976)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Saint Martin(978)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Wallis et Futumas(986)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Polynésie(987)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nouvelle Calédonie(988)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Monaco(980)"]

{"sheet":"COMITÉS ORGANISATEURS","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,3,3,3]]}
["PAIEMENT DES DROITS D'INSCRIPTION A L'ADRESSE DU COMITE ORGANISANT VOTRE CHAMPIONNAT REGIONAL"]
[]
["QUALIFICATIONS","REGIONS","DEPARTEMENTS","ENVOI DU PAIEMENT"]
["REGIONALES ou INTER-REGIONALES","CONCERNÉES","CONCERNÉS"]
["Championnat régional Bretagne\n\nbretagne@ffdanse.fr\n\nTél : 06 87 49 69 14\n\n","Bretagne","22 – 29 – 35 – 56","C.R.DANSE DE BRETAGNE\n\nchez Mme Gisèle FELIN\n177 St michel\n22290 PLEHEDEL"]
["Championnat régional Pays de Loire\n\n vendee@ffdanse.fr\n \nTél : 06 13 57 33 61\n","Pays de loire","44 - 49 - 53 - 72 - 85","\nC.D VENDEE\nchez Mme Françoise Nomballais                 6 Allée du Vermenou                               85180 Le Château d'Olonne\n"]
["Championnat  régional Nouvelle Aquitaine\n\namvialard@ffdanse.fr                   \n\nTél : 06 82 90 65 55\n","Nouvelle Aquitaine\n","16 – 17 - 19 – 23 - 24 – 33 – 40\n 47 – 64 – 65 – 79 – 86 - 87","C.R. DANSE NOUVELLE AQUITAINE\n\nChez Mme Anne-Marie VIALARD\n7 avenue Franconi\n24750 TRELISSAC"]
["Championnat régional Occitanie\n\n castruc@ffdanse.fr \n\nTél : 06 16 29 30 98\n\n","Occitanie","09 – 11 - 12 – 30 - 31 – 32 – 34\n46 – 47 – 48 – 66 – 81 - 82   ","\nC.R. DANSE OCCITANIE\n\nChez Mme Isabelle JULIAT\n4 Avenue Grandidier\n31500 TOULOUSE\n\n\n"]
["Championnat régional PACA \n\naolivegauthier@ffdanse.fr\n\n   Tél : 06 76 60 17 49\n\n","Provence Alpes Côte d’Azur\n, Corse, Monaco","04 – 05 – 06 – 13 – 2A – 2B – 83 – 84 - 999 Monaco","C.R. DANSE PACA\n\nChez Mr. Jean VAGNOL\n25 Domaine de Freiresque\n13660 ORGON\n"]
["Championnat régional Grand Est\n\ngrand.est@ffdanse.fr\n\nTél : 06 22 28 88 19\n","Grand-Est","08 – 10  – 51 – 52 – 54 – 55 – 57 – 67 – 68  – 88","C.R. DANSE Grand Est\n\nchez Mr Quentin Schmit\n22 chemin des vignerons\n57070 METZ\n"]
["Championnat inter-régional Ile de France  - Centre Val de Loire et DOM TOM\n\nile.de.france@ffdanse.fr\n\nOlivia AYISSI NDZANA\n\nTél: 06 64 45 22 16\n\n","\nIle de France, \nCentre Val de Loire, \net  DOM-TOM\n(Excepté si les comités régionaux de ces territoires organisent un championnat régional)","18 – 28 – 36 – 37 – 41 – 45 – 75 – 77 – 78 – 80 – 91 – 92 – 93 – 94 – 95 – 971 – 972 – 973 – 974 - 976 ","C.R. DANSE ILE DE FRANCE\n\nCRDIS\n10 Route Vauhallan\n91430 IGNY"]
["Championnat inter-régional Normandie\n\nAnnie TREUIL CHERON\neure@ffdanse.fr\n\nTél : 06 82 10 19 40\n","Normandie,Hauts de France\n","02 -14 - 27 - 50 - 59 - 60 - 61 - 62 - 76 - 80 ","Comité Départemental de Danse de l'EURE\n\n6 rue d'Argence\n27930 Gravigny\n"]
["Championnat inter-régional \nAuvergne Rhône-Alpes\n\nchampion.jazz@ffdanse.fr\nTel: 06 16 29 30 98\n\n","\nAuverne-Rhône-Alpes, Bourgone Franche-Comté","01 – 03 – 07 – 15 – 21 – 25 – 26 – 38 – 39 – 58 – 42 – 43 – 63 – 69 – 70 – 71 – 73 – 74 – 89 - 90 ","C.R.DANSE AUVERGNE- RHÔNE ALPES\n\nchez Mr Gilbert Chemin\n154 Montée des Clarines\n38560 JARRIE"]

{"sheet":"DROITS D'INSCRIPTION","index":3,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[18,8,20,14],[21,0,21,2],[21,8,24,14],[14,0,17,0],[14,3,17,3],[14,4,17,4],[14,5,17,5],[14,8,14,14],[15,8,16,14],[17,8,17,14],[0,0,0,15],[1,0,1,15],[6,0,11,0],[6,3,11,3],[6,4,11,4],[6,5,11,5],[9,8,9,14],[10,8,10,14],[11,8,13,14],[12,0,13,0],[12,3,13,3],[12,4,13,4],[12,5,13,5],[5,8,7,14],[8,8,8,14],[3,0,4,5]]}
["CALCUL AUTOMATIQUE  DU NOMBRE D'INSCRITS ET DU MONTANT DES DROITS D'INSCRIPTION"]
["Les droits d'inscription sont à régler par chèque bancaire libellé à l'ordre du comité Régional organisateur auquel vous êtes rattaché"]
[]
[{"$f":"IF(A6=TRUE,\"LE DOSSIER A ÉTÉ VALIDÉ\",\"LE DOSSIER N'A PAS ÉTÉ VALIDÉ  VOIR COORDONNÉES DE STRUCTURE\")","v":"LE DOSSIER N'A PAS ÉTÉ VALIDÉ  VOIR COORDONNÉES DE STRUCTURE"}]
[]
[{"$f":"'COORDONNEES DES STRUCTURES'!J35","v":false},null,"Nombre de","Nb total","Droit",null,null,null,"Attention ce tableau se remplit automatiquement\n en fonction de vos inscriptions !"]
["SOLISTE","JUVENILES 1",{"$f":"IF(A6=TRUE,'JUVENILE 1'!A4,0)","v":0},{"$f":"SUM(C7:C12)","v":0},{"$f":"FEUIL1!E19","v":10},{"$f":"D7*E7","v":0}]
[null,"JUVENILES 2",{"$f":"IF(A6=TRUE,'JUVENILE 2'!A4,0)","v":0}]
[null,"JUNIORS 1",{"$f":"IF(A6=TRUE,'JUNIOR 1'!A4,0)","v":0},null,null,null,null,null,"si il est vide Validez  votre inscription dans l'onglet COORDONNEES DES STRUCTURES"]
[null,"JUNIORS 2",{"$f":" IF(A6=TRUE,'JUNIOR 2'!A4,0)","v":0},null,null,null,null,null,"Les nombres sont le reflet d'une inscription correcte"]
[null,"YOUTH",{"$f":"IF(A6=TRUE,YOUTH!A4,0)","v":0},null,null,null,null,null,"Si il y a des écarts vérifiez vos inscriptions :"]
[null,"ADULTES",{"$f":"IF(A6=TRUE,ADULTE!A4,0)","v":0},null,null,null,null,null,"Noms et prénoms pour les solos\n2 noms et 2 prénoms pour les duos\nLe titre dela chorégraphie pour les groupes"]
["DUO","Youth",{"$f":"IF(A6=TRUE,DUO_YOUTH!A5,0)","v":0},{"$f":"SUM(C13:C14)","v":0},{"$f":"FEUIL1!E20","v":20},{"$f":"D13*E13","v":0}]
[null,"Adultes",{"$f":"IF(A6=TRUE,'DUO ADULTE'!A5,0)","v":0}]
["GROUPE","JUVENILES",{"$f":"IF(A6=TRUE,'GROUPE JUVENILE'!A2,0)","v":0},{"$f":"SUM(C15:C18)","v":0},{"$f":"FEUIL1!E21","v":30},{"$f":"D15*E15","v":0},null,null,{"$f":"CONCATENATE(\"Ce calcul se fait sur la base des droits maximums autorisés : \",FEUIL1!E19,\"  ,  \",FEUIL1!E20,\"  ,  \",FEUIL1!E21, \"  Euros\")","v":"Ce calcul se fait sur la base des droits maximums autorisés : 10  ,  20  ,  30  Euros"}]
[null,"JUNIORS",{"$f":"IF(A6=TRUE,'GROUPE JUNIOR'!A2,0)","v":0},null,null,null,null,null,"Avant paiement, vérifier auprès de votre comité régional organisateur le montant demandé par prestation qui peut être inférieur"]
[null,"YOUTH",{"$f":"IF(A6=TRUE,'GROUPE YOUTH'!A2,0)","v":0},null,null,{"$f":"D17*E17","v":0}]
[null,"ADULTES",{"$f":"IF(A6=TRUE,'GROUPE ADULTE'!A2,0)","v":0},null,null,null,null,null,"(voir coordonnées sur onglet suivant)"]
[null,null,null,null,null,null,null,null,"Le total à payer se calcule automatiquement"]
[]
[]
["TOTAL A PAYER",null,null,null,null,{"$f":"F7+F13+F15","v":0},null,null,"Pour information, en cas de sélections pour le championnat de France,  des droits d'inscription seront à régler au moment de votre confirmation de participation."]

{"sheet":"JUVENILE 1","index":4,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,5],[1,0,1,3],[2,0,2,5]]}
["SOLISTE ",null,null,null,"Date de naissance entre  le:"]
["JUVENILE 1",null,null,null,{"$f":"FEUIL1!I3","v":"2014-01-01"},{"$f":"FEUIL1!J3","v":"2015-12-31"}]
["DANSEURS"]
[{"$f":"SUM(G5:G43)","v":0},"Catégorie","Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"annee","mois","jour"]
[null,{"$f":"PROPER($A$2)","v":"Juvenile 1"},null,null,null,null,{"$f":"IF(AND(C5<>\"\",D5<>\"\",E5>0)=TRUE,1,0)","v":0},{"$f":"IF(C5<>\"\",TEXT(E5,\"aaaa\"),\"\")","v":""},{"$f":"IF(C5<>\"\",TEXT(E5,\"mm\"),\"\")","v":""},{"$f":"IF(C5<>\"\",TEXT(E5,\"jj\"),\"\")","v":""},{"$f":"IF($C5<>\"\",LEFT($C5,3)&\"-\"&LEFT($D5,2),\"\")","v":""},{"$f":"IF(AND(G5>0,H5>0,I5>0,J5<>\"\"),CONCATENATE(H5,I5,J5,\"-\",K5),\"\")","v":""}]
[null,"Juvenile 1",null,null,null,null,{"$f":"IF(AND(C6<>\"\",D6<>\"\",E6>0)=TRUE,1,0)","v":0},{"$f":"IF(C6<>\"\",TEXT(E6,\"aaaa\"),\"\")","v":""},{"$f":"IF(C6<>\"\",TEXT(E6,\"mm\"),\"\")","v":""},{"$f":"IF(C6<>\"\",TEXT(E6,\"jj\"),\"\")","v":""},"",{"$f":"IF(AND(G6>0,H6>0,I6>0,J6<>\"\"),CONCATENATE(H6,I6,J6,\"-\",K6),\"\")","v":""}]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]
[null,"Juvenile 1",null,null,null,null,0,"","","","",""]

{"sheet":"JUVENILE 2","index":5,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,5],[1,0,1,3],[2,0,2,5]]}
["SOLISTE ",null,null,null,"Date de naissance entre  le:"]
["JUVENILE 2",null,null,null,{"$f":"FEUIL1!I4","v":"2013-01-01"},{"$f":"FEUIL1!J4","v":"2013-12-31"}]
["DANSEURS"]
[{"$f":"SUM(G5:G43)","v":0},"Catégorie","Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence"]
[null,{"$f":"PROPER($A$2)","v":"Juvenile 2"},null,null,null,null,{"$f":"IF(AND(C5<>\"\",D5<>\"\",E5>0)=TRUE,1,0)","v":0},{"$f":"IF(C5<>\"\",TEXT(E5,\"aaaa\"),\"\")","v":""},{"$f":"IF(C5<>\"\",TEXT(E5,\"mm\"),\"\")","v":""},{"$f":"IF(C5<>\"\",TEXT(E5,\"jj\"),\"\")","v":""},{"$f":"IF($C5<>\"\",LEFT($C5,3)&\"-\"&LEFT($D5,2),\"\")","v":""},{"$f":"IF(AND(G5>0,H5>0,I5>0,J5<>\"\"),CONCATENATE(H5,I5,J5,\"-\",K5),\"\")","v":""}]
[null,"Juvenile 2",null,null,null,null,{"$f":"IF(AND(C6<>\"\",D6<>\"\",E6>0)=TRUE,1,0)","v":0},{"$f":"IF(C6<>\"\",TEXT(E6,\"aaaa\"),\"\")","v":""},{"$f":"IF(C6<>\"\",TEXT(E6,\"mm\"),\"\")","v":""},{"$f":"IF(C6<>\"\",TEXT(E6,\"jj\"),\"\")","v":""},"",{"$f":"IF(AND(G6>0,H6>0,I6>0,J6<>\"\"),CONCATENATE(H6,I6,J6,\"-\",K6),\"\")","v":""}]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]
[null,"Juvenile 2",null,null,null,null,0,"","","","",""]

{"sheet":"JUNIOR 1","index":6,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,5],[1,0,1,3],[2,0,2,5]]}
["SOLISTE ",null,null,null,"Date de naissance entre  le:"]
["JUNIOR 1",null,null,null,{"$f":"FEUIL1!I5","v":"2011-01-01"},{"$f":"FEUIL1!J5","v":"2012-12-31"}]
["DANSEURS"]
[{"$f":"SUM(G5:G43)","v":0},"Catégorie","Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence"]
[null,{"$f":"PROPER($A$2)","v":"Junior 1"},null,null,null,null,{"$f":"IF(AND(C5<>\"\",D5<>\"\",E5>0)=TRUE,1,0)","v":0},{"$f":"IF(C5<>\"\",TEXT(E5,\"aaaa\"),\"\")","v":""},{"$f":"IF(C5<>\"\",TEXT(E5,\"mm\"),\"\")","v":""},{"$f":"IF(C5<>\"\",TEXT(E5,\"jj\"),\"\")","v":""},{"$f":"IF($C5<>\"\",LEFT($C5,3)&\"-\"&LEFT($D5,2),\"\")","v":""},{"$f":"IF(AND(G5>0,H5>0,I5>0,J5<>\"\"),CONCATENATE(H5,I5,J5,\"-\",K5),\"\")","v":""}]
[null,"Junior 1",null,null,null,null,{"$f":"IF(AND(C6<>\"\",D6<>\"\",E6>0)=TRUE,1,0)","v":0},{"$f":"IF(C6<>\"\",TEXT(E6,\"aaaa\"),\"\")","v":""},{"$f":"IF(C6<>\"\",TEXT(E6,\"mm\"),\"\")","v":""},{"$f":"IF(C6<>\"\",TEXT(E6,\"jj\"),\"\")","v":""},"",{"$f":"IF(AND(G6>0,H6>0,I6>0,J6<>\"\"),CONCATENATE(H6,I6,J6,\"-\",K6),\"\")","v":""}]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]
[null,"Junior 1",null,null,null,null,0,"","","","",""]

{"sheet":"JUNIOR 2","index":7,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,5],[1,0,1,3],[2,0,2,5]]}
["SOLISTE ",null,null,null,"Date de naissance entre  le:"]
["JUNIOR 2",null,null,null,{"$f":"FEUIL1!I6","v":"2009-01-01"},{"$f":"FEUIL1!J6","v":"2010-12-31"}]
["DANSEURS"]
[{"$f":"SUM(G5:G43)","v":0},"Catégorie","Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence"]
[null,{"$f":"PROPER($A$2)","v":"Junior 2"},null,null,null,null,{"$f":"IF(AND(C5<>\"\",D5<>\"\",E5>0)=TRUE,1,0)","v":0},{"$f":"IF(C5<>\"\",TEXT(E5,\"aaaa\"),\"\")","v":""},{"$f":"IF(C5<>\"\",TEXT(E5,\"mm\"),\"\")","v":""},{"$f":"IF(C5<>\"\",TEXT(E5,\"jj\"),\"\")","v":""},{"$f":"IF($C5<>\"\",LEFT($C5,3)&\"-\"&LEFT($D5,2),\"\")","v":""},{"$f":"IF(AND(G5>0,H5>0,I5>0,J5<>\"\"),CONCATENATE(H5,I5,J5,\"-\",K5),\"\")","v":""}]
[null,"Junior 2",null,null,null,null,{"$f":"IF(AND(C6<>\"\",D6<>\"\",E6>0)=TRUE,1,0)","v":0},{"$f":"IF(C6<>\"\",TEXT(E6,\"aaaa\"),\"\")","v":""},{"$f":"IF(C6<>\"\",TEXT(E6,\"mm\"),\"\")","v":""},{"$f":"IF(C6<>\"\",TEXT(E6,\"jj\"),\"\")","v":""},"",{"$f":"IF(AND(G6>0,H6>0,I6>0,J6<>\"\"),CONCATENATE(H6,I6,J6,\"-\",K6),\"\")","v":""}]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]
[null,"Junior 2",null,null,null,null,0,"","","","",""]

{"sheet":"YOUTH","index":8,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,9],[0,10,0,11],[1,0,1,9],[2,0,2,5],[2,7,2,11]]}
["SOLISTE",null,null,null,null,null,null,null,null,null,"Date de naissance entre  le:"]
["YOUTH",null,null,null,null,null,null,null,null,null,{"$f":"FEUIL1!I7","v":"2006-01-01"},{"$f":"FEUIL1!J7","v":"2008-12-31"}]
["DANSEURS",null,null,null,null,null,null,"Composition Personnelle"]
[{"$f":"SUM(M5:M43)","v":0},"Catégorie","Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Titre Composition personnelle\n","Durée","Titre Musique","Compositeur","Décors et accessoires"]
[null,{"$f":"PROPER($A$2)","v":"Youth"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C5<>\"\",D5<>\"\",E5>0)=TRUE,1,0)","v":0},{"$f":"IF(E5<>\"\",TEXT(E5,\"aaaa\"),\"\")","v":""},{"$f":"IF(E5<>\"\",TEXT(E5,\"mm\"),\"\")","v":""},{"$f":"IF(E5<>\"\",TEXT(E5,\"jj\"),\"\")","v":""},{"$f":"IF($C5<>\"\",LEFT($C5,3)&\"-\"&LEFT($D5,2),\"\")","v":""},{"$f":"IF(AND(C5>0,D5>0,E5>0,P5<>\"\"),CONCATENATE(N5,O5,P5,\"-\",Q5),\"\")","v":""}]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C6<>\"\",D6<>\"\",E6>0)=TRUE,1,0)","v":0},{"$f":"IF(E6<>\"\",TEXT(E6,\"aaaa\"),\"\")","v":""},{"$f":"IF(E6<>\"\",TEXT(E6,\"mm\"),\"\")","v":""},{"$f":"IF(E6<>\"\",TEXT(E6,\"jj\"),\"\")","v":""},"",{"$f":"IF(AND(M6>0,N6>0,O6>0,P6<>\"\"),CONCATENATE(N6,O6,P6,\"-\",Q6),\"\")","v":""}]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]
[null,"Youth",null,null,null,null,null,null,null,null,null,null,0,"","","","",""]

{"sheet":"ADULTE","index":9,"n_rows":43,"n_cols":19,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,9],[0,10,0,11],[1,0,1,9],[2,0,2,5],[2,7,2,11]]}
["SOLISTE",null,null,null,null,null,null,null,null,null,"Date de naissance entre  le:"]
["ADULTE",null,null,null,null,null,null,null,null,null,{"$f":"FEUIL1!I8","v":"1925-01-01"},{"$f":"FEUIL1!J8","v":"2005-12-31"}]
["DANSEURS",null,null,null,null,null,null,"Composition Personnelle"]
[{"$f":"SUM(M5:M43)","v":0},"Catégorie","Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Titre composition personnelle\n","Durée","Titre Musique","Compositeur","Décors et accessoires"]
[null,{"$f":"PROPER($A$2)","v":"Adulte"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C5<>\"\",D5<>\"\",E5>0)=TRUE,1,0)","v":0},{"$f":"IF(E5<>\"\",TEXT(E5,\"aaaa\"),\"\")","v":""},{"$f":"IF(E5<>\"\",TEXT(E5,\"mm\"),\"\")","v":""},{"$f":"IF(E5<>\"\",TEXT(E5,\"jj\"),\"\")","v":""},{"$f":"IF($C5<>\"\",LEFT($C5,3)&\"-\"&LEFT($D5,2),\"\")","v":""},{"$f":"IF(AND(C5>0,D5>0,E5>0,P5<>\"\"),CONCATENATE(N5,O5,P5,\"-\",Q5),\"\")","v":""},{"$f":"IF(AND(D5>0,E5>0,F5>0,Q5<>\"\"),CONCATENATE(O5,P5,Q5,\"-\",R5),\"\")","v":""}]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C6<>\"\",D6<>\"\",E6>0)=TRUE,1,0)","v":0},{"$f":"IF(I6<>\"\",TEXT(K6,\"aaaa\"),\"\")","v":""},{"$f":"IF(I6<>\"\",TEXT(K6,\"mm\"),\"\")","v":""},{"$f":"IF(I6<>\"\",TEXT(K6,\"jj\"),\"\")","v":""},"",{"$f":"IF(AND(M6>0,N6>0,O6>0,P6<>\"\"),CONCATENATE(N6,O6,P6,\"-\",Q6),\"\")","v":""},{"$f":"IF(AND(N6>0,O6>0,P6>0,Q6<>\"\"),CONCATENATE(O6,P6,Q6,\"-\",R6),\"\")","v":""}]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]
[null,"Adulte",null,null,null,null,null,null,null,null,null,null,0,"","","","","",""]

{"sheet":"DUO_YOUTH","index":10,"n_rows":57,"n_cols":29,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,26,3,26],[6,15,7,15],[9,15,10,15],[12,15,13,15],[0,0,0,13],[0,14,0,15],[1,0,1,13],[2,0,2,15],[3,0,3,3],[3,4,3,7],[3,8,3,12],[3,13,3,14],[3,15,4,15]]}
["DUO YOUTH",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date de naissance entre:",null,null,null,null,null,"inscrit duo youth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FEUIL1!$I$10","v":"2006-01-01"},{"$f":"FEUIL1!$J$10","v":"2008-12-31"},null,null,null,null,"nom","prenom","naissance","lic recons "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nb danseur uniquement duo",{"$f":"AB8","v":0}]
["CHOREGRAPHIE",null,null,null,"DANSEURS",null,null,null,"CHOREGRAPHE",null,null,null,null,"MUSIQUES UTILISEES",null,"Observations",null,null,null,null,"inscription youth"]
[{"$f":"AB9","v":0},"Titre Chorégraphie","Minutage","Décor","NOM\n(les 2 noms sont obligatoires)","Prénom\n(Les 2 prénoms sont obligatoires)","Date de naissance\n(obligatoire)","N° Licence","Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",null,null,null,null,"reference solo","nom groupr","prenom groupe","naissance groupe","lic recons  groupe",null,"danseurs 2 categories","danseurs groupe"]
[null,null,null,"(oui/non)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nb danseur",{"$f":"AB7","v":0}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lic recons ",null,null,null,null,null,{"$f":"SUM(Z8:Z13)","v":0},{"$f":"SUM(AA8:AA13)","v":0},{"$f":"AA7","v":0},"nb total danseur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(YOUTH!R5=\"\",\"\",YOUTH!R5)","v":""},{"$f":"IF(E7=\"\",\"\",LEFT(E7,3))","v":""},{"$f":"IF(F7=\"\",\"\",LEFT(F7,2))","v":""},{"$f":"IF(G7>0,CONCATENATE(TEXT(G7,\"aaaa\"),TEXT(G7,\"mm\"),TEXT(G7,\"jj\")),\"\")","v":""},{"$f":"IF(U8<>\"\",CONCATENATE(W8,\"-\",U8,\"-\",V8),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X8,$T$5:$X$55,1,FALSE),0)","v":""},{"$f":"IF(OR(Y8=0,Y8=\"\"),0,1)","v":0},{"$f":"IF(X8<>\"\",1,0)","v":0},{"$f":"AB7-Z7","v":0},"nb dans groupe uniquement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(YOUTH!R6=\"\",\"\",YOUTH!R6)","v":""},{"$f":"IF(E8=\"\",\"\",LEFT(E8,3))","v":""},{"$f":"IF(F8=\"\",\"\",LEFT(F8,2))","v":""},{"$f":"IF(G8>0,CONCATENATE(TEXT(G8,\"aaaa\"),TEXT(G8,\"mm\"),TEXT(G8,\"jj\")),\"\")","v":""},{"$f":"IF(U9<>\"\",CONCATENATE(W9,\"-\",U9,\"-\",V9),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X9,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y9=0,Y9=\"\"),0,1)","v":0},{"$f":"IF(X9<>\"\",1,0)","v":0},{"$f":"INT(AB7/2)","v":0},"nb duo"]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(YOUTH!R7=\"\",\"\",YOUTH!R7)","v":""},{"$f":"IF(E10=\"\",\"\",LEFT(E10,3))","v":""},{"$f":"IF(F10=\"\",\"\",LEFT(F10,2))","v":""},{"$f":"IF(G10>0,CONCATENATE(TEXT(G10,\"aaaa\"),TEXT(G10,\"mm\"),TEXT(G10,\"jj\")),\"\")","v":""},{"$f":"IF(U10<>\"\",CONCATENATE(W10,\"-\",U10,\"-\",V10),\"\")","v":""},"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(YOUTH!R8=\"\",\"\",YOUTH!R8)","v":""},{"$f":"IF(E11=\"\",\"\",LEFT(E11,3))","v":""},{"$f":"IF(F11=\"\",\"\",LEFT(F11,2))","v":""},{"$f":"IF(G11>0,CONCATENATE(TEXT(G11,\"aaaa\"),TEXT(G11,\"mm\"),TEXT(G11,\"jj\")),\"\")","v":""},"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(YOUTH!R9=\"\",\"\",YOUTH!R9)","v":""},{"$f":"IF(E13=\"\",\"\",LEFT(E13,3))","v":""},{"$f":"IF(F13=\"\",\"\",LEFT(F13,2))","v":""},{"$f":"IF(G13>0,CONCATENATE(TEXT(G13,\"aaaa\"),TEXT(G13,\"mm\"),TEXT(G13,\"jj\")),\"\")","v":""},"","",0,0]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(YOUTH!R10=\"\",\"\",YOUTH!R10)","v":""},{"$f":"IF(E14=\"\",\"\",LEFT(E14,3))","v":""},{"$f":"IF(F14=\"\",\"\",LEFT(F14,2))","v":""},{"$f":"IF(G14>0,CONCATENATE(TEXT(G14,\"aaaa\"),TEXT(G14,\"mm\"),TEXT(G14,\"jj\")),\"\")","v":""},"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(YOUTH!R11=\"\",\"\",YOUTH!R11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF(YOUTH!R12=\"\",\"\",YOUTH!R12)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"IF(YOUTH!R13=\"\",\"\",YOUTH!R13)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF(YOUTH!R14=\"\",\"\",YOUTH!R14)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF(YOUTH!R15=\"\",\"\",YOUTH!R15)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF(YOUTH!R16=\"\",\"\",YOUTH!R16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF(YOUTH!R17=\"\",\"\",YOUTH!R17)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF(YOUTH!R18=\"\",\"\",YOUTH!R18)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"IF(YOUTH!R19=\"\",\"\",YOUTH!R19)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(YOUTH!R20=\"\",\"\",YOUTH!R20)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(YOUTH!R21=\"\",\"\",YOUTH!R21)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF(YOUTH!R22=\"\",\"\",YOUTH!R22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF(YOUTH!R23=\"\",\"\",YOUTH!R23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF(YOUTH!R24=\"\",\"\",YOUTH!R24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF(YOUTH!R25=\"\",\"\",YOUTH!R25)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF(YOUTH!R26=\"\",\"\",YOUTH!R26)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF(YOUTH!R27=\"\",\"\",YOUTH!R27)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(YOUTH!R28=\"\",\"\",YOUTH!R28)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF(YOUTH!R29=\"\",\"\",YOUTH!R29)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF(YOUTH!R30=\"\",\"\",YOUTH!R30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF(YOUTH!R31=\"\",\"\",YOUTH!R31)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF(YOUTH!R32=\"\",\"\",YOUTH!R32)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"IF(YOUTH!R33=\"\",\"\",YOUTH!R33)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"IF(YOUTH!R34=\"\",\"\",YOUTH!R34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF(YOUTH!R35=\"\",\"\",YOUTH!R35)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF(YOUTH!R36=\"\",\"\",YOUTH!R36)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF(YOUTH!R37=\"\",\"\",YOUTH!R37)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF(YOUTH!R38=\"\",\"\",YOUTH!R38)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF(YOUTH!R39=\"\",\"\",YOUTH!R39)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF(YOUTH!R40=\"\",\"\",YOUTH!R40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF(YOUTH!R41=\"\",\"\",YOUTH!R41)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF(YOUTH!R42=\"\",\"\",YOUTH!R42)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF(YOUTH!R43=\"\",\"\",YOUTH!R43)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF(YOUTH!R44=\"\",\"\",YOUTH!R44)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"IF(YOUTH!R45=\"\",\"\",YOUTH!R45)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"IF(YOUTH!R46=\"\",\"\",YOUTH!R46)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF(YOUTH!R47=\"\",\"\",YOUTH!R47)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF(YOUTH!R48=\"\",\"\",YOUTH!R48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF(YOUTH!R49=\"\",\"\",YOUTH!R49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF(YOUTH!R50=\"\",\"\",YOUTH!R50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF(YOUTH!R51=\"\",\"\",YOUTH!R51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF(YOUTH!R52=\"\",\"\",YOUTH!R52)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF(YOUTH!R53=\"\",\"\",YOUTH!R53)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(YOUTH!R54=\"\",\"\",YOUTH!R54)","v":""}]

{"sheet":"DUO ADULTE","index":11,"n_rows":57,"n_cols":29,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,26,3,26],[6,15,7,15],[9,15,10,15],[12,15,13,15],[0,0,0,13],[0,14,0,15],[1,0,1,13],[2,0,2,15],[3,0,3,3],[3,4,3,7],[3,8,3,12],[3,13,3,14],[3,15,4,15]]}
["DUO ADULTE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date de naissance entre:",null,null,null,null,null,"inscrit duo adulte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FEUIL1!$I$11","v":"1925-01-01"},{"$f":"FEUIL1!$J$11","v":"2005-12-31"},null,null,null,null,"nom","prenom","naissance","lic recons "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nb danseur seulement duo",{"$f":"AB8","v":0}]
["CHOREGRAPHIE",null,null,null,"DANSEURS",null,null,null,"CHOREGRAPHE",null,null,null,null,"MUSIQUES UTILISEES",null,"Observations",null,null,null,null,"inscription youth"]
[{"$f":"'DUO ADULTE'!AB9","v":0},"Titre Chorégraphie","Minutage","Décor","NOM\n(les 2 noms sont obligatoires)","Prénom\n(Les 2 prénoms sont obligatoires)","Date de naissance\n(obligatoire)","N° Licence","Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",null,null,null,null,"reference solo","nom groupr","prenom groupe","naissance groupe","lic recons  groupe",null,"danseurs 2 categories","danseurs groupe"]
[null,null,null,"(oui/non)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nb danseur",{"$f":"AB7","v":0}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lic recons ",null,null,null,null,null,{"$f":"SUM(Z8:Z13)","v":0},{"$f":"SUM(AA8:AA13)","v":0},{"$f":"AA7","v":0},"nb danseur groupe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(ADULTE!R5=\"\",\"\",ADULTE!R5)","v":""},{"$f":"IF(E7=\"\",\"\",LEFT(E7,3))","v":""},{"$f":"IF(F7=\"\",\"\",LEFT(F7,2))","v":""},{"$f":"IF(G7>0,CONCATENATE(TEXT(G7,\"aaaa\"),TEXT(G7,\"mm\"),TEXT(G7,\"jj\")),\"\")","v":""},{"$f":"IF(U8<>\"\",CONCATENATE(W8,\"-\",U8,\"-\",V8),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X8,$T$5:$X$55,1,FALSE),0)","v":""},{"$f":"IF(OR(Y8=0,Y8=\"\"),0,1)","v":0},{"$f":"IF(X8<>\"\",1,0)","v":0},{"$f":"AB7-Z7","v":0},"nb dans groupe uniquement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(ADULTE!R6=\"\",\"\",ADULTE!R6)","v":""},{"$f":"IF(E8=\"\",\"\",LEFT(E8,3))","v":""},{"$f":"IF(F8=\"\",\"\",LEFT(F8,2))","v":""},{"$f":"IF(G8>0,CONCATENATE(TEXT(G8,\"aaaa\"),TEXT(G8,\"mm\"),TEXT(G8,\"jj\")),\"\")","v":""},{"$f":"IF(U9<>\"\",CONCATENATE(W9,\"-\",U9,\"-\",V9),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X9,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y9=0,Y9=\"\"),0,1)","v":0},{"$f":"IF(X9<>\"\",1,0)","v":0},{"$f":"INT(AB7/2)","v":0},"nb duo"]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(ADULTE!R7=\"\",\"\",ADULTE!R7)","v":""},{"$f":"IF(E10=\"\",\"\",LEFT(E10,3))","v":""},{"$f":"IF(F10=\"\",\"\",LEFT(F10,2))","v":""},{"$f":"IF(G10>0,CONCATENATE(TEXT(G10,\"aaaa\"),TEXT(G10,\"mm\"),TEXT(G10,\"jj\")),\"\")","v":""},{"$f":"IF(U10<>\"\",CONCATENATE(W10,\"-\",U10,\"-\",V10),\"\")","v":""},"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(ADULTE!R8=\"\",\"\",ADULTE!R8)","v":""},{"$f":"IF(E11=\"\",\"\",LEFT(E11,3))","v":""},{"$f":"IF(F11=\"\",\"\",LEFT(F11,2))","v":""},{"$f":"IF(G11>0,CONCATENATE(TEXT(G11,\"aaaa\"),TEXT(G11,\"mm\"),TEXT(G11,\"jj\")),\"\")","v":""},"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(ADULTE!R9=\"\",\"\",ADULTE!R9)","v":""},{"$f":"IF(E13=\"\",\"\",LEFT(E13,3))","v":""},{"$f":"IF(F13=\"\",\"\",LEFT(F13,2))","v":""},{"$f":"IF(G13>0,CONCATENATE(TEXT(G13,\"aaaa\"),TEXT(G13,\"mm\"),TEXT(G13,\"jj\")),\"\")","v":""},"","",0,0]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(ADULTE!R10=\"\",\"\",ADULTE!R10)","v":""},{"$f":"IF(E14=\"\",\"\",LEFT(E14,3))","v":""},{"$f":"IF(F14=\"\",\"\",LEFT(F14,2))","v":""},{"$f":"IF(G14>0,CONCATENATE(TEXT(G14,\"aaaa\"),TEXT(G14,\"mm\"),TEXT(G14,\"jj\")),\"\")","v":""},"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(ADULTE!R11=\"\",\"\",ADULTE!R11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF(ADULTE!R12=\"\",\"\",ADULTE!R12)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"IF(ADULTE!R13=\"\",\"\",ADULTE!R13)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF(ADULTE!R14=\"\",\"\",ADULTE!R14)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF(ADULTE!R15=\"\",\"\",ADULTE!R15)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF(ADULTE!R16=\"\",\"\",ADULTE!R16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF(ADULTE!R17=\"\",\"\",ADULTE!R17)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF(ADULTE!R18=\"\",\"\",ADULTE!R18)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"IF(ADULTE!R19=\"\",\"\",ADULTE!R19)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(ADULTE!R20=\"\",\"\",ADULTE!R20)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(ADULTE!R21=\"\",\"\",ADULTE!R21)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF(ADULTE!R22=\"\",\"\",ADULTE!R22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF(ADULTE!R23=\"\",\"\",ADULTE!R23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF(ADULTE!R24=\"\",\"\",ADULTE!R24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF(ADULTE!R25=\"\",\"\",ADULTE!R25)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF(ADULTE!R26=\"\",\"\",ADULTE!R26)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF(ADULTE!R27=\"\",\"\",ADULTE!R27)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(ADULTE!R28=\"\",\"\",ADULTE!R28)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF(ADULTE!R29=\"\",\"\",ADULTE!R29)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF(ADULTE!R30=\"\",\"\",ADULTE!R30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF(ADULTE!R31=\"\",\"\",ADULTE!R31)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF(ADULTE!R32=\"\",\"\",ADULTE!R32)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"IF(ADULTE!R33=\"\",\"\",ADULTE!R33)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"IF(ADULTE!R34=\"\",\"\",ADULTE!R34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF(ADULTE!R35=\"\",\"\",ADULTE!R35)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF(ADULTE!R36=\"\",\"\",ADULTE!R36)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF(ADULTE!R37=\"\",\"\",ADULTE!R37)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF(ADULTE!R38=\"\",\"\",ADULTE!R38)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF(ADULTE!R39=\"\",\"\",ADULTE!R39)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF(ADULTE!R40=\"\",\"\",ADULTE!R40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF(ADULTE!R41=\"\",\"\",ADULTE!R41)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF(ADULTE!R42=\"\",\"\",ADULTE!R42)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF(ADULTE!R43=\"\",\"\",ADULTE!R43)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF(ADULTE!R44=\"\",\"\",ADULTE!R44)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"IF(ADULTE!R45=\"\",\"\",ADULTE!R45)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"IF(ADULTE!R46=\"\",\"\",ADULTE!R46)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF(ADULTE!R47=\"\",\"\",ADULTE!R47)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF(ADULTE!R48=\"\",\"\",ADULTE!R48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF(ADULTE!R49=\"\",\"\",ADULTE!R49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF(ADULTE!R50=\"\",\"\",ADULTE!R50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF(ADULTE!R51=\"\",\"\",ADULTE!R51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF(ADULTE!R52=\"\",\"\",ADULTE!R52)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF(ADULTE!R53=\"\",\"\",ADULTE!R53)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(ADULTE!R54=\"\",\"\",ADULTE!R54)","v":""}]

{"sheet":"GROUPE JUVENILE","index":12,"n_rows":104,"n_cols":29,"rows_kept":104,"cut":false,"hidden":false,"merged":[[32,16,32,17],[36,3,45,4],[21,3,30,4],[32,0,33,0],[32,1,33,1],[32,2,33,2],[32,3,33,3],[32,4,33,4],[21,0,22,2],[23,1,25,1],[36,0,37,2],[38,1,40,1],[32,5,33,5],[32,6,32,9],[32,11,32,15],[2,16,2,17],[6,3,15,4],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,17,9],[17,11,17,15],[17,16,17,17],[6,0,7,2],[8,1,10,1],[0,7,0,9],[0,12,0,13],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,2,9],[2,11,2,15]]}
[null,null,null,null,null,null,"GROUPE"," JUVENILE",null,null,null,null,"Date de naissance entre :",null,null,null,null,null,null,null,"inscription groupe juvenile"]
[{"$f":"COUNTA(C5,C20,C35)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"FEUIL1!I13","v":"2013-01-01"},{"$f":"FEUIL1!J13","v":"2015-12-31"},null,null,null,null,null,"reference solo","nom groupr","prenom groupe","naissance groupe","lic recons  groupe",null,"danseurs 2 categories","danseurs groupe"]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,null,null,null,null,null,null,null,null,null,"nb danseur",{"$f":"AB5+AB20+AB35","v":0}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",null,"lic recons ",null,null,null,null,null,{"$f":"SUM(Z5:Z16)","v":0},{"$f":"SUM(AA5:AA16)","v":0},{"$f":"AA4","v":0},"nb danseur groupe"]
[1,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Juvenile"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF('JUVENILE 1'!L5=\"\",\"\",'JUVENILE 1'!L5)","v":""},{"$f":"IF(G5=\"\",\"\",LEFT(G5,3))","v":""},{"$f":"IF(H5=\"\",\"\",LEFT(H5,2))","v":""},{"$f":"IF(I5>0,CONCATENATE(TEXT(I5,\"aaaa\"),TEXT(I5,\"mm\"),TEXT(I5,\"jj\")),\"\")","v":""},{"$f":"IF(U5<>\"\",CONCATENATE(W5,\"-\",U5,\"-\",V5),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X5,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y5=0,Y5=\"\"),0,1)","v":0},{"$f":"IF(X5<>\"\",1,0)","v":0},{"$f":"AB4-Z4","v":0},"nb dans groupe uniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF('JUVENILE 1'!L6=\"\",\"\",'JUVENILE 1'!L6)","v":""},{"$f":"IF(G6=\"\",\"\",LEFT(G6,3))","v":""},{"$f":"IF(H6=\"\",\"\",LEFT(H6,2))","v":""},{"$f":"IF(I6>0,CONCATENATE(TEXT(I6,\"aaaa\"),TEXT(I6,\"mm\"),TEXT(I6,\"jj\")),\"\")","v":""},{"$f":"IF(U6<>\"\",CONCATENATE(W6,\"-\",U6,\"-\",V6),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X6,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y6=0,Y6=\"\"),0,1)","v":0},{"$f":"IF(X6<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF('JUVENILE 1'!L7=\"\",\"\",'JUVENILE 1'!L7)","v":""},"","","","","",0,0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF('JUVENILE 1'!L8=\"\",\"\",'JUVENILE 1'!L8)","v":""},"","","","","",0,0]
[null,{"$f":"Z4","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF('JUVENILE 1'!L9=\"\",\"\",'JUVENILE 1'!L9)","v":""},"","","","","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF('JUVENILE 1'!L10=\"\",\"\",'JUVENILE 1'!L10)","v":""},"","","","","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF('JUVENILE 1'!L11=\"\",\"\",'JUVENILE 1'!L11)","v":""},"","","","","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF('JUVENILE 1'!L12=\"\",\"\",'JUVENILE 1'!L12)","v":""},"","","","","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"IF('JUVENILE 1'!L13=\"\",\"\",'JUVENILE 1'!L13)","v":""},"","","","","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF('JUVENILE 1'!L14=\"\",\"\",'JUVENILE 1'!L14)","v":""},"","","","","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF('JUVENILE 1'!L15=\"\",\"\",'JUVENILE 1'!L15)","v":""},"","","","","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF('JUVENILE 1'!L16=\"\",\"\",'JUVENILE 1'!L16)","v":""},"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF('JUVENILE 1'!L17=\"\",\"\",'JUVENILE 1'!L17)","v":""},null,{"$f":"IF('JUNIOR 1'!D17=\"\",\"\",'JUNIOR 1'!D17)","v":""},{"$f":"IF('JUNIOR 1'!E17=\"\",\"\",'JUNIOR 1'!E17)","v":""}]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,14,{"$f":"IF('JUVENILE 1'!L18=\"\",\"\",'JUVENILE 1'!L18)","v":""},null,{"$f":"IF('JUNIOR 1'!D18=\"\",\"\",'JUNIOR 1'!D18)","v":""},{"$f":"IF('JUNIOR 1'!E18=\"\",\"\",'JUNIOR 1'!E18)","v":""}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",15,{"$f":"IF('JUVENILE 1'!L19=\"\",\"\",'JUVENILE 1'!L19)","v":""},null,{"$f":"IF('JUNIOR 1'!D19=\"\",\"\",'JUNIOR 1'!D19)","v":""},{"$f":"IF('JUNIOR 1'!E19=\"\",\"\",'JUNIOR 1'!E19)","v":""},null,null,{"$f":"SUM(Z20:Z31)","v":0},{"$f":"SUM(AA20:AA31)","v":0},{"$f":"AA19","v":0},"nb danseur groupe"]
[2,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Juvenile"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF('JUVENILE 1'!L20=\"\",\"\",'JUVENILE 1'!L20)","v":""},{"$f":"IF(G20=\"\",\"\",LEFT(G20,3))","v":""},{"$f":"IF(H20=\"\",\"\",LEFT(H20,2))","v":""},{"$f":"IF(I20>0,CONCATENATE(TEXT(I20,\"aaaa\"),TEXT(I20,\"mm\"),TEXT(I20,\"jj\")),\"\")","v":""},{"$f":"IF(U20<>\"\",CONCATENATE(W20,\"-\",U20,\"-\",V20),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X20,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y20=0,Y20=\"\"),0,1)","v":0},{"$f":"IF(X20<>\"\",1,0)","v":0},{"$f":"AB19-Z19","v":0},"nb dans groupe uniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF('JUVENILE 1'!L21=\"\",\"\",'JUVENILE 1'!L21)","v":""},{"$f":"IF(G21=\"\",\"\",LEFT(G21,3))","v":""},{"$f":"IF(H21=\"\",\"\",LEFT(H21,2))","v":""},{"$f":"IF(I21>0,CONCATENATE(TEXT(I21,\"aaaa\"),TEXT(I21,\"mm\"),TEXT(I21,\"jj\")),\"\")","v":""},{"$f":"IF(U21<>\"\",CONCATENATE(W21,\"-\",U21,\"-\",V21),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X21,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y21=0,Y21=\"\"),0,1)","v":0},{"$f":"IF(X21<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF('JUVENILE 1'!L22=\"\",\"\",'JUVENILE 1'!L22)","v":""},{"$f":"IF(G22=\"\",\"\",LEFT(G22,3))","v":""},{"$f":"IF(H22=\"\",\"\",LEFT(H22,2))","v":""},{"$f":"IF(I22>0,CONCATENATE(TEXT(I22,\"aaaa\"),TEXT(I22,\"mm\"),TEXT(I22,\"jj\")),\"\")","v":""},{"$f":"IF(U22<>\"\",CONCATENATE(W22,\"-\",U22,\"-\",V22),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X22,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y22=0,Y22=\"\"),0,1)","v":0},0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF('JUVENILE 1'!L23=\"\",\"\",'JUVENILE 1'!L23)","v":""},"","","","","",0,0]
[null,{"$f":"Z19","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF('JUVENILE 1'!L24=\"\",\"\",'JUVENILE 1'!L24)","v":""},"","","","","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF('JUVENILE 1'!L25=\"\",\"\",'JUVENILE 1'!L25)","v":""},"","","","","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF('JUVENILE 1'!L26=\"\",\"\",'JUVENILE 1'!L26)","v":""},"","","","","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF('JUVENILE 1'!L27=\"\",\"\",'JUVENILE 1'!L27)","v":""},"","","","","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF('JUVENILE 1'!L28=\"\",\"\",'JUVENILE 1'!L28)","v":""},"","","","","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF('JUVENILE 1'!L29=\"\",\"\",'JUVENILE 1'!L29)","v":""},"","","","","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF('JUVENILE 1'!L30=\"\",\"\",'JUVENILE 1'!L30)","v":""},"","","","","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF('JUVENILE 1'!L31=\"\",\"\",'JUVENILE 1'!L31)","v":""},"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF('JUVENILE 1'!L32=\"\",\"\",'JUVENILE 1'!L32)","v":""}]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,29,{"$f":"IF('JUVENILE 1'!L33=\"\",\"\",'JUVENILE 1'!L33)","v":""},null,{"$f":"IF('JUNIOR 1'!D33=\"\",\"\",'JUNIOR 1'!D33)","v":""},{"$f":"IF('JUNIOR 1'!E33=\"\",\"\",'JUNIOR 1'!E33)","v":""}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",30,{"$f":"IF('JUVENILE 1'!L34=\"\",\"\",'JUVENILE 1'!L34)","v":""},null,{"$f":"IF('JUNIOR 1'!D34=\"\",\"\",'JUNIOR 1'!D34)","v":""},{"$f":"IF('JUNIOR 1'!E34=\"\",\"\",'JUNIOR 1'!E34)","v":""},null,null,{"$f":"SUM(Z35:Z46)","v":0},{"$f":"SUM(AA35:AA46)","v":0},{"$f":"COUNTA(G35:G46)","v":0},"nb danseur groupe"]
[3,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Juvenile"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF('JUVENILE 1'!L35=\"\",\"\",'JUVENILE 1'!L35)","v":""},null,{"$f":"IF('JUNIOR 1'!D35=\"\",\"\",'JUNIOR 1'!D35)","v":""},{"$f":"IF('JUNIOR 1'!E35=\"\",\"\",'JUNIOR 1'!E35)","v":""},{"$f":"LEFT(J35,15)","v":""},{"$f":"IFERROR(VLOOKUP($X35,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y35=0,Y35=\"\"),0,1)","v":0},{"$f":"IF(X35<>\"\",1,0)","v":0},{"$f":"AB34-Z34","v":0},"nb dans gruniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF('JUVENILE 1'!L36=\"\",\"\",'JUVENILE 1'!L36)","v":""},{"$f":"IF('JUNIOR 1'!C36=\"\",\"\",'JUNIOR 1'!C36)","v":""},{"$f":"IF('JUNIOR 1'!D36=\"\",\"\",'JUNIOR 1'!D36)","v":""},{"$f":"IF('JUNIOR 1'!E36=\"\",\"\",'JUNIOR 1'!E36)","v":""},"",{"$f":"IFERROR(VLOOKUP($X36,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y36=0,Y36=\"\"),0,1)","v":0},{"$f":"IF(X36<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF('JUVENILE 1'!L37=\"\",\"\",'JUVENILE 1'!L37)","v":""},{"$f":"IF('JUNIOR 1'!C37=\"\",\"\",'JUNIOR 1'!C37)","v":""},{"$f":"IF('JUNIOR 1'!D37=\"\",\"\",'JUNIOR 1'!D37)","v":""},{"$f":"IF('JUNIOR 1'!E37=\"\",\"\",'JUNIOR 1'!E37)","v":""},"",{"$f":"IFERROR(VLOOKUP($X37,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y37=0,Y37=\"\"),0,1)","v":0},0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF('JUVENILE 1'!L38=\"\",\"\",'JUVENILE 1'!L38)","v":""},{"$f":"IF('JUNIOR 1'!C38=\"\",\"\",'JUNIOR 1'!C38)","v":""},{"$f":"IF('JUNIOR 1'!D38=\"\",\"\",'JUNIOR 1'!D38)","v":""},{"$f":"IF('JUNIOR 1'!E38=\"\",\"\",'JUNIOR 1'!E38)","v":""},"","",0,0]
[null,{"$f":"Z34","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF('JUVENILE 1'!L39=\"\",\"\",'JUVENILE 1'!L39)","v":""},{"$f":"IF('JUNIOR 1'!C39=\"\",\"\",'JUNIOR 1'!C39)","v":""},{"$f":"IF('JUNIOR 1'!D39=\"\",\"\",'JUNIOR 1'!D39)","v":""},{"$f":"IF('JUNIOR 1'!E39=\"\",\"\",'JUNIOR 1'!E39)","v":""},"","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF('JUVENILE 1'!L40=\"\",\"\",'JUVENILE 1'!L40)","v":""},{"$f":"IF('JUNIOR 1'!C40=\"\",\"\",'JUNIOR 1'!C40)","v":""},{"$f":"IF('JUNIOR 1'!D40=\"\",\"\",'JUNIOR 1'!D40)","v":""},{"$f":"IF('JUNIOR 1'!E40=\"\",\"\",'JUNIOR 1'!E40)","v":""},"","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF('JUVENILE 1'!L41=\"\",\"\",'JUVENILE 1'!L41)","v":""},{"$f":"IF('JUNIOR 1'!C41=\"\",\"\",'JUNIOR 1'!C41)","v":""},{"$f":"IF('JUNIOR 1'!D41=\"\",\"\",'JUNIOR 1'!D41)","v":""},{"$f":"IF('JUNIOR 1'!E41=\"\",\"\",'JUNIOR 1'!E41)","v":""},"","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF('JUVENILE 1'!L42=\"\",\"\",'JUVENILE 1'!L42)","v":""},{"$f":"IF('JUNIOR 1'!C42=\"\",\"\",'JUNIOR 1'!C42)","v":""},{"$f":"IF('JUNIOR 1'!D42=\"\",\"\",'JUNIOR 1'!D42)","v":""},{"$f":"IF('JUNIOR 1'!E42=\"\",\"\",'JUNIOR 1'!E42)","v":""},"","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF('JUVENILE 1'!L43=\"\",\"\",'JUVENILE 1'!L43)","v":""},{"$f":"IF('JUNIOR 1'!C43=\"\",\"\",'JUNIOR 1'!C43)","v":""},{"$f":"IF('JUNIOR 1'!D43=\"\",\"\",'JUNIOR 1'!D43)","v":""},{"$f":"IF('JUNIOR 1'!E43=\"\",\"\",'JUNIOR 1'!E43)","v":""},"","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF('JUVENILE 1'!L44=\"\",\"\",'JUVENILE 1'!L44)","v":""},{"$f":"IF('JUNIOR 1'!C44=\"\",\"\",'JUNIOR 1'!C44)","v":""},{"$f":"IF('JUNIOR 1'!D44=\"\",\"\",'JUNIOR 1'!D44)","v":""},{"$f":"IF('JUNIOR 1'!E44=\"\",\"\",'JUNIOR 1'!E44)","v":""},"","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"IF('JUVENILE 1'!L45=\"\",\"\",'JUVENILE 1'!L45)","v":""},{"$f":"IF('JUNIOR 1'!C45=\"\",\"\",'JUNIOR 1'!C45)","v":""},{"$f":"IF('JUNIOR 1'!D45=\"\",\"\",'JUNIOR 1'!D45)","v":""},{"$f":"IF('JUNIOR 1'!E45=\"\",\"\",'JUNIOR 1'!E45)","v":""},"","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"IF('JUVENILE 1'!L46=\"\",\"\",'JUVENILE 1'!L46)","v":""},{"$f":"IF('JUNIOR 1'!C46=\"\",\"\",'JUNIOR 1'!C46)","v":""},{"$f":"IF('JUNIOR 1'!D46=\"\",\"\",'JUNIOR 1'!D46)","v":""},{"$f":"IF('JUNIOR 1'!E46=\"\",\"\",'JUNIOR 1'!E46)","v":""},"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF('JUVENILE 1'!L47=\"\",\"\",'JUVENILE 1'!L47)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF('JUVENILE 1'!L48=\"\",\"\",'JUVENILE 1'!L48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF('JUVENILE 1'!L49=\"\",\"\",'JUVENILE 1'!L49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF('JUVENILE 1'!L50=\"\",\"\",'JUVENILE 1'!L50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF('JUVENILE 1'!L51=\"\",\"\",'JUVENILE 1'!L51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF('JUVENILE 1'!L52=\"\",\"\",'JUVENILE 1'!L52)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF('JUVENILE 1'!L53=\"\",\"\",'JUVENILE 1'!L53)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF('JUVENILE 1'!L54=\"\",\"\",'JUVENILE 1'!L54)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF('JUVENILE 2'!L5=\"\",\"\",'JUVENILE 2'!L5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF('JUVENILE 2'!L6=\"\",\"\",'JUVENILE 2'!L6)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF('JUVENILE 2'!L7=\"\",\"\",'JUVENILE 2'!L7)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF('JUVENILE 2'!L8=\"\",\"\",'JUVENILE 2'!L8)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF('JUVENILE 2'!L9=\"\",\"\",'JUVENILE 2'!L9)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF('JUVENILE 2'!L10=\"\",\"\",'JUVENILE 2'!L10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF('JUVENILE 2'!L11=\"\",\"\",'JUVENILE 2'!L11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF('JUVENILE 2'!L12=\"\",\"\",'JUVENILE 2'!L12)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"IF('JUVENILE 2'!L13=\"\",\"\",'JUVENILE 2'!L13)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF('JUVENILE 2'!L14=\"\",\"\",'JUVENILE 2'!L14)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF('JUVENILE 2'!L15=\"\",\"\",'JUVENILE 2'!L15)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF('JUVENILE 2'!L16=\"\",\"\",'JUVENILE 2'!L16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF('JUVENILE 2'!L17=\"\",\"\",'JUVENILE 2'!L17)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF('JUVENILE 2'!L18=\"\",\"\",'JUVENILE 2'!L18)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"IF('JUVENILE 2'!L19=\"\",\"\",'JUVENILE 2'!L19)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF('JUVENILE 2'!L20=\"\",\"\",'JUVENILE 2'!L20)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF('JUVENILE 2'!L21=\"\",\"\",'JUVENILE 2'!L21)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF('JUVENILE 2'!L22=\"\",\"\",'JUVENILE 2'!L22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF('JUVENILE 2'!L23=\"\",\"\",'JUVENILE 2'!L23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF('JUVENILE 2'!L24=\"\",\"\",'JUVENILE 2'!L24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF('JUVENILE 2'!L25=\"\",\"\",'JUVENILE 2'!L25)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF('JUVENILE 2'!L26=\"\",\"\",'JUVENILE 2'!L26)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF('JUVENILE 2'!L27=\"\",\"\",'JUVENILE 2'!L27)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF('JUVENILE 2'!L28=\"\",\"\",'JUVENILE 2'!L28)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF('JUVENILE 2'!L29=\"\",\"\",'JUVENILE 2'!L29)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF('JUVENILE 2'!L30=\"\",\"\",'JUVENILE 2'!L30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF('JUVENILE 2'!L31=\"\",\"\",'JUVENILE 2'!L31)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF('JUVENILE 2'!L32=\"\",\"\",'JUVENILE 2'!L32)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"IF('JUVENILE 2'!L33=\"\",\"\",'JUVENILE 2'!L33)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"IF('JUVENILE 2'!L34=\"\",\"\",'JUVENILE 2'!L34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF('JUVENILE 2'!L35=\"\",\"\",'JUVENILE 2'!L35)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF('JUVENILE 2'!L36=\"\",\"\",'JUVENILE 2'!L36)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF('JUVENILE 2'!L37=\"\",\"\",'JUVENILE 2'!L37)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF('JUVENILE 2'!L38=\"\",\"\",'JUVENILE 2'!L38)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF('JUVENILE 2'!L39=\"\",\"\",'JUVENILE 2'!L39)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF('JUVENILE 2'!L40=\"\",\"\",'JUVENILE 2'!L40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF('JUVENILE 2'!L41=\"\",\"\",'JUVENILE 2'!L41)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF('JUVENILE 2'!L42=\"\",\"\",'JUVENILE 2'!L42)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF('JUVENILE 2'!L43=\"\",\"\",'JUVENILE 2'!L43)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF('JUVENILE 2'!L44=\"\",\"\",'JUVENILE 2'!L44)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"IF('JUVENILE 2'!L45=\"\",\"\",'JUVENILE 2'!L45)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"IF('JUVENILE 2'!L46=\"\",\"\",'JUVENILE 2'!L46)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF('JUVENILE 2'!L47=\"\",\"\",'JUVENILE 2'!L47)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF('JUVENILE 2'!L48=\"\",\"\",'JUVENILE 2'!L48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF('JUVENILE 2'!L49=\"\",\"\",'JUVENILE 2'!L49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF('JUVENILE 2'!L50=\"\",\"\",'JUVENILE 2'!L50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF('JUVENILE 2'!L51=\"\",\"\",'JUVENILE 2'!L51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF('JUVENILE 2'!L52=\"\",\"\",'JUVENILE 2'!L52)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF('JUVENILE 2'!L53=\"\",\"\",'JUVENILE 2'!L53)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF('JUVENILE 2'!L54=\"\",\"\",'JUVENILE 2'!L54)","v":""}]

{"sheet":"GROUPE JUNIOR","index":13,"n_rows":104,"n_cols":29,"rows_kept":104,"cut":false,"hidden":false,"merged":[[32,16,32,17],[36,3,45,4],[21,3,30,4],[32,0,33,0],[32,1,33,1],[32,2,33,2],[32,3,33,3],[32,4,33,4],[21,0,22,2],[23,1,25,1],[36,0,37,2],[38,1,40,1],[32,5,33,5],[32,6,32,9],[32,11,32,15],[2,16,2,17],[6,3,15,4],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,17,9],[17,11,17,15],[17,16,17,17],[6,0,7,2],[8,1,10,1],[0,7,0,9],[0,12,0,13],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,2,9],[2,11,2,15]]}
[null,null,null,null,null,null,"GROUPE"," JUNIOR",null,null,null,null,"Date de naissance entre :",null,null,null,null,null,null,null,"inscription groupe junior"]
[{"$f":"COUNTA(C5,C20,C35)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"FEUIL1!I14","v":"2009-01-01"},{"$f":"FEUIL1!J14","v":"2012-12-31"},null,null,null,null,null,"reference solo","nom groupr","prenom groupe","naissance groupe","lic recons  groupe",null,"danseurs 2 categories","danseurs groupe"]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,null,null,null,null,null,null,null,null,null,"nb danseur",{"$f":"AB5+AB20+AB35","v":0}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",null,"lic recons ",null,null,null,null,null,{"$f":"SUM(Z5:Z16)","v":0},{"$f":"SUM(AA5:AA16)","v":0},{"$f":"AA4","v":0},"nb danseur groupe"]
[1,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Junior"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF('JUNIOR 1'!L5=\"\",\"\",'JUNIOR 1'!L5)","v":""},{"$f":"IF(G5=\"\",\"\",LEFT(G5,3))","v":""},{"$f":"IF(H5=\"\",\"\",LEFT(H5,2))","v":""},{"$f":"IF(I5>0,CONCATENATE(TEXT(I5,\"aaaa\"),TEXT(I5,\"mm\"),TEXT(I5,\"jj\")),\"\")","v":""},{"$f":"IF(U5<>\"\",CONCATENATE(W5,\"-\",U5,\"-\",V5),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X5,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y5=0,Y5=\"\"),0,1)","v":0},{"$f":"IF(X5<>\"\",1,0)","v":0},{"$f":"AB4-Z4","v":0},"nb dans groupe uniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF('JUNIOR 1'!L6=\"\",\"\",'JUNIOR 1'!L6)","v":""},{"$f":"IF(G6=\"\",\"\",LEFT(G6,3))","v":""},{"$f":"IF(H6=\"\",\"\",LEFT(H6,2))","v":""},{"$f":"IF(I6>0,CONCATENATE(TEXT(I6,\"aaaa\"),TEXT(I6,\"mm\"),TEXT(I6,\"jj\")),\"\")","v":""},{"$f":"IF(U6<>\"\",CONCATENATE(W6,\"-\",U6,\"-\",V6),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X6,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y6=0,Y6=\"\"),0,1)","v":0},{"$f":"IF(X6<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF('JUNIOR 1'!L7=\"\",\"\",'JUNIOR 1'!L7)","v":""},"","","","","",0,0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF('JUNIOR 1'!L8=\"\",\"\",'JUNIOR 1'!L8)","v":""},"","","","","",0,0]
[null,{"$f":"Z4","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF('JUNIOR 1'!L9=\"\",\"\",'JUNIOR 1'!L9)","v":""},"","","","","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF('JUNIOR 1'!L10=\"\",\"\",'JUNIOR 1'!L10)","v":""},"","","","","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF('JUNIOR 1'!L11=\"\",\"\",'JUNIOR 1'!L11)","v":""},"","","","","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF('JUNIOR 1'!L12=\"\",\"\",'JUNIOR 1'!L12)","v":""},"","","","","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"IF('JUNIOR 1'!L13=\"\",\"\",'JUNIOR 1'!L13)","v":""},"","","","","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF('JUNIOR 1'!L14=\"\",\"\",'JUNIOR 1'!L14)","v":""},"","","","","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF('JUNIOR 1'!L15=\"\",\"\",'JUNIOR 1'!L15)","v":""},"","","","","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF('JUNIOR 1'!L16=\"\",\"\",'JUNIOR 1'!L16)","v":""},"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF('JUNIOR 1'!L17=\"\",\"\",'JUNIOR 1'!L17)","v":""},null,{"$f":"IF('JUNIOR 1'!D17=\"\",\"\",'JUNIOR 1'!D17)","v":""},{"$f":"IF('JUNIOR 1'!E17=\"\",\"\",'JUNIOR 1'!E17)","v":""}]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,14,{"$f":"IF('JUNIOR 1'!L18=\"\",\"\",'JUNIOR 1'!L18)","v":""},null,{"$f":"IF('JUNIOR 1'!D18=\"\",\"\",'JUNIOR 1'!D18)","v":""},{"$f":"IF('JUNIOR 1'!E18=\"\",\"\",'JUNIOR 1'!E18)","v":""}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",15,{"$f":"IF('JUNIOR 1'!L19=\"\",\"\",'JUNIOR 1'!L19)","v":""},null,{"$f":"IF('JUNIOR 1'!D19=\"\",\"\",'JUNIOR 1'!D19)","v":""},{"$f":"IF('JUNIOR 1'!E19=\"\",\"\",'JUNIOR 1'!E19)","v":""},null,null,{"$f":"SUM(Z20:Z31)","v":0},{"$f":"SUM(AA20:AA31)","v":0},{"$f":"AA19","v":0},"nb danseur groupe"]
[2,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Junior"},null,null,null,1,null,null,null,null,null,"GANDON","JULIA","19800911-gan-ju53",617338343,"espacedansedukreisker@gmail.com","nothing from nothing","billy preston",16,{"$f":"IF('JUNIOR 1'!L20=\"\",\"\",'JUNIOR 1'!L20)","v":""},{"$f":"IF(G20=\"\",\"\",LEFT(G20,3))","v":""},{"$f":"IF(H20=\"\",\"\",LEFT(H20,2))","v":""},{"$f":"IF(I20>0,CONCATENATE(TEXT(I20,\"aaaa\"),TEXT(I20,\"mm\"),TEXT(I20,\"jj\")),\"\")","v":""},{"$f":"IF(U20<>\"\",CONCATENATE(W20,\"-\",U20,\"-\",V20),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X20,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y20=0,Y20=\"\"),0,1)","v":0},{"$f":"IF(X20<>\"\",1,0)","v":0},{"$f":"AB19-Z19","v":0},"nb dans groupe uniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF('JUNIOR 1'!L21=\"\",\"\",'JUNIOR 1'!L21)","v":""},"",{"$f":"IF(H21=\"\",\"\",LEFT(H21,2))","v":""},{"$f":"IF(I21>0,CONCATENATE(TEXT(I21,\"aaaa\"),TEXT(I21,\"mm\"),TEXT(I21,\"jj\")),\"\")","v":""},{"$f":"IF(U21<>\"\",CONCATENATE(W21,\"-\",U21,\"-\",V21),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X21,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y21=0,Y21=\"\"),0,1)","v":0},{"$f":"IF(X21<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF('JUNIOR 1'!L22=\"\",\"\",'JUNIOR 1'!L22)","v":""},"",{"$f":"IF(H22=\"\",\"\",LEFT(H22,2))","v":""},{"$f":"IF(I22>0,CONCATENATE(TEXT(I22,\"aaaa\"),TEXT(I22,\"mm\"),TEXT(I22,\"jj\")),\"\")","v":""},{"$f":"IF(U22<>\"\",CONCATENATE(W22,\"-\",U22,\"-\",V22),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X22,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y22=0,Y22=\"\"),0,1)","v":0},0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF('JUNIOR 1'!L23=\"\",\"\",'JUNIOR 1'!L23)","v":""},"","","","","",0,0]
[null,{"$f":"Z19","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF('JUNIOR 1'!L24=\"\",\"\",'JUNIOR 1'!L24)","v":""},"","","","","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF('JUNIOR 1'!L25=\"\",\"\",'JUNIOR 1'!L25)","v":""},"","","","","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF('JUNIOR 1'!L26=\"\",\"\",'JUNIOR 1'!L26)","v":""},"","","","","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF('JUNIOR 1'!L27=\"\",\"\",'JUNIOR 1'!L27)","v":""},"","","","","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF('JUNIOR 1'!L28=\"\",\"\",'JUNIOR 1'!L28)","v":""},"","","","","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF('JUNIOR 1'!L29=\"\",\"\",'JUNIOR 1'!L29)","v":""},"","","","","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF('JUNIOR 1'!L30=\"\",\"\",'JUNIOR 1'!L30)","v":""},"","","","","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF('JUNIOR 1'!L31=\"\",\"\",'JUNIOR 1'!L31)","v":""},"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF('JUNIOR 1'!L32=\"\",\"\",'JUNIOR 1'!L32)","v":""}]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,29,{"$f":"IF('JUNIOR 1'!L33=\"\",\"\",'JUNIOR 1'!L33)","v":""},null,{"$f":"IF('JUNIOR 1'!D33=\"\",\"\",'JUNIOR 1'!D33)","v":""},{"$f":"IF('JUNIOR 1'!E33=\"\",\"\",'JUNIOR 1'!E33)","v":""}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",30,{"$f":"IF('JUNIOR 1'!L34=\"\",\"\",'JUNIOR 1'!L34)","v":""},null,{"$f":"IF('JUNIOR 1'!D34=\"\",\"\",'JUNIOR 1'!D34)","v":""},{"$f":"IF('JUNIOR 1'!E34=\"\",\"\",'JUNIOR 1'!E34)","v":""},null,null,{"$f":"SUM(Z35:Z46)","v":0},{"$f":"SUM(AA35:AA46)","v":0},{"$f":"COUNTA(G35:G46)","v":0},"nb danseur groupe"]
[3,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Junior"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF('JUNIOR 1'!L35=\"\",\"\",'JUNIOR 1'!L35)","v":""},{"$f":"IF(G35=\"\",\"\",LEFT(G35,3))","v":""},{"$f":"IF('JUNIOR 1'!D35=\"\",\"\",'JUNIOR 1'!D35)","v":""},{"$f":"IF('JUNIOR 1'!E35=\"\",\"\",'JUNIOR 1'!E35)","v":""},{"$f":"LEFT(J35,15)","v":""},{"$f":"IFERROR(VLOOKUP($X35,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y35=0,Y35=\"\"),0,1)","v":0},{"$f":"IF(X35<>\"\",1,0)","v":0},{"$f":"AB34-Z34","v":0},"nb dans gruniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF('JUNIOR 1'!L36=\"\",\"\",'JUNIOR 1'!L36)","v":""},"",{"$f":"IF('JUNIOR 1'!D36=\"\",\"\",'JUNIOR 1'!D36)","v":""},{"$f":"IF('JUNIOR 1'!E36=\"\",\"\",'JUNIOR 1'!E36)","v":""},"",{"$f":"IFERROR(VLOOKUP($X36,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y36=0,Y36=\"\"),0,1)","v":0},{"$f":"IF(X36<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF('JUNIOR 1'!L37=\"\",\"\",'JUNIOR 1'!L37)","v":""},"",{"$f":"IF('JUNIOR 1'!D37=\"\",\"\",'JUNIOR 1'!D37)","v":""},{"$f":"IF('JUNIOR 1'!E37=\"\",\"\",'JUNIOR 1'!E37)","v":""},"",{"$f":"IFERROR(VLOOKUP($X37,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y37=0,Y37=\"\"),0,1)","v":0},0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF('JUNIOR 1'!L38=\"\",\"\",'JUNIOR 1'!L38)","v":""},"",{"$f":"IF('JUNIOR 1'!D38=\"\",\"\",'JUNIOR 1'!D38)","v":""},{"$f":"IF('JUNIOR 1'!E38=\"\",\"\",'JUNIOR 1'!E38)","v":""},"","",0,0]
[null,{"$f":"Z34","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF('JUNIOR 1'!L39=\"\",\"\",'JUNIOR 1'!L39)","v":""},"",{"$f":"IF('JUNIOR 1'!D39=\"\",\"\",'JUNIOR 1'!D39)","v":""},{"$f":"IF('JUNIOR 1'!E39=\"\",\"\",'JUNIOR 1'!E39)","v":""},"","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF('JUNIOR 1'!L40=\"\",\"\",'JUNIOR 1'!L40)","v":""},"",{"$f":"IF('JUNIOR 1'!D40=\"\",\"\",'JUNIOR 1'!D40)","v":""},{"$f":"IF('JUNIOR 1'!E40=\"\",\"\",'JUNIOR 1'!E40)","v":""},"","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF('JUNIOR 1'!L41=\"\",\"\",'JUNIOR 1'!L41)","v":""},"",{"$f":"IF('JUNIOR 1'!D41=\"\",\"\",'JUNIOR 1'!D41)","v":""},{"$f":"IF('JUNIOR 1'!E41=\"\",\"\",'JUNIOR 1'!E41)","v":""},"","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF('JUNIOR 1'!L42=\"\",\"\",'JUNIOR 1'!L42)","v":""},"",{"$f":"IF('JUNIOR 1'!D42=\"\",\"\",'JUNIOR 1'!D42)","v":""},{"$f":"IF('JUNIOR 1'!E42=\"\",\"\",'JUNIOR 1'!E42)","v":""},"","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF('JUNIOR 1'!L43=\"\",\"\",'JUNIOR 1'!L43)","v":""},"",{"$f":"IF('JUNIOR 1'!D43=\"\",\"\",'JUNIOR 1'!D43)","v":""},{"$f":"IF('JUNIOR 1'!E43=\"\",\"\",'JUNIOR 1'!E43)","v":""},"","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF('JUNIOR 1'!L44=\"\",\"\",'JUNIOR 1'!L44)","v":""},"",{"$f":"IF('JUNIOR 1'!D44=\"\",\"\",'JUNIOR 1'!D44)","v":""},{"$f":"IF('JUNIOR 1'!E44=\"\",\"\",'JUNIOR 1'!E44)","v":""},"","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"IF('JUNIOR 1'!L45=\"\",\"\",'JUNIOR 1'!L45)","v":""},"",{"$f":"IF('JUNIOR 1'!D45=\"\",\"\",'JUNIOR 1'!D45)","v":""},{"$f":"IF('JUNIOR 1'!E45=\"\",\"\",'JUNIOR 1'!E45)","v":""},"","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"IF('JUNIOR 1'!L46=\"\",\"\",'JUNIOR 1'!L46)","v":""},"",{"$f":"IF('JUNIOR 1'!D46=\"\",\"\",'JUNIOR 1'!D46)","v":""},{"$f":"IF('JUNIOR 1'!E46=\"\",\"\",'JUNIOR 1'!E46)","v":""},"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF('JUNIOR 1'!L47=\"\",\"\",'JUNIOR 1'!L47)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF('JUNIOR 1'!L48=\"\",\"\",'JUNIOR 1'!L48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF('JUNIOR 1'!L49=\"\",\"\",'JUNIOR 1'!L49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF('JUNIOR 1'!L50=\"\",\"\",'JUNIOR 1'!L50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF('JUNIOR 1'!L51=\"\",\"\",'JUNIOR 1'!L51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF('JUNIOR 1'!L52=\"\",\"\",'JUNIOR 1'!L52)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF('JUNIOR 1'!L53=\"\",\"\",'JUNIOR 1'!L53)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF('JUNIOR 1'!L54=\"\",\"\",'JUNIOR 1'!L54)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF('JUNIOR 2'!L5=\"\",\"\",'JUNIOR 2'!L5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF('JUNIOR 2'!L6=\"\",\"\",'JUNIOR 2'!L6)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF('JUNIOR 2'!L7=\"\",\"\",'JUNIOR 2'!L7)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF('JUNIOR 2'!L8=\"\",\"\",'JUNIOR 2'!L8)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF('JUNIOR 2'!L9=\"\",\"\",'JUNIOR 2'!L9)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF('JUNIOR 2'!L10=\"\",\"\",'JUNIOR 2'!L10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF('JUNIOR 2'!L11=\"\",\"\",'JUNIOR 2'!L11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF('JUNIOR 2'!L12=\"\",\"\",'JUNIOR 2'!L12)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"IF('JUNIOR 2'!L13=\"\",\"\",'JUNIOR 2'!L13)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF('JUNIOR 2'!L14=\"\",\"\",'JUNIOR 2'!L14)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF('JUNIOR 2'!L15=\"\",\"\",'JUNIOR 2'!L15)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF('JUNIOR 2'!L16=\"\",\"\",'JUNIOR 2'!L16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF('JUNIOR 2'!L17=\"\",\"\",'JUNIOR 2'!L17)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF('JUNIOR 2'!L18=\"\",\"\",'JUNIOR 2'!L18)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"IF('JUNIOR 2'!L19=\"\",\"\",'JUNIOR 2'!L19)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF('JUNIOR 2'!L20=\"\",\"\",'JUNIOR 2'!L20)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF('JUNIOR 2'!L21=\"\",\"\",'JUNIOR 2'!L21)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF('JUNIOR 2'!L22=\"\",\"\",'JUNIOR 2'!L22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF('JUNIOR 2'!L23=\"\",\"\",'JUNIOR 2'!L23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF('JUNIOR 2'!L24=\"\",\"\",'JUNIOR 2'!L24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF('JUNIOR 2'!L25=\"\",\"\",'JUNIOR 2'!L25)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF('JUNIOR 2'!L26=\"\",\"\",'JUNIOR 2'!L26)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF('JUNIOR 2'!L27=\"\",\"\",'JUNIOR 2'!L27)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF('JUNIOR 2'!L28=\"\",\"\",'JUNIOR 2'!L28)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF('JUNIOR 2'!L29=\"\",\"\",'JUNIOR 2'!L29)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF('JUNIOR 2'!L30=\"\",\"\",'JUNIOR 2'!L30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF('JUNIOR 2'!L31=\"\",\"\",'JUNIOR 2'!L31)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF('JUNIOR 2'!L32=\"\",\"\",'JUNIOR 2'!L32)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"IF('JUNIOR 2'!L33=\"\",\"\",'JUNIOR 2'!L33)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"IF('JUNIOR 2'!L34=\"\",\"\",'JUNIOR 2'!L34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF('JUNIOR 2'!L35=\"\",\"\",'JUNIOR 2'!L35)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF('JUNIOR 2'!L36=\"\",\"\",'JUNIOR 2'!L36)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF('JUNIOR 2'!L37=\"\",\"\",'JUNIOR 2'!L37)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF('JUNIOR 2'!L38=\"\",\"\",'JUNIOR 2'!L38)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF('JUNIOR 2'!L39=\"\",\"\",'JUNIOR 2'!L39)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF('JUNIOR 2'!L40=\"\",\"\",'JUNIOR 2'!L40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF('JUNIOR 2'!L41=\"\",\"\",'JUNIOR 2'!L41)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF('JUNIOR 2'!L42=\"\",\"\",'JUNIOR 2'!L42)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF('JUNIOR 2'!L43=\"\",\"\",'JUNIOR 2'!L43)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF('JUNIOR 2'!L44=\"\",\"\",'JUNIOR 2'!L44)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"IF('JUNIOR 2'!L45=\"\",\"\",'JUNIOR 2'!L45)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"IF('JUNIOR 2'!L46=\"\",\"\",'JUNIOR 2'!L46)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF('JUNIOR 2'!L47=\"\",\"\",'JUNIOR 2'!L47)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF('JUNIOR 2'!L48=\"\",\"\",'JUNIOR 2'!L48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF('JUNIOR 2'!L49=\"\",\"\",'JUNIOR 2'!L49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF('JUNIOR 2'!L50=\"\",\"\",'JUNIOR 2'!L50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF('JUNIOR 2'!L51=\"\",\"\",'JUNIOR 2'!L51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF('JUNIOR 2'!L52=\"\",\"\",'JUNIOR 2'!L52)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF('JUNIOR 2'!L53=\"\",\"\",'JUNIOR 2'!L53)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF('JUNIOR 2'!L54=\"\",\"\",'JUNIOR 2'!L54)","v":""}]

{"sheet":"GROUPE YOUTH","index":14,"n_rows":54,"n_cols":29,"rows_kept":54,"cut":false,"hidden":false,"merged":[[32,16,32,17],[36,3,45,4],[21,3,30,4],[32,0,33,0],[32,1,33,1],[32,2,33,2],[32,3,33,3],[32,4,33,4],[21,0,22,2],[23,1,25,1],[36,0,37,2],[38,1,40,1],[32,5,33,5],[32,6,32,9],[32,11,32,15],[2,16,2,17],[6,3,15,4],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,17,9],[17,11,17,15],[17,16,17,17],[8,1,10,1],[6,0,7,2],[0,7,0,9],[0,12,0,13],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,2,9],[2,11,2,15]]}
[null,null,null,null,null,null,"GROUPE"," YOUTH",null,null,null,null,"Date de naissance entre :",null,null,null,null,null,null,null,"inscription groupe youth"]
[{"$f":"COUNTA(C5,C20,C35)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"FEUIL1!I15","v":"2006-01-01"},{"$f":"FEUIL1!J15","v":"2008-12-31"},null,null,null,null,null,"reference solo","nom groupr","prenom groupe","naissance groupe","lic recons  groupe",null,"danseurs 2 categories","danseurs groupe"]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,null,null,null,null,null,null,null,null,null,"nb danseur",{"$f":"AB5+AB20+AB35","v":0}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",null,"lic recons ",null,null,null,null,null,{"$f":"SUM(Z5:Z16)","v":0},{"$f":"SUM(AA5:AA16)","v":0},{"$f":"AA4","v":0},"nb danseur groupe"]
[1,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Youth"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(YOUTH!R5=\"\",\"\",YOUTH!R5)","v":""},{"$f":"IF(G5=\"\",\"\",LEFT(G5,3))","v":""},{"$f":"IF(H5=\"\",\"\",LEFT(H5,2))","v":""},{"$f":"IF(I5>0,CONCATENATE(TEXT(I5,\"aaaa\"),TEXT(I5,\"mm\"),TEXT(I5,\"jj\")),\"\")","v":""},{"$f":"IF(U5<>\"\",CONCATENATE(W5,\"-\",U5,\"-\",V5),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X5,$T$5:$X$55,1,FALSE),0)","v":""},{"$f":"IF(OR(Y5=0,Y5=\"\"),0,1)","v":0},{"$f":"IF(X5<>\"\",1,0)","v":0},{"$f":"AB4-Z4","v":0},"nb dans groupe uniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(YOUTH!R6=\"\",\"\",YOUTH!R6)","v":""},{"$f":"IF(G6=\"\",\"\",LEFT(G6,3))","v":""},{"$f":"IF(H6=\"\",\"\",LEFT(H6,2))","v":""},{"$f":"IF(I6>0,CONCATENATE(TEXT(I6,\"aaaa\"),TEXT(I6,\"mm\"),TEXT(I6,\"jj\")),\"\")","v":""},{"$f":"IF(U6<>\"\",CONCATENATE(W6,\"-\",U6,\"-\",V6),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X6,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y6=0,Y6=\"\"),0,1)","v":0},{"$f":"IF(X6<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(YOUTH!R7=\"\",\"\",YOUTH!R7)","v":""},"","","","","",0,0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(YOUTH!R8=\"\",\"\",YOUTH!R8)","v":""},"","","","","",0,0]
[null,{"$f":"Z4","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(YOUTH!R9=\"\",\"\",YOUTH!R9)","v":""},"","","","","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(YOUTH!R10=\"\",\"\",YOUTH!R10)","v":""},"","","","","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(YOUTH!R11=\"\",\"\",YOUTH!R11)","v":""},"","","","","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF(YOUTH!R12=\"\",\"\",YOUTH!R12)","v":""},"","","","","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"IF(YOUTH!R13=\"\",\"\",YOUTH!R13)","v":""},"","","","","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF(YOUTH!R14=\"\",\"\",YOUTH!R14)","v":""},"","","","","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF(YOUTH!R15=\"\",\"\",YOUTH!R15)","v":""},"","","","","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF(YOUTH!R16=\"\",\"\",YOUTH!R16)","v":""},"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF(YOUTH!R17=\"\",\"\",YOUTH!R17)","v":""},null,{"$f":"IF('JUNIOR 1'!D17=\"\",\"\",'JUNIOR 1'!D17)","v":""},{"$f":"IF('JUNIOR 1'!E17=\"\",\"\",'JUNIOR 1'!E17)","v":""}]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,14,{"$f":"IF(YOUTH!R18=\"\",\"\",YOUTH!R18)","v":""},null,{"$f":"IF('JUNIOR 1'!D18=\"\",\"\",'JUNIOR 1'!D18)","v":""},{"$f":"IF('JUNIOR 1'!E18=\"\",\"\",'JUNIOR 1'!E18)","v":""}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",15,{"$f":"IF(YOUTH!R19=\"\",\"\",YOUTH!R19)","v":""},null,{"$f":"IF('JUNIOR 1'!D19=\"\",\"\",'JUNIOR 1'!D19)","v":""},{"$f":"IF('JUNIOR 1'!E19=\"\",\"\",'JUNIOR 1'!E19)","v":""},null,null,{"$f":"SUM(Z20:Z31)","v":0},{"$f":"SUM(AA20:AA31)","v":0},{"$f":"AA19","v":0},"nb danseur groupe"]
[2,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Youth"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(YOUTH!R20=\"\",\"\",YOUTH!R20)","v":""},{"$f":"IF(G20=\"\",\"\",LEFT(G20,3))","v":""},{"$f":"IF(H20=\"\",\"\",LEFT(H20,2))","v":""},{"$f":"IF(I20>0,CONCATENATE(TEXT(I20,\"aaaa\"),TEXT(I20,\"mm\"),TEXT(I20,\"jj\")),\"\")","v":""},{"$f":"IF(U20<>\"\",CONCATENATE(W20,\"-\",U20,\"-\",V20),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X20,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y20=0,Y20=\"\"),0,1)","v":0},{"$f":"IF(X20<>\"\",1,0)","v":0},{"$f":"AB19-Z19","v":0},"nb dans groupe uniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(YOUTH!R21=\"\",\"\",YOUTH!R21)","v":""},"",{"$f":"IF(H21=\"\",\"\",LEFT(H21,2))","v":""},{"$f":"IF(I21>0,CONCATENATE(TEXT(I21,\"aaaa\"),TEXT(I21,\"mm\"),TEXT(I21,\"jj\")),\"\")","v":""},{"$f":"IF(U21<>\"\",CONCATENATE(W21,\"-\",U21,\"-\",V21),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X21,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y21=0,Y21=\"\"),0,1)","v":0},{"$f":"IF(X21<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF(YOUTH!R22=\"\",\"\",YOUTH!R22)","v":""},"",{"$f":"IF(H22=\"\",\"\",LEFT(H22,2))","v":""},{"$f":"IF(I22>0,CONCATENATE(TEXT(I22,\"aaaa\"),TEXT(I22,\"mm\"),TEXT(I22,\"jj\")),\"\")","v":""},{"$f":"IF(U22<>\"\",CONCATENATE(W22,\"-\",U22,\"-\",V22),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X22,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y22=0,Y22=\"\"),0,1)","v":0},0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF(YOUTH!R23=\"\",\"\",YOUTH!R23)","v":""},"","","","","",0,0]
[null,{"$f":"Z19","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF(YOUTH!R24=\"\",\"\",YOUTH!R24)","v":""},"","","","","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF(YOUTH!R25=\"\",\"\",YOUTH!R25)","v":""},"","","","","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF(YOUTH!R26=\"\",\"\",YOUTH!R26)","v":""},"","","","","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF(YOUTH!R27=\"\",\"\",YOUTH!R27)","v":""},"","","","","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(YOUTH!R28=\"\",\"\",YOUTH!R28)","v":""},"","","","","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF(YOUTH!R29=\"\",\"\",YOUTH!R29)","v":""},"","","","","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF(YOUTH!R30=\"\",\"\",YOUTH!R30)","v":""},"","","","","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF(YOUTH!R31=\"\",\"\",YOUTH!R31)","v":""},"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF(YOUTH!R32=\"\",\"\",YOUTH!R32)","v":""}]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,29,{"$f":"IF(YOUTH!R33=\"\",\"\",YOUTH!R33)","v":""},null,{"$f":"IF('JUNIOR 1'!D33=\"\",\"\",'JUNIOR 1'!D33)","v":""},{"$f":"IF('JUNIOR 1'!E33=\"\",\"\",'JUNIOR 1'!E33)","v":""}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",30,{"$f":"IF(YOUTH!R34=\"\",\"\",YOUTH!R34)","v":""},null,{"$f":"IF('JUNIOR 1'!D34=\"\",\"\",'JUNIOR 1'!D34)","v":""},{"$f":"IF('JUNIOR 1'!E34=\"\",\"\",'JUNIOR 1'!E34)","v":""},null,null,{"$f":"SUM(Z35:Z46)","v":0},{"$f":"SUM(AA35:AA46)","v":0},{"$f":"COUNTA(G35:G46)","v":0},"nb danseur groupe"]
[3,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Youth"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF(YOUTH!R35=\"\",\"\",YOUTH!R35)","v":""},{"$f":"IF(G35=\"\",\"\",LEFT(G35,3))","v":""},{"$f":"IF('JUNIOR 1'!D35=\"\",\"\",'JUNIOR 1'!D35)","v":""},{"$f":"IF('JUNIOR 1'!E35=\"\",\"\",'JUNIOR 1'!E35)","v":""},{"$f":"LEFT(J35,15)","v":""},{"$f":"IFERROR(VLOOKUP($X35,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y35=0,Y35=\"\"),0,1)","v":0},{"$f":"IF(X35<>\"\",1,0)","v":0},{"$f":"AB34-Z34","v":0},"nb dans gruniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF(YOUTH!R36=\"\",\"\",YOUTH!R36)","v":""},"",{"$f":"IF('JUNIOR 1'!D36=\"\",\"\",'JUNIOR 1'!D36)","v":""},{"$f":"IF('JUNIOR 1'!E36=\"\",\"\",'JUNIOR 1'!E36)","v":""},"",{"$f":"IFERROR(VLOOKUP($X36,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y36=0,Y36=\"\"),0,1)","v":0},{"$f":"IF(X36<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF(YOUTH!R37=\"\",\"\",YOUTH!R37)","v":""},"",{"$f":"IF('JUNIOR 1'!D37=\"\",\"\",'JUNIOR 1'!D37)","v":""},{"$f":"IF('JUNIOR 1'!E37=\"\",\"\",'JUNIOR 1'!E37)","v":""},"",{"$f":"IFERROR(VLOOKUP($X37,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y37=0,Y37=\"\"),0,1)","v":0},0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF(YOUTH!R38=\"\",\"\",YOUTH!R38)","v":""},"",{"$f":"IF('JUNIOR 1'!D38=\"\",\"\",'JUNIOR 1'!D38)","v":""},{"$f":"IF('JUNIOR 1'!E38=\"\",\"\",'JUNIOR 1'!E38)","v":""},"","",0,0]
[null,{"$f":"Z34","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF(YOUTH!R39=\"\",\"\",YOUTH!R39)","v":""},"",{"$f":"IF('JUNIOR 1'!D39=\"\",\"\",'JUNIOR 1'!D39)","v":""},{"$f":"IF('JUNIOR 1'!E39=\"\",\"\",'JUNIOR 1'!E39)","v":""},"","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF(YOUTH!R40=\"\",\"\",YOUTH!R40)","v":""},"",{"$f":"IF('JUNIOR 1'!D40=\"\",\"\",'JUNIOR 1'!D40)","v":""},{"$f":"IF('JUNIOR 1'!E40=\"\",\"\",'JUNIOR 1'!E40)","v":""},"","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF(YOUTH!R41=\"\",\"\",YOUTH!R41)","v":""},"",{"$f":"IF('JUNIOR 1'!D41=\"\",\"\",'JUNIOR 1'!D41)","v":""},{"$f":"IF('JUNIOR 1'!E41=\"\",\"\",'JUNIOR 1'!E41)","v":""},"","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF(YOUTH!R42=\"\",\"\",YOUTH!R42)","v":""},"",{"$f":"IF('JUNIOR 1'!D42=\"\",\"\",'JUNIOR 1'!D42)","v":""},{"$f":"IF('JUNIOR 1'!E42=\"\",\"\",'JUNIOR 1'!E42)","v":""},"","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF(YOUTH!R43=\"\",\"\",YOUTH!R43)","v":""},"",{"$f":"IF('JUNIOR 1'!D43=\"\",\"\",'JUNIOR 1'!D43)","v":""},{"$f":"IF('JUNIOR 1'!E43=\"\",\"\",'JUNIOR 1'!E43)","v":""},"","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF(YOUTH!R44=\"\",\"\",YOUTH!R44)","v":""},"",{"$f":"IF('JUNIOR 1'!D44=\"\",\"\",'JUNIOR 1'!D44)","v":""},{"$f":"IF('JUNIOR 1'!E44=\"\",\"\",'JUNIOR 1'!E44)","v":""},"","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"IF(YOUTH!R45=\"\",\"\",YOUTH!R45)","v":""},"",{"$f":"IF('JUNIOR 1'!D45=\"\",\"\",'JUNIOR 1'!D45)","v":""},{"$f":"IF('JUNIOR 1'!E45=\"\",\"\",'JUNIOR 1'!E45)","v":""},"","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"IF(YOUTH!R46=\"\",\"\",YOUTH!R46)","v":""},"",{"$f":"IF('JUNIOR 1'!D46=\"\",\"\",'JUNIOR 1'!D46)","v":""},{"$f":"IF('JUNIOR 1'!E46=\"\",\"\",'JUNIOR 1'!E46)","v":""},"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF(YOUTH!R47=\"\",\"\",YOUTH!R47)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF(YOUTH!R48=\"\",\"\",YOUTH!R48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF(YOUTH!R49=\"\",\"\",YOUTH!R49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF(YOUTH!R50=\"\",\"\",YOUTH!R50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF(YOUTH!R51=\"\",\"\",YOUTH!R51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF(YOUTH!R52=\"\",\"\",YOUTH!R52)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF(YOUTH!R53=\"\",\"\",YOUTH!R53)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(YOUTH!R54=\"\",\"\",YOUTH!R54)","v":""}]

{"sheet":"GROUPE ADULTE","index":15,"n_rows":104,"n_cols":29,"rows_kept":104,"cut":false,"hidden":false,"merged":[[32,16,32,17],[36,3,45,4],[21,3,30,4],[32,0,33,0],[32,1,33,1],[32,2,33,2],[32,3,33,3],[32,4,33,4],[21,0,22,2],[23,1,25,1],[36,0,37,2],[38,1,40,1],[32,5,33,5],[32,6,32,9],[32,11,32,15],[2,16,2,17],[6,3,15,4],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,17,9],[17,11,17,15],[17,16,17,17],[6,0,7,2],[8,1,10,1],[0,7,0,9],[0,12,0,13],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,2,9],[2,11,2,15]]}
[null,null,null,null,null,null,"GROUPE"," ADULTE",null,null,null,null,"Date de naissance entre :",null,null,null,null,null,null,null,"inscription groupe adulte"]
[{"$f":"COUNTA(C5,C20,C35)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"FEUIL1!I16","v":"1925-01-01"},{"$f":"FEUIL1!J16","v":"2005-12-31"},null,null,null,null,null,"reference solo","nom groupr","prenom groupe","naissance groupe","lic recons  groupe",null,"danseurs 2 categories","danseurs groupe"]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,null,null,null,null,null,null,null,null,null,"nb danseur",{"$f":"AB5+AB20+AB35","v":0}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",null,"lic recons ",null,null,null,null,null,{"$f":"SUM(Z5:Z16)","v":0},{"$f":"SUM(AA5:AA16)","v":0},{"$f":"AA4","v":0},"nb danseur groupe"]
[1,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Adulte"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(ADULTE!R5=\"\",\"\",ADULTE!R5)","v":""},{"$f":"IF(G5=\"\",\"\",LEFT(G5,3))","v":""},{"$f":"IF(H5=\"\",\"\",LEFT(H5,2))","v":""},{"$f":"IF(I5>0,CONCATENATE(TEXT(I5,\"aaaa\"),TEXT(I5,\"mm\"),TEXT(I5,\"jj\")),\"\")","v":""},{"$f":"IF(U5<>\"\",CONCATENATE(W5,\"-\",U5,\"-\",V5),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X5,$T$5:$X$55,1,FALSE),0)","v":""},{"$f":"IF(OR(Y5=0,Y5=\"\"),0,1)","v":0},{"$f":"IF(X5<>\"\",1,0)","v":0},{"$f":"AB4-Z4","v":0},"nb dans groupe uniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(YOUTH!R6=\"\",\"\",YOUTH!R6)","v":""},{"$f":"IF(G6=\"\",\"\",LEFT(G6,3))","v":""},{"$f":"IF(H6=\"\",\"\",LEFT(H6,2))","v":""},{"$f":"IF(I6>0,CONCATENATE(TEXT(I6,\"aaaa\"),TEXT(I6,\"mm\"),TEXT(I6,\"jj\")),\"\")","v":""},{"$f":"IF(U6<>\"\",CONCATENATE(W6,\"-\",U6,\"-\",V6),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X6,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y6=0,Y6=\"\"),0,1)","v":0},{"$f":"IF(X6<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(YOUTH!R7=\"\",\"\",YOUTH!R7)","v":""},"","","","","",0,0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(YOUTH!R8=\"\",\"\",YOUTH!R8)","v":""},"","","","","",0,0]
[null,{"$f":"Z4","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(YOUTH!R9=\"\",\"\",YOUTH!R9)","v":""},"","","","","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(YOUTH!R10=\"\",\"\",YOUTH!R10)","v":""},"","","","","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(YOUTH!R11=\"\",\"\",YOUTH!R11)","v":""},"","","","","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF(YOUTH!R12=\"\",\"\",YOUTH!R12)","v":""},"","","","","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"IF(YOUTH!R13=\"\",\"\",YOUTH!R13)","v":""},"","","","","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF(YOUTH!R14=\"\",\"\",YOUTH!R14)","v":""},"","","","","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF(YOUTH!R15=\"\",\"\",YOUTH!R15)","v":""},"","","","","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF(YOUTH!R16=\"\",\"\",YOUTH!R16)","v":""},"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF(YOUTH!R17=\"\",\"\",YOUTH!R17)","v":""},null,{"$f":"IF('JUNIOR 1'!D17=\"\",\"\",'JUNIOR 1'!D17)","v":""},{"$f":"IF('JUNIOR 1'!E17=\"\",\"\",'JUNIOR 1'!E17)","v":""}]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,14,{"$f":"IF(YOUTH!R18=\"\",\"\",YOUTH!R18)","v":""},null,{"$f":"IF('JUNIOR 1'!D18=\"\",\"\",'JUNIOR 1'!D18)","v":""},{"$f":"IF('JUNIOR 1'!E18=\"\",\"\",'JUNIOR 1'!E18)","v":""}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",15,{"$f":"IF(YOUTH!R19=\"\",\"\",YOUTH!R19)","v":""},null,{"$f":"IF('JUNIOR 1'!D19=\"\",\"\",'JUNIOR 1'!D19)","v":""},{"$f":"IF('JUNIOR 1'!E19=\"\",\"\",'JUNIOR 1'!E19)","v":""},null,null,{"$f":"SUM(Z20:Z31)","v":0},{"$f":"SUM(AA20:AA31)","v":0},{"$f":"AA19","v":0},"nb danseur groupe"]
[2,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Adulte"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(YOUTH!R20=\"\",\"\",YOUTH!R20)","v":""},{"$f":"IF(G20=\"\",\"\",LEFT(G20,3))","v":""},{"$f":"IF(H20=\"\",\"\",LEFT(H20,2))","v":""},{"$f":"IF(I20>0,CONCATENATE(TEXT(I20,\"aaaa\"),TEXT(I20,\"mm\"),TEXT(I20,\"jj\")),\"\")","v":""},{"$f":"IF(U20<>\"\",CONCATENATE(W20,\"-\",U20,\"-\",V20),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X20,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y20=0,Y20=\"\"),0,1)","v":0},{"$f":"IF(X20<>\"\",1,0)","v":0},{"$f":"AB19-Z19","v":0},"nb dans groupe uniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(YOUTH!R21=\"\",\"\",YOUTH!R21)","v":""},"",{"$f":"IF(H21=\"\",\"\",LEFT(H21,2))","v":""},{"$f":"IF(I21>0,CONCATENATE(TEXT(I21,\"aaaa\"),TEXT(I21,\"mm\"),TEXT(I21,\"jj\")),\"\")","v":""},{"$f":"IF(U21<>\"\",CONCATENATE(W21,\"-\",U21,\"-\",V21),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X21,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y21=0,Y21=\"\"),0,1)","v":0},{"$f":"IF(X21<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF(YOUTH!R22=\"\",\"\",YOUTH!R22)","v":""},"",{"$f":"IF(H22=\"\",\"\",LEFT(H22,2))","v":""},{"$f":"IF(I22>0,CONCATENATE(TEXT(I22,\"aaaa\"),TEXT(I22,\"mm\"),TEXT(I22,\"jj\")),\"\")","v":""},{"$f":"IF(U22<>\"\",CONCATENATE(W22,\"-\",U22,\"-\",V22),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($X22,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y22=0,Y22=\"\"),0,1)","v":0},0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF(YOUTH!R23=\"\",\"\",YOUTH!R23)","v":""},"","","","","",0,0]
[null,{"$f":"Z19","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF(YOUTH!R24=\"\",\"\",YOUTH!R24)","v":""},"","","","","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF(YOUTH!R25=\"\",\"\",YOUTH!R25)","v":""},"","","","","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF(YOUTH!R26=\"\",\"\",YOUTH!R26)","v":""},"","","","","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF(YOUTH!R27=\"\",\"\",YOUTH!R27)","v":""},"","","","","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(YOUTH!R28=\"\",\"\",YOUTH!R28)","v":""},"","","","","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF(YOUTH!R29=\"\",\"\",YOUTH!R29)","v":""},"","","","","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF(YOUTH!R30=\"\",\"\",YOUTH!R30)","v":""},"","","","","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF(YOUTH!R31=\"\",\"\",YOUTH!R31)","v":""},"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF(YOUTH!R32=\"\",\"\",YOUTH!R32)","v":""}]
["N°","Catégorie","Titre de la Chorégraphie\n(Obligatoire)","Durée","Décors",null,"DANSEURS",null,null,null,null,"Chorégraphe",null,null,null,null,"MUSIQUES UTILISEES",null,29,{"$f":"IF(YOUTH!R33=\"\",\"\",YOUTH!R33)","v":""},null,{"$f":"IF('JUNIOR 1'!D33=\"\",\"\",'JUNIOR 1'!D33)","v":""},{"$f":"IF('JUNIOR 1'!E33=\"\",\"\",'JUNIOR 1'!E33)","v":""}]
[null,null,null,null,null,null,"Nom\n(obligatoire)","Prénom\n(obligatoire)","Date de Naissance\n(obligatoire)","N° Licence",null,"Nom","Prénom","N° Licence","Téléphone","E-mail","Titre Musique","Compositeur (s)",30,{"$f":"IF(YOUTH!R34=\"\",\"\",YOUTH!R34)","v":""},null,{"$f":"IF('JUNIOR 1'!D34=\"\",\"\",'JUNIOR 1'!D34)","v":""},{"$f":"IF('JUNIOR 1'!E34=\"\",\"\",'JUNIOR 1'!E34)","v":""},null,null,{"$f":"SUM(Z35:Z46)","v":0},{"$f":"SUM(AA35:AA46)","v":0},{"$f":"COUNTA(G35:G46)","v":0},"nb danseur groupe"]
[3,{"$f":"CONCATENATE(PROPER($G$1),PROPER($H$1))","v":"Groupe Adulte"},null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF(YOUTH!R35=\"\",\"\",YOUTH!R35)","v":""},{"$f":"IF(G35=\"\",\"\",LEFT(G35,3))","v":""},{"$f":"IF('JUNIOR 1'!D35=\"\",\"\",'JUNIOR 1'!D35)","v":""},{"$f":"IF('JUNIOR 1'!E35=\"\",\"\",'JUNIOR 1'!E35)","v":""},{"$f":"LEFT(J35,15)","v":""},{"$f":"IFERROR(VLOOKUP($X35,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y35=0,Y35=\"\"),0,1)","v":0},{"$f":"IF(X35<>\"\",1,0)","v":0},{"$f":"AB34-Z34","v":0},"nb dans gruniquement"]
[null,null,null,"\n ","Si oui",2,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF(YOUTH!R36=\"\",\"\",YOUTH!R36)","v":""},"",{"$f":"IF('JUNIOR 1'!D36=\"\",\"\",'JUNIOR 1'!D36)","v":""},{"$f":"IF('JUNIOR 1'!E36=\"\",\"\",'JUNIOR 1'!E36)","v":""},"",{"$f":"IFERROR(VLOOKUP($X36,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y36=0,Y36=\"\"),0,1)","v":0},{"$f":"IF(X36<>\"\",1,0)","v":0}]
["Nombre de Danseurs inscrits en SOLO\ndans ce Groupe",null,null,"Etablir la liste des décors:",null,3,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF(YOUTH!R37=\"\",\"\",YOUTH!R37)","v":""},"",{"$f":"IF('JUNIOR 1'!D37=\"\",\"\",'JUNIOR 1'!D37)","v":""},{"$f":"IF('JUNIOR 1'!E37=\"\",\"\",'JUNIOR 1'!E37)","v":""},"",{"$f":"IFERROR(VLOOKUP($X37,$T$5:$X$104,1,FALSE),0)","v":""},{"$f":"IF(OR(Y37=0,Y37=\"\"),0,1)","v":0},0]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF(YOUTH!R38=\"\",\"\",YOUTH!R38)","v":""},"",{"$f":"IF('JUNIOR 1'!D38=\"\",\"\",'JUNIOR 1'!D38)","v":""},{"$f":"IF('JUNIOR 1'!E38=\"\",\"\",'JUNIOR 1'!E38)","v":""},"","",0,0]
[null,{"$f":"Z34","v":0},null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF(YOUTH!R39=\"\",\"\",YOUTH!R39)","v":""},"",{"$f":"IF('JUNIOR 1'!D39=\"\",\"\",'JUNIOR 1'!D39)","v":""},{"$f":"IF('JUNIOR 1'!E39=\"\",\"\",'JUNIOR 1'!E39)","v":""},"","",0,0]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF(YOUTH!R40=\"\",\"\",YOUTH!R40)","v":""},"",{"$f":"IF('JUNIOR 1'!D40=\"\",\"\",'JUNIOR 1'!D40)","v":""},{"$f":"IF('JUNIOR 1'!E40=\"\",\"\",'JUNIOR 1'!E40)","v":""},"","",0,0]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF(YOUTH!R41=\"\",\"\",YOUTH!R41)","v":""},"",{"$f":"IF('JUNIOR 1'!D41=\"\",\"\",'JUNIOR 1'!D41)","v":""},{"$f":"IF('JUNIOR 1'!E41=\"\",\"\",'JUNIOR 1'!E41)","v":""},"","",0,0]
[null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF(YOUTH!R42=\"\",\"\",YOUTH!R42)","v":""},"",{"$f":"IF('JUNIOR 1'!D42=\"\",\"\",'JUNIOR 1'!D42)","v":""},{"$f":"IF('JUNIOR 1'!E42=\"\",\"\",'JUNIOR 1'!E42)","v":""},"","",0,0]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF(YOUTH!R43=\"\",\"\",YOUTH!R43)","v":""},"",{"$f":"IF('JUNIOR 1'!D43=\"\",\"\",'JUNIOR 1'!D43)","v":""},{"$f":"IF('JUNIOR 1'!E43=\"\",\"\",'JUNIOR 1'!E43)","v":""},"","",0,0]
[null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF(YOUTH!R44=\"\",\"\",YOUTH!R44)","v":""},"",{"$f":"IF('JUNIOR 1'!D44=\"\",\"\",'JUNIOR 1'!D44)","v":""},{"$f":"IF('JUNIOR 1'!E44=\"\",\"\",'JUNIOR 1'!E44)","v":""},"","",0,0]
[null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"IF(YOUTH!R45=\"\",\"\",YOUTH!R45)","v":""},"",{"$f":"IF('JUNIOR 1'!D45=\"\",\"\",'JUNIOR 1'!D45)","v":""},{"$f":"IF('JUNIOR 1'!E45=\"\",\"\",'JUNIOR 1'!E45)","v":""},"","",0,0]
[null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"IF(YOUTH!R46=\"\",\"\",YOUTH!R46)","v":""},"",{"$f":"IF('JUNIOR 1'!D46=\"\",\"\",'JUNIOR 1'!D46)","v":""},{"$f":"IF('JUNIOR 1'!E46=\"\",\"\",'JUNIOR 1'!E46)","v":""},"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF(YOUTH!R47=\"\",\"\",YOUTH!R47)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF(YOUTH!R48=\"\",\"\",YOUTH!R48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF(YOUTH!R49=\"\",\"\",YOUTH!R49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF(YOUTH!R50=\"\",\"\",YOUTH!R50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF(YOUTH!R51=\"\",\"\",YOUTH!R51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF(YOUTH!R52=\"\",\"\",YOUTH!R52)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF(YOUTH!R53=\"\",\"\",YOUTH!R53)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(YOUTH!R54=\"\",\"\",YOUTH!R54)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]

{"sheet":"FEUIL1","index":16,"n_rows":120,"n_cols":10,"rows_kept":120,"cut":false,"hidden":true,"merged":[[0,3,0,4],[8,3,8,4],[11,3,11,4]]}
["BRETAGNE",null,null,"Solo",null,{"$f":"'COORDONNEES DES STRUCTURES'!$C$7","v":2023},{"$f":"F1+1","v":2024}]
["PAYS-DE-LA- LOIRE",null,null,"Ages","Mini","Maxi","année mini","année maxi","date de naissance entre :"]
["NOUVELLE-AQUITAINE",null,null,"juvenile 1",9,10,{"$f":"$G$1-E3","v":2015},2014,{"$f":"DATE(H3,1,1)","v":"2014-01-01"},{"$f":"DATE(G3,12,31)","v":"2015-12-31"}]
["OCCITANIE",null,null,"juvenile 2",11,11,2013,2013,"2013-01-01","2013-12-31"]
["PROVENCE-ALPES-CÔTE-D'AZUR",null,null,"junior 1",12,13,2012,2011,"2011-01-01","2012-12-31"]
["GRAND-EST",null,null,"junior 2",14,15,2010,2009,"2009-01-01","2010-12-31"]
["BOURGOGNE-FRANCHE-COMTE",null,null,"youth",16,18,2008,2006,"2006-01-01","2008-12-31"]
["AUVERGNE-RHÔNE-ALPES",null,null,"adulte",19,99,2005,1925,"1925-01-01","2005-12-31"]
["NORMANDIE",null,null,"Duo"]
["HAUTS-DE-FRANCE",null,null,"youth",16,18,{"$f":"$G$1-E10","v":2008},{"$f":"$G$1-F10","v":2006},{"$f":"DATE(H10,1,1)","v":"2006-01-01"},{"$f":"DATE(G10,12,31)","v":"2008-12-31"}]
["CENTRE-VAL-DE-LOIRE",null,null,"adultes",19,99,{"$f":"$G$1-E11","v":2005},{"$f":"$G$1-F11","v":1925},{"$f":"DATE(H11,1,1)","v":"1925-01-01"},{"$f":"DATE(G11,12,31)","v":"2005-12-31"}]
["ILE-DE-FRANCE",null,null,"Groupe"]
["DOM-TOM",null,null,"juvenile",9,11,{"$f":"$G$1-E13","v":2015},2013,{"$f":"DATE(H13,1,1)","v":"2013-01-01"},{"$f":"DATE(G13,12,31)","v":"2015-12-31"}]
["Ain (01)",null,null,"junior",12,15,2012,2009,{"$f":"DATE(H14,1,1)","v":"2009-01-01"},{"$f":"DATE(G14,12,31)","v":"2012-12-31"}]
["Aisne (02)",null,null,"youth",16,18,2008,2006,{"$f":"DATE(H15,1,1)","v":"2006-01-01"},{"$f":"DATE(G15,12,31)","v":"2008-12-31"}]
["Allier (03)",null,null,"adulte",19,99,2005,1925,{"$f":"DATE(H16,1,1)","v":"1925-01-01"},{"$f":"DATE(G16,12,31)","v":"2005-12-31"}]
["Alpes-de-Haute-Provence (04)"]
["Hautes-Alpes (05)",null,null,"Droit d'entrée"]
["Alpes Maritimes (06)",null,null,"solo",10]
["Ardèche (07)",null,null,"duo",20]
["Ardennes (08)",null,null,"groupe",30]
["Ariège (09)"]
["Aube (10)"]
["Aude (11)"]
["Aveyron (12)"]
["Bouches-du-Rhône (13)"]
["Calvados (14)"]
["Cantal (15)"]
["Charente (16)"]
["Charente-Maritime  (17)"]
["Cher (18)"]
["Corrèze (19)"]
["Corse-du-Sud (2A)"]
["Haute Corse (2B)"]
["Côte-d'Or (21)"]
["Côtes d'Armor (22)"]
["Creuse (23)"]
["Dordogne (24)"]
["Doubs (25)"]
["Drôme (26)"]
["Eure (27)"]
["Eure-et-Loir (28)"]
["Finistère (29)"]
["Gard (30)"]
["Haute Garonne (31)"]
["Gers (32)"]
["Gironde (33)"]
["Hérault (34)"]
["Ille-et-Vilaine (35)"]
["Indre (36)"]
["Indre-et-Loire (37)"]
["Isère (38)"]
["Jura (39)"]
["Landes (40)"]
["Loir-et-Cher (41)"]
["Loire (42)"]
["Haute Loire (43)"]
["Loire Atlantique (44)"]
["Loiret (45)"]
["Lot (46)"]
["Lot-et-Garonne (47)"]
["Lozère (48)"]
["Maine-et-Loire (49)"]
["Manche (50)"]
["Marne (51)"]
["Haute Marne (52)"]
["Mayenne (53)"]
["Meurthe-et-Moselle (54)"]
["Meuse (55)"]
["Morbihan (56)"]
["Moselle (57)"]
["Nièvre (58)"]
["Nord (59)"]
["Oise (60)"]
["Orne (61)"]
["Pas-de-Calais (62)"]
["Puy-de-Dôme (63)"]
["Pyrénées Atlantiques (64)"]
["Hautes Pyrénées (65)"]
["Pyrénées Orientales (66)"]
["Bas-Rhin (67)"]
["Haut-Rhin (68)"]
["Rhône (69)"]
["Haute Saône (70)"]
["Saône-et-Loire (71)"]
["Sarthe (72)"]
["Savoie (73)"]
["Haute Savoie (74)"]
["Paris (75)"]
["Seine Maritime (76)"]
["Seine-et-Marne  (77)"]
["Yvelines (78)"]
["Deux-Sèvres (79)"]
["Somme (80)"]
["Tarn (81)"]
["Tarn-et-Garonne (82)"]
["Var (83)"]
["Vaucluse (84)"]
["Vendée (85)"]
["Vienne (86)"]
["Haute Vienne (87)"]
["Vosges (88)"]
["Yonne (89)"]
["Territoire de Belfort (90)"]
["Essonne (91)"]
["Hauts-de-Seine (92)"]
["Seine-St-Denis (93)"]
["Val-de-Marne (94)"]
["Val-D'Oise (95)"]
["Guadeloupe (971)"]
["Martinique (972)"]
["Guyane (973)"]
["La Réunion (974)"]
["Saint Pierre et Miquelon(975)"]
["Mayotte (976)"]
["Saint Martin(978)"]
["Wallis et Futumas(986)"]
["Polynésie(987)"]
["Nouvelle Calédonie(988)"]
["Monaco(980)"]