{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Mode d'emploi","Accueil","FdM-3Joueurs","FdM-4Joueurs","FdM-5Joueurs","FdM-6Joueurs","FdM-7Joueurs","FdM-8Joueurs"],"not_rendered":{"charts":0,"images":26,"macros":1,"external_links":0,"defined_names":47,"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":"Mode d'emploi","index":0,"n_rows":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
[null,"1) Sur le site de la Fédération, selectionner les matchs d'une compétition avec la souris et les copier (ctrl et C ou avec le click droit de la souris)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2) Les coller dans la feuille \"Accueil\". (astuce : sélectionner la cellule en dessous de \"Numero\" et coller)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3) Renseigner les zones suivantes :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Sur la feuille \"Accueil\""]
[]
[null,null,"Nbr de joueurs :",null,"permet la sélection de la feuille correspondante (obligatoire)"]
[null,null,"Nbr de points : ",null,"distance affichée dans la feuille de match"]
[null,null,"Nbr de reprises :",null,"nombre de reprise affiché dans la feuille de match"]
[null,null,"Titre ligne 1 :",null,"texte affiché dans la ligne du haut sur les feuilles de matchs"]
[null,null,"Titre ligne 2 :",null,"texte affiché dans la ligne du bas sur les feuilles de matchs"]
[]
[null,null,"Décimales à 3 chiffres : ",null,"si l'option est cochée, les moyennes s'afficheront avec 3 décimales, 2 si pas cochée"]
[]
[null,null,"Bouton \"Editer la feuille\" :",null,"rempli la feuille correspondante avec les matchs copiés et affichés"]
[null,null,"Bouton \"Nouveau\" :",null,"efface toutes les feuilles de match  et zones de la feuille \"Accueil\""]
[]
[null,null,null,null,"Sur les feuilles de match "]
[]
[null,null,"Bouton \"Exporter en pdf\" :",null,"propose à l'utilisateur d'exporter la feuille de match au format pdf (fichier)"]
[null,null,null,null,"pour par exemple l'expédier par mail"]
[null,null,null,null,"Le nom du fichier qui est proposé est celui des deux lignes de titres combinées"]
[null,null,null,null,"Il est modifiable"]
[null,null,"Bouton \"Imprimer\" :",null,"réaliser une impression de la feuille de match"]
[]
[null,"Un contrôle est réalisé afin de vérifier la cohérence entre le nombre de joueurs indiqués et le nombre de joueurs différents présents dans les matchs"]

{"sheet":"Accueil","index":1,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,5,1,7]]}
[]
["Nbr de joueurs :",null,null,"Nombre de Points :",null,"Nombre de Reprises :",null,null,"mettre \"illim\" si pas\nde limitation"]
["Titre ligne 1 :",null,null,null,null,"Titre ligne 2 :"]
[]
[]
["Numéro","Date","Billard","Joueur 1","Pts J1","Rep J1","Ser J1","Moy J1","Joueur 2","Pts J2","Rep J2","Ser J2","Moy J2"]

