{"text_format":"1","workbook":"xls","n_sheets":5,"sheets":["BUT","REGLES","INITIALISATION","RESULTAT","TABLE_1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":51,"comments":1,"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","formulas":"cached_only"}

{"sheet":"BUT","index":0,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[[12,0,12,11],[13,0,13,11],[14,0,14,11],[0,0,0,11],[2,0,2,11],[4,0,4,11],[5,0,5,11],[23,0,23,11],[19,0,19,11],[3,0,3,11],[21,0,21,11],[22,0,22,11],[15,0,15,11],[16,0,16,11],[17,0,17,11],[18,0,18,11],[11,0,11,11]],"flags":["formulas_cached_only"]}
["Feuille de match automatisée et unique pour toutes les catégories du "]
[]
["Championnat de France par équipes de club : Jeux de série (4 Div) et 3 bandes (4 Div)."]
["************"]
["Pour rendre service à mon Club (BCCO Ronchin) et aux autres CLUBS intéressés, j'ai réalisé, en EXCEL (2003), ce programme généralisé permettant une saisie automatisée, très contrôlée et sécurisée afin d'éviter les erreurs sur les feuilles de match des 8 catégories ci-dessus. "]
["L'un des avantages de cette version, outre la sécurité, est que les paramètres de chaque mode de jeu et division ont été mis dans une TABLE, ce qui permet une modification très facile du modèle, par simple mise à jour de la table, en cas d'évolution (années à venir) et cela même par un non-spécialiste d'EXCEL :"]
["- nb de joueurs 3 ou 4"]
["- nb de points à jouer (L, cadre(s), B, 3B)"]
["- points de match attribués (G,N,P,forfait) : 3,2,1,0 ou 2,1,0,0"]
["- limite de reprises (60,...)"]
[]
["Principaux avantages :"]
["- uniformisation des résultats et des affichages sur les sites"]
["- sécurité, fiabilité"]
["- évolutivité et facilité de la maintenance par table (et avantage de l'unicité : ne pas rechercher longtemps le programme adéquat)"]
["mais surtout "]
["- possibilité de passage des résultats sur un site web en quelques clics et quelques secondes : en effet, la définition d'une 'zone-web' (à sélectionner et \"enregistrer en tant que page web\" donc xxx.htm) a été étudiée pour une bonne lisibilité. Le fichier htm obtenu, de faible taille (60 ko) par rapport à une image scannée) peut être transféré sur un site web du club et/ou transmis par email à un web-master de club, de district, de ligue ou à la FFB. Dans tous les cas, la feuille signée est toujours transmise au responsable concerné."]
["- la saisie des résultats est cadrée automatiquement selon la taille de l'écran utilisée dans chaque club, ceci permet d'optimiser l'utilisation de l'écran afin d'avoir le maximum de visibilité et de vue d'ensemble."]
["- traitement complet et automatique des cas de FORFAIT"]
["- contrôle des N° de licence (clé), etc..."]
[]
["Les règles appliquées et le détail des contrôles réalisés sont sur la feuille REGLES ci-contre."]
["La vérification, saisie ou correction des destinataires se fait sur la feuille TABLE_1 ci-contre."]
["Pour commencer à saisir une rencontre on clique d'abord sur le bouton mode d'emploi ci-contre                                                      (INITIALISATION)"]

{"sheet":"REGLES","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,0,8,11],[9,0,9,11],[7,0,7,5],[7,6,7,11],[0,0,0,11],[5,0,5,11],[6,0,6,5],[6,6,6,11],[2,0,2,11],[3,0,3,5],[3,6,3,11],[4,0,4,5],[4,6,4,11],[10,0,10,11],[13,0,13,11],[14,0,14,11],[11,0,11,11],[12,0,12,11]],"flags":["formulas_cached_only"]}
[]
[]
["Principales REGLES (oct.2008) appliquées et contrôles automatiques (mis sous forme de TABLE aisément modifiable) :"]
["Equipes de 3 joueurs sauf  3 BANDES en D1 et D2  (4 joueurs)",null,null,null,null,null,"  CALCUL : Points de match : gagné,nul,perdu = 2,1,0       sauf  JDS_D1 = (3,2,1)"]
["Points à jouer : attribués automatiquement selon 'mode de jeu et division'.",null,null,null,null,null,"La moyenne est mise automatiquement à 3 décimales au 3 BANDES."]
["Au \"3BANDES\" les D3 et D4 sont limitées à 60 reprises,de ce fait le calcul des points de match tient toujours compte qu'un gagnant peut ne pas avoir atteint les \"points à jouer\"."]
[null,null,null,null,null,null,"  CONTRÔLE :         0 <= Points réalisés < = Points à jouer"]
["Reprises : aucune anomalie signalée de 1 à 150 reprises (sauf 3B_D3, D4)",null,null,null,null,null,"  CONTRÔLE :         Moy.réalisée <= Série <= Points réalisés"]
["La lettre-clé du N° de LICENCE doit être saisie comme dernier caractère de ce N° car elle est contrôlée et la case reste en jaune si la clé est invalide."]
["En cas de FORFAIT : pour que les points de match (et % pts réalisés) soient tout de même attribués automatiquement on peut saisir : 0 points et 0 reprises mais pour le joueur présent et donc gagnant : 0,001 point réalisé (en 0 reprise) puis saisir \"FORFAIT\" à la place du N° de licence du perdant ."]
[]
["                                                                                             (INITIALISATION)"]

{"sheet":"INITIALISATION","index":2,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[14,0,14,11],[10,0,10,11],[19,0,19,11],[12,0,12,11],[18,0,18,11],[17,0,17,11],[16,0,16,11],[0,0,0,11],[7,0,7,11],[2,0,2,11],[6,0,6,11],[3,0,3,11],[4,0,4,11],[21,0,21,4],[5,0,5,11],[15,0,15,11],[21,5,21,7],[20,0,20,11],[8,0,8,11],[9,0,9,11],[13,0,13,11],[11,9,11,10],[11,0,11,8]],"flags":["formulas_cached_only"]}
["MODE D'EMPLOI : "]
[]
["Programme prévu pour fonctionner sous EXCEL2003, EXCEL2000 ou Excel97.                                                Ecran conseillé : 1024 x 768 pixels"]
["Au préalable, il faut créer OBLIGATOIREMENT sur votre disque dur C ou D un répertoire ('COMPETITIONS' par ex) qui enregistrera les présents RESULTATS des compétitions et éventuellement le fichier des résultats sous forme HTM destinés à un site web (à consulter en ligne par Internet Explorer). Répertoire choisi (modifiable) :"]
["D:\\COMPETITIONS\\"]
["NB : Pour ce programme EXCEL, il faut autoriser les macros : par ex répondre OUI  à la question \"ACTIVER LES MACROS ?\" lors du chargement de ce fichier .xls ; au besoin, AVANT 1er chargement de ce XLS/XLT, on aura fait : Excel/Outils/options/Sécurité/SécuritéMacros/Faible puis Charger le XLS et remettre l'option habituelle."]
["Le présent format XLS a été prévu pour permettre, en quelques clics, d'afficher le résultat de façon claire et bien cadrée sur un site WEB et qu'il puisse se présenter de façon uniforme dans toutes les LIGUES puis dans les phases NATIONALES. Voir ci-contre les AVANTAGES et le BUT  recherché :"]
[" Après avoir lu l'ensemble de cette page, cliquez sur le bouton \"REMISE à ZERO et COMMENCER\" ci-dessous."]
["Si vous voulez, comme cela est souhaitable, que les destinataires des résultats, propres à votre ligue figurent bien sur chaque feuille de match, il est nécessaire :"]
[" 1/ de vérifier et au besoin corriger, pour votre LIGUE, les responsables destinataires figurant ci-après en TABLE_1?"]
[" 2/ Au minimum, vous devez saisir votre LIGUE en \"TABLE_1\" car son N° se reporte sur la feuille de match en case O4."]
[" Ensuite, il faudra SAISIR, dans l'ordre, de haut en bas et de gauche à droite, TOUTES les zones en",null,null,null,null,null,null,null,null,"JAUNE clair",null," (comme celle-ci.)"]
["Pour afficher les choix et choisir le \"Mode de jeu\" cliquez sur la petite flèche située à droite de la case concernée. Faites de même sur la case \"Division\" et saisissez votre N° de Ligue (pour indication automatique du destinataire des résultats selon les indications que vous avez vérifiées ou corrigées en TABLE_1\") puis cliquez OBLIGATOIREMENT sur le bouton \"VALIDER...\" "]
["Ensuite continuez en saisissant : Phase, Date, Noms des CLUBS, Format de billard choisi, Noms des JOUEURS et leur N° de licence et enfin, tout en bas, Noms des CAPITAINES des 2 équipes. Ne pas oublier de saisir le format des billards de chaque joueur encliquant en A1, A13, A15."]
[" CONSEIL : A ce moment, cliquer sur le bouton \"SAUVEGARDER\" pour enregistrer (dans le même répertoire que le XLT d'origine) le fichier dont le nom AUTOMATIQUE sera du type Ch.F_JDS_D3_LIG_BCCO_AVION.xls ou du type Ch.F_3B_D1_NAT_St-Maur_Andernos.xls ; le nom exact étant construit dans la cellule AB23 de la feuille résultat."]
["Ensuite faire une sauvegarde après chaque match dont on effectue la SAISIE toujours de GAUCHE à DROITE."]
[]
[]
[]
["Principales REGLES appliquées et contrôles automatiques (mis sous forme de TABLE aisément modifiable) :"]
[]
["Ce programme (et d'autres) sont  téléchargeables sur le  site internet :",null,null,null,null,"http://BILLARD59.chez-alice.fr",null,null,null,null,"Auteur : Daniel.Stocker :","ds59@aliceadsl.fr"]

{"sheet":"RESULTAT","index":3,"n_rows":42,"n_cols":33,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,0,1,11],[22,27,22,32],[34,1,34,4],[32,5,32,8],[31,22,31,23],[33,5,33,8],[34,5,34,8],[24,1,27,7],[24,8,27,14],[32,1,32,4],[7,0,9,0],[5,0,5,1],[10,6,11,6],[8,4,9,4],[8,5,9,5],[8,6,9,6],[10,3,11,3],[10,4,11,4],[10,5,11,5],[5,2,5,6],[4,17,4,19],[10,7,11,7],[10,10,11,10],[0,16,13,16],[10,13,11,13],[8,12,9,12],[8,11,9,11],[0,0,0,14],[12,0,13,0],[5,28,7,31],[10,0,11,0],[5,9,5,14],[1,20,1,21],[2,20,2,21],[3,20,3,21],[3,0,3,7],[0,15,2,15],[3,9,3,13],[4,20,4,21],[14,12,15,12],[10,14,11,14],[12,3,13,3],[12,4,13,4],[10,11,11,11],[10,12,11,12],[12,10,13,10],[12,11,13,11],[7,9,7,14],[12,12,13,12],[16,10,17,10],[14,7,15,7],[14,10,15,10],[16,12,17,12],[16,11,17,11],[14,11,15,11],[14,13,15,13],[14,14,15,14],[16,6,17,6],[16,7,17,7],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[16,0,17,0],[16,3,17,3],[16,4,17,4],[16,5,17,5],[18,1,18,2],[28,9,28,12],[20,9,20,14],[20,1,21,1],[20,2,20,7],[22,4,22,5],[22,11,22,12],[18,8,18,9],[28,6,28,7],[16,13,17,13],[16,14,17,14],[35,0,35,15],[24,0,34,0],[29,2,31,5],[29,6,31,7],[28,13,28,14],[29,9,31,12],[29,13,31,14],[28,2,28,5],[18,28,19,28],[9,29,9,31],[18,18,18,21],[18,22,18,25],[18,27,19,27],[2,9,2,12],[2,13,2,14],[8,13,9,13],[14,0,15,0],[12,5,13,5],[12,6,13,6],[7,2,7,7],[12,14,13,14],[12,7,13,7],[12,13,13,13]],"flags":["formulas_cached_only"]}
["FEDERATION FRANCAISE DE BILLARD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliquer ici après saisie N° Ligue et phase --v",null,null,null,null,null,null,null,"REP.Max","",null,"JDS","<==JDS ou 3B","","3m10 anormal si:"]
["19 et 21, Avenue Aristide Briand - B.P.2202   03202 VICHY CEDEX - Tél. : 04.70.96.01.02",null,null,null,null,null,null,null,null,null,null,null,null,null,"  N (Nat.) ou n° Ligue",null,null,"JEUX DE SERIE",null,null,"4ème division.",null,null,"3B=",0,"0.00","<=décimales avec \".\" pour macro",null,null,0,0,0]
[null,null,null,null,null,null,null,null,"Mode de jeu","Division",null,null,null,null,null,null,null,"",null,null,"3ème division.",null,null,"N_div",0,0,0,"<==1 si Phase Nat",null,"3B","JDS"]
["CHAMPIONNAT de FRANCE par équipes ",null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,"3 BANDES",null,null,"2ème division.",null,null,"Nb_Jr",4,null,"LIGN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table : \"POINTS\"",null,null,"1ère division.",null,null,"N_col",1,0,"N","<==G_3=1 si G=3 points"]
["Phase :",null,null,null,null,null,null,null,"RENCONTRE DU (JJ / MM) : ","2009-01-26",null,null,null,null,null,null,null,"valeur init","Div1","Div2","Div3","Div4","Div1","Div2","Div3","Div4",1,null,"la LIGNE 5 donne le n° de ligne dans la table \"DESTINA\" des destinataires des résultats: FFB; AA, SL, L13, Lxx"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",3,3,3,3,4,4,3,3,2,"<==Joueurs"]
["Format","CLUB VISITÉ :",null,null,null,null,null,null,"CLUB VISITEUR :",null,null,null,null,null,null,null,null,"",999,999,999,999,999,999,60,60,3,"<==Rep.Max"]
[null,"NOM-Prénom","Points","Points","Rep.","Moy.G","Série","Points","NOM-Prénom","Points","Points","Rep.","Moy.G","Série","Points",null,null,"",0,0,0,0,0,0,0,0,4,"<==Gag=3 càd Si=1==>GNP=3,2,1 sinon 2,1,0"]
[null,"N° de LICENCE","à jouer","réalisés",null,null,null,"match","N° de LICENCE","à jouer","réalisés",null,null,null,"match",null,null,"",null,null,null,null,null,null,null,null,5,"Libre","Erreur de clé ?","=1 si gagné par forfait"]
["2,80",null,"",null,null,"",null,"",null,"","","","",null,"",null,null,"",250,300,200,150,40,35,30,20,6]
[null,null,"",null,null,"",null,null,null,"","",null,null,null,null,null,null,"","C.47/2","Libre","Libre","Libre","","","","",7,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"}]
["2,80",null,"",null,null,"",null,"",null,"","","","",null,"",null,null,"",200,200,120,100,40,35,30,20,8]
[null,null,"",null,null,"",null,null,null,"","",null,null,null,null,null,null,"","C.71/2","Cadre","Cadre","Libre","","","","",9,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"}]
["2,80",null,"",null,null,"",null,"",null,"","","","",null,"",null,null,"",120,100,80,60,40,35,30,20,10]
[null,null,"",null,null,"",null,null,null,"","",null,null,null,null,null,null,"","Bande","Bande","Bande","Bande","","","","",11,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"}]
["2,80",null,"",null,null,"",null,"",null,"",null,"","",null,"",null,null,"",0,0,0,0,40,35,30,20,12]
[null,null,"",null,null,"",null,null,null,"",null,null,null,null,null,null,null,"","SVP cliquer sur  \"VALIDER…\"","SVP cliquer sur  \"VALIDER…\"","SVP cliquer sur  \"VALIDER…\"","SVP cliquer sur  \"VALIDER…\"","","","SVP cliquer sur  \"VALIDER…\"","SVP cliquer sur  \"VALIDER…\"",13,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"}]
[null,"RESULTATS",null,0,0,"",0,"","RESULTATS",null,0,0,"",0,"",null,null,"","JEUX DE SERIE",null,null,null,"3 BANDES",null,null,null,14,"","<==Pour K11:K18 avec format conditionnel"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Libre",null,null,null,null,null,null,null,null,15,"",null,null,"somme=",{"$error":"#VALUE!"}]
[null," RESULTATS DE LA RENCONTRE :",0,null,null,null,null,null,"MATCH NUL",0,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,16]
[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,17,"Nom automatique de la sauvegarde :"]
[null,"POURCENTAGE POINTS REALISES :",null,null,"",null,null,"","à","",null,"",null,null,null,null,null,"LIGUE          Poule n° ",null,null,null,null,null,null,null,null,18,"D:\\COMPETITIONS\\Ch.F_JDS_D0_=_&_.xls"]
[null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,"NATIONALE  1/16ème",null,null,null,null,null,null,null,null,19]
[null,"Je soussigné, Capitaine de l'équipe mentionnée ci-dessus, déclare sur l'honneur que les joueurs précités répondent aux critères requis par le règlement de la Coupe de France.",null,null,null,null,null,null,"Je soussigné, Capitaine de l'équipe mentionnée ci-dessus, déclare sur l'honneur que les joueurs précités répondent aux critères requis par le règlement de la Coupe de France.",null,null,null,null,null,null,null,null,"NATIONALE  1/8ème",null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NATIONALE  1/4 finale",null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NATIONALE  1/2 finale",null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NATIONALE  FINALE",null,null,null,null,null,null,null,null,23]
[null,"NOM-PRENOM :","Observation :",null,null,null,"SIGNATURE :",null,"NOM-PRENOM :","Observation :",null,null,null,"SIGNATURE :",null,null,null,"NATIONALE  1/16ème",null,null,null,null,null,null,null,null,24,null,"OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NATIONALE      Poule n° ",null,null,null,null,null,null,null,null,null,"n° ligue ou \"N\"",13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table_REF",null,null,null,"REF= (N ou n°Ligue) & base",null,null,"Ligne copie :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N°col","base",null,null,null,"REF=","13 ","13 Copie",null,null,"13 Sportif"]
[null,"Ces résultats sont à envoyer immédiatement à ",null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,1,"",null,null,null,"LIG=",{"$error":"#N/A"},120,null,null,111,"+10 pour LIG réelle"]
[null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,2,"JDS D1",null,null,null,"LIG=",{"$error":"#N/A"},"LIG retenue","+10 pour LIG réelle"]
[null,"SVP : copie à     clairetjf@gmail.com",null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,3,"JDS D2",null,null,null,"NOM=",{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"JDS D3",null,null,null,"Tél.  ",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"JDS D4",null,null,null,"Mob.  ",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"3B D1",null,null,null,"Fax  ",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"3B D2",null,null,null,"SVP : copie à     ","clairetjf@gmail.com","SVP : copie à     clairetjf@gmail.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"3B D3",null,null,null,"Email        ",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"3B D4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Copie"]

{"sheet":"TABLE_1","index":4,"n_rows":240,"n_cols":18,"rows_kept":240,"cut":false,"hidden":false,"merged":[[1,4,1,10],[6,6,7,6],[6,8,6,10],[11,2,14,2],[5,1,6,4],[4,6,4,7],[5,6,5,7]],"flags":["formulas_cached_only"]}
[]
[null,null,null,null,"Table des RESPONSABLES de LIGUE (et FFB) JDS et 3B des 4 divisions."]
[]
[]
[null,null,null,null,null,null,"pour votre LIGUE :",null,null,null,null,null,null,null,null,null,"Rang",12]
[null,"Vérifier et/ou SAISIR ci-dessous les différents RESPONSABLES",null,null,null,null,"Nord-Pas de Calais",null,null,null,null,null,null,null,null,"ADR","deb",121]
[null,null,null,null,null,"N° ",13,null,"Si vérification, mise à jour terminée : ===>",null,null,null,null,null,null,"A121:E131","fin",131]
[]
[]
[null,"Référence ","LIGUE","n°","responsable","nom","prénom","Adresse","Code P. Ville","téléphone","mobile","fax","email",null,null,"LIGUES","n°","rang"]
[null,"N Sportif","Nationale","N","Sportif","la FEDERATION FRANCAISE DE BILLARD",null,"19 et 21, Avenue Aristide Briand   B.P.2202 ","03202 VICHY CEDEX ",null,null,"04.70.96.01.02","ffb.vichy@wanadoo.fr",null,null," Phase NATIONALE (FFB)","N",1]
[null,"N 3B D1","( Responsables phase nationale)","N","3B D1","la FEDERATION FRANCAISE DE BILLARD",null,"19 et 21, Avenue Aristide Briand   B.P.2202 ","03202 VICHY CEDEX ",null,null,"04.70.96.01.02","ffb.vichy@wanadoo.fr",null,null,"Alsace",1,2]
[null,"N 3B D2",null,"N","3B D2","AYOT","Alex","1, Rue Abel Aubrun","13800 ISTRES",null,null,"04 90 56 48 45","ayotalex@free.fr",null,null,"Aquitaine",4,5]
[null,"N 3B D3",null,"N","3B D3","AYOT","Alex","1, Rue Abel Aubrun","13800 ISTRES",null,null,"04 90 56 48 45","ayotalex@free.fr",null,null,"Auvergne",3,4]
[null,"N 3B D4",null,"N","3B D4","AYOT","Alex","1, Rue Abel Aubrun","13800 ISTRES",null,null,"04 90 56 48 45","ayotalex@free.fr",null,null,"Bourgogne",22,21]
[null,"N JDS D1",null,"N","JDS D1","la FEDERATION FRANCAISE DE BILLARD",null,"19 et 21, Avenue Aristide Briand   B.P.2202 ","03202 VICHY CEDEX ",null,null,null,"ffb.vichy@wanadoo.fr",null,null,"Bretagne",2,3]
[null,"N JDS D2",null,"N","JDS D2","LANDRÉ","Sylvie","Les Violettes  -4, Allée des Chênes","49500 SEGRE",null,null,"02.41.61.22.52","sylvie.landre@wanadoo.fr",null,null,"Centre",15,14]
[null,"N JDS D3",null,"N","JDS D3","LANDRÉ","Sylvie","Les Violettes  -4, Allée des Chênes","49500 SEGRE",null,null,"02.41.61.22.52","sylvie.landre@wanadoo.fr",null,null,"Champagne",5,6]
[null,"N JDS D4",null,"N","JDS D4","LANDRÉ","Sylvie","Les Violettes  -4, Allée des Chênes","49500 SEGRE",null,null,"02.41.61.22.52","sylvie.landre@wanadoo.fr",null,null,"Franche Comté",8,7]
[null,"N Copie",null,"N","Copie",null,null,null,null,null,null,null,null,null,null,"Guadeloupe",24,23]
[null,"1 Sportif","Alsace",1,"Sportif","KAUFFEISEN","Jean","","ERSTEIN","03.88.98.69.07","","","jkauffeisen@wanadoo.fr",null,null,"Ile de France",9,8]
[null,"1 3B D1",null,1,"3B D1",null,null,null,null,null,null,null,null,null,null,"Languedoc-Roussillon",10,9]
[null,"1 3B D2",null,1,"3B D2",null,null,null,null,null,null,null,null,null,null,"Limousin",21,20]
[null,"1 3B D3",null,1,"3B D3",null,null,null,null,null,null,null,null,null,null,"Lorraine",11,10]
[null,"1 3B D4",null,1,"3B D4",null,null,null,null,null,null,null,null,null,null,"Méditerranée",19,18]
[null,"1 JDS D1",null,1,"JDS D1",null,null,null,null,null,null,null,null,null,null,"Midi-Pyrénées",20,19]
[null,"1 JDS D2",null,1,"JDS D2",null,null,null,null,null,null,null,null,null,null,"Nord-Pas de Calais",13,12]
[null,"1 JDS D3",null,1,"JDS D3",null,null,null,null,null,null,null,null,null,null,"Normandie",14,13]
[null,"1 JDS D4",null,1,"JDS D4",null,null,null,null,null,null,null,null,null,null,"Pays de la Loire",16,15]
[null,"1 Copie",null,1,"Copie",null,null,null,null,null,null,null,null,null,null,"Picardie",17,16]
[null,"2 Sportif","Bretagne",2,"Sportif","VALLEE","Christian","","KERVIGNAC","","06.32.95.91.68","","christian.valle1@libertysurf.fr",null,null,"Poitou-Charentes",18,17]
[null,"2 3B D1",null,2,"3B D1",null,null,null,null,null,null,null,null,null,null,"Réunion",23,22]
[null,"2 3B D2",null,2,"3B D2",null,null,null,null,null,null,null,null,null,null,"Rhône-Alpes",12,11]
[null,"2 3B D3",null,2,"3B D3"]
[null,"2 3B D4",null,2,"3B D4"]
[null,"2 JDS D1",null,2,"JDS D1"]
[null,"2 JDS D2",null,2,"JDS D2"]
[null,"2 JDS D3",null,2,"JDS D3"]
[null,"2 JDS D4",null,2,"JDS D4"]
[null,"2 Copie",null,2,"Copie"]
[null,"3 Sportif","Auvergne",3,"Sportif","DURAND","Pascal","","NEVERS","03.86.36.95.16","06.72.79.74.40","","Pascal.Durand39@wanadoo.fr"]
[null,"3 3B D1",null,3,"3B D1"]
[null,"3 3B D2",null,3,"3B D2"]
[null,"3 3B D3",null,3,"3B D3"]
[null,"3 3B D4",null,3,"3B D4"]
[null,"3 JDS D1",null,3,"JDS D1"]
[null,"3 JDS D2",null,3,"JDS D2"]
[null,"3 JDS D3",null,3,"JDS D3"]
[null,"3 JDS D4",null,3,"JDS D4"]
[null,"3 Copie",null,3,"Copie"]
[null,"4 Sportif","Aquitaine",4,"Sportif","BARTHELEMY","Eric","","VILLENAVE D'ORNON","05.56.75.96.52","06.15.27.61.14","05.56.75.96.52","eric.barth@wanadoo.fr"]
[null,"4 3B D1",null,4,"3B D1"]
[null,"4 3B D2",null,4,"3B D2"]
[null,"4 3B D3",null,4,"3B D3"]
[null,"4 3B D4",null,4,"3B D4"]
[null,"4 JDS D1",null,4,"JDS D1"]
[null,"4 JDS D2",null,4,"JDS D2"]
[null,"4 JDS D3",null,4,"JDS D3"]
[null,"4 JDS D4",null,4,"JDS D4"]
[null,"4 Copie",null,4,"Copie"]
[null,"5 Sportif","Champagne",5,"Sportif","BENOIT","Paul","","REIMS","03.26.07.05.72","06.61.09.26.02","03.26.07.05.72","paul.benoit@wanadoo.fr"]
[null,"5 3B D1",null,5,"3B D1"]
[null,"5 3B D2",null,5,"3B D2"]
[null,"5 3B D3",null,5,"3B D3"]
[null,"5 3B D4",null,5,"3B D4"]
[null,"5 JDS D1",null,5,"JDS D1"]
[null,"5 JDS D2",null,5,"JDS D2"]
[null,"5 JDS D3",null,5,"JDS D3"]
[null,"5 JDS D4",null,5,"JDS D4"]
[null,"5 Copie",null,5,"Copie"]
[null,"8 Sportif","Franche Comté",8,"Sportif","BENGUIGUI","Paul","","SCEY SUR SAONE","03.84.68.82.18","","","paul.benguigui@tele2.fr"]
[null,"8 3B D1",null,8,"3B D1"]
[null,"8 3B D2",null,8,"3B D2"]
[null,"8 3B D3",null,8,"3B D3"]
[null,"8 3B D4",null,8,"3B D4"]
[null,"8 JDS D1",null,8,"JDS D1"]
[null,"8 JDS D2",null,8,"JDS D2"]
[null,"8 JDS D3",null,8,"JDS D3"]
[null,"8 JDS D4",null,8,"JDS D4"]
[null,"8 Copie",null,8,"Copie"]
[null,"9 Sportif","Ile de France",9,"Sportif","DARVILLE","Christophe","","CHEVILLY LA RUE","01.49.79.02.37","","","darvillechris@free.fr"]
[null,"9 3B D1",null,9,"3B D1"]
[null,"9 3B D2",null,9,"3B D2"]
[null,"9 3B D3",null,9,"3B D3"]
[null,"9 3B D4",null,9,"3B D4"]
[null,"9 JDS D1",null,9,"JDS D1"]
[null,"9 JDS D2",null,9,"JDS D2"]
[null,"9 JDS D3",null,9,"JDS D3"]
[null,"9 JDS D4",null,9,"JDS D4"]
[null,"9 Copie",null,9,"Copie"]
[null,"10 Sportif","Languedoc-Roussillon",10,"Sportif","VALETTE","Jean","","ST NAZAIRE DE PEZAN","04.67.71.47.78","","04.67.83.23.20","tamvothi@cegetel.net"]
[null,"10 3B D1",null,10,"3B D1"]
[null,"10 3B D2",null,10,"3B D2"]
[null,"10 3B D3",null,10,"3B D3"]
[null,"10 3B D4",null,10,"3B D4"]
[null,"10 JDS D1",null,10,"JDS D1"]
[null,"10 JDS D2",null,10,"JDS D2"]
[null,"10 JDS D3",null,10,"JDS D3"]
[null,"10 JDS D4",null,10,"JDS D4"]
[null,"10 Copie",null,10,"Copie"]
[null,"11 Sportif","Lorraine",11,"Sportif","COLSON","Hervé","","ST MIHIEL","03.29.90.29.13","06.73.34.43.96","","her.colson@free.fr"]
[null,"11 3B D1",null,11,"3B D1"]
[null,"11 3B D2",null,11,"3B D2"]
[null,"11 3B D3",null,11,"3B D3"]
[null,"11 3B D4",null,11,"3B D4"]
[null,"11 JDS D1",null,11,"JDS D1"]
[null,"11 JDS D2",null,11,"JDS D2"]
[null,"11 JDS D3",null,11,"JDS D3"]
[null,"11 JDS D4",null,11,"JDS D4"]
[null,"11 Copie",null,11,"Copie"]
[null,"12 Sportif","Rhône-Alpes",12,"Sportif","LAVAUD","Jean-Michel","","CALUIRE","04.78.23.38.89",null,null,"jmlavaud@free.fr"]
[null,"12 3B D1",null,12,"3B D1"]
[null,"12 3B D2",null,12,"3B D2"]
[null,"12 3B D3",null,12,"3B D3"]
[null,"12 3B D4",null,12,"3B D4"]
[null,"12 JDS D1",null,12,"JDS D1"]
[null,"12 JDS D2",null,12,"JDS D2"]
[null,"12 JDS D3",null,12,"JDS D3"]
[null,"12 JDS D4",null,12,"JDS D4"]
[null,"12 Copie",null,12,"Copie"]
[null,"13 Sportif","Nord-Pas de Calais",13,"Sportif","HENTZ","François","Billard Club - 3 Avenue Fosse 2","62420 BILLY-MONTIGNY","03.21.20.17.85","06.81.27.27.46","03.21.49.21.44","fh62420bm@wanadoo.fr"]
[null,"13 3B D1",null,13,"3B D1"]
[null,"13 3B D2",null,13,"3B D2"]
[null,"13 3B D3",null,13,"3B D3","DELATTRE","Christian","2 Allée des Tulipes","62470 CALONNE RICOUART","03.21.52.45.08 ","06.65.12.13.66 ",null,"christiandelattre@orange.fr"]
[null,"13 3B D4",null,13,"3B D4","DELATTRE","Christian","2 Allée des Tulipes","62470 CALONNE RICOUART","03.21.52.45.08 ","06.65.12.13.66 ",null,"christiandelattre@orange.fr"]
[null,"13 JDS D1",null,13,"JDS D1","POULEYN","André"," 56 rue du baron Coppens","59122 HONDSCHOOTE","03.28.62.57.95",null,"03 28 62 57 95","andrepouleyn@wanadoo.fr"]
[null,"13 JDS D2",null,13,"JDS D2","POULEYN","André"," 56 rue du baron Coppens","59122 HONDSCHOOTE","03.28.62.57.95",null,"03 28 62 57 95","andrepouleyn@wanadoo.fr"]
[null,"13 JDS D3",null,13,"JDS D3","POULEYN","André"," 56 rue du baron Coppens","59122 HONDSCHOOTE","03.28.62.57.95",null,"03 28 62 57 95","andrepouleyn@wanadoo.fr"]
[null,"13 JDS D4",null,13,"JDS D4","POULEYN","André"," 56 rue du baron Coppens","59122 HONDSCHOOTE","03.28.62.57.95",null,"03 28 62 57 95","andrepouleyn@wanadoo.fr"]
[null,"13 Copie",null,13,"Copie","CLAIRET","J-François",null,null,null,null,null,"clairetjf@gmail.com"]
[null,"14 Sportif","Normandie",14,"Sportif","PETIT","Johann","","OISSEL","02.35.64.73.58","06.11.17.50.45","","johann-petit@wanadoo.fr"]
[null,"14 3B D1",null,14,"3B D1"]
[null,"14 3B D2",null,14,"3B D2"]
[null,"14 3B D3",null,14,"3B D3"]
[null,"14 3B D4",null,14,"3B D4"]
[null,"14 JDS D1",null,14,"JDS D1"]
[null,"14 JDS D2",null,14,"JDS D2"]
[null,"14 JDS D3",null,14,"JDS D3"]
[null,"14 JDS D4",null,14,"JDS D4"]
[null,"14 Copie",null,14,"Copie"]
[null,"15 Sportif","Centre",15,"Sportif","PEYRAMAURE","Dominique","","FLEURY LES AUBRAIS","02.38.84.36.32","06.67.03.57.00","02.38.84.36.32","csportiveligueducentre@wanadoo.fr"]
[null,"15 3B D1",null,15,"3B D1"]
[null,"15 3B D2",null,15,"3B D2"]
[null,"15 3B D3",null,15,"3B D3"]
[null,"15 3B D4",null,15,"3B D4"]
[null,"15 JDS D1",null,15,"JDS D1"]
[null,"15 JDS D2",null,15,"JDS D2"]
[null,"15 JDS D3",null,15,"JDS D3"]
[null,"15 JDS D4",null,15,"JDS D4"]
[null,"15 Copie",null,15,"Copie"]
[null,"16 Sportif","Pays de la Loire",16,"Sportif","PRIOU","Denis","","CHOLET","","06.87.11.14.21","02.41.56.19.36","denis.priou@wanadoo.fr"]
[null,"16 3B D1",null,16,"3B D1"]
[null,"16 3B D2",null,16,"3B D2"]
[null,"16 3B D3",null,16,"3B D3"]
[null,"16 3B D4",null,16,"3B D4"]
[null,"16 JDS D1",null,16,"JDS D1"]
[null,"16 JDS D2",null,16,"JDS D2"]
[null,"16 JDS D3",null,16,"JDS D3"]
[null,"16 JDS D4",null,16,"JDS D4"]
[null,"16 Copie",null,16,"Copie"]
[null,"17 Sportif","Picardie",17,"Sportif","LE MEE","Laurent","","PONT SAINTE MAXENCE","03.44.31.92.35","06.63.39.74.00","","lolorsr@wanadoo.fr"]
[null,"17 3B D1",null,17,"3B D1"]
[null,"17 3B D2",null,17,"3B D2"]
[null,"17 3B D3",null,17,"3B D3"]
[null,"17 3B D4",null,17,"3B D4"]
[null,"17 JDS D1",null,17,"JDS D1"]
[null,"17 JDS D2",null,17,"JDS D2"]
[null,"17 JDS D3",null,17,"JDS D3"]
[null,"17 JDS D4",null,17,"JDS D4"]
[null,"17 Copie",null,17,"Copie"]
[null,"18 Sportif","Poitou-Charentes",18,"Sportif","MAUDET","Michel","","MARSILLY","05.46.01.58.91","06.19.36.44.93","","michelmaudet@aol.com"]
[null,"18 3B D1",null,18,"3B D1"]
[null,"18 3B D2",null,18,"3B D2"]
[null,"18 3B D3",null,18,"3B D3"]
[null,"18 3B D4",null,18,"3B D4"]
[null,"18 JDS D1",null,18,"JDS D1"]
[null,"18 JDS D2",null,18,"JDS D2"]
[null,"18 JDS D3",null,18,"JDS D3"]
[null,"18 JDS D4",null,18,"JDS D4"]
[null,"18 Copie",null,18,"Copie"]
[null,"19 Sportif","Méditerranée",19,"Sportif","AYOT","Alexandre","","ISTRES","08.74.52.14.09","06.80.31.26.51","04.42.11.81.63","ayotalex@free.fr"]
[null,"19 3B D1",null,19,"3B D1"]
[null,"19 3B D2",null,19,"3B D2"]
[null,"19 3B D3",null,19,"3B D3"]
[null,"19 3B D4",null,19,"3B D4"]
[null,"19 JDS D1",null,19,"JDS D1"]
[null,"19 JDS D2",null,19,"JDS D2"]
[null,"19 JDS D3",null,19,"JDS D3"]
[null,"19 JDS D4",null,19,"JDS D4"]
[null,"19 Copie",null,19,"Copie"]
[null,"20 Sportif","Midi-Pyrénées",20,"Sportif","GIRON","Juan","","TOULOUSE","05.61.71.11.81","","05.61.71.11.81","juan.giron1@free.fr"]
[null,"20 3B D1",null,20,"3B D1"]
[null,"20 3B D2",null,20,"3B D2"]
[null,"20 3B D3",null,20,"3B D3"]
[null,"20 3B D4",null,20,"3B D4"]
[null,"20 JDS D1",null,20,"JDS D1"]
[null,"20 JDS D2",null,20,"JDS D2"]
[null,"20 JDS D3",null,20,"JDS D3"]
[null,"20 JDS D4",null,20,"JDS D4"]
[null,"20 Copie",null,20,"Copie"]
[null,"21 Sportif","Limousin",21,"Sportif","MAZEL","Raymond","","AURILLAC","04.71.48.31.90","","04.71.64.12.50","aurillacbillardclub@free.fr"]
[null,"21 3B D1",null,21,"3B D1"]
[null,"21 3B D2",null,21,"3B D2"]
[null,"21 3B D3",null,21,"3B D3"]
[null,"21 3B D4",null,21,"3B D4"]
[null,"21 JDS D1",null,21,"JDS D1"]
[null,"21 JDS D2",null,21,"JDS D2"]
[null,"21 JDS D3",null,21,"JDS D3"]
[null,"21 JDS D4",null,21,"JDS D4"]
[null,"21 Copie",null,21,"Copie"]
[null,"22 Sportif","Bourgogne",22,"Sportif","DORLET","Jean","","ROUSSILLON EN MORVAN","03.85.82.79.83","","","jean.dorlet@tiscali.fr"]
[null,"22 3B D1",null,22,"3B D1"]
[null,"22 3B D2",null,22,"3B D2"]
[null,"22 3B D3",null,22,"3B D3"]
[null,"22 3B D4",null,22,"3B D4"]
[null,"22 JDS D1",null,22,"JDS D1"]
[null,"22 JDS D2",null,22,"JDS D2"]
[null,"22 JDS D3",null,22,"JDS D3"]
[null,"22 JDS D4",null,22,"JDS D4"]
[null,"22 Copie",null,22,"Copie"]
[null,"23 Sportif","Réunion",23,"Sportif","PINEAU","Roger","","PETITE ILE","02.62.56.83.89","06.92.64.96.76","02.62.56.70.57","anne-marie.pineau@wanadoo.fr"]
[null,"23 3B D1",null,23,"3B D1"]
[null,"23 3B D2",null,23,"3B D2"]
[null,"23 3B D3",null,23,"3B D3"]
[null,"23 3B D4",null,23,"3B D4"]
[null,"23 JDS D1",null,23,"JDS D1"]
[null,"23 JDS D2",null,23,"JDS D2"]
[null,"23 JDS D3",null,23,"JDS D3"]
[null,"23 JDS D4",null,23,"JDS D4"]
[null,"23 Copie",null,23,"Copie"]
[null,"24 Sportif","Guadeloupe",24,"Sportif","BEAUPIN","Jean-Claude","","ST FRANCOIS","","06.90.35.63.76","","jemb@wanadoo.fr"]
[null,"24 3B D1",null,24,"3B D1"]
[null,"24 3B D2",null,24,"3B D2"]
[null,"24 3B D3",null,24,"3B D3"]
[null,"24 3B D4",null,24,"3B D4"]
[null,"24 JDS D1",null,24,"JDS D1"]
[null,"24 JDS D2",null,24,"JDS D2"]
[null,"24 JDS D3",null,24,"JDS D3"]
[null,"24 JDS D4",null,24,"JDS D4"]
[null,"24 Copie",null,24,"Copie"]