{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Règlement","Matchs","Resultats","Verif"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":173,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Règlement","index":0,"n_rows":105,"n_cols":6,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CONCOURS \"EURO 2016\""]
[null,"Solution \"clé en main\" pour votre concours de pronostics Euro 2016. Pour tous renseignements :"]
[null,"La version présentée dans le présent document est une version provisoire, qui sera mise à jour avant le début de la compétition."]
[]
[null,"OBJET DU CONCOURS"]
[]
[null,"Le concours \"Pronostics Euro 2016\" est un jeu permettant à ses participants de pronostiquer les résultats du Championnat d'Europe des Nations UEFA 2016. "]
[null,"Les participants devront valider plusieurs étapes - définies ci après - pour gagner un maximum de points. "]
[null,"Le classement des participants sera mis à jour quotidiennement pendant la période de la compétition (du 10/06 au 10/07/2016)."]
[]
[]
[null,"DESCRIPTION DES PHASES DE JEU"]
[]
[null,"Le concours est divisé en plusieurs étapes. "]
[]
[null,"Phase 1 :","Avant le début de la compétition (le 10/06), les participants devront pronostiquer le résultat des 36 matchs de Poule. (Onglet \"Matchs\")"]
[null,null,"Pour chacun des 36 matchs, des cotes sont proposées. Ces cotes ont été définies par le site de pari Unibet (tronquées à la première décimale)."]
[null,null,"Les cotes sont également consultables sur le lien suivant http://www.cotes.fr/football/Euro-2016-ed251"]
[null,null,"Les cotes ont été relevées sur ce site en date du 31/05/2016. Elles sont fixes et ne seront plus modifiées. "]
[null,null,"Le barême des points appliqué à chacun des 36 matchs de Poule est le suivant : "]
[null,null,"- en cas de bon pronostic sans le score, le joueur gagnera (3 * la cote du pronostic) points"]
[null,null,"- en cas de bon pronostic avec le score exact, le joueur gagnera (5 * la cote du pronostic) points"]
[null,null,"- dans les autres cas, le joueur gagnera 0 point"]
[]
[null,null,"Simulation avec le match FRANCE - ROUMANIE"]
[null,null,"Les cotes sont de 1.4 pour une victoire de la France ; 8.0 pour une victoire de la Roumanie ; de 4.2 pour un match nul"]
[null,null,"Dans l'exemple 1, la France s'impose 1-0."]
[null,null,null,"A l'issue de la rencontre, tous les joueurs ayant pronostiqué une victoire de la France sur le score de 1-0 marquent 5*1.4 , soit 7.0 points."]
[null,null,null,"Tous les joueurs ayant pronostiqué une victoire de la France sur un score différent de 1-0 marquent 3*1.4 , soit 4.2 points"]
[null,null,null,"Tous les joueurs ayant pronostiqué une victoire de la Roumanie ou un match nul marquent 0 point."]
[null,null,"Dans l'exemple 2, la Roumanie s'impose 1-0."]
[null,null,null,"A l'issue de la rencontre, tous les joueurs ayant pronostiqué une victoire de la Roumanie sur le score de 1-0 marquent 5*8.0 , soit 40.0 points."]
[null,null,null,"Tous les joueurs ayant pronostiqué une victoire de la Roumanie sur un score différent de 1-0 marquent 3*8.0 , soit 24.0 points"]
[null,null,null,"Tous les joueurs ayant pronostiqué une victoire de la France ou un match nul marquent 0 point."]
[]
[null,null,"Date limite du pronostic : le 10/06/2016"]
[]
[null,null,"Avant le début de la compétition (le 10/06), les participants devront pronostiquer le tableau final de la compétition (uniquement le qualifié pour chaque match). (Onglet \"Matchs\")"]
[]
[null,null,"- HUITIEMES DE FINALE ",null,"La saisie des résultats des 36 matchs de poule (étape 1) génère automatiquement la constitution des huitièmes de finale"]
[null,null,null,null,"Pour chaque huitième de finaliste trouvé, le joueur marque (5 * la cote de qualification en 8ème) points"]
[null,null,null,null,"Exemples : ","la qualification de la France en 8ème rapportera (5 * 1,0) points à ceux qui l'ont pronostiquée, soit 5.0 points"]
[null,null,null,null,null,"la qualification de la Roumanie en 8ème rapportera (5 * 1,8) points à ceux qui l'ont pronostiquée, soit 9.0 points"]
[]
[null,null,"- QUARTS DE FINALE ",null,"Le participant sélectionne les 8 équipes qu'il pense voir se qualifier en quarts de finale"]
[null,null,null,null,"pour chaque quart de finaliste trouvé, le joueur marque 12 points"]
[]
[null,null,"- DEMI-FINALES",null,"Le participant sélectionne les 4 équipes qu'il pense voir se qualifier en demi-finales"]
[null,null,null,null,"pour chaque demi-finaliste trouvé, le joueur marque 20 points"]
[]
[null,null,"- FINALE",null,"Le participant sélectionne les 2 équipes qu'il pense voir se qualifier en finale"]
[null,null,null,null,"pour chaque finaliste trouvé, le joueur marque 35 points"]
[]
[null,null,"- VAINQUEUR",null,"Le participant sélectionne l'équipe qu'il pense voir gagner l'Euro"]
[null,null,null,null,"si le joueur trouve le vainqueur de la compétition, il marque 50 points"]
[]
[null,null,"Date limite du pronostic : le 10/06/2016"]
[]
[null,"Phase 2 :","Lorsque les affiches auront été définies, les participants devront pronostiquer les scores des 8 Huitièmes de Finale."]
[null,null,"Des cotes seront proposées pour chaque Huitième de Finale."]
[null,null,"Les scores à pronostiquer seront les scores à l'issue des 90 minutes, avant éventuelle prolongation. Une cote sera donc également attribuée pour le match nul."]
[]
[null,null,"Le barême des points appliqué aux 8 Huitièmes de Finale est le suivant : "]
[null,null,"- en cas de bon pronostic sans le score, le joueur gagnera (6 * la cote du pronostic) points"]
[null,null,"- en cas de bon pronostic avec le score exact, le joueur gagnera (10 * la cote du pronostic) points"]
[null,null,"- dans les autres cas, le joueur gagnera 0 point"]
[]
[null,null,"Il est de la responsabilité de chaque participant de bien veiller à transmettre ses pronostics à temps."]
[null,null,"En cas de non réception du pronostic à temps, les matchs non pronostiqués rapporteront 0 point aux participants concernés."]
[]
[null,null,"Date limite du pronostic : le 25/06/2016"]
[]
[null,"Phase 3 :","Lorsque les affiches auront été définies, les participants devront pronostiquer les scores des 4 Quarts de Finale."]
[null,null,"Des cotes seront proposées pour chaque Quart de Finale."]
[null,null,"Les scores à pronostiquer seront les scores à l'issue des 90 minutes, avant éventuelle prolongation. Une cote sera donc également attribuée pour le match nul."]
[]
[null,null,"Le barême des points appliqué est identique à celui de l'Etape 3"]
[]
[null,null,"Il est de la responsabilité de chaque participant de bien veiller à transmettre ses pronostics à temps."]
[null,null,"En cas de non réception du pronostic à temps, les matchs non pronostiqués rapporteront 0 point aux participants concernés."]
[]
[null,null,"Date limite du pronostic : le 30/06/2016"]
[]
[null,"Phase 4 :","Lorsque les affiches auront été définies, les participants devront pronostiquer les scores des 2 Demi-Finales."]
[null,null,"Des cotes seront proposées pour chaque Demi-Finale."]
[null,null,"Les scores à pronostiquer seront les scores à l'issue des 90 minutes, avant éventuelle prolongation. Une cote sera donc également attribuée pour le match nul."]
[]
[null,null,"Le barême des points appliqué est identique à celui de l'Etape 3"]
[]
[null,null,"Il est de la responsabilité de chaque participant de bien veiller à transmettre ses pronostics à temps."]
[null,null,"En cas de non réception du pronostic à temps, les matchs non pronostiqués rapporteront 0 point aux participants concernés."]
[]
[null,null,"Date limite du pronostic : le 06/07/2016"]
[]
[null,"Phase 5 :","Lorsque les affiches auront été définies, les participants devront pronostiquer le score de la finale, ainsi que le score du match de classement pour la troisième place"]
[null,null,"Des cotes seront proposées pour chacun de ces deux matchs."]
[null,null,"Les scores à pronostiquer seront les scores à l'issue des 90 minutes, avant éventuelle prolongation. Une cote sera donc également attribuée pour le match nul."]
[]
[null,null,"Le barême des points appliqué est identique à celui de l'Etape 3"]
[]
[null,null,"Il est de la responsabilité de chaque participant de bien veiller à transmettre ses pronostics à temps."]
[null,null,"En cas de non réception du pronostic à temps, les matchs non pronostiqués rapporteront 0 point aux participants concernés."]
[]
[null,null,"Date limite du pronostic : le 10/07/2016"]

