{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["+sieurs Poules de 3 joueurs","1 poule de 5 joueurs","2 Poules de 2 joueurs","+sieurs Poules de 2 joueurs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"+sieurs Poules de 3 joueurs","index":0,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[47,8,48,8],[44,8,45,8],[41,8,42,8],[0,0,0,8],[8,8,9,8],[11,8,12,8],[3,4,4,8],[3,0,3,3],[1,1,1,3],[1,5,1,8],[6,2,6,5],[25,8,26,8],[19,8,20,8],[25,7,26,7],[39,2,39,5],[4,0,5,3],[8,7,9,7],[11,7,12,7],[5,7,5,8],[33,8,34,8],[14,8,15,8],[30,8,31,8],[22,8,23,8],[14,7,15,7],[19,7,20,7],[22,7,23,7],[17,2,17,5],[28,2,28,5],[53,0,53,8],[30,7,31,7],[33,7,34,7],[36,7,37,7],[41,7,42,7],[44,7,45,7],[47,7,48,7],[36,8,37,8]]}
["LES RENCONTRES DU CD59 \n(cette feuille doit être imprimée, remplie, signée et archivée dans le club jusqu'à la fin de la saison)"]
["CLUB :",null,null,null,"date :",{"$f":"TODAY()","v":"2019-11-12"}]
[null,"format des billards  :",null,"3m10","2m80","2m60","Début des matchs à 14h30"]
["Envoyer cette feuille en pièce jointe aux destinataires ci-dessous (clic)",null,null,null,"il est indispensable d'enregistrer les résultats sur FFBSPORTIF.COM en vous aidant des liens ci-dessous (votre club possède une identification). Les résultats pour 2 poules de 2 s'écrivent dans une poule commune."]
["s.gauquie@free.fr; andre.desbleumortiers@orange.fr;pierre.reynaert@free.fr"]
[null,null,null,null,"libre","cadre","bande","3 bandes"]
["Discipline ( mode de jeu et catégorie):",null,null,null,null,null,"poule"]
["JOUEUR / Licence","Adversaires","Points réalisés","Reprises","Série","Moyenne","G/P/N",null,"place"]
[null,{"$f":"IF(A12=\"\",\"\",A12)","v":""},null,null,null,{"$f":"IF(D9=\"\",\" \",C9/D9)","v":" "},{"$f":"IF(C9=\"\",\"\",IF(C9>C13,\"G\",IF(C9=C13,\"N\",\"P\")))","v":""},{"$f":"IF((D9+D10)=0,\"\",(C9+C10)/(D9+D10))","v":""},{"$f":"IF(A9=\"\",\"\",RANK(J9,$J$9:$J$16))","v":""},{"$f":"(IF(G9=\"P\",0,IF(G9=\"N\",1,2))+IF(G10=\"P\",0,IF(G10=\"N\",1,2)))*1000+H9*100+MAX(E9:E10)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A15=\"\",\"\",A15)","v":""},null,null,null,{"$f":"IF(D10=\"\",\" \",C10/D10)","v":" "},{"$f":"IF(C10=\"\",\"\",IF(C10>C16,\"G\",IF(C10=C16,\"N\",\"P\")))","v":""}]
[]
[null,{"$f":"IF(A15=\"\",\"\",A15)","v":""},null,null,null,{"$f":"IF(D12=\"\",\" \",C12/D12)","v":" "},{"$f":"IF(C12=\"\",\"\",IF(C12>C15,\"G\",IF(C12=C15,\"N\",\"P\")))","v":""},{"$f":"IF((D12+D13)=0,\"\",(C12+C13)/(D12+D13))","v":""},{"$f":"IF(A12=\"\",\"\",RANK(J12,$J$9:$J$16))","v":""},{"$f":"(IF(G12=\"P\",0,IF(G12=\"N\",1,2))+IF(G13=\"P\",0,IF(G13=\"N\",1,2)))*1000+H12*100+MAX(E12:E13)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A9=\"\",\"\",A9)","v":""},null,{"$f":"IF(D9<>\"\",D9,0)","v":0},null,{"$f":"IF(D13=0,\" \",C13/D13)","v":" "},{"$f":"IF(G9=\"\",\"\",IF(G9=\"G\",\"P\",IF(G9=\"N\",\"N\",\"G\")))","v":""}]
[]
[null,{"$f":"IF(A12=\"\",\"\",A12)","v":""},null,{"$f":"IF(D12<>\"\",D12,0)","v":0},null,{"$f":"IF(D15=0,\" \",C15/D15)","v":" "},{"$f":"IF(G12=\"\",\"\",IF(G12=\"G\",\"P\",IF(G12=\"N\",\"N\",\"G\")))","v":""},{"$f":"IF((D15+D16)=0,\"\",(C15+C16)/(D15+D16))","v":""},{"$f":"IF(A15=\"\",\"\",RANK(J15,$J$9:$J$16))","v":""},{"$f":"(IF(G15=\"P\",0,IF(G15=\"N\",1,2))+IF(G16=\"P\",0,IF(G16=\"N\",1,2)))*1000+H15*100+MAX(E15:E16)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A9=\"\",\"\",A9)","v":""},null,{"$f":"IF(D10<>\"\",D10,0)","v":0},null,{"$f":"IF(D16=0,\" \",C16/D16)","v":" "},{"$f":"IF(G10=\"\",\"\",IF(G10=\"G\",\"P\",IF(G10=\"N\",\"N\",\"G\")))","v":""}]
[]
["Discipline ( mode de jeu et catégorie):",null,null,null,null,null,"poule"]
["JOUEUR / Licence","Adversaires","Points réalisés","Reprises","Série","Moyenne","G/P/N",null,"place"]
[null,{"$f":"IF(A23=\"\",\"\",A23)","v":""},null,null,null,{"$f":"IF(D20=\"\",\" \",C20/D20)","v":" "},{"$f":"IF(C20=\"\",\"\",IF(C20>C24,\"G\",IF(C20=C24,\"N\",\"P\")))","v":""},{"$f":"IF((D20+D21)=0,\"\",(C20+C21)/(D20+D21))","v":""},{"$f":"IF(A20=\"\",\"\",RANK(J20,$J$20:$J$27))","v":""},{"$f":"(IF(G20=\"P\",0,IF(G20=\"N\",1,2))+IF(G21=\"P\",0,IF(G21=\"N\",1,2)))*1000+H20*100+MAX(E20:E21)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A26=\"\",\"\",A26)","v":""},null,null,null,{"$f":"IF(D21=\"\",\" \",C21/D21)","v":" "},{"$f":"IF(C21=\"\",\"\",IF(C21>C27,\"G\",IF(C21=C27,\"N\",\"P\")))","v":""}]
[]
[null,{"$f":"IF(A26=\"\",\"\",A26)","v":""},null,null,null,{"$f":"IF(D23=\"\",\" \",C23/D23)","v":" "},{"$f":"IF(C23=\"\",\"\",IF(C23>C26,\"G\",IF(C23=C26,\"N\",\"P\")))","v":""},{"$f":"IF((D23+D24)=0,\"\",(C23+C24)/(D23+D24))","v":""},{"$f":"IF(A23=\"\",\"\",RANK(J23,$J$20:$J$27))","v":""},{"$f":"(IF(G23=\"P\",0,IF(G23=\"N\",1,2))+IF(G24=\"P\",0,IF(G24=\"N\",1,2)))*1000+H23*100+MAX(E23:E24)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A20=\"\",\"\",A20)","v":""},null,{"$f":"IF(D20<>\"\",D20,0)","v":0},null,{"$f":"IF(D24=0,\" \",C24/D24)","v":" "},{"$f":"IF(G20=\"\",\"\",IF(G20=\"G\",\"P\",IF(G20=\"N\",\"N\",\"G\")))","v":""}]
[]
[null,{"$f":"IF(A23=\"\",\"\",A23)","v":""},null,{"$f":"IF(D23<>\"\",D23,0)","v":0},null,{"$f":"IF(D26=0,\" \",C26/D26)","v":" "},{"$f":"IF(G23=\"\",\"\",IF(G23=\"G\",\"P\",IF(G23=\"N\",\"N\",\"G\")))","v":""},{"$f":"IF((D26+D27)=0,\"\",(C26+C27)/(D26+D27))","v":""},{"$f":"IF(A26=\"\",\"\",RANK(J26,$J$20:$J$27))","v":""},{"$f":"(IF(G26=\"P\",0,IF(G26=\"N\",1,2))+IF(G27=\"P\",0,IF(G27=\"N\",1,2)))*1000+H26*100+MAX(E26:E27)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A20=\"\",\"\",A20)","v":""},null,{"$f":"IF(D21<>\"\",D21,0)","v":0},null,{"$f":"IF(D27=0,\" \",C27/D27)","v":" "},{"$f":"IF(G21=\"\",\"\",IF(G21=\"G\",\"P\",IF(G21=\"N\",\"N\",\"G\")))","v":""}]
[]
["Discipline ( mode de jeu et catégorie):",null,null,null,null,null,"poule"]
["JOUEUR / Licence","Adversaires","Points réalisés","Reprises","Série","Moyenne","G/P/N",null,"place"]
[null,{"$f":"IF(A34=\"\",\"\",A34)","v":""},null,null,null,{"$f":"IF(D31=\"\",\" \",C31/D31)","v":" "},{"$f":"IF(C31=\"\",\"\",IF(C31>C35,\"G\",IF(C31=C35,\"N\",\"P\")))","v":""},{"$f":"IF((D31+D32)=0,\"\",(C31+C32)/(D31+D32))","v":""},{"$f":"IF(A31=\"\",\"\",RANK(J31,$J$31:$J$38))","v":""},{"$f":"(IF(G31=\"P\",0,IF(G31=\"N\",1,2))+IF(G32=\"P\",0,IF(G32=\"N\",1,2)))*1000+H31*100+MAX(E31:E32)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A37=\"\",\"\",A37)","v":""},null,null,null,{"$f":"IF(D32=\"\",\" \",C32/D32)","v":" "},{"$f":"IF(C32=\"\",\"\",IF(C32>C38,\"G\",IF(C32=C38,\"N\",\"P\")))","v":""}]
[]
[null,{"$f":"IF(A37=\"\",\"\",A37)","v":""},null,null,null,{"$f":"IF(D34=\"\",\" \",C34/D34)","v":" "},{"$f":"IF(C34=\"\",\"\",IF(C34>C37,\"G\",IF(C34=C37,\"N\",\"P\")))","v":""},{"$f":"IF((D34+D35)=0,\"\",(C34+C35)/(D34+D35))","v":""},{"$f":"IF(A34=\"\",\"\",RANK(J34,$J$31:$J$38))","v":""},{"$f":"(IF(G34=\"P\",0,IF(G34=\"N\",1,2))+IF(G35=\"P\",0,IF(G35=\"N\",1,2)))*1000+H34*100+MAX(E34:E35)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A31=\"\",\"\",A31)","v":""},null,{"$f":"IF(D31<>\"\",D31,0)","v":0},null,{"$f":"IF(D35=0,\" \",C35/D35)","v":" "},{"$f":"IF(G31=\"\",\"\",IF(G31=\"G\",\"P\",IF(G31=\"N\",\"N\",\"G\")))","v":""}]
[]
[null,{"$f":"IF(A34=\"\",\"\",A34)","v":""},null,{"$f":"IF(D34<>\"\",D34,0)","v":0},null,{"$f":"IF(D37=0,\" \",C37/D37)","v":" "},{"$f":"IF(G34=\"\",\"\",IF(G34=\"G\",\"P\",IF(G34=\"N\",\"N\",\"G\")))","v":""},{"$f":"IF((D37+D38)=0,\"\",(C37+C38)/(D37+D38))","v":""},{"$f":"IF(A37=\"\",\"\",RANK(J37,$J$31:$J$38))","v":""},{"$f":"(IF(G37=\"P\",0,IF(G37=\"N\",1,2))+IF(G38=\"P\",0,IF(G38=\"N\",1,2)))*1000+H37*100+MAX(E37:E38)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A31=\"\",\"\",A31)","v":""},null,{"$f":"IF(D32<>\"\",D32,0)","v":0},null,{"$f":"IF(D38=0,\" \",C38/D38)","v":" "},{"$f":"IF(G32=\"\",\"\",IF(G32=\"G\",\"P\",IF(G32=\"N\",\"N\",\"G\")))","v":""}]
[]
["Discipline ( mode de jeu et catégorie):",null,null,null,null,null,"poule"]
["JOUEUR / Licence","Adversaires","Points réalisés","Reprises","Série","Moyenne","G/P/N",null,"place"]
[null,{"$f":"IF(A45=\"\",\"\",A45)","v":""},null,null,null,{"$f":"IF(D42=\"\",\" \",C42/D42)","v":" "},{"$f":"IF(C42=\"\",\"\",IF(C42>C46,\"G\",IF(C42=C46,\"N\",\"P\")))","v":""},{"$f":"IF((D42+D43)=0,\"\",(C42+C43)/(D42+D43))","v":""},{"$f":"IF(A42=\"\",\"\",RANK(J42,$J$42:$J$49))","v":""},{"$f":"(IF(G42=\"P\",0,IF(G42=\"N\",1,2))+IF(G43=\"P\",0,IF(G43=\"N\",1,2)))*1000+H42*100+MAX(E42:E43)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A48=\"\",\"\",A48)","v":""},null,null,null,{"$f":"IF(D43=\"\",\" \",C43/D43)","v":" "},{"$f":"IF(C43=\"\",\"\",IF(C43>C49,\"G\",IF(C43=C49,\"N\",\"P\")))","v":""}]
[]
[null,{"$f":"IF(A48=\"\",\"\",A48)","v":""},null,null,null,{"$f":"IF(D45=\"\",\" \",C45/D45)","v":" "},{"$f":"IF(C45=\"\",\"\",IF(C45>C48,\"G\",IF(C45=C48,\"N\",\"P\")))","v":""},{"$f":"IF((D45+D46)=0,\"\",(C45+C46)/(D45+D46))","v":""},{"$f":"IF(A45=\"\",\"\",RANK(J45,$J$42:$J$49))","v":""},{"$f":"(IF(G45=\"P\",0,IF(G45=\"N\",1,2))+IF(G46=\"P\",0,IF(G46=\"N\",1,2)))*1000+H45*100+MAX(E45:E46)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A42=\"\",\"\",A42)","v":""},null,{"$f":"IF(D42<>\"\",D42,0)","v":0},null,{"$f":"IF(D46=0,\" \",C46/D46)","v":" "},{"$f":"IF(G42=\"\",\"\",IF(G42=\"G\",\"P\",IF(G42=\"N\",\"N\",\"G\")))","v":""}]
[]
[null,{"$f":"IF(A45=\"\",\"\",A45)","v":""},null,{"$f":"IF(D45<>\"\",D45,0)","v":0},null,{"$f":"IF(D48=0,\" \",C48/D48)","v":" "},{"$f":"IF(G45=\"\",\"\",IF(G45=\"G\",\"P\",IF(G45=\"N\",\"N\",\"G\")))","v":""},{"$f":"IF((D48+D49)=0,\"\",(C48+C49)/(D48+D49))","v":""},{"$f":"IF(A48=\"\",\"\",RANK(J48,$J$42:$J$49))","v":""},{"$f":"(IF(G48=\"P\",0,IF(G48=\"N\",1,2))+IF(G49=\"P\",0,IF(G49=\"N\",1,2)))*1000+H48*100+MAX(E48:E49)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A42=\"\",\"\",A42)","v":""},null,{"$f":"IF(D43<>\"\",D43,0)","v":0},null,{"$f":"IF(D49=0,\" \",C49/D49)","v":" "},{"$f":"IF(G43=\"\",\"\",IF(G43=\"G\",\"P\",IF(G43=\"N\",\"N\",\"G\")))","v":""}]
[]
[null,"1er tour :","La tête de série arbitre les 2 autres joueurs. Les joueurs d'un même club débutent la compétition."]
["POULE DE 3","2ème tour","Le perdant du match précédent joue contre la tête de série."]
[null,"3ème tour ","Le gagnant du premier match joue contre la tête de série."]
["Le joueur qui doit arbitrer peut être remplacé par un autre personne !!!"]

{"sheet":"1 poule de 5 joueurs","index":1,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,2,32,5],[4,6,11,7],[28,3,28,4],[27,0,27,4],[27,5,28,7],[29,0,29,8],[30,1,30,3],[30,5,30,8]]}
[1,2,3,4,5,"places"]
[null,null,null,null,null,"noms"]
[null,null,null,null,null,"licences"]
[null,null,null,null,null,"moyennes"]
[null,null,null,null,null,"POINTS","Remplir les cases jaunes"]
[null,null,null,null,null,"REPRISES"]
[{"$f":"IF(A6=0,\"\",A5/A6)","v":""},{"$f":"IF(B6=0,\"\",B5/B6)","v":""},{"$f":"IF(C6=0,\"\",C5/C6)","v":""},{"$f":"IF(D6=0,\"\",D5/D6)","v":""},{"$f":"IF(E6=0,\"\",E5/E6)","v":""},"MOYENNES",null,null,{"$f":"MAX(A7:E7)","v":0}]
[null,null,null,null,null,"PT MATCH"]
[null,null,null,null,null,"SERIES",null,null,{"$f":"MAX(A9:E9)","v":0}]
[{"$f":"IF(A7=\"\",0,A8*10000+A7*100+A9)","v":0},{"$f":"IF(B7=\"\",0,B8*10000+B7*100+B9)","v":0},{"$f":"IF(C7=\"\",0,C8*10000+C7*100+C9)","v":0},{"$f":"IF(D7=\"\",0,D8*10000+D7*100+D9)","v":0},{"$f":"IF(E7=\"\",0,E8*10000+E7*100+E9)","v":0}]
[{"$f":"IF(A7=\"\",\"\",RANK(A10,$A$10:$E$10))","v":""},{"$f":"IF(B7=\"\",\"\",RANK(B10,$A$10:$E$10))","v":""},{"$f":"IF(C7=\"\",\"\",RANK(C10,$A$10:$E$10))","v":""},{"$f":"IF(D7=\"\",\"\",RANK(D10,$A$10:$E$10))","v":""},{"$f":"IF(E7=\"\",\"\",RANK(E10,$A$10:$E$10))","v":""},"PLACES"]
[{"$f":"IF(A11=\"\",\"\",IF(A11=1,8,IF(A8>=5,8,IF(A8>=4,5,2))))","v":""},{"$f":"IF(B11=\"\",\"\",IF(B11=1,8,IF(B8>=5,8,IF(B8>=4,5,2))))","v":""},{"$f":"IF(C11=\"\",\"\",IF(C11=1,8,IF(C8>=5,8,IF(C8>=4,5,2))))","v":""},{"$f":"IF(D11=\"\",\"\",IF(D11=1,8,IF(D8>=5,8,IF(D8>=4,5,2))))","v":""},{"$f":"IF(E11=\"\",\"\",IF(E11=1,8,IF(E8>=5,8,IF(E8>=4,5,2))))","v":""},"PT RANKING"]
["matchs","résultats","joueurs","points","reprises","série","bille blanche","MG"]
[1,{"$f":"A14&A15&IF(I14=0,\"\",IF(I14>I15,\"G\",\"P\"))","v":"15"},{"$f":"HLOOKUP(A14,$A$1:$E$4,2)","v":0},null,null,null,null,{"$f":"IF(E14=\"\",\"\",D14/E14)","v":""},{"$f":"D14*100+F14*10+G14","v":0},{"$f":"IF(D14=D15,2,IF(D14>D15,3,1))","v":2}]
[5,{"$f":"A14&A15&IF(I15=0,\"\",IF(I15>I14,\"G\",\"P\"))","v":"15"},{"$f":"HLOOKUP(A15,$A$1:$E$4,2)","v":0},null,{"$f":"E14","v":0},null,null,{"$f":"IF(E15=0,\"\",D15/E15)","v":""},{"$f":"D15*100+F15*10+G15","v":0},{"$f":"IF(D14=D15,2,IF(D14>D15,1,3))","v":2}]
[null,null,null,null,null,"mettre 1 pour","celui qui a la ","bille blanche"]
[2,{"$f":"A17&A18&IF(I17=0,\"\",IF(I17>I18,\"G\",\"P\"))","v":"24"},{"$f":"HLOOKUP(A17,$A$1:$E$4,2)","v":0},null,null,null,null,{"$f":"IF(E17=\"\",\"\",D17/E17)","v":""},{"$f":"D17*100+F17*10+G17","v":0},{"$f":"IF(D17=D18,2,IF(D17>D18,3,1))","v":2}]
[4,{"$f":"A17&A18&IF(I18=0,\"\",IF(I18>I17,\"G\",\"P\"))","v":"24"},{"$f":"HLOOKUP(A18,$A$1:$E$4,2)","v":0},null,{"$f":"+E17","v":0},null,null,{"$f":"IF(E18=0,\"\",D18/E18)","v":""},{"$f":"D18*100+F18*10+G18","v":0},{"$f":"IF(D17=D18,2,IF(D17>D18,1,3))","v":2}]
["2ème Tour"]
[{"$f":"15-SUM($A$14:$A$18)","v":3},null,{"$f":"HLOOKUP(A20,$A$1:$E$4,2)","v":0},null,null,null,null,{"$f":"IF(E20=\"\",\"\",D20/E20)","v":""},{"$f":"D20*100+F20*10+G20","v":0},{"$f":"IF(D20=D21,2,IF(D20>D21,3,1))","v":2}]
[{"$f":"$A$17&$A$18&\"G\"","v":"24G"},null,{"$f":"IF(A21=$B$14,$C$14,IF(A21=$B$15,$C$15,IF(A21=$B$17,$C$17,IF(A21=$B$18,$C$18,\"\"))))","v":""},null,{"$f":"+E20","v":0},null,null,{"$f":"IF(E21=0,\"\",D21/E21)","v":""},{"$f":"D21*100+F21*10+G21","v":0},{"$f":"IF(D20=D21,2,IF(D20>D21,1,3))","v":2}]
[]
[{"$f":"$A$14&$A$15&\"G\"","v":"15G"},null,{"$f":"IF(A23=$B$14,$C$14,IF(A23=$B$15,$C$15,IF(A23=$B$17,$C$17,IF(A23=$B$18,$C$18,\"\"))))","v":""},null,null,null,null,{"$f":"IF(E23=\"\",\"\",D23/E23)","v":""},{"$f":"D23*100+F23*10+G23","v":0},{"$f":"IF(D23=D24,2,IF(D23>D24,3,1))","v":2}]
[{"$f":"$A$17&$A$18&\"P\"","v":"24P"},null,{"$f":"IF(A24=$B$14,$C$14,IF(A24=$B$15,$C$15,IF(A24=$B$17,$C$17,IF(A24=$B$18,$C$18,\"\"))))","v":""},null,{"$f":"E23","v":0},null,null,{"$f":"IF(E24=0,\"\",D24/E24)","v":""},{"$f":"D24*100+F24*10+G24","v":0},{"$f":"IF(D23=D24,2,IF(D23>D24,1,3))","v":2}]
["3ème Tour"]
[{"$f":"15-SUM($A$14:$A$18)","v":3},null,{"$f":"HLOOKUP(A26,$A$1:$E$4,2)","v":0},null,null,null,null,{"$f":"IF(E26=\"\",\"\",D26/E26)","v":""},{"$f":"D26*100+F26*10+G26","v":0},{"$f":"IF(D26=D27,2,IF(D26>D27,3,1))","v":2}]
[{"$f":"$A$14&$A$15&\"P\"","v":"15P"},null,{"$f":"IF(A27=$B$14,$C$14,IF(A27=$B$15,$C$15,IF(A27=$B$17,$C$17,IF(A27=$B$18,$C$18,\"\"))))","v":""},null,{"$f":"+E26","v":0},null,null,{"$f":"IF(E27=0,\"\",D27/E27)","v":""},{"$f":"D27*100+F27*10+G27","v":0},{"$f":"IF(D26=D27,2,IF(D26>D27,1,3))","v":2}]
["Accès à FFBSPORTIF",null,null,null,null,{"$f":"'+sieurs Poules de 3 joueurs'!F2:I2","v":"2019-11-12"}]
["libre","cadre","bande","3 bandes"]
["LES RENCONTRES DU CD59 \n(cette feuille doit être imprimée, remplie, signée et archivée dans le club jusqu'à la fin de la saison)"]
["CLUB :",null,null,null,"date :",{"$f":"IF('+sieurs Poules de 3 joueurs'!F2:I2=\"\",\"\",'+sieurs Poules de 3 joueurs'!F2:I2)","v":"2019-11-12"}]
[null,"format des billards  :",null,"3m10","2m80","2m60","Début matchs à 14h30"]
["Discipline ( mode de jeu et catégorie):",null,null,null,null,null,"poule"]

