{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Clubs","Catégories","Menu","Mode d'emploi","Demande de Carte","Renouvellement de Licence","DOCUMENT UNIQUE LICENCE a","QUESTIONNAIRE DE SANTE MINEUR","DOCUMENT UNIQUE LICENCE","Vérification des Licences ","Feuille Comptable","Demande de Duplicata","DUPLICATA EN COURS D'ANNEE","Correction d'erreur","Feuil1"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":5,"defined_names":25,"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":"Clubs","index":0,"n_rows":70,"n_cols":2,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["N°Club","Club"]
[1004,"Fidèles Sud Loire"]
[1015,"Boulistes Avrillé"]
[1016,"La boule Angevine"]
[1025,"Les Amis de la Pétanque Trélazéenne"]
[1045,"ASPTT Angers Pétanque"]
[1119,"Intrépide d'Angers"]
[1198,"Club Angevin Amicale Laïque J. ferry"]
[1212,"Pétanque Club Empiré"]
[1249,"Pétanque Club Soulaire et Bourg"]
[1250,"La Rafle d'Angers"]
[1254,"SC Beaucouzé Pétanque"]
[1257,"Pétanque Saint Jean - Saint Martin"]
[1266,"Liberté Pétanque St-Melaine / Aubance"]
[1269,"Ecouflant Pétanque Club"]
[1274,"Pétanque Sylvanaise"]
[1275,"CE Pétanque les Ponts de Cé"]
[1280,"USAC Angers"]
[2008,"Pétanque Soucelloise"]
[2049,"Sarrigné Plessis Pétanque Club"]
[2076,"Durtal Pétanque Club"]
[2078,"Pétanque Beaufortaise"]
[2080,"Cochonnet Mazéais"]
[2148,"Soleil Pétanque de Baugé"]
[2160,"Pétanque Brainoise"]
[2223,"Pellouailles les Boules"]
[2244,"Pétanque Tiercéenne"]
[2264,"Pétanque Club Daumeray - Morannes"]
[2270,"E.S. Jarzé Pétanque"]
[3002,"Fanny Club Villedieu la Blouère"]
[3017,"Energie Pétanque le May sur Evre"]
[3040,"Montjean Pétanque"]
[3042,"Chemillé Pétanque"]
[3051,"Union Pétanquaise Saint Georges sur Loire"]
[3101,"Espetven Pétanque Saint Macaire"]
[3102,"ASPTT Cholet Pétanque"]
[3121,"ASEC Pétanque La Pommeraye"]
[3127,"Boule d'Or Montlimartoise"]
[3128,"Cholet pétanque club"]
[3129,"Saint Martin Sports Beaupréau"]
[3133,"Saint Michel Pétanque La Poitevinière"]
[3149,"CAEB Cholet Pétanque"]
[3169,"Pétanque Saint Légeoise"]
[3186,"En Avant La Tessoualle Pétanque"]
[3209,"NDC Pétanque La Jubaudière"]
[3220,"Avenir Pétanque Trémentines"]
[3226,"Jallais Pétanque Club"]
[3255,"Verger Pétanque Club Cholet"]
[3256,"ES Girardière pétanque de Cholet"]
[3261,"Pétanque Club andrezé"]
[3268,"Pétanque Club de Nuaillé"]
[3279,"Les Amis de la Pétanque Chemilloise"]
[3280,"Orée d'Anjou pétanque"]
[4094,"C.S.A. Allonnes Pétanque"]
[4112,"Pétanque Club Paul Biet longué"]
[4131,"Union Clémentaise Pétanque"]
[4150,"Avant Garde Pétanque Vivy"]
[4202,"Pétanque club Villebernier"]
[4240,"Gennes Pétanque"]
[4247,"La Triplette Montreuillaise"]
[4263,"Racing Club Doué Pétanque"]
[4264,"Amicale du Carreau saumurois"]
[4265,"Rosiers Pétanque Gennes Val de Loire"]
[5032,"La Pétanque Noyantaise"]
[5066,"Lambertois petanque Club"]
[5083,"E.S.S.H.A Section pétanque"]
[5144,"Les Amis de La Pétanque Bécon les granits"]
[5251,"Société Omnisport Candéenne de Pétanque"]
[5273,"SPC Bouillé - Bel Air"]
[5278,"Le Carreau Membrollais"]

{"sheet":"Catégories","index":1,"n_rows":10,"n_cols":25,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,6,0,7],[0,19,0,21],[0,22,0,23],[0,13,0,15],[0,16,0,18]]}
["Année","Benjamin","Minime","Cadet","Juniors",null,"Séniors",null,"Vétérans",null,null,"Année","Benjamin","Minime",null,null,"Cadet",null,null,"Juniors",null,null,"Séniors",null,"Vétérans"]
[2017,2008,"2005 - 2006 - 2007","2002 - 2003 - 2004",2000,2001,1958,1999,1957,null,null,2017,2008,2005,2006,2007,2002,2003,2004,2000,null,2001,1958,1999,1957]
[2018,2009,"2006 - 2007 - 2008","2003 - 2004 - 2005",2001,2002,1959,2000,1958,null,null,2018,2009,2006,2007,2008,2003,2004,2005,2001,null,2002,1959,2000,1958]
[2019,2010,"2007 - 2008 - 2009","2004 - 2005 - 2006",2002,2003,1960,2001,1959,null,null,2019,2010,2007,2008,2009,2004,2005,2006,2002,null,2003,1960,2001,1959]
[2020,2011,"2008 - 2009 - 2010","2005 - 2006 - 2007",2003,2004,1961,2002,1960,null,null,2020,2011,2008,2009,2010,2005,2006,2007,2003,null,2004,1961,2002,1960]
[2021,2013,"2010 - 2011 - 2012","2007 - 2008 - 2009",2004,2006,1962,2003,1961,null,null,2021,2013,2010,2011,2012,2007,2008,2009,2004,null,2006,1962,2003,1961]
[2022,2014,"2011 - 2012 - 2013","2008 - 2009 - 2010",2005,2007,1963,2004,1962,null,null,2022,2014,2011,2012,2013,2008,2009,2010,2005,2006,2007,1963,2004,1962]
[2023,2015,"2012 - 2013 - 2014","2009 - 2010 - 2011",2006,2008,1964,2005,1963,null,null,2023,2015,2012,2013,2014,2009,2010,2011,2006,2007,2008,1964,2005,1963]
[2024,2016,"2013 - 2014 - 2015","2010 - 2011 - 2012",2007,2009,1965,2006,1964,null,null,2024,2015,2013,2014,2015,2010,2011,2012,2007,2008,2009,1965,2006,1964]
[2025,2016,"2013 - 2014 - 2015","2010 - 2011 - 2012",2008,2009,1966,2007,1965,null,null,2025,2016,2013,2014,2015,2010,2011,2012,2008,2009,2010,1966,2007,1965]

