{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["RESULTATS","CLASSEMENT","GUIDE","Pronostiqueur 1"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":15,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RESULTATS","index":0,"n_rows":138,"n_cols":44,"rows_kept":138,"cut":false,"hidden":false,"merged":[[6,29,6,36],[6,37,6,42],[6,17,6,26],[3,9,3,12],[2,9,2,11],[5,17,5,26],[5,29,5,43],[5,1,5,13]]}
[]
[null,"RESULTATS REELS"]
[]
[null,"A SAISIR SUR CETTE PAGE"]
[]
[null,"SAISIE DES RESULTATS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POINTS",null,null,null,null,null,null,null,null,null,null,null,"PHASES FINALES"]
[null,"Date","Heure","Match","Groupe",1,"N",2,null,"Buts",null,null,"Buts",null,null,null,null,"   suivi des scores||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||",null,null,null,null,null,null,null,null,null,null,null,"Dernière saisie des scores >>>",null,null,null,null,null,null,null,"vendredi 02 février 2018 à 00:40:10"]
[null,"2018-06-14","18:00:00",1,"Groupe A",null,null,null,"Russie",null,null,"Arabie Saoudite",null,null,null,null,null,"Rg","Groupe A","MJ","G","N","P","BP","BC","+/-","Pts",null,null,"Date","Finale",null,null,"Buts",null,"Pen",null,null,null,"Buts",null,"Pen"]
[null,"2018-06-15","17:00:00",2,"Groupe A",null,null,null,"Egypte",null,null,"Uruguay",null,null,null,null,{"$f":"AA9*1000+Z9*100+X9*10","v":0},{"$f":"RANK(Q9,$Q$9:$Q$12,0)","v":1},"Russie",{"$f":"SUMPRODUCT((Teams1=S9)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S9)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S9)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S9)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S9)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S9)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S9)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S9)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S9)*(Teams1_Score))+SUMPRODUCT((Teams2=S9)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S9)*(Teams2_Score))+SUMPRODUCT((Teams2=S9)*(Teams1_Score))","v":0},{"$f":"X9-Y9","v":0},{"$f":"3*U9+V9","v":0}]
[null,"2018-06-15","18:00:00",3,"Groupe B",null,null,null,"Maroc",null,null,"RI Iran",null,null,null,null,{"$f":"AA10*1000+Z10*100+X10*10","v":0},{"$f":"RANK(Q10,$Q$9:$Q$12,0)","v":1},"Arabie Saoudite",{"$f":"SUMPRODUCT((Teams1=S10)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S10)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S10)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S10)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S10)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S10)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S10)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S10)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S10)*(Teams1_Score))+SUMPRODUCT((Teams2=S10)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S10)*(Teams2_Score))+SUMPRODUCT((Teams2=S10)*(Teams1_Score))","v":0},{"$f":"X10-Y10","v":0},{"$f":"3*U10+V10","v":0},null,null,"2018-07-15",null,{"$f":"+IF(AH18<>\"\",IF(AG18>AM18,AF18,AL18),\"Vainqueur 1\")","v":"Vainqueur 1"},{"$f":"AH10*10+AJ10","v":0},null,null,null,null,{"$f":"+IF(AH19<>\"\",IF(AG19>AM19,AF19,AL19),\"Vainqueur 2\")","v":"Vainqueur 2"},{"$f":"AN10*10+AP10","v":0},null,null,null,null,{"$f":"IF(AH10<>\"\",IF(AG10>AM10,AF10,AL10),\"\")","v":""}]
[null,"2018-06-15","21:00:00",4,"Groupe B",null,null,null,"Portugal",null,null,"Espagne",null,null,null,null,{"$f":"AA11*1000+Z11*100+X11*10","v":0},1,"Egypte",{"$f":"SUMPRODUCT((Teams1=S11)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S11)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S11)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S11)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S11)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S11)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S11)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S11)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S11)*(Teams1_Score))+SUMPRODUCT((Teams2=S11)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S11)*(Teams2_Score))+SUMPRODUCT((Teams2=S11)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-16","13:00:00",5,"Groupe C",null,null,null,"France",null,null,"Australie",null,null,null,null,{"$f":"AA12*1000+Z12*100+X12*10","v":0},1,"Uruguay",{"$f":"SUMPRODUCT((Teams1=S12)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S12)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S12)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S12)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S12)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S12)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S12)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S12)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S12)*(Teams1_Score))+SUMPRODUCT((Teams2=S12)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S12)*(Teams2_Score))+SUMPRODUCT((Teams2=S12)*(Teams1_Score))","v":0},0,0,null,null,"Date","Petite Finale",null,null,"Buts",null,"Pen",null,null,null,"Buts",null,"Pen"]
[null,"2018-06-16","19:00:00",6,"Groupe C",null,null,null,"Pérou",null,null,"Danemark"]
[null,"2018-06-16","16:00:00",7,"Groupe D",null,null,null,"Argentine",null,null,"Islande",null,null,null,null,null,"Rg","Groupe B","MJ","G","N","P","BP","BC","Pts","Pts",null,null,"2018-07-14",null,{"$f":"+IF(AH18<>\"\",IF(AG18>AM18,AL18,AF18),\"Perdant 1\")","v":"Perdant 1"},{"$f":"AH14*10+AJ14","v":0},null,null,null,null,{"$f":"+IF(AH19<>\"\",IF(AG19>AM19,AL19,AF19),\"Perdant 2\")","v":"Perdant 2"},{"$f":"AN14*10+AP14","v":0}]
[null,"2018-06-16","21:00:00",8,"Groupe D",null,null,null,"Croatie",null,null,"Nigeria",null,null,null,null,{"$f":"AA15*1000+Z15*100+X15*10","v":0},{"$f":"RANK(Q15,$Q$15:$Q$18,0)","v":1},"Maroc",{"$f":"SUMPRODUCT((Teams1=S15)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S15)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S15)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S15)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S15)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S15)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S15)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S15)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S15)*(Teams1_Score))+SUMPRODUCT((Teams2=S15)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S15)*(Teams2_Score))+SUMPRODUCT((Teams2=S15)*(Teams1_Score))","v":0},{"$f":"X15-Y15","v":0},{"$f":"3*U15+V15","v":0}]
[null,"2018-06-17","16:00:00",9,"Groupe E",null,null,null,"Costa Rica",null,null,"Serbie",null,null,null,null,{"$f":"AA16*1000+Z16*100+X16*10","v":0},{"$f":"RANK(Q16,$Q$15:$Q$18,0)","v":1},"RI Iran",{"$f":"SUMPRODUCT((Teams1=S16)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S16)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S16)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S16)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S16)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S16)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S16)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S16)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S16)*(Teams1_Score))+SUMPRODUCT((Teams2=S16)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S16)*(Teams2_Score))+SUMPRODUCT((Teams2=S16)*(Teams1_Score))","v":0},0,0,null,null,"Date","Demi Finale",null,null,"Buts",null,"Pen",null,null,null,"Buts",null,"Pen"]
[null,"2018-06-17","21:00:00",10,"Groupe E",null,null,null,"Brésil",null,null,"Suisse",null,null,null,null,{"$f":"AA17*1000+Z17*100+X17*10","v":0},1,"Portugal",{"$f":"SUMPRODUCT((Teams1=S17)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S17)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S17)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S17)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S17)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S17)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S17)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S17)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S17)*(Teams1_Score))+SUMPRODUCT((Teams2=S17)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S17)*(Teams2_Score))+SUMPRODUCT((Teams2=S17)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-17","18:00:00",11,"Groupe F",null,null,null,"Allemagne",null,null,"Mexique",null,null,null,null,{"$f":"AA18*1000+Z18*100+X18*10","v":0},1,"Espagne",{"$f":"SUMPRODUCT((Teams1=S18)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S18)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S18)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S18)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S18)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S18)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S18)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S18)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S18)*(Teams1_Score))+SUMPRODUCT((Teams2=S18)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S18)*(Teams2_Score))+SUMPRODUCT((Teams2=S18)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-10",1,{"$f":"+IF(AH23<>\"\",IF(AG23>AM23,AF23,AL23),\"Vainqueur A\")","v":"Vainqueur A"},{"$f":"AH18*10+AJ18","v":0},null,null,null,null,{"$f":"+IF(AH25<>\"\",IF(AG25>AM25,AF25,AL25),\"Vainqueur C\")","v":"Vainqueur C"},{"$f":"AN18*10+AP18","v":0}]
[null,"2018-06-18","15:00:00",12,"Groupe F",null,null,null,"Suède",null,null,"République de Corée",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-11",2,{"$f":"+IF(AH24<>\"\",IF(AG24>AM24,AF24,AL24),\"Vainqueur B\")","v":"Vainqueur B"},0,null,null,null,null,{"$f":"+IF(AH26<>\"\",IF(AG26>AM26,AF26,AL26),\"Vainqueur D\")","v":"Vainqueur D"},0]
[null,"2018-06-18","18:00:00",13,"Groupe G",null,null,null,"Belgique",null,null,"Panama",null,null,null,null,null,"Rg","Groupe C","MJ","G","N","P","BP","BC","Pts","Pts"]
[null,"2018-06-18","21:00:00",14,"Groupe G",null,null,null,"Tunisie",null,null,"Angleterre",null,null,null,null,{"$f":"AA21*1000+Z21*100+X21*10","v":0},{"$f":"RANK(Q21,$Q$21:$Q$24,0)","v":1},"France",{"$f":"SUMPRODUCT((Teams1=S21)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S21)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S21)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S21)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S21)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S21)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S21)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S21)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S21)*(Teams1_Score))+SUMPRODUCT((Teams2=S21)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S21)*(Teams2_Score))+SUMPRODUCT((Teams2=S21)*(Teams1_Score))","v":0},{"$f":"X21-Y21","v":0},{"$f":"3*U21+V21","v":0},null,null,"Date","Quart de Finale",null,null,"Buts",null,"Pen",null,null,null,"Buts",null,"Pen"]
[null,"2018-06-19","15:00:00",15,"Groupe H",null,null,null,"Colombie",null,null,"Japon",null,null,null,null,{"$f":"AA22*1000+Z22*100+X22*10","v":0},{"$f":"RANK(Q22,$Q$21:$Q$24,0)","v":1},"Australie",{"$f":"SUMPRODUCT((Teams1=S22)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S22)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S22)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S22)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S22)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S22)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S22)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S22)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S22)*(Teams1_Score))+SUMPRODUCT((Teams2=S22)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S22)*(Teams2_Score))+SUMPRODUCT((Teams2=S22)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-19","18:00:00",16,"Groupe H",null,null,null,"Pologne",null,null,"Sénégal",null,null,null,null,{"$f":"AA23*1000+Z23*100+X23*10","v":0},1,"Pérou",{"$f":"SUMPRODUCT((Teams1=S23)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S23)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S23)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S23)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S23)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S23)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S23)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S23)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S23)*(Teams1_Score))+SUMPRODUCT((Teams2=S23)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S23)*(Teams2_Score))+SUMPRODUCT((Teams2=S23)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-06","A",{"$f":"+IF(AH30<>\"\",IF(AG30>AM30,AF30,AL30),\"Vainqueur 1\")","v":"Vainqueur 1"},{"$f":"AH23*10+AJ23","v":0},null,null,null,null,{"$f":"+IF(AH32<>\"\",IF(AG32>AM32,AF32,AL32),\"Vainqueur 3\")","v":"Vainqueur 3"},{"$f":"AN23*10+AP23","v":0}]
[null,"2018-06-19","21:00:00",17,"Groupe A",null,null,null,"Russie",null,null,"Egypte",null,null,null,null,{"$f":"AA24*1000+Z24*100+X24*10","v":0},1,"Danemark",{"$f":"SUMPRODUCT((Teams1=S24)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S24)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S24)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S24)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S24)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S24)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S24)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S24)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S24)*(Teams1_Score))+SUMPRODUCT((Teams2=S24)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S24)*(Teams2_Score))+SUMPRODUCT((Teams2=S24)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-07","B",{"$f":"+IF(AH31<>\"\",IF(AG31>AM31,AF31,AL31),\"Vainqueur 2\")","v":"Vainqueur 2"},0,null,null,null,null,{"$f":"+IF(AH33<>\"\",IF(AG33>AM33,AF33,AL33),\"Vainqueur 4\")","v":"Vainqueur 4"},0]
[null,"2018-06-20","18:00:00",18,"Groupe A",null,null,null,"Uruguay",null,null,"Arabie Saoudite",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-06","C",{"$f":"+IF(AH34<>\"\",IF(AG34>AM34,AF34,AL34),\"Vainqueur 5\")","v":"Vainqueur 5"},0,null,null,null,null,{"$f":"+IF(AH36<>\"\",IF(AG36>AM36,AF36,AL36),\"Vainqueur 7\")","v":"Vainqueur 7"},0]
[null,"2018-06-20","15:00:00",19,"Groupe B",null,null,null,"Portugal",null,null,"Maroc",null,null,null,null,null,"Rg","Groupe D","MJ","G","N","P","BP","BC","Pts","Pts",null,null,"2018-07-07","D",{"$f":"+IF(AH35<>\"\",IF(AG35>AM35,AF35,AL35),\"Vainqueur 6\")","v":"Vainqueur 6"},0,null,null,null,null,{"$f":"+IF(AH37<>\"\",IF(AG37>AM37,AF37,AL37),\"Vainqueur 8\")","v":"Vainqueur 8"},0]
[null,"2018-06-20","21:00:00",20,"Groupe B",null,null,null,"RI Iran",null,null,"Espagne",null,null,null,null,{"$f":"AA27*1000+Z27*100+X27*10","v":0},{"$f":"RANK(Q27,$Q$27:$Q$30,0)","v":1},"Argentine",{"$f":"SUMPRODUCT((Teams1=S27)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S27)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S27)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S27)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S27)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S27)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S27)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S27)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S27)*(Teams1_Score))+SUMPRODUCT((Teams2=S27)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S27)*(Teams2_Score))+SUMPRODUCT((Teams2=S27)*(Teams1_Score))","v":0},{"$f":"X27-Y27","v":0},{"$f":"3*U27+V27","v":0}]
[null,"2018-06-21","16:00:00",21,"Groupe C",null,null,null,"Danemark",null,null,"Australie",null,null,null,null,{"$f":"AA28*1000+Z28*100+X28*10","v":0},{"$f":"RANK(Q28,$Q$27:$Q$30,0)","v":1},"Islande",{"$f":"SUMPRODUCT((Teams1=S28)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S28)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S28)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S28)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S28)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S28)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S28)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S28)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S28)*(Teams1_Score))+SUMPRODUCT((Teams2=S28)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S28)*(Teams2_Score))+SUMPRODUCT((Teams2=S28)*(Teams1_Score))","v":0},0,0,null,null,"Date","Huitième de Finale",null,null,"Buts",null,"Pen",null,null,null,"Buts",null,"Pen"]
[null,"2018-06-21","20:00:00",22,"Groupe C",null,null,null,"France",null,null,"Pérou",null,null,null,null,{"$f":"AA29*1000+Z29*100+X29*10","v":0},1,"Croatie",{"$f":"SUMPRODUCT((Teams1=S29)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S29)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S29)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S29)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S29)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S29)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S29)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S29)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S29)*(Teams1_Score))+SUMPRODUCT((Teams2=S29)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S29)*(Teams2_Score))+SUMPRODUCT((Teams2=S29)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-21","21:00:00",23,"Groupe D",null,null,null,"Argentine",null,null,"Croatie",null,null,null,null,{"$f":"AA30*1000+Z30*100+X30*10","v":0},1,"Nigeria",{"$f":"SUMPRODUCT((Teams1=S30)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S30)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S30)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S30)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S30)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S30)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S30)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S30)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S30)*(Teams1_Score))+SUMPRODUCT((Teams2=S30)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S30)*(Teams2_Score))+SUMPRODUCT((Teams2=S30)*(Teams1_Score))","v":0},0,0,null,null,"2018-06-30",1,{"$f":"IF(SUM(T9:T12)=0,\"1er Groupe A\",IF(COUNTIF(R9:R12,1)=1,VLOOKUP(1,R9:S12,2,FALSE),IF(COUNTIF(R9:R12,1)>=2,\"Tirage au Sort A1\")))","v":"1er Groupe A"},{"$f":"AH30*10+AJ30","v":0},null,null,null,null,{"$f":"IF(SUM(T15:T18)=0,\"2nd Groupe B\",IF(OR(COUNTIF(R15:R18,1)>1,COUNTIF(R15:R18,2)>1),\"Tirage au sort B2\",VLOOKUP(2,R15:S18,2,FALSE)))","v":"2nd Groupe B"},{"$f":"AN30*10+AP30","v":0}]
[null,"2018-06-22","18:00:00",24,"Groupe D",null,null,null,"Nigeria",null,null,"Islande",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-01",2,{"$f":"IF(SUM(T15:T18)=0,\"1er Groupe B\",IF(COUNTIF(R15:R18,1)=1,VLOOKUP(1,R15:S18,2,FALSE),IF(COUNTIF(R15:R18,1)>=2,\"Tirage au Sort B1\")))","v":"1er Groupe B"},{"$f":"AH31*10+AJ31","v":0},null,null,null,null,{"$f":"IF(SUM(T9:T12)=0,\"2nd Groupe A\",IF(OR(COUNTIF(R9:R12,1)>1,COUNTIF(R9:R12,2)>1),\"Tirage au sort A2\",VLOOKUP(2,R9:S12,2,FALSE)))","v":"2nd Groupe A"},0]
[null,"2018-06-22","15:00:00",25,"Groupe E",null,null,null,"Brésil",null,null,"Costa Rica",null,null,null,null,null,"Rg","Groupe E","MJ","G","N","P","BP","BC","Pts","Pts",null,null,"2017-06-30",3,{"$f":"IF(SUM(T21:T24)=0,\"1er Groupe C\",IF(COUNTIF(R21:R24,1)=1,VLOOKUP(1,R21:S24,2,FALSE),IF(COUNTIF(R21:R24,1)>=2,\"Tirage au Sort C1\")))","v":"1er Groupe C"},0,null,null,null,null,{"$f":"IF(SUM(T27:T30)=0,\"2nd Groupe D\",IF(OR(COUNTIF(R27:R30,1)>1,COUNTIF(R27:R30,2)>1),\"Tirage au sort D2\",VLOOKUP(2,R27:S30,2,FALSE)))","v":"2nd Groupe D"},0]
[null,"2018-06-22","20:00:00",26,"Groupe E",null,null,null,"Serbie",null,null,"Suisse",null,null,null,null,{"$f":"AA33*1000+Z33*100+X33*10","v":0},{"$f":"RANK(Q33,$Q$33:$Q$36,0)","v":1},"Costa Rica",{"$f":"SUMPRODUCT((Teams1=S33)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S33)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S33)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S33)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S33)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S33)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S33)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S33)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S33)*(Teams1_Score))+SUMPRODUCT((Teams2=S33)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S33)*(Teams2_Score))+SUMPRODUCT((Teams2=S33)*(Teams1_Score))","v":0},{"$f":"X33-Y33","v":0},{"$f":"3*U33+V33","v":0},null,null,"2018-07-01",4,{"$f":"IF(SUM(T27:T30)=0,\"1er Groupe D\",IF(COUNTIF(R27:R30,1)=1,VLOOKUP(1,R27:S30,2,FALSE),IF(COUNTIF(R27:R30,1)>=2,\"Tirage au Sort D1\")))","v":"1er Groupe D"},0,null,null,null,null,{"$f":"IF(SUM(T21:T24)=0,\"2nd Groupe C\",IF(OR(COUNTIF(R21:R24,1)>1,COUNTIF(R21:R24,2)>1),\"Tirage au sort C2\",VLOOKUP(2,R21:S24,2,FALSE)))","v":"2nd Groupe C"},0]
[null,"2018-06-23","18:00:00",27,"Groupe F",null,null,null,"République de Corée",null,null,"Mexique",null,null,null,null,{"$f":"AA34*1000+Z34*100+X34*10","v":0},{"$f":"RANK(Q34,$Q$33:$Q$36,0)","v":1},"Serbie",{"$f":"SUMPRODUCT((Teams1=S34)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S34)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S34)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S34)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S34)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S34)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S34)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S34)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S34)*(Teams1_Score))+SUMPRODUCT((Teams2=S34)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S34)*(Teams2_Score))+SUMPRODUCT((Teams2=S34)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-02",5,{"$f":"IF(SUM(T33:T36)=0,\"1er Groupe E\",IF(COUNTIF(R33:R36,1)=1,VLOOKUP(1,R33:S36,2,FALSE),IF(COUNTIF(R33:R36,1)>=2,\"Tirage au Sort E1\")))","v":"1er Groupe E"},0,null,null,null,null,{"$f":"IF(SUM(T39:T42)=0,\"2nd Groupe F\",IF(OR(COUNTIF(R39:R42,1)>1,COUNTIF(R39:R42,2)>1),\"Tirage au sort F2\",VLOOKUP(2,R39:S42,2,FALSE)))","v":"2nd Groupe F"},0]
[null,"2018-06-23","21:00:00",28,"Groupe F",null,null,null,"Allemagne",null,null,"Suède",null,null,null,null,{"$f":"AA35*1000+Z35*100+X35*10","v":0},1,"Brésil",{"$f":"SUMPRODUCT((Teams1=S35)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S35)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S35)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S35)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S35)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S35)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S35)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S35)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S35)*(Teams1_Score))+SUMPRODUCT((Teams2=S35)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S35)*(Teams2_Score))+SUMPRODUCT((Teams2=S35)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-03",6,{"$f":"IF(SUM(T39:T42)=0,\"1er Groupe F\",IF(COUNTIF(R39:R42,1)=1,VLOOKUP(1,R39:S42,2,FALSE),IF(COUNTIF(R39:R42,1)>=2,\"Tirage au Sort F1\")))","v":"1er Groupe F"},0,null,null,null,null,{"$f":"IF(SUM(T33:T36)=0,\"2nd Groupe E\",IF(OR(COUNTIF(R33:R36,1)>1,COUNTIF(R33:R36,2)>1),\"Tirage au sort E2\",VLOOKUP(2,R33:S36,2,FALSE)))","v":"2nd Groupe E"},0]
[null,"2018-06-23","15:00:00",29,"Groupe G",null,null,null,"Belgique",null,null,"Tunisie",null,null,null,null,{"$f":"AA36*1000+Z36*100+X36*10","v":0},1,"Suisse",{"$f":"SUMPRODUCT((Teams1=S36)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S36)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S36)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S36)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S36)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S36)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S36)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S36)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S36)*(Teams1_Score))+SUMPRODUCT((Teams2=S36)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S36)*(Teams2_Score))+SUMPRODUCT((Teams2=S36)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-02",7,{"$f":"IF(SUM(T45:T48)=0,\"1er Groupe G\",IF(COUNTIF(R45:R48,1)=1,VLOOKUP(1,R45:S48,2,FALSE),IF(COUNTIF(R45:R48,1)>=2,\"Tirage au Sort G1\")))","v":"1er Groupe G"},0,null,null,null,null,{"$f":"IF(SUM(T51:T54)=0,\"2nd Groupe H\",IF(OR(COUNTIF(R51:R54,1)>1,COUNTIF(R51:R54,2)>1),\"Tirage au sort H2\",VLOOKUP(2,R51:S54,2,FALSE)))","v":"2nd Groupe H"},0]
[null,"2018-06-24","15:00:00",30,"Groupe G",null,null,null,"Angleterre",null,null,"Panama",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-03",8,{"$f":"IF(SUM(T51:T54)=0,\"1er Groupe H\",IF(COUNTIF(R51:R54,1)=1,VLOOKUP(1,R51:S54,2,FALSE),IF(COUNTIF(R51:R54,1)>=2,\"Tirage au Sort H1\")))","v":"1er Groupe H"},0,null,null,null,null,{"$f":"IF(SUM(T45:T48)=0,\"2nd Groupe G\",IF(OR(COUNTIF(R45:R48,1)>1,COUNTIF(R45:R48,2)>1),\"Tirage au sort G2\",VLOOKUP(2,R45:S48,2,FALSE)))","v":"2nd Groupe G"},0]
[null,"2018-06-24","20:00:00",31,"Groupe H",null,null,null,"Japon",null,null,"Sénégal",null,null,null,null,null,"Rg","Groupe F","MJ","G","N","P","BP","BC","Pts","Pts"]
[null,"2018-06-24","21:00:00",32,"Groupe H",null,null,null,"Pologne",null,null,"Colombie",null,null,null,null,{"$f":"AA39*1000+Z39*100+X39*10","v":0},{"$f":"RANK(Q39,$Q$39:$Q$42,0)","v":1},"Allemagne",{"$f":"SUMPRODUCT((Teams1=S39)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S39)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S39)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S39)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S39)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S39)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S39)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S39)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S39)*(Teams1_Score))+SUMPRODUCT((Teams2=S39)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S39)*(Teams2_Score))+SUMPRODUCT((Teams2=S39)*(Teams1_Score))","v":0},{"$f":"X39-Y39","v":0},{"$f":"3*U39+V39","v":0}]
[null,"2018-06-25","18:00:00",33,"Groupe A",null,null,null,"Uruguay",null,null,"Russie",null,null,null,null,{"$f":"AA40*1000+Z40*100+X40*10","v":0},{"$f":"RANK(Q40,$Q$39:$Q$42,0)","v":1},"Mexique",{"$f":"SUMPRODUCT((Teams1=S40)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S40)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S40)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S40)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S40)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S40)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S40)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S40)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S40)*(Teams1_Score))+SUMPRODUCT((Teams2=S40)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S40)*(Teams2_Score))+SUMPRODUCT((Teams2=S40)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-25","17:00:00",34,"Groupe A",null,null,null,"Arabie Saoudite",null,null,"Egypte",null,null,null,null,{"$f":"AA41*1000+Z41*100+X41*10","v":0},1,"Suède",{"$f":"SUMPRODUCT((Teams1=S41)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S41)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S41)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S41)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S41)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S41)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S41)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S41)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S41)*(Teams1_Score))+SUMPRODUCT((Teams2=S41)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S41)*(Teams2_Score))+SUMPRODUCT((Teams2=S41)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-25","21:00:00",35,"Groupe B",null,null,null,"RI Iran",null,null,"Portugal",null,null,null,null,{"$f":"AA42*1000+Z42*100+X42*10","v":0},1,"République de Corée",{"$f":"SUMPRODUCT((Teams1=S42)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S42)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S42)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S42)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S42)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S42)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S42)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S42)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S42)*(Teams1_Score))+SUMPRODUCT((Teams2=S42)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S42)*(Teams2_Score))+SUMPRODUCT((Teams2=S42)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-25","20:00:00",36,"Groupe B",null,null,null,"Espagne",null,null,"Maroc"]
[null,"2018-06-26","17:00:00",37,"Groupe C",null,null,null,"Danemark",null,null,"France",null,null,null,null,null,"Rg","Groupe G","MJ","G","N","P","BP","BC","Pts","Pts"]
[null,"2018-06-26","17:00:00",38,"Groupe C",null,null,null,"Australie",null,null,"Pérou",null,null,null,null,{"$f":"AA45*1000+Z45*100+X45*10","v":0},{"$f":"RANK(Q45,$Q$45:$Q$48,0)","v":1},"Belgique",{"$f":"SUMPRODUCT((Teams1=S45)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S45)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S45)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S45)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S45)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S45)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S45)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S45)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S45)*(Teams1_Score))+SUMPRODUCT((Teams2=S45)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S45)*(Teams2_Score))+SUMPRODUCT((Teams2=S45)*(Teams1_Score))","v":0},{"$f":"X45-Y45","v":0},{"$f":"3*U45+V45","v":0}]
[null,"2018-06-26","21:00:00",39,"Groupe D",null,null,null,"Nigeria",null,null,"Argentine",null,null,null,null,{"$f":"AA46*1000+Z46*100+X46*10","v":0},{"$f":"RANK(Q46,$Q$45:$Q$48,0)","v":1},"Panama",{"$f":"SUMPRODUCT((Teams1=S46)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S46)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S46)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S46)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S46)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S46)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S46)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S46)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S46)*(Teams1_Score))+SUMPRODUCT((Teams2=S46)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S46)*(Teams2_Score))+SUMPRODUCT((Teams2=S46)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-26","21:00:00",40,"Groupe D",null,null,null,"Islande",null,null,"Croatie",null,null,null,null,{"$f":"AA47*1000+Z47*100+X47*10","v":0},1,"Tunisie",{"$f":"SUMPRODUCT((Teams1=S47)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S47)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S47)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S47)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S47)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S47)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S47)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S47)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S47)*(Teams1_Score))+SUMPRODUCT((Teams2=S47)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S47)*(Teams2_Score))+SUMPRODUCT((Teams2=S47)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-27","21:00:00",41,"Groupe E",null,null,null,"Serbie",null,null,"Brésil",null,null,null,null,{"$f":"AA48*1000+Z48*100+X48*10","v":0},1,"Angleterre",{"$f":"SUMPRODUCT((Teams1=S48)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S48)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S48)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S48)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S48)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S48)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S48)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S48)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S48)*(Teams1_Score))+SUMPRODUCT((Teams2=S48)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S48)*(Teams2_Score))+SUMPRODUCT((Teams2=S48)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-27","21:00:00",42,"Groupe E",null,null,null,"Suisse",null,null,"Costa Rica"]
[null,"2018-06-27","19:00:00",43,"Groupe F",null,null,null,"Mexique",null,null,"Suède",null,null,null,null,null,"Rg","Groupe H","MJ","G","N","P","BP","BC","Pts","Pts"]
[null,"2018-06-27","17:00:00",44,"Groupe F",null,null,null,"République de Corée",null,null,"Allemagne",null,null,null,null,{"$f":"AA51*1000+Z51*100+X51*10","v":0},{"$f":"RANK(Q51,$Q$51:$Q$54,0)","v":1},"Colombie",{"$f":"SUMPRODUCT((Teams1=S51)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S51)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S51)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S51)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S51)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S51)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S51)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S51)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S51)*(Teams1_Score))+SUMPRODUCT((Teams2=S51)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S51)*(Teams2_Score))+SUMPRODUCT((Teams2=S51)*(Teams1_Score))","v":0},{"$f":"X51-Y51","v":0},{"$f":"3*U51+V51","v":0}]
[null,"2018-06-28","21:00:00",45,"Groupe G",null,null,null,"Panama",null,null,"Tunisie",null,null,null,null,{"$f":"AA52*1000+Z52*100+X52*10","v":0},{"$f":"RANK(Q52,$Q$51:$Q$54,0)","v":1},"Japon",{"$f":"SUMPRODUCT((Teams1=S52)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S52)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S52)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S52)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S52)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S52)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S52)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S52)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S52)*(Teams1_Score))+SUMPRODUCT((Teams2=S52)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S52)*(Teams2_Score))+SUMPRODUCT((Teams2=S52)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-28","20:00:00",46,"Groupe G",null,null,null,"Angleterre",null,null,"Belgique",null,null,null,null,{"$f":"AA53*1000+Z53*100+X53*10","v":0},1,"Pologne",{"$f":"SUMPRODUCT((Teams1=S53)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S53)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S53)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S53)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S53)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S53)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S53)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S53)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S53)*(Teams1_Score))+SUMPRODUCT((Teams2=S53)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S53)*(Teams2_Score))+SUMPRODUCT((Teams2=S53)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-28","17:00:00",47,"Groupe H",null,null,null,"Japon",null,null,"Pologne",null,null,null,null,{"$f":"AA54*1000+Z54*100+X54*10","v":0},1,"Sénégal",{"$f":"SUMPRODUCT((Teams1=S54)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S54)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S54)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=S54)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S54)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=S54)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=S54)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=S54)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S54)*(Teams1_Score))+SUMPRODUCT((Teams2=S54)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=S54)*(Teams2_Score))+SUMPRODUCT((Teams2=S54)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-28","18:00:00",48,"Groupe H",null,null,null,"Sénégal",null,null,"Colombie"]
[]
[]
[]
[null,"Tirage au sort A1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($R$9:$R$12,1),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=1,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:1))),\"\")","v":"Russie"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($R$9:$R$12,1),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=1,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:2))),\"\")","v":"Arabie Saoudite"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($R$9:$R$12,1),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=1,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:3))),\"\")","v":"Egypte"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($R$9:$R$12,1),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=1,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:4))),\"\")","v":"Uruguay"}]
[null,"Tirage au sort A2"]
[null,{"$f":"IF(COUNTIF($R$9:$R$12,1)>1,IF(ROWS($1:1)<=COUNTIF($R$9:$R$12,1),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=1,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:1))),\"\"),IF(COUNTIF($R$9:$R$12,2)>1,IF(ROWS($1:1)<=COUNTIF($R$9:$R$12,2),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=2,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:1))),\"\")))","v":"Russie"}]
[null,{"$f":"IF(COUNTIF($R$9:$R$12,1)>1,IF(ROWS($1:2)<=COUNTIF($R$9:$R$12,1),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=1,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:2))),\"\"),IF(COUNTIF($R$9:$R$12,2)>1,IF(ROWS($1:2)<=COUNTIF($R$9:$R$12,2),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=2,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:2))),\"\")))","v":"Arabie Saoudite"}]
[null,{"$f":"IF(COUNTIF($R$9:$R$12,1)>1,IF(ROWS($1:3)<=COUNTIF($R$9:$R$12,1),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=1,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:3))),\"\"),IF(COUNTIF($R$9:$R$12,2)>1,IF(ROWS($1:3)<=COUNTIF($R$9:$R$12,2),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=2,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:3))),\"\")))","v":"Egypte"}]
[null,{"$f":"IF(COUNTIF($R$9:$R$12,1)>1,IF(ROWS($1:4)<=COUNTIF($R$9:$R$12,1),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=1,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:4))),\"\"),IF(COUNTIF($R$9:$R$12,2)>1,IF(ROWS($1:4)<=COUNTIF($R$9:$R$12,2),INDEX($S$9:$S$12,SMALL(IF($R$9:$R$12=2,ROW(INDIRECT(\"1:\"&ROWS($R$9:$R$12)))),ROWS($1:4))),\"\")))","v":"Uruguay"}]
[null,"Tirage au sort B1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($R$15:$R$18,1),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=1,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:1))),\"\")","v":"Maroc"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($R$15:$R$18,1),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=1,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:2))),\"\")","v":"RI Iran"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($R$15:$R$18,1),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=1,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:3))),\"\")","v":"Portugal"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($R$15:$R$18,1),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=1,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:4))),\"\")","v":"Espagne"}]
[null,"Tirage au sort B2"]
[null,{"$f":"IF(COUNTIF($R$15:$R$18,1)>1,IF(ROWS($1:1)<=COUNTIF($R$15:$R$18,1),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=1,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:1))),\"\"),IF(COUNTIF($R$15:$R$18,2)>1,IF(ROWS($1:1)<=COUNTIF($R$15:$R$18,2),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=2,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:1))),\"\")))","v":"Maroc"}]
[null,{"$f":"IF(COUNTIF($R$15:$R$18,1)>1,IF(ROWS($1:2)<=COUNTIF($R$15:$R$18,1),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=1,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:2))),\"\"),IF(COUNTIF($R$15:$R$18,2)>1,IF(ROWS($1:2)<=COUNTIF($R$15:$R$18,2),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=2,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:2))),\"\")))","v":"RI Iran"}]
[null,{"$f":"IF(COUNTIF($R$15:$R$18,1)>1,IF(ROWS($1:3)<=COUNTIF($R$15:$R$18,1),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=1,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:3))),\"\"),IF(COUNTIF($R$15:$R$18,2)>1,IF(ROWS($1:3)<=COUNTIF($R$15:$R$18,2),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=2,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:3))),\"\")))","v":"Portugal"}]
[null,{"$f":"IF(COUNTIF($R$15:$R$18,1)>1,IF(ROWS($1:4)<=COUNTIF($R$15:$R$18,1),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=1,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:4))),\"\"),IF(COUNTIF($R$15:$R$18,2)>1,IF(ROWS($1:4)<=COUNTIF($R$15:$R$18,2),INDEX($S$15:$S$18,SMALL(IF($R$15:$R$18=2,ROW(INDIRECT(\"1:\"&ROWS($R$15:$R$18)))),ROWS($1:4))),\"\")))","v":"Espagne"}]
[null,"Tirage au sort C1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($R$21:$R$24,1),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=1,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:1))),\"\")","v":"France"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($R$21:$R$24,1),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=1,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:2))),\"\")","v":"Australie"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($R$21:$R$24,1),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=1,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:3))),\"\")","v":"Pérou"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($R$21:$R$24,1),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=1,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:4))),\"\")","v":"Danemark"}]
[null,"Tirage au sort C2"]
[null,{"$f":"IF(COUNTIF($R$21:$R$24,1)>1,IF(ROWS($1:1)<=COUNTIF($R$21:$R$24,1),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=1,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:1))),\"\"),IF(COUNTIF($R$21:$R$24,2)>1,IF(ROWS($1:1)<=COUNTIF($R$21:$R$24,2),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=2,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:1))),\"\")))","v":"France"}]
[null,{"$f":"IF(COUNTIF($R$21:$R$24,1)>1,IF(ROWS($1:2)<=COUNTIF($R$21:$R$24,1),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=1,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:2))),\"\"),IF(COUNTIF($R$21:$R$24,2)>1,IF(ROWS($1:2)<=COUNTIF($R$21:$R$24,2),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=2,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:2))),\"\")))","v":"Australie"}]
[null,{"$f":"IF(COUNTIF($R$21:$R$24,1)>1,IF(ROWS($1:3)<=COUNTIF($R$21:$R$24,1),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=1,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:3))),\"\"),IF(COUNTIF($R$21:$R$24,2)>1,IF(ROWS($1:3)<=COUNTIF($R$21:$R$24,2),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=2,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:3))),\"\")))","v":"Pérou"}]
[null,{"$f":"IF(COUNTIF($R$21:$R$24,1)>1,IF(ROWS($1:4)<=COUNTIF($R$21:$R$24,1),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=1,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:4))),\"\"),IF(COUNTIF($R$21:$R$24,2)>1,IF(ROWS($1:4)<=COUNTIF($R$21:$R$24,2),INDEX($S$21:$S$24,SMALL(IF($R$21:$R$24=2,ROW(INDIRECT(\"1:\"&ROWS($R$21:$R$24)))),ROWS($1:4))),\"\")))","v":"Danemark"}]
[null,"Tirage au sort D1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($R$27:$R$30,1),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=1,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:1))),\"\")","v":"Argentine"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($R$27:$R$30,1),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=1,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:2))),\"\")","v":"Islande"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($R$27:$R$30,1),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=1,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:3))),\"\")","v":"Croatie"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($R$27:$R$30,1),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=1,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:4))),\"\")","v":"Nigeria"}]
[null,"Tirage au sort D2"]
[null,{"$f":"IF(COUNTIF($R$27:$R$30,1)>1,IF(ROWS($1:1)<=COUNTIF($R$27:$R$30,1),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=1,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:1))),\"\"),IF(COUNTIF($R$27:$R$30,2)>1,IF(ROWS($1:1)<=COUNTIF($R$27:$R$30,2),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=2,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:1))),\"\")))","v":"Argentine"}]
[null,{"$f":"IF(COUNTIF($R$27:$R$30,1)>1,IF(ROWS($1:2)<=COUNTIF($R$27:$R$30,1),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=1,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:2))),\"\"),IF(COUNTIF($R$27:$R$30,2)>1,IF(ROWS($1:2)<=COUNTIF($R$27:$R$30,2),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=2,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:2))),\"\")))","v":"Islande"}]
[null,{"$f":"IF(COUNTIF($R$27:$R$30,1)>1,IF(ROWS($1:3)<=COUNTIF($R$27:$R$30,1),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=1,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:3))),\"\"),IF(COUNTIF($R$27:$R$30,2)>1,IF(ROWS($1:3)<=COUNTIF($R$27:$R$30,2),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=2,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:3))),\"\")))","v":"Croatie"}]
[null,{"$f":"IF(COUNTIF($R$27:$R$30,1)>1,IF(ROWS($1:4)<=COUNTIF($R$27:$R$30,1),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=1,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:4))),\"\"),IF(COUNTIF($R$27:$R$30,2)>1,IF(ROWS($1:4)<=COUNTIF($R$27:$R$30,2),INDEX($S$27:$S$30,SMALL(IF($R$27:$R$30=2,ROW(INDIRECT(\"1:\"&ROWS($R$27:$R$30)))),ROWS($1:4))),\"\")))","v":"Nigeria"}]
[null,"Tirage au sort E1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($R$33:$R$36,1),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=1,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:1))),\"\")","v":"Costa Rica"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($R$33:$R$36,1),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=1,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:2))),\"\")","v":"Serbie"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($R$33:$R$36,1),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=1,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:3))),\"\")","v":"Brésil"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($R$33:$R$36,1),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=1,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:4))),\"\")","v":"Suisse"}]
[null,"Tirage au sort E2"]
[null,{"$f":"IF(COUNTIF($R$33:$R$36,1)>1,IF(ROWS($1:1)<=COUNTIF($R$33:$R$36,1),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=1,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:1))),\"\"),IF(COUNTIF($R$33:$R$36,2)>1,IF(ROWS($1:1)<=COUNTIF($R$33:$R$36,2),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=2,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:1))),\"\")))","v":"Costa Rica"}]
[null,{"$f":"IF(COUNTIF($R$33:$R$36,1)>1,IF(ROWS($1:2)<=COUNTIF($R$33:$R$36,1),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=1,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:2))),\"\"),IF(COUNTIF($R$33:$R$36,2)>1,IF(ROWS($1:2)<=COUNTIF($R$33:$R$36,2),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=2,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:2))),\"\")))","v":"Serbie"}]
[null,{"$f":"IF(COUNTIF($R$33:$R$36,1)>1,IF(ROWS($1:3)<=COUNTIF($R$33:$R$36,1),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=1,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:3))),\"\"),IF(COUNTIF($R$33:$R$36,2)>1,IF(ROWS($1:3)<=COUNTIF($R$33:$R$36,2),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=2,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:3))),\"\")))","v":"Brésil"}]
[null,{"$f":"IF(COUNTIF($R$33:$R$36,1)>1,IF(ROWS($1:4)<=COUNTIF($R$33:$R$36,1),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=1,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:4))),\"\"),IF(COUNTIF($R$33:$R$36,2)>1,IF(ROWS($1:4)<=COUNTIF($R$33:$R$36,2),INDEX($S$33:$S$36,SMALL(IF($R$33:$R$36=2,ROW(INDIRECT(\"1:\"&ROWS($R$33:$R$36)))),ROWS($1:4))),\"\")))","v":"Suisse"}]
[null,"Tirage au sort F1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($R$39:$R$42,1),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=1,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:1))),\"\")","v":"Allemagne"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($R$39:$R$42,1),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=1,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:2))),\"\")","v":"Mexique"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($R$39:$R$42,1),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=1,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:3))),\"\")","v":"Suède"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($R$39:$R$42,1),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=1,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:4))),\"\")","v":"République de Corée"}]
[null,"Tirage au sort F2"]
[null,{"$f":"IF(COUNTIF($R$39:$R$42,1)>1,IF(ROWS($1:1)<=COUNTIF($R$39:$R$42,1),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=1,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:1))),\"\"),IF(COUNTIF($R$39:$R$42,2)>1,IF(ROWS($1:1)<=COUNTIF($R$39:$R$42,2),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=2,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:1))),\"\")))","v":"Allemagne"}]
[null,{"$f":"IF(COUNTIF($R$39:$R$42,1)>1,IF(ROWS($1:2)<=COUNTIF($R$39:$R$42,1),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=1,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:2))),\"\"),IF(COUNTIF($R$39:$R$42,2)>1,IF(ROWS($1:2)<=COUNTIF($R$39:$R$42,2),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=2,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:2))),\"\")))","v":"Mexique"}]
[null,{"$f":"IF(COUNTIF($R$39:$R$42,1)>1,IF(ROWS($1:3)<=COUNTIF($R$39:$R$42,1),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=1,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:3))),\"\"),IF(COUNTIF($R$39:$R$42,2)>1,IF(ROWS($1:3)<=COUNTIF($R$39:$R$42,2),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=2,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:3))),\"\")))","v":"Suède"}]
[null,{"$f":"IF(COUNTIF($R$39:$R$42,1)>1,IF(ROWS($1:4)<=COUNTIF($R$39:$R$42,1),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=1,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:4))),\"\"),IF(COUNTIF($R$39:$R$42,2)>1,IF(ROWS($1:4)<=COUNTIF($R$39:$R$42,2),INDEX($S$39:$S$42,SMALL(IF($R$39:$R$42=2,ROW(INDIRECT(\"1:\"&ROWS($R$39:$R$42)))),ROWS($1:4))),\"\")))","v":"République de Corée"}]
[null,"Tirage au sort G1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($R$45:$R$48,1),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=1,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:1))),\"\")","v":"Belgique"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($R$45:$R$48,1),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=1,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:2))),\"\")","v":"Panama"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($R$45:$R$48,1),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=1,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:3))),\"\")","v":"Tunisie"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($R$45:$R$48,1),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=1,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:4))),\"\")","v":"Angleterre"}]
[null,"Tirage au sort G2"]
[null,{"$f":"IF(COUNTIF($R$45:$R$48,1)>1,IF(ROWS($1:1)<=COUNTIF($R$45:$R$48,1),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=1,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:1))),\"\"),IF(COUNTIF($R$45:$R$48,2)>1,IF(ROWS($1:1)<=COUNTIF($R$45:$R$48,2),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=2,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:1))),\"\")))","v":"Belgique"}]
[null,{"$f":"IF(COUNTIF($R$45:$R$48,1)>1,IF(ROWS($1:2)<=COUNTIF($R$45:$R$48,1),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=1,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:2))),\"\"),IF(COUNTIF($R$45:$R$48,2)>1,IF(ROWS($1:2)<=COUNTIF($R$45:$R$48,2),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=2,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:2))),\"\")))","v":"Panama"}]
[null,{"$f":"IF(COUNTIF($R$45:$R$48,1)>1,IF(ROWS($1:3)<=COUNTIF($R$45:$R$48,1),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=1,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:3))),\"\"),IF(COUNTIF($R$45:$R$48,2)>1,IF(ROWS($1:3)<=COUNTIF($R$45:$R$48,2),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=2,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:3))),\"\")))","v":"Tunisie"}]
[null,{"$f":"IF(COUNTIF($R$45:$R$48,1)>1,IF(ROWS($1:4)<=COUNTIF($R$45:$R$48,1),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=1,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:4))),\"\"),IF(COUNTIF($R$45:$R$48,2)>1,IF(ROWS($1:4)<=COUNTIF($R$45:$R$48,2),INDEX($S$45:$S$48,SMALL(IF($R$45:$R$48=2,ROW(INDIRECT(\"1:\"&ROWS($R$45:$R$48)))),ROWS($1:4))),\"\")))","v":"Angleterre"}]
[null,"Tirage au sort H1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($R$51:$R$54,1),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=1,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:1))),\"\")","v":"Colombie"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($R$51:$R$54,1),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=1,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:2))),\"\")","v":"Japon"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($R$51:$R$54,1),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=1,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:3))),\"\")","v":"Pologne"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($R$51:$R$54,1),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=1,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:4))),\"\")","v":"Sénégal"}]
[null,"Tirage au sort H2"]
[null,{"$f":"IF(COUNTIF($R$51:$R$54,1)>1,IF(ROWS($1:1)<=COUNTIF($R$51:$R$54,1),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=1,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:1))),\"\"),IF(COUNTIF($R$51:$R$54,2)>1,IF(ROWS($1:1)<=COUNTIF($R$51:$R$54,2),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=2,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:1))),\"\")))","v":"Colombie"}]
[null,{"$f":"IF(COUNTIF($R$51:$R$54,1)>1,IF(ROWS($1:2)<=COUNTIF($R$51:$R$54,1),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=1,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:2))),\"\"),IF(COUNTIF($R$51:$R$54,2)>1,IF(ROWS($1:2)<=COUNTIF($R$51:$R$54,2),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=2,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:2))),\"\")))","v":"Japon"}]
[null,{"$f":"IF(COUNTIF($R$51:$R$54,1)>1,IF(ROWS($1:3)<=COUNTIF($R$51:$R$54,1),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=1,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:3))),\"\"),IF(COUNTIF($R$51:$R$54,2)>1,IF(ROWS($1:3)<=COUNTIF($R$51:$R$54,2),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=2,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:3))),\"\")))","v":"Pologne"}]
[null,{"$f":"IF(COUNTIF($R$51:$R$54,1)>1,IF(ROWS($1:4)<=COUNTIF($R$51:$R$54,1),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=1,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:4))),\"\"),IF(COUNTIF($R$51:$R$54,2)>1,IF(ROWS($1:4)<=COUNTIF($R$51:$R$54,2),INDEX($S$51:$S$54,SMALL(IF($R$51:$R$54=2,ROW(INDIRECT(\"1:\"&ROWS($R$51:$R$54)))),ROWS($1:4))),\"\")))","v":"Sénégal"}]