{"sheet":"2 Poules de 2 joueurs","index":2,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,1,1,3],[1,5,1,8],[3,0,3,3],[3,4,4,8],[4,0,5,3],[5,7,5,8],[6,2,6,5],[8,7,9,7],[8,8,9,8],[11,7,12,7],[11,8,12,8],[17,7,18,7],[17,8,18,8],[14,7,15,7],[14,8,15,8]]}
["LES RENCONTRES DU CD59 \n(cette feuille doit être imprimée, remplie, signée et archivée dans le club jusqu'à la fin de la saison)"]
["CLUB :",null,null,null,"date :",{"$f":"IF('+sieurs Poules de 3 joueurs'!F2:I2=\"\",\"\",'+sieurs Poules de 3 joueurs'!F2:I2)","v":"2019-11-12"}]
[null,"format des billards  :",null,"3m10","2m80","2m60","Début des matchs à 14h30"]
["Envoyer cette feuille en pièce jointe aux destinataires ci-dessous (clic)",null,null,null,"il est indispensable d'enregistrer les résultats sur DELPHICENTER en vous aidant des liens ci-dessous (votre club possède une identification). Les résultats pour 2 poules de 2 s'écrivent dans une poule commune."]
[]
[null,null,null,null,"libre","cadre","bande","3 bandes"]
["Discipline ( mode de jeu et catégorie):",null,null,null,null,null,"poule"]
["JOUEUR.Licence","Adversaires","Points réalisés","Reprises","Série","Moyenne","G/P/N",null,"place"]
[null,{"$f":"IF(A12=\"\",\"\",A12)","v":""},null,null,null,{"$f":"IF(D9=\"\",\" \",C9/D9)","v":" "},{"$f":"IF(C9=\"\",\"\",IF(C9>C12,\"G\",IF(C9=C12,\"N\",\"P\")))","v":""},{"$f":"IF((D9+D10)=0,\"\",(C9+C10)/(D9+D10))","v":""},{"$f":"IF(F9=\" \",\"\",IF(A9=\"\",\"\",RANK(J9,MATRICE1)))","v":""},{"$f":"(IF(G9=\"P\",0,IF(G9=\"N\",1,2))+IF(G10=\"P\",0,IF(G10=\"N\",1,2)))*1000+H9*100+MAX(E9:E10)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"IF(D10=\"\",\" \",C10/D10)","v":" "},{"$f":"IF(C10=\"\",\"\",IF(C10>_ADV1,\"G\",IF(C10=_ADV1,\"N\",\"P\")))","v":""}]
[]
[null,{"$f":"IF(A9=\"\",\"\",A9)","v":""},null,{"$f":"D9","v":0},null,{"$f":"IF(D12=0,\" \",C12/D12)","v":" "},{"$f":"IF(G9=\"\",\"\",IF(G9=\"G\",\"P\",IF(G9=\"N\",\"N\",\"G\")))","v":""},{"$f":"IF((D12+D13)=0,\"\",(C12+C13)/(D12+D13))","v":""},{"$f":"IF(F12=\" \",\"\",IF(A12=\"\",\"\",RANK(J12,MATRICE1)))","v":""},{"$f":"(IF(G12=\"P\",0,IF(G12=\"N\",1,2))+IF(G13=\"P\",0,IF(G13=\"N\",1,2)))*1000+H12*100+MAX(E12:E13)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"IF(D13=\"\",\" \",C13/D13)","v":" "},{"$f":"IF(C13=\"\",\"\",IF(C13>_ADV2,\"G\",IF(C13=_ADV2,\"N\",\"P\")))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F14=\" \",\"\",IF(A14=\"\",\"\",RANK(J14,$J$9:$J$19)))","v":""}]
[null,{"$f":"IF(A18=\"\",\"\",A18)","v":""},null,null,null,{"$f":"IF(D15=\"\",\" \",C15/D15)","v":" "},{"$f":"IF(C15=\"\",\"\",IF(C15>C18,\"G\",IF(C15=C18,\"N\",\"P\")))","v":""},{"$f":"IF((D15+D16)=0,\"\",(C15+C16)/(D15+D16))","v":""},{"$f":"IF(F15=\" \",\"\",IF(A15=\"\",\"\",RANK(J15,MATRICE2)))","v":""},{"$f":"(IF(G15=\"P\",0,IF(G15=\"N\",1,2))+IF(G16=\"P\",0,IF(G16=\"N\",1,2)))*1000+H15*100+MAX(E15:E16)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"IF(D16=0,\" \",C16/D16)","v":" "},{"$f":"IF(C16=\"\",\"\",IF(C16>_ADV3,\"G\",IF(C16=_ADV3,\"N\",\"P\")))","v":""}]
[]
[null,{"$f":"IF(A15=\"\",\"\",A15)","v":""},null,{"$f":"D15","v":0},null,{"$f":"IF(D18=0,\" \",C18/D18)","v":" "},{"$f":"IF(G15=\"\",\"\",IF(G15=\"G\",\"P\",IF(G15=\"N\",\"N\",\"G\")))","v":""},{"$f":"IF((D18+D19)=0,\"\",(C18+C19)/(D18+D19))","v":""},{"$f":"IF(F18=\" \",\"\",IF(A18=\"\",\"\",RANK(J18,MATRICE2)))","v":""},{"$f":"(IF(G18=\"P\",0,IF(G18=\"N\",1,2))+IF(G19=\"P\",0,IF(G19=\"N\",1,2)))*1000+H18*100+MAX(E18:E19)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"IF(D19=0,\" \",C19/D19)","v":" "},{"$f":"IF(C19=\"\",\"\",IF(C19>_ADV4,\"G\",IF(C19=_ADV4,\"N\",\"P\")))","v":""}]
[]
[]
[]
[null,"1er tour :","Les joueurs de chaque  poule se rencontrent "]
["2 POULES DE 2","2ème tour","Le gagnant de la poule 1 rencontre le gagnant de la poule 2 sur le billard de la poule 1"]
["prévoir 2 arbitres","ou autoarbitrage si nécessaire","Le perdant de la poule 2 rencontre le perdant de l'autre poule"]

{"sheet":"+sieurs Poules de 2 joueurs","index":3,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,1,1,3],[1,5,1,8],[3,0,3,3],[3,4,4,8],[4,0,5,3],[5,7,5,8],[6,2,6,5],[8,7,9,7],[8,8,9,8],[11,7,12,7],[11,8,12,8],[15,2,15,5],[17,7,18,7],[17,8,18,8],[20,7,21,7],[20,8,21,8],[24,2,24,5],[26,7,27,7],[26,8,27,8],[29,7,30,7],[29,8,30,8],[33,2,33,5],[35,7,36,7],[35,8,36,8],[38,7,39,7],[38,8,39,8]]}
["LES RENCONTRES DU CD59 \n(cette feuille doit être imprimée, remplie, signée et archivée dans le club jusqu'à la fin de la saison)"]
["CLUB :",null,null,null,"date :",{"$f":"IF('+sieurs Poules de 3 joueurs'!F2:I2=\"\",TODAY(),'+sieurs Poules de 3 joueurs'!F2:I2)","v":"2019-11-12"}]
[null,"format des billards  :",null,"3m10","2m80","2m60","Début des matchs à 14h30"]
["Envoyer cette feuille en pièce jointe aux destinataires ci-dessous (clic)",null,null,null,"il est indispensable d'enregistrer les résultats sur DELPHICENTER en vous aidant des liens ci-dessous (votre club possède une identification). Les résultats pour 2 poules de 2 s'écrivent dans une poule commune."]
["s.gauquie@free.fr; andre.desbleumortiers@orange.fr;pierre.reynaert@free.fr"]
[null,null,null,null,"libre","cadre","bande","3 bandes"]
["Discipline ( mode de jeu et catégorie):",null,null,null,null,null,"poule"]
["JOUEUR / Licence","Adversaires","Points réalisés","Reprises","Série","Moyenne","G/P/N",null,"place"]
[null,{"$f":"IF(A12=\"\",\"\",A12)","v":""},null,null,null,{"$f":"IF(D9=\"\",\" \",C9/D9)","v":" "},{"$f":"IF(C9=\"\",\"\",IF(C9>C13,\"G\",IF(C9=C13,\"N\",\"P\")))","v":""},{"$f":"IF((D9+D10)=0,\"\",(C9+C10)/(D9+D10))","v":""},{"$f":"IF(A9=\"\",\"\",RANK(J9,$J$9:$J$14))","v":""},{"$f":"(IF(G9=\"P\",0,IF(G9=\"N\",1,2))+IF(G10=\"P\",0,IF(G10=\"N\",1,2)))*1000+H9*100+MAX(E9:E10)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A12=\"\",\"\",A12)","v":""},null,null,null,{"$f":"IF(D10=\"\",\" \",C10/D10)","v":" "},{"$f":"IF(C10=\"\",\"\",IF(C10>C12,\"G\",IF(C10=C12,\"N\",\"P\")))","v":""}]
[]
[null,{"$f":"IF(A9=\"\",\"\",A9)","v":""},null,{"$f":"IF(D10<>\"\",D10,0)","v":0},null,{"$f":"IF(D12=0,\" \",C12/D12)","v":" "},{"$f":"IF(C12=\"\",\"\",IF(C12>C10,\"G\",IF(C12=C10,\"N\",\"P\")))","v":""},{"$f":"IF((D12+D13)=0,\"\",(C12+C13)/(D12+D13))","v":""},{"$f":"IF(A12=\"\",\"\",RANK(J12,$J$9:$J$14))","v":""},{"$f":"(IF(G12=\"P\",0,IF(G12=\"N\",1,2))+IF(G13=\"P\",0,IF(G13=\"N\",1,2)))*1000+H12*100+MAX(E12:E13)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A9=\"\",\"\",A9)","v":""},null,{"$f":"IF(D9<>\"\",D9,0)","v":0},null,{"$f":"IF(D13=0,\" \",C13/D13)","v":" "},{"$f":"IF(G9=\"\",\"\",IF(G9=\"G\",\"P\",IF(G9=\"N\",\"N\",\"G\")))","v":""}]
[]
[]
["Discipline ( mode de jeu et catégorie):",null,null,null,null,null,"poule"]
["JOUEUR / Licence","Adversaires","Points réalisés","Reprises","Série","Moyenne","G/P/N",null,"place"]
[null,{"$f":"IF(A21=\"\",\"\",A21)","v":""},null,null,null,{"$f":"IF(D18=\"\",\" \",C18/D18)","v":" "},{"$f":"IF(C18=\"\",\"\",IF(C18>C22,\"G\",IF(C18=C22,\"N\",\"P\")))","v":""},{"$f":"IF((D18+D19)=0,\"\",(C18+C19)/(D18+D19))","v":""},{"$f":"IF(A18=\"\",\"\",RANK(J18,$J$18:$J$23))","v":""},{"$f":"(IF(G18=\"P\",0,IF(G18=\"N\",1,2))+IF(G19=\"P\",0,IF(G19=\"N\",1,2)))*1000+H18*100+MAX(E18:E19)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A21=\"\",\"\",A21)","v":""},null,null,null,{"$f":"IF(D19=\"\",\" \",C19/D19)","v":" "},{"$f":"IF(C19=\"\",\"\",IF(C19>C21,\"G\",IF(C19=C21,\"N\",\"P\")))","v":""}]
[]
[null,{"$f":"IF(A18=\"\",\"\",A18)","v":""},null,{"$f":"IF(D19<>\"\",D19,0)","v":0},null,{"$f":"IF(D21=0,\" \",C21/D21)","v":" "},{"$f":"IF(C21=\"\",\"\",IF(C21>C19,\"G\",IF(C21=C19,\"N\",\"P\")))","v":""},{"$f":"IF((D21+D22)=0,\"\",(C21+C22)/(D21+D22))","v":""},{"$f":"IF(A21=\"\",\"\",RANK(J21,$J$18:$J$23))","v":""},{"$f":"(IF(G21=\"P\",0,IF(G21=\"N\",1,2))+IF(G22=\"P\",0,IF(G22=\"N\",1,2)))*1000+H21*100+MAX(E21:E22)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A18=\"\",\"\",A18)","v":""},null,{"$f":"IF(D18<>\"\",D18,0)","v":0},null,{"$f":"IF(D22=0,\" \",C22/D22)","v":" "},{"$f":"IF(G18=\"\",\"\",IF(G18=\"G\",\"P\",IF(G18=\"N\",\"N\",\"G\")))","v":""}]
[]
[]
["Discipline ( mode de jeu et catégorie):",null,null,null,null,null,"poule"]
["JOUEUR / Licence","Adversaires","Points réalisés","Reprises","Série","Moyenne","G/P/N",null,"place"]
[null,{"$f":"IF(A30=\"\",\"\",A30)","v":""},null,null,null,{"$f":"IF(D27=\"\",\" \",C27/D27)","v":" "},{"$f":"IF(C27=\"\",\"\",IF(C27>C31,\"G\",IF(C27=C31,\"N\",\"P\")))","v":""},{"$f":"IF((D27+D28)=0,\"\",(C27+C28)/(D27+D28))","v":""},{"$f":"IF(A27=\"\",\"\",RANK(J27,$J$27:$J$32))","v":""},{"$f":"(IF(G27=\"P\",0,IF(G27=\"N\",1,2))+IF(G28=\"P\",0,IF(G28=\"N\",1,2)))*1000+H27*100+MAX(E27:E28)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A30=\"\",\"\",A30)","v":""},null,null,null,{"$f":"IF(D28=\"\",\" \",C28/D28)","v":" "},{"$f":"IF(C28=\"\",\"\",IF(C28>C30,\"G\",IF(C28=C30,\"N\",\"P\")))","v":""}]
[]
[null,{"$f":"IF(A27=\"\",\"\",A27)","v":""},null,{"$f":"IF(D28<>\"\",D28,0)","v":0},null,{"$f":"IF(D30=0,\" \",C30/D30)","v":" "},{"$f":"IF(C30=\"\",\"\",IF(C30>C28,\"G\",IF(C30=C28,\"N\",\"P\")))","v":""},{"$f":"IF((D30+D31)=0,\"\",(C30+C31)/(D30+D31))","v":""},{"$f":"IF(A30=\"\",\"\",RANK(J30,$J$27:$J$32))","v":""},{"$f":"(IF(G30=\"P\",0,IF(G30=\"N\",1,2))+IF(G31=\"P\",0,IF(G31=\"N\",1,2)))*1000+H30*100+MAX(E30:E31)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A27=\"\",\"\",A27)","v":""},null,{"$f":"IF(D27<>\"\",D27,0)","v":0},null,{"$f":"IF(D31=0,\" \",C31/D31)","v":" "},{"$f":"IF(G27=\"\",\"\",IF(G27=\"G\",\"P\",IF(G27=\"N\",\"N\",\"G\")))","v":""}]
[]
[]
["Discipline ( mode de jeu et catégorie):",null,null,null,null,null,"poule"]
["JOUEUR / Licence","Adversaires","Points réalisés","Reprises","Série","Moyenne","G/P/N",null,"place"]
[null,{"$f":"IF(A39=\"\",\"\",A39)","v":""},null,null,null,{"$f":"IF(D36=\"\",\" \",C36/D36)","v":" "},{"$f":"IF(C36=\"\",\"\",IF(C36>C40,\"G\",IF(C36=C40,\"N\",\"P\")))","v":""},{"$f":"IF((D36+D37)=0,\"\",(C36+C37)/(D36+D37))","v":""},{"$f":"IF(A36=\"\",\"\",RANK(J36,$J$36:$J$41))","v":""},{"$f":"(IF(G36=\"P\",0,IF(G36=\"N\",1,2))+IF(G37=\"P\",0,IF(G37=\"N\",1,2)))*1000+H36*100+MAX(E36:E37)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A39=\"\",\"\",A39)","v":""},null,null,null,{"$f":"IF(D37=\"\",\" \",C37/D37)","v":" "},{"$f":"IF(C37=\"\",\"\",IF(C37>C39,\"G\",IF(C37=C39,\"N\",\"P\")))","v":""}]
[]
[null,{"$f":"IF(A36=\"\",\"\",A36)","v":""},null,{"$f":"IF(D37<>\"\",D37,0)","v":0},null,{"$f":"IF(D39=0,\" \",C39/D39)","v":" "},{"$f":"IF(C39=\"\",\"\",IF(C39>C37,\"G\",IF(C39=C37,\"N\",\"P\")))","v":""},{"$f":"IF((D39+D40)=0,\"\",(C39+C40)/(D39+D40))","v":""},{"$f":"IF(A39=\"\",\"\",RANK(J39,$J$36:$J$41))","v":""},{"$f":"(IF(G39=\"P\",0,IF(G39=\"N\",1,2))+IF(G40=\"P\",0,IF(G40=\"N\",1,2)))*1000+H39*100+MAX(E39:E40)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A36=\"\",\"\",A36)","v":""},null,{"$f":"IF(D36<>\"\",D36,0)","v":0},null,{"$f":"IF(D40=0,\" \",C40/D40)","v":" "},{"$f":"IF(G36=\"\",\"\",IF(G36=\"G\",\"P\",IF(G36=\"N\",\"N\",\"G\")))","v":""}]
[]
[]
[null,"1er tour :","les joueurs se rencontrent 2 fois"]
["1 POULE DE 2","2ème tour","Tirage à la bande pour le point de départ"]
["prévoir 1 arbitre","3ème tour ","pas de troisième tour"]