{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["LISEZ-MOI","A RENSEIGNER","POULE DE 3 ","RESULTATS  POULE DE  3","POULE DE 2","RESULTATS POULE DE 2","categories","BD_JOUEURS_CLUB_CATEGORIES","resultats pour ranking"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":19,"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":"LISEZ-MOI","index":0,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Ce classeur contient 4 feuilles"]
[]
["1 /  La feuille lisez_-moi vous indique comment utiliser ce classeur"]
[]
["2 / La feuille \" A RENSEIGNER\" vous demande de remplir les cases bleues uniquement mais complètement"]
[]
[null,"la date"]
[null,"le lieu"]
[null,"le nom du Directeur de jeu"]
[null,"le numéro de la poule que vous trouverez en consultant la convocation"]
[]
[null,"POULE DE 3"]
[null,"indiquez le nom des joueurs "]
[null,"ou"]
[null,"POULE DE 2"]
[null,"indiquez le nom des joueurs"]
[]
[null,"cette action remplie  la feuille de poule"]
[]
["3 : la feuille POULE DE 3 se remplit de la façon suivante"]
[]
[null,"remplir les cases bleutées"]
[null,"c' est tout."]
[null,"la feuille est protégée"]
[null,"les calculs se font automatiquement"]
[]
["4: la feuille RESULTATS POULE DE 3 est accessible par le bouton rouge"]
[]
["5 : la feuille POULE DE 2 se remplit de la façon suivante"]
[]
[null,"remplir les cases bleutées"]
[null,"c' est tout."]
[null,"la feuille est protégée"]
[null,"les calculs se font automatiquement"]
[]
["6: la feuille RESULTATS POULE DE 2 est accessible par le bouton rouge"]
[]
["7: En cas de forfait dans une poule de trois joueurs, utilisez la feuille de match de poule de deux joueurs"]
[]
[]
["NE PAS OUBLIER QUE DEUX JOUEURS DU MÊME CLUB SE RENCONTRENT AU PREMIER MATCH"]

{"sheet":"A RENSEIGNER","index":1,"n_rows":186,"n_cols":6,"rows_kept":186,"cut":false,"hidden":false,"merged":[[0,1,0,3],[2,1,2,3],[4,0,4,8],[10,3,10,9],[37,1,37,3],[34,1,34,3],[21,1,21,3],[24,1,24,3],[12,5,16,8],[19,1,19,3]]}
["VERSION 10/2021"]
[]
[]
[]
["CDBVM\n     SAISON  2021- 2022"]
[]
[]
[]
[]
[]
[null,"DATE DE LA COMPETITION   ","2022-03-13",{"$f":"IF(COUNTA(C11:C17)<7,\"RENSEIGNEZ TOUS LES CHAMPS ! MERCI\",\"\")","v":"RENSEIGNEZ TOUS LES CHAMPS ! MERCI"}]
[null,"LIEU   ","ABMA"]
[null,"DIRECTEUR DE JEU   ",null,null,null,"Ce fichier rempli doit être envoyé dès la fin de la compétition à la Commission Sportive à l'adresse de messagerie: csdistrict9394@outlook.fr"]
[null,"TOURNOI N°   ","FINALE"]
[null,"POULE N°   ",1]
[null,"MODE DE JEU    ","LIBRE",null,{"$f":"VLOOKUP(C16,ModeJeu_col,2,0)","v":1}]
[null,"CATEGORIE","N3"]
[]
[]
[null,"CE FICHIER NE SERT QU' A UNE SEULE POULE\n DE 3 JOUEURS OU DE 2 JOUEURS"]
[]
[null,"SI C' EST UNE POULE DE 3  JOUEURS, CLIQUEZ ICI"]
[]
[]
[null,"REMPLIR LES NOMS DES JOUEURS AVEC LA LISTE DEROULANTE"]
[]
[null,"NOM DES JOUEURS","CATEGORIE","CLUB"]
[null,"JARRETY Didier",{"$f":"IF(ISBLANK(B28),\"\",INDEX(tab_corresp_ID_cate,E28,$E$16))","v":"N3"},{"$f":"IF(ISBLANK(B28),\"\",VLOOKUP(B28,BD_JOUEURS_CATEGORIES,2,0))","v":"LIVRY"},{"$f":"VLOOKUP(B28,BD_JOUEURS_CATEGORIES,3,0)","v":40}]
[null,"SIMON Claude",{"$f":"IF(ISBLANK(B29),\"\",INDEX(tab_corresp_ID_cate,E29,$E$16))","v":"N3"},{"$f":"IF(ISBLANK(B29),\"\",VLOOKUP(B29,BD_JOUEURS_CATEGORIES,2,0))","v":"ABASM"},{"$f":"VLOOKUP(B29,BD_JOUEURS_CATEGORIES,3,0)","v":75}]
[null,"RIEGEL Serge",{"$f":"IF(ISBLANK(B30),\"\",INDEX(tab_corresp_ID_cate,E30,$E$16))","v":"N3"},{"$f":"IF(ISBLANK(B30),\"\",VLOOKUP(B30,BD_JOUEURS_CATEGORIES,2,0))","v":"ABASM"},{"$f":"VLOOKUP(B30,BD_JOUEURS_CATEGORIES,3,0)","v":72}]
[]
[null,{"$f":"IF(AND(B29<>B28,B28<>B30,B29<>B30,B28<>\"\",B29<>\"\",B30<>\"\"),\"\",\"Vous n' avez pas encore inscrit les trois joueurs ou vous avez inscrit deux mêmes joueurs\")","v":""}]
[null,{"$f":"IF(COUNTA(B28:B30)=0,\"\",IF(COUNTA(B28:B30)=3,\"\",IF(COUNTA(B28:B30)=1,\"manque 2 joueurs\",IF(COUNTA(B28:B30)=2,\"manque 1 joueur\"))))","v":""}]
[]
[null,"SI C' EST UNE POULE DE 2  JOUEURS, CLIQUEZ ICI"]
[]
[]
[null,"REMPLIR LES NOMS DES JOUEURS AVEC LA LISTE DEROULANTE"]
[]
[null,"NOM DES JOUEURS","CATEGORIE","CLUB"]
[null,null,{"$f":"IF(ISBLANK(B41),\"\",INDEX(tab_corresp_ID_cate,E41,$E$16))","v":""},{"$f":"IF(ISBLANK(B41),\"\",VLOOKUP(B41,BD_JOUEURS_CATEGORIES,2,0))","v":""},{"$f":"VLOOKUP(B41,BD_JOUEURS_CATEGORIES,3,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF(ISBLANK(B42),\"\",INDEX(tab_corresp_ID_cate,E42,$E$16))","v":""},{"$f":"IF(ISBLANK(B42),\"\",VLOOKUP(B42,BD_JOUEURS_CATEGORIES,2,0))","v":""},{"$f":"VLOOKUP(B42,BD_JOUEURS_CATEGORIES,3,0)","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"IF(AND(B41<>B42,B41<>\"\",B42<>\"\"),\"\",\"Vous n' avez pas encore inscrit les deux joueurs ou vous avez inscrit les deux mêmes\")","v":"Vous n' avez pas encore inscrit les deux joueurs ou vous avez inscrit les deux mêmes"}]
[null,{"$f":"IF(COUNTA(B41:B42)=0,\"\",IF(COUNTA(B41:B42)=2,\"\",IF(COUNTA(B41:B42)=1,\"manque 1 joueur\")))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[]
[]
[]
[]
[]
[null,"LIBRE",1]
[null,"BANDE",2]
[null,"3 BANDES",3]
[null,"CADRE",4]

{"sheet":"POULE DE 3 ","index":2,"n_rows":240,"n_cols":34,"rows_kept":240,"cut":false,"hidden":false,"merged":[[96,192,96,207],[96,128,96,143],[43,15,43,23],[39,2,39,9],[96,208,96,223],[96,48,96,63],[96,64,96,79],[96,80,96,95],[96,96,96,111],[96,176,96,191],[96,160,96,175],[96,112,96,127],[47,15,47,23],[96,144,96,159],[96,32,96,43],[39,20,42,20],[96,0,96,15],[40,2,40,9],[45,15,45,24],[96,16,96,31],[57,3,57,17],[1,2,1,9],[32,2,32,9],[4,5,5,9],[23,15,23,33],[23,2,23,9],[18,2,18,9],[31,27,41,27],[20,2,20,9],[31,26,41,26],[41,15,41,19],[32,15,32,17],[32,19,32,21]]}
[]
[null,null,"CDBVM\n     SAISON  2021- 2022"]
[]
[null,null,{"$f":"'A RENSEIGNER'!B11","v":"DATE DE LA COMPETITION   "},{"$f":"IF(ISBLANK('A RENSEIGNER'!C11),\"\",'A RENSEIGNER'!C11)","v":"2022-03-13"}]
[null,null,{"$f":"'A RENSEIGNER'!B12","v":"LIEU   "},{"$f":"IF(ISBLANK('A RENSEIGNER'!C12),\"\",'A RENSEIGNER'!C12)","v":"ABMA"},null,"FEUILLE DE MATCH\nPOULE DE 3 JOUEURS"]
[null,null,{"$f":"'A RENSEIGNER'!B13","v":"DIRECTEUR DE JEU   "},{"$f":"IF(ISBLANK('A RENSEIGNER'!C13),\"\",'A RENSEIGNER'!C13)","v":""}]
[null,null,{"$f":"'A RENSEIGNER'!B14","v":"TOURNOI N°   "},{"$f":"IF(ISBLANK('A RENSEIGNER'!C14),\"\",'A RENSEIGNER'!C14)","v":"FINALE"}]
[null,null,{"$f":"'A RENSEIGNER'!B15","v":"POULE N°   "},{"$f":"IF(ISBLANK('A RENSEIGNER'!C15),\"\",'A RENSEIGNER'!C15)","v":1}]
[null,null,{"$f":"'A RENSEIGNER'!B16","v":"MODE DE JEU    "},{"$f":"IF(ISBLANK('A RENSEIGNER'!C16),\"\",'A RENSEIGNER'!C16)","v":"LIBRE"}]
[]
[]
[null,null,"JOUEURS","CATEGORIE"]
[]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",'A RENSEIGNER'!B28)","v":"JARRETY Didier"},{"$f":"'A RENSEIGNER'!C28","v":"N3"},{"$f":"VLOOKUP(D14,$P$34:$Q$38,2,0)","v":200}]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",'A RENSEIGNER'!B29)","v":"SIMON Claude"},{"$f":"'A RENSEIGNER'!C29","v":"N3"},{"$f":"VLOOKUP(D15,$P$34:$Q$38,2,0)","v":200}]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",'A RENSEIGNER'!B30)","v":"RIEGEL Serge"},{"$f":"'A RENSEIGNER'!C30","v":"N3"},{"$f":"VLOOKUP(D16,$P$34:$Q$38,2,0)","v":200}]
[]
[]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!C16),\"\",IF('A RENSEIGNER'!C16=\"3 BANDES\",\"LA DISTANCE DE LA POULE EST DE\"&\" \"&IF(AND(D14=D15=D16),VLOOKUP(D14,P34:Q38,2,0),MAX(E14:E16))&\"  \"&\"POINTS EN 50 REPRISES\",\"LA DISTANCE DE LA POULE EST DE\"&\" \"&IF(AND(D14=D15=D16),VLOOKUP(D14,P34:Q38,2,0),MAX(E14:E16))&\"  \"&\"POINTS SANS LIMITATION DE REPRISES\"))","v":"LA DISTANCE DE LA POULE EST DE 200  POINTS SANS LIMITATION DE REPRISES"}]
[]
[null,null,"SAISIE DES MATCHS"]
[]
[]
[null,null,"MATCH 1",null,null,null,null,null,null,null,null,null,null,null,null,"RESULTATS"]
[]
[null,null,"NOM","CATEGORIE","POINTS","REPRISES","SERIE",null,"MOY PART","POINTS MATCH","GAIN CATEG","GAIN MATCH","moy part validée",null,null,"NOM","CATEGORIE","TOTAL POINTS","TOTAL REPRISES","MOYENNE GENERALE","MOYENNE PARTICULIERE","MEILLEURE SERIE","POINTS DE MATCHS","calcul du rang","RANG","POINTS CLASSEMENT","BONUS moyenne match 1","BONUS moyenne match 2","Bonus catégorie Match 1","Bonus catégorie Match 2","Bonus  gain match 1","Bonus  gain match 2","TOTAL POINTS BONUS","TOTAL GENERAL"]
[null,{"$f":"VLOOKUP(D27,CATE_COR,2,0)","v":5},null,{"$f":"'A RENSEIGNER'!C28","v":"N3"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",'A RENSEIGNER'!B28)","v":"JARRETY Didier"},{"$f":"'A RENSEIGNER'!C28","v":"N3"},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",E36+E44)","v":400},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",F36+F44)","v":60},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",R27/S27)","v":6.666666666666667},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",MAX(M36,M44))","v":8.3333333333333339},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",MAX(G36,G44))","v":32},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",J36+J44)","v":4},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",W27*1000000000+T27*1000000+U27*10000+V27)","v":4006750032},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",RANK(X27,$X$27:$X$29,0))","v":1},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",IF(Y27=1,8,IF(Y27=2,5,IF(Y27=3,3))))","v":8},{"$f":"IF(J36=0,0,IF(ISBLANK('A RENSEIGNER'!B28),\"\",IF(I36>VLOOKUP(D36,$T$34:$V$38,3,0),2,IF(I36<VLOOKUP(D36,$T$34:$V$38,2,0),0,1))))","v":0},{"$f":"IF(J44=0,0,IF(ISBLANK('A RENSEIGNER'!B28),\"\",IF(I44>VLOOKUP(D44,$T$34:$V$38,3,0),2,IF(I44<VLOOKUP(D44,$T$34:$V$38,2,0),0,1))))","v":1},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",K36)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",K44)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",L36)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",L44)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",SUM(AA27:AF27))","v":1},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",SUM(Z27,AG27))","v":9}]
[null,{"$f":"VLOOKUP(D28,CATE_COR,2,0)","v":5},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",'A RENSEIGNER'!B29)","v":"SIMON Claude"},{"$f":"IF(ISBLANK('A RENSEIGNER'!C29),\"\",'A RENSEIGNER'!C29)","v":"N3"},141,28,18,{"$f":"IF(G28<I28,1,0)","v":0},{"$f":"IF(OR(E28=\"\",F28=\"\"),\"\",E28/F28)","v":5.0357142857142856},{"$f":"IF(E28=\"\",\"\",IF(E28>E29,2,IF(E28=E29,1,IF(E28<E29,0))))","v":0},{"$f":"IF(B28<B29,1,0)","v":0},{"$f":"IF(K28=0,0,IF(J28=2,3,IF(J28=1,2,IF(J28=0,1))))","v":0},{"$f":"IF(J28=0,0,I28)","v":0},null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",'A RENSEIGNER'!B29)","v":"SIMON Claude"},{"$f":"'A RENSEIGNER'!C29","v":"N3"},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",E28+E37)","v":270},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",F28+F37)","v":64},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",R28/S28)","v":4.21875},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",MAX(M28,M37))","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",MAX(G28,G37))","v":21},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",J28+J37)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",W28*1000000000+T28*1000000+U28*10000+V28)","v":4218771},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",RANK(X28,$X$27:$X$29,0))","v":3},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",IF(Y28=1,8,IF(Y28=2,5,IF(Y28=3,3))))","v":3},{"$f":"IF(J28=0,0,IF(ISBLANK('A RENSEIGNER'!B29),\"\",IF(I28>VLOOKUP(D28,$T$34:$V$38,3,0),2,IF(I28<VLOOKUP(D28,$T$34:$V$38,2,0),0,1))))","v":0},{"$f":"IF(J37=0,0,IF(ISBLANK('A RENSEIGNER'!B29),\"\",IF(I37>VLOOKUP(D37,$T$34:$V$38,3,0),2,IF(I37<VLOOKUP(D37,$T$34:$V$38,2,0),0,1))))","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",K28)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",K37)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",L28)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",L37)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",SUM(AA28:AF28))","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",SUM(Z28,AG28))","v":3}]
[null,{"$f":"VLOOKUP(D29,CATE_COR,2,0)","v":5},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",'A RENSEIGNER'!B30)","v":"RIEGEL Serge"},{"$f":"IF(ISBLANK('A RENSEIGNER'!C30),\"\",'A RENSEIGNER'!C30)","v":"N3"},200,{"$f":"IF(ISBLANK(F28),\"\",F28)","v":28},30,{"$f":"IF(G29<I29,1,0)","v":0},{"$f":"IF(OR(E29=\"\",F29=\"\"),\"\",E29/F29)","v":7.1428571428571432},{"$f":"IF(E29=\"\",\"\",IF(E29>E28,2,IF(E29=E28,1,IF(E29<E28,0))))","v":2},{"$f":"IF(B29<B28,1,0)","v":0},{"$f":"IF(K29=0,0,IF(J29=2,3,IF(J29=1,2,IF(J29=0,1))))","v":0},{"$f":"IF(J29=0,0,I29)","v":7.1428571428571432},null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",'A RENSEIGNER'!B30)","v":"RIEGEL Serge"},{"$f":"'A RENSEIGNER'!C30","v":"N3"},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",E29+E46)","v":261},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",F29+F46)","v":52},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",R29/S29)","v":5.0192307692307692},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",MAX(M29,M46))","v":7.1428571428571432},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",MAX(G29,G46))","v":30},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",J29+J46)","v":2},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",W29*1000000000+T29*1000000+U29*10000+V29)","v":2005090689.3406594},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",RANK(X29,$X$27:$X$29,0))","v":2},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",IF(Y29=1,8,IF(Y29=2,5,IF(Y29=3,3))))","v":5},{"$f":"IF(J29=0,0,IF(ISBLANK('A RENSEIGNER'!B30),\"\",IF(I29>VLOOKUP(D29,$T$34:$V$38,3,0),2,IF(I29<VLOOKUP(D29,$T$34:$V$38,2,0),0,1))))","v":1},{"$f":"IF(J46=0,0,IF(ISBLANK('A RENSEIGNER'!B30),\"\",IF(I46>VLOOKUP(D46,$T$34:$V$38,3,0),2,IF(I46<VLOOKUP(D46,$T$34:$V$38,2,0),0,1))))","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",K46)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",K46)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",L29)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",L46)","v":0},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",SUM(AA29:AF29))","v":1},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",SUM(Z29,AG29))","v":6}]
[]
[]
[]
[null,null,"MATCH  2",null,null,null,null,null,null,null,null,null,null,null,null,"TABLEAU DES DISTANCES",null,null,null,"MOYENNE DES CATEGORIES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R4",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!P34,tabdistance,4,0)","v":50},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!P34,tabdistance,5,0)","v":"PC"},null,"R4",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!T34,tablemoy,4,0)","v":0},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!T34,tablemoy,5,0)","v":1.1999998999999999}]
[null,null,"NOM","CATEGORIE","POINTS","REPRISES","SERIE",null,"MOY PART","POINTS MATCH","GAIN CATEG","GAIN MATCH","moy part validée",null,null,"R3",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!P35,tabdistance,4,0)","v":70},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!P35,tabdistance,5,0)","v":"PC"},null,"R3",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!T35,tablemoy,4,0)","v":1.2},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!T35,tablemoy,5,0)","v":2.2999990000000001}]
[null,{"$f":"VLOOKUP(D36,CATE_COR,2,0)","v":5},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",'A RENSEIGNER'!B28)","v":"JARRETY Didier"},{"$f":"IF(ISBLANK('A RENSEIGNER'!C28),\"\",'A RENSEIGNER'!C28)","v":"N3"},200,36,25,{"$f":"IF(G36<I36,1,0)","v":0},{"$f":"IF(OR(E36=\"\",F36=\"\"),\"\",E36/F36)","v":5.5555555555555554},{"$f":"IF(E36=\"\",\"\",IF(E36>E37,2,IF(E36=E37,1,IF(E36<E37,0))))","v":2},{"$f":"IF(B36<B37,1,0)","v":0},{"$f":"IF(K36=0,0,IF(J36=2,3,IF(J36=1,2,IF(J36=0,1))))","v":0},{"$f":"IF(J36=0,0,I36)","v":5.5555555555555554},null,null,"R2",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!P36,tabdistance,4,0)","v":100},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!P36,tabdistance,5,0)","v":"PC"},null,"R2",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!T36,tablemoy,4,0)","v":2.2999999999999998},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!T36,tablemoy,5,0)","v":3.9999999000000002}]
[null,{"$f":"VLOOKUP(D37,CATE_COR,2,0)","v":5},{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",'A RENSEIGNER'!B29)","v":"SIMON Claude"},{"$f":"IF(ISBLANK('A RENSEIGNER'!C29),\"\",'A RENSEIGNER'!C29)","v":"N3"},129,{"$f":"IF(ISBLANK(F36),\"\",F36)","v":36},21,{"$f":"IF(G37<I37,1,0)","v":0},{"$f":"IF(OR(E37=\"\",F37=\"\"),\"\",E37/F37)","v":3.5833333333333335},{"$f":"IF(E37=\"\",\"\",IF(E37>E36,2,IF(E37=E36,1,IF(E37<E36,0))))","v":0},{"$f":"IF(B37<B36,1,0)","v":0},{"$f":"IF(K37=0,0,IF(J37=2,3,IF(J37=1,2,IF(J37=0,1))))","v":0},{"$f":"IF(J37=0,0,I37)","v":0},null,null,"R1",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!P37,tabdistance,4,0)","v":150},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!P37,tabdistance,5,0)","v":"PC"},null,"R1",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!T37,tablemoy,4,0)","v":4},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!T37,tablemoy,5,0)","v":5.9999998999999997}]
[null,{"$f":"VLOOKUP(D38,CATE_COR,2,0)","v":5},null,{"$f":"'A RENSEIGNER'!C30","v":"N3"},null,null,null,null,null,null,null,null,null,null,null,"N3",200,{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!P38,tabdistance,5,0)","v":"GC"},null,"N3",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!T38,tablemoy,4,0)","v":6},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&'POULE DE 3 '!T38,tablemoy,5,0)","v":12.499999900000001}]
[]
[]
[null,null,"MATCH   3"]
[]
[null,null,"NOM","CATEGORIE","POINTS","REPRISES","SERIE",null,"MOY PART","POINTS MATCH","GAIN CATEG","GAIN MATCH","moy part validée"]
[null,{"$f":"VLOOKUP(D44,CATE_COR,2,0)","v":5},{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",'A RENSEIGNER'!B28)","v":"JARRETY Didier"},{"$f":"IF(ISBLANK('A RENSEIGNER'!C28),\"\",'A RENSEIGNER'!C28)","v":"N3"},200,24,32,{"$f":"IF(G44<I44,1,0)","v":0},{"$f":"IF(OR(E44=\"\",F44=\"\"),\"\",E44/F44)","v":8.3333333333333339},{"$f":"IF(E44=\"\",\"\",IF(E44>E46,2,IF(E44=E46,1,IF(E44<E46,0))))","v":2},{"$f":"IF(B44<B46,1,0)","v":0},{"$f":"IF(K44=0,0,IF(J44=2,3,IF(J44=1,2,IF(J44=0,1))))","v":0},{"$f":"IF(J44=0,0,I44)","v":8.3333333333333339}]
[null,{"$f":"VLOOKUP(D45,CATE_COR,2,0)","v":5},null,{"$f":"'A RENSEIGNER'!C29","v":"N3"}]
[null,{"$f":"VLOOKUP(D46,CATE_COR,2,0)","v":5},{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",'A RENSEIGNER'!B30)","v":"RIEGEL Serge"},{"$f":"IF(ISBLANK('A RENSEIGNER'!C30),\"\",'A RENSEIGNER'!C30)","v":"N3"},61,{"$f":"IF(ISBLANK(F44),\"\",F44)","v":24},14,{"$f":"IF(G46<I46,1,0)","v":0},{"$f":"IF(OR(E46=\"\",F46=\"\"),\"\",E46/F46)","v":2.5416666666666665},{"$f":"IF(E46=\"\",\"\",IF(E46>E44,2,IF(E46=E44,1,IF(E46<E44,0))))","v":0},{"$f":"IF(B46<B44,1,0)","v":0},{"$f":"IF(K46=0,0,IF(J46=2,3,IF(J46=1,2,IF(J46=0,1))))","v":0},{"$f":"IF(J46=0,0,I46)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",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,"R1",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,"R2",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,"R3",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,"R4",1]

{"sheet":"RESULTATS  POULE DE  3","index":3,"n_rows":28,"n_cols":21,"rows_kept":28,"cut":false,"hidden":false,"merged":[[16,13,16,14],[17,19,19,19],[18,12,18,13],[18,14,18,15],[17,20,19,20],[17,16,19,16],[17,13,17,14],[19,12,19,13],[19,14,19,15],[20,9,20,11],[2,2,2,20],[4,2,4,20],[6,2,6,20],[8,2,8,20],[10,2,10,20],[20,3,20,5],[20,6,20,8],[20,13,20,14],[12,2,12,20],[16,6,16,8],[17,18,19,18],[17,17,19,17],[16,3,16,5],[14,2,14,20],[16,9,16,11],[21,16,23,16],[21,18,23,18],[23,12,23,13],[24,3,24,5],[24,6,24,8],[22,12,22,13],[24,9,24,11],[25,20,27,20],[25,19,27,19],[25,18,27,18],[21,17,23,17],[21,13,21,14],[25,16,27,16],[26,12,26,13],[26,14,26,15],[27,12,27,13],[21,20,23,20],[23,14,23,15],[27,14,27,15],[24,13,24,14],[25,17,27,17],[21,19,23,19],[25,13,25,14]]}
[]
[]
[null,null,{"$f":"'A RENSEIGNER'!$C$11","v":"2022-03-13"}]
[]
[null,null,{"$f":"'A RENSEIGNER'!$C$12","v":"ABMA"}]
[]
[null,null,{"$f":"\"MODE DE JEU\"&\"  \"&'A RENSEIGNER'!$C$16","v":"MODE DE JEU  LIBRE"}]
[]
[null,null,{"$f":"\"CATEGORIE\"&\"  \"&'A RENSEIGNER'!$C$17","v":"CATEGORIE  N3"}]
[]
[null,null,{"$f":"\"TOURNOI N°\"&\"  \"&'A RENSEIGNER'!$C$14","v":"TOURNOI N°  FINALE"}]
[]
[null,null,{"$f":"\"POULE n°\"&\"  \"&'A RENSEIGNER'!$C$15","v":"POULE n°  1"}]
[]
[null,null,"RESULTATS DE LA POULE"]
[]
[null,null,"JOUEUR\ncategorie\nclub",{"$f":"C18","v":"JARRETY Didier"},null,null,{"$f":"C22","v":"SIMON Claude"},null,null,{"$f":"C26","v":"RIEGEL Serge"},null,null,"PTS","REP",null,"MG","PTS DE\n MATCHS","RANG","POINTS DE \nCLASSEMENT","POINTS DE\n BONUS","TOTAL \nPOINTS"]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B28),\"\",'A RENSEIGNER'!B28)","v":"JARRETY Didier"},null,null,null,{"$f":"IF(ISBLANK('POULE DE 3 '!E36),\"\",'POULE DE 3 '!E36)","v":200},null,{"$f":"IF(ISBLANK('POULE DE 3 '!F36),\"\",'POULE DE 3 '!F36)","v":36},{"$f":"IF(ISBLANK('POULE DE 3 '!E44),\"\",'POULE DE 3 '!E44)","v":200},null,{"$f":"IF(ISBLANK('POULE DE 3 '!F44),\"\",'POULE DE 3 '!F44)","v":24},{"$f":"IF('POULE DE 3 '!R27=0,\"\",'POULE DE 3 '!R27)","v":400},{"$f":"IF('POULE DE 3 '!S27=0,\"\",'POULE DE 3 '!S27)","v":60},null,{"$f":"IF(ISERROR('POULE DE 3 '!T27),\"\",'POULE DE 3 '!T27)","v":6.666666666666667},{"$f":"IF(ISERROR('POULE DE 3 '!W27),\"\",'POULE DE 3 '!W27)","v":4},{"$f":"IF(ISERROR('POULE DE 3 '!Y27),\"\",IF(ISBLANK('A RENSEIGNER'!B28),\"\",IF('POULE DE 3 '!Y27=1,'POULE DE 3 '!Y27&\"er\",'POULE DE 3 '!Y27&\"ème\")))","v":"1er"},{"$f":"IF(ISERROR('POULE DE 3 '!Z27),\"\",'POULE DE 3 '!Z27)","v":8},{"$f":"IF(ISBLANK(C18),\"\",'POULE DE 3 '!AG27)","v":1},{"$f":"IF(ISERROR('POULE DE 3 '!AH27),\"\",'POULE DE 3 '!AH27)","v":9}]
[null,null,{"$f":"'A RENSEIGNER'!C28","v":"N3"},null,null,null,null,{"$f":"'POULE DE 3 '!J36","v":2},null,null,{"$f":"'POULE DE 3 '!J44","v":2},null,"MP",null,"SERIE"]
[null,null,{"$f":"'A RENSEIGNER'!D28","v":"LIVRY"},null,null,null,{"$f":"+'POULE DE 3 '!I36","v":5.5555555555555554},null,{"$f":"IF(ISBLANK('POULE DE 3 '!G36),\"\",'POULE DE 3 '!G36)","v":25},{"$f":"+'POULE DE 3 '!I44","v":8.3333333333333339},null,{"$f":"IF(ISBLANK('POULE DE 3 '!G44),\"\",'POULE DE 3 '!G44)","v":32},{"$f":"IF('POULE DE 3 '!U27=0,\"\",'POULE DE 3 '!U27)","v":8.3333333333333339},null,{"$f":"IF('POULE DE 3 '!V27=0,\"\",'POULE DE 3 '!V27)","v":32}]
[null,null,"JOUEUR\ncategorie\nclub",{"$f":"D17","v":"JARRETY Didier"},null,null,{"$f":"G17","v":"SIMON Claude"},null,null,{"$f":"J17","v":"RIEGEL Serge"},null,null,"PTS","REP",null,"MG","PTS DE\n MATCHS","RANG","POINTS DE \nCLASSEMENTS","POINTS DE\n BONUS","TOTAL \nPOINTS"]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B29),\"\",'A RENSEIGNER'!B29)","v":"SIMON Claude"},{"$f":"IF(ISBLANK('POULE DE 3 '!E37),\"\",'POULE DE 3 '!E37)","v":129},null,{"$f":"IF(ISBLANK('POULE DE 3 '!F37),\"\",'POULE DE 3 '!F37)","v":36},null,null,null,{"$f":"IF(ISBLANK('POULE DE 3 '!E28),\"\",'POULE DE 3 '!E28)","v":141},null,{"$f":"IF(ISBLANK('POULE DE 3 '!F28),\"\",'POULE DE 3 '!F28)","v":28},{"$f":"IF('POULE DE 3 '!R28=0,\"\",'POULE DE 3 '!R28)","v":270},{"$f":"IF(ISERROR('POULE DE 3 '!S28),\"\",'POULE DE 3 '!S28)","v":64},null,{"$f":"IF(ISERROR('POULE DE 3 '!T28),\"\",'POULE DE 3 '!T28)","v":4.21875},{"$f":"IF(ISERROR('POULE DE 3 '!W28),\"\",'POULE DE 3 '!W28)","v":0},{"$f":"IF(ISERROR('POULE DE 3 '!Y28),\"\",IF(ISBLANK('A RENSEIGNER'!B29),\"\",IF('POULE DE 3 '!Y28=1,'POULE DE 3 '!Y28&\"er\",'POULE DE 3 '!Y28&\"ème\")))","v":"3ème"},{"$f":"IF(ISERROR('POULE DE 3 '!Z28),\"\",'POULE DE 3 '!Z28)","v":3},{"$f":"+'POULE DE 3 '!AG28","v":0},{"$f":"IF(ISERROR('POULE DE 3 '!AH28),\"\",'POULE DE 3 '!AH28)","v":3}]
[null,null,{"$f":"'A RENSEIGNER'!C29","v":"N3"},null,{"$f":"'POULE DE 3 '!J37","v":0},null,null,null,null,null,{"$f":"'POULE DE 3 '!J28","v":0},null,"MP",null,null,"SERIE"]
[null,null,{"$f":"'A RENSEIGNER'!D29","v":"ABASM"},{"$f":"+'POULE DE 3 '!I37","v":3.5833333333333335},null,{"$f":"IF(ISBLANK('POULE DE 3 '!G37),\"\",'POULE DE 3 '!G37)","v":21},null,null,null,{"$f":"+'POULE DE 3 '!I28","v":5.0357142857142856},null,{"$f":"IF(ISBLANK('POULE DE 3 '!G28),\"\",'POULE DE 3 '!G28)","v":18},{"$f":"IF('POULE DE 3 '!U28=0,\"\",'POULE DE 3 '!U28)","v":""},null,{"$f":"IF('POULE DE 3 '!V28=0,\"\",'POULE DE 3 '!V28)","v":21}]
[null,null,"JOUEUR\ncategorie\nclub",{"$f":"$D$21","v":"JARRETY Didier"},null,null,{"$f":"$G$21","v":"SIMON Claude"},null,null,{"$f":"$J$21","v":"RIEGEL Serge"},null,null,"PTS","REP",null,"MG","PTS DE\n MATCHS","RANG","POINTS DE \nCLASSEMENTS","POINTS DE\n BONUS","TOTAL \nPOINTS"]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B30),\"\",'A RENSEIGNER'!B30)","v":"RIEGEL Serge"},{"$f":"IF(ISBLANK('POULE DE 3 '!E46),\"\",'POULE DE 3 '!E46)","v":61},null,{"$f":"+'POULE DE 3 '!F46","v":24},{"$f":"IF(ISBLANK('POULE DE 3 '!E29),\"\",'POULE DE 3 '!E29)","v":200},null,{"$f":"+'POULE DE 3 '!F29","v":28},null,null,null,{"$f":"IF('POULE DE 3 '!R29=0,\"\",'POULE DE 3 '!R29)","v":261},{"$f":"IF(ISERROR('POULE DE 3 '!S29),\"\",'POULE DE 3 '!S29)","v":52},null,{"$f":"IF(ISERROR('POULE DE 3 '!T29),\"\",'POULE DE 3 '!T29)","v":5.0192307692307692},{"$f":"IF(ISERROR('POULE DE 3 '!W29),\"\",'POULE DE 3 '!W29)","v":2},{"$f":"IF(ISERROR('POULE DE 3 '!Y29),\"\",IF(ISBLANK('A RENSEIGNER'!B30),\"\",IF('POULE DE 3 '!Y29=1,'POULE DE 3 '!Y29&\"er\",'POULE DE 3 '!Y29&\"ème\")))","v":"2ème"},{"$f":"IF(ISERROR('POULE DE 3 '!Z29),\"\",'POULE DE 3 '!Z29)","v":5},{"$f":"+'POULE DE 3 '!AG29","v":1},{"$f":"IF(ISERROR('POULE DE 3 '!AH29),\"\",'POULE DE 3 '!AH29)","v":6}]
[null,null,{"$f":"'A RENSEIGNER'!C30","v":"N3"},null,{"$f":"'POULE DE 3 '!J46","v":0},null,null,{"$f":"'POULE DE 3 '!J29","v":2},null,null,null,null,"MP",null,"SERIE"]
[null,null,{"$f":"'A RENSEIGNER'!D30","v":"ABASM"},{"$f":"+'POULE DE 3 '!I46","v":2.5416666666666665},null,{"$f":"IF(ISBLANK('POULE DE 3 '!G46),\"\",'POULE DE 3 '!G46)","v":14},{"$f":"+'POULE DE 3 '!I29","v":7.1428571428571432},null,{"$f":"IF(ISBLANK('POULE DE 3 '!G29),\"\",'POULE DE 3 '!G29)","v":30},null,null,null,{"$f":"IF('POULE DE 3 '!U29=0,\"\",'POULE DE 3 '!U29)","v":7.1428571428571432},null,{"$f":"IF('POULE DE 3 '!V29=0,\"\",'POULE DE 3 '!V29)","v":30}]

