{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TACC Competition","Group Tables","3rd Place","Teams","Marking Sheet"],"not_rendered":{"charts":0,"images":3,"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":"TACC Competition","index":0,"n_rows":59,"n_cols":26,"rows_kept":59,"cut":false,"hidden":false,"merged":[[53,20,53,23],[54,20,54,23],[16,17,16,19],[16,20,16,23],[16,2,16,10],[25,9,25,18],[18,20,18,23],[47,20,47,23],[51,20,51,23],[46,20,46,23],[49,20,49,23],[1,1,3,4],[1,20,3,23],[18,9,18,18],[4,20,14,23],[13,1,13,4],[8,9,8,18],[7,9,7,18],[9,9,9,18],[10,9,11,18],[12,9,13,18],[5,1,11,4],[57,20,57,23],[58,20,58,23],[18,1,18,4],[32,1,32,4],[46,1,46,4],[36,20,36,23],[41,20,41,23],[29,20,29,23],[50,20,50,23],[45,20,45,23],[53,9,53,18],[46,9,46,18],[39,9,39,18],[32,9,32,18],[55,20,55,23],[39,20,39,23]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Instructions for Group Stages:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for Knockout Stages:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Place an 'X' in the box next to the team you think will win each knockout match. The spreadsheet will do the work for you by progressing the relevant teams depending on your predictions. Bonus points are available for this part of the tournament and are detailed where necessary."]
[null,"Predict a score for each group stage match by entering values into the yellow boxes. The group table will automatically update depending on your predicted score and place the correct teams into the Knockout Stages. Please see the points table below:"]
[]
[null,null,null,null,null,null,null,null,null,"Hint: push the TACC logo to generate random group stage results!"]
[]
[null,null,null,null,null,null,null,null,null,"How to Enter"]
[null,null,null,null,null,null,null,null,null,"Please send £2 entry fee via PayPal to: ryanjohnstone67@hotmail.co.uk (via friends and family option)."]
[]
[null,null,null,null,null,null,null,null,null,"Completed forms to be sent electronically to the same e-mail address with proof of payment."]
[]
[]
[]
[null,"Full Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact"]
[]
[null,"Matchday 1",null,null,null,null,null,null,null,"Group A",null,null,null,null,null,null,null,null,null,null,"Round of 16"]
[null,{"$f":"Teams!A1","v":"Turkey"},null,{"$f":"Teams!A2","v":"Italy"},null,null,{"$f":"IF(C20=\"\",\"\",IF(C20>E20,3,IF(C20=E20,1,0)))","v":""},{"$f":"IF(E20=\"\",\"\",IF(E20>C20,3,IF(E20=C20,1,0)))","v":""},null,"Pos","Team","P","W","D","L","GF","GA","+/-","Pts",null,{"$f":"IF(L56>2,K56,\"Winner Group F\")","v":"Winner Group F"},null,{"$f":"IF(L58>2,IF('3rd Place'!K6=\"ABCD\",'TACC Competition'!K37,IF('3rd Place'!K6=\"ABCE\",'TACC Competition'!K37,IF('3rd Place'!K6=\"ABCF\",'TACC Competition'!K37,IF('3rd Place'!K6=\"BCDE\",'TACC Competition'!K37,IF('3rd Place'!K6=\"CDEF\",'TACC Competition'!K37,IF('3rd Place'!K6=\"ABDE\",'TACC Competition'!K30,IF('3rd Place'!K6=\"ABDF\",'TACC Competition'!K30,IF('3rd Place'!K6=\"BCDF\",'TACC Competition'!K30,IF('3rd Place'!K6=\"BCEF\",'TACC Competition'!K30,IF('3rd Place'!K6=\"BDEF\",'TACC Competition'!K30,IF('3rd Place'!K6=\"ABEF\",K23,IF('3rd Place'!K6=\"ACDE\",K23,IF('3rd Place'!K6=\"ACDF\",K23,IF('3rd Place'!K6=\"ACEF\",K23,IF('3rd Place'!K6=\"ADEF\",K23,\"3rd A/B/C\"))))))))))))))),\"3rd A/B/C\")","v":"3rd A/B/C"}]
[null,{"$f":"Teams!A3","v":"Wales"},null,{"$f":"Teams!A4","v":"Switzerland"},null,null,"","",null,1,{"$f":"VLOOKUP($J21,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:K21)+1,0)","v":"Turkey"},{"$f":"VLOOKUP($J21,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:L21)+1,0)","v":0},{"$f":"VLOOKUP($J21,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:M21)+1,0)","v":0},{"$f":"VLOOKUP($J21,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:N21)+1,0)","v":0},{"$f":"VLOOKUP($J21,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:O21)+1,0)","v":0},{"$f":"VLOOKUP($J21,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:P21)+1,0)","v":0},{"$f":"VLOOKUP($J21,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:Q21)+1,0)","v":0},{"$f":"VLOOKUP($J21,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:R21)+1,0)","v":0},{"$f":"VLOOKUP($J21,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:S21)+1,0)","v":0},null,{"$f":"IF(L43>2,K43,\"Runner Up Group D\")","v":"Runner Up Group D"},null,{"$f":"IF(L50>2,K50,\"Runner Up Group E\")","v":"Runner Up Group E"}]
[null,{"$f":"Teams!D1","v":"Denmark"},null,{"$f":"Teams!D2","v":"Finland"},null,null,"","",null,2,{"$f":"VLOOKUP($J22,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:K22)+1,0)","v":"Italy"},{"$f":"VLOOKUP($J22,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:L22)+1,0)","v":0},{"$f":"VLOOKUP($J22,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:M22)+1,0)","v":0},{"$f":"VLOOKUP($J22,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:N22)+1,0)","v":0},{"$f":"VLOOKUP($J22,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:O22)+1,0)","v":0},{"$f":"VLOOKUP($J22,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:P22)+1,0)","v":0},{"$f":"VLOOKUP($J22,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:Q22)+1,0)","v":0},{"$f":"VLOOKUP($J22,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:R22)+1,0)","v":0},{"$f":"VLOOKUP($J22,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:S22)+1,0)","v":0},null,{"$f":"IF(L28>2,K28,\"Winner Group B\")","v":"Winner Group B"},null,{"$f":"IF(L58>2,IF('3rd Place'!K6=\"ABCD\",K23,IF('3rd Place'!K6=\"ABCE\",K23,IF('3rd Place'!K6=\"ABCF\",K23,IF('3rd Place'!K6=\"BCDE\",K51,IF('3rd Place'!K6=\"CDEF\",K58,IF('3rd Place'!K6=\"ABDE\",K44,IF('3rd Place'!K6=\"ABDF\",K44,IF('3rd Place'!K6=\"BCDF\",K58,IF('3rd Place'!K6=\"BCEF\",K58,IF('3rd Place'!K6=\"BDEF\",K58,IF('3rd Place'!K6=\"ABEF\",K51,IF('3rd Place'!K6=\"ACDE\",K51,IF('3rd Place'!K6=\"ACDF\",K58,IF('3rd Place'!K6=\"ACEF\",K51,IF('3rd Place'!K6=\"ADEF\",K51,\"3rd A/D/E/F\"))))))))))))))),\"3rd A/D/E/F\")","v":"3rd A/D/E/F"}]
[null,{"$f":"Teams!D3","v":"Belgium"},null,{"$f":"Teams!D4","v":"Russia"},null,null,"","",null,3,{"$f":"VLOOKUP($J23,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:K23)+1,0)","v":"Wales"},{"$f":"VLOOKUP($J23,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:L23)+1,0)","v":0},{"$f":"VLOOKUP($J23,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:M23)+1,0)","v":0},{"$f":"VLOOKUP($J23,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:N23)+1,0)","v":0},{"$f":"VLOOKUP($J23,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:O23)+1,0)","v":0},{"$f":"VLOOKUP($J23,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:P23)+1,0)","v":0},{"$f":"VLOOKUP($J23,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:Q23)+1,0)","v":0},{"$f":"VLOOKUP($J23,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:R23)+1,0)","v":0},{"$f":"VLOOKUP($J23,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:S23)+1,0)","v":0},null,{"$f":"IF(L21>2,K21,\"Winner Group A\")","v":"Winner Group A"},null,{"$f":"IF(L36>2,K36,\"Runner Up Group C\")","v":"Runner Up Group C"}]
[null,{"$f":"Teams!G1","v":"Netherlands"},null,{"$f":"Teams!G2","v":"Ukraine"},null,null,"","",null,4,{"$f":"VLOOKUP($J24,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:K24)+1,0)","v":"Switzerland"},{"$f":"VLOOKUP($J24,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:L24)+1,0)","v":0},{"$f":"VLOOKUP($J24,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:M24)+1,0)","v":0},{"$f":"VLOOKUP($J24,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:N24)+1,0)","v":0},{"$f":"VLOOKUP($J24,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:O24)+1,0)","v":0},{"$f":"VLOOKUP($J24,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:P24)+1,0)","v":0},{"$f":"VLOOKUP($J24,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:Q24)+1,0)","v":0},{"$f":"VLOOKUP($J24,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:R24)+1,0)","v":0},{"$f":"VLOOKUP($J24,'Group Tables'!$A$2:$J$6,COLUMNS($K$21:S24)+1,0)","v":0},null,{"$f":"IF(L49>2,K49,\"Winner Group E\")","v":"Winner Group E"},null,{"$f":"IF(L58>2,IF('3rd Place'!K6=\"ABCD\",K30,IF('3rd Place'!K6=\"ABCE\",K30,IF('3rd Place'!K6=\"ABCF\",K30,IF('3rd Place'!K6=\"BCDE\",K30,IF('3rd Place'!K6=\"CDEF\",K44,IF('3rd Place'!K6=\"ABDE\",K23,IF('3rd Place'!K6=\"ABDF\",K23,IF('3rd Place'!K6=\"BCDF\",K37,IF('3rd Place'!K6=\"BCEF\",K37,IF('3rd Place'!K6=\"BDEF\",K44,IF('3rd Place'!K6=\"ABEF\",K30,IF('3rd Place'!K6=\"ACDE\",K37,IF('3rd Place'!K6=\"ACDF\",K37,IF('3rd Place'!K6=\"ACEF\",K37,IF('3rd Place'!K6=\"ADEF\",K44,\"3rd A/B/C/D\"))))))))))))))),\"3rd A/B/C/D\")","v":"3rd A/B/C/D"}]
[null,{"$f":"Teams!G3","v":"Austria"},null,{"$f":"Teams!G4","v":"North Macedonia"},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L42>2,K42,\"Winner Group D\")","v":"Winner Group D"},null,{"$f":"IF(L57>2,K57,\"Runner Up Group F\")","v":"Runner Up Group F"}]
[null,{"$f":"Teams!A7","v":"England"},null,{"$f":"Teams!A8","v":"Croatia"},null,null,"","",null,"Group B",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L35>2,K35,\"Winner Group C\")","v":"Winner Group C"},null,{"$f":"IF(L58>2,IF('3rd Place'!K6=\"ABCD\",K44,IF('3rd Place'!K6=\"ABCE\",K51,IF('3rd Place'!K6=\"ABCF\",K58,IF('3rd Place'!K6=\"BCDE\",K44,IF('3rd Place'!K6=\"CDEF\",K51,IF('3rd Place'!K6=\"ABDE\",K51,IF('3rd Place'!K6=\"ABDF\",K58,IF('3rd Place'!K6=\"BCDF\",K44,IF('3rd Place'!K6=\"BCEF\",K51,IF('3rd Place'!K6=\"BDEF\",K51,IF('3rd Place'!K6=\"ABEF\",K58,IF('3rd Place'!K6=\"ACDE\",K44,IF('3rd Place'!K6=\"ACDF\",K44,IF('3rd Place'!K6=\"ACEF\",K58,IF('3rd Place'!K6=\"ADEF\",K58,\"3rd D/E/F\"))))))))))))))),\"3rd D/E/F\")","v":"3rd D/E/F"}]
[null,{"$f":"Teams!A9","v":"Scotland"},null,{"$f":"Teams!A10","v":"Czech Republic"},null,null,"","",null,"Pos","Team","P","W","D","L","GF","GA","+/-","Pts",null,{"$f":"IF(L22>2,K22,\"Runner Up Group A\")","v":"Runner Up Group A"},null,{"$f":"IF(L29>2,K29,\"Runner Up Group B\")","v":"Runner Up Group B"}]
[null,{"$f":"Teams!D7","v":"Spain"},null,{"$f":"Teams!D8","v":"Sweden"},null,null,"","",null,1,{"$f":"VLOOKUP($J28,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:K28)+1,0)","v":"Denmark"},{"$f":"VLOOKUP($J28,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:L28)+1,0)","v":0},{"$f":"VLOOKUP($J28,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:M28)+1,0)","v":0},{"$f":"VLOOKUP($J28,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:N28)+1,0)","v":0},{"$f":"VLOOKUP($J28,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:O28)+1,0)","v":0},{"$f":"VLOOKUP($J28,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:P28)+1,0)","v":0},{"$f":"VLOOKUP($J28,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:Q28)+1,0)","v":0},{"$f":"VLOOKUP($J28,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:R28)+1,0)","v":0},{"$f":"VLOOKUP($J28,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:S28)+1,0)","v":0}]
[null,{"$f":"Teams!D9","v":"Poland"},null,{"$f":"Teams!D10","v":"Slovakia"},null,null,"","",null,2,{"$f":"VLOOKUP($J29,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:K29)+1,0)","v":"Finland"},{"$f":"VLOOKUP($J29,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:L29)+1,0)","v":0},{"$f":"VLOOKUP($J29,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:M29)+1,0)","v":0},{"$f":"VLOOKUP($J29,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:N29)+1,0)","v":0},{"$f":"VLOOKUP($J29,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:O29)+1,0)","v":0},{"$f":"VLOOKUP($J29,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:P29)+1,0)","v":0},{"$f":"VLOOKUP($J29,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:Q29)+1,0)","v":0},{"$f":"VLOOKUP($J29,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:R29)+1,0)","v":0},{"$f":"VLOOKUP($J29,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:S29)+1,0)","v":0}]
[null,{"$f":"Teams!G7","v":"Hungary"},null,{"$f":"Teams!G8","v":"Portugal"},null,null,"","",null,3,{"$f":"VLOOKUP($J30,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:K30)+1,0)","v":"Belgium"},{"$f":"VLOOKUP($J30,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:L30)+1,0)","v":0},{"$f":"VLOOKUP($J30,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:M30)+1,0)","v":0},{"$f":"VLOOKUP($J30,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:N30)+1,0)","v":0},{"$f":"VLOOKUP($J30,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:O30)+1,0)","v":0},{"$f":"VLOOKUP($J30,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:P30)+1,0)","v":0},{"$f":"VLOOKUP($J30,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:Q30)+1,0)","v":0},{"$f":"VLOOKUP($J30,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:R30)+1,0)","v":0},{"$f":"VLOOKUP($J30,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:S30)+1,0)","v":0},null,"Quarter Final"]
[null,{"$f":"Teams!G9","v":"France"},null,{"$f":"Teams!G10","v":"Germany"},null,null,"","",null,4,{"$f":"VLOOKUP($J31,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:K31)+1,0)","v":"Russia"},{"$f":"VLOOKUP($J31,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:L31)+1,0)","v":0},{"$f":"VLOOKUP($J31,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:M31)+1,0)","v":0},{"$f":"VLOOKUP($J31,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:N31)+1,0)","v":0},{"$f":"VLOOKUP($J31,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:O31)+1,0)","v":0},{"$f":"VLOOKUP($J31,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:P31)+1,0)","v":0},{"$f":"VLOOKUP($J31,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:Q31)+1,0)","v":0},{"$f":"VLOOKUP($J31,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:R31)+1,0)","v":0},{"$f":"VLOOKUP($J31,'Group Tables'!$A$8:$J$12,COLUMNS($K$28:S31)+1,0)","v":0},null,{"$f":"IF(V20=\"X\",U20,IF(X20=\"X\",W20,\"Winner R16 (1)\"))","v":"Winner R16 (1)"},null,{"$f":"IF(V21=\"X\",U21,IF(X21=\"X\",W21,\"Winner R16 (2)\"))","v":"Winner R16 (2)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V22=\"X\",U22,IF(X22=\"X\",W22,\"Winner R16 (3)\"))","v":"Winner R16 (3)"},null,{"$f":"IF(V23=\"X\",U23,IF(X23=\"X\",W23,\"Winner R16 (4)\"))","v":"Winner R16 (4)"}]
[null,"Matchday 2",null,null,null,null,null,null,null,"Group C",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V24=\"X\",U24,IF(X24=\"X\",W24,\"Winner R16 (5)\"))","v":"Winner R16 (5)"},null,{"$f":"IF(V25=\"X\",U25,IF(X25=\"X\",W25,\"Winner R16 (6)\"))","v":"Winner R16 (6)"}]
[null,{"$f":"Teams!A1","v":"Turkey"},null,{"$f":"Teams!A3","v":"Wales"},null,null,{"$f":"IF(C34=\"\",\"\",IF(C34>E34,3,IF(C34=E34,1,0)))","v":""},{"$f":"IF(E34=\"\",\"\",IF(E34>C34,3,IF(E34=C34,1,0)))","v":""},null,"Pos","Team","P","W","D","L","GF","GA","+/-","Pts",null,{"$f":"IF(V26=\"X\",U26,IF(X26=\"X\",W26,\"Winner R16 (7)\"))","v":"Winner R16 (7)"},null,{"$f":"IF(V27=\"X\",U27,IF(X27=\"X\",W27,\"Winner R16 (8)\"))","v":"Winner R16 (8)"}]
[null,{"$f":"Teams!A2","v":"Italy"},null,{"$f":"Teams!A4","v":"Switzerland"},null,null,"","",null,1,{"$f":"VLOOKUP($J35,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:K38)+1,0)","v":"Netherlands"},{"$f":"VLOOKUP($J35,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:L35)+1,0)","v":0},{"$f":"VLOOKUP($J35,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:M35)+1,0)","v":0},{"$f":"VLOOKUP($J35,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:N35)+1,0)","v":0},{"$f":"VLOOKUP($J35,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:O35)+1,0)","v":0},{"$f":"VLOOKUP($J35,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:P35)+1,0)","v":0},{"$f":"VLOOKUP($J35,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:Q35)+1,0)","v":0},{"$f":"VLOOKUP($J35,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:R35)+1,0)","v":0},{"$f":"VLOOKUP($J35,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:S35)+1,0)","v":0}]
[null,{"$f":"Teams!D1","v":"Denmark"},null,{"$f":"Teams!D3","v":"Belgium"},null,null,"","",null,2,{"$f":"VLOOKUP($J36,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:K39)+1,0)","v":"Ukraine"},{"$f":"VLOOKUP($J36,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:L36)+1,0)","v":0},{"$f":"VLOOKUP($J36,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:M36)+1,0)","v":0},{"$f":"VLOOKUP($J36,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:N36)+1,0)","v":0},{"$f":"VLOOKUP($J36,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:O36)+1,0)","v":0},{"$f":"VLOOKUP($J36,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:P36)+1,0)","v":0},{"$f":"VLOOKUP($J36,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:Q36)+1,0)","v":0},{"$f":"VLOOKUP($J36,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:R36)+1,0)","v":0},{"$f":"VLOOKUP($J36,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:S36)+1,0)","v":0}]
[null,{"$f":"Teams!D2","v":"Finland"},null,{"$f":"Teams!D4","v":"Russia"},null,null,"","",null,3,{"$f":"VLOOKUP($J37,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:K40)+1,0)","v":"Austria"},{"$f":"VLOOKUP($J37,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:L37)+1,0)","v":0},{"$f":"VLOOKUP($J37,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:M37)+1,0)","v":0},{"$f":"VLOOKUP($J37,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:N37)+1,0)","v":0},{"$f":"VLOOKUP($J37,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:O37)+1,0)","v":0},{"$f":"VLOOKUP($J37,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:P37)+1,0)","v":0},{"$f":"VLOOKUP($J37,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:Q37)+1,0)","v":0},{"$f":"VLOOKUP($J37,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:R37)+1,0)","v":0},{"$f":"VLOOKUP($J37,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:S37)+1,0)","v":0},null,"Semi Final"]
[null,{"$f":"Teams!G1","v":"Netherlands"},null,{"$f":"Teams!G3","v":"Austria"},null,null,"","",null,4,{"$f":"VLOOKUP($J38,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:K41)+1,0)","v":"North Macedonia"},{"$f":"VLOOKUP($J38,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:L38)+1,0)","v":0},{"$f":"VLOOKUP($J38,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:M38)+1,0)","v":0},{"$f":"VLOOKUP($J38,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:N38)+1,0)","v":0},{"$f":"VLOOKUP($J38,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:O38)+1,0)","v":0},{"$f":"VLOOKUP($J38,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:P38)+1,0)","v":0},{"$f":"VLOOKUP($J38,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:Q38)+1,0)","v":0},{"$f":"VLOOKUP($J38,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:R38)+1,0)","v":0},{"$f":"VLOOKUP($J38,'Group Tables'!$A$14:$J$18,COLUMNS($K$35:S38)+1,0)","v":0},null,{"$f":"IF(V31=\"X\",U31,IF(X31=\"X\",W31,\"Winner QF (1)\"))","v":"Winner QF (1)"},null,{"$f":"IF(V32=\"X\",U32,IF(X32=\"X\",W32,\"Winner QF (2)\"))","v":"Winner QF (2)"}]
[null,{"$f":"Teams!G2","v":"Ukraine"},null,{"$f":"Teams!G4","v":"North Macedonia"},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V33=\"X\",U33,IF(X33=\"X\",W33,\"Winner QF (3)\"))","v":"Winner QF (3)"},null,{"$f":"IF(V34=\"X\",U34,IF(X34=\"X\",W34,\"Winner QF (4)\"))","v":"Winner QF (4)"}]
[null,{"$f":"Teams!A7","v":"England"},null,{"$f":"Teams!A9","v":"Scotland"},null,null,"","",null,"Group D",null,null,null,null,null,null,null,null,null,null,"5 pts for each semi-finalist"]
[null,{"$f":"Teams!A8","v":"Croatia"},null,{"$f":"Teams!A10","v":"Czech Republic"},null,null,"","",null,"Pos","Team","P","W","D","L","GF","GA","+/-","Pts"]
[null,{"$f":"Teams!D7","v":"Spain"},null,{"$f":"Teams!D9","v":"Poland"},null,null,"","",null,1,{"$f":"VLOOKUP($J42,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:K45)+1,0)","v":"England"},{"$f":"VLOOKUP($J42,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:L42)+1,0)","v":0},{"$f":"VLOOKUP($J42,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:M42)+1,0)","v":0},{"$f":"VLOOKUP($J42,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:N42)+1,0)","v":0},{"$f":"VLOOKUP($J42,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:O42)+1,0)","v":0},{"$f":"VLOOKUP($J42,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:P42)+1,0)","v":0},{"$f":"VLOOKUP($J42,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:Q42)+1,0)","v":0},{"$f":"VLOOKUP($J42,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:R42)+1,0)","v":0},{"$f":"VLOOKUP($J42,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:S42)+1,0)","v":0},null,"Final"]
[null,{"$f":"Teams!D8","v":"Sweden"},null,{"$f":"Teams!D10","v":"Slovakia"},null,null,"","",null,2,{"$f":"VLOOKUP($J43,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:K46)+1,0)","v":"Croatia"},{"$f":"VLOOKUP($J43,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:L43)+1,0)","v":0},{"$f":"VLOOKUP($J43,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:M43)+1,0)","v":0},{"$f":"VLOOKUP($J43,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:N43)+1,0)","v":0},{"$f":"VLOOKUP($J43,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:O43)+1,0)","v":0},{"$f":"VLOOKUP($J43,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:P43)+1,0)","v":0},{"$f":"VLOOKUP($J43,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:Q43)+1,0)","v":0},{"$f":"VLOOKUP($J43,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:R43)+1,0)","v":0},{"$f":"VLOOKUP($J43,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:S43)+1,0)","v":0},null,{"$f":"IF(V38=\"X\",U38,IF(X38=\"X\",W38,\"Winner SF (1)\"))","v":"Winner SF (1)"},null,{"$f":"IF(V39=\"X\",U39,IF(X39=\"X\",W39,\"Winner SF (2)\"))","v":"Winner SF (2)"}]
[null,{"$f":"Teams!G7","v":"Hungary"},null,{"$f":"Teams!G9","v":"France"},null,null,"","",null,3,{"$f":"VLOOKUP($J44,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:K47)+1,0)","v":"Scotland"},{"$f":"VLOOKUP($J44,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:L44)+1,0)","v":0},{"$f":"VLOOKUP($J44,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:M44)+1,0)","v":0},{"$f":"VLOOKUP($J44,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:N44)+1,0)","v":0},{"$f":"VLOOKUP($J44,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:O44)+1,0)","v":0},{"$f":"VLOOKUP($J44,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:P44)+1,0)","v":0},{"$f":"VLOOKUP($J44,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:Q44)+1,0)","v":0},{"$f":"VLOOKUP($J44,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:R44)+1,0)","v":0},{"$f":"VLOOKUP($J44,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:S44)+1,0)","v":0}]
[null,{"$f":"Teams!G8","v":"Portugal"},null,{"$f":"Teams!G10","v":"Germany"},null,null,"","",null,4,{"$f":"VLOOKUP($J45,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:K48)+1,0)","v":"Czech Republic"},{"$f":"VLOOKUP($J45,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:L45)+1,0)","v":0},{"$f":"VLOOKUP($J45,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:M45)+1,0)","v":0},{"$f":"VLOOKUP($J45,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:N45)+1,0)","v":0},{"$f":"VLOOKUP($J45,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:O45)+1,0)","v":0},{"$f":"VLOOKUP($J45,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:P45)+1,0)","v":0},{"$f":"VLOOKUP($J45,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:Q45)+1,0)","v":0},{"$f":"VLOOKUP($J45,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:R45)+1,0)","v":0},{"$f":"VLOOKUP($J45,'Group Tables'!$A$20:$J$24,COLUMNS($K$42:S45)+1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winner"]
[null,"Matchday 3",null,null,null,null,null,null,null,"Group E",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V43=\"X\",U43,IF(X43=\"X\",W43,\"\"))","v":""},null,null,null,null,{"$f":"U47","v":""}]
[null,{"$f":"Teams!A4","v":"Switzerland"},null,{"$f":"Teams!A1","v":"Turkey"},null,null,{"$f":"IF(C48=\"\",\"\",IF(C48>E48,3,IF(C48=E48,1,0)))","v":""},{"$f":"IF(E48=\"\",\"\",IF(E48>C48,3,IF(E48=C48,1,0)))","v":""},null,"Pos","Team","P","W","D","L","GF","GA","+/-","Pts",null,"5 pts"]
[null,{"$f":"Teams!A2","v":"Italy"},null,{"$f":"Teams!A3","v":"Wales"},null,null,"","",null,1,{"$f":"VLOOKUP($J49,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:K52)+1,0)","v":"Spain"},{"$f":"VLOOKUP($J49,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:L52)+1,0)","v":0},{"$f":"VLOOKUP($J49,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:M49)+1,0)","v":0},{"$f":"VLOOKUP($J49,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:N49)+1,0)","v":0},{"$f":"VLOOKUP($J49,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:O49)+1,0)","v":0},{"$f":"VLOOKUP($J49,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:P49)+1,0)","v":0},{"$f":"VLOOKUP($J49,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:Q49)+1,0)","v":0},{"$f":"VLOOKUP($J49,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:R49)+1,0)","v":0},{"$f":"VLOOKUP($J49,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:S49)+1,0)","v":0}]
[null,{"$f":"Teams!D4","v":"Russia"},null,{"$f":"Teams!D1","v":"Denmark"},null,null,"","",null,2,{"$f":"VLOOKUP($J50,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:K53)+1,0)","v":"Sweden"},{"$f":"VLOOKUP($J50,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:L53)+1,0)","v":0},{"$f":"VLOOKUP($J50,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:M50)+1,0)","v":0},{"$f":"VLOOKUP($J50,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:N50)+1,0)","v":0},{"$f":"VLOOKUP($J50,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:O50)+1,0)","v":0},{"$f":"VLOOKUP($J50,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:P50)+1,0)","v":0},{"$f":"VLOOKUP($J50,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:Q50)+1,0)","v":0},{"$f":"VLOOKUP($J50,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:R50)+1,0)","v":0},{"$f":"VLOOKUP($J50,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:S50)+1,0)","v":0},null,"Top Goalscorer"]
[null,{"$f":"Teams!D2","v":"Finland"},null,{"$f":"Teams!D3","v":"Belgium"},null,null,"","",null,3,{"$f":"VLOOKUP($J51,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:K54)+1,0)","v":"Poland"},{"$f":"VLOOKUP($J51,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:L54)+1,0)","v":0},{"$f":"VLOOKUP($J51,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:M51)+1,0)","v":0},{"$f":"VLOOKUP($J51,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:N51)+1,0)","v":0},{"$f":"VLOOKUP($J51,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:O51)+1,0)","v":0},{"$f":"VLOOKUP($J51,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:P51)+1,0)","v":0},{"$f":"VLOOKUP($J51,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:Q51)+1,0)","v":0},{"$f":"VLOOKUP($J51,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:R51)+1,0)","v":0},{"$f":"VLOOKUP($J51,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:S51)+1,0)","v":0},null,null,null,null,null,null,{"$f":"IF(U51=\"\",\"\",U51)","v":""}]
[null,{"$f":"Teams!G4","v":"North Macedonia"},null,{"$f":"Teams!G1","v":"Netherlands"},null,null,"","",null,4,{"$f":"VLOOKUP($J52,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:K55)+1,0)","v":"Slovakia"},{"$f":"VLOOKUP($J52,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:L55)+1,0)","v":0},{"$f":"VLOOKUP($J52,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:M52)+1,0)","v":0},{"$f":"VLOOKUP($J52,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:N52)+1,0)","v":0},{"$f":"VLOOKUP($J52,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:O52)+1,0)","v":0},{"$f":"VLOOKUP($J52,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:P52)+1,0)","v":0},{"$f":"VLOOKUP($J52,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:Q52)+1,0)","v":0},{"$f":"VLOOKUP($J52,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:R52)+1,0)","v":0},{"$f":"VLOOKUP($J52,'Group Tables'!$A$26:$J$30,COLUMNS($K$49:S52)+1,0)","v":0},null,"5 pts (as ruled by UEFA)"]
[null,{"$f":"Teams!G2","v":"Ukraine"},null,{"$f":"Teams!G3","v":"Austria"},null,null,"",""]
[null,{"$f":"Teams!A10","v":"Czech Republic"},null,{"$f":"Teams!A7","v":"England"},null,null,"","",null,"Group F",null,null,null,null,null,null,null,null,null,null,"Goals in Group Stages"]
[null,{"$f":"Teams!A8","v":"Croatia"},null,{"$f":"Teams!A9","v":"Scotland"},null,null,"","",null,"Pos","Team","P","W","D","L","GF","GA","+/-","Pts",null,{"$f":"SUM(C20:C31,E20:E31,C34:C45,E34:E45,C48:C59,E48:E59)","v":0}]
[null,{"$f":"Teams!D10","v":"Slovakia"},null,{"$f":"Teams!D7","v":"Spain"},null,null,"","",null,1,{"$f":"VLOOKUP($J56,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:K59)+1,0)","v":"Hungary"},{"$f":"VLOOKUP($J56,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:L56)+1,0)","v":0},{"$f":"VLOOKUP($J56,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:M56)+1,0)","v":0},{"$f":"VLOOKUP($J56,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:N56)+1,0)","v":0},{"$f":"VLOOKUP($J56,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:O56)+1,0)","v":0},{"$f":"VLOOKUP($J56,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:P56)+1,0)","v":0},{"$f":"VLOOKUP($J56,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:Q56)+1,0)","v":0},{"$f":"VLOOKUP($J56,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:R56)+1,0)","v":0},{"$f":"VLOOKUP($J56,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:S56)+1,0)","v":0},null,"Tiebreaker (updates automatically)"]
[null,{"$f":"Teams!D8","v":"Sweden"},null,{"$f":"Teams!D9","v":"Poland"},null,null,"","",null,2,{"$f":"VLOOKUP($J57,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:K59)+1,0)","v":"Portugal"},{"$f":"VLOOKUP($J57,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:L57)+1,0)","v":0},{"$f":"VLOOKUP($J57,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:M57)+1,0)","v":0},{"$f":"VLOOKUP($J57,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:N57)+1,0)","v":0},{"$f":"VLOOKUP($J57,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:O57)+1,0)","v":0},{"$f":"VLOOKUP($J57,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:P57)+1,0)","v":0},{"$f":"VLOOKUP($J57,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:Q57)+1,0)","v":0},{"$f":"VLOOKUP($J57,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:R57)+1,0)","v":0},{"$f":"VLOOKUP($J57,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:S57)+1,0)","v":0}]
[null,{"$f":"Teams!G10","v":"Germany"},null,{"$f":"Teams!G7","v":"Hungary"},null,null,"","",null,3,{"$f":"VLOOKUP($J58,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:K59)+1,0)","v":"France"},{"$f":"VLOOKUP($J58,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:L58)+1,0)","v":0},{"$f":"VLOOKUP($J58,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:M58)+1,0)","v":0},{"$f":"VLOOKUP($J58,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:N58)+1,0)","v":0},{"$f":"VLOOKUP($J58,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:O58)+1,0)","v":0},{"$f":"VLOOKUP($J58,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:P58)+1,0)","v":0},{"$f":"VLOOKUP($J58,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:Q58)+1,0)","v":0},{"$f":"VLOOKUP($J58,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:R58)+1,0)","v":0},{"$f":"VLOOKUP($J58,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:S58)+1,0)","v":0},null,"Total Points (marking purposes)"]
[null,{"$f":"Teams!G8","v":"Portugal"},null,{"$f":"Teams!G9","v":"France"},null,null,"","",null,4,{"$f":"VLOOKUP($J59,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:K60)+1,0)","v":"Germany"},{"$f":"VLOOKUP($J59,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:L59)+1,0)","v":0},{"$f":"VLOOKUP($J59,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:M59)+1,0)","v":0},{"$f":"VLOOKUP($J59,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:N59)+1,0)","v":0},{"$f":"VLOOKUP($J59,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:O59)+1,0)","v":0},{"$f":"VLOOKUP($J59,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:P59)+1,0)","v":0},{"$f":"VLOOKUP($J59,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:Q59)+1,0)","v":0},{"$f":"VLOOKUP($J59,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:R59)+1,0)","v":0},{"$f":"VLOOKUP($J59,'Group Tables'!$A$32:$J$36,COLUMNS($K$56:S59)+1,0)","v":0}]