{"sheet":"Menu","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[17,1,17,4],[0,0,0,5],[1,0,1,5],[3,3,3,4],[6,1,6,4]]}
["Fédération Française de Pétanque et jeu Provençal",null,null,null,null,null,null,null,null,{"$f":"B7-1","v":2023}]
["Région des Pays de la Loire - Comité de Maine et Loire"]
[]
["N°Club",null,"Club",{"$f":"IF(B4=\"\",\"\",VLOOKUP(B4,Clubs!A1:B72,2,0))","v":""}]
[]
[]
[null,2024]
[]
[null,"Mode d'emploi",null,"Mode d'emploi"]
[null,"Document unique de licences",null,"Nouveau document fédéral à utiliser pour types de demandes de licences"]
[null,null,null,"CREATION - RENOUVELLEMENT-DUPLICATA - MUTATION"]
[null,null,null,"Il est impératif de cocher la bonne case"]
[null,"Vérification des Licences",null,{"$f":"\"Feuille récapitulative des prises de licence s\"&B7&\", pour les licences qui passent dans le lecteur\"","v":"Feuille récapitulative des prises de licence s2024, pour les licences qui passent dans le lecteur"}]
[null,"Feuille Comptable",null,"Formulaire à joindre impérativement à toutes vos demandes de licences"]
[null,"Correction d'erreur",null,{"$f":"\"La correction intervient après une erreur manuscrite sur la licence \"&B7&\" ( Nom,Prénom, etc…)\"","v":"La correction intervient après une erreur manuscrite sur la licence 2024 ( Nom,Prénom, etc…)"}]

{"sheet":"Mode d'emploi","index":3,"n_rows":59,"n_cols":2,"rows_kept":59,"cut":false,"hidden":false,"merged":[[46,0,46,2],[49,0,49,2],[57,0,57,2],[52,0,52,2],[1,0,1,2],[3,0,3,2],[23,0,23,2],[37,0,37,2],[16,0,16,2]]}
[]
[{"$f":"\"Comment établir une licence \"&Menu!B7","v":"Comment établir une licence 2024"}]
[]
["CRÉATION DE LICENCE"]
[null,"Nouvelle licence uniquement   (ne jamais avoir été licencié)"]
[null,"Renseignez toutes les lignes "]
[null,"Pour les clubs ou les personnes qui remplissent le formulaire en lettres manuscrites, écrivez en majuscules, de façon claire et compréhensible"]
[null,"Formulaire à signer obligatoirement par le licencié en 2 exemplaires (un pour le club et un pour le comité)"]
[null,"Joindre obligatoirement une photo"]
[null,"Joindre la copie de la carte d'identité ou livret de famille "]
[null,"Demander la carte d'identité ou livret de famille (jeunes) pour établir la 1ère demande de licence"]
[null,"pour les nouveaux joueurs (ses), demander si ils ont joué dans le département ou hors département."]
[null,"pour un étranger, demander la carte de séjour."]
[null,"Pour toute demande de nouvelle licence, joindre obligatoirement une photo récente non estampillée avec le NOM, Prénom et N° club inscrits au dos de celle-ci (ne pas agrafer la photo)"]
[null,"CE FORMULAIRE EST À TRANSMETTRE AU COMITÉ AVEC LA FEUILLE COMPTABLE ACCOMPAGNÉE DU RÈGLEMENT"]
[]
["RENOUVELLEMENT DE LICENCE"]
[null,"Uniquement pour les licences qui passent dans le lecteur "]
[null,"Renseignez toutes les lignes "]
[null,"Pour les clubs ou les personnes qui remplissent le formulaire en lettres manuscrites, écrivez en majuscules, de façon claire et compréhensible"]
[null,"Formulaire à remplir en 2exemplaires et à signer obligatoirement par le licencié (un pour le club et un pour le comité)"]
[null,"CE FORMULAIRE EST À TRANSMETTRE AU COMITÉ AVEC LA FEUILLE COMPTABLE ACCOMPAGNÉE DU RÈGLEMENT"]
[]
["DUPLICATA DE LICENCE (Demande de nouvelle carte)"]
[null,"Uniquement pour les licences qui ne passent pas sur le lecteur, les licences perdues ou cassées"]
[null,"Renseignez toutes les lignes "]
[null,"Formulaire à signer obligatoirement par le licencié en 2 exemplaires (un pour le club et un pour le comité)"]
[null,"Pour les clubs ou les personnes qui remplissent le formulaire en lettres manuscrites, écrivez en majuscules, de façon claire et compréhensible"]
[null,"respecter les catégories"]
[null,"MUTATION"]
[]
[null,"Pour les joueurs mutés vous devrez obligatoirement joindre à ce formulaire une demande de mutation, même si ce joueur n'a pas joué depuis plusieurs années. Si le joueur n'est pas en possession de ce document n'établissez pas de demande."]
[null,"A SAVOIR : Les demandes de mutations peuvent se faire tout au long de l'année."]
[null,"Formulaire à remplir en 2exemplaires et à signer obligatoirement par le licencié (un pour le club et un pour le comité)"]
[]
[null,"CE FORMULAIRE EST À TRANSMETTRE AU COMITÉ AVEC LA FEUILLE COMPTABLE ACCOMPAGNÉE DU RÈGLEMENT"]
[]
["VÉRIFICATION DES LICENCES"]
[null,{"$f":"\"Feuille récapitulative de prise de licence \"&Menu!B7","v":"Feuille récapitulative de prise de licence 2024"}]
[null,"Dans ce formulaire, vous devez impérativement passer la licence sur le lecteur, aucune inscription manuscrite ne sera admise."]
[null,"Vous devez, en présence du licencié contrôler son adresse complète et sa date de naissance."]
[null,"Faites les corrections si nécessaire directement sur le formulaire en changeant la couleur de remplissage des cases ou il y a eu des changements"]
[null,"Pour les joueurs mutés, la case club se modifiera automatiquement d'une autre couleur, vous devrez obligatoirement joindre à ce formulaire une demande de mutation pour tous ces joueurs mutés. Si le joueur n'est pas en possession de ce document, supprimez la ligne et n'établissez pas de demande."]
[]
[null,"CE FORMULAIRE EST À TRANSMETTRE AU COMITÉ AVEC LA FEUILLE COMPTABLE ACCOMPAGNÉ DU RÈGLEMENT"]
[]
["DEMANDE DE DUPLICATA"]
[null,"Document à utiliser uniquement encours d'année quand le licencié a perdu ou cassé sa licence"]
[]
["CORRECTION D'ERREUR"]
[null,{"$f":"\"la correction intervient après une erreur manuscrite sur la licence \"&Menu!B7&\" (Nom, prénom, etc…)\"","v":"la correction intervient après une erreur manuscrite sur la licence 2024 (Nom, prénom, etc…)"}]
[]
["FEUILLE COMPTABLE"]
[null,"Formulaire à joindre impérativement à toutes vos demandes de licences"]
[null,"Il est IMPÉRATIF que ce formulaire soit rempli  informatiquement et accompagné de votre règlement"]
[null,"ATTENTION : Respectez scrupuleusement toutes les catégories. (Le montant total en dépend)"]
[]
["LITIGES"]
[null,"En cas du non-respect des critères cités ci-dessus ou la feuille comptable erronée ou complétée manuellement le dossier de demandes de licences ne sera pas traité et vous sera retourné à vos frais dans sa totalité"]

{"sheet":"Demande de Carte","index":4,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":true,"merged":[[45,0,45,7],[46,0,46,7],[48,0,48,7],[12,1,12,3],[14,5,14,7],[18,1,18,2],[14,1,14,3],[16,1,16,6],[43,1,43,6],[18,4,18,6],[25,4,25,5],[20,1,20,2],[20,5,20,6],[22,1,22,4],[39,1,39,6],[40,0,40,7],[52,4,52,6],[53,4,53,6],[47,2,47,4],[47,5,47,6],[51,4,51,6],[50,0,50,7],[0,0,0,7],[1,0,1,7],[3,0,3,7],[9,0,9,7],[10,2,10,5],[4,0,4,7],[5,1,5,2],[5,4,5,7],[7,4,7,7],[7,1,7,2],[35,0,35,7],[36,1,36,6],[41,0,41,6],[42,1,42,6],[24,1,24,2],[25,6,25,7],[26,1,26,6],[27,1,27,6],[30,1,30,6],[31,1,31,6],[33,0,33,7],[34,1,34,6]]}
["Fédération Française de Pétanque et Jeu Provençal"]
["Région des Pays de la Loire - Comité de Maine et Loire"]
[]
[{"$f":"\"DEMANDE DE LICENCE \"&Menu!B7","v":"DEMANDE DE LICENCE 2024"}]
["ATTENTION ! A compter de 2018 le coût supplémentaire\npour une demande de carte perdue ou cassée est de 6 €\nsauf mutation"]
["N° de Club",{"$f":"Menu!$B$4","v":0},null,"Club",{"$f":"IF(B6=0,\"\",VLOOKUP(B6,Clubs!A1:B72,2,0))","v":""}]
[]
[{"$f":"\"N° du Club en \"&Menu!J1","v":"N° du Club en 2023"},null,null,null,{"$f":"\"Fournir OBLIGATOIREMENT une mutation si il y un changement de club en \"&Menu!B7","v":"Fournir OBLIGATOIREMENT une mutation si il y un changement de club en 2024"}]
[]
[]
[null,null,"Pour les cartes cassées, joindre licence"]
[]
["N° licence"]
[]
["NOM",null,null,null,"Prénom"]
[]
["Adresse"]
[]
["Code Postal",null,null,"Ville"]
[]
[null,null,null,null,"Catégorie"]
[]
["Email"]
[]
["Téléphone Fixe",null,null,"Portable"]
[null,null,null,null,"Date du Certificat Médical"]
[null,"Je fournis une PHOTO D’IDENTITE et j’accepte d’être photographié pour que ma photo soit téléchargée sur le logiciel fédéral"]
[null,"Le demandeur est susceptible de recevoir des offres commerciales de partenaires commerciaux de la F.F.P.J.P. En cas de refus , cocher la case "]
[]
["ENCADRANTS et/ou DIRIGEANTS : "]
[null," Je suis Initiateur, Educateur ou Dirigeant (Président, Secrétaire Générale, Trésorier Général de club ou de Comité). La licence que je sollicite me permet d’accéder aux fonctions d’éducateur sportif et/ou de dirigeant d’Etablissement d’Activités Physiques et Sportives au sens des articles L. 212-1 et L. 322-1 du code du sport. A ce titre, les éléments constitutifs de mon identité seront transmis par la fédération aux services de l’Etat afin qu’un contrôle automatisé de mon honorabilité au sens de l’article L. 212-9 du code du sport soit effectué. J’ai compris et j’accepte ce contrôle.\n"]
[null,"Je refuse ce contrôle et confirme mon intention de ne plus exercer les fonctions d’initiateur, d’éducateur et/ou de dirigeant."]
["ATTESTATION SUR L'HONNEUR :"]
["Je certifie sur l'honneur l'exactitude des renseignements ci-dessus et atteste:"]
[null,"Avoir été informé qu'avec la licence,j'adhère simultanément au contrat collectif d'assurance souscrit auprès de MMA Assurance,par la F.F.P.J.P. de son coût et de l'intérêt que présente la souscription d'un contrat de personnes couvrant des dommages corporels (non obligatoire)"]
["Si je ne souhaite pas souscrire cette assurance de personnes , cochez cette casse"]
[null,"Avoir été informé de l'intérêt de souscrire les garanties optionnelles,accident corporels,correspondant à l'option \"avantage\" de la compagnie d'assurance MMA conformément à l'article L .321-4 du code du sport."]
[]
["AUTORISATION PARENTALE ( enfant mineur)"]
["Je soussigné (e)"]
["père/mère/tuteur légal,autorise le bénéficiaire de cette demande, identifié ci-dessus,à pratiquer la Pétanque et Jeu Provencal\nau sein de l'association,ainsi qu'à assurer son transport éventuel. En cas d'accident : personne à prévenir"]
["Personne à contacter en cas d’accident : "]
["Nom : "]
["Tél : "]
[]
[]
[]
[null,null,"Signature du joueur ou représentant légal "]
[]
[]
["Les données personnelles figurant sur ce document font l'objet de traitement informatique aux fins de traitements de gestion des licences. Elles sont destinées aux clubs,Comités,ligues et FFPJP et,sauf opposition ci-dessus,à nos partenaires.Conformément à la loi informatique et libertés du 6 Janvier 1978, le demandeur bénéfice d'un droit d'accès,de rectification et d'opposition aux informations qui le concerne. Le demandeur peut exercer ses droit et obtenir communication des informations en s'adressant au siège de la F.F.P.J.P - 13,rue Trigance - 13002 MARSEILLE\ncourriel: ffpjp.siege@petanque.fr"]
[null,null,null,null,"Signature du Président"]
[]
[null,null,null,null,"cachet du Club"]

{"sheet":"Renouvellement de Licence","index":5,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":true,"merged":[[36,0,36,7],[34,1,34,2],[35,1,35,2],[43,0,43,7],[45,0,45,1],[37,0,37,7],[38,0,41,1],[38,2,39,2],[38,3,39,4],[38,6,38,7],[41,6,41,7],[39,6,39,7],[40,2,41,2],[40,3,41,4],[40,6,40,7],[25,1,25,6],[0,0,0,7],[1,0,1,7],[7,0,7,7],[3,1,3,2],[3,4,3,7],[5,1,5,2],[5,4,5,7],[11,1,11,2],[22,0,22,7],[23,1,23,6],[24,0,24,7],[15,1,15,6],[16,1,16,6],[19,1,19,6],[20,1,20,6],[28,1,28,6],[34,3,35,4],[29,0,29,7],[30,0,30,6],[32,1,32,6],[31,1,31,6],[34,5,35,6]]}
["Fédération Française de Pétanque et Jeu Provencal"]
["Région des Pays de la Loire - Comité de Maine et Loire"]
[]
["N° Club",{"$f":"Menu!$B$4","v":0},null,"Club",{"$f":"IF(B4=0,\"\",VLOOKUP(B4,Clubs!A1:C70,2,0))","v":""}]
[]
[{"$f":"\"N° du Club en \"&Menu!J1","v":"N° du Club en 2023"},null,null,null,{"$f":"\"Fournir OBLIGATOIREMENT une mutation si il y un changement de club en \"&Menu!B7","v":"Fournir OBLIGATOIREMENT une mutation si il y un changement de club en 2024"}]
[]
[{"$f":"\"RENOUVELLEMENT DE LICENCE SAISON \"&Menu!B7","v":"RENOUVELLEMENT DE LICENCE SAISON 2024"}]
[]
["Je,soussigne e)","NOM",null,"Prénom",null,"N°licence"]
[]
["Catégorie",null,null,null,null,"date du certificat médical"]
[]
["Classification ",null," Elite","Honneur","                Promotion"]
[]
[null,"Je fournis une PHOTO D’IDENTITE et j’accepte d’être photographié pour que ma photo soit téléchargée sur le logiciel fédéral"]
[null,"Le demandeur est susceptible de recevoir des offres commerciales de partenaires commerciaux de la F.F.P.J.P. En cas de refus , cocher la case "]
[]
["ENCADRANTS et/ou DIRIGEANTS : "]
[null," Je suis Initiateur, Educateur ou Dirigeant (Président, Secrétaire Générale, Trésorier Général de club ou de Comité). La licence que je sollicite me permet d’accéder aux fonctions d’éducateur sportif et/ou de dirigeant d’Etablissement d’Activités Physiques et Sportives au sens des articles L. 212-1 et L. 322-1 du code du sport. A ce titre, les éléments constitutifs de mon identité seront transmis par la fédération aux services de l’Etat afin qu’un contrôle automatisé de mon honorabilité au sens de l’article L. 212-9 du code du sport soit effectué. J’ai compris et j’accepte ce contrôle.\n"]
[null,"Je refuse ce contrôle et confirme mon intention de ne plus exercer les fonctions d’initiateur, d’éducateur et/ou de dirigeant."]
["ATTESTATION SUR L'HONNEUR :"]
["Je certifie sur l'honneur l'exactitude des renseignements ci-dessus et atteste:"]
[null,"Avoir été informé qu'avec la licence,j'adhère simultanément au contrat collectif d'assurance souscrit auprès de MMA Assurance,par la F.F.P.J.P. de son coût et de l'intérêt que présente la souscription d'un contrat de personnes couvrant des dommages corporels (non obligatoire)"]
["Si je ne souhaite pas souscrire cette assurance de personnes , cochez cette casse"]
[null,"Avoir été informé de l'intérêt de souscrire les garanties optionnelles,accident corporels,correspondant à l'option \"avantage\" de la compagnie d'assurance MMA conformément à l'article L .321-4 du code du sport."]
[]
["AUTORISATION PARENTALE ( enfant mineur)"]
["Je soussigné (e)"]
["père/mère/tuteur légal,autorise le bénéficiaire de cette demande, identifié ci-dessus,à pratiquer la Pétanque et Jeu Provencal\nau sein de l'association,ainsi qu'à assurer son transport éventuel. En cas d'accident : personne à prévenir"]
["Personne à contacter en cas d’accident : "]
["Nom : "]
["Tél : "]
[]
[null,null,null,"Signature du Joueur\nou du représentant légal"]
[]
[]
["Les données personnelles figurant sur ce document font l'objet de traitement informatique aux fins de traitements de gestion des licences. Elles sont destinées aux clubs,Comités,ligues et FFPJP et,sauf opposition ci-dessus,à nos partenaires.Conformément à la loi informatique et libertés du 6 Janvier 1978, le demandeur bénéfice d'un droit d'accès,de rectification et d'opposition aux informations qui le concerne. Le demandeur peut exercer ses droit et obtenir communication des informations en s'adressant au siège de la F.F.P.J.P - 13,rue Trigance - 13002 MARSEILLE\ncourriel: ffpjp.siege@petanque.fr"]
["catégories",null,"VÉTÉRANS",{"$f":"VLOOKUP(Menu!B7,base,9,0)&\" et avant\"","v":"1964 et avant"},null,"JUNIORS",{"$f":"VLOOKUP(Menu!B7,base,5,0)&\" et \"&VLOOKUP(Menu!B7,base,6,0)","v":"2007 et 2009"}]
[null,null,null,null,null,"CADETS",{"$f":"VLOOKUP(Menu!B7,base,4,0)","v":"2010 - 2011 - 2012"}]
[null,null,"SENIORS",{"$f":"VLOOKUP(Menu!B7,base,7,0)&\" à \"&VLOOKUP(Menu!B7,base,8,0)","v":"1965 à 2006"},null,"MINIMES",{"$f":"VLOOKUP(Menu!B7,base,3,0)","v":"2013 - 2014 - 2015"}]
[null,null,null,null,null,"BENJAMINS",{"$f":"VLOOKUP(Menu!B7,base,2,0)& \" et après\"","v":"2016 et après"}]
[]
["Joindre une nouvelle photo pour le changement de catégorie"]
[]
[null,null,null,null,null,"signature du Président et cachet du club"]

{"sheet":"DOCUMENT UNIQUE LICENCE a","index":6,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":true,"merged":[[8,2,8,3],[8,4,8,5],[8,6,8,7],[17,0,17,7],[18,1,18,7],[6,0,6,7],[0,0,0,7],[1,1,1,5],[2,3,2,5],[3,2,3,4],[5,0,5,7],[7,0,7,1],[7,2,7,3],[7,5,7,7],[23,2,23,5],[9,0,9,1],[10,1,10,7],[11,3,11,7],[12,1,12,4],[12,6,12,7],[13,0,13,6],[14,2,14,5],[15,0,15,6],[16,0,16,7],[19,0,19,7],[21,0,21,7],[8,0,8,1],[32,6,32,7],[24,0,24,7],[25,0,25,7],[26,2,26,5],[28,0,28,7],[29,2,29,5],[30,0,30,1],[30,2,30,4],[30,5,30,7],[31,0,31,7],[27,0,27,7],[41,0,41,7],[33,2,33,5],[34,0,34,7],[35,0,35,7],[36,0,36,7],[37,0,37,7],[39,2,40,4],[39,5,40,7],[38,0,38,7]]}
["Fédération Française de Pétanque                                                                                                            et de Jeu Provençal"]
[null,"       COMITÉ DÉPARTEMENTAL de Maine et Loire",null,null,null,null,"SAISON                                    "]
[null,"       CLUB :",{"$f":"Menu!B4","v":0},{"$f":"IF(C3=0,\"Veuillez entrer le numero de club\",VLOOKUP(C3,Clubs!A1:B70,2,0))","v":"Veuillez entrer le numero de club"},null,null,{"$f":"Menu!B7","v":2024}]
[null,"      SECTEUR :",{"$f":"IF(C3=\"\",\"\",VLOOKUP(C3,[2]Clubs!A1:C72,3,0))","v":{"$error":"#N/A"}}]
[]
["                              CRÉATION            RENOUVELLEMENT                  DUPLICATA                     MUTATION"]
["Civilité :             M             F         Nationalité :              Française                      Union Européenne                 Etrangère"]
["Nom de naissance: ",null,null,null,"Nom d'usage :"]
["Prénom de naissance: ",null,null,null,"Prénom d'usage: "]
["Date de naissance : ",null,null,"Lieu de naissance:",null,"INSEE:"]
["Adresse:"]
["Code Postal:",null,"Ville:"]
["Courriel:",null,null,null,null,"Téléphone :"]
[]
["N° de licence (si existant):"]
["CLASSIFICATION"]
["                                              ÉLITE                            HONNEUR                         PROMOTION                       NON CLASSÉ"]
[]
[null,"Titulaire d'une carte MOBILITE INCLUSION pour les personnes en situation d'handicap"]
["Je fournis une PHOTO D'IDENTITÉ et j'accepte d'être photographié pour que ma photo soit téléchargée sur le logiciel fédéral de gestion des licences."]
[]
[" Le demandeur est susceptible de recevoir des offres commerciales de partenaires commerciaux de la F.F.P.J.P.             \n                                                Si vous ne le souhaitez pas, Cochez cette case "]
[]
["ENCADRANTS et/ou DIRIGEANTS",null,"ENCADRANTS et/ou DIRIGEANTS"]
["      Je suis initiateur, Educateur ou Dirigeant (Président, Secrétaire Générale, Trésorier Général de club ou de Comité).La licence que je sollicite me permet d'accéder aux fonctions d'éducateur sportif et/ou de dirigeant d'Etablissement d'Activités Physiques et Sportives au sens des articles L; 212-1 et L. 322-1 du code du sport. A ce titre, les éléments constitutifs de mon identité seront transmis par la fédération aux services de l'Etat afin qu'un contrôle automatisé de mon honorabilité au sens de l'article L. 212-9 du code du sport soit effectué. J'ai compris et j'accepte ce contrôle."]
["      Je refuse ce contôle et confirme mon intention de ne plus exercer les fonctions d'initiateur, d'éducateur et/ou de dirigeant"]
["ENCADRANTS et/ou DIRIGEANTS",null,"CERTIFICAT MÉDICAL"]
[" • Pour les majeurs : plus de certificat médical"]
["• Pour les mineurs : renseigner le questionnaire de santé et avoir répondu par la négative à l'ensemble des rubriques. (A défaut, fournir un certicat de moins de 6 mois)."]
["ENCADRANTS et/ou DIRIGEANTS",null,"AUTORISATION PARENTALE"]
["Je soussignée, ",null,null,null,null,"père/mère/tuteur légal, autorise le"]
["bénéficiaire de cette demande, identifié ci-dessus, à pratiquer la pétanque et le jeu provençal au sein de l'association."]
["Personne à contacter en cas d'accident :  ",null,null,"Nom : ",null,"Tél :"]
["ENCADRANTS et/ou DIRIGEANTS",null,"ATTESTATION SUR L'HONNEUR"]
["Je soussigné(e), certifie sur l'honneur l'exactitude des renseignements ci-dessus et atteste:"]
["     Avoir été informé(e) qu'avec la licence, j'adhère simultanément au contrat collectif d'assurance souscrit auprès de MMA Assurances, par la F.F.P.J.P., conformément à l'article L. 312-1 du Code du Sport, des garanties et de l'intérêt que présente la souscription d'un contrat de personnes couvrant les dommages corporels (non obligatoire).Nb: le coût de cette assurance non obligatoire accordée en base dans la licence est de 0.35€."]
["Si je ne souhaite pas cette assurance de personnes, cochez cette case."]
["     Avoir été informé(e) de l'intérêt de souscrire les garanties complémentaires optionnelles, accidents correspondant à l'option «avantage» de la compagnie d'assurance, M.M.A conforément à l'article L.321-4 du code du sport"]
["     Avoir été informé(e) de l'existence de garanties relatives à l'accompagnement juridique et psychologiques ainsi qu'à  la prise en charge des frais de procédures engagés par les victimes de violences sexuelles, physique et psychologiques"]
[null,null,"SIGNATURE DU JOUEUR/JOUEUSE     ou du REPRESENTANT LEGAL "]
[]
["Les données personnelles figurant sur ce documentfont l'objet de traitements informatiques aux fin de traitement de gestion des licences. Vu le Règlement UE2016/679, la directive (UE) 2016/680, la loi de n°78-17 modifiée et le décret n°2019-536 relatif à la protection des données personnelles, vous avez le droit Pour toutes ces demandes, contactez votre club ou écrivez-nous à: sve@petanque.fr inexactes et de faire bloquer, effacer ou détruire des données , selon les circonstances et sous conditions, de vous opposer au traitement de vos  inexactes et de faire bloquer, effacer ou détruire des données , selon les circonstances et sous conditions, de vous opposer au traitement de vos  d'accéder et de demander une copie des données traitées vous concernant, de faire rectifier des données"]

{"sheet":"QUESTIONNAIRE DE SANTE MINEUR","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DOCUMENT UNIQUE LICENCE","index":8,"n_rows":358,"n_cols":38,"rows_kept":358,"cut":false,"hidden":false,"merged":[[0,1,0,8],[1,2,1,6],[3,3,3,5],[5,10,6,10],[6,2,6,3],[6,5,6,7],[5,1,5,8],[7,1,7,4],[7,5,7,8],[8,1,8,4],[8,5,8,8],[9,1,9,3],[9,4,9,7],[10,1,10,8],[11,1,11,2],[11,3,11,8],[12,1,12,5],[12,6,12,8],[13,1,13,7],[14,3,14,6],[15,3,15,5],[16,3,16,5],[17,2,17,8],[18,1,19,8],[21,1,21,8],[23,3,23,6],[24,1,24,8],[25,1,25,8],[26,3,26,6],[27,1,27,8],[28,1,28,8],[29,1,29,8],[30,3,30,6],[31,1,31,5],[31,6,31,8],[32,1,32,8],[33,4,33,6],[33,7,33,8],[40,26,41,29],[34,3,34,6],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[42,1,42,8],[55,20,57,20],[39,1,39,8],[40,3,41,5],[40,6,41,8],[40,10,41,12]]}
[null,"Fédération Française de Pétanque et de Jeu Provençal",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(K2,'[3]Base de Données'!$B$4:$DZ$206,106,FALSE)),\"\",VLOOKUP(K2,'[3]Base de Données'!$B$4:$DZ$206,106,FALSE))","v":""},{"$f":"YEAR(M1)","v":2023},null,{"$f":"TODAY()","v":"2023-11-28"},0,{"$f":"DATE(K1,10,1)","v":"2023-10-01"},{"$f":"K1+1","v":2024},{"$f":"DATE(P1,1,1)","v":"2024-01-01"},null,{"$f":"IF(ISERROR(VLOOKUP($K$2,#REF!,32,FALSE)),\"\",VLOOKUP($K$2,#REF!,32,FALSE))","v":""},null,null,null,null,null,1]
[null,null,"       COMITÉ DÉPARTEMENTAL de Maine et Loire",null,null,null,null,null,"SAISON                                    ",null,{"$f":"Z8","v":"DOCUMENT UNIQUE LICENCE"},null,{"$f":"IF(ISERROR(LEFT($N$4,2)),\"0\",LEFT($N$4,2))","v":""},{"$f":"LEFT($N$4,2)","v":""},{"$f":"M2","v":""},null,null,null,null,null,null,null,null,null,2]
[null,null,"       CLUB :",{"$f":"IF(AL2<>\"\",$AL$2,Menu!B4)","v":0},{"$f":"IF(AB3=0,\"\",UPPER(AB3))","v":""},null,null,null,{"$f":"IF(AL3<>\"\",AL3,Menu!B7)","v":2024},null,null,null,{"$f":"LEFT($N$4,4)","v":""},{"$f":"LEFT($N$4,4)","v":""},{"$f":"RIGHT(M3,2)","v":""},null,null,null,null,null,null,null,null,null,3,null,null,{"$f":"IF(ISERROR(VLOOKUP(D3,[4]Clubs!$C$3:$E$74,2,FALSE)),\"\",VLOOKUP(D3,[4]Clubs!$C$3:$E$74,2,FALSE))","v":0}]
[null,null,"      SECTEUR :",{"$f":"IF(D3=\"\",\"\",IF(ISERROR(VLOOKUP(D3,[2]Clubs!A1:C72,3,0)),\"\",VLOOKUP(D3,[2]Clubs!A1:C72,3,0)))","v":""},null,null,null,null,null,null,null,null,{"$f":"LEFT($N$4,6)","v":""},{"$f":"IF($AL$16<>\"\",AL16,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,13,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,13,FALSE)))","v":""},{"$f":"RIGHT(M4,2)","v":""},null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT($N$4,8)","v":""},{"$f":"IF($AL$15<>\"\",$AL$15,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,12,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,12,FALSE)))","v":""},{"$f":"RIGHT(M5,2)","v":""},null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,"NOM de NAISSANCE",2]
[null,"RENOUVELLEMENT DE LICENCE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AL$11<>\"\",$AL$11,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,9,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,9,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,"NOM d'USAGE",3]
[null,{"$f":"\"Civilité : \"","v":"Civilité : "},null,null,{"$f":"\"Nationalité :\"","v":"Nationalité :"},null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(N4,2)","v":""},null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,"PRÉNOM de NAISSANCE",4]
[null,{"$f":"IF(AL5<>\"\",\"Nom de Naissance :  \"&AL5,IF(N18=\"0\",\"Nom de Naissance : \",\"Nom de Naissance :   \"&N18))","v":"Nom de Naissance :   "},null,null,null,{"$f":"IF(AL6<>\"\",\"Nom d'usage :  \"&AL6,IF(N19=\"0\",\"Nom d'usage: \",\"Nom d'usage:  \"&N19))","v":"Nom d'usage:  "},null,null,null,null,null,null,null,{"$f":"IF(AL9<>\"\",AL9,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,6,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,6,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,null,8,{"$f":"RIGHT(CELL(\"nomfichier\",$A$1),LEN(CELL(\"nomfichier\",$A$1))-FIND(\"]\",CELL(\"nomfichier\",$A$1)))","v":"DOCUMENT UNIQUE LICENCE"},null,null,null,null,null,null,null,null,null,"PRÉNOM d'USAGE",5]
[null,{"$f":"IF(AL7<>\"\",\"Prénom de Naissance :  \"&AL7,IF(N24=\"0\",\"Prénom de Naissance : \",\"Prénom de Naissance :   \"&N24))","v":"Prénom de Naissance :   "},null,null,null,{"$f":"IF(AL8<>\"\",\"Prénom d'usage :  \"&AL8,IF(N25=\"0\",\"Prénom d'usage: \",\"Prénom d'usage:  \"&N25))","v":"Prénom d'usage:  "},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,null,null,null,"DATE de NAISSANCE",6]
[null,{"$f":"IF(N13=\"00\",\"Date de Naissance : \",IF(N10=\"0\",\"Date de Naissance : \",\"Date de Naissance :   \"&N13&\" / \"&N17&\" / \"&M15))","v":"Date de Naissance : "},null,null,{"$f":"IF(AL10<>\"\",\"Lieu de Naissance :  \"&AL10,IF(N26=0,\"Lieu de Naissance : \",\"Lieu de Naissance :  \"&N26))","v":"Lieu de Naissance :  "},null,null,null,{"$f":"IF(M21=\"0\",\"N° INSEE : \",\"N° INSEE :  \"&M21&\" \"&M22)","v":"N° INSEE :   "},null,null,null,null,{"$f":"IF(ISERROR(DAY(N8)),\"0\",DAY(N8))","v":"0"},null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,"LIEU de NAISSANCE",7]
[null,{"$f":"IF(N21=0,\"Adresse : \",\"Adresse :  \"&N21)","v":"Adresse :  "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(N10)","v":1},null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,"N° INSEE",8]
[null,{"$f":"IF(M18=\"0\",\"Code Postal : \",\"Code Postal :  \"&M18&\" \"&M19)","v":"Code Postal :   "},null,{"$f":"IF(AL14<>\"\",\"Ville :  \"&AL14,IF(N23=0,\"Ville : \",\"Ville :  \"&N23))","v":"Ville :  "},null,null,null,null,null,null,null,null,null,{"$f":"IF(N11=1,0,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,"ADRESSE",9]
[null,{"$f":"IF(M23=\"\",\"Courriel : \",\"Courriel :  \"&M24&\"  @  \"&M26)","v":"Courriel : "},null,null,null,null,{"$f":"IF(M2=\"0\",\"Téléphone : \",\"Téléphone :  \"&O2&\" \"&O3&\" \"&O4&\" \"&O5&\" \"&O7)","v":"Téléphone :      "},null,null,null,null,null,null,{"$f":"N12&N10","v":"00"},null,null,null,null,"E","ÉLITE",null,"CRÉATION DE LICENCE",null,null,12,null,null,null,null,null,null,null,null,null,null,"CODE POSTAL",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MONTH(N8)","v":{"$error":"#VALUE!"}},null,null,null,null,"H","HONNEUR",null,"RENOUVELLEMENT DE LICENCE",null,null,13,null,null,null,null,null,null,null,null,null,null,"VILLE",11]
[null,"N° de licence (si existant):",null,{"$f":"IF(O27=\"0\",\"\",O27&\" \"&O26)","v":" "},null,null,null,null,null,null,null,null,{"$f":"YEAR(N8)","v":{"$error":"#VALUE!"}},{"$f":"LEN(N14)","v":{"$error":"#VALUE!"}},null,null,null,null,"P","PROMOTION",null,"DUPLICATA DE LICENCE",null,null,14,null,null,null,null,null,null,null,null,null,null,"COURRIEL",12]
[null,null,null,"CLASSIFICATION",null,null,null,null,null,null,null,null,{"$f":"$Z$8","v":"DOCUMENT UNIQUE LICENCE"},{"$f":"IF(N15=1,0,\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,"NC","NON CLASSÉ",null,"MUTATION",null,null,15,null,null,null,null,null,null,null,null,null,null,"TÉLÉPHONE",13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N16&N14","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,null,null,null,"N° de LICENCE",14]
[null,null,"      Titulaire d'une carte MOBILITÉ INCLUSION pour les personnes en situation d'handicap.",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(LEFT(N22,2)),\"0\",LEFT(N22,2))","v":""},{"$f":"IF($AL$5<>\"\",$AL$5,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,$AK$5,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,$AK$5,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,"Responsable Légal",15]
[null,"Je fournis une PHOTO D'IDENTITÉ ou j'accepte d'être photographié pour que ma photo soit téléchargée sur le logiciel fédéral de gestion des licences.",null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(N22,3)","v":""},{"$f":"IF($AL$6<>\"\",$AL$6,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,$AK$6,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,$AK$6,FALSE)))","v":""},null,null,null,null,"F","FÉMININ",null,null,null,null,18,null,null,null,null,null,null,null,null,null,null,"Contact",16]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(LEFT(N6,2)),\"0\",LEFT(N6,2))","v":""},{"$f":"IF($AL$12<>\"\",$AL$12,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,12,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,12,FALSE)))","v":""},null,null,null,null,"M","MASCULIN",null,null,null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,"            N° INSEE"]
[null," Le demandeur est susceptible de recevoir des offres commerciales de partenaires commerciaux de la F.F.P.J.P.             \n                                                Si vous ne le souhaitez pas, Cochez cette case ",null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(N6,3)","v":""},{"$f":"IF(AL13<>\"\",$AL$13,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,10,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,10,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"@\",N5)),\"\",SEARCH(\"@\",N5))","v":""},{"$f":"IF(AL14<>\"\",$AL$13,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,11,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,11,FALSE)))","v":""},{"$f":"IF(N23=0,\"\",N23)","v":""},null,null,null,null,null,null,null,null,null,21]
[null,"ENCADRANTS et/ou DIRIGEANTS",null,"ENCADRANTS et/ou DIRIGEANTS",null,null,null,null,null,null,null,null,{"$f":"LEFT(N5,M23-1)","v":{"$error":"#VALUE!"}},{"$f":"IF($AL$7<>\"\",$AL$7,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,$AK$7,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,$AK$7,FALSE)))","v":""},null,null,null,null,"F","FRANÇAISE",null,null,null,null,22]
[null,"        Je suis initiateur, Educateur, Arbitre ou Dirigeant (Président, Secrétaire Générale, Trésorier Général de club ou de Comité).La licence que je sollicite me permet d'accéder aux fonctions d'éducateur sportif et/ou de dirigeant d'Etablissement d'Activités Physiques et Sportives au sens des articles L; 212-1 ET l. 322-1 du code du sport. A ce titre, les éléments constitutifs de mon identité seront transmis par la fédération aux services de l'Etat afin qu'un contrôle automatisé de mon honorabilité au sens de l'article L. 212-9 du code du sport soit effectué. J'ai compris et j'accepte ce contrôle.",null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(N5)","v":0},{"$f":"IF($AL$8<>\"\",$AL$8,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,$AK$8,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,$AK$8,FALSE)))","v":""},null,null,null,null,"UE","UNION EUROPÉENNE",null,null,null,null,23]
[null,"      Je refuse ce contrôle et confirme mon intention de ne plus exercer les fonctions d'initiateur, d'éducateur et/ou de dirigeant",null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(N5,M25-M23)","v":{"$error":"#VALUE!"}},{"$f":"IF($AL$7<>\"\",$AL$7,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,7,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,7,FALSE)))","v":""},{"$f":"RIGHT(N27,5)","v":""},null,null,null,"ÉT","ÉTRANGÈRE",null,null,null,null,24]
[null,"ENCADRANTS et/ou DIRIGEANTS",null,"CERTIFICAT MÉDICAL",null,null,null,null,null,null,null,null,{"$f":"IF(N28=0,\"\",LEFT(N28,1))","v":""},{"$f":"IF($AL$17<>\"\",$AL$17,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,14,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,14,FALSE)))","v":""},{"$f":"IF(ISERROR(LEFT(N27,3)),\"0\",LEFT(N27,3))","v":""},null,null,null,null,null,null,null,null,null,25]
[null,"• Pour les Majeurs : plus de certificat médical.",null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(N28,O28-1)","v":{"$error":"#VALUE!"}},{"$f":"IF($AL$18<>\"\",$AL$18,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,15,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,15,FALSE)))","v":""},{"$f":"LEN(N28)","v":0},null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT($N$29,2)","v":""},{"$f":"IF($AL$19<>\"\",$AL$19,IF(ISERROR(VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,16,FALSE)),\"\",VLOOKUP($K$2,[4]Catégories!$B$4:$CW$206,16,FALSE)))","v":""},{"$f":"IF(N28=0,\"\",LOWER(M28))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,27]
[null,"• Pour les mineurs : renseigner le questionnaire de santé et avoir répondu par la négative à l'ensemble des rubriques. (A défaut, fournir un certicat de moinsde 6 mois).",null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT($N$29,4)","v":""},{"$f":"RIGHT(M30,2)","v":""},null,null,null,null,null,null,null,null,null,null,28]
[null,"ENCADRANTS et/ou DIRIGEANTS",null,"AUTORISATION PARENTALE",null,null,null,null,null,null,null,null,{"$f":"LEFT($N$29,6)","v":""},{"$f":"RIGHT(M31,2)","v":""},null,null,null,null,null,null,null,null,null,null,29]
[null,{"$f":"IF(N28=0,\"Je soussigné,  \",\"Je soussigné,  \"&N28)","v":"Je soussigné,  "},null,null,null,null,"père / mère / tuteur légal, autorise le",null,null,null,null,null,{"$f":"LEFT($N$29,8)","v":""},{"$f":"RIGHT(M32,2)","v":""},null,null,null,null,null,null,null,null,null,null,30]
[null,"bénéficiaire de cette demande, identifié ci-dessus, à pratiquer la pétanque et le jeu provençal au sein de l'association.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(N29,2)","v":""},null,null,null,null,null,null,null,null,null,null,31]
[null,"Personne à contacter en cas d'accident :  ",null,null,{"$f":"IF(N28=0,\"Nom :  \",\"Nom :  \"&N28)","v":"Nom :  "},null,null,{"$f":"IF(N29=0,\"Tél :  \",\"Tél :  \"&M29&\" \"&N30&\" \"&N31&\" \"&N32&\" \"&N33)","v":"Tél :      "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32]
[null,"ENCADRANTS et/ou DIRIGEANTS",null,"ATTESTATION SUR L'HONNEUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,"Je soussigné(e), certifie sur l'honneur l'exactitude des renseignements ci-dessus et atteste:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,"          Avoir été informé(e) qu'avec la licence, j'adhère simultanément au contrat collectif d'assurance souscrit auprès de MMA Assurances, par la F.F.P.J.P., conformément à l'article L. 312-1 du Code du Sport, des garanties et de l'intérêt que présente la souscription d'un contrat de personnes couvrant les dommages corporels (non obligatoire).Nb: le coût de cette assurance non obligatoire accordée en base dans la licence est de 0.35€.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,"Si je ne souhaite pas souscrire cette assurance de personnes, cochez cette case.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36]
[null,"          Avoir été informé(e) de l'intérêt de souscrire les garanties complémentaires optionnelles, accidents correspondant à l'option «avantage» de la compagnie d'assurance, M.M.A conformément à l'article L.312-4 du code du sport",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37]
[null,"          Avoir été informé(e) de l'existence de garanties relatives à l'accompagnement juridique et et psychologique ainsi qu'à  la prise en charge des frais de procédures engagés par les victimes de violences sexuelles, physique et psychologique",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
[null,null,null,"SIGNATURE DU JOUEUR / JOUEUSE     ou du REPRÉSENTANT LÉGAL ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M16","v":"DOCUMENT UNIQUE LICENCE"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,"Les données personnelles figurant sur ce documentfont l'objet de traitements informatiques aux fin de traitement de gestion des licences. Vu le Règlement UE2016/679, la directive (UE) 2016/680, la loi de n°78-17 modifiée et le décret n°2019-536 relatif à la protection des données personnelles, vous avez le droit Pour toutes ces demandes, contactez votre club ou écrivez-nous à: sve@petanque.fr inexactes et de faire bloquer, effacer ou détruire des données , selon les circonstances et sous conditions, de vous opposer au traitement de vos  inexactes et de faire bloquer, effacer ou détruire des données , selon les circonstances et sous conditions, de vous opposer au traitement de vos  d'accéder et de demander une copie des données traitées vous concernant, de faire rectifier des données.",null,null,null,null,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,122]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,141]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,143]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,154]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,157]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,158]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,161]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,163]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,164]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,165]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,166]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,169]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,171]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,172]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,174]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,176]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,177]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,178]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,179]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,181]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,183]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,184]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,185]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,186]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,189]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,190]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,191]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,193]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,195]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,197]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,199]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,202]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,203]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,204]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,206]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,207]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,208]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,209]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,211]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,212]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,213]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,214]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,215]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,216]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,217]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,218]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,219]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,221]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,222]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,224]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,225]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,226]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,227]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,228]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,229]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,230]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,231]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,232]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,233]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,234]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,235]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,236]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,237]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,238]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,239]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,241]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,242]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,243]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,244]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,245]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,246]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,247]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,248]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,249]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,251]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,252]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,253]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,254]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,256]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,257]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,258]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,259]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,260]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,261]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,262]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,263]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,264]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,265]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,266]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,267]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,268]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,269]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,270]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,271]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,272]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,273]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,274]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,275]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,276]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,277]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,278]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,279]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,281]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,282]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,283]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,284]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,285]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,286]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,287]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,288]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,289]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,290]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,291]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,292]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,293]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,294]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,295]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,296]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,297]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,298]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,299]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,302]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,303]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,304]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,305]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,306]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,307]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,308]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,309]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,310]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,311]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,312]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,313]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,314]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,315]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,316]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,317]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,321]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,322]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,323]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,324]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,325]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,326]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,327]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,328]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,329]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,330]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,331]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,334]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,335]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,336]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,337]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,338]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,339]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,340]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,341]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,342]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,343]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,344]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,345]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,346]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,347]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,348]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,349]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,351]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,352]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,353]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,354]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,355]

