{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Groupes","Groupe A","Groupe B","Groupe C","Groupe D","Groupe E","Groupe F","Classement des 3e","Tableau final","Règles de calcul","Report","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Groupes","index":0,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["France","Angleterre","Allemagne","Espagne","Belgique","Portugal"]
["Roumanie","Russie","Ukraine","République Tchèque","Italie","Islande"]
["Albanie","Pays de Galles","Pologne","Turquie","Irlande","Autriche"]
["Suisse","Slovaquie","Irlande du Nord","Croatie","Suède","Hongrie"]

{"sheet":"Groupe A","index":1,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,12,0],[13,0,14,0],[1,18,2,27],[9,18,12,27],[1,0,2,0],[3,0,4,0],[5,0,6,0],[7,0,8,0],[9,0,10,0]]}
[null,null,null,1]
["2016-06-10",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"France"},3,null,{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"France"},{"$f":"C2+C6+C10","v":8},{"$f":"C3+C7+C11","v":3},{"$f":"Victoire(C2,C3)+Victoire(C6,C7)+Victoire(C10,C11)","v":3},{"$f":"NUL(C2,C3)+NUL(C6,C7)+NUL(C10,C11)","v":0},{"$f":"Defaite(C2,C3)+Defaite(C6,C7)+Defaite(C10,C11)","v":0},{"$f":"H2+I2+J2","v":3},{"$f":"H2*3+I2","v":9},{"$f":"1000000+L2*100000+(F2-G2)*10000+F2*1000+0.4","v":1958000.4},{"$f":"IF(M2=MAX(M:M),1,M2)","v":1},{"$f":"IF(N2=MAX(N:N),2,N2)","v":1},{"$f":"IF(O2=MAX(O:O),3,O2)","v":1},{"$f":"IF(P2=MAX(P:P),4,P2)","v":1},null,"Classement"]
[null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Roumanie"},1,null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Roumanie"},{"$f":"C3+C8+C12","v":1},{"$f":"C2+C9+C13","v":6},{"$f":"Victoire(C3,C2)+Victoire(C8,C9)+Victoire(C12,C13)","v":0},{"$f":"NUL(C3,C2)+NUL(C8,C9)+NUL(C12,C13)","v":0},{"$f":"Defaite(C3,C2)+Defaite(C8,C9)+Defaite(C12,C13)","v":3},{"$f":"H3+I3+J3","v":3},{"$f":"H3*3+I3","v":0},{"$f":"1000000+L3*100000+(F3-G3)*10000+F3*1000+0.3","v":951000.3},{"$f":"IF(M3=MAX(M:M),1,M3)","v":951000.3},{"$f":"IF(N3=MAX(N:N),2,N3)","v":951000.3},{"$f":"IF(O3=MAX(O:O),3,O3)","v":951000.3},{"$f":"IF(P3=MAX(P:P),4,P3)","v":4}]
["2016-06-11",{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Albanie"},1,null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Albanie"},{"$f":"C4+C7+C13","v":3},{"$f":"C5+C6+C12","v":3},{"$f":"Victoire(C4,C5)+Victoire(C7,C6)+Victoire(C13,C12)","v":1},{"$f":"NUL(C4,C5)+NUL(C7,C6)+NUL(C13,C12)","v":1},{"$f":"Defaite(C4,C5)+Defaite(C7,C6)+Defaite(C13,C12)","v":1},{"$f":"H4+I4+J4","v":3},{"$f":"H4*3+I4","v":4},{"$f":"1000000+L4*100000+(F4-G4)*10000+F4*1000+0.2","v":1403000.2},{"$f":"IF(M4=MAX(M:M),1,M4)","v":1403000.2},{"$f":"IF(N4=MAX(N:N),2,N4)","v":1403000.2},{"$f":"IF(O4=MAX(O:O),3,O4)","v":3},{"$f":"IF(P4=MAX(P:P),4,P4)","v":3},null,null,null,"J","V","N","P","BP","BC","Diff","Pts"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Suisse"},1,null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Suisse"},{"$f":"C5+C9+C11","v":4},{"$f":"C4+C8+C10","v":4},{"$f":"Victoire(C5,C4)+Victoire(C9,C8)+Victoire(C11,C10)","v":1},{"$f":"NUL(C5,C4)+NUL(C9,C8)+NUL(C11,C10)","v":1},{"$f":"Defaite(C5,C4)+Defaite(C9,C8)+Defaite(C11,C10)","v":1},{"$f":"H5+I5+J5","v":3},{"$f":"H5*3+I5","v":4},{"$f":"1000000+L5*100000+(F5-G5)*10000+F5*1000+0.1","v":1404000.1},{"$f":"IF(M5=MAX(M:M),1,M5)","v":1404000.1},{"$f":"IF(N5=MAX(N:N),2,N5)","v":2},{"$f":"IF(O5=MAX(O:O),3,O5)","v":2},{"$f":"IF(P5=MAX(P:P),4,P5)","v":2},null,1,{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q2:Q5,0)+1,5))","v":"France"},{"$f":"INDIRECT(ADDRESS(MATCH(S5,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,8))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,9))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,10))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,6))","v":8},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,7))","v":3},{"$f":"Y5-Z5","v":5},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,12))","v":9}]
["2016-06-15",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"France"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q2:Q5,0)+1,5))","v":"Suisse"},{"$f":"INDIRECT(ADDRESS(MATCH(S6,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,8))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,10))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,6))","v":4},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,7))","v":4},{"$f":"Y6-Z6","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,12))","v":4}]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Albanie"},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q2:Q5,0)+1,5))","v":"Albanie"},{"$f":"INDIRECT(ADDRESS(MATCH(S7,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,8))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,10))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,6))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,7))","v":3},{"$f":"Y7-Z7","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,12))","v":4}]
["2016-06-15",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Roumanie"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q2:Q5,0)+1,5))","v":"Roumanie"},{"$f":"INDIRECT(ADDRESS(MATCH(S8,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,8))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,9))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,10))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,6))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,7))","v":6},{"$f":"Y8-Z8","v":-5},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,12))","v":0}]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Suisse"},2]
["2016-06-19",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"France"},3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groupe A"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Suisse"},1]
["2016-06-19",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Roumanie"},0]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Albanie"},1]