{"sheet":"FdM-3Joueurs","index":2,"n_rows":21,"n_cols":28,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,4,8],[5,1,7,8],[9,1,9,2],[9,3,9,4],[9,5,9,6],[12,0,13,0],[12,3,13,4],[12,7,13,7],[12,9,13,9],[12,11,13,11],[10,0,11,0],[10,1,11,2],[10,7,11,7],[10,9,11,9],[10,11,11,11],[14,0,15,0],[14,5,15,6],[14,7,15,7],[14,9,15,9],[14,11,15,11],[20,0,20,2],[20,3,20,4],[20,10,20,11],[20,5,20,9],[19,1,19,2],[19,3,19,4],[19,7,19,8],[19,9,19,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f","Pts classement","Moy. Génér.","Meill. Série"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J3",4,3.5660377358490565,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J1",2,1.4333333333333333,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J2",0,1.0566037735849056,6]
[]
[]
[]
[]
[]
["JOUEURS",null,null,null,null,null,null,"Pts \nde \nClas.","Pts\n\nM.G","Meill. Moy. Part.","Repri\n\nM.Se","Class\nG."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pts","R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Moy","S"]
[]
[]
[]
[]
[]
[]
[]
[]
["Distance :",null,null,null,null,"Nbr de reprises :"]

{"sheet":"FdM-4Joueurs","index":3,"n_rows":23,"n_cols":30,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,1,4,10],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[5,1,7,10],[12,11,13,11],[12,13,13,13],[10,0,11,0],[10,1,11,2],[10,9,11,9],[10,11,11,11],[10,13,11,13],[12,0,13,0],[12,3,13,4],[12,9,13,9],[16,11,17,11],[16,13,17,13],[14,0,15,0],[14,5,15,6],[14,9,15,9],[14,11,15,11],[14,13,15,13],[16,0,17,0],[16,7,17,8],[16,9,17,9],[22,5,22,8],[22,9,22,10],[21,11,21,12],[21,1,21,2],[21,3,21,4],[21,6,21,7],[21,9,21,10],[22,0,22,2],[22,3,22,4]]}
[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,"Joueur","Pts classement","Moy. Génér.","Meill. Série"]
[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,"J3",6,1.0888888888888888,8]
[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,"J1",2,1.2531645569620253,9]
[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,"J4",2,0.9642857142857143,6]
[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,"J2",2,0.76470588235294112,5]
[]
[]
[]
[]
["JOUEURS",null,null,null,null,null,null,null,null,"Pts \nde \nClas.","Pts\n\nM.G","Meill. Moy. Part.","Repri\n\nM.Se","Class\nG."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pts","R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moy","S"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Distance :",null,null,null,null,"Nbr de reprises :"]

{"sheet":"FdM-5Joueurs","index":4,"n_rows":23,"n_cols":30,"rows_kept":23,"cut":false,"hidden":false,"merged":[[18,0,19,0],[22,1,22,3],[2,1,4,12],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[12,11,13,11],[14,11,15,11],[5,1,7,12],[22,6,22,9],[22,10,22,11],[22,4,22,5],[20,1,20,2],[20,3,20,4],[12,15,13,15],[12,3,13,4],[10,0,11,0],[10,1,11,2],[10,11,11,11],[10,13,11,13],[10,15,11,15],[12,0,13,0],[12,13,13,13],[14,15,15,15],[16,0,17,0],[16,11,17,11],[16,13,17,13],[16,15,17,15],[14,5,15,6],[16,7,17,8],[14,0,15,0],[14,13,15,13],[18,15,19,15],[20,6,20,7],[20,8,20,9],[20,13,20,14],[20,11,20,12],[18,9,19,10],[18,13,19,13],[18,11,19,11]]}
[]
[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,"Joueur","Pts classement","Moy. Génér.","Meill. Série"]
[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,"J2",8,1.411764705882353,12]
[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,"J1",6,0.95575221238938057,10]
[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,"J3",4,0.89423076923076927,6]
[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,"J5",2,0.5663716814159292,3]
[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,"J4",0,0.40206185567010311,2]
[]
[]
["JOUEURS",null,null,null,null,null,null,null,null,null,null,"Pts \nde \nClas.","Pts\n\nM.G","Meilleure Moyenne Part.","Repri\n\nM.Se","Class\nG."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pts","R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moy","S"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Distance :",null,null,null,null,"Nbr de reprises :"]

{"sheet":"FdM-6Joueurs","index":5,"n_rows":25,"n_cols":32,"rows_kept":25,"cut":false,"hidden":false,"merged":[[20,0,21,0],[20,17,21,17],[24,1,24,3],[24,4,24,5],[24,6,24,9],[24,10,24,13],[20,11,21,12],[20,13,21,13],[20,15,21,15],[18,17,19,17],[14,0,15,0],[14,5,15,6],[14,13,15,13],[14,15,15,15],[14,17,15,17],[16,0,17,0],[16,7,17,8],[16,13,17,13],[16,15,17,15],[16,17,17,17],[18,0,19,0],[18,9,19,10],[18,13,19,13],[18,15,19,15],[10,17,11,17],[12,0,13,0],[12,3,13,4],[12,13,13,13],[12,15,13,15],[12,17,13,17],[10,0,11,0],[10,1,11,2],[10,13,11,13],[10,15,11,15],[2,1,4,14],[5,1,7,14],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12]]}
[]
[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,"Joueur","Pts classement","Moy. Génér.","Meill. Série"]
[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,"J6",8,4.4432989690721651,26]
[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,"J3",6,3.9009900990099009,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,null,null,"J2",4,4.806451612903226,36]
[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,"J5",4,4.7127659574468082,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,null,null,null,null,"J4",4,3.98,21]
[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,"J1",4,3.0275229357798166,22]
[]
["JOUEURS",null,null,null,null,null,null,null,null,null,null,null,null,"Pts \nde \nClas.","Pts\n\nM.G","Meilleure Moyenne Part.","Repri\n\nM.Se","Class\nG."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pts","R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moy","S"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Distance :",null,null,null,null,"Nbr de reprises :"]