{"sheet":"Vérification des Licences ","index":9,"n_rows":111,"n_cols":34,"rows_kept":111,"cut":false,"hidden":false,"merged":[[9,0,9,9],[6,0,6,8],[12,3,12,18],[2,2,2,12],[3,0,3,8],[9,12,10,18],[8,12,8,18],[10,1,10,6],[0,25,0,27],[4,0,4,8],[0,22,0,24],[0,28,0,30],[0,31,0,32]]}
[{"$f":"IF(Menu!$B$7=\"\",\"\",Menu!$B$7)","v":2024},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Année","Benjamin","Minime",null,null,"Cadet",null,null,"Juniors",null,null,"Séniors",null,"Vétérans"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Menu!B7","v":2024},{"$f":"VLOOKUP($U$2,cat,2,0)","v":2015},{"$f":"VLOOKUP($U$2,cat,3,0)","v":2013},{"$f":"VLOOKUP($U$2,cat,4,0)","v":2014},{"$f":"VLOOKUP($U$2,cat,5,0)","v":2015},{"$f":"VLOOKUP($U$2,cat,6,0)","v":2010},{"$f":"VLOOKUP($U$2,cat,7,0)","v":2011},{"$f":"VLOOKUP($U$2,cat,8,0)","v":2012},{"$f":"VLOOKUP($U$2,cat,9,0)","v":2007},{"$f":"VLOOKUP($U$2,cat,10,0)","v":2008},{"$f":"VLOOKUP($U$2,cat,11,0)","v":2009},{"$f":"VLOOKUP($U$2,cat,12,0)","v":1965},{"$f":"VLOOKUP($U$2,cat,13,0)","v":2006},{"$f":"VLOOKUP($U$2,cat,14,0)","v":1964}]
["F.F.P.J.P",null,{"$f":"\"VÉRIFICATION DES LICENCES \"&Menu!B7","v":"VÉRIFICATION DES LICENCES 2024"},null,null,null,null,null,null,null,null,null,null,null,"CD49"]
[]
["dans la case jaune mettre la nouvelle date du certificat"]
[]
["Pour toutes les mutations joindre la feuille rose"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cachet et signature"]
["Le Président……………………………….certifie exactes les informations figurant sur ce bordereau et que tous les adhérents ont pris connaissance de l'intérêt de sourcrire aux garanties optionnelles,accidents corporels,correspondant à l'option \"avantage\" de la compagnie M.M.A à l'article L.321-4 du code du sport. Que les informations recueillies figurant sur ce formulaire sont exactes et autorise à ce qu'elles fassent l'objet d'un traitement informatique, conformément à la loi du 06/01/1978Je bénéficie d'un droit d'accès et de rectification auprès du siège de  la F.F.P.J.P"]
["DATE"]
[]
["N° de CLUB",{"$f":"Menu!$B$4","v":0},"CLUB",{"$f":"IF(B13=0,\"Veuillez renseigner le numéro de Club\",VLOOKUP(B13,Clubs!A1:B72,2,0))","v":"Veuillez renseigner le numéro de Club"}]
[]
["NOM","Prénom","Né le","A","B","C","D","N° licence","N°Club","Adresse","v","CP","Ville","E","certificat","Dern\nAnn","F","G","H",null,null,"Année de Naissance","Catégorie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C16=\"\",\"\",YEAR(C16))","v":""},{"$f":"IF(V16=\"\",\"\",IF(V16>=$V$2,\"Benjamin\",IF((V16>=$W$2)*OR(V16<=$Y$2),\"Minime\",IF((V16>=$Z$2)*OR(V16<=$AB$2),\"Cadet\",IF((V16>=$AC$2)*OR(V16<=$AE$2),\"Junior\",IF((V16>=$AF$2)*OR(V16<=$AG$2),\"Senior\",IF(V16<=$AH$2,\"Veteran\",0)))))))","v":""},{"$f":"E16","v":0},{"$f":"W16&\" - \"&X16","v":" - 0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(V17=\"\",\"\",IF(V17>=$V$2,\"Benjamin\",IF((V17>=$W$2)*OR(V17<=$Y$2),\"Minime\",IF((V17>=$Z$2)*OR(V17<=$AB$2),\"Cadet\",IF((V17>=$AC$2)*OR(V17<=$AE$2),\"Junior\",IF((V17>=$AF$2)*OR(V17<=$AG$2),\"Senior\",IF(V17<=$AH$2,\"Veteran\",0)))))))","v":""},0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C60=\"\",\"\",YEAR(C60))","v":""},"",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C78=\"\",\"\",YEAR(C78))","v":""},"",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"E79","v":0},{"$f":"W79&\" - \"&X79","v":" - 0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(V81=\"\",\"\",IF(V81>=$V$2,\"Benjamin\",IF((V81>=$W$2)*OR(V81<=$Y$2),\"Minime\",IF((V81>=$Z$2)*OR(V81<=$AB$2),\"Cadet\",IF((V81>=$AC$2)*OR(V81<=$AE$2),\"Junior\",IF((V81>=$AF$2)*OR(V81<=$AG$2),\"Senior\",IF(V81<=$AH$2,\"Veteran\",0)))))))","v":""},0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0," - 0"]
[]
["Veteran - M",{"$f":"COUNTIF($Y$16:$Y$97,A99)","v":0}]
["Veteran - F",{"$f":"COUNTIF($Y$16:$Y$97,A100)","v":0}]
["Senior - M",{"$f":"COUNTIF($Y$16:$Y$97,A101)","v":0}]
["Senior - F",0]
["Junior - M",0]
["Junior - F",0]
["Cadet - M",0]
["Cadet - F",0]
["Minime - M",0]
["Minime - F",0]
["Benjamin - M",0]
["Benjamin - F",0]
["TOTAL",{"$f":"SUM(B99:B110)","v":0}]