{"sheet":"Groupe B","index":2,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,12,0],[13,0,14,0],[9,18,12,27],[1,0,2,0],[1,18,2,27],[3,0,4,0],[5,0,6,0],[7,0,8,0],[9,0,10,0]]}
[null,null,null,2]
["2016-06-11",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Angleterre"},1,null,{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Angleterre"},{"$f":"C2+C6+C10","v":6},{"$f":"C3+C7+C11","v":4},{"$f":"Victoire(C2,C3)+Victoire(C6,C7)+Victoire(C10,C11)","v":1},{"$f":"NUL(C2,C3)+NUL(C6,C7)+NUL(C10,C11)","v":2},{"$f":"Defaite(C2,C3)+Defaite(C6,C7)+Defaite(C10,C11)","v":0},{"$f":"H2+I2+J2","v":3},{"$f":"H2*3+I2","v":5},{"$f":"1000000+L2*100000+(F2-G2)*10000+F2*1000+0.4","v":1526000.4},{"$f":"IF(M2=MAX(M:M),1,M2)","v":1526000.4},{"$f":"IF(N2=MAX(N:N),2,N2)","v":2},{"$f":"IF(O2=MAX(O:O),3,O2)","v":2},{"$f":"IF(P2=MAX(P:P),4,P2)","v":2},null,"Classement"]
[null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Russie"},1,null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Russie"},{"$f":"C3+C8+C12","v":5},{"$f":"C2+C9+C13","v":2},{"$f":"Victoire(C3,C2)+Victoire(C8,C9)+Victoire(C12,C13)","v":2},{"$f":"NUL(C3,C2)+NUL(C8,C9)+NUL(C12,C13)","v":1},{"$f":"Defaite(C3,C2)+Defaite(C8,C9)+Defaite(C12,C13)","v":0},{"$f":"H3+I3+J3","v":3},{"$f":"H3*3+I3","v":7},{"$f":"1000000+L3*100000+(F3-G3)*10000+F3*1000+0.3","v":1735000.3},{"$f":"IF(M3=MAX(M:M),1,M3)","v":1},{"$f":"IF(N3=MAX(N:N),2,N3)","v":1},{"$f":"IF(O3=MAX(O:O),3,O3)","v":1},{"$f":"IF(P3=MAX(P:P),4,P3)","v":1}]
["2016-06-11",{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Pays de Galles"},2,null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Pays de Galles"},{"$f":"C4+C7+C13","v":5},{"$f":"C5+C6+C12","v":4},{"$f":"Victoire(C4,C5)+Victoire(C7,C6)+Victoire(C13,C12)","v":1},{"$f":"NUL(C4,C5)+NUL(C7,C6)+NUL(C13,C12)","v":1},{"$f":"Defaite(C4,C5)+Defaite(C7,C6)+Defaite(C13,C12)","v":1},{"$f":"H4+I4+J4","v":3},{"$f":"H4*3+I4","v":4},{"$f":"1000000+L4*100000+(F4-G4)*10000+F4*1000+0.2","v":1415000.2},{"$f":"IF(M4=MAX(M:M),1,M4)","v":1415000.2},{"$f":"IF(N4=MAX(N:N),2,N4)","v":1415000.2},{"$f":"IF(O4=MAX(O:O),3,O4)","v":3},{"$f":"IF(P4=MAX(P:P),4,P4)","v":3},null,null,null,"J","V","N","P","BP","BC","Diff","Pts"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Slovaquie"},0,null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Slovaquie"},{"$f":"C5+C9+C11","v":1},{"$f":"C4+C8+C10","v":7},{"$f":"Victoire(C5,C4)+Victoire(C9,C8)+Victoire(C11,C10)","v":0},{"$f":"NUL(C5,C4)+NUL(C9,C8)+NUL(C11,C10)","v":0},{"$f":"Defaite(C5,C4)+Defaite(C9,C8)+Defaite(C11,C10)","v":3},{"$f":"H5+I5+J5","v":3},{"$f":"H5*3+I5","v":0},{"$f":"1000000+L5*100000+(F5-G5)*10000+F5*1000+0.1","v":941000.1},{"$f":"IF(M5=MAX(M:M),1,M5)","v":941000.1},{"$f":"IF(N5=MAX(N:N),2,N5)","v":941000.1},{"$f":"IF(O5=MAX(O:O),3,O5)","v":941000.1},{"$f":"IF(P5=MAX(P:P),4,P5)","v":4},null,1,{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q2:Q5,0)+1,5))","v":"Russie"},{"$f":"INDIRECT(ADDRESS(MATCH(S5,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,8))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,10))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,6))","v":5},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,7))","v":2},{"$f":"Y5-Z5","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,12))","v":7}]
["2016-06-16",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Angleterre"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q2:Q5,0)+1,5))","v":"Angleterre"},{"$f":"INDIRECT(ADDRESS(MATCH(S6,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,8))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,9))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,10))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,6))","v":6},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,7))","v":4},{"$f":"Y6-Z6","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,12))","v":5}]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Pays de Galles"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q2:Q5,0)+1,5))","v":"Pays de Galles"},{"$f":"INDIRECT(ADDRESS(MATCH(S7,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,8))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,10))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,6))","v":5},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,7))","v":4},{"$f":"Y7-Z7","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,12))","v":4}]
["2016-06-15",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Russie"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q2:Q5,0)+1,5))","v":"Slovaquie"},{"$f":"INDIRECT(ADDRESS(MATCH(S8,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,8))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,9))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,10))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,6))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,7))","v":7},{"$f":"Y8-Z8","v":-6},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,12))","v":0}]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Slovaquie"},0]
["2016-06-20",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Angleterre"},3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groupe B"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Slovaquie"},1]
["2016-06-20",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Russie"},2]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Pays de Galles"},1]

{"sheet":"Groupe C","index":3,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,12,0],[13,0,14,0],[9,18,12,27],[1,0,2,0],[1,18,2,27],[3,0,4,0],[5,0,6,0],[7,0,8,0],[9,0,10,0]]}
[null,null,null,3]
["2016-06-12",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Allemagne"},2,null,{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Allemagne"},{"$f":"C2+C6+C10","v":8},{"$f":"C3+C7+C11","v":2},{"$f":"Victoire(C2,C3)+Victoire(C6,C7)+Victoire(C10,C11)","v":3},{"$f":"NUL(C2,C3)+NUL(C6,C7)+NUL(C10,C11)","v":0},{"$f":"Defaite(C2,C3)+Defaite(C6,C7)+Defaite(C10,C11)","v":0},{"$f":"H2+I2+J2","v":3},{"$f":"H2*3+I2","v":9},{"$f":"1000000+L2*100000+(F2-G2)*10000+F2*1000+0.4","v":1968000.4},{"$f":"IF(M2=MAX(M:M),1,M2)","v":1},{"$f":"IF(N2=MAX(N:N),2,N2)","v":1},{"$f":"IF(O2=MAX(O:O),3,O2)","v":1},{"$f":"IF(P2=MAX(P:P),4,P2)","v":1},null,"Classement"]
[null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Ukraine"},0,null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Ukraine"},{"$f":"C3+C8+C12","v":0},{"$f":"C2+C9+C13","v":4},{"$f":"Victoire(C3,C2)+Victoire(C8,C9)+Victoire(C12,C13)","v":0},{"$f":"NUL(C3,C2)+NUL(C8,C9)+NUL(C12,C13)","v":1},{"$f":"Defaite(C3,C2)+Defaite(C8,C9)+Defaite(C12,C13)","v":2},{"$f":"H3+I3+J3","v":3},{"$f":"H3*3+I3","v":1},{"$f":"1000000+L3*100000+(F3-G3)*10000+F3*1000+0.3","v":1060000.3},{"$f":"IF(M3=MAX(M:M),1,M3)","v":1060000.3},{"$f":"IF(N3=MAX(N:N),2,N3)","v":1060000.3},{"$f":"IF(O3=MAX(O:O),3,O3)","v":1060000.3},{"$f":"IF(P3=MAX(P:P),4,P3)","v":4}]
["2016-06-12",{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Pologne"},1,null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Pologne"},{"$f":"C4+C7+C13","v":4},{"$f":"C5+C6+C12","v":4},{"$f":"Victoire(C4,C5)+Victoire(C7,C6)+Victoire(C13,C12)","v":1},{"$f":"NUL(C4,C5)+NUL(C7,C6)+NUL(C13,C12)","v":1},{"$f":"Defaite(C4,C5)+Defaite(C7,C6)+Defaite(C13,C12)","v":1},{"$f":"H4+I4+J4","v":3},{"$f":"H4*3+I4","v":4},{"$f":"1000000+L4*100000+(F4-G4)*10000+F4*1000+0.2","v":1404000.2},{"$f":"IF(M4=MAX(M:M),1,M4)","v":1404000.2},{"$f":"IF(N4=MAX(N:N),2,N4)","v":2},{"$f":"IF(O4=MAX(O:O),3,O4)","v":2},{"$f":"IF(P4=MAX(P:P),4,P4)","v":2},null,null,null,"J","V","N","P","BP","BC","Diff","Pts"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Irlande du Nord"},1,null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Irlande du Nord"},{"$f":"C5+C9+C11","v":2},{"$f":"C4+C8+C10","v":4},{"$f":"Victoire(C5,C4)+Victoire(C9,C8)+Victoire(C11,C10)","v":0},{"$f":"NUL(C5,C4)+NUL(C9,C8)+NUL(C11,C10)","v":2},{"$f":"Defaite(C5,C4)+Defaite(C9,C8)+Defaite(C11,C10)","v":1},{"$f":"H5+I5+J5","v":3},{"$f":"H5*3+I5","v":2},{"$f":"1000000+L5*100000+(F5-G5)*10000+F5*1000+0.1","v":1182000.1000000001},{"$f":"IF(M5=MAX(M:M),1,M5)","v":1182000.1000000001},{"$f":"IF(N5=MAX(N:N),2,N5)","v":1182000.1000000001},{"$f":"IF(O5=MAX(O:O),3,O5)","v":3},{"$f":"IF(P5=MAX(P:P),4,P5)","v":3},null,1,{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q2:Q5,0)+1,5))","v":"Allemagne"},{"$f":"INDIRECT(ADDRESS(MATCH(S5,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,8))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,9))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,10))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,6))","v":8},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,7))","v":2},{"$f":"Y5-Z5","v":6},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,12))","v":9}]
["2016-06-16",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Allemagne"},3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q2:Q5,0)+1,5))","v":"Pologne"},{"$f":"INDIRECT(ADDRESS(MATCH(S6,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,8))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,10))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,6))","v":4},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,7))","v":4},{"$f":"Y6-Z6","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,12))","v":4}]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Pologne"},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q2:Q5,0)+1,5))","v":"Irlande du Nord"},{"$f":"INDIRECT(ADDRESS(MATCH(S7,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,8))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,9))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,10))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,6))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,7))","v":4},{"$f":"Y7-Z7","v":-2},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,12))","v":2}]
["2016-06-16",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Ukraine"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q2:Q5,0)+1,5))","v":"Ukraine"},{"$f":"INDIRECT(ADDRESS(MATCH(S8,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,8))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,10))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,6))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,7))","v":4},{"$f":"Y8-Z8","v":-4},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,12))","v":1}]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Irlande du Nord"},0]
["2016-06-21",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Allemagne"},3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groupe C"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Irlande du Nord"},1]
["2016-06-21",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Ukraine"},0]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Pologne"},2]

