{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Euro 2016 vierge"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Euro 2016 vierge","index":0,"n_rows":65,"n_cols":58,"rows_kept":65,"cut":false,"hidden":false,"merged":[[45,23,46,23],[45,24,46,24],[46,16,47,16],[48,16,49,16],[46,17,47,17],[48,17,49,17],[45,21,46,21],[45,22,46,22],[46,18,47,18],[46,19,47,19],[48,18,49,18],[48,19,49,19],[37,26,38,26],[37,27,38,27],[42,47,44,47],[42,48,44,48],[42,49,44,49],[42,50,44,50],[42,51,44,51],[63,46,64,46],[63,47,64,47],[46,31,47,34],[45,31,45,34],[39,1,44,1],[39,26,40,26],[39,27,40,27],[40,16,41,16],[40,17,41,17],[42,16,43,16],[42,17,43,17],[40,18,41,18],[40,19,41,19],[42,18,43,18],[42,19,43,19],[43,21,44,21],[43,22,44,22],[43,23,44,23],[43,24,44,24],[33,1,38,1],[33,21,34,21],[33,22,34,22],[34,16,35,16],[34,17,35,17],[36,16,37,16],[34,18,35,18],[34,19,35,19],[36,18,37,18],[36,19,37,19],[36,17,37,17],[24,16,25,16],[24,17,25,17],[25,31,26,31],[25,32,26,32],[27,1,32,1],[27,31,28,31],[27,32,28,32],[28,16,29,16],[28,17,29,17],[21,1,26,1],[21,21,22,21],[21,22,22,22],[22,16,23,16],[22,17,23,17],[22,18,23,18],[22,19,23,19],[30,16,31,16],[30,17,31,17],[31,21,32,21],[31,22,32,22],[30,18,31,18],[30,19,31,19],[28,18,29,18],[28,19,29,19],[15,1,20,1],[15,26,16,26],[15,27,16,27],[16,16,17,16],[16,17,17,17],[16,18,17,18],[16,19,17,19],[18,18,19,18],[18,19,19,19],[18,16,19,16],[18,17,19,17],[19,21,20,21],[19,22,20,22],[7,24,8,24],[8,3,8,6],[8,9,8,14],[9,1,14,1],[9,21,10,21],[9,22,10,22],[10,16,11,16],[10,17,11,17],[12,16,13,16],[12,17,13,17],[10,18,11,18],[10,19,11,19],[12,18,13,18],[12,19,13,19],[16,37,16,42],[9,24,10,24],[19,23,20,23],[19,24,20,24],[21,23,22,23],[21,24,22,24],[24,18,25,18],[24,19,25,19],[3,16,3,17],[3,21,3,22],[3,26,3,27],[3,37,3,42],[4,16,5,16],[4,17,5,17],[6,16,7,16],[6,17,7,17],[7,21,8,21],[7,22,8,22],[3,31,3,32],[4,18,5,18],[6,18,7,18],[4,19,5,19],[6,19,7,19],[7,23,8,23],[2,2,6,14],[39,28,40,28],[39,29,40,29],[1,26,2,29],[1,31,2,34],[25,33,26,33],[25,34,26,34],[27,33,28,33],[27,34,28,34],[13,28,14,28],[13,29,14,29],[15,28,16,28],[15,29,16,29],[37,28,38,28],[37,29,38,29],[31,23,32,23],[31,24,32,24],[33,23,34,23],[33,24,34,24],[9,23,10,23],[13,26,14,26],[13,27,14,27],[1,16,2,19],[1,21,2,24]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"⅛ de Finale\n6 TF1 - 2 BeIN",null,null,null,null,"¼ de Finale\n3 TF1 - 1 M6",null,null,null,null,"½ Finale\n1 TF1 - 1 M6",null,null,null,null,"Finale\nM6"]
[null,null,"Règles des pronostics EURO 2016\nPhase de poules : score exact : 3pts, résultat correct : 1pt, résultat faux : 0pt.\nQualification : équipe qualifiée et à la bonne place de sa poule : 2pts, équipe qualifiée : 1pt, sinon 0pt.\nTour principal : score exact : 5 pts, bon qualifié au bon moment (tps régl., prolong., tab) : 3 pts, bon qualifié 1 pt, sinon 0pt.\nTour principal : NB :si l'équipe qualifiée est bonne mais que l'équipe adverse n'est pas la bonne, les points ci-dessus sont divisés par 2."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pr.","TàB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Troisièmes des 6 Groupes",null,null,null,null,null,null,null,null,"Pays","BP","BC","+/-","Points","Points en tout","Pays",null,null,null,"Max","Pays"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K12","v":"France"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groupes","Équipes","Points",{"$f":"\"+/-\"","v":"+/-"},"BP","Total",null,null,null,{"$f":"D10","v":"France"},{"$f":"SUM(E10,E13,E14)","v":0},{"$f":"SUM(F10,F13,F14)","v":0},{"$f":"SUM(AV5,-AW5)","v":0},{"$f":"COUNTIF(H10:H15,D10)*3+COUNTIF(H10,\"Égalité\")+COUNTIF(H13:H14,\"Égalité\")","v":0},{"$f":"SUM(AY5,AX5/100,AV5/10000)","v":0},{"$f":"D10","v":"France"},{"$f":"IF(AZ5=AZ6,AZ5+$E$13/10000,AZ5)","v":0},{"$f":"IF(AZ5=AZ7,AZ5+$E$10/10000,AZ5)","v":0},{"$f":"IF(AZ5=AZ8,AZ5+$E$14/10000,AZ5)","v":0},{"$f":"MAX(BB5:BD5)","v":0},{"$f":"D10","v":"France"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"K13","v":"France"},{"$f":"L13","v":0},{"$f":"O13","v":0},{"$f":"M13","v":0},{"$f":"AN6+0.01*AO6+0.0001*AP6","v":0},{"$f":"K13","v":"France"},"A",null,{"$f":"D11","v":"Albanie"},{"$f":"SUM(E11,F13,F15)","v":0},{"$f":"SUM(F11,E13,E15)","v":0},{"$f":"SUM(AV6,-AW6)","v":0},{"$f":"COUNTIF(H10:H15,D11)*3+COUNTIF(H11,\"Égalité\")+COUNTIF(H13,\"Égalité\")+COUNTIF(H15,\"Égalité\")","v":0},{"$f":"SUM(AY6,AX6/100,AV6/10000)","v":0},{"$f":"D11","v":"Albanie"},{"$f":"IF(AZ6=AZ5,AZ6+$F$13/10000,AZ6)","v":0},{"$f":"IF(AZ6=AZ7,AZ6+$F$15/10000,AZ6)","v":0},{"$f":"IF(AZ6=AZ8,AZ6+$E$11/10000,AZ6)","v":0},{"$f":"MAX(BB6:BD6)","v":0},{"$f":"D11","v":"Albanie"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K24","v":"Pologne"},null,null,null,null,null,null,"Pr.","TàB",null,null,null,null,null,null,null,null,null,null,null,null,"B",{"$f":"K19","v":"P. Galles"},{"$f":"L19","v":0},{"$f":"O19","v":0},{"$f":"M19","v":0},{"$f":"AN7+0.01*AO7+0.0001*AP7","v":0},{"$f":"K19","v":"P. Galles"},"B",null,{"$f":"G10","v":"Roumanie"},{"$f":"SUM(F10,E12,E15)","v":0},{"$f":"SUM(E10,F12,F15)","v":0},{"$f":"SUM(AV7,-AW7)","v":0},{"$f":"COUNTIF(H10:H15,G10)*3+COUNTIF(H10,\"Égalité\")+COUNTIF(H12,\"Égalité\")+COUNTIF(H15,\"Égalité\")","v":0},{"$f":"SUM(AY7,AX7/100,AV7/10000)","v":0},{"$f":"G10","v":"Roumanie"},{"$f":"IF(AZ7=AZ5,AZ7+$F$10/10000,AZ7)","v":0},{"$f":"IF(AZ7=AZ6,AZ7+$E$15/10000,AZ7)","v":0},{"$f":"IF(AZ7=AZ8,AZ7+$E$12/10000,AZ7)","v":0},{"$f":"MAX(BB7:BD7)","v":0},{"$f":"G10","v":"Roumanie"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R5<>R7,IF(R5>R7,Q5,Q7),IF(S5<>S7,IF(S5>S7,Q5,Q7),IF(T5<>T7,IF(T5>T7,Q5,Q7),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",{"$f":"K25","v":"Pologne"},{"$f":"L25","v":0},{"$f":"O25","v":0},{"$f":"M25","v":0},{"$f":"AN8+0.01*AO8+0.0001*AP8","v":0},{"$f":"K25","v":"Pologne"},"C",null,{"$f":"G11","v":"Suisse"},{"$f":"SUM(F11,F12,F14)","v":0},{"$f":"SUM(E11,E12,E14)","v":0},{"$f":"SUM(AV8,-AW8)","v":0},{"$f":"COUNTIF(H10:H15,G11)*3+COUNTIF(H11:H12,\"Égalité\")+COUNTIF(H14,\"Égalité\")","v":0},{"$f":"SUM(AY8,AX8/100,AV8/10000)","v":0},{"$f":"G11","v":"Suisse"},{"$f":"IF(AZ8=AZ5,AZ8+$F$14/10000,AZ8)","v":0},{"$f":"IF(AZ8=AZ6,AZ8+$F$11/10000,AZ8)","v":0},{"$f":"IF(AZ8=AZ7,AZ8+$F$12/10000,AZ8)","v":0},{"$f":"MAX(BB8:BD8)","v":0},{"$f":"G11","v":"Suisse"}]
[null,"Gr.","Date/Heure","Matchs",null,null,null,"Vainqueur",null,"Résultats des Poules",null,null,null,null,null,null,"25-06 15h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",{"$f":"K31","v":"Turquie"},{"$f":"L31","v":0},{"$f":"O31","v":0},{"$f":"M31","v":0},{"$f":"AN9+0.01*AO9+0.0001*AP9","v":0},{"$f":"K31","v":"Turquie"},"D"]
[null,"A","10-06 21h TF1","France",null,null,"Roumanie",{"$f":"IF(E10>F10,D10,IF(E10<F10,G10,IF(E10=\"\",\"Non joué\",IF(E10=F10,\"Égalité\"))))","v":"Non joué"},null,"Pos.","Pays","Points","BP","BC","+/-",null,null,null,"Pr.","TàB",null,{"$f":"IF(R11<>R13,IF(R11>R13,Q11,Q13),IF(S11<>S13,IF(S11>S13,Q11,Q13),IF(T11<>T13,IF(T11>T13,Q11,Q13),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",{"$f":"K37","v":"Belgique"},{"$f":"L37","v":0},{"$f":"O37","v":0},{"$f":"M37","v":0},{"$f":"AN10+0.01*AO10+0.0001*AP10","v":0},{"$f":"K37","v":"Belgique"},"E",null,"Pays","BP","BC","+/-","Points","Points en tout","Pays",null,null,null,"Max","Pays"]
[null,null,"11-06 15h TF1","Albanie",null,null,"Suisse",{"$f":"IF(E11>F11,D11,IF(E11<F11,G11,IF(E11=\"\",\"Non joué\",IF(E11=F11,\"Égalité\"))))","v":"Non joué"},null,1,{"$f":"VLOOKUP(MAX(BE5:BE8),BE5:BF8,2,FALSE)","v":"France"},{"$f":"VLOOKUP(K11,AU5:AY8,5,FALSE)","v":0},{"$f":"VLOOKUP(K11,AU5:AV8,2,FALSE)","v":0},{"$f":"VLOOKUP(K11,AU5:AW8,3,FALSE)","v":0},{"$f":"VLOOKUP(K11,AU5:AX8,4,FALSE)","v":0},null,{"$f":"K29","v":"Turquie"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",{"$f":"K43","v":"Autriche"},{"$f":"L43","v":0},{"$f":"O43","v":0},{"$f":"M43","v":0},{"$f":"AN11+0.01*AO11+0.0001*AP11","v":0},{"$f":"K43","v":"Autriche"},"F",null,{"$f":"D16","v":"P. Galles"},{"$f":"SUM(E16,F19,F21)","v":0},{"$f":"SUM(F16,E19,E21)","v":0},{"$f":"SUM(AV11,-AW11)","v":0},{"$f":"COUNTIF(H16:H21,D16)*3+COUNTIF(H16,\"Égalité\")+COUNTIF(H19,\"Égalité\")+COUNTIF(H21,\"Égalité\")","v":0},{"$f":"SUM(AY11,AX11/100,AV11/10000)","v":0},{"$f":"D16","v":"P. Galles"},{"$f":"IF(AZ11=AZ12,AZ11+$F$19/10000,AZ11)","v":0},{"$f":"IF(AZ11=AZ13,AZ11+$E$16/10000,AZ11)","v":0},{"$f":"IF(AZ11=AZ14,AZ11+$F$21/10000,AZ11)","v":0},{"$f":"MAX(BB11:BD11)","v":0},{"$f":"D16","v":"P. Galles"}]
[null,null,"15-06 18h TF1",{"$f":"G10","v":"Roumanie"},null,null,{"$f":"G11","v":"Suisse"},{"$f":"IF(E12>F12,D12,IF(E12<F12,G12,IF(E12=\"\",\"Non joué\",IF(E12=F12,\"Égalité\"))))","v":"Non joué"},null,2,{"$f":"VLOOKUP(LARGE(BE5:BE8,2),BE5:BF8,2,FALSE)","v":"France"},{"$f":"VLOOKUP(K12,AU5:AY8,5,FALSE)","v":0},{"$f":"VLOOKUP(K12,AU5:AV8,2,FALSE)","v":0},{"$f":"VLOOKUP(K12,AU5:AW8,3,FALSE)","v":0},{"$f":"VLOOKUP(K12,AU5:AX8,4,FALSE)","v":0},null,null,null,null,null,null,"30-06 21h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D17","v":"Angleterre"},{"$f":"SUM(E17,E19:E20)","v":0},{"$f":"SUM(F17,F19:F20)","v":0},{"$f":"SUM(AV12,-AW12)","v":0},{"$f":"COUNTIF(H16:H21,D17)*3+COUNTIF(H17,\"Égalité\")+COUNTIF(H19:H20,\"Égalité\")","v":0},{"$f":"SUM(AY12,AX12/100,AV12/10000)","v":0},{"$f":"D17","v":"Angleterre"},{"$f":"IF(AZ12=AZ11,AZ12+$E$19/10000,AZ12)","v":0},{"$f":"IF(AZ12=AZ13,AZ12+$E$20/10000,AZ12)","v":0},{"$f":"IF(AZ12=AZ14,AZ12+$E$17/10000,AZ12)","v":0},0,{"$f":"D17","v":"Angleterre"}]
[null,null,"15-06 21h TF1",{"$f":"D10","v":"France"},null,null,{"$f":"D11","v":"Albanie"},{"$f":"IF(E13>F13,D13,IF(E13<F13,G13,IF(E13=\"\",\"Non joué\",IF(E13=F13,\"Égalité\"))))","v":"Non joué"},null,3,{"$f":"VLOOKUP(LARGE(BE5:BE8,3),BE5:BF8,2,FALSE)","v":"France"},{"$f":"VLOOKUP(K13,AU5:AY8,5,FALSE)","v":0},{"$f":"VLOOKUP(K13,AU5:AV8,2,FALSE)","v":0},{"$f":"VLOOKUP(K13,AU5:AW8,3,FALSE)","v":0},{"$f":"VLOOKUP(K13,AU5:AX8,4,FALSE)","v":0},null,{"$f":"AZ65","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"Pr.","TàB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G16","v":"Slovaquie"},{"$f":"SUM(F16,F18,F20)","v":0},{"$f":"SUM(E16,E18,E20)","v":0},0,{"$f":"COUNTIF(H16:H21,G16)*3+COUNTIF(H16,\"Égalité\")+COUNTIF(H18,\"Égalité\")+COUNTIF(H20,\"Égalité\")","v":0},0,{"$f":"G16","v":"Slovaquie"},{"$f":"IF(AZ13=AZ11,AZ13+$F$16/10000,AZ13)","v":0},{"$f":"IF(AZ13=AZ12,AZ13+$F$20/10000,AZ13)","v":0},{"$f":"IF(AZ13=AZ14,AZ13+$F$18/10000,AZ13)","v":0},0,{"$f":"G16","v":"Slovaquie"}]
[null,null,"19-06 21h M6",{"$f":"D10","v":"France"},null,null,{"$f":"G11","v":"Suisse"},{"$f":"IF(E14>F14,D14,IF(E14<F14,G14,IF(E14=\"\",\"Non joué\",IF(E14=F14,\"Égalité\"))))","v":"Non joué"},null,4,{"$f":"VLOOKUP(LARGE(BE5:BE8,4),BE5:BF8,2,FALSE)","v":"France"},{"$f":"VLOOKUP(K14,AU5:AY8,5,FALSE)","v":0},{"$f":"VLOOKUP(K14,AU5:AV8,2,FALSE)","v":0},{"$f":"VLOOKUP(K14,AU5:AW8,3,FALSE)","v":0},{"$f":"VLOOKUP(K14,AU5:AX8,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W8<>W10,IF(W8>W10,V8,V10),IF(X8<>X10,IF(X8>X10,V8,V10),IF(Y8<>Y10,IF(Y8>Y10,V8,V10),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G17","v":"Russie"},{"$f":"SUM(F17,E18,E21)","v":0},{"$f":"SUM(E17,F18,F21)","v":0},0,{"$f":"COUNTIF(H16:H21,G17)*3+COUNTIF(H17:H18,\"Égalité\")+COUNTIF(H21,\"Égalité\")","v":0},0,{"$f":"G17","v":"Russie"},{"$f":"IF(AZ14=AZ11,AZ14+$E$21/10000,AZ14)","v":0},{"$f":"IF(AZ14=AZ12,AZ14+$F$17/10000,AZ14)","v":0},{"$f":"IF(AZ14=AZ13,AZ14+$E$18/10000,AZ14)","v":0},0,{"$f":"G17","v":"Russie"}]
[null,null,"19-06 21h BeIN",{"$f":"G10","v":"Roumanie"},null,null,{"$f":"D11","v":"Albanie"},{"$f":"IF(E15>F15,D15,IF(E15<F15,G15,IF(E15=\"\",\"Non joué\",IF(E15=F15,\"Égalité\"))))","v":"Non joué"},null,null,null,null,null,null,null,null,"25-06 21h"]
[null,"B","11-06 18h beIN","P. Galles",null,null,"Slovaquie","Non joué",null,"Pos.","Pays","Points","BP","BC","+/-",null,null,null,"Pr.","TàB",null,null,null,null,null,null,{"$f":"IF(W20<>W22,IF(W20>W22,V20,V22),IF(X20<>X22,IF(X20>X22,V20,V22),IF(Y20<>Y22,IF(Y20>Y22,V20,V22),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pays","BP","BC","+/-","Points","Points en tout","Pays",null,null,null,"Max","Pays"]
[null,null,"11-06 21h M6","Angleterre",null,null,"Russie","Non joué",null,1,{"$f":"VLOOKUP(MAX(BE11:BE14),BE11:BF14,2,FALSE)","v":"P. Galles"},{"$f":"VLOOKUP(K17,AU11:AY14,5,FALSE)","v":0},{"$f":"VLOOKUP(K17,AU11:AV14,2,FALSE)","v":0},{"$f":"VLOOKUP(K17,AU11:AW14,3,FALSE)","v":0},{"$f":"VLOOKUP(K17,AU11:AX14,4,FALSE)","v":0},null,{"$f":"K17","v":"P. Galles"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 Meilleurs Troisièmes Qualifiés",null,null,null,null,null,null,null,null,{"$f":"D22","v":"Pologne"},{"$f":"SUM(E22,F25,F27)","v":0},{"$f":"SUM(F22,E25,E27)","v":0},{"$f":"SUM(AV17,-AW17)","v":0},{"$f":"COUNTIF(H22:H27,D22)*3+COUNTIF(H22,\"Égalité\")+COUNTIF(H25,\"Égalité\")+COUNTIF(H27,\"Égalité\")","v":0},{"$f":"SUM(AY17,AX17/100,AV17/10000)","v":0},{"$f":"D22","v":"Pologne"},{"$f":"IF(AZ17=AZ18,AZ17+$F$25/10000,AZ17)","v":0},{"$f":"IF(AZ17=AZ19,AZ17+$E$22/10000,AZ17)","v":0},{"$f":"IF(AZ17=AZ20,AZ17+$F$27/10000,AZ17)","v":0},0,{"$f":"D22","v":"Pologne"}]
[null,null,"15-06 15h beIN",{"$f":"G17","v":"Russie"},null,null,{"$f":"G16","v":"Slovaquie"},"Non joué",null,2,{"$f":"VLOOKUP(LARGE(BE11:BE14,2),BE11:BF14,2,FALSE)","v":"P. Galles"},{"$f":"VLOOKUP(K18,AU11:AY14,5,FALSE)","v":0},{"$f":"VLOOKUP(K18,AU11:AV14,2,FALSE)","v":0},{"$f":"VLOOKUP(K18,AU11:AW14,3,FALSE)","v":0},{"$f":"VLOOKUP(K18,AU11:AX14,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,"06-07 21h",null,null,null,null,null,null,null,null,null,null,"Rang","Groupe","Équipes","Points",{"$f":"\"+/-\"","v":"+/-"},"BP",null,null,null,{"$f":"D23","v":"Allemagne"},{"$f":"SUM(E23,E25:E26)","v":0},{"$f":"SUM(F23,F25:F26)","v":0},{"$f":"SUM(AV18,-AW18)","v":0},{"$f":"COUNTIF(H22:H27,D23)*3+COUNTIF(H23,\"Égalité\")+COUNTIF(H25:H26,\"Égalité\")","v":0},{"$f":"SUM(AY18,AX18/100,AV18/10000)","v":0},{"$f":"D23","v":"Allemagne"},{"$f":"IF(AZ18=AZ17,AZ18+$E$25/10000,AZ18)","v":0},{"$f":"IF(AZ18=AZ19,AZ18+$E$26/10000,AZ18)","v":0},{"$f":"IF(AZ18=AZ20,AZ18+$E$23/10000,AZ18)","v":0},0,{"$f":"D23","v":"Allemagne"}]
[null,null,"16-06 15h beIN",{"$f":"D17","v":"Angleterre"},null,null,{"$f":"D16","v":"P. Galles"},"Non joué",null,3,{"$f":"VLOOKUP(LARGE(BE11:BE14,3),BE11:BF14,2,FALSE)","v":"P. Galles"},{"$f":"VLOOKUP(K19,AU11:AY14,5,FALSE)","v":0},{"$f":"VLOOKUP(K19,AU11:AV14,2,FALSE)","v":0},{"$f":"VLOOKUP(K19,AU11:AW14,3,FALSE)","v":0},{"$f":"VLOOKUP(K19,AU11:AX14,4,FALSE)","v":0},null,{"$f":"AX65","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Pr.","TàB",null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(AN19,$AR$6:$BA$11,2,FALSE)","v":"A"},{"$f":"VLOOKUP(MAX(AQ6:AQ11),AQ6:AR11,2,FALSE)","v":"France"},{"$f":"VLOOKUP(AN19,$AM$6:$AP$11,2,FALSE)","v":0},{"$f":"VLOOKUP($AN19,$AM$6:$AP$11,3,FALSE)","v":0},{"$f":"VLOOKUP($AN19,$AM$6:$AP$11,4,FALSE)","v":0},null,null,null,{"$f":"G22","v":"Irlande N."},{"$f":"SUM(F22,F24,F26)","v":0},{"$f":"SUM(E22,E24,E26)","v":0},0,{"$f":"COUNTIF(H22:H27,G22)*3+COUNTIF(H22,\"Égalité\")+COUNTIF(H24,\"Égalité\")+COUNTIF(H26,\"Égalité\")","v":0},0,{"$f":"G22","v":"Irlande N."},{"$f":"IF(AZ19=AZ17,AZ19+$F$22/10000,AZ19)","v":0},{"$f":"IF(AZ19=AZ18,AZ19+$F$26/10000,AZ19)","v":0},{"$f":"IF(AZ19=AZ20,AZ19+$F$24/10000,AZ19)","v":0},0,{"$f":"G22","v":"Irlande N."}]
[null,null,"20-06 21h TF1",{"$f":"D17","v":"Angleterre"},null,null,{"$f":"G16","v":"Slovaquie"},"Non joué",null,4,{"$f":"VLOOKUP(LARGE(BE11:BE14,4),BE11:BF14,2,FALSE)","v":"P. Galles"},{"$f":"VLOOKUP(K20,AU11:AY14,5,FALSE)","v":0},{"$f":"VLOOKUP(K20,AU11:AV14,2,FALSE)","v":0},{"$f":"VLOOKUP(K20,AU11:AW14,3,FALSE)","v":0},{"$f":"VLOOKUP(K20,AU11:AX14,4,FALSE)","v":0},null,null,null,null,null,null,{"$f":"IF(R17<>R19,IF(R17>R19,Q17,Q19),IF(S17<>S19,IF(S17>S19,Q17,Q19),IF(T17<>T19,IF(T17>T19,Q17,Q19),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"A",{"$f":"VLOOKUP(LARGE(AQ6:AQ11,2),AQ6:AR11,2,FALSE)","v":"France"},0,0,0,null,null,null,{"$f":"G23","v":"Ukraine"},{"$f":"SUM(F23,E24,E27)","v":0},{"$f":"SUM(E23,F24,F27)","v":0},0,{"$f":"COUNTIF(H22:H27,G23)*3+COUNTIF(H23:H24,\"Égalité\")+COUNTIF(H27,\"Égalité\")","v":0},0,{"$f":"G23","v":"Ukraine"},{"$f":"IF(AZ20=AZ17,AZ20+$E$27/10000,AZ20)","v":0},{"$f":"IF(AZ20=AZ18,AZ20+$F$23/10000,AZ20)","v":0},{"$f":"IF(AZ20=AZ19,AZ20+$E$24/10000,AZ20)","v":0},0,{"$f":"G23","v":"Ukraine"}]
[null,null,"20-06 21h beIN",{"$f":"D18","v":"Russie"},null,null,{"$f":"G19","v":"P. Galles"},"Non joué",null,null,null,null,null,null,null,null,"25-06 18h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"A",{"$f":"VLOOKUP(LARGE(AQ6:AQ11,3),AQ6:AR11,2,FALSE)","v":"France"},0,0,0]
[null,"C","12-06 18h beIN","Pologne",null,null,"Irlande N.","Non joué",null,"Pos.","Pays","Points","BP","BC","+/-",null,null,null,"Pr.","TàB",null,{"$f":"IF(R23<>R25,IF(R23>R25,Q23,Q25),IF(S23<>S25,IF(S23>S25,Q23,Q25),IF(T23<>T25,IF(T23>T25,Q23,Q25),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"A",{"$f":"VLOOKUP(LARGE(AQ6:AQ11,4),AQ6:AR11,2,FALSE)","v":"France"},0,0,0,null,null,null,"Pays","BP","BC","+/-","Points","Points en tout","Pays",null,null,null,"Max","Pays"]
[null,null,"12-06 21h TF1","Allemagne",null,null,"Ukraine","Non joué",null,1,{"$f":"VLOOKUP(MAX(BE17:BE20),BE17:BF20,2,FALSE)","v":"Pologne"},{"$f":"VLOOKUP(K23,AU17:AY20,5,FALSE)","v":0},{"$f":"VLOOKUP(K23,AU17:AV20,2,FALSE)","v":0},{"$f":"VLOOKUP(K23,AU17:AW20,3,FALSE)","v":0},{"$f":"VLOOKUP(K23,AU17:AX20,4,FALSE)","v":0},null,{"$f":"K41","v":"Autriche"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"A",{"$f":"VLOOKUP(LARGE(AQ6:AQ11,5),AQ6:AR11,2,FALSE)","v":"France"},0,0,0,null,null,null,{"$f":"D28","v":"Turquie"},{"$f":"SUM(E28,F31,F33)","v":0},{"$f":"SUM(F28,E31,E33)","v":0},{"$f":"SUM(AV23,-AW23)","v":0},{"$f":"COUNTIF(H28:H33,D28)*3+COUNTIF(H28,\"Égalité\")+COUNTIF(H31,\"Égalité\")+COUNTIF(H33,\"Égalité\")","v":0},{"$f":"SUM(AY23,AX23/100,AV23/10000)","v":0},{"$f":"D28","v":"Turquie"},{"$f":"IF(AZ23=AZ24,AZ23+$F$31/10000,AZ23)","v":0},{"$f":"IF(AZ23=AZ25,AZ23+$E$28/10000,AZ23)","v":0},{"$f":"IF(AZ23=AZ26,AZ23+$F$33/10000,AZ23)","v":0},0,{"$f":"D28","v":"Turquie"}]
[null,null,"16-06 18h beIN",{"$f":"G23","v":"Ukraine"},null,null,{"$f":"G22","v":"Irlande N."},"Non joué",null,2,{"$f":"VLOOKUP(LARGE(BE17:BE20,2),BE17:BF20,2,FALSE)","v":"Pologne"},{"$f":"VLOOKUP(K24,AU17:AY20,5,FALSE)","v":0},{"$f":"VLOOKUP(K24,AU17:AV20,2,FALSE)","v":0},{"$f":"VLOOKUP(K24,AU17:AW20,3,FALSE)","v":0},{"$f":"VLOOKUP(K24,AU17:AX20,4,FALSE)","v":0},null,null,null,null,null,null,"01-07 21h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"A",{"$f":"VLOOKUP(MIN(AQ6:AQ11),AQ6:AR11,2,FALSE)","v":"France"},0,0,0,null,null,null,{"$f":"D29","v":"Espagne"},{"$f":"SUM(E29,E31:E32)","v":0},{"$f":"SUM(F29,F31:F32)","v":0},{"$f":"SUM(AV24,-AW24)","v":0},{"$f":"COUNTIF(H28:H33,D29)*3+COUNTIF(H29,\"Égalité\")+COUNTIF(H31:H32,\"Égalité\")","v":0},{"$f":"SUM(AY24,AX24/100,AV24/10000)","v":0},{"$f":"D29","v":"Espagne"},{"$f":"IF(AZ24=AZ23,AZ24+$E$31/10000,AZ24)","v":0},{"$f":"IF(AZ24=AZ25,AZ24+$E$32/10000,AZ24)","v":0},{"$f":"IF(AZ24=AZ26,AZ24+$E$29/10000,AZ24)","v":0},0,{"$f":"D29","v":"Espagne"}]
[null,null,"16-06 21h M6",{"$f":"D23","v":"Allemagne"},null,null,{"$f":"D22","v":"Pologne"},"Non joué",null,3,{"$f":"VLOOKUP(LARGE(BE17:BE20,3),BE17:BF20,2,FALSE)","v":"Pologne"},{"$f":"VLOOKUP(K25,AU17:AY20,5,FALSE)","v":0},{"$f":"VLOOKUP(K25,AU17:AV20,2,FALSE)","v":0},{"$f":"VLOOKUP(K25,AU17:AW20,3,FALSE)","v":0},{"$f":"VLOOKUP(K25,AU17:AX20,4,FALSE)","v":0},null,{"$f":"K36","v":"Belgique"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pr.","TàB",null,null,null,null,null,null,null,null,null,null,null,{"$f":"G28","v":"Croatie"},{"$f":"SUM(F28,F30,F32)","v":0},{"$f":"SUM(E28,E30,E32)","v":0},0,{"$f":"COUNTIF(H28:H33,G28)*3+COUNTIF(H28,\"Égalité\")+COUNTIF(H30,\"Égalité\")+COUNTIF(H32,\"Égalité\")","v":0},0,{"$f":"G28","v":"Croatie"},{"$f":"IF(AZ25=AZ23,AZ25+$F$28/10000,AZ25)","v":0},{"$f":"IF(AZ25=AZ24,AZ25+$F$32/10000,AZ25)","v":0},{"$f":"IF(AZ25=AZ26,AZ25+$F$30/10000,AZ25)","v":0},0,{"$f":"G28","v":"Croatie"}]
[null,null,"21-06 18h beIN",{"$f":"D23","v":"Allemagne"},null,null,{"$f":"G22","v":"Irlande N."},"Non joué",null,4,{"$f":"VLOOKUP(LARGE(BE17:BE20,4),BE17:BF20,2,FALSE)","v":"Pologne"},{"$f":"VLOOKUP(K26,AU17:AY20,5,FALSE)","v":0},{"$f":"VLOOKUP(K26,AU17:AV20,2,FALSE)","v":0},{"$f":"VLOOKUP(K26,AU17:AW20,3,FALSE)","v":0},{"$f":"VLOOKUP(K26,AU17:AX20,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB14<>AB16,IF(AB14>AB16,AA14,AA16),IF(AC14<>AC16,IF(AC14>AC16,AA14,AA16),IF(AD14<>AD16,IF(AD14>AD16,AA14,AA16),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G29","v":"R. Tchèque"},{"$f":"SUM(F29,E30,E33)","v":0},{"$f":"SUM(E29,F30,F33)","v":0},0,{"$f":"COUNTIF(H28:H33,G29)*3+COUNTIF(H29:H30,\"Égalité\")+COUNTIF(H33,\"Égalité\")","v":0},0,{"$f":"G29","v":"R. Tchèque"},{"$f":"IF(AZ26=AZ23,AZ26+$E$33/10000,AZ26)","v":0},{"$f":"IF(AZ26=AZ24,AZ26+$F$29/10000,AZ26)","v":0},{"$f":"IF(AZ26=AZ25,AZ26+$E$30/10000,AZ26)","v":0},0,{"$f":"G29","v":"R. Tchèque"}]
[null,null,"21-06 18h beIN",{"$f":"G23","v":"Ukraine"},null,null,{"$f":"D22","v":"Pologne"},"Non joué",null,null,null,null,null,null,null,null,"26-06 21h"]
[null,"D","12-06 15h TF1","Turquie",null,null,"Croatie","Non joué",null,"Pos.","Pays","Points","BP","BC","+/-",null,null,null,"Pr.","TàB",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB38<>AB40,IF(AB38>AB40,AA38,AA40),IF(AC38<>AC40,IF(AC38>AC40,AA38,AA40),IF(AD38<>AD40,IF(AD38>AD40,AA38,AA40),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pays","BP","BC","+/-","Points","Points en tout","Pays",null,null,null,"Max","Pays"]
[null,null,"13-06 15h beIN","Espagne",null,null,"R. Tchèque","Non joué",null,1,{"$f":"VLOOKUP(MAX(BE23:BE26),BE23:BF26,2,FALSE)","v":"Turquie"},{"$f":"VLOOKUP(K29,AU23:AY26,5,FALSE)","v":0},{"$f":"VLOOKUP(K29,AU23:AV26,2,FALSE)","v":0},{"$f":"VLOOKUP(K29,AU23:AW26,3,FALSE)","v":0},{"$f":"VLOOKUP(K29,AU23:AX26,4,FALSE)","v":0},null,{"$f":"K23","v":"Pologne"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D34","v":"Belgique"},{"$f":"SUM(E34,E37:E38)","v":0},{"$f":"SUM(F34,F37:F38)","v":0},{"$f":"SUM(AV29,-AW29)","v":0},{"$f":"COUNTIF(H34:H39,D34)*3+COUNTIF(H34,\"Égalité\")+COUNTIF(H37:H38,\"Égalité\")","v":0},{"$f":"SUM(AY29,AX29/100,AV29/10000)","v":0},{"$f":"D34","v":"Belgique"},{"$f":"IF(AZ29=AZ30,AZ29+$E$37/10000,AZ29)","v":0},{"$f":"IF(AZ29=AZ31,AZ29+$E$34/10000,AZ29)","v":0},{"$f":"IF(AZ29=AZ32,AZ29+$E$38/10000,AZ29)","v":0},0,{"$f":"D34","v":"Belgique"}]
[null,null,"17-06 18h beIN",{"$f":"G29","v":"R. Tchèque"},null,null,{"$f":"G28","v":"Croatie"},"Non joué",null,2,{"$f":"VLOOKUP(LARGE(BE23:BE26,2),BE23:BF26,2,FALSE)","v":"Turquie"},{"$f":"VLOOKUP(K30,AU23:AY26,5,FALSE)","v":0},{"$f":"VLOOKUP(K30,AU23:AV26,2,FALSE)","v":0},{"$f":"VLOOKUP(K30,AU23:AW26,3,FALSE)","v":0},{"$f":"VLOOKUP(K30,AU23:AX26,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-07 21h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D35","v":"Irlande"},{"$f":"SUM(E35,F37,F39)","v":0},{"$f":"SUM(F35,E37,E39)","v":0},{"$f":"SUM(AV30,-AW30)","v":0},{"$f":"COUNTIF(H34:H39,D35)*3+COUNTIF(H35,\"Égalité\")+COUNTIF(H37,\"Égalité\")+COUNTIF(H39,\"Égalité\")","v":0},{"$f":"SUM(AY30,AX30/100,AV30/10000)","v":0},{"$f":"D35","v":"Irlande"},{"$f":"IF(AZ30=AZ29,AZ30+$F$37/10000,AZ30)","v":0},{"$f":"IF(AZ30=AZ31,AZ30+$F$39/10000,AZ30)","v":0},{"$f":"IF(AZ30=AZ32,AZ30+$E$35/10000,AZ30)","v":0},0,{"$f":"D35","v":"Irlande"}]
[null,null,"17-06 21h M6",{"$f":"D29","v":"Espagne"},null,null,{"$f":"D28","v":"Turquie"},"Non joué",null,3,{"$f":"VLOOKUP(LARGE(BE23:BE26,3),BE23:BF26,2,FALSE)","v":"Turquie"},{"$f":"VLOOKUP(K31,AU23:AY26,5,FALSE)","v":0},{"$f":"VLOOKUP(K31,AU23:AV26,2,FALSE)","v":0},{"$f":"VLOOKUP(K31,AU23:AW26,3,FALSE)","v":0},{"$f":"VLOOKUP(K31,AU23:AX26,4,FALSE)","v":0},null,{"$f":"AY65","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Pr.","TàB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G34","v":"Italie"},{"$f":"SUM(E39,F35,F37)","v":0},{"$f":"SUM(E35,E37,F39)","v":0},0,{"$f":"COUNTIF(H34:H39,G34)*3+COUNTIF(H34,\"Égalité\")+COUNTIF(H36,\"Égalité\")+COUNTIF(H39,\"Égalité\")","v":0},0,{"$f":"G34","v":"Italie"},{"$f":"IF(AZ31=AZ29,AZ31+$F$34/10000,AZ31)","v":0},{"$f":"IF(AZ31=AZ30,AZ31+$E$39/10000,AZ31)","v":0},{"$f":"IF(AZ31=AZ32,AZ31+$E$36/10000,AZ31)","v":0},0,{"$f":"G34","v":"Italie"}]
[null,null,"21-06 21h TF1",{"$f":"D29","v":"Espagne"},null,null,{"$f":"G28","v":"Croatie"},"Non joué",null,4,{"$f":"VLOOKUP(LARGE(BE23:BE26,4),BE23:BF26,2,FALSE)","v":"Turquie"},{"$f":"VLOOKUP(K32,AU23:AY26,5,FALSE)","v":0},{"$f":"VLOOKUP(K32,AU23:AV26,2,FALSE)","v":0},{"$f":"VLOOKUP(K32,AU23:AW26,3,FALSE)","v":0},{"$f":"VLOOKUP(K32,AU23:AX26,4,FALSE)","v":0},null,null,null,null,null,null,{"$f":"IF(R29<>R31,IF(R29>R31,Q29,Q31),IF(S29<>S31,IF(S29>S31,Q29,Q31),IF(T29<>T31,IF(T29>T31,Q29,Q31),\"\")))","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,{"$f":"G35","v":"Suède"},{"$f":"SUM(F35:F36,F38)","v":0},{"$f":"SUM(E35:E36,E38)","v":0},0,{"$f":"COUNTIF(H34:H39,G35)*3+COUNTIF(H35:H36,\"Égalité\")+COUNTIF(H38,\"Égalité\")","v":0},0,{"$f":"G35","v":"Suède"},{"$f":"IF(AZ32=AZ29,AZ32+$F$36/10000,AZ32)","v":0},{"$f":"IF(AZ32=AZ30,AZ32+$F$35/10000,AZ32)","v":0},{"$f":"IF(AZ32=AZ31,AZ32+$F$36/10000,AZ32)","v":0},0,{"$f":"G35","v":"Suède"}]
[null,null,"21-06 21h beIN",{"$f":"G29","v":"R. Tchèque"},null,null,{"$f":"D28","v":"Turquie"},"Non joué",null,null,null,null,null,null,null,null,"26-06 18h"]
[null,"E","12-06 21h M6","Belgique",null,null,"Italie","Non joué",null,"Pos.","Pays","Points","BP","BC","+/-",null,null,null,"Pr.","TàB",null,{"$f":"IF(R35<>R37,IF(R35>R37,Q35,Q37),IF(S35<>S37,IF(S35>S37,Q35,Q37),IF(T35<>T37,IF(T35>T37,Q35,Q37),\"\")))","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,"Pays","BP","BC","+/-","Points","Points en tout","Pays",null,null,null,"Max","Pays"]
[null,null,"13-06 18h beIN","Irlande",null,null,"Suède","Non joué",null,1,{"$f":"VLOOKUP(MAX(BE29:BE32),BE29:BF32,2,FALSE)","v":"Belgique"},{"$f":"VLOOKUP(K35,AU29:AY32,5,FALSE)","v":0},{"$f":"VLOOKUP(K35,AU29:AV32,2,FALSE)","v":0},{"$f":"VLOOKUP(K35,AU29:AW32,3,FALSE)","v":0},{"$f":"VLOOKUP(K35,AU29:AX32,4,FALSE)","v":0},null,{"$f":"K35","v":"Belgique"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D40","v":"Autriche"},{"$f":"SUM(E40,F43,F45)","v":0},{"$f":"SUM(F40,E43,E45)","v":0},{"$f":"SUM(AV35,-AW35)","v":0},{"$f":"COUNTIF(H40:H45,D40)*3+COUNTIF(H40,\"Égalité\")+COUNTIF(H43,\"Égalité\")+COUNTIF(H45,\"Égalité\")","v":0},{"$f":"SUM(AY35,AX35/100,AV35/10000)","v":0},{"$f":"D40","v":"Autriche"},{"$f":"IF(AZ35=AZ36,AZ35+$F$43/10000,AZ35)","v":0},{"$f":"IF(AZ35=AZ37,AZ35+$E$40/10000,AZ35)","v":0},{"$f":"IF(AZ35=AZ38,AZ35+$F$45/10000,AZ35)","v":0},0,{"$f":"D40","v":"Autriche"}]
[null,null,"17-06 15h TF1",{"$f":"G34","v":"Italie"},null,null,{"$f":"G35","v":"Suède"},"Non joué",null,2,{"$f":"VLOOKUP(LARGE(BE29:BE32,2),BE29:BF32,2,FALSE)","v":"Belgique"},{"$f":"VLOOKUP(K36,AU29:AY32,5,FALSE)","v":0},{"$f":"VLOOKUP(K36,AU29:AV32,2,FALSE)","v":0},{"$f":"VLOOKUP(K36,AU29:AW32,3,FALSE)","v":0},{"$f":"VLOOKUP(K36,AU29:AX32,4,FALSE)","v":0},null,null,null,null,null,null,"02-07 21h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D41","v":"Portugal"},{"$f":"SUM(E41,E43:E44)","v":0},{"$f":"SUM(F41,F43:F44)","v":0},{"$f":"SUM(AV36,-AW36)","v":0},{"$f":"COUNTIF(H40:H45,D41)*3+COUNTIF(H41,\"Égalité\")+COUNTIF(H43:H44,\"Égalité\")","v":0},{"$f":"SUM(AY36,AX36/100,AV36/10000)","v":0},{"$f":"D41","v":"Portugal"},{"$f":"IF(AZ36=AZ35,AZ36+$E$43/10000,AZ36)","v":0},{"$f":"IF(AZ36=AZ37,AZ36+$E$44/10000,AZ36)","v":0},{"$f":"IF(AZ36=AZ38,AZ36+$E$41/10000,AZ36)","v":0},0,{"$f":"D41","v":"Portugal"}]
[null,null,"18-06 15h TF1",{"$f":"D34","v":"Belgique"},null,null,{"$f":"D35","v":"Irlande"},"Non joué",null,3,{"$f":"VLOOKUP(LARGE(BE29:BE32,3),BE29:BF32,2,FALSE)","v":"Belgique"},{"$f":"VLOOKUP(K37,AU29:AY32,5,FALSE)","v":0},{"$f":"VLOOKUP(K37,AU29:AV32,2,FALSE)","v":0},{"$f":"VLOOKUP(K37,AU29:AW32,3,FALSE)","v":0},{"$f":"VLOOKUP(K37,AU29:AX32,4,FALSE)","v":0},null,{"$f":"K30","v":"Turquie"},null,null,null,null,null,null,null,null,null,null,null,"Pr.","TàB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G40","v":"Hongrie"},{"$f":"SUM(F40,F42,F44)","v":0},{"$f":"SUM(E40,E42,E44)","v":0},0,{"$f":"COUNTIF(H40:H45,G40)*3+COUNTIF(H40,\"Égalité\")+COUNTIF(H42,\"Égalité\")+COUNTIF(H44,\"Égalité\")","v":0},0,{"$f":"G40","v":"Hongrie"},{"$f":"IF(AZ37=AZ35,AZ37+$F$40/10000,AZ37)","v":0},{"$f":"IF(AZ37=AZ36,AZ37+$F$44/10000,AZ37)","v":0},{"$f":"IF(AZ37=AZ38,AZ37+$F$42/10000,AZ37)","v":0},0,{"$f":"G40","v":"Hongrie"}]
[null,null,"22-06 21h M6",{"$f":"D34","v":"Belgique"},null,null,{"$f":"G35","v":"Suède"},"Non joué",null,4,{"$f":"VLOOKUP(LARGE(BE29:BE32,4),BE29:BF32,2,FALSE)","v":"Belgique"},{"$f":"VLOOKUP(K38,AU29:AY32,5,FALSE)","v":0},{"$f":"VLOOKUP(K38,AU29:AV32,2,FALSE)","v":0},{"$f":"VLOOKUP(K38,AU29:AW32,3,FALSE)","v":0},{"$f":"VLOOKUP(K38,AU29:AX32,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W32<>W34,IF(W32>W34,V32,V34),IF(X32<>X34,IF(X32>X34,V32,V34),IF(Y32<>Y34,IF(Y32>Y34,V32,V34),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G41","v":"Islande"},{"$f":"SUM(F41,E42,E45)","v":0},{"$f":"SUM(E41,F42,F45)","v":0},0,{"$f":"COUNTIF(H40:H45,G41)*3+COUNTIF(H41:H42,\"Égalité\")+COUNTIF(H45,\"Égalité\")","v":0},0,{"$f":"G41","v":"Islande"},{"$f":"IF(AZ38=AZ35,AZ38+$E$45/10000,AZ38)","v":0},{"$f":"IF(AZ38=AZ36,AZ38+$F$41/10000,AZ38)","v":0},{"$f":"IF(AZ38=AZ37,AZ38+$E$42/10000,AZ38)","v":0},0,{"$f":"G41","v":"Islande"}]
[null,null,"22-06 21h beIN",{"$f":"G34","v":"Italie"},null,null,{"$f":"D35","v":"Irlande"},"Non joué",null,null,null,null,null,null,null,null,"27-06 18h"]
[null,"F","14-06 18h beIN","Autriche",null,null,"Hongrie","Non joué",null,"Pos.","Pays","Points","BP","BC","+/-",null,null,null,"Pr.","TàB",null,null,null,null,null,null,{"$f":"IF(W44<>W46,IF(W44>W46,V44,V46),IF(X44<>X46,IF(X44>X46,V44,V46),IF(Y44<>Y46,IF(Y44>Y46,V44,V46),\"\")))","v":""}]
[null,null,"14-06 21h TF1","Portugal",null,null,"Islande","Non joué",null,1,{"$f":"VLOOKUP(MAX(BE35:BE38),BE35:BF38,2,FALSE)","v":"Autriche"},{"$f":"VLOOKUP(K41,AU35:AY38,5,FALSE)","v":0},{"$f":"VLOOKUP(K41,AU35:AV38,2,FALSE)","v":0},{"$f":"VLOOKUP(K41,AU35:AW38,3,FALSE)","v":0},{"$f":"VLOOKUP(K41,AU35:AX38,4,FALSE)","v":0},null,{"$f":"K11","v":"France"}]
[null,null,"18-06 18h beIN",{"$f":"G41","v":"Islande"},null,null,{"$f":"G40","v":"Hongrie"},"Non joué",null,2,{"$f":"VLOOKUP(LARGE(BE35:BE38,2),BE35:BF38,2,FALSE)","v":"Autriche"},{"$f":"VLOOKUP(K42,AU35:AY38,5,FALSE)","v":0},{"$f":"VLOOKUP(K42,AU35:AV38,2,FALSE)","v":0},{"$f":"VLOOKUP(K42,AU35:AW38,3,FALSE)","v":0},{"$f":"VLOOKUP(K42,AU35:AX38,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,"07-07 21h"]
[null,null,"18-06 21h TF1",{"$f":"D41","v":"Portugal"},null,null,{"$f":"D40","v":"Autriche"},"Non joué",null,3,{"$f":"VLOOKUP(LARGE(BE35:BE38,3),BE35:BF38,2,FALSE)","v":"Autriche"},{"$f":"VLOOKUP(K43,AU35:AY38,5,FALSE)","v":0},{"$f":"VLOOKUP(K43,AU35:AV38,2,FALSE)","v":0},{"$f":"VLOOKUP(K43,AU35:AW38,3,FALSE)","v":0},{"$f":"VLOOKUP(K43,AU35:AX38,4,FALSE)","v":0},null,{"$f":"AW65","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Pr.","TàB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si les 4 meilleurs sont :","1A joue contre le 3e du groupe :","1B joue contre le 3e du groupe :","1C joue contre le 3e du groupe :","1D joue contre le 3e du groupe :"]
[null,null,"22-06 18h beIN",{"$f":"D41","v":"Portugal"},null,null,{"$f":"G40","v":"Hongrie"},"Non joué",null,4,{"$f":"VLOOKUP(LARGE(BE35:BE38,4),BE35:BF38,2,FALSE)","v":"Autriche"},{"$f":"VLOOKUP(K44,AU35:AY38,5,FALSE)","v":0},{"$f":"VLOOKUP(K44,AU35:AV38,2,FALSE)","v":0},{"$f":"VLOOKUP(K44,AU35:AW38,3,FALSE)","v":0},{"$f":"VLOOKUP(K44,AU35:AX38,4,FALSE)","v":0},null,null,null,null,null,null,{"$f":"IF(R41<>R43,IF(R41>R43,Q41,Q43),IF(S41<>S43,IF(S41>S43,Q41,Q43),IF(T41<>T43,IF(T41>T43,Q41,Q43),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 Meilleurs"]
[null,null,"22-06 18h beIN",{"$f":"G41","v":"Islande"},null,null,{"$f":"D40","v":"Autriche"},"Non joué",null,null,null,null,null,null,null,null,"26-06 15h"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pr.","TàB",null,{"$f":"IF(R47<>R49,IF(R47>R49,Q47,Q49),IF(S47<>S49,IF(S47>S49,Q47,Q49),IF(T47<>T49,IF(T47>T49,Q47,Q49),\"\")))","v":""},null,null,null,null,null,null,null,null,null,"VAINQUEUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABEF","E","A","B","F",null,{"$f":"IF(OR(\"A\"=$AM$19,\"A\"=$AM$20,\"A\"=$AM$21,\"A\"=$AM$22),\"A\",\"\")","v":"A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K18","v":"P. Galles"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG26<>AG28,IF(AG26>AG28,AF26,AF28),IF(AH26<>AH28,IF(AH26>AH28,AF26,AF28),IF(AI26<>AI28,IF(AI26>AI28,AF26,AF28),\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABCD","C","D","A","B",null,{"$f":"IF(OR(\"B\"=$AM$19,\"B\"=$AM$20,\"B\"=$AM$21,\"B\"=$AM$22),\"B\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03-07 21h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABCE","C","A","B","E",null,{"$f":"IF(OR(\"C\"=$AM$19,\"C\"=$AM$20,\"C\"=$AM$21,\"C\"=$AM$22),\"C\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K42","v":"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,"ABCF","C","A","B","F",null,{"$f":"IF(OR(\"D\"=$AM$19,\"D\"=$AM$20,\"D\"=$AM$21,\"D\"=$AM$22),\"D\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABDE","D","A","B","E",null,{"$f":"IF(OR(\"E\"=$AM$19,\"E\"=$AM$20,\"E\"=$AM$21,\"E\"=$AM$22),\"E\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27-06 21h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABDF","D","A","B","F",null,{"$f":"IF(OR(\"F\"=$AM$19,\"F\"=$AM$20,\"F\"=$AM$21,\"F\"=$AM$22),\"F\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABEF","E","A","B","F",null,"Résultat"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A. Gibot",null,null,"Mai 2016",null,null,null,null,null,null,null,null,null,null,null,"ACDE","C","D","A","E",null,{"$f":"CONCATENATE(BB46,BB47,BB48,BB49,BB50,BB51)","v":"A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACDF","C","D","A","F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACEF","C","A","F","E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADEF","D","A","F","E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BCDE","C","D","B","E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BCDF","C","D","B","F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BCEF","E","C","B","F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BDEF","E","D","B","F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDEF","C","D","F","E"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Résultat",{"$f":"BB53","v":"A"},{"$f":"VLOOKUP($AV$64,$AV$46:$AZ$61,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AV$64,$AV$46:$AZ$61,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AV$64,$AV$46:$AZ$61,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AV$64,$AV$46:$AZ$61,5,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AW64,$AL$6:$AM$11,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AX64,$AL$6:$AM$11,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]