{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Fixtures","Grid","Ladders","Qualif","FinalsTop","FinalsBottom","Final","McRopod","LaddersH"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Fixtures","index":0,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["   ",null,null,null,null,null,null,null,null,null,{"$f":"McRopod!K1","v":"V1 281225"}]
[null,"Game","Group","Venue","Local Date and Time",null,"Home",null,"Away","Result"]
[null,2,null,"Stade de Nice","2024-07-24","17:00:00","Guinea","v","New Zealand",null,null,null,"GUI","ZED",null,null,11,12]
[null,1,null,"Stade de Marseille","2024-07-24","21:00:00","France","v","USA",null,null,null,"FRA","USA",null,null,13,14]
[null,10,null,"Stade de Marseille","2024-07-27","19:00:00","New Zealand","v","USA",null,null,null,"ZED","USA",null,null,12,14]
[null,9,null,"Stade de Nice","2024-07-27"," - 21:00","France","v","Guinea",null,null,null,"FRA","GUI",null,null,13,11]
[null,17,null,"Stade de Marseille","2024-07-30","19:00:00","New Zealand","v","France",null,null,null,"ZED","FRA",null,null,12,13]
[null,18,null,"Stade Geoffroy-Guichard Saint-Etienne","2024-07-30","19:00:00","USA","v","Guinea",null,null,null,"USA","GUI",null,null,14,11]
[null,null,"  (Men's)"]
[null,3,null,"Stade Geoffroy-Guichard Saint-Etienne","2024-07-24","15:00:00","Argentina","v","Morocco",null,null,null,"ARG","MCC",null,null,21,22]
[null,4,null,"Stade de Lyon","2024-07-24","19:00:00","Iraq","v","Ukraine",null,null,null,"IRQ","UKR",null,null,23,24]
[null,11,null,"Stade de Lyon","2024-07-27","15:00:00","Argentina","v","Iraq",null,null,null,"ARG","IRQ",null,null,21,23]
[null,12,null," Stade Geoffroy-Guichard Saint-Etienne","2024-07-27","17:00:00","Ukraine","v","Morocco",null,null,null,"UKR","MCC",null,null,24,22]
[null,19,null,"Stade de Lyon","2024-07-30","17:00:00","Ukraine","v","Argentina",null,null,null,"UKR","ARG",null,null,24,21]
[null,20,null,"Stade de Nice","2024-07-30","17:00:00","Morocco","v"," Iraq",null,null,null,"MCC","IRQ",null,null,22,23]
[null,null,"  (Men's)"]
[null,5,null,"Parc des Princes Paris","2024-07-24","15:00:00","Uzbekistan","v","Spain",null,null,null,"UZB","ESP",null,null,31,32]
[null,6,null,"Stade de la Beaujoire Nantes","2024-07-24","17:00:00","Egypt","v","Dominican Republic",null,null,null,"GYP","DRP",null,null,33,34]
[null,13,null,"Stade de Bordeaux","2024-07-27","15:00:00"," Dominican Republic","v","Spain",null,null,null,"DRP","ESP",null,null,34,32]
[null,14,null," Stade de la Beaujoire Nantes","2024-07-27","17:00:00","Uzbekistan","v","Egypt",null,null,null,"UZB","GYP",null,null,31,33]
[null,21,null,"Parc des Princes Paris","2024-07-30","15:00:00"," Dominican Republic","v","Uzbekistan",null,null,null,"DRP","UZB",null,null,34,31]
[null,22,null,"Stade de Bordeaux","2024-07-30","15:00:00","Spain","v","Egypt",null,null,null,"ESP","GYP",null,null,32,33]
[null,null,"  (Men's)"]
[null,7,null,"Stade de Bordeaux","2024-07-24","19:00:00","Japan","v","Paraguay",null,null,null,"JPN","PAR",null,null,41,42]
[null,8,null,"Parc des Princes Paris","2024-07-24"," - 21:00","Mali","v","Israel",null,null,null,"MAL","ISR",null,null,43,44]
[null,15,null,"Parc des Princes Paris","2024-07-27","19:00:00","Israel","v","Paraguay",null,null,null,"ISR","PAR",null,null,44,42]
[null,16,null,"Stade de Bordeaux","2024-07-27"," - 21:00","Japan","v","Mali",null,null,null,"JPN","MAL",null,null,41,43]
[null,23,null,"Stade de la Beaujoire Nantes","2024-07-30"," - 21:00","Israel","v","Japan",null,null,null,"ISR","JPN",null,null,44,41]
[null,24,null,"Parc des Princes Paris","2024-07-30"," - 21:00"," Paraguay","v","Mali",null,null,null,"PAR","MAL",null,null,42,43]
[null,null,"  (Men's)"]
[null,1,"A","Perth","2026-03-01","17:00:00","Australia","v"," Philippines",1,0,null,"CAN","NZL",null,null,51,52]
[null,2,"A","Gold Coast","2026-03-02","19:00:00","Korea Republic","v"," Iran",3,0,null,"FRA","COL",null,null,53,54]
[null,7,"A","Gold Coast","2026-03-05","13:00:00","Philippines","v","Korea Republic",0,3,null,"NZL","COL",null,null,52,54]
[null,8,"A","Gold Coast","2026-03-05","19:00:00","Iran","v"," Australia",0,4,null,"FRA","CAN",null,null,53,51]
[null,13,"A","Gold Coast","2026-03-08","19:00:00","Iran","v"," Philippines",0,2,null,"NZL","FRA",null,null,52,53]
[null,14,"A","Stadium Australia","2026-03-08","20:00:00","Australia","v","Korea Republic",3,3,null,"COL","CAN",null,null,54,51]
[]
[null,3,"B","Western Sydney","2026-03-03","13:00:00","DPR Korea","v"," Uzbekistan",3,0,null,"GER","AUS",null,null,61,64]
[null,4,"B","Western Sydney","2026-03-03","19:00:00","China","v"," Bangladesh",2,0,null,"USA","ZAM",null,null,62,63]
[null,9,"B","Western Sydney","2026-03-06","13:00:00","Bangladesh","v","DPR Korea",5,0,null,"AUS","ZAM",null,null,64,63]
[null,10,"B","Western Sydney","2026-03-06","19:00:00","Uzbekistan","v"," China",0,3,null,"USA","GER",null,null,62,61]
[null,15,"B","Perth Rectangular","2026-03-09","20:00:00","Bangladesh","v"," Uzbekistan",null,null,null,"AUS","USA",null,null,64,62]
[null,16,"B","Western Sydney","2026-03-09","20:00:00","DPR Korea","v"," China",null,null,null,"ZAM","GER",null,null,63,61]
[]
[null,5,"C","Perth Rectangular","2026-03-04","13:00:00","Japan","v"," Chinese Taipei",2,0,null,"ESP","JPN",null,null,71,72]
[null,6,"C","Perth Rectangular","2026-03-04","19:00:00","Vietnam","v"," India",2,1,null,"NIG","BRA",null,null,73,74]
[null,11,"C","Perth Rectangular","2026-03-07","13:00:00","Chinese Taipei","v"," Vietnam",1,0,null,"BRA","JPN",null,null,74,72]
[null,12,"C","Perth Rectangular","2026-03-07","19:00:00","India","v"," Japan",0,11,null,"ESP","NIG",null,null,71,73]
[null,17,"C","Perth Rectangular","2026-03-10","17:00:00","Japan","v"," Vietnam",null,null,null,"BRA","ESP",null,null,74,71]
[null,18,"C","Western Sydney","2026-03-10","20:00:00","India","v"," Chinese Taipei",null,null,null,"JPN","NIG",null,null,72,73]
[null,null,"Results System (c) McRopod Concepts 2025 - mcropod@mcropod.com.au"]

{"sheet":"Grid","index":1,"n_rows":50,"n_cols":25,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,{"$f":"B3","v":"Guinea"},null,null,{"$f":"B4","v":"New Zealand"},null,null,{"$f":"B5","v":"France"},null,null,{"$f":"B6","v":"USA"},null,null,null,{"$f":"IF(SUM(R3:R6)=12,\"Final Ladder\",\"Incomplete\")","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts"]
[null,{"$f":"Fixtures!G3","v":"Guinea"},null,null,{"$f":"IF(C3=\"\",\"\",IF(D3=\"\",\"\",IF(C3>D3,\"W\",IF(C3<D3,\"L\",IF(C3=D3,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$3=\"\",\"\",Fixtures!$J$3)","v":""},{"$f":"IF(Fixtures!K3=\"\",\"\",Fixtures!K3)","v":""},{"$f":"IF(F3=\"\",\"\",IF(G3=\"\",\"\",IF(F3>G3,\"W\",IF(F3<G3,\"L\",IF(F3=G3,\"D\")))))","v":""},null,null,{"$f":"IF(I3=\"\",\"\",IF(J3=\"\",\"\",IF(I3>J3,\"W\",IF(I3<J3,\"L\",IF(I3=J3,\"D\")))))","v":""},null,null,{"$f":"IF(L3=\"\",\"\",IF(M3=\"\",\"\",IF(L3>M3,\"W\",IF(L3<M3,\"L\",IF(L3=M3,\"D\")))))","v":""},null,null,{"$f":"B3","v":"Guinea"},{"$f":"SUM(S3+T3+U3)","v":0},{"$f":"IF(E3=\"W\",1,0)+IF(H3=\"W\",1,0)+IF(K3=\"W\",1,0)+IF(N3=\"W\",1,0)+C7","v":0},{"$f":"IF(E3=\"D\",1,0)+IF(H3=\"D\",1,0)+IF(K3=\"D\",1,0)+IF(N3=\"D\",1,0)+D7","v":0},{"$f":"IF(E3=\"L\",1,0)+IF(H3=\"L\",1,0)+IF(K3=\"L\",1,0)+IF(N3=\"L\",1,0)+E7","v":0},{"$f":"SUM(C3)+SUM(F3)+SUM(I3)+SUM(L3)+C8","v":0},{"$f":"SUM(D3)+SUM(G3)+SUM(J3)+SUM(M3)+D8","v":0},{"$f":"V3-W3","v":0},{"$f":"S3*3+T3","v":0}]
[null,{"$f":"Fixtures!I3","v":"New Zealand"},null,null,{"$f":"IF(C4=\"\",\"\",IF(D4=\"\",\"\",IF(C4>D4,\"W\",IF(C4<D4,\"L\",IF(C4=D4,\"D\")))))","v":""},null,null,{"$f":"IF(F4=\"\",\"\",IF(G4=\"\",\"\",IF(F4>G4,\"W\",IF(F4<G4,\"L\",IF(F4=G4,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$7=\"\",\"\",Fixtures!$J$7)","v":""},{"$f":"IF(Fixtures!K7=\"\",\"\",Fixtures!K7)","v":""},{"$f":"IF(I4=\"\",\"\",IF(J4=\"\",\"\",IF(I4>J4,\"W\",IF(I4<J4,\"L\",IF(I4=J4,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$5=\"\",\"\",Fixtures!$J$5)","v":""},{"$f":"IF(Fixtures!K5=\"\",\"\",Fixtures!K5)","v":""},{"$f":"IF(L4=\"\",\"\",IF(M4=\"\",\"\",IF(L4>M4,\"W\",IF(L4<M4,\"L\",IF(L4=M4,\"D\")))))","v":""},null,null,{"$f":"B4","v":"New Zealand"},{"$f":"SUM(S4+T4+U4)","v":0},{"$f":"IF(E4=\"W\",1,0)+IF(H4=\"W\",1,0)+IF(K4=\"W\",1,0)+IF(N4=\"W\",1,0)+F7","v":0},{"$f":"IF(E4=\"D\",1,0)+IF(H4=\"D\",1,0)+IF(K4=\"D\",1,0)+IF(N4=\"D\",1,0)+G7","v":0},{"$f":"IF(E4=\"L\",1,0)+IF(H4=\"L\",1,0)+IF(K4=\"L\",1,0)+IF(N4=\"L\",1,0)+H7","v":0},{"$f":"SUM(C4)+SUM(F4)+SUM(I4)+SUM(L4)+F8","v":0},{"$f":"SUM(D4)+SUM(G4)+SUM(J4)+SUM(M4)+G8","v":0},{"$f":"V4-W4","v":0},{"$f":"S4*3+T4","v":0}]
[null,{"$f":"Fixtures!G4","v":"France"},{"$f":"IF(Fixtures!$J$6=\"\",\"\",Fixtures!$J$6)","v":""},{"$f":"IF(Fixtures!K6=\"\",\"\",Fixtures!K6)","v":""},{"$f":"IF(C5=\"\",\"\",IF(D5=\"\",\"\",IF(C5>D5,\"W\",IF(C5<D5,\"L\",IF(C5=D5,\"D\")))))","v":""},null,null,{"$f":"IF(F5=\"\",\"\",IF(G5=\"\",\"\",IF(F5>G5,\"W\",IF(F5<G5,\"L\",IF(F5=G5,\"D\")))))","v":""},null,null,{"$f":"IF(I5=\"\",\"\",IF(J5=\"\",\"\",IF(I5>J5,\"W\",IF(I5<J5,\"L\",IF(I5=J5,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$4=\"\",\"\",Fixtures!$J$4)","v":""},{"$f":"IF(Fixtures!K4=\"\",\"\",Fixtures!K4)","v":""},{"$f":"IF(L5=\"\",\"\",IF(M5=\"\",\"\",IF(L5>M5,\"W\",IF(L5<M5,\"L\",IF(L5=M5,\"D\")))))","v":""},null,null,{"$f":"B5","v":"France"},{"$f":"SUM(S5+T5+U5)","v":0},{"$f":"IF(E5=\"W\",1,0)+IF(H5=\"W\",1,0)+IF(K5=\"W\",1,0)+IF(N5=\"W\",1,0)+I7","v":0},{"$f":"IF(E5=\"D\",1,0)+IF(H5=\"D\",1,0)+IF(K5=\"D\",1,0)+IF(N5=\"D\",1,0)+J7","v":0},{"$f":"IF(E5=\"L\",1,0)+IF(H5=\"L\",1,0)+IF(K5=\"L\",1,0)+IF(N5=\"L\",1,0)+K7","v":0},{"$f":"SUM(C5)+SUM(F5)+SUM(I5)+SUM(L5)+I8","v":0},{"$f":"SUM(D5)+SUM(G5)+SUM(J5)+SUM(M5)+J8","v":0},{"$f":"V5-W5","v":0},{"$f":"S5*3+T5","v":0}]
[null,{"$f":"Fixtures!I4","v":"USA"},{"$f":"IF(Fixtures!$J$8=\"\",\"\",Fixtures!$J$8)","v":""},{"$f":"IF(Fixtures!K8=\"\",\"\",Fixtures!K8)","v":""},{"$f":"IF(C6=\"\",\"\",IF(D6=\"\",\"\",IF(C6>D6,\"W\",IF(C6<D6,\"L\",IF(C6=D6,\"D\")))))","v":""},null,null,{"$f":"IF(F6=\"\",\"\",IF(G6=\"\",\"\",IF(F6>G6,\"W\",IF(F6<G6,\"L\",IF(F6=G6,\"D\")))))","v":""},null,null,{"$f":"IF(I6=\"\",\"\",IF(J6=\"\",\"\",IF(I6>J6,\"W\",IF(I6<J6,\"L\",IF(I6=J6,\"D\")))))","v":""},null,null,{"$f":"IF(L6=\"\",\"\",IF(M6=\"\",\"\",IF(L6>M6,\"W\",IF(L6<M6,\"L\",IF(L6=M6,\"D\")))))","v":""},null,null,{"$f":"B6","v":"USA"},{"$f":"SUM(S6+T6+U6)","v":0},{"$f":"IF(E6=\"W\",1,0)+IF(H6=\"W\",1,0)+IF(K6=\"W\",1,0)+IF(N6=\"W\",1,0)+L7","v":0},{"$f":"IF(E6=\"D\",1,0)+IF(H6=\"D\",1,0)+IF(K6=\"D\",1,0)+IF(N6=\"D\",1,0)+M7","v":0},{"$f":"IF(E6=\"L\",1,0)+IF(H6=\"L\",1,0)+IF(K6=\"L\",1,0)+IF(O6=\"L\",1,0)+N7","v":0},{"$f":"SUM(C6)+SUM(F6)+SUM(I6)+SUM(L6)+L8","v":0},{"$f":"SUM(D6)+SUM(G6)+SUM(J6)+SUM(M6)+M8","v":0},{"$f":"V6-W6","v":0},{"$f":"S6*3+T6","v":0}]
[null,"W/D/L",{"$f":"IF(E3=\"L\",1,0)+IF(E4=\"L\",1,0)+IF(E5=\"L\",1,0)+IF(E6=\"L\",1,0)","v":0},{"$f":"IF(E3=\"D\",1,0)+IF(E4=\"D\",1,0)+IF(E5=\"D\",1,0)+IF(E6=\"D\",1,0)","v":0},{"$f":"IF(E3=\"W\",1,0)+IF(E4=\"W\",1,0)+IF(E5=\"W\",1,0)+IF(E6=\"W\",1,0)","v":0},{"$f":"IF(H3=\"L\",1,0)+IF(H4=\"L\",1,0)+IF(H5=\"L\",1,0)+IF(H6=\"L\",1,0)","v":0},{"$f":"IF(H3=\"D\",1,0)+IF(H4=\"D\",1,0)+IF(H5=\"D\",1,0)+IF(H6=\"D\",1,0)","v":0},{"$f":"IF(H3=\"W\",1,0)+IF(H4=\"W\",1,0)+IF(H5=\"W\",1,0)+IF(H6=\"W\",1,0)","v":0},{"$f":"IF(K3=\"L\",1,0)+IF(K4=\"L\",1,0)+IF(K5=\"L\",1,0)+IF(K6=\"L\",1,0)","v":0},{"$f":"IF(K3=\"D\",1,0)+IF(K4=\"D\",1,0)+IF(K5=\"D\",1,0)+IF(K6=\"D\",1,0)","v":0},{"$f":"IF(K3=\"W\",1,0)+IF(K4=\"W\",1,0)+IF(K5=\"W\",1,0)+IF(K6=\"W\",1,0)","v":0},{"$f":"IF(N3=\"L\",1,0)+IF(N4=\"L\",1,0)+IF(N5=\"L\",1,0)+IF(N6=\"L\",1,0)","v":0},{"$f":"IF(N3=\"D\",1,0)+IF(N4=\"D\",1,0)+IF(N5=\"D\",1,0)+IF(N6=\"D\",1,0)","v":0},{"$f":"IF(N3=\"W\",1,0)+IF(N4=\"W\",1,0)+IF(N5=\"W\",1,0)+IF(N6=\"W\",1,0)","v":0}]
[null,"F/A",{"$f":"SUM(D3)+SUM(D4)+SUM(D5)+SUM(D6)","v":0},{"$f":"SUM(C3)+SUM(C4)+SUM(C5)+SUM(C6)","v":0},null,{"$f":"SUM(G3)+SUM(G4)+SUM(G5)+SUM(G6)","v":0},{"$f":"SUM(F3)+SUM(F4)+SUM(F5)+SUM(F6)","v":0},null,{"$f":"SUM(J3)+SUM(J4)+SUM(J5)+SUM(J6)","v":0},{"$f":"SUM(I3)+SUM(I4)+SUM(I5)+SUM(I6)","v":0},null,{"$f":"SUM(M3)+SUM(M4)+SUM(M5)+SUM(M6)","v":0},{"$f":"SUM(L3)+SUM(L4)+SUM(L5)+SUM(L6)","v":0}]
[null,null,null,{"$f":"B10","v":"Argentina"},null,null,{"$f":"B11","v":"Iraq"},null,null,{"$f":"B12","v":"Ukraine"},null,null,{"$f":"B13","v":"Morocco"},null,null,null,{"$f":"IF(SUM(R10:R13)=12,\"Final Ladder\",\"Incomplete\")","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts"]
[null,{"$f":"Fixtures!G12","v":"Argentina"},null,null,{"$f":"IF(C10=\"\",\"\",IF(D10=\"\",\"\",IF(C10>D10,\"W\",IF(C10<D10,\"L\",IF(C10=D10,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$12=\"\",\"\",Fixtures!$J$12)","v":""},{"$f":"IF(Fixtures!K12=\"\",\"\",Fixtures!K12)","v":""},{"$f":"IF(F10=\"\",\"\",IF(G10=\"\",\"\",IF(F10>G10,\"W\",IF(F10<G10,\"L\",IF(F10=G10,\"D\")))))","v":""},null,null,{"$f":"IF(I10=\"\",\"\",IF(J10=\"\",\"\",IF(I10>J10,\"W\",IF(I10<J10,\"L\",IF(I10=J10,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$10=\"\",\"\",Fixtures!$J$10)","v":""},{"$f":"IF(Fixtures!$K$10=\"\",\"\",Fixtures!$K$10)","v":""},{"$f":"IF(L10=\"\",\"\",IF(M10=\"\",\"\",IF(L10>M10,\"W\",IF(L10<M10,\"L\",IF(L10=M10,\"D\")))))","v":""},null,null,{"$f":"B10","v":"Argentina"},{"$f":"SUM(S10+T10+U10)","v":0},{"$f":"IF(E10=\"W\",1,0)+IF(H10=\"W\",1,0)+IF(K10=\"W\",1,0)+IF(N10=\"W\",1,0)+C14","v":0},{"$f":"IF(E10=\"D\",1,0)+IF(H10=\"D\",1,0)+IF(K10=\"D\",1,0)+IF(N10=\"D\",1,0)+D14","v":0},{"$f":"IF(E10=\"L\",1,0)+IF(H10=\"L\",1,0)+IF(K10=\"L\",1,0)+IF(N10=\"L\",1,0)+E14","v":0},{"$f":"SUM(C10)+SUM(F10)+SUM(I10)+SUM(L10)+C15","v":0},{"$f":"SUM(D10)+SUM(G10)+SUM(J10)+SUM(M10)+D15","v":0},{"$f":"V10-W10","v":0},{"$f":"S10*3+T10","v":0}]
[null,{"$f":"Fixtures!I12","v":"Iraq"},null,null,{"$f":"IF(C11=\"\",\"\",IF(D11=\"\",\"\",IF(C11>D11,\"W\",IF(C11<D11,\"L\",IF(C11=D11,\"D\")))))","v":""},null,null,{"$f":"IF(F11=\"\",\"\",IF(G11=\"\",\"\",IF(F11>G11,\"W\",IF(F11<G11,\"L\",IF(F11=G11,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$11=\"\",\"\",Fixtures!$J$11)","v":""},{"$f":"IF(Fixtures!$K$11=\"\",\"\",Fixtures!$K$11)","v":""},{"$f":"IF(I11=\"\",\"\",IF(J11=\"\",\"\",IF(I11>J11,\"W\",IF(I11<J11,\"L\",IF(I11=J11,\"D\")))))","v":""},null,null,{"$f":"IF(L11=\"\",\"\",IF(M11=\"\",\"\",IF(L11>M11,\"W\",IF(L11<M11,\"L\",IF(L11=M11,\"D\")))))","v":""},null,null,{"$f":"B11","v":"Iraq"},{"$f":"SUM(S11+T11+U11)","v":0},{"$f":"IF(E11=\"W\",1,0)+IF(H11=\"W\",1,0)+IF(K11=\"W\",1,0)+IF(N11=\"W\",1,0)+F14","v":0},{"$f":"IF(E11=\"D\",1,0)+IF(H11=\"D\",1,0)+IF(K11=\"D\",1,0)+IF(N11=\"D\",1,0)+G14","v":0},{"$f":"IF(E11=\"L\",1,0)+IF(H11=\"L\",1,0)+IF(K11=\"L\",1,0)+IF(N11=\"L\",1,0)+H14","v":0},{"$f":"SUM(C11)+SUM(F11)+SUM(I11)+SUM(L11)+F15","v":0},{"$f":"SUM(D11)+SUM(G11)+SUM(J11)+SUM(M11)+G15","v":0},{"$f":"V11-W11","v":0},{"$f":"S11*3+T11","v":0}]
[null,{"$f":"Fixtures!G13","v":"Ukraine"},{"$f":"IF(Fixtures!$J$14=\"\",\"\",Fixtures!$J$14)","v":""},{"$f":"IF(Fixtures!$K$14=\"\",\"\",Fixtures!$K$14)","v":""},{"$f":"IF(C12=\"\",\"\",IF(D12=\"\",\"\",IF(C12>D12,\"W\",IF(C12<D12,\"L\",IF(C12=D12,\"D\")))))","v":""},null,null,{"$f":"IF(F12=\"\",\"\",IF(G12=\"\",\"\",IF(F12>G12,\"W\",IF(F12<G12,\"L\",IF(F12=G12,\"D\")))))","v":""},null,null,{"$f":"IF(I12=\"\",\"\",IF(J12=\"\",\"\",IF(I12>J12,\"W\",IF(I12<J12,\"L\",IF(I12=J12,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$13=\"\",\"\",Fixtures!$J$13)","v":""},{"$f":"IF(Fixtures!$K$13=\"\",\"\",Fixtures!$K$13)","v":""},{"$f":"IF(L12=\"\",\"\",IF(M12=\"\",\"\",IF(L12>M12,\"W\",IF(L12<M12,\"L\",IF(L12=M12,\"D\")))))","v":""},null,null,{"$f":"B12","v":"Ukraine"},{"$f":"SUM(S12+T12+U12)","v":0},{"$f":"IF(E12=\"W\",1,0)+IF(H12=\"W\",1,0)+IF(K12=\"W\",1,0)+IF(N12=\"W\",1,0)+I14","v":0},{"$f":"IF(E12=\"D\",1,0)+IF(H12=\"D\",1,0)+IF(K12=\"D\",1,0)+IF(N12=\"D\",1,0)+J14","v":0},{"$f":"IF(E12=\"L\",1,0)+IF(H12=\"L\",1,0)+IF(K12=\"L\",1,0)+IF(N12=\"L\",1,0)+K14","v":0},{"$f":"SUM(C12)+SUM(F12)+SUM(I12)+SUM(L12)+I15","v":0},{"$f":"SUM(D12)+SUM(G12)+SUM(J12)+SUM(M12)+J15","v":0},{"$f":"V12-W12","v":0},{"$f":"S12*3+T12","v":0}]
[null,{"$f":"Fixtures!I13","v":"Morocco"},null,null,{"$f":"IF(C13=\"\",\"\",IF(D13=\"\",\"\",IF(C13>D13,\"W\",IF(C13<D13,\"L\",IF(C13=D13,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$15=\"\",\"\",Fixtures!$J$15)","v":""},{"$f":"IF(Fixtures!K15=\"\",\"\",Fixtures!K15)","v":""},{"$f":"IF(F13=\"\",\"\",IF(G13=\"\",\"\",IF(F13>G13,\"W\",IF(F13<G13,\"L\",IF(F13=G13,\"D\")))))","v":""},null,null,{"$f":"IF(I13=\"\",\"\",IF(J13=\"\",\"\",IF(I13>J13,\"W\",IF(I13<J13,\"L\",IF(I13=J13,\"D\")))))","v":""},null,null,{"$f":"IF(L13=\"\",\"\",IF(M13=\"\",\"\",IF(L13>M13,\"W\",IF(L13<M13,\"L\",IF(L13=M13,\"D\")))))","v":""},null,null,{"$f":"B13","v":"Morocco"},{"$f":"SUM(S13+T13+U13)","v":0},{"$f":"IF(E13=\"W\",1,0)+IF(H13=\"W\",1,0)+IF(K13=\"W\",1,0)+IF(N13=\"W\",1,0)+L14","v":0},{"$f":"IF(E13=\"D\",1,0)+IF(H13=\"D\",1,0)+IF(K13=\"D\",1,0)+IF(N13=\"D\",1,0)+M14","v":0},{"$f":"IF(E13=\"L\",1,0)+IF(H13=\"L\",1,0)+IF(K13=\"L\",1,0)+IF(O13=\"L\",1,0)+N14","v":0},{"$f":"SUM(C13)+SUM(F13)+SUM(I13)+SUM(L13)+L15","v":0},{"$f":"SUM(D13)+SUM(G13)+SUM(J13)+SUM(M13)+M15","v":0},{"$f":"V13-W13","v":0},{"$f":"S13*3+T13","v":0}]
[null,"W/D/L",{"$f":"IF(E10=\"L\",1,0)+IF(E11=\"L\",1,0)+IF(E12=\"L\",1,0)+IF(E13=\"L\",1,0)","v":0},{"$f":"IF(E10=\"D\",1,0)+IF(E11=\"D\",1,0)+IF(E12=\"D\",1,0)+IF(E13=\"D\",1,0)","v":0},{"$f":"IF(E10=\"W\",1,0)+IF(E11=\"W\",1,0)+IF(E12=\"W\",1,0)+IF(E13=\"W\",1,0)","v":0},{"$f":"IF(H10=\"L\",1,0)+IF(H11=\"L\",1,0)+IF(H12=\"L\",1,0)+IF(H13=\"L\",1,0)","v":0},{"$f":"IF(H10=\"D\",1,0)+IF(H11=\"D\",1,0)+IF(H12=\"D\",1,0)+IF(H13=\"D\",1,0)","v":0},{"$f":"IF(H10=\"W\",1,0)+IF(H11=\"W\",1,0)+IF(H12=\"W\",1,0)+IF(H13=\"W\",1,0)","v":0},{"$f":"IF(K10=\"L\",1,0)+IF(K11=\"L\",1,0)+IF(K12=\"L\",1,0)+IF(K13=\"L\",1,0)","v":0},{"$f":"IF(K10=\"D\",1,0)+IF(K11=\"D\",1,0)+IF(K12=\"D\",1,0)+IF(K13=\"D\",1,0)","v":0},{"$f":"IF(K10=\"W\",1,0)+IF(K11=\"W\",1,0)+IF(K12=\"W\",1,0)+IF(K13=\"W\",1,0)","v":0},{"$f":"IF(N10=\"L\",1,0)+IF(N11=\"L\",1,0)+IF(N12=\"L\",1,0)+IF(N13=\"L\",1,0)","v":0},{"$f":"IF(N10=\"D\",1,0)+IF(N11=\"D\",1,0)+IF(N12=\"D\",1,0)+IF(N13=\"D\",1,0)","v":0},{"$f":"IF(N10=\"W\",1,0)+IF(N11=\"W\",1,0)+IF(N12=\"W\",1,0)+IF(N13=\"W\",1,0)","v":0}]
[null,"F/A",{"$f":"SUM(D10)+SUM(D11)+SUM(D12)+SUM(D13)","v":0},{"$f":"SUM(C10)+SUM(C11)+SUM(C12)+SUM(C13)","v":0},null,{"$f":"SUM(G10)+SUM(G11)+SUM(G12)+SUM(G13)","v":0},{"$f":"SUM(F10)+SUM(F11)+SUM(F12)+SUM(F13)","v":0},null,{"$f":"SUM(J10)+SUM(J11)+SUM(J12)+SUM(J13)","v":0},{"$f":"SUM(I10)+SUM(I11)+SUM(I12)+SUM(I13)","v":0},null,{"$f":"SUM(M10)+SUM(M11)+SUM(M12)+SUM(M13)","v":0},{"$f":"SUM(L10)+SUM(L11)+SUM(L12)+SUM(L13)","v":0}]
[null,null,null,{"$f":"B17","v":"Uzbekistan"},null,null,{"$f":"B18","v":"Spain"},null,null,{"$f":"B19","v":"Egypt"},null,null,{"$f":"B20","v":"Dominican Republic"},null,null,null,{"$f":"IF(SUM(R17:R20)=12,\"Final Ladder\",\"Incomplete\")","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts"]
[null,{"$f":"Fixtures!G17","v":"Uzbekistan"},null,null,{"$f":"IF(C17=\"\",\"\",IF(D17=\"\",\"\",IF(C17>D17,\"W\",IF(C17<D17,\"L\",IF(C17=D17,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$17=\"\",\"\",Fixtures!$J$17)","v":""},{"$f":"IF(Fixtures!$K$17=\"\",\"\",Fixtures!$K$17)","v":""},{"$f":"IF(F17=\"\",\"\",IF(G17=\"\",\"\",IF(F17>G17,\"W\",IF(F17<G17,\"L\",IF(F17=G17,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$20=\"\",\"\",Fixtures!$J$20)","v":""},{"$f":"IF(Fixtures!$K$20=\"\",\"\",Fixtures!$K$20)","v":""},{"$f":"IF(I17=\"\",\"\",IF(J17=\"\",\"\",IF(I17>J17,\"W\",IF(I17<J17,\"L\",IF(I17=J17,\"D\")))))","v":""},null,null,{"$f":"IF(L17=\"\",\"\",IF(M17=\"\",\"\",IF(L17>M17,\"W\",IF(L17<M17,\"L\",IF(L17=M17,\"D\")))))","v":""},null,null,{"$f":"B17","v":"Uzbekistan"},{"$f":"SUM(S17+T17+U17)","v":0},{"$f":"IF(E17=\"W\",1,0)+IF(H17=\"W\",1,0)+IF(K17=\"W\",1,0)+IF(N17=\"W\",1,0)+C21","v":0},{"$f":"IF(E17=\"D\",1,0)+IF(H17=\"D\",1,0)+IF(K17=\"D\",1,0)+IF(N17=\"D\",1,0)+D21","v":0},{"$f":"IF(E17=\"L\",1,0)+IF(H17=\"L\",1,0)+IF(K17=\"L\",1,0)+IF(N17=\"L\",1,0)+E21","v":0},{"$f":"SUM(C17)+SUM(F17)+SUM(I17)+SUM(L17)+C22","v":0},{"$f":"SUM(D17)+SUM(G17)+SUM(J17)+SUM(M17)+D22","v":0},{"$f":"V17-W17","v":0},{"$f":"S17*3+T17","v":0}]
[null,{"$f":"Fixtures!I17","v":"Spain"},null,null,{"$f":"IF(C18=\"\",\"\",IF(D18=\"\",\"\",IF(C18>D18,\"W\",IF(C18<D18,\"L\",IF(C18=D18,\"D\")))))","v":""},null,null,{"$f":"IF(F18=\"\",\"\",IF(G18=\"\",\"\",IF(F18>G18,\"W\",IF(F18<G18,\"L\",IF(F18=G18,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$22=\"\",\"\",Fixtures!$J$22)","v":""},{"$f":"IF(Fixtures!$K$22=\"\",\"\",Fixtures!$K$22)","v":""},{"$f":"IF(I18=\"\",\"\",IF(J18=\"\",\"\",IF(I18>J18,\"W\",IF(I18<J18,\"L\",IF(I18=J18,\"D\")))))","v":""},null,null,{"$f":"IF(L18=\"\",\"\",IF(M18=\"\",\"\",IF(L18>M18,\"W\",IF(L18<M18,\"L\",IF(L18=M18,\"D\")))))","v":""},null,null,{"$f":"B18","v":"Spain"},{"$f":"SUM(S18+T18+U18)","v":0},{"$f":"IF(E18=\"W\",1,0)+IF(H18=\"W\",1,0)+IF(K18=\"W\",1,0)+IF(N18=\"W\",1,0)+F21","v":0},{"$f":"IF(E18=\"D\",1,0)+IF(H18=\"D\",1,0)+IF(K18=\"D\",1,0)+IF(N18=\"D\",1,0)+G21","v":0},{"$f":"IF(E18=\"L\",1,0)+IF(H18=\"L\",1,0)+IF(K18=\"L\",1,0)+IF(N18=\"L\",1,0)+H21","v":0},{"$f":"SUM(C18)+SUM(F18)+SUM(I18)+SUM(L18)+F22","v":0},{"$f":"SUM(D18)+SUM(G18)+SUM(J18)+SUM(M18)+G22","v":0},{"$f":"V18-W18","v":0},{"$f":"S18*3+T18","v":0}]
[null,{"$f":"Fixtures!G18","v":"Egypt"},null,null,{"$f":"IF(C19=\"\",\"\",IF(D19=\"\",\"\",IF(C19>D19,\"W\",IF(C19<D19,\"L\",IF(C19=D19,\"D\")))))","v":""},null,null,{"$f":"IF(F19=\"\",\"\",IF(G19=\"\",\"\",IF(F19>G19,\"W\",IF(F19<G19,\"L\",IF(F19=G19,\"D\")))))","v":""},null,null,{"$f":"IF(I19=\"\",\"\",IF(J19=\"\",\"\",IF(I19>J19,\"W\",IF(I19<J19,\"L\",IF(I19=J19,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$18=\"\",\"\",Fixtures!$J$18)","v":""},{"$f":"IF(Fixtures!$K$18=\"\",\"\",Fixtures!$K$18)","v":""},{"$f":"IF(L19=\"\",\"\",IF(M19=\"\",\"\",IF(L19>M19,\"W\",IF(L19<M19,\"L\",IF(L19=M19,\"D\")))))","v":""},null,null,{"$f":"B19","v":"Egypt"},{"$f":"SUM(S19+T19+U19)","v":0},{"$f":"IF(E19=\"W\",1,0)+IF(H19=\"W\",1,0)+IF(K19=\"W\",1,0)+IF(N19=\"W\",1,0)+I21","v":0},{"$f":"IF(E19=\"D\",1,0)+IF(H19=\"D\",1,0)+IF(K19=\"D\",1,0)+IF(N19=\"D\",1,0)+J21","v":0},{"$f":"IF(E19=\"L\",1,0)+IF(H19=\"L\",1,0)+IF(K19=\"L\",1,0)+IF(N19=\"L\",1,0)+K21","v":0},{"$f":"SUM(C19)+SUM(F19)+SUM(I19)+SUM(L19)+I22","v":0},{"$f":"SUM(D19)+SUM(G19)+SUM(J19)+SUM(M19)+J22","v":0},{"$f":"V19-W19","v":0},{"$f":"S19*3+T19","v":0}]
[null,{"$f":"Fixtures!I18","v":"Dominican Republic"},{"$f":"IF(Fixtures!$J$21=\"\",\"\",Fixtures!$J$21)","v":""},{"$f":"IF(Fixtures!$K$21=\"\",\"\",Fixtures!$K$21)","v":""},{"$f":"IF(C20=\"\",\"\",IF(D20=\"\",\"\",IF(C20>D20,\"W\",IF(C20<D20,\"L\",IF(C20=D20,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$19=\"\",\"\",Fixtures!$J$19)","v":""},{"$f":"IF(Fixtures!$K$19=\"\",\"\",Fixtures!$K$19)","v":""},{"$f":"IF(F20=\"\",\"\",IF(G20=\"\",\"\",IF(F20>G20,\"W\",IF(F20<G20,\"L\",IF(F20=G20,\"D\")))))","v":""},null,null,{"$f":"IF(I20=\"\",\"\",IF(J20=\"\",\"\",IF(I20>J20,\"W\",IF(I20<J20,\"L\",IF(I20=J20,\"D\")))))","v":""},null,null,{"$f":"IF(L20=\"\",\"\",IF(M20=\"\",\"\",IF(L20>M20,\"W\",IF(L20<M20,\"L\",IF(L20=M20,\"D\")))))","v":""},null,null,{"$f":"B20","v":"Dominican Republic"},{"$f":"SUM(S20+T20+U20)","v":0},{"$f":"IF(E20=\"W\",1,0)+IF(H20=\"W\",1,0)+IF(K20=\"W\",1,0)+IF(N20=\"W\",1,0)+L21","v":0},{"$f":"IF(E20=\"D\",1,0)+IF(H20=\"D\",1,0)+IF(K20=\"D\",1,0)+IF(N20=\"D\",1,0)+M21","v":0},{"$f":"IF(E20=\"L\",1,0)+IF(H20=\"L\",1,0)+IF(K20=\"L\",1,0)+IF(O20=\"L\",1,0)+N21","v":0},{"$f":"SUM(C20)+SUM(F20)+SUM(I20)+SUM(L20)+L22","v":0},{"$f":"SUM(D20)+SUM(G20)+SUM(J20)+SUM(M20)+M22","v":0},{"$f":"V20-W20","v":0},{"$f":"S20*3+T20","v":0}]
[null,"W/D/L",{"$f":"IF(E17=\"L\",1,0)+IF(E18=\"L\",1,0)+IF(E19=\"L\",1,0)+IF(E20=\"L\",1,0)","v":0},{"$f":"IF(E17=\"D\",1,0)+IF(E18=\"D\",1,0)+IF(E19=\"D\",1,0)+IF(E20=\"D\",1,0)","v":0},{"$f":"IF(E17=\"W\",1,0)+IF(E18=\"W\",1,0)+IF(E19=\"W\",1,0)+IF(E20=\"W\",1,0)","v":0},{"$f":"IF(H17=\"L\",1,0)+IF(H18=\"L\",1,0)+IF(H19=\"L\",1,0)+IF(H20=\"L\",1,0)","v":0},{"$f":"IF(H17=\"D\",1,0)+IF(H18=\"D\",1,0)+IF(H19=\"D\",1,0)+IF(H20=\"D\",1,0)","v":0},{"$f":"IF(H17=\"W\",1,0)+IF(H18=\"W\",1,0)+IF(H19=\"W\",1,0)+IF(H20=\"W\",1,0)","v":0},{"$f":"IF(K17=\"L\",1,0)+IF(K18=\"L\",1,0)+IF(K19=\"L\",1,0)+IF(K20=\"L\",1,0)","v":0},{"$f":"IF(K17=\"D\",1,0)+IF(K18=\"D\",1,0)+IF(K19=\"D\",1,0)+IF(K20=\"D\",1,0)","v":0},{"$f":"IF(K17=\"W\",1,0)+IF(K18=\"W\",1,0)+IF(K19=\"W\",1,0)+IF(K20=\"W\",1,0)","v":0},{"$f":"IF(N17=\"L\",1,0)+IF(N18=\"L\",1,0)+IF(N19=\"L\",1,0)+IF(N20=\"L\",1,0)","v":0},{"$f":"IF(N17=\"D\",1,0)+IF(N18=\"D\",1,0)+IF(N19=\"D\",1,0)+IF(N20=\"D\",1,0)","v":0},{"$f":"IF(N17=\"W\",1,0)+IF(N18=\"W\",1,0)+IF(N19=\"W\",1,0)+IF(N20=\"W\",1,0)","v":0}]
[null,"F/A",{"$f":"SUM(D17)+SUM(D18)+SUM(D19)+SUM(D20)","v":0},{"$f":"SUM(C17)+SUM(C18)+SUM(C19)+SUM(C20)","v":0},null,{"$f":"SUM(G17)+SUM(G18)+SUM(G19)+SUM(G20)","v":0},{"$f":"SUM(F17)+SUM(F18)+SUM(F19)+SUM(F20)","v":0},null,{"$f":"SUM(J17)+SUM(J18)+SUM(J19)+SUM(J20)","v":0},{"$f":"SUM(I17)+SUM(I18)+SUM(I19)+SUM(I20)","v":0},null,{"$f":"SUM(M17)+SUM(M18)+SUM(M19)+SUM(M20)","v":0},{"$f":"SUM(L17)+SUM(L18)+SUM(L19)+SUM(L20)","v":0},null,null,null,null,null,{"$f":"IF(Fixtures!J23=\"\",\"\",Fixtures!J23)","v":""},{"$f":"IF(Fixtures!K23=\"\",\"\",Fixtures!K23)","v":""}]
[null,null,null,{"$f":"B24","v":"Japan"},null,null,{"$f":"B25","v":"Paraguay"},null,null,{"$f":"B26","v":"Mali"},null,null,{"$f":"B27","v":"Israel"},null,null,null,{"$f":"IF(SUM(R24:R27)=12,\"Final Ladder\",\"Incomplete\")","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts"]
[null,{"$f":"Fixtures!G24","v":"Japan"},null,null,{"$f":"IF(C24=\"\",\"\",IF(D24=\"\",\"\",IF(C24>D24,\"W\",IF(C24<D24,\"L\",IF(C24=D24,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$24=\"\",\"\",Fixtures!$J$24)","v":""},{"$f":"IF(Fixtures!$K$24=\"\",\"\",Fixtures!$K$24)","v":""},{"$f":"IF(F24=\"\",\"\",IF(G24=\"\",\"\",IF(F24>G24,\"W\",IF(F24<G24,\"L\",IF(F24=G24,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$27=\"\",\"\",Fixtures!$J$27)","v":""},{"$f":"IF(Fixtures!$K$27=\"\",\"\",Fixtures!$K$27)","v":""},{"$f":"IF(I24=\"\",\"\",IF(J24=\"\",\"\",IF(I24>J24,\"W\",IF(I24<J24,\"L\",IF(I24=J24,\"D\")))))","v":""},null,null,{"$f":"IF(L24=\"\",\"\",IF(M24=\"\",\"\",IF(L24>M24,\"W\",IF(L24<M24,\"L\",IF(L24=M24,\"D\")))))","v":""},null,null,{"$f":"B24","v":"Japan"},{"$f":"SUM(S24+T24+U24)","v":0},{"$f":"IF(E24=\"W\",1,0)+IF(H24=\"W\",1,0)+IF(K24=\"W\",1,0)+IF(N24=\"W\",1,0)+C28","v":0},{"$f":"IF(E24=\"D\",1,0)+IF(H24=\"D\",1,0)+IF(K24=\"D\",1,0)+IF(N24=\"D\",1,0)+D28","v":0},{"$f":"IF(E24=\"L\",1,0)+IF(H24=\"L\",1,0)+IF(K24=\"L\",1,0)+IF(N24=\"L\",1,0)+E28","v":0},{"$f":"SUM(C24)+SUM(F24)+SUM(I24)+SUM(L24)+C29","v":0},{"$f":"SUM(D24)+SUM(G24)+SUM(J24)+SUM(M24)+D29","v":0},{"$f":"V24-W24","v":0},{"$f":"S24*3+T24","v":0}]
[null,{"$f":"Fixtures!I24","v":"Paraguay"},null,null,{"$f":"IF(C25=\"\",\"\",IF(D25=\"\",\"\",IF(C25>D25,\"W\",IF(C25<D25,\"L\",IF(C25=D25,\"D\")))))","v":""},null,null,{"$f":"IF(F25=\"\",\"\",IF(G25=\"\",\"\",IF(F25>G25,\"W\",IF(F25<G25,\"L\",IF(F25=G25,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$29=\"\",\"\",Fixtures!$J$29)","v":""},{"$f":"IF(Fixtures!$K$29=\"\",\"\",Fixtures!$K$29)","v":""},{"$f":"IF(I25=\"\",\"\",IF(J25=\"\",\"\",IF(I25>J25,\"W\",IF(I25<J25,\"L\",IF(I25=J25,\"D\")))))","v":""},null,null,{"$f":"IF(L25=\"\",\"\",IF(M25=\"\",\"\",IF(L25>M25,\"W\",IF(L25<M25,\"L\",IF(L25=M25,\"D\")))))","v":""},null,null,{"$f":"B25","v":"Paraguay"},{"$f":"SUM(S25+T25+U25)","v":0},{"$f":"IF(E25=\"W\",1,0)+IF(H25=\"W\",1,0)+IF(K25=\"W\",1,0)+IF(N25=\"W\",1,0)+F28","v":0},{"$f":"IF(E25=\"D\",1,0)+IF(H25=\"D\",1,0)+IF(K25=\"D\",1,0)+IF(N25=\"D\",1,0)+G28","v":0},{"$f":"IF(E25=\"L\",1,0)+IF(H25=\"L\",1,0)+IF(K25=\"L\",1,0)+IF(N25=\"L\",1,0)+H28","v":0},{"$f":"SUM(C25)+SUM(F25)+SUM(I25)+SUM(L25)+F29","v":0},{"$f":"SUM(D25)+SUM(G25)+SUM(J25)+SUM(M25)+G29","v":0},{"$f":"V25-W25","v":0},{"$f":"S25*3+T25","v":0}]
[null,{"$f":"Fixtures!G25","v":"Mali"},null,null,{"$f":"IF(C26=\"\",\"\",IF(D26=\"\",\"\",IF(C26>D26,\"W\",IF(C26<D26,\"L\",IF(C26=D26,\"D\")))))","v":""},null,null,{"$f":"IF(F26=\"\",\"\",IF(G26=\"\",\"\",IF(F26>G26,\"W\",IF(F26<G26,\"L\",IF(F26=G26,\"D\")))))","v":""},null,null,{"$f":"IF(I26=\"\",\"\",IF(J26=\"\",\"\",IF(I26>J26,\"W\",IF(I26<J26,\"L\",IF(I26=J26,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$25=\"\",\"\",Fixtures!$J$25)","v":""},{"$f":"IF(Fixtures!$K$25=\"\",\"\",Fixtures!$K$25)","v":""},{"$f":"IF(L26=\"\",\"\",IF(M26=\"\",\"\",IF(L26>M26,\"W\",IF(L26<M26,\"L\",IF(L26=M26,\"D\")))))","v":""},null,null,{"$f":"B26","v":"Mali"},{"$f":"SUM(S26+T26+U26)","v":0},{"$f":"IF(E26=\"W\",1,0)+IF(H26=\"W\",1,0)+IF(K26=\"W\",1,0)+IF(N26=\"W\",1,0)+I28","v":0},{"$f":"IF(E26=\"D\",1,0)+IF(H26=\"D\",1,0)+IF(K26=\"D\",1,0)+IF(N26=\"D\",1,0)+J28","v":0},{"$f":"IF(E26=\"L\",1,0)+IF(H26=\"L\",1,0)+IF(K26=\"L\",1,0)+IF(N26=\"L\",1,0)+K28","v":0},{"$f":"SUM(C26)+SUM(F26)+SUM(I26)+SUM(L26)+I29","v":0},{"$f":"SUM(D26)+SUM(G26)+SUM(J26)+SUM(M26)+J29","v":0},{"$f":"V26-W26","v":0},{"$f":"S26*3+T26","v":0}]
[null,{"$f":"Fixtures!I25","v":"Israel"},{"$f":"IF(Fixtures!$J$28=\"\",\"\",Fixtures!$J$28)","v":""},{"$f":"IF(Fixtures!$K$28=\"\",\"\",Fixtures!$K$28)","v":""},{"$f":"IF(C27=\"\",\"\",IF(D27=\"\",\"\",IF(C27>D27,\"W\",IF(C27<D27,\"L\",IF(C27=D27,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$26=\"\",\"\",Fixtures!$J$26)","v":""},{"$f":"IF(Fixtures!$K$26=\"\",\"\",Fixtures!$K$26)","v":""},{"$f":"IF(F27=\"\",\"\",IF(G27=\"\",\"\",IF(F27>G27,\"W\",IF(F27<G27,\"L\",IF(F27=G27,\"D\")))))","v":""},null,null,{"$f":"IF(I27=\"\",\"\",IF(J27=\"\",\"\",IF(I27>J27,\"W\",IF(I27<J27,\"L\",IF(I27=J27,\"D\")))))","v":""},null,null,{"$f":"IF(L27=\"\",\"\",IF(M27=\"\",\"\",IF(L27>M27,\"W\",IF(L27<M27,\"L\",IF(L27=M27,\"D\")))))","v":""},null,null,{"$f":"B27","v":"Israel"},{"$f":"SUM(S27+T27+U27)","v":0},{"$f":"IF(E27=\"W\",1,0)+IF(H27=\"W\",1,0)+IF(K27=\"W\",1,0)+IF(N27=\"W\",1,0)+L28","v":0},{"$f":"IF(E27=\"D\",1,0)+IF(H27=\"D\",1,0)+IF(K27=\"D\",1,0)+IF(N27=\"D\",1,0)+M28","v":0},{"$f":"IF(E27=\"L\",1,0)+IF(H27=\"L\",1,0)+IF(K27=\"L\",1,0)+IF(O27=\"L\",1,0)+N28","v":0},{"$f":"SUM(C27)+SUM(F27)+SUM(I27)+SUM(L27)+L29","v":0},{"$f":"SUM(D27)+SUM(G27)+SUM(J27)+SUM(M27)+M29","v":0},{"$f":"V27-W27","v":0},{"$f":"S27*3+T27","v":0}]
[null,"W/D/L",{"$f":"IF(E24=\"L\",1,0)+IF(E25=\"L\",1,0)+IF(E26=\"L\",1,0)+IF(E27=\"L\",1,0)","v":0},{"$f":"IF(E24=\"D\",1,0)+IF(E25=\"D\",1,0)+IF(E26=\"D\",1,0)+IF(E27=\"D\",1,0)","v":0},{"$f":"IF(E24=\"W\",1,0)+IF(E25=\"W\",1,0)+IF(E26=\"W\",1,0)+IF(E27=\"W\",1,0)","v":0},{"$f":"IF(H24=\"L\",1,0)+IF(H25=\"L\",1,0)+IF(H26=\"L\",1,0)+IF(H27=\"L\",1,0)","v":0},{"$f":"IF(H24=\"D\",1,0)+IF(H25=\"D\",1,0)+IF(H26=\"D\",1,0)+IF(H27=\"D\",1,0)","v":0},{"$f":"IF(H24=\"W\",1,0)+IF(H25=\"W\",1,0)+IF(H26=\"W\",1,0)+IF(H27=\"W\",1,0)","v":0},{"$f":"IF(K24=\"L\",1,0)+IF(K25=\"L\",1,0)+IF(K26=\"L\",1,0)+IF(K27=\"L\",1,0)","v":0},{"$f":"IF(K24=\"D\",1,0)+IF(K25=\"D\",1,0)+IF(K26=\"D\",1,0)+IF(K27=\"D\",1,0)","v":0},{"$f":"IF(K24=\"W\",1,0)+IF(K25=\"W\",1,0)+IF(K26=\"W\",1,0)+IF(K27=\"W\",1,0)","v":0},{"$f":"IF(N24=\"L\",1,0)+IF(N25=\"L\",1,0)+IF(N26=\"L\",1,0)+IF(N27=\"L\",1,0)","v":0},{"$f":"IF(N24=\"D\",1,0)+IF(N25=\"D\",1,0)+IF(N26=\"D\",1,0)+IF(N27=\"D\",1,0)","v":0},{"$f":"IF(N24=\"W\",1,0)+IF(N25=\"W\",1,0)+IF(N26=\"W\",1,0)+IF(N27=\"W\",1,0)","v":0}]
[null,"F/A",{"$f":"SUM(D24)+SUM(D25)+SUM(D26)+SUM(D27)","v":0},{"$f":"SUM(C24)+SUM(C25)+SUM(C26)+SUM(C27)","v":0},null,{"$f":"SUM(G24)+SUM(G25)+SUM(G26)+SUM(G27)","v":0},{"$f":"SUM(F24)+SUM(F25)+SUM(F26)+SUM(F27)","v":0},null,{"$f":"SUM(J24)+SUM(J25)+SUM(J26)+SUM(J27)","v":0},{"$f":"SUM(I24)+SUM(I25)+SUM(I26)+SUM(I27)","v":0},null,{"$f":"SUM(M24)+SUM(M25)+SUM(M26)+SUM(M27)","v":0},{"$f":"SUM(L24)+SUM(L25)+SUM(L26)+SUM(L27)","v":0}]
[null,null,null,{"$f":"B31","v":"Australia"},null,null,{"$f":"B32","v":" Philippines"},null,null,{"$f":"B33","v":"Korea Republic"},null,null,{"$f":"B34","v":" Iran"},null,null,null,{"$f":"IF(SUM(R31:R34)=12,\"Final Ladder\",\"Incomplete\")","v":"Final Ladder"},"P","W","D","L","F","A","GD","Pts"]
[null,{"$f":"Fixtures!G31","v":"Australia"},null,null,{"$f":"IF(C31=\"\",\"\",IF(D31=\"\",\"\",IF(C31>D31,\"W\",IF(C31<D31,\"L\",IF(C31=D31,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$31=\"\",\"\",Fixtures!$J$31)","v":1},{"$f":"IF(Fixtures!$K$31=\"\",\"\",Fixtures!$K$31)","v":0},{"$f":"IF(F31=\"\",\"\",IF(G31=\"\",\"\",IF(F31>G31,\"W\",IF(F31<G31,\"L\",IF(F31=G31,\"D\")))))","v":"W"},{"$f":"IF(Fixtures!$J$36=\"\",\"\",Fixtures!$J$36)","v":3},{"$f":"IF(Fixtures!$K$36=\"\",\"\",Fixtures!$K$36)","v":3},{"$f":"IF(I31=\"\",\"\",IF(J31=\"\",\"\",IF(I31>J31,\"W\",IF(I31<J31,\"L\",IF(I31=J31,\"D\")))))","v":"D"},null,null,{"$f":"IF(L31=\"\",\"\",IF(M31=\"\",\"\",IF(L31>M31,\"W\",IF(L31<M31,\"L\",IF(L31=M31,\"D\")))))","v":""},null,null,{"$f":"B31","v":"Australia"},{"$f":"SUM(S31+T31+U31)","v":3},{"$f":"IF(E31=\"W\",1,0)+IF(H31=\"W\",1,0)+IF(K31=\"W\",1,0)+IF(N31=\"W\",1,0)+C35","v":2},{"$f":"IF(E31=\"D\",1,0)+IF(H31=\"D\",1,0)+IF(K31=\"D\",1,0)+IF(N31=\"D\",1,0)+D35","v":1},{"$f":"IF(E31=\"L\",1,0)+IF(H31=\"L\",1,0)+IF(K31=\"L\",1,0)+IF(N31=\"L\",1,0)+E35","v":0},{"$f":"SUM(C31)+SUM(F31)+SUM(I31)+SUM(L31)+C36","v":8},{"$f":"SUM(D31)+SUM(G31)+SUM(J31)+SUM(M31)+D36","v":3},{"$f":"V31-W31","v":5},{"$f":"S31*3+T31","v":7}]
[null,{"$f":"Fixtures!I31","v":" Philippines"},null,null,{"$f":"IF(C32=\"\",\"\",IF(D32=\"\",\"\",IF(C32>D32,\"W\",IF(C32<D32,\"L\",IF(C32=D32,\"D\")))))","v":""},null,null,{"$f":"IF(F32=\"\",\"\",IF(G32=\"\",\"\",IF(F32>G32,\"W\",IF(F32<G32,\"L\",IF(F32=G32,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$33=\"\",\"\",Fixtures!$J$33)","v":0},{"$f":"IF(Fixtures!$K$33=\"\",\"\",Fixtures!$K$33)","v":3},{"$f":"IF(I32=\"\",\"\",IF(J32=\"\",\"\",IF(I32>J32,\"W\",IF(I32<J32,\"L\",IF(I32=J32,\"D\")))))","v":"L"},null,null,{"$f":"IF(L32=\"\",\"\",IF(M32=\"\",\"\",IF(L32>M32,\"W\",IF(L32<M32,\"L\",IF(L32=M32,\"D\")))))","v":""},null,null,{"$f":"B32","v":" Philippines"},{"$f":"SUM(S32+T32+U32)","v":3},{"$f":"IF(E32=\"W\",1,0)+IF(H32=\"W\",1,0)+IF(K32=\"W\",1,0)+IF(N32=\"W\",1,0)+F35","v":1},{"$f":"IF(E32=\"D\",1,0)+IF(H32=\"D\",1,0)+IF(K32=\"D\",1,0)+IF(N32=\"D\",1,0)+G35","v":0},{"$f":"IF(E32=\"L\",1,0)+IF(H32=\"L\",1,0)+IF(K32=\"L\",1,0)+IF(N32=\"L\",1,0)+H35","v":2},{"$f":"SUM(C32)+SUM(F32)+SUM(I32)+SUM(L32)+F36","v":2},{"$f":"SUM(D32)+SUM(G32)+SUM(J32)+SUM(M32)+G36","v":4},{"$f":"V32-W32","v":-2},{"$f":"S32*3+T32","v":3}]
[null,{"$f":"Fixtures!G32","v":"Korea Republic"},null,null,{"$f":"IF(C33=\"\",\"\",IF(D33=\"\",\"\",IF(C33>D33,\"W\",IF(C33<D33,\"L\",IF(C33=D33,\"D\")))))","v":""},null,null,{"$f":"IF(F33=\"\",\"\",IF(G33=\"\",\"\",IF(F33>G33,\"W\",IF(F33<G33,\"L\",IF(F33=G33,\"D\")))))","v":""},null,null,{"$f":"IF(I33=\"\",\"\",IF(J33=\"\",\"\",IF(I33>J33,\"W\",IF(I33<J33,\"L\",IF(I33=J33,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$32=\"\",\"\",Fixtures!$J$32)","v":3},{"$f":"IF(Fixtures!$K$32=\"\",\"\",Fixtures!$K$32)","v":0},{"$f":"IF(L33=\"\",\"\",IF(M33=\"\",\"\",IF(L33>M33,\"W\",IF(L33<M33,\"L\",IF(L33=M33,\"D\")))))","v":"W"},null,null,{"$f":"B33","v":"Korea Republic"},{"$f":"SUM(S33+T33+U33)","v":3},{"$f":"IF(E33=\"W\",1,0)+IF(H33=\"W\",1,0)+IF(K33=\"W\",1,0)+IF(N33=\"W\",1,0)+I35","v":2},{"$f":"IF(E33=\"D\",1,0)+IF(H33=\"D\",1,0)+IF(K33=\"D\",1,0)+IF(N33=\"D\",1,0)+J35","v":1},{"$f":"IF(E33=\"L\",1,0)+IF(H33=\"L\",1,0)+IF(K33=\"L\",1,0)+IF(N33=\"L\",1,0)+K35","v":0},{"$f":"SUM(C33)+SUM(F33)+SUM(I33)+SUM(L33)+I36","v":9},{"$f":"SUM(D33)+SUM(G33)+SUM(J33)+SUM(M33)+J36","v":3},{"$f":"V33-W33","v":6},{"$f":"S33*3+T33","v":7}]
[null,{"$f":"Fixtures!I32","v":" Iran"},{"$f":"IF(Fixtures!$J$34=\"\",\"\",Fixtures!$J$34)","v":0},{"$f":"IF(Fixtures!$K$34=\"\",\"\",Fixtures!$K$34)","v":4},{"$f":"IF(C34=\"\",\"\",IF(D34=\"\",\"\",IF(C34>D34,\"W\",IF(C34<D34,\"L\",IF(C34=D34,\"D\")))))","v":"L"},{"$f":"IF(Fixtures!$J$35=\"\",\"\",Fixtures!$J$35)","v":0},{"$f":"IF(Fixtures!$K$35=\"\",\"\",Fixtures!$K$35)","v":2},{"$f":"IF(F34=\"\",\"\",IF(G34=\"\",\"\",IF(F34>G34,\"W\",IF(F34<G34,\"L\",IF(F34=G34,\"D\")))))","v":"L"},null,null,{"$f":"IF(I34=\"\",\"\",IF(J34=\"\",\"\",IF(I34>J34,\"W\",IF(I34<J34,\"L\",IF(I34=J34,\"D\")))))","v":""},null,null,{"$f":"IF(L34=\"\",\"\",IF(M34=\"\",\"\",IF(L34>M34,\"W\",IF(L34<M34,\"L\",IF(L34=M34,\"D\")))))","v":""},null,null,{"$f":"B34","v":" Iran"},{"$f":"SUM(S34+T34+U34)","v":3},{"$f":"IF(E34=\"W\",1,0)+IF(H34=\"W\",1,0)+IF(K34=\"W\",1,0)+IF(N34=\"W\",1,0)+L35","v":0},{"$f":"IF(E34=\"D\",1,0)+IF(H34=\"D\",1,0)+IF(K34=\"D\",1,0)+IF(N34=\"D\",1,0)+M35","v":0},{"$f":"IF(E34=\"L\",1,0)+IF(H34=\"L\",1,0)+IF(K34=\"L\",1,0)+IF(O34=\"L\",1,0)+N35","v":3},{"$f":"SUM(C34)+SUM(F34)+SUM(I34)+SUM(L34)+L36","v":0},{"$f":"SUM(D34)+SUM(G34)+SUM(J34)+SUM(M34)+M36","v":9},{"$f":"V34-W34","v":-9},{"$f":"S34*3+T34","v":0}]
[null,"W/D/L",{"$f":"IF(E31=\"L\",1,0)+IF(E32=\"L\",1,0)+IF(E33=\"L\",1,0)+IF(E34=\"L\",1,0)","v":1},{"$f":"IF(E31=\"D\",1,0)+IF(E32=\"D\",1,0)+IF(E33=\"D\",1,0)+IF(E34=\"D\",1,0)","v":0},{"$f":"IF(E31=\"W\",1,0)+IF(E32=\"W\",1,0)+IF(E33=\"W\",1,0)+IF(E34=\"W\",1,0)","v":0},{"$f":"IF(H31=\"L\",1,0)+IF(H32=\"L\",1,0)+IF(H33=\"L\",1,0)+IF(H34=\"L\",1,0)","v":1},{"$f":"IF(H31=\"D\",1,0)+IF(H32=\"D\",1,0)+IF(H33=\"D\",1,0)+IF(H34=\"D\",1,0)","v":0},{"$f":"IF(H31=\"W\",1,0)+IF(H32=\"W\",1,0)+IF(H33=\"W\",1,0)+IF(H34=\"W\",1,0)","v":1},{"$f":"IF(K31=\"L\",1,0)+IF(K32=\"L\",1,0)+IF(K33=\"L\",1,0)+IF(K34=\"L\",1,0)","v":1},{"$f":"IF(K31=\"D\",1,0)+IF(K32=\"D\",1,0)+IF(K33=\"D\",1,0)+IF(K34=\"D\",1,0)","v":1},{"$f":"IF(K31=\"W\",1,0)+IF(K32=\"W\",1,0)+IF(K33=\"W\",1,0)+IF(K34=\"W\",1,0)","v":0},{"$f":"IF(N31=\"L\",1,0)+IF(N32=\"L\",1,0)+IF(N33=\"L\",1,0)+IF(N34=\"L\",1,0)","v":0},{"$f":"IF(N31=\"D\",1,0)+IF(N32=\"D\",1,0)+IF(N33=\"D\",1,0)+IF(N34=\"D\",1,0)","v":0},{"$f":"IF(N31=\"W\",1,0)+IF(N32=\"W\",1,0)+IF(N33=\"W\",1,0)+IF(N34=\"W\",1,0)","v":1}]
[null,"F/A",{"$f":"SUM(D31)+SUM(D32)+SUM(D33)+SUM(D34)","v":4},{"$f":"SUM(C31)+SUM(C32)+SUM(C33)+SUM(C34)","v":0},null,{"$f":"SUM(G31)+SUM(G32)+SUM(G33)+SUM(G34)","v":2},{"$f":"SUM(F31)+SUM(F32)+SUM(F33)+SUM(F34)","v":1},null,{"$f":"SUM(J31)+SUM(J32)+SUM(J33)+SUM(J34)","v":6},{"$f":"SUM(I31)+SUM(I32)+SUM(I33)+SUM(I34)","v":3},null,{"$f":"SUM(M31)+SUM(M32)+SUM(M33)+SUM(M34)","v":0},{"$f":"SUM(L31)+SUM(L32)+SUM(L33)+SUM(L34)","v":3}]
[null,null,null,{"$f":"B38","v":"DPR Korea"},null,null,{"$f":"B39","v":" Uzbekistan"},null,null,{"$f":"B40","v":"China"},null,null,{"$f":"B41","v":" Bangladesh"},null,null,null,{"$f":"IF(SUM(R38:R41)=12,\"Final Ladder\",\"Incomplete\")","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts"]
[null,{"$f":"Fixtures!G38","v":"DPR Korea"},null,null,{"$f":"IF(C38=\"\",\"\",IF(D38=\"\",\"\",IF(C38>D38,\"W\",IF(C38<D38,\"L\",IF(C38=D38,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$38=\"\",\"\",Fixtures!$J$38)","v":3},{"$f":"IF(Fixtures!$K$38=\"\",\"\",Fixtures!$K$38)","v":0},{"$f":"IF(F38=\"\",\"\",IF(G38=\"\",\"\",IF(F38>G38,\"W\",IF(F38<G38,\"L\",IF(F38=G38,\"D\")))))","v":"W"},{"$f":"IF(Fixtures!$J$43=\"\",\"\",Fixtures!$J$43)","v":""},{"$f":"IF(Fixtures!$K$43=\"\",\"\",Fixtures!$K$43)","v":""},{"$f":"IF(I38=\"\",\"\",IF(J38=\"\",\"\",IF(I38>J38,\"W\",IF(I38<J38,\"L\",IF(I38=J38,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$40=\"\",\"\",Fixtures!$J$40)","v":5},{"$f":"IF(Fixtures!$K$40=\"\",\"\",Fixtures!$K$40)","v":0},{"$f":"IF(L38=\"\",\"\",IF(M38=\"\",\"\",IF(L38>M38,\"W\",IF(L38<M38,\"L\",IF(L38=M38,\"D\")))))","v":"W"},null,null,{"$f":"B38","v":"DPR Korea"},{"$f":"SUM(S38+T38+U38)","v":2},{"$f":"IF(E38=\"W\",1,0)+IF(H38=\"W\",1,0)+IF(K38=\"W\",1,0)+IF(N38=\"W\",1,0)+C42","v":2},{"$f":"IF(E38=\"D\",1,0)+IF(H38=\"D\",1,0)+IF(K38=\"D\",1,0)+IF(N38=\"D\",1,0)+D42","v":0},{"$f":"IF(E38=\"L\",1,0)+IF(H38=\"L\",1,0)+IF(K38=\"L\",1,0)+IF(N38=\"L\",1,0)+E42","v":0},{"$f":"SUM(C38)+SUM(F38)+SUM(I38)+SUM(L38)+C43","v":8},{"$f":"SUM(D38)+SUM(G38)+SUM(J38)+SUM(M38)+D43","v":0},{"$f":"V38-W38","v":8},{"$f":"S38*3+T38","v":6}]
[null,{"$f":"Fixtures!I38","v":" Uzbekistan"},null,null,{"$f":"IF(C39=\"\",\"\",IF(D39=\"\",\"\",IF(C39>D39,\"W\",IF(C39<D39,\"L\",IF(C39=D39,\"D\")))))","v":""},null,null,{"$f":"IF(F39=\"\",\"\",IF(G39=\"\",\"\",IF(F39>G39,\"W\",IF(F39<G39,\"L\",IF(F39=G39,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$41=\"\",\"\",Fixtures!$J$41)","v":0},{"$f":"IF(Fixtures!$K$41=\"\",\"\",Fixtures!$K$41)","v":3},{"$f":"IF(I39=\"\",\"\",IF(J39=\"\",\"\",IF(I39>J39,\"W\",IF(I39<J39,\"L\",IF(I39=J39,\"D\")))))","v":"L"},null,null,{"$f":"IF(L39=\"\",\"\",IF(M39=\"\",\"\",IF(L39>M39,\"W\",IF(L39<M39,\"L\",IF(L39=M39,\"D\")))))","v":""},null,null,{"$f":"B39","v":" Uzbekistan"},{"$f":"SUM(S39+T39+U39)","v":2},{"$f":"IF(E39=\"W\",1,0)+IF(H39=\"W\",1,0)+IF(K39=\"W\",1,0)+IF(N39=\"W\",1,0)+F42","v":0},{"$f":"IF(E39=\"D\",1,0)+IF(H39=\"D\",1,0)+IF(K39=\"D\",1,0)+IF(N39=\"D\",1,0)+G42","v":0},{"$f":"IF(E39=\"L\",1,0)+IF(H39=\"L\",1,0)+IF(K39=\"L\",1,0)+IF(N39=\"L\",1,0)+H42","v":2},{"$f":"SUM(C39)+SUM(F39)+SUM(I39)+SUM(L39)+F43","v":0},{"$f":"SUM(D39)+SUM(G39)+SUM(J39)+SUM(M39)+G43","v":6},{"$f":"V39-W39","v":-6},{"$f":"S39*3+T39","v":0}]
[null,{"$f":"Fixtures!G39","v":"China"},null,null,{"$f":"IF(C40=\"\",\"\",IF(D40=\"\",\"\",IF(C40>D40,\"W\",IF(C40<D40,\"L\",IF(C40=D40,\"D\")))))","v":""},null,null,{"$f":"IF(F40=\"\",\"\",IF(G40=\"\",\"\",IF(F40>G40,\"W\",IF(F40<G40,\"L\",IF(F40=G40,\"D\")))))","v":""},null,null,{"$f":"IF(I40=\"\",\"\",IF(J40=\"\",\"\",IF(I40>J40,\"W\",IF(I40<J40,\"L\",IF(I40=J40,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$39=\"\",\"\",Fixtures!$J$39)","v":2},{"$f":"IF(Fixtures!$K$39=\"\",\"\",Fixtures!$K$39)","v":0},{"$f":"IF(L40=\"\",\"\",IF(M40=\"\",\"\",IF(L40>M40,\"W\",IF(L40<M40,\"L\",IF(L40=M40,\"D\")))))","v":"W"},null,null,{"$f":"B40","v":"China"},{"$f":"SUM(S40+T40+U40)","v":2},{"$f":"IF(E40=\"W\",1,0)+IF(H40=\"W\",1,0)+IF(K40=\"W\",1,0)+IF(N40=\"W\",1,0)+I42","v":2},{"$f":"IF(E40=\"D\",1,0)+IF(H40=\"D\",1,0)+IF(K40=\"D\",1,0)+IF(N40=\"D\",1,0)+J42","v":0},{"$f":"IF(E40=\"L\",1,0)+IF(H40=\"L\",1,0)+IF(K40=\"L\",1,0)+IF(N40=\"L\",1,0)+K42","v":0},{"$f":"SUM(C40)+SUM(F40)+SUM(I40)+SUM(L40)+I43","v":5},{"$f":"SUM(D40)+SUM(G40)+SUM(J40)+SUM(M40)+J43","v":0},{"$f":"V40-W40","v":5},{"$f":"S40*3+T40","v":6}]
[null,{"$f":"Fixtures!I39","v":" Bangladesh"},null,null,{"$f":"IF(C41=\"\",\"\",IF(D41=\"\",\"\",IF(C41>D41,\"W\",IF(C41<D41,\"L\",IF(C41=D41,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$42=\"\",\"\",Fixtures!$J$42)","v":""},{"$f":"IF(Fixtures!$K$42=\"\",\"\",Fixtures!$K$42)","v":""},{"$f":"IF(F41=\"\",\"\",IF(G41=\"\",\"\",IF(F41>G41,\"W\",IF(F41<G41,\"L\",IF(F41=G41,\"D\")))))","v":""},null,null,{"$f":"IF(I41=\"\",\"\",IF(J41=\"\",\"\",IF(I41>J41,\"W\",IF(I41<J41,\"L\",IF(I41=J41,\"D\")))))","v":""},null,null,{"$f":"IF(L41=\"\",\"\",IF(M41=\"\",\"\",IF(L41>M41,\"W\",IF(L41<M41,\"L\",IF(L41=M41,\"D\")))))","v":""},null,null,{"$f":"B41","v":" Bangladesh"},{"$f":"SUM(S41+T41+U41)","v":2},{"$f":"IF(E41=\"W\",1,0)+IF(H41=\"W\",1,0)+IF(K41=\"W\",1,0)+IF(N41=\"W\",1,0)+L42","v":0},{"$f":"IF(E41=\"D\",1,0)+IF(H41=\"D\",1,0)+IF(K41=\"D\",1,0)+IF(N41=\"D\",1,0)+M42","v":0},{"$f":"IF(E41=\"L\",1,0)+IF(H41=\"L\",1,0)+IF(K41=\"L\",1,0)+IF(O41=\"L\",1,0)+N42","v":2},{"$f":"SUM(C41)+SUM(F41)+SUM(I41)+SUM(L41)+L43","v":0},{"$f":"SUM(D41)+SUM(G41)+SUM(J41)+SUM(M41)+M43","v":7},{"$f":"V41-W41","v":-7},{"$f":"S41*3+T41","v":0}]
[null,"W/D/L",{"$f":"IF(E38=\"L\",1,0)+IF(E39=\"L\",1,0)+IF(E40=\"L\",1,0)+IF(E41=\"L\",1,0)","v":0},{"$f":"IF(E38=\"D\",1,0)+IF(E39=\"D\",1,0)+IF(E40=\"D\",1,0)+IF(E41=\"D\",1,0)","v":0},{"$f":"IF(E38=\"W\",1,0)+IF(E39=\"W\",1,0)+IF(E40=\"W\",1,0)+IF(E41=\"W\",1,0)","v":0},{"$f":"IF(H38=\"L\",1,0)+IF(H39=\"L\",1,0)+IF(H40=\"L\",1,0)+IF(H41=\"L\",1,0)","v":0},{"$f":"IF(H38=\"D\",1,0)+IF(H39=\"D\",1,0)+IF(H40=\"D\",1,0)+IF(H41=\"D\",1,0)","v":0},{"$f":"IF(H38=\"W\",1,0)+IF(H39=\"W\",1,0)+IF(H40=\"W\",1,0)+IF(H41=\"W\",1,0)","v":1},{"$f":"IF(K38=\"L\",1,0)+IF(K39=\"L\",1,0)+IF(K40=\"L\",1,0)+IF(K41=\"L\",1,0)","v":1},{"$f":"IF(K38=\"D\",1,0)+IF(K39=\"D\",1,0)+IF(K40=\"D\",1,0)+IF(K41=\"D\",1,0)","v":0},{"$f":"IF(K38=\"W\",1,0)+IF(K39=\"W\",1,0)+IF(K40=\"W\",1,0)+IF(K41=\"W\",1,0)","v":0},{"$f":"IF(N38=\"L\",1,0)+IF(N39=\"L\",1,0)+IF(N40=\"L\",1,0)+IF(N41=\"L\",1,0)","v":0},{"$f":"IF(N38=\"D\",1,0)+IF(N39=\"D\",1,0)+IF(N40=\"D\",1,0)+IF(N41=\"D\",1,0)","v":0},{"$f":"IF(N38=\"W\",1,0)+IF(N39=\"W\",1,0)+IF(N40=\"W\",1,0)+IF(N41=\"W\",1,0)","v":2}]
[null,"F/A",{"$f":"SUM(D38)+SUM(D39)+SUM(D40)+SUM(D41)","v":0},{"$f":"SUM(C38)+SUM(C39)+SUM(C40)+SUM(C41)","v":0},null,{"$f":"SUM(G38)+SUM(G39)+SUM(G40)+SUM(G41)","v":0},{"$f":"SUM(F38)+SUM(F39)+SUM(F40)+SUM(F41)","v":3},null,{"$f":"SUM(J38)+SUM(J39)+SUM(J40)+SUM(J41)","v":3},{"$f":"SUM(I38)+SUM(I39)+SUM(I40)+SUM(I41)","v":0},null,{"$f":"SUM(M38)+SUM(M39)+SUM(M40)+SUM(M41)","v":0},{"$f":"SUM(L38)+SUM(L39)+SUM(L40)+SUM(L41)","v":7}]
[null,null,null,{"$f":"B45","v":"Japan"},null,null,{"$f":"B46","v":" Chinese Taipei"},null,null,{"$f":"B47","v":"Vietnam"},null,null,{"$f":"B48","v":" India"},null,null,null,{"$f":"IF(SUM(R45:R48)=12,\"Final Ladder\",\"Incomplete\")","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts"]
[null,{"$f":"Fixtures!G45","v":"Japan"},null,null,{"$f":"IF(C45=\"\",\"\",IF(D45=\"\",\"\",IF(C45>D45,\"W\",IF(C45<D45,\"L\",IF(C45=D45,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$45=\"\",\"\",Fixtures!$J$45)","v":2},{"$f":"IF(Fixtures!K45=\"\",\"\",Fixtures!K45)","v":0},{"$f":"IF(F45=\"\",\"\",IF(G45=\"\",\"\",IF(F45>G45,\"W\",IF(F45<G45,\"L\",IF(F45=G45,\"D\")))))","v":"W"},{"$f":"IF(Fixtures!$J$49=\"\",\"\",Fixtures!$J$49)","v":""},{"$f":"IF(Fixtures!$K$49=\"\",\"\",Fixtures!$K$49)","v":""},{"$f":"IF(I45=\"\",\"\",IF(J45=\"\",\"\",IF(I45>J45,\"W\",IF(I45<J45,\"L\",IF(I45=J45,\"D\")))))","v":""},null,null,{"$f":"IF(L45=\"\",\"\",IF(M45=\"\",\"\",IF(L45>M45,\"W\",IF(L45<M45,\"L\",IF(L45=M45,\"D\")))))","v":""},null,null,{"$f":"B45","v":"Japan"},{"$f":"SUM(S45+T45+U45)","v":2},{"$f":"IF(E45=\"W\",1,0)+IF(H45=\"W\",1,0)+IF(K45=\"W\",1,0)+IF(N45=\"W\",1,0)+C49","v":2},{"$f":"IF(E45=\"D\",1,0)+IF(H45=\"D\",1,0)+IF(K45=\"D\",1,0)+IF(N45=\"D\",1,0)+D49","v":0},{"$f":"IF(E45=\"L\",1,0)+IF(H45=\"L\",1,0)+IF(K45=\"L\",1,0)+IF(N45=\"L\",1,0)+E49","v":0},{"$f":"SUM(C45)+SUM(F45)+SUM(I45)+SUM(L45)+C50","v":13},{"$f":"SUM(D45)+SUM(G45)+SUM(J45)+SUM(M45)+D50","v":0},{"$f":"V45-W45","v":13},{"$f":"S45*3+T45","v":6}]
[null,{"$f":"Fixtures!I45","v":" Chinese Taipei"},null,null,{"$f":"IF(C46=\"\",\"\",IF(D46=\"\",\"\",IF(C46>D46,\"W\",IF(C46<D46,\"L\",IF(C46=D46,\"D\")))))","v":""},null,null,{"$f":"IF(F46=\"\",\"\",IF(G46=\"\",\"\",IF(F46>G46,\"W\",IF(F46<G46,\"L\",IF(F46=G46,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$47=\"\",\"\",Fixtures!$J$47)","v":1},{"$f":"IF(Fixtures!$K$47=\"\",\"\",Fixtures!$K$47)","v":0},{"$f":"IF(I46=\"\",\"\",IF(J46=\"\",\"\",IF(I46>J46,\"W\",IF(I46<J46,\"L\",IF(I46=J46,\"D\")))))","v":"W"},null,null,{"$f":"IF(L46=\"\",\"\",IF(M46=\"\",\"\",IF(L46>M46,\"W\",IF(L46<M46,\"L\",IF(L46=M46,\"D\")))))","v":""},null,null,{"$f":"B46","v":" Chinese Taipei"},{"$f":"SUM(S46+T46+U46)","v":2},{"$f":"IF(E46=\"W\",1,0)+IF(H46=\"W\",1,0)+IF(K46=\"W\",1,0)+IF(N46=\"W\",1,0)+F49","v":1},{"$f":"IF(E46=\"D\",1,0)+IF(H46=\"D\",1,0)+IF(K46=\"D\",1,0)+IF(N46=\"D\",1,0)+G49","v":0},{"$f":"IF(E46=\"L\",1,0)+IF(H46=\"L\",1,0)+IF(K46=\"L\",1,0)+IF(N46=\"L\",1,0)+H49","v":1},{"$f":"SUM(C46)+SUM(F46)+SUM(I46)+SUM(L46)+F50","v":1},{"$f":"SUM(D46)+SUM(G46)+SUM(J46)+SUM(M46)+G50","v":2},{"$f":"V46-W46","v":-1},{"$f":"S46*3+T46","v":3}]
[null,{"$f":"Fixtures!G46","v":"Vietnam"},null,null,{"$f":"IF(C47=\"\",\"\",IF(D47=\"\",\"\",IF(C47>D47,\"W\",IF(C47<D47,\"L\",IF(C47=D47,\"D\")))))","v":""},null,null,{"$f":"IF(F47=\"\",\"\",IF(G47=\"\",\"\",IF(F47>G47,\"W\",IF(F47<G47,\"L\",IF(F47=G47,\"D\")))))","v":""},null,null,{"$f":"IF(I47=\"\",\"\",IF(J47=\"\",\"\",IF(I47>J47,\"W\",IF(I47<J47,\"L\",IF(I47=J47,\"D\")))))","v":""},{"$f":"IF(Fixtures!$J$46=\"\",\"\",Fixtures!$J$46)","v":2},{"$f":"IF(Fixtures!K46=\"\",\"\",Fixtures!K46)","v":1},{"$f":"IF(L47=\"\",\"\",IF(M47=\"\",\"\",IF(L47>M47,\"W\",IF(L47<M47,\"L\",IF(L47=M47,\"D\")))))","v":"W"},null,null,{"$f":"B47","v":"Vietnam"},{"$f":"SUM(S47+T47+U47)","v":2},{"$f":"IF(E47=\"W\",1,0)+IF(H47=\"W\",1,0)+IF(K47=\"W\",1,0)+IF(N47=\"W\",1,0)+I49","v":1},{"$f":"IF(E47=\"D\",1,0)+IF(H47=\"D\",1,0)+IF(K47=\"D\",1,0)+IF(N47=\"D\",1,0)+J49","v":0},{"$f":"IF(E47=\"L\",1,0)+IF(H47=\"L\",1,0)+IF(K47=\"L\",1,0)+IF(N47=\"L\",1,0)+K49","v":1},{"$f":"SUM(C47)+SUM(F47)+SUM(I47)+SUM(L47)+I50","v":2},{"$f":"SUM(D47)+SUM(G47)+SUM(J47)+SUM(M47)+J50","v":2},{"$f":"V47-W47","v":0},{"$f":"S47*3+T47","v":3}]
[null,{"$f":"Fixtures!I46","v":" India"},{"$f":"IF(Fixtures!$J$48=\"\",\"\",Fixtures!$J$48)","v":0},{"$f":"IF(Fixtures!$K$48=\"\",\"\",Fixtures!$K$48)","v":11},{"$f":"IF(C48=\"\",\"\",IF(D48=\"\",\"\",IF(C48>D48,\"W\",IF(C48<D48,\"L\",IF(C48=D48,\"D\")))))","v":"L"},{"$f":"IF(Fixtures!$J$50=\"\",\"\",Fixtures!$J$50)","v":""},{"$f":"IF(Fixtures!$K$50=\"\",\"\",Fixtures!$K$50)","v":""},{"$f":"IF(F48=\"\",\"\",IF(G48=\"\",\"\",IF(F48>G48,\"W\",IF(F48<G48,\"L\",IF(F48=G48,\"D\")))))","v":""},null,null,{"$f":"IF(I48=\"\",\"\",IF(J48=\"\",\"\",IF(I48>J48,\"W\",IF(I48<J48,\"L\",IF(I48=J48,\"D\")))))","v":""},null,null,{"$f":"IF(L48=\"\",\"\",IF(M48=\"\",\"\",IF(L48>M48,\"W\",IF(L48<M48,\"L\",IF(L48=M48,\"D\")))))","v":""},null,null,{"$f":"B48","v":" India"},{"$f":"SUM(S48+T48+U48)","v":2},{"$f":"IF(E48=\"W\",1,0)+IF(H48=\"W\",1,0)+IF(K48=\"W\",1,0)+IF(N48=\"W\",1,0)+L49","v":0},{"$f":"IF(E48=\"D\",1,0)+IF(H48=\"D\",1,0)+IF(K48=\"D\",1,0)+IF(N48=\"D\",1,0)+M49","v":0},{"$f":"IF(E48=\"L\",1,0)+IF(H48=\"L\",1,0)+IF(K48=\"L\",1,0)+IF(N48=\"L\",1,0)+N49","v":2},{"$f":"SUM(C48)+SUM(F48)+SUM(I48)+SUM(L48)+L50","v":1},{"$f":"SUM(D48)+SUM(G48)+SUM(J48)+SUM(M48)+M50","v":13},{"$f":"V48-W48","v":-12},{"$f":"S48*3+T48","v":0}]
[null,"W/D/L",{"$f":"IF(E45=\"L\",1,0)+IF(E46=\"L\",1,0)+IF(E47=\"L\",1,0)+IF(E48=\"L\",1,0)","v":1},{"$f":"IF(E45=\"D\",1,0)+IF(E46=\"D\",1,0)+IF(E47=\"D\",1,0)+IF(E48=\"D\",1,0)","v":0},{"$f":"IF(E45=\"W\",1,0)+IF(E46=\"W\",1,0)+IF(E47=\"W\",1,0)+IF(E48=\"W\",1,0)","v":0},{"$f":"IF(H45=\"L\",1,0)+IF(H46=\"L\",1,0)+IF(H47=\"L\",1,0)+IF(H48=\"L\",1,0)","v":0},{"$f":"IF(H45=\"D\",1,0)+IF(H46=\"D\",1,0)+IF(H47=\"D\",1,0)+IF(H48=\"D\",1,0)","v":0},{"$f":"IF(H45=\"W\",1,0)+IF(H46=\"W\",1,0)+IF(H47=\"W\",1,0)+IF(H48=\"W\",1,0)","v":1},{"$f":"IF(K45=\"L\",1,0)+IF(K46=\"L\",1,0)+IF(K47=\"L\",1,0)+IF(K48=\"L\",1,0)","v":0},{"$f":"IF(K45=\"D\",1,0)+IF(K46=\"D\",1,0)+IF(K47=\"D\",1,0)+IF(K48=\"D\",1,0)","v":0},{"$f":"IF(K45=\"W\",1,0)+IF(K46=\"W\",1,0)+IF(K47=\"W\",1,0)+IF(K48=\"W\",1,0)","v":1},{"$f":"IF(N45=\"L\",1,0)+IF(N46=\"L\",1,0)+IF(N47=\"L\",1,0)+IF(N48=\"L\",1,0)","v":0},{"$f":"IF(N45=\"D\",1,0)+IF(N46=\"D\",1,0)+IF(N47=\"D\",1,0)+IF(N48=\"D\",1,0)","v":0},{"$f":"IF(N45=\"W\",1,0)+IF(N46=\"W\",1,0)+IF(N47=\"W\",1,0)+IF(N48=\"W\",1,0)","v":1}]
[null,"F/A",{"$f":"SUM(D45)+SUM(D46)+SUM(D47)+SUM(D48)","v":11},{"$f":"SUM(C45)+SUM(C46)+SUM(C47)+SUM(C48)","v":0},null,{"$f":"SUM(G45)+SUM(G46)+SUM(G47)+SUM(G48)","v":0},{"$f":"SUM(F45)+SUM(F46)+SUM(F47)+SUM(F48)","v":2},null,{"$f":"SUM(J45)+SUM(J46)+SUM(J47)+SUM(J48)","v":0},{"$f":"SUM(I45)+SUM(I46)+SUM(I47)+SUM(I48)","v":1},null,{"$f":"SUM(M45)+SUM(M46)+SUM(M47)+SUM(M48)","v":1},{"$f":"SUM(L45)+SUM(L46)+SUM(L47)+SUM(L48)","v":2}]

{"sheet":"Ladders","index":2,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["      "]
[]
[]
[null,null,{"$f":"LaddersH!B4","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts",""]
[null,null,{"$f":"LaddersH!B5","v":"France"},{"$f":"LaddersH!C5","v":0},{"$f":"LaddersH!D5","v":0},{"$f":"LaddersH!E5","v":0},{"$f":"LaddersH!F5","v":0},{"$f":"LaddersH!G5","v":0},{"$f":"LaddersH!H5","v":0},{"$f":"LaddersH!I5","v":0},{"$f":"LaddersH!J5","v":0},""]
[null,null,{"$f":"LaddersH!B6","v":"USA"},{"$f":"LaddersH!C6","v":0},{"$f":"LaddersH!D6","v":0},{"$f":"LaddersH!E6","v":0},{"$f":"LaddersH!F6","v":0},{"$f":"LaddersH!G6","v":0},{"$f":"LaddersH!H6","v":0},{"$f":"LaddersH!I6","v":0},{"$f":"LaddersH!J6","v":0},""]
[null,null,{"$f":"LaddersH!B7","v":"Guinea"},{"$f":"LaddersH!C7","v":0},{"$f":"LaddersH!D7","v":0},{"$f":"LaddersH!E7","v":0},{"$f":"LaddersH!F7","v":0},{"$f":"LaddersH!G7","v":0},{"$f":"LaddersH!H7","v":0},{"$f":"LaddersH!I7","v":0},{"$f":"LaddersH!J7","v":0},""]
[null,null,{"$f":"LaddersH!B8","v":"New Zealand"},{"$f":"LaddersH!C8","v":0},{"$f":"LaddersH!D8","v":0},{"$f":"LaddersH!E8","v":0},{"$f":"LaddersH!F8","v":0},{"$f":"LaddersH!G8","v":0},{"$f":"LaddersH!H8","v":0},{"$f":"LaddersH!I8","v":0},{"$f":"LaddersH!J8","v":0}]
[null,"Men's",null,null,null,null,null,null,null,null,{"$f":"LaddersH!K9","v":"Ladder OK"}]
[]
[null,null,{"$f":"LaddersH!B11","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts",""]
[null,null,{"$f":"LaddersH!B12","v":"Ukraine"},{"$f":"LaddersH!C12","v":0},{"$f":"LaddersH!D12","v":0},{"$f":"LaddersH!E12","v":0},{"$f":"LaddersH!F12","v":0},{"$f":"LaddersH!G12","v":0},{"$f":"LaddersH!H12","v":0},{"$f":"LaddersH!I12","v":0},{"$f":"LaddersH!J12","v":0},""]
[null,null,{"$f":"LaddersH!B13","v":"Iraq"},{"$f":"LaddersH!C13","v":0},{"$f":"LaddersH!D13","v":0},{"$f":"LaddersH!E13","v":0},{"$f":"LaddersH!F13","v":0},{"$f":"LaddersH!G13","v":0},{"$f":"LaddersH!H13","v":0},{"$f":"LaddersH!I13","v":0},{"$f":"LaddersH!J13","v":0},""]
[null,null,{"$f":"LaddersH!B14","v":"Morocco"},{"$f":"LaddersH!C14","v":0},{"$f":"LaddersH!D14","v":0},{"$f":"LaddersH!E14","v":0},{"$f":"LaddersH!F14","v":0},{"$f":"LaddersH!G14","v":0},{"$f":"LaddersH!H14","v":0},{"$f":"LaddersH!I14","v":0},{"$f":"LaddersH!J14","v":0},""]
[null,null,{"$f":"LaddersH!B15","v":"Argentina"},{"$f":"LaddersH!C15","v":0},{"$f":"LaddersH!D15","v":0},{"$f":"LaddersH!E15","v":0},{"$f":"LaddersH!F15","v":0},{"$f":"LaddersH!G15","v":0},{"$f":"LaddersH!H15","v":0},{"$f":"LaddersH!I15","v":0},{"$f":"LaddersH!J15","v":0}]
[null,"Men's",null,null,null,null,null,null,null,null,{"$f":"LaddersH!K16","v":"Ladder OK"}]
[]
[null,null,{"$f":"LaddersH!B18","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts",""]
[null,null,{"$f":"LaddersH!B19","v":"Dominican Republic"},{"$f":"LaddersH!C19","v":0},{"$f":"LaddersH!D19","v":0},{"$f":"LaddersH!E19","v":0},{"$f":"LaddersH!F19","v":0},{"$f":"LaddersH!G19","v":0},{"$f":"LaddersH!H19","v":0},{"$f":"LaddersH!I19","v":0},{"$f":"LaddersH!J19","v":0},""]
[null,null,{"$f":"LaddersH!B20","v":"Egypt"},{"$f":"LaddersH!C20","v":0},{"$f":"LaddersH!D20","v":0},{"$f":"LaddersH!E20","v":0},{"$f":"LaddersH!F20","v":0},{"$f":"LaddersH!G20","v":0},{"$f":"LaddersH!H20","v":0},{"$f":"LaddersH!I20","v":0},{"$f":"LaddersH!J20","v":0},""]
[null,null,{"$f":"LaddersH!B21","v":"Spain"},{"$f":"LaddersH!C21","v":0},{"$f":"LaddersH!D21","v":0},{"$f":"LaddersH!E21","v":0},{"$f":"LaddersH!F21","v":0},{"$f":"LaddersH!G21","v":0},{"$f":"LaddersH!H21","v":0},{"$f":"LaddersH!I21","v":0},{"$f":"LaddersH!J21","v":0},""]
[null,null,{"$f":"LaddersH!B22","v":"Uzbekistan"},{"$f":"LaddersH!C22","v":0},{"$f":"LaddersH!D22","v":0},{"$f":"LaddersH!E22","v":0},{"$f":"LaddersH!F22","v":0},{"$f":"LaddersH!G22","v":0},{"$f":"LaddersH!H22","v":0},{"$f":"LaddersH!I22","v":0},{"$f":"LaddersH!J22","v":0}]
[null,"Men's",null,null,null,null,null,null,null,null,{"$f":"LaddersH!K23","v":"Ladder OK"}]
[]
[null,null,{"$f":"LaddersH!B25","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts",""]
[null,null,{"$f":"LaddersH!B26","v":"Israel"},{"$f":"LaddersH!C26","v":0},{"$f":"LaddersH!D26","v":0},{"$f":"LaddersH!E26","v":0},{"$f":"LaddersH!F26","v":0},{"$f":"LaddersH!G26","v":0},{"$f":"LaddersH!H26","v":0},{"$f":"LaddersH!I26","v":0},{"$f":"LaddersH!J26","v":0},""]
[null,null,{"$f":"LaddersH!B27","v":"Mali"},{"$f":"LaddersH!C27","v":0},{"$f":"LaddersH!D27","v":0},{"$f":"LaddersH!E27","v":0},{"$f":"LaddersH!F27","v":0},{"$f":"LaddersH!G27","v":0},{"$f":"LaddersH!H27","v":0},{"$f":"LaddersH!I27","v":0},{"$f":"LaddersH!J27","v":0},""]
[null,null,{"$f":"LaddersH!B28","v":"Paraguay"},{"$f":"LaddersH!C28","v":0},{"$f":"LaddersH!D28","v":0},{"$f":"LaddersH!E28","v":0},{"$f":"LaddersH!F28","v":0},{"$f":"LaddersH!G28","v":0},{"$f":"LaddersH!H28","v":0},{"$f":"LaddersH!I28","v":0},{"$f":"LaddersH!J28","v":0},""]
[null,null,{"$f":"LaddersH!B29","v":"Japan"},{"$f":"LaddersH!C29","v":0},{"$f":"LaddersH!D29","v":0},{"$f":"LaddersH!E29","v":0},{"$f":"LaddersH!F29","v":0},{"$f":"LaddersH!G29","v":0},{"$f":"LaddersH!H29","v":0},{"$f":"LaddersH!I29","v":0},{"$f":"LaddersH!J29","v":0}]
[null,"Men's",null,null,null,null,null,null,null,null,{"$f":"LaddersH!K30","v":"Ladder OK"}]
[]
[null,null,{"$f":"LaddersH!B32","v":"Final Ladder"},"P","W","D","L","F","A","GD","Pts",""]
[null,null,{"$f":"LaddersH!B33","v":"Korea Republic"},{"$f":"LaddersH!C33","v":3},{"$f":"LaddersH!D33","v":2},{"$f":"LaddersH!E33","v":1},{"$f":"LaddersH!F33","v":0},{"$f":"LaddersH!G33","v":9},{"$f":"LaddersH!H33","v":3},{"$f":"LaddersH!I33","v":6},{"$f":"LaddersH!J33","v":7},""]
[null,null,{"$f":"LaddersH!B34","v":"Australia"},{"$f":"LaddersH!C34","v":3},{"$f":"LaddersH!D34","v":2},{"$f":"LaddersH!E34","v":1},{"$f":"LaddersH!F34","v":0},{"$f":"LaddersH!G34","v":8},{"$f":"LaddersH!H34","v":3},{"$f":"LaddersH!I34","v":5},{"$f":"LaddersH!J34","v":7},""]
[null,null,{"$f":"LaddersH!B35","v":" Philippines"},{"$f":"LaddersH!C35","v":3},{"$f":"LaddersH!D35","v":1},{"$f":"LaddersH!E35","v":0},{"$f":"LaddersH!F35","v":2},{"$f":"LaddersH!G35","v":2},{"$f":"LaddersH!H35","v":4},{"$f":"LaddersH!I35","v":-2},{"$f":"LaddersH!J35","v":3}]
[null,null,{"$f":"LaddersH!B36","v":" Iran"},{"$f":"LaddersH!C36","v":3},{"$f":"LaddersH!D36","v":0},{"$f":"LaddersH!E36","v":0},{"$f":"LaddersH!F36","v":3},{"$f":"LaddersH!G36","v":0},{"$f":"LaddersH!H36","v":9},{"$f":"LaddersH!I36","v":-9},{"$f":"LaddersH!J36","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"LaddersH!K37","v":"Ladder OK"}]
[]
[null,null,{"$f":"LaddersH!B39","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts",""]
[null,null,{"$f":"LaddersH!B40","v":"DPR Korea"},{"$f":"LaddersH!C40","v":2},{"$f":"LaddersH!D40","v":2},{"$f":"LaddersH!E40","v":0},{"$f":"LaddersH!F40","v":0},{"$f":"LaddersH!G40","v":8},{"$f":"LaddersH!H40","v":0},{"$f":"LaddersH!I40","v":8},{"$f":"LaddersH!J40","v":6},""]
[null,null,{"$f":"LaddersH!B41","v":"China"},{"$f":"LaddersH!C41","v":2},{"$f":"LaddersH!D41","v":2},{"$f":"LaddersH!E41","v":0},{"$f":"LaddersH!F41","v":0},{"$f":"LaddersH!G41","v":5},{"$f":"LaddersH!H41","v":0},{"$f":"LaddersH!I41","v":5},{"$f":"LaddersH!J41","v":6},""]
[null,null,{"$f":"LaddersH!B42","v":" Uzbekistan"},{"$f":"LaddersH!C42","v":2},{"$f":"LaddersH!D42","v":0},{"$f":"LaddersH!E42","v":0},{"$f":"LaddersH!F42","v":2},{"$f":"LaddersH!G42","v":0},{"$f":"LaddersH!H42","v":6},{"$f":"LaddersH!I42","v":-6},{"$f":"LaddersH!J42","v":0}]
[null,null,{"$f":"LaddersH!B43","v":" Bangladesh"},{"$f":"LaddersH!C43","v":2},{"$f":"LaddersH!D43","v":0},{"$f":"LaddersH!E43","v":0},{"$f":"LaddersH!F43","v":2},{"$f":"LaddersH!G43","v":0},{"$f":"LaddersH!H43","v":7},{"$f":"LaddersH!I43","v":-7},{"$f":"LaddersH!J43","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"LaddersH!K44","v":"Ladder OK"}]
[]
[null,null,{"$f":"LaddersH!B46","v":"Incomplete"},"P","W","D","L","F","A","GD","Pts",""]
[null,null,{"$f":"LaddersH!B49","v":"Japan"},{"$f":"LaddersH!C49","v":2},{"$f":"LaddersH!D49","v":2},{"$f":"LaddersH!E49","v":0},{"$f":"LaddersH!F49","v":0},{"$f":"LaddersH!G49","v":13},{"$f":"LaddersH!H49","v":0},{"$f":"LaddersH!I49","v":13},{"$f":"LaddersH!J49","v":6},""]
[null,null,{"$f":"LaddersH!B50","v":"Vietnam"},{"$f":"LaddersH!C50","v":2},{"$f":"LaddersH!D50","v":1},{"$f":"LaddersH!E50","v":0},{"$f":"LaddersH!F50","v":1},{"$f":"LaddersH!G50","v":2},{"$f":"LaddersH!H50","v":2},{"$f":"LaddersH!I50","v":0},{"$f":"LaddersH!J50","v":3},""]
[null,null,{"$f":"LaddersH!B51","v":" Chinese Taipei"},{"$f":"LaddersH!C51","v":2},{"$f":"LaddersH!D51","v":1},{"$f":"LaddersH!E51","v":0},{"$f":"LaddersH!F51","v":1},{"$f":"LaddersH!G51","v":1},{"$f":"LaddersH!H51","v":2},{"$f":"LaddersH!I51","v":-1},{"$f":"LaddersH!J51","v":3},""]
[null,null,{"$f":"LaddersH!B52","v":" India"},{"$f":"LaddersH!C52","v":2},{"$f":"LaddersH!D52","v":0},{"$f":"LaddersH!E52","v":0},{"$f":"LaddersH!F52","v":2},{"$f":"LaddersH!G52","v":1},{"$f":"LaddersH!H52","v":13},{"$f":"LaddersH!I52","v":-12},{"$f":"LaddersH!J52","v":0},""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"LaddersH!K52","v":"Ladder OK"}]
[]
[null,null,{"$f":"LaddersH!B62","v":"Group/s Incomplete"},"P","W","D","L","F","A","GD","Pts"]
[null,null,{"$f":"LaddersH!B64","v":" Chinese Taipei"},{"$f":"LaddersH!C64","v":2},{"$f":"LaddersH!D64","v":1},{"$f":"LaddersH!E64","v":0},{"$f":"LaddersH!F64","v":1},{"$f":"LaddersH!G64","v":1},{"$f":"LaddersH!H64","v":2},{"$f":"LaddersH!I64","v":-1},{"$f":"LaddersH!J64","v":3},""]
[null,null,{"$f":"LaddersH!B65","v":" Philippines"},{"$f":"LaddersH!C65","v":3},{"$f":"LaddersH!D65","v":1},{"$f":"LaddersH!E65","v":0},{"$f":"LaddersH!F65","v":2},{"$f":"LaddersH!G65","v":2},{"$f":"LaddersH!H65","v":4},{"$f":"LaddersH!I65","v":-2},{"$f":"LaddersH!J65","v":3}]
[null,null,{"$f":"LaddersH!B66","v":" Uzbekistan"},{"$f":"LaddersH!C66","v":2},{"$f":"LaddersH!D66","v":0},{"$f":"LaddersH!E66","v":0},{"$f":"LaddersH!F66","v":2},{"$f":"LaddersH!G66","v":0},{"$f":"LaddersH!H66","v":6},{"$f":"LaddersH!I66","v":-6},{"$f":"LaddersH!J66","v":0}]
[null,null,"The seventh and eighth qualifiers for the Quarter-Finals will be the two best-ranked 3rd-Placed"]
[null,null,"teams.  Sort all Groups first, then sort here.",null,null,null,null,null,null,null,{"$f":"LaddersH!K67","v":"Sort Ladder"}]
[null,"Results System (c) McRopod Concepts 2025 - mcropod@mcropod.com.au"]

{"sheet":"Qualif","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"If Group Tables are Final and sorted, these have Qualified:"]
[null,{"$f":"Ladders!C4","v":"Incomplete"},"A1",{"$f":"LaddersH!B5","v":"France"}]
[null,{"$f":"Ladders!K9","v":"Ladder OK"},"A2",{"$f":"LaddersH!B6","v":"USA"}]
[null,{"$f":"Ladders!C11","v":"Incomplete"},"B1",{"$f":"LaddersH!B12","v":"Ukraine"}]
[null,{"$f":"Ladders!K16","v":"Ladder OK"},"B2",{"$f":"LaddersH!B13","v":"Iraq"}]
[null,{"$f":"Ladders!C18","v":"Incomplete"},"C1",{"$f":"LaddersH!B19","v":"Dominican Republic"}]
[null,{"$f":"Ladders!K23","v":"Ladder OK"},"C2",{"$f":"LaddersH!B20","v":"Egypt"}]
[null,{"$f":"Ladders!C25","v":"Incomplete"},"D1",{"$f":"LaddersH!B26","v":"Israel"}]
[null,{"$f":"Ladders!K30","v":"Ladder OK"},"D2",{"$f":"LaddersH!B27","v":"Mali"}]
[null,{"$f":"Ladders!C32","v":"Final Ladder"},"A1",{"$f":"LaddersH!B33","v":"Korea Republic"}]
[null,{"$f":"Ladders!K37","v":"Ladder OK"},"A2",{"$f":"LaddersH!B34","v":"Australia"}]
[null,{"$f":"Ladders!C46","v":"Incomplete"},"B1",{"$f":"LaddersH!B40","v":"DPR Korea"}]
[null,{"$f":"Ladders!K44","v":"Ladder OK"},"B2",{"$f":"LaddersH!B41","v":"China"}]
[null,{"$f":"Ladders!C46","v":"Incomplete"},"C1",{"$f":"LaddersH!B49","v":"Japan"}]
[null,{"$f":"Ladders!K51","v":"Ladder OK"},"C2",{"$f":"LaddersH!B50","v":"Vietnam"}]
[null,null,"G3",{"$f":"LaddersH!B48","v":"Thirds Steady"}]
[null,"Best 3rds","A/B/C3",{"$f":"LaddersH!B54","v":" Philippines"}]
[null,{"$f":"Ladders!K58","v":"Sort Ladder"},"A/B/C3",{"$f":"LaddersH!B55","v":" Uzbekistan"}]

{"sheet":"FinalsTop","index":4,"n_rows":18,"n_cols":21,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"McRopod!K1","v":"V1 281225"}]
[null,"Quarter-Finals: Fri - 2 August",null,null,null,null,null,"Semi-Finals: Mon - 5 August",null,null,null,null,null,"Final: Fri - 9 August"]
[]
[null,null,{"$f":"IF(Qualif!B3=\"Incomplete\",\"Winner Group A\",Qualif!D3)","v":"Winner Group A"}]
[null,25,"Bordeaux - 21:00h",null,{"$f":"IF(D6=\"\",\"\",IF(D4=D6,\"(Pens)\",\"\"))","v":""}]
[null,null,{"$f":"IF(Qualif!B5=\"Incomplete\",\"Runner-up Group B\",Qualif!D6)","v":"Runner-up Group B"},null,null,null,null,null,{"$f":"IF(D4=\"\",\"Winner Match 25\",IF(D6=\"\",\"Winner Match 25\",IF(D4>D6,C4,IF(D4<D6,C6,IF(AND(D4=D6,E6=\"\"),\"Winner Match 25\",IF(AND(D4=D6,E4>E6),C4,IF(AND(D4=D6,E4<E6),C6,\"There must be a winner!\")))))))","v":"Winner Match 25"}]
[null,null,null,null,null,null,null,29,"Lyon - 21:00h",null,{"$f":"IF(J8=\"\",\"\",IF(J6=J8,\"(Pens)\",\"\"))","v":""}]
[null,null,{"$f":"IF(Qualif!B7=\"Incomplete\",\"Winner Group C\",Qualif!D7)","v":"Winner Group C"},null,null,null,null,null,{"$f":"IF(D8=\"\",\"Winner Match 27\",IF(D10=\"\",\"Winner Match 27\",IF(D8>D10,C8,IF(D8<D10,C10,IF(AND(D8=D10,E10=\"\"),\"Winner Match 27\",IF(AND(D8=D10,E8>E10),C8,IF(AND(D8=D10,E8<E10),C10,\"There must be a winner!\")))))))","v":"Winner Match 27"}]
[null,27,"Marseille - 19:00h",null,{"$f":"IF(D10=\"\",\"\",IF(D8=D10,\"(Pens)\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"Winner Match 29\",IF(J6>J8,I6,IF(J6<J8,I8,IF(AND(J6=J8,K8=\"\"),\"Winner Match 29\",IF(AND(J6=J8,K6>K8),I6,IF(AND(J6=J8,K6<K8),I8,\"There must be a winner!\"))))))","v":"Winner Match 29"}]
[null,null,{"$f":"IF(Qualif!B9=\"Incomplete\",\"Runner-up Group D\",Qualif!D10)","v":"Runner-up Group D"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P10=\"\",\"\",\"Champions:\")","v":"Champions:"},null,{"$f":"IF(P13=\"\",\"Winner Match 32\",IF(P9>P13,O9,IF(P9<P13,O13,IF(AND(P9=P13,Q13=\"\"),\"Winner Match 32\",IF(AND(P9=P13,Q9>Q13),O9,IF(AND(P9=P13,Q9<Q13),O13,\"There must be a winner\"))))))","v":"Winner Match 32"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,32,"Paris - 18:00h"]
[null,null,{"$f":"IF(Qualif!B9=\"Incomplete\",\"Winner Group B\",Qualif!D5)","v":"Winner Group B"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P12=\"\",\"\",\"Runners-Up:\")","v":"Runners-Up:"},null,{"$f":"IF(P10=\"Winner Match 32\",\"Loser Match 32\",IF(P10=O9,O13,O9))","v":"Loser Match 32"}]
[null,26,"Paris - 15:00h",null,{"$f":"IF(D14=\"\",\"\",IF(D12=D14,\"(Pens)\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J16=\"\",\"Winner Match 30\",IF(J14>J16,I14,IF(J14<J16,I16,IF(AND(J14=J16,K16=\"\"),\"Winner Match 30\",IF(AND(J14=J16,K14>K16),I14,IF(AND(J14=J16,K14<K16),I16,\"There must be a winner!\"))))))","v":"Winner Match 30"}]
[null,null,{"$f":"IF(Qualif!B7=\"Incomplete\",\"Runner-up Group A\",Qualif!D4)","v":"Runner-up Group A"},null,null,null,null,null,{"$f":"IF(D12=\"\",\"Winner Match 26\",IF(D14=\"\",\"Winner Match 26\",IF(D12>D14,C12,IF(D12<D14,C14,IF(AND(D12=D14,E14=\"\"),\"Winner Match 26\",IF(AND(D12=D14,E12>E14),C12,IF(AND(D12=D14,E12<E14),C14,\"There must be a winner!\")))))))","v":"Winner Match 26"}]
[null,null,null,null,null,null,null,30,"Marseille - 18:00h",null,{"$f":"IF(J16=\"\",\"\",IF(J14=J16,\"(Pens)\",\"\"))","v":""},null,null,"Third-Place Play-Off: Thu - 8 August"]
[null,null,{"$f":"IF(Qualif!B5=\"Incomplete\",\"Winner Group D\",Qualif!D9)","v":"Winner Group D"},null,null,null,null,null,{"$f":"IF(D16=\"\",\"Winner Match 28\",IF(D18=\"\",\"Winner Match 28\",IF(D16>D18,C16,IF(D16<D18,C18,IF(AND(D16=D18,E18=\"\"),\"Winner Match 28\",IF(AND(D16=D18,E16>E18),C16,IF(AND(D16=D18,E16<E18),C18,\"There must be a winner!\")))))))","v":"Winner Match 28"},null,null,null,null,null,{"$f":"IF(J8=\"\",\"Loser Match 29\",IF(O9=I8,I6,I8))","v":"Loser Match 29"}]
[null,28,"Lyon - 17:00h",null,{"$f":"IF(D18=\"\",\"\",IF(D16=D18,\"(Pens)\",\"\"))","v":""},null,null,null,null,null,null,null,null,31,"Nantes - 17:00h"]
[null,null,{"$f":"IF(Qualif!B3=\"Incomplete\",\"Runner-up Group C\",Qualif!D8)","v":"Runner-up Group C"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"Loser Match 30\",IF(O11=I10,I8,I10))","v":"Loser Match 30"},null,null,null,null,null,{"$f":"IF(P16=\"\",\"\",IF(P18=\"\",\"\",IF(P16>P18,O16,IF(P16<P18,O18,IF(AND(P16=P18,Q18=\"\"),\"\",IF(AND(P16=P18,Q16>Q18),O16,IF(AND(P16=P18,Q16<Q18),O18,\"There must be a winner!\")))))))","v":""}]

{"sheet":"FinalsBottom","index":5,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V1 2106"]
[null,"Quarter-Finals: 13 to 15 March",null,null,null,null,null,"Semi-Finals: 17 & 18 Mar",null,null,null,null,null,"Final: 21 March"]
[]
[null,null,{"$f":"IF(Qualif!B13=\"Incomplete\",\"Winner Group B\",Qualif!D13)","v":"Winner Group B"}]
[null,20,"Perth Sat-14 Mar at 19:00h",null,{"$f":"IF(D6=\"\",\"\",IF(D4=D6,\"(Pens)\",\"\"))","v":""}]
[null,null,{"$f":"IF(Qualif!B15=\"Incomplete\",\"Runner-up Group C\",Qualif!D16)","v":"Runner-up Group C"},null,null,null,null,null,{"$f":"IF(D4=\"\",\"Winner Match 20\",IF(D6=\"\",\"Winner Match 20\",IF(D4>D6,C4,IF(D4<D6,C6,IF(AND(D4=D6,E6=\"\"),\"Winner Match 20\",IF(AND(D4=D6,E4>E6),C4,IF(AND(D4=D6,E4<E6),C6,\"Winner Match 20\")))))))","v":"Winner Match 20"}]
[null,null,null,null,null,null,null,23,"Perth Tue 17-Mar at 19:00h",null,{"$f":"IF(J8=\"\",\"\",IF(J6=J8,\"(Pens)\",\"\"))","v":""}]
[null,null,{"$f":"IF(Qualif!B15=\"Incomplete\",\"Runner-up Group A\",Qualif!D15)","v":"Runner-up Group A"},null,null,null,null,null,{"$f":"IF(D8=\"\",\"Winner Match 19\",IF(D10=\"\",\"Winner Match 19\",IF(D8>D10,C8,IF(D8<D10,C10,IF(AND(D8=D10,E10=\"\"),\"Winner Match 19\",IF(AND(D8=D10,E8>E10),C8,IF(AND(D8=D10,E8<E10),C10,\"Winner Match 19\")))))))","v":"Winner Match 19"}]
[null,19,"Perth Fri-13 Mar at 18:00h",null,{"$f":"IF(D10=\"\",\"\",IF(D8=D10,\"(Pens)\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"Winner Match 23\",IF(J6>J8,I6,IF(J6<J8,I8,IF(AND(J6=J8,K8=\"\"),\"Winner Match 23\",IF(AND(J6=J8,K6>K8),I6,IF(AND(J6=J8,K6<K8),I8,\"There must be a winner!\"))))))","v":"Winner Match 23"}]
[null,null,{"$f":"IF(Qualif!B13=\"Incomplete\",\"Runner-up Group B\",Qualif!D14)","v":"Runner-up Group B"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P10=\"\",\"\",\"Champions:\")","v":""},null,{"$f":"IF(P13=\"\",\"\",IF(P9>P13,O9,IF(P9<P13,O13,IF(AND(P9=P13,Q13=\"\"),\"\",IF(AND(P9=P13,Q9>Q13),O9,IF(AND(P9=P13,Q9<Q13),O13,\"There must be a winner\"))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27,"Sydney Sat-21 Mar at 20:00h"]
[null,null,{"$f":"IF(Qualif!B11=\"Incomplete\",\"Winner Group A\",Qualif!D12)","v":"Australia"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P12=\"\",\"\",\"Runners-Up:\")","v":""},null,{"$f":"IF(P10=\"\",\"\",IF(P10=O9,O13,O9))","v":""}]
[null,21,"Sydney Sat-14 Mar at 20:00h",null,{"$f":"IF(D14=\"\",\"\",IF(D12=D14,\"(Pens)\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J16=\"\",\"Winner Match 24\",IF(J14>J16,I14,IF(J14<J16,I16,IF(AND(J14=J16,K16=\"\"),\"Winner Match 24\",IF(AND(J14=J16,K14>K16),I14,IF(AND(J14=J16,K14<K16),I16,\"There must be a winner!\"))))))","v":"Winner Match 24"}]
[null,null,"(Third Place (B/C)",null,null,null,null,null,{"$f":"IF(D12=\"\",\"Winner Match 21\",IF(D14=\"\",\"Winner Match 21\",IF(D12>D14,C12,IF(D12<D14,C14,IF(AND(D12=D14,E14=\"\"),\"Winner Match 21\",IF(AND(D12=D14,E12>E14),C12,IF(AND(D12=D14,E12<E14),C14,\"Winner Match 21\")))))))","v":"Winner Match 21"}]
[null,null,null,null,null,null,null,24,"Sydney Wed 17-Mar at 20:00h",null,{"$f":"IF(J16=\"\",\"\",IF(J14=J16,\"(Pens)\",\"\"))","v":""},null,null,"Play-off 1 (Oly Games ranking)"]
[null,null,{"$f":"IF(Qualif!B15=\"Incomplete\",\"Winner Group C\",Qualif!D15)","v":"Winner Group C"},null,null,null,null,null,{"$f":"IF(D16=\"\",\"Winner Match 22\",IF(D18=\"\",\"Winner Match 22\",IF(D16>D18,C16,IF(D16<D18,C18,IF(AND(D16=D18,E18=\"\"),\"Winner Match 22\",IF(AND(D16=D18,E16>E18),C16,IF(AND(D16=D18,E16<E18),C18,\"There must be a winner!\")))))))","v":"Winner Match 22"},null,null,null,null,null,{"$f":"IF(D14=\"\",\"Loser Match 21\",IF(I14=C12,C14,IF(I14=C14,C12,\"Loser Match 21\")))","v":"Loser Match 21"}]
[null,22,"Sydney Sun-15 Mar at 18:00h",null,{"$f":"IF(D18=\"\",\"\",IF(D16=D18,\"(Pens)\",\"\"))","v":""},null,null,null,null,null,null,null,null,25,"Gold Coast - Thu 15 Mar at 1300h"]
[null,null,"(Third Place (A/B)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D18=\"\",\"Loser Match 22\",IF(I16=C18,C16,IF(I16=C16,C18,\"Loser Match 22\")))","v":"Loser Match 22"},null,null,null,null,null,{"$f":"IF(P16=\"\",\"\",IF(P18=\"\",\"\",IF(P16>P18,O16,IF(P16<P18,O18,IF(AND(P16=P18,Q18=\"\"),\"\",IF(AND(P16=P18,Q16>Q18),O16,IF(AND(P16=P18,Q16<Q18),O18,\"There must be a winner!\")))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Play-off 2 (Oly Games ranking)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D6=\"\",\"Loser Match 20\",IF(I6=C4,C6,IF(I6=C6,C4,\"Loser Match 20\")))","v":"Loser Match 20"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,26,"Gold Coast - Thu 15 Mar at 19:00h"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D10=\"\",\"Loser Match 19\",IF(I8=C10,C8,IF(I8=C8,C10,\"Loser Match 19\")))","v":"Loser Match 19"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Note:  oddly, the published AFC tournament program"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"does not have a traditional Third-Place playoff game,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"but does have what seems to be a 5 v 6 and a 7 v 8."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If this 3PPO game does get include in the schedule"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"I will add it to this McRopod Sports System as a V2."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The two Oly Games playoff games are to find the"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fourth to sixth AFC qualification places."]

{"sheet":"Final","index":6,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Honours Board Men",null,null,null,"Honours Board Women"]
[null,null,"Gold",{"$f":"IF(FinalsTop!$P$9=\"\",\"Winner Match 32\",FinalsTop!$P$10)","v":"Winner Match 32"},null,null,"Gold",{"$f":"IF(FinalsBottom!$P$10=\"\",\"Winner Match 26\",FinalsBottom!$P$10)","v":"Winner Match 26"}]
[null,null,"Silver",{"$f":"IF(FinalsTop!$P$10=\"\",\"Loser Match 32\",FinalsTop!$P$12)","v":"Loser Match 32"},null,null,"Silver",{"$f":"IF(FinalsBottom!$P$12=\"\",\"Loser Match 26\",FinalsBottom!$P$12)","v":"Loser Match 26"}]
[null,null,"Bronze",{"$f":"IF(FinalsTop!$P$16>FinalsTop!$P$18,FinalsTop!$O$16,IF(FinalsTop!$P$18>FinalsTop!$P$16,FinalsTop!$O$18,IF(FinalsTop!$P$16=\"\",\"Winner Match 31\")))","v":"Winner Match 31"},null,null,"Bronze",{"$f":"IF(FinalsBottom!$P$16>FinalsBottom!$P$18,FinalsBottom!$O$16,IF(FinalsBottom!$P$18>FinalsBottom!$P$16,FinalsBottom!$O$18,IF(FinalsBottom!$P$15=\"\",\"Winner Match 24\")))","v":"Winner Match 24"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">"]

{"sheet":"McRopod","index":7,"n_rows":113,"n_cols":11,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"V1 281225"]
[]
[null,"Welcome to the McRopod Concepts' Women's AFC Championship 2026 Sports System."]
[]
[null,"I'm sure you'll have fun with this.  Use it to predict what will happen, and use it to keep tabs with what does happen."]
[null,"By entering a result - actual or predicted - everything else is calculated for you: which teams qualify"]
[null,"and which depart, which teams advance, which go home, and which teams get the medals."]
[]
[null,"Before you do anything else - let's maximise the image!  Go to <View>, then select <Full Screen>.  If you want"]
[null,"to return to your normal screen layout afterwards, 'all you have to do is select <View>, and then <Full Screen> again."]
[]
[]
[null,"Instructions for use"]
[]
[null,"First Stage - Group Fixtures"]
[]
[null,"Go to the <First Stage> page.  There you’ll see all of the fixtures comprising the Group phase for the tournament.."]
[null,"The three Groups are A, B, C."]
[]
[null,"The fixtures are shown by Group.  You’ll need to scroll down to see all the Groups’ fixtures."]
[]
[null,"There are spaces for you to input the scores of a fixture.  You’ll need to make sure that only a whole positive number"]
[null,"or a blank appears in these cells.  If anything else appears you'll get an error flag in the system: <######> for example."]
[]
[null,"If ever this happens, check to make sure that you have not input something other than a whole positive number"]
[null,"or a blank.  If it’s not clear where you have input something else into a Group’s results cells, delete that Group’s"]
[null,"results and start again. "]
[]
[null,"Sorting the Group Tables"]
[]
[null,"After inputting the results of a Group, press the <Sort> button for that Group.  You’ll instantly be taken to that"]
[null,"Group’s Table, which will be correctly sorted. "]
[]
[null,"You can go back to the <First Stage> page by pressing the button at the top of the <Ladders> page."]
[]
[null,"You can re-order a Group Table when Points, Goal Difference, and Goals For are equal between two or"]
[null,"more teams, and the Table sort is not the way FIFA has it."]
[]
[null,"In most cases these three criteria will separate teams into their correct order.  However where they are equal,"]
[null,"and where a fourth or subsequent criterion comes into play, the McRopod Concepts Olympic Games 2000 Sport System’s"]
[null,"standard automatic sort function is unable to take that into account."]
[]
[null,"Eventually, it may even come down to a ballot between the sides.  Whichever way is used to split any"]
[null,"teams equal on these three criteria, the McRopod Sports System will be able to ensure your Tables take this into"]
[null,"account."]
[]
[null,"Because all of these can’t be loaded into the McRopod Concepts Olympic Games 2012 Sports System without asking"]
[null,"you to keep track of far too much detail, the system:"]
[null,"·    flags whenever there are two teams in a Group with exactly the same record,"]
[null,"·    lets you know which teams these are, and"]
[null,"·    asks if you want to swap their order."]
[]
[null,"There are three buttons in the far right column of each Group Table, headed <Swap?>.  The buttons are"]
[null,"labelled < 2 > 1 >, < 3 > 2 >, and < 4 > 3 > respectively.  When you press < 2 > 1 >, the team ranked second"]
[null,"swaps places with the first ranked team."]
[]
[null,"A message appears letting you know whenever such a tie has occurred, which positions are affected,"]
[null,"and inviting you to swap these two teams.  You will only need to swap when the Group Table ranking"]
[null,"is incorrect because of the fourth or subsequent criteria."]
[]
[null,"If you see a <No> under the <Swap?> heading in a Group Table, the Table is correct and should be left"]
[null,"as it is.  Although you could re-arrange the Group rankings by doing this swap,  if you do, it’ll be out of order."]
[null,"You can correct it by pressing the <Sort> button for that Group."]
[]
[null,"After all the games of a Group have been played, that Group Table lets you know it is the Final Table."]
[]
[null,"Until each of the Group Tables are finalised, the elimination phase games are not confirmed."]
[]
[null,"The Second Stage - Elimination Round"]
[]
[null,"Eight of the 16 teams advance to the Second Phase - an elimination series.  The Group winners and"]
[null,"runners-up automatically qualify.  So too, do two of the three Women's Third-placed teams."]
[]
[null,"Once a Group’s games have all been played, and subject only to any swapping needed to separate tied teams"]
[null,"on the fourth criterion, those teams which are confirmed as having advanced to the Second Stage"]
[null,"can be seen on the <Qualified> page.  You can get there from any other page by pressing the <Qualified> button."]
[null,"They are also added to their Second Stage position in the draw at that time.  You'll also need to sort the Women's Third-placed teams."]
[]
[null,"The Second Stage matches can be seen by pressing the <2nd Stage> button. "]
[]
[null,"When you enter a full-time score (or full-time plus extra-time where extra-time has been played)"]
[null,"in the first set of yellow cells, the McRopod Concepts Women's AFC Champioship Sports System detects if "]
[null,"there has been a winner, advances that team to the next round, and farewells the loser."]
[null,"  "]
[null,"If you input a score that means the match is a draw, the match is then determined on a penalty shoot-out."]
[null,"The second set of yellow cells is for the penalties.  As there must be a winner this way, one team has to advance."]
[]
[null,"By progressively entering scores in the Elimination tree, you’ll get to the Final."]
[]
[null,"There are spaces for you to input the scores of a fixture.  You’ll need to make sure that only a whole positive number"]
[null,"or a blank appears in these cells.  If anything else appears you'll get an error flag in the system: <######> for example."]
[]
[null,"If ever this happens, check to make sure that you have not input something other than a whole positive number"]
[null,"or a blank.  If it’s not clear where you have input something else into the cells, press that page’s <Clear All Scores>"]
[null,"button and start again. "]
[null,""]
[null,"Enter the Final and third-place game scores and the McRopod Concepts Olympic Games 2024 Sports System"]
[null,"will tell you the medallists."]
[]
[null,"OK?  So head on off now to the <First Stage> Group Fixtures page, and get cracking :-)"]
[]
[null,"Need a Sports System for a League you are running?"]
[]
[null,"McRopod Concepts can design a Sports System for a League you are running, or a tournament you organise."]
[null,"McRopod Concepts can also design a Sports System for a League or Tournament you are following.  "]
[]
[null,"If you'd like to have a Sports System designed, email <mcropod@mcropod.com.au>."]
[]
[]
[]
[]
[null,"Alan Clark"]
[null,"McRopod Concepts"]

{"sheet":"LaddersH","index":8,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,{"$f":"Grid!Q2","v":"Incomplete"},{"$f":"Grid!$R$2","v":"P"},{"$f":"Grid!$S$2","v":"W"},{"$f":"Grid!$T$2","v":"D"},{"$f":"Grid!$U$2","v":"L"},{"$f":"Grid!$V$2","v":"F"},{"$f":"Grid!$W$2","v":"A"},{"$f":"Grid!$X$2","v":"GD"},{"$f":"Grid!$Y$2","v":"Pts"},null,"PtsX","Pts+GDX","PtsGD+F"]
["A",{"$f":"Grid!$Q$5","v":"France"},{"$f":"Grid!$R$5","v":0},{"$f":"Grid!$S$5","v":0},{"$f":"Grid!$T$5","v":0},{"$f":"Grid!$U$5","v":0},{"$f":"Grid!$V$5","v":0},{"$f":"Grid!$W$5","v":0},{"$f":"Grid!$X$5","v":0},{"$f":"Grid!$Y$5","v":0},null,{"$f":"IF(J5<J6,1,0)","v":0},{"$f":"IF(AND(J5=J6,I5<I6),1,0)","v":0},{"$f":"IF(AND(M5<>0,G5>G6),1,0)","v":0}]
[null,{"$f":"Grid!$Q$6","v":"USA"},{"$f":"Grid!$R$6","v":0},{"$f":"Grid!$S$6","v":0},{"$f":"Grid!$T$6","v":0},{"$f":"Grid!$U$6","v":0},{"$f":"Grid!$V$6","v":0},{"$f":"Grid!$W$6","v":0},{"$f":"Grid!$X$6","v":0},{"$f":"Grid!$Y$6","v":0},null,{"$f":"IF(J6<J7,1,0)","v":0},{"$f":"IF(AND(J6=J7,I6<I7),1,0)","v":0},{"$f":"IF(AND(M6<>0,G6>G7),1,0)","v":0}]
[null,{"$f":"Grid!$Q$3","v":"Guinea"},{"$f":"Grid!$R$3","v":0},{"$f":"Grid!$S$3","v":0},{"$f":"Grid!$T$3","v":0},{"$f":"Grid!$U$3","v":0},{"$f":"Grid!$V$3","v":0},{"$f":"Grid!$W$3","v":0},{"$f":"Grid!$X$3","v":0},{"$f":"Grid!$Y$3","v":0},null,{"$f":"IF(J7<J8,1,0)","v":0},{"$f":"IF(AND(J7=J8,I7<I8),1,0)","v":0},{"$f":"IF(AND(M7<>0,G7>G8),1,0)","v":0}]
[null,{"$f":"Grid!$Q$4","v":"New Zealand"},{"$f":"Grid!$R$4","v":0},{"$f":"Grid!$S$4","v":0},{"$f":"Grid!$T$4","v":0},{"$f":"Grid!$U$4","v":0},{"$f":"Grid!$V$4","v":0},{"$f":"Grid!$W$4","v":0},{"$f":"Grid!$X$4","v":0},{"$f":"Grid!$Y$4","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L9)+SUM(M9)+SUM(N9)<>0,\"Sort Ladder\",\"Ladder OK\")","v":"Ladder OK"},{"$f":"(SUM(L5)+SUM(L6)+SUM(L7))","v":0},{"$f":"(SUM(M5)+SUM(M6)+SUM(M7))","v":0},{"$f":"(SUM(N5)+SUM(N6)+SUM(N7))","v":0}]
[]
[null,{"$f":"Grid!Q9","v":"Incomplete"},{"$f":"Grid!$R$9","v":"P"},{"$f":"Grid!$S$9","v":"W"},{"$f":"Grid!$T$9","v":"D"},{"$f":"Grid!$U$9","v":"L"},{"$f":"Grid!$V$9","v":"F"},{"$f":"Grid!$W$9","v":"A"},{"$f":"Grid!$X$9","v":"GD"},{"$f":"Grid!$Y$9","v":"Pts"},null,"PtsX","Pts+GDX","PtsGD+F"]
["B",{"$f":"Grid!$Q$12","v":"Ukraine"},{"$f":"Grid!$R$12","v":0},{"$f":"Grid!$S$12","v":0},{"$f":"Grid!$T$12","v":0},{"$f":"Grid!$U$12","v":0},{"$f":"Grid!$V$12","v":0},{"$f":"Grid!$W$12","v":0},{"$f":"Grid!$X$12","v":0},{"$f":"Grid!$Y$12","v":0},null,{"$f":"IF(J12<J13,1,0)","v":0},{"$f":"IF(AND(J12=J13,I12<I13),1,0)","v":0},{"$f":"IF(AND(M12<>0,G12>G13),1,0)","v":0}]
[null,{"$f":"Grid!$Q$11","v":"Iraq"},{"$f":"Grid!$R$11","v":0},{"$f":"Grid!$S$11","v":0},{"$f":"Grid!$T$11","v":0},{"$f":"Grid!$U$11","v":0},{"$f":"Grid!$V$11","v":0},{"$f":"Grid!$W$11","v":0},{"$f":"Grid!$X$11","v":0},{"$f":"Grid!$Y$11","v":0},null,{"$f":"IF(J13<J14,1,0)","v":0},{"$f":"IF(AND(J13=J14,I13<I14),1,0)","v":0},{"$f":"IF(AND(M13<>0,G13>G14),1,0)","v":0}]
[null,{"$f":"Grid!$Q$13","v":"Morocco"},{"$f":"Grid!$R$13","v":0},{"$f":"Grid!$S$13","v":0},{"$f":"Grid!$T$13","v":0},{"$f":"Grid!$U$13","v":0},{"$f":"Grid!$V$13","v":0},{"$f":"Grid!$W$13","v":0},{"$f":"Grid!$X$13","v":0},{"$f":"Grid!$Y$13","v":0},null,{"$f":"IF(J14<J15,1,0)","v":0},{"$f":"IF(AND(J14=J15,I14<I15),1,0)","v":0},{"$f":"IF(AND(M14<>0,G14>G15),1,0)","v":0}]
[null,{"$f":"Grid!$Q$10","v":"Argentina"},{"$f":"Grid!$R$10","v":0},{"$f":"Grid!$S$10","v":0},{"$f":"Grid!$T$10","v":0},{"$f":"Grid!$U$10","v":0},{"$f":"Grid!$V$10","v":0},{"$f":"Grid!$W$10","v":0},{"$f":"Grid!$X$10","v":0},{"$f":"Grid!$Y$10","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L16)+SUM(M16)+SUM(N16)<>0,\"Sort Ladder\",\"Ladder OK\")","v":"Ladder OK"},{"$f":"(SUM(L12)+SUM(L13)+SUM(L14))","v":0},{"$f":"(SUM(M12)+SUM(M13)+SUM(M14))","v":0},{"$f":"(SUM(N12)+SUM(N13)+SUM(N14))","v":0}]
[]
[null,{"$f":"Grid!Q16","v":"Incomplete"},{"$f":"Grid!$R$16","v":"P"},{"$f":"Grid!$S$16","v":"W"},{"$f":"Grid!$T$16","v":"D"},{"$f":"Grid!$U$16","v":"L"},{"$f":"Grid!$V$16","v":"F"},{"$f":"Grid!$W$16","v":"A"},{"$f":"Grid!$X$16","v":"GD"},{"$f":"Grid!$Y$16","v":"Pts"},null,"PtsX","Pts+GDX","PtsGD+F"]
["C",{"$f":"Grid!$Q$20","v":"Dominican Republic"},{"$f":"Grid!$R$20","v":0},{"$f":"Grid!$S$20","v":0},{"$f":"Grid!$T$20","v":0},{"$f":"Grid!$U$20","v":0},{"$f":"Grid!$V$20","v":0},{"$f":"Grid!$W$20","v":0},{"$f":"Grid!$X$20","v":0},{"$f":"Grid!$Y$20","v":0},null,{"$f":"IF(J19<J20,1,0)","v":0},{"$f":"IF(AND(J19=J20,I19<I20),1,0)","v":0},{"$f":"IF(AND(M19<>0,G19>G20),1,0)","v":0}]
[null,{"$f":"Grid!$Q$19","v":"Egypt"},{"$f":"Grid!$R$19","v":0},{"$f":"Grid!$S$19","v":0},{"$f":"Grid!$T$19","v":0},{"$f":"Grid!$U$19","v":0},{"$f":"Grid!$V$19","v":0},{"$f":"Grid!$W$19","v":0},{"$f":"Grid!$X$19","v":0},{"$f":"Grid!$Y$19","v":0},null,{"$f":"IF(J20<J21,1,0)","v":0},{"$f":"IF(AND(J20=J21,I20<I21),1,0)","v":0},{"$f":"IF(AND(M20<>0,G20>G21),1,0)","v":0}]
[null,{"$f":"Grid!$Q$18","v":"Spain"},{"$f":"Grid!$R$18","v":0},{"$f":"Grid!$S$18","v":0},{"$f":"Grid!$T$18","v":0},{"$f":"Grid!$U$18","v":0},{"$f":"Grid!$V$18","v":0},{"$f":"Grid!$W$18","v":0},{"$f":"Grid!$X$18","v":0},{"$f":"Grid!$Y$18","v":0},null,{"$f":"IF(J21<J22,1,0)","v":0},{"$f":"IF(AND(J21=J22,I21<I22),1,0)","v":0},{"$f":"IF(AND(M21<>0,G21>G22),1,0)","v":0}]
[null,{"$f":"Grid!$Q$17","v":"Uzbekistan"},{"$f":"Grid!$R$17","v":0},{"$f":"Grid!$S$17","v":0},{"$f":"Grid!$T$17","v":0},{"$f":"Grid!$U$17","v":0},{"$f":"Grid!$V$17","v":0},{"$f":"Grid!$W$17","v":0},{"$f":"Grid!$X$17","v":0},{"$f":"Grid!$Y$17","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L23)+SUM(M23)+SUM(N23)<>0,\"Sort Ladder\",\"Ladder OK\")","v":"Ladder OK"},{"$f":"(SUM(L19)+SUM(L20)+SUM(L21))","v":0},{"$f":"(SUM(M19)+SUM(M20)+SUM(M21))","v":0},{"$f":"(SUM(N19)+SUM(N20)+SUM(N21))","v":0}]
[]
[null,{"$f":"Grid!Q23","v":"Incomplete"},{"$f":"Grid!$R$23","v":"P"},{"$f":"Grid!$S$23","v":"W"},{"$f":"Grid!$T$23","v":"D"},{"$f":"Grid!$U$23","v":"L"},{"$f":"Grid!$V$23","v":"F"},{"$f":"Grid!$W$23","v":"A"},{"$f":"Grid!$X$23","v":"GD"},{"$f":"Grid!$Y$23","v":"Pts"},null,"PtsX","Pts+GDX","PtsGD+F"]
["D",{"$f":"Grid!$Q$27","v":"Israel"},{"$f":"Grid!$R$27","v":0},{"$f":"Grid!$S$27","v":0},{"$f":"Grid!$T$27","v":0},{"$f":"Grid!$U$27","v":0},{"$f":"Grid!$V$27","v":0},{"$f":"Grid!$W$27","v":0},{"$f":"Grid!$X$27","v":0},{"$f":"Grid!$Y$27","v":0},null,{"$f":"IF(J26<J27,1,0)","v":0},{"$f":"IF(AND(J26=J27,I26<I27),1,0)","v":0},{"$f":"IF(AND(M26<>0,G26>G27),1,0)","v":0}]
[null,{"$f":"Grid!$Q$26","v":"Mali"},{"$f":"Grid!$R$26","v":0},{"$f":"Grid!$S$26","v":0},{"$f":"Grid!$T$26","v":0},{"$f":"Grid!$U$26","v":0},{"$f":"Grid!$V$26","v":0},{"$f":"Grid!$W$26","v":0},{"$f":"Grid!$X$26","v":0},{"$f":"Grid!$Y$26","v":0},null,{"$f":"IF(J27<J28,1,0)","v":0},{"$f":"IF(AND(J27=J28,I27<I28),1,0)","v":0},{"$f":"IF(AND(M27<>0,G27>G28),1,0)","v":0}]
[null,{"$f":"Grid!$Q$25","v":"Paraguay"},{"$f":"Grid!$R$25","v":0},{"$f":"Grid!$S$25","v":0},{"$f":"Grid!$T$25","v":0},{"$f":"Grid!$U$25","v":0},{"$f":"Grid!$V$25","v":0},{"$f":"Grid!$W$25","v":0},{"$f":"Grid!$X$25","v":0},{"$f":"Grid!$Y$25","v":0},null,{"$f":"IF(J28<J29,1,0)","v":0},{"$f":"IF(AND(J28=J29,I28<I29),1,0)","v":0},{"$f":"IF(AND(M28<>0,G28>G29),1,0)","v":0}]
[null,{"$f":"Grid!$Q$24","v":"Japan"},{"$f":"Grid!$R$24","v":0},{"$f":"Grid!$S$24","v":0},{"$f":"Grid!$T$24","v":0},{"$f":"Grid!$U$24","v":0},{"$f":"Grid!$V$24","v":0},{"$f":"Grid!$W$24","v":0},{"$f":"Grid!$X$24","v":0},{"$f":"Grid!$Y$24","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L30)+SUM(M30)+SUM(N30)<>0,\"Sort Ladder\",\"Ladder OK\")","v":"Ladder OK"},{"$f":"(SUM(L26)+SUM(L27)+SUM(L28))","v":0},{"$f":"(SUM(M26)+SUM(M27)+SUM(M28))","v":0},{"$f":"(SUM(N26)+SUM(N27)+SUM(N28))","v":0}]
[]
[null,{"$f":"Grid!Q30","v":"Final Ladder"},{"$f":"Grid!$R$30","v":"P"},{"$f":"Grid!$S$30","v":"W"},{"$f":"Grid!$T$30","v":"D"},{"$f":"Grid!$U$30","v":"L"},{"$f":"Grid!$V$30","v":"F"},{"$f":"Grid!$W$30","v":"A"},{"$f":"Grid!$X$30","v":"GD"},{"$f":"Grid!$Y$30","v":"Pts"},null,"PtsX","Pts+GDX","PtsGD+F"]
["E",{"$f":"Grid!$Q$33","v":"Korea Republic"},{"$f":"Grid!$R$33","v":3},{"$f":"Grid!$S$33","v":2},{"$f":"Grid!$T$33","v":1},{"$f":"Grid!$U$33","v":0},{"$f":"Grid!$V$33","v":9},{"$f":"Grid!$W$33","v":3},{"$f":"Grid!$X$33","v":6},{"$f":"Grid!$Y$33","v":7},null,{"$f":"IF(J33<J34,1,0)","v":0},{"$f":"IF(AND(J33=J34,I33<I34),1,0)","v":0},{"$f":"IF(AND(M33<>0,G33>G34),1,0)","v":0}]
[null,{"$f":"Grid!$Q$31","v":"Australia"},{"$f":"Grid!$R$31","v":3},{"$f":"Grid!$S$31","v":2},{"$f":"Grid!$T$31","v":1},{"$f":"Grid!$U$31","v":0},{"$f":"Grid!$V$31","v":8},{"$f":"Grid!$W$31","v":3},{"$f":"Grid!$X$31","v":5},{"$f":"Grid!$Y$31","v":7},null,{"$f":"IF(J34<J35,1,0)","v":0},{"$f":"IF(AND(J34=J35,I34<I35),1,0)","v":0},{"$f":"IF(AND(M34<>0,G34>G35),1,0)","v":0}]
[null,{"$f":"Grid!$Q$32","v":" Philippines"},{"$f":"Grid!$R$32","v":3},{"$f":"Grid!$S$32","v":1},{"$f":"Grid!$T$32","v":0},{"$f":"Grid!$U$32","v":2},{"$f":"Grid!$V$32","v":2},{"$f":"Grid!$W$32","v":4},{"$f":"Grid!$X$32","v":-2},{"$f":"Grid!$Y$32","v":3},null,{"$f":"IF(J35<J36,1,0)","v":0},{"$f":"IF(AND(J35=J36,I35<I36),1,0)","v":0},{"$f":"IF(AND(M35<>0,G35>G36),1,0)","v":0}]
[null,{"$f":"Grid!$Q$34","v":" Iran"},{"$f":"Grid!$R$34","v":3},{"$f":"Grid!$S$34","v":0},{"$f":"Grid!$T$34","v":0},{"$f":"Grid!$U$34","v":3},{"$f":"Grid!$V$34","v":0},{"$f":"Grid!$W$34","v":9},{"$f":"Grid!$X$34","v":-9},{"$f":"Grid!$Y$34","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L37)+SUM(M37)+SUM(N37)<>0,\"Sort Ladder\",\"Ladder OK\")","v":"Ladder OK"},{"$f":"(SUM(L33)+SUM(L34)+SUM(L35))","v":0},{"$f":"(SUM(M33)+SUM(M34)+SUM(M35))","v":0},{"$f":"(SUM(N33)+SUM(N34)+SUM(N35))","v":0}]
[]
[null,{"$f":"Grid!Q37","v":"Incomplete"},{"$f":"Grid!$R$37","v":"P"},{"$f":"Grid!$S$37","v":"W"},{"$f":"Grid!$T$37","v":"D"},{"$f":"Grid!$U$37","v":"L"},{"$f":"Grid!$V$37","v":"F"},{"$f":"Grid!$W$37","v":"A"},{"$f":"Grid!$X$37","v":"GD"},{"$f":"Grid!$Y$37","v":"Pts"},null,"PtsX","Pts+GDX","PtsGD+F"]
["F",{"$f":"Grid!$Q$38","v":"DPR Korea"},{"$f":"Grid!$R$38","v":2},{"$f":"Grid!$S$38","v":2},{"$f":"Grid!$T$38","v":0},{"$f":"Grid!$U$38","v":0},{"$f":"Grid!$V$38","v":8},{"$f":"Grid!$W$38","v":0},{"$f":"Grid!$X$38","v":8},{"$f":"Grid!$Y$38","v":6},null,{"$f":"IF(J40<J41,1,0)","v":0},{"$f":"IF(AND(J40=J41,I40<I41),1,0)","v":0},{"$f":"IF(AND(M40<>0,G40>G41),1,0)","v":0}]
[null,{"$f":"Grid!$Q$40","v":"China"},{"$f":"Grid!$R$40","v":2},{"$f":"Grid!$S$40","v":2},{"$f":"Grid!$T$40","v":0},{"$f":"Grid!$U$40","v":0},{"$f":"Grid!$V$40","v":5},{"$f":"Grid!$W$40","v":0},{"$f":"Grid!$X$40","v":5},{"$f":"Grid!$Y$40","v":6},null,{"$f":"IF(J41<J42,1,0)","v":0},{"$f":"IF(AND(J41=J42,I41<I42),1,0)","v":0},{"$f":"IF(AND(M41<>0,G41>G42),1,0)","v":0}]
[null,{"$f":"Grid!$Q$39","v":" Uzbekistan"},{"$f":"Grid!$R$39","v":2},{"$f":"Grid!$S$39","v":0},{"$f":"Grid!$T$39","v":0},{"$f":"Grid!$U$39","v":2},{"$f":"Grid!$V$39","v":0},{"$f":"Grid!$W$39","v":6},{"$f":"Grid!$X$39","v":-6},{"$f":"Grid!$Y$39","v":0},null,{"$f":"IF(J42<J43,1,0)","v":0},{"$f":"IF(AND(J42=J43,I42<I43),1,0)","v":0},{"$f":"IF(AND(M42<>0,G42>G43),1,0)","v":0}]
[null,{"$f":"Grid!$Q$41","v":" Bangladesh"},{"$f":"Grid!$R$41","v":2},{"$f":"Grid!$S$41","v":0},{"$f":"Grid!$T$41","v":0},{"$f":"Grid!$U$41","v":2},{"$f":"Grid!$V$41","v":0},{"$f":"Grid!$W$41","v":7},{"$f":"Grid!$X$41","v":-7},{"$f":"Grid!$Y$41","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L44)+SUM(M44)+SUM(N44)<>0,\"Sort Ladder\",\"Ladder OK\")","v":"Ladder OK"},{"$f":"(SUM(L40)+SUM(L41)+SUM(L42))","v":0},{"$f":"(SUM(M40)+SUM(M41)+SUM(M42))","v":0},{"$f":"(SUM(N40)+SUM(N41)+SUM(N42))","v":0}]
[]
[null,{"$f":"Grid!Q44","v":"Incomplete"},{"$f":"Grid!$R$44","v":"P"},{"$f":"Grid!$S$44","v":"W"},{"$f":"Grid!$T$44","v":"D"},{"$f":"Grid!$U$44","v":"L"},{"$f":"Grid!$V$44","v":"F"},{"$f":"Grid!$W$44","v":"A"},{"$f":"Grid!$X$44","v":"GD"},{"$f":"Grid!$Y$44","v":"Pts"},null,"PtsX","Pts+GDX","PtsGD+F"]
["G",null,{"$f":"Grid!$R$44","v":"P"},{"$f":"Grid!$S$44","v":"W"},{"$f":"Grid!$T$44","v":"D"},{"$f":"Grid!$U$44","v":"L"},{"$f":"Grid!$V$44","v":"F"},{"$f":"Grid!$W$44","v":"A"},{"$f":"Grid!$X$44","v":"GD"},{"$f":"Grid!$Y$44","v":"Pts"},null,"PtsX","Pts+GDX","PtsGD+F"]
[null,"Thirds Steady","P","W","D","L","F","A","GD","Pts",null,{"$f":"IF(J48<J49,1,0)","v":0},{"$f":"IF(AND(J48=J49,I48<I49),1,0)","v":0},{"$f":"IF(AND(M48<>0,G48>G49),1,0)","v":0}]
[null,{"$f":"Grid!$Q$45","v":"Japan"},{"$f":"Grid!$R$45","v":2},{"$f":"Grid!$S$45","v":2},{"$f":"Grid!$T$45","v":0},{"$f":"Grid!$U$45","v":0},{"$f":"Grid!$V$45","v":13},{"$f":"Grid!$W$45","v":0},{"$f":"Grid!$X$45","v":13},{"$f":"Grid!$Y$45","v":6},null,{"$f":"IF(J49<J50,1,0)","v":0},{"$f":"IF(AND(J49=J50,I49<I50),1,0)","v":0},{"$f":"IF(AND(M49<>0,G49>G50),1,0)","v":0}]
[null,{"$f":"Grid!$Q$47","v":"Vietnam"},{"$f":"Grid!$R$47","v":2},{"$f":"Grid!$S$47","v":1},{"$f":"Grid!$T$47","v":0},{"$f":"Grid!$U$47","v":1},{"$f":"Grid!$V$47","v":2},{"$f":"Grid!$W$47","v":2},{"$f":"Grid!$X$47","v":0},{"$f":"Grid!$Y$47","v":3},null,{"$f":"IF(J50<J51,1,0)","v":0},{"$f":"IF(AND(J50=J51,I50<I51),1,0)","v":0},{"$f":"IF(AND(M50<>0,G50>G51),1,0)","v":0}]
[null,{"$f":"Grid!$Q$46","v":" Chinese Taipei"},{"$f":"Grid!$R$46","v":2},{"$f":"Grid!$S$46","v":1},{"$f":"Grid!$T$46","v":0},{"$f":"Grid!$U$46","v":1},{"$f":"Grid!$V$46","v":1},{"$f":"Grid!$W$46","v":2},{"$f":"Grid!$X$46","v":-1},{"$f":"Grid!$Y$46","v":3}]
[null,{"$f":"Grid!$Q$48","v":" India"},{"$f":"Grid!$R$48","v":2},{"$f":"Grid!$S$48","v":0},{"$f":"Grid!$T$48","v":0},{"$f":"Grid!$U$48","v":2},{"$f":"Grid!$V$48","v":1},{"$f":"Grid!$W$48","v":13},{"$f":"Grid!$X$48","v":-12},{"$f":"Grid!$Y$48","v":0},{"$f":"IF(SUM(L52)+SUM(M52)+SUM(N52)<>0,\"Sort Ladder\",\"Ladder OK\")","v":"Ladder OK"},{"$f":"(SUM(L48)+SUM(L49)+SUM(L50))","v":0},{"$f":"(SUM(M48)+SUM(M49)+SUM(M50))","v":0},{"$f":"(SUM(N48)+SUM(N49)+SUM(N50))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"PtsX","Pts+GDX","PtsGD+F"]
[null,{"$f":"B35","v":" Philippines"},{"$f":"C35","v":3},1,0,2,2,4,-2,3,null,{"$f":"IF(J54<J55,1,0)","v":0},{"$f":"IF(AND(J54=J55,I54<I55),1,0)","v":0},{"$f":"IF(AND(M54<>0,G54>G55),1,0)","v":0}]
[null,{"$f":"B42","v":" Uzbekistan"},{"$f":"C42","v":2},0,0,2,0,6,-6,0,null,{"$f":"IF(J55<J56,1,0)","v":1},{"$f":"IF(AND(J55=J56,I55<I56),1,0)","v":0},{"$f":"IF(AND(M55<>0,G55>G56),1,0)","v":0}]
[null,{"$f":"B51","v":" Chinese Taipei"},{"$f":"C51","v":2},1,0,1,1,2,-1,3,null,{"$f":"IF(J56<J57,1,0)","v":0},{"$f":"IF(AND(J56=J57,I56<I57),1,0)","v":0},{"$f":"IF(AND(M56<>0,G56>G57),1,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L58)+SUM(M58)+SUM(N58)<>0,\"Sort Ladder\",\"Ladder OK\")","v":"Sort Ladder"},{"$f":"(SUM(L54)+SUM(L55)+SUM(L56))","v":1},{"$f":"(SUM(M54)+SUM(M55)+SUM(M56))","v":0},{"$f":"(SUM(N54)+SUM(N55)+SUM(N56))","v":0}]
[]
[]
[null,{"$f":"IF(B39=\"Incomplete\",1,0)+IF(B46=\"Incomplete\",1,0)+IF(B46=\"Incomplete\",1,0)","v":3}]
[null,{"$f":"IF(B61>0,\"Group/s Incomplete\",\"Final Ladder\")","v":"Group/s Incomplete"},null,null,null,null,null,null,null,null,null,"PtsX","Pts+GDX","PtsGD+F"]
[null,"Thirds",{"$f":"Grid!$R$44","v":"P"},{"$f":"Grid!$S$44","v":"W"},{"$f":"Grid!$T$44","v":"D"},{"$f":"Grid!$U$44","v":"L"},{"$f":"Grid!$V$44","v":"F"},{"$f":"Grid!$W$44","v":"A"},{"$f":"Grid!$X$44","v":"GD"},{"$f":"Grid!$Y$44","v":"Pts"},null,{"$f":"IF(J63<J64,1,0)","v":0},{"$f":"IF(AND(J63=J64,I63<I64),1,0)","v":0},{"$f":"IF(AND(M63=0,G63<G64),1,0)","v":0}]
[null,{"$f":"$B$56","v":" Chinese Taipei"},{"$f":"$C$56","v":2},{"$f":"$D$56","v":1},{"$f":"$E$56","v":0},{"$f":"$F$56","v":1},{"$f":"$G$56","v":1},{"$f":"$H$56","v":2},{"$f":"$I$56","v":-1},{"$f":"$J$56","v":3},null,{"$f":"IF(J64<J65,1,0)","v":0},{"$f":"IF(AND(J64=J65,I64<I65),1,0)","v":0},{"$f":"IF(AND(M64=0,G64<G65),1,0)","v":1}]
[null,{"$f":"$B$54","v":" Philippines"},{"$f":"$C$54","v":3},{"$f":"$D$54","v":1},{"$f":"$E$54","v":0},{"$f":"$F$54","v":2},{"$f":"$G$54","v":2},{"$f":"$H$54","v":4},{"$f":"$I$54","v":-2},{"$f":"$J$54","v":3},null,{"$f":"IF(J65<J66,1,0)","v":0},{"$f":"IF(AND(J65=J66,I65<I66),1,0)","v":0},{"$f":"IF(AND(M65=0,G65<G66),1,0)","v":0}]
[null,{"$f":"$B$55","v":" Uzbekistan"},{"$f":"$C$55","v":2},{"$f":"$D$55","v":0},{"$f":"$E$55","v":0},{"$f":"$F$55","v":2},{"$f":"$G$55","v":0},{"$f":"$H$55","v":6},{"$f":"$I$55","v":-6},{"$f":"$J$55","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L67)+SUM(M67)+SUM(N67)<>0,\"Sort Ladder\",\"Ladder OK\")","v":"Sort Ladder"},{"$f":"(SUM(L63)+SUM(L64)+SUM(L65))","v":0},{"$f":"(SUM(M63)+SUM(M64)+SUM(M65))","v":0},{"$f":"(SUM(N63)+SUM(N64)+SUM(N65))","v":1}]