{"sheet":"Groupe D","index":4,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,12,0],[13,0,14,0],[9,18,12,27],[1,0,2,0],[1,18,2,27],[3,0,4,0],[5,0,6,0],[7,0,8,0],[9,0,10,0]]}
[null,null,null,4]
["2016-06-13",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Espagne"},1,null,{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Espagne"},{"$f":"C2+C6+C10","v":5},{"$f":"C3+C7+C11","v":3},{"$f":"Victoire(C2,C3)+Victoire(C6,C7)+Victoire(C10,C11)","v":1},{"$f":"NUL(C2,C3)+NUL(C6,C7)+NUL(C10,C11)","v":2},{"$f":"Defaite(C2,C3)+Defaite(C6,C7)+Defaite(C10,C11)","v":0},{"$f":"H2+I2+J2","v":3},{"$f":"H2*3+I2","v":5},{"$f":"1000000+L2*100000+(F2-G2)*10000+F2*1000+0.4","v":1525000.4},{"$f":"IF(M2=MAX(M:M),1,M2)","v":1},{"$f":"IF(N2=MAX(N:N),2,N2)","v":1},{"$f":"IF(O2=MAX(O:O),3,O2)","v":1},{"$f":"IF(P2=MAX(P:P),4,P2)","v":1},null,"Classement"]
[null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"République Tchèque"},1,null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"République Tchèque"},{"$f":"C3+C8+C12","v":4},{"$f":"C2+C9+C13","v":3},{"$f":"Victoire(C3,C2)+Victoire(C8,C9)+Victoire(C12,C13)","v":1},{"$f":"NUL(C3,C2)+NUL(C8,C9)+NUL(C12,C13)","v":2},{"$f":"Defaite(C3,C2)+Defaite(C8,C9)+Defaite(C12,C13)","v":0},{"$f":"H3+I3+J3","v":3},{"$f":"H3*3+I3","v":5},{"$f":"1000000+L3*100000+(F3-G3)*10000+F3*1000+0.3","v":1514000.3},{"$f":"IF(M3=MAX(M:M),1,M3)","v":1514000.3},{"$f":"IF(N3=MAX(N:N),2,N3)","v":2},{"$f":"IF(O3=MAX(O:O),3,O3)","v":2},{"$f":"IF(P3=MAX(P:P),4,P3)","v":2}]
["2016-06-12",{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Turquie"},2,null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Turquie"},{"$f":"C4+C7+C13","v":3},{"$f":"C5+C6+C12","v":4},{"$f":"Victoire(C4,C5)+Victoire(C7,C6)+Victoire(C13,C12)","v":1},{"$f":"NUL(C4,C5)+NUL(C7,C6)+NUL(C13,C12)","v":1},{"$f":"Defaite(C4,C5)+Defaite(C7,C6)+Defaite(C13,C12)","v":1},{"$f":"H4+I4+J4","v":3},{"$f":"H4*3+I4","v":4},{"$f":"1000000+L4*100000+(F4-G4)*10000+F4*1000+0.2","v":1393000.2},{"$f":"IF(M4=MAX(M:M),1,M4)","v":1393000.2},{"$f":"IF(N4=MAX(N:N),2,N4)","v":1393000.2},{"$f":"IF(O4=MAX(O:O),3,O4)","v":3},{"$f":"IF(P4=MAX(P:P),4,P4)","v":3},null,null,null,"J","V","N","P","BP","BC","Diff","Pts"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Croatie"},1,null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Croatie"},{"$f":"C5+C9+C11","v":4},{"$f":"C4+C8+C10","v":6},{"$f":"Victoire(C5,C4)+Victoire(C9,C8)+Victoire(C11,C10)","v":0},{"$f":"NUL(C5,C4)+NUL(C9,C8)+NUL(C11,C10)","v":1},{"$f":"Defaite(C5,C4)+Defaite(C9,C8)+Defaite(C11,C10)","v":2},{"$f":"H5+I5+J5","v":3},{"$f":"H5*3+I5","v":1},{"$f":"1000000+L5*100000+(F5-G5)*10000+F5*1000+0.1","v":1084000.1000000001},{"$f":"IF(M5=MAX(M:M),1,M5)","v":1084000.1000000001},{"$f":"IF(N5=MAX(N:N),2,N5)","v":1084000.1000000001},{"$f":"IF(O5=MAX(O:O),3,O5)","v":1084000.1000000001},{"$f":"IF(P5=MAX(P:P),4,P5)","v":4},null,1,{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q2:Q5,0)+1,5))","v":"Espagne"},{"$f":"INDIRECT(ADDRESS(MATCH(S5,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,8))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,9))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,10))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,6))","v":5},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,7))","v":3},{"$f":"Y5-Z5","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,12))","v":5}]
["2016-06-17",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Espagne"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q2:Q5,0)+1,5))","v":"République Tchèque"},{"$f":"INDIRECT(ADDRESS(MATCH(S6,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,8))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,9))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,10))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,6))","v":4},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,7))","v":3},{"$f":"Y6-Z6","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,12))","v":5}]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Turquie"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q2:Q5,0)+1,5))","v":"Turquie"},{"$f":"INDIRECT(ADDRESS(MATCH(S7,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,8))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,10))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,6))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,7))","v":4},{"$f":"Y7-Z7","v":-1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,12))","v":4}]
["2016-06-17",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"République Tchèque"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q2:Q5,0)+1,5))","v":"Croatie"},{"$f":"INDIRECT(ADDRESS(MATCH(S8,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,8))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,10))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,6))","v":4},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,7))","v":6},{"$f":"Y8-Z8","v":-2},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,12))","v":1}]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Croatie"},1]
["2016-06-21",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Espagne"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groupe D"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Croatie"},2]
["2016-06-21",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"République Tchèque"},1]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Turquie"},1]

