{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Classement","Historique Séance en cours"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Classement","index":0,"n_rows":48,"n_cols":18,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"TOURNOI DEFI",null,null,null,null,null,null,null,null,null,null,null,null,"Ecart","abs Ecart","Perdant descend","Gagnant monte"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(M1,$C$4:$D$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N1,$C$4:$D$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"M2-N2","v":{"$error":"#N/A"}},{"$f":"IF(O2>0,ABS(O2),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P2,I4:J48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(M2<N2,0,INT((ABS(O2-Q2)+1)/2))","v":{"$error":"#N/A"}}]
[null,"CLASSEMENT","NOMS","classement","descente perdant","montée gagnant",null,null,"Ecart","descente du perdant en fonction de l'écart de classement",null,null,"Gagnant","Perdant"]
[null,1,"Kelly",{"$f":"B4","v":1},{"$f":"IF($N$1=C4,B4+$Q$2+0.1,B4)","v":1},{"$f":"IF($M$1=C4,E4-$R$2,E4+0.1)","v":1.1000000000000001},null,null,1,0]
[null,2,"Antonio",2,2,2.1,null,null,2,0]
[null,3,"Rosana",3,3,3.1,null,null,3,0]
[null,4,"Prescillia",4,4,4.0999999999999996,null,null,4,0]
[null,5,"Anais",5,5,5.0999999999999996,null,null,5,1]
[null,6,"Enzo",6,6,6.1,null,null,6,1]
[null,7,"Romain",7,7,7.1,null,null,7,2]
[null,8,"Lisa",8,8,8.1,null,null,8,2]
[null,9,"Adel",9,9,9.1,null,null,9,3]
[null,10,"Maria",10,10,10.1,null,null,10,3]
[null,11,"Tayson",11,11,11.1,null,null,11,4]
[null,12,"Marouane",12,12,12.1,null,null,12,4]
[null,13,"Lola",13,13,13.1,null,null,13,5]
[null,14,"Maïlys",14,14,14.1,null,null,14,5]
[null,15,"Ismail-Efe",15,15,15.1,null,null,15,6]
[null,16,"Justin",16,16,16.100000000000001,null,null,16,6]
[null,17,"Seyma",17,17,17.100000000000001,null,null,17,7]
[null,18,"Sana",18,18,18.100000000000001,null,null,18,7]
[null,19,"Hugo",19,19,19.100000000000001,null,null,19,8]
[null,20,"Lydie",20,20,20.100000000000001,null,null,20,8]
[null,21,"Kessy",21,21,21.1,null,null,21,9]
[null,22,"Julia",22,22,22.1,null,null,22,9]
[null,23,"Alban",23,23,23.1,null,null,23,10]
[null,24,"Tillia",24,24,24.1,null,null,24,10]
[null,25,"Faïz",25,25,25.1,null,null,25,11]
[null,26,"Gaétan",26,26,26.1,null,null,26,11]
[null,27,"Chiara",27,27,27.1,null,null,27,12]
[null,28,null,28,{"$error":"#N/A"},{"$error":"#N/A"},null,null,28,12]
[null,29,null,29,{"$error":"#N/A"},{"$error":"#N/A"},null,null,29,13]
[null,30,null,30,{"$error":"#N/A"},{"$error":"#N/A"},null,null,30,13]
[null,31,null,31,{"$error":"#N/A"},{"$error":"#N/A"},null,null,31,14]
[null,32,null,32,{"$error":"#N/A"},{"$error":"#N/A"},null,null,32,14]
[null,33,null,33,{"$error":"#N/A"},{"$error":"#N/A"},null,null,33,15]
[null,34,null,34,{"$error":"#N/A"},{"$error":"#N/A"},null,null,34,15]
[null,35,null,35,{"$error":"#N/A"},{"$error":"#N/A"},null,null,35,16]
[null,36,null,36,{"$error":"#N/A"},{"$error":"#N/A"},null,null,36,16]
[null,37,null,37,{"$error":"#N/A"},{"$error":"#N/A"},null,null,37,17]
[null,38,null,38,{"$error":"#N/A"},{"$error":"#N/A"},null,null,38,17]
[null,39,null,39,{"$error":"#N/A"},{"$error":"#N/A"},null,null,39,18]
[null,40,null,40,{"$error":"#N/A"},{"$error":"#N/A"},null,null,40,18]
[null,41,null,41,{"$error":"#N/A"},{"$error":"#N/A"},null,null,41,19]
[null,42,null,42,{"$error":"#N/A"},{"$error":"#N/A"},null,null,42,19]
[null,43,null,43,{"$error":"#N/A"},{"$error":"#N/A"},null,null,43,20]
[null,44,null,44,{"$error":"#N/A"},{"$error":"#N/A"},null,null,44,20]
[null,45,null,45,{"$error":"#N/A"},{"$error":"#N/A"},null,null,0,0]

