{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Round 1","Round 2","calculation","text"],"not_rendered":{"images":2,"external_links":1,"defined_names":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Round 1","index":0,"n_rows":68,"n_cols":18,"rows_kept":68,"merged":[[0,0,0,17],[2,0,2,17],[5,0,5,17],[6,14,6,16],[11,10,12,17],[13,0,13,17],[14,14,14,16],[19,10,20,17],[21,0,21,17],[22,14,22,16],[27,10,28,17],[29,0,29,17],[30,14,30,16],[35,10,36,17],[37,0,37,17],[38,14,38,16],[43,10,44,17],[45,0,45,17],[46,14,46,16],[51,10,52,17],[53,0,53,17],[54,14,54,16],[59,10,60,17],[61,0,61,17],[62,14,62,16],[67,10,68,17]],"flags":["formulas_cached_only"]}
["2006 World Cup tracker"]
[]
["ROUND 1"]
[]
["Match","Date","Venue"]
["GROUP A"]
[1,"2006-06-09","Munich","Germany",":","Costa Rica",4,":",2,null,false,"A","M","Pts","Goals",null,null,"GD"]
[2,"2006-06-09","Gelsenkirchen","Poland",":","Ecuador",0,":",2,1,1,"Germany",3,9,8,":",2,6]
[17,"2006-06-14","Dortmund","Germany",":","Poland",1,":",0,2,2,"Ecuador",3,6,4,":",3,1]
[18,"2006-06-15","Hamburg","Ecuador",":","Costa Rica",2,":",0,3,3,"Poland",3,3,2,":",4,-2]
[33,"2006-06-20","Berlin","Ecuador",":","Germany",0,":",3,4,4,"Costa Rica",3,0,3,":",8,-5]
[34,"2006-06-20","Hanover","Costa Rica",":","Poland",1,":",2,null,""]
[]
["GROUP B"]
[3,"2006-06-10","Frankfurt","England",":","Paraguay",1,":",0,null,false,"B","M","Pts","Goals",null,null,"GD"]
[4,"2006-06-10","Dortmund","Trinidad and Tobago",":","Sweden",0,":",0,1,1,"England",3,7,5,":",2,3]
[19,"2006-06-15","Nuremberg","England",":","Trinidad and Tobago",2,":",0,2,2,"Sweden",3,5,3,":",2,1]
[20,"2006-06-15","Berlin","Sweden",":","Paraguay",1,":",0,3,3,"Paraguay",3,3,2,":",2,0]
[35,"2006-06-20","Cologne","Sweden",":","England",2,":",2,4,4,"Trinidad and Tobago",3,1,0,":",4,-4]
[36,"2006-06-20","Kaiserslautern","Paraguay",":","Trinidad and Tobago",2,":",0,null,""]
[]
["GROUP C"]
[5,"2006-06-10","Hamburg","Argentina",":","Cote d'Ivoire",2,":",1,null,false,"C","M","Pts","Goals",null,null,"GD"]
[6,"2006-06-11","Leipzig","Serbia and Montenegro",":","Netherlands",0,":",1,1,1,"Argentina",3,7,9,":",2,7]
[21,"2006-06-16","Gelsenkirchen","Argentina",":","Serbia and Montenegro",6,":",0,2,2,"Netherlands",3,7,4,":",2,2]
[22,"2006-06-16","Stuttgart","Netherlands",":","Cote d'Ivoire",2,":",1,3,3,"Serbia and Montenegro",3,3,1,":",7,-6]
[37,"2006-06-21","Frankfurt","Netherlands",":","Argentina",1,":",1,4,4,"Cote d'Ivoire",3,0,2,":",5,-3]
[38,"2006-06-21","Munich","Cote d'Ivoire",":","Serbia and Montenegro",0,":",1,null,""]
[]
["GROUP D"]
[7,"2006-06-11","Nuremberg","Mexico",":","Iran",3,":",1,null,false,"D","M","Pts","Goals",null,null,"GD"]
[8,"2006-06-11","Cologne","Angola",":","Portugal",0,":",1,1,1,"Portugal",3,9,5,":",1,4]
[23,"2006-06-16","Hanover","Mexico",":","Angola",0,":",0,2,2,"Mexico",3,4,4,":",3,1]
[24,"2006-06-17","Frankfurt","Portugal",":","Iran",2,":",0,3,3,"Angola",3,2,1,":",2,-1]
[39,"2006-06-21","Gelsenkirchen","Portugal",":","Mexico",2,":",1,4,4,"Iran",3,1,2,":",6,-4]
[40,"2006-06-21","Leipzig","Iran",":","Angola",1,":",1,null,""]
[]
["GROUP E"]
[9,"2006-06-12","Hanover","Italy",":","Ghana",2,":",0,null,false,"E","M","Pts","Goals",null,null,"GD"]
[10,"2006-06-12","Gelsenkirchen","USA",":","Czech Republic",0,":",3,1,1,"Italy",3,7,5,":",1,4]
[25,"2006-06-17","Kaiserslautern","Italy",":","USA",1,":",1,2,2,"Ghana",3,6,4,":",3,1]
[26,"2006-06-17","Cologne","Czech Republic",":","Ghana",0,":",2,3,3,"Czech Republic",3,3,3,":",4,-1]
[41,"2006-06-22","Hamburg","Czech Republic",":","Italy",0,":",2,4,4,"USA",3,1,2,":",6,-4]
[42,"2006-06-22","Nuremberg","Ghana",":","USA",2,":",1,null,""]
[]
["GROUP F"]
[11,"2006-06-13","Berlin","Brazil",":","Croatia",3,":",1,null,false,"F","M","Pts","Goals",null,null,"GD"]
[12,"2006-06-12","Kaiserslautern","Australia",":","Japan",1,":",0,1,1,"Brazil",3,9,9,":",2,7]
[27,"2006-06-18","Munich","Brazil",":","Australia",2,":",0,2,2,"Australia",3,4,3,":",4,-1]
[28,"2006-06-18","Nuremberg","Japan",":","Croatia",0,":",0,3,3,"Croatia",3,2,3,":",5,-2]
[43,"2006-06-22","Dortmund","Japan",":","Brazil",1,":",4,4,4,"Japan",3,1,1,":",5,-4]
[44,"2006-06-22","Stuttgart","Croatia",":","Australia",2,":",2,null,""]
[]
["GROUP G"]
[13,"2006-06-13","Stuttgart","France",":","Switzerland",0,":",0,null,false,"G","M","Pts","Goals",null,null,"GD"]
[14,"2006-06-13","Frankfurt","Korea Republic",":","Togo",2,":",1,1,1,"Switzerland",3,7,3,":",0,3]
[29,"2006-06-18","Leipzig","France",":","Korea Republic",1,":",1,2,2,"France",3,5,3,":",1,2]
[30,"2006-06-19","Dortmund","Togo",":","Switzerland",0,":",2,3,3,"Korea Republic",3,4,3,":",3,0]
[45,"2006-06-23","Cologne","Togo",":","France",0,":",2,4,4,"Togo",3,0,1,":",6,-5]
[46,"2006-06-23","Hanover","Switzerland",":","Korea Republic",1,":",0,null,""]
[]
["GROUP H"]
[15,"2006-06-14","Leipzig","Spain",":","Ukraine",4,":",0,null,false,"H","M","Pts","Goals",null,null,"GD"]
[16,"2006-06-14","Munich","Tunisia",":","Saudi Arabia",2,":",2,1,1,"Spain",3,9,8,":",0,8]
[31,"2006-06-19","Stuttgart","Spain",":","Tunisia",2,":",0,2,2,"Ukraine",3,4,6,":",6,0]
[32,"2006-06-19","Hamburg","Saudi Arabia",":","Ukraine",0,":",4,3,3,"Tunisia",3,2,4,":",6,-2]
[47,"2006-06-23","Kaiserslautern","Saudi Arabia",":","Spain",0,":",2,4,4,"Saudi Arabia",3,1,2,":",8,-6]
[48,"2006-06-23","Berlin","Ukraine",":","Tunisia",2,":",2,null,""]