{"sheet":"Groupe E","index":5,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,12,0],[13,0,14,0],[9,18,12,27],[1,0,2,0],[1,18,2,27],[3,0,4,0],[5,0,6,0],[7,0,8,0],[9,0,10,0]]}
[null,null,null,5]
["2016-06-13",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Belgique"},3,null,{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Belgique"},{"$f":"C2+C6+C10","v":7},{"$f":"C3+C7+C11","v":2},{"$f":"Victoire(C2,C3)+Victoire(C6,C7)+Victoire(C10,C11)","v":2},{"$f":"NUL(C2,C3)+NUL(C6,C7)+NUL(C10,C11)","v":1},{"$f":"Defaite(C2,C3)+Defaite(C6,C7)+Defaite(C10,C11)","v":0},{"$f":"H2+I2+J2","v":3},{"$f":"H2*3+I2","v":7},{"$f":"1000000+L2*100000+(F2-G2)*10000+F2*1000+0.4","v":1757000.4},{"$f":"IF(M2=MAX(M:M),1,M2)","v":1},{"$f":"IF(N2=MAX(N:N),2,N2)","v":1},{"$f":"IF(O2=MAX(O:O),3,O2)","v":1},{"$f":"IF(P2=MAX(P:P),4,P2)","v":1},null,"Classement"]
[null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Italie"},0,null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Italie"},{"$f":"C3+C8+C12","v":2},{"$f":"C2+C9+C13","v":7},{"$f":"Victoire(C3,C2)+Victoire(C8,C9)+Victoire(C12,C13)","v":0},{"$f":"NUL(C3,C2)+NUL(C8,C9)+NUL(C12,C13)","v":1},{"$f":"Defaite(C3,C2)+Defaite(C8,C9)+Defaite(C12,C13)","v":2},{"$f":"H3+I3+J3","v":3},{"$f":"H3*3+I3","v":1},{"$f":"1000000+L3*100000+(F3-G3)*10000+F3*1000+0.3","v":1052000.3},{"$f":"IF(M3=MAX(M:M),1,M3)","v":1052000.3},{"$f":"IF(N3=MAX(N:N),2,N3)","v":1052000.3},{"$f":"IF(O3=MAX(O:O),3,O3)","v":1052000.3},{"$f":"IF(P3=MAX(P:P),4,P3)","v":4}]
["2016-06-13",{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Irlande"},1,null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Irlande"},{"$f":"C4+C7+C13","v":2},{"$f":"C5+C6+C12","v":5},{"$f":"Victoire(C4,C5)+Victoire(C7,C6)+Victoire(C13,C12)","v":0},{"$f":"NUL(C4,C5)+NUL(C7,C6)+NUL(C13,C12)","v":1},{"$f":"Defaite(C4,C5)+Defaite(C7,C6)+Defaite(C13,C12)","v":2},{"$f":"H4+I4+J4","v":3},{"$f":"H4*3+I4","v":1},{"$f":"1000000+L4*100000+(F4-G4)*10000+F4*1000+0.2","v":1072000.2},{"$f":"IF(M4=MAX(M:M),1,M4)","v":1072000.2},{"$f":"IF(N4=MAX(N:N),2,N4)","v":1072000.2},{"$f":"IF(O4=MAX(O:O),3,O4)","v":3},{"$f":"IF(P4=MAX(P:P),4,P4)","v":3},null,null,null,"J","V","N","P","BP","BC","Diff","Pts"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Suède"},2,null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Suède"},{"$f":"C5+C9+C11","v":7},{"$f":"C4+C8+C10","v":4},{"$f":"Victoire(C5,C4)+Victoire(C9,C8)+Victoire(C11,C10)","v":2},{"$f":"NUL(C5,C4)+NUL(C9,C8)+NUL(C11,C10)","v":1},{"$f":"Defaite(C5,C4)+Defaite(C9,C8)+Defaite(C11,C10)","v":0},{"$f":"H5+I5+J5","v":3},{"$f":"H5*3+I5","v":7},{"$f":"1000000+L5*100000+(F5-G5)*10000+F5*1000+0.1","v":1737000.1},{"$f":"IF(M5=MAX(M:M),1,M5)","v":1737000.1},{"$f":"IF(N5=MAX(N:N),2,N5)","v":2},{"$f":"IF(O5=MAX(O:O),3,O5)","v":2},{"$f":"IF(P5=MAX(P:P),4,P5)","v":2},null,1,{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q2:Q5,0)+1,5))","v":"Belgique"},{"$f":"INDIRECT(ADDRESS(MATCH(S5,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,8))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,10))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,6))","v":7},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,7))","v":2},{"$f":"Y5-Z5","v":5},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,12))","v":7}]
["2016-06-18",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Belgique"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q2:Q5,0)+1,5))","v":"Suède"},{"$f":"INDIRECT(ADDRESS(MATCH(S6,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,8))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,10))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,6))","v":7},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,7))","v":4},{"$f":"Y6-Z6","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,12))","v":7}]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Irlande"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q2:Q5,0)+1,5))","v":"Irlande"},{"$f":"INDIRECT(ADDRESS(MATCH(S7,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,8))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,10))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,6))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,7))","v":5},{"$f":"Y7-Z7","v":-3},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,12))","v":1}]
["2016-06-17",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Italie"},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q2:Q5,0)+1,5))","v":"Italie"},{"$f":"INDIRECT(ADDRESS(MATCH(S8,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,8))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,9))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,10))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,6))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,7))","v":7},{"$f":"Y8-Z8","v":-5},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,12))","v":1}]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Suède"},3]
["2016-06-22",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Belgique"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groupe E"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Suède"},2]
["2016-06-22",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Italie"},1]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Irlande"},1]