{"sheet":"Feuille Comptable","index":10,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,7,17,9],[19,7,19,9],[17,1,18,1],[19,1,20,1],[18,8,18,9],[20,8,20,9],[38,0,38,9],[32,3,32,4],[32,5,32,6],[32,7,32,9],[34,3,34,4],[34,5,34,6],[34,7,34,9],[36,2,36,3],[28,2,28,8],[23,1,23,2],[22,1,22,2],[21,1,21,2],[24,1,24,2],[21,8,21,9],[26,7,26,9],[26,4,26,5],[15,1,16,1],[9,7,9,9],[13,8,13,9],[14,7,14,9],[13,1,14,1],[10,7,10,9],[11,7,11,9],[12,7,12,9],[9,1,10,1],[11,1,12,1],[16,8,16,9],[15,7,15,9],[6,8,6,9],[8,7,8,9],[0,1,0,9],[1,1,1,9],[4,8,4,9],[4,2,4,7],[5,1,5,9],[6,2,6,6],[3,2,3,7],[2,2,2,7]]}
[null,"FÉDÉRATION FRANCAISE DE PÉTANQUE ET DE JEU PROVENÇAL"]
[null,"COMITÉ DE MAINE ET LOIRE"]
[null,null,"FEUILLE COMPTABLE 2024"]
[null,null,"2023-10-24"]
[null,null,"Il est obligatoire que ce document soit rempli informatiquement, et doit être joint impérativement à chaque demande de licences"]
[]
[null,"CLUB",{"$f":"IF(I7=0,\"\",VLOOKUP(I7,Clubs!A1:B72,2,0))","v":""},null,null,null,null,"N°",{"$f":"Menu!$B$4","v":0}]
[]
[null,"année","CATEGORIE","NOMBRE","PRIX UNITAIRE","TOTAL",null,"Réservé  Comité"]
[null,"1964 et avant ","VETERANS MASCULINS ",null,34,{"$f":"E10*D10","v":0},null,"Date d'arrivée au comité"]
[null,null,"VETERANS FEMININES ",null,34,{"$f":"E11*D11","v":0}]
[null,"1965 à 2006","SENIORS MASCULINS ",null,34,0,null,"Controlé par :"]
[null,null,"SENIORS FEMININES ",null,34,0]
[null,"2007 à 2009","JUNIORS MASCULINS ",null,24,0,null,"Date"]
[null,null,"JUNIORS FEMININES ",null,24,0,null,"Traité par :"]
[null,"2010 à 2012","CADETS MASCULINS ",null,17,0]
[null,null,"CADETS FEMININES ",null,17,0,null,"Date"]
[null,"2013 à 2015","MINIMES MASCULINS ",null,17,0,null,"Réception des Licences"]
[null,null,"MINIMES FEMININES ",null,17,0,null,"Date"]
[null,"2016 et apres","BENJAMINS MASCULINS ",null,12,0,null,"Avisé club date"]
[null,null,"BENJAMINS FEMININES ",null,12,0,null,"Mise à Jour"]
[null,"TOTAL LICENCE (S) ",null,{"$f":"SUM(D10:D21)","v":0},null,{"$f":"SUM(F10:F21)","v":0},null,"Réception"]
[null,"DEMANDE DE DUPLICATA ",null,"NOMBRE","PRIX UNITAIRE","TOTAL"]
[null,"TOUTES CATÉGORIES",null,null,6,{"$f":"E24*D24","v":0}]
[null,"TOTAL  ",null,{"$f":"D22","v":0},null,{"$f":"SUM(F22+F24)","v":0}]
[]
[null,null,null,null,"Montant à régler",null,null,{"$f":"F22+F24","v":0}]
[]
[null,null,"MODE DE REGLEMENT"]
[null,null,"CHÈQUE","VIREMENT",null,"ESPÈCE"]
[]
[]
[null,null,"DATE D'ENVOI DU CLUB: ",null,null,"Visa du Club"]
[]
[null,null,"DATE RECEPTION COMITE",null,null,"visa du Comité"]
[]
[null,null,"RETRAIT DES LICENCES AU COMITÉ",null,"OUI","NON"]
[]
["FFPJP - CD 49  - 135 Rue Saumuroise  -  Tel : 02 41 66 86 82"]