{"sheet":"Round 2","index":1,"n_rows":34,"n_cols":8,"rows_kept":34,"merged":[[0,0,0,7],[2,0,2,7],[5,0,5,7],[15,0,15,7],[21,0,21,7],[25,0,25,7],[28,0,28,7],[31,0,32,7],[33,0,34,7]],"flags":["formulas_cached_only"]}
["2006 World Cup tracker"]
[]
["ROUND 2"]
[]
["Match","Date","Venue"]
["ROUND OF 16"]
[49,"2006-06-24","Munich","Germany",2,":",0,"Sweden"]
[50,"2006-06-24","Leipzig","Argentina",2,":",1,"Mexico"]
[51,"2006-06-25","Stuttgart","England",1,":",0,"Ecuador"]
[52,"2006-06-25","Nuremberg","Portugal",1,":",0,"Netherlands"]
[53,"2006-06-26","Kaiserslautern","Italy",1,":",0,"Australia"]
[54,"2006-06-26","Cologne","Switzerland",0,":",1,"Ukraine"]
[55,"2006-06-27","Dortmund","Brazil",3,":",0,"Ghana"]
[56,"2006-06-27","Hanover","Spain",1,":",3,"France"]
[]
["QUARTER-FINALS"]
[57,"2006-06-30","Berlin","Germany",4,":",1,"Argentina"]
[58,"2006-06-30","Hamburg","Italy",null,":",null,"Ukraine"]
[59,"2006-07-01","Gelsenkirchen","England",null,":",null,"Portugal"]
[60,"2006-07-01","Frankfurt","Brazil",null,":",null,"France"]
[]
["SEMI-FINALS"]
[61,"2006-07-04","Dortmund","Germany",null,":",null,"Winner Match 58"]
[62,"2006-07-05","Munich","Winner Match 59",null,":",null,"Winner Match 60"]
[]
["THIRD PLACE"]
[63,"2006-07-08","Stuttgart","Runner-up Match 61",null,":",null,"Runner-up Match 62"]
[]
["FINAL"]
[64,"2006-07-09","Berlin","Winner Match 61",null,":",null,"Winner Match 62"]
[]
["WORLD CUP CHAMPION"]
[]
[""]