{"sheet":"CLASSEMENT","index":1,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[[28,4,28,5],[13,8,13,12],[14,8,14,12],[15,8,15,12],[0,1,2,6]]}
[null,"CLASSEMENT DES PRONOSTIQUEURS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROWS($1:2)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:2)),\"\")","v":"CLASSEMENT"}]
[null,null,null,"Nom Pronostiqueur","Lien","Points",null,null,null,null,null,null,null,null,null,{"$f":"IF(ROWS($1:3)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:3)),\"\")","v":"GUIDE"}]
[null,null,1,{"$f":"IF($O5=\"\",\"\",IFERROR(INDEX($O$5:$O$24,MATCH(LARGE($R$5:$R$24,$C5),$R$5:$R$24,0)),\"\"))","v":""},{"$f":"IF(ISERROR(HYPERLINK(INDIRECT(\"'\"&D5&\"'!A1\"),D5)),\"\",HYPERLINK(INDIRECT(\"'\"&D5&\"'!A1\"),D5))","v":""},{"$f":"IF(O5<>\"\",IFERROR(LARGE($R$5:$R$24,$C5),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&P5&\"'!$B$4\"),\"\")","v":"Pronostiqueur 1"},{"$f":"IF(ROWS($1:4)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:4)),\"\")","v":"Pronostiqueur 1"},{"$f":"IFERROR(INDIRECT(\"'\"&P5&\"'!$AO$6\"),\"\")","v":0},{"$f":"IFERROR(IF(Q5,Q5+(ROW()/10^9),\"\"),\"\")","v":""}]
[null,null,2,"",{"$f":"IF(ISERROR(HYPERLINK(INDIRECT(\"'\"&D6&\"'!A1\"),D6)),\"\",HYPERLINK(INDIRECT(\"'\"&D6&\"'!A1\"),D6))","v":""},"",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:5)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:5)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&P6&\"'!$AO$6\"),\"\")","v":""},{"$f":"IFERROR(IF(Q6,Q6+(ROW()/10^9),\"\"),\"\")","v":""}]
[null,null,3,"",{"$f":"IF(ISERROR(HYPERLINK(INDIRECT(\"'\"&D7&\"'!A1\"),D7)),\"\",HYPERLINK(INDIRECT(\"'\"&D7&\"'!A1\"),D7))","v":""},"",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:6)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:6)),\"\")","v":""},"",""]
[null,null,4,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:7)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:7)),\"\")","v":""},"",""]
[null,null,5,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:8)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:8)),\"\")","v":""},"",""]
[null,null,6,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:9)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:9)),\"\")","v":""},"",""]
[null,null,7,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:10)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:10)),\"\")","v":""},"",""]
[null,null,8,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:11)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:11)),\"\")","v":""},"",""]
[null,null,9,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:12)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:12)),\"\")","v":""},"",""]
[null,null,10,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:13)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:13)),\"\")","v":""},"",""]
[null,null,11,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:14)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:14)),\"\")","v":""},"",""]
[null,null,12,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:15)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:15)),\"\")","v":""},"",""]
[null,null,13,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:16)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:16)),\"\")","v":""},"",""]
[null,null,14,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:17)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:17)),\"\")","v":""},"",""]
[null,null,15,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:18)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:18)),\"\")","v":""},"",""]
[null,null,16,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:19)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:19)),\"\")","v":""},"",""]
[null,null,17,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:20)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:20)),\"\")","v":""},"",""]
[null,null,18,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:21)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:21)),\"\")","v":""},"",""]
[null,null,19,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:22)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:22)),\"\")","v":""},"",""]
[null,null,20,"","","",null,null,null,null,null,null,null,null,"",{"$f":"IF(ROWS($1:23)<=COUNTA(NomsF),INDEX(NomsF,ROWS($1:23)),\"\")","v":""},"",""]