{"sheet":"Groupe F","index":6,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,12,0],[13,0,14,0],[9,18,12,27],[1,0,2,0],[1,18,2,27],[3,0,4,0],[5,0,6,0],[7,0,8,0],[9,0,10,0]]}
[null,null,null,6]
["2016-06-14",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Portugal"},3,null,{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Portugal"},{"$f":"C2+C6+C10","v":8},{"$f":"C3+C7+C11","v":4},{"$f":"Victoire(C2,C3)+Victoire(C6,C7)+Victoire(C10,C11)","v":2},{"$f":"NUL(C2,C3)+NUL(C6,C7)+NUL(C10,C11)","v":0},{"$f":"Defaite(C2,C3)+Defaite(C6,C7)+Defaite(C10,C11)","v":1},{"$f":"H2+I2+J2","v":3},{"$f":"H2*3+I2","v":6},{"$f":"1000000+L2*100000+(F2-G2)*10000+F2*1000+0.4","v":1648000.4},{"$f":"IF(M2=MAX(M:M),1,M2)","v":1},{"$f":"IF(N2=MAX(N:N),2,N2)","v":1},{"$f":"IF(O2=MAX(O:O),3,O2)","v":1},{"$f":"IF(P2=MAX(P:P),4,P2)","v":1},null,"Classement"]
[null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Islande"},1,null,{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Islande"},{"$f":"C3+C8+C12","v":5},{"$f":"C2+C9+C13","v":5},{"$f":"Victoire(C3,C2)+Victoire(C8,C9)+Victoire(C12,C13)","v":2},{"$f":"NUL(C3,C2)+NUL(C8,C9)+NUL(C12,C13)","v":0},{"$f":"Defaite(C3,C2)+Defaite(C8,C9)+Defaite(C12,C13)","v":1},{"$f":"H3+I3+J3","v":3},{"$f":"H3*3+I3","v":6},{"$f":"1000000+L3*100000+(F3-G3)*10000+F3*1000+0.3","v":1605000.3},{"$f":"IF(M3=MAX(M:M),1,M3)","v":1605000.3},{"$f":"IF(N3=MAX(N:N),2,N3)","v":2},{"$f":"IF(O3=MAX(O:O),3,O3)","v":2},{"$f":"IF(P3=MAX(P:P),4,P3)","v":2}]
["2016-06-14",{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Autriche"},1,null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Autriche"},{"$f":"C4+C7+C13","v":3},{"$f":"C5+C6+C12","v":6},{"$f":"Victoire(C4,C5)+Victoire(C7,C6)+Victoire(C13,C12)","v":1},{"$f":"NUL(C4,C5)+NUL(C7,C6)+NUL(C13,C12)","v":0},{"$f":"Defaite(C4,C5)+Defaite(C7,C6)+Defaite(C13,C12)","v":2},{"$f":"H4+I4+J4","v":3},{"$f":"H4*3+I4","v":3},{"$f":"1000000+L4*100000+(F4-G4)*10000+F4*1000+0.2","v":1273000.2},{"$f":"IF(M4=MAX(M:M),1,M4)","v":1273000.2},{"$f":"IF(N4=MAX(N:N),2,N4)","v":1273000.2},{"$f":"IF(O4=MAX(O:O),3,O4)","v":1273000.2},{"$f":"IF(P4=MAX(P:P),4,P4)","v":4},null,null,null,"J","V","N","P","BP","BC","Diff","Pts"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Hongrie"},0,null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Hongrie"},{"$f":"C5+C9+C11","v":3},{"$f":"C4+C8+C10","v":4},{"$f":"Victoire(C5,C4)+Victoire(C9,C8)+Victoire(C11,C10)","v":1},{"$f":"NUL(C5,C4)+NUL(C9,C8)+NUL(C11,C10)","v":0},{"$f":"Defaite(C5,C4)+Defaite(C9,C8)+Defaite(C11,C10)","v":2},{"$f":"H5+I5+J5","v":3},{"$f":"H5*3+I5","v":3},{"$f":"1000000+L5*100000+(F5-G5)*10000+F5*1000+0.1","v":1293000.1000000001},{"$f":"IF(M5=MAX(M:M),1,M5)","v":1293000.1000000001},{"$f":"IF(N5=MAX(N:N),2,N5)","v":1293000.1000000001},{"$f":"IF(O5=MAX(O:O),3,O5)","v":3},{"$f":"IF(P5=MAX(P:P),4,P5)","v":3},null,1,{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q2:Q5,0)+1,5))","v":"Portugal"},{"$f":"INDIRECT(ADDRESS(MATCH(S5,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,8))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,9))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,10))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,6))","v":8},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,7))","v":4},{"$f":"Y5-Z5","v":4},{"$f":"INDIRECT(ADDRESS(MATCH(S5,Q$2:Q$5,0)+1,12))","v":6}]
["2016-06-18",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Portugal"},4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q2:Q5,0)+1,5))","v":"Islande"},{"$f":"INDIRECT(ADDRESS(MATCH(S6,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,8))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,9))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,10))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,6))","v":5},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,7))","v":5},{"$f":"Y6-Z6","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S6,Q$2:Q$5,0)+1,12))","v":6}]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Autriche"},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q2:Q5,0)+1,5))","v":"Hongrie"},{"$f":"INDIRECT(ADDRESS(MATCH(S7,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,8))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,9))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,10))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,6))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,7))","v":4},{"$f":"Y7-Z7","v":-1},{"$f":"INDIRECT(ADDRESS(MATCH(S7,Q$2:Q$5,0)+1,12))","v":3}]
["2016-06-18",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Islande"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q2:Q5,0)+1,5))","v":"Autriche"},{"$f":"INDIRECT(ADDRESS(MATCH(S8,$Q$2:$Q$5,0)+1,11))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,8))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,9))","v":0},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,10))","v":2},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,6))","v":3},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,7))","v":6},{"$f":"Y8-Z8","v":-3},{"$f":"INDIRECT(ADDRESS(MATCH(S8,Q$2:Q$5,0)+1,12))","v":3}]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Hongrie"},1]
["2016-06-22",{"$f":"INDIRECT(ADDRESS(1,D1,,,\"Groupes\"))","v":"Portugal"},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groupe F"]
[null,{"$f":"INDIRECT(ADDRESS(4,D1,,,\"Groupes\"))","v":"Hongrie"},2]
["2016-06-22",{"$f":"INDIRECT(ADDRESS(2,D1,,,\"Groupes\"))","v":"Islande"},2]
[null,{"$f":"INDIRECT(ADDRESS(3,D1,,,\"Groupes\"))","v":"Autriche"},1]

{"sheet":"Classement des 3e","index":7,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Pts","Diff","BP",null,null,null,null,null,null,null,null,null,null,null,"Pts","Diff","BP"]
["A",1,{"$f":"'Groupe A'!T$7","v":"Albanie"},{"$f":"'Groupe A'!AB$7","v":4},{"$f":"'Groupe A'!AA$7","v":0},{"$f":"'Groupe A'!Y$7","v":3},{"$f":"D2*10000+E2*1000+F2*10+7.1","v":40037.1},{"$f":"IF(G2=MAX(G:G),1,G2)","v":40037.1},{"$f":"IF(H2=MAX(H:H),2,H2)","v":2},{"$f":"IF(I2=MAX(I:I),3,I2)","v":2},{"$f":"IF(J2=MAX(J:J),4,J2)","v":2},{"$f":"IF(K2=MAX(K:K),5,K2)","v":2},{"$f":"IF(L2=MAX(L:L),6,L2)","v":2},null,null,1,{"$f":"INDIRECT(ADDRESS(MATCH(P2,$M$2:$M$7,0)+1,3))","v":"Pays de Galles"},{"$f":"INDIRECT(ADDRESS(MATCH(P2,$M$2:$M$7,0)+1,4))","v":4},{"$f":"INDIRECT(ADDRESS(MATCH(P2,$M$2:$M$7,0)+1,5))","v":1},{"$f":"INDIRECT(ADDRESS(MATCH(P2,$M$2:$M$7,0)+1,6))","v":5}]
["B",2,{"$f":"'Groupe B'!T$7","v":"Pays de Galles"},{"$f":"'Groupe B'!AB$7","v":4},{"$f":"'Groupe B'!AA$7","v":1},{"$f":"'Groupe B'!Y$7","v":5},{"$f":"D3*10000+E3*1000+F3*10+7.2","v":41057.199999999997},1,1,1,1,1,1,null,null,2,"Albanie",4,0,3]
["C",4,{"$f":"'Groupe C'!T$7","v":"Irlande du Nord"},{"$f":"'Groupe C'!AB$7","v":2},{"$f":"'Groupe C'!AA$7","v":-2},{"$f":"'Groupe C'!Y$7","v":2},{"$f":"D4*10000+E4*1000+F4*10+7.3","v":18027.3},18027.3,18027.3,18027.3,18027.3,5,5,null,null,3,"Turquie",4,-1,3]
["D",8,{"$f":"'Groupe D'!T$7","v":"Turquie"},{"$f":"'Groupe D'!AB$7","v":4},{"$f":"'Groupe D'!AA$7","v":-1},{"$f":"'Groupe D'!Y$7","v":3},{"$f":"D5*10000+E5*1000+F5*10+7.4","v":39037.4},39037.4,39037.4,3,3,3,3,null,null,4,"Hongrie",3,-1,3]
["E",16,{"$f":"'Groupe E'!T$7","v":"Irlande"},{"$f":"'Groupe E'!AB$7","v":1},{"$f":"'Groupe E'!AA$7","v":-3},{"$f":"'Groupe E'!Y$7","v":2},{"$f":"D6*10000+E6*1000+F6*10+7.5","v":7027.5},7027.5,7027.5,7027.5,7027.5,7027.5,6,null,null,5,"Irlande du Nord",2,-2,2]
["F",32,{"$f":"'Groupe F'!T$7","v":"Hongrie"},{"$f":"'Groupe F'!AB$7","v":3},{"$f":"'Groupe F'!AA$7","v":-1},{"$f":"'Groupe F'!Y$7","v":3},{"$f":"D7*10000+E7*1000+F7*10+7.6","v":29037.599999999999},29037.599999999999,29037.599999999999,29037.599999999999,4,4,4,null,null,6,"Irlande",1,-3,2]
[]
[]
[]
[]
[null,null,{"$f":"IF(M2<5,B2,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(MATCH(C18,Feuil2!A19:A33,0)+18,2,,,\"Feuil2\"))","v":"Turquie"}]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(MATCH(C18,Feuil2!A19:A33,0)+18,3,,,\"Feuil2\"))","v":"Albanie"}]
[null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(MATCH(C18,Feuil2!A19:A33,0)+18,4,,,\"Feuil2\"))","v":"Pays de Galles"}]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(MATCH(C18,Feuil2!A19:A33,0)+18,5,,,\"Feuil2\"))","v":"Hongrie"}]
[null,null,0]
[null,null,32]
[null,null,{"$f":"SUM(C12:C17)","v":43}]