{"sheet":"POULE DE 2","index":4,"n_rows":230,"n_cols":34,"rows_kept":230,"cut":false,"hidden":false,"merged":[[49,15,49,23],[33,15,33,17],[40,2,40,9],[43,15,43,19],[45,15,45,23],[47,15,47,24],[33,19,33,21],[32,26,43,26],[32,27,43,27],[32,2,32,9],[19,2,19,9],[1,2,1,9],[1,10,1,17],[24,2,24,9],[24,15,24,33],[1,18,1,25],[1,26,1,33],[6,5,7,9],[21,2,21,9],[2,2,2,9]]}
[]
[null,null,"CDBVM\n     SAISON  2020- 2021",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDBHS\n     SAISON  2015- 2016",null,null,null,null,null,null,null,"CDBHS\n     SAISON  2015- 2016"]
[]
[]
[null,null,{"$f":"'POULE DE 3 '!C4","v":"DATE DE LA COMPETITION   "},{"$f":"'POULE DE 3 '!D4","v":"2022-03-13"}]
[null,null,{"$f":"'POULE DE 3 '!C5","v":"LIEU   "},{"$f":"'POULE DE 3 '!D5","v":"ABMA"}]
[null,null,{"$f":"'POULE DE 3 '!C6","v":"DIRECTEUR DE JEU   "},{"$f":"'POULE DE 3 '!D6","v":""},null,"FEUILLE DE MATCH\nPOULE DE 2 JOUEURS"]
[null,null,{"$f":"'A RENSEIGNER'!B14","v":"TOURNOI N°   "},{"$f":"'POULE DE 3 '!D7","v":"FINALE"}]
[null,null,{"$f":"'POULE DE 3 '!C8","v":"POULE N°   "},{"$f":"'POULE DE 3 '!D8","v":1}]
[null,null,{"$f":"'POULE DE 3 '!C9","v":"MODE DE JEU    "},{"$f":"'POULE DE 3 '!D9","v":"LIBRE"}]
[]
[]
[null,null,"JOUEURS","CATEGORIE"]
[]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",'A RENSEIGNER'!B41)","v":""},{"$f":"'A RENSEIGNER'!C41","v":""},{"$f":"VLOOKUP(D15,P35:Q39,2,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",'A RENSEIGNER'!B42)","v":""},{"$f":"'A RENSEIGNER'!C42","v":""},{"$f":"VLOOKUP(D16,P36:Q40,2,0)","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!C16),\"\",IF('A RENSEIGNER'!C16=\"3 BANDES\",\"LA DISTANCE DE LA POULE EST DE\"&\" \"&IF(AND(D15=D16),VLOOKUP(D15,P35:Q39,2,0),MAX(E15:E16))&\"  \"&\"POINTS EN 60 REPRISES\",\"LA DISTANCE DE LA POULE EST DE\"&\" \"&IF(AND(D15=D16),VLOOKUP(D15,P35:Q39,2,0),MAX(E15:E16))&\"  \"&\"POINTS EN 30 REPRISES\"))","v":{"$error":"#N/A"}}]
[]
[null,null,"SAISIE DES MATCHS"]
[]
[]
[null,null,"MATCH 1",null,null,null,null,null,null,null,null,null,null,null,null,"RESULTATS"]
[]
[null,null,"NOM","CATEGORIE","POINTS","REPRISES","SERIE",null,"MOY PART","POINTS MATCH","GAIN CATEG","GAIN MATCH","moy part validée",null,null,"NOM","CATEGORIE","TOTAL POINTS","TOTAL REPRISES","MOYENNE GENERALE","MOYENNE PARTICULIERE","MEILLEURE SERIE","POINTS DE MATCHS","calcul du rang","RANG","POINTS CLASSEMENT","BONUS moyenne match 1","BONUS moyenne match 2","Bonus catégorie Match 1","Bonus catégorie Match 2","Bonus  gain match 1","Bonus  gain match 2","TOTAL POINTS BONUS","TOTAL GENERAL"]
[null,{"$f":"VLOOKUP(D28,CATE_COR,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",'A RENSEIGNER'!B41)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!C41),\"\",'A RENSEIGNER'!C41)","v":""},null,null,null,{"$f":"IF(G28<I28,1,0)","v":0},{"$f":"IF(ISBLANK(E28),\"\",E28/F28)","v":""},{"$f":"IF(E28=\"\",\"\",IF(E28>E29,2,IF(E28=E29,1,IF(E28<E29,0))))","v":""},{"$f":"IF(B28<B29,1,0)","v":{"$error":"#N/A"}},{"$f":"IF(K28=0,0,IF(J28=2,3,IF(J28=1,2,IF(J28=0,1))))","v":{"$error":"#N/A"}},{"$f":"IF(J28=0,0,I28)","v":""},null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",'A RENSEIGNER'!B41)","v":""},{"$f":"'A RENSEIGNER'!C41","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",E28+E36)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",F28+F36)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",R28/S28)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",MAX(M28,M36))","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",MAX(G28,G36))","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",J28+J36)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",W28*1000000000+T28*1000000+U28*10000+V28)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",RANK(X28,$X$28:$X$30,0))","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",IF(Y28=1,8,IF(Y28=2,5,IF(Y28=3,3))))","v":""},{"$f":"IF(J28=0,0,IF(ISBLANK('A RENSEIGNER'!B41),\"\",IF(I28>VLOOKUP(D28,$T$35:$V$39,3,0),2,IF(I28<VLOOKUP(D28,$T$35:$V$39,2,0),0,1))))","v":""},{"$f":"IF(J36=0,0,IF(ISBLANK('A RENSEIGNER'!B41),\"\",IF(I36>VLOOKUP(D36,$T$35:$V$39,3,0),2,IF(I36<VLOOKUP(D36,$T$35:$V$39,2,0),0,1))))","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",K36)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",K46)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",L36)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",L46)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",SUM(AA28:AF28))","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",SUM(Z28,AG28))","v":""}]
[null,{"$f":"VLOOKUP(D29,CATE_COR,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",'A RENSEIGNER'!B42)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!C42),\"\",'A RENSEIGNER'!C42)","v":""},null,{"$f":"IF(ISBLANK(F28),\"\",F28)","v":""},null,{"$f":"IF(G29<I29,1,0)","v":0},{"$f":"IF(ISBLANK(E29),\"\",E29/F29)","v":""},{"$f":"IF(E29=\"\",\"\",IF(E29>E28,2,IF(E29=E28,1,IF(E29<E28+N21,0))))","v":""},{"$f":"IF(B29<B28,1,0)","v":{"$error":"#N/A"}},{"$f":"IF(K29=0,0,IF(J29=2,3,IF(J29=1,2,IF(J29=0,1))))","v":{"$error":"#N/A"}},{"$f":"IF(J29=0,0,I29)","v":""},null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",'A RENSEIGNER'!B42)","v":""},{"$f":"'A RENSEIGNER'!C42","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",E29+E37)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",F29+F37)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",R29/S29)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",MAX(M29,M37))","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",MAX(G29,G37))","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",J29+J37)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",W29*1000000000+T29*1000000+U29*10000+V29)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",RANK(X29,$X$28:$X$30,0))","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",IF(Y29=1,8,IF(Y29=2,5,IF(Y29=3,3))))","v":""},{"$f":"IF(J29=0,0,IF(ISBLANK('A RENSEIGNER'!B42),\"\",IF(I29>VLOOKUP(D29,$T$35:$V$39,3,0),2,IF(I29<VLOOKUP(D29,$T$35:$V$39,2,0),0,1))))","v":""},{"$f":"IF(J37=0,0,IF(ISBLANK('A RENSEIGNER'!B42),\"\",IF(I37>VLOOKUP(D37,$T$35:$V$39,3,0),2,IF(I37<VLOOKUP(D37,$T$35:$V$39,2,0),0,1))))","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",K37)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",K37)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",L28)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",L37)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",SUM(AA29:AF29))","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",SUM(Z29,AG29))","v":""}]
[]
[]
[]
[null,null,"MATCH  2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLEAU DES DISTANCES",null,null,null,"MOYENNE DES CATEGORIES"]
[null,null,"NOM","CATEGORIE","POINTS","REPRISES","SERIE",null,"MOY PART","POINTS MATCH","GAIN CATEG","GAIN MATCH","moy part validée",null,null,"R4",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&P35,tabdistance,4,0)","v":50},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&P35,tabdistance,5,0)","v":"PC"},null,"R4",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&T35,tablemoy,4,0)","v":0},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&T35,tablemoy,5,0)","v":1.1999998999999999}]
[null,{"$f":"VLOOKUP(D36,CATE_COR,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",'A RENSEIGNER'!B41)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!C41),\"\",'A RENSEIGNER'!C41)","v":""},null,null,null,{"$f":"IF(G36<I36,1,0)","v":0},{"$f":"IF(ISBLANK(E36),\"\",E36/F36)","v":""},{"$f":"IF(E36=\"\",\"\",IF(E36>E37,2,IF(E36=E37,1,IF(E36<E37,0))))","v":""},{"$f":"IF(B36<B37,1,0)","v":{"$error":"#N/A"}},{"$f":"IF(K36=0,0,IF(J36=2,3,IF(J36=1,2,IF(J36=0,1))))","v":{"$error":"#N/A"}},{"$f":"IF(J36=0,0,I36)","v":""},null,null,"R3",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&P36,tabdistance,4,0)","v":70},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&P36,tabdistance,5,0)","v":"PC"},null,"R3",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&T36,tablemoy,4,0)","v":1.2},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&T36,tablemoy,5,0)","v":2.2999990000000001}]
[null,{"$f":"VLOOKUP(D37,CATE_COR,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",'A RENSEIGNER'!B42)","v":""},{"$f":"IF(ISBLANK('A RENSEIGNER'!C42),\"\",'A RENSEIGNER'!C42)","v":""},null,{"$f":"IF(ISBLANK(F36),\"\",F36)","v":""},null,{"$f":"IF(G37<I37,1,0)","v":0},{"$f":"IF(ISBLANK(E37),\"\",E37/F37)","v":""},{"$f":"IF(E37=\"\",\"\",IF(E37>E36,2,IF(E37=E36,1,IF(E37<E36+N29,0))))","v":""},{"$f":"IF(B37<B36,1,0)","v":{"$error":"#N/A"}},{"$f":"IF(K37=0,0,IF(J37=2,3,IF(J37=1,2,IF(J37=0,1))))","v":{"$error":"#N/A"}},{"$f":"IF(J37=0,0,I37)","v":""},null,null,"R2",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&P37,tabdistance,4,0)","v":100},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&P37,tabdistance,5,0)","v":"PC"},null,"R2",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&T37,tablemoy,4,0)","v":2.2999999999999998},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&T37,tablemoy,5,0)","v":3.9999999000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R1",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&P38,tabdistance,4,0)","v":150},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&P38,tabdistance,5,0)","v":"PC"},null,"R1",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&T38,tablemoy,4,0)","v":4},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&T38,tablemoy,5,0)","v":5.9999998999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&P39,tabdistance,4,0)","v":200},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&P39,tabdistance,5,0)","v":"GC"},null,"N3",{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&T39,tablemoy,4,0)","v":6},{"$f":"VLOOKUP('A RENSEIGNER'!$C$16&T39,tablemoy,5,0)","v":12.499999900000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",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,"R1",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,"R2",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,"R3",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,"R4",1]

{"sheet":"RESULTATS POULE DE 2","index":5,"n_rows":24,"n_cols":21,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,16,23,16],[21,17,23,17],[18,12,18,13],[18,14,18,15],[21,20,23,20],[22,12,22,13],[23,12,23,13],[17,20,19,20],[21,19,23,19],[23,14,23,15],[20,13,20,14],[17,19,19,19],[21,13,21,14],[21,18,23,18],[2,2,2,20],[16,3,16,5],[16,6,16,8],[16,9,16,11],[16,13,16,14],[8,2,8,20],[6,2,6,20],[20,3,20,5],[4,2,4,20],[10,2,10,20],[14,2,14,20],[12,2,12,20],[19,12,19,13],[19,14,19,15],[17,18,19,18],[17,17,19,17],[17,13,17,14],[17,16,19,16],[20,6,20,8],[20,9,20,11]]}
[]
[]
[null,null,{"$f":"'A RENSEIGNER'!$C$11","v":"2022-03-13"}]
[]
[null,null,{"$f":"'A RENSEIGNER'!$C$12","v":"ABMA"}]
[]
[null,null,{"$f":"\"MODE DE JEU\"&\"  \"&'A RENSEIGNER'!$C$16","v":"MODE DE JEU  LIBRE"}]
[]
[null,null,{"$f":"\"CATEGORIE\"&\"  \"&'A RENSEIGNER'!$C$17","v":"CATEGORIE  N3"}]
[]
[null,null,{"$f":"\"TOURNOI N°\"&\"  \"&'A RENSEIGNER'!$C$14","v":"TOURNOI N°  FINALE"}]
[]
[null,null,{"$f":"\"POULE n°\"&\"  \"&'A RENSEIGNER'!$C$15","v":"POULE n°  1"}]
[]
[null,null,"RESULTATS DE LA POULE"]
[]
[null,null,"JOUEUR\ncategorie\nclub",{"$f":"C18","v":""},null,null,{"$f":"C22&\"  \"&\"match 1\"","v":"  match 1"},null,null,{"$f":"C22&\"  \"&\"match 2\"","v":"  match 2"},null,null,"PTS","REP",null,"MG","PTS DE\n MATCHS","RANG","POINTS DE \nCLASSEMENT","POINTS DE\n BONUS","TOTAL \nPOINTS"]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B41),\"\",('A RENSEIGNER'!B41))","v":""},null,null,null,{"$f":"IF(ISBLANK('POULE DE 2'!E28),\"\",'POULE DE 2'!E28)","v":""},null,{"$f":"IF(ISBLANK('POULE DE 2'!F28),\"\",'POULE DE 2'!F28)","v":""},{"$f":"IF(ISBLANK('POULE DE 2'!E36),\"\",'POULE DE 2'!E36)","v":""},null,{"$f":"IF(ISBLANK('POULE DE 2'!E36),\"\",'POULE DE 2'!F36)","v":""},{"$f":"IF('POULE DE 2'!R28=0,\"\",'POULE DE 2'!R28)","v":""},{"$f":"IF('POULE DE 2'!S28=0,\"\",'POULE DE 2'!S28)","v":""},null,{"$f":"IF(ISERROR('POULE DE 2'!T28),\"\",'POULE DE 2'!T28)","v":""},{"$f":"IF(ISERROR('POULE DE 3 '!W28),\"\",'POULE DE 2'!W28)","v":""},{"$f":"IF(ISERROR('POULE DE 3 '!Y28),\"\",IF(ISBLANK('A RENSEIGNER'!B41),\"\",IF('POULE DE 2'!Y28=1,'POULE DE 2'!Y28&\"er\",'POULE DE 2'!Y28&\"ème\")))","v":""},{"$f":"IF(ISERROR('POULE DE 3 '!Z28),\"\",'POULE DE 2'!Z28)","v":""},{"$f":"IF(ISBLANK(C18),\"\",'POULE DE 2'!AG28)","v":""},{"$f":"IF(ISERROR('POULE DE 2'!AH28),\"\",'POULE DE 2'!AH28)","v":""}]
[null,null,{"$f":"'A RENSEIGNER'!C41","v":""},null,null,null,null,{"$f":"'POULE DE 2'!J28","v":""},null,null,{"$f":"'POULE DE 2'!J36","v":""},null,"MP",null,"SERIE"]
[null,null,{"$f":"'A RENSEIGNER'!D41","v":""},null,null,null,{"$f":"'POULE DE 2'!I28","v":""},null,{"$f":"IF(ISBLANK('POULE DE 2'!G28),\"\",'POULE DE 2'!G28)","v":""},{"$f":"'POULE DE 2'!I36","v":""},null,{"$f":"IF(ISBLANK('POULE DE 2'!E36),\"\",'POULE DE 2'!G36)","v":""},{"$f":"IF('POULE DE 2'!U28=0,\"\",'POULE DE 2'!U28)","v":""},null,{"$f":"IF('POULE DE 2'!V28=0,\"\",'POULE DE 2'!V28)","v":""}]
[null,null,"JOUEUR\ncategorie\nclub",{"$f":"C18&\"  \"&\"match 1\"","v":"  match 1"},null,null,{"$f":"C22","v":""},null,null,{"$f":"C18&\"  \"&\"match 2\"","v":"  match 2"},null,null,"PTS","REP",null,"MG","PTS DE\n MATCHS","RANG","POINTS DE \nCLASSEMENTS","POINTS DE\n BONUS","TOTAL \nPOINTS"]
[null,null,{"$f":"IF(ISBLANK('A RENSEIGNER'!B42),\"\",'A RENSEIGNER'!B42)","v":""},{"$f":"IF(ISBLANK('POULE DE 2'!E29),\"\",'POULE DE 2'!E29)","v":""},null,{"$f":"'POULE DE 2'!F29","v":""},null,null,null,{"$f":"IF(ISBLANK('POULE DE 2'!E37),\"\",'POULE DE 2'!E37)","v":""},null,{"$f":"'POULE DE 2'!F37","v":""},{"$f":"IF('POULE DE 2'!R29=0,\"\",'POULE DE 2'!R29)","v":""},{"$f":"IF(ISERROR('POULE DE 2'!S29=0),\"\",'POULE DE 2'!S29)","v":""},null,{"$f":"IF(ISERROR('POULE DE 2'!T29),\"\",'POULE DE 2'!T29)","v":""},{"$f":"IF(ISERROR('POULE DE 3 '!W29),\"\",'POULE DE 2'!W29)","v":""},{"$f":"IF(ISERROR('POULE DE 3 '!Y29),\"\",IF(ISBLANK('A RENSEIGNER'!B42),\"\",IF('POULE DE 2'!Y29=1,'POULE DE 2'!Y29&\"er\",'POULE DE 2'!Y29&\"ème\")))","v":""},{"$f":"IF(ISERROR('POULE DE 3 '!Z29),\"\",'POULE DE 2'!Z29)","v":""},{"$f":"IF(ISBLANK(C22),\"\",'POULE DE 2'!AG29)","v":""},{"$f":"IF(ISERROR('POULE DE 2'!AH29),\"\",'POULE DE 2'!AH29)","v":""}]
[null,null,{"$f":"'A RENSEIGNER'!C42","v":""},null,{"$f":"'POULE DE 2'!J29","v":""},null,null,null,null,null,{"$f":"'POULE DE 2'!J37","v":""},null,"MP",null,null,"SERIE"]
[null,null,{"$f":"'A RENSEIGNER'!D42","v":""},{"$f":"'POULE DE 2'!I29","v":""},null,{"$f":"IF(ISBLANK('POULE DE 2'!G29),\"\",'POULE DE 2'!G29)","v":""},null,null,null,{"$f":"'POULE DE 2'!I37","v":""},null,{"$f":"IF(ISBLANK('POULE DE 2'!G37),\"\",'POULE DE 2'!G37)","v":""},{"$f":"IF('POULE DE 2'!U29=0,\"\",'POULE DE 2'!U29)","v":""},null,{"$f":"IF('POULE DE 2'!V29=0,\"\",'POULE DE 2'!V29)","v":""}]