{"sheet":"Demande de Duplicata","index":11,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":true,"merged":[[15,1,15,5],[17,3,17,5],[21,1,21,3],[23,1,23,4],[11,1,11,2],[11,4,11,5],[13,2,13,4],[19,1,19,3],[9,1,9,2],[0,0,0,6],[1,0,1,6],[3,0,3,6],[5,1,5,5],[7,1,7,4]]}
["Fédération Française de Pétanque et Jeu Provençal"]
["Région des Pays de la Loire - Comité de Maine et Loire"]
[]
["DEMANDE DE DUPLICATA"]
[]
[null,"ATTESTATION"]
[]
["Club",{"$f":"IF(G8=0,\"\",VLOOKUP(G8,Clubs!A1:B72,2,0))","v":""},null,null,null,"N°",{"$f":"Menu!$B$4","v":0}]
[]
["N° licence",null,null,null,null,null,"réservé Comité"]
[]
["NOM",null,null,"prénom",null,null,"Vétérans 20 €"]
[]
["date de naissance",null,null,null,null,null,"Séniors 20 €"]
[]
["adresse",null,null,null,null,null,"Juniors12 €"]
[]
["code postal",null,"Ville",null,null,null,"Cadets  8.00€"]
[]
["Catégorie",null,null,null,null,null,"Minimes 8.00€"]
[]
["fait à",null,null,null,"le",null,"Benjamins 8.00€"]
[]
[null,"Signature du joueur ou du président",null,null,null," N° Chèque"]
[null,null,null,null,null,"Espèces","  OUI       NON"]

{"sheet":"DUPLICATA EN COURS D'ANNEE","index":12,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,1,21,3],[23,1,23,4],[11,1,11,2],[11,4,11,5],[13,2,13,4],[15,1,15,5],[17,3,17,5],[19,1,19,3],[9,1,9,2],[0,0,0,6],[1,0,1,6],[3,0,3,6],[5,1,5,5],[7,1,7,4]]}
["Fédération Française de Pétanque et Jeu Provençal"]
["Région des Pays de la Loire - Comité de Maine et Loire"]
[]
["DEMANDE DE DUPLICATA"]
[]
[null,"ATTESTATION"]
[]
["Club",{"$f":"IF(G8=0,\"\",VLOOKUP(G8,[5]Clubs!A1:B74,2,0))","v":""},null,null,null,"N°",{"$f":"[5]Menu!$B$4","v":0}]
[]
["N° licence",null,null,null,null,null,"réservé Comité"]
[]
["NOM",null,null,"prénom",null,null,"Vétérans 20 €"]
[]
["date de naissance",null,null,null,null,null,"Séniors 20 €"]
[]
["adresse",null,null,null,null,null,"Juniors12 €"]
[]
["code postal",null,"Ville",null,null,null,"Cadets  8.00€"]
[]
["Catégorie",null,null,null,null,null,"Minimes 8.00€"]
[]
["fait à",null,null,null,"le",null,"Benjamins 8.00€"]
[]
[null,"Signature du joueur ou du président",null,null,null," N° Chèque"]
[null,null,null,null,null,"Espèces","  OUI       NON"]

