{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Points","Accueil","Inscrits","1","Final","Classement"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":66,"comments":2,"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":"Points","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Place","R1","D2","D3"]
[1,200,200,200]
[2,180,180,180]
[3,161,161,161]
[4,161,161,161]
[5,143,143,143]
[6,143,143,143]
[7,126,126,126]
[8,126,126,126]
["FNE",-50,-50,-50]
["FE",0,0,0]
["A",0,0,0]

{"sheet":"Accueil","index":1,"n_rows":128,"n_cols":7,"rows_kept":128,"cut":false,"hidden":false,"merged":[[1,2,1,6],[24,3,24,6],[25,3,25,6],[15,2,15,6]]}
["A"]
["F",null,"INFOS UTILES POUR CE TOURNOI"]
[0]
[1,null,"DEPARTEMENT","DROME",null,"SAISON","2009/2010"]
[2]
[3,null,"DATE","2009-10-04",null,"TOURNOI","N°1"]
[4]
[5,null,"CLUB","ABG",null,"DIVISION","D1"]
["A"]
["F",null,"VILLE DU CLUB","Saint Marcel les Valence",null,"NB JOUEURS"]
[0]
[1,null,"Nombre de joueurs\nMontants de Division",0]
[2]
[{"$f":"IF(G18=3,3,\"\")","v":3},null,"Nombre de joueurs\nDescendants de Division",0,null,"Nombre de Billards\n8 Pool"]
["A"]
[0,null,"DISTANCES DES MATCHS"]
[1]
[2,null,"Nb Parties Gagnantes\ndans les Poules\n(côté gagnant)",3,null,"Nb Parties Gagnantes\ndans les Poules\n(côté perdant)",3]
[3]
[{"$f":"IF(D20=4,4,\"\")","v":""}]
[]
["A",null,"Nb Parties Gagnantes\nen 1/2 de finale",4,null,"Nb Parties Gagnantes\nen Finale",5]
[0]
[1]
[2,null,"Nom du fichier des Licenciés","Championnat FFB avec R3.xls"]
[3,null,"Chemin du fichier Licenciés","E:\\FFB\\Logiciel\\Championnat FFB avec R3.xls"]
[{"$f":"IF(G20=4,4,\"\")","v":""}]
[]
["A"]
[0]
[1]
[2]
[3]
[{"$f":"IF(D22=4,4,\"\")","v":4}]
[]
["A"]
[0]
[1]
[2]
[3]
[{"$f":"IF(G22>3,4,\"\")","v":4}]
[{"$f":"IF(G22=5,5,\"\")","v":5}]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
["A"]
["B"]
["C"]
["D"]
["E"]
["F"]
["G"]
["H"]
["I"]
["J"]
["K"]
["L"]
["M"]
["N"]
["O"]
["P"]
["Q"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DAMIENFFB8POOL"]

{"sheet":"Inscrits","index":2,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,11,1,11],[8,11,9,11],[16,11,18,11],[25,11,26,11]]}
["N° Tirage","Nom du Joueur","Classement","Club","N° Licence","Forfait\nNon Excusé","Forfait\nExcusé","Abandon",1,"X",null,1]
[1,"PHONGSY PHOXAY",2,"Billard Club Lyonnais 8 Pool","153152V",null,"-",null,2,"-"]
[2,"FESQUET EMILIE",4,"Billard Club Pontois","156703E",null,"-",null,3]
[3,"GOUTTE LYDIE",5,"Billard Club Pontois","155903K",null,"-",null,4]
[4,"NAVEL ANGELIQUE","NC","Billard Club Pontois","162464R",null,"-",null,5]
[5,"CARDON CECILE","NC","Billard Club Lyonnais 8 Pool","en cours",null,"-",null,6]
[6,"GORGORA JACKIE","NC","Billard Club Lyonnais 8 Pool","162474C",null,"-",null,7]
[7,"CHAMONAZ VANESSA","NC","Billard Club Pontois","100904Y",null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"OU"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,#REF!,3,FALSE))","v":""},null,null,null,null,null,null,null,null,3]
[null,null,{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B13=\"\",\"\",VLOOKUP(B13,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B14=\"\",\"\",VLOOKUP(B14,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B15=\"\",\"\",VLOOKUP(B15,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B16=\"\",\"\",VLOOKUP(B16,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B17=\"\",\"\",VLOOKUP(B17,#REF!,3,FALSE))","v":""}]

{"sheet":"1","index":3,"n_rows":21,"n_cols":45,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,9,20,17],[12,1,12,2],[0,9,0,17],[1,42,1,45],[11,42,11,45],[10,20,10,21]]}
[null,null,null,null,null,null,null,null,null,"MATCHS EN 3 PARTIES GAGNANTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUALIFIES"]
[null,null,null,null,null,null,null,null,null,null,"P1",1,{"$f":"IF(IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L3,Inscrits!$A$2:$C$24,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L3,Inscrits!$A$2:$C$24,2,FALSE)))","v":"PHONGSY PHOXAY"},{"$f":"IF(IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L3,Inscrits!$A$2:$C$24,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L3,Inscrits!$A$2:$C$24,3,FALSE))&\")\"))","v":"(2)"},null,null,"G1",null,null,null,null,null,null,null,null,null,null,null,"G","P","G","P","G","P","G","P","G","P","G","P","Ga",null,null,"NOM","Ga"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Match 1 - Billard",null,null,null,{"$f":"M3","v":"PHONGSY PHOXAY"},{"$f":"N3","v":"(2)"},null,null,null,null,null,null,1,{"$f":"IF(U6=\"\",\"\",IF(U6=Q4,Q4,Q8))","v":""},null,{"$f":"M3","v":"PHONGSY PHOXAY"},{"$f":"IF(AB4=M3,IF(O5=\"F\",\"\",O3),0)","v":0},{"$f":"IF(AB4=M3,IF(O3=\"F\",\"\",O5),0)","v":0},{"$f":"IF(AB4=Q4,IF(S8=\"F\",\"\",S4),0)","v":0},{"$f":"IF(AB4=Q4,IF(S4=\"F\",\"\",S8),0)","v":0},{"$f":"IF(AB4=J4,IF(I8=\"F\",\"\",I4),0)","v":0},{"$f":"IF(AB4=J4,IF(I4=\"F\",\"\",I8),0)","v":0},{"$f":"IF(AB4=F6,IF(E10=\"F\",\"\",E6),0)","v":0},{"$f":"IF(AB4=F6,IF(E6=\"F\",\"\",E10),0)","v":0},{"$f":"IF(AB4=F20,IF(E16=\"F\",\"\",E20),0)","v":0},{"$f":"IF(AB4=F20,IF(E20=\"F\",\"\",E16),0)","v":0},{"$f":"SUM(AC4,AE4,AG4,AI4,AK4)","v":0},0,{"$f":"AM4-AN4","v":0},null,null,{"$f":"Z4","v":""},{"$f":"IF(AR4=\"\",\"\",(VLOOKUP(AR4,AB4:AO17,14,FALSE)))","v":""}]
[null,null,null,null,null,null,"G7",null,null,null,null,null,null,null,null,null,null,null,null,null,"G5",null,null,null,3,{"$f":"IF(B8=\"\",\"\",IF(B8=F6,F6,F10))","v":""},null,{"$f":"M5","v":0},{"$f":"IF(AB5=M5,IF(O3=\"F\",\"\",O5),0)","v":0},{"$f":"IF(AB5=M5,IF(O5=\"F\",\"\",O3),0)","v":0},{"$f":"IF(AB5=Q4,IF(S8=\"F\",\"\",S4),0)","v":0},{"$f":"IF(AB5=Q4,IF(S4=\"F\",\"\",S8),0)","v":0},{"$f":"IF(AB5=J4,IF(I8=\"F\",\"\",I4),0)","v":0},{"$f":"IF(AB5=J4,IF(I4=\"F\",\"\",I8),0)","v":0},{"$f":"IF(AB5=F6,IF(E10=\"F\",\"\",E6),0)","v":0},{"$f":"IF(AB5=F6,IF(E6=\"F\",\"\",E10),0)","v":0},{"$f":"IF(AB5=F20,IF(E16=\"F\",\"\",E20),0)","v":0},{"$f":"IF(AB5=F20,IF(E20=\"F\",\"\",E16),0)","v":0},0,0,{"$f":"AM5-AN5","v":0},null,null,{"$f":"Z14","v":""},{"$f":"IF(AR5=\"\",\"\",(VLOOKUP(AR5,AB4:AO17,14,FALSE)))","v":""}]
[null,null,null,null,null,{"$f":"J8","v":""},{"$f":"K8","v":""},null,null,"Match 7 - Billard",null,null,null,null,null,null,"Match 5 - Billard",null,null,null,{"$f":"IF(OR(S4=\"F\",S4=\"A\"),Q8,IF(OR(S8=\"F\",S8=\"A\"),Q4,IF(S4=S8,\"\",(IF(S4>S8,Q4,Q8)))))","v":""},{"$f":"IF(OR(S4=\"F\",S4=\"A\"),R8,IF(OR(S8=\"F\",S8=\"A\"),R4,IF(S4=S8,\"\",(IF(S4>S8,R4,R8)))))","v":""},"A",null,5,{"$f":"IF(B8=\"\",\"\",IF(B8=F6,F10,F6))","v":""},null,{"$f":"M7","v":"CARDON CECILE"},{"$f":"IF(AB6=M7,IF(O9=\"F\",\"\",O7),0)","v":0},{"$f":"IF(AB6=M7,IF(O7=\"F\",\"\",O9),0)","v":0},{"$f":"IF(AB6=Q8,IF(S4=\"F\",\"\",S8),0)","v":0},{"$f":"IF(AB6=Q8,IF(S8=\"F\",\"\",S4),0)","v":0},{"$f":"IF(AB6=J8,IF(I4=\"F\",\"\",I8),0)","v":0},{"$f":"IF(AB6=J8,IF(I8=\"F\",\"\",I4),0)","v":0},{"$f":"IF(AB6=F6,IF(E10=\"F\",\"\",E6),0)","v":0},{"$f":"IF(AB6=F6,IF(E6=\"F\",\"\",E10),0)","v":0},{"$f":"IF(AB6=F20,IF(E16=\"F\",\"\",E20),0)","v":0},{"$f":"IF(AB6=F20,IF(E20=\"F\",\"\",E16),0)","v":0},0,0,{"$f":"AM6-AN6","v":0},null,null,{"$f":"Z5","v":""},{"$f":"IF(AR6=\"\",\"\",(VLOOKUP(AR6,AB4:AO17,14,FALSE)))","v":""}]
[null,null,"G9",null,null,null,null,null,null,null,null,5,{"$f":"IF(IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L7,Inscrits!$A$2:$C$24,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L7,Inscrits!$A$2:$C$24,2,FALSE)))","v":"CARDON CECILE"},{"$f":"IF(IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L7,Inscrits!$A$2:$C$24,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L7,Inscrits!$A$2:$C$24,3,FALSE))&\")\"))","v":"(NC)"},null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(F6=\"\",\"\",IF(F6=J4,J8,J4))","v":""},null,{"$f":"M9","v":"NAVEL ANGELIQUE"},{"$f":"IF(AB7=M9,IF(O7=\"F\",\"\",O9),0)","v":0},{"$f":"IF(AB7=M9,IF(O9=\"F\",\"\",O7),0)","v":0},{"$f":"IF(AB7=Q8,IF(S4=\"F\",\"\",S8),0)","v":0},{"$f":"IF(AB7=Q8,IF(S8=\"F\",\"\",S4),0)","v":0},{"$f":"IF(AB7=J8,IF(I4=\"F\",\"\",I8),0)","v":0},{"$f":"IF(AB7=J8,IF(I8=\"F\",\"\",I4),0)","v":0},{"$f":"IF(AB7=F6,IF(E10=\"F\",\"\",E6),0)","v":0},{"$f":"IF(AB7=F6,IF(E6=\"F\",\"\",E10),0)","v":0},{"$f":"IF(AB7=F20,IF(E16=\"F\",\"\",E20),0)","v":0},{"$f":"IF(AB7=F20,IF(E20=\"F\",\"\",E16),0)","v":0},0,0,{"$f":"AM7-AN7","v":0},null,null,{"$f":"Z15","v":""},{"$f":"IF(AR7=\"\",\"\",(VLOOKUP(AR7,AB4:AO17,14,FALSE)))","v":""}]
["S",{"$f":"IF(OR(E6=\"F\",E6=\"A\"),F10,IF(OR(E10=\"F\",E10=\"A\"),F6,IF(E6=E10,\"\",(IF(E6>E10,F6,F10)))))","v":""},{"$f":"IF(OR(E6=\"F\",E6=\"A\"),G10,IF(OR(E10=\"F\",E10=\"A\"),G6,IF(E6=E10,\"\",(IF(E6>E10,G6,G10)))))","v":""},null,null,"Match 9 - Billard",null,null,null,{"$f":"IF(OR(AND(O7=\"F\",O9=\"F\"),AND(O7=\"A\",O9=\"A\")),M9,IF(OR(O7=\"F\",O7=\"A\"),M7,IF(OR(O9=\"F\",O9=\"A\"),M9,IF(O7=O9,\"\",(IF(O7<O9,M7,M9))))))","v":""},{"$f":"IF(OR(AND(O7=\"F\",O9=\"F\"),AND(O7=\"A\",O9=\"A\")),N9,IF(OR(O7=\"F\",O7=\"A\"),N7,IF(OR(O9=\"F\",O9=\"A\"),N9,IF(O7=O9,\"\",(IF(O7<O9,N7,N9))))))","v":""},null,"Match 2 - Billard",null,null,null,{"$f":"IF(OR(AND(O7=\"F\",O9=\"F\"),AND(O7=\"A\",O9=\"A\")),M7,IF(OR(O7=\"F\",O7=\"A\"),M9,IF(OR(O9=\"F\",O9=\"A\"),M7,IF(O7=O9,\"\",(IF(O7>O9,M7,M9))))))","v":""},{"$f":"IF(OR(AND(O7=\"F\",O9=\"F\"),AND(O7=\"A\",O9=\"A\")),N7,IF(OR(O7=\"F\",O7=\"A\"),N9,IF(OR(O9=\"F\",O9=\"A\"),N7,IF(O7=O9,\"\",(IF(O7>O9,N7,N9))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"P2",4,{"$f":"IF(IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L9,Inscrits!$A$2:$C$24,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L9,Inscrits!$A$2:$C$24,2,FALSE)))","v":"NAVEL ANGELIQUE"},{"$f":"IF(IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L9,Inscrits!$A$2:$C$24,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L9,Inscrits!$A$2:$C$24,3,FALSE))&\")\"))","v":"(NC)"},null,null,"G2"]
[null,null,null,null,null,{"$f":"IF(OR(S14=\"F\",S14=\"A\"),Q14,IF(OR(S18=\"F\",S18=\"A\"),Q18,IF(S14=S18,\"\",(IF(S14<S18,Q14,Q18)))))","v":""},{"$f":"IF(OR(S14=\"F\",S14=\"A\"),R14,IF(OR(S18=\"F\",S18=\"A\"),R18,IF(S14=S18,\"\",(IF(S14<S18,R14,R18)))))","v":""}]
[null,null,null,null,null,null,"P6",null,null,null,null,null,null,null,null,null,null,null,null,null,"QUALIFIES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELIMINES"]
[null,"QUALIFIES",null,null,null,null,null,null,null,null,"P3",3,{"$f":"IF(IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L13,Inscrits!$A$2:$C$24,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L13,Inscrits!$A$2:$C$24,2,FALSE)))","v":"GOUTTE LYDIE"},{"$f":"IF(IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L13,Inscrits!$A$2:$C$24,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L13,Inscrits!$A$2:$C$24,3,FALSE))&\")\"))","v":"(5)"},null,null,"G3",null,null,null,null,null,null,null,null,null,null,null,"G","P","G","P","G","P","G","P","G","P","G","P","Ga",null,null,"NOM","Ga"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(O13=\"F\",O15=\"F\"),AND(O13=\"A\",O15=\"A\")),M15,IF(OR(O13=\"F\",O13=\"A\"),M13,IF(OR(O15=\"F\",O15=\"A\"),M15,IF(O13=O15,\"\",(IF(O13<O15,M13,M15))))))","v":""},{"$f":"IF(OR(AND(O13=\"F\",O15=\"F\"),AND(O13=\"A\",O15=\"A\")),N15,IF(OR(O13=\"F\",O13=\"A\"),N13,IF(OR(O15=\"F\",O15=\"A\"),N15,IF(O13=O15,\"\",(IF(O13<O15,N13,N15))))))","v":""},null,"Match 3 - Billard",null,null,null,{"$f":"IF(OR(AND(O13=\"F\",O15=\"F\"),AND(O13=\"A\",O15=\"A\")),M13,IF(OR(O13=\"F\",O13=\"A\"),M15,IF(OR(O15=\"F\",O15=\"A\"),M13,IF(O13=O15,\"\",(IF(O13>O15,M13,M15))))))","v":""},{"$f":"IF(OR(AND(O13=\"F\",O15=\"F\"),AND(O13=\"A\",O15=\"A\")),N13,IF(OR(O13=\"F\",O13=\"A\"),N15,IF(OR(O15=\"F\",O15=\"A\"),N13,IF(O13=O15,\"\",(IF(O13>O15,N13,N15))))))","v":""},null,null,null,null,null,null,2,{"$f":"IF(U16=\"\",\"\",IF(U16=Q14,Q14,Q18))","v":""},null,{"$f":"M13","v":"GOUTTE LYDIE"},{"$f":"IF(AB14=M13,IF(O15=\"F\",\"\",O13),0)","v":0},{"$f":"IF(AB14=M13,IF(O13=\"F\",\"\",O15),0)","v":0},{"$f":"IF(AB14=Q14,IF(S18=\"F\",\"\",S14),0)","v":0},{"$f":"IF(AB14=Q14,IF(S14=\"F\",\"\",S18),0)","v":0},{"$f":"IF(AB14=J14,IF(I18=\"F\",\"\",I14),0)","v":0},{"$f":"IF(AB14=J14,IF(I14=\"F\",\"\",I18),0)","v":0},{"$f":"IF(AB14=F16,IF(E20=\"F\",\"\",E16),0)","v":0},{"$f":"IF(AB14=F16,IF(E16=\"F\",\"\",E20),0)","v":0},{"$f":"IF(AB14=F10,IF(E6=\"F\",\"\",E10),0)","v":0},{"$f":"IF(AB14=F10,IF(E10=\"F\",\"\",E6),0)","v":0},{"$f":"SUM(AC14,AE14,AG14,AI14,AK14)","v":0},0,{"$f":"AM14-AN14","v":0},null,null,{"$f":"Z6","v":""},{"$f":"IF(AR14=\"\",\"\",(VLOOKUP(AR14,AB4:AO17,14,FALSE)))","v":""}]
[null,null,null,null,null,null,"G8",null,null,null,null,6,{"$f":"IF(IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L15,Inscrits!$A$2:$C$24,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L15,Inscrits!$A$2:$C$24,2,FALSE)))","v":"GORGORA JACKIE"},{"$f":"IF(IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L15,Inscrits!$A$2:$C$24,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L15,Inscrits!$A$2:$C$24,3,FALSE))&\")\"))","v":"(NC)"},null,null,null,null,null,null,"G6",null,null,null,4,{"$f":"IF(B18=\"\",\"\",IF(B18=F16,F16,F20))","v":""},null,{"$f":"M15","v":"GORGORA JACKIE"},{"$f":"IF(AB15=M15,IF(O13=\"F\",\"\",O15),0)","v":0},{"$f":"IF(AB15=M15,IF(O15=\"F\",\"\",O13),0)","v":0},{"$f":"IF(AB15=Q14,IF(S18=\"F\",\"\",S14),0)","v":0},{"$f":"IF(AB15=Q14,IF(S14=\"F\",\"\",S18),0)","v":0},{"$f":"IF(AB15=J14,IF(I18=\"F\",\"\",I14),0)","v":0},{"$f":"IF(AB15=J14,IF(I14=\"F\",\"\",I18),0)","v":0},{"$f":"IF(AB15=F16,IF(E20=\"F\",\"\",E16),0)","v":0},{"$f":"IF(AB15=F16,IF(E16=\"F\",\"\",E20),0)","v":0},{"$f":"IF(AB15=F10,IF(E6=\"F\",\"\",E10),0)","v":0},{"$f":"IF(AB15=F10,IF(E10=\"F\",\"\",E6),0)","v":0},0,0,{"$f":"AM15-AN15","v":0},null,null,{"$f":"Z16","v":""},{"$f":"IF(AR15=\"\",\"\",(VLOOKUP(AR15,AB4:AO17,14,FALSE)))","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(I14=\"F\",I14=\"A\"),J18,IF(OR(I18=\"F\",I18=\"A\"),J14,IF(I14=I18,\"\",(IF(I14>I18,J14,J18)))))","v":""},{"$f":"IF(OR(I14=\"F\",I14=\"A\"),K18,IF(OR(I18=\"F\",I18=\"A\"),K14,IF(I14=I18,\"\",(IF(I14>I18,K14,K18)))))","v":""},null,null,"Match 8 - Billard",null,null,null,null,null,null,"Match 6 - Billard",null,null,null,{"$f":"IF(OR(S14=\"F\",S14=\"A\"),Q18,IF(OR(S18=\"F\",S18=\"A\"),Q14,IF(S14=S18,\"\",(IF(S14>S18,Q14,Q18)))))","v":""},{"$f":"IF(OR(S14=\"F\",S14=\"A\"),R18,IF(OR(S18=\"F\",S18=\"A\"),R14,IF(S14=S18,\"\",(IF(S14>S18,R14,R18)))))","v":""},"B",null,6,{"$f":"IF(B18=\"\",\"\",IF(B18=F16,F20,F16))","v":""},null,{"$f":"M17","v":"CHAMONAZ VANESSA"},{"$f":"IF(AB16=M17,IF(O19=\"F\",\"\",O17),0)","v":0},{"$f":"IF(AB16=M17,IF(O17=\"F\",\"\",O19),0)","v":0},{"$f":"IF(AB16=Q18,IF(S14=\"F\",\"\",S18),0)","v":0},{"$f":"IF(AB16=Q18,IF(S18=\"F\",\"\",S14),0)","v":0},{"$f":"IF(AB16=J18,IF(I14=\"F\",\"\",I18),0)","v":0},{"$f":"IF(AB16=J18,IF(I18=\"F\",\"\",I14),0)","v":0},{"$f":"IF(AB16=F16,IF(E20=\"F\",\"\",E16),0)","v":0},{"$f":"IF(AB16=F16,IF(E16=\"F\",\"\",E20),0)","v":0},{"$f":"IF(AB16=F10,IF(E6=\"F\",\"\",E10),0)","v":0},{"$f":"IF(AB16=F10,IF(E10=\"F\",\"\",E6),0)","v":0},0,0,{"$f":"AM16-AN16","v":0},null,null,{"$f":"Z17","v":""},{"$f":"IF(AR16=\"\",\"\",(VLOOKUP(AR16,AB4:AO17,14,FALSE)))","v":""}]
[null,null,"G10",null,null,null,null,null,null,null,null,7,{"$f":"IF(IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L17,Inscrits!$A$2:$C$24,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L17,Inscrits!$A$2:$C$24,2,FALSE)))","v":"CHAMONAZ VANESSA"},{"$f":"IF(IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L17,Inscrits!$A$2:$C$24,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L17,Inscrits!$A$2:$C$24,3,FALSE))&\")\"))","v":"(NC)"},null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF(F16=\"\",\"\",IF(F16=J14,J18,J14))","v":""},null,{"$f":"M19","v":"FESQUET EMILIE"},{"$f":"IF(AB17=M19,IF(O17=\"F\",\"\",O19),0)","v":0},{"$f":"IF(AB17=M19,IF(O19=\"F\",\"\",O17),0)","v":0},{"$f":"IF(AB17=Q18,IF(S14=\"F\",\"\",S18),0)","v":0},{"$f":"IF(AB17=Q18,IF(S18=\"F\",\"\",S14),0)","v":0},{"$f":"IF(AB17=J18,IF(I14=\"F\",\"\",I18),0)","v":0},{"$f":"IF(AB17=J18,IF(I18=\"F\",\"\",I14),0)","v":0},{"$f":"IF(AB17=F16,IF(E20=\"F\",\"\",E16),0)","v":0},{"$f":"IF(AB17=F16,IF(E16=\"F\",\"\",E20),0)","v":0},{"$f":"IF(AB17=F10,IF(E6=\"F\",\"\",E10),0)","v":0},{"$f":"IF(AB17=F10,IF(E10=\"F\",\"\",E6),0)","v":0},0,{"$f":"SUM(AD17,AF17,AH17,AJ17,AL17)","v":0},{"$f":"AM17-AN17","v":0}]
["T",{"$f":"IF(OR(E16=\"F\",E16=\"A\"),F20,IF(OR(E20=\"F\",E20=\"A\"),F16,IF(E16=E20,\"\",(IF(E16>E20,F16,F20)))))","v":""},{"$f":"IF(OR(E16=\"F\",E16=\"A\"),G20,IF(OR(E20=\"F\",E20=\"A\"),G16,IF(E16=E20,\"\",(IF(E16>E20,G16,G20)))))","v":""},null,null,"Match 10 - Billard",null,null,null,{"$f":"IF(OR(AND(O17=\"F\",O19=\"F\"),AND(O17=\"A\",O19=\"A\")),M19,IF(OR(O17=\"F\",O17=\"A\"),M17,IF(OR(O19=\"F\",O19=\"A\"),M19,IF(O17=O19,\"\",(IF(O17<O19,M17,M19))))))","v":""},{"$f":"IF(OR(AND(O17=\"F\",O19=\"F\"),AND(O17=\"A\",O19=\"A\")),N19,IF(OR(O17=\"F\",O17=\"A\"),N17,IF(OR(O19=\"F\",O19=\"A\"),N19,IF(O17=O19,\"\",(IF(O17<O19,N17,N19))))))","v":""},null,"Match 4 - Billard",null,null,null,{"$f":"IF(OR(AND(O17=\"F\",O19=\"F\"),AND(O17=\"A\",O19=\"A\")),M17,IF(OR(O17=\"F\",O17=\"A\"),M19,IF(OR(O19=\"F\",O19=\"A\"),M17,IF(O17=O19,\"\",(IF(O17>O19,M17,M19))))))","v":""},{"$f":"IF(OR(AND(O17=\"F\",O19=\"F\"),AND(O17=\"A\",O19=\"A\")),N17,IF(OR(O17=\"F\",O17=\"A\"),N19,IF(OR(O19=\"F\",O19=\"A\"),N17,IF(O17=O19,\"\",(IF(O17>O19,N17,N19))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"P4",2,{"$f":"IF(IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L19,Inscrits!$A$2:$C$24,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$24,2,FALSE)),\"\",VLOOKUP(L19,Inscrits!$A$2:$C$24,2,FALSE)))","v":"FESQUET EMILIE"},{"$f":"IF(IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L19,Inscrits!$A$2:$C$24,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$24,3,FALSE)),\"\",\"(\"&(VLOOKUP(L19,Inscrits!$A$2:$C$24,3,FALSE))&\")\"))","v":"(4)"},null,null,"G4"]
[null,null,null,null,null,{"$f":"IF(OR(S4=\"F\",S4=\"A\"),Q4,IF(OR(S8=\"F\",S8=\"A\"),Q8,IF(S4=S8,\"\",(IF(S4<S8,Q4,Q8)))))","v":""},{"$f":"IF(OR(S4=\"F\",S4=\"A\"),R4,IF(OR(S8=\"F\",S8=\"A\"),R8,IF(S4=S8,\"\",(IF(S4<S8,R4,R8)))))","v":""}]
[null,null,null,null,null,null,"P5",null,null,{"$f":"IF(Accueil!G18=3,\"\",\"MATCHS EN 2 GAGNANTES COTE PERDANT\")","v":""}]

