{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Fiche_Inscription"],"not_rendered":{"images":3,"macros":1,"external_links":2,"defined_names":43},"read":"whole","date_system":"1900"}

{"sheet":"Fiche_Inscription","index":0,"n_rows":86,"n_cols":33,"rows_kept":86,"merged":[[0,7,0,10],[1,7,2,8],[1,9,2,10],[6,0,6,14],[7,32,7,34],[8,0,8,14],[12,3,12,6],[12,9,12,11],[13,1,13,7],[13,8,13,9],[13,10,13,14],[13,32,13,34],[14,0,14,2],[14,3,14,7],[14,8,14,9],[14,10,14,12],[15,0,15,2],[15,3,15,14],[16,0,16,2],[16,5,16,14],[17,0,17,2],[17,3,17,6],[17,7,17,9],[17,10,17,14],[18,0,18,2],[18,3,18,14],[19,0,19,2],[19,3,19,6],[19,7,19,10],[19,11,19,14],[24,9,28,14],[30,8,30,14],[31,8,31,14],[32,8,32,14],[34,6,34,7],[34,8,34,10],[34,11,34,14],[35,6,35,7],[35,8,35,10],[35,11,35,14],[35,18,35,24],[36,6,36,7],[36,8,36,10],[36,11,36,14],[37,4,37,5],[37,6,37,7],[37,8,37,10],[37,11,37,14],[40,0,40,14],[41,7,41,10],[41,12,41,14],[43,2,43,10],[43,12,43,14],[45,7,46,14],[49,0,49,14],[51,3,51,14],[52,7,52,14],[54,3,54,6],[54,11,54,14],[55,3,55,14],[56,0,56,14],[57,3,57,6],[57,10,57,14],[58,3,58,14],[60,0,60,14],[61,0,61,11],[62,0,63,14],[65,0,65,14],[66,0,67,14],[71,5,71,10],[72,3,72,10],[73,2,73,10],[77,0,77,14]]}
[null,null,"AÏKIDO La Teste",{"$nulls":4},"Saison",{"$nulls":9},"Situation","Fédérations",{"$f":"H2&\" - \"&J2","v":"2024 - - 2025"},"Âge mini","Âge maxi","Date mini","Date max","Coef Tarif","Cotisation",{"$f":"SUM(AA2:AA6)*IF(Bénévole=X,Y17,1)*IF(Famille_2é=X,Y14,1)*IF(Famille_3é=X,Y15,1)*IF(Social=X,Y16,1)","v":0},"Licences",{"$f":"SUM(AC2:AC6)","v":0},"Passeport",{"$f":"SUM(AE2:AE6)","v":0}]
[null,null,"Dojos J. FERRE à Cazaux",{"$nulls":4},{"$f":"IF( MONTH(TODAY())>7,YEAR(TODAY())&\" -\",YEAR(TODAY())-1&\" -\")","v":"2024 -"},null,{"$f":"IF( MONTH(TODAY())>7,YEAR(TODAY())+1,YEAR(TODAY()))","v":2025},{"$nulls":7},{"$f":"IF(AND(DateNaiss<X2,DateNaiss>W2,Etudiant=\"\"),\"x\",\"\")","v":""},"FFAAA","AÏKIDO adulte",18,99,{"$f":"DATE(IF(MONTH(TODAY())>8,YEAR(TODAY()),YEAR(TODAY()-1))-AgeMax,9,1)","v":"1925-09-01"},{"$f":"DATE(IF(MONTH(TODAY())>8,YEAR(TODAY()),YEAR(TODAY()-1))-AgeMini,9,1)-1","v":"2006-08-31"},{"v":1,"d":"100%"},{"$f":"Y2*Cotisatio_basique","v":{"v":160,"d":"160 €"}},{"$f":"IF($R2=\"x\",Z2,\"\")","v":""},{"v":38,"d":"38 €"},{"$f":"IF($R2=\"x\",AB2,\"\")","v":""},{"v":15,"d":"15 €"},{"$f":"IF(AND(PasseportSelect=$S$24,$R2=$T$24),AD2,\"\")","v":""}]
[null,null,"33260 LA TESTE DE BUCH",{"$nulls":14},{"$f":"IF(AND(DateNaiss<X3,DateNaiss>W3,Etudiant=\"\"),\"x\",\"\")","v":""},"FFAAA","AÏKIDO jeune 13<<18",13,18,{"$f":"DATE(IF(MONTH(TODAY())>8,YEAR(TODAY()),YEAR(TODAY()-1))-AgeMax,9,1)","v":"2006-09-01"},{"$f":"DATE(IF(MONTH(TODAY())>8,YEAR(TODAY()),YEAR(TODAY()-1))-AgeMini,9,1)-1","v":"2011-08-31"},{"v":0.8,"d":"80%"},{"$f":"Y3*Cotisatio_basique","v":{"v":128,"d":"128 €"}},{"$f":"IF($R3=\"x\",Z3,\"\")","v":""},{"v":38,"d":"38 €"},{"$f":"IF($R3=\"x\",AB3,\"\")","v":""},{"v":15,"d":"15 €"},{"$f":"IF(AND(PasseportSelect=$S$24,$R3=$T$24),AD3,\"\")","v":""}]
[null,null,"Tél.: 06 62 47 44 60",{"$nulls":14},{"$f":"IF(AND(DateNaiss<X4,DateNaiss>W4,Etudiant=\"\"),\"x\",\"\")","v":""},"FFAAA","AÏKIDO jeune <13",6,13,{"$f":"DATE(IF(MONTH(TODAY())>8,YEAR(TODAY()),YEAR(TODAY()-1))-AgeMax,9,1)","v":"2011-09-01"},{"$f":"DATE(IF(MONTH(TODAY())>8,YEAR(TODAY()),YEAR(TODAY()-1))-AgeMini,9,1)-1","v":"2018-08-31"},{"v":0.8,"d":"80%"},{"$f":"Y4*Cotisatio_basique","v":{"v":128,"d":"128 €"}},"",{"v":26,"d":"26 €"},"",{"v":15,"d":"15 €"},{"$f":"IF(AND(PasseportSelect=$S$24,$R4=$T$24),AD4,\"\")","v":""}]
[null,null,"alt.aikido@gmail.com",{"$nulls":14},{"$f":"IF(AND(Etudiant=X,DateNaiss>W5),\"x\",\"\")","v":""},"FFAAA","AÏKIDO étudiant 13<<25",13,25,{"$f":"DATE(IF(MONTH(TODAY())>8,YEAR(TODAY()),YEAR(TODAY()-1))-AgeMax,9,1)","v":"1999-09-01"},{"$f":"DATE(IF(MONTH(TODAY())>8,YEAR(TODAY()),YEAR(TODAY()-1))-AgeMini,9,1)-1","v":"2011-08-31"},{"v":0.8,"d":"80%"},{"$f":"Y5*Cotisatio_basique","v":{"v":128,"d":"128 €"}},"",{"v":26,"d":"26 €"},"",{"v":15,"d":"15 €"},{"$f":"IF(AND(PasseportSelect=$S$24,$R5=$T$24),AD5,\"\")","v":""}]
[]
["FICHE D'INSCRIPTION INDIVIDUELLE",{"$nulls":31},"Préremplissage Adhérent"]
[{"$nulls":15},"Nom"]
[]
[{"$nulls":3},"AÏKIDO","X"]
[]
[]
[{"$nulls":23},"Étudiant",{"$f":"Y5","v":{"v":0.8,"d":"80%"}}]
["Nom",{"$f":"IF(Nom_Adhérent=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,1,TRUE))","v":""},{"$nulls":6},"Prénom",null,{"$f":"IF(Nom_Adhérent=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,2,TRUE))","v":""},{"$nulls":4},"Prénom",{"$nulls":7},"2éme/famille",{"v":0.8,"d":"80%"}]
["Date de naiss.*",null,null,{"$f":"IF(Nom_Adhérent=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,4,TRUE))","v":""},{"$nulls":4},"Âge",null,{"$f":"IF(DateNaiss=\"\",\"\",INT(YEAR(TODAY())-YEAR(DateNaiss)+(MONTH(TODAY())-MONTH(DateNaiss))/12))","v":""},null,null,"Genre",{"$f":"IF(Nom_Adhérent=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,3,TRUE))","v":""},{"$nulls":8},"≥3e /famille",{"v":0.1,"d":"10%"}]
["Adresse postale",null,null,{"$f":"IF(Nom_Adhérent=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$100,7,TRUE))","v":""},{"$nulls":19},"Sociale",{"v":0.1,"d":"10%"}]
["Code postal",null,null,{"$f":"IF(Nom_Adhérent=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,8,TRUE))","v":""},"Ville",{"$f":"IF(Nom_Adhérent=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,9,TRUE))","v":""},{"$nulls":17},"Bénévole",{"v":0.1,"d":"10%"}]
["Téléphone 1",null,null,{"$f":"IF(Nom_Adhérent=\"\",\"\",IF(VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,10,TRUE)=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,10,TRUE)))","v":""},{"$nulls":3},"Téléphone 2",null,null,{"$f":"IF(Nom_Adhérent=\"\",\"\",IF(VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,11,TRUE)=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,11,TRUE)))","v":""}]
["Adresse courriel",null,null,{"$f":"IF(Nom_Adhérent=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,12,TRUE))","v":""}]
["N° adh. au club",null,null,{"$f":"IF(Nom_Adhérent=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,13,TRUE))","v":""},{"$nulls":3},"N° licence fédérale",{"$nulls":3},{"$f":"IF(Nom_Adhérent=\"\",\"\",VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,14,TRUE))","v":""}]
[]
[]
[{"$nulls":5},"Paiement annuel",{"$nulls":11},"Coef Tarif","Présélections"]
[null,"Étudiant",null,"2e/famille","≥3e/famille",null,"Sociale","Bénévole",null,"Observation :",{"$nulls":8},"oui","X","opt 1",{"v":11,"d":"€11"},"H","courriel","espèce","NON\n à la totalité des rubriques","papier"]
[{"$nulls":4},{"$f":"IF(Nom_Adhérent=\"\",\"\",IF(VLOOKUP(Nom_Adhérent,[1]Coordonnées!$B$3:$V$82,19,TRUE)=\"\",\"\",VLOOKUP(Nom_Adhérent,[1]Coordonnées!$B$3:$V$82,19,TRUE)))","v":""},null,{"$f":"IF(Nom_Adhérent=\"\",\"\",IF(VLOOKUP(Nom_Adhérent,[1]Coordonnées!$B$3:$V$82,20,TRUE)=\"\",\"\",VLOOKUP(Nom_Adhérent,[1]Coordonnées!$B$3:$V$82,20,TRUE)))","v":""},{"$nulls":11},"non",null,"opt 2",{"v":15,"d":"€15"},"F","papier","chèque"," OUI\n à l’une ou plusieurs rubriques","numérique "]
[{"$nulls":20},"rien",null,"N",null,null,"Certificat médical < 3 mois","passeport"]
[null,null,"Cotisation",{"$f":"IFERROR(ROUNDDOWN(IF(Cotisation=0,\"\",IF(Cotisation<Cotisatio_basique*Y17,Cotisatio_basique*Y17,Cotisation)),0),\"\")","v":""},"€ ",{"$nulls":21},"pas de certif méd"]
[null,null,"Licence",{"$f":"IF(Licence=0,\"\",Licence)","v":""},"€"]
[null,null,"Assurance supl.",{"$f":"IFERROR(VLOOKUP(F29,U24:V26,2,TRUE),\"\")","v":""},"€"]
[null,null,"Cde passeport",{"$f":"IF(Passeport=0,\"\",Passeport)","v":""},"€"]
[null,null,"Total",{"$f":"SUM(D27:D30)","v":0},"€",null,null,"N° reçu                  "]
[{"$nulls":7},"Banque"]
[{"$nulls":7},"Nom porteur                                                       "]
[]
[{"$nulls":6},"Montant",null,"Date d'encaiss.",null,null,"N° Chq."]
[null,null,"Espèce"]
[null,null,"Virement"]
[null,null,"Chèque",null,"à l'ordre de\n\"AIKIDO La Teste\""]
[]
[]
["Certificat médical"]
["Attestat. de santé:",null,null,"réponse au questionnaire ",{"$nulls":7},"date",""]
[]
[null,"Médecin",{"$f":"IF(Nom_Adhérent=\"\",\"\",IF(VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,15,TRUE)>(TODAY()-(360*3-60)),VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,16,TRUE),\"\"))","v":""},{"$nulls":8},"date ",{"$f":"IF(Nom_Adhérent=\"\",\"\",IF(VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,15,TRUE)>(TODAY()-(360*3-60)),VLOOKUP(Nom_Adhérent,[2]Coordonnées!$B$3:$Q$99,15,TRUE),\"\"))","v":""}]
[]
["Indications médicales complémentaires :                                         "]
[]
[]
["Format : ",null,"papier",{"$nulls":3},"numérique ",{"$nulls":4},"sur le passeport",null,null,"…/…"]
["Autorisation parentale"]
[{"$nulls":6},"Pour les enfants mineurs"]
["Je soussigné(e),"]
["en tant que responsable légal de l’enfant",{"$nulls":6},{"$f":"IF(Nom_AutoPar=\"\",\"\",Nom &\" \"& Prénom&\",\")","v":""}]
["J’autorise ce dernier à pratiquer l'aïkido au sein du club Aïkido La Teste"]
[null,null,"Lien parental",{"$nulls":7},"Date de naissance"]
[null,null,"Adresse postale"]
[]
[null,null,"Téléphone 1",{"$nulls":6},"Téléphone 2"]
[null,null,"Adresse courriel"]
[]
["Règlement intérieur et statuts de l'association"]
["Ils sont disponibles sur demande ou sur le site du club :http://aiki.voieinterieure.free.fr"]
["Je reconnais avoir pris connaissance du règlement intérieur, des statuts de l'association ALT et du protocole sanitaire envigeur, que je accepte dans leur ensemble. Je m’engage à les respecter et les mettre en application, autant pour moi que pour les personnes qui m’accompagneront."]
[]
[]
["Droit à l'image"]
["Conformément au règlement intérieur, le signataire du présent document autorise, ou non, la captation de son image et de sa voix, ou celles du mineur qu'il représente, par les représentants du club pour la promotion de l'association AÏKIDO La Teste."]
[]
["Je donne le droit à l’image :",{"$nulls":4},"Oui",null,null,"Non"]
[]
[]
["Fait à La Teste-de-Buch, le ",{"$nulls":4},{"$f":"IF(Nom=\"\",\"\",TODAY())","v":""}]
["Nom / Prénom :",null,null,{"$f":"IF(NomParent=\"\",Nom&\" \"&Prénom,NomParent)","v":" "}]
["Signature : "]
[]
[]
[]
["Lieux, Horaires & Tarifs"]
["Séances Adultes et enfants > 13 ans : ",{"$nulls":12},"Tarification basique"]
["1er cours pour tous d'1h30 + 2é cours avancés de 0h30"]
[{"$nulls":12},"Cotisation club :",{"v":160,"d":"160 €"}]
["Dojo Jean FERRE:  rue des 100 Francs 33260 CAZAUX",{"$nulls":11},"Réduction, étudiant, famille:",{"v":0.2,"d":"20%"}]
[]
["Horaires principaux annuels",{"$nulls":11},"Licence FFAAA :",{"v":38,"d":"38 €"}]
["Mardi : 20h00 - 22h00 CLAVIER",{"$nulls":11},"Passeport FFAAA :",{"v":15,"d":"15 €"}]
["Jeudi : 20h00 - 22h00 CLAVIER"]