{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Préparation","Bilan","Feuille de match Bac à 5","Feuille de match Bac à 4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Préparation","index":0,"n_rows":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":false,"merged":[[26,9,27,11],[3,0,7,0],[9,0,12,0],[1,9,1,10],[1,11,1,12],[1,13,1,14],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
[]
[null,"POULE 1",null,"POULE 2",null,"POULE 3",null,"POULE 4",null,"POULE 5",null,"POULE 6",null,"POULE 7",null,null,"Nom Prénom","SEXE",null,"Nom Prénom","SEXE"]
[null,"Prénoms","Sexe","Prénoms","Sexe","Prénoms","Sexe","Prénoms","Sexe","Prénoms","Sexe","Prénoms","Sexe","Prénoms","Sexe",null,null,null,null,{"$f":"Q3","v":0},{"$f":"R3","v":0},{"$f":"COUNTIF($B$4:$O$13,T3)","v":0},1,{"$f":"IF(V3=0,0,100)","v":0},{"$f":"W3+X3","v":1},{"$f":"RANK(Y3,$Y$3:$Y$37,1)","v":1},{"$f":"IF(V3=1,\"\",T3)","v":0},1,{"$f":"VLOOKUP(AB3,$Z$3:$AA$37,2,FALSE)","v":0}]
["Poule de 5",null,{"$f":"IFERROR(VLOOKUP(B4,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D4,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(F4,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H4,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J4,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L4,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(N4,Inscription,2,FALSE),\"\")","v":""},null,null,null,null,{"$f":"Q4","v":0},{"$f":"R4","v":0},{"$f":"COUNTIF($B$4:$O$13,T4)","v":0},2,{"$f":"IF(V4=0,0,100)","v":0},{"$f":"W4+X4","v":2},{"$f":"RANK(Y4,$Y$3:$Y$37,1)","v":2},{"$f":"IF(V4=1,\"\",T4)","v":0},2,{"$f":"VLOOKUP(AB4,$Z$3:$AA$37,2,FALSE)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B5,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D5,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(F5,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H5,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J5,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L5,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(N5,Inscription,2,FALSE),\"\")","v":""},null,null,null,null,0,0,0,3,0,3,3,0,3,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B6,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D6,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(F6,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H6,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J6,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L6,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(N6,Inscription,2,FALSE),\"\")","v":""},null,null,null,null,0,0,0,4,0,4,4,0,4,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B7,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D7,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(F7,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H7,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J7,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L7,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(N7,Inscription,2,FALSE),\"\")","v":""},null,null,null,null,0,0,0,5,0,5,5,0,5,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B8,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D8,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(F8,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H8,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J8,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L8,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(N8,Inscription,2,FALSE),\"\")","v":""},null,null,null,null,0,0,0,6,0,6,6,0,6,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,7,0,7,7,0,7,0]
["Poule de 4 ",null,{"$f":"IFERROR(VLOOKUP(B10,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D10,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(F10,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H10,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J10,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L10,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(N10,Inscription,2,FALSE),\"\")","v":""},null,null,null,null,0,0,0,8,0,8,8,0,8,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B11,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D11,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(F11,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H11,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J11,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L11,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(N11,Inscription,2,FALSE),\"\")","v":""},null,null,null,null,0,0,0,9,0,9,9,0,9,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B12,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D12,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(F12,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H12,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J12,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L12,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(N12,Inscription,2,FALSE),\"\")","v":""},null,null,null,null,0,0,0,10,0,10,10,0,10,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B13,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(D13,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(F13,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H13,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J13,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(L13,Inscription,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(N13,Inscription,2,FALSE),\"\")","v":""},null,null,null,null,0,0,0,11,0,11,11,0,11,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,12,0,12,12,0,12,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,13,0,13,13,0,13,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,14,0,14,14,0,14,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,15,0,15,15,0,15,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,16,0,16,16,0,16,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,17,0,17,17,0,17,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,18,0,18,18,0,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,19,0,19,19,0,19,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,20,0,20,20,0,20,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,21,0,21,21,0,21,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,22,0,22,22,0,22,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,23,0,23,23,0,23,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,24,0,24,24,0,24,0]
[null,null,null,null,null,null,null,null,null,"Paul ANTIAO\nJean Moulin\nMontmorillon",null,null,null,null,null,null,null,null,null,0,0,0,25,0,25,25,0,25,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,26,0,26,26,0,26,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,27,0,27,27,0,27,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,28,0,28,28,0,28,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,29,0,29,29,0,29,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,30,0,30,30,0,30,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,31,0,31,31,0,31,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,32,0,32,32,0,32,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,33,0,33,33,0,33,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,34,0,34,34,0,34,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,35,0,35,35,0,35,0]

{"sheet":"Bilan","index":1,"n_rows":52,"n_cols":105,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,68,1,74],[1,76,1,82],[1,84,1,90],[1,92,1,98],[1,1,1,4],[1,30,1,40],[1,15,1,17],[1,12,1,14],[2,60,2,61],[2,58,2,59],[1,57,1,61],[1,19,1,23],[1,44,1,54],[2,30,2,33],[2,34,2,37],[2,38,2,42],[2,44,2,47],[2,48,2,51],[2,52,2,56]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"CLASSEMENT général","CLASSEMENT FILLES",null,null,"CLASSEMENT GARCONS",null,null,null,"RÉCAPITULATIF",null,null,null,null,null,null,null,null,null,null,"Cellules calculs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cellules valeurs",null,null,null,null,null,null,null,null,null,null,null,null,"Notes",null,null,null,null,null,null,null,null,null,null,"Filles",null,null,null,null,null,null,null,"Gars",null,null,null,null,null,null,null,"Ensemble",null,null,null,null,null,null,null,"NOM ALPHABETIQUE"]
[null,"RANG","NOM","F/G","STRATÉGIE",null,null,null,null,null,null,"Nom Prénom","Nom Prénom","CLASS.","Poule","Nom Prénom","CLASS.","Poule",null,"NOM - Prénom","Sexe","Stratégie","Classement","Poules",null,null,null,null,null,null,"Filles",null,null,null,"Garçons",null,null,null,"Ensemble",null,null,null,null,null,"Filles",null,null,null,"Garçons",null,null,null,"Ensemble",null,null,null,null,null,"Filles",null,"Gars",null,null,null,null,null,null,null,"ORDRE","RANG",null,"NOM","CLASS","RECVORDRE","RECVNOM",null,"ORDRE","RANG",null,"NOM","CLASS","RECVORDRE","RECVNOM",null,"ORDRE","RANG",null,"NOM","CLASS","RECVORDRE","RECVNOM",null,"VALEUR","OCCURRENCE","ORDRE","NOM","CLASS","RECVNOM","RECVSExe"]
[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,{"$f":"IF(AF4=\"\",\"\",AM4)","v":""},{"$f":"IF(D4=\"F\",C4,\"\")","v":""},{"$f":"IF(AO4=\"F\",AP4,\"\")","v":""},{"$f":"COUNTIF(AF4,\"\")","v":1},{"$f":"IF(AJ4=\"\",\"\",AM4)","v":""},{"$f":"IF(D4=\"G\",C4,\"\")","v":""},{"$f":"IF(AO4=\"G\",AP4,\"\")","v":""},{"$f":"COUNTIF(AJ4,\"\")","v":1},{"$f":"IF(B4=\"\",\"\",B4)","v":""},{"$f":"IF(C4=0,\"\",C4)","v":""},{"$f":"IF(D4=0,\"\",D4)","v":""},{"$f":"IF(BL4=\"\",\"\",BL4)","v":""},{"$f":"COUNTIF(AN4,\"\")","v":1},null,{"$f":"BV4","v":""},{"$f":"BW4","v":""},{"$f":"BH4","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT4,$AF$4:$AG$38,2,FALSE)","v":""},{"$f":"CD4","v":""},{"$f":"CE4","v":""},{"$f":"BJ4","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX4,$AJ$4:$AK$38,2,FALSE)","v":""},{"$f":"CL4","v":""},{"$f":"CM4","v":""},{"$f":"VLOOKUP(BB4,$AN$4:$AP$38,2,FALSE)","v":""},{"$f":"VLOOKUP(BB4,$AN$4:$AP$38,3,FALSE)","v":""},null,0,{"$f":"3-(BF4*$AH$40)","v":{"$error":"#DIV/0!"}},{"$f":"IF(BG4>0,BG4,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"3-(BF4*$AL$40)","v":{"$error":"#DIV/0!"}},{"$f":"IF(BI4>0,BI4,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF($BN$4>1,\"\",IF($BN$4=1,(2-(B4*0.5)+0.5),(2-(B4*0.4)+0.4)))","v":""},{"$f":"IF(BK4>2,\"\",BK4)","v":""},"Poule 1 ",{"$f":"COUNTBLANK(B4:B8)","v":5},null,null,{"$f":"IF(AH4=0,AE4,100)","v":100},{"$f":"RANK(BQ4,$BQ$4:$BQ$38,1)","v":1},{"$f":"IF(AH4=1,\"\",AE4)","v":""},{"$f":"IF(AH4=1,\"\",AF4)","v":""},1,{"$f":"IFERROR(VLOOKUP(BU4,$BR$4:$BT$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BU4,$BR$4:$BT$38,3,FALSE),\"\")","v":""},null,{"$f":"IF(AL4=0,AI4,100)","v":100},{"$f":"RANK(BY4,$BY$4:$BY$38,1)","v":1},{"$f":"IF(AL4=1,\"\",AI4)","v":""},{"$f":"IF(AL4=1,\"\",AJ4)","v":""},1,{"$f":"IFERROR(VLOOKUP(CC4,$BZ$4:$CB$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CC4,$BZ$4:$CB$38,3,FALSE),\"\")","v":""},null,{"$f":"IF(AQ4=0,AM4,100)","v":100},{"$f":"RANK(CG4,$CG$4:$CG$38,1)","v":1},{"$f":"IF(AQ4=1,\"\",AM4)","v":""},{"$f":"IF(AQ4=1,\"\",AN4)","v":""},1,{"$f":"IFERROR(VLOOKUP(CK4,$CH$4:$CJ$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CK4,$CH$4:$CJ$38,3,FALSE),\"\")","v":""},null,{"$f":"IF(ISTEXT(C4),C4,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO4)=0,\"\",COUNTIF(Plage,\"<=\"&$CO4))","v":""},{"$f":"IFERROR(RANK(CP4,$CP$4:$CP$39,1),\"\")","v":""},{"$f":"CO4","v":""},1,{"$f":"IFERROR(VLOOKUP(CS4,$CQ$4:$CR$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CT4,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY4,0),\"\")","v":""},{"$f":"IFERROR(ROUND(CZ4,1),\"\")","v":""},{"$f":"IFERROR(ROUND(DA4,1),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CT4,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU4=\"G\",VLOOKUP(CT4,Gars,2,FALSE),VLOOKUP(CT4,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU4=\"G\",VLOOKUP(CT4,Gars,3,FALSE),VLOOKUP(CT4,Fille,3,FALSE)),\"\")","v":""}]
[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,{"$f":"IF(AF5=\"\",\"\",AM5)","v":""},"",{"$f":"IF(AO5=\"F\",AP5,\"\")","v":""},{"$f":"COUNTIF(AF5,\"\")","v":1},{"$f":"IF(AJ5=\"\",\"\",AM5)","v":""},"",{"$f":"IF(AO5=\"G\",AP5,\"\")","v":""},{"$f":"COUNTIF(AJ5,\"\")","v":1},{"$f":"IF(B5=\"\",\"\",B5)","v":""},"","",{"$f":"IF(BL5=\"\",\"\",BL5)","v":""},{"$f":"COUNTIF(AN5,\"\")","v":1},null,{"$f":"BV5","v":""},{"$f":"BW5","v":""},{"$f":"BH5","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT5,$AF$4:$AG$38,2,FALSE)","v":""},{"$f":"CD5","v":""},{"$f":"CE5","v":""},{"$f":"BJ5","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX5,$AJ$4:$AK$38,2,FALSE)","v":""},{"$f":"CL5","v":""},{"$f":"CM5","v":""},{"$f":"VLOOKUP(BB5,$AN$4:$AP$38,2,FALSE)","v":""},{"$f":"VLOOKUP(BB5,$AN$4:$AP$38,3,FALSE)","v":""},null,1,{"$f":"3-(BF5*$AH$40)","v":{"$error":"#DIV/0!"}},{"$f":"IF(BG5>0,BG5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"3-(BF5*$AL$40)","v":{"$error":"#DIV/0!"}},{"$f":"IF(BI5>0,BI5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF($BN$4>1,\"\",IF($BN$4=1,(2-(B5*0.5)+0.5),(2-(B5*0.4)+0.4)))","v":""},{"$f":"IF(BK5>2,\"\",BK5)","v":""},"Poule 2",{"$f":"COUNTBLANK(B9:B13)","v":5},null,null,{"$f":"IF(AH5=0,AE5,100)","v":100},{"$f":"RANK(BQ5,$BQ$4:$BQ$38,1)","v":1},{"$f":"IF(AH5=1,\"\",AE5)","v":""},{"$f":"IF(AH5=1,\"\",AF5)","v":""},2,{"$f":"IFERROR(VLOOKUP(BU5,$BR$4:$BT$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BU5,$BR$4:$BT$38,3,FALSE),\"\")","v":""},null,{"$f":"IF(AL5=0,AI5,100)","v":100},{"$f":"RANK(BY5,$BY$4:$BY$38,1)","v":1},{"$f":"IF(AL5=1,\"\",AI5)","v":""},{"$f":"IF(AL5=1,\"\",AJ5)","v":""},2,{"$f":"IFERROR(VLOOKUP(CC5,$BZ$4:$CB$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CC5,$BZ$4:$CB$38,3,FALSE),\"\")","v":""},null,{"$f":"IF(AQ5=0,AM5,100)","v":100},{"$f":"RANK(CG5,$CG$4:$CG$38,1)","v":1},{"$f":"IF(AQ5=1,\"\",AM5)","v":""},{"$f":"IF(AQ5=1,\"\",AN5)","v":""},2,{"$f":"IFERROR(VLOOKUP(CK5,$CH$4:$CJ$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CK5,$CH$4:$CJ$38,3,FALSE),\"\")","v":""},null,{"$f":"IF(ISTEXT(C5),C5,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO5)=0,\"\",COUNTIF(Plage,\"<=\"&$CO5))","v":""},{"$f":"IFERROR(RANK(CP5,$CP$4:$CP$39,1),\"\")","v":""},{"$f":"CO5","v":""},2,{"$f":"IFERROR(VLOOKUP(CS5,$CQ$4:$CR$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CT5,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY5,0),\"\")","v":""},{"$f":"IFERROR(ROUND(CZ5,1),\"\")","v":""},{"$f":"IFERROR(ROUND(DA5,1),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CT5,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU5=\"G\",VLOOKUP(CT5,Gars,2,FALSE),VLOOKUP(CT5,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU5=\"G\",VLOOKUP(CT5,Gars,3,FALSE),VLOOKUP(CT5,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B6=\"\",\"\",B6)","v":""},"","","",1,null,"","",{"$f":"BH6","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT6,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ6","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX6,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$4>1,\"\",IF($BN$4=1,(2-(B6*0.5)+0.5),(2-(B6*0.4)+0.4)))","v":""},"","Poule 3",{"$f":"COUNTBLANK(B14:B18)","v":5},null,null,{"$f":"IF(AH6=0,AE6,100)","v":100},1,{"$f":"IF(AH6=1,\"\",AE6)","v":""},{"$f":"IF(AH6=1,\"\",AF6)","v":""},3,"","",null,{"$f":"IF(AL6=0,AI6,100)","v":100},1,{"$f":"IF(AL6=1,\"\",AI6)","v":""},{"$f":"IF(AL6=1,\"\",AJ6)","v":""},3,"","",null,{"$f":"IF(AQ6=0,AM6,100)","v":100},1,{"$f":"IF(AQ6=1,\"\",AM6)","v":""},{"$f":"IF(AQ6=1,\"\",AN6)","v":""},3,"","",null,{"$f":"IF(ISTEXT(C6),C6,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO6)=0,\"\",COUNTIF(Plage,\"<=\"&$CO6))","v":""},"","",3,"",{"$f":"IFERROR(VLOOKUP(CT6,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY6,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT6,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU6=\"G\",VLOOKUP(CT6,Gars,2,FALSE),VLOOKUP(CT6,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU6=\"G\",VLOOKUP(CT6,Gars,3,FALSE),VLOOKUP(CT6,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B7=\"\",\"\",B7)","v":""},"","","",1,null,"","",{"$f":"BH7","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT7,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ7","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX7,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,3,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$4>1,\"\",IF($BN$4=1,(2-(B7*0.5)+0.5),(2-(B7*0.4)+0.4)))","v":""},"","Poule 4",{"$f":"COUNTBLANK(B19:B23)","v":5},null,null,{"$f":"IF(AH7=0,AE7,100)","v":100},1,{"$f":"IF(AH7=1,\"\",AE7)","v":""},{"$f":"IF(AH7=1,\"\",AF7)","v":""},4,"","",null,{"$f":"IF(AL7=0,AI7,100)","v":100},1,{"$f":"IF(AL7=1,\"\",AI7)","v":""},{"$f":"IF(AL7=1,\"\",AJ7)","v":""},4,"","",null,{"$f":"IF(AQ7=0,AM7,100)","v":100},1,{"$f":"IF(AQ7=1,\"\",AM7)","v":""},{"$f":"IF(AQ7=1,\"\",AN7)","v":""},4,"","",null,{"$f":"IF(ISTEXT(C7),C7,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO7)=0,\"\",COUNTIF(Plage,\"<=\"&$CO7))","v":""},"","",4,"",{"$f":"IFERROR(VLOOKUP(CT7,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY7,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT7,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU7=\"G\",VLOOKUP(CT7,Gars,2,FALSE),VLOOKUP(CT7,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU7=\"G\",VLOOKUP(CT7,Gars,3,FALSE),VLOOKUP(CT7,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B8=\"\",\"\",B8)","v":""},"","","",1,null,"","",{"$f":"BH8","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT8,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ8","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX8,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,4,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$4>1,\"\",IF($BN$4=1,(2-(B8*0.5)+0.5),(2-(B8*0.4)+0.4)))","v":""},"","Poule 5",{"$f":"COUNTBLANK(B24:B28)","v":5},null,null,{"$f":"IF(AH8=0,AE8,100)","v":100},1,{"$f":"IF(AH8=1,\"\",AE8)","v":""},{"$f":"IF(AH8=1,\"\",AF8)","v":""},5,"","",null,{"$f":"IF(AL8=0,AI8,100)","v":100},1,{"$f":"IF(AL8=1,\"\",AI8)","v":""},{"$f":"IF(AL8=1,\"\",AJ8)","v":""},5,"","",null,{"$f":"IF(AQ8=0,AM8,100)","v":100},1,{"$f":"IF(AQ8=1,\"\",AM8)","v":""},{"$f":"IF(AQ8=1,\"\",AN8)","v":""},5,"","",null,{"$f":"IF(ISTEXT(C8),C8,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO8)=0,\"\",COUNTIF(Plage,\"<=\"&$CO8))","v":""},"","",5,"",{"$f":"IFERROR(VLOOKUP(CT8,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY8,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT8,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU8=\"G\",VLOOKUP(CT8,Gars,2,FALSE),VLOOKUP(CT8,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU8=\"G\",VLOOKUP(CT8,Gars,3,FALSE),VLOOKUP(CT8,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B9=\"\",\"\",IF($B$8=\"\",B9+4,B9+5))","v":""},"","","",1,null,"","",{"$f":"BH9","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT9,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ9","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX9,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$5>1,\"\",IF($BN$5=1,(2-(B9*0.5)+0.5),(2-(B9*0.4)+0.4)))","v":""},"","Poule 6",{"$f":"COUNTBLANK(B29:B33)","v":5},null,null,{"$f":"IF(AH9=0,AE9,100)","v":100},1,{"$f":"IF(AH9=1,\"\",AE9)","v":""},{"$f":"IF(AH9=1,\"\",AF9)","v":""},6,"","",null,{"$f":"IF(AL9=0,AI9,100)","v":100},1,{"$f":"IF(AL9=1,\"\",AI9)","v":""},{"$f":"IF(AL9=1,\"\",AJ9)","v":""},6,"","",null,{"$f":"IF(AQ9=0,AM9,100)","v":100},1,{"$f":"IF(AQ9=1,\"\",AM9)","v":""},{"$f":"IF(AQ9=1,\"\",AN9)","v":""},6,"","",null,{"$f":"IF(ISTEXT(C9),C9,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO9)=0,\"\",COUNTIF(Plage,\"<=\"&$CO9))","v":""},"","",6,"",{"$f":"IFERROR(VLOOKUP(CT9,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY9,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT9,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU9=\"G\",VLOOKUP(CT9,Gars,2,FALSE),VLOOKUP(CT9,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU9=\"G\",VLOOKUP(CT9,Gars,3,FALSE),VLOOKUP(CT9,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B10=\"\",\"\",IF($B$8=\"\",B10+4,B10+5))","v":""},"","","",1,null,"","",{"$f":"BH10","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT10,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ10","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX10,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,6,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$5>1,\"\",IF($BN$5=1,(2-(B10*0.5)+0.5),(2-(B10*0.4)+0.4)))","v":""},"","Poule 7",{"$f":"COUNTBLANK(B34:B38)","v":5},null,null,{"$f":"IF(AH10=0,AE10,100)","v":100},1,{"$f":"IF(AH10=1,\"\",AE10)","v":""},{"$f":"IF(AH10=1,\"\",AF10)","v":""},7,"","",null,{"$f":"IF(AL10=0,AI10,100)","v":100},1,{"$f":"IF(AL10=1,\"\",AI10)","v":""},{"$f":"IF(AL10=1,\"\",AJ10)","v":""},7,"","",null,{"$f":"IF(AQ10=0,AM10,100)","v":100},1,{"$f":"IF(AQ10=1,\"\",AM10)","v":""},{"$f":"IF(AQ10=1,\"\",AN10)","v":""},7,"","",null,{"$f":"IF(ISTEXT(C10),C10,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO10)=0,\"\",COUNTIF(Plage,\"<=\"&$CO10))","v":""},"","",7,"",{"$f":"IFERROR(VLOOKUP(CT10,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY10,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT10,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU10=\"G\",VLOOKUP(CT10,Gars,2,FALSE),VLOOKUP(CT10,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU10=\"G\",VLOOKUP(CT10,Gars,3,FALSE),VLOOKUP(CT10,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B11=\"\",\"\",IF($B$8=\"\",B11+4,B11+5))","v":""},"","","",1,null,"","",{"$f":"BH11","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT11,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ11","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX11,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,7,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$5>1,\"\",IF($BN$5=1,(2-(B11*0.5)+0.5),(2-(B11*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH11=0,AE11,100)","v":100},1,{"$f":"IF(AH11=1,\"\",AE11)","v":""},{"$f":"IF(AH11=1,\"\",AF11)","v":""},8,"","",null,{"$f":"IF(AL11=0,AI11,100)","v":100},1,{"$f":"IF(AL11=1,\"\",AI11)","v":""},{"$f":"IF(AL11=1,\"\",AJ11)","v":""},8,"","",null,{"$f":"IF(AQ11=0,AM11,100)","v":100},1,{"$f":"IF(AQ11=1,\"\",AM11)","v":""},{"$f":"IF(AQ11=1,\"\",AN11)","v":""},8,"","",null,{"$f":"IF(ISTEXT(C11),C11,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO11)=0,\"\",COUNTIF(Plage,\"<=\"&$CO11))","v":""},"","",8,"",{"$f":"IFERROR(VLOOKUP(CT11,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY11,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT11,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU11=\"G\",VLOOKUP(CT11,Gars,2,FALSE),VLOOKUP(CT11,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU11=\"G\",VLOOKUP(CT11,Gars,3,FALSE),VLOOKUP(CT11,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B12=\"\",\"\",IF($B$8=\"\",B12+4,B12+5))","v":""},"","","",1,null,"","",{"$f":"BH12","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT12,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ12","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX12,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,8,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$5>1,\"\",IF($BN$5=1,(2-(B12*0.5)+0.5),(2-(B12*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH12=0,AE12,100)","v":100},1,{"$f":"IF(AH12=1,\"\",AE12)","v":""},{"$f":"IF(AH12=1,\"\",AF12)","v":""},9,"","",null,{"$f":"IF(AL12=0,AI12,100)","v":100},1,{"$f":"IF(AL12=1,\"\",AI12)","v":""},{"$f":"IF(AL12=1,\"\",AJ12)","v":""},9,"","",null,{"$f":"IF(AQ12=0,AM12,100)","v":100},1,{"$f":"IF(AQ12=1,\"\",AM12)","v":""},{"$f":"IF(AQ12=1,\"\",AN12)","v":""},9,"","",null,{"$f":"IF(ISTEXT(C12),C12,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO12)=0,\"\",COUNTIF(Plage,\"<=\"&$CO12))","v":""},"","",9,"",{"$f":"IFERROR(VLOOKUP(CT12,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY12,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT12,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU12=\"G\",VLOOKUP(CT12,Gars,2,FALSE),VLOOKUP(CT12,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU12=\"G\",VLOOKUP(CT12,Gars,3,FALSE),VLOOKUP(CT12,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B13=\"\",\"\",IF($B$8=\"\",B13+4,B13+5))","v":""},"","","",1,null,"","",{"$f":"BH13","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT13,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ13","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX13,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$5>1,\"\",IF($BN$5=1,(2-(B13*0.5)+0.5),(2-(B13*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH13=0,AE13,100)","v":100},1,{"$f":"IF(AH13=1,\"\",AE13)","v":""},{"$f":"IF(AH13=1,\"\",AF13)","v":""},10,"","",null,{"$f":"IF(AL13=0,AI13,100)","v":100},1,{"$f":"IF(AL13=1,\"\",AI13)","v":""},{"$f":"IF(AL13=1,\"\",AJ13)","v":""},10,"","",null,{"$f":"IF(AQ13=0,AM13,100)","v":100},1,{"$f":"IF(AQ13=1,\"\",AM13)","v":""},{"$f":"IF(AQ13=1,\"\",AN13)","v":""},10,"","",null,{"$f":"IF(ISTEXT(C13),C13,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO13)=0,\"\",COUNTIF(Plage,\"<=\"&$CO13))","v":""},"","",10,"",{"$f":"IFERROR(VLOOKUP(CT13,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY13,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT13,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU13=\"G\",VLOOKUP(CT13,Gars,2,FALSE),VLOOKUP(CT13,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU13=\"G\",VLOOKUP(CT13,Gars,3,FALSE),VLOOKUP(CT13,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B14=\"\",\"\",IF($AN$47=2,B14+8,IF($AN$47=1,B14+9,B14+10)))","v":""},"","","",1,null,"","",{"$f":"BH14","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT14,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ14","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX14,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,10,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$6>1,\"\",IF($BN$6=1,(2-(B14*0.5)+0.5),(2-(B14*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH14=0,AE14,100)","v":100},1,{"$f":"IF(AH14=1,\"\",AE14)","v":""},{"$f":"IF(AH14=1,\"\",AF14)","v":""},11,"","",null,{"$f":"IF(AL14=0,AI14,100)","v":100},1,{"$f":"IF(AL14=1,\"\",AI14)","v":""},{"$f":"IF(AL14=1,\"\",AJ14)","v":""},11,"","",null,{"$f":"IF(AQ14=0,AM14,100)","v":100},1,{"$f":"IF(AQ14=1,\"\",AM14)","v":""},{"$f":"IF(AQ14=1,\"\",AN14)","v":""},11,"","",null,{"$f":"IF(ISTEXT(C14),C14,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO14)=0,\"\",COUNTIF(Plage,\"<=\"&$CO14))","v":""},"","",11,"",{"$f":"IFERROR(VLOOKUP(CT14,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY14,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT14,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU14=\"G\",VLOOKUP(CT14,Gars,2,FALSE),VLOOKUP(CT14,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU14=\"G\",VLOOKUP(CT14,Gars,3,FALSE),VLOOKUP(CT14,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B15=\"\",\"\",IF($AN$47=2,B15+8,IF($AN$47=1,B15+9,B15+10)))","v":""},"","","",1,null,"","",{"$f":"BH15","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT15,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ15","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX15,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,11,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$6>1,\"\",IF($BN$6=1,(2-(B15*0.5)+0.5),(2-(B15*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH15=0,AE15,100)","v":100},1,{"$f":"IF(AH15=1,\"\",AE15)","v":""},{"$f":"IF(AH15=1,\"\",AF15)","v":""},12,"","",null,{"$f":"IF(AL15=0,AI15,100)","v":100},1,{"$f":"IF(AL15=1,\"\",AI15)","v":""},{"$f":"IF(AL15=1,\"\",AJ15)","v":""},12,"","",null,{"$f":"IF(AQ15=0,AM15,100)","v":100},1,{"$f":"IF(AQ15=1,\"\",AM15)","v":""},{"$f":"IF(AQ15=1,\"\",AN15)","v":""},12,"","",null,{"$f":"IF(ISTEXT(C15),C15,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO15)=0,\"\",COUNTIF(Plage,\"<=\"&$CO15))","v":""},"","",12,"",{"$f":"IFERROR(VLOOKUP(CT15,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY15,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT15,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU15=\"G\",VLOOKUP(CT15,Gars,2,FALSE),VLOOKUP(CT15,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU15=\"G\",VLOOKUP(CT15,Gars,3,FALSE),VLOOKUP(CT15,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B16=\"\",\"\",IF($AN$47=2,B16+8,IF($AN$47=1,B16+9,B16+10)))","v":""},"","","",1,null,"","",{"$f":"BH16","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT16,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ16","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX16,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,12,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$6>1,\"\",IF($BN$6=1,(2-(B16*0.5)+0.5),(2-(B16*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH16=0,AE16,100)","v":100},1,{"$f":"IF(AH16=1,\"\",AE16)","v":""},{"$f":"IF(AH16=1,\"\",AF16)","v":""},13,"","",null,{"$f":"IF(AL16=0,AI16,100)","v":100},1,{"$f":"IF(AL16=1,\"\",AI16)","v":""},{"$f":"IF(AL16=1,\"\",AJ16)","v":""},13,"","",null,{"$f":"IF(AQ16=0,AM16,100)","v":100},1,{"$f":"IF(AQ16=1,\"\",AM16)","v":""},{"$f":"IF(AQ16=1,\"\",AN16)","v":""},13,"","",null,{"$f":"IF(ISTEXT(C16),C16,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO16)=0,\"\",COUNTIF(Plage,\"<=\"&$CO16))","v":""},"","",13,"",{"$f":"IFERROR(VLOOKUP(CT16,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY16,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT16,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU16=\"G\",VLOOKUP(CT16,Gars,2,FALSE),VLOOKUP(CT16,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU16=\"G\",VLOOKUP(CT16,Gars,3,FALSE),VLOOKUP(CT16,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B17=\"\",\"\",IF($AN$47=2,B17+8,IF($AN$47=1,B17+9,B17+10)))","v":""},"","","",1,null,"","",{"$f":"BH17","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT17,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ17","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX17,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,13,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$6>1,\"\",IF($BN$6=1,(2-(B17*0.5)+0.5),(2-(B17*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH17=0,AE17,100)","v":100},1,{"$f":"IF(AH17=1,\"\",AE17)","v":""},{"$f":"IF(AH17=1,\"\",AF17)","v":""},14,"","",null,{"$f":"IF(AL17=0,AI17,100)","v":100},1,{"$f":"IF(AL17=1,\"\",AI17)","v":""},{"$f":"IF(AL17=1,\"\",AJ17)","v":""},14,"","",null,{"$f":"IF(AQ17=0,AM17,100)","v":100},1,{"$f":"IF(AQ17=1,\"\",AM17)","v":""},{"$f":"IF(AQ17=1,\"\",AN17)","v":""},14,"","",null,{"$f":"IF(ISTEXT(C17),C17,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO17)=0,\"\",COUNTIF(Plage,\"<=\"&$CO17))","v":""},"","",14,"",{"$f":"IFERROR(VLOOKUP(CT17,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY17,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT17,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU17=\"G\",VLOOKUP(CT17,Gars,2,FALSE),VLOOKUP(CT17,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU17=\"G\",VLOOKUP(CT17,Gars,3,FALSE),VLOOKUP(CT17,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B18=\"\",\"\",IF($AN$47=2,B18+8,IF($AN$47=1,B18+9,B18+10)))","v":""},"","","",1,null,"","",{"$f":"BH18","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT18,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ18","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX18,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,14,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$6>1,\"\",IF($BN$6=1,(2-(B18*0.5)+0.5),(2-(B18*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH18=0,AE18,100)","v":100},1,{"$f":"IF(AH18=1,\"\",AE18)","v":""},{"$f":"IF(AH18=1,\"\",AF18)","v":""},15,"","",null,{"$f":"IF(AL18=0,AI18,100)","v":100},1,{"$f":"IF(AL18=1,\"\",AI18)","v":""},{"$f":"IF(AL18=1,\"\",AJ18)","v":""},15,"","",null,{"$f":"IF(AQ18=0,AM18,100)","v":100},1,{"$f":"IF(AQ18=1,\"\",AM18)","v":""},{"$f":"IF(AQ18=1,\"\",AN18)","v":""},15,"","",null,{"$f":"IF(ISTEXT(C18),C18,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO18)=0,\"\",COUNTIF(Plage,\"<=\"&$CO18))","v":""},"","",15,"",{"$f":"IFERROR(VLOOKUP(CT18,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY18,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT18,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU18=\"G\",VLOOKUP(CT18,Gars,2,FALSE),VLOOKUP(CT18,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU18=\"G\",VLOOKUP(CT18,Gars,3,FALSE),VLOOKUP(CT18,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B19=\"\",\"\",IF($AN$48=3,B19+12,IF($AN$48=2,B19+13,IF($AN$48=1,B19+14,B19+15))))","v":""},"","","",1,null,"","",{"$f":"BH19","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT19,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ19","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX19,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,15,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$7>1,\"\",IF($BN$7=1,(2-(B19*0.5)+0.5),(2-(B19*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH19=0,AE19,100)","v":100},1,{"$f":"IF(AH19=1,\"\",AE19)","v":""},{"$f":"IF(AH19=1,\"\",AF19)","v":""},16,"","",null,{"$f":"IF(AL19=0,AI19,100)","v":100},1,{"$f":"IF(AL19=1,\"\",AI19)","v":""},{"$f":"IF(AL19=1,\"\",AJ19)","v":""},16,"","",null,{"$f":"IF(AQ19=0,AM19,100)","v":100},1,{"$f":"IF(AQ19=1,\"\",AM19)","v":""},{"$f":"IF(AQ19=1,\"\",AN19)","v":""},16,"","",null,{"$f":"IF(ISTEXT(C19),C19,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO19)=0,\"\",COUNTIF(Plage,\"<=\"&$CO19))","v":""},"","",16,"",{"$f":"IFERROR(VLOOKUP(CT19,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY19,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT19,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU19=\"G\",VLOOKUP(CT19,Gars,2,FALSE),VLOOKUP(CT19,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU19=\"G\",VLOOKUP(CT19,Gars,3,FALSE),VLOOKUP(CT19,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B20=\"\",\"\",IF($AN$48=3,B20+12,IF($AN$48=2,B20+13,IF($AN$48=1,B20+14,B20+15))))","v":""},"","","",1,null,"","",{"$f":"BH20","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT20,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ20","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX20,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,16,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$7>1,\"\",IF($BN$7=1,(2-(B20*0.5)+0.5),(2-(B20*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH20=0,AE20,100)","v":100},1,{"$f":"IF(AH20=1,\"\",AE20)","v":""},{"$f":"IF(AH20=1,\"\",AF20)","v":""},17,"","",null,{"$f":"IF(AL20=0,AI20,100)","v":100},1,{"$f":"IF(AL20=1,\"\",AI20)","v":""},{"$f":"IF(AL20=1,\"\",AJ20)","v":""},17,"","",null,{"$f":"IF(AQ20=0,AM20,100)","v":100},1,{"$f":"IF(AQ20=1,\"\",AM20)","v":""},{"$f":"IF(AQ20=1,\"\",AN20)","v":""},17,"","",null,{"$f":"IF(ISTEXT(C20),C20,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO20)=0,\"\",COUNTIF(Plage,\"<=\"&$CO20))","v":""},"","",17,"",{"$f":"IFERROR(VLOOKUP(CT20,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY20,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT20,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU20=\"G\",VLOOKUP(CT20,Gars,2,FALSE),VLOOKUP(CT20,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU20=\"G\",VLOOKUP(CT20,Gars,3,FALSE),VLOOKUP(CT20,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B21=\"\",\"\",IF($AN$48=3,B21+12,IF($AN$48=2,B21+13,IF($AN$48=1,B21+14,B21+15))))","v":""},"","","",1,null,"","",{"$f":"BH21","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT21,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ21","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX21,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,17,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$7>1,\"\",IF($BN$7=1,(2-(B21*0.5)+0.5),(2-(B21*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH21=0,AE21,100)","v":100},1,{"$f":"IF(AH21=1,\"\",AE21)","v":""},{"$f":"IF(AH21=1,\"\",AF21)","v":""},18,"","",null,{"$f":"IF(AL21=0,AI21,100)","v":100},1,{"$f":"IF(AL21=1,\"\",AI21)","v":""},{"$f":"IF(AL21=1,\"\",AJ21)","v":""},18,"","",null,{"$f":"IF(AQ21=0,AM21,100)","v":100},1,{"$f":"IF(AQ21=1,\"\",AM21)","v":""},{"$f":"IF(AQ21=1,\"\",AN21)","v":""},18,"","",null,{"$f":"IF(ISTEXT(C21),C21,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO21)=0,\"\",COUNTIF(Plage,\"<=\"&$CO21))","v":""},"","",18,"",{"$f":"IFERROR(VLOOKUP(CT21,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY21,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT21,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU21=\"G\",VLOOKUP(CT21,Gars,2,FALSE),VLOOKUP(CT21,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU21=\"G\",VLOOKUP(CT21,Gars,3,FALSE),VLOOKUP(CT21,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B22=\"\",\"\",IF($AN$48=3,B22+12,IF($AN$48=2,B22+13,IF($AN$48=1,B22+14,B22+15))))","v":""},"","","",1,null,"","",{"$f":"BH22","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT22,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ22","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX22,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,18,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$7>1,\"\",IF($BN$7=1,(2-(B22*0.5)+0.5),(2-(B22*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH22=0,AE22,100)","v":100},1,{"$f":"IF(AH22=1,\"\",AE22)","v":""},{"$f":"IF(AH22=1,\"\",AF22)","v":""},19,"","",null,{"$f":"IF(AL22=0,AI22,100)","v":100},1,{"$f":"IF(AL22=1,\"\",AI22)","v":""},{"$f":"IF(AL22=1,\"\",AJ22)","v":""},19,"","",null,{"$f":"IF(AQ22=0,AM22,100)","v":100},1,{"$f":"IF(AQ22=1,\"\",AM22)","v":""},{"$f":"IF(AQ22=1,\"\",AN22)","v":""},19,"","",null,{"$f":"IF(ISTEXT(C22),C22,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO22)=0,\"\",COUNTIF(Plage,\"<=\"&$CO22))","v":""},"","",19,"",{"$f":"IFERROR(VLOOKUP(CT22,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY22,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT22,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU22=\"G\",VLOOKUP(CT22,Gars,2,FALSE),VLOOKUP(CT22,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU22=\"G\",VLOOKUP(CT22,Gars,3,FALSE),VLOOKUP(CT22,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B23=\"\",\"\",IF($AN$48=3,B23+12,IF($AN$48=2,B23+13,IF($AN$48=1,B23+14,B23+15))))","v":""},"","","",1,null,"","",{"$f":"BH23","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT23,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ23","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX23,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,19,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$7>1,\"\",IF($BN$7=1,(2-(B23*0.5)+0.5),(2-(B23*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH23=0,AE23,100)","v":100},1,{"$f":"IF(AH23=1,\"\",AE23)","v":""},{"$f":"IF(AH23=1,\"\",AF23)","v":""},20,"","",null,{"$f":"IF(AL23=0,AI23,100)","v":100},1,{"$f":"IF(AL23=1,\"\",AI23)","v":""},{"$f":"IF(AL23=1,\"\",AJ23)","v":""},20,"","",null,{"$f":"IF(AQ23=0,AM23,100)","v":100},1,{"$f":"IF(AQ23=1,\"\",AM23)","v":""},{"$f":"IF(AQ23=1,\"\",AN23)","v":""},20,"","",null,{"$f":"IF(ISTEXT(C23),C23,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO23)=0,\"\",COUNTIF(Plage,\"<=\"&$CO23))","v":""},"","",20,"",{"$f":"IFERROR(VLOOKUP(CT23,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY23,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT23,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU23=\"G\",VLOOKUP(CT23,Gars,2,FALSE),VLOOKUP(CT23,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU23=\"G\",VLOOKUP(CT23,Gars,3,FALSE),VLOOKUP(CT23,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B24=\"\",\"\",IF($AN$49=4,B24+16,IF($AN$49=3,B24+17,IF($AN$49=2,B24+18,IF($AN$49=1,B24+19,B24+20)))))","v":""},"","","",1,null,"","",{"$f":"BH24","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT24,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ24","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX24,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,20,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$8>1,\"\",IF($BN$8=1,(2-(B24*0.5)+0.5),(2-(B24*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH24=0,AE24,100)","v":100},1,{"$f":"IF(AH24=1,\"\",AE24)","v":""},{"$f":"IF(AH24=1,\"\",AF24)","v":""},21,"","",null,{"$f":"IF(AL24=0,AI24,100)","v":100},1,{"$f":"IF(AL24=1,\"\",AI24)","v":""},{"$f":"IF(AL24=1,\"\",AJ24)","v":""},21,"","",null,{"$f":"IF(AQ24=0,AM24,100)","v":100},1,{"$f":"IF(AQ24=1,\"\",AM24)","v":""},{"$f":"IF(AQ24=1,\"\",AN24)","v":""},21,"","",null,{"$f":"IF(ISTEXT(C24),C24,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO24)=0,\"\",COUNTIF(Plage,\"<=\"&$CO24))","v":""},"","",21,"",{"$f":"IFERROR(VLOOKUP(CT24,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY24,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT24,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU24=\"G\",VLOOKUP(CT24,Gars,2,FALSE),VLOOKUP(CT24,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU24=\"G\",VLOOKUP(CT24,Gars,3,FALSE),VLOOKUP(CT24,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B25=\"\",\"\",IF($AN$49=4,B25+16,IF($AN$49=3,B25+17,IF($AN$49=2,B25+18,IF($AN$49=1,B25+19,B25+20)))))","v":""},"","","",1,null,"","",{"$f":"BH25","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT25,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ25","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX25,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,21,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$8>1,\"\",IF($BN$8=1,(2-(B25*0.5)+0.5),(2-(B25*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH25=0,AE25,100)","v":100},1,{"$f":"IF(AH25=1,\"\",AE25)","v":""},{"$f":"IF(AH25=1,\"\",AF25)","v":""},22,"","",null,{"$f":"IF(AL25=0,AI25,100)","v":100},1,{"$f":"IF(AL25=1,\"\",AI25)","v":""},{"$f":"IF(AL25=1,\"\",AJ25)","v":""},22,"","",null,{"$f":"IF(AQ25=0,AM25,100)","v":100},1,{"$f":"IF(AQ25=1,\"\",AM25)","v":""},{"$f":"IF(AQ25=1,\"\",AN25)","v":""},22,"","",null,{"$f":"IF(ISTEXT(C25),C25,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO25)=0,\"\",COUNTIF(Plage,\"<=\"&$CO25))","v":""},"","",22,"",{"$f":"IFERROR(VLOOKUP(CT25,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY25,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT25,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU25=\"G\",VLOOKUP(CT25,Gars,2,FALSE),VLOOKUP(CT25,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU25=\"G\",VLOOKUP(CT25,Gars,3,FALSE),VLOOKUP(CT25,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B26=\"\",\"\",IF($AN$49=4,B26+16,IF($AN$49=3,B26+17,IF($AN$49=2,B26+18,IF($AN$49=1,B26+19,B26+20)))))","v":""},"","","",1,null,"","",{"$f":"BH26","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT26,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ26","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX26,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,22,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$8>1,\"\",IF($BN$8=1,(2-(B26*0.5)+0.5),(2-(B26*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH26=0,AE26,100)","v":100},1,{"$f":"IF(AH26=1,\"\",AE26)","v":""},{"$f":"IF(AH26=1,\"\",AF26)","v":""},23,"","",null,{"$f":"IF(AL26=0,AI26,100)","v":100},1,{"$f":"IF(AL26=1,\"\",AI26)","v":""},{"$f":"IF(AL26=1,\"\",AJ26)","v":""},23,"","",null,{"$f":"IF(AQ26=0,AM26,100)","v":100},1,{"$f":"IF(AQ26=1,\"\",AM26)","v":""},{"$f":"IF(AQ26=1,\"\",AN26)","v":""},23,"","",null,{"$f":"IF(ISTEXT(C26),C26,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO26)=0,\"\",COUNTIF(Plage,\"<=\"&$CO26))","v":""},"","",23,"",{"$f":"IFERROR(VLOOKUP(CT26,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY26,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT26,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU26=\"G\",VLOOKUP(CT26,Gars,2,FALSE),VLOOKUP(CT26,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU26=\"G\",VLOOKUP(CT26,Gars,3,FALSE),VLOOKUP(CT26,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B27=\"\",\"\",IF($AN$49=4,B27+16,IF($AN$49=3,B27+17,IF($AN$49=2,B27+18,IF($AN$49=1,B27+19,B27+20)))))","v":""},"","","",1,null,"","",{"$f":"BH27","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT27,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ27","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX27,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,23,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$8>1,\"\",IF($BN$8=1,(2-(B27*0.5)+0.5),(2-(B27*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH27=0,AE27,100)","v":100},1,{"$f":"IF(AH27=1,\"\",AE27)","v":""},{"$f":"IF(AH27=1,\"\",AF27)","v":""},24,"","",null,{"$f":"IF(AL27=0,AI27,100)","v":100},1,{"$f":"IF(AL27=1,\"\",AI27)","v":""},{"$f":"IF(AL27=1,\"\",AJ27)","v":""},24,"","",null,{"$f":"IF(AQ27=0,AM27,100)","v":100},1,{"$f":"IF(AQ27=1,\"\",AM27)","v":""},{"$f":"IF(AQ27=1,\"\",AN27)","v":""},24,"","",null,{"$f":"IF(ISTEXT(C27),C27,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO27)=0,\"\",COUNTIF(Plage,\"<=\"&$CO27))","v":""},"","",24,"",{"$f":"IFERROR(VLOOKUP(CT27,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY27,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT27,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU27=\"G\",VLOOKUP(CT27,Gars,2,FALSE),VLOOKUP(CT27,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU27=\"G\",VLOOKUP(CT27,Gars,3,FALSE),VLOOKUP(CT27,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B28=\"\",\"\",IF($AN$49=4,B28+16,IF($AN$49=3,B28+17,IF($AN$49=2,B28+18,IF($AN$49=1,B28+19,B28+20)))))","v":""},"","","",1,null,"","",{"$f":"BH28","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT28,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ28","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX28,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,24,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$8>1,\"\",IF($BN$8=1,(2-(B28*0.5)+0.5),(2-(B28*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH28=0,AE28,100)","v":100},1,{"$f":"IF(AH28=1,\"\",AE28)","v":""},{"$f":"IF(AH28=1,\"\",AF28)","v":""},25,"","",null,{"$f":"IF(AL28=0,AI28,100)","v":100},1,{"$f":"IF(AL28=1,\"\",AI28)","v":""},{"$f":"IF(AL28=1,\"\",AJ28)","v":""},25,"","",null,{"$f":"IF(AQ28=0,AM28,100)","v":100},1,{"$f":"IF(AQ28=1,\"\",AM28)","v":""},{"$f":"IF(AQ28=1,\"\",AN28)","v":""},25,"","",null,{"$f":"IF(ISTEXT(C28),C28,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO28)=0,\"\",COUNTIF(Plage,\"<=\"&$CO28))","v":""},"","",25,"",{"$f":"IFERROR(VLOOKUP(CT28,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY28,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT28,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU28=\"G\",VLOOKUP(CT28,Gars,2,FALSE),VLOOKUP(CT28,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU28=\"G\",VLOOKUP(CT28,Gars,3,FALSE),VLOOKUP(CT28,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,{"$f":"IF(B29=\"\",\"\",IF($AN$50=5,B29+20,IF($AN$50=4,B29+21,IF($AN$50=3,B29+22,IF($AN$50=2,B29+23,IF($AN$50=1,B29+14,B29+25))))))","v":""},"","","",1,null,"","",{"$f":"BH29","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT29,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ29","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX29,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,25,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$9>1,\"\",IF($BN$9=1,(2-(B29*0.5)+0.5),(2-(B29*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH29=0,AE29,100)","v":100},1,{"$f":"IF(AH29=1,\"\",AE29)","v":""},{"$f":"IF(AH29=1,\"\",AF29)","v":""},26,"","",null,{"$f":"IF(AL29=0,AI29,100)","v":100},1,{"$f":"IF(AL29=1,\"\",AI29)","v":""},{"$f":"IF(AL29=1,\"\",AJ29)","v":""},26,"","",null,{"$f":"IF(AQ29=0,AM29,100)","v":100},1,{"$f":"IF(AQ29=1,\"\",AM29)","v":""},{"$f":"IF(AQ29=1,\"\",AN29)","v":""},26,"","",null,{"$f":"IF(ISTEXT(C29),C29,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO29)=0,\"\",COUNTIF(Plage,\"<=\"&$CO29))","v":""},"","",26,"",{"$f":"IFERROR(VLOOKUP(CT29,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY29,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT29,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU29=\"G\",VLOOKUP(CT29,Gars,2,FALSE),VLOOKUP(CT29,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU29=\"G\",VLOOKUP(CT29,Gars,3,FALSE),VLOOKUP(CT29,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,"","","","",1,null,"","",{"$f":"BH30","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT30,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ30","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX30,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,26,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$9>1,\"\",IF($BN$9=1,(2-(B30*0.5)+0.5),(2-(B30*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH30=0,AE30,100)","v":100},1,{"$f":"IF(AH30=1,\"\",AE30)","v":""},{"$f":"IF(AH30=1,\"\",AF30)","v":""},27,"","",null,{"$f":"IF(AL30=0,AI30,100)","v":100},1,{"$f":"IF(AL30=1,\"\",AI30)","v":""},{"$f":"IF(AL30=1,\"\",AJ30)","v":""},27,"","",null,{"$f":"IF(AQ30=0,AM30,100)","v":100},1,{"$f":"IF(AQ30=1,\"\",AM30)","v":""},{"$f":"IF(AQ30=1,\"\",AN30)","v":""},27,"","",null,{"$f":"IF(ISTEXT(C30),C30,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO30)=0,\"\",COUNTIF(Plage,\"<=\"&$CO30))","v":""},"","",27,"",{"$f":"IFERROR(VLOOKUP(CT30,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY30,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT30,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU30=\"G\",VLOOKUP(CT30,Gars,2,FALSE),VLOOKUP(CT30,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU30=\"G\",VLOOKUP(CT30,Gars,3,FALSE),VLOOKUP(CT30,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,"","","","",1,null,"","",{"$f":"BH31","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT31,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ31","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX31,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,27,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$9>1,\"\",IF($BN$9=1,(2-(B31*0.5)+0.5),(2-(B31*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH31=0,AE31,100)","v":100},1,{"$f":"IF(AH31=1,\"\",AE31)","v":""},{"$f":"IF(AH31=1,\"\",AF31)","v":""},28,"","",null,{"$f":"IF(AL31=0,AI31,100)","v":100},1,{"$f":"IF(AL31=1,\"\",AI31)","v":""},{"$f":"IF(AL31=1,\"\",AJ31)","v":""},28,"","",null,{"$f":"IF(AQ31=0,AM31,100)","v":100},1,{"$f":"IF(AQ31=1,\"\",AM31)","v":""},{"$f":"IF(AQ31=1,\"\",AN31)","v":""},28,"","",null,{"$f":"IF(ISTEXT(C31),C31,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO31)=0,\"\",COUNTIF(Plage,\"<=\"&$CO31))","v":""},"","",28,"",{"$f":"IFERROR(VLOOKUP(CT31,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY31,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT31,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU31=\"G\",VLOOKUP(CT31,Gars,2,FALSE),VLOOKUP(CT31,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU31=\"G\",VLOOKUP(CT31,Gars,3,FALSE),VLOOKUP(CT31,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,"","","","",1,null,"","",{"$f":"BH32","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT32,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ32","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX32,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,28,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$9>1,\"\",IF($BN$9=1,(2-(B32*0.5)+0.5),(2-(B32*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH32=0,AE32,100)","v":100},1,{"$f":"IF(AH32=1,\"\",AE32)","v":""},{"$f":"IF(AH32=1,\"\",AF32)","v":""},29,"","",null,{"$f":"IF(AL32=0,AI32,100)","v":100},1,{"$f":"IF(AL32=1,\"\",AI32)","v":""},{"$f":"IF(AL32=1,\"\",AJ32)","v":""},29,"","",null,{"$f":"IF(AQ32=0,AM32,100)","v":100},1,{"$f":"IF(AQ32=1,\"\",AM32)","v":""},{"$f":"IF(AQ32=1,\"\",AN32)","v":""},29,"","",null,{"$f":"IF(ISTEXT(C32),C32,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO32)=0,\"\",COUNTIF(Plage,\"<=\"&$CO32))","v":""},"","",29,"",{"$f":"IFERROR(VLOOKUP(CT32,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY32,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT32,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU32=\"G\",VLOOKUP(CT32,Gars,2,FALSE),VLOOKUP(CT32,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU32=\"G\",VLOOKUP(CT32,Gars,3,FALSE),VLOOKUP(CT32,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",{"$f":"COUNTIF(AJ33,\"\")","v":1},"","","","",1,null,"","",{"$f":"BH33","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT33,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ33","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX33,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,29,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$9>1,\"\",IF($BN$9=1,(2-(B33*0.5)+0.5),(2-(B33*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH33=0,AE33,100)","v":100},1,{"$f":"IF(AH33=1,\"\",AE33)","v":""},{"$f":"IF(AH33=1,\"\",AF33)","v":""},30,"","",null,{"$f":"IF(AL33=0,AI33,100)","v":100},1,{"$f":"IF(AL33=1,\"\",AI33)","v":""},{"$f":"IF(AL33=1,\"\",AJ33)","v":""},30,"","",null,{"$f":"IF(AQ33=0,AM33,100)","v":100},1,{"$f":"IF(AQ33=1,\"\",AM33)","v":""},{"$f":"IF(AQ33=1,\"\",AN33)","v":""},30,"","",null,{"$f":"IF(ISTEXT(C33),C33,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO33)=0,\"\",COUNTIF(Plage,\"<=\"&$CO33))","v":""},"","",30,"",{"$f":"IFERROR(VLOOKUP(CT33,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY33,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT33,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU33=\"G\",VLOOKUP(CT33,Gars,2,FALSE),VLOOKUP(CT33,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU33=\"G\",VLOOKUP(CT33,Gars,3,FALSE),VLOOKUP(CT33,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",{"$f":"COUNTIF(AJ34,\"\")","v":1},"","","","",1,null,"","",{"$f":"BH34","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT34,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ34","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX34,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,30,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$10>1,\"\",IF($BN$10=1,(2-(B34*0.5)+0.5),(2-(B34*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH34=0,AE34,100)","v":100},1,{"$f":"IF(AH34=1,\"\",AE34)","v":""},{"$f":"IF(AH34=1,\"\",AF34)","v":""},31,"","",null,{"$f":"IF(AL34=0,AI34,100)","v":100},1,{"$f":"IF(AL34=1,\"\",AI34)","v":""},{"$f":"IF(AL34=1,\"\",AJ34)","v":""},31,"","",null,{"$f":"IF(AQ34=0,AM34,100)","v":100},1,{"$f":"IF(AQ34=1,\"\",AM34)","v":""},{"$f":"IF(AQ34=1,\"\",AN34)","v":""},31,"","",null,{"$f":"IF(ISTEXT(C34),C34,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO34)=0,\"\",COUNTIF(Plage,\"<=\"&$CO34))","v":""},"","",31,"",{"$f":"IFERROR(VLOOKUP(CT34,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY34,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT34,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU34=\"G\",VLOOKUP(CT34,Gars,2,FALSE),VLOOKUP(CT34,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU34=\"G\",VLOOKUP(CT34,Gars,3,FALSE),VLOOKUP(CT34,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,"","","","",1,null,"","",{"$f":"BH35","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT35,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ35","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX35,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,31,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$10>1,\"\",IF($BN$10=1,(2-(B35*0.5)+0.5),(2-(B35*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH35=0,AE35,100)","v":100},1,{"$f":"IF(AH35=1,\"\",AE35)","v":""},{"$f":"IF(AH35=1,\"\",AF35)","v":""},32,"","",null,{"$f":"IF(AL35=0,AI35,100)","v":100},1,{"$f":"IF(AL35=1,\"\",AI35)","v":""},{"$f":"IF(AL35=1,\"\",AJ35)","v":""},32,"","",null,{"$f":"IF(AQ35=0,AM35,100)","v":100},1,{"$f":"IF(AQ35=1,\"\",AM35)","v":""},{"$f":"IF(AQ35=1,\"\",AN35)","v":""},32,"","",null,{"$f":"IF(ISTEXT(C35),C35,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO35)=0,\"\",COUNTIF(Plage,\"<=\"&$CO35))","v":""},"","",32,"",{"$f":"IFERROR(VLOOKUP(CT35,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY35,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT35,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU35=\"G\",VLOOKUP(CT35,Gars,2,FALSE),VLOOKUP(CT35,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU35=\"G\",VLOOKUP(CT35,Gars,3,FALSE),VLOOKUP(CT35,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,"","","","",1,null,"","",{"$f":"BH36","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT36,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ36","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX36,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,32,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$10>1,\"\",IF($BN$10=1,(2-(B36*0.5)+0.5),(2-(B36*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH36=0,AE36,100)","v":100},1,{"$f":"IF(AH36=1,\"\",AE36)","v":""},{"$f":"IF(AH36=1,\"\",AF36)","v":""},33,"","",null,{"$f":"IF(AL36=0,AI36,100)","v":100},1,{"$f":"IF(AL36=1,\"\",AI36)","v":""},{"$f":"IF(AL36=1,\"\",AJ36)","v":""},33,"","",null,{"$f":"IF(AQ36=0,AM36,100)","v":100},1,{"$f":"IF(AQ36=1,\"\",AM36)","v":""},{"$f":"IF(AQ36=1,\"\",AN36)","v":""},33,"","",null,{"$f":"IF(ISTEXT(C36),C36,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO36)=0,\"\",COUNTIF(Plage,\"<=\"&$CO36))","v":""},"","",33,"",{"$f":"IFERROR(VLOOKUP(CT36,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY36,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT36,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU36=\"G\",VLOOKUP(CT36,Gars,2,FALSE),VLOOKUP(CT36,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU36=\"G\",VLOOKUP(CT36,Gars,3,FALSE),VLOOKUP(CT36,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","","",1,"","","","",1,null,"","",{"$f":"BH37","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT37,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ37","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX37,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,33,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$10>1,\"\",IF($BN$10=1,(2-(B37*0.5)+0.5),(2-(B37*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH37=0,AE37,100)","v":100},1,{"$f":"IF(AH37=1,\"\",AE37)","v":""},{"$f":"IF(AH37=1,\"\",AF37)","v":""},34,"","",null,{"$f":"IF(AL37=0,AI37,100)","v":100},1,{"$f":"IF(AL37=1,\"\",AI37)","v":""},{"$f":"IF(AL37=1,\"\",AJ37)","v":""},34,"","",null,{"$f":"IF(AQ37=0,AM37,100)","v":100},1,{"$f":"IF(AQ37=1,\"\",AM37)","v":""},{"$f":"IF(AQ37=1,\"\",AN37)","v":""},34,"","",null,{"$f":"IF(ISTEXT(C37),C37,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO37)=0,\"\",COUNTIF(Plage,\"<=\"&$CO37))","v":""},"","",34,"",{"$f":"IFERROR(VLOOKUP(CT37,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY37,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT37,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU37=\"G\",VLOOKUP(CT37,Gars,2,FALSE),VLOOKUP(CT37,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU37=\"G\",VLOOKUP(CT37,Gars,3,FALSE),VLOOKUP(CT37,Fille,3,FALSE)),\"\")","v":""}]
[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,"","","",1,"","",{"$f":"IF(AO38=\"G\",AP38,\"\")","v":""},1,"","","","",1,null,"","",{"$f":"BH38","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AT38,$AF$4:$AG$38,2,FALSE)","v":""},"","",{"$f":"BJ38","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AX38,$AJ$4:$AK$38,2,FALSE)","v":""},"","","","",null,34,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF($BN$10>1,\"\",IF($BN$10=1,(2-(B38*0.5)+0.5),(2-(B38*0.4)+0.4)))","v":""},"",null,null,null,null,{"$f":"IF(AH38=0,AE38,100)","v":100},1,{"$f":"IF(AH38=1,\"\",AE38)","v":""},{"$f":"IF(AH38=1,\"\",AF38)","v":""},35,"","",null,{"$f":"IF(AL38=0,AI38,100)","v":100},1,{"$f":"IF(AL38=1,\"\",AI38)","v":""},{"$f":"IF(AL38=1,\"\",AJ38)","v":""},35,"","",null,{"$f":"IF(AQ38=0,AM38,100)","v":100},1,{"$f":"IF(AQ38=1,\"\",AM38)","v":""},{"$f":"IF(AQ38=1,\"\",AN38)","v":""},35,"","",null,{"$f":"IF(ISTEXT(C38),C38,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO38)=0,\"\",COUNTIF(Plage,\"<=\"&$CO38))","v":""},"","",35,"",{"$f":"IFERROR(VLOOKUP(CT38,C$4:D$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(ROUND(CY38,0),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(CT38,Stratégie,3,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(CU38=\"G\",VLOOKUP(CT38,Gars,2,FALSE),VLOOKUP(CT38,Fille,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(CU38=\"G\",VLOOKUP(CT38,Gars,3,FALSE),VLOOKUP(CT38,Fille,3,FALSE)),\"\")","v":""}]
[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,{"$f":"COUNTIF(AH4:AH33,0)","v":0},null,null,null,{"$f":"COUNTIF(AL4:AL33,0)","v":0},null,null,null,null,{"$f":"COUNTIF(AQ4:AQ33,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISTEXT(C39),C39,\"\")","v":""},{"$f":"IF(COUNTIF(Plage,\"<=\"&$CO39)=0,\"\",COUNTIF(Plage,\"<=\"&$CO39))","v":""},"","",null,"",{"$f":"IFERROR(VLOOKUP(CT39,C$4:D$38,2,FALSE),\"\")","v":""}]
[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,{"$f":"3/AH39","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"3/AL39","v":{"$error":"#DIV/0!"}},{"$f":"IF(B36=\"\",\"\",IF($AN$51=6,B36+24,IF($AN$51=5,B36+25,IF($AN$51=4,B36+26,IF($AN$51=3,B36+27,IF($AN$51=2,B36+28,IF($AN$51=1,B36+29,B36+30)))))))","v":""},null,null,null,{"$f":"3/AQ39","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vides sur rang"]
[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,"2ème niveau",null,{"$f":"COUNTBLANK(B4:B13)","v":10}]
[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,"3ème niveau",null,{"$f":"COUNTBLANK(B5:B18)","v":14}]
[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,"4ème niveau",null,{"$f":"COUNTBLANK(B6:B23)","v":18}]
[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,"5ème niveau",null,{"$f":"COUNTBLANK(B7:B28)","v":22}]
[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,"6ème niveau",null,{"$f":"COUNTBLANK(B8:B33)","v":26}]
[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,"7ème niveau",null,{"$f":"COUNTBLANK(B9:B38)","v":30}]

{"sheet":"Feuille de match Bac à 5","index":2,"n_rows":37,"n_cols":30,"rows_kept":37,"cut":false,"hidden":true,"merged":[[6,22,7,24],[2,18,5,23],[1,4,1,9],[1,14,2,14],[1,15,2,15],[9,1,10,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[9,21,9,22],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,9,9,10],[9,11,9,12],[9,13,9,14],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[1,1,2,1],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,3,2,3],[1,2,2,2],[2,8,2,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"By Paul ANTIAO"]
[null,"RANG","PRÉNOM","SEXE","Efficacité des choix stratégiques",null,null,null,null,null,"Points","Vict.","Nuls ","Diff.","Pour","Contre"]
[null,null,null,null,"M1","M2","M3","M4","Final"]
[null,{"$f":"IFERROR(AC4+AD4,\"\")","v":""},null,null,{"$f":"IFERROR(D20,\"\")","v":""},{"$f":"IFERROR(H20,\"\")","v":""},{"$f":"IFERROR(N20,\"\")","v":""},{"$f":"IFERROR(T20,\"\")","v":""},{"$f":"IFERROR(AVERAGE(E4:H4),\"\")","v":""},null,{"$f":"L4*3+M4","v":0},{"$f":"COUNTIF(D12,\">\"&D13)+COUNTIF(H12,\">\"&H16)+COUNTIF(N12,\">\"&N14)+COUNTIF(T12,\">\"&T15)+COUNTIF(E12,\">\"&E13)+COUNTIF(I12,\">\"&I16)+COUNTIF(O12,\">\"&O14)+COUNTIF(U12,\">\"&U15)","v":0},{"$f":"COUNTIF(D12,\"=\"&D13)+COUNTIF(H12,\"=\"&H16)+COUNTIF(N12,\"=\"&N14)+COUNTIF(T12,\"=\"&T15)-COUNTBLANK(D12:W12)+12+COUNTIF(E12,\"=\"&E13)+COUNTIF(I12,\"=\"&I16)+COUNTIF(O12,\"=\"&O14)+COUNTIF(U12,\"=\"&U15)","v":0},{"$f":"O4-P4","v":0},{"$f":"SUM(D12:W12)","v":0},{"$f":"SUM(D13,H16,N14,T15,E13,I16,O14,U15)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(N4,\"<\"&N5,AD4,\"=\"&AD5)+COUNTIFS(N4,\"<\"&N6,AD4,\"=\"&AD6)+COUNTIFS(N4,\"<\"&N7,AD4,\"=\"&AD7)+COUNTIFS(N4,\"<\"&N8,AD4,\"=\"&AD8)","v":0},{"$f":"IF(AND(K4=0,K5=0,K6=0,K7=0,K8=0),\"\",RANK(K4,K4:K8))","v":""}]
[null,{"$f":"IFERROR(AC5+AD5,\"\")","v":""},null,null,{"$f":"IFERROR(D22,\"\")","v":""},{"$f":"IFERROR(J20,\"\")","v":""},{"$f":"IFERROR(P20,\"\")","v":""},{"$f":"IFERROR(V20,\"\")","v":""},{"$f":"IFERROR(AVERAGE(E5:H5),\"\")","v":""},null,{"$f":"L5*3+M5","v":0},{"$f":"COUNTIF(D13,\">\"&D12)+COUNTIF(J13,\">\"&J14)+COUNTIF(P13,\">\"&P15)+COUNTIF(V13,\">\"&V16)+COUNTIF(E13,\">\"&E12)+COUNTIF(K13,\">\"&K14)+COUNTIF(Q13,\">\"&Q15)+COUNTIF(W13,\">\"&W16)","v":0},{"$f":"COUNTIF(D13,\"=\"&D12)+COUNTIF(J13,\"=\"&J14)+COUNTIF(P13,\"=\"&P15)+COUNTIF(V13,\"=\"&V16)-COUNTBLANK(D13:W13)+12+COUNTIF(E13,\"=\"&E12)+COUNTIF(K13,\"=\"&K14)+COUNTIF(Q13,\"=\"&Q15)+COUNTIF(W13,\"=\"&W16)","v":0},{"$f":"O5-P5","v":0},{"$f":"SUM(D13:W13)","v":0},{"$f":"SUM(D12,J14,P15,V16,E12,K14,Q15,W16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(N5,\"<\"&N6,AD5,\"=\"&AD6)+COUNTIFS(N5,\"<\"&N7,AD5,\"=\"&AD7)+COUNTIFS(N5,\"<\"&N8,AD5,\"=\"&AD8)+COUNTIFS(N5,\"<\"&N4,AD5,\"=\"&AD4)","v":0},{"$f":"IF(AND(K4=0,K5=0,K6=0,K7=0,K8=0),\"\",RANK(K5,K4:K8))","v":""}]
[null,"",null,null,{"$f":"IFERROR(F20,\"\")","v":""},{"$f":"IFERROR(J22,\"\")","v":""},{"$f":"IFERROR(N22,\"\")","v":""},{"$f":"IFERROR(R20,\"\")","v":""},"",null,0,{"$f":"COUNTIF(F14,\">\"&F15)+COUNTIF(J14,\">\"&J13)+COUNTIF(N14,\">\"&N12)+COUNTIF(R14,\">\"&R16)+COUNTIF(G14,\">\"&G15)+COUNTIF(K14,\">\"&K13)+COUNTIF(O14,\">\"&O12)+COUNTIF(S14,\">\"&S16)","v":0},{"$f":"COUNTIF(F14,\"=\"&F15)+COUNTIF(J14,\"=\"&J13)+COUNTIF(N14,\"=\"&N12)+COUNTIF(R14,\"=\"&R16)-COUNTBLANK(D14:W14)+12+COUNTIF(G14,\"=\"&G15)+COUNTIF(K14,\"=\"&K13)+COUNTIF(O14,\"=\"&O12)+COUNTIF(S14,\"=\"&S16)","v":0},{"$f":"O6-P6","v":0},{"$f":"SUM(D14:W14)","v":0},{"$f":"SUM(F15,G15,K13,O12,S16,J13,N12,R16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(N6,\"<\"&N7,AD6,\"=\"&AD7)+COUNTIFS(N6,\"<\"&N8,AD6,\"=\"&AD8)+COUNTIFS(N6,\"<\"&N5,AD6,\"=\"&AD5)+COUNTIFS(N6,\"<\"&N4,AD6,\"=\"&AD4)","v":0},{"$f":"IF(AND(K4=0,K5=0,K6=0,K7=0,K8=0),\"\",RANK(K6,K4:K8))","v":""}]
[null,"",null,null,{"$f":"IFERROR(F22,\"\")","v":""},{"$f":"IFERROR(L20,\"\")","v":""},{"$f":"IFERROR(P22,\"\")","v":""},{"$f":"IFERROR(T22,\"\")","v":""},"",null,0,{"$f":"COUNTIF(F15,\">\"&F14)+COUNTIF(L15,\">\"&L16)+COUNTIF(P15,\">\"&P13)+COUNTIF(T15,\">\"&T12)+COUNTIF(G15,\">\"&G14)+COUNTIF(M15,\">\"&M16)+COUNTIF(Q15,\">\"&Q13)+COUNTIF(U15,\">\"&U12)","v":0},{"$f":"COUNTIF(F15,\"=\"&F14)+COUNTIF(L15,\"=\"&L16)+COUNTIF(P15,\"=\"&P13)+COUNTIF(T15,\"=\"&T12)-COUNTBLANK(D15:W15)+12+COUNTIF(G15,\"=\"&G14)+COUNTIF(M15,\"=\"&M16)+COUNTIF(Q15,\"=\"&Q13)+COUNTIF(U15,\"=\"&U12)","v":0},{"$f":"O7-P7","v":0},{"$f":"SUM(D15:W15)","v":0},{"$f":"SUM(F14,L16,P13,T12,G14,M16,Q13,U12)","v":0},null,null,null,null,null,null,"Paul ANTIAO\nJean Moulin\nMontmorillon",null,null,null,null,null,{"$f":"COUNTIFS(N7,\"<\"&N8,AD7,\"=\"&AD8)+COUNTIFS(N7,\"<\"&N6,AD7,\"=\"&AD6)+COUNTIFS(N7,\"<\"&N5,AD7,\"=\"&AD5)+COUNTIFS(N7,\"<\"&N4,AD7,\"=\"&AD4)","v":0},{"$f":"IF(AND(K4=0,K5=0,K6=0,K7=0,K8=0),\"\",RANK(K7,K4:K8))","v":""}]
[null,"",null,null,{"$f":"IFERROR(H22,\"\")","v":""},{"$f":"IFERROR(L22,\"\")","v":""},{"$f":"IFERROR(R22,\"\")","v":""},{"$f":"IFERROR(V22,\"\")","v":""},"",null,0,{"$f":"COUNTIF(H16,\">\"&H12)+COUNTIF(L16,\">\"&L15)+COUNTIF(R16,\">\"&R14)+COUNTIF(V16,\">\"&V13)+COUNTIF(I16,\">\"&I12)+COUNTIF(M16,\">\"&M15)+COUNTIF(S16,\">\"&S14)+COUNTIF(W16,\">\"&W13)","v":0},{"$f":"COUNTIF(H16,\"=\"&H12)+COUNTIF(L16,\"=\"&L15)+COUNTIF(R16,\"=\"&R14)+COUNTIF(V16,\"=\"&V13)-COUNTBLANK(D16:W16)+12+COUNTIF(I16,\"=\"&I12)+COUNTIF(M16,\"=\"&M15)+COUNTIF(S16,\"=\"&S14)+COUNTIF(W16,\"=\"&W13)","v":0},{"$f":"O8-P8","v":0},{"$f":"SUM(D16:W16)","v":0},{"$f":"SUM(H12,L15,R14,V13,I12,M15,S14,W13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(N8,\"<\"&N7,AD8,\"=\"&AD7)+COUNTIFS(N8,\"<\"&N6,AD8,\"=\"&AD6)+COUNTIFS(N8,\"<\"&N5,AD8,\"=\"&AD5)+COUNTIFS(N8,\"<\"&N4,AD8,\"=\"&AD4)","v":0},{"$f":"IF(AND(K4=0,K5=0,K6=0,K7=0,K8=0),\"\",RANK(K8,K4:K8))","v":""}]
[]
[null,"JOUEURS",null,"Match 1",null,"Match 2",null,"Match 3",null,"Match 4",null,"Match 5",null,"Match 6",null,"Match 7",null,"Match 8",null,"Match 9",null,"Match 10"]
[null,null,null,"Set 1","Set 2","Set 1","Set 2","Set 1","Set 2","Set 1","Set 2","Set 1","Set 2","Set 1","Set 2","Set 1","Set 2","Set 1","Set 2","Set 1","Set 2","Set 1","Set 2"]
[null,{"$f":"IF(C4=\"\",\"\",C4)","v":""}]
[null,{"$f":"IF(C5=\"\",\"\",C5)","v":""}]
[null,{"$f":"IF(C6=\"\",\"\",C6)","v":""}]
[null,""]
[null,""]
[]
[null,null,null,{"$f":"IF(OR(D12=\"\",D13=\"\"),\"\",ABS(D13-D12))","v":""},{"$f":"IF(OR(E12=\"\",E13=\"\"),\"\",ABS(E13-E12))","v":""},{"$f":"IF(OR(F14=\"\",F15=\"\"),\"\",ABS(F15-F14))","v":""},{"$f":"IF(OR(G14=\"\",G15=\"\"),\"\",ABS(G15-G14))","v":""},{"$f":"IF(OR(H12=\"\",H16=\"\"),\"\",ABS(H12-H16))","v":""},{"$f":"IF(OR(I12=\"\",I16=\"\"),\"\",ABS(I12-I16))","v":""},{"$f":"IF(OR(J13=\"\",J14=\"\"),\"\",ABS(J13-J14))","v":""},{"$f":"IF(OR(K13=\"\",K14=\"\"),\"\",ABS(K13-K14))","v":""},{"$f":"IF(OR(L15=\"\",L16=\"\"),\"\",ABS(L16-L15))","v":""},{"$f":"IF(OR(M15=\"\",M16=\"\"),\"\",ABS(M16-M15))","v":""},{"$f":"IF(OR(N12=\"\",N14=\"\"),\"\",ABS(N12-N14))","v":""},{"$f":"IF(OR(O12=\"\",O14=\"\"),\"\",ABS(O12-O14))","v":""},{"$f":"IF(OR(P13=\"\",P15=\"\"),\"\",ABS(P13-P15))","v":""},{"$f":"IF(OR(Q13=\"\",Q15=\"\"),\"\",ABS(Q13-Q15))","v":""},{"$f":"IF(OR(R14=\"\",R16=\"\"),\"\",ABS(R16-R14))","v":""},{"$f":"IF(OR(S14=\"\",S16=\"\"),\"\",ABS(S16-S14))","v":""},{"$f":"IF(OR(T12=\"\",T15=\"\"),\"\",ABS(T15-T12))","v":""},{"$f":"IF(OR(U12=\"\",U15=\"\"),\"\",ABS(U15-U12))","v":""},{"$f":"IF(OR(V13=\"\",V16=\"\"),\"\",ABS(V13-V16))","v":""},{"$f":"IF(OR(W13=\"\",W16=\"\"),\"\",ABS(W13-W16))","v":""}]
[null,null,null,{"$f":"COUNTIF(D12,\">\"&D13)","v":0},{"$f":"COUNTIF(E12,\">\"&E13)","v":0},{"$f":"COUNTIF(F14,\">\"&F15)","v":0},{"$f":"COUNTIF(G14,\">\"&G15)","v":0},{"$f":"COUNTIF(H12,\">\"&H16)","v":0},{"$f":"COUNTIF(I12,\">\"&I16)","v":0},{"$f":"COUNTIF(J13,\">\"&J14)","v":0},{"$f":"COUNTIF(K13,\">\"&K14)","v":0},{"$f":"COUNTIF(L15,\">\"&L16)","v":0},{"$f":"COUNTIF(M15,\">\"&M16)","v":0},{"$f":"COUNTIF(N12,\">\"&N14)","v":0},{"$f":"COUNTIF(O12,\">\"&O14)","v":0},{"$f":"COUNTIF(P13,\">\"&P15)","v":0},{"$f":"COUNTIF(Q13,\">\"&Q15)","v":0},{"$f":"COUNTIF(R14,\">\"&R16)","v":0},{"$f":"COUNTIF(S14,\">\"&S16)","v":0},{"$f":"COUNTIF(T12,\">\"&T15)","v":0},{"$f":"COUNTIF(U12,\">\"&U15)","v":0},{"$f":"COUNTIF(V13,\">\"&V16)","v":0},{"$f":"COUNTIF(W13,\">\"&W16)","v":0}]
[null,null,null,{"$f":"IF(AND(D19+E19=2,E20>0),6,IF(OR(AND(D19+E19=2,E20<0),AND(D19+E19=2,E20=0)),5,IF(AND(D19+E19=0,E20<-1),2,IF(OR(AND(D19+E19=0,E20>-1),AND(D19+E19=0,E20=-1)),1,IF(D19-E19=-1,4,IF(D19-E19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"E18-D18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(F19+G19=2,G20>0),6,IF(OR(AND(F19+G19=2,G20<0),AND(F19+G19=2,G20=0)),5,IF(AND(F19+G19=0,G20<-1),2,IF(OR(AND(F19+G19=0,G20>-1),AND(F19+G19=0,G20=-1)),1,IF(F19-G19=-1,4,IF(F19-G19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"G18-F18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(H19+I19=2,I20>0),6,IF(OR(AND(H19+I19=2,I20<0),AND(H19+I19=2,I20=0)),5,IF(AND(H19+I19=0,I20<-1),2,IF(OR(AND(H19+I19=0,I20>-1),AND(H19+I19=0,I20=-1)),1,IF(H19-I19=-1,4,IF(H19-I19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"I18-H18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(J19+K19=2,K20>0),6,IF(OR(AND(J19+K19=2,K20<0),AND(J19+K19=2,K20=0)),5,IF(AND(J19+K19=0,K20<-1),2,IF(OR(AND(J19+K19=0,K20>-1),AND(J19+K19=0,K20=-1)),1,IF(J19-K19=-1,4,IF(J19-K19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"K18-J18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(L19+M19=2,M20>0),6,IF(OR(AND(L19+M19=2,M20<0),AND(L19+M19=2,M20=0)),5,IF(AND(L19+M19=0,M20<-1),2,IF(OR(AND(L19+M19=0,M20>-1),AND(L19+M19=0,M20=-1)),1,IF(L19-M19=-1,4,IF(L19-M19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"M18-L18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(N19+O19=2,O20>0),6,IF(OR(AND(N19+O19=2,O20<0),AND(N19+O19=2,O20=0)),5,IF(AND(N19+O19=0,O20<-1),2,IF(OR(AND(N19+O19=0,O20>-1),AND(N19+O19=0,O20=-1)),1,IF(N19-O19=-1,4,IF(N19-O19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"O18-N18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(P19+Q19=2,Q20>0),6,IF(OR(AND(P19+Q19=2,Q20<0),AND(P19+Q19=2,Q20=0)),5,IF(AND(P19+Q19=0,Q20<-1),2,IF(OR(AND(P19+Q19=0,Q20>-1),AND(P19+Q19=0,Q20=-1)),1,IF(P19-Q19=-1,4,IF(P19-Q19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"Q18-P18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(R19+S19=2,S20>0),6,IF(OR(AND(R19+S19=2,S20<0),AND(R19+S19=2,S20=0)),5,IF(AND(R19+S19=0,S20<-1),2,IF(OR(AND(R19+S19=0,S20>-1),AND(R19+S19=0,S20=-1)),1,IF(R19-S19=-1,4,IF(R19-S19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"S18-R18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(T19+U19=2,U20>0),6,IF(OR(AND(T19+U19=2,U20<0),AND(T19+U19=2,U20=0)),5,IF(AND(T19+U19=0,U20<-1),2,IF(OR(AND(T19+U19=0,U20>-1),AND(T19+U19=0,U20=-1)),1,IF(T19-U19=-1,4,IF(T19-U19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"U18-T18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(V19+W19=2,W20>0),6,IF(OR(AND(V19+W19=2,W20<0),AND(V19+W19=2,W20=0)),5,IF(AND(V19+W19=0,W20<-1),2,IF(OR(AND(V19+W19=0,W20>-1),AND(V19+W19=0,W20=-1)),1,IF(V19-W19=-1,4,IF(V19-W19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"W18-V18","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"COUNTIF(D12,\"<\"&D13)","v":0},{"$f":"COUNTIF(E12,\"<\"&E13)","v":0},{"$f":"COUNTIF(F14,\"<\"&F15)","v":0},{"$f":"COUNTIF(G14,\"<\"&G15)","v":0},{"$f":"COUNTIF(H12,\"<\"&H16)","v":0},{"$f":"COUNTIF(I12,\"<\"&I16)","v":0},{"$f":"COUNTIF(J13,\"<\"&J14)","v":0},{"$f":"COUNTIF(K13,\"<\"&K14)","v":0},{"$f":"COUNTIF(L15,\"<\"&L16)","v":0},{"$f":"COUNTIF(M15,\"<\"&M16)","v":0},{"$f":"COUNTIF(N12,\"<\"&N14)","v":0},{"$f":"COUNTIF(O12,\"<\"&O14)","v":0},{"$f":"COUNTIF(P13,\"<\"&P15)","v":0},{"$f":"COUNTIF(Q13,\"<\"&Q15)","v":0},{"$f":"COUNTIF(R14,\"<\"&R16)","v":0},{"$f":"COUNTIF(S14,\"<\"&S16)","v":0},{"$f":"COUNTIF(T12,\"<\"&T15)","v":0},{"$f":"COUNTIF(U12,\"<\"&U15)","v":0},{"$f":"COUNTIF(V13,\"<\"&V16)","v":0},{"$f":"COUNTIF(W13,\"<\"&W16)","v":0}]
[null,null,null,{"$f":"IF(AND(D21+E21=2,E22>0),6,IF(OR(AND(D21+E21=2,E22<0),AND(D21+E21=2,E22=0)),5,IF(AND(D21+E21=0,E22<-1),2,IF(OR(AND(D21+E21=0,E22>-1),AND(D21+E21=0,E22=-1)),1,IF(D21-E21=-1,4,IF(D21-E21=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"E18-D18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(F21+G21=2,G22>0),6,IF(OR(AND(F21+G21=2,G22<0),AND(F21+G21=2,G22=0)),5,IF(AND(F21+G21=0,G22<-1),2,IF(OR(AND(F21+G21=0,G22>-1),AND(F21+G21=0,G22=-1)),1,IF(F21-G21=-1,4,IF(F21-G21=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"G18-F18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(H21+I21=2,I22>0),6,IF(OR(AND(H21+I21=2,I22<0),AND(H21+I21=2,I22=0)),5,IF(AND(H21+I21=0,I22<-1),2,IF(OR(AND(H21+I21=0,I22>-1),AND(H21+I21=0,I22=-1)),1,IF(H21-I21=-1,4,IF(H21-I21=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"I18-H18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(J21+K21=2,K22>0),6,IF(OR(AND(J21+K21=2,K22<0),AND(J21+K21=2,K22=0)),5,IF(AND(J21+K21=0,K22<-1),2,IF(OR(AND(J21+K21=0,K22>-1),AND(J21+K21=0,K22=-1)),1,IF(J21-K21=-1,4,IF(J21-K21=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"K18-J18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(L21+M21=2,M22>0),6,IF(OR(AND(L21+M21=2,M22<0),AND(L21+M21=2,M22=0)),5,IF(AND(L21+M21=0,M22<-1),2,IF(OR(AND(L21+M21=0,M22>-1),AND(L21+M21=0,M22=-1)),1,IF(L21-M21=-1,4,IF(L21-M21=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"M18-L18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(N21+O21=2,O22>0),6,IF(OR(AND(N21+O21=2,O22<0),AND(N21+O21=2,O22=0)),5,IF(AND(N21+O21=0,O22<-1),2,IF(OR(AND(N21+O21=0,O22>-1),AND(N21+O21=0,O22=-1)),1,IF(N21-O21=-1,4,IF(N21-O21=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"O18-N18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(P21+Q21=2,Q22>0),6,IF(OR(AND(P21+Q21=2,Q22<0),AND(P21+Q21=2,Q22=0)),5,IF(AND(P21+Q21=0,Q22<-1),2,IF(OR(AND(P21+Q21=0,Q22>-1),AND(P21+Q21=0,Q22=-1)),1,IF(P21-Q21=-1,4,IF(P21-Q21=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"Q18-P18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(R21+S21=2,S22>0),6,IF(OR(AND(R21+S21=2,S22<0),AND(R21+S21=2,S22=0)),5,IF(AND(R21+S21=0,S22<-1),2,IF(OR(AND(R21+S21=0,S22>-1),AND(R21+S21=0,S22=-1)),1,IF(R21-S21=-1,4,IF(R21-S21=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"S18-R18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(T21+U21=2,U22>0),6,IF(OR(AND(T21+U21=2,U22<0),AND(T21+U21=2,U22=0)),5,IF(AND(T21+U21=0,U22<-1),2,IF(OR(AND(T21+U21=0,U22>-1),AND(T21+U21=0,U22=-1)),1,IF(T21-U21=-1,4,IF(T21-U21=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"U18-T18","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(V21+W21=2,W22>0),6,IF(OR(AND(V21+W21=2,W22<0),AND(V21+W21=2,W22=0)),5,IF(AND(V21+W21=0,W22<-1),2,IF(OR(AND(V21+W21=0,W22>-1),AND(V21+W21=0,W22=-1)),1,IF(V21-W21=-1,4,IF(V21-W21=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"W18-V18","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"By Paul ANTIAO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"By Paul ANTIAO"]

{"sheet":"Feuille de match Bac à 4","index":3,"n_rows":21,"n_cols":27,"rows_kept":21,"cut":false,"hidden":true,"merged":[[13,1,13,2],[12,1,12,2],[11,1,11,2],[10,1,10,2],[9,21,9,22],[8,1,9,2],[5,26,6,28],[6,7,6,8],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,13,8,14],[5,7,5,8],[1,13,2,13],[1,14,2,14],[2,7,2,8],[2,19,4,27],[1,1,2,1],[1,4,1,8],[1,9,2,9],[1,10,2,10],[1,2,2,2],[1,3,2,3],[3,7,3,8],[4,7,4,8],[1,11,2,11],[1,12,2,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"By Paul ANTIAO"]
[null,"RANG","PRÉNOM","SEXE","Efficacité des choix stratégiques",null,null,null,null,"Points","Vict.","Nuls ","Diff.","Pour","Contre"]
[null,null,null,null,"M1","M2","M3","Final"]
[null,{"$f":"IFERROR(Q4+R4,\"\")","v":""},null,null,{"$f":"IFERROR(D18,\"\")","v":""},{"$f":"IFERROR(J18,\"\")","v":""},{"$f":"IFERROR(N18,\"\")","v":""},{"$f":"IFERROR(AVERAGE(E4:G4),\"\")","v":""},null,{"$f":"K4*3+L4","v":0},{"$f":"COUNTIF(D11,\">\"&D12)+COUNTIF(J11,\">\"&J14)+COUNTIF(N11,\">\"&N13)+COUNTIF(E11,\">\"&E12)+COUNTIF(K11,\">\"&K14)+COUNTIF(O11,\">\"&O13)","v":0},{"$f":"COUNTIF(D11,\"=\"&D12)+COUNTIF(J11,\"=\"&J14)+COUNTIF(N11,\"=\"&N13)+COUNTIF(E11,\"=\"&E12)+COUNTIF(K11,\"=\"&K14)+COUNTIF(O11,\"=\"&O13)-COUNTBLANK(D11:O11)+6","v":0},{"$f":"N4-O4","v":0},{"$f":"SUM(D11:O11)","v":0},{"$f":"SUM(D12,J14,N13,E12,K14,O13)","v":0},null,{"$f":"COUNTIFS(M4,\"<\"&M5,R4,\"=\"&R5)+COUNTIFS(M4,\"<\"&M6,R4,\"=\"&R6)+COUNTIFS(M4,\"<\"&M7,R4,\"=\"&R7)","v":0},{"$f":"IF(AND(J4=0,J5=0,J6=0,J7=0),\"\",RANK(J4,J4:J7))","v":""}]
[null,{"$f":"IFERROR(Q5+R5,\"\")","v":""},null,null,{"$f":"IFERROR(D20,\"\")","v":""},{"$f":"IFERROR(H18,\"\")","v":""},{"$f":"IFERROR(L18,\"\")","v":""},{"$f":"IFERROR(AVERAGE(E5:G5),\"\")","v":""},null,{"$f":"K5*3+L5","v":0},{"$f":"COUNTIF(D12,\">\"&D11)+COUNTIF(H12,\">\"&H13)+COUNTIF(L12,\">\"&L14)+COUNTIF(E12,\">\"&E11)+COUNTIF(I12,\">\"&I13)+COUNTIF(M12,\">\"&M14)","v":0},{"$f":"COUNTIF(D12,\"=\"&D11)+COUNTIF(H12,\"=\"&H13)+COUNTIF(L12,\"=\"&L14)+COUNTIF(E12,\"=\"&E11)+COUNTIF(I12,\"=\"&I13)+COUNTIF(M12,\"=\"&M14)-COUNTBLANK(D12:O12)+6","v":0},{"$f":"N5-O5","v":0},{"$f":"SUM(D12:O12)","v":0},{"$f":"SUM(D11,H13,L14,E11,I13,M14)","v":0},null,{"$f":"COUNTIFS(M5,\"<\"&M6,R5,\"=\"&R6)+COUNTIFS(M5,\"<\"&M7,R5,\"=\"&R7)+COUNTIFS(M5,\"<\"&M4,R5,\"=\"&R4)","v":0},{"$f":"IF(AND(J4=0,J5=0,J6=0,J7=0),\"\",RANK(J5,J4:J7))","v":""}]
[null,{"$f":"IFERROR(Q6+R6,\"\")","v":""},null,null,{"$f":"IFERROR(F18,\"\")","v":""},{"$f":"IFERROR(H20,\"\")","v":""},{"$f":"IFERROR(N20,\"\")","v":""},{"$f":"IFERROR(AVERAGE(E6:G6),\"\")","v":""},null,0,{"$f":"COUNTIF(F13,\">\"&F14)+COUNTIF(H13,\">\"&H12)+COUNTIF(N13,\">\"&N11)+COUNTIF(G13,\">\"&G14)+COUNTIF(I13,\">\"&I12)+COUNTIF(O13,\">\"&O11)","v":0},{"$f":"COUNTIF(F13,\"=\"&F14)+COUNTIF(H13,\"=\"&H12)+COUNTIF(N13,\"=\"&N11)+COUNTIF(G13,\"=\"&G14)+COUNTIF(I13,\"=\"&I12)+COUNTIF(O13,\"=\"&O11)-COUNTBLANK(D13:O13)+6","v":0},{"$f":"N6-O6","v":0},{"$f":"SUM(D13:O13)","v":0},{"$f":"SUM(F14,H12,N11,G14,I12,O11)","v":0},null,{"$f":"COUNTIFS(M6,\"<\"&M7,R6,\"=\"&R7)+COUNTIFS(M6,\"<\"&M5,R6,\"=\"&R5)+COUNTIFS(M6,\"<\"&M4,R6,\"=\"&R4)","v":0},{"$f":"IF(AND(J4=0,J5=0,J6=0,J7=0),\"\",RANK(J6,J4:J7))","v":""},null,null,null,null,null,null,null,null,"Paul ANTIAO\nJean Moulin\nMontmorillon"]
[null,"",null,null,{"$f":"IFERROR(F20,\"\")","v":""},{"$f":"IFERROR(J20,\"\")","v":""},{"$f":"IFERROR(L20,\"\")","v":""},{"$f":"IFERROR(AVERAGE(E7:G7),\"\")","v":""},null,0,{"$f":"COUNTIF(F14,\">\"&F13)+COUNTIF(J14,\">\"&J11)+COUNTIF(L14,\">\"&L12)+COUNTIF(G14,\">\"&G13)+COUNTIF(K14,\">\"&K11)+COUNTIF(M14,\">\"&M12)","v":0},{"$f":"COUNTIF(F14,\"=\"&F13)+COUNTIF(J14,\"=\"&J11)+COUNTIF(L14,\"=\"&L12)+COUNTIF(G14,\"=\"&G13)+COUNTIF(K14,\"=\"&K11)+COUNTIF(M14,\"=\"&M12)-COUNTBLANK(D14:O14)+6","v":0},{"$f":"N7-O7","v":0},{"$f":"SUM(D14:O14)","v":0},{"$f":"SUM(F13,J11,L12,G13,K11,M12)","v":0},null,{"$f":"COUNTIFS(M7,\"<\"&M6,R7,\"=\"&R6)+COUNTIFS(M7,\"<\"&M5,R7,\"=\"&R5)+COUNTIFS(M7,\"<\"&M4,R7,\"=\"&R4)","v":0},{"$f":"IF(AND(J4=0,J5=0,J6=0,J7=0),\"\",RANK(J7,J4:J7))","v":""}]
[]
[null,"JOUEURS",null,"Match 1",null,"Match 2",null,"Match 3",null,"Match 4",null,"Match 5",null,"Match 6"]
[null,null,null,"Set 1","Set 2","Set 1","Set 2","Set 1","Set 2","Set 1","Set 2","Set 1","Set 2","Set 1","Set 2"]
[null,{"$f":"IF(C4=\"\",\"\",C4)","v":""}]
[null,{"$f":"IF(C5=\"\",\"\",C5)","v":""}]
[null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"By Paul ANTIAO"]
[]
[null,null,null,{"$f":"IF(OR(D11=\"\",D12=\"\"),\"\",ABS(D11-D12))","v":""},{"$f":"IF(OR(E11=\"\",E12=\"\"),\"\",ABS(E11-E12))","v":""},{"$f":"IF(OR(F13=\"\",F14=\"\"),\"\",ABS(F13-F14))","v":""},{"$f":"IF(OR(G13=\"\",G14=\"\"),\"\",ABS(G13-G14))","v":""},{"$f":"IF(OR(H12=\"\",H13=\"\"),\"\",ABS(H12-H13))","v":""},{"$f":"IF(OR(I12=\"\",I13=\"\"),\"\",ABS(I12-I13))","v":""},{"$f":"IF(OR(J11=\"\",J14=\"\"),\"\",ABS(J11-J14))","v":""},{"$f":"IF(OR(K11=\"\",K14=\"\"),\"\",ABS(K11-K14))","v":""},{"$f":"IF(OR(L12=\"\",L14=\"\"),\"\",ABS(L14-L12))","v":""},{"$f":"IF(OR(M12=\"\",M14=\"\"),\"\",ABS(M14-M12))","v":""},{"$f":"IF(OR(N11=\"\",N13=\"\"),\"\",ABS(N11-N13))","v":""},{"$f":"IF(OR(O11=\"\",O13=\"\"),\"\",ABS(O11-O13))","v":""}]
[null,null,null,{"$f":"COUNTIF(D11,\">\"&D12)","v":0},{"$f":"COUNTIF(E11,\">\"&E12)","v":0},{"$f":"COUNTIF(F13,\">\"&F14)","v":0},{"$f":"COUNTIF(G13,\">\"&G14)","v":0},{"$f":"COUNTIF(H12,\">\"&H13)","v":0},{"$f":"COUNTIF(I12,\">\"&I13)","v":0},{"$f":"COUNTIF(J11,\">\"&J14)","v":0},{"$f":"COUNTIF(K11,\">\"&K14)","v":0},{"$f":"COUNTIF(L12,\">\"&L14)","v":0},{"$f":"COUNTIF(M12,\">\"&M14)","v":0},{"$f":"COUNTIF(N11,\">\"&N13)","v":0},{"$f":"COUNTIF(O11,\">\"&O13)","v":0}]
[null,null,null,{"$f":"IF(AND(D17+E17=2,E18>0),6,IF(OR(AND(D17+E17=2,E18<0),AND(D17+E17=2,E18=0)),5,IF(AND(D17+E17=0,E18<-1),2,IF(OR(AND(D17+E17=0,E18>-1),AND(D17+E17=0,E18=-1)),1,IF(D17-E17=-1,4,IF(D17-E17=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"E16-D16","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(F17+G17=2,G18>0),6,IF(OR(AND(F17+G17=2,G18<0),AND(F17+G17=2,G18=0)),5,IF(AND(F17+G17=0,G18<-1),2,IF(OR(AND(F17+G17=0,G18>-1),AND(F17+G17=0,G18=-1)),1,IF(F17-G17=-1,4,IF(F17-G17=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"G16-F16","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(H17+I17=2,I18>0),6,IF(OR(AND(H17+I17=2,I18<0),AND(H17+I17=2,I18=0)),5,IF(AND(H17+I17=0,I18<-1),2,IF(OR(AND(H17+I17=0,I18>-1),AND(H17+I17=0,I18=-1)),1,IF(H17-I17=-1,4,IF(H17-I17=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"I16-H16","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(J17+K17=2,K18>0),6,IF(OR(AND(J17+K17=2,K18<0),AND(J17+K17=2,K18=0)),5,IF(AND(J17+K17=0,K18<-1),2,IF(OR(AND(J17+K17=0,K18>-1),AND(J17+K17=0,K18=-1)),1,IF(J17-K17=-1,4,IF(J17-K17=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"K16-J16","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(L17+M17=2,M18>0),6,IF(OR(AND(L17+M17=2,M18<0),AND(L17+M17=2,M18=0)),5,IF(AND(L17+M17=0,M18<-1),2,IF(OR(AND(L17+M17=0,M18>-1),AND(L17+M17=0,M18=-1)),1,IF(L17-M17=-1,4,IF(L17-M17=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"M16-L16","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(N17+O17=2,O18>0),6,IF(OR(AND(N17+O17=2,O18<0),AND(N17+O17=2,O18=0)),5,IF(AND(N17+O17=0,O18<-1),2,IF(OR(AND(N17+O17=0,O18>-1),AND(N17+O17=0,O18=-1)),1,IF(N17-O17=-1,4,IF(N17-O17=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"O16-N16","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"COUNTIF(D11,\"<\"&D12)","v":0},{"$f":"COUNTIF(E11,\"<\"&E12)","v":0},{"$f":"COUNTIF(F13,\"<\"&F14)","v":0},{"$f":"COUNTIF(G13,\"<\"&G14)","v":0},{"$f":"COUNTIF(H12,\"<\"&H13)","v":0},{"$f":"COUNTIF(I12,\"<\"&I13)","v":0},{"$f":"COUNTIF(J11,\"<\"&J14)","v":0},{"$f":"COUNTIF(K11,\"<\"&K14)","v":0},{"$f":"COUNTIF(L12,\"<\"&L14)","v":0},{"$f":"COUNTIF(M12,\"<\"&M14)","v":0},{"$f":"COUNTIF(N11,\"<\"&N13)","v":0},{"$f":"COUNTIF(O11,\"<\"&O13)","v":0}]
[null,null,null,{"$f":"IF(AND(D19+E19=2,E20>0),6,IF(OR(AND(D19+E19=2,E20<0),AND(D19+E19=2,E20=0)),5,IF(AND(D19+E19=0,E20<-1),2,IF(OR(AND(D19+E19=0,E20>-1),AND(D19+E19=0,E20=-1)),1,IF(D19-E19=-1,4,IF(D19-E19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"IF(E18=\"\",\"\",E16-D16)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(F19+G19=2,G20>0),6,IF(OR(AND(F19+G19=2,G20<0),AND(F19+G19=2,G20=0)),5,IF(AND(F19+G19=0,G20<-1),2,IF(OR(AND(F19+G19=0,G20>-1),AND(F19+G19=0,G20=-1)),1,IF(F19-G19=-1,4,IF(F19-G19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"G16-F16","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(H19+I19=2,I20>0),6,IF(OR(AND(H19+I19=2,I20<0),AND(H19+I19=2,I20=0)),5,IF(AND(H19+I19=0,I20<-1),2,IF(OR(AND(H19+I19=0,I20>-1),AND(H19+I19=0,I20=-1)),1,IF(H19-I19=-1,4,IF(H19-I19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"I16-H16","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(J19+K19=2,K20>0),6,IF(OR(AND(J19+K19=2,K20<0),AND(J19+K19=2,K20=0)),5,IF(AND(J19+K19=0,K20<-1),2,IF(OR(AND(J19+K19=0,K20>-1),AND(J19+K19=0,K20=-1)),1,IF(J19-K19=-1,4,IF(J19-K19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"K16-J16","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(L19+M19=2,M20>0),6,IF(OR(AND(L19+M19=2,M20<0),AND(L19+M19=2,M20=0)),5,IF(AND(L19+M19=0,M20<-1),2,IF(OR(AND(L19+M19=0,M20>-1),AND(L19+M19=0,M20=-1)),1,IF(L19-M19=-1,4,IF(L19-M19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"M16-L16","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(N19+O19=2,O20>0),6,IF(OR(AND(N19+O19=2,O20<0),AND(N19+O19=2,O20=0)),5,IF(AND(N19+O19=0,O20<-1),2,IF(OR(AND(N19+O19=0,O20>-1),AND(N19+O19=0,O20=-1)),1,IF(N19-O19=-1,4,IF(N19-O19=1,3,0))))))","v":{"$error":"#VALUE!"}},{"$f":"O16-N16","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"By Paul ANTIAO"]