{"sheet":"Tableau final","index":8,"n_rows":32,"n_cols":34,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,13,30,14],[6,16,7,16],[6,17,7,19],[10,16,10,19],[11,16,12,16],[7,26,8,26],[23,26,24,26],[3,31,4,31],[11,31,12,31],[19,31,20,31],[1,13,5,20],[27,31,28,31],[15,11,16,11],[19,16,19,19],[20,16,21,16],[15,21,16,21],[15,16,15,19],[16,16,17,16],[7,6,8,6],[23,6,24,6],[3,1,4,1],[11,1,12,1],[19,1,20,1],[27,1,28,1]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tableau Final"]
[]
[null,"2016-06-25",{"$f":"IF(SUM('Groupe A'!U5:U8)=12,'Groupe A'!T6,\"\")","v":"Suisse"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-06-26",{"$f":"IF(SUM('Groupe C'!U5:U8)=12,'Groupe C'!T5,\"\")","v":"Allemagne"},1]
[null,null,{"$f":"IF(SUM('Groupe C'!U5:U8)=12,'Groupe C'!T6,\"\")","v":"Pologne"},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,{"$f":"IF(SUM('Groupe D'!U5:U8)=12,'Classement des 3e'!O14,\"\")","v":"Pays de Galles"},2]
[]
[]
[null,null,null,null,null,null,"2016-06-30",{"$f":"IF(D4>D5,C4,IF(D5>D4,C5,IF(E4>E5,C4,IF(E4<>E5,C5,\"\"))))","v":"Suisse"},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-02",{"$f":"IF(AH4>AH5,AG4,IF(AH5>AH4,AG5,IF(AI4>AI5,AG4,IF(AI4<>AI5,AG5,\"\"))))","v":"Pays de Galles"},1]
[null,null,null,null,null,null,null,{"$f":"IF(D12>D13,C12,IF(D13>D12,C13,IF(E12>E13,C12,IF(E12<>E13,C13,\"\"))))","v":"Espagne"},3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH12>AH13,AG12,IF(AH13>AH12,AG13,IF(AI12>AI13,AG12,IF(AI12<>AI13,AG13,\"\"))))","v":"Belgique"},3]
[]
[]
[null,"2016-06-25",{"$f":"IF(SUM('Groupe D'!U5:U8)=12,'Groupe D'!T5,\"\")","v":"Espagne"},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,"2016-06-27",{"$f":"IF(SUM('Groupe E'!U5:U8)=12,'Groupe E'!T5,\"\")","v":"Belgique"},3]
[null,null,{"$f":"IF(SUM('Groupe D'!U5:U8)=12,'Classement des 3e'!O15,\"\")","v":"Hongrie"},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,{"$f":"IF(SUM('Groupe D'!U5:U8)=12,'Groupe D'!T6,\"\")","v":"République Tchèque"},2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"2016-07-06",{"$f":"IF(I8>I9,H8,IF(I9>I8,H9,IF(J8>J9,H8,IF(J8<>J9,H9,\"\"))))","v":"Espagne"},2,null,null,"FINALE",null,null,null,null,"2016-07-07",{"$f":"IF(AC8>AC9,AB8,IF(AC9>AC8,AB9,IF(AD8>AD9,AB8,IF(AD8<>AD9,AB9,\"\"))))","v":"Belgique"},1]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I24>I25,H24,IF(I25>I24,H25,IF(J24>J25,H24,IF(J24<>J25,H25,\"\"))))","v":"Russie"},1,null,null,"2016-07-10",{"$f":"IF(N16>N17,M16,IF(N17>N16,M17,IF(O16>O17,M16,IF(O16<>O17,M17,\"\"))))","v":"Espagne"},1,null,null,null,{"$f":"IF(AC24>AC25,AB24,IF(AC25>AC24,AB25,IF(AD24>AD25,AB24,IF(AD24<>AD25,AB25,\"\"))))","v":"France"},3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X16>X17,W16,IF(X17>X16,W17,IF(Y16>Y17,W16,IF(Y16<>Y17,W17,\"\"))))","v":"France"},2]
[]
[null,"2016-06-25",{"$f":"IF(SUM('Groupe B'!U5:U8)=12,'Groupe B'!T5,\"\")","v":"Russie"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-26",{"$f":"IF(SUM('Groupe A'!U5:U8)=12,'Groupe A'!T5,\"\")","v":"France"},3]
[null,null,{"$f":"IF(SUM('Groupe D'!U5:U8)=12,'Classement des 3e'!O13,\"\")","v":"Albanie"},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,{"$f":"IF(SUM('Groupe D'!U5:U8)=12,'Classement des 3e'!O12,\"\")","v":"Turquie"},1]
[]
[]
[null,null,null,null,null,null,"2016-07-01",{"$f":"IF(D20>D21,C20,IF(D21>D20,C21,IF(E20>E21,C20,IF(E20<>E21,C21,\"\"))))","v":"Russie"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-03",{"$f":"IF(AH20>AH21,AG20,IF(AH21>AH20,AG21,IF(AI20>AI21,AG20,IF(AI20<>AI21,AG21,\"\"))))","v":"France"},2]
[null,null,null,null,null,null,null,{"$f":"IF(D28>D29,C28,IF(D29>D28,C29,IF(E28>E29,C28,IF(E28<>E29,C29,\"\"))))","v":"Suède"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH28>AH29,AG28,IF(AH29>AH28,AG29,IF(AI28>AI29,AG28,IF(AI28<>AI29,AG29,\"\"))))","v":"Islande"},1]
[]
[]
[null,"2016-06-26",{"$f":"IF(SUM('Groupe F'!U5:U8)=12,'Groupe F'!T5,\"\")","v":"Portugal"},2,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meilleur Joueur",null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-27",{"$f":"IF(SUM('Groupe B'!U5:U8)=12,'Groupe B'!T6,\"\")","v":"Angleterre"},1]
[null,null,{"$f":"IF(SUM('Groupe E'!U5:U8)=12,'Groupe E'!T6,\"\")","v":"Suède"},3,null,null,null,null,null,null,null,null,null,null,null,null,null,"payet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM('Groupe F'!U5:U8)=12,'Groupe F'!T6,\"\")","v":"Islande"},2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Buts marqués",{"$f":"SUM('Groupe A'!C2:C13,'Groupe B'!C2:C13,'Groupe C'!C2:C13,'Groupe D'!C2:C13,'Groupe E'!C2:C13,'Groupe F'!C2:C13,'Tableau final'!D4:D5,'Tableau final'!D12:D13,'Tableau final'!D20:D21,'Tableau final'!D28:D29,'Tableau final'!I8:I9,'Tableau final'!I24:I25,'Tableau final'!N16:N17,S17:S18,'Tableau final'!X16:X17,'Tableau final'!AC8:AC9,'Tableau final'!AC24:AC25,'Tableau final'!AH28:AH29,'Tableau final'!AH20:AH21,'Tableau final'!AH12:AH13,'Tableau final'!AH4:AH5)","v":152},null,null,null,"Meilleur Buteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"giroud"]

{"sheet":"Règles de calcul","index":9,"n_rows":47,"n_cols":1,"rows_kept":47,"cut":false,"hidden":false,"merged":[[16,0,16,6],[17,0,17,6],[18,0,18,6],[7,0,7,6],[0,0,0,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[6,0,6,6],[5,0,5,6],[9,0,9,6],[10,0,10,6],[11,0,11,6],[12,0,12,6],[13,0,13,6],[15,0,15,6],[37,0,37,6],[23,0,23,6],[24,0,24,6],[26,0,26,6],[27,0,27,6],[28,0,28,6],[29,0,29,6],[31,0,31,6],[32,0,32,6],[33,0,33,6],[35,0,35,6],[36,0,36,6],[19,0,19,6],[21,0,21,6],[22,0,22,6],[46,0,46,6],[38,0,38,6],[40,0,40,6],[41,0,41,6],[42,0,42,6],[44,0,44,6],[45,0,45,6]]}
["Calcul des points"]
[]
["36 matches de poule"]
["20 points par bons scores"]
["15 points par bon pronostic mais mauvais score"]
["BONUS de 50 pts si plus de 50% de bons scores"]
["BONUS de 40 pts supplémentaires si plus de 50% de bons pronostics"]
["Total = 800pts"]
[]
["16 équipes qualifiées en 1/8 de finale"]
["15pts par équipe pronostiquée présente"]
["BONUS de 20 points si plus de 8 équipes correctes"]
["BONUS de 20 points supplémentaires si plus de 12 équipes correctes"]
["Total = 280pts"]
[]
["8 équipes qualifiées en 1/4 de finale"]
["25pts par équipe pronostiquée présente"]
["BONUS de 50 points si plus de 4 équipes correctes"]
["BONUS de 50 points supplémentaires si plus de 6 équipes correctes"]
["Total = 300pts"]
[]
["4 équipes qualifiées en 1/2 finale"]
["60pts par équipe pronostiquée présente"]
["BONUS de 80 points si au moins 3 équipes correctes sur 4"]
["Total = 320pts"]
[]
["2 équipes qualifiées en finale"]
["120pts par équipe pronostiquée présente"]
["BONUS de 100 points si 2 équipes correctes sur 2"]
["Total = 340pts"]
[]
["Vainqueur"]
["400pts pour le bon pronostic du Vainqueur de la Coupe du Monde"]
["Total = 400pts"]
[]
["Joueurs"]
["100pts pour le bon pronostic du Meilleur Joueur nommé par l'UEFA"]
["100pts pour le bon pronostic du Meilleur Buteur nommé par l'UEFA"]
["Total = 200pts"]
[]
["Buts marqués (Malus possible)"]
["Points = 210 -  5 * |Buts marqués - Pronostics|"]
["Total max = 210pts"]
[]
["Total des points"]
["800 + 280 + 300 + 320 + 340 + 400 + 200 + 210"]
["2850pts possibles"]

{"sheet":"Report","index":10,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":true,"merged":[[2,11,2,12],[1,5,1,6],[2,5,2,6],[1,13,1,14],[0,13,0,14],[0,11,0,12],[0,9,0,10],[0,7,0,8],[0,5,0,6],[1,11,1,12],[7,5,7,6],[8,7,8,8],[1,9,1,10],[2,9,2,10],[3,9,3,10],[4,9,4,10],[11,5,11,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[1,7,1,8],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,7,5,8],[6,7,6,8],[13,5,13,6],[12,5,12,6],[7,7,7,8],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6]]}
[null,null,null,null,null,"1/8 de finalistes",null,"1/4 de finalistes",null,"1/2 finalistes",null,"Finalistes",null,"Vainqueur"]
["France - Roumanie",{"$f":"'Groupe A'!C2","v":3},{"$f":"'Groupe A'!C3","v":1},{"$f":"CONCATENATE(B2,\"-\",C2)","v":"3-1"},null,{"$f":"'Tableau final'!C4","v":"Suisse"},null,{"$f":"'Tableau final'!H8","v":"Suisse"},null,{"$f":"'Tableau final'!M16","v":"Espagne"},null,{"$f":"'Tableau final'!R17","v":"Espagne"},null,{"$f":"IF('Tableau final'!S17>'Tableau final'!S18,'Tableau final'!R17,IF('Tableau final'!S18>'Tableau final'!S17,'Tableau final'!R18,IF('Tableau final'!T17>'Tableau final'!T18,'Tableau final'!R17,IF('Tableau final'!T17<>'Tableau final'!T18,'Tableau final'!R18,\"\"))))","v":"France"}]
["Albanie - Suisse",{"$f":"'Groupe A'!C4","v":1},{"$f":"'Groupe A'!C5","v":1},{"$f":"CONCATENATE(B3,\"-\",C3)","v":"1-1"},null,{"$f":"'Tableau final'!C5","v":"Pologne"},null,{"$f":"'Tableau final'!H9","v":"Espagne"},null,{"$f":"'Tableau final'!M17","v":"Russie"},null,{"$f":"'Tableau final'!R18","v":"France"}]
["Pays de Galles - Slovaquie",{"$f":"'Groupe B'!C4","v":2},{"$f":"'Groupe B'!C5","v":0},"2-0",null,{"$f":"'Tableau final'!C12","v":"Espagne"},null,{"$f":"'Tableau final'!H24","v":"Russie"},null,{"$f":"'Tableau final'!W16","v":"Belgique"}]
["Angleterre - Russie",{"$f":"'Groupe B'!C2","v":1},{"$f":"'Groupe B'!C3","v":1},"1-1",null,{"$f":"'Tableau final'!C13","v":"Hongrie"},null,{"$f":"'Tableau final'!H25","v":"Suède"},null,{"$f":"'Tableau final'!W17","v":"France"}]
["Turquie - Croatie",{"$f":"'Groupe D'!C4","v":2},{"$f":"'Groupe D'!C5","v":1},"2-1",null,{"$f":"'Tableau final'!C20","v":"Russie"},null,{"$f":"'Tableau final'!AB8","v":"Pays de Galles"}]
["Pologne - Irlande du Nord",{"$f":"'Groupe C'!C4","v":1},{"$f":"'Groupe C'!C5","v":1},"1-1",null,{"$f":"'Tableau final'!C21","v":"Albanie"},null,{"$f":"'Tableau final'!AB9","v":"Belgique"}]
["Allemagne - Ukraine",{"$f":"'Groupe C'!C2","v":2},{"$f":"'Groupe C'!C3","v":0},"2-0",null,{"$f":"'Tableau final'!C28","v":"Portugal"},null,{"$f":"'Tableau final'!AB24","v":"France"}]
["Espagne - Rép. Tchèque",{"$f":"'Groupe D'!C2","v":1},{"$f":"'Groupe D'!C3","v":1},"1-1",null,{"$f":"'Tableau final'!C29","v":"Suède"},null,{"$f":"'Tableau final'!AB25","v":"Islande"}]
["Irlande - Suède",{"$f":"'Groupe E'!C4","v":1},{"$f":"'Groupe E'!C5","v":2},"1-2",null,{"$f":"'Tableau final'!AG4","v":"Allemagne"}]
["Belgique - Italie",{"$f":"'Groupe E'!C2","v":3},{"$f":"'Groupe E'!C3","v":0},"3-0",null,{"$f":"'Tableau final'!AG5","v":"Pays de Galles"}]
["Autriche - Hongrie",{"$f":"'Groupe F'!C4","v":1},{"$f":"'Groupe F'!C5","v":0},"1-0",null,{"$f":"'Tableau final'!AG12","v":"Belgique"}]
["Portugal - Islande",{"$f":"'Groupe F'!C2","v":3},{"$f":"'Groupe F'!C3","v":1},"3-1",null,{"$f":"'Tableau final'!AG13","v":"République Tchèque"}]
["Russie - Slovaquie",{"$f":"'Groupe B'!C8","v":2},{"$f":"'Groupe B'!C9","v":0},"2-0",null,{"$f":"'Tableau final'!AG20","v":"France"}]
["Roumanie - Suisse",{"$f":"'Groupe A'!C8","v":0},{"$f":"'Groupe A'!C9","v":2},"0-2",null,{"$f":"'Tableau final'!AG21","v":"Turquie"}]
["France - Albanie",{"$f":"'Groupe A'!C6","v":2},{"$f":"'Groupe A'!C7","v":1},"2-1",null,{"$f":"'Tableau final'!AG28","v":"Angleterre"}]
["Angleterre - Pays de Galles",{"$f":"'Groupe B'!C6","v":2},{"$f":"'Groupe B'!C7","v":2},"2-2",null,{"$f":"'Tableau final'!AG29","v":"Islande"}]
["Ukraine - Irlande du Nord",{"$f":"'Groupe C'!C8","v":0},{"$f":"'Groupe C'!C9","v":0},"0-0"]
["Allemagne - Pologne",{"$f":"'Groupe C'!C6","v":3},{"$f":"'Groupe C'!C7","v":1},"3-1"]
["Italie - Suède",{"$f":"'Groupe E'!C8","v":1},{"$f":"'Groupe E'!C9","v":3},"1-3"]
["Rép. Tchèque - Croatie",{"$f":"'Groupe D'!C8","v":2},{"$f":"'Groupe D'!C9","v":1},"2-1"]
["Espagne - Turquie",{"$f":"'Groupe D'!C6","v":2},{"$f":"'Groupe D'!C7","v":0},"2-0"]
["Belgique - Irlande",{"$f":"'Groupe E'!C6","v":2},{"$f":"'Groupe E'!C7","v":0},"2-0"]
["Islande - Hongrie",{"$f":"'Groupe F'!C8","v":2},{"$f":"'Groupe F'!C9","v":1},"2-1"]
["Portugal - Autriche",{"$f":"'Groupe F'!C6","v":4},{"$f":"'Groupe F'!C7","v":1},"4-1"]
["France - Suisse",{"$f":"'Groupe A'!C10","v":3},{"$f":"'Groupe A'!C11","v":1},"3-1"]
["Roumanie - Albanie",{"$f":"'Groupe A'!C12","v":0},{"$f":"'Groupe A'!C13","v":1},"0-1"]
["Angleterre - Slovaquie",{"$f":"'Groupe B'!C10","v":3},{"$f":"'Groupe B'!C11","v":1},"3-1"]
["Russie - Pays de Galles",{"$f":"'Groupe B'!C12","v":2},{"$f":"'Groupe B'!C13","v":1},"2-1"]
["Allemagne - Irlande du Nord",{"$f":"'Groupe C'!C10","v":3},{"$f":"'Groupe C'!C11","v":1},"3-1"]
["Ukraine - Pologne",{"$f":"'Groupe C'!C12","v":0},{"$f":"'Groupe C'!C13","v":2},"0-2"]
["Espagne - Croatie",{"$f":"'Groupe D'!C10","v":2},{"$f":"'Groupe D'!C11","v":2},"2-2"]
["Rép. Tchèque - Turquie",{"$f":"'Groupe D'!C12","v":1},{"$f":"'Groupe D'!C13","v":1},"1-1"]
["Portugal - Hongrie",{"$f":"'Groupe F'!C10","v":1},{"$f":"'Groupe F'!C11","v":2},"1-2"]
["Islande - Autriche",{"$f":"'Groupe F'!C12","v":2},{"$f":"'Groupe F'!C13","v":1},"2-1"]
["Belgique - Suède",{"$f":"'Groupe E'!C10","v":2},{"$f":"'Groupe E'!C11","v":2},"2-2"]
["Italie - Irlande",{"$f":"'Groupe E'!C12","v":1},{"$f":"'Groupe E'!C13","v":1},"1-1"]

{"sheet":"Feuil2","index":11,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,"Adversaires de","Adversaires de","Adversaires de","Adversaires de"]
[null,"1A","1B","1C","1D"]
["A B C D",4,5,2,3,15]
["A B C E",4,2,3,6,23]
["A B C F",4,2,3,7,39]
["A B D E",5,2,3,6,27]
["A B D F",5,2,3,7,43]
["A B E F",6,2,3,7,51]
["A C D E",4,5,2,6,29]
["A C D F",4,5,2,7,45]
["A C E F",4,2,7,6,53]
["A D E F",5,2,7,6,57]
["B C D E",4,5,3,6,30]
["B C D F",4,5,3,7,46]
["B C E F",6,4,3,7,54]
["B D E F",6,5,3,7,58]
["C D E F",4,5,7,6,60]
[]
[15,{"$f":"INDIRECT(ADDRESS(B3,3,,,\"Classement des 3e\"))","v":"Irlande du Nord"},"Turquie","Albanie","Pays de Galles",null,15,"Pologne","Croatie","Roumanie","Slovaquie"]
[23,"Irlande du Nord","Albanie","Pays de Galles","Irlande",null,23,"Pologne","Roumanie","Slovaquie","Belgique"]
[39,"Irlande du Nord","Albanie","Pays de Galles","Hongrie",null,27,"Croatie","Roumanie","Slovaquie","Belgique"]
[27,"Turquie","Albanie","Pays de Galles","Irlande",null,29,"Pologne","Croatie","Roumanie","Belgique"]
[43,"Turquie","Albanie","Pays de Galles","Hongrie",null,30,"Pologne","Croatie","Slovaquie","Belgique"]
[51,"Irlande","Albanie","Pays de Galles","Hongrie",null,39,"Pologne","Roumanie","Slovaquie","Islande"]
[29,"Irlande du Nord","Turquie","Albanie","Irlande",null,43,"Croatie","Roumanie","Slovaquie","Islande"]
[45,"Irlande du Nord","Turquie","Albanie","Hongrie",null,45,"Pologne","Croatie","Roumanie","Islande"]
[53,"Irlande du Nord","Albanie","Hongrie","Irlande",null,46,"Pologne","Croatie","Slovaquie","Islande"]
[57,"Turquie","Albanie","Hongrie","Irlande",null,51,"Belgique","Roumanie","Slovaquie","Islande"]
[30,"Irlande du Nord","Turquie","Pays de Galles","Irlande",null,53,"Pologne","Roumanie","Islande","Belgique"]
[46,"Irlande du Nord","Turquie","Pays de Galles","Hongrie",null,54,"Belgique","Pologne","Slovaquie","Islande"]
[54,"Irlande","Irlande du Nord","Pays de Galles","Hongrie",null,57,"Croatie","Roumanie","Islande","Belgique"]
[58,"Irlande","Turquie","Pays de Galles","Hongrie",null,58,"Belgique","Croatie","Slovaquie","Islande"]
[60,"Irlande du Nord","Turquie","Hongrie","Irlande",null,60,"Pologne","Croatie","Islande","Belgique"]