{"sheet":"Group Tables","index":1,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":true,"merged":[[1,12,1,13]]}
[]
["Rank","Team","P","W","D","L","GF","GA","+/-","Pts","Rank Criteria",null,"do not change these cells"]
[{"$f":"RANK(K3,$K$3:$K$6,0)+COUNTIF($K$3:$K3,$K3)-1","v":1},{"$f":"Teams!A1","v":"Turkey"},{"$f":"COUNTIFS('TACC Competition'!$B$20:'TACC Competition'!$B$59,'Group Tables'!B3,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B3,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B3,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B3,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B3,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B3,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B3,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B3,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B3,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B3,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B3,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B3,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G3-H3","v":0},{"$f":"SUM((D3*3)+E3)","v":0},{"$f":"SUM(J3*1000000+I3*10000+G3*100+D3*10)","v":0}]
[{"$f":"RANK(K4,$K$3:$K$6,0)+COUNTIF($K$3:$K4,$K4)-1","v":2},{"$f":"Teams!A2","v":"Italy"},{"$f":"COUNTIFS('TACC Competition'!$B$20:'TACC Competition'!$B$59,'Group Tables'!B4,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B4,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B4,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B4,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B4,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B4,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B4,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B4,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B4,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B4,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B4,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B4,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G4-H4","v":0},{"$f":"SUM((D4*3)+E4)","v":0},{"$f":"SUM(J4*1000000+I4*10000+G4*100+D4*10)","v":0}]
[{"$f":"RANK(K5,$K$3:$K$6,0)+COUNTIF($K$3:$K5,$K5)-1","v":3},{"$f":"Teams!A3","v":"Wales"},{"$f":"COUNTIFS('TACC Competition'!$B$20:'TACC Competition'!$B$59,'Group Tables'!B5,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B5,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B5,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B5,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B5,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B5,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B5,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B5,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B5,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B5,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B5,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B5,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D5*3)+E5)","v":0},0]
[{"$f":"RANK(K6,$K$3:$K$6,0)+COUNTIF($K$3:$K6,$K6)-1","v":4},{"$f":"Teams!A4","v":"Switzerland"},{"$f":"COUNTIFS('TACC Competition'!$B$20:'TACC Competition'!$B$59,'Group Tables'!B6,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B6,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B6,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B6,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B6,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B6,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B6,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B6,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B6,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B6,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B6,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B6,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D6*3)+E6)","v":0},0]
[]
["Rank","Team","P","W","D","L","GF","GA","+/-","Pts","Rank Criteria"]
[{"$f":"RANK(K9,$K$9:$K$12,0)+COUNTIF($K$9:$K9,$K9)-1","v":1},{"$f":"Teams!D1","v":"Denmark"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B9,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B9,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B9,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B9,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B9,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B9,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B9,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B9,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B9,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B9,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B9,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B9,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G9-H9","v":0},{"$f":"SUM((D9*3)+E9)","v":0},{"$f":"SUM(J9*1000000+I9*10000+G9*100+D9*10)","v":0}]
[{"$f":"RANK(K10,$K$9:$K$12,0)+COUNTIF($K$9:$K10,$K10)-1","v":2},{"$f":"Teams!D2","v":"Finland"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B10,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B10,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B10,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B10,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B10,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B10,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B10,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B10,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B10,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B10,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B10,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B10,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G10-H10","v":0},{"$f":"SUM((D10*3)+E10)","v":0},{"$f":"SUM(J10*1000000+I10*10000+G10*100+D10*10)","v":0}]
[{"$f":"RANK(K11,$K$9:$K$12,0)+COUNTIF($K$9:$K11,$K11)-1","v":3},{"$f":"Teams!D3","v":"Belgium"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B11,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B11,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B11,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B11,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B11,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B11,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B11,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B11,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B11,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B11,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B11,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B11,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D11*3)+E11)","v":0},0]
[{"$f":"RANK(K12,$K$9:$K$12,0)+COUNTIF($K$9:$K12,$K12)-1","v":4},{"$f":"Teams!D4","v":"Russia"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B12,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B12,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B12,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B12,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B12,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B12,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B12,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B12,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B12,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B12,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B12,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B12,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D12*3)+E12)","v":0},0]
[]
["Rank","Team","P","W","D","L","GF","GA","+/-","Pts","Rank Criteria"]
[{"$f":"RANK(K15,$K$15:$K$18,0)+COUNTIF($K$15:$K15,$K15)-1","v":1},{"$f":"Teams!G1","v":"Netherlands"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B15,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B15,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B15,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B15,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B15,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B15,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B15,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B15,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B15,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B15,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B15,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B15,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G15-H15","v":0},{"$f":"SUM((D15*3)+E15)","v":0},{"$f":"SUM(J15*1000000+I15*10000+G15*100+D15*10)","v":0}]
[{"$f":"RANK(K16,$K$15:$K$18,0)+COUNTIF($K$15:$K16,$K16)-1","v":2},{"$f":"Teams!G2","v":"Ukraine"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B16,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B16,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B16,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B16,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B16,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B16,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B16,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B16,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B16,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B16,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B16,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B16,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G16-H16","v":0},{"$f":"SUM((D16*3)+E16)","v":0},{"$f":"SUM(J16*1000000+I16*10000+G16*100+D16*10)","v":0}]
[{"$f":"RANK(K17,$K$15:$K$18,0)+COUNTIF($K$15:$K17,$K17)-1","v":3},{"$f":"Teams!G3","v":"Austria"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B17,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B17,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B17,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B17,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B17,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B17,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B17,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B17,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B17,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B17,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B17,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B17,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D17*3)+E17)","v":0},0]
[{"$f":"RANK(K18,$K$15:$K$18,0)+COUNTIF($K$15:$K18,$K18)-1","v":4},{"$f":"Teams!G4","v":"North Macedonia"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B18,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B18,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B18,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B18,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B18,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B18,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B18,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B18,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B18,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B18,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B18,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B18,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D18*3)+E18)","v":0},0]
[]
["Rank","Team","P","W","D","L","GF","GA","+/-","Pts","Rank Criteria"]
[{"$f":"RANK(K21,$K$21:$K$24,0)+COUNTIF($K21:$K$21,$K21)-1","v":1},{"$f":"Teams!A7","v":"England"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B21,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B21,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B21,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B21,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B21,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B21,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B21,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B21,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B21,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B21,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B21,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B21,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G21-H21","v":0},{"$f":"SUM((D21*3)+E21)","v":0},{"$f":"SUM(J21*1000000+I21*10000+G21*100+D21*10)","v":0}]
[{"$f":"RANK(K22,$K$21:$K$24,0)+COUNTIF($K$21:$K22,$K22)-1","v":2},{"$f":"Teams!A8","v":"Croatia"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B22,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B22,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B22,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B22,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B22,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B22,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B22,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B22,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B22,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B22,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B22,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B22,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G22-H22","v":0},{"$f":"SUM((D22*3)+E22)","v":0},{"$f":"SUM(J22*1000000+I22*10000+G22*100+D22*10)","v":0}]
[{"$f":"RANK(K23,$K$21:$K$24,0)+COUNTIF($K$21:$K23,$K23)-1","v":3},{"$f":"Teams!A9","v":"Scotland"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B23,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B23,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B23,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B23,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B23,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B23,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B23,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B23,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B23,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B23,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B23,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B23,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D23*3)+E23)","v":0},0]
[{"$f":"RANK(K24,$K$21:$K$24,0)+COUNTIF($K$21:$K24,$K24)-1","v":4},{"$f":"Teams!A10","v":"Czech Republic"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B24,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B24,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B24,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B24,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B24,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B24,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B24,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B24,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B24,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B24,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B24,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B24,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D24*3)+E24)","v":0},0]
[]
["Rank","Team","P","W","D","L","GF","GA","+/-","Pts","Rank Criteria"]
[{"$f":"RANK(K27,$K$27:$K$30,0)+COUNTIF($K$27:$K27,$K27)-1","v":1},{"$f":"Teams!D7","v":"Spain"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B27,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B27,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B27,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B27,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B27,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B27,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B27,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B27,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B27,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B27,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B27,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B27,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G27-H27","v":0},{"$f":"SUM((D27*3)+E27)","v":0},{"$f":"SUM(J27*1000000+I27*10000+G27*100+D27*10)","v":0}]
[{"$f":"RANK(K28,$K$27:$K$30,0)+COUNTIF($K$27:$K28,$K28)-1","v":2},{"$f":"Teams!D8","v":"Sweden"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B28,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B28,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B28,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B28,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B28,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B28,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B28,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B28,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B28,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B28,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B28,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B28,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G28-H28","v":0},{"$f":"SUM((D28*3)+E28)","v":0},{"$f":"SUM(J28*1000000+I28*10000+G28*100+D28*10)","v":0}]
[{"$f":"RANK(K29,$K$27:$K$30,0)+COUNTIF($K$27:$K29,$K29)-1","v":3},{"$f":"Teams!D9","v":"Poland"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B29,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B29,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B29,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B29,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B29,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B29,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B29,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B29,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B29,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B29,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B29,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B29,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D29*3)+E29)","v":0},0]
[{"$f":"RANK(K30,$K$27:$K$30,0)+COUNTIF($K$27:$K30,$K30)-1","v":4},{"$f":"Teams!D10","v":"Slovakia"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B30,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B30,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B30,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B30,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B30,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B30,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B30,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B30,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B30,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B30,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B30,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B30,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D30*3)+E30)","v":0},0]
[]
["Rank","Team","P","W","D","L","GF","GA","+/-","Pts","Rank Criteria"]
[{"$f":"RANK(K33,$K$33:$K$36,0)+COUNTIF($K$33:$K33,$K33)-1","v":1},{"$f":"Teams!G7","v":"Hungary"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B33,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B33,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B33,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B33,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B33,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B33,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B33,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B33,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B33,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B33,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B33,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B33,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G33-H33","v":0},{"$f":"SUM((D33*3)+E33)","v":0},{"$f":"SUM(J33*1000000+I33*10000+G33*100+D33*10)","v":0}]
[{"$f":"RANK(K34,$K$33:$K$36,0)+COUNTIF($K$33:$K34,$K34)-1","v":2},{"$f":"Teams!G8","v":"Portugal"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B34,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B34,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B34,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B34,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B34,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B34,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B34,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B34,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B34,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B34,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B34,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B34,'TACC Competition'!$C$20:$C$59)","v":0},{"$f":"G34-H34","v":0},{"$f":"SUM((D34*3)+E34)","v":0},{"$f":"SUM(J34*1000000+I34*10000+G34*100+D34*10)","v":0}]
[{"$f":"RANK(K35,$K$33:$K$36,0)+COUNTIF($K$33:$K35,$K35)-1","v":3},{"$f":"Teams!G9","v":"France"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B35,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B35,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B35,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B35,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B35,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B35,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B35,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B35,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B35,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B35,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B35,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B35,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D35*3)+E35)","v":0},0]
[{"$f":"RANK(K36,$K$33:$K$36,0)+COUNTIF($K$33:$K36,$K36)-1","v":4},{"$f":"Teams!G10","v":"Germany"},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B36,'TACC Competition'!$C$20:$C$59,\">=0\")+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B36,'TACC Competition'!$E$20:$E$59,\">=0\")","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B36,'TACC Competition'!$G$20:$G$59,3)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B36,'TACC Competition'!$H$20:$H$59,3)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B36,'TACC Competition'!$G$20:$G$59,1)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B36,'TACC Competition'!$H$20:$H$59,1)","v":0},{"$f":"COUNTIFS('TACC Competition'!$B$20:$B$59,'Group Tables'!B36,'TACC Competition'!$G$20:$G$59,0)+COUNTIFS('TACC Competition'!$D$20:$D$59,'Group Tables'!B36,'TACC Competition'!$H$20:$H$59,0)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B36,'TACC Competition'!$C$20:$C$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B36,'TACC Competition'!$E$20:$E$59)","v":0},{"$f":"SUMIF('TACC Competition'!$B$20:$B$59,'Group Tables'!B36,'TACC Competition'!$E$20:$E$59)+SUMIF('TACC Competition'!$D$20:$D$59,'Group Tables'!B36,'TACC Competition'!$C$20:$C$59)","v":0},0,{"$f":"SUM((D36*3)+E36)","v":0},0]

{"sheet":"3rd Place","index":2,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":true,"merged":[[8,1,8,2]]}
["A",1,{"$f":"VLOOKUP(E1,'Group Tables'!B3:K6,10,0)","v":0},"A",{"$f":"'TACC Competition'!K23","v":"Wales"},{"$f":"RANK(C1,$C$1:$C$6,0)+COUNTIF($C$1:$C1,$C1)-1","v":1},{"$f":"D1","v":"A"},{"$f":"VLOOKUP(B1,$F$1:$G$6,2,0)","v":"A"},{"$f":"COUNTIF($H$1:$H$4,\"<=\"&H1)","v":1},{"$f":"INDEX($H$1:$H$4,MATCH(ROWS($I$1:I1),$I$1:$I$4,0))","v":"A"}]
["B",2,{"$f":"VLOOKUP(E2,'Group Tables'!B9:K12,10,0)","v":0},"B",{"$f":"'TACC Competition'!K30","v":"Belgium"},{"$f":"RANK(C2,$C$1:$C$6,0)+COUNTIF($C$1:$C2,$C2)-1","v":2},"B",{"$f":"VLOOKUP(B2,$F$1:$G$6,2,0)","v":"B"},{"$f":"COUNTIF($H$1:$H$4,\"<=\"&H2)","v":2},{"$f":"INDEX($H$1:$H$4,MATCH(ROWS($I$1:I2),$I$1:$I$4,0))","v":"B"}]
["C",3,{"$f":"VLOOKUP(E3,'Group Tables'!B15:K18,10,0)","v":0},"C",{"$f":"'TACC Competition'!K37","v":"Austria"},{"$f":"RANK(C3,$C$1:$C$6,0)+COUNTIF($C$1:$C3,$C3)-1","v":3},"C","C",3,{"$f":"INDEX($H$1:$H$4,MATCH(ROWS($I$1:I3),$I$1:$I$4,0))","v":"C"}]
["D",4,{"$f":"VLOOKUP(E4,'Group Tables'!B21:K24,10,0)","v":0},"D",{"$f":"'TACC Competition'!K44","v":"Scotland"},{"$f":"RANK(C4,$C$1:$C$6,0)+COUNTIF($C$1:$C4,$C4)-1","v":4},"D","D",4,{"$f":"INDEX($H$1:$H$4,MATCH(ROWS($I$1:I4),$I$1:$I$4,0))","v":"D"}]
["E",5,{"$f":"VLOOKUP(E5,'Group Tables'!B27:K30,10,0)","v":0},"E",{"$f":"'TACC Competition'!K51","v":"Poland"},{"$f":"RANK(C5,$C$1:$C$6,0)+COUNTIF($C$1:$C5,$C5)-1","v":5},"E"]
["F",6,{"$f":"VLOOKUP(E6,'Group Tables'!B33:K36,10,0)","v":0},"F",{"$f":"'TACC Competition'!K58","v":"France"},{"$f":"RANK(C6,$C$1:$C$6,0)+COUNTIF($C$1:$C6,$C6)-1","v":6},"F",null,null,null,{"$f":"IF('TACC Competition'!L59>0,CONCATENATE(J1,J2,J3,J4),0)","v":0}]
[]
[]
[null,"do not change these cells"]

{"sheet":"Teams","index":3,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Turkey","A1",null,"Denmark","B1",null,"Netherlands","C1",null,"input (list)","X"]
["Italy","A2",null,"Finland","B2",null,"Ukraine","C2"]
["Wales","A3",null,"Belgium","B3",null,"Austria","C3"]
["Switzerland","A4",null,"Russia","B4",null,"North Macedonia","C4"]
[]
[]
["England","D1",null,"Spain","E1",null,"Hungary","F1"]
["Croatia","D2",null,"Sweden","E2",null,"Portugal","F2"]
["Scotland","D3",null,"Poland","E3",null,"France","F3"]
["Czech Republic","D4",null,"Slovakia","E4",null,"Germany","F4"]

{"sheet":"Marking Sheet","index":4,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[null,"NAME",null,{"$f":"'TACC Competition'!C17","v":0}]
[]
[null,"PREDICTIONS",null,null,null,null,"PREDICTIONS"]
[null,{"$f":"'TACC Competition'!B20","v":"Turkey"},{"$f":"'TACC Competition'!C20","v":0},{"$f":"'TACC Competition'!E20","v":0},{"$f":"'TACC Competition'!D20","v":"Italy"},null,{"$f":"'TACC Competition'!U38","v":"Winner QF (1)"}]
[null,{"$f":"'TACC Competition'!B21","v":"Wales"},{"$f":"'TACC Competition'!C21","v":0},{"$f":"'TACC Competition'!E21","v":0},{"$f":"'TACC Competition'!D21","v":"Switzerland"},null,{"$f":"'TACC Competition'!W38","v":"Winner QF (2)"}]
[null,{"$f":"'TACC Competition'!B22","v":"Denmark"},{"$f":"'TACC Competition'!C22","v":0},{"$f":"'TACC Competition'!E22","v":0},{"$f":"'TACC Competition'!D22","v":"Finland"},null,{"$f":"'TACC Competition'!U39","v":"Winner QF (3)"}]
[null,{"$f":"'TACC Competition'!B23","v":"Belgium"},{"$f":"'TACC Competition'!C23","v":0},{"$f":"'TACC Competition'!E23","v":0},{"$f":"'TACC Competition'!D23","v":"Russia"},null,{"$f":"'TACC Competition'!W39","v":"Winner QF (4)"}]
[null,{"$f":"'TACC Competition'!B24","v":"Netherlands"},{"$f":"'TACC Competition'!C24","v":0},{"$f":"'TACC Competition'!E24","v":0},{"$f":"'TACC Competition'!D24","v":"Ukraine"},null,"WINNER"]
[null,{"$f":"'TACC Competition'!B25","v":"Austria"},{"$f":"'TACC Competition'!C25","v":0},{"$f":"'TACC Competition'!E25","v":0},{"$f":"'TACC Competition'!D25","v":"North Macedonia"},null,{"$f":"'TACC Competition'!U47","v":""}]
[null,{"$f":"'TACC Competition'!B26","v":"England"},{"$f":"'TACC Competition'!C26","v":0},{"$f":"'TACC Competition'!E26","v":0},{"$f":"'TACC Competition'!D26","v":"Croatia"},null,"TOP GOALSCORER"]
[null,{"$f":"'TACC Competition'!B27","v":"Scotland"},{"$f":"'TACC Competition'!C27","v":0},{"$f":"'TACC Competition'!E27","v":0},{"$f":"'TACC Competition'!D27","v":"Czech Republic"},null,{"$f":"'TACC Competition'!U51","v":0}]
[null,{"$f":"'TACC Competition'!B28","v":"Spain"},{"$f":"'TACC Competition'!C28","v":0},{"$f":"'TACC Competition'!E28","v":0},{"$f":"'TACC Competition'!D28","v":"Sweden"}]
[null,{"$f":"'TACC Competition'!B29","v":"Poland"},{"$f":"'TACC Competition'!C29","v":0},{"$f":"'TACC Competition'!E29","v":0},{"$f":"'TACC Competition'!D29","v":"Slovakia"}]
[null,{"$f":"'TACC Competition'!B30","v":"Hungary"},{"$f":"'TACC Competition'!C30","v":0},{"$f":"'TACC Competition'!E30","v":0},{"$f":"'TACC Competition'!D30","v":"Portugal"}]
[null,{"$f":"'TACC Competition'!B31","v":"France"},{"$f":"'TACC Competition'!C31","v":0},{"$f":"'TACC Competition'!E31","v":0},{"$f":"'TACC Competition'!D31","v":"Germany"}]
[null,{"$f":"'TACC Competition'!B34","v":"Turkey"},{"$f":"'TACC Competition'!C34","v":0},{"$f":"'TACC Competition'!E34","v":0},{"$f":"'TACC Competition'!D34","v":"Wales"}]
[null,{"$f":"'TACC Competition'!B35","v":"Italy"},{"$f":"'TACC Competition'!C35","v":0},{"$f":"'TACC Competition'!E35","v":0},{"$f":"'TACC Competition'!D35","v":"Switzerland"}]
[null,{"$f":"'TACC Competition'!B36","v":"Denmark"},{"$f":"'TACC Competition'!C36","v":0},{"$f":"'TACC Competition'!E36","v":0},{"$f":"'TACC Competition'!D36","v":"Belgium"}]
[null,{"$f":"'TACC Competition'!B37","v":"Finland"},{"$f":"'TACC Competition'!C37","v":0},{"$f":"'TACC Competition'!E37","v":0},{"$f":"'TACC Competition'!D37","v":"Russia"}]
[null,{"$f":"'TACC Competition'!B38","v":"Netherlands"},{"$f":"'TACC Competition'!C38","v":0},{"$f":"'TACC Competition'!E38","v":0},{"$f":"'TACC Competition'!D38","v":"Austria"}]
[null,{"$f":"'TACC Competition'!B39","v":"Ukraine"},{"$f":"'TACC Competition'!C39","v":0},{"$f":"'TACC Competition'!E39","v":0},{"$f":"'TACC Competition'!D39","v":"North Macedonia"}]
[null,{"$f":"'TACC Competition'!B40","v":"England"},{"$f":"'TACC Competition'!C40","v":0},{"$f":"'TACC Competition'!E40","v":0},{"$f":"'TACC Competition'!D40","v":"Scotland"}]
[null,{"$f":"'TACC Competition'!B41","v":"Croatia"},{"$f":"'TACC Competition'!C41","v":0},{"$f":"'TACC Competition'!E41","v":0},{"$f":"'TACC Competition'!D41","v":"Czech Republic"}]
[null,{"$f":"'TACC Competition'!B42","v":"Spain"},{"$f":"'TACC Competition'!C42","v":0},{"$f":"'TACC Competition'!E42","v":0},{"$f":"'TACC Competition'!D42","v":"Poland"}]
[null,{"$f":"'TACC Competition'!B43","v":"Sweden"},{"$f":"'TACC Competition'!C43","v":0},{"$f":"'TACC Competition'!E43","v":0},{"$f":"'TACC Competition'!D43","v":"Slovakia"}]
[null,{"$f":"'TACC Competition'!B44","v":"Hungary"},{"$f":"'TACC Competition'!C44","v":0},{"$f":"'TACC Competition'!E44","v":0},{"$f":"'TACC Competition'!D44","v":"France"}]
[null,{"$f":"'TACC Competition'!B45","v":"Portugal"},{"$f":"'TACC Competition'!C45","v":0},{"$f":"'TACC Competition'!E45","v":0},{"$f":"'TACC Competition'!D45","v":"Germany"}]
[null,{"$f":"'TACC Competition'!B48","v":"Switzerland"},{"$f":"'TACC Competition'!C48","v":0},{"$f":"'TACC Competition'!E48","v":0},{"$f":"'TACC Competition'!D48","v":"Turkey"}]
[null,{"$f":"'TACC Competition'!B49","v":"Italy"},{"$f":"'TACC Competition'!C49","v":0},{"$f":"'TACC Competition'!E49","v":0},{"$f":"'TACC Competition'!D49","v":"Wales"}]
[null,{"$f":"'TACC Competition'!B50","v":"Russia"},{"$f":"'TACC Competition'!C50","v":0},{"$f":"'TACC Competition'!E50","v":0},{"$f":"'TACC Competition'!D50","v":"Denmark"}]
[null,{"$f":"'TACC Competition'!B51","v":"Finland"},{"$f":"'TACC Competition'!C51","v":0},{"$f":"'TACC Competition'!E51","v":0},{"$f":"'TACC Competition'!D51","v":"Belgium"}]
[null,{"$f":"'TACC Competition'!B52","v":"North Macedonia"},{"$f":"'TACC Competition'!C52","v":0},{"$f":"'TACC Competition'!E52","v":0},{"$f":"'TACC Competition'!D52","v":"Netherlands"}]
[null,{"$f":"'TACC Competition'!B53","v":"Ukraine"},{"$f":"'TACC Competition'!C53","v":0},{"$f":"'TACC Competition'!E53","v":0},{"$f":"'TACC Competition'!D53","v":"Austria"}]
[null,{"$f":"'TACC Competition'!B54","v":"Czech Republic"},{"$f":"'TACC Competition'!C54","v":0},{"$f":"'TACC Competition'!E54","v":0},{"$f":"'TACC Competition'!D54","v":"England"}]
[null,{"$f":"'TACC Competition'!B55","v":"Croatia"},{"$f":"'TACC Competition'!C55","v":0},{"$f":"'TACC Competition'!E55","v":0},{"$f":"'TACC Competition'!D55","v":"Scotland"}]
[null,{"$f":"'TACC Competition'!B56","v":"Slovakia"},{"$f":"'TACC Competition'!C56","v":0},{"$f":"'TACC Competition'!E56","v":0},{"$f":"'TACC Competition'!D56","v":"Spain"}]
[null,{"$f":"'TACC Competition'!B57","v":"Sweden"},{"$f":"'TACC Competition'!C57","v":0},{"$f":"'TACC Competition'!E57","v":0},{"$f":"'TACC Competition'!D57","v":"Poland"}]
[null,{"$f":"'TACC Competition'!B58","v":"Germany"},{"$f":"'TACC Competition'!C58","v":0},{"$f":"'TACC Competition'!E58","v":0},{"$f":"'TACC Competition'!D58","v":"Hungary"}]
[null,{"$f":"'TACC Competition'!B59","v":"Portugal"},{"$f":"'TACC Competition'!C59","v":0},{"$f":"'TACC Competition'!E59","v":0},{"$f":"'TACC Competition'!D59","v":"France"}]