{"sheet":"calculation","index":2,"n_rows":66,"n_cols":58,"rows_kept":66,"merged":[[0,0,0,3],[0,6,0,10],[0,13,0,17],[2,43,2,45],[2,50,2,52],[2,54,2,56],[3,43,3,45],[3,50,3,52],[3,54,3,56],[10,43,10,45],[10,50,10,52],[10,54,10,56],[11,43,11,45],[11,50,11,52],[11,54,11,56],[18,43,18,45],[18,50,18,52],[18,54,18,56],[19,43,19,45],[19,50,19,52],[19,54,19,56],[26,43,26,45],[26,50,26,52],[26,54,26,56],[27,43,27,45],[27,50,27,52],[27,54,27,56],[34,43,34,45],[34,50,34,52],[34,54,34,56],[35,43,35,45],[35,50,35,52],[35,54,35,56],[42,43,42,45],[42,50,42,52],[42,54,42,56],[43,43,43,45],[43,50,43,52],[43,54,43,56],[50,43,50,45],[50,50,50,52],[50,54,50,56],[51,43,51,45],[51,50,51,52],[51,54,51,56],[58,43,58,45],[58,50,58,52],[58,54,58,56],[59,43,59,45],[59,50,59,52],[59,54,59,56],[66,43,66,45],[66,50,66,52],[66,54,66,56]],"flags":["formulas_cached_only"]}
["Match results",{"$nulls":5},"Goals",{"$nulls":6},"Points",{"$nulls":7},"Table in original group order",{"$nulls":7},"Final rank",{"$nulls":7},"Tie case 2 or 4",{"$nulls":4},"Tie case 3",{"$nulls":6},"Ranking in groups"]
[{"$nulls":43},"Points","Goal difference","Goals forward","tie score"]
[{"$nulls":32},"combined score: 10000*Pts+100*GD+GF","teams with equal score",{"$nulls":3},"direct opp. with same score","points against direct opp.","tie score",null,null,"team not in tie","against teams in tie",{"$nulls":5},"total score","sort teams",null,null,"rank","clear or draw lots?"]
["GROUP A"]
["Germany",4,2,"Costa Rica",null,null,17,"GER","CRC","POL","ECU",null,null,18,"GER","CRC","POL","ECU",{"$nulls":4},"M","Pts","GF","GA","GD",{"$nulls":15},1]
["Poland",0,2,"Ecuador",null,null,"GER",null,4,1,3,null,null,"GER",null,3,3,3,null,null,1,"Germany",3,9,8,2,6,null,null,1,null,null,90608,1,"x",null,null,1,0,{"v":0,"d":"0.00000"},{"$nulls":3},9,6,8,{"v":0,"d":"0.00000"},null,null,{"v":90608,"d":"90608.00000"},1,1,1,1,1,"x",1]
["Germany",1,0,"Poland",null,null,"CRC",2,null,1,0,null,null,"CRC",0,null,0,0,null,null,2,"Costa Rica",3,0,3,8,-5,null,null,4,null,null,-497,1,"x",null,null,2,0,{"v":0,"d":"0.00000"},{"$nulls":3},0,-3,1,{"v":0,"d":"0.00000"},null,null,{"v":-497,"d":"-497.00000"},2,3,4,4,1,"x",4]
["Ecuador",2,0,"Costa Rica",null,null,"POL",0,2,null,0,null,null,"POL",0,3,null,0,null,null,3,"Poland",3,3,2,4,-2,null,null,3,null,null,29802,1,"x",null,null,3,0,{"v":0,"d":"0.00000"},{"$nulls":3},3,-1,2,{"v":0,"d":"0.00000"},null,null,{"v":29802,"d":"29802.00000"},4,4,3,3,1,"x",3]
["Ecuador",0,3,"Germany",null,null,"ECU",0,2,2,{"$nulls":3},"ECU",0,3,3,{"$nulls":3},4,"Ecuador",3,6,4,3,1,null,null,2,null,null,60104,1,"x",null,null,4,0,{"v":0,"d":"0.00000"},{"$nulls":3},6,4,4,{"v":0,"d":"0.00000"},null,null,{"v":60104,"d":"60104.00000"},3,2,2,2,1,"x",2]
["Costa Rica",1,2,"Poland",{"$nulls":17},"matches complete?",true,{"$nulls":6},"ranking clear",null,null,"tie case",1,{"$nulls":21},4,10,"ranking clear"]
[]
["GROUP B"]
["England",1,0,"Paraguay",null,null,10,"ENG","PAR","TRI","SWE",null,null,16,"ENG","PAR","TRI","SWE",{"$nulls":4},"M","Pts","GF","GA","GD",{"$nulls":15},1]
["Trinidad and Tobago",0,0,"Sweden",null,null,"ENG",null,1,2,2,null,null,"ENG",null,3,3,1,null,null,1,"England",3,7,5,2,3,null,null,1,null,null,70305,1,"x",null,null,1,0,{"v":0,"d":"0.00000"},{"$nulls":3},7,3,5,{"v":0,"d":"0.00000"},null,null,{"v":70305,"d":"70305.00000"},1,1,1,1,1,"x",1]
["England",2,0,"Trinidad and Tobago",null,null,"PAR",0,null,2,0,null,null,"PAR",0,null,3,0,null,null,2,"Paraguay",3,3,2,2,0,null,null,3,null,null,30002,1,"x",null,null,2,0,{"v":0,"d":"0.00000"},{"$nulls":3},3,1,2,{"v":0,"d":"0.00000"},null,null,{"v":30002,"d":"30002.00000"},2,2,4,3,1,"x",3]
["Sweden",1,0,"Paraguay",null,null,"TRI",0,0,null,0,null,null,"TRI",0,0,null,1,null,null,3,"Trinidad and Tobago",3,1,0,4,-4,null,null,4,null,null,9600,1,"x",null,null,3,0,{"v":0,"d":"0.00000"},{"$nulls":3},1,-2,0,{"v":0,"d":"0.00000"},null,null,{"v":9600,"d":"9600.00000"},4,4,2,4,1,"x",4]
["Sweden",2,2,"England",null,null,"SWE",2,1,0,{"$nulls":3},"SWE",1,3,1,{"$nulls":3},4,"Sweden",3,5,3,2,1,null,null,2,null,null,50103,1,"x",null,null,4,0,{"v":0,"d":"0.00000"},{"$nulls":3},4,1,1,{"v":0,"d":"0.00000"},null,null,{"v":50103,"d":"50103.00000"},3,3,3,2,1,"x",2]
["Paraguay",2,0,"Trinidad and Tobago",{"$nulls":17},"matches complete?",true,{"$nulls":6},"ranking clear",null,null,"tie case",1,{"$nulls":21},4,10,"ranking clear"]
[]
["GROUP C"]
["Argentina",2,1,"Cote d'Ivoire",null,null,16,"ARG","CIV","SCG","NED",null,null,17,"ARG","CIV","SCG","NED",{"$nulls":4},"M","Pts","GF","GA","GD",{"$nulls":15},1]
["Serbia and Montenegro",0,1,"Netherlands",null,null,"ARG",null,2,6,1,null,null,"ARG",null,3,3,1,null,null,1,"Argentina",3,7,9,2,7,null,null,1,null,null,70709,1,"x",null,null,1,0,{"v":0,"d":"0.00000"},{"$nulls":3},7,7,9,{"v":0,"d":"0.00000"},null,null,{"v":70709,"d":"70709.00000"},1,1,1,1,1,"x",1]
["Argentina",6,0,"Serbia and Montenegro",null,null,"CIV",1,null,0,1,null,null,"CIV",0,null,0,0,null,null,2,"Cote d'Ivoire",3,0,2,5,-3,null,null,4,null,null,-298,1,"x",null,null,2,0,{"v":0,"d":"0.00000"},{"$nulls":3},0,-2,1,{"v":0,"d":"0.00000"},null,null,{"v":-298,"d":"-298.00000"},2,3,4,4,1,"x",4]
["Netherlands",2,1,"Cote d'Ivoire",null,null,"SCG",0,1,null,0,null,null,"SCG",0,3,null,0,null,null,3,"Serbia and Montenegro",3,3,1,7,-6,null,null,3,null,null,29401,1,"x",null,null,3,0,{"v":0,"d":"0.00000"},{"$nulls":3},3,0,1,{"v":0,"d":"0.00000"},null,null,{"v":29401,"d":"29401.00000"},4,4,3,3,1,"x",3]
["Netherlands",1,1,"Argentina",null,null,"NED",1,2,1,{"$nulls":3},"NED",1,3,3,{"$nulls":3},4,"Netherlands",3,7,4,2,2,null,null,2,null,null,70204,1,"x",null,null,4,0,{"v":0,"d":"0.00000"},{"$nulls":3},6,2,3,{"v":0,"d":"0.00000"},null,null,{"v":70204,"d":"70204.00000"},3,2,2,2,1,"x",2]
["Cote d'Ivoire",0,1,"Serbia and Montenegro",{"$nulls":17},"matches complete?",true,{"$nulls":6},"ranking clear",null,null,"tie case",1,{"$nulls":21},4,10,"ranking clear"]
[]
["GROUP D"]
["Mexico",3,1,"Iran",null,null,12,"MEX","IRN","ANG","POR",null,null,16,"MEX","IRN","ANG","POR",{"$nulls":4},"M","Pts","GF","GA","GD",{"$nulls":15},1]
["Angola",0,1,"Portugal",null,null,"MEX",null,3,0,1,null,null,"MEX",null,3,1,0,null,null,1,"Mexico",3,4,4,3,1,null,null,2,null,null,40104,1,"x",null,null,1,0,{"v":0,"d":"0.00000"},{"$nulls":3},4,1,4,{"v":0,"d":"0.00000"},null,null,{"v":40104,"d":"40104.00000"},1,4,4,2,1,"x",2]
["Mexico",0,0,"Angola",null,null,"IRN",1,null,1,0,null,null,"IRN",0,null,1,0,null,null,2,"Iran",3,1,2,6,-4,null,null,4,null,null,9602,1,"x",null,null,2,0,{"v":0,"d":"0.00000"},{"$nulls":3},1,-2,1,{"v":0,"d":"0.00000"},null,null,{"v":9602,"d":"9602.00000"},2,3,1,4,1,"x",4]
["Portugal",2,0,"Iran",null,null,"ANG",0,1,null,0,null,null,"ANG",1,1,null,0,null,null,3,"Angola",3,2,1,2,-1,null,null,3,null,null,19901,1,"x",null,null,3,0,{"v":0,"d":"0.00000"},{"$nulls":3},1,-1,1,{"v":0,"d":"0.00000"},null,null,{"v":19901,"d":"19901.00000"},4,1,3,3,1,"x",3]
["Portugal",2,1,"Mexico",null,null,"POR",2,2,1,{"$nulls":3},"POR",3,3,3,{"$nulls":3},4,"Portugal",3,9,5,1,4,null,null,1,null,null,90405,1,"x",null,null,4,0,{"v":0,"d":"0.00000"},{"$nulls":3},6,3,3,{"v":0,"d":"0.00000"},null,null,{"v":90405,"d":"90405.00000"},3,2,2,1,1,"x",1]
["Iran",1,1,"Angola",{"$nulls":17},"matches complete?",true,{"$nulls":6},"ranking clear",null,null,"tie case",1,{"$nulls":21},4,10,"ranking clear"]
[]
["GROUP E"]
["Italy",2,0,"Ghana",null,null,14,"ITA","GHA","USA","CZE",null,null,17,"ITA","GHA","USA","CZE",{"$nulls":4},"M","Pts","GF","GA","GD",{"$nulls":15},1]
["USA",0,3,"Czech Republic",null,null,"ITA",null,2,1,2,null,null,"ITA",null,3,1,3,null,null,1,"Italy",3,7,5,1,4,null,null,1,null,null,70405,1,"x",null,null,1,0,{"v":0,"d":"0.00000"},{"$nulls":3},7,4,5,{"v":0,"d":"0.00000"},null,null,{"v":70405,"d":"70405.00000"},1,1,1,1,1,"x",1]
["Italy",1,1,"USA",null,null,"GHA",0,null,2,2,null,null,"GHA",0,null,3,3,null,null,2,"Ghana",3,6,4,3,1,null,null,2,null,null,60104,1,"x",null,null,2,0,{"v":0,"d":"0.00000"},{"$nulls":3},6,3,4,{"v":0,"d":"0.00000"},null,null,{"v":60104,"d":"60104.00000"},2,2,2,2,1,"x",2]
["Czech Republic",0,2,"Ghana",null,null,"USA",1,1,null,0,null,null,"USA",1,0,null,0,null,null,3,"USA",3,1,2,6,-4,null,null,4,null,null,9602,1,"x",null,null,3,0,{"v":0,"d":"0.00000"},{"$nulls":3},0,-4,1,{"v":0,"d":"0.00000"},null,null,{"v":9602,"d":"9602.00000"},4,4,4,4,1,"x",4]
["Czech Republic",0,2,"Italy",null,null,"CZE",0,0,3,{"$nulls":3},"CZE",0,0,3,{"$nulls":3},4,"Czech Republic",3,3,3,4,-1,null,null,3,null,null,29903,1,"x",null,null,4,0,{"v":0,"d":"0.00000"},{"$nulls":3},3,1,3,{"v":0,"d":"0.00000"},null,null,{"v":29903,"d":"29903.00000"},3,3,3,3,1,"x",3]
["Ghana",2,1,"USA",{"$nulls":17},"matches complete?",true,{"$nulls":6},"ranking clear",null,null,"tie case",1,{"$nulls":21},4,10,"ranking clear"]
[]
["GROUP F"]
["Brazil",3,1,"Croatia",null,null,16,"BRA","CRO","AUS","JPN",null,null,16,"BRA","CRO","AUS","JPN",{"$nulls":4},"M","Pts","GF","GA","GD",{"$nulls":15},1]
["Australia",1,0,"Japan",null,null,"BRA",null,3,2,4,null,null,"BRA",null,3,3,3,null,null,1,"Brazil",3,9,9,2,7,null,null,1,null,null,90709,1,"x",null,null,1,0,{"v":0,"d":"0.00000"},{"$nulls":3},9,7,9,{"v":0,"d":"0.00000"},null,null,{"v":90709,"d":"90709.00000"},1,1,1,1,1,"x",1]
["Brazil",2,0,"Australia",null,null,"CRO",1,null,2,0,null,null,"CRO",0,null,1,1,null,null,2,"Croatia",3,2,3,5,-2,null,null,3,null,null,19803,1,"x",null,null,2,0,{"v":0,"d":"0.00000"},{"$nulls":3},2,0,2,{"v":0,"d":"0.00000"},null,null,{"v":19803,"d":"19803.00000"},2,2,3,3,1,"x",3]
["Japan",0,0,"Croatia",null,null,"AUS",0,2,null,1,null,null,"AUS",0,1,null,3,null,null,3,"Australia",3,4,3,4,-1,null,null,2,null,null,39903,1,"x",null,null,3,0,{"v":0,"d":"0.00000"},{"$nulls":3},4,1,3,{"v":0,"d":"0.00000"},null,null,{"v":39903,"d":"39903.00000"},3,3,2,2,1,"x",2]
["Japan",1,4,"Brazil",null,null,"JPN",1,0,0,{"$nulls":3},"JPN",0,1,0,{"$nulls":3},4,"Japan",3,1,1,5,-4,null,null,4,null,null,9601,1,"x",null,null,4,0,{"v":0,"d":"0.00000"},{"$nulls":3},1,-1,0,{"v":0,"d":"0.00000"},null,null,{"v":9601,"d":"9601.00000"},4,4,4,4,1,"x",4]
["Croatia",2,2,"Australia",{"$nulls":17},"matches complete?",true,{"$nulls":6},"ranking clear",null,null,"tie case",1,{"$nulls":21},4,10,"ranking clear"]
[]
["GROUP G"]
["France",0,0,"Switzerland",null,null,10,"FRA","SUI","KOR","TOG",null,null,16,"FRA","SUI","KOR","TOG",{"$nulls":4},"M","Pts","GF","GA","GD",{"$nulls":15},1]
["Korea Republic",2,1,"Togo",null,null,"FRA",null,0,1,2,null,null,"FRA",null,1,1,3,null,null,1,"France",3,5,3,1,2,null,null,2,null,null,50203,1,"x",null,null,1,0,{"v":0,"d":"0.00000"},{"$nulls":3},5,2,3,{"v":0,"d":"0.00000"},null,null,{"v":50203,"d":"50203.00000"},2,2,2,2,1,"x",2]
["France",1,1,"Korea Republic",null,null,"SUI",0,null,1,2,null,null,"SUI",1,null,3,3,null,null,2,"Switzerland",3,7,3,0,3,null,null,1,null,null,70303,1,"x",null,null,2,0,{"v":0,"d":"0.00000"},{"$nulls":3},6,3,3,{"v":0,"d":"0.00000"},null,null,{"v":70303,"d":"70303.00000"},1,1,1,1,1,"x",1]
["Togo",0,2,"Switzerland",null,null,"KOR",1,0,null,2,null,null,"KOR",1,0,null,3,null,null,3,"Korea Republic",3,4,3,3,0,null,null,3,null,null,40003,1,"x",null,null,3,0,{"v":0,"d":"0.00000"},{"$nulls":3},3,0,2,{"v":0,"d":"0.00000"},null,null,{"v":40003,"d":"40003.00000"},3,3,3,3,1,"x",3]
["Togo",0,2,"France",null,null,"TOG",0,0,1,{"$nulls":3},"TOG",0,0,0,{"$nulls":3},4,"Togo",3,0,1,6,-5,null,null,4,null,null,-499,1,"x",null,null,4,0,{"v":0,"d":"0.00000"},{"$nulls":3},0,-3,1,{"v":0,"d":"0.00000"},null,null,{"v":-499,"d":"-499.00000"},4,4,4,4,1,"x",4]
["Switzerland",1,0,"Korea Republic",{"$nulls":17},"matches complete?",true,{"$nulls":6},"ranking clear",null,null,"tie case",1,{"$nulls":21},4,10,"ranking clear"]
[]
["GROUP H"]
["Spain",4,0,"Ukraine",null,null,20,"ESP","UKR","TUN","KSA",null,null,16,"ESP","UKR","TUN","KSA",{"$nulls":4},"M","Pts","GF","GA","GD",{"$nulls":15},1]
["Tunisia",2,2,"Saudi Arabia",null,null,"ESP",null,4,2,2,null,null,"ESP",null,3,3,3,null,null,1,"Spain",3,9,8,0,8,null,null,1,null,null,90808,1,"x",null,null,1,0,{"v":0,"d":"0.00000"},{"$nulls":3},9,8,8,{"v":0,"d":"0.00000"},null,null,{"v":90808,"d":"90808.00000"},1,1,1,1,1,"x",1]
["Spain",2,0,"Tunisia",null,null,"UKR",0,null,2,4,null,null,"UKR",0,null,1,3,null,null,2,"Ukraine",3,4,6,6,0,null,null,2,null,null,40006,1,"x",null,null,2,0,{"v":0,"d":"0.00000"},{"$nulls":3},4,4,6,{"v":0,"d":"0.00000"},null,null,{"v":40006,"d":"40006.00000"},2,2,2,2,1,"x",2]
["Saudi Arabia",0,4,"Ukraine",null,null,"TUN",0,2,null,2,null,null,"TUN",0,1,null,1,null,null,3,"Tunisia",3,2,4,6,-2,null,null,3,null,null,19804,1,"x",null,null,3,0,{"v":0,"d":"0.00000"},{"$nulls":3},2,0,4,{"v":0,"d":"0.00000"},null,null,{"v":19804,"d":"19804.00000"},3,3,3,3,1,"x",3]
["Saudi Arabia",0,2,"Spain",null,null,"KSA",0,0,2,{"$nulls":3},"KSA",0,0,1,{"$nulls":3},4,"Saudi Arabia",3,1,2,8,-6,null,null,4,null,null,9402,1,"x",null,null,4,0,{"v":0,"d":"0.00000"},{"$nulls":3},1,-4,2,{"v":0,"d":"0.00000"},null,null,{"v":9402,"d":"9402.00000"},4,4,4,4,1,"x",4]
["Ukraine",2,2,"Tunisia",{"$nulls":17},"matches complete?",true,{"$nulls":6},"ranking clear",null,null,"tie case",1,{"$nulls":21},4,10,"ranking clear"]