{"sheet":"FdM-7Joueurs","index":6,"n_rows":29,"n_cols":32,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,1,4,16],[5,1,7,16],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[9,13,9,14],[12,0,13,0],[12,3,13,4],[12,15,13,15],[12,17,13,17],[12,19,13,19],[10,0,11,0],[10,1,11,2],[10,15,11,15],[10,17,11,17],[10,19,11,19],[14,5,15,6],[14,15,15,15],[14,17,15,17],[14,19,15,19],[16,0,17,0],[16,7,17,8],[16,15,17,15],[16,17,17,17],[16,19,17,19],[14,0,15,0],[22,17,23,17],[22,19,23,19],[22,0,23,0],[18,0,19,0],[18,9,19,10],[18,15,19,15],[18,17,19,17],[18,19,19,19],[20,0,21,0],[20,11,21,12],[20,15,21,15],[20,17,21,17],[20,19,21,19],[26,1,26,3],[26,4,26,5],[26,6,26,9],[22,15,23,15],[26,10,26,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["JOUEURS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pts \nde \nClas.","Pts\n\nM.G","Meilleure Moyenne Part.","Repri\n\nM.Se","Class\nG."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pts","R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moy","S",null,null,null,null,null,"Joueur","Pts classement","Moy. Génér.","Meill. Série"]
[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,"J2",8,0.53691275167785235,5]
[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,"J4",6,0.4358974358974359,5]
[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,"J1",4,0.48666666666666669,4]
[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,"J3",4,0.39374999999999999,4]
[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,"J7",3,0.34806629834254144,3]
[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,"J5",2,0.27127659574468083,3]
[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,"J6",1,0.21195652173913043,3]
[]
[]
[]
[]
[]
[]
[]
[null,"Distance :",null,null,null,null,"Nbr de reprises :"]
[]
["Il est normal que des matchs ne soient pas joués car tous les joueurs ne se rencontrent pas afin de limiter le temps de compétition."]

{"sheet":"FdM-8Joueurs","index":7,"n_rows":28,"n_cols":42,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,1,4,18],[5,1,7,18],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[10,17,11,17],[10,19,11,19],[10,21,11,21],[12,0,13,0],[12,3,13,4],[12,17,13,17],[12,19,13,19],[12,21,13,21],[14,21,15,21],[16,0,17,0],[16,7,17,8],[16,17,17,17],[16,19,17,19],[16,21,17,21],[14,17,15,17],[14,19,15,19],[18,21,19,21],[20,0,21,0],[20,11,21,12],[20,17,21,17],[20,19,21,19],[20,21,21,21],[18,17,19,17],[18,19,19,19],[22,21,23,21],[27,1,27,3],[27,4,27,5],[27,6,27,9],[24,17,25,17],[24,21,25,21],[24,19,25,19],[22,17,23,17],[22,19,23,19],[24,0,25,0],[27,10,27,11],[9,15,9,16],[9,13,9,14],[22,0,23,0],[18,0,19,0],[18,9,19,10],[14,0,15,0],[14,5,15,6],[10,0,11,0],[10,1,11,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["JOUEURS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pts \nde \nClas.","Pts\n\nM.G","Meill. Moy. Part.","Repri\n\nM.Se","Class\nG."]
[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,"Pts","R"]
[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,"Moy","S",null,null,null,null,null,null,null,null,null,"Joueur","Pts classement","Moy. Génér.","Meill. Série"]
[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,"J1"]
[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,"J5"]
[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,"J7"]
[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,"J4"]
[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,"J2"]
[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,"J8"]
[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,"J3"]
[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,"J6"]
[]
[]
[]
[]
[]
[]
[]
[null,"Distance :",null,null,null,null,"Nbr de reprises :"]