{"sheet":"Matchs","index":1,"n_rows":73,"n_cols":89,"rows_kept":73,"cut":false,"hidden":false,"merged":[[45,23,45,32],[7,11,7,13],[15,59,15,61],[16,59,16,60],[17,59,17,60],[11,59,11,60],[12,59,12,60],[13,59,13,60],[39,59,39,61],[40,59,40,60],[41,59,41,60],[42,59,42,60],[43,59,43,60],[33,59,33,61],[34,59,34,60],[35,59,35,60],[36,59,36,60],[37,59,37,60],[9,59,9,61],[10,59,10,60],[31,59,31,60],[18,59,18,60],[19,59,19,60],[21,59,21,61],[22,59,22,60],[23,59,23,60],[24,59,24,60],[25,59,25,60],[27,59,27,61],[28,59,28,60],[29,59,29,60],[30,59,30,60],[56,19,56,21],[56,11,56,12],[56,13,56,18],[46,1,46,2],[46,7,46,10],[46,19,46,21],[46,11,46,12],[46,13,46,18],[66,19,66,21],[62,1,62,2],[62,7,62,10],[62,11,62,12],[62,13,62,18],[62,19,62,21],[71,1,71,2],[66,1,66,2],[66,7,66,10],[66,11,66,12],[66,13,66,18],[6,1,6,7],[3,11,4,13],[69,1,69,2],[70,1,70,2],[56,1,56,2],[56,7,56,10],[7,1,7,2],[7,7,7,10],[4,1,4,2],[4,7,4,10],[5,1,5,2],[5,7,5,10],[6,8,6,14]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISTEXT(H5),ISTEXT(H6),LEN(H5)>0,LEN(H6)>0,LEN(H5)<20,LEN(H65)<20),\"OK\",\"[!]\")","v":"[!]"}]
[null,"Nom :   "]
[null,"Prenom :   "]
[]
["N°:","Date et heure",null,null,null,null,null,"Matchs de poule",null,null,null,"COTES (1N2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GROUPE A"]
[]
[1,"2016-06-10","21:00:00",{"$f":"IF(AND(I10<>\"\",J10<>\"\"),1,0)","v":1},{"$f":"IF(AND(I10>J10,D10=1),1,0)","v":1},{"$f":"IF(AND(I10=J10,D10=1),1,0)","v":0},{"$f":"IF(AND(I10<J10,D10=1),1,0)","v":0},"France",2,1,"Roumanie",{"$f":"Resultats!J6","v":1.2855555555555558},{"$f":"Resultats!K6","v":4.9833333333333334},{"$f":"Resultats!L6","v":13.444444444444445},{"$f":"IF(AND(I10<>\"\",J10<>\"\"),1,0)","v":1},{"$f":"IF(AND(I10<J10,O10=1),1,0)","v":0},{"$f":"IF(AND(I10=J10,O10=1),1,0)","v":0},{"$f":"IF(AND(I10>J10,O10=1),1,0)","v":1},null,null,null,null,null,null,"Poule A","PTS","J","G","N","P","B+","B-","Diff",null,null,"Class",null,"PT/Class","J","PTS","G","N","P","B+","B-","Diff","Bonus","Egalité",1,2,3,4,"Bonus","Egalite 1","Egalite 2",1,2,3,4,"COTES QUALIF 8ème",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42531,0.875,1,1,0,0,"France",2,1,"Roumanie"]
[2,"2016-06-11","15:00:00",1,0,0,1,"Albanie",0,1,"Suisse",{"$f":"Resultats!J7","v":5.5111111111111111},{"$f":"Resultats!K7","v":3.3277777777777775},{"$f":"Resultats!L7","v":1.7399999999999998},1,1,0,0,null,null,null,null,null,1,{"$f":"VLOOKUP(X11,AJ11:AT14,2,FALSE)","v":"France"},{"$f":"(3*AB11)+AC11","v":7},{"$f":"SUM(AB11:AD11)","v":3},{"$f":"VLOOKUP(X11,AJ11:AT14,6,FALSE)","v":2},{"$f":"VLOOKUP(X11,AJ11:AT14,7,FALSE)","v":1},{"$f":"VLOOKUP(X11,AJ11:AT14,8,FALSE)","v":0},{"$f":"VLOOKUP(X11,AJ11:AT14,9,FALSE)","v":4},{"$f":"VLOOKUP(X11,AJ11:AT14,10,FALSE)","v":1},{"$f":"AE11-AF11","v":3},null,1,{"$f":"RANK(AL11,AL11:AL14)","v":1},{"$f":"H10","v":"France"},{"$f":"(AN11*1000000000)+((AU11+BA11)*100000)+(AT11*1000)+(AR11*10)-AI11","v":7000003039},{"$f":"D10+D13+O14","v":3},{"$f":"(3*AO11)+AP11","v":7},{"$f":"COUNTIFS(PaysR,AK11,VpaysR,\"1\")+ COUNTIFS(PaysV,AK11,VpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK11,NpaysR,\"1\")+ COUNTIFS(PaysV,AK11,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK11,DpaysR,\"1\")+ COUNTIFS(PaysV,AK11,DpaysV,\"1\")","v":0},{"$f":"SUMIFS(BpaysR,PaysR,AK11)+SUMIFS(BpaysV,PaysV,AK11)","v":4},{"$f":"SUMIFS(BpaysV,PaysR,AK11)+SUMIFS(BpaysR,PaysV,AK11)","v":1},{"$f":"AR11-AS11","v":3},{"$f":"IF(AND(AV11<>\"\",COUNTIF(AW11:AZ11,AV11)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN11:AN14,AN11)=2,IF(AN11=AN12,AI12,IF(AN11=AN13,AI13,IF(AN11=AN14,AI14,\"\"))),\"\")","v":""},null,{"$f":"IF($CI$10>$CJ$10,2,\"\")","v":2},{"$f":"IF($CI$13>$CJ$13,3,\"\")","v":3},{"$f":"IF($CJ$14>$CI$14,4,\"\")","v":""},{"$f":"SUM(BD11:BG11)","v":0},{"$f":"IF(COUNTIF(AN11:AN14,AN11)=3,IF(AN11=AN12,AI12,AI13),\"\")","v":""},{"$f":"IF(COUNTIF(AN11:AN14,AN11)=3,IF(AN11=AN14,AI14,AI13),\"\")","v":""},null,{"$f":"IF(COUNTIF(BB11:BC11,BE10)=1,1000*($CI$10-$CJ$10)+10*$CI$10,\"\")","v":""},{"$f":"IF(COUNTIF(BB11:BC11,BF10)=1,1000*($CI$12-$CJ$12)+10*$CI$12,\"\")","v":""},{"$f":"IF(COUNTIF(BB11:BC11,BG10)=1,1000*($CJ$14-$CI$14)+10*$CJ$14,\"\")","v":""},{"$f":"AK11","v":"France"},null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42532,0.625,1,1,0,0,"Albanie",0,1,"Suisse"]
[3,"2016-06-11","18:00:00",1,1,0,0,"Pays de Galles",2,1,"Slovaquie",{"$f":"Resultats!J8","v":2.6511111111111112},{"$f":"Resultats!K8","v":2.9833333333333334},{"$f":"Resultats!L8","v":2.8888888888888884},1,0,0,1,null,null,null,null,null,2,{"$f":"VLOOKUP(X12,AJ11:AT14,2,FALSE)","v":"Suisse"},{"$f":"(3*AB12)+AC12","v":5},{"$f":"SUM(AB12:AD12)","v":3},{"$f":"VLOOKUP(X12,AJ11:AT14,6,FALSE)","v":1},{"$f":"VLOOKUP(X12,AJ11:AT14,7,FALSE)","v":2},{"$f":"VLOOKUP(X12,AJ11:AT14,8,FALSE)","v":0},{"$f":"VLOOKUP(X12,AJ11:AT14,9,FALSE)","v":2},{"$f":"VLOOKUP(X12,AJ11:AT14,10,FALSE)","v":1},{"$f":"AE12-AF12","v":1},null,2,{"$f":"RANK(AL12,AL11:AL14)","v":4},{"$f":"K10","v":"Roumanie"},{"$f":"(AN12*1000000000)+((AU12+BA12)*100000)+(AT12*1000)+(AR12*10)-AI12","v":999998018},{"$f":"O10+D12+D15","v":3},{"$f":"(3*AO12)+AP12","v":1},{"$f":"COUNTIFS(PaysR,AK12,VpaysR,\"1\")+ COUNTIFS(PaysV,AK12,VpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK12,NpaysR,\"1\")+ COUNTIFS(PaysV,AK12,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK12,DpaysR,\"1\")+ COUNTIFS(PaysV,AK12,DpaysV,\"1\")","v":2},{"$f":"SUMIFS(BpaysR,PaysR,AK12)+SUMIFS(BpaysV,PaysV,AK12)","v":2},{"$f":"SUMIFS(BpaysV,PaysR,AK12)+SUMIFS(BpaysR,PaysV,AK12)","v":4},{"$f":"AR12-AS12","v":-2},{"$f":"IF(AND(AV12<>\"\",COUNTIF(AW12:AZ12,AV12)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN11:AN14,AN12)=2,IF(AN12=AN11,AI11,IF(AN12=AN13,AI13,IF(AN12=AN14,AI14,\"\"))),\"\")","v":""},{"$f":"IF($CJ$10>$CI$10,1,\"\")","v":""},null,{"$f":"IF($CI$15>$CJ$15,3,\"\")","v":""},{"$f":"IF($CI$12>$CJ$12,4,\"\")","v":""},{"$f":"SUM(BD12:BG12)","v":0},{"$f":"IF(COUNTIF(AN11:AN14,AN12)=3,IF(AN12=AN11,AI11,AI13),\"\")","v":""},{"$f":"IF(COUNTIF(AN11:AN14,AN12)=3,IF(AN12=AN14,AI14,AI13),\"\")","v":""},{"$f":"IF(COUNTIF(BB12:BC12,BD10)=1,1000*($CJ$10-$CI$10)+10*$CJ$10,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB12:BC12,BF10)=1,1000*($CI$15-$CJ$15)+10*$CI$15,\"\")","v":""},{"$f":"IF(COUNTIF(BB12:BC12,BG10)=1,1000*($CJ$13-$CI$13)+10*$CJ$13,\"\")","v":""},{"$f":"AK12","v":"Roumanie"},null,1.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42536,0.75,1,1,0,0,"Roumanie",1,1,"Suisse"]
[4,"2016-06-11","21:00:00",1,0,1,0,"Angleterre",1,1,"Russie",{"$f":"Resultats!J9","v":1.8755555555555554},{"$f":"Resultats!K9","v":3.3000000000000003},{"$f":"Resultats!L9","v":4.4922222222222228},1,0,1,0,null,null,null,null,null,3,{"$f":"VLOOKUP(X13,AJ11:AT14,2,FALSE)","v":"Albanie"},{"$f":"(3*AB13)+AC13","v":3},{"$f":"SUM(AB13:AD13)","v":3},{"$f":"VLOOKUP(X13,AJ11:AT14,6,FALSE)","v":1},{"$f":"VLOOKUP(X13,AJ11:AT14,7,FALSE)","v":0},{"$f":"VLOOKUP(X13,AJ11:AT14,8,FALSE)","v":2},{"$f":"VLOOKUP(X13,AJ11:AT14,9,FALSE)","v":1},{"$f":"VLOOKUP(X13,AJ11:AT14,10,FALSE)","v":3},{"$f":"AE13-AF13","v":-2},null,3,{"$f":"RANK(AL13,AL11:AL14)","v":3},{"$f":"H11","v":"Albanie"},2999998007,{"$f":"D11+O13+O15","v":3},{"$f":"(3*AO13)+AP13","v":3},{"$f":"COUNTIFS(PaysR,AK13,VpaysR,\"1\")+ COUNTIFS(PaysV,AK13,VpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK13,NpaysR,\"1\")+ COUNTIFS(PaysV,AK13,NpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK13,DpaysR,\"1\")+ COUNTIFS(PaysV,AK13,DpaysV,\"1\")","v":2},{"$f":"SUMIFS(BpaysR,PaysR,AK13)+SUMIFS(BpaysV,PaysV,AK13)","v":1},{"$f":"SUMIFS(BpaysV,PaysR,AK13)+SUMIFS(BpaysR,PaysV,AK13)","v":3},{"$f":"AR13-AS13","v":-2},0,{"$f":"IF(COUNTIF(AN11:AN14,AN13)=2,IF(AN13=AN11,AI11,IF(AN13=AN12,AI12,IF(AN13=AN14,AI14,\"\"))),\"\")","v":""},{"$f":"IF($CJ$13>$CI$13,1,\"\")","v":""},{"$f":"IF($CJ$15>$CI$15,2,\"\")","v":2},null,{"$f":"IF($CI$11>$CJ$11,4,\"\")","v":""},{"$f":"SUM(BD13:BG13)","v":0},{"$f":"IF(COUNTIF(AN11:AN14,AN13)=3,IF(AN13=AN11,AI11,AI12),\"\")","v":""},{"$f":"IF(COUNTIF(AN11:AN14,AN13)=3,IF(AN13=AN14,AI14,AI12),\"\")","v":""},{"$f":"IF(COUNTIF(BB13:BC13,BD10)=1,1000*($CJ$12-$CI$12)+10*$CJ$12,\"\")","v":""},{"$f":"IF(COUNTIF(BB13:BC13,BE10)=1,1000*($CJ$15-$CI$15)+10*$CJ$15,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB13:BC13,BG10)=1,1000*($CI$11-$CJ$11)+10*$CI$11,\"\")","v":""},{"$f":"AK13","v":"Albanie"},null,1.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42536,0.875,1,0,1,0,"France",2,0,"Albanie"]
[5,"2016-06-12","15:00:00",1,0,0,1,"Turquie",0,1,"Croatie",{"$f":"Resultats!J10","v":3.5333333333333337},{"$f":"Resultats!K10","v":3.1722222222222225},{"$f":"Resultats!L10","v":2.1666666666666665},1,1,0,0,null,null,null,null,null,4,{"$f":"VLOOKUP(X14,AJ11:AT14,2,FALSE)","v":"Roumanie"},{"$f":"(3*AB14)+AC14","v":1},{"$f":"SUM(AB14:AD14)","v":3},{"$f":"VLOOKUP(X14,AJ11:AT14,6,FALSE)","v":0},{"$f":"VLOOKUP(X14,AJ11:AT14,7,FALSE)","v":1},{"$f":"VLOOKUP(X14,AJ11:AT14,8,FALSE)","v":2},{"$f":"VLOOKUP(X14,AJ11:AT14,9,FALSE)","v":2},{"$f":"VLOOKUP(X14,AJ11:AT14,10,FALSE)","v":4},{"$f":"AE14-AF14","v":-2},null,4,{"$f":"RANK(AL14,AL11:AL14)","v":2},{"$f":"K11","v":"Suisse"},5000001016,{"$f":"O11+O12+D14","v":3},{"$f":"(3*AO14)+AP14","v":5},{"$f":"COUNTIFS(PaysR,AK14,VpaysR,\"1\")+ COUNTIFS(PaysV,AK14,VpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK14,NpaysR,\"1\")+ COUNTIFS(PaysV,AK14,NpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK14,DpaysR,\"1\")+ COUNTIFS(PaysV,AK14,DpaysV,\"1\")","v":0},{"$f":"SUMIFS(BpaysR,PaysR,AK14)+SUMIFS(BpaysV,PaysV,AK14)","v":2},{"$f":"SUMIFS(BpaysV,PaysR,AK14)+SUMIFS(BpaysR,PaysV,AK14)","v":1},{"$f":"AR14-AS14","v":1},0,{"$f":"IF(COUNTIF(AN11:AN14,AN14)=2,IF(AN14=AN11,AI11,IF(AN14=AN12,AI12,IF(AN14=AN13,AI13,\"\"))),\"\")","v":""},{"$f":"IF($CI$14>$CJ$14,1,\"\")","v":""},{"$f":"IF($CJ$12>$CI$12,2,\"\")","v":""},{"$f":"IF($CJ$11>$CI$11,3,\"\")","v":3},null,{"$f":"SUM(BD14:BG14)","v":0},{"$f":"IF(COUNTIF(AN11:AN14,AN14)=3,IF(AN14=AN11,AI11,AI12),\"\")","v":""},{"$f":"IF(COUNTIF(AN11:AN14,AN14)=3,IF(AN14=AN13,AI13,AI12),\"\")","v":""},{"$f":"IF(COUNTIF(BB14:BC14,BD10)=1,1000*($CI$14-$CJ$14)+10*$CI$14,\"\")","v":""},{"$f":"IF(COUNTIF(BB14:BC14,BE10)=1,1000*($CI$13-$CJ$13)+10*$CI$13,\"\")","v":""},{"$f":"IF(COUNTIF(BB14:BC14,BF10)=1,1000*($CJ$11-$CI$11)+10*$CJ$11,\"\")","v":""},null,{"$f":"AK14","v":"Suisse"},null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42540,0.875,1,1,0,0,"Suisse",0,0,"France"]
[6,"2016-06-12","18:00:00",1,1,0,0,"Pologne",1,0,"Irlande du Nord",{"$f":"Resultats!J11","v":1.67},{"$f":"Resultats!K11","v":3.5166666666666666},{"$f":"Resultats!L11","v":5.7111111111111112},1,0,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42540,0.875,1,1,0,0,"Roumanie",0,1,"Albanie"]
[7,"2016-06-12","21:00:00",1,1,0,0,"Allemagne",2,0,"Ukraine",{"$f":"Resultats!J12","v":1.5088888888888892},{"$f":"Resultats!K12","v":4.1111111111111107},{"$f":"Resultats!L12","v":6.9444444444444446},{"$f":"IF(AND(I16<>\"\",J16<>\"\"),1,0)","v":1},0,0,1,null,null,null,null,null,null,"Poule B","PTS","J","G","N","P","B+","B-","Diff",null,null,"Class",null,"PT/Class","J","PTS","G","N","P","B+","B-","Diff","Bonus","Egalité",1,2,3,4,"Bonus","Egalite 1","Egalite 2",1,2,3,4,"COTES QUALIF 8ème"]
[8,"2016-06-13","15:00:00",1,1,0,0,"Espagne",1,0,"Rép. Tchèque",{"$f":"Resultats!J13","v":1.45},{"$f":"Resultats!K13","v":4.0444444444444443},{"$f":"Resultats!L13","v":7.8277777777777784},1,0,0,1,null,null,null,null,null,1,{"$f":"VLOOKUP(X17,AJ17:AT20,2,FALSE)","v":"Pays de Galles"},{"$f":"(3*AB17)+AC17","v":6},{"$f":"SUM(AB17:AD17)","v":3},{"$f":"VLOOKUP(X17,AJ17:AT20,6,FALSE)","v":2},{"$f":"VLOOKUP(X17,AJ17:AT20,7,FALSE)","v":0},{"$f":"VLOOKUP(X17,AJ17:AT20,8,FALSE)","v":1},{"$f":"VLOOKUP(X17,AJ17:AT20,9,FALSE)","v":6},{"$f":"VLOOKUP(X17,AJ17:AT20,10,FALSE)","v":3},{"$f":"AE17-AF17","v":3},null,1,{"$f":"RANK(AL17,AL17:AL20)","v":2},{"$f":"H13","v":"Angleterre"},{"$f":"(AN17*1000000000)+((AU17+BA17)*100000)+(AT17*1000)+(AR17*100)-AI17","v":5000001299},{"$f":"D16+D19+O20","v":3},{"$f":"(3*AO17)+AP17","v":5},{"$f":"COUNTIFS(PaysR,AK17,VpaysR,\"1\")+ COUNTIFS(PaysV,AK17,VpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK17,NpaysR,\"1\")+ COUNTIFS(PaysV,AK17,NpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK17,DpaysR,\"1\")+ COUNTIFS(PaysV,AK17,DpaysV,\"1\")","v":0},{"$f":"SUMIFS(BpaysR,PaysR,AK17)+SUMIFS(BpaysV,PaysV,AK17)","v":3},{"$f":"SUMIFS(BpaysV,PaysR,AK17)+SUMIFS(BpaysR,PaysV,AK17)","v":2},{"$f":"AR17-AS17","v":1},{"$f":"IF(AND(AV17<>\"\",COUNTIF(AW17:AZ17,AV17)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN17:AN20,AN17)=2,IF(AN17=AN18,AI18,IF(AN17=AN19,AI19,IF(AN17=AN20,AI20,\"\"))),\"\")","v":""},null,{"$f":"IF($CI$21>$CJ$21,2,\"\")","v":""},{"$f":"IF($CI$24>$CJ$24,3,\"\")","v":3},{"$f":"IF($CJ$25>$CI$25,4,\"\")","v":""},{"$f":"SUM(BD17:BG17)","v":0},{"$f":"IF(COUNTIF(AN17:AN20,AN17)=3,IF(AN17=AN18,AI18,AI19),\"\")","v":""},{"$f":"IF(COUNTIF(AN17:AN20,AN17)=3,IF(AN17=AN20,AI20,AI19),\"\")","v":""},null,{"$f":"IF(COUNTIF(BB17:BC17,BE16)=1,1000*($CI$21-$CJ$21)+10*$CI$21,\"\")","v":""},{"$f":"IF(COUNTIF(BB17:BC17,BF16)=1,1000*($CI$23-$CJ$23)+10*$CI$23,\"\")","v":""},{"$f":"IF(COUNTIF(BB17:BC17,BG16)=1,1000*($CJ$25-$CI$25)+10*$CJ$25,\"\")","v":""},{"$f":"AK17","v":"Angleterre"},null,1]
[9,"2016-06-13","18:00:00",1,0,1,0,"Irlande",1,1,"Suède",{"$f":"Resultats!J14","v":3.1722222222222225},{"$f":"Resultats!K14","v":3.0444444444444452},{"$f":"Resultats!L14","v":2.4288888888888889},1,0,1,0,null,null,null,null,null,2,{"$f":"VLOOKUP(X18,AJ17:AT20,2,FALSE)","v":"Angleterre"},{"$f":"(3*AB18)+AC18","v":5},{"$f":"SUM(AB18:AD18)","v":3},{"$f":"VLOOKUP(X18,AJ17:AT20,6,FALSE)","v":1},{"$f":"VLOOKUP(X18,AJ17:AT20,7,FALSE)","v":2},{"$f":"VLOOKUP(X18,AJ17:AT20,8,FALSE)","v":0},{"$f":"VLOOKUP(X18,AJ17:AT20,9,FALSE)","v":3},{"$f":"VLOOKUP(X18,AJ17:AT20,10,FALSE)","v":2},{"$f":"AE18-AF18","v":1},null,2,{"$f":"RANK(AL18,AL17:AL20)","v":4},{"$f":"K13","v":"Russie"},{"$f":"(AN18*1000000000)+((AU18+BA18)*100000)+(AT18*1000)+(AR18*100)-AI18","v":999996198},{"$f":"O16+D18+D21","v":3},{"$f":"(3*AO18)+AP18","v":1},{"$f":"COUNTIFS(PaysR,AK18,VpaysR,\"1\")+ COUNTIFS(PaysV,AK18,VpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK18,NpaysR,\"1\")+ COUNTIFS(PaysV,AK18,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK18,DpaysR,\"1\")+ COUNTIFS(PaysV,AK18,DpaysV,\"1\")","v":2},{"$f":"SUMIFS(BpaysR,PaysR,AK18)+SUMIFS(BpaysV,PaysV,AK18)","v":2},{"$f":"SUMIFS(BpaysV,PaysR,AK18)+SUMIFS(BpaysR,PaysV,AK18)","v":6},{"$f":"AR18-AS18","v":-4},{"$f":"IF(AND(AV18<>\"\",COUNTIF(AW18:AZ18,AV18)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN17:AN20,AN18)=2,IF(AN18=AN17,AI17,IF(AN18=AN19,AI19,IF(AN18=AN20,AI20,\"\"))),\"\")","v":""},{"$f":"IF($CJ$21>$CI$21,1,\"\")","v":""},null,{"$f":"IF($CI$26>$CJ$26,3,\"\")","v":""},{"$f":"IF($CI$23>$CJ$23,4,\"\")","v":""},{"$f":"SUM(BD18:BG18)","v":0},{"$f":"IF(COUNTIF(AN17:AN20,AN18)=3,IF(AN18=AN17,AI17,AI19),\"\")","v":""},{"$f":"IF(COUNTIF(AN17:AN20,AN18)=3,IF(AN18=AN20,AI20,AI19),\"\")","v":""},{"$f":"IF(COUNTIF(BB18:BC18,BD16)=1,1000*($CJ$21-$CI$21)+10*$CJ$21,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB18:BC18,BF16)=1,1000*($CI$26-$CJ$26)+10*$CI$26,\"\")","v":""},{"$f":"IF(COUNTIF(BB18:BC18,BG16)=1,1000*($CJ$24-$CI$24)+10*$CJ$24,\"\")","v":""},{"$f":"AK18","v":"Russie"},null,1.4]
[10,"2016-06-13","21:00:00",1,0,0,1,"Belgique",0,2,"Italie",{"$f":"Resultats!J15","v":2.4988888888888892},{"$f":"Resultats!K15","v":3.0555555555555562},{"$f":"Resultats!L15","v":3.0222222222222226},1,1,0,0,null,null,null,null,null,3,{"$f":"VLOOKUP(X19,AJ17:AT20,2,FALSE)","v":"Slovaquie"},{"$f":"(3*AB19)+AC19","v":4},{"$f":"SUM(AB19:AD19)","v":3},{"$f":"VLOOKUP(X19,AJ17:AT20,6,FALSE)","v":1},{"$f":"VLOOKUP(X19,AJ17:AT20,7,FALSE)","v":1},{"$f":"VLOOKUP(X19,AJ17:AT20,8,FALSE)","v":1},{"$f":"VLOOKUP(X19,AJ17:AT20,9,FALSE)","v":3},{"$f":"VLOOKUP(X19,AJ17:AT20,10,FALSE)","v":3},{"$f":"AE19-AF19","v":0},null,3,{"$f":"RANK(AL19,AL17:AL20)","v":1},{"$f":"H12","v":"Pays de Galles"},{"$f":"(AN19*1000000000)+((AU19+BA19)*100000)+(AT19*1000)+(AR19*100)-AI19","v":6000003597},{"$f":"D17+O19+O21","v":3},{"$f":"(3*AO19)+AP19","v":6},{"$f":"COUNTIFS(PaysR,AK19,VpaysR,\"1\")+ COUNTIFS(PaysV,AK19,VpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK19,NpaysR,\"1\")+ COUNTIFS(PaysV,AK19,NpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK19,DpaysR,\"1\")+ COUNTIFS(PaysV,AK19,DpaysV,\"1\")","v":1},{"$f":"SUMIFS(BpaysR,PaysR,AK19)+SUMIFS(BpaysV,PaysV,AK19)","v":6},{"$f":"SUMIFS(BpaysV,PaysR,AK19)+SUMIFS(BpaysR,PaysV,AK19)","v":3},{"$f":"AR19-AS19","v":3},{"$f":"IF(AND(AV19<>\"\",COUNTIF(AW19:AZ19,AV19)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN17:AN20,AN19)=2,IF(AN19=AN17,AI17,IF(AN19=AN18,AI18,IF(AN19=AN20,AI20,\"\"))),\"\")","v":""},{"$f":"IF($CJ$24>$CI$24,1,\"\")","v":""},{"$f":"IF($CJ$26>$CI$26,2,\"\")","v":2},null,{"$f":"IF($CI$22>$CJ$22,4,\"\")","v":4},{"$f":"SUM(BD19:BG19)","v":0},{"$f":"IF(COUNTIF(AN17:AN20,AN19)=3,IF(AN19=AN17,AI17,AI18),\"\")","v":""},{"$f":"IF(COUNTIF(AN17:AN20,AN19)=3,IF(AN19=AN20,AI20,AI18),\"\")","v":""},{"$f":"IF(COUNTIF(BB19:BC19,BD16)=1,1000*($CJ$23-$CI$23)+10*$CJ$23,\"\")","v":""},{"$f":"IF(COUNTIF(BB19:BC19,BE16)=1,1000*($CJ$26-$CI$26)+10*$CJ$26,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB19:BC19,BG16)=1,1000*($CI$22-$CJ$22)+10*$CI$22,\"\")","v":""},{"$f":"AK19","v":"Pays de Galles"},null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GROUPE B"]
[11,"2016-06-14","18:00:00",1,0,0,1,"Autriche",0,2,"Hongrie",{"$f":"Resultats!J16","v":1.7055555555555557},{"$f":"Resultats!K16","v":3.5000000000000004},{"$f":"Resultats!L16","v":5.366666666666668},1,1,0,0,null,null,null,null,null,4,{"$f":"VLOOKUP(X20,AJ17:AT20,2,FALSE)","v":"Russie"},{"$f":"(3*AB20)+AC20","v":1},{"$f":"SUM(AB20:AD20)","v":3},{"$f":"VLOOKUP(X20,AJ17:AT20,6,FALSE)","v":0},{"$f":"VLOOKUP(X20,AJ17:AT20,7,FALSE)","v":1},{"$f":"VLOOKUP(X20,AJ17:AT20,8,FALSE)","v":2},{"$f":"VLOOKUP(X20,AJ17:AT20,9,FALSE)","v":2},{"$f":"VLOOKUP(X20,AJ17:AT20,10,FALSE)","v":6},{"$f":"AE20-AF20","v":-4},null,4,{"$f":"RANK(AL20,AL17:AL20)","v":3},{"$f":"K12","v":"Slovaquie"},{"$f":"(AN20*1000000000)+((AU20+BA20)*100000)+(AT20*1000)+(AR20*100)-AI20","v":4000000296},{"$f":"O17+O18+D20","v":3},{"$f":"(3*AO20)+AP20","v":4},{"$f":"COUNTIFS(PaysR,AK20,VpaysR,\"1\")+ COUNTIFS(PaysV,AK20,VpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK20,NpaysR,\"1\")+ COUNTIFS(PaysV,AK20,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK20,DpaysR,\"1\")+ COUNTIFS(PaysV,AK20,DpaysV,\"1\")","v":1},{"$f":"SUMIFS(BpaysR,PaysR,AK20)+SUMIFS(BpaysV,PaysV,AK20)","v":3},{"$f":"SUMIFS(BpaysV,PaysR,AK20)+SUMIFS(BpaysR,PaysV,AK20)","v":3},{"$f":"AR20-AS20","v":0},0,{"$f":"IF(COUNTIF(AN17:AN20,AN20)=2,IF(AN20=AN17,AI17,IF(AN20=AN18,AI18,IF(AN20=AN19,AI19,\"\"))),\"\")","v":""},{"$f":"IF($CI$25>$CJ$25,1,\"\")","v":""},{"$f":"IF($CJ$23>$CI$23,2,\"\")","v":2},{"$f":"IF($CJ$22>$CI$22,3,\"\")","v":""},null,{"$f":"SUM(BD20:BG20)","v":0},{"$f":"IF(COUNTIF(AN17:AN20,AN20)=3,IF(AN20=AN17,AI17,AI18),\"\")","v":""},{"$f":"IF(COUNTIF(AN17:AN20,AN20)=3,IF(AN20=AN19,AI19,AI18),\"\")","v":""},{"$f":"IF(COUNTIF(BB20:BC20,BD16)=1,1000*($CI$25-$CJ$25)+10*$CI$25,\"\")","v":""},{"$f":"IF(COUNTIF(BB20:BC20,BE16)=1,1000*($CI$24-$CJ$24)+10*$CI$24,\"\")","v":""},{"$f":"IF(COUNTIF(BB20:BC20,BF16)=1,1000*($CJ$22-$CI$22)+10*$CJ$22,\"\")","v":""},null,{"$f":"AK20","v":"Slovaquie"},null,9]
[12,"2016-06-14","21:00:00",1,0,1,0,"Portugal",1,1,"Islande",{"$f":"Resultats!J17","v":1.62},{"$f":"Resultats!K17","v":3.5999999999999996},{"$f":"Resultats!L17","v":6.2},1,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42532,0.875,1,1,0,0,"Angleterre",1,1,"Russie"]
[13,"2016-06-15","15:00:00",1,0,0,1,"Russie",1,2,"Slovaquie",{"$f":"Resultats!J18","v":1.9444444444444444},{"$f":"Resultats!K18","v":2},{"$f":"Resultats!L18","v":3},{"$f":"IF(AND(I22<>\"\",J22<>\"\"),1,0)","v":1},1,0,0,null,null,null,null,null,null,"Poule C","PTS","J","G","N","P","B+","B-","Diff",null,null,"Class",null,"PT/Class","J","PTS","G","N","P","B+","B-","Diff","Bonus","Egalité",1,2,3,4,"Bonus","Egalite 1","Egalite 2",1,2,3,4,"COTES QUALIF 8ème",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42532,0.75,1,0,0,1,"Pays de Galles",2,1,"Slovaquie"]
[14,"2016-06-15","18:00:00",1,0,1,0,"Roumanie",1,1,"Suisse",{"$f":"Resultats!J19","v":3.6160493827160494},{"$f":"Resultats!K19","v":3.219753086419753},{"$f":"Resultats!L19","v":2.2498765432098766},1,0,1,0,null,null,null,null,null,1,{"$f":"VLOOKUP(X23,AJ23:AT26,2,FALSE)","v":"Allemagne"},{"$f":"(3*AB23)+AC23","v":7},{"$f":"SUM(AB23:AD23)","v":3},{"$f":"VLOOKUP(X23,AJ23:AT26,6,FALSE)","v":2},{"$f":"VLOOKUP(X23,AJ23:AT26,7,FALSE)","v":1},{"$f":"VLOOKUP(X23,AJ23:AT26,8,FALSE)","v":0},{"$f":"VLOOKUP(X23,AJ23:AT26,9,FALSE)","v":3},{"$f":"VLOOKUP(X23,AJ23:AT26,10,FALSE)","v":0},{"$f":"AE23-AF23","v":3},null,1,{"$f":"RANK(AL23,AL23:AL26)","v":1},{"$f":"H16","v":"Allemagne"},{"$f":"(AN23*1000000000)+((AU23+BA23)*100000)+(AT23*1000)+(AR23*10)-AI23","v":7000003029},{"$f":"D22+D25+O26","v":3},{"$f":"(3*AO23)+AP23","v":7},{"$f":"COUNTIFS(PaysR,AK23,VpaysR,\"1\")+ COUNTIFS(PaysV,AK23,VpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK23,NpaysR,\"1\")+ COUNTIFS(PaysV,AK23,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK23,DpaysR,\"1\")+ COUNTIFS(PaysV,AK23,DpaysV,\"1\")","v":0},{"$f":"SUMIFS(BpaysR,PaysR,AK23)+SUMIFS(BpaysV,PaysV,AK23)","v":3},{"$f":"SUMIFS(BpaysV,PaysR,AK23)+SUMIFS(BpaysR,PaysV,AK23)","v":0},{"$f":"AR23-AS23","v":3},{"$f":"IF(AND(AV23<>\"\",COUNTIF(AW23:AZ23,AV23)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN23:AN26,AN23)=2,IF(AN23=AN24,AI24,IF(AN23=AN25,AI25,IF(AN23=AN26,AI26,\"\"))),\"\")","v":3},null,{"$f":"IF($CI$32>$CJ$32,2,\"\")","v":2},{"$f":"IF($CI$35>$CJ$35,3,\"\")","v":""},{"$f":"IF($CJ$36>$CI$36,4,\"\")","v":4},{"$f":"SUM(BD23:BG23)","v":0},{"$f":"IF(COUNTIF(AN23:AN26,AN23)=3,IF(AN23=AN24,AI24,AI25),\"\")","v":""},{"$f":"IF(COUNTIF(AN23:AN26,AN23)=3,IF(AN23=AN26,AI26,AI25),\"\")","v":""},null,{"$f":"IF(COUNTIF(BB23:BC23,BE22)=1,1000*($CI$32-$CJ$32)+10*$CI$32,\"\")","v":""},{"$f":"IF(COUNTIF(BB23:BC23,BF22)=1,1000*($CI$35-$CJ$35)+10*$CI$35,\"\")","v":""},{"$f":"IF(COUNTIF(BB23:BC23,BG22)=1,1000*($CJ$36-$CI$36)+10*$CJ$36,\"\")","v":""},{"$f":"AK23","v":"Allemagne"},null,1.1000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42536,0.625,1,0,1,0,"Russie",1,2,"Slovaquie"]
[15,"2016-06-15","21:00:00",1,1,0,0,"France",2,0,"Albanie",{"$f":"Resultats!J20","v":1.4551165980795608},{"$f":"Resultats!K20","v":2},{"$f":"Resultats!L20","v":3},1,0,0,1,null,null,null,null,null,2,{"$f":"VLOOKUP(X24,AJ23:AT26,2,FALSE)","v":"Pologne"},{"$f":"(3*AB24)+AC24","v":7},{"$f":"SUM(AB24:AD24)","v":3},{"$f":"VLOOKUP(X24,AJ23:AT26,6,FALSE)","v":2},{"$f":"VLOOKUP(X24,AJ23:AT26,7,FALSE)","v":1},{"$f":"VLOOKUP(X24,AJ23:AT26,8,FALSE)","v":0},{"$f":"VLOOKUP(X24,AJ23:AT26,9,FALSE)","v":2},{"$f":"VLOOKUP(X24,AJ23:AT26,10,FALSE)","v":0},{"$f":"AE24-AF24","v":2},null,2,{"$f":"RANK(AL24,AL23:AL26)","v":4},{"$f":"K16","v":"Ukraine"},{"$f":"(AN24*1000000000)+((AU24+BA24)*100000)+(AT24*1000)+(AR24*10)-AI24","v":-5002},{"$f":"O22+D24+D27","v":3},{"$f":"(3*AO24)+AP24","v":0},{"$f":"COUNTIFS(PaysR,AK24,VpaysR,\"1\")+ COUNTIFS(PaysV,AK24,VpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK24,NpaysR,\"1\")+ COUNTIFS(PaysV,AK24,NpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK24,DpaysR,\"1\")+ COUNTIFS(PaysV,AK24,DpaysV,\"1\")","v":3},{"$f":"SUMIFS(BpaysR,PaysR,AK24)+SUMIFS(BpaysV,PaysV,AK24)","v":0},{"$f":"SUMIFS(BpaysV,PaysR,AK24)+SUMIFS(BpaysR,PaysV,AK24)","v":5},{"$f":"AR24-AS24","v":-5},{"$f":"IF(AND(AV24<>\"\",COUNTIF(AW24:AZ24,AV24)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN23:AN26,AN24)=2,IF(AN24=AN23,AI23,IF(AN24=AN25,AI25,IF(AN24=AN26,AI26,\"\"))),\"\")","v":""},{"$f":"IF($CJ$32>$CI$32,1,\"\")","v":""},null,{"$f":"IF($CI$37>$CJ$37,3,\"\")","v":""},{"$f":"IF($CI$34>$CJ$34,4,\"\")","v":""},{"$f":"SUM(BD24:BG24)","v":0},{"$f":"IF(COUNTIF(AN23:AN26,AN24)=3,IF(AN24=AN23,AI23,AI25),\"\")","v":""},{"$f":"IF(COUNTIF(AN23:AN26,AN24)=3,IF(AN24=AN26,AI26,AI25),\"\")","v":""},{"$f":"IF(COUNTIF(BB24:BC24,BD22)=1,1000*($CJ$32-$CI$32)+10*$CJ$32,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB24:BC24,BF22)=1,1000*($CI$37-$CJ$37)+10*$CI$37,\"\")","v":""},{"$f":"IF(COUNTIF(BB24:BC24,BG22)=1,1000*($CI$34-$CJ$34)+10*$CI$34,\"\")","v":""},{"$f":"AK24","v":"Ukraine"},null,1.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42537,0.625,1,0,1,0,"Angleterre",2,1,"Pays de Galles"]
[16,"2016-06-16","15:00:00",1,1,0,0,"Angleterre",2,1,"Pays de Galles",{"$f":"Resultats!J19","v":3.6160493827160494},{"$f":"Resultats!K19","v":3.219753086419753},{"$f":"Resultats!L19","v":2.2498765432098766},1,0,0,1,null,null,null,null,null,3,{"$f":"VLOOKUP(X25,AJ23:AT26,2,FALSE)","v":"Irlande du Nord"},{"$f":"(3*AB25)+AC25","v":3},{"$f":"SUM(AB25:AD25)","v":3},{"$f":"VLOOKUP(X25,AJ23:AT26,6,FALSE)","v":1},{"$f":"VLOOKUP(X25,AJ23:AT26,7,FALSE)","v":0},{"$f":"VLOOKUP(X25,AJ23:AT26,8,FALSE)","v":2},{"$f":"VLOOKUP(X25,AJ23:AT26,9,FALSE)","v":2},{"$f":"VLOOKUP(X25,AJ23:AT26,10,FALSE)","v":2},{"$f":"AE25-AF25","v":0},null,3,{"$f":"RANK(AL25,AL23:AL26)","v":2},{"$f":"H15","v":"Pologne"},{"$f":"(AN25*1000000000)+((AU25+BA25)*100000)+(AT25*1000)+(AR25*10)-AI25","v":7000002017},{"$f":"D23+O25+O27","v":3},{"$f":"(3*AO25)+AP25","v":7},{"$f":"COUNTIFS(PaysR,AK25,VpaysR,\"1\")+ COUNTIFS(PaysV,AK25,VpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK25,NpaysR,\"1\")+ COUNTIFS(PaysV,AK25,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK25,DpaysR,\"1\")+ COUNTIFS(PaysV,AK25,DpaysV,\"1\")","v":0},{"$f":"SUMIFS(BpaysR,PaysR,AK25)+SUMIFS(BpaysV,PaysV,AK25)","v":2},{"$f":"SUMIFS(BpaysV,PaysR,AK25)+SUMIFS(BpaysR,PaysV,AK25)","v":0},{"$f":"AR25-AS25","v":2},0,{"$f":"IF(COUNTIF(AN23:AN26,AN25)=2,IF(AN25=AN23,AI23,IF(AN25=AN24,AI24,IF(AN25=AN26,AI26,\"\"))),\"\")","v":1},{"$f":"IF($CJ$35>$CI$35,1,\"\")","v":""},{"$f":"IF($CJ$37>$CI$37,2,\"\")","v":2},null,{"$f":"IF($CI$33>$CJ$33,4,\"\")","v":4},{"$f":"SUM(BD25:BG25)","v":0},{"$f":"IF(COUNTIF(AN23:AN26,AN25)=3,IF(AN25=AN23,AI23,AI24),\"\")","v":""},{"$f":"IF(COUNTIF(AN23:AN26,AN25)=3,IF(AN25=AN26,AI26,AI24),\"\")","v":""},{"$f":"IF(COUNTIF(BB25:BC25,BD22)=1,1000*($CJ$35-$CI$35)+10*$CJ$35,\"\")","v":""},{"$f":"IF(COUNTIF(BB25:BC25,BE22)=1,1000*($CJ$37-$CI$37)+10*$CJ$37,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB25:BC25,BG22)=1,1000*($CI$33-$CJ$33)+10*$CI$33,\"\")","v":""},{"$f":"AK25","v":"Pologne"},null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42541,0.875,1,0,1,0,"Slovaquie",0,0,"Angleterre"]
[17,"2016-06-16","18:00:00",1,0,0,1,"Ukraine",0,2,"Irlande du Nord",{"$f":"Resultats!J22","v":1.7148779826923402},{"$f":"Resultats!K22","v":2},{"$f":"Resultats!L22","v":3},1,1,0,0,null,null,null,null,null,4,{"$f":"VLOOKUP(X26,AJ23:AT26,2,FALSE)","v":"Ukraine"},{"$f":"(3*AB26)+AC26","v":0},{"$f":"SUM(AB26:AD26)","v":3},{"$f":"VLOOKUP(X26,AJ23:AT26,6,FALSE)","v":0},{"$f":"VLOOKUP(X26,AJ23:AT26,7,FALSE)","v":0},{"$f":"VLOOKUP(X26,AJ23:AT26,8,FALSE)","v":3},{"$f":"VLOOKUP(X26,AJ23:AT26,9,FALSE)","v":0},{"$f":"VLOOKUP(X26,AJ23:AT26,10,FALSE)","v":5},{"$f":"AE26-AF26","v":-5},null,4,{"$f":"RANK(AL26,AL23:AL26)","v":3},{"$f":"K15","v":"Irlande du Nord"},{"$f":"(AN26*1000000000)+((AU26+BA26)*100000)+(AT26*1000)+(AR26*10)-AI26","v":3000000016},{"$f":"O23+O24+D26","v":3},{"$f":"(3*AO26)+AP26","v":3},{"$f":"COUNTIFS(PaysR,AK26,VpaysR,\"1\")+ COUNTIFS(PaysV,AK26,VpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK26,NpaysR,\"1\")+ COUNTIFS(PaysV,AK26,NpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK26,DpaysR,\"1\")+ COUNTIFS(PaysV,AK26,DpaysV,\"1\")","v":2},{"$f":"SUMIFS(BpaysR,PaysR,AK26)+SUMIFS(BpaysV,PaysV,AK26)","v":2},{"$f":"SUMIFS(BpaysV,PaysR,AK26)+SUMIFS(BpaysR,PaysV,AK26)","v":2},{"$f":"AR26-AS26","v":0},0,{"$f":"IF(COUNTIF(AN23:AN26,AN26)=2,IF(AN26=AN23,AI23,IF(AN26=AN24,AI24,IF(AN26=AN25,AI25,\"\"))),\"\")","v":""},{"$f":"IF($CI$36>$CJ$36,1,\"\")","v":""},{"$f":"IF($CJ$34>$CI$34,2,\"\")","v":2},{"$f":"IF($CJ$33>$CI$33,3,\"\")","v":""},null,{"$f":"SUM(BD26:BG26)","v":0},{"$f":"IF(COUNTIF(AN23:AN26,AN26)=3,IF(AN26=AN23,AI23,AI24),\"\")","v":""},{"$f":"IF(COUNTIF(AN23:AN26,AN26)=3,IF(AN26=AN25,AI25,AI24),\"\")","v":""},{"$f":"IF(COUNTIF(BB26:BC26,BD22)=1,1000*($CI$36-$CJ$36)+10*$CI$36,\"\")","v":""},{"$f":"IF(COUNTIF(BB26:BC26,BE22)=1,1000*($CJ$34-$CI$34)+10*$CJ$34,\"\")","v":""},{"$f":"IF(COUNTIF(BB26:BC26,BF22)=1,1000*($CJ$33-$CI$33)+10*$CJ$33,\"\")","v":""},null,{"$f":"AK26","v":"Irlande du Nord"},null,2.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42541,0.875,1,1,0,0,"Russie",0,3,"Pays de Galles"]
[18,"2016-06-16","21:00:00",1,0,1,0,"Allemagne",0,0,"Pologne",{"$f":"Resultats!J23","v":1.5760975536324822},{"$f":"Resultats!K23","v":2},{"$f":"Resultats!L23","v":3},1,0,1,0]
[19,"2016-06-17","15:00:00",1,1,0,0,"Italie",1,0,"Suède",{"$f":"Resultats!J24","v":1.8973441726258313},{"$f":"Resultats!K24","v":2},{"$f":"Resultats!L24","v":3},{"$f":"IF(AND(I28<>\"\",J28<>\"\"),1,0)","v":1},0,0,1,null,null,null,null,null,null,"Poule D","PTS","J","G","N","P","B+","B-","Diff",null,null,"Class",null,"PT/Class","J","PTS","G","N","P","B+","B-","Diff","Bonus","Egalité",1,2,3,4,"Bonus","Egalite 1","Egalite 2",1,2,3,4,"COTES QUALIF 8ème"]
[20,"2016-06-17","18:00:00",1,0,1,0,"Rép. Tchèque",2,2,"Croatie",{"$f":"Resultats!J25","v":3.1663715747362029},{"$f":"Resultats!K25","v":3.2023573073080289},{"$f":"Resultats!L25","v":2.4156584642068326},1,0,1,0,null,null,null,null,null,1,{"$f":"VLOOKUP(X29,AJ29:AT32,2,FALSE)","v":"Croatie"},{"$f":"(3*AB29)+AC29","v":7},{"$f":"SUM(AB29:AD29)","v":3},{"$f":"VLOOKUP(X29,AJ29:AT32,6,FALSE)","v":2},{"$f":"VLOOKUP(X29,AJ29:AT32,7,FALSE)","v":1},{"$f":"VLOOKUP(X29,AJ29:AT32,8,FALSE)","v":0},{"$f":"VLOOKUP(X29,AJ29:AT32,9,FALSE)","v":5},{"$f":"VLOOKUP(X29,AJ29:AT32,10,FALSE)","v":3},{"$f":"AE29-AF29","v":2},null,1,{"$f":"RANK(AL29,AL29:AL32)","v":2},{"$f":"H17","v":"Espagne"},{"$f":"(AN29*1000000000)+((AU29+BA29)*100000)+(AT29*1000)+(AR29*10)-AI29","v":6000003049},{"$f":"D28+D31+O32","v":3},{"$f":"(3*AO29)+AP29","v":6},{"$f":"COUNTIFS(PaysR,AK29,VpaysR,\"1\")+ COUNTIFS(PaysV,AK29,VpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK29,NpaysR,\"1\")+ COUNTIFS(PaysV,AK29,NpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK29,DpaysR,\"1\")+ COUNTIFS(PaysV,AK29,DpaysV,\"1\")","v":1},{"$f":"SUMIFS(BpaysR,PaysR,AK29)+SUMIFS(BpaysV,PaysV,AK29)","v":5},{"$f":"SUMIFS(BpaysV,PaysR,AK29)+SUMIFS(BpaysR,PaysV,AK29)","v":2},{"$f":"AR29-AS29","v":3},{"$f":"IF(AND(AV29<>\"\",COUNTIF(AW29:AZ29,AV29)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN29:AN32,AN29)=2,IF(AN29=AN30,AI30,IF(AN29=AN31,AI31,IF(AN29=AN32,AI32,\"\"))),\"\")","v":""},null,{"$f":"IF($CI$43>$CJ$43,2,\"\")","v":2},{"$f":"IF($CI$46>$CJ$46,3,\"\")","v":3},{"$f":"IF($CJ$47>$CI$47,4,\"\")","v":""},{"$f":"SUM(BD29:BG29)","v":0},{"$f":"IF(COUNTIF(AN29:AN32,AN29)=3,IF(AN29=AN30,AI30,AI31),\"\")","v":""},{"$f":"IF(COUNTIF(AN29:AN32,AN29)=3,IF(AN29=AN32,AI32,AI31),\"\")","v":""},null,{"$f":"IF(COUNTIF(BB29:BC29,BE28)=1,1000*($CI$43-$CJ$43)+10*$CI$43,\"\")","v":""},{"$f":"IF(COUNTIF(BB29:BC29,BF28)=1,1000*($CI$45-$CJ$45)+10*$CI$45,\"\")","v":""},{"$f":"IF(COUNTIF(BB29:BC29,BG28)=1,1000*($CJ$47-$CI$47)+10*$CJ$47,\"\")","v":""},{"$f":"AK29","v":"Espagne"},null,1.3]
[21,"2016-06-17","21:00:00",1,1,0,0,"Espagne",3,0,"Turquie",{"$f":"Resultats!J26","v":1.6918190638595783},{"$f":"Resultats!K26","v":2},{"$f":"Resultats!L26","v":3},{"$f":"IF(AND(I30<>\"\",J30<>\"\"),1,0)","v":1},0,0,1,null,null,null,null,null,2,{"$f":"VLOOKUP(X30,AJ29:AT32,2,FALSE)","v":"Espagne"},{"$f":"(3*AB30)+AC30","v":6},{"$f":"SUM(AB30:AD30)","v":3},{"$f":"VLOOKUP(X30,AJ29:AT32,6,FALSE)","v":2},{"$f":"VLOOKUP(X30,AJ29:AT32,7,FALSE)","v":0},{"$f":"VLOOKUP(X30,AJ29:AT32,8,FALSE)","v":1},{"$f":"VLOOKUP(X30,AJ29:AT32,9,FALSE)","v":5},{"$f":"VLOOKUP(X30,AJ29:AT32,10,FALSE)","v":2},{"$f":"AE30-AF30","v":3},null,2,{"$f":"RANK(AL30,AL29:AL32)","v":4},{"$f":"K17","v":"Rép. Tchèque"},{"$f":"(AN30*1000000000)+((AU30+BA30)*100000)+(AT30*1000)+(AR30*10)-AI30","v":999997018},{"$f":"O28+D30+D33","v":3},{"$f":"(3*AO30)+AP30","v":1},{"$f":"COUNTIFS(PaysR,AK30,VpaysR,\"1\")+ COUNTIFS(PaysV,AK30,VpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK30,NpaysR,\"1\")+ COUNTIFS(PaysV,AK30,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK30,DpaysR,\"1\")+ COUNTIFS(PaysV,AK30,DpaysV,\"1\")","v":2},{"$f":"SUMIFS(BpaysR,PaysR,AK30)+SUMIFS(BpaysV,PaysV,AK30)","v":2},{"$f":"SUMIFS(BpaysV,PaysR,AK30)+SUMIFS(BpaysR,PaysV,AK30)","v":5},{"$f":"AR30-AS30","v":-3},{"$f":"IF(AND(AV30<>\"\",COUNTIF(AW30:AZ30,AV30)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN29:AN32,AN30)=2,IF(AN30=AN29,AI29,IF(AN30=AN31,AI31,IF(AN30=AN32,AI32,\"\"))),\"\")","v":""},{"$f":"IF($CJ$43>$CI$43,1,\"\")","v":""},null,{"$f":"IF($CI$48>$CJ$48,3,\"\")","v":""},{"$f":"IF($CI$45>$CJ$45,4,\"\")","v":""},{"$f":"SUM(BD30:BG30)","v":0},{"$f":"IF(COUNTIF(AN29:AN32,AN30)=3,IF(AN30=AN29,AI29,AI31),\"\")","v":""},{"$f":"IF(COUNTIF(AN29:AN32,AN30)=3,IF(AN30=AN32,AI32,AI31),\"\")","v":""},{"$f":"IF(COUNTIF(BB30:BC30,BD28)=1,1000*($CJ$43-$CI$43)+10*$CJ$43,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB30:BC30,BF28)=1,1000*($CI$48-$CJ$48)+10*$CI$48,\"\")","v":""},{"$f":"IF(COUNTIF(BB30:BC30,BG28)=1,1000*($CJ$46-$CI$46)+10*$CJ$46,\"\")","v":""},{"$f":"AK30","v":"Rép. Tchèque"},null,1.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GROUPE C",null,null,null,null,null,"GROUPE C"]
[22,"2016-06-18","15:00:00",1,1,0,0,"Belgique",3,0,"Irlande",{"$f":"Resultats!J27","v":1.5790910070955089},{"$f":"Resultats!K27","v":2},{"$f":"Resultats!L27","v":3},1,0,0,1,null,null,null,null,null,3,{"$f":"VLOOKUP(X31,AJ29:AT32,2,FALSE)","v":"Turquie"},{"$f":"(3*AB31)+AC31","v":3},{"$f":"SUM(AB31:AD31)","v":3},{"$f":"VLOOKUP(X31,AJ29:AT32,6,FALSE)","v":1},{"$f":"VLOOKUP(X31,AJ29:AT32,7,FALSE)","v":0},{"$f":"VLOOKUP(X31,AJ29:AT32,8,FALSE)","v":2},{"$f":"VLOOKUP(X31,AJ29:AT32,9,FALSE)","v":2},{"$f":"VLOOKUP(X31,AJ29:AT32,10,FALSE)","v":4},{"$f":"AE31-AF31","v":-2},null,3,{"$f":"RANK(AL31,AL29:AL32)","v":3},{"$f":"H14","v":"Turquie"},{"$f":"(AN31*1000000000)+((AU31+BA31)*100000)+(AT31*1000)+(AR31*10)-AI31","v":2999998017},{"$f":"D29+O31+O33","v":3},{"$f":"(3*AO31)+AP31","v":3},{"$f":"COUNTIFS(PaysR,AK31,VpaysR,\"1\")+ COUNTIFS(PaysV,AK31,VpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK31,NpaysR,\"1\")+ COUNTIFS(PaysV,AK31,NpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK31,DpaysR,\"1\")+ COUNTIFS(PaysV,AK31,DpaysV,\"1\")","v":2},{"$f":"SUMIFS(BpaysR,PaysR,AK31)+SUMIFS(BpaysV,PaysV,AK31)","v":2},{"$f":"SUMIFS(BpaysV,PaysR,AK31)+SUMIFS(BpaysR,PaysV,AK31)","v":4},{"$f":"AR31-AS31","v":-2},0,{"$f":"IF(COUNTIF(AN29:AN32,AN31)=2,IF(AN31=AN29,AI29,IF(AN31=AN30,AI30,IF(AN31=AN32,AI32,\"\"))),\"\")","v":""},{"$f":"IF($CJ$46>$CI$46,1,\"\")","v":""},{"$f":"IF($CJ$48>$CI$48,2,\"\")","v":2},null,{"$f":"IF($CI$44>$CJ$44,4,\"\")","v":""},{"$f":"SUM(BD31:BG31)","v":0},{"$f":"IF(COUNTIF(AN29:AN32,AN31)=3,IF(AN31=AN29,AI29,AI30),\"\")","v":""},{"$f":"IF(COUNTIF(AN29:AN32,AN31)=3,IF(AN31=AN32,AI32,AI30),\"\")","v":""},{"$f":"IF(COUNTIF(BB31:BC31,BD28)=1,1000*($CJ$45-$CI$45)+10*$CJ$45,\"\")","v":""},{"$f":"IF(COUNTIF(BB31:BC31,BE28)=1,1000*($CJ$48-$CI$48)+10*$CJ$48,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB31:BC31,BG28)=1,1000*($CI$44-$CJ$44)+10*$CI$44,\"\")","v":""},{"$f":"AK31","v":"Turquie"},null,1.5]
[23,"2016-06-18","18:00:00",1,0,1,0,"Islande",1,1,"Hongrie",{"$f":"Resultats!J28","v":2.2098990007883899},{"$f":"Resultats!K28","v":3.2100855381444555},{"$f":"Resultats!L28","v":3.4576346480990492},1,0,1,0,null,null,null,null,null,4,{"$f":"VLOOKUP(X32,AJ29:AT32,2,FALSE)","v":"Rép. Tchèque"},{"$f":"(3*AB32)+AC32","v":1},{"$f":"SUM(AB32:AD32)","v":3},{"$f":"VLOOKUP(X32,AJ29:AT32,6,FALSE)","v":0},{"$f":"VLOOKUP(X32,AJ29:AT32,7,FALSE)","v":1},{"$f":"VLOOKUP(X32,AJ29:AT32,8,FALSE)","v":2},{"$f":"VLOOKUP(X32,AJ29:AT32,9,FALSE)","v":2},{"$f":"VLOOKUP(X32,AJ29:AT32,10,FALSE)","v":5},{"$f":"AE32-AF32","v":-3},null,4,{"$f":"RANK(AL32,AL29:AL32)","v":1},{"$f":"K14","v":"Croatie"},{"$f":"(AN32*1000000000)+((AU32+BA32)*100000)+(AT32*1000)+(AR32*10)-AI32","v":7000002046},{"$f":"O29+O30+D32","v":3},{"$f":"(3*AO32)+AP32","v":7},{"$f":"COUNTIFS(PaysR,AK32,VpaysR,\"1\")+ COUNTIFS(PaysV,AK32,VpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK32,NpaysR,\"1\")+ COUNTIFS(PaysV,AK32,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK32,DpaysR,\"1\")+ COUNTIFS(PaysV,AK32,DpaysV,\"1\")","v":0},{"$f":"SUMIFS(BpaysR,PaysR,AK32)+SUMIFS(BpaysV,PaysV,AK32)","v":5},{"$f":"SUMIFS(BpaysV,PaysR,AK32)+SUMIFS(BpaysR,PaysV,AK32)","v":3},{"$f":"AR32-AS32","v":2},0,{"$f":"IF(COUNTIF(AN29:AN32,AN32)=2,IF(AN32=AN29,AI29,IF(AN32=AN30,AI30,IF(AN32=AN31,AI31,\"\"))),\"\")","v":""},{"$f":"IF($CI$47>$CJ$47,1,\"\")","v":1},{"$f":"IF($CJ$45>$CI$45,2,\"\")","v":""},{"$f":"IF($CJ$44>$CI$44,3,\"\")","v":3},null,{"$f":"SUM(BD32:BG32)","v":0},{"$f":"IF(COUNTIF(AN29:AN32,AN32)=3,IF(AN32=AN29,AI29,AI30),\"\")","v":""},{"$f":"IF(COUNTIF(AN29:AN32,AN32)=3,IF(AN32=AN31,AI31,AI30),\"\")","v":""},{"$f":"IF(COUNTIF(BB32:BC32,BD28)=1,1000*($CI$47-$CJ$47)+10*$CI$47,\"\")","v":""},{"$f":"IF(COUNTIF(BB32:BC32,BE28)=1,1000*($CI$46-$CJ$46)+10*$CI$46,\"\")","v":""},{"$f":"IF(COUNTIF(BB32:BC32,BF28)=1,1000*($CJ$44-$CI$44)+10*$CJ$44,\"\")","v":""},null,{"$f":"AK32","v":"Croatie"},null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42533,0.875,1,1,0,0,"Allemagne",2,0,"Ukraine"]
[24,"2016-06-18","21:00:00",1,0,1,0,"Portugal",0,0,"Autriche",{"$f":"Resultats!J29","v":2.1455443334209323},{"$f":"Resultats!K29","v":3.2511206153493841},{"$f":"Resultats!L29","v":3.3786260720110053},1,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42533,0.75,1,1,0,0,"Pologne",1,0,"Irlande du Nord"]
[25,"2016-06-19","21:00:00",1,0,1,0,"Suisse",0,0,"France",{"$f":"Resultats!J30","v":3},{"$f":"Resultats!K30","v":2},{"$f":"Resultats!L30","v":1.8755385934816173},{"$f":"IF(AND(I34<>\"\",J34<>\"\"),1,0)","v":1},0,1,0,null,null,null,null,null,null,"Poule E","PTS","J","G","N","P","B+","B-","Diff",null,null,"Class",null,"PT/Class","J","PTS","G","N","P","B+","B-","Diff","Bonus","Egalité",1,2,3,4,"Bonus","Egalite 1","Egalite 2",1,2,3,4,"COTES QUALIF 8ème",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42537,0.75,1,1,0,0,"Ukraine",0,2,"Irlande du Nord"]
[26,"2016-06-19","21:00:00",1,0,0,1,"Roumanie",0,1,"Albanie",{"$f":"Resultats!J31","v":1.969504925935659},{"$f":"Resultats!K31","v":3.3001245128165988},{"$f":"Resultats!L31","v":3.8198473413345564},1,1,0,0,null,null,null,null,null,1,{"$f":"VLOOKUP(X35,AJ35:AT38,2,FALSE)","v":"Italie"},{"$f":"(3*AB35)+AC35","v":6},{"$f":"SUM(AB35:AD35)","v":3},{"$f":"VLOOKUP(X35,AJ35:AT38,6,FALSE)","v":2},{"$f":"VLOOKUP(X35,AJ35:AT38,7,FALSE)","v":0},{"$f":"VLOOKUP(X35,AJ35:AT38,8,FALSE)","v":1},{"$f":"VLOOKUP(X35,AJ35:AT38,9,FALSE)","v":3},{"$f":"VLOOKUP(X35,AJ35:AT38,10,FALSE)","v":1},{"$f":"AE35-AF35","v":2},null,1,{"$f":"RANK(AL35,AL35:AL38)","v":2},{"$f":"H19","v":"Belgique"},{"$f":"(AN35*1000000000)+((AU35+BA35)*100000)+(AT35*1000)+(AR35*10)-AI35","v":6000002039},{"$f":"D34+D37+O38","v":3},{"$f":"(3*AO35)+AP35","v":6},{"$f":"COUNTIFS(PaysR,AK35,VpaysR,\"1\")+ COUNTIFS(PaysV,AK35,VpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK35,NpaysR,\"1\")+ COUNTIFS(PaysV,AK35,NpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK35,DpaysR,\"1\")+ COUNTIFS(PaysV,AK35,DpaysV,\"1\")","v":1},{"$f":"SUMIFS(BpaysR,PaysR,AK35)+SUMIFS(BpaysV,PaysV,AK35)","v":4},{"$f":"SUMIFS(BpaysV,PaysR,AK35)+SUMIFS(BpaysR,PaysV,AK35)","v":2},{"$f":"AR35-AS35","v":2},{"$f":"IF(AND(AV35<>\"\",COUNTIF(AW35:AZ35,AV35)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN35:AN38,AN35)=2,IF(AN35=AN36,AI36,IF(AN35=AN37,AI37,IF(AN35=AN38,AI38,\"\"))),\"\")","v":2},null,{"$f":"IF($CI$54>$CJ$54,2,\"\")","v":""},{"$f":"IF($CI$57>$CJ$57,3,\"\")","v":3},{"$f":"IF($CJ$58>$CI$58,4,\"\")","v":4},{"$f":"SUM(BD35:BG35)","v":0},{"$f":"IF(COUNTIF(AN35:AN38,AN35)=3,IF(AN35=AN36,AI36,AI37),\"\")","v":""},{"$f":"IF(COUNTIF(AN35:AN38,AN35)=3,IF(AN35=AN38,AI38,AI37),\"\")","v":""},null,{"$f":"IF(COUNTIF(BB35:BC35,BE34)=1,1000*($CI$54-$CJ$54)+10*$CI$54,\"\")","v":""},{"$f":"IF(COUNTIF(BB35:BC35,BF34)=1,1000*($CI$56-$CJ$56)+10*$CI$56,\"\")","v":""},{"$f":"IF(COUNTIF(BB35:BC35,BG34)=1,1000*($CJ$58-$CI$58)+10*$CJ$58,\"\")","v":""},{"$f":"AK35","v":"Belgique"},null,1.1000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42537,0.875,1,1,0,0,"Allemagne",0,0,"Pologne"]
[27,"2016-06-20","21:00:00",1,0,1,0,"Slovaquie",0,0,"Angleterre",{"$f":"Resultats!J32","v":3},{"$f":"Resultats!K32","v":2},{"$f":"Resultats!L32","v":1.772043686339279},1,0,1,0,null,null,null,null,null,2,{"$f":"VLOOKUP(X36,AJ35:AT38,2,FALSE)","v":"Belgique"},{"$f":"(3*AB36)+AC36","v":6},{"$f":"SUM(AB36:AD36)","v":3},{"$f":"VLOOKUP(X36,AJ35:AT38,6,FALSE)","v":2},{"$f":"VLOOKUP(X36,AJ35:AT38,7,FALSE)","v":0},{"$f":"VLOOKUP(X36,AJ35:AT38,8,FALSE)","v":1},{"$f":"VLOOKUP(X36,AJ35:AT38,9,FALSE)","v":4},{"$f":"VLOOKUP(X36,AJ35:AT38,10,FALSE)","v":2},{"$f":"AE36-AF36","v":2},null,2,{"$f":"RANK(AL36,AL35:AL38)","v":1},{"$f":"K19","v":"Italie"},{"$f":"(AN36*1000000000)+((AU36+BA36)*100000)+(AT36*1000)+(AR36*10)-AI36","v":6100002028},{"$f":"O34+D36+D39","v":3},{"$f":"(3*AO36)+AP36","v":6},{"$f":"COUNTIFS(PaysR,AK36,VpaysR,\"1\")+ COUNTIFS(PaysV,AK36,VpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK36,NpaysR,\"1\")+ COUNTIFS(PaysV,AK36,NpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK36,DpaysR,\"1\")+ COUNTIFS(PaysV,AK36,DpaysV,\"1\")","v":1},{"$f":"SUMIFS(BpaysR,PaysR,AK36)+SUMIFS(BpaysV,PaysV,AK36)","v":3},{"$f":"SUMIFS(BpaysV,PaysR,AK36)+SUMIFS(BpaysR,PaysV,AK36)","v":1},{"$f":"AR36-AS36","v":2},{"$f":"IF(AND(AV36<>\"\",COUNTIF(AW36:AZ36,AV36)=1),1000,0)","v":1000},{"$f":"IF(COUNTIF(AN35:AN38,AN36)=2,IF(AN36=AN35,AI35,IF(AN36=AN37,AI37,IF(AN36=AN38,AI38,\"\"))),\"\")","v":1},{"$f":"IF($CJ$54>$CI$54,1,\"\")","v":1},null,{"$f":"IF($CI$59>$CJ$59,3,\"\")","v":""},{"$f":"IF($CI$56>$CJ$56,4,\"\")","v":4},{"$f":"SUM(BD36:BG36)","v":0},{"$f":"IF(COUNTIF(AN35:AN38,AN36)=3,IF(AN36=AN35,AI35,AI37),\"\")","v":""},{"$f":"IF(COUNTIF(AN35:AN38,AN36)=3,IF(AN36=AN38,AI38,AI37),\"\")","v":""},{"$f":"IF(COUNTIF(BB36:BC36,BD34)=1,1000*($CJ$54-$CI$54)+10*$CJ$54,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB36:BC36,BF34)=1,1000*($CI$59-$CJ$59)+10*$CI$59,\"\")","v":""},{"$f":"IF(COUNTIF(BB36:BC36,BG34)=1,1000*($CJ$57-$CI$57)+10*$CJ$57,\"\")","v":""},{"$f":"AK36","v":"Italie"},null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42542,0.75,1,0,0,1,"Irlande du Nord",0,1,"Allemagne"]
[28,"2016-06-20","21:00:00",1,0,0,1,"Russie",0,3,"Pays de Galles",{"$f":"Resultats!J33","v":2.4707346287152547},{"$f":"Resultats!K33","v":3.2561743767014391},{"$f":"Resultats!L33","v":3.2083931770535128},1,1,0,0,null,null,null,null,null,3,{"$f":"VLOOKUP(X37,AJ35:AT38,2,FALSE)","v":"Irlande"},{"$f":"(3*AB37)+AC37","v":4},{"$f":"SUM(AB37:AD37)","v":3},{"$f":"VLOOKUP(X37,AJ35:AT38,6,FALSE)","v":1},{"$f":"VLOOKUP(X37,AJ35:AT38,7,FALSE)","v":1},{"$f":"VLOOKUP(X37,AJ35:AT38,8,FALSE)","v":1},{"$f":"VLOOKUP(X37,AJ35:AT38,9,FALSE)","v":2},{"$f":"VLOOKUP(X37,AJ35:AT38,10,FALSE)","v":4},{"$f":"AE37-AF37","v":-2},null,3,{"$f":"RANK(AL37,AL35:AL38)","v":3},{"$f":"H18","v":"Irlande"},{"$f":"(AN37*1000000000)+((AU37+BA37)*100000)+(AT37*1000)+(AR37*10)-AI37","v":3999998017},{"$f":"D35+O37+O39","v":3},{"$f":"(3*AO37)+AP37","v":4},{"$f":"COUNTIFS(PaysR,AK37,VpaysR,\"1\")+ COUNTIFS(PaysV,AK37,VpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK37,NpaysR,\"1\")+ COUNTIFS(PaysV,AK37,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK37,DpaysR,\"1\")+ COUNTIFS(PaysV,AK37,DpaysV,\"1\")","v":1},{"$f":"SUMIFS(BpaysR,PaysR,AK37)+SUMIFS(BpaysV,PaysV,AK37)","v":2},{"$f":"SUMIFS(BpaysV,PaysR,AK37)+SUMIFS(BpaysR,PaysV,AK37)","v":4},{"$f":"AR37-AS37","v":-2},0,{"$f":"IF(COUNTIF(AN35:AN38,AN37)=2,IF(AN37=AN35,AI35,IF(AN37=AN36,AI36,IF(AN37=AN38,AI38,\"\"))),\"\")","v":""},{"$f":"IF($CJ$57>$CI$57,1,\"\")","v":""},{"$f":"IF($CJ$59>$CI$59,2,\"\")","v":2},null,{"$f":"IF($CI$55>$CJ$55,4,\"\")","v":""},{"$f":"SUM(BD37:BG37)","v":0},{"$f":"IF(COUNTIF(AN35:AN38,AN37)=3,IF(AN37=AN35,AI35,AI36),\"\")","v":""},{"$f":"IF(COUNTIF(AN35:AN38,AN37)=3,IF(AN37=AN38,AI38,AI36),\"\")","v":""},{"$f":"IF(COUNTIF(BB37:BC37,BD34)=1,1000*($CJ$56-$CI$56)+10*$CJ$56,\"\")","v":""},{"$f":"IF(COUNTIF(BB37:BC37,BE34)=1,1000*($CJ$59-$CI$59)+10*$CJ$59,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB37:BC37,BG34)=1,1000*($CI$55-$CJ$55)+10*$CI$55,\"\")","v":""},{"$f":"AK37","v":"Irlande"},null,1.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42542,0.75,1,1,0,0,"Ukraine",0,1,"Pologne"]
[29,"2016-06-21","18:00:00",1,0,0,1,"Irlande du Nord",0,1,"Allemagne",{"$f":"Resultats!J34","v":3},{"$f":"Resultats!K34","v":2},{"$f":"Resultats!L34","v":1.2924492984821421},1,1,0,0,null,null,null,null,null,4,{"$f":"VLOOKUP(X38,AJ35:AT38,2,FALSE)","v":"Suède"},{"$f":"(3*AB38)+AC38","v":1},{"$f":"SUM(AB38:AD38)","v":3},{"$f":"VLOOKUP(X38,AJ35:AT38,6,FALSE)","v":0},{"$f":"VLOOKUP(X38,AJ35:AT38,7,FALSE)","v":1},{"$f":"VLOOKUP(X38,AJ35:AT38,8,FALSE)","v":2},{"$f":"VLOOKUP(X38,AJ35:AT38,9,FALSE)","v":1},{"$f":"VLOOKUP(X38,AJ35:AT38,10,FALSE)","v":3},{"$f":"AE38-AF38","v":-2},null,4,{"$f":"RANK(AL38,AL35:AL38)","v":4},{"$f":"K18","v":"Suède"},{"$f":"(AN38*1000000000)+((AU38+BA38)*100000)+(AT38*1000)+(AR38*10)-AI38","v":999998006},{"$f":"O35+O36+D38","v":3},{"$f":"(3*AO38)+AP38","v":1},{"$f":"COUNTIFS(PaysR,AK38,VpaysR,\"1\")+ COUNTIFS(PaysV,AK38,VpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK38,NpaysR,\"1\")+ COUNTIFS(PaysV,AK38,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK38,DpaysR,\"1\")+ COUNTIFS(PaysV,AK38,DpaysV,\"1\")","v":2},{"$f":"SUMIFS(BpaysR,PaysR,AK38)+SUMIFS(BpaysV,PaysV,AK38)","v":1},{"$f":"SUMIFS(BpaysV,PaysR,AK38)+SUMIFS(BpaysR,PaysV,AK38)","v":3},{"$f":"AR38-AS38","v":-2},0,{"$f":"IF(COUNTIF(AN35:AN38,AN38)=2,IF(AN38=AN35,AI35,IF(AN38=AN36,AI36,IF(AN38=AN37,AI37,\"\"))),\"\")","v":""},{"$f":"IF($CI$58>$CJ$58,1,\"\")","v":""},{"$f":"IF($CJ$56>$CI$56,2,\"\")","v":""},{"$f":"IF($CJ$55>$CI$55,3,\"\")","v":""},null,{"$f":"SUM(BD38:BG38)","v":0},{"$f":"IF(COUNTIF(AN35:AN38,AN38)=3,IF(AN38=AN35,AI35,AI36),\"\")","v":""},{"$f":"IF(COUNTIF(AN35:AN38,AN38)=3,IF(AN38=AN37,AI37,AI36),\"\")","v":""},{"$f":"IF(COUNTIF(BB38:BC38,BD34)=1,1000*($CI$58-$CJ$58)+10*$CI$58,\"\")","v":""},{"$f":"IF(COUNTIF(BB38:BC38,BE34)=1,1000*($CI$57-$CJ$57)+10*$CI$57,\"\")","v":""},{"$f":"IF(COUNTIF(BB38:BC38,BF34)=1,1000*($CJ$55-$CI$55)+10*$CJ$55,\"\")","v":""},null,{"$f":"AK38","v":"Suède"},null,6]
[30,"2016-06-21","18:00:00",1,0,0,1,"Ukraine",0,1,"Pologne",{"$f":"Resultats!J35","v":3.6481765907115431},{"$f":"Resultats!K35","v":3.4384172488020592},{"$f":"Resultats!L35","v":2.3747165887202382},1,1,0,0]
[31,"2016-06-21","21:00:00",1,1,0,0,"Croatie",2,1,"Espagne",{"$f":"Resultats!J36","v":3},{"$f":"Resultats!K36","v":2},{"$f":"Resultats!L36","v":1.96052406541336},{"$f":"IF(AND(I40<>\"\",J40<>\"\"),1,0)","v":1},0,0,1,null,null,null,null,null,null,"Poule F","PTS","J","G","N","P","B+","B-","Diff",null,null,"Class",null,"PT/Class","J","PTS","G","N","P","B+","B-","Diff","Bonus","Egalité",1,2,3,4,"Bonus","Egalite 1","Egalite 2",1,2,3,4,"COTES QUALIF 8ème"]
[32,"2016-06-21","21:00:00",1,0,0,1,"Rép. Tchèque",0,2,"Turquie",{"$f":"Resultats!J37","v":2.7740515628482907},{"$f":"Resultats!K37","v":3.1967705833185445},{"$f":"Resultats!L37","v":2.574502673934818},1,1,0,0,null,null,null,null,null,1,{"$f":"VLOOKUP(X41,AJ41:AT44,2,FALSE)","v":"Hongrie"},{"$f":"(3*AB41)+AC41","v":5},{"$f":"SUM(AB41:AD41)","v":3},{"$f":"VLOOKUP(X41,AJ41:AT44,6,FALSE)","v":1},{"$f":"VLOOKUP(X41,AJ41:AT44,7,FALSE)","v":2},{"$f":"VLOOKUP(X41,AJ41:AT44,8,FALSE)","v":0},{"$f":"VLOOKUP(X41,AJ41:AT44,9,FALSE)","v":6},{"$f":"VLOOKUP(X41,AJ41:AT44,10,FALSE)","v":4},{"$f":"AE41-AF41","v":2},null,1,{"$f":"RANK(AL41,AL41:AL44)","v":3},{"$f":"H21","v":"Portugal"},{"$f":"(AN41*1000000000)+((AU41+BA41)*100000)+(AT41*1000)+(AR41*10)-AI41","v":3000000039},{"$f":"D40+D43+O44","v":3},{"$f":"(3*AO41)+AP41","v":3},{"$f":"COUNTIFS(PaysR,AK41,VpaysR,\"1\")+ COUNTIFS(PaysV,AK41,VpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK41,NpaysR,\"1\")+ COUNTIFS(PaysV,AK41,NpaysV,\"1\")","v":3},{"$f":"COUNTIFS(PaysR,AK41,DpaysR,\"1\")+ COUNTIFS(PaysV,AK41,DpaysV,\"1\")","v":0},{"$f":"SUMIFS(BpaysR,PaysR,AK41)+SUMIFS(BpaysV,PaysV,AK41)","v":4},{"$f":"SUMIFS(BpaysV,PaysR,AK41)+SUMIFS(BpaysR,PaysV,AK41)","v":4},{"$f":"AR41-AS41","v":0},{"$f":"IF(AND(AV41<>\"\",COUNTIF(AW41:AZ41,AV41)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN41:AN44,AN41)=2,IF(AN41=AN42,AI42,IF(AN41=AN43,AI43,IF(AN41=AN44,AI44,\"\"))),\"\")","v":""},null,{"$f":"IF($CI$65>$CJ$65,2,\"\")","v":""},{"$f":"IF($CI$68>$CJ$68,3,\"\")","v":""},{"$f":"IF($CJ$69>$CI$69,4,\"\")","v":""},{"$f":"SUM(BD41:BG41)","v":0},{"$f":"IF(COUNTIF(AN41:AN44,AN41)=3,IF(AN41=AN42,AI42,AI43),\"\")","v":""},{"$f":"IF(COUNTIF(AN41:AN44,AN41)=3,IF(AN41=AN44,AI44,AI43),\"\")","v":""},null,{"$f":"IF(COUNTIF(BB41:BC41,BE40)=1,1000*($CI$65-$CJ$65)+10*$CI$65,\"\")","v":""},{"$f":"IF(COUNTIF(BB41:BC41,BF40)=1,1000*($CI$67-$CJ$67)+10*$CI$67,\"\")","v":""},{"$f":"IF(COUNTIF(BB41:BC41,BG40)=1,1000*($CJ$69-$CI$69)+10*$CJ$69,\"\")","v":""},{"$f":"AK41","v":"Portugal"},null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GROUPE D",null,null,null,null,null,"GROUPE D"]
[33,"2016-06-22","18:00:00",1,0,1,0,"Hongrie",3,3,"Portugal",{"$f":"Resultats!J38","v":3},{"$f":"Resultats!K38","v":2},{"$f":"Resultats!L38","v":1.6616114082149798},1,0,1,0,null,null,null,null,null,2,{"$f":"VLOOKUP(X42,AJ41:AT44,2,FALSE)","v":"Islande"},{"$f":"(3*AB42)+AC42","v":5},{"$f":"SUM(AB42:AD42)","v":3},{"$f":"VLOOKUP(X42,AJ41:AT44,6,FALSE)","v":1},{"$f":"VLOOKUP(X42,AJ41:AT44,7,FALSE)","v":2},{"$f":"VLOOKUP(X42,AJ41:AT44,8,FALSE)","v":0},{"$f":"VLOOKUP(X42,AJ41:AT44,9,FALSE)","v":4},{"$f":"VLOOKUP(X42,AJ41:AT44,10,FALSE)","v":3},{"$f":"AE42-AF42","v":1},null,2,{"$f":"RANK(AL42,AL41:AL44)","v":2},{"$f":"K21","v":"Islande"},{"$f":"(AN42*1000000000)+((AU42+BA42)*100000)+(AT42*1000)+(AR42*10)-AI42","v":5000001038},{"$f":"O40+D42+D45","v":3},{"$f":"(3*AO42)+AP42","v":5},{"$f":"COUNTIFS(PaysR,AK42,VpaysR,\"1\")+ COUNTIFS(PaysV,AK42,VpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK42,NpaysR,\"1\")+ COUNTIFS(PaysV,AK42,NpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK42,DpaysR,\"1\")+ COUNTIFS(PaysV,AK42,DpaysV,\"1\")","v":0},{"$f":"SUMIFS(BpaysR,PaysR,AK42)+SUMIFS(BpaysV,PaysV,AK42)","v":4},{"$f":"SUMIFS(BpaysV,PaysR,AK42)+SUMIFS(BpaysR,PaysV,AK42)","v":3},{"$f":"AR42-AS42","v":1},{"$f":"IF(AND(AV42<>\"\",COUNTIF(AW42:AZ42,AV42)=1),1000,0)","v":0},{"$f":"IF(COUNTIF(AN41:AN44,AN42)=2,IF(AN42=AN41,AI41,IF(AN42=AN43,AI43,IF(AN42=AN44,AI44,\"\"))),\"\")","v":4},{"$f":"IF($CJ$65>$CI$65,1,\"\")","v":""},null,{"$f":"IF($CI$70>$CJ$70,3,\"\")","v":3},{"$f":"IF($CI$67>$CJ$67,4,\"\")","v":""},{"$f":"SUM(BD42:BG42)","v":0},{"$f":"IF(COUNTIF(AN41:AN44,AN42)=3,IF(AN42=AN41,AI41,AI43),\"\")","v":""},{"$f":"IF(COUNTIF(AN41:AN44,AN42)=3,IF(AN42=AN44,AI44,AI43),\"\")","v":""},{"$f":"IF(COUNTIF(BB42:BC42,BD40)=1,1000*($CJ$65-$CI$65)+10*$CJ$65,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB42:BC42,BF40)=1,1000*($CI$70-$CJ$70)+10*$CI$70,\"\")","v":""},{"$f":"IF(COUNTIF(BB42:BC42,BG40)=1,1000*($CJ$68-$CI$68)+10*$CJ$68,\"\")","v":""},{"$f":"AK42","v":"Islande"},null,1.6]
[34,"2016-06-22","18:00:00",1,1,0,0,"Islande",2,1,"Autriche",{"$f":"Resultats!J39","v":3},{"$f":"Resultats!K39","v":2},{"$f":"Resultats!L39","v":1.9568457120238867},{"$f":"IF(AND(I43<>\"\",J43<>\"\"),1,0)","v":1},0,0,1,null,null,null,null,null,3,{"$f":"VLOOKUP(X43,AJ41:AT44,2,FALSE)","v":"Portugal"},{"$f":"(3*AB43)+AC43","v":3},{"$f":"SUM(AB43:AD43)","v":3},{"$f":"VLOOKUP(X43,AJ41:AT44,6,FALSE)","v":0},{"$f":"VLOOKUP(X43,AJ41:AT44,7,FALSE)","v":3},{"$f":"VLOOKUP(X43,AJ41:AT44,8,FALSE)","v":0},{"$f":"VLOOKUP(X43,AJ41:AT44,9,FALSE)","v":4},{"$f":"VLOOKUP(X43,AJ41:AT44,10,FALSE)","v":4},{"$f":"AE43-AF43","v":0},null,3,{"$f":"RANK(AL43,AL41:AL44)","v":4},{"$f":"H20","v":"Autriche"},{"$f":"(AN43*1000000000)+((AU43+BA43)*100000)+(AT43*1000)+(AR43*10)-AI43","v":999997007},{"$f":"D41+O43+O45","v":3},{"$f":"(3*AO43)+AP43","v":1},{"$f":"COUNTIFS(PaysR,AK43,VpaysR,\"1\")+ COUNTIFS(PaysV,AK43,VpaysV,\"1\")","v":0},{"$f":"COUNTIFS(PaysR,AK43,NpaysR,\"1\")+ COUNTIFS(PaysV,AK43,NpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK43,DpaysR,\"1\")+ COUNTIFS(PaysV,AK43,DpaysV,\"1\")","v":2},{"$f":"SUMIFS(BpaysR,PaysR,AK43)+SUMIFS(BpaysV,PaysV,AK43)","v":1},{"$f":"SUMIFS(BpaysV,PaysR,AK43)+SUMIFS(BpaysR,PaysV,AK43)","v":4},{"$f":"AR43-AS43","v":-3},0,{"$f":"IF(COUNTIF(AN41:AN44,AN43)=2,IF(AN43=AN41,AI41,IF(AN43=AN42,AI42,IF(AN43=AN44,AI44,\"\"))),\"\")","v":""},{"$f":"IF($CJ$68>$CI$68,1,\"\")","v":""},{"$f":"IF($CJ$70>$CI$70,2,\"\")","v":""},null,{"$f":"IF($CI$66>$CJ$66,4,\"\")","v":""},{"$f":"SUM(BD43:BG43)","v":0},{"$f":"IF(COUNTIF(AN41:AN44,AN43)=3,IF(AN43=AN41,AI41,AI42),\"\")","v":""},{"$f":"IF(COUNTIF(AN41:AN44,AN43)=3,IF(AN43=AN44,AI44,AI42),\"\")","v":""},{"$f":"IF(COUNTIF(BB43:BC43,BD40)=1,1000*($CJ$67-$CI$67)+10*$CJ$67,\"\")","v":""},{"$f":"IF(COUNTIF(BB43:BC43,BE40)=1,1000*($CJ$70-$CI$70)+10*$CJ$70,\"\")","v":""},null,{"$f":"IF(COUNTIF(BB43:BC43,BG40)=1,1000*($CI$66-$CJ$66)+10*$CI$66,\"\")","v":""},{"$f":"AK43","v":"Autriche"},null,1.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42534,0.625,1,1,0,0,"Espagne",1,0,"Rép. Tchèque"]
[35,"2016-06-22","21:00:00",1,0,0,1,"Suède",0,1,"Belgique",{"$f":"Resultats!J40","v":3},{"$f":"Resultats!K40","v":2},{"$f":"Resultats!L40","v":2.0676153791607885},1,1,0,0,null,null,null,null,null,4,{"$f":"VLOOKUP(X44,AJ41:AT44,2,FALSE)","v":"Autriche"},{"$f":"(3*AB44)+AC44","v":1},{"$f":"SUM(AB44:AD44)","v":3},{"$f":"VLOOKUP(X44,AJ41:AT44,6,FALSE)","v":0},{"$f":"VLOOKUP(X44,AJ41:AT44,7,FALSE)","v":1},{"$f":"VLOOKUP(X44,AJ41:AT44,8,FALSE)","v":2},{"$f":"VLOOKUP(X44,AJ41:AT44,9,FALSE)","v":1},{"$f":"VLOOKUP(X44,AJ41:AT44,10,FALSE)","v":4},{"$f":"AE44-AF44","v":-3},null,4,{"$f":"RANK(AL44,AL41:AL44)","v":1},{"$f":"K20","v":"Hongrie"},{"$f":"(AN44*1000000000)+((AU44+BA44)*100000)+(AT44*1000)+(AR44*10)-AI44","v":5000002056},{"$f":"O41+O42+D44","v":3},{"$f":"(3*AO44)+AP44","v":5},{"$f":"COUNTIFS(PaysR,AK44,VpaysR,\"1\")+ COUNTIFS(PaysV,AK44,VpaysV,\"1\")","v":1},{"$f":"COUNTIFS(PaysR,AK44,NpaysR,\"1\")+ COUNTIFS(PaysV,AK44,NpaysV,\"1\")","v":2},{"$f":"COUNTIFS(PaysR,AK44,DpaysR,\"1\")+ COUNTIFS(PaysV,AK44,DpaysV,\"1\")","v":0},{"$f":"SUMIFS(BpaysR,PaysR,AK44)+SUMIFS(BpaysV,PaysV,AK44)","v":6},{"$f":"SUMIFS(BpaysV,PaysR,AK44)+SUMIFS(BpaysR,PaysV,AK44)","v":4},{"$f":"AR44-AS44","v":2},0,{"$f":"IF(COUNTIF(AN41:AN44,AN44)=2,IF(AN44=AN41,AI41,IF(AN44=AN42,AI42,IF(AN44=AN43,AI43,\"\"))),\"\")","v":2},{"$f":"IF($CI$69>$CJ$69,1,\"\")","v":""},{"$f":"IF($CJ$67>$CI$67,2,\"\")","v":""},{"$f":"IF($CJ$66>$CI$66,3,\"\")","v":3},null,{"$f":"SUM(BD44:BG44)","v":0},{"$f":"IF(COUNTIF(AN41:AN44,AN44)=3,IF(AN44=AN41,AI41,AI42),\"\")","v":""},{"$f":"IF(COUNTIF(AN41:AN44,AN44)=3,IF(AN44=AN43,AI43,AI42),\"\")","v":""},{"$f":"IF(COUNTIF(BB44:BC44,BD40)=1,1000*($CI$69-$CJ$69)+10*$CI$69,\"\")","v":""},{"$f":"IF(COUNTIF(BB44:BC44,BE40)=1,1000*($CI$68-$CJ$68)+10*$CI$68,\"\")","v":""},{"$f":"IF(COUNTIF(BB44:BC44,BF40)=1,1000*($CJ$66-$CI$66)+10*$CJ$66,\"\")","v":""},null,{"$f":"AK44","v":"Hongrie"},null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42533,0.625,1,1,0,0,"Turquie",0,1,"Croatie"]
[36,"2016-06-22","21:00:00",1,0,0,1,"Italie",0,1,"Irlande",{"$f":"Resultats!J41","v":1.9494568608543874},{"$f":"Resultats!K41","v":2},{"$f":"Resultats!L41","v":3},1,1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42538,0.75,1,1,0,0,"Rép. Tchèque",2,2,"Croatie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLASSEMENT DES 3èmes DE GROUPE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42538,0.875,1,0,1,0,"Espagne",3,0,"Turquie"]
["N°:","Date et heure",null,null,null,null,null,"Huitièmes de finale (fin 90')",null,null,null,"ap. prlg.",null,"Vainqueur (X)",null,null,null,null,null,"COTES (1N2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42542,0.875,1,0,1,0,"Croatie",2,1,"Espagne"]
[37,"2016-06-25","15:00:00",null,null,null,null,{"$f":"IF(SUM(Matchs!AA11:AA14)=12,Matchs!Y12,\"\")","v":"Suisse"},1,1,{"$f":"IF(SUM(Matchs!AA23:AA26)=12,Matchs!Y24,\"\")","v":"Pologne"},1,1,null,null,null,null,null,"x",{"$f":"IF(Resultats!J42<>\"\",Resultats!J42,\"\")","v":3.05},{"$f":"IF(Resultats!K42<>\"\",Resultats!K42,\"\")","v":2.91},{"$f":"IF(Resultats!L42<>\"\",Resultats!L42,\"\")","v":2.58},null,null,null,"PTS","J","G","N","P","B+","B-","Diff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42542,0.875,1,1,0,0,"Rép. Tchèque",0,2,"Turquie"]
[38,"2016-06-25","18:00:00",null,null,null,null,{"$f":"IF(SUM(Matchs!AA17:AA20)=12,Matchs!Y17,\"\")","v":"Pays de Galles"},1,0,{"$f":"IF(SUM(Matchs!AA11:AA14,Matchs!AA17:AA20,Matchs!AA23:AA26,Matchs!AA29:AA32,Matchs!AA35:AA38,Matchs!AA41:AA44)=72,Matchs!AC57,\"\")","v":"Irlande du Nord"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J43<>\"\",Resultats!J43,\"\")","v":2.46},{"$f":"IF(Resultats!K43<>\"\",Resultats!K43,\"\")","v":2.91},{"$f":"IF(Resultats!L43<>\"\",Resultats!L43,\"\")","v":2.85},null,1,{"$f":"VLOOKUP(X49,AJ49:AT54,2,FALSE)","v":"Slovaquie"},{"$f":"(3*AB49)+AC49","v":4},{"$f":"SUM(AB49:AD49)","v":3},{"$f":"VLOOKUP(X49,AJ49:AT54,6,FALSE)","v":1},{"$f":"VLOOKUP(X49,AJ49:AT54,7,FALSE)","v":1},{"$f":"VLOOKUP(X49,AJ49:AT54,8,FALSE)","v":1},{"$f":"VLOOKUP(X49,AJ49:AT54,9,FALSE)","v":3},{"$f":"VLOOKUP(X49,AJ49:AT54,10,FALSE)","v":3},{"$f":"AE49-AF49","v":0},{"$f":"VLOOKUP(X49,$AJ$49:$AU$54,12,FALSE)","v":2},1,{"$f":"RANK(AL49,$AL$49:$AL$54)","v":6},{"$f":"Y13","v":"Albanie"},{"$f":"(AN49*100000000)+(AT49*100000)+(AR49*1000)-AI49","v":299800999},{"$f":"AA13","v":3},{"$f":"Z13","v":3},{"$f":"AB13","v":1},0,2,1,3,-2,1]
[39,"2016-06-25","21:00:00",null,null,null,null,{"$f":"IF(SUM(Matchs!AA29:AA32)=12,Matchs!Y29,\"\")","v":"Croatie"},0,0,{"$f":"IF(SUM(Matchs!AA11:AA14,Matchs!AA17:AA20,Matchs!AA23:AA26,Matchs!AA29:AA32,Matchs!AA35:AA38,Matchs!AA41:AA44)=72,Matchs!AE57,\"\")","v":"Portugal"},0,1,null,null,null,null,null,null,{"$f":"IF(Resultats!J44<>\"\",Resultats!J44,\"\")","v":1.89},{"$f":"IF(Resultats!K44<>\"\",Resultats!K44,\"\")","v":2.75},{"$f":"IF(Resultats!L44<>\"\",Resultats!L44,\"\")","v":3},null,2,{"$f":"VLOOKUP(X50,AJ49:AT54,2,FALSE)","v":"Irlande"},4,3,{"$f":"VLOOKUP(X50,AJ49:AT54,6,FALSE)","v":1},{"$f":"VLOOKUP(X50,AJ49:AT54,7,FALSE)","v":1},{"$f":"VLOOKUP(X50,AJ49:AT54,8,FALSE)","v":1},{"$f":"VLOOKUP(X50,AJ49:AT54,9,FALSE)","v":2},{"$f":"VLOOKUP(X50,AJ49:AT54,10,FALSE)","v":4},-2,5,2,1,{"$f":"Y19","v":"Slovaquie"},400002998,{"$f":"AA19","v":3},{"$f":"Z19","v":4},{"$f":"AB19","v":1},1,1,3,3,0,2]
[40,"2016-06-26","15:00:00",null,null,null,null,{"$f":"IF(SUM(Matchs!AA11:AA14)=12,Matchs!Y11,\"\")","v":"France"},2,1,{"$f":"IF(SUM(Matchs!AA11:AA14,Matchs!AA17:AA20,Matchs!AA23:AA26,Matchs!AA29:AA32,Matchs!AA35:AA38,Matchs!AA41:AA44)=72,Matchs!AB57,\"\")","v":"Irlande"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J45<>\"\",Resultats!J45,\"\")","v":3},{"$f":"IF(Resultats!K45<>\"\",Resultats!K45,\"\")","v":2.94},{"$f":"IF(Resultats!L45<>\"\",Resultats!L45,\"\")","v":2.12},null,3,{"$f":"VLOOKUP(X51,AJ49:AT54,2,FALSE)","v":"Portugal"},3,3,{"$f":"VLOOKUP(X51,AJ49:AT54,6,FALSE)","v":0},{"$f":"VLOOKUP(X51,AJ49:AT54,7,FALSE)","v":3},{"$f":"VLOOKUP(X51,AJ49:AT54,8,FALSE)","v":0},{"$f":"VLOOKUP(X51,AJ49:AT54,9,FALSE)","v":4},{"$f":"VLOOKUP(X51,AJ49:AT54,10,FALSE)","v":4},0,6,3,4,{"$f":"Y25","v":"Irlande du Nord"},300001997,{"$f":"AA25","v":3},{"$f":"Z25","v":3},{"$f":"AB25","v":1},0,2,2,2,0,3]
[41,"2016-06-26","18:00:00",null,null,null,null,{"$f":"IF(SUM(Matchs!AA23:AA26)=12,Matchs!Y23,\"\")","v":"Allemagne"},3,0,{"$f":"IF(SUM(Matchs!AA11:AA14,Matchs!AA17:AA20,Matchs!AA23:AA26,Matchs!AA29:AA32,Matchs!AA35:AA38,Matchs!AA41:AA44)=72,Matchs!AD57,\"\")","v":"Slovaquie"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J46<>\"\",Resultats!J46,\"\")","v":1.38},{"$f":"IF(Resultats!K46<>\"\",Resultats!K46,\"\")","v":2},{"$f":"IF(Resultats!L46<>\"\",Resultats!L46,\"\")","v":3},null,4,{"$f":"VLOOKUP(X52,AJ49:AT54,2,FALSE)","v":"Irlande du Nord"},3,3,{"$f":"VLOOKUP(X52,AJ49:AT54,6,FALSE)","v":1},{"$f":"VLOOKUP(X52,AJ49:AT54,7,FALSE)","v":0},{"$f":"VLOOKUP(X52,AJ49:AT54,8,FALSE)","v":2},{"$f":"VLOOKUP(X52,AJ49:AT54,9,FALSE)","v":2},{"$f":"VLOOKUP(X52,AJ49:AT54,10,FALSE)","v":2},0,3,4,5,{"$f":"Y31","v":"Turquie"},299801996,{"$f":"AA31","v":3},{"$f":"Z31","v":3},{"$f":"AB31","v":1},0,2,2,4,-2,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GROUPE E",null,null,null,null,null,"GROUPE E"]
[42,"2016-06-26","21:00:00",null,null,null,null,{"$f":"IF(SUM(Matchs!AA41:AA44)=12,Matchs!Y41,\"\")","v":"Hongrie"},0,4,{"$f":"IF(SUM(Matchs!AA35:AA38)=12,Matchs!Y36,\"\")","v":"Belgique"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J47<>\"\",Resultats!J47,\"\")","v":1.44},{"$f":"IF(Resultats!K47<>\"\",Resultats!K47,\"\")","v":2},{"$f":"IF(Resultats!L47<>\"\",Resultats!L47,\"\")","v":3},null,5,{"$f":"VLOOKUP(X53,AJ49:AT54,2,FALSE)","v":"Turquie"},3,3,{"$f":"VLOOKUP(X53,AJ49:AT54,6,FALSE)","v":1},{"$f":"VLOOKUP(X53,AJ49:AT54,7,FALSE)","v":0},{"$f":"VLOOKUP(X53,AJ49:AT54,8,FALSE)","v":2},{"$f":"VLOOKUP(X53,AJ49:AT54,9,FALSE)","v":2},{"$f":"VLOOKUP(X53,AJ49:AT54,10,FALSE)","v":4},-2,4,5,2,{"$f":"Y37","v":"Irlande"},399801995,{"$f":"AA37","v":3},{"$f":"Z37","v":4},{"$f":"AB37","v":1},1,1,2,4,-2,5]
[43,"2016-06-27","18:00:00",null,null,null,null,{"$f":"IF(SUM(Matchs!AA35:AA38)=12,Matchs!Y35,\"\")","v":"Italie"},2,0,{"$f":"IF(SUM(Matchs!AA29:AA32)=12,Matchs!Y30,\"\")","v":"Espagne"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J48<>\"\",Resultats!J48,\"\")","v":3},{"$f":"IF(Resultats!K48<>\"\",Resultats!K48,\"\")","v":2},{"$f":"IF(Resultats!L48<>\"\",Resultats!L48,\"\")","v":1.57},null,6,{"$f":"VLOOKUP(X54,AJ49:AT54,2,FALSE)","v":"Albanie"},3,3,{"$f":"VLOOKUP(X54,AJ49:AT54,6,FALSE)","v":1},{"$f":"VLOOKUP(X54,AJ49:AT54,7,FALSE)","v":0},{"$f":"VLOOKUP(X54,AJ49:AT54,8,FALSE)","v":2},{"$f":"VLOOKUP(X54,AJ49:AT54,9,FALSE)","v":1},{"$f":"VLOOKUP(X54,AJ49:AT54,10,FALSE)","v":3},-2,1,6,3,{"$f":"Y43","v":"Portugal"},300003994,{"$f":"AA43","v":3},{"$f":"Z43","v":3},{"$f":"AB43","v":0},3,0,4,4,0,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42534,0.875,1,0,1,0,"Belgique",0,2,"Italie"]
[44,"2016-06-27","21:00:00",null,null,null,null,{"$f":"IF(SUM(Matchs!AA17:AA20)=12,Matchs!Y18,\"\")","v":"Angleterre"},1,2,{"$f":"IF(SUM(Matchs!AA41:AA44)=12,Matchs!Y42,\"\")","v":"Islande"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J49<>\"\",Resultats!J49,\"\")","v":1.5},{"$f":"IF(Resultats!K49<>\"\",Resultats!K49,\"\")","v":2},{"$f":"IF(Resultats!L49<>\"\",Resultats!L49,\"\")","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42534,0.75,1,1,0,0,"Irlande",1,1,"Suède"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42538,0.625,1,1,0,0,"Italie",1,0,"Suède"]
["N°:","Date et heure",null,null,null,null,null,"Quarts de finale (fin 90')",null,null,null,"ap. prlg.",null,"Vainqueur (X)",null,null,null,null,null,"COTES (1N2)",null,null,null,null,null,null,{"$f":"CONCATENATE(SMALL($AH$49:$AH$52,1),SMALL($AH$49:$AH$52,2),SMALL($AH$49:$AH$52,3),SMALL($AH$49:$AH$52,4))","v":"2356"},{"$f":"VLOOKUP(AA57,AG59:AI73,3,FALSE)","v":"Irlande"},{"$f":"VLOOKUP(AA57,AG59:AJ73,4,FALSE)","v":"Irlande du Nord"},{"$f":"VLOOKUP(AA57,AG59:AK73,5,FALSE)","v":"Slovaquie"},{"$f":"VLOOKUP(AA57,AG59:AL73,6,FALSE)","v":"Portugal"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42539,0.625,1,0,1,0,"Belgique",3,0,"Irlande"]
[45,"2016-06-30","21:00:00",null,null,null,null,{"$f":"IF(OR(I48=\"\",J48=\"\"),\"\",IF(OR(I48>J48,AND(I48=J48,L48>M48),AND(I48=J48,L48=M48,N48>S48)),H48,IF(OR(I48<J48,AND(I48=J48,L48<M48),AND(I48=J48,L48=M48,N48<S48)),K48,\"\")))","v":"Pologne"},1,1,{"$f":"IF(OR(I50=\"\",J50=\"\"),\"\",IF(OR(I50>J50,AND(I50=J50,L50>M50),AND(I50=J50,L50=M50,N50>S50)),H50,IF(OR(I50<J50,AND(I50=J50,L50<M50),AND(I50=J50,L50=M50,N50<S50)),K50,\"\")))","v":"Portugal"},1,1,null,null,null,null,null,"x",{"$f":"IF(Resultats!J50<>\"\",Resultats!J50,\"\")","v":""},{"$f":"IF(Resultats!K50<>\"\",Resultats!K50,\"\")","v":""},{"$f":"IF(Resultats!L50<>\"\",Resultats!L50,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"WA","WB","WC","WD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42543,0.875,1,0,1,0,"Suède",0,1,"Belgique"]
[46,"2016-07-01","21:00:00",null,null,null,null,{"$f":"IF(OR(I49=\"\",J49=\"\"),\"\",IF(OR(I49>J49,AND(I49=J49,L49>M49),AND(I49=J49,L49=M49,N49>S49)),H49,IF(OR(I49<J49,AND(I49=J49,L49<M49),AND(I49=J49,L49=M49,N49<S49)),K49,\"\")))","v":"Pays de Galles"},3,1,{"$f":"IF(OR(I53=\"\",J53=\"\"),\"\",IF(OR(I53>J53,AND(I53=J53,L53>M53),AND(I53=J53,L53=M53,N53>S53)),H53,IF(OR(I53<J53,AND(I53=J53,L53<M53),AND(I53=J53,L53=M53,N53<S53)),K53,\"\")))","v":"Belgique"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J51<>\"\",Resultats!J51,\"\")","v":""},{"$f":"IF(Resultats!K51<>\"\",Resultats!K51,\"\")","v":""},{"$f":"IF(Resultats!L51<>\"\",Resultats!L51,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"1234",null,{"$f":"Y25","v":"Irlande du Nord"},{"$f":"Y31","v":"Turquie"},{"$f":"Y13","v":"Albanie"},{"$f":"Y19","v":"Slovaquie"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42543,0.875,1,1,0,0,"Italie",0,1,"Irlande"]
[47,"2016-07-02","21:00:00",null,null,null,null,{"$f":"IF(OR(I52=\"\",J52=\"\"),\"\",IF(OR(I52>J52,AND(I52=J52,L52>M52),AND(I52=J52,L52=M52,N52>S52)),H52,IF(OR(I52<J52,AND(I52=J52,L52<M52),AND(I52=J52,L52=M52,N52<S52)),K52,\"\")))","v":"Allemagne"},1,1,{"$f":"IF(OR(I54=\"\",J54=\"\"),\"\",IF(OR(I54>J54,AND(I54=J54,L54>M54),AND(I54=J54,L54=M54,N54>S54)),H54,IF(OR(I54<J54,AND(I54=J54,L54<M54),AND(I54=J54,L54=M54,N54<S54)),K54,\"\")))","v":"Italie"},1,1,"x",null,null,null,null,null,{"$f":"IF(Resultats!J52<>\"\",Resultats!J52,\"\")","v":""},{"$f":"IF(Resultats!K52<>\"\",Resultats!K52,\"\")","v":""},{"$f":"IF(Resultats!L52<>\"\",Resultats!L52,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"1235",null,{"$f":"Y25","v":"Irlande du Nord"},{"$f":"Y13","v":"Albanie"},{"$f":"Y19","v":"Slovaquie"},{"$f":"Y37","v":"Irlande"}]
[48,"2016-07-03","21:00:00",null,null,null,null,{"$f":"IF(OR(I51=\"\",J51=\"\"),\"\",IF(OR(I51>J51,AND(I51=J51,L51>M51),AND(I51=J51,L51=M51,N51>S51)),H51,IF(OR(I51<J51,AND(I51=J51,L51<M51),AND(I51=J51,L51=M51,N51<S51)),K51,\"\")))","v":"France"},5,2,{"$f":"IF(OR(I55=\"\",J55=\"\"),\"\",IF(OR(I55>J55,AND(I55=J55,L55>M55),AND(I55=J55,L55=M55,N55>S55)),H55,IF(OR(I55<J55,AND(I55=J55,L55<M55),AND(I55=J55,L55=M55,N55<S55)),K55,\"\")))","v":"Islande"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J53<>\"\",Resultats!J53,\"\")","v":""},{"$f":"IF(Resultats!K53<>\"\",Resultats!K53,\"\")","v":""},{"$f":"IF(Resultats!L53<>\"\",Resultats!L53,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"1236",null,{"$f":"Y25","v":"Irlande du Nord"},{"$f":"Y13","v":"Albanie"},{"$f":"Y19","v":"Slovaquie"},{"$f":"Y43","v":"Portugal"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1245",null,{"$f":"Y31","v":"Turquie"},{"$f":"Y13","v":"Albanie"},{"$f":"Y19","v":"Slovaquie"},{"$f":"Y37","v":"Irlande"}]
["N°:","Date et heure",null,null,null,null,null,"Demi finales (fin 90')",null,null,null,"ap. prlg.",null,"Vainqueur (X)",null,null,null,null,null,"COTES (1N2)",null,null,null,null,null,null,null,null,null,null,null,null,"1246",null,{"$f":"Y31","v":"Turquie"},{"$f":"Y13","v":"Albanie"},{"$f":"Y19","v":"Slovaquie"},{"$f":"Y43","v":"Portugal"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GROUPE F",null,null,null,null,null,"GROUPE F"]
[49,"2016-07-06","21:00:00",null,null,null,null,{"$f":"IF(OR(I58=\"\",J58=\"\"),\"\",IF(OR(I58>J58,AND(I58=J58,L58>M58),AND(I58=J58,L58=M58,N58>S58)),H58,IF(OR(I58<J58,AND(I58=J58,L58<M58),AND(I58=J58,L58=M58,N58<S58)),K58,\"\")))","v":"Portugal"},2,0,{"$f":"IF(OR(I59=\"\",J59=\"\"),\"\",IF(OR(I59>J59,AND(I59=J59,L59>M59),AND(I59=J59,L59=M59,N59>S59)),H59,IF(OR(I59<J59,AND(I59=J59,L59<M59),AND(I59=J59,L59=M59,N59<S59)),K59,\"\")))","v":"Pays de Galles"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J54<>\"\",Resultats!J54,\"\")","v":""},{"$f":"IF(Resultats!K54<>\"\",Resultats!K54,\"\")","v":""},{"$f":"IF(Resultats!L54<>\"\",Resultats!L54,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"1256",null,{"$f":"Y37","v":"Irlande"},{"$f":"Y13","v":"Albanie"},{"$f":"Y19","v":"Slovaquie"},{"$f":"Y43","v":"Portugal"}]
[50,"2016-07-07","21:00:00",null,null,null,null,{"$f":"IF(OR(I60=\"\",J60=\"\"),\"\",IF(OR(I60>J60,AND(I60=J60,L60>M60),AND(I60=J60,L60=M60,N60>S60)),H60,IF(OR(I60<J60,AND(I60=J60,L60<M60),AND(I60=J60,L60=M60,N60<S60)),K60,\"\")))","v":"Allemagne"},0,2,{"$f":"IF(OR(I61=\"\",J61=\"\"),\"\",IF(OR(I61>J61,AND(I61=J61,L61>M61),AND(I61=J61,L61=M61,N61>S61)),H61,IF(OR(I61<J61,AND(I61=J61,L61<M61),AND(I61=J61,L61=M61,N61<S61)),K61,\"\")))","v":"France"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J55<>\"\",Resultats!J55,\"\")","v":""},{"$f":"IF(Resultats!K55<>\"\",Resultats!K55,\"\")","v":""},{"$f":"IF(Resultats!L55<>\"\",Resultats!L55,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"1345",null,{"$f":"Y25","v":"Irlande du Nord"},{"$f":"Y31","v":"Turquie"},{"$f":"Y13","v":"Albanie"},{"$f":"Y37","v":"Irlande"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42535,0.875,1,1,0,0,"Portugal",1,1,"Islande"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1346",null,{"$f":"Y25","v":"Irlande du Nord"},{"$f":"Y31","v":"Turquie"},{"$f":"Y13","v":"Albanie"},{"$f":"Y43","v":"Portugal"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42535,0.75,1,0,1,0,"Autriche",0,2,"Hongrie"]
["N°:","Date et heure",null,null,null,null,null,"Finale (fin 90')",null,null,null,"ap. prlg.",null,"Vainqueur (X)",null,null,null,null,null,"COTES (1N2)",null,null,null,null,null,null,null,null,null,null,null,null,"1356",null,{"$f":"Y25","v":"Irlande du Nord"},{"$f":"Y13","v":"Albanie"},{"$f":"Y43","v":"Portugal"},{"$f":"Y37","v":"Irlande"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42539,0.75,1,1,0,0,"Islande",1,1,"Hongrie"]
[51,"2016-07-10","21:00:00",null,null,null,null,{"$f":"IF(OR(I64=\"\",J64=\"\"),\"\",IF(OR(I64>J64,AND(I64=J64,L64>M64),AND(I64=J64,L64=M64,N64>S64)),H64,IF(OR(I64<J64,AND(I64=J64,L64<M64),AND(I64=J64,L64=M64,N64<S64)),K64,\"\")))","v":"Portugal"},null,null,{"$f":"IF(OR(I65=\"\",J65=\"\"),\"\",IF(OR(I65>J65,AND(I65=J65,L65>M65),AND(I65=J65,L65=M65,N65>S65)),H65,IF(OR(I65<J65,AND(I65=J65,L65<M65),AND(I65=J65,L65=M65,N65<S65)),K65,\"\")))","v":"France"},null,null,null,null,null,null,null,null,{"$f":"IF(Resultats!J56<>\"\",Resultats!J56,\"\")","v":""},{"$f":"IF(Resultats!K56<>\"\",Resultats!K56,\"\")","v":""},{"$f":"IF(Resultats!L56<>\"\",Resultats!L56,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"1456",null,{"$f":"Y31","v":"Turquie"},{"$f":"Y13","v":"Albanie"},{"$f":"Y43","v":"Portugal"},{"$f":"Y37","v":"Irlande"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42539,0.875,1,0,1,0,"Portugal",0,0,"Autriche"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2345",null,{"$f":"Y25","v":"Irlande du Nord"},{"$f":"Y31","v":"Turquie"},{"$f":"Y19","v":"Slovaquie"},{"$f":"Y37","v":"Irlande"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42543,0.75,1,0,1,0,"Hongrie",3,3,"Portugal"]
[null,"Podium",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2346",null,{"$f":"Y25","v":"Irlande du Nord"},{"$f":"Y31","v":"Turquie"},{"$f":"Y19","v":"Slovaquie"},{"$f":"Y43","v":"Portugal"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42543,0.75,1,1,0,0,"Islande",2,1,"Autriche"]
["1er",{"$f":"IF(OR(I68=\"\",J68=\"\"),\"\",IF(OR(I68>J68,AND(I68=J68,L68>M68),AND(I68=J68,L68=M68,N68>S68)),H68,IF(OR(I68<J68,AND(I68=J68,L68<M68),AND(I68=J68,L68=M68,N68<S68)),K68,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2356",null,{"$f":"Y37","v":"Irlande"},{"$f":"Y25","v":"Irlande du Nord"},{"$f":"Y19","v":"Slovaquie"},{"$f":"Y43","v":"Portugal"}]
["2ème",{"$f":"IF(OR(I68=\"\",J68=\"\"),\"\",IF(OR(I68<J68,AND(I68=J68,L68<M68),AND(I68=J68,L68=M68,N68<S68)),H68,IF(OR(I68>J68,AND(I68=J68,L68>M68),AND(I68=J68,L68=M68,N68>S68)),K68,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2456",null,{"$f":"Y37","v":"Irlande"},{"$f":"Y31","v":"Turquie"},{"$f":"Y19","v":"Slovaquie"},{"$f":"Y43","v":"Portugal"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3456",null,{"$f":"Y25","v":"Irlande du Nord"},{"$f":"Y31","v":"Turquie"},{"$f":"Y43","v":"Portugal"},{"$f":"Y37","v":"Irlande"}]

{"sheet":"Resultats","index":2,"n_rows":87,"n_cols":13,"rows_kept":87,"cut":false,"hidden":false,"merged":[[71,4,71,5],[68,4,68,5],[66,4,66,5],[67,4,67,5],[69,4,69,5],[70,4,70,5],[81,4,81,5],[79,4,79,5],[72,4,72,5],[76,4,76,5],[75,4,75,5],[80,4,80,5],[86,4,86,5],[85,4,85,5],[1,4,2,5],[84,4,84,5],[59,4,59,5],[73,4,73,5],[60,4,60,5],[74,4,74,5],[58,4,58,5],[61,4,61,5],[63,4,63,5],[82,4,82,5],[83,4,83,5],[77,4,77,5],[78,4,78,5],[65,4,65,5],[64,4,64,5],[1,9,1,12],[56,4,56,5],[57,4,57,5],[62,4,62,5]]}
[]
[null,null,null,null,"Score",null,"Prolongations",null,"Winner","Cotes"]
[null,null,null,null,null,null,null,null,null,1,"N",2,"G"]
[]
[2]
[3,1,"France","Roumanie",{"$f":"IF(Matchs!I10<>\"\",Matchs!I10,\"\")","v":2},{"$f":"IF(Matchs!J10<>\"\",Matchs!J10,\"\")","v":1},null,null,null,1.2855555555555558,4.9833333333333334,13.444444444444445,{"$f":"IF(OR(E6=\"\",F6=\"\"),\"\",IF(E6>F6,J6,IF(E6=F6,K6,L6)))","v":1.2855555555555558}]
[4,2,"Albanie","Suisse",{"$f":"IF(Matchs!I11<>\"\",Matchs!I11,\"\")","v":0},{"$f":"IF(Matchs!J11<>\"\",Matchs!J11,\"\")","v":1},null,null,null,5.5111111111111111,3.3277777777777775,1.7399999999999998,{"$f":"IF(OR(E7=\"\",F7=\"\"),\"\",IF(E7>F7,J7,IF(E7=F7,K7,L7)))","v":1.7399999999999998}]
[5,3,"Pays de Galles","Slovaquie",{"$f":"IF(Matchs!I12<>\"\",Matchs!I12,\"\")","v":2},{"$f":"IF(Matchs!J12<>\"\",Matchs!J12,\"\")","v":1},null,null,null,2.6511111111111112,2.9833333333333334,2.8888888888888884,2.6511111111111112]
[6,4,"Angleterre","Russie",{"$f":"IF(Matchs!I13<>\"\",Matchs!I13,\"\")","v":1},{"$f":"IF(Matchs!J13<>\"\",Matchs!J13,\"\")","v":1},null,null,null,1.8755555555555554,3.3000000000000003,4.4922222222222228,3.3000000000000003]
[7,5,"Turquie","Croatie",{"$f":"IF(Matchs!I14<>\"\",Matchs!I14,\"\")","v":0},{"$f":"IF(Matchs!J14<>\"\",Matchs!J14,\"\")","v":1},null,null,null,3.5333333333333337,3.1722222222222225,2.1666666666666665,2.1666666666666665]
[8,6,"Pologne","Irlande du Nord",{"$f":"IF(Matchs!I15<>\"\",Matchs!I15,\"\")","v":1},{"$f":"IF(Matchs!J15<>\"\",Matchs!J15,\"\")","v":0},null,null,null,1.67,3.5166666666666666,5.7111111111111112,1.67]
[9,7,"Allemagne","Ukraine",{"$f":"IF(Matchs!I16<>\"\",Matchs!I16,\"\")","v":2},{"$f":"IF(Matchs!J16<>\"\",Matchs!J16,\"\")","v":0},null,null,null,1.5088888888888892,4.1111111111111107,6.9444444444444446,1.5088888888888892]
[10,8,"Espagne","Rép. Tchèque",{"$f":"IF(Matchs!I17<>\"\",Matchs!I17,\"\")","v":1},{"$f":"IF(Matchs!J17<>\"\",Matchs!J17,\"\")","v":0},null,null,null,1.45,4.0444444444444443,7.8277777777777784,{"$f":"IF(OR(E13=\"\",F13=\"\"),\"\",IF(E13>F13,J13,IF(E13=F13,K13,L13)))","v":1.45}]
[11,9,"Irlande","Suède",{"$f":"IF(Matchs!I18<>\"\",Matchs!I18,\"\")","v":1},{"$f":"IF(Matchs!J18<>\"\",Matchs!J18,\"\")","v":1},null,null,null,3.1722222222222225,3.0444444444444452,2.4288888888888889,{"$f":"IF(OR(E14=\"\",F14=\"\"),\"\",IF(E14>F14,J14,IF(E14=F14,K14,L14)))","v":3.0444444444444452}]
[12,10,"Belgique","Italie",{"$f":"IF(Matchs!I19<>\"\",Matchs!I19,\"\")","v":0},{"$f":"IF(Matchs!J19<>\"\",Matchs!J19,\"\")","v":2},null,null,null,2.4988888888888892,3.0555555555555562,3.0222222222222226,3.0222222222222226]
[13,11,"Autriche","Hongrie",{"$f":"IF(Matchs!I20<>\"\",Matchs!I20,\"\")","v":0},{"$f":"IF(Matchs!J20<>\"\",Matchs!J20,\"\")","v":2},null,null,null,1.7055555555555557,3.5000000000000004,5.366666666666668,5.366666666666668]
[14,12,"Portugal","Islande",{"$f":"IF(Matchs!I21<>\"\",Matchs!I21,\"\")","v":1},{"$f":"IF(Matchs!J21<>\"\",Matchs!J21,\"\")","v":1},null,null,null,1.62,3.5999999999999996,6.2,{"$f":"IF(OR(E17=\"\",F17=\"\"),\"\",IF(E17>F17,J17,IF(E17=F17,K17,L17)))","v":3.5999999999999996}]
[15,13,"Russie","Slovaquie",{"$f":"IF(Matchs!I22<>\"\",Matchs!I22,\"\")","v":1},{"$f":"IF(Matchs!J22<>\"\",Matchs!J22,\"\")","v":2},null,null,null,1.9444444444444444,2,3,3]
[16,14,"Roumanie","Suisse",{"$f":"IF(Matchs!I23<>\"\",Matchs!I23,\"\")","v":1},{"$f":"IF(Matchs!J23<>\"\",Matchs!J23,\"\")","v":1},null,null,null,3.6160493827160494,3.219753086419753,2.2498765432098766,3.219753086419753]
[17,15,"France","Albanie",{"$f":"IF(Matchs!I24<>\"\",Matchs!I24,\"\")","v":2},{"$f":"IF(Matchs!J24<>\"\",Matchs!J24,\"\")","v":0},null,null,null,1.4551165980795608,2,3,1.4551165980795608]
[18,16,"Angleterre","Pays de Galles",{"$f":"IF(Matchs!I25<>\"\",Matchs!I25,\"\")","v":2},{"$f":"IF(Matchs!J25<>\"\",Matchs!J25,\"\")","v":1},null,null,null,1.5939018442310626,2,3,1.5939018442310626]
[19,17,"Ukraine","Irlande du Nord",{"$f":"IF(Matchs!I26<>\"\",Matchs!I26,\"\")","v":0},{"$f":"IF(Matchs!J26<>\"\",Matchs!J26,\"\")","v":2},null,null,null,1.7148779826923402,2,3,{"$f":"IF(OR(E22=\"\",F22=\"\"),\"\",IF(E22>F22,J22,IF(E22=F22,K22,L22)))","v":3}]
[20,18,"Allemagne","Pologne",{"$f":"IF(Matchs!I27<>\"\",Matchs!I27,\"\")","v":0},{"$f":"IF(Matchs!J27<>\"\",Matchs!J27,\"\")","v":0},null,null,null,1.5760975536324822,2,3,2]
[21,19,"Italie","Suède",{"$f":"IF(Matchs!I28<>\"\",Matchs!I28,\"\")","v":1},{"$f":"IF(Matchs!J28<>\"\",Matchs!J28,\"\")","v":0},null,null,null,1.8973441726258313,2,3,{"$f":"IF(OR(E24=\"\",F24=\"\"),\"\",IF(E24>F24,J24,IF(E24=F24,K24,L24)))","v":1.8973441726258313}]
[22,20,"Rép. Tchèque","Croatie",{"$f":"IF(Matchs!I29<>\"\",Matchs!I29,\"\")","v":2},{"$f":"IF(Matchs!J29<>\"\",Matchs!J29,\"\")","v":2},null,null,null,3.1663715747362029,3.2023573073080289,2.4156584642068326,{"$f":"IF(OR(E25=\"\",F25=\"\"),\"\",IF(E25>F25,J25,IF(E25=F25,K25,L25)))","v":3.2023573073080289}]
[23,21,"Espagne","Turquie",{"$f":"IF(Matchs!I30<>\"\",Matchs!I30,\"\")","v":3},{"$f":"IF(Matchs!J30<>\"\",Matchs!J30,\"\")","v":0},null,null,null,1.6918190638595783,2,3,1.6918190638595783]
[24,22,"Belgique","Irlande",{"$f":"IF(Matchs!I31<>\"\",Matchs!I31,\"\")","v":3},{"$f":"IF(Matchs!J31<>\"\",Matchs!J31,\"\")","v":0},null,null,null,1.5790910070955089,2,3,1.5790910070955089]
[25,23,"Islande","Hongrie",{"$f":"IF(Matchs!I32<>\"\",Matchs!I32,\"\")","v":1},{"$f":"IF(Matchs!J32<>\"\",Matchs!J32,\"\")","v":1},null,null,null,2.2098990007883899,3.2100855381444555,3.4576346480990492,{"$f":"IF(OR(E28=\"\",F28=\"\"),\"\",IF(E28>F28,J28,IF(E28=F28,K28,L28)))","v":3.2100855381444555}]
[26,24,"Portugal","Autriche",{"$f":"IF(Matchs!I33<>\"\",Matchs!I33,\"\")","v":0},{"$f":"IF(Matchs!J33<>\"\",Matchs!J33,\"\")","v":0},null,null,null,2.1455443334209323,3.2511206153493841,3.3786260720110053,3.2511206153493841]
[27,25,"Suisse","France",{"$f":"IF(Matchs!I34<>\"\",Matchs!I34,\"\")","v":0},{"$f":"IF(Matchs!J34<>\"\",Matchs!J34,\"\")","v":0},null,null,null,3,2,1.8755385934816173,2]
[28,26,"Roumanie","Albanie",{"$f":"IF(Matchs!I35<>\"\",Matchs!I35,\"\")","v":0},{"$f":"IF(Matchs!J35<>\"\",Matchs!J35,\"\")","v":1},null,null,null,1.969504925935659,3.3001245128165988,3.8198473413345564,{"$f":"IF(OR(E31=\"\",F31=\"\"),\"\",IF(E31>F31,J31,IF(E31=F31,K31,L31)))","v":3.8198473413345564}]
[29,27,"Slovaquie","Angleterre",{"$f":"IF(Matchs!I36<>\"\",Matchs!I36,\"\")","v":0},{"$f":"IF(Matchs!J36<>\"\",Matchs!J36,\"\")","v":0},null,null,null,3,2,1.772043686339279,2]
[30,28,"Russie","Pays de Galles",{"$f":"IF(Matchs!I37<>\"\",Matchs!I37,\"\")","v":0},{"$f":"IF(Matchs!J37<>\"\",Matchs!J37,\"\")","v":3},null,null,null,2.4707346287152547,3.2561743767014391,3.2083931770535128,3.2083931770535128]
[31,29,"Irlande du Nord","Allemagne",{"$f":"IF(Matchs!I38<>\"\",Matchs!I38,\"\")","v":0},{"$f":"IF(Matchs!J38<>\"\",Matchs!J38,\"\")","v":1},null,null,null,3,2,1.2924492984821421,{"$f":"IF(OR(E34=\"\",F34=\"\"),\"\",IF(E34>F34,J34,IF(E34=F34,K34,L34)))","v":1.2924492984821421}]
[32,30,"Ukraine","Pologne",{"$f":"IF(Matchs!I39<>\"\",Matchs!I39,\"\")","v":0},{"$f":"IF(Matchs!J39<>\"\",Matchs!J39,\"\")","v":1},null,null,null,3.6481765907115431,3.4384172488020592,2.3747165887202382,2.3747165887202382]
[33,31,"Croatie","Espagne",{"$f":"IF(Matchs!I40<>\"\",Matchs!I40,\"\")","v":2},{"$f":"IF(Matchs!J40<>\"\",Matchs!J40,\"\")","v":1},null,null,null,3,2,1.96052406541336,3]
[34,32,"Rép. Tchèque","Turquie",{"$f":"IF(Matchs!I41<>\"\",Matchs!I41,\"\")","v":0},{"$f":"IF(Matchs!J41<>\"\",Matchs!J41,\"\")","v":2},null,null,null,2.7740515628482907,3.1967705833185445,2.574502673934818,{"$f":"IF(OR(E37=\"\",F37=\"\"),\"\",IF(E37>F37,J37,IF(E37=F37,K37,L37)))","v":2.574502673934818}]
[35,33,"Hongrie","Portugal",{"$f":"IF(Matchs!I42<>\"\",Matchs!I42,\"\")","v":3},{"$f":"IF(Matchs!J42<>\"\",Matchs!J42,\"\")","v":3},null,null,null,3,2,1.6616114082149798,2]
[36,34,"Islande","Autriche",{"$f":"IF(Matchs!I43<>\"\",Matchs!I43,\"\")","v":2},{"$f":"IF(Matchs!J43<>\"\",Matchs!J43,\"\")","v":1},null,null,null,3,2,1.9568457120238867,3]
[37,35,"Suède","Belgique",{"$f":"IF(Matchs!I44<>\"\",Matchs!I44,\"\")","v":0},{"$f":"IF(Matchs!J44<>\"\",Matchs!J44,\"\")","v":1},null,null,null,3,2,2.0676153791607885,{"$f":"IF(OR(E40=\"\",F40=\"\"),\"\",IF(E40>F40,J40,IF(E40=F40,K40,L40)))","v":2.0676153791607885}]
[38,36,"Italie","Irlande",{"$f":"IF(Matchs!I45<>\"\",Matchs!I45,\"\")","v":0},{"$f":"IF(Matchs!J45<>\"\",Matchs!J45,\"\")","v":1},null,null,null,1.9494568608543874,2,3,{"$f":"IF(OR(E41=\"\",F41=\"\"),\"\",IF(E41>F41,J41,IF(E41=F41,K41,L41)))","v":3}]
[39,"H1",{"$f":"E57","v":"Suisse"},{"$f":"E58","v":"Pologne"},{"$f":"IF(Matchs!I48<>\"\",Matchs!I48,\"\")","v":1},{"$f":"IF(Matchs!J48<>\"\",Matchs!J48,\"\")","v":1},{"$f":"IF(AND(Matchs!I48<>\"\",Matchs!I48=Matchs!J48),Matchs!L48,\"\")","v":1},{"$f":"IF(AND(Matchs!I48<>\"\",Matchs!I48=Matchs!J48),Matchs!M48,\"\")","v":1},{"$f":"IF(AND(G42<>\"\",G42<>H42),\"\",IF(G42<>H42,D42,IF(AND(ISBLANK(Matchs!N48),ISBLANK(Matchs!S48)),\"\",IF(Matchs!N48=\"x\",C42,D42))))","v":"Pologne"},3.05,2.91,2.58,{"$f":"IF(OR(E42=\"\",F42=\"\",J42=\"\"),\"\",IF(E42>F42,J42,IF(E42=F42,K42,L42)))","v":2.91}]
[40,"H2",{"$f":"E61","v":"Croatie"},{"$f":"E62","v":"Portugal"},{"$f":"IF(Matchs!I50<>\"\",Matchs!I50,\"\")","v":0},{"$f":"IF(Matchs!J50<>\"\",Matchs!J50,\"\")","v":0},{"$f":"IF(AND(Matchs!I50<>\"\",Matchs!I50=Matchs!J50),Matchs!L50,\"\")","v":0},{"$f":"IF(AND(Matchs!I50<>\"\",Matchs!I50=Matchs!J50),Matchs!M50,\"\")","v":1},{"$f":"IF(AND(G43<>\"\",G43<>H43),\"\",IF(G43<>H43,D43,IF(AND(ISBLANK(Matchs!N50),ISBLANK(Matchs!S50)),\"\",IF(Matchs!N50=\"x\",C43,D43))))","v":""},2.46,2.91,2.85,2.91]
[41,"H3",{"$f":"E59","v":"Pays de Galles"},{"$f":"E60","v":"Irlande du Nord"},{"$f":"IF(Matchs!I49<>\"\",Matchs!I49,\"\")","v":1},{"$f":"IF(Matchs!J49<>\"\",Matchs!J49,\"\")","v":0},{"$f":"IF(AND(Matchs!I49<>\"\",Matchs!I49=Matchs!J49),Matchs!L49,\"\")","v":""},{"$f":"IF(AND(Matchs!I49<>\"\",Matchs!I49=Matchs!J49),Matchs!M49,\"\")","v":""},{"$f":"IF(AND(G44<>\"\",G44<>H44),\"\",IF(G44<>H44,D44,IF(AND(ISBLANK(Matchs!N49),ISBLANK(Matchs!S49)),\"\",IF(Matchs!N49=\"x\",C44,D44))))","v":""},1.89,2.75,3,1.89]
[42,"H4",{"$f":"E69","v":"Italie"},{"$f":"E70","v":"Espagne"},{"$f":"IF(Matchs!I54<>\"\",Matchs!I54,\"\")","v":2},{"$f":"IF(Matchs!J54<>\"\",Matchs!J54,\"\")","v":0},{"$f":"IF(AND(Matchs!I54<>\"\",Matchs!I54=Matchs!J54),Matchs!L54,\"\")","v":""},{"$f":"IF(AND(Matchs!I54<>\"\",Matchs!I54=Matchs!J54),Matchs!M54,\"\")","v":""},{"$f":"IF(AND(G45<>\"\",G45<>H45),\"\",IF(G45<>H45,D45,IF(AND(ISBLANK(Matchs!N54),ISBLANK(Matchs!S54)),\"\",IF(Matchs!N54=\"x\",C45,D45))))","v":""},3,2.94,2.12,3]
[43,"H5",{"$f":"E65","v":"Allemagne"},{"$f":"E66","v":"Slovaquie"},{"$f":"IF(Matchs!I52<>\"\",Matchs!I52,\"\")","v":3},{"$f":"IF(Matchs!J52<>\"\",Matchs!J52,\"\")","v":0},{"$f":"IF(AND(Matchs!I52<>\"\",Matchs!I52=Matchs!J52),Matchs!L52,\"\")","v":""},{"$f":"IF(AND(Matchs!I52<>\"\",Matchs!I52=Matchs!J52),Matchs!M52,\"\")","v":""},{"$f":"IF(AND(G46<>\"\",G46<>H46),\"\",IF(G46<>H46,D46,IF(AND(ISBLANK(Matchs!N52),ISBLANK(Matchs!S52)),\"\",IF(Matchs!N52=\"x\",C46,D46))))","v":""},1.38,2,3,{"$f":"IF(OR(E46=\"\",F46=\"\",J46=\"\"),\"\",IF(E46>F46,J46,IF(E46=F46,K46,L46)))","v":1.38}]
[44,"H6",{"$f":"E63","v":"France"},{"$f":"E64","v":"Irlande"},{"$f":"IF(Matchs!I51<>\"\",Matchs!I51,\"\")","v":2},{"$f":"IF(Matchs!J51<>\"\",Matchs!J51,\"\")","v":1},{"$f":"IF(AND(Matchs!I51<>\"\",Matchs!I51=Matchs!J51),Matchs!L51,\"\")","v":""},{"$f":"IF(AND(Matchs!I51<>\"\",Matchs!I51=Matchs!J51),Matchs!M51,\"\")","v":""},{"$f":"IF(AND(G47<>\"\",G47<>H47),\"\",IF(G47<>H47,D47,IF(AND(ISBLANK(Matchs!N51),ISBLANK(Matchs!S51)),\"\",IF(Matchs!N51=\"x\",C47,D47))))","v":""},1.44,2,3,{"$f":"IF(OR(E47=\"\",F47=\"\",J47=\"\"),\"\",IF(E47>F47,J47,IF(E47=F47,K47,L47)))","v":1.44}]
[45,"H7",{"$f":"+E67","v":"Hongrie"},{"$f":"+E68","v":"Belgique"},{"$f":"IF(Matchs!I53<>\"\",Matchs!I53,\"\")","v":0},{"$f":"IF(Matchs!J53<>\"\",Matchs!J53,\"\")","v":4},{"$f":"IF(AND(Matchs!I53<>\"\",Matchs!I53=Matchs!J53),Matchs!L53,\"\")","v":""},{"$f":"IF(AND(Matchs!I53<>\"\",Matchs!I53=Matchs!J53),Matchs!M53,\"\")","v":""},{"$f":"IF(AND(G48<>\"\",G48<>H48),\"\",IF(G48<>H48,D48,IF(AND(ISBLANK(Matchs!N53),ISBLANK(Matchs!S53)),\"\",IF(Matchs!N53=\"x\",C48,D48))))","v":""},3,2,1.57,1.57]
[46,"H8",{"$f":"E71","v":"Angleterre"},{"$f":"E72","v":"Islande"},{"$f":"IF(Matchs!I55<>\"\",Matchs!I55,\"\")","v":1},{"$f":"IF(Matchs!J55<>\"\",Matchs!J55,\"\")","v":2},{"$f":"IF(AND(Matchs!I55<>\"\",Matchs!I55=Matchs!J55),Matchs!L55,\"\")","v":""},{"$f":"IF(AND(Matchs!I55<>\"\",Matchs!I55=Matchs!J55),Matchs!M55,\"\")","v":""},{"$f":"IF(AND(G49<>\"\",G49<>H49),\"\",IF(G49<>H49,D49,IF(AND(ISBLANK(Matchs!N55),ISBLANK(Matchs!S55)),\"\",IF(Matchs!N55=\"x\",C49,D49))))","v":""},1.5,2,3,3]
[47,"Q1",{"$f":"E73","v":"Pologne"},{"$f":"E74","v":"Portugal"},{"$f":"IF(Matchs!I58<>\"\",Matchs!I58,\"\")","v":1},{"$f":"IF(Matchs!J58<>\"\",Matchs!J58,\"\")","v":1},{"$f":"IF(AND(Matchs!I58<>\"\",Matchs!I58=Matchs!J58),Matchs!L58,\"\")","v":1},{"$f":"IF(AND(Matchs!I58<>\"\",Matchs!I58=Matchs!J58),Matchs!M58,\"\")","v":1},{"$f":"IF(AND(G50<>\"\",G50<>H50),\"\",IF(G50<>H50,D50,IF(AND(ISBLANK(Matchs!N58),ISBLANK(Matchs!S58)),\"\",IF(Matchs!N58=\"x\",C50,D50))))","v":"Portugal"},null,null,null,""]
[48,"Q2",{"$f":"E75","v":"Pays de Galles"},{"$f":"E76","v":"Belgique"},{"$f":"IF(Matchs!I59<>\"\",Matchs!I59,\"\")","v":3},{"$f":"IF(Matchs!J59<>\"\",Matchs!J59,\"\")","v":1},{"$f":"IF(AND(Matchs!I59<>\"\",Matchs!I59=Matchs!J59),Matchs!L59,\"\")","v":""},{"$f":"IF(AND(Matchs!I59<>\"\",Matchs!I59=Matchs!J59),Matchs!M59,\"\")","v":""},{"$f":"IF(AND(G51<>\"\",G51<>H51),\"\",IF(G51<>H51,D51,IF(AND(ISBLANK(Matchs!N59),ISBLANK(Matchs!S59)),\"\",IF(Matchs!N59=\"x\",C51,D51))))","v":""},null,null,null,""]
[49,"Q3",{"$f":"E77","v":"Allemagne"},{"$f":"E78","v":"Italie"},{"$f":"IF(Matchs!I60<>\"\",Matchs!I60,\"\")","v":1},{"$f":"IF(Matchs!J60<>\"\",Matchs!J60,\"\")","v":1},{"$f":"IF(AND(Matchs!I60<>\"\",Matchs!I60=Matchs!J60),Matchs!L60,\"\")","v":1},{"$f":"IF(AND(Matchs!I60<>\"\",Matchs!I60=Matchs!J60),Matchs!M60,\"\")","v":1},{"$f":"IF(AND(G52<>\"\",G52<>H52),\"\",IF(G52<>H52,D52,IF(AND(ISBLANK(Matchs!N60),ISBLANK(Matchs!S60)),\"\",IF(Matchs!N60=\"x\",C52,D52))))","v":"Allemagne"},null,null,null,""]
[50,"Q4",{"$f":"E79","v":"France"},{"$f":"E80","v":"Islande"},{"$f":"IF(Matchs!I61<>\"\",Matchs!I61,\"\")","v":5},{"$f":"IF(Matchs!J61<>\"\",Matchs!J61,\"\")","v":2},{"$f":"IF(AND(Matchs!I61<>\"\",Matchs!I61=Matchs!J61),Matchs!L61,\"\")","v":""},{"$f":"IF(AND(Matchs!I61<>\"\",Matchs!I61=Matchs!J61),Matchs!M61,\"\")","v":""},{"$f":"IF(AND(G53<>\"\",G53<>H53),\"\",IF(G53<>H53,D53,IF(AND(ISBLANK(Matchs!N61),ISBLANK(Matchs!S61)),\"\",IF(Matchs!N61=\"x\",C53,D53))))","v":""},null,null,null,""]
[51,"D1",{"$f":"E81","v":"Portugal"},{"$f":"E82","v":"Pays de Galles"},{"$f":"IF(Matchs!I64<>\"\",Matchs!I64,\"\")","v":2},{"$f":"IF(Matchs!J64<>\"\",Matchs!J64,\"\")","v":0},{"$f":"IF(AND(Matchs!I64<>\"\",Matchs!I64=Matchs!J64),Matchs!L64,\"\")","v":""},{"$f":"IF(AND(Matchs!I64<>\"\",Matchs!I64=Matchs!J64),Matchs!M64,\"\")","v":""},{"$f":"IF(AND(G54<>\"\",G54<>H54),\"\",IF(G54<>H54,D54,IF(AND(ISBLANK(Matchs!N64),ISBLANK(Matchs!S64)),\"\",IF(Matchs!N64=\"x\",C54,D54))))","v":""},null,null,null,""]
[52,"D2",{"$f":"E83","v":"Allemagne"},{"$f":"E84","v":"France"},{"$f":"IF(Matchs!I65<>\"\",Matchs!I65,\"\")","v":0},{"$f":"IF(Matchs!J65<>\"\",Matchs!J65,\"\")","v":2},{"$f":"IF(AND(Matchs!I65<>\"\",Matchs!I65=Matchs!J65),Matchs!L65,\"\")","v":""},{"$f":"IF(AND(Matchs!I65<>\"\",Matchs!I65=Matchs!J65),Matchs!M65,\"\")","v":""},{"$f":"IF(AND(G55<>\"\",G55<>H55),\"\",IF(G55<>H55,D55,IF(AND(ISBLANK(Matchs!N65),ISBLANK(Matchs!S65)),\"\",IF(Matchs!N65=\"x\",C55,D55))))","v":""},null,null,null,""]
[53,"F",{"$f":"E85","v":"Portugal"},{"$f":"E86","v":"France"},{"$f":"IF(Matchs!I68<>\"\",Matchs!I68,\"\")","v":""},{"$f":"IF(Matchs!J68<>\"\",Matchs!J68,\"\")","v":""},{"$f":"IF(AND(Matchs!I68<>\"\",Matchs!I68=Matchs!J68),Matchs!L68,\"\")","v":""},{"$f":"IF(AND(Matchs!I68<>\"\",Matchs!I68=Matchs!J68),Matchs!M68,\"\")","v":""},{"$f":"IF(AND(G56<>\"\",G56<>H56),\"\",IF(G56<>H56,D56,IF(AND(ISBLANK(Matchs!N68),ISBLANK(Matchs!S68)),\"\",IF(Matchs!N68=\"x\",C56,D56))))","v":""},null,null,null,""]
[54,"H","8è de Finaliste 1 (5*Cote PTS)",null,{"$f":"IF(Huitieme1<>\"\",Huitieme1,\"\")","v":"Suisse"},null,null,null,null,null,null,null,{"$f":"IF(E57<>\"\",VLOOKUP(E57,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":5}]
[55,null,"8è de Finaliste 2 (5*Cote PTS)",null,{"$f":"IF(Huitieme2<>\"\",Huitieme2,\"\")","v":"Pologne"},null,null,null,null,null,null,null,{"$f":"IF(E58<>\"\",VLOOKUP(E58,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":2}]
[56,null,"8è de Finaliste 3 (5*Cote PTS)",null,{"$f":"IF(Huitieme3<>\"\",Huitieme3,\"\")","v":"Pays de Galles"},null,null,null,null,null,null,null,{"$f":"IF(E59<>\"\",VLOOKUP(E59,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":2}]
[57,null,"8è de Finaliste 4 (5*Cote PTS)",null,{"$f":"IF(Huitieme4<>\"\",Huitieme4,\"\")","v":"Irlande du Nord"},null,null,null,null,null,null,null,{"$f":"IF(E60<>\"\",VLOOKUP(E60,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":2.7}]
[58,null,"8è de Finaliste 5 (5*Cote PTS)",null,{"$f":"IF(Huitieme5<>\"\",Huitieme5,\"\")","v":"Croatie"},null,null,null,null,null,null,null,{"$f":"IF(E61<>\"\",VLOOKUP(E61,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":8}]
[59,null,"8è de Finaliste 6 (5*Cote PTS)",null,{"$f":"IF(Huitieme6<>\"\",Huitieme6,\"\")","v":"Portugal"},null,null,null,null,null,null,null,{"$f":"IF(E62<>\"\",VLOOKUP(E62,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":1}]
[60,null,"8è de Finaliste 7 (5*Cote PTS)",null,{"$f":"IF(Huitieme7<>\"\",Huitieme7,\"\")","v":"France"},null,null,null,null,null,null,null,{"$f":"IF(E63<>\"\",VLOOKUP(E63,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":1}]
[61,null,"8è de Finaliste 8 (5*Cote PTS)",null,{"$f":"IF(Huitieme8<>\"\",Huitieme8,\"\")","v":"Irlande"},null,null,null,null,null,null,null,{"$f":"IF(E64<>\"\",VLOOKUP(E64,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":1.8}]
[62,null,"8è de Finaliste 9 (5*Cote PTS)",null,{"$f":"IF(Huitieme9<>\"\",Huitieme9,\"\")","v":"Allemagne"},null,null,null,null,null,null,null,{"$f":"IF(E65<>\"\",VLOOKUP(E65,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":1.1000000000000001}]
[63,null,"8è de Finaliste 10 (5*Cote PTS)",null,{"$f":"IF(Huitieme10<>\"\",Huitieme10,\"\")","v":"Slovaquie"},null,null,null,null,null,null,null,{"$f":"IF(E66<>\"\",VLOOKUP(E66,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":9}]
[64,null,"8è de Finaliste 11 (5*Cote PTS)",null,{"$f":"IF(Huitieme11<>\"\",Huitieme11,\"\")","v":"Hongrie"},null,null,null,null,null,null,null,{"$f":"IF(E67<>\"\",VLOOKUP(E67,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":6}]
[65,null,"8è de Finaliste 12 (5*Cote PTS)",null,{"$f":"IF(Huitieme12<>\"\",Huitieme12,\"\")","v":"Belgique"},null,null,null,null,null,null,null,{"$f":"IF(E68<>\"\",VLOOKUP(E68,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":1.1000000000000001}]
[66,null,"8è de Finaliste 13 (5*Cote PTS)",null,{"$f":"IF(Huitieme13<>\"\",Huitieme13,\"\")","v":"Italie"},null,null,null,null,null,null,null,{"$f":"IF(E69<>\"\",VLOOKUP(E69,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":1.5}]
[67,null,"8è de Finaliste 14 (5*Cote PTS)",null,{"$f":"IF(Huitieme14<>\"\",Huitieme14,\"\")","v":"Espagne"},null,null,null,null,null,null,null,{"$f":"IF(E70<>\"\",VLOOKUP(E70,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":1.3}]
[68,null,"8è de Finaliste 15 (5*Cote PTS)",null,{"$f":"IF(Huitieme15<>\"\",Huitieme15,\"\")","v":"Angleterre"},null,null,null,null,null,null,null,{"$f":"IF(E71<>\"\",VLOOKUP(E71,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":1}]
[69,null,"8è de Finaliste 16 (5*Cote PTS)",null,{"$f":"IF(Huitieme16<>\"\",Huitieme16,\"\")","v":"Islande"},null,null,null,null,null,null,null,{"$f":"IF(E72<>\"\",VLOOKUP(E72,Matchs!$BH$11:$BJ$44,3,FALSE),\"\")","v":1.6}]
[70,"Q","Quart de Finaliste 1 (12PTS)",null,{"$f":"IF(Quarts1<>\"\",Quarts1,\"\")","v":"Pologne"}]
[71,null,"Quart de Finaliste 2 (12PTS)",null,{"$f":"IF(Quarts2<>\"\",Quarts2,\"\")","v":"Portugal"}]
[72,null,"Quart de Finaliste 3 (12PTS)",null,{"$f":"IF(Quarts3<>\"\",Quarts3,\"\")","v":"Pays de Galles"}]
[73,null,"Quart de Finaliste 4 (12PTS)",null,{"$f":"IF(Quarts4<>\"\",Quarts4,\"\")","v":"Belgique"}]
[74,null,"Quart de Finaliste 5 (12PTS)",null,{"$f":"IF(Quarts5<>\"\",Quarts5,\"\")","v":"Allemagne"}]
[75,null,"Quart de Finaliste 6 (12PTS)",null,{"$f":"IF(Quarts6<>\"\",Quarts6,\"\")","v":"Italie"}]
[76,null,"Quart de Finaliste 7 (12PTS)",null,{"$f":"IF(Quarts7<>\"\",Quarts7,\"\")","v":"France"}]
[77,null,"Quart de Finaliste 8 (12PTS)",null,{"$f":"IF(Quarts8<>\"\",Quarts8,\"\")","v":"Islande"}]
[78,"D","Demi Finaliste 1 (20PTS)",null,{"$f":"IF(Demi1<>\"\",Demi1,\"\")","v":"Portugal"}]
[79,null,"Demi Finaliste 2 (20PTS)",null,{"$f":"IF(Demi2<>\"\",Demi2,\"\")","v":"Pays de Galles"}]
[80,null,"Demi Finaliste 3 (20PTS)",null,{"$f":"IF(Demi3<>\"\",Demi3,\"\")","v":"Allemagne"}]
[81,null,"Demi Finaliste 4 (20PTS)",null,{"$f":"IF(Demi4<>\"\",Demi4,\"\")","v":"France"}]
[82,"F","Finaliste 1 (35PTS)",null,{"$f":"IF(Finale1<>\"\",Finale1,\"\")","v":"Portugal"}]
[83,null,"Finaliste 2 (35PTS)",null,{"$f":"IF(Finale2<>\"\",Finale2,\"\")","v":"France"}]
[84,"V","Vainqueur (50PTS)",null,{"$f":"IF(Vainqueur<>\"\",Vainqueur,\"\")","v":""}]

{"sheet":"Verif","index":3,"n_rows":52,"n_cols":3,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,"tous joues compt"]
[null,{"$f":"SUMPRODUCT((ISNUMBER(Matchs!I10:I45))+(ISNUMBER(Matchs!J10:J45)))","v":72},"tous joues groupes"]
[null,{"$f":"SUMPRODUCT((ISNUMBER(Matchs!I48:I55))+(ISNUMBER(Matchs!J48:J55)))","v":16},"tous joués huitiemes"]
[null,{"$f":"SUMPRODUCT((ISNUMBER(Matchs!I58:I61))+(ISNUMBER(Matchs!J58:J61)))","v":8},"tous joues quarts"]
[null,{"$f":"SUMPRODUCT((ISNUMBER(Matchs!I64:I65))+(ISNUMBER(Matchs!J64:J65)))","v":4},"tous joués demi"]
[null,{"$f":"SUMPRODUCT((ISNUMBER(Matchs!I68:I68))+(ISNUMBER(Matchs!J68:J68)))","v":0},"tous joués finale"]
[null,{"$f":"SUM(B3:B7)","v":100},"tous joués compet"]
[]
[]
[]
[]
[]
[]
[]
[null,"ALARCON denis"]
[null,"BOUKHELIFA rachid"]
[null,"BOUSSAGUET cyril"]
[null,"BROCHIER martial"]
[null,"CHARRA johanna"]
[null,"COLONEL yoann"]
[null,"COMES herve"]
[null,"CORNU alexis"]
[null,"COUTURIER stéphane"]
[null,"DAGUIER anthony"]
[null,"DHALLUIN michael"]
[null,"DURANTI bernard"]
[null,"ESMINGEAUD thomas"]
[null,"GAILLOT fabrice"]
[null,"GOUBIN alain"]
[null,"GRUFFAZ guillaume"]
[null,"GUIRAO michael"]
[null,"HARLE francois"]
[null,"JELLOULI boul'"]
[null,"LABOISNE sylvain"]
[null,"LAVERDURE jeremy"]
[null,"LE GARLANTEZEC yves"]
[null,"LESAFFRE thierry"]
[null,"LESCUYER mikael"]
[null,"LOPEZ rené"]
[null,"MAHIOUZ larbi"]
[null,"MICHALLON olivier"]
[null,"MILLET alex"]
[null,"MOCHE philippe"]
[null,"REQUENA nico"]
[null,"RIMA heliel"]
[null,"RONI serge"]
[null,"ROUSSE philippe"]
[null,"SONZOGNI christophe"]
[null,"STRIPPOLI andre"]
[null,"VAN NIJNATTEN roberto"]
[null,"VIRY julien"]