{"sheet":"Historique Séance en cours","index":1,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"HISTORIQUE DES MATCHS"]
[]
[null,null,"Nombre de matchs"]
[null,"Noms","Joués","Gagnés","Perdus",null,"Gagnant","Perdant"]
[null,{"$f":"IF(Classement!C4=0,\"\",Classement!C4)","v":"Kelly"},{"$f":"IF(B5=\"\",\"\",COUNTIF($G$5:$H$254,B5))","v":0},{"$f":"IF(B5=\"\",\"\",COUNTIF($G$5:$G$254,B5))","v":0},{"$f":"IF(B5=\"\",\"\",COUNTIF($H$5:$H$254,B5))","v":0}]
[null,{"$f":"IF(Classement!C5=0,\"\",Classement!C5)","v":"Antonio"},{"$f":"IF(B6=\"\",\"\",COUNTIF($G$5:$H$254,B6))","v":0},{"$f":"IF(B6=\"\",\"\",COUNTIF($G$5:$G$254,B6))","v":0},{"$f":"IF(B6=\"\",\"\",COUNTIF($H$5:$H$254,B6))","v":0}]
[null,{"$f":"IF(Classement!C6=0,\"\",Classement!C6)","v":"Rosana"},0,0,0]
[null,{"$f":"IF(Classement!C7=0,\"\",Classement!C7)","v":"Prescillia"},0,0,0]
[null,{"$f":"IF(Classement!C8=0,\"\",Classement!C8)","v":"Anais"},0,0,0]
[null,{"$f":"IF(Classement!C9=0,\"\",Classement!C9)","v":"Enzo"},0,0,0]
[null,{"$f":"IF(Classement!C10=0,\"\",Classement!C10)","v":"Romain"},0,0,0]
[null,{"$f":"IF(Classement!C11=0,\"\",Classement!C11)","v":"Lisa"},0,0,0]
[null,{"$f":"IF(Classement!C12=0,\"\",Classement!C12)","v":"Adel"},0,0,0]
[null,{"$f":"IF(Classement!C13=0,\"\",Classement!C13)","v":"Maria"},0,0,0]
[null,{"$f":"IF(Classement!C14=0,\"\",Classement!C14)","v":"Tayson"},0,0,0]
[null,{"$f":"IF(Classement!C15=0,\"\",Classement!C15)","v":"Marouane"},0,0,0]
[null,{"$f":"IF(Classement!C16=0,\"\",Classement!C16)","v":"Lola"},0,0,0]
[null,{"$f":"IF(Classement!C17=0,\"\",Classement!C17)","v":"Maïlys"},0,0,0]
[null,{"$f":"IF(Classement!C18=0,\"\",Classement!C18)","v":"Ismail-Efe"},0,0,0]
[null,{"$f":"IF(Classement!C19=0,\"\",Classement!C19)","v":"Justin"},0,0,0]
[null,{"$f":"IF(Classement!C20=0,\"\",Classement!C20)","v":"Seyma"},0,0,0]
[null,{"$f":"IF(Classement!C21=0,\"\",Classement!C21)","v":"Sana"},0,0,0]
[null,{"$f":"IF(Classement!C22=0,\"\",Classement!C22)","v":"Hugo"},0,0,0]
[null,{"$f":"IF(Classement!C23=0,\"\",Classement!C23)","v":"Lydie"},0,0,0]
[null,{"$f":"IF(Classement!C24=0,\"\",Classement!C24)","v":"Kessy"},0,0,0]
[null,{"$f":"IF(Classement!C25=0,\"\",Classement!C25)","v":"Julia"},0,0,0]
[null,{"$f":"IF(Classement!C26=0,\"\",Classement!C26)","v":"Alban"},0,0,0]
[null,{"$f":"IF(Classement!C27=0,\"\",Classement!C27)","v":"Tillia"},0,0,0]
[null,{"$f":"IF(Classement!C28=0,\"\",Classement!C28)","v":"Faïz"},0,0,0]
[null,{"$f":"IF(Classement!C29=0,\"\",Classement!C29)","v":"Gaétan"},0,0,0]
[null,{"$f":"IF(Classement!C30=0,\"\",Classement!C30)","v":"Chiara"},0,0,0]
[null,{"$f":"IF(Classement!C31=0,\"\",Classement!C31)","v":""},"","",""]
[null,{"$f":"IF(Classement!C32=0,\"\",Classement!C32)","v":""},"","",""]
[null,{"$f":"IF(Classement!C33=0,\"\",Classement!C33)","v":""},"","",""]
[null,{"$f":"IF(Classement!C34=0,\"\",Classement!C34)","v":""},"","",""]
[null,{"$f":"IF(Classement!C35=0,\"\",Classement!C35)","v":""},"","",""]
[null,{"$f":"IF(Classement!C36=0,\"\",Classement!C36)","v":""},"","",""]
[null,{"$f":"IF(Classement!C37=0,\"\",Classement!C37)","v":""},"","",""]
[null,{"$f":"IF(Classement!C38=0,\"\",Classement!C38)","v":""},"","",""]
[null,{"$f":"IF(Classement!C39=0,\"\",Classement!C39)","v":""},"","",""]
[null,{"$f":"IF(Classement!C40=0,\"\",Classement!C40)","v":""},"","",""]
[null,{"$f":"IF(Classement!C41=0,\"\",Classement!C41)","v":""},"","",""]
[null,{"$f":"IF(Classement!C42=0,\"\",Classement!C42)","v":""},"","",""]
[null,{"$f":"IF(Classement!C43=0,\"\",Classement!C43)","v":""},"","",""]
[null,{"$f":"IF(Classement!C44=0,\"\",Classement!C44)","v":""},"","",""]
[null,{"$f":"IF(Classement!C45=0,\"\",Classement!C45)","v":""},"","",""]
[null,{"$f":"IF(Classement!C46=0,\"\",Classement!C46)","v":""},"","",""]
[null,{"$f":"IF(Classement!C47=0,\"\",Classement!C47)","v":""},"","",""]
[null,{"$f":"IF(Classement!C48=0,\"\",Classement!C48)","v":""},"","",""]