{"sheet":"text","index":3,"n_rows":101,"n_cols":2,"rows_kept":101,"flags":["formulas_cached_only"]}
["Abbreviation","Full text"]
["A","GROUP A"]
["GER","Germany"]
["CRC","Costa Rica"]
["POL","Poland"]
["ECU","Ecuador"]
[]
[]
[]
["B","GROUP B"]
["ENG","England"]
["PAR","Paraguay"]
["TRI","Trinidad and Tobago"]
["SWE","Sweden"]
[]
[]
[]
["C","GROUP C"]
["ARG","Argentina"]
["CIV","Cote d'Ivoire"]
["SCG","Serbia and Montenegro"]
["NED","Netherlands"]
[]
[]
[]
["D","GROUP D"]
["MEX","Mexico"]
["IRN","Iran"]
["ANG","Angola"]
["POR","Portugal"]
[]
[]
[]
["E","GROUP E"]
["ITA","Italy"]
["GHA","Ghana"]
["USA","USA"]
["CZE","Czech Republic"]
[]
[]
[]
["F","GROUP F"]
["BRA","Brazil"]
["CRO","Croatia"]
["AUS","Australia"]
["JPN","Japan"]
[]
[]
[]
["G","GROUP G"]
["FRA","France"]
["SUI","Switzerland"]
["KOR","Korea Republic"]
["TOG","Togo"]
[]
[]
[]
["H","GROUP H"]
["ESP","Spain"]
["UKR","Ukraine"]
["TUN","Tunisia"]
["KSA","Saudi Arabia"]
[]
["M","Matches"]
["Pts","Points"]
["GF","Goals forward"]
["GA","Goals against"]
["GD","Goal difference"]
["Goals","Goals"]
[]
[null,"ranking clear"]
[null,"two teams at 3rd rank"]
[null,"drawing lots"]
[null,"Lots drawn due to tie. Enter team rank manually 1-4. Note: Team names will reorder correctly even if numbers appear off."]
[null,"2006 World Cup tracker"]
[null,"ROUND 1"]
[null,"ROUND 2"]
[null,"ROUND OF 16"]
[null,"QUARTER-FINALS"]
[null,"SEMI-FINALS"]
[null,"THIRD PLACE"]
[null,"FINAL"]
[null,"WORLD CUP CHAMPION"]
[null,"Winner"]
[null,"Runner-up"]
[null,"Group"]
[null,"Match"]
[null,"Date"]
[null,"Venue"]
[null,"Berlin"]
[null,"Dortmund"]
[null,"Frankfurt"]
[null,"Gelsenkirchen"]
[null,"Hamburg"]
[null,"Hanover"]
[null,"Kaiserslautern"]
[null,"Cologne"]
[null,"Leipzig"]
[null,"Munich"]
[null,"Nuremberg"]
[null,"Stuttgart"]