{"sheet":"GUIDE","index":2,"n_rows":148,"n_cols":29,"rows_kept":148,"cut":false,"hidden":false,"merged":[[3,5,3,11],[5,28,5,37],[6,28,6,37],[13,28,13,37],[16,28,16,37],[5,2,5,16],[5,17,5,24],[20,28,20,37],[24,28,24,37],[28,28,28,37],[32,28,32,37],[36,28,36,37],[23,28,23,37]]}
[]
[]
[]
[]
[]
[null,null,"UTILISATION DU FICHIER PRONOSTIC FIFA World Cup 2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pour accéder aux côtes dans les onglets Résultats & des pronostiqueurs, ôtez la protection avec le mot de passe : XLD.",null,null,null,null,null,null,null,null,null,null,"VERSIONS"]
[null,null,"1 - COMMENT CA MARCHE?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 1.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,"Cette version 1.0 a été réalisée à partir de la version 2.6 (JCGL) du fichier précédemment créé pour"]
[null,null,"Merci d'avoir téléchargé \"FIFA World Cup Russia 2018 - XLD\".",null,null,null,null,null,null,null,null,null,null,null,null,"REGLES DE CALCUL DES POINTS ATTRIBUES :",null,null,null,null,null,null,null,null,null,null,null,null," la coupe du monde 2014."]
[null,null,"L'origine de ce fichier remonte à la coupe du monde 2014. Il a été créé par David Aubert, webmaster du site Excel Downloads :"]
[null,null,"https://www.excel-downloads.com"]
[null,null,"Il a été ensuite amélioré par les membres du site et plus particulièrement par JCGL, que je remercie chaleureusement!!"]
[null,null,"Rendez vous régulièrement sur la page de téléchargement du fichier pour suivre les mises à jour ou participer aux discussions relatives"]
[null,null,"au programme :",null,"https://www.excel-downloads.com/resources/coupe-du-monde-football-russie-2018.1075/"]
[]
[null,null,"Ce fichier va vous permettre d'organiser un concours de pronostics pour 1 à 20 joueurs. "]
[null,null,"Avant la coupe du monde, créez un onglet par pronostiqueur et saisissez les pronostics des joueurs."]
[null,null,"Lorsque la Coupe du Monde débute, il ne vous reste plus qu'à saisir les résultats des matchs au jour le jour et "]
[null,null,"voir évoluer les scores et classements des pronostiqueurs jusqu'à la Finale, dans l'onglet \"CLASSEMENT\"."]
[]
[null,null,"Commençons tout d'abord par voir comment créer les onglets des pronostiqueurs…"]
[]
[]
[null,null,"2 - AJOUT DES PRONOSTIQUEURS"]
[]
[null,null,"IMPORTANT : pour le bon fonctionnement du fichier, il est crucial que les onglets \"RESULTATS\", \"CLASSEMENT\" et \"GUIDE\" restent positionnés avant les onglets de pronostics."]
[null,null,"Faite donc en sorte de ne jamais déplacer un fichier de pronostic avant ou entre ces onglets."]
[]
[null,null,"Suivre les étapes imagées ci-dessous :"]
[null,null,"Le fichier d'origine comporte un seul pronostiqueur nommé \"Pronostiqueur 1\"."]
[null,null,"Dupliquez cet onglet autant de fois que nécessaire et renommez le ainsi que ses copies avec les noms des pronostiqueurs."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"3 - SAISIE DES PRONOSTIQUES"]
[]
[null,null,"La saisie des pronostics d'effectue dans les onglets que vous avez créés tel qu'expliqué dans la partie \"2 - AJOUT DES PRONOSTIQUEURS\" de ce guide."]
[]
[null,null,"EN PHASE DE GROUPES"]
[]
[null,null,"Saisir les scores pour chaque matchs dans les colonnes \"Buts\"",null,null,null,null,null,null,null,null,"Les points et les statistiques sont calculés automatiquement "]
[null,null,"Les vainqueurs sont automatiquement mis en évidence sur fond rouge.",null,null,null,null,null,null,null,null,"dans les tableaux récapitulatifs des groupes."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1/8èmes de FINALE"]
[]
[null,null,"Dans 99% des cas, les règles de la FIFA permettent de départager tous les pays",null,null,null,null,null,null,null,null,"Si les règles de calcul de la FIFA ne permettent pas de départager les ex-aequos,"]
[null,null,"et il y a très peu de chances qu'il y ait des ex-aequos.",null,null,null,null,null,null,null,null,"alors le tableau des huitièmes de finales mettra en évidences les ex-aequos qui"]
[null,null,"Après avoir saisi tous les scores en phases de groupes, le tableau des huitièmes de finales doit être ainsi :",null,null,null,null,null,null,null,null,"seront départagés par un tirage au sort."]
[null,null,null,null,null,null,null,null,null,null,null,"Le tableau ressemblera à cela :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Dans ce cas, il y a des ex-aequos dans le groupe B qui seront départagés par un "]
[null,null,null,null,null,null,null,null,null,null,null,null,"tirage au sort. Choisissez les pays dans la liste déroulante."]
[null,null,null,null,null,null,null,null,null,null,null,null,"ATTENTION, dans ce cas, les modifications apportées aux scores dans la phase "]
[null,null,null,null,null,null,null,null,null,null,null,null,"de groupe ne seront plus répercutées dans le tableau des huitièmes de finales."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Il faudra reprendre un fichier vierge et ressaisir les scores pour faire une autre "]
[null,null,null,null,null,null,null,null,null,null,null,null,"simulation."]
[]
[null,null,"SAISIE DES SCORES EN PHASE FINALE"]
[]
[null,null,"Saisissez les scores des huitèmes de finales dans les colonnes \"Buts\"."]
[null,null,"En cas d'égalité, départagez les équipes aux tirs au buts en inscrivant les scores"]
[null,null,"dans les colonnes \"Pen\"."]
[null,null,"Vos pronostics des huitièmes de finales se répercutent automatiquement dans le "]
[null,null,"tableau des quarts de finales qu'il faudra renseigner de la même façon et ainsi "]
[null,null,"de suite jusqu'à la finale!!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"4 - SAISIE DES RESULTATS PENDANT LA COUPE DU MONDE & CLASSEMENT DES PRONOSTIQUEURS"]
[]
[null,null,"Dès que la coupe du monde démarre, ne touchez plus aux pronositques."]
[null,null,"Il suffit maintenant de saisir les résultats régulièrement (ou en fin de Coupe du Monde) pour découvrir le vainqueur du concours de pronostics!!"]
[]
[null,null,"La saisie des résultats s'efectue dans l'onglet \"RESULTATS\" comme vous l'avez fait pour les onglets des pronostiqueurs."]
[]
[null,null,"Le score des pronostiqueurs est automatiquement mis à jour dans les onglets des pronostiqueurs (en haut à droite) :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Le classement des pronostiqueurs est lui aussi mis à jour au fil de la saisie des résultats."]
[null,null,"Onglet \"CLASSEMENT\" :"]

{"sheet":"Pronostiqueur 1","index":3,"n_rows":138,"n_cols":45,"rows_kept":138,"cut":false,"hidden":false,"merged":[[3,9,3,12],[3,1,3,8],[2,1,2,8]]}
[]
[null,"Pronostics de :"]
[]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,32)","v":"Pronostiqueur 1"}]
[]
[null,"SAISIE DES PRONOSTICS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POINTS",null,null,null,null,null,null,null,null,null,null,null,null,"SCORE PRONOSTIQUEUR",null,null,null,null,null,null,null,null,{"$f":"AM8+AM12","v":0}]
[null,"Date","Heure","Match","Groupe",1,"N",2,null,"Buts",null,null,"Buts"]
[null,"2018-06-14","18:00:00",1,"Groupe A",1.3,4.3,10,"Russie",null,null,"Arabie Saoudite",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J8),ISBLANK(J8)),\"\",IF(AND('Pronostiqueur 1'!J8=RESULTATS!J8,'Pronostiqueur 1'!M8=RESULTATS!M8),3,IF(OR(AND('Pronostiqueur 1'!J8>'Pronostiqueur 1'!M8,RESULTATS!J8>RESULTATS!M8),AND('Pronostiqueur 1'!J8<'Pronostiqueur 1'!M8,RESULTATS!J8<RESULTATS!M8),AND('Pronostiqueur 1'!J8='Pronostiqueur 1'!M8,RESULTATS!J8=RESULTATS!M8)),1,0)))","v":""},null,null,null,null,"Rg","Groupe A","MJ","G","N","P","BP","BC","+/-","Pts",null,null,null,"Phases de groupes",null,null,null,null,null,null,{"$f":"N56","v":0},null,"points"]
[null,"2018-06-15","17:00:00",2,"Groupe A",2.2000000000000002,2.9,3.25,"Egypte",null,null,"Uruguay",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J9),ISBLANK(J9)),\"\",IF(AND('Pronostiqueur 1'!J9=RESULTATS!J9,'Pronostiqueur 1'!M9=RESULTATS!M9),3,IF(OR(AND('Pronostiqueur 1'!J9>'Pronostiqueur 1'!M9,RESULTATS!J9>RESULTATS!M9),AND('Pronostiqueur 1'!J9<'Pronostiqueur 1'!M9,RESULTATS!J9<RESULTATS!M9),AND('Pronostiqueur 1'!J9='Pronostiqueur 1'!M9,RESULTATS!J9=RESULTATS!M9)),1,0)))","v":""},null,null,null,{"$f":"AB9*1000+AA9*100+Y9*10","v":0},{"$f":"RANK(R9,$R$9:$R$12,0)","v":1},"Russie",{"$f":"SUMPRODUCT((Teams1=T9)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T9)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T9)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T9)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T9)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T9)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T9)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T9)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T9)*(Teams1_Score))+SUMPRODUCT((Teams2=T9)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T9)*(Teams2_Score))+SUMPRODUCT((Teams2=T9)*(Teams1_Score))","v":0},{"$f":"Y9-Z9","v":0},{"$f":"3*V9+W9","v":0},null,null,null,"Vainqueur ou nul trouvé (1 pt)",null,null,{"$f":"COUNTIF($N$8:$N$55,1)+COUNTIF($N$8:$N$55,3)","v":0},"matchs",null,null,{"$f":"AI9","v":0},null,"points"]
[null,"2018-06-15","18:00:00",3,"Groupe B",1.8,3.05,4.5,"Maroc",null,null,"RI Iran",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J10),ISBLANK(J10)),\"\",IF(AND('Pronostiqueur 1'!J10=RESULTATS!J10,'Pronostiqueur 1'!M10=RESULTATS!M10),3,IF(OR(AND('Pronostiqueur 1'!J10>'Pronostiqueur 1'!M10,RESULTATS!J10>RESULTATS!M10),AND('Pronostiqueur 1'!J10<'Pronostiqueur 1'!M10,RESULTATS!J10<RESULTATS!M10),AND('Pronostiqueur 1'!J10='Pronostiqueur 1'!M10,RESULTATS!J10=RESULTATS!M10)),1,0)))","v":""},null,null,null,{"$f":"AB10*1000+AA10*100+Y10*10","v":0},{"$f":"RANK(R10,$R$9:$R$12,0)","v":1},"Arabie Saoudite",{"$f":"SUMPRODUCT((Teams1=T10)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T10)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T10)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T10)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T10)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T10)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T10)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T10)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T10)*(Teams1_Score))+SUMPRODUCT((Teams2=T10)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T10)*(Teams2_Score))+SUMPRODUCT((Teams2=T10)*(Teams1_Score))","v":0},{"$f":"Y10-Z10","v":0},{"$f":"3*V10+W10","v":0},null,null,null,"Bonus score exact (2 pts)",null,null,{"$f":"+COUNTIF($N$8:$N$55,3)","v":0},"matchs",null,null,{"$f":"AI10*2","v":0},null,"points"]
[null,"2018-06-15","21:00:00",4,"Groupe B",1.42,3.9,7,"Portugal",null,null,"Espagne",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J11),ISBLANK(J11)),\"\",IF(AND('Pronostiqueur 1'!J11=RESULTATS!J11,'Pronostiqueur 1'!M11=RESULTATS!M11),3,IF(OR(AND('Pronostiqueur 1'!J11>'Pronostiqueur 1'!M11,RESULTATS!J11>RESULTATS!M11),AND('Pronostiqueur 1'!J11<'Pronostiqueur 1'!M11,RESULTATS!J11<RESULTATS!M11),AND('Pronostiqueur 1'!J11='Pronostiqueur 1'!M11,RESULTATS!J11=RESULTATS!M11)),1,0)))","v":""},null,null,null,{"$f":"AB11*1000+AA11*100+Y11*10","v":0},1,"Egypte",{"$f":"SUMPRODUCT((Teams1=T11)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T11)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T11)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T11)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T11)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T11)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T11)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T11)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T11)*(Teams1_Score))+SUMPRODUCT((Teams2=T11)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T11)*(Teams2_Score))+SUMPRODUCT((Teams2=T11)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-16","13:00:00",5,"Groupe C",1.7,3.1,5,"France",null,null,"Australie",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J12),ISBLANK(J12)),\"\",IF(AND('Pronostiqueur 1'!J12=RESULTATS!J12,'Pronostiqueur 1'!M12=RESULTATS!M12),3,IF(OR(AND('Pronostiqueur 1'!J12>'Pronostiqueur 1'!M12,RESULTATS!J12>RESULTATS!M12),AND('Pronostiqueur 1'!J12<'Pronostiqueur 1'!M12,RESULTATS!J12<RESULTATS!M12),AND('Pronostiqueur 1'!J12='Pronostiqueur 1'!M12,RESULTATS!J12=RESULTATS!M12)),1,0)))","v":""},null,null,null,{"$f":"AB12*1000+AA12*100+Y12*10","v":0},1,"Uruguay",{"$f":"SUMPRODUCT((Teams1=T12)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T12)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T12)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T12)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T12)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T12)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T12)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T12)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T12)*(Teams1_Score))+SUMPRODUCT((Teams2=T12)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T12)*(Teams2_Score))+SUMPRODUCT((Teams2=T12)*(Teams1_Score))","v":0},0,0,null,null,null,"Phases finales",null,null,null,null,null,null,{"$f":"SUM(AM13:AM17)","v":0},null,"points"]
[null,"2018-06-16","19:00:00",6,"Groupe C",2.5499999999999998,2.9,2.7,"Pérou",null,null,"Danemark",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J13),ISBLANK(J13)),\"\",IF(AND('Pronostiqueur 1'!J13=RESULTATS!J13,'Pronostiqueur 1'!M13=RESULTATS!M13),3,IF(OR(AND('Pronostiqueur 1'!J13>'Pronostiqueur 1'!M13,RESULTATS!J13>RESULTATS!M13),AND('Pronostiqueur 1'!J13<'Pronostiqueur 1'!M13,RESULTATS!J13<RESULTATS!M13),AND('Pronostiqueur 1'!J13='Pronostiqueur 1'!M13,RESULTATS!J13=RESULTATS!M13)),1,0)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Huitièmes de finaliste trouvés (2 pts)",null,null,{"$f":"$AJ$53+$AP$53","v":0},"équipe(s) ",null,null,{"$f":"AI13*2","v":0},null,"points"]
[null,"2018-06-16","16:00:00",7,"Groupe D",1.4,4,7.25,"Argentine",null,null,"Islande",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J14),ISBLANK(J14)),\"\",IF(AND('Pronostiqueur 1'!J14=RESULTATS!J14,'Pronostiqueur 1'!M14=RESULTATS!M14),3,IF(OR(AND('Pronostiqueur 1'!J14>'Pronostiqueur 1'!M14,RESULTATS!J14>RESULTATS!M14),AND('Pronostiqueur 1'!J14<'Pronostiqueur 1'!M14,RESULTATS!J14<RESULTATS!M14),AND('Pronostiqueur 1'!J14='Pronostiqueur 1'!M14,RESULTATS!J14=RESULTATS!M14)),1,0)))","v":""},null,null,null,null,"Rg","Groupe B","MJ","G","N","P","BP","BC","Pts","Pts",null,null,null,"Quarts de finalistes trouvés (4 pts)",null,null,{"$f":"$AJ$42+$AP$42","v":0},"équipe(s) ",null,null,{"$f":"AI14*4","v":0},null,"points"]
[null,"2018-06-16","21:00:00",8,"Groupe D",2.95,2.7,2.5499999999999998,"Croatie",null,null,"Nigeria",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J15),ISBLANK(J15)),\"\",IF(AND('Pronostiqueur 1'!J15=RESULTATS!J15,'Pronostiqueur 1'!M15=RESULTATS!M15),3,IF(OR(AND('Pronostiqueur 1'!J15>'Pronostiqueur 1'!M15,RESULTATS!J15>RESULTATS!M15),AND('Pronostiqueur 1'!J15<'Pronostiqueur 1'!M15,RESULTATS!J15<RESULTATS!M15),AND('Pronostiqueur 1'!J15='Pronostiqueur 1'!M15,RESULTATS!J15=RESULTATS!M15)),1,0)))","v":""},null,null,null,{"$f":"AB15*1000+AA15*100+Y15*10","v":0},{"$f":"RANK(R15,$R$15:$R$18,0)","v":1},"Maroc",{"$f":"SUMPRODUCT((Teams1=T15)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T15)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T15)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T15)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T15)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T15)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T15)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T15)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T15)*(Teams1_Score))+SUMPRODUCT((Teams2=T15)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T15)*(Teams2_Score))+SUMPRODUCT((Teams2=T15)*(Teams1_Score))","v":0},{"$f":"Y15-Z15","v":0},{"$f":"3*V15+W15","v":0},null,null,null,"Demi finalistes trouvés (5 pts)",null,null,{"$f":"$AJ$35+$AP$35","v":0},"équipe(s) ",null,null,{"$f":"AI15*5","v":0},null,"points"]
[null,"2018-06-17","16:00:00",9,"Groupe E",2.35,2.9,2.95,"Costa Rica",null,null,"Serbie",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J16),ISBLANK(J16)),\"\",IF(AND('Pronostiqueur 1'!J16=RESULTATS!J16,'Pronostiqueur 1'!M16=RESULTATS!M16),3,IF(OR(AND('Pronostiqueur 1'!J16>'Pronostiqueur 1'!M16,RESULTATS!J16>RESULTATS!M16),AND('Pronostiqueur 1'!J16<'Pronostiqueur 1'!M16,RESULTATS!J16<RESULTATS!M16),AND('Pronostiqueur 1'!J16='Pronostiqueur 1'!M16,RESULTATS!J16=RESULTATS!M16)),1,0)))","v":""},null,null,null,{"$f":"AB16*1000+AA16*100+Y16*10","v":0},{"$f":"RANK(R16,$R$15:$R$18,0)","v":1},"RI Iran",{"$f":"SUMPRODUCT((Teams1=T16)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T16)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T16)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T16)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T16)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T16)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T16)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T16)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T16)*(Teams1_Score))+SUMPRODUCT((Teams2=T16)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T16)*(Teams2_Score))+SUMPRODUCT((Teams2=T16)*(Teams1_Score))","v":0},0,0,null,null,null,"Finalistes trouvés (6 pts)",null,null,{"$f":"$AJ$25+$AP$25","v":0},"équipe(s) ",null,null,{"$f":"AI16*6","v":0},null,"points"]
[null,"2018-06-17","21:00:00",10,"Groupe E",1.28,4.7,9.5,"Brésil",null,null,"Suisse",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J17),ISBLANK(J17)),\"\",IF(AND('Pronostiqueur 1'!J17=RESULTATS!J17,'Pronostiqueur 1'!M17=RESULTATS!M17),3,IF(OR(AND('Pronostiqueur 1'!J17>'Pronostiqueur 1'!M17,RESULTATS!J17>RESULTATS!M17),AND('Pronostiqueur 1'!J17<'Pronostiqueur 1'!M17,RESULTATS!J17<RESULTATS!M17),AND('Pronostiqueur 1'!J17='Pronostiqueur 1'!M17,RESULTATS!J17=RESULTATS!M17)),1,0)))","v":""},null,null,null,{"$f":"AB17*1000+AA17*100+Y17*10","v":0},1,"Portugal",{"$f":"SUMPRODUCT((Teams1=T17)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T17)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T17)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T17)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T17)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T17)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T17)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T17)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T17)*(Teams1_Score))+SUMPRODUCT((Teams2=T17)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T17)*(Teams2_Score))+SUMPRODUCT((Teams2=T17)*(Teams1_Score))","v":0},0,0,null,null,null,"Champion du monde trouvé (7 pts)",null,null,{"$f":"IF(AI25<>\"\",IF($AS$25=RESULTATS!AR10,1,0),0)","v":0},"équipe",null,null,{"$f":"AI17*7","v":0},null,"points"]
[null,"2018-06-17","18:00:00",11,"Groupe F",1.34,4.3,7.5,"Allemagne",null,null,"Mexique",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J18),ISBLANK(J18)),\"\",IF(AND('Pronostiqueur 1'!J18=RESULTATS!J18,'Pronostiqueur 1'!M18=RESULTATS!M18),3,IF(OR(AND('Pronostiqueur 1'!J18>'Pronostiqueur 1'!M18,RESULTATS!J18>RESULTATS!M18),AND('Pronostiqueur 1'!J18<'Pronostiqueur 1'!M18,RESULTATS!J18<RESULTATS!M18),AND('Pronostiqueur 1'!J18='Pronostiqueur 1'!M18,RESULTATS!J18=RESULTATS!M18)),1,0)))","v":""},null,null,null,{"$f":"AB18*1000+AA18*100+Y18*10","v":0},1,"Espagne",{"$f":"SUMPRODUCT((Teams1=T18)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T18)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T18)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T18)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T18)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T18)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T18)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T18)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T18)*(Teams1_Score))+SUMPRODUCT((Teams2=T18)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T18)*(Teams2_Score))+SUMPRODUCT((Teams2=T18)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-18","15:00:00",12,"Groupe F",3.3,2.95,2.15,"Suède",null,null,"République de Corée",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J19),ISBLANK(J19)),\"\",IF(AND('Pronostiqueur 1'!J19=RESULTATS!J19,'Pronostiqueur 1'!M19=RESULTATS!M19),3,IF(OR(AND('Pronostiqueur 1'!J19>'Pronostiqueur 1'!M19,RESULTATS!J19>RESULTATS!M19),AND('Pronostiqueur 1'!J19<'Pronostiqueur 1'!M19,RESULTATS!J19<RESULTATS!M19),AND('Pronostiqueur 1'!J19='Pronostiqueur 1'!M19,RESULTATS!J19=RESULTATS!M19)),1,0)))","v":""}]
[null,"2018-06-18","18:00:00",13,"Groupe G",1.95,2.95,4,"Belgique",null,null,"Panama",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J20),ISBLANK(J20)),\"\",IF(AND('Pronostiqueur 1'!J20=RESULTATS!J20,'Pronostiqueur 1'!M20=RESULTATS!M20),3,IF(OR(AND('Pronostiqueur 1'!J20>'Pronostiqueur 1'!M20,RESULTATS!J20>RESULTATS!M20),AND('Pronostiqueur 1'!J20<'Pronostiqueur 1'!M20,RESULTATS!J20<RESULTATS!M20),AND('Pronostiqueur 1'!J20='Pronostiqueur 1'!M20,RESULTATS!J20=RESULTATS!M20)),1,0)))","v":""},null,null,null,null,"Rg","Groupe C","MJ","G","N","P","BP","BC","Pts","Pts"]
[null,"2018-06-18","21:00:00",14,"Groupe G",2.5499999999999998,2.9,2.7,"Tunisie",null,null,"Angleterre",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J21),ISBLANK(J21)),\"\",IF(AND('Pronostiqueur 1'!J21=RESULTATS!J21,'Pronostiqueur 1'!M21=RESULTATS!M21),3,IF(OR(AND('Pronostiqueur 1'!J21>'Pronostiqueur 1'!M21,RESULTATS!J21>RESULTATS!M21),AND('Pronostiqueur 1'!J21<'Pronostiqueur 1'!M21,RESULTATS!J21<RESULTATS!M21),AND('Pronostiqueur 1'!J21='Pronostiqueur 1'!M21,RESULTATS!J21=RESULTATS!M21)),1,0)))","v":""},null,null,null,{"$f":"AB21*1000+AA21*100+Y21*10","v":0},{"$f":"RANK(R21,$R$21:$R$24,0)","v":1},"France",{"$f":"SUMPRODUCT((Teams1=T21)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T21)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T21)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T21)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T21)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T21)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T21)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T21)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T21)*(Teams1_Score))+SUMPRODUCT((Teams2=T21)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T21)*(Teams2_Score))+SUMPRODUCT((Teams2=T21)*(Teams1_Score))","v":0},{"$f":"Y21-Z21","v":0},{"$f":"3*V21+W21","v":0},null,null,null,"PHASES FINALES"]
[null,"2018-06-19","15:00:00",15,"Groupe H",1.38,3.9,8,"Colombie",null,null,"Japon",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J22),ISBLANK(J22)),\"\",IF(AND('Pronostiqueur 1'!J22=RESULTATS!J22,'Pronostiqueur 1'!M22=RESULTATS!M22),3,IF(OR(AND('Pronostiqueur 1'!J22>'Pronostiqueur 1'!M22,RESULTATS!J22>RESULTATS!M22),AND('Pronostiqueur 1'!J22<'Pronostiqueur 1'!M22,RESULTATS!J22<RESULTATS!M22),AND('Pronostiqueur 1'!J22='Pronostiqueur 1'!M22,RESULTATS!J22=RESULTATS!M22)),1,0)))","v":""},null,null,null,{"$f":"AB22*1000+AA22*100+Y22*10","v":0},{"$f":"RANK(R22,$R$21:$R$24,0)","v":1},"Australie",{"$f":"SUMPRODUCT((Teams1=T22)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T22)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T22)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T22)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T22)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T22)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T22)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T22)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T22)*(Teams1_Score))+SUMPRODUCT((Teams2=T22)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T22)*(Teams2_Score))+SUMPRODUCT((Teams2=T22)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-19","18:00:00",16,"Groupe H",2.0499999999999998,2.9,3.5,"Pologne",null,null,"Sénégal",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J23),ISBLANK(J23)),\"\",IF(AND('Pronostiqueur 1'!J23=RESULTATS!J23,'Pronostiqueur 1'!M23=RESULTATS!M23),3,IF(OR(AND('Pronostiqueur 1'!J23>'Pronostiqueur 1'!M23,RESULTATS!J23>RESULTATS!M23),AND('Pronostiqueur 1'!J23<'Pronostiqueur 1'!M23,RESULTATS!J23<RESULTATS!M23),AND('Pronostiqueur 1'!J23='Pronostiqueur 1'!M23,RESULTATS!J23=RESULTATS!M23)),1,0)))","v":""},null,null,null,{"$f":"AB23*1000+AA23*100+Y23*10","v":0},1,"Pérou",{"$f":"SUMPRODUCT((Teams1=T23)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T23)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T23)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T23)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T23)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T23)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T23)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T23)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T23)*(Teams1_Score))+SUMPRODUCT((Teams2=T23)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T23)*(Teams2_Score))+SUMPRODUCT((Teams2=T23)*(Teams1_Score))","v":0},0,0,null,null,"Date","Finale",null,null,"Buts",null,"Pen",null,null,null,"Buts",null,"Pen"]
[null,"2018-06-19","21:00:00",17,"Groupe A",1.26,4.8,9,"Russie",null,null,"Egypte",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J24),ISBLANK(J24)),\"\",IF(AND('Pronostiqueur 1'!J24=RESULTATS!J24,'Pronostiqueur 1'!M24=RESULTATS!M24),3,IF(OR(AND('Pronostiqueur 1'!J24>'Pronostiqueur 1'!M24,RESULTATS!J24>RESULTATS!M24),AND('Pronostiqueur 1'!J24<'Pronostiqueur 1'!M24,RESULTATS!J24<RESULTATS!M24),AND('Pronostiqueur 1'!J24='Pronostiqueur 1'!M24,RESULTATS!J24=RESULTATS!M24)),1,0)))","v":""},null,null,null,{"$f":"AB24*1000+AA24*100+Y24*10","v":0},1,"Danemark",{"$f":"SUMPRODUCT((Teams1=T24)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T24)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T24)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T24)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T24)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T24)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T24)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T24)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T24)*(Teams1_Score))+SUMPRODUCT((Teams2=T24)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T24)*(Teams2_Score))+SUMPRODUCT((Teams2=T24)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-20","18:00:00",18,"Groupe A",3.5,3,2,"Uruguay",null,null,"Arabie Saoudite",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J25),ISBLANK(J25)),\"\",IF(AND('Pronostiqueur 1'!J25=RESULTATS!J25,'Pronostiqueur 1'!M25=RESULTATS!M25),3,IF(OR(AND('Pronostiqueur 1'!J25>'Pronostiqueur 1'!M25,RESULTATS!J25>RESULTATS!M25),AND('Pronostiqueur 1'!J25<'Pronostiqueur 1'!M25,RESULTATS!J25<RESULTATS!M25),AND('Pronostiqueur 1'!J25='Pronostiqueur 1'!M25,RESULTATS!J25=RESULTATS!M25)),1,0)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-15",null,{"$f":"+IF(AI33<>\"\",IF(AH33>AN33,AG33,AM33),\"Vainqueur 1\")","v":"Vainqueur 1"},{"$f":"AI25*10+AK25","v":0},null,{"$f":"IF(LEFT(AG25,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$10:$AL$10,AG25),0)","v":0},null,null,{"$f":"+IF(AI34<>\"\",IF(AH34>AN34,AG34,AM34),\"Vainqueur 2\")","v":"Vainqueur 2"},{"$f":"AO25*10+AQ25","v":0},null,{"$f":"IF(LEFT(AM25,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$10:$AL$10,AM25),0)","v":0},null,null,{"$f":"IF(AI25<>\"\",IF(AH25>AN25,AG25,AM25),\"\")","v":""}]
[null,"2018-06-20","15:00:00",19,"Groupe B",1.66,3.35,4.8,"Portugal",null,null,"Maroc",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J26),ISBLANK(J26)),\"\",IF(AND('Pronostiqueur 1'!J26=RESULTATS!J26,'Pronostiqueur 1'!M26=RESULTATS!M26),3,IF(OR(AND('Pronostiqueur 1'!J26>'Pronostiqueur 1'!M26,RESULTATS!J26>RESULTATS!M26),AND('Pronostiqueur 1'!J26<'Pronostiqueur 1'!M26,RESULTATS!J26<RESULTATS!M26),AND('Pronostiqueur 1'!J26='Pronostiqueur 1'!M26,RESULTATS!J26=RESULTATS!M26)),1,0)))","v":""},null,null,null,null,"Rg","Groupe D","MJ","G","N","P","BP","BC","Pts","Pts"]
[null,"2018-06-20","21:00:00",20,"Groupe B",8.5,4.7,1.28,"RI Iran",null,null,"Espagne",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J27),ISBLANK(J27)),\"\",IF(AND('Pronostiqueur 1'!J27=RESULTATS!J27,'Pronostiqueur 1'!M27=RESULTATS!M27),3,IF(OR(AND('Pronostiqueur 1'!J27>'Pronostiqueur 1'!M27,RESULTATS!J27>RESULTATS!M27),AND('Pronostiqueur 1'!J27<'Pronostiqueur 1'!M27,RESULTATS!J27<RESULTATS!M27),AND('Pronostiqueur 1'!J27='Pronostiqueur 1'!M27,RESULTATS!J27=RESULTATS!M27)),1,0)))","v":""},null,null,null,{"$f":"AB27*1000+AA27*100+Y27*10","v":0},{"$f":"RANK(R27,$R$27:$R$30,0)","v":1},"Argentine",{"$f":"SUMPRODUCT((Teams1=T27)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T27)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T27)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T27)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T27)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T27)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T27)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T27)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T27)*(Teams1_Score))+SUMPRODUCT((Teams2=T27)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T27)*(Teams2_Score))+SUMPRODUCT((Teams2=T27)*(Teams1_Score))","v":0},{"$f":"Y27-Z27","v":0},{"$f":"3*V27+W27","v":0},null,null,"Date","Petite Finale",null,null,"Buts",null,"Pen",null,null,null,"Buts",null,"Pen"]
[null,"2018-06-21","16:00:00",21,"Groupe C",1.85,3,4,"Danemark",null,null,"Australie",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J28),ISBLANK(J28)),\"\",IF(AND('Pronostiqueur 1'!J28=RESULTATS!J28,'Pronostiqueur 1'!M28=RESULTATS!M28),3,IF(OR(AND('Pronostiqueur 1'!J28>'Pronostiqueur 1'!M28,RESULTATS!J28>RESULTATS!M28),AND('Pronostiqueur 1'!J28<'Pronostiqueur 1'!M28,RESULTATS!J28<RESULTATS!M28),AND('Pronostiqueur 1'!J28='Pronostiqueur 1'!M28,RESULTATS!J28=RESULTATS!M28)),1,0)))","v":""},null,null,null,{"$f":"AB28*1000+AA28*100+Y28*10","v":0},{"$f":"RANK(R28,$R$27:$R$30,0)","v":1},"Islande",{"$f":"SUMPRODUCT((Teams1=T28)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T28)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T28)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T28)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T28)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T28)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T28)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T28)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T28)*(Teams1_Score))+SUMPRODUCT((Teams2=T28)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T28)*(Teams2_Score))+SUMPRODUCT((Teams2=T28)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-21","20:00:00",22,"Groupe C",2.2999999999999998,3,2.9,"France",null,null,"Pérou",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J29),ISBLANK(J29)),\"\",IF(AND('Pronostiqueur 1'!J29=RESULTATS!J29,'Pronostiqueur 1'!M29=RESULTATS!M29),3,IF(OR(AND('Pronostiqueur 1'!J29>'Pronostiqueur 1'!M29,RESULTATS!J29>RESULTATS!M29),AND('Pronostiqueur 1'!J29<'Pronostiqueur 1'!M29,RESULTATS!J29<RESULTATS!M29),AND('Pronostiqueur 1'!J29='Pronostiqueur 1'!M29,RESULTATS!J29=RESULTATS!M29)),1,0)))","v":""},null,null,null,{"$f":"AB29*1000+AA29*100+Y29*10","v":0},1,"Croatie",{"$f":"SUMPRODUCT((Teams1=T29)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T29)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T29)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T29)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T29)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T29)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T29)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T29)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T29)*(Teams1_Score))+SUMPRODUCT((Teams2=T29)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T29)*(Teams2_Score))+SUMPRODUCT((Teams2=T29)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-14",null,{"$f":"+IF(AI33<>\"\",IF(AH33>AN33,AM33,AG33),\"Perdant 1\")","v":"Perdant 1"},{"$f":"AI29*10+AK29","v":0},null,null,null,null,{"$f":"+IF(AI34<>\"\",IF(AH34>AN34,AM34,AG34),\"Perdant 2\")","v":"Perdant 2"},{"$f":"AO29*10+AQ29","v":0}]
[null,"2018-06-21","21:00:00",23,"Groupe D",2.4,3,2.8,"Argentine",null,null,"Croatie",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J30),ISBLANK(J30)),\"\",IF(AND('Pronostiqueur 1'!J30=RESULTATS!J30,'Pronostiqueur 1'!M30=RESULTATS!M30),3,IF(OR(AND('Pronostiqueur 1'!J30>'Pronostiqueur 1'!M30,RESULTATS!J30>RESULTATS!M30),AND('Pronostiqueur 1'!J30<'Pronostiqueur 1'!M30,RESULTATS!J30<RESULTATS!M30),AND('Pronostiqueur 1'!J30='Pronostiqueur 1'!M30,RESULTATS!J30=RESULTATS!M30)),1,0)))","v":""},null,null,null,{"$f":"AB30*1000+AA30*100+Y30*10","v":0},1,"Nigeria",{"$f":"SUMPRODUCT((Teams1=T30)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T30)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T30)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T30)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T30)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T30)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T30)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T30)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T30)*(Teams1_Score))+SUMPRODUCT((Teams2=T30)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T30)*(Teams2_Score))+SUMPRODUCT((Teams2=T30)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-22","18:00:00",24,"Groupe D",1.26,4.5999999999999996,9.5,"Nigeria",null,null,"Islande",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J31),ISBLANK(J31)),\"\",IF(AND('Pronostiqueur 1'!J31=RESULTATS!J31,'Pronostiqueur 1'!M31=RESULTATS!M31),3,IF(OR(AND('Pronostiqueur 1'!J31>'Pronostiqueur 1'!M31,RESULTATS!J31>RESULTATS!M31),AND('Pronostiqueur 1'!J31<'Pronostiqueur 1'!M31,RESULTATS!J31<RESULTATS!M31),AND('Pronostiqueur 1'!J31='Pronostiqueur 1'!M31,RESULTATS!J31=RESULTATS!M31)),1,0)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","Demi Finale",null,null,"Buts",null,"Pen",null,null,null,"Buts",null,"Pen"]
[null,"2018-06-22","15:00:00",25,"Groupe E",3.5,2.95,2.1,"Brésil",null,null,"Costa Rica",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J32),ISBLANK(J32)),\"\",IF(AND('Pronostiqueur 1'!J32=RESULTATS!J32,'Pronostiqueur 1'!M32=RESULTATS!M32),3,IF(OR(AND('Pronostiqueur 1'!J32>'Pronostiqueur 1'!M32,RESULTATS!J32>RESULTATS!M32),AND('Pronostiqueur 1'!J32<'Pronostiqueur 1'!M32,RESULTATS!J32<RESULTATS!M32),AND('Pronostiqueur 1'!J32='Pronostiqueur 1'!M32,RESULTATS!J32=RESULTATS!M32)),1,0)))","v":""},null,null,null,null,"Rg","Groupe E","MJ","G","N","P","BP","BC","Pts","Pts"]
[null,"2018-06-22","20:00:00",26,"Groupe E",4.8,3.25,1.62,"Serbie",null,null,"Suisse",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J33),ISBLANK(J33)),\"\",IF(AND('Pronostiqueur 1'!J33=RESULTATS!J33,'Pronostiqueur 1'!M33=RESULTATS!M33),3,IF(OR(AND('Pronostiqueur 1'!J33>'Pronostiqueur 1'!M33,RESULTATS!J33>RESULTATS!M33),AND('Pronostiqueur 1'!J33<'Pronostiqueur 1'!M33,RESULTATS!J33<RESULTATS!M33),AND('Pronostiqueur 1'!J33='Pronostiqueur 1'!M33,RESULTATS!J33=RESULTATS!M33)),1,0)))","v":""},null,null,null,{"$f":"AB33*1000+AA33*100+Y33*10","v":0},{"$f":"RANK(R33,$R$33:$R$36,0)","v":1},"Costa Rica",{"$f":"SUMPRODUCT((Teams1=T33)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T33)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T33)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T33)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T33)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T33)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T33)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T33)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T33)*(Teams1_Score))+SUMPRODUCT((Teams2=T33)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T33)*(Teams2_Score))+SUMPRODUCT((Teams2=T33)*(Teams1_Score))","v":0},{"$f":"Y33-Z33","v":0},{"$f":"3*V33+W33","v":0},null,null,"2018-07-10",1,{"$f":"+IF(AI38<>\"\",IF(AH38>AN38,AG38,AM38),\"Vainqueur A\")","v":"Vainqueur A"},{"$f":"AI33*10+AK33","v":0},null,{"$f":"IF(LEFT(AG33,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$18:$AL$19,AG33),0)","v":0},null,null,{"$f":"+IF(AI40<>\"\",IF(AH40>AN40,AG40,AM40),\"Vainqueur C\")","v":"Vainqueur C"},{"$f":"AO33*10+AQ33","v":0},null,{"$f":"IF(LEFT(AM33,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$18:$AL$19,AM33),0)","v":0}]
[null,"2018-06-23","18:00:00",27,"Groupe F",1.1200000000000001,6.5,15,"République de Corée",null,null,"Mexique",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J34),ISBLANK(J34)),\"\",IF(AND('Pronostiqueur 1'!J34=RESULTATS!J34,'Pronostiqueur 1'!M34=RESULTATS!M34),3,IF(OR(AND('Pronostiqueur 1'!J34>'Pronostiqueur 1'!M34,RESULTATS!J34>RESULTATS!M34),AND('Pronostiqueur 1'!J34<'Pronostiqueur 1'!M34,RESULTATS!J34<RESULTATS!M34),AND('Pronostiqueur 1'!J34='Pronostiqueur 1'!M34,RESULTATS!J34=RESULTATS!M34)),1,0)))","v":""},null,null,null,{"$f":"AB34*1000+AA34*100+Y34*10","v":0},{"$f":"RANK(R34,$R$33:$R$36,0)","v":1},"Serbie",{"$f":"SUMPRODUCT((Teams1=T34)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T34)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T34)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T34)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T34)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T34)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T34)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T34)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T34)*(Teams1_Score))+SUMPRODUCT((Teams2=T34)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T34)*(Teams2_Score))+SUMPRODUCT((Teams2=T34)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-11",2,{"$f":"+IF(AI39<>\"\",IF(AH39>AN39,AG39,AM39),\"Vainqueur B\")","v":"Vainqueur B"},0,null,{"$f":"IF(LEFT(AG34,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$18:$AL$19,AG34),0)","v":0},null,null,{"$f":"+IF(AI41<>\"\",IF(AH41>AN41,AG41,AM41),\"Vainqueur D\")","v":"Vainqueur D"},0,null,{"$f":"IF(LEFT(AM34,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$18:$AL$19,AM34),0)","v":0}]
[null,"2018-06-23","21:00:00",28,"Groupe F",2.8,2.95,2.4,"Allemagne",null,null,"Suède",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J35),ISBLANK(J35)),\"\",IF(AND('Pronostiqueur 1'!J35=RESULTATS!J35,'Pronostiqueur 1'!M35=RESULTATS!M35),3,IF(OR(AND('Pronostiqueur 1'!J35>'Pronostiqueur 1'!M35,RESULTATS!J35>RESULTATS!M35),AND('Pronostiqueur 1'!J35<'Pronostiqueur 1'!M35,RESULTATS!J35<RESULTATS!M35),AND('Pronostiqueur 1'!J35='Pronostiqueur 1'!M35,RESULTATS!J35=RESULTATS!M35)),1,0)))","v":""},null,null,null,{"$f":"AB35*1000+AA35*100+Y35*10","v":0},1,"Brésil",{"$f":"SUMPRODUCT((Teams1=T35)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T35)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T35)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T35)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T35)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T35)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T35)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T35)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T35)*(Teams1_Score))+SUMPRODUCT((Teams2=T35)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T35)*(Teams2_Score))+SUMPRODUCT((Teams2=T35)*(Teams1_Score))","v":0},0,0,null,null,null,null,null,null,null,{"$f":"SUM(AJ33:AJ34)","v":0},null,null,null,null,null,{"$f":"SUM(AP33:AP34)","v":0}]
[null,"2018-06-23","15:00:00",29,"Groupe G",1.36,4,7.5,"Belgique",null,null,"Tunisie",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J36),ISBLANK(J36)),\"\",IF(AND('Pronostiqueur 1'!J36=RESULTATS!J36,'Pronostiqueur 1'!M36=RESULTATS!M36),3,IF(OR(AND('Pronostiqueur 1'!J36>'Pronostiqueur 1'!M36,RESULTATS!J36>RESULTATS!M36),AND('Pronostiqueur 1'!J36<'Pronostiqueur 1'!M36,RESULTATS!J36<RESULTATS!M36),AND('Pronostiqueur 1'!J36='Pronostiqueur 1'!M36,RESULTATS!J36=RESULTATS!M36)),1,0)))","v":""},null,null,null,{"$f":"AB36*1000+AA36*100+Y36*10","v":0},1,"Suisse",{"$f":"SUMPRODUCT((Teams1=T36)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T36)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T36)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T36)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T36)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T36)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T36)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T36)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T36)*(Teams1_Score))+SUMPRODUCT((Teams2=T36)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T36)*(Teams2_Score))+SUMPRODUCT((Teams2=T36)*(Teams1_Score))","v":0},0,0,null,null,"Date","Quart de Finale",null,null,"Buts",null,"Pen",null,null,null,"Buts",null,"Pen"]
[null,"2018-06-24","15:00:00",30,"Groupe G",4.7,3.4,1.62,"Angleterre",null,null,"Panama",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J37),ISBLANK(J37)),\"\",IF(AND('Pronostiqueur 1'!J37=RESULTATS!J37,'Pronostiqueur 1'!M37=RESULTATS!M37),3,IF(OR(AND('Pronostiqueur 1'!J37>'Pronostiqueur 1'!M37,RESULTATS!J37>RESULTATS!M37),AND('Pronostiqueur 1'!J37<'Pronostiqueur 1'!M37,RESULTATS!J37<RESULTATS!M37),AND('Pronostiqueur 1'!J37='Pronostiqueur 1'!M37,RESULTATS!J37=RESULTATS!M37)),1,0)))","v":""}]
[null,"2018-06-24","20:00:00",31,"Groupe H",2.1,2.95,3.35,"Japon",null,null,"Sénégal",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J38),ISBLANK(J38)),\"\",IF(AND('Pronostiqueur 1'!J38=RESULTATS!J38,'Pronostiqueur 1'!M38=RESULTATS!M38),3,IF(OR(AND('Pronostiqueur 1'!J38>'Pronostiqueur 1'!M38,RESULTATS!J38>RESULTATS!M38),AND('Pronostiqueur 1'!J38<'Pronostiqueur 1'!M38,RESULTATS!J38<RESULTATS!M38),AND('Pronostiqueur 1'!J38='Pronostiqueur 1'!M38,RESULTATS!J38=RESULTATS!M38)),1,0)))","v":""},null,null,null,null,"Rg","Groupe F","MJ","G","N","P","BP","BC","Pts","Pts",null,null,"2018-07-06","A",{"$f":"+IF(AI45<>\"\",IF(AH45>AN45,AG45,AM45),\"Vainqueur 1\")","v":"Vainqueur 1"},{"$f":"AI38*10+AK38","v":0},null,{"$f":"IF(LEFT(AG38,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$23:$AL$26,AG38),0)","v":0},null,null,{"$f":"+IF(AI47<>\"\",IF(AH47>AN47,AG47,AM47),\"Vainqueur 3\")","v":"Vainqueur 3"},{"$f":"AO38*10+AQ38","v":0},null,{"$f":"IF(LEFT(AM38,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$23:$AL$26,AM38),0)","v":0}]
[null,"2018-06-24","21:00:00",32,"Groupe H",1.9,3,3.8,"Pologne",null,null,"Colombie",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J39),ISBLANK(J39)),\"\",IF(AND('Pronostiqueur 1'!J39=RESULTATS!J39,'Pronostiqueur 1'!M39=RESULTATS!M39),3,IF(OR(AND('Pronostiqueur 1'!J39>'Pronostiqueur 1'!M39,RESULTATS!J39>RESULTATS!M39),AND('Pronostiqueur 1'!J39<'Pronostiqueur 1'!M39,RESULTATS!J39<RESULTATS!M39),AND('Pronostiqueur 1'!J39='Pronostiqueur 1'!M39,RESULTATS!J39=RESULTATS!M39)),1,0)))","v":""},null,null,null,{"$f":"AB39*1000+AA39*100+Y39*10","v":0},{"$f":"RANK(R39,$R$39:$R$42,0)","v":1},"Allemagne",{"$f":"SUMPRODUCT((Teams1=T39)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T39)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T39)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T39)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T39)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T39)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T39)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T39)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T39)*(Teams1_Score))+SUMPRODUCT((Teams2=T39)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T39)*(Teams2_Score))+SUMPRODUCT((Teams2=T39)*(Teams1_Score))","v":0},{"$f":"Y39-Z39","v":0},{"$f":"3*V39+W39","v":0},null,null,"2018-07-07","B",{"$f":"+IF(AI46<>\"\",IF(AH46>AN46,AG46,AM46),\"Vainqueur 2\")","v":"Vainqueur 2"},0,null,{"$f":"IF(LEFT(AG39,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$23:$AL$26,AG39),0)","v":0},null,null,{"$f":"+IF(AI48<>\"\",IF(AH48>AN48,AG48,AM48),\"Vainqueur 4\")","v":"Vainqueur 4"},0,null,{"$f":"IF(LEFT(AM39,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$23:$AL$26,AM39),0)","v":0}]
[null,"2018-06-25","18:00:00",33,"Groupe A",11,6.5,1.17,"Uruguay",null,null,"Russie",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J40),ISBLANK(J40)),\"\",IF(AND('Pronostiqueur 1'!J40=RESULTATS!J40,'Pronostiqueur 1'!M40=RESULTATS!M40),3,IF(OR(AND('Pronostiqueur 1'!J40>'Pronostiqueur 1'!M40,RESULTATS!J40>RESULTATS!M40),AND('Pronostiqueur 1'!J40<'Pronostiqueur 1'!M40,RESULTATS!J40<RESULTATS!M40),AND('Pronostiqueur 1'!J40='Pronostiqueur 1'!M40,RESULTATS!J40=RESULTATS!M40)),1,0)))","v":""},null,null,null,{"$f":"AB40*1000+AA40*100+Y40*10","v":0},{"$f":"RANK(R40,$R$39:$R$42,0)","v":1},"Mexique",{"$f":"SUMPRODUCT((Teams1=T40)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T40)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T40)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T40)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T40)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T40)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T40)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T40)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T40)*(Teams1_Score))+SUMPRODUCT((Teams2=T40)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T40)*(Teams2_Score))+SUMPRODUCT((Teams2=T40)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-06","C",{"$f":"+IF(AI49<>\"\",IF(AH49>AN49,AG49,AM49),\"Vainqueur 5\")","v":"Vainqueur 5"},0,null,{"$f":"IF(LEFT(AG40,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$23:$AL$26,AG40),0)","v":0},null,null,{"$f":"+IF(AI51<>\"\",IF(AH51>AN51,AG51,AM51),\"Vainqueur 7\")","v":"Vainqueur 7"},0,null,{"$f":"IF(LEFT(AM40,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$23:$AL$26,AM40),0)","v":0}]
[null,"2018-06-25","17:00:00",34,"Groupe A",2.4,2.95,2.75,"Arabie Saoudite",null,null,"Egypte",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J41),ISBLANK(J41)),\"\",IF(AND('Pronostiqueur 1'!J41=RESULTATS!J41,'Pronostiqueur 1'!M41=RESULTATS!M41),3,IF(OR(AND('Pronostiqueur 1'!J41>'Pronostiqueur 1'!M41,RESULTATS!J41>RESULTATS!M41),AND('Pronostiqueur 1'!J41<'Pronostiqueur 1'!M41,RESULTATS!J41<RESULTATS!M41),AND('Pronostiqueur 1'!J41='Pronostiqueur 1'!M41,RESULTATS!J41=RESULTATS!M41)),1,0)))","v":""},null,null,null,{"$f":"AB41*1000+AA41*100+Y41*10","v":0},1,"Suède",{"$f":"SUMPRODUCT((Teams1=T41)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T41)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T41)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T41)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T41)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T41)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T41)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T41)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T41)*(Teams1_Score))+SUMPRODUCT((Teams2=T41)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T41)*(Teams2_Score))+SUMPRODUCT((Teams2=T41)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-07","D",{"$f":"+IF(AI50<>\"\",IF(AH50>AN50,AG50,AM50),\"Vainqueur 6\")","v":"Vainqueur 6"},0,null,{"$f":"IF(LEFT(AG41,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$23:$AL$26,AG41),0)","v":0},null,null,{"$f":"+IF(AI52<>\"\",IF(AH52>AN52,AG52,AM52),\"Vainqueur 8\")","v":"Vainqueur 8"},0,null,{"$f":"IF(LEFT(AM41,5)<>\"Vainq\",COUNTIF(RESULTATS!$AF$23:$AL$26,AM41),0)","v":0}]
[null,"2018-06-25","21:00:00",35,"Groupe B",13,6.5,1.1399999999999999,"RI Iran",null,null,"Portugal",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J42),ISBLANK(J42)),\"\",IF(AND('Pronostiqueur 1'!J42=RESULTATS!J42,'Pronostiqueur 1'!M42=RESULTATS!M42),3,IF(OR(AND('Pronostiqueur 1'!J42>'Pronostiqueur 1'!M42,RESULTATS!J42>RESULTATS!M42),AND('Pronostiqueur 1'!J42<'Pronostiqueur 1'!M42,RESULTATS!J42<RESULTATS!M42),AND('Pronostiqueur 1'!J42='Pronostiqueur 1'!M42,RESULTATS!J42=RESULTATS!M42)),1,0)))","v":""},null,null,null,{"$f":"AB42*1000+AA42*100+Y42*10","v":0},1,"République de Corée",{"$f":"SUMPRODUCT((Teams1=T42)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T42)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T42)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T42)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T42)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T42)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T42)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T42)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T42)*(Teams1_Score))+SUMPRODUCT((Teams2=T42)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T42)*(Teams2_Score))+SUMPRODUCT((Teams2=T42)*(Teams1_Score))","v":0},0,0,null,null,null,null,null,null,null,{"$f":"SUM(AJ38:AJ41)","v":0},null,null,null,null,null,{"$f":"SUM(AP38:AP41)","v":0}]
[null,"2018-06-25","20:00:00",36,"Groupe B",2.25,3.1,2.95,"Espagne",null,null,"Maroc",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J43),ISBLANK(J43)),\"\",IF(AND('Pronostiqueur 1'!J43=RESULTATS!J43,'Pronostiqueur 1'!M43=RESULTATS!M43),3,IF(OR(AND('Pronostiqueur 1'!J43>'Pronostiqueur 1'!M43,RESULTATS!J43>RESULTATS!M43),AND('Pronostiqueur 1'!J43<'Pronostiqueur 1'!M43,RESULTATS!J43<RESULTATS!M43),AND('Pronostiqueur 1'!J43='Pronostiqueur 1'!M43,RESULTATS!J43=RESULTATS!M43)),1,0)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","Huitième de Finale",null,null,"Buts",null,"Pen",null,null,null,"Buts",null,"Pen"]
[null,"2018-06-26","17:00:00",37,"Groupe C",4.3,3.25,1.76,"Danemark",null,null,"France",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J44),ISBLANK(J44)),\"\",IF(AND('Pronostiqueur 1'!J44=RESULTATS!J44,'Pronostiqueur 1'!M44=RESULTATS!M44),3,IF(OR(AND('Pronostiqueur 1'!J44>'Pronostiqueur 1'!M44,RESULTATS!J44>RESULTATS!M44),AND('Pronostiqueur 1'!J44<'Pronostiqueur 1'!M44,RESULTATS!J44<RESULTATS!M44),AND('Pronostiqueur 1'!J44='Pronostiqueur 1'!M44,RESULTATS!J44=RESULTATS!M44)),1,0)))","v":""},null,null,null,null,"Rg","Groupe G","MJ","G","N","P","BP","BC","Pts","Pts"]
[null,"2018-06-26","17:00:00",38,"Groupe C",3.05,3,2.25,"Australie",null,null,"Pérou",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J45),ISBLANK(J45)),\"\",IF(AND('Pronostiqueur 1'!J45=RESULTATS!J45,'Pronostiqueur 1'!M45=RESULTATS!M45),3,IF(OR(AND('Pronostiqueur 1'!J45>'Pronostiqueur 1'!M45,RESULTATS!J45>RESULTATS!M45),AND('Pronostiqueur 1'!J45<'Pronostiqueur 1'!M45,RESULTATS!J45<RESULTATS!M45),AND('Pronostiqueur 1'!J45='Pronostiqueur 1'!M45,RESULTATS!J45=RESULTATS!M45)),1,0)))","v":""},null,null,null,{"$f":"AB45*1000+AA45*100+Y45*10","v":0},{"$f":"RANK(R45,$R$45:$R$48,0)","v":1},"Belgique",{"$f":"SUMPRODUCT((Teams1=T45)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T45)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T45)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T45)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T45)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T45)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T45)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T45)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T45)*(Teams1_Score))+SUMPRODUCT((Teams2=T45)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T45)*(Teams2_Score))+SUMPRODUCT((Teams2=T45)*(Teams1_Score))","v":0},{"$f":"Y45-Z45","v":0},{"$f":"3*V45+W45","v":0},null,null,"2018-06-30",1,{"$f":"IF(SUM(U9:U12)=0,\"1er Groupe A\",IF(COUNTIF(S9:S12,1)=1,VLOOKUP(1,S9:T12,2,FALSE),IF(COUNTIF(S9:S12,1)>=2,\"Tirage au Sort A1\")))","v":"1er Groupe A"},{"$f":"AI45*10+AK45","v":0},null,{"$f":"IF(AND(LEFT(AG45,3)<>\"1er\",LEFT(AG45,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AG45),0)","v":0},null,null,{"$f":"IF(SUM(U15:U18)=0,\"2nd Groupe B\",IF(OR(COUNTIF(S15:S18,1)>1,COUNTIF(S15:S18,2)>1),\"Tirage au sort B2\",VLOOKUP(2,S15:T18,2,FALSE)))","v":"2nd Groupe B"},{"$f":"AO45*10+AQ45","v":0},null,{"$f":"IF(AND(LEFT(AM45,3)<>\"1er\",LEFT(AM45,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AM45),0)","v":0}]
[null,"2018-06-26","21:00:00",39,"Groupe D",2.4,2.9,2.85,"Nigeria",null,null,"Argentine",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J46),ISBLANK(J46)),\"\",IF(AND('Pronostiqueur 1'!J46=RESULTATS!J46,'Pronostiqueur 1'!M46=RESULTATS!M46),3,IF(OR(AND('Pronostiqueur 1'!J46>'Pronostiqueur 1'!M46,RESULTATS!J46>RESULTATS!M46),AND('Pronostiqueur 1'!J46<'Pronostiqueur 1'!M46,RESULTATS!J46<RESULTATS!M46),AND('Pronostiqueur 1'!J46='Pronostiqueur 1'!M46,RESULTATS!J46=RESULTATS!M46)),1,0)))","v":""},null,null,null,{"$f":"AB46*1000+AA46*100+Y46*10","v":0},{"$f":"RANK(R46,$R$45:$R$48,0)","v":1},"Panama",{"$f":"SUMPRODUCT((Teams1=T46)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T46)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T46)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T46)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T46)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T46)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T46)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T46)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T46)*(Teams1_Score))+SUMPRODUCT((Teams2=T46)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T46)*(Teams2_Score))+SUMPRODUCT((Teams2=T46)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-01",2,{"$f":"IF(SUM(U15:U18)=0,\"1er Groupe B\",IF(COUNTIF(S15:S18,1)=1,VLOOKUP(1,S15:T18,2,FALSE),IF(COUNTIF(S15:S18,1)>=2,\"Tirage au Sort B1\")))","v":"1er Groupe B"},{"$f":"AI46*10+AK46","v":0},null,{"$f":"IF(AND(LEFT(AG46,3)<>\"1er\",LEFT(AG46,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AG46),0)","v":0},null,null,{"$f":"IF(SUM(U9:U12)=0,\"2nd Groupe A\",IF(OR(COUNTIF(S9:S12,1)>1,COUNTIF(S9:S12,2)>1),\"Tirage au sort A2\",VLOOKUP(2,S9:T12,2,FALSE)))","v":"2nd Groupe A"},0,null,{"$f":"IF(AND(LEFT(AM46,3)<>\"1er\",LEFT(AM46,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AM46),0)","v":0}]
[null,"2018-06-26","21:00:00",40,"Groupe D",6.5,3.7,1.44,"Islande",null,null,"Croatie",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J47),ISBLANK(J47)),\"\",IF(AND('Pronostiqueur 1'!J47=RESULTATS!J47,'Pronostiqueur 1'!M47=RESULTATS!M47),3,IF(OR(AND('Pronostiqueur 1'!J47>'Pronostiqueur 1'!M47,RESULTATS!J47>RESULTATS!M47),AND('Pronostiqueur 1'!J47<'Pronostiqueur 1'!M47,RESULTATS!J47<RESULTATS!M47),AND('Pronostiqueur 1'!J47='Pronostiqueur 1'!M47,RESULTATS!J47=RESULTATS!M47)),1,0)))","v":""},null,null,null,{"$f":"AB47*1000+AA47*100+Y47*10","v":0},1,"Tunisie",{"$f":"SUMPRODUCT((Teams1=T47)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T47)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T47)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T47)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T47)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T47)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T47)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T47)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T47)*(Teams1_Score))+SUMPRODUCT((Teams2=T47)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T47)*(Teams2_Score))+SUMPRODUCT((Teams2=T47)*(Teams1_Score))","v":0},0,0,null,null,"2017-06-30",3,{"$f":"IF(SUM(U21:U24)=0,\"1er Groupe C\",IF(COUNTIF(S21:S24,1)=1,VLOOKUP(1,S21:T24,2,FALSE),IF(COUNTIF(S21:S24,1)>=2,\"Tirage au Sort C1\")))","v":"1er Groupe C"},0,null,{"$f":"IF(AND(LEFT(AG47,3)<>\"1er\",LEFT(AG47,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AG47),0)","v":0},null,null,{"$f":"IF(SUM(U27:U30)=0,\"2nd Groupe D\",IF(OR(COUNTIF(S27:S30,1)>1,COUNTIF(S27:S30,2)>1),\"Tirage au sort D2\",VLOOKUP(2,S27:T30,2,FALSE)))","v":"2nd Groupe D"},0,null,{"$f":"IF(AND(LEFT(AM47,3)<>\"1er\",LEFT(AM47,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AM47),0)","v":0}]
[null,"2018-06-27","21:00:00",41,"Groupe E",6.5,3.5,1.48,"Serbie",null,null,"Brésil",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J48),ISBLANK(J48)),\"\",IF(AND('Pronostiqueur 1'!J48=RESULTATS!J48,'Pronostiqueur 1'!M48=RESULTATS!M48),3,IF(OR(AND('Pronostiqueur 1'!J48>'Pronostiqueur 1'!M48,RESULTATS!J48>RESULTATS!M48),AND('Pronostiqueur 1'!J48<'Pronostiqueur 1'!M48,RESULTATS!J48<RESULTATS!M48),AND('Pronostiqueur 1'!J48='Pronostiqueur 1'!M48,RESULTATS!J48=RESULTATS!M48)),1,0)))","v":""},null,null,null,{"$f":"AB48*1000+AA48*100+Y48*10","v":0},1,"Angleterre",{"$f":"SUMPRODUCT((Teams1=T48)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T48)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T48)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T48)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T48)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T48)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T48)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T48)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T48)*(Teams1_Score))+SUMPRODUCT((Teams2=T48)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T48)*(Teams2_Score))+SUMPRODUCT((Teams2=T48)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-01",4,{"$f":"IF(SUM(U27:U30)=0,\"1er Groupe D\",IF(COUNTIF(S27:S30,1)=1,VLOOKUP(1,S27:T30,2,FALSE),IF(COUNTIF(S27:S30,1)>=2,\"Tirage au Sort D1\")))","v":"1er Groupe D"},0,null,{"$f":"IF(AND(LEFT(AG48,3)<>\"1er\",LEFT(AG48,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AG48),0)","v":0},null,null,{"$f":"IF(SUM(U21:U24)=0,\"2nd Groupe C\",IF(OR(COUNTIF(S21:S24,1)>1,COUNTIF(S21:S24,2)>1),\"Tirage au sort C2\",VLOOKUP(2,S21:T24,2,FALSE)))","v":"2nd Groupe C"},0,null,{"$f":"IF(AND(LEFT(AM48,3)<>\"1er\",LEFT(AM48,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AM48),0)","v":0}]
[null,"2018-06-27","21:00:00",42,"Groupe E",4,3.05,1.9,"Suisse",null,null,"Costa Rica",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J49),ISBLANK(J49)),\"\",IF(AND('Pronostiqueur 1'!J49=RESULTATS!J49,'Pronostiqueur 1'!M49=RESULTATS!M49),3,IF(OR(AND('Pronostiqueur 1'!J49>'Pronostiqueur 1'!M49,RESULTATS!J49>RESULTATS!M49),AND('Pronostiqueur 1'!J49<'Pronostiqueur 1'!M49,RESULTATS!J49<RESULTATS!M49),AND('Pronostiqueur 1'!J49='Pronostiqueur 1'!M49,RESULTATS!J49=RESULTATS!M49)),1,0)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-02",5,{"$f":"IF(SUM(U33:U36)=0,\"1er Groupe E\",IF(COUNTIF(S33:S36,1)=1,VLOOKUP(1,S33:T36,2,FALSE),IF(COUNTIF(S33:S36,1)>=2,\"Tirage au Sort E1\")))","v":"1er Groupe E"},0,null,{"$f":"IF(AND(LEFT(AG49,3)<>\"1er\",LEFT(AG49,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AG49),0)","v":0},null,null,{"$f":"IF(SUM(U39:U42)=0,\"2nd Groupe F\",IF(OR(COUNTIF(S39:S42,1)>1,COUNTIF(S39:S42,2)>1),\"Tirage au sort F2\",VLOOKUP(2,S39:T42,2,FALSE)))","v":"2nd Groupe F"},0,null,{"$f":"IF(AND(LEFT(AM49,3)<>\"1er\",LEFT(AM49,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AM49),0)","v":0}]
[null,"2018-06-27","19:00:00",43,"Groupe F",8.5,4.3,1.3,"Mexique",null,null,"Suède",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J50),ISBLANK(J50)),\"\",IF(AND('Pronostiqueur 1'!J50=RESULTATS!J50,'Pronostiqueur 1'!M50=RESULTATS!M50),3,IF(OR(AND('Pronostiqueur 1'!J50>'Pronostiqueur 1'!M50,RESULTATS!J50>RESULTATS!M50),AND('Pronostiqueur 1'!J50<'Pronostiqueur 1'!M50,RESULTATS!J50<RESULTATS!M50),AND('Pronostiqueur 1'!J50='Pronostiqueur 1'!M50,RESULTATS!J50=RESULTATS!M50)),1,0)))","v":""},null,null,null,null,"Rg","Groupe H","MJ","G","N","P","BP","BC","Pts","Pts",null,null,"2018-07-03",6,{"$f":"IF(SUM(U39:U42)=0,\"1er Groupe F\",IF(COUNTIF(S39:S42,1)=1,VLOOKUP(1,S39:T42,2,FALSE),IF(COUNTIF(S39:S42,1)>=2,\"Tirage au Sort F1\")))","v":"1er Groupe F"},0,null,{"$f":"IF(AND(LEFT(AG50,3)<>\"1er\",LEFT(AG50,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AG50),0)","v":0},null,null,{"$f":"IF(SUM(U33:U36)=0,\"2nd Groupe E\",IF(OR(COUNTIF(S33:S36,1)>1,COUNTIF(S33:S36,2)>1),\"Tirage au sort E2\",VLOOKUP(2,S33:T36,2,FALSE)))","v":"2nd Groupe E"},0,null,{"$f":"IF(AND(LEFT(AM50,3)<>\"1er\",LEFT(AM50,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AM50),0)","v":0}]
[null,"2018-06-27","17:00:00",44,"Groupe F",1.48,3.6,6.25,"République de Corée",null,null,"Allemagne",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J51),ISBLANK(J51)),\"\",IF(AND('Pronostiqueur 1'!J51=RESULTATS!J51,'Pronostiqueur 1'!M51=RESULTATS!M51),3,IF(OR(AND('Pronostiqueur 1'!J51>'Pronostiqueur 1'!M51,RESULTATS!J51>RESULTATS!M51),AND('Pronostiqueur 1'!J51<'Pronostiqueur 1'!M51,RESULTATS!J51<RESULTATS!M51),AND('Pronostiqueur 1'!J51='Pronostiqueur 1'!M51,RESULTATS!J51=RESULTATS!M51)),1,0)))","v":""},null,null,null,{"$f":"AB51*1000+AA51*100+Y51*10","v":0},{"$f":"RANK(R51,$R$51:$R$54,0)","v":1},"Colombie",{"$f":"SUMPRODUCT((Teams1=T51)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T51)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T51)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T51)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T51)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T51)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T51)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T51)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T51)*(Teams1_Score))+SUMPRODUCT((Teams2=T51)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T51)*(Teams2_Score))+SUMPRODUCT((Teams2=T51)*(Teams1_Score))","v":0},{"$f":"Y51-Z51","v":0},{"$f":"3*V51+W51","v":0},null,null,"2018-07-02",7,{"$f":"IF(SUM(U45:U48)=0,\"1er Groupe G\",IF(COUNTIF(S45:S48,1)=1,VLOOKUP(1,S45:T48,2,FALSE),IF(COUNTIF(S45:S48,1)>=2,\"Tirage au Sort G1\")))","v":"1er Groupe G"},0,null,{"$f":"IF(AND(LEFT(AG51,3)<>\"1er\",LEFT(AG51,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AG51),0)","v":0},null,null,{"$f":"IF(SUM(U51:U54)=0,\"2nd Groupe H\",IF(OR(COUNTIF(S51:S54,1)>1,COUNTIF(S51:S54,2)>1),\"Tirage au sort H2\",VLOOKUP(2,S51:T54,2,FALSE)))","v":"2nd Groupe H"},0,null,{"$f":"IF(AND(LEFT(AM51,3)<>\"1er\",LEFT(AM51,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AM51),0)","v":0}]
[null,"2018-06-28","21:00:00",45,"Groupe G",8,4.2,1.32,"Panama",null,null,"Tunisie",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J52),ISBLANK(J52)),\"\",IF(AND('Pronostiqueur 1'!J52=RESULTATS!J52,'Pronostiqueur 1'!M52=RESULTATS!M52),3,IF(OR(AND('Pronostiqueur 1'!J52>'Pronostiqueur 1'!M52,RESULTATS!J52>RESULTATS!M52),AND('Pronostiqueur 1'!J52<'Pronostiqueur 1'!M52,RESULTATS!J52<RESULTATS!M52),AND('Pronostiqueur 1'!J52='Pronostiqueur 1'!M52,RESULTATS!J52=RESULTATS!M52)),1,0)))","v":""},null,null,null,{"$f":"AB52*1000+AA52*100+Y52*10","v":0},{"$f":"RANK(R52,$R$51:$R$54,0)","v":1},"Japon",{"$f":"SUMPRODUCT((Teams1=T52)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T52)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T52)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T52)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T52)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T52)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T52)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T52)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T52)*(Teams1_Score))+SUMPRODUCT((Teams2=T52)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T52)*(Teams2_Score))+SUMPRODUCT((Teams2=T52)*(Teams1_Score))","v":0},0,0,null,null,"2018-07-03",8,{"$f":"IF(SUM(U51:U54)=0,\"1er Groupe H\",IF(COUNTIF(S51:S54,1)=1,VLOOKUP(1,S51:T54,2,FALSE),IF(COUNTIF(S51:S54,1)>=2,\"Tirage au Sort H1\")))","v":"1er Groupe H"},0,null,{"$f":"IF(AND(LEFT(AG52,3)<>\"1er\",LEFT(AG52,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AG52),0)","v":0},null,null,{"$f":"IF(SUM(U45:U48)=0,\"2nd Groupe G\",IF(OR(COUNTIF(S45:S48,1)>1,COUNTIF(S45:S48,2)>1),\"Tirage au sort G2\",VLOOKUP(2,S45:T48,2,FALSE)))","v":"2nd Groupe G"},0,null,{"$f":"IF(AND(LEFT(AM52,3)<>\"1er\",LEFT(AM52,3)<>\"2nd\"),COUNTIF(RESULTATS!$AF$30:$AL$37,AM52),0)","v":0}]
[null,"2018-06-28","20:00:00",46,"Groupe G",1.74,3.2,4.0999999999999996,"Angleterre",null,null,"Belgique",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J53),ISBLANK(J53)),\"\",IF(AND('Pronostiqueur 1'!J53=RESULTATS!J53,'Pronostiqueur 1'!M53=RESULTATS!M53),3,IF(OR(AND('Pronostiqueur 1'!J53>'Pronostiqueur 1'!M53,RESULTATS!J53>RESULTATS!M53),AND('Pronostiqueur 1'!J53<'Pronostiqueur 1'!M53,RESULTATS!J53<RESULTATS!M53),AND('Pronostiqueur 1'!J53='Pronostiqueur 1'!M53,RESULTATS!J53=RESULTATS!M53)),1,0)))","v":""},null,null,null,{"$f":"AB53*1000+AA53*100+Y53*10","v":0},1,"Pologne",{"$f":"SUMPRODUCT((Teams1=T53)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T53)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T53)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T53)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T53)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T53)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T53)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T53)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T53)*(Teams1_Score))+SUMPRODUCT((Teams2=T53)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T53)*(Teams2_Score))+SUMPRODUCT((Teams2=T53)*(Teams1_Score))","v":0},0,0,null,null,null,null,null,null,null,{"$f":"SUM(AJ45:AJ52)","v":0},null,null,null,0,null,{"$f":"SUM(AP45:AP52)","v":0}]
[null,"2018-06-28","17:00:00",47,"Groupe H",4.9000000000000004,3.25,1.62,"Japon",null,null,"Pologne",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J54),ISBLANK(J54)),\"\",IF(AND('Pronostiqueur 1'!J54=RESULTATS!J54,'Pronostiqueur 1'!M54=RESULTATS!M54),3,IF(OR(AND('Pronostiqueur 1'!J54>'Pronostiqueur 1'!M54,RESULTATS!J54>RESULTATS!M54),AND('Pronostiqueur 1'!J54<'Pronostiqueur 1'!M54,RESULTATS!J54<RESULTATS!M54),AND('Pronostiqueur 1'!J54='Pronostiqueur 1'!M54,RESULTATS!J54=RESULTATS!M54)),1,0)))","v":""},null,null,null,{"$f":"AB54*1000+AA54*100+Y54*10","v":0},1,"Sénégal",{"$f":"SUMPRODUCT((Teams1=T54)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T54)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T54)*(Teams1_Score>Teams2_Score))+SUMPRODUCT((Teams2=T54)*(Teams2_Score>Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T54)*(Teams1_Score=Teams2_Score)*(Teams1_Score<>\"\"))+SUMPRODUCT((Teams2=T54)*(Teams2_Score=Teams1_Score)*(Teams2_Score<>\"\"))","v":0},{"$f":"SUMPRODUCT((Teams1=T54)*(Teams1_Score<Teams2_Score))+SUMPRODUCT((Teams2=T54)*(Teams2_Score<Teams1_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T54)*(Teams1_Score))+SUMPRODUCT((Teams2=T54)*(Teams2_Score))","v":0},{"$f":"SUMPRODUCT((Teams1=T54)*(Teams2_Score))+SUMPRODUCT((Teams2=T54)*(Teams1_Score))","v":0},0,0]
[null,"2018-06-28","18:00:00",48,"Groupe H",6,3.4,1.52,"Sénégal",null,null,"Colombie",null,{"$f":"IF(OR(ISBLANK(RESULTATS!J55),ISBLANK(J55)),\"\",IF(AND('Pronostiqueur 1'!J55=RESULTATS!J55,'Pronostiqueur 1'!M55=RESULTATS!M55),3,IF(OR(AND('Pronostiqueur 1'!J55>'Pronostiqueur 1'!M55,RESULTATS!J55>RESULTATS!M55),AND('Pronostiqueur 1'!J55<'Pronostiqueur 1'!M55,RESULTATS!J55<RESULTATS!M55),AND('Pronostiqueur 1'!J55='Pronostiqueur 1'!M55,RESULTATS!J55=RESULTATS!M55)),1,0)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N8:N55)","v":0}]
[]
[]
[null,"Tirage au sort A1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($S$9:$S$12,1),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=1,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:1))),\"\")","v":"Russie"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($S$9:$S$12,1),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=1,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:2))),\"\")","v":"Arabie Saoudite"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($S$9:$S$12,1),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=1,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:3))),\"\")","v":"Egypte"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($S$9:$S$12,1),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=1,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:4))),\"\")","v":"Uruguay"}]
[null,"Tirage au sort A2"]
[null,{"$f":"IF(COUNTIF($S$9:$S$12,1)>1,IF(ROWS($1:1)<=COUNTIF($S$9:$S$12,1),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=1,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:1))),\"\"),IF(COUNTIF($S$9:$S$12,2)>1,IF(ROWS($1:1)<=COUNTIF($S$9:$S$12,2),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=2,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:1))),\"\")))","v":"Russie"}]
[null,{"$f":"IF(COUNTIF($S$9:$S$12,1)>1,IF(ROWS($1:2)<=COUNTIF($S$9:$S$12,1),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=1,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:2))),\"\"),IF(COUNTIF($S$9:$S$12,2)>1,IF(ROWS($1:2)<=COUNTIF($S$9:$S$12,2),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=2,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:2))),\"\")))","v":"Arabie Saoudite"}]
[null,{"$f":"IF(COUNTIF($S$9:$S$12,1)>1,IF(ROWS($1:3)<=COUNTIF($S$9:$S$12,1),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=1,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:3))),\"\"),IF(COUNTIF($S$9:$S$12,2)>1,IF(ROWS($1:3)<=COUNTIF($S$9:$S$12,2),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=2,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:3))),\"\")))","v":"Egypte"}]
[null,{"$f":"IF(COUNTIF($S$9:$S$12,1)>1,IF(ROWS($1:4)<=COUNTIF($S$9:$S$12,1),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=1,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:4))),\"\"),IF(COUNTIF($S$9:$S$12,2)>1,IF(ROWS($1:4)<=COUNTIF($S$9:$S$12,2),INDEX($T$9:$T$12,SMALL(IF($S$9:$S$12=2,ROW(INDIRECT(\"1:\"&ROWS($S$9:$S$12)))),ROWS($1:4))),\"\")))","v":"Uruguay"}]
[null,"Tirage au sort B1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($S$15:$S$18,1),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=1,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:1))),\"\")","v":"Maroc"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($S$15:$S$18,1),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=1,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:2))),\"\")","v":"RI Iran"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($S$15:$S$18,1),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=1,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:3))),\"\")","v":"Portugal"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($S$15:$S$18,1),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=1,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:4))),\"\")","v":"Espagne"}]
[null,"Tirage au sort B2"]
[null,{"$f":"IF(COUNTIF($S$15:$S$18,1)>1,IF(ROWS($1:1)<=COUNTIF($S$15:$S$18,1),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=1,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:1))),\"\"),IF(COUNTIF($S$15:$S$18,2)>1,IF(ROWS($1:1)<=COUNTIF($S$15:$S$18,2),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=2,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:1))),\"\")))","v":"Maroc"}]
[null,{"$f":"IF(COUNTIF($S$15:$S$18,1)>1,IF(ROWS($1:2)<=COUNTIF($S$15:$S$18,1),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=1,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:2))),\"\"),IF(COUNTIF($S$15:$S$18,2)>1,IF(ROWS($1:2)<=COUNTIF($S$15:$S$18,2),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=2,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:2))),\"\")))","v":"RI Iran"}]
[null,{"$f":"IF(COUNTIF($S$15:$S$18,1)>1,IF(ROWS($1:3)<=COUNTIF($S$15:$S$18,1),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=1,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:3))),\"\"),IF(COUNTIF($S$15:$S$18,2)>1,IF(ROWS($1:3)<=COUNTIF($S$15:$S$18,2),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=2,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:3))),\"\")))","v":"Portugal"}]
[null,{"$f":"IF(COUNTIF($S$15:$S$18,1)>1,IF(ROWS($1:4)<=COUNTIF($S$15:$S$18,1),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=1,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:4))),\"\"),IF(COUNTIF($S$15:$S$18,2)>1,IF(ROWS($1:4)<=COUNTIF($S$15:$S$18,2),INDEX($T$15:$T$18,SMALL(IF($S$15:$S$18=2,ROW(INDIRECT(\"1:\"&ROWS($S$15:$S$18)))),ROWS($1:4))),\"\")))","v":"Espagne"}]
[null,"Tirage au sort C1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($S$21:$S$24,1),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=1,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:1))),\"\")","v":"France"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($S$21:$S$24,1),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=1,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:2))),\"\")","v":"Australie"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($S$21:$S$24,1),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=1,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:3))),\"\")","v":"Pérou"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($S$21:$S$24,1),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=1,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:4))),\"\")","v":"Danemark"}]
[null,"Tirage au sort C2"]
[null,{"$f":"IF(COUNTIF($S$21:$S$24,1)>1,IF(ROWS($1:1)<=COUNTIF($S$21:$S$24,1),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=1,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:1))),\"\"),IF(COUNTIF($S$21:$S$24,2)>1,IF(ROWS($1:1)<=COUNTIF($S$21:$S$24,2),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=2,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:1))),\"\")))","v":"France"}]
[null,{"$f":"IF(COUNTIF($S$21:$S$24,1)>1,IF(ROWS($1:2)<=COUNTIF($S$21:$S$24,1),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=1,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:2))),\"\"),IF(COUNTIF($S$21:$S$24,2)>1,IF(ROWS($1:2)<=COUNTIF($S$21:$S$24,2),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=2,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:2))),\"\")))","v":"Australie"}]
[null,{"$f":"IF(COUNTIF($S$21:$S$24,1)>1,IF(ROWS($1:3)<=COUNTIF($S$21:$S$24,1),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=1,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:3))),\"\"),IF(COUNTIF($S$21:$S$24,2)>1,IF(ROWS($1:3)<=COUNTIF($S$21:$S$24,2),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=2,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:3))),\"\")))","v":"Pérou"}]
[null,{"$f":"IF(COUNTIF($S$21:$S$24,1)>1,IF(ROWS($1:4)<=COUNTIF($S$21:$S$24,1),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=1,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:4))),\"\"),IF(COUNTIF($S$21:$S$24,2)>1,IF(ROWS($1:4)<=COUNTIF($S$21:$S$24,2),INDEX($T$21:$T$24,SMALL(IF($S$21:$S$24=2,ROW(INDIRECT(\"1:\"&ROWS($S$21:$S$24)))),ROWS($1:4))),\"\")))","v":"Danemark"}]
[null,"Tirage au sort D1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($S$27:$S$30,1),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=1,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:1))),\"\")","v":"Argentine"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($S$27:$S$30,1),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=1,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:2))),\"\")","v":"Islande"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($S$27:$S$30,1),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=1,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:3))),\"\")","v":"Croatie"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($S$27:$S$30,1),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=1,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:4))),\"\")","v":"Nigeria"}]
[null,"Tirage au sort D2"]
[null,{"$f":"IF(COUNTIF($S$27:$S$30,1)>1,IF(ROWS($1:1)<=COUNTIF($S$27:$S$30,1),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=1,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:1))),\"\"),IF(COUNTIF($S$27:$S$30,2)>1,IF(ROWS($1:1)<=COUNTIF($S$27:$S$30,2),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=2,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:1))),\"\")))","v":"Argentine"}]
[null,{"$f":"IF(COUNTIF($S$27:$S$30,1)>1,IF(ROWS($1:2)<=COUNTIF($S$27:$S$30,1),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=1,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:2))),\"\"),IF(COUNTIF($S$27:$S$30,2)>1,IF(ROWS($1:2)<=COUNTIF($S$27:$S$30,2),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=2,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:2))),\"\")))","v":"Islande"}]
[null,{"$f":"IF(COUNTIF($S$27:$S$30,1)>1,IF(ROWS($1:3)<=COUNTIF($S$27:$S$30,1),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=1,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:3))),\"\"),IF(COUNTIF($S$27:$S$30,2)>1,IF(ROWS($1:3)<=COUNTIF($S$27:$S$30,2),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=2,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:3))),\"\")))","v":"Croatie"}]
[null,{"$f":"IF(COUNTIF($S$27:$S$30,1)>1,IF(ROWS($1:4)<=COUNTIF($S$27:$S$30,1),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=1,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:4))),\"\"),IF(COUNTIF($S$27:$S$30,2)>1,IF(ROWS($1:4)<=COUNTIF($S$27:$S$30,2),INDEX($T$27:$T$30,SMALL(IF($S$27:$S$30=2,ROW(INDIRECT(\"1:\"&ROWS($S$27:$S$30)))),ROWS($1:4))),\"\")))","v":"Nigeria"}]
[null,"Tirage au sort E1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($S$33:$S$36,1),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=1,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:1))),\"\")","v":"Costa Rica"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($S$33:$S$36,1),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=1,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:2))),\"\")","v":"Serbie"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($S$33:$S$36,1),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=1,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:3))),\"\")","v":"Brésil"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($S$33:$S$36,1),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=1,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:4))),\"\")","v":"Suisse"}]
[null,"Tirage au sort E2"]
[null,{"$f":"IF(COUNTIF($S$33:$S$36,1)>1,IF(ROWS($1:1)<=COUNTIF($S$33:$S$36,1),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=1,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:1))),\"\"),IF(COUNTIF($S$33:$S$36,2)>1,IF(ROWS($1:1)<=COUNTIF($S$33:$S$36,2),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=2,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:1))),\"\")))","v":"Costa Rica"}]
[null,{"$f":"IF(COUNTIF($S$33:$S$36,1)>1,IF(ROWS($1:2)<=COUNTIF($S$33:$S$36,1),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=1,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:2))),\"\"),IF(COUNTIF($S$33:$S$36,2)>1,IF(ROWS($1:2)<=COUNTIF($S$33:$S$36,2),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=2,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:2))),\"\")))","v":"Serbie"}]
[null,{"$f":"IF(COUNTIF($S$33:$S$36,1)>1,IF(ROWS($1:3)<=COUNTIF($S$33:$S$36,1),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=1,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:3))),\"\"),IF(COUNTIF($S$33:$S$36,2)>1,IF(ROWS($1:3)<=COUNTIF($S$33:$S$36,2),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=2,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:3))),\"\")))","v":"Brésil"}]
[null,{"$f":"IF(COUNTIF($S$33:$S$36,1)>1,IF(ROWS($1:4)<=COUNTIF($S$33:$S$36,1),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=1,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:4))),\"\"),IF(COUNTIF($S$33:$S$36,2)>1,IF(ROWS($1:4)<=COUNTIF($S$33:$S$36,2),INDEX($T$33:$T$36,SMALL(IF($S$33:$S$36=2,ROW(INDIRECT(\"1:\"&ROWS($S$33:$S$36)))),ROWS($1:4))),\"\")))","v":"Suisse"}]
[null,"Tirage au sort F1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($S$39:$S$42,1),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=1,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:1))),\"\")","v":"Allemagne"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($S$39:$S$42,1),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=1,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:2))),\"\")","v":"Mexique"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($S$39:$S$42,1),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=1,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:3))),\"\")","v":"Suède"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($S$39:$S$42,1),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=1,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:4))),\"\")","v":"République de Corée"}]
[null,"Tirage au sort F2"]
[null,{"$f":"IF(COUNTIF($S$39:$S$42,1)>1,IF(ROWS($1:1)<=COUNTIF($S$39:$S$42,1),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=1,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:1))),\"\"),IF(COUNTIF($S$39:$S$42,2)>1,IF(ROWS($1:1)<=COUNTIF($S$39:$S$42,2),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=2,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:1))),\"\")))","v":"Allemagne"}]
[null,{"$f":"IF(COUNTIF($S$39:$S$42,1)>1,IF(ROWS($1:2)<=COUNTIF($S$39:$S$42,1),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=1,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:2))),\"\"),IF(COUNTIF($S$39:$S$42,2)>1,IF(ROWS($1:2)<=COUNTIF($S$39:$S$42,2),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=2,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:2))),\"\")))","v":"Mexique"}]
[null,{"$f":"IF(COUNTIF($S$39:$S$42,1)>1,IF(ROWS($1:3)<=COUNTIF($S$39:$S$42,1),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=1,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:3))),\"\"),IF(COUNTIF($S$39:$S$42,2)>1,IF(ROWS($1:3)<=COUNTIF($S$39:$S$42,2),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=2,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:3))),\"\")))","v":"Suède"}]
[null,{"$f":"IF(COUNTIF($S$39:$S$42,1)>1,IF(ROWS($1:4)<=COUNTIF($S$39:$S$42,1),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=1,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:4))),\"\"),IF(COUNTIF($S$39:$S$42,2)>1,IF(ROWS($1:4)<=COUNTIF($S$39:$S$42,2),INDEX($T$39:$T$42,SMALL(IF($S$39:$S$42=2,ROW(INDIRECT(\"1:\"&ROWS($S$39:$S$42)))),ROWS($1:4))),\"\")))","v":"République de Corée"}]
[null,"Tirage au sort G1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($S$45:$S$48,1),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=1,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:1))),\"\")","v":"Belgique"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($S$45:$S$48,1),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=1,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:2))),\"\")","v":"Panama"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($S$45:$S$48,1),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=1,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:3))),\"\")","v":"Tunisie"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($S$45:$S$48,1),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=1,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:4))),\"\")","v":"Angleterre"}]
[null,"Tirage au sort G2"]
[null,{"$f":"IF(COUNTIF($S$45:$S$48,1)>1,IF(ROWS($1:1)<=COUNTIF($S$45:$S$48,1),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=1,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:1))),\"\"),IF(COUNTIF($S$45:$S$48,2)>1,IF(ROWS($1:1)<=COUNTIF($S$45:$S$48,2),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=2,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:1))),\"\")))","v":"Belgique"}]
[null,{"$f":"IF(COUNTIF($S$45:$S$48,1)>1,IF(ROWS($1:2)<=COUNTIF($S$45:$S$48,1),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=1,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:2))),\"\"),IF(COUNTIF($S$45:$S$48,2)>1,IF(ROWS($1:2)<=COUNTIF($S$45:$S$48,2),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=2,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:2))),\"\")))","v":"Panama"}]
[null,{"$f":"IF(COUNTIF($S$45:$S$48,1)>1,IF(ROWS($1:3)<=COUNTIF($S$45:$S$48,1),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=1,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:3))),\"\"),IF(COUNTIF($S$45:$S$48,2)>1,IF(ROWS($1:3)<=COUNTIF($S$45:$S$48,2),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=2,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:3))),\"\")))","v":"Tunisie"}]
[null,{"$f":"IF(COUNTIF($S$45:$S$48,1)>1,IF(ROWS($1:4)<=COUNTIF($S$45:$S$48,1),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=1,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:4))),\"\"),IF(COUNTIF($S$45:$S$48,2)>1,IF(ROWS($1:4)<=COUNTIF($S$45:$S$48,2),INDEX($T$45:$T$48,SMALL(IF($S$45:$S$48=2,ROW(INDIRECT(\"1:\"&ROWS($S$45:$S$48)))),ROWS($1:4))),\"\")))","v":"Angleterre"}]
[null,"Tirage au sort H1"]
[null,{"$f":"IF(ROWS($1:1)<=COUNTIF($S$51:$S$54,1),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=1,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:1))),\"\")","v":"Colombie"}]
[null,{"$f":"IF(ROWS($1:2)<=COUNTIF($S$51:$S$54,1),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=1,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:2))),\"\")","v":"Japon"}]
[null,{"$f":"IF(ROWS($1:3)<=COUNTIF($S$51:$S$54,1),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=1,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:3))),\"\")","v":"Pologne"}]
[null,{"$f":"IF(ROWS($1:4)<=COUNTIF($S$51:$S$54,1),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=1,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:4))),\"\")","v":"Sénégal"}]
[null,"Tirage au sort H2"]
[null,{"$f":"IF(COUNTIF($S$51:$S$54,1)>1,IF(ROWS($1:1)<=COUNTIF($S$51:$S$54,1),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=1,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:1))),\"\"),IF(COUNTIF($S$51:$S$54,2)>1,IF(ROWS($1:1)<=COUNTIF($S$51:$S$54,2),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=2,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:1))),\"\")))","v":"Colombie"}]
[null,{"$f":"IF(COUNTIF($S$51:$S$54,1)>1,IF(ROWS($1:2)<=COUNTIF($S$51:$S$54,1),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=1,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:2))),\"\"),IF(COUNTIF($S$51:$S$54,2)>1,IF(ROWS($1:2)<=COUNTIF($S$51:$S$54,2),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=2,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:2))),\"\")))","v":"Japon"}]
[null,{"$f":"IF(COUNTIF($S$51:$S$54,1)>1,IF(ROWS($1:3)<=COUNTIF($S$51:$S$54,1),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=1,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:3))),\"\"),IF(COUNTIF($S$51:$S$54,2)>1,IF(ROWS($1:3)<=COUNTIF($S$51:$S$54,2),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=2,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:3))),\"\")))","v":"Pologne"}]
[null,{"$f":"IF(COUNTIF($S$51:$S$54,1)>1,IF(ROWS($1:4)<=COUNTIF($S$51:$S$54,1),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=1,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:4))),\"\"),IF(COUNTIF($S$51:$S$54,2)>1,IF(ROWS($1:4)<=COUNTIF($S$51:$S$54,2),INDEX($T$51:$T$54,SMALL(IF($S$51:$S$54=2,ROW(INDIRECT(\"1:\"&ROWS($S$51:$S$54)))),ROWS($1:4))),\"\")))","v":"Sénégal"}]