{"sheet":"Correction d'erreur","index":13,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[25,0,25,9],[27,2,27,3],[29,1,29,4],[15,2,15,4],[24,8,24,9],[0,1,0,9],[1,1,1,9],[3,1,3,9],[5,1,5,4],[5,6,5,9],[13,2,13,3],[24,1,24,2],[7,2,7,3],[7,7,7,8],[9,2,9,4],[9,7,9,9],[11,2,11,4],[11,7,11,8],[24,6,24,7]]}
[null,"Fédération Française de Pétanque et Jeu Provençal"]
[null,"Région des Pays de la Loire - Comité de Maine et Loire"]
[]
[null,"CORRECTION D'ERREUR"]
[]
[null,"LICENCE ACTUELLE",null,null,null,null,"NOUVELLE LICENCE"]
[]
[null,"N° licence",null,null,null,null,"N° licence"]
[]
[null,"NOM",null,null,null,null,"NOM"]
[]
[null,"Prénom",null,null,null,null,"Prénom"]
[]
[null,"Né le",null,null,null,null,"Né le"]
[]
[null,"Club",null,null,null,null,"Club"]
[]
[null,"N°",null,null,null,null,"N°"]
[]
[null,"Catégorie",null,null,null,null,"Catégorie"]
[]
[null,"Classification",null,null,null,null,"Classification"]
[]
[]
[null,"erreur du club",null,"6 euros",null,null,"erreur du Comité ",null,"à la charge du Comité"]
["Le changement d'adresse en cours de saison n'engage pas une nouvelle licence"]
[]
[null,"chèque N°",null,null,null,null,"Espèces","OUI","NON"]
[]
[null,"signature du Président et et cachet du club"]

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