{"sheet":"categories","index":6,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["version excel",null," 2016_CDBHS_FM_v9"]
["non trouvé",null,"-"]
[]
["distance","jeux","TABLEAU DES DISTANCES LIBRE","pt","f",null,"moyenne","jeux","MOYENNE DES CATEGORIES LIBRE ","mini","maxi"]
[{"$f":"B5&C5","v":"3 BANDESN3"},"3 BANDES","N3",25,"60 REP",null,{"$f":"H5&I5","v":"3 BANDESN3"},"3 BANDES","N3",0.36,0.52299989999999996]
[{"$f":"B6&C6","v":"3 BANDESR1"},"3 BANDES","R1",20,"60 REP",null,{"$f":"H6&I6","v":"3 BANDESR1"},"3 BANDES","R1",0.25,0.35999989999999998]
["3 BANDESR2","3 BANDES","R2",15,"60 REP",null,"3 BANDESR2","3 BANDES","R2",0,0.249999]
["3 BANDESR3","3 BANDES","R3","-","-",null,"3 BANDESR3","3 BANDES","R3","-","-"]
["3 BANDESR4","3 BANDES","R4","-","-",null,"3 BANDESR4","3 BANDES","R4","-","-"]
["BANDEN3","BANDE","N3",80,null,null,"BANDEN3","BANDE","N3",1.75,2.5799998999999998]
["BANDER1","BANDE","R1",60,null,null,"BANDER1","BANDE","R1",1,1.7499998999999999]
["BANDER2","BANDE","R2",40,null,null,"BANDER2","BANDE","R2",0,0.99999990000000005]
["BANDER3","BANDE","R3","-","-",null,"BANDER3","BANDE","R3","-","-"]
["BANDER4","BANDE","R4","-","-",null,"BANDER4","BANDE","R4","-","-"]
["CADREN3","CADRE","N3",120,"42/2",null,"CADREN3","CADRE","N3",3.5,6.2499998999999997]
["CADRER1","CADRE","R1",80,"42/2",null,"CADRER1","CADRE","R1",0,3.4999999989999999]
["CADRER2","CADRE","R2","-","-",null,"CADRER2","CADRE","R2","-","-"]
["CADRER3","CADRE","R3","-","-",null,"CADRER3","CADRE","R3","-","-"]
["CADRER4","CADRE","R4","-","-",null,"CADRER4","CADRE","R4","-","-"]
["LIBREN3","LIBRE","N3",200,"GC",null,"LIBREN3","LIBRE","N3",6,12.499999900000001]
["LIBRER1","LIBRE","R1",150,"PC",null,"LIBRER1","LIBRE","R1",4,5.9999998999999997]
["LIBRER2","LIBRE","R2",100,"PC",null,"LIBRER2","LIBRE","R2",2.2999999999999998,3.9999999000000002]
[{"$f":"B23&C23","v":"LIBRER3"},"LIBRE","R3",70,"PC",null,{"$f":"H23&I23","v":"LIBRER3"},"LIBRE","R3",1.2,2.2999990000000001]
[{"$f":"B24&C24","v":"LIBRER4"},"LIBRE","R4",50,"PC",null,{"$f":"H24&I24","v":"LIBRER4"},"LIBRE","R4",0,1.1999998999999999]

{"sheet":"BD_JOUEURS_CLUB_CATEGORIES","index":7,"n_rows":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,2,1],[1,2,2,2]]}
[null,null,null,1,2,3,4]
["NOM","CLUB","ID","               CATEGORIES"]
[null,null,null,"libre","bande","3 bandes","cadre","n-2"]
["ADMONT Jean-Pierre","ABMA",1,"R2","R1","N3",null,1]
["ARGIS Mickael","ABMA",2,"R1","N3",null,"N3",1]
["BAURECHE Louis","ABASM",3,"R3","R1",null,null,0]
["BEAUCHER Alain","LIVRY",4,"R2","N3","N3","R1",1]
["BENDAYAN Jacky","ABMA",5,"R3",null,"N3","R1",1]
["BOISSET Jean-Pierre","ABASM",6,"R3","R1","R1","R1",1]
["CHAMPY Philippe","ABASM",7,"R2","R1",null,"R1",1]
["CHUNG Hoan Toan","LIVRY",8,"R3","R1","R1","R1",0]
["COKAL Recep","ABASM",9,null,null,"R1","R1",0]
["COURATIN Jean-Daniel","ABMA",10,"R3",null,null,null,1]
["CROLARD Ivan","ABASM",11,"R3",null,null,null,0]
["DAIRE Eric","ABASM",12,"R2","R1","R1","R1",1]
["DECLUNDER Magali",null,13,null,null,"N3",null,0]
["DELALANDE Christian","LIVRY",14,"N3","N3","N3","N3",1]
["DELALANDE Guy","ABMA",15,null,"R2",null,null,0]
["DELAPLACE Emmanuel","LIVRY",16,"R2","R1","N3","R1",1]
["DI GIOIA Serge","ABASM",17,null,null,"R1"," ",1]
["DIAZ Vincent","ABMA",18,"R4","R2",null,null,0]
["DJIAN Didier","La Comete",19,"R2","N3",null,null,0]
["DOUSSOT Pierre","ABMA",20,"R1","R1","N3","N3",1]
["DUMONT Christine","LIVRY",21,"R4",null,null,null,0]
["DUPRE Bernard","La Comete",22,null,null,"R1",null,0]
["DUVAL Gérard","LIVRY",23,"R3",null,"R1",null,0]
["FAVERO Alain","LIVRY",24,"R1","N3",null,"N3",1]
["FAVIEN Christian","LIVRY",25,null,null,"R1",null,1]
["FERNANDEZ ALVES Francisco","ABMA",26,"R2","R1","N3","R1",1]
["FERRARA  Jean-Pierre","ABMA",27,null,null,"N3","N3",1]
["GAYRAUD Françoise","L HAY LES ROSES ",28,"R3",null,null,null,0]
["GELLER Marc","ABMA",29,"N3",null,null,null,0]
["GERNEZ Jean Philippe","ABMA",30,"R3",null,null,null,1]
["GILLOT Olivier","ABMA",31,"N3","R1","R1","N3",1]
["GOUVEIA Victor","LIVRY",32,"R3","R1","N3",null,1]
["GUERIN Jacky","ABASM",33,"R3","R2",null,null,1]
["GUILLOTIN Gilles","ABMA",34,"R1","R1"," ","R1",0]
["GUREWAN Suresh","ABMA",35,"N3","N3","N3","N3",1]
["HARY Mathieu","ABMA",36,"N3","N3","N3","N3",0]
["HELLAL Denis","ABASM",37,null,"R1","N3",null,0]
["HENRIQUET Marc","ABASM",38,"R3","R2","R1","R1",1]
["IVANOVIC Spomanko","ABASM",39,"R2","R1","R1","R1",0]
["JARRETY Didier","LIVRY",40,"N3","N3","N3","N3",1]
["JARRIER Christian","ABASM",41,null,"R1","N3","N3",0]
["KELLNER Pierre","ABMA",42,"R3",null,null,null,1]
["KEREBEL Eric","ABASM",43,"R2","R1","R1","R1",1]
["KERIZAC Franck","ABMA",44,"R3",null,null,null,0]
["L HERONDE Michel","ABMA",45,"R2","R1",null,null,1]
["LABOUREAU Véronique","ABMA",46,"R3","R2","R2","R1",1]
["LAPERTOT Michel","LIVRY",47,"R1","N3","N3","N3",0]
["LE CAM Fabrice","ABMA",48,"R3",null,null,null,0]
["LE CAM Fabrice","La Comete",49,"R3","R1","R1","R1",1]
["Le Huan CUA Tran","ABMA",50,"R3","R1","R1","R1",0]
["LECLERC Michel","ABASM",51,"R2","R1","N3","R1",1]
["LEFEBVRE Frédéric","LIVRY",52,"R2","R1","R1",null,0]
["LEMOINE David","ABASM",53,"R3","R1","R1","R1",0]
["LEMONIER Thierry","ABMA",54,"R3","R2",null,null,1]
["LOURDOU Gérard","LIVRY",55,"R2","R1","R1","R1",1]
["LUCAS Philippe","ABASM",56,"R3","R1","R1","R1",1]
["MA PHUOC Bich","ABMA",57,"R2","R1",null,"R1",1]
["MALAHIEUDE Claude","ABMA",58,null,null,"R1","R1",1]
["MALASSIGNE Elfege","ABASM",59,"R4",null,"R2",null,1]
["MANCY Pierre","ABMA",60,"R3","R2","R1",null,0]
["MARIGNIER Daniel","ABMA",61,"R3","R2",null,null,0]
["MENDEL Gilles","ABMA",62,"R1","R1","R1","R1",1,null,null,null," "]
["MOLET Claude","ABASM",63,"N3","N3","N2","N3",1]
["NGUYEN Antoine","ABMA",64,null,null,"N3","N3",0]
["PALLOT Dominique","LIVRY",65,null,null,"N3",null,0]
["PAURON Regis","ABMA",66,"R3","R1","R1","R1",1]
["PEYROLE Philippe","LIVRY",67,"R2","R1",null,"N3",1]
["PIBOURDIN Eric","ABMA",68,"R2","R1","R1","R1",1]
["PIVONET Françis","ABASM",69,"R2","R1","R1","R1",1]
["PONCE Frédéric","ABMA",70,"R3","R1","R1","R1",1]
["RAOULT Pierre-Jean","ABASM",71,"R1","R1","R1","R1",1]
["RIEGEL Serge","ABASM",72,"N3","N3","N3","N3",1]
["RODRIGUEZ Julien","ABMA",73,"R1","R1","N3","R1",1]
["SAGET Xavier","ABASM",74,"R2","R1","N3","N3",1]
["SIMON Claude","ABASM",75,"N3","N3","N3","N3",1]
["SULEM Paul","ABASM",76,"R3","R1","R1",null,1]
["TENREIRO Aristide","LIVRY",77,null,"R1","N3",null,1]
["THIERRY Jean-Michel","ABMA",78,"N3","N3","N3","N3",1]
["VASSEUR Philippe","ABMA",79,"R3",null,null,null,0," "]
["WEILL Denis","ABASM",80,"R1","R1","R1","R1",0]
["Joueur 1",null,81,null,null,null,null,1]
["joueur2",null,82,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H4:H85)","v":51}]
[]
[]
[null,null,null,null,null,null,null," ",null," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[" "]

{"sheet":"resultats pour ranking","index":8,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[10,0,10,5],[18,0,18,5],[8,0,8,5]]}
[{"$f":"'A RENSEIGNER'!$C$11","v":"2022-03-13"}]
[{"$f":"'A RENSEIGNER'!$C$12","v":"ABMA"}]
[{"$f":"\"MODE DE JEU\"&\"  \"&'A RENSEIGNER'!$C$16","v":"MODE DE JEU  LIBRE"}]
[{"$f":"\"CATEGORIE\"&\"  \"&'A RENSEIGNER'!$C$17","v":"CATEGORIE  N3"}]
[{"$f":"\"TOURNOI N°\"&\"  \"&'A RENSEIGNER'!$C$14","v":"TOURNOI N°  FINALE"}]
[{"$f":"\"POULE n°\"&\"  \"&'A RENSEIGNER'!$C$15","v":"POULE n°  1"}]
[]
[]
["RESULTATS DE LA POULE"]
[]
["Poule de 3 joueurs"]
["NOM","points de classement ranking","total points","total reprises","Meilleure Particulière","Meilleure série"]
[{"$f":"'RESULTATS  POULE DE  3'!$C$18","v":"JARRETY Didier"},{"$f":"'RESULTATS  POULE DE  3'!$U$18","v":9},{"$f":"'RESULTATS  POULE DE  3'!$M$18","v":400},{"$f":"'RESULTATS  POULE DE  3'!$N$18","v":60},{"$f":"'RESULTATS  POULE DE  3'!$M$20","v":8.3333333333333339},{"$f":"'RESULTATS  POULE DE  3'!$O$20","v":32}]
[{"$f":"'RESULTATS  POULE DE  3'!$C$22","v":"SIMON Claude"},{"$f":"'RESULTATS  POULE DE  3'!$U$22","v":3},{"$f":"'RESULTATS  POULE DE  3'!$M$22","v":270},{"$f":"'RESULTATS  POULE DE  3'!$N$22","v":64},{"$f":"'RESULTATS  POULE DE  3'!$M$24","v":""},{"$f":"'RESULTATS  POULE DE  3'!$O$24","v":21}]
[{"$f":"'RESULTATS  POULE DE  3'!$C$26","v":"RIEGEL Serge"},{"$f":"'RESULTATS  POULE DE  3'!$U$26","v":6},{"$f":"'RESULTATS  POULE DE  3'!$M$26","v":261},{"$f":"'RESULTATS  POULE DE  3'!$N$26","v":52},{"$f":"'RESULTATS  POULE DE  3'!$M$28","v":7.1428571428571432},{"$f":"'RESULTATS  POULE DE  3'!$O$28","v":30}]
[]
[null,null,null,null,null,null,null,"Copier les cellules et coller dans le ranking avec \" valeur\""]
[]
["Poule de 2 joueurs"]
["NOM","points de classement ranking","total points","total reprises","Meilleure Particulière","Meilleure série"]
[{"$f":"'RESULTATS POULE DE 2'!$C$18","v":""},{"$f":"'RESULTATS POULE DE 2'!$U$18","v":""},{"$f":"'RESULTATS POULE DE 2'!$M$18","v":""},{"$f":"'RESULTATS POULE DE 2'!$N$18","v":""},{"$f":"'RESULTATS POULE DE 2'!M20","v":""},{"$f":"'RESULTATS POULE DE 2'!$O$20","v":""}]
[{"$f":"'RESULTATS POULE DE 2'!$C$22","v":""},{"$f":"'RESULTATS POULE DE 2'!$U$22","v":""},{"$f":"'RESULTATS POULE DE 2'!$M$22","v":""},{"$f":"'RESULTATS POULE DE 2'!$N$22","v":""},{"$f":"'RESULTATS POULE DE 2'!$M$24","v":""},{"$f":"'RESULTATS POULE DE 2'!$O$24","v":""}]