{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Bordereau","Feuil1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Instructions","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,11],[3,0,3,8],[7,0,7,16383],[25,0,25,16383],[27,0,27,16383],[29,0,51,16383],[4,0,5,16383],[1,0,2,16383],[3,9,3,25],[9,0,9,16383],[11,0,11,16383],[13,0,13,16383],[17,0,17,16383],[19,0,19,16383],[21,0,21,16383],[23,0,23,16383],[15,0,15,16383]]}
["Bonjour et Bienvenue dans cette nouvelle version du bordereau numérique,"]
[]
[]
["Important : merci de respecter quelques règles pour utiliser ce fichier :"]
[]
[]
[null,"1)","La première licence à enregistrer doit être une reprise"]
[]
[null,"2)","Il est préférable de brancher le lecteur de carte avant d'ouvrir ce fichier"]
[]
[null,"3)","Passez un maximun de 12 licences par bordereau, les unes après les autres"]
[]
[null,"4)","Cliquez sur le bouton A->Z pour ranger vos licenciés par ordre alphabétique"]
[]
[null,"5)","Renseignez la case situation (N, R, M, D) via le menu déroulant"]
[]
[null,"6)","Si vous avez 1 reprise + 1 duplicata, merci de le faire en 2 fois (problème de compta) (1 ligne reprise + 1 ligne duplicata)"]
[]
[null,"7)","Si pour une raison autre, vous avez cliqué sur une cellule pour la mettre à jour et que vous souhaitez reprendre avec le lecteur carte, cliquez sur cet icône           à la ligne désirée"]
[]
[null,"8)","Lorsque vous cliquez sur le bouton A->Z, la case situation ne suivra pas. Pensez à remettre à jour vos licenciés"]
[]
[null,"9)","Imprimez, sauvegardez ou envoyez le fichier par mail selon votre convenance"]
[]
[null,"10)","N'oubliez pas d'activer les macros ou d'activer son contenu ainsi que de cliquez sur l'onglet \"bordereau\" avant de commencer."]
[]
[null,"11)","La fonction RAZ efface complétement le fichier ainsi que sa dernière sauvegarde"]
[]
[null,"12)","Si le lecteur de carte ne fonctionne pas correctement, ouvrer gestion concours en même temps que ce fichier"]

{"sheet":"Bordereau","index":1,"n_rows":38,"n_cols":29,"rows_kept":38,"cut":false,"hidden":false,"merged":[[16,0,17,0],[16,6,17,6],[16,7,17,7],[16,10,17,10],[13,4,13,11],[14,4,14,11],[36,8,38,10],[12,4,12,11],[13,12,13,15],[16,8,17,8],[16,9,17,9],[36,11,38,13],[16,5,17,5],[38,4,38,5],[35,0,35,15],[16,11,17,11],[37,0,37,6],[36,0,36,6],[12,0,14,3],[12,12,12,15],[14,12,14,15],[16,12,17,15],[31,0,33,0],[34,0,34,15],[31,4,31,15],[29,1,29,2],[31,1,33,3],[32,4,32,15],[33,4,33,15],[37,14,38,15],[36,14,36,15],[23,1,23,2],[30,1,30,2],[16,4,17,4],[24,1,24,2],[22,1,22,2],[19,1,19,2],[20,1,20,2],[26,1,26,2],[21,1,21,2],[25,1,25,2],[18,1,18,2],[16,3,17,3],[27,1,27,2],[28,1,28,2]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",13,54,5418096,4106,"23bis rue du Colonel Moll"]
[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,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,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,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,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,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,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,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,null,null,"CD54 / FEDERATION FRANCAISE DE PETANQUE ET JEU PROVENCAL ",null,null,null,null,null,null,null,"Date :",null,null,null," "]
[null,null,null,null," 13, rue Jean Moulin - 54510 TOMBLAINE - Tel. 03.83.18.88.31",null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-11-15"}]
[null,null,null,null,"BORDEREAU DE COMMANDE DE LICENCES (à compléter par ordre alphabétique)",null,null,null,null,null,null,null,"Bordereau n°"]
[null,null,null,"CLUB :",{"$f":"VLOOKUP(I1,Feuil1!B2:C71,2,TRUE)","v":{"$error":"#N/A"}},null,{"$f":"\"N° :\"&Q13&Q13&I1","v":"N° :  "}]
["N°","N","R","N° LICENCE                           (si existant)","NOM et Prénom","DATE DE NAISSANCE","ADRESSE COMPLÈTE","Si Certificat médical date","QS","Sexe","Nationalité","MAIL\n(avec accord licencié)","Atteste avoir lu les informations MMA et RGPD "]
[null,"M","D"]
[1," ",null,{"$f":"H1","v":0},{"$f":"A1&X1&B1","v":" "},{"$f":"C1","v":"00:00:00"},{"$f":"J1&X1&L1&X1&M1","v":"  "},null,{"$f":"IF(H19=\"\",\"x\",\"\")","v":"x"},{"$f":"E1","v":0},{"$f":"D1","v":"00:00:00"},null,{"$f":"IF(F19=0,\"\",\"x\")","v":""},"oui",null,"non"]
[2," ",null,0," ","00:00:00","  ",null,"x",0,0,null,"","oui",null,"non"]
[3," ",null,0," ","00:00:00","  ",null,"x",0,0,null,"","oui",null,"non"]
[4," ",null,0," ","00:00:00","  ",null,"x",0,"00:00:00",null,"","oui",null,"non"]
[5," ",null,0," ","00:00:00","  ",null,"x",0,0,null,"","oui",null,"non"]
[6," ",null,0," ","00:00:00","  ",null,"x",0,0,null,"","oui",null,"non"]
[7," ",null,0," ","00:00:00","  ",null,"x",0,0,null,"","oui",null,"non"]
[8," ",null,0," ","00:00:00","  ",null,"x",0,0,null,"","oui",null,"non"]
[9," ",null,0," ","00:00:00","  ",null,"x",0,0,null,"","oui",null,"non"]
[10," ",null,0," ","00:00:00","  ",null,"x",0,"00:00:00",null,"","oui",null,"non"]
[11," ",null,0," ","00:00:00","  ",null,"x",0,0,null,"","oui",null,"non"]
[12," ",null,0," ","00:00:00","  ",null,{"$f":"IF(H30=\"\",\"x\",IF(B30=\"N\",\"\",\"\"))","v":"x"},0,0,null,"","oui",null,"non"]
[]
["→","Légende",null,null,"N = Nouveau - R = Renouvellement - M = Mutation - D = Duplicata - CM = Date Certificat Médical : OBLIGATOIRE si nouvelle licence (non licencié en 2021) "]
[null,null,null,null,"QS = Questionnaire Santé :  OBLIGATOIRE pour le renouvellement (licencié en 2021)"]
[null,null,null,null,"NAT. = Nationalité : F (Française), U (Union Européenne), E (Etranger) / SEXE : H = Homme / F = Femme"]
["Le Président …................................................................. certifie exactes les informations figurant sur ce bordereau et que TOUS ses adhérents ont bien pris connaissance :  "]
["* de la possibilité pour chaque licencié de ne pas souscrire à l'assurance dommages corporels et de son coût ;\n* de l'intérêt de souscrire les garanties optionnelles, accidents corporels, correspondant à l'option \"avantage\" de la compagnie d'Assurance  M.M.A conformément à l'article L.321-4 du Code du Sport, par le biais de l'imprimé prévu à cet effet ;                                                                                                                                                                                                                                                                                                                                                                                                                                 * que les informations 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/1978 modifiée, et qu'elles soient utilisées à des fins commerciales.                                                                                                                                                                                         Qu'ils bénéficient d'un droit d'accès, de rectification et d'opposition auprès des services du siége de la F.F.P.J.P. 13 rue Trigance 13002 MARSEILLE."]
[null,null,null,null,null,null,null,null,"Signature :",null,null,null,null,null,"PRIX"]
["Le Président …................................................................ certifie avoir reçu pour : \n* un mineur : l'attestation relative Questionnaire Santé (adressez une copie au Comité Départemental)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Feuil1!H16","v":0}]

{"sheet":"Feuil1","index":2,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,9,1,16],[2,9,2,10],[3,9,3,10],[2,11,2,12],[3,11,3,12],[2,13,2,15],[3,13,3,15]]}
["ListDeroul","Numéro club","Club",null,null,"année n","age n saison","Prix Licence","Situation"]
["N",1002,"BRIEY",null,1,{"$f":"YEAR(Bordereau!F19)","v":1900},{"$f":"F15-F2","v":125},{"$f":"IF(G2<12,J4,IF(G2<15,L4,IF(I2=\"D\",Q4,IF(G2>110,0,N4))))","v":0},{"$f":"Bordereau!B19","v":" "},"TARIF"]
["R",1004,"BATILLY",null,2,{"$f":"YEAR(Bordereau!F20)","v":1900},{"$f":"F15-F3","v":125},{"$f":"IF(G3<12,J4,IF(G3<15,L4,IF(I3=\"D\",Q4,IF(G3>110,0,N4))))","v":0},{"$f":"Bordereau!B20","v":" "},"BENJ + MINIME AGE < 12",null,"CADET AGE < 15",null,"JUNIOR + SENIOR + VETERAN",null,null,"DUPLICATA"]
["M",1005,"VALLEROY",null,3,{"$f":"YEAR(Bordereau!F21)","v":1900},{"$f":"F15-F4","v":125},{"$f":"IF(G4<12,J4,IF(G4<15,L4,IF(I4=\"D\",Q4,IF(G4>110,0,N4))))","v":0},{"$f":"Bordereau!B21","v":" "},16,null,17,null,30,null,null,10]
["D",1006,"AUBOUE",null,4,{"$f":"YEAR(Bordereau!F22)","v":1900},{"$f":"F15-F5","v":125},{"$f":"IF(G5<12,J4,IF(G5<15,L4,IF(I5=\"D\",Q4,IF(G5>110,0,N4))))","v":0},{"$f":"Bordereau!B22","v":" "}]
[null,1009,"MANCIEULLES",null,5,{"$f":"YEAR(Bordereau!F23)","v":1900},{"$f":"F15-F6","v":125},{"$f":"IF(G6<12,J4,IF(G6<15,L4,IF(I6=\"D\",Q4,IF(G6>110,0,N4))))","v":0},{"$f":"Bordereau!B23","v":" "}]
[null,1021,"GIRAUMONT",null,6,{"$f":"YEAR(Bordereau!F24)","v":1900},{"$f":"F15-F7","v":125},{"$f":"IF(G7<12,J4,IF(G7<15,L4,IF(I7=\"D\",Q4,IF(G7>110,0,N4))))","v":0},{"$f":"Bordereau!B24","v":" "}]
[null,1031,"JARNY",null,7,{"$f":"YEAR(Bordereau!F25)","v":1900},{"$f":"F15-F8","v":125},{"$f":"IF(G8<12,J4,IF(G8<15,L4,IF(I8=\"D\",Q4,IF(G8>110,0,N4))))","v":0},{"$f":"Bordereau!B25","v":" "}]
[null,1042,"MOUTIERS",null,8,{"$f":"YEAR(Bordereau!F26)","v":1900},{"$f":"F15-F9","v":125},{"$f":"IF(G9<12,J4,IF(G9<15,L4,IF(I9=\"D\",Q4,IF(G9>110,0,N4))))","v":0},{"$f":"Bordereau!B26","v":" "}]
[null,1070,"JOEUF",null,9,{"$f":"YEAR(Bordereau!F27)","v":1900},{"$f":"F15-F10","v":125},{"$f":"IF(G10<12,J4,IF(G10<15,L4,IF(I10=\"D\",Q4,IF(G10>110,0,N4))))","v":0},{"$f":"Bordereau!B27","v":" "}]
[null,2004,"SAULNES",null,10,{"$f":"YEAR(Bordereau!F28)","v":1900},{"$f":"F15-F11","v":125},{"$f":"IF(G11<12,J4,IF(G11<15,L4,IF(I11=\"D\",Q4,IF(G11>110,0,N4))))","v":0},{"$f":"Bordereau!B28","v":" "}]
[null,2007,"MONT ST MARTIN",null,11,{"$f":"YEAR(Bordereau!F29)","v":1900},{"$f":"F15-F12","v":125},{"$f":"IF(G12<12,J4,IF(G12<15,L4,IF(I12=\"D\",Q4,IF(G12>110,0,N4))))","v":0},{"$f":"Bordereau!B29","v":" "}]
[null,2050,"GOURAINCOURT",null,12,{"$f":"YEAR(Bordereau!F30)","v":1900},{"$f":"F15-F13","v":125},{"$f":"IF(G13<12,J4,IF(G13<15,L4,IF(I13=\"D\",Q4,IF(G13>110,0,N4))))","v":0},{"$f":"Bordereau!B30","v":" "}]
[null,2053,"GORCY"]
[null,2067,"LONGUYON",null,"année n",{"$f":"YEAR(TODAY())+F16","v":2025},null,"TOTAL"]
[null,2076,"HEUMONT REHON",null,"fin d'année ?",{"$f":"IF(MONTH(TODAY())=11,1,IF(MONTH(TODAY())=12,1,0))","v":1},null,{"$f":"SUM(H2:H13)","v":0}]
[null,2090,"MEXY"]
[null,2095,"LONGWY"]
[null,2097,"HAUCOURT ST CHARLES"]
[null,2112,"HUSSIGNY"]
[null,2118,"MERCY LE BAS"]
[null,3019,"AP LUNEVILLE"]
[null,3020,"DOMBASLE"]
[null,3033,"LANEUVEVILLE"]
[null,3034,"ST NICOLAS"]
[null,3045,"NEUVES MAISONS"]
[null,3058,"LUNEVILLE GARI"]
[null,3068,"JARVILLE"]
[null,3085,"BACCARAT"]
[null,3091,"ACBD"]
[null,3105,"BAINVILLE"]
[null,3108,"SOMMERVILLER"]
[null,3114,"BAYON"]
[null,3200,"CHALIGNY"]
[null,4016,"ANP"]
[null,4029,"AP VANDOEUVRE"]
[null,4041,"ASPTT"]
[null,4095,"PULNOY"]
[null,4098,"VILLERS"]
[null,4103,"ESSEY"]
[null,4106,"AP STE MARIE"]
[null,5013,"PONT A MOUSSON"]
[null,5024,"CHAMPIGNEULLES"]
[null,5025,"PAGNY / MOSELLE"]
[null,5030,"DIEULOUARD"]
[null,5036,"BLENOD"]
[null,5049,"BOUXIERES AUX DAMES"]
[null,5060,"JEANDELAINCOURT"]
[null,5081,"CHAMPEY"]
[null,5082,"LIVERDUN"]
[null,5083,"LAY ST CHRISTOPHE"]
[null,5086,"FROUARD"]
[null,5099,"BEZAUMONT"]