{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Points","Accueil","Inscrits","1","2","Final","Classement"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":66,"comments":3,"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":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Place","R1","R2","R3"]
[1,200,142,93]
[2,180,125,79]
[3,161,109,66]
[4,161,109,66]
[5,143,94,54]
[6,143,94,54]
[7,143,94,54]
[8,143,94,54]
[9,126,80,43]
[10,126,80,43]
[11,126,80,43]
[12,126,80,43]
[13,110,67,33]
[14,110,67,33]
[15,110,67,33]
[16,110,67,33]
["FNE",-50,-35,-20]
["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,"LIGUE","Rhône-Alpes",null,"SAISON","2017/2018"]
[2]
[3,null,"DATE","2017-10-26",null,"TOURNOI","N°1"]
[4]
[5,null,"CLUB","Billard Club Pontois",null,"DIVISION","R1"]
["A"]
["F",null,"VILLE DU CLUB","Pont-de-Chéruy",null,"NB JOUEURS",12]
[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",5]
["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":""},null,null,null,null,"Nb Parties Gagnantes\nen 1/4 de finale",4]
[]
["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":4}]
[]
["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":42,"n_cols":12,"rows_kept":42,"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,"BERRAHOU SOLANGE","NC","Academie de Billard de la Valserine","153217Q",null,"-",null,2,"-"]
[2,"DONATO LAURENT","NC","Academie de Billard de la Valserine","146971B",null,"-",null,3]
[3,"DUARTE JOSE","NC","Academie de Billard de la Valserine","146968Y",null,"-",null,4]
[4,"GELIBERT ALEXIS","NC","Academie de Billard de la Valserine","159122J",null,"-",null,5]
[5,"DURET CHRISTOPHE","NC","Club Chamberien de Billard","105704O",null,"-",null,6]
[6,"TASSET JEROME","NC","Club Chamberien de Billard","156368Q",null,"-",null,7]
[7,"SOCKEEL YANNICK","NC","Billard Club de Clarafont-Arcine","159064W",null,"-",null,8]
[8,"SOCKEEL MARIE PIERRE","NC","Billard Club de Clarafont-Arcine","159065X",null,"-",null,9,null,null,2]
[9,"RAY VINCENT","NC","Billard Club de Clarafont-Arcine","150948Z",null,"-",null,10]
[10,"SUDARA BRUNO","NC","Club Chamberien de Billard","156581X",null,"-",null,11]
[11,"ARNAUD JEAN PHILIPPE","NC","Billard Club de Clarafont-Arcine","159063V",null,"-",null,12]
[12,"BABEL STEPHANIE","NC","Billard Club de Clarafont-Arcine","159062T",null,"-",null,13]
[13,"KUSAR HERVE","NC","Billard Club de Clarafont-Arcine","152914L",null,"-",null,14]
[14,"MOREL FLORENT","NC","Billard Club de Clarafont-Arcine","150953E",null,"-",null,15]
[15,"BLANC 5","NC",null,null,null,"-",null,16]
[16,"BLANC 6","NC",null,null,null,"-",null,null,null,null,"OU"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,3]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(B19=\"\",\"\",VLOOKUP(B19,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B21=\"\",\"\",VLOOKUP(B21,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B22=\"\",\"\",VLOOKUP(B22,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B23=\"\",\"\",VLOOKUP(B23,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B24=\"\",\"\",VLOOKUP(B24,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B25=\"\",\"\",VLOOKUP(B25,#REF!,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B26=\"\",\"\",VLOOKUP(B26,#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$33,2,FALSE)),\"\",VLOOKUP(L3,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L3,Inscrits!$A$2:$C$33,2,FALSE)))","v":"BERRAHOU SOLANGE"},{"$f":"IF(IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L3,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L3,Inscrits!$A$2:$C$33,3,FALSE))&\")\"))","v":"(NC)"},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,"F",{"$f":"IF(OR(AND(O3=\"F\",O5=\"F\"),AND(O3=\"A\",O5=\"A\")),M5,IF(OR(O3=\"F\",O3=\"A\"),M3,IF(OR(O5=\"F\",O5=\"A\"),M5,IF(O3=O5,\"\",(IF(O3<O5,M3,M5))))))","v":"BLANC 6"},{"$f":"IF(OR(AND(O3=\"F\",O5=\"F\"),AND(O3=\"A\",O5=\"A\")),N5,IF(OR(O3=\"F\",O3=\"A\"),N3,IF(OR(O5=\"F\",O5=\"A\"),N5,IF(O3=O5,\"\",(IF(O3<O5,N3,N5))))))","v":"(NC)"},null,"Match 1 - Billard",null,null,null,{"$f":"IF(OR(AND(O3=\"F\",O5=\"F\"),AND(O3=\"A\",O5=\"A\")),M3,IF(OR(O3=\"F\",O3=\"A\"),M5,IF(OR(O5=\"F\",O5=\"A\"),M3,IF(O3=O5,\"\",(IF(O3>O5,M3,M5))))))","v":"BERRAHOU SOLANGE"},{"$f":"IF(OR(AND(O3=\"F\",O5=\"F\"),AND(O3=\"A\",O5=\"A\")),N3,IF(OR(O3=\"F\",O3=\"A\"),N5,IF(OR(O5=\"F\",O5=\"A\"),N3,IF(O3=O5,\"\",(IF(O3>O5,N3,N5))))))","v":"(NC)"},null,null,null,null,null,null,1,{"$f":"IF(U6=\"\",\"\",IF(U6=Q4,Q4,Q8))","v":""},null,{"$f":"M3","v":"BERRAHOU SOLANGE"},{"$f":"IF(AB4=M3,IF(O5=\"F\",\"\",O3),0)","v":""},{"$f":"IF(AB4=M3,IF(O3=\"F\",\"\",O5),0)","v":"F"},{"$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,16,{"$f":"IF(IF(ISNA(VLOOKUP(L5,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L5,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L5,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L5,Inscrits!$A$2:$C$33,2,FALSE)))","v":"BLANC 6"},{"$f":"IF(IF(ISNA(VLOOKUP(L5,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L5,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L5,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L5,Inscrits!$A$2:$C$33,3,FALSE))&\")\"))","v":"(NC)"},"F",null,null,null,null,null,"G5",null,null,null,3,{"$f":"IF(B8=\"\",\"\",IF(B8=F6,F6,F10))","v":""},null,{"$f":"M5","v":"BLANC 6"},{"$f":"IF(AB5=M5,IF(O3=\"F\",\"\",O5),0)","v":"F"},{"$f":"IF(AB5=M5,IF(O5=\"F\",\"\",O3),0)","v":""},{"$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":"F"},{"$f":"IF(AB5=J4,IF(I4=\"F\",\"\",I8),0)","v":""},{"$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":"IF(OR(I4=\"F\",I4=\"A\"),J8,IF(OR(I8=\"F\",I8=\"A\"),J4,IF(I4=I8,\"\",(IF(I4>I8,J4,J8)))))","v":""},{"$f":"IF(OR(I4=\"F\",I4=\"A\"),K8,IF(OR(I8=\"F\",I8=\"A\"),K4,IF(I4=I8,\"\",(IF(I4>I8,K4,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":"RAY VINCENT"},{"$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,9,{"$f":"IF(IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L7,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L7,Inscrits!$A$2:$C$33,2,FALSE)))","v":"RAY VINCENT"},{"$f":"IF(IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L7,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L7,Inscrits!$A$2:$C$33,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":"SOCKEEL MARIE PIERRE"},{"$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",8,{"$f":"IF(IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L9,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L9,Inscrits!$A$2:$C$33,2,FALSE)))","v":"SOCKEEL MARIE PIERRE"},{"$f":"IF(IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L9,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L9,Inscrits!$A$2:$C$33,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",5,{"$f":"IF(IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L13,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L13,Inscrits!$A$2:$C$33,2,FALSE)))","v":"DURET CHRISTOPHE"},{"$f":"IF(IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L13,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L13,Inscrits!$A$2:$C$33,3,FALSE))&\")\"))","v":"(NC)"},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":"DURET CHRISTOPHE"},{"$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,12,{"$f":"IF(IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L15,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L15,Inscrits!$A$2:$C$33,2,FALSE)))","v":"BABEL STEPHANIE"},{"$f":"IF(IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L15,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L15,Inscrits!$A$2:$C$33,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":"BABEL STEPHANIE"},{"$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":"KUSAR HERVE"},{"$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":"Z7","v":""},{"$f":"IF(AR16=\"\",\"\",(VLOOKUP(AR16,AB4:AO17,14,FALSE)))","v":""}]
[null,null,"G10",null,null,null,null,null,null,null,null,13,{"$f":"IF(IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L17,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L17,Inscrits!$A$2:$C$33,2,FALSE)))","v":"KUSAR HERVE"},{"$f":"IF(IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L17,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L17,Inscrits!$A$2:$C$33,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":"GELIBERT ALEXIS"},{"$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},null,null,{"$f":"Z17","v":""},{"$f":"IF(AR17=\"\",\"\",(VLOOKUP(AR17,AB4:AO17,14,FALSE)))","v":""}]
["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",4,{"$f":"IF(IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L19,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L19,Inscrits!$A$2:$C$33,2,FALSE)))","v":"GELIBERT ALEXIS"},{"$f":"IF(IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L19,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L19,Inscrits!$A$2:$C$33,3,FALSE))&\")\"))","v":"(NC)"},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":"2","index":4,"n_rows":21,"n_cols":45,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,9,0,17],[12,1,12,2],[10,20,10,21],[1,42,1,45],[11,42,11,45],[20,9,20,17]]}
[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",3,{"$f":"IF(IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L3,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L3,Inscrits!$A$2:$C$33,2,FALSE)))","v":"DUARTE JOSE"},{"$f":"IF(IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L3,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L3,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L3,Inscrits!$A$2:$C$33,3,FALSE))&\")\"))","v":"(NC)"},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,{"$f":"IF(OR(AND(O3=\"F\",O5=\"F\"),AND(O3=\"A\",O5=\"A\")),M5,IF(OR(O3=\"F\",O3=\"A\"),M3,IF(OR(O5=\"F\",O5=\"A\"),M5,IF(O3=O5,\"\",(IF(O3<O5,M3,M5))))))","v":""},{"$f":"IF(OR(AND(O3=\"F\",O5=\"F\"),AND(O3=\"A\",O5=\"A\")),N5,IF(OR(O3=\"F\",O3=\"A\"),N3,IF(OR(O5=\"F\",O5=\"A\"),N5,IF(O3=O5,\"\",(IF(O3<O5,N3,N5))))))","v":""},null,"Match 1 - Billard",null,null,null,{"$f":"IF(OR(AND(O3=\"F\",O5=\"F\"),AND(O3=\"A\",O5=\"A\")),M3,IF(OR(O3=\"F\",O3=\"A\"),M5,IF(OR(O5=\"F\",O5=\"A\"),M3,IF(O3=O5,\"\",(IF(O3>O5,M3,M5))))))","v":""},{"$f":"IF(OR(AND(O3=\"F\",O5=\"F\"),AND(O3=\"A\",O5=\"A\")),N3,IF(OR(O3=\"F\",O3=\"A\"),N5,IF(OR(O5=\"F\",O5=\"A\"),N3,IF(O3=O5,\"\",(IF(O3>O5,N3,N5))))))","v":""},null,null,null,null,null,null,1,{"$f":"IF(U6=\"\",\"\",IF(U6=Q4,Q4,Q8))","v":""},null,{"$f":"M3","v":"DUARTE JOSE"},{"$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,14,{"$f":"IF(IF(ISNA(VLOOKUP(L5,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L5,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L5,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L5,Inscrits!$A$2:$C$33,2,FALSE)))","v":"MOREL FLORENT"},{"$f":"IF(IF(ISNA(VLOOKUP(L5,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L5,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L5,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L5,Inscrits!$A$2:$C$33,3,FALSE))&\")\"))","v":"(NC)"},null,null,null,null,null,null,"G5",null,null,null,3,{"$f":"IF(B8=\"\",\"\",IF(B8=F6,F6,F10))","v":""},null,{"$f":"M5","v":"MOREL FLORENT"},{"$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":"IF(OR(I4=\"F\",I4=\"A\"),J8,IF(OR(I8=\"F\",I8=\"A\"),J4,IF(I4=I8,\"\",(IF(I4>I8,J4,J8)))))","v":""},{"$f":"IF(OR(I4=\"F\",I4=\"A\"),K8,IF(OR(I8=\"F\",I8=\"A\"),K4,IF(I4=I8,\"\",(IF(I4>I8,K4,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":""},"C",null,5,{"$f":"IF(B8=\"\",\"\",IF(B8=F6,F10,F6))","v":""},null,{"$f":"M7","v":"ARNAUD JEAN PHILIPPE"},{"$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,11,{"$f":"IF(IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L7,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L7,Inscrits!$A$2:$C$33,2,FALSE)))","v":"ARNAUD JEAN PHILIPPE"},{"$f":"IF(IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L7,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L7,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L7,Inscrits!$A$2:$C$33,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":"TASSET JEROME"},{"$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":""}]
["U",{"$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",6,{"$f":"IF(IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L9,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L9,Inscrits!$A$2:$C$33,2,FALSE)))","v":"TASSET JEROME"},{"$f":"IF(IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L9,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L9,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L9,Inscrits!$A$2:$C$33,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",7,{"$f":"IF(IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L13,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L13,Inscrits!$A$2:$C$33,2,FALSE)))","v":"SOCKEEL YANNICK"},{"$f":"IF(IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L13,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L13,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L13,Inscrits!$A$2:$C$33,3,FALSE))&\")\"))","v":"(NC)"},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":"SOCKEEL YANNICK"},{"$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,10,{"$f":"IF(IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L15,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L15,Inscrits!$A$2:$C$33,2,FALSE)))","v":"SUDARA BRUNO"},{"$f":"IF(IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L15,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L15,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L15,Inscrits!$A$2:$C$33,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":"SUDARA BRUNO"},{"$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":""},"D",null,6,{"$f":"IF(B18=\"\",\"\",IF(B18=F16,F20,F16))","v":""},null,{"$f":"M17","v":"BLANC 5"},{"$f":"IF(AB16=M17,IF(O19=\"F\",\"\",O17),0)","v":"F"},{"$f":"IF(AB16=M17,IF(O17=\"F\",\"\",O19),0)","v":""},{"$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":"F"},{"$f":"IF(AB16=J18,IF(I18=\"F\",\"\",I14),0)","v":""},{"$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":"Z7","v":""},{"$f":"IF(AR16=\"\",\"\",(VLOOKUP(AR16,AB4:AO17,14,FALSE)))","v":""}]
[null,null,"G10",null,null,null,null,null,null,null,null,15,{"$f":"IF(IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L17,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L17,Inscrits!$A$2:$C$33,2,FALSE)))","v":"BLANC 5"},{"$f":"IF(IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L17,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L17,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L17,Inscrits!$A$2:$C$33,3,FALSE))&\")\"))","v":"(NC)"},"F",null,null,null,null,null,null,null,null,null,8,{"$f":"IF(F16=\"\",\"\",IF(F16=J14,J18,J14))","v":""},null,{"$f":"M19","v":"DONATO LAURENT"},{"$f":"IF(AB17=M19,IF(O17=\"F\",\"\",O19),0)","v":""},{"$f":"IF(AB17=M19,IF(O19=\"F\",\"\",O17),0)","v":"F"},{"$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,0,{"$f":"AM17-AN17","v":0},null,null,{"$f":"Z17","v":""},{"$f":"IF(AR17=\"\",\"\",(VLOOKUP(AR17,AB4:AO17,14,FALSE)))","v":""}]
["V",{"$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,"F",{"$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":"BLANC 5"},{"$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":"(NC)"},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":"DONATO LAURENT"},{"$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":"(NC)"}]
[null,null,null,null,null,null,null,null,null,null,"P4",2,{"$f":"IF(IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L19,Inscrits!$A$2:$C$33,2,FALSE))=0,\"\",IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$33,2,FALSE)),\"\",VLOOKUP(L19,Inscrits!$A$2:$C$33,2,FALSE)))","v":"DONATO LAURENT"},{"$f":"IF(IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L19,Inscrits!$A$2:$C$33,3,FALSE))&\")\")=\"()\",\"\",IF(ISNA(VLOOKUP(L19,Inscrits!$A$2:$C$33,3,FALSE)),\"\",\"(\"&(VLOOKUP(L19,Inscrits!$A$2:$C$33,3,FALSE))&\")\"))","v":"(NC)"},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":5,"n_rows":27,"n_cols":35,"rows_kept":27,"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":"(4 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":"F5","v":""},null,{"$f":"IF(AND(H5=\"A\",H7=\"A\"),0,IF(H5=\"A\",-H7,IF(H7=\"A\",H5,H5-H7)))","v":0},{"$f":"IF(J6=V4,IF(AND(L6=\"A\",L12=\"A\"),0,IF(OR(X4>0,H7=\"A\"),IF(L6=\"A\",-L12,IF(L12=\"A\",L6,L6-L12)),0)),0)","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":"BERRAHOU SOLANGE"},{"$f":"VLOOKUP(AF4,$AC$4:$AD$35,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AF4,$V$4:$AA$35,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"AG4+AH4","v":{"$error":"#N/A"}}]
[null,null,null,null,"A",{"$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,null,null,null,null,{"$f":"'1'!AR5","v":""},{"$f":"'1'!AS5","v":""},null,{"$f":"IF(Inscrits!B3=0,\"\",Inscrits!B3)","v":"DONATO LAURENT"},{"$f":"VLOOKUP(AF5,$AC$4:$AD$35,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AF5,$V$4:$AA$35,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,"Match 1 - Billard",null,null,null,{"$f":"IF(AND(H5=\"A\",H7=\"A\"),F5,IF(H5=\"A\",F7,IF(H7=\"A\",F5,IF(H5=H7,\"\",(IF(H5>H7,F5,F7))))))","v":""},{"$f":"IF(AND(H5=\"A\",H7=\"A\"),G5,IF(H5=\"A\",G7,IF(H7=\"A\",G5,IF(H5=H7,\"\",(IF(H5>H7,G5,G7))))))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"F7","v":""},null,{"$f":"IF(AND(H5=\"A\",H7=\"A\"),0,IF(H7=\"A\",-H5,IF(H5=\"A\",H7,H7-H5)))","v":0},{"$f":"IF(J6=V6,IF(AND(L6=\"A\",L12=\"A\"),0,IF(OR(X6>0,H5=\"A\"),IF(L6=\"A\",-L12,IF(L12=\"A\",L6,L6-L12)),0)),0)","v":0},{"$f":"IF(N9=V6,IF(AND(P9=\"A\",P21=\"A\"),0,IF(OR(Y6>0,L12=\"A\"),IF(P9=\"A\",-P21,IF(P21=\"A\",P9,P9-P21)),0)),0)","v":0},{"$f":"SUM(W6:Z6)","v":0},null,{"$f":"'1'!AR6","v":""},{"$f":"'1'!AS6","v":""},null,{"$f":"IF(Inscrits!B4=0,\"\",Inscrits!B4)","v":"DUARTE JOSE"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,"Z",{"$f":"IF('2'!B18=0,\"\",'2'!B18)","v":""},{"$f":"IF('2'!C18=0,\"\",'2'!C18)","v":""},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":"GELIBERT ALEXIS"},{"$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":"F11","v":""},null,{"$f":"IF(AND(H11=\"A\",H13=\"A\"),0,IF(H11=\"A\",-H13,IF(H13=\"A\",H11,H11-H13)))","v":0},{"$f":"IF(J12=V8,IF(AND(L6=\"A\",L12=\"A\"),0,IF(OR(X8>0,H13=\"A\"),IF(L12=\"A\",-L6,IF(L6=\"A\",L12,L12-L6)),0)),0)","v":0},{"$f":"IF(N9=V8,IF(AND(P9=\"A\",P21=\"A\"),0,IF(OR(Y8>0,L6=\"A\"),IF(P9=\"A\",-P21,IF(P21=\"A\",P9,P9-P21)),0)),0)","v":0},0,null,{"$f":"'1'!AR14","v":""},{"$f":"'1'!AS14","v":""},null,{"$f":"IF(Inscrits!B6=0,\"\",Inscrits!B6)","v":"DURET CHRISTOPHE"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"Match 5 - 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":"TASSET JEROME"},{"$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":"F13","v":""},null,{"$f":"IF(AND(H11=\"A\",H13=\"A\"),0,IF(H13=\"A\",-H11,IF(H11=\"A\",H13,H13-H11)))","v":0},{"$f":"IF(J12=V10,IF(AND(L6=\"A\",L12=\"A\"),0,IF(OR(X10>0,H11=\"A\"),IF(L12=\"A\",-L6,IF(L6=\"A\",L12,L12-L6)),0)),0)","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},0,null,{"$f":"'1'!AR16","v":""},{"$f":"'1'!AS16","v":""},null,{"$f":"IF(Inscrits!B8=0,\"\",Inscrits!B8)","v":"SOCKEEL YANNICK"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,"B",{"$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":"'1'!AR17","v":""},{"$f":"'1'!AS17","v":""},null,{"$f":"IF(Inscrits!B9=0,\"\",Inscrits!B9)","v":"SOCKEEL MARIE PIERRE"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,"Match 2 - Billard",null,null,null,{"$f":"IF(AND(H11=\"A\",H13=\"A\"),F11,IF(H11=\"A\",F13,IF(H13=\"A\",F11,IF(H11=H13,\"\",(IF(H11>H13,F11,F13))))))","v":""},{"$f":"IF(AND(H11=\"A\",H13=\"A\"),G11,IF(H11=\"A\",G13,IF(H13=\"A\",G11,IF(H11=H13,\"\",(IF(H11>H13,G11,G13))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2'!AR4","v":""},{"$f":"'2'!AS4","v":""},null,{"$f":"IF(Inscrits!B10=0,\"\",Inscrits!B10)","v":"RAY VINCENT"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,"Y",{"$f":"IF('2'!B8=0,\"\",'2'!B8)","v":""},{"$f":"IF('2'!C8=0,\"\",'2'!C8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F17","v":""},null,{"$f":"IF(AND(H17=\"A\",H19=\"A\"),0,IF(H17=\"A\",-H19,IF(H19=\"A\",H17,H17-H19)))","v":0},{"$f":"IF(J18=V13,IF(AND(L18=\"A\",L24=\"A\"),0,IF(OR(X13>0,H19=\"A\"),IF(L18=\"A\",-L24,IF(L24=\"A\",L18,L18-L24)),0)),0)","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},0,null,{"$f":"'2'!AR5","v":""},{"$f":"'2'!AS5","v":""},null,{"$f":"IF(Inscrits!B11=0,\"\",Inscrits!B11)","v":"SUDARA BRUNO"},{"$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":"'2'!AR6","v":""},{"$f":"'2'!AS6","v":""},null,{"$f":"IF(Inscrits!B12=0,\"\",Inscrits!B12)","v":"ARNAUD JEAN PHILIPPE"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Match 7 - 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,{"$f":"F19","v":""},null,{"$f":"IF(AND(H17=\"A\",H19=\"A\"),0,IF(H19=\"A\",-H17,IF(H17=\"A\",H19,H19-H17)))","v":0},{"$f":"IF(J18=V15,IF(AND(L18=\"A\",L24=\"A\"),0,IF(OR(X15>0,H17=\"A\"),IF(L18=\"A\",-L24,IF(L24=\"A\",L18,L18-L24)),0)),0)","v":0},{"$f":"IF(N21=V15,IF(AND(P9=\"A\",P21=\"A\"),0,IF(OR(Y15>0,L24=\"A\"),IF(P21=\"A\",-P9,IF(P9=\"A\",P21,P21-P9)),0)),0)","v":0},0,null,{"$f":"'2'!AR7","v":""},{"$f":"'2'!AS7","v":""},null,{"$f":"IF(Inscrits!B13=0,\"\",Inscrits!B13)","v":"BABEL STEPHANIE"},{"$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":"'2'!AR14","v":""},{"$f":"'2'!AS14","v":""},null,{"$f":"IF(Inscrits!B14=0,\"\",Inscrits!B14)","v":"KUSAR HERVE"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,"C",{"$f":"IF('2'!U6=0,\"\",'2'!U6)","v":""},{"$f":"IF('2'!V6=0,\"\",'2'!V6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F23","v":""},null,{"$f":"IF(AND(H23=\"A\",H25=\"A\"),0,IF(H23=\"A\",-H25,IF(H25=\"A\",H23,H23-H25)))","v":0},{"$f":"IF(J24=V17,IF(AND(L18=\"A\",L24=\"A\"),0,IF(OR(X17>0,H25=\"A\"),IF(L24=\"A\",-L18,IF(L18=\"A\",L24,L24-L18)),0)),0)","v":0},{"$f":"IF(N21=V17,IF(AND(P9=\"A\",P21=\"A\"),0,IF(OR(Y17>0,L18=\"A\"),IF(P21=\"A\",-P9,IF(P9=\"A\",P21,P21-P9)),0)),0)","v":0},0,null,{"$f":"'2'!AR15","v":""},{"$f":"'2'!AS15","v":""},null,{"$f":"IF(Inscrits!B15=0,\"\",Inscrits!B15)","v":"MOREL FLORENT"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,"Match 3 - Billard",null,null,null,{"$f":"IF(AND(H17=\"A\",H19=\"A\"),F17,IF(H17=\"A\",F19,IF(H19=\"A\",F17,IF(H17=H19,\"\",(IF(H17>H19,F17,F19))))))","v":""},{"$f":"IF(AND(H17=\"A\",H19=\"A\"),G17,IF(H17=\"A\",G19,IF(H19=\"A\",G17,IF(H17=H19,\"\",(IF(H17>H19,G17,G19))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2'!AR16","v":""},{"$f":"'2'!AS16","v":""},null,{"$f":"IF(Inscrits!B16=0,\"\",Inscrits!B16)","v":"BLANC 5"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,"X",{"$f":"IF('1'!B18=0,\"\",'1'!B18)","v":""},{"$f":"IF('1'!C18=0,\"\",'1'!C18)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F25","v":""},null,{"$f":"IF(AND(H23=\"A\",H25=\"A\"),0,IF(H25=\"A\",-H23,IF(H23=\"A\",H25,H25-H23)))","v":0},{"$f":"IF(J24=V19,IF(AND(L18=\"A\",L24=\"A\"),0,IF(OR(X19>0,H23=\"A\"),IF(L24=\"A\",-L18,IF(L18=\"A\",L24,L24-L18)),0)),0)","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},0,null,{"$f":"'2'!AR17","v":""},{"$f":"'2'!AS17","v":""},null,{"$f":"IF(Inscrits!B17=0,\"\",Inscrits!B17)","v":"BLANC 6"},{"$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":"'1'!AR14","v":""},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Match 6 - 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,"D",{"$f":"IF('2'!U16=0,\"\",'2'!U16)","v":""},{"$f":"IF('2'!V16=0,\"\",'2'!V16)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1'!AR17","v":""},null,null,null,null,0]
[null,null,null,null,null,"Match 4 - Billard",null,null,null,{"$f":"IF(AND(H23=\"A\",H25=\"A\"),F23,IF(H23=\"A\",F25,IF(H25=\"A\",F23,IF(H23=H25,\"\",(IF(H23>H25,F23,F25))))))","v":""},{"$f":"IF(AND(H23=\"A\",H25=\"A\"),G23,IF(H23=\"A\",G25,IF(H25=\"A\",G23,IF(H23=H25,\"\",(IF(H23>H25,G23,G25))))))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"'2'!AR14","v":""},null,null,null,null,0]
[null,null,null,null,"W",{"$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,{"$f":"'2'!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":"'2'!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":"'2'!AR17","v":""},null,null,null,null,0]

{"sheet":"Classement","index":6,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,"Formules Initiales","Nom & Prénom","Place","Points","GA","CF","RF","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$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E2,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E2,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E2,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E2,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E2,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D2,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D2,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$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":"R1"}]
[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$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E3,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E3,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E3,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E3,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E3,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D3,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D3,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$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":"R1"}]
[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(E4,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E4,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E4,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E4,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E4,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E4,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D4,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D4,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$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":"R1"}]
[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(E5,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E5,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E5,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E5,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E5,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E5,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D5,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D5,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$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":"R1"}]
[null,null,5,{"$f":"IF(Final!H7=\"A\",Final!F7,IF(Final!H5=\"A\",Final!F5,IF(Final!H5<Final!H7,Final!F5,Final!F7)))","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E6,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E6,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E6,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E6,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E6,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E6,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D6,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D6,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$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":"R1"}]
[null,null,6,{"$f":"IF(Final!H13=\"A\",Final!F13,IF(Final!H11=\"A\",Final!F11,IF(Final!H11<Final!H13,Final!F11,Final!F13)))","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E7,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E7,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E7,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E7,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E7,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E7,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D7,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D7,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$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":"R1"}]
[null,null,8,{"$f":"IF(Final!H25=\"A\",Final!F25,IF(Final!H23=\"A\",Final!F23,IF(Final!H23<Final!H25,Final!F23,Final!F25)))","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E8,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E8,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E8,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E8,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E8,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E8,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D8,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D8,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$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":"R1"}]
[null,null,7,{"$f":"IF(Final!H19=\"A\",Final!F19,IF(Final!H17=\"A\",Final!F17,IF(Final!H17<Final!H19,Final!F17,Final!F19)))","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E9,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E9,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E9,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E9,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E9,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E9,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D9,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D9,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D9,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D9,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D9,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D9,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D9,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D9,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_UP>7,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":"R1"}]
[null,null,9,{"$f":"'1'!AR14","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E10,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E10,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E10,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E10,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E10,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E10,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D10,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D10,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D10,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D10,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D10,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D10,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D10,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D10,Inscrits!B:E,5,FALSE))","v":""},{"$f":"Division","v":"R1"}]
[null,null,11,{"$f":"'2'!AR14","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E11,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E11,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E11,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E11,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E11,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E11,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D11,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D11,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D11,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D11,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D11,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D11,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D11,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D11,Inscrits!B:E,5,FALSE))","v":""},{"$f":"Division","v":"R1"}]
[null,null,12,{"$f":"'2'!AR15","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E12,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E12,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E12,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E12,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E12,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E12,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D12,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D12,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D12,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D12,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D12,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D12,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D12,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D12,Inscrits!B:E,5,FALSE))","v":""},{"$f":"Division","v":"R1"}]
[null,null,10,{"$f":"'1'!AR15","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E13,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E13,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E13,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E13,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E13,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E13,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D13,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D13,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D13,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D13,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D13,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D13,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D13,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D13,Inscrits!B:E,5,FALSE))","v":""},{"$f":"Division","v":"R1"}]
[null,null,14,{"$f":"'1'!AR17","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E14,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E14,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E14,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E14,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E14,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E14,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D14,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D14,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D14,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D14,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D14,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D14,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D14,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D14,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_DOWN>3,\"Relégué(e)\",Division)","v":"R1"}]
[null,null,15,{"$f":"'2'!AR16","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E15,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E15,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E15,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E15,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E15,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E15,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D15,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D15,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D15,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D15,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D15,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D15,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D15,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D15,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_DOWN>2,\"Relégué(e)\",Division)","v":"R1"}]
[null,null,13,{"$f":"'1'!AR16","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E16,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E16,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E16,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E16,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E16,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E16,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D16,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D16,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D16,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D16,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D16,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D16,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D16,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D16,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_DOWN>1,\"Relégué(e)\",Division)","v":"R1"}]
[null,null,16,{"$f":"'2'!AR17","v":""},null,{"$f":"IF(ISNA(IF(LEFT(Division,2)=\"R1\",VLOOKUP(E17,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E17,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E17,Points!$A$2:$D$20,4,FALSE),\"DIV ???\")))),0,IF(LEFT(Division,2)=\"R1\",VLOOKUP(E17,Points!$A$2:$D$20,2,FALSE),IF(LEFT(Division,2)=\"R2\",VLOOKUP(E17,Points!$A$2:$D$20,3,FALSE),IF(LEFT(Division,2)=\"R3\",VLOOKUP(E17,Points!$A$2:$D$20,4,FALSE),\"DIV ???\"))))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D17,Final!$AF$4:$AI$35,4,FALSE)),\"\",VLOOKUP(D17,Final!$AF$4:$AI$35,4,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D17,Inscrits!B:E,3,FALSE)),\"\",VLOOKUP(D17,Inscrits!B:E,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D17,Inscrits!B:E,4,FALSE)),\"\",VLOOKUP(D17,Inscrits!B:E,4,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(D17,Inscrits!B:E,5,FALSE)),\"\",VLOOKUP(D17,Inscrits!B:E,5,FALSE))","v":""},{"$f":"IF(NB_JOUEURS_DOWN>0,\"Relégué(e)\",Division)","v":"R1"}]