{"sheet":"Final","index":4,"n_rows":24,"n_cols":35,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,5,1,7],[1,9,1,11],[1,13,1,15],[0,1,0,3],[1,1,1,3],[0,13,0,15],[0,9,0,11],[0,5,0,7]]}
[null,"1/8 de finale",null,null,null,"1/4 de finale",null,null,null,"1/2 finale",null,null,null,"Finale"]
[null,{"$f":"\"(\"&Accueil!D20&\" manches)\"","v":"( manches)"},null,null,null,{"$f":"\"(\"&Accueil!G20&\" manches)\"","v":"( manches)"},null,null,null,{"$f":"\"(\"&Accueil!D22&\" manches)\"","v":"(4 manches)"},null,null,null,{"$f":"\"(\"&Accueil!G22&\" manches)\"","v":"(5 manches)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOUEURS","1/8","1/4","1/2","Finale","GA Final",null,"JOUEURS","GA Poules",null,"JOUEURS","GA Poules","GA Final","GA TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J6","v":""},null,null,{"$f":"IF(AND(L6=\"A\",L12=\"A\"),0,IF(L6=\"A\",-L12,IF(L12=\"A\",L6,L6-L12)))","v":0},{"$f":"IF(N9=V4,IF(AND(P9=\"A\",P21=\"A\"),0,IF(OR(Y4>0,L12=\"A\"),IF(P9=\"A\",-P21,IF(P21=\"A\",P9,P9-P21)),0)),0)","v":0},{"$f":"SUM(W4:Z4)","v":0},null,{"$f":"'1'!AR4","v":""},{"$f":"'1'!AS4","v":""},null,{"$f":"IF(Inscrits!B2=0,\"\",Inscrits!B2)","v":"PHONGSY PHOXAY"},{"$f":"VLOOKUP(AF4,$AC$4:$AD$11,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AF4,$V$4:$AA$23,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"AG4+AH4","v":{"$error":"#N/A"}}]
[null,null,null,null,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":"'1'!AR5","v":""},{"$f":"'1'!AS5","v":""},null,{"$f":"IF(Inscrits!B3=0,\"\",Inscrits!B3)","v":"FESQUET EMILIE"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('1'!U6=0,\"\",'1'!U6)","v":""},{"$f":"IF('1'!V6=0,\"\",'1'!V6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1'!AR6","v":""},{"$f":"'1'!AS6","v":""},null,{"$f":"IF(Inscrits!B4=0,\"\",Inscrits!B4)","v":"GOUTTE LYDIE"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1'!AR7","v":""},{"$f":"'1'!AS7","v":""},null,{"$f":"IF(Inscrits!B5=0,\"\",Inscrits!B5)","v":"NAVEL ANGELIQUE"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1'!AR14","v":""},{"$f":"'1'!AS14","v":""},null,{"$f":"IF(Inscrits!B6=0,\"\",Inscrits!B6)","v":"CARDON CECILE"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"Match 1 - Billard",null,null,null,{"$f":"IF(AND(L6=\"A\",L12=\"A\"),J6,IF(L6=\"A\",J12,IF(L12=\"A\",J6,IF(L6=L12,\"\",(IF(L6>L12,J6,J12))))))","v":""},{"$f":"IF(AND(L6=\"A\",L12=\"A\"),K6,IF(L6=\"A\",K12,IF(L12=\"A\",K6,IF(L6=L12,\"\",(IF(L6>L12,K6,K12))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1'!AR15","v":""},{"$f":"'1'!AS15","v":""},null,{"$f":"IF(Inscrits!B7=0,\"\",Inscrits!B7)","v":"GORGORA JACKIE"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J12","v":""},null,null,{"$f":"IF(AND(L6=\"A\",L12=\"A\"),0,IF(L6=\"A\",L12,IF(L12=\"A\",-L6,L12-L6)))","v":0},{"$f":"IF(N9=V10,IF(AND(P9=\"A\",P21=\"A\"),0,IF(OR(Y10>0,L6=\"A\"),IF(P9=\"A\",-P21,IF(P21=\"A\",P9,P9-P21)),0)),0)","v":0},{"$f":"SUM(W10:Z10)","v":0},null,{"$f":"'1'!AR16","v":""},{"$f":"'1'!AS16","v":""},null,{"$f":"IF(Inscrits!B8=0,\"\",Inscrits!B8)","v":"CHAMONAZ VANESSA"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1'!AR17","v":0},{"$f":"'1'!AS17","v":0},null,{"$f":"IF(Inscrits!#REF!=0,\"\",Inscrits!#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('1'!B8=0,\"\",'1'!B8)","v":""},{"$f":"IF('1'!C8=0,\"\",'1'!C8)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J18","v":""},null,null,{"$f":"IF(AND(L18=\"A\",L24=\"A\"),0,IF(L18=\"A\",-L24,IF(L18=\"A\",L24,L18-L24)))","v":0},{"$f":"IF(N21=V13,IF(AND(P9=\"A\",P21=\"A\"),0,IF(OR(Y13>0,L24=\"A\"),IF(P21=\"A\",-P9,IF(P9=\"A\",P21,P21-P9)),0)),0)","v":0},{"$f":"SUM(W13:Z13)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Match 3 - Billard",null,null,null,{"$f":"IF(AND(P9=\"A\",P21=\"A\"),N9,IF(P9=\"A\",N21,IF(P21=\"A\",N9,IF(P9=P21,\"\",(IF(P9>P21,N9,N21))))))","v":""},{"$f":"IF(AND(P9=\"F\",P21=\"F\"),O9,IF(P9=\"F\",O21,IF(P21=\"F\",O9,IF(P9=P21,\"\",(IF(P9>P21,O9,O21))))))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('1'!U16=0,\"\",'1'!U16)","v":""},{"$f":"IF('1'!V16=0,\"\",'1'!V16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J24","v":""},null,null,{"$f":"IF(AND(L18=\"A\",L24=\"A\"),0,IF(L18=\"A\",L24,IF(L18=\"A\",-L24,L24-L18)))","v":0},{"$f":"IF(N21=V19,IF(AND(P9=\"A\",P21=\"A\"),0,IF(OR(Y19>0,L18=\"A\"),IF(P21=\"A\",-P9,IF(P9=\"A\",P21,P21-P9)),0)),0)","v":0},{"$f":"SUM(W19:Z19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1'!AR14","v":""},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Match 2 - Billard",null,null,null,{"$f":"IF(AND(L18=\"A\",L24=\"A\"),J18,IF(L18=\"A\",J24,IF(L24=\"A\",J18,IF(L18=L24,\"\",(IF(L18>L24,J18,J24))))))","v":""},{"$f":"IF(AND(L18=\"A\",L24=\"A\"),K18,IF(L18=\"A\",K24,IF(L24=\"A\",K18,IF(L18=L24,\"\",(IF(L18>L24,K18,K24))))))","v":""},null,null,null,null,null,null,{"$f":"'1'!AR15","v":""},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1'!AR16","v":""},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1'!AR17","v":0},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('1'!B18=0,\"\",'1'!B18)","v":""},{"$f":"IF('1'!C18=0,\"\",'1'!C18)","v":""}]

{"sheet":"Classement","index":5,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,"Formules Initiales","Nom & Prénom","Place","Points","GA","Club","Ville","Licence","Division"]
[null,null,1,{"$f":"Final!R15","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E2,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E2,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E2,Points!$A$2:$D$12,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E2,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E2,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E2,Points!$A$2:$D$12,4,FALSE),\"DIV ???\"))))","v":"DIV ???"},{"$f":"IF(ISERROR(VLOOKUP(D2,Final!$AF$4:$AI$11,4,FALSE)),\"\",VLOOKUP(D2,Final!$AF$4:$AI$11,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D2,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D2,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D2,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D2,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D2,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D2,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_UP>0,IF(LEN(Division)=2,\"R\"&RIGHT(Division,1)-1&\"\",IF(LEN(Division)=3,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",IF(Nb_R2=1,\"R2\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(Division,1)&\"\")),IF(LEN(Division)=4,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(LEFT(Division,3),1)&\"\"),\"?\"))),Division)","v":"D1"}]
[null,null,2,{"$f":"IF(Final!P21=\"A\",Final!N21,IF(Final!P9=\"A\",Final!N9,IF(Final!P9<Final!P21,Final!N9,Final!N21)))","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E3,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E3,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E3,Points!$A$2:$D$12,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E3,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E3,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E3,Points!$A$2:$D$12,4,FALSE),\"DIV ???\"))))","v":"DIV ???"},{"$f":"IF(ISERROR(VLOOKUP(D3,Final!$AF$4:$AI$11,4,FALSE)),\"\",VLOOKUP(D3,Final!$AF$4:$AI$11,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D3,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D3,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D3,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D3,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D3,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D3,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_UP>1,IF(LEN(Division)=2,\"R\"&RIGHT(Division,1)-1&\"\",IF(LEN(Division)=3,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",IF(Nb_R2=1,\"R2\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(Division,1)&\"\")),IF(LEN(Division)=4,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(LEFT(Division,3),1)&\"\"),\"?\"))),Division)","v":"D1"}]
[null,null,3,{"$f":"IF(Final!L12=\"A\",Final!J12,IF(Final!L6=\"A\",Final!J6,IF(Final!L6<Final!L12,Final!J6,Final!J12)))","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E4,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E4,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E4,Points!$A$2:$D$12,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E4,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E4,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E4,Points!$A$2:$D$12,4,FALSE),\"DIV ???\"))))","v":"DIV ???"},{"$f":"IF(ISERROR(VLOOKUP(D4,Final!$AF$4:$AI$11,4,FALSE)),\"\",VLOOKUP(D4,Final!$AF$4:$AI$11,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D4,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D4,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D4,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D4,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D4,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D4,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_UP>2,IF(LEN(Division)=2,\"R\"&RIGHT(Division,1)-1&\"\",IF(LEN(Division)=3,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",IF(Nb_R2=1,\"R2\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(Division,1)&\"\")),IF(LEN(Division)=4,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(LEFT(Division,3),1)&\"\"),\"?\"))),Division)","v":"D1"}]
[null,null,4,{"$f":"IF(Final!L24=\"A\",Final!J24,IF(Final!L18=\"A\",Final!J18,IF(Final!L18<Final!L24,Final!J18,Final!J24)))","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E5,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E5,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E5,Points!$A$2:$D$12,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E5,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E5,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E5,Points!$A$2:$D$12,4,FALSE),\"DIV ???\"))))","v":"DIV ???"},{"$f":"IF(ISERROR(VLOOKUP(D5,Final!$AF$4:$AI$11,4,FALSE)),\"\",VLOOKUP(D5,Final!$AF$4:$AI$11,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D5,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D5,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D5,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D5,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D5,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D5,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_UP>3,IF(LEN(Division)=2,\"R\"&RIGHT(Division,1)-1&\"\",IF(LEN(Division)=3,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",IF(Nb_R2=1,\"R2\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(Division,1)&\"\")),IF(LEN(Division)=4,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(LEFT(Division,3),1)&\"\"),\"?\"))),Division)","v":"D1"}]
[null,null,5,{"$f":"'1'!AR14","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E6,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E6,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E6,Points!$A$2:$D$12,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E6,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E6,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E6,Points!$A$2:$D$12,4,FALSE),\"DIV ???\"))))","v":"DIV ???"},{"$f":"IF(ISERROR(VLOOKUP(D6,Final!$AF$4:$AI$11,4,FALSE)),\"\",VLOOKUP(D6,Final!$AF$4:$AI$11,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D6,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D6,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D6,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D6,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D6,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D6,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_UP>4,IF(LEN(Division)=2,\"R\"&RIGHT(Division,1)-1&\"\",IF(LEN(Division)=3,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",IF(Nb_R2=1,\"R2\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(Division,1)&\"\")),IF(LEN(Division)=4,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(LEFT(Division,3),1)&\"\"),\"?\"))),Division)","v":"D1"}]
[null,null,6,{"$f":"'1'!AR15","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E7,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E7,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E7,Points!$A$2:$D$12,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E7,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E7,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E7,Points!$A$2:$D$12,4,FALSE),\"DIV ???\"))))","v":"DIV ???"},{"$f":"IF(ISERROR(VLOOKUP(D7,Final!$AF$4:$AI$11,4,FALSE)),\"\",VLOOKUP(D7,Final!$AF$4:$AI$11,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D7,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D7,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D7,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D7,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D7,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D7,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_UP>5,IF(LEN(Division)=2,\"R\"&RIGHT(Division,1)-1&\"\",IF(LEN(Division)=3,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",IF(Nb_R2=1,\"R2\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(Division,1)&\"\")),IF(LEN(Division)=4,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(LEFT(Division,3),1)&\"\"),\"?\"))),Division)","v":"D1"}]
[null,null,7,{"$f":"'1'!AR16","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E8,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E8,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E8,Points!$A$2:$D$12,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E8,Points!$A$2:$D$12,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E8,Points!$A$2:$D$12,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E8,Points!$A$2:$D$12,4,FALSE),\"DIV ???\"))))","v":"DIV ???"},{"$f":"IF(ISERROR(VLOOKUP(D8,Final!$AF$4:$AI$11,4,FALSE)),\"\",VLOOKUP(D8,Final!$AF$4:$AI$11,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D8,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D8,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D8,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D8,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D8,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D8,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_UP>6,IF(LEN(Division)=2,\"R\"&RIGHT(Division,1)-1&\"\",IF(LEN(Division)=3,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",IF(Nb_R2=1,\"R2\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(Division,1)&\"\")),IF(LEN(Division)=4,IF(RIGHT(LEFT(Division,2),1)=\"2\",\"R1\",\"R\"&RIGHT(LEFT(Division,2),1)-1&\"\"&RIGHT(LEFT(Division,3),1)&\"\"),\"?\"))),Division)","v":"D1"}]