{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Overview","Group Stage","Knockout Rounds","OddsCreation","OddsCreation (2)","OddsCreation (3)","OddsCreation (4)","KOCoeffs","OddsTesting","GroupQuals","GroupQuals (2)","Simulations"],"not_rendered":{"charts":20,"images":1,"macros":1,"external_links":0,"defined_names":176,"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":"Overview","index":0,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":false,"merged":[[29,9,29,12],[30,9,30,12],[25,9,25,12],[0,6,3,15],[10,9,10,12],[17,9,17,12],[22,9,22,12],[27,9,28,12],[20,9,20,12]]}
[null,null,null,null,null,null,{"$f":"IF(C34<0.95, \"TGIAF 2014 World Cup Simulator\", \"Paul the Octopus predicts:\")","v":"TGIAF 2014 World Cup Simulator"}]
[]
[]
[]
[]
[]
[null,"A",null,"Round of 16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round of 16",null,"B"]
[null,{"$f":"'Group Stage'!AE3","v":"BRA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Group Stage'!AE10","v":"CHI"}]
[null,{"$f":"'Group Stage'!AE4","v":"MEX"},null,{"$f":"'Knockout Rounds'!A3","v":"Brazil"},null,null,"Quarter-finals",null,null,null,null,null,null,null,null,"Quarter-finals",null,null,{"$f":"'Knockout Rounds'!A7","v":"Chile"},null,{"$f":"'Group Stage'!AE11","v":"AUS"}]
[null,{"$f":"'Group Stage'!AE5","v":"CAM"},null,"28 June, Belo Horizonte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29 June, Fortaleza",null,{"$f":"'Group Stage'!AE12","v":"NED"}]
[null,{"$f":"'Group Stage'!AE6","v":"CRO"},null,{"$f":"'Knockout Rounds'!E3","v":"Australia"},null,null,{"$f":"'Knockout Rounds'!A14","v":"Brazil"},null,null,"Semi-finals",null,null,null,null,null,{"$f":"'Knockout Rounds'!A16","v":"Mexico"},null,null,{"$f":"'Knockout Rounds'!E7","v":"Mexico"},null,{"$f":"'Group Stage'!AE13","v":"ESP"}]
[null,null,null,null,null,null,"4 July, Fortaleza",null,null,null,null,null,null,null,null,"5 July, Salvador"]
[null,"C",null,null,null,null,{"$f":"'Knockout Rounds'!E14","v":"Colombia"},null,null,{"$f":"'Knockout Rounds'!A21","v":"Brazil"},null,null,{"$f":"'Knockout Rounds'!A22","v":"Mexico"},null,null,{"$f":"'Knockout Rounds'!E16","v":"England"},null,null,null,null,"D"]
[null,{"$f":"'Group Stage'!AE17","v":"COL"},null,null,null,null,null,null,null,"8 July, Belo Horizonte",null,null,"9 July, São Paulo",null,null,null,null,null,null,null,{"$f":"'Group Stage'!AE24","v":"ENG"}]
[null,{"$f":"'Group Stage'!AE18","v":"IVO"},null,{"$f":"'Knockout Rounds'!A4","v":"Colombia"},null,null,null,null,null,{"$f":"'Knockout Rounds'!E21","v":"Iran"},null,null,{"$f":"'Knockout Rounds'!E22","v":"Germany"},null,null,null,null,null,{"$f":"'Knockout Rounds'!A8","v":"England"},null,{"$f":"'Group Stage'!AE25","v":"URU"}]
[null,{"$f":"'Group Stage'!AE19","v":"GRE"},null,"28 June, Rio de Janeiro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29 June, Recife",null,{"$f":"'Group Stage'!AE26","v":"ITA"}]
[null,{"$f":"'Group Stage'!AE20","v":"JAP"},null,{"$f":"'Knockout Rounds'!E4","v":"Uruguay"},null,null,{"$f":"'Knockout Rounds'!A15","v":"Iran"},null,null,null,null,null,null,null,null,{"$f":"'Knockout Rounds'!A17","v":"Argentina"},null,null,{"$f":"'Knockout Rounds'!E8","v":"Ivory Coast"},null,{"$f":"'Group Stage'!AE27","v":"COS"}]
[null,null,null,null,null,null,"4 July, Rio de Janeiro",null,null,"Third-place play-off",null,null,null,null,null,"5 July, Brasília"]
[null,"E",null,null,null,null,{"$f":"'Knockout Rounds'!E15","v":"Portugal"},null,null,null,null,null,null,null,null,{"$f":"'Knockout Rounds'!E17","v":"Germany"},null,null,null,null,"F"]
[null,{"$f":"'Group Stage'!AE31","v":"ECU"},null,null,null,null,null,null,null,{"$f":"'Knockout Rounds'!A26","v":"Iran"},null,null,{"$f":"'Knockout Rounds'!E26","v":"Germany"},null,null,null,null,null,null,null,{"$f":"'Group Stage'!AE38","v":"ARG"}]
[null,{"$f":"'Group Stage'!AE32","v":"SWI"},null,{"$f":"'Knockout Rounds'!A5","v":"Ecuador"},null,null,null,null,null,"12 July, Brasília",null,null,null,null,null,null,null,null,{"$f":"'Knockout Rounds'!A9","v":"Argentina"},null,{"$f":"'Group Stage'!AE39","v":"IRN"}]
[null,{"$f":"'Group Stage'!AE33","v":"FRA"},null,"30 June, Brasília",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 July, São Paulo",null,{"$f":"'Group Stage'!AE40","v":"NIG"}]
[null,{"$f":"'Group Stage'!AE34","v":"HON"},null,{"$f":"'Knockout Rounds'!E5","v":"Iran"},null,null,null,null,null,"Final",null,null,null,null,null,null,null,null,{"$f":"'Knockout Rounds'!E9","v":"Switzerland"},null,{"$f":"'Group Stage'!AE41","v":"BOS"}]
[]
[null,"G",null,null,null,null,null,null,null,{"$f":"'Knockout Rounds'!A30","v":"Brazil"},null,null,{"$f":"'Knockout Rounds'!E30","v":"Mexico"},null,null,null,null,null,null,null,"H"]
[null,{"$f":"'Group Stage'!AE45","v":"POR"},null,null,null,null,null,null,null,"13 July, Rio de Janeiro",null,null,null,null,null,null,null,null,null,null,{"$f":"'Group Stage'!AE52","v":"SKO"}]
[null,{"$f":"'Group Stage'!AE46","v":"GER"},null,{"$f":"'Knockout Rounds'!A6","v":"Portugal"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Knockout Rounds'!A10","v":"South Korea"},null,{"$f":"'Group Stage'!AE53","v":"BEL"}]
[null,{"$f":"'Group Stage'!AE47","v":"USA"},null,"30 June, Porto Alegre",null,null,null,null,null,{"$f":"'Knockout Rounds'!Q30","v":"Brazil"},null,null,null,null,null,null,null,null,"1 July, Salvador",null,{"$f":"'Group Stage'!AE54","v":"RUS"}]
[null,{"$f":"'Group Stage'!AE48","v":"GHA"},null,{"$f":"'Knockout Rounds'!E6","v":"Belgium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Knockout Rounds'!E10","v":"Germany"},null,{"$f":"'Group Stage'!AE55","v":"ALG"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J28='Knockout Rounds'!A30, 'Knockout Rounds'!E30, 'Knockout Rounds'!A30)","v":"Mexico"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Knockout Rounds'!Q26","v":"Germany"}]
[]
[]
[{"$f":"RAND()","v":3.169207254943962E-3},{"$f":"RAND()","v":0.90314779965154546},{"$f":"RAND()","v":0.32577016334104625},{"$f":"IF(G11=D9, D11, D9)","v":"Australia"},null,null,{"$f":"IF(J13=G11, G13, G11)","v":"Colombia"},null,null,null,{"$f":"IF(Third=J20, M20, J20)","v":"Iran"},null,null,null,null,{"$f":"IF(M13=P11, P13, P11)","v":"England"},null,null,{"$f":"IF(P11=S9, S11, S9)","v":"Chile"},{"$f":"RAND()","v":0.21239187906889745},{"$f":"RAND()","v":0.60595830796370287}]
[null,null,null,{"$f":"IF(G13=D15, D17, D15)","v":"Uruguay"},null,null,{"$f":"IF(J20=G17, G19, G17)","v":"Portugal"},null,null,null,null,null,null,null,null,{"$f":"IF(M15=P17, P19, P17)","v":"Argentina"},null,null,{"$f":"IF(P13=S15, S17, S15)","v":"Ivory Coast"}]
[null,null,null,{"$f":"IF(G17=D21, D23, D21)","v":"Ecuador"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P17=S21, S23, S21)","v":"Switzerland"}]
[null,null,null,{"$f":"IF(G19=D27, D29, D27)","v":"Belgium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P19=S27, S29, S27)","v":"South Korea"}]

{"sheet":"Group Stage","index":1,"n_rows":56,"n_cols":35,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Team 1","1W","D","2W","Team 2",null,null,null,null,null,null,"C1","C2","C3",null,"Random","Result"]
["Brazil",0.3,3.6,9,"Croatia",{"$f":"1/B2","v":3.3333333333333335},{"$f":"1/C2","v":0.27777777777777779},0.1111111111111111,{"$f":"F2/($F2+$G2+$H2)","v":0.89552238805970152},{"$f":"G2/($F2+$G2+$H2)","v":7.4626865671641798E-2},{"$f":"H2/($F2+$G2+$H2)","v":2.9850746268656712E-2},{"$f":"I2","v":0.89552238805970152},{"$f":"I2+J2","v":0.97014925373134331},{"$f":"I2+J2+K2","v":1},null,{"$f":"RAND()","v":0.71945445983715228},{"$f":"IF(P2<L2, A2, IF(P2<M2, \"Draw\", E2))","v":"Brazil"},null,"Group A","M1","M2","M3","Ran","Tot","Pos","Group A"]
["Mexico",1.1499999999999999,2,2.5,"Cameroon",{"$f":"1/B3","v":0.86956521739130443},{"$f":"1/C3","v":0.5},{"$f":"1/D3","v":0.4},{"$f":"F3/($F3+$G3+$H3)","v":0.49140049140049141},{"$f":"G3/($F3+$G3+$H3)","v":0.28255528255528251},{"$f":"H3/($F3+$G3+$H3)","v":0.22604422604422603},{"$f":"I3","v":0.49140049140049141},{"$f":"I3+J3","v":0.77395577395577386},{"$f":"I3+J3+K3","v":0.99999999999999989},null,{"$f":"RAND()","v":0.19876045951391241},{"$f":"IF(P3<L3, A3, IF(P3<M3, \"Draw\", E3))","v":"Mexico"},null,"Brazil",{"$f":"IF($Q2=$S3, 3, IF($Q2=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q4=$S3, 3, IF($Q4=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q6=$S3, 3, IF($Q6=\"Draw\", 1, 0))","v":3},{"$f":"RAND()/10","v":3.4869947160956441E-2},{"$f":"SUM(T3:W3)","v":9.0348699471609564},{"$f":"VLOOKUP(S3, AH3:AI6, 2, FALSE)","v":1},"Brazil","BRA",null,1,{"$f":"VLOOKUP(AC3,Y3:Z6,2, FALSE)","v":"Brazil"},{"$f":"VLOOKUP(AD3,Z$3:AA$6,2, FALSE)","v":"BRA"},null,{"$f":"LARGE(X3:X6, 1)","v":9.0348699471609564},{"$f":"VLOOKUP(AG3, X3:Z6, 3, FALSE)","v":"Brazil"},1]
["Brazil",0.36399999999999999,3.3330000000000002,6,"Mexico",2.7472527472527473,0.30003000300030003,0.16666666666666666,0.85479028785890043,9.335243467765969E-2,5.1857277463439953E-2,0.85479028785890043,0.94814272253656018,1.0000000000000002,null,0.63010975450974038,"Brazil",null,"Croatia",{"$f":"IF($Q2=$S4, 3, IF($Q2=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q5=$S4, 3, IF($Q5=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q7=$S4, 3, IF($Q7=\"Draw\", 1, 0))","v":1},{"$f":"RAND()/10","v":4.9314430132402623E-2},{"$f":"SUM(T4:W4)","v":1.0493144301324027},{"$f":"VLOOKUP(S4, AH3:AI6, 2, FALSE)","v":4},"Croatia","CRO",null,2,{"$f":"VLOOKUP(AC4,Y3:Z6,2, FALSE)","v":"Mexico"},{"$f":"VLOOKUP(AD4,Z$3:AA$6,2, FALSE)","v":"MEX"},null,{"$f":"LARGE(X3:X6, 2)","v":4.0020709217713755},{"$f":"VLOOKUP(AG4, X3:Z6, 3, FALSE)","v":"Mexico"},2]
["Cameroon",2.4,2,1.05,"Croatia",0.41666666666666669,0.5,0.95238095238095233,0.22292993630573249,0.26751592356687898,0.50955414012738853,0.22292993630573249,0.49044585987261147,1,null,1.1102291396274611E-2,"Cameroon",null,"Mexico",{"$f":"IF($Q3=$S5, 3, IF($Q3=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q4=$S5, 3, IF($Q4=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q7=$S5, 3, IF($Q7=\"Draw\", 1, 0))","v":1},2.0709217713753003E-3,4.0020709217713755,{"$f":"VLOOKUP(S5, AH3:AI6, 2, FALSE)","v":2},"Mexico","MEX",null,3,{"$f":"VLOOKUP(AC5,Y3:Z6,2, FALSE)","v":"Cameroon"},{"$f":"VLOOKUP(AD5,Z$3:AA$6,2, FALSE)","v":"CAM"},null,{"$f":"LARGE(X3:X6, 3)","v":3.0931837054269944},{"$f":"VLOOKUP(AG5, X3:Z6, 3, FALSE)","v":"Cameroon"},3]
["Cameroon",12,4,0.2,"Brazil",8.3333333333333329E-2,0.25,5,1.5625E-2,4.6875E-2,0.9375,1.5625E-2,6.25E-2,1,null,0.87511812612501605,"Brazil",null,"Cameroon",{"$f":"IF($Q3=$S6, 3, IF($Q3=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q5=$S6, 3, IF($Q5=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q6=$S6, 3, IF($Q6=\"Draw\", 1, 0))","v":0},9.3183705426994251E-2,3.0931837054269944,{"$f":"VLOOKUP(S6, AH3:AI6, 2, FALSE)","v":3},"Cameroon","CAM",null,4,{"$f":"VLOOKUP(AC6,Y3:Z6,2, FALSE)","v":"Croatia"},{"$f":"VLOOKUP(AD6,Z$3:AA$6,2, FALSE)","v":"CRO"},null,{"$f":"LARGE(X3:X6, 4)","v":1.0493144301324027},{"$f":"VLOOKUP(AG6, X3:Z6, 3, FALSE)","v":"Croatia"},4]
["Croatia",1.5,2.2999999999999998,1.45,"Mexico",0.66666666666666663,0.43478260869565222,0.68965517241379315,0.3722098214285714,0.24274553571428573,0.38504464285714285,0.3722098214285714,0.6149553571428571,1,null,0.39139754641874402,"Draw"]
[]
["Spain",1,2.1,3,"Netherlands",1,0.47619047619047616,0.33333333333333331,0.55263157894736836,0.26315789473684209,0.18421052631578946,0.55263157894736836,0.8157894736842104,0.99999999999999989,null,0.24506967285489312,{"$f":"IF(P9<L9, A9, IF(P9<M9, \"Draw\", E9))","v":"Spain"},null,"Group B","M1","M2","M3","Ran","Tot","Pos","Group B"]
["Chile",0.5,2.75,5.5,"Australia",2,0.36363636363636365,0.18181818181818182,0.7857142857142857,0.14285714285714288,7.1428571428571438E-2,0.7857142857142857,0.9285714285714286,1,null,0.51250522339581062,"Chile",null,"Spain",{"$f":"IF($Q9=$S10, 3, IF($Q9=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q12=$S10, 3, IF($Q12=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q13=$S10, 3, IF($Q13=\"Draw\", 1, 0))","v":0},{"$f":"RAND()/10","v":4.6656155714416949E-3},{"$f":"SUM(T10:W10)","v":3.0046656155714415},{"$f":"VLOOKUP(S10, AH10:AI13, 2, FALSE)","v":4},"Spain","ESP",null,1,{"$f":"VLOOKUP(AC10,Y10:Z13,2, FALSE)","v":"Chile"},{"$f":"VLOOKUP(AD10,Z$10:AA$13,2, FALSE)","v":"CHI"},null,{"$f":"LARGE(X10:X13, 1)","v":9.0929178074075132},{"$f":"VLOOKUP(AG10, X10:Z13, 3, FALSE)","v":"Chile"},1]
["Australia",5.5,3.5,0.36399999999999999,"Netherlands",0.18181818181818182,0.2857142857142857,2.7472527472527473,5.6556867619639524E-2,8.8875077688004969E-2,0.85456805469235542,5.6556867619639524E-2,0.1454319453076445,0.99999999999999989,null,0.60619512590102831,"Netherlands",null,"Netherlands",{"$f":"IF($Q9=$S11, 3, IF($Q9=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q11=$S11, 3, IF($Q11=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q14=$S11, 3, IF($Q14=\"Draw\", 1, 0))","v":0},{"$f":"RAND()/10","v":6.772582820584E-2},{"$f":"SUM(T11:W11)","v":3.0677258282058402},{"$f":"VLOOKUP(S11, AH10:AI13, 2, FALSE)","v":3},"Netherlands","NED",null,2,{"$f":"VLOOKUP(AC11,Y10:Z13,2, FALSE)","v":"Australia"},{"$f":"VLOOKUP(AD11,Z$10:AA$13,2, FALSE)","v":"AUS"},null,{"$f":"LARGE(X10:X13, 2)","v":3.0707437227562862},{"$f":"VLOOKUP(AG11, X10:Z13, 3, FALSE)","v":"Australia"},2]
["Spain",0.7,2.4,3.3330000000000002,"Chile",1.4285714285714286,0.41666666666666669,0.30003000300030003,0.6659174346295047,0.19422591843360557,0.13985664693688968,0.6659174346295047,0.86014335306311029,1,null,0.90688909532583606,"Chile",null,"Chile",{"$f":"IF($Q10=$S12, 3, IF($Q10=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q12=$S12, 3, IF($Q12=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q14=$S12, 3, IF($Q14=\"Draw\", 1, 0))","v":3},9.2917807407512529E-2,9.0929178074075132,{"$f":"VLOOKUP(S12, AH10:AI13, 2, FALSE)","v":1},"Chile","CHI",null,3,{"$f":"VLOOKUP(AC12,Y10:Z13,2, FALSE)","v":"Netherlands"},"NED",null,{"$f":"LARGE(X10:X13, 3)","v":3.0677258282058402},{"$f":"VLOOKUP(AG12, X10:Z13, 3, FALSE)","v":"Netherlands"},3]
["Australia",8,4,0.25,"Spain",0.125,0.25,4,2.8571428571428571E-2,5.7142857142857141E-2,0.91428571428571426,2.8571428571428571E-2,8.5714285714285715E-2,1,null,1.0381106946556695E-2,"Australia",null,"Australia",{"$f":"IF($Q10=$S13, 3, IF($Q10=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q11=$S13, 3, IF($Q11=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q13=$S13, 3, IF($Q13=\"Draw\", 1, 0))","v":3},7.0743722756286181E-2,3.0707437227562862,{"$f":"VLOOKUP(S13, AH10:AI13, 2, FALSE)","v":2},"Australia","AUS",null,4,{"$f":"VLOOKUP(AC13,Y10:Z13,2, FALSE)","v":"Spain"},"ESP",null,{"$f":"LARGE(X10:X13, 4)","v":3.0046656155714415},{"$f":"VLOOKUP(AG13, X10:Z13, 3, FALSE)","v":"Spain"},4]
["Netherlands",1.2,2.2999999999999998,1.9,"Chile",0.83333333333333337,0.43478260869565222,0.52631578947368418,0.46439957492029754,0.24229543039319873,0.29330499468650367,0.46439957492029754,0.70669500531349627,1,null,0.9291820788385392,"Chile"]
[]
["Colombia",0.7,2.4,4,"Greece",1.4285714285714286,0.41666666666666669,0.25,0.68181818181818177,0.19886363636363635,0.11931818181818181,0.68181818181818177,0.88068181818181812,0.99999999999999989,null,0.26479875780486117,"Colombia",null,"Group C","M1","M2","M3","Ran","Tot","Pos","Group C"]
["Ivory Coast",1.5,2,1.625,"Japan",0.66666666666666663,0.5,0.61538461538461542,0.37410071942446044,0.28057553956834536,0.34532374100719426,0.37410071942446044,0.65467625899280579,1,null,7.1063972778182438E-2,"Ivory Coast",null,"Colombia",{"$f":"IF($Q16=$S17, 3, IF($Q16=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q18=$S17, 3, IF($Q18=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q20=$S17, 3, IF($Q20=\"Draw\", 1, 0))","v":3},{"$f":"RAND()/10","v":9.6496408527666833E-2},{"$f":"SUM(T17:W17)","v":9.0964964085276669},{"$f":"VLOOKUP(S17, AH17:AI20, 2, FALSE)","v":1},"Colombia","COL",null,1,{"$f":"VLOOKUP(AC17,Y17:Z20,2, FALSE)","v":"Colombia"},{"$f":"VLOOKUP(AD17,Z$17:AA$20,2, FALSE)","v":"COL"},null,{"$f":"LARGE(X17:X20, 1)","v":9.0964964085276669},{"$f":"VLOOKUP(AG17, X17:Z20, 3, FALSE)","v":"Colombia"},1]
["Colombia",1,2.25,2.4,"Ivory Coast",1,0.44444444444444442,0.41666666666666669,0.53731343283582089,0.2388059701492537,0.22388059701492538,0.53731343283582089,0.77611940298507465,1,null,0.49754731642829353,"Colombia",null,"Greece",{"$f":"IF($Q16=$S18, 3, IF($Q16=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q19=$S18, 3, IF($Q19=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q21=$S18, 3, IF($Q21=\"Draw\", 1, 0))","v":0},{"$f":"RAND()/10","v":6.2265605212662965E-2},{"$f":"SUM(T18:W18)","v":3.0622656052126631},{"$f":"VLOOKUP(S18, AH17:AI20, 2, FALSE)","v":3},"Greece","GRE",null,2,{"$f":"VLOOKUP(AC18,Y17:Z20,2, FALSE)","v":"Ivory Coast"},{"$f":"VLOOKUP(AD18,Z$17:AA$20,2, FALSE)","v":"IVO"},null,{"$f":"LARGE(X17:X20, 2)","v":6.0660860480932639},{"$f":"VLOOKUP(AG18, X17:Z20, 3, FALSE)","v":"Ivory Coast"},2]
["Japan",1.3,2,1.9,"Greece",0.76923076923076916,0.5,0.52631578947368418,0.42841037204058624,0.27846674182638109,0.29312288613303272,0.42841037204058624,0.70687711386696739,1,null,0.89066801018704478,"Greece",null,"Ivory Coast",{"$f":"IF($Q17=$S19, 3, IF($Q17=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q18=$S19, 3, IF($Q18=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q21=$S19, 3, IF($Q21=\"Draw\", 1, 0))","v":3},6.6086048093264266E-2,6.0660860480932639,{"$f":"VLOOKUP(S19, AH17:AI20, 2, FALSE)","v":2},"Ivory Coast","IVO",null,3,{"$f":"VLOOKUP(AC19,Y17:Z20,2, FALSE)","v":"Greece"},{"$f":"VLOOKUP(AD19,Z$17:AA$20,2, FALSE)","v":"GRE"},null,{"$f":"LARGE(X17:X20, 3)","v":3.0622656052126631},{"$f":"VLOOKUP(AG19, X17:Z20, 3, FALSE)","v":"Greece"},3]
["Japan",2.75,2.5,0.83299999999999996,"Colombia",0.36363636363636365,0.4,1.2004801920768309,0.18513991065276819,0.20365390171804501,0.61120618762918677,0.18513991065276819,0.38879381237081323,1,null,0.39647803922569158,"Colombia",null,"Japan",{"$f":"IF($Q17=$S20, 3, IF($Q17=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q19=$S20, 3, IF($Q19=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q20=$S20, 3, IF($Q20=\"Draw\", 1, 0))","v":0},3.7286944013818171E-2,3.7286944013818171E-2,{"$f":"VLOOKUP(S20, AH17:AI20, 2, FALSE)","v":4},"Japan","JAP",null,4,{"$f":"VLOOKUP(AC20,Y17:Z20,2, FALSE)","v":"Japan"},"JAP",null,{"$f":"LARGE(X17:X20, 4)","v":3.7286944013818171E-2},{"$f":"VLOOKUP(AG20, X17:Z20, 3, FALSE)","v":"Japan"},4]
["Greece",1.8,2.25,1.25,"Ivory Coast",0.55555555555555558,0.44444444444444442,0.8,0.30864197530864196,0.24691358024691357,0.44444444444444448,0.30864197530864196,0.55555555555555558,1,null,0.81583917232723069,"Ivory Coast"]
[]
["Uruguay",0.33,3.2,9,"Costa Rica",3.0303030303030303,0.3125,0.1111111111111111,0.87735331749223178,9.0477060866386405E-2,3.2169621641381832E-2,0.87735331749223178,0.96783037835861818,1,null,9.7967354379616456E-2,"Uruguay",null,"Group D","M1","M2","M3","Ran","Tot","Pos","Group D"]
["England",2,1.8,1.5,"Italy",0.5,0.55555555555555558,0.66666666666666663,0.29032258064516125,0.32258064516129031,0.38709677419354832,0.29032258064516125,0.61290322580645151,0.99999999999999978,null,0.54814107739625106,"Draw",null,"Uruguay",{"$f":"IF($Q23=$S24, 3, IF($Q23=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q25=$S24, 3, IF($Q25=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q27=$S24, 3, IF($Q27=\"Draw\", 1, 0))","v":3},{"$f":"RAND()/10","v":5.8315909600571945E-2},{"$f":"SUM(T24:W24)","v":6.0583159096005721},{"$f":"VLOOKUP(S24, AH24:AI27, 2, FALSE)","v":2},"Uruguay","URU",null,1,{"$f":"VLOOKUP(AC24,Y24:Z27,2, FALSE)","v":"England"},{"$f":"VLOOKUP(AD24,Z$24:AA$27,2, FALSE)","v":"ENG"},null,{"$f":"LARGE(X24:X27, 1)","v":7.0626131010675923},{"$f":"VLOOKUP(AG24, X24:Z27, 3, FALSE)","v":"England"},1]
["Uruguay",1.6,2.1,1.625,"England",0.625,0.47619047619047616,0.61538461538461542,0.36409709255801542,0.27740730861563079,0.35849559882635368,0.36409709255801542,0.64150440117364615,0.99999999999999978,null,0.93949270955327657,"England",null,"Costa Rica",{"$f":"IF($Q23=$S25, 3, IF($Q23=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q26=$S25, 3, IF($Q26=\"Draw\", 1, 0))","v":1},{"$f":"IF($Q28=$S25, 3, IF($Q28=\"Draw\", 1, 0))","v":0},{"$f":"RAND()/10","v":1.4169930121549278E-2},{"$f":"SUM(T25:W25)","v":1.0141699301215492},{"$f":"VLOOKUP(S25, AH24:AI27, 2, FALSE)","v":4},"Costa Rica","COS",null,2,{"$f":"VLOOKUP(AC25,Y24:Z27,2, FALSE)","v":"Uruguay"},{"$f":"VLOOKUP(AD25,Z$24:AA$27,2, FALSE)","v":"URU"},null,{"$f":"LARGE(X24:X27, 2)","v":6.0583159096005721},{"$f":"VLOOKUP(AG25, X24:Z27, 3, FALSE)","v":"Uruguay"},2]
["Italy",0.33300000000000002,3.5,6.5,"Costa Rica",3.0030030030030028,0.2857142857142857,0.15384615384615385,0.8723159509202455,8.299463190184049E-2,4.4689417177914116E-2,0.8723159509202455,0.95531058282208603,1.0000000000000002,null,0.89636421840352276,"Draw",null,"England",{"$f":"IF($Q24=$S26, 3, IF($Q24=\"Draw\", 1, 0))","v":1},{"$f":"IF($Q25=$S26, 3, IF($Q25=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q28=$S26, 3, IF($Q28=\"Draw\", 1, 0))","v":3},6.2613101067592145E-2,7.0626131010675923,{"$f":"VLOOKUP(S26, AH24:AI27, 2, FALSE)","v":1},"England","ENG",null,3,{"$f":"VLOOKUP(AC26,Y24:Z27,2, FALSE)","v":"Italy"},{"$f":"VLOOKUP(AD26,Z$24:AA$27,2, FALSE)","v":"ITA"},null,{"$f":"LARGE(X24:X27, 3)","v":2.0432129371813361},{"$f":"VLOOKUP(AG26, X24:Z27, 3, FALSE)","v":"Italy"},3]
["Italy",1.375,2.25,1.625,"Uruguay",0.72727272727272729,0.44444444444444442,0.61538461538461542,0.40695652173913044,0.24869565217391301,0.34434782608695652,0.40695652173913044,0.65565217391304342,1,null,0.73414369083704123,"Uruguay",null,"Italy",{"$f":"IF($Q24=$S27, 3, IF($Q24=\"Draw\", 1, 0))","v":1},{"$f":"IF($Q26=$S27, 3, IF($Q26=\"Draw\", 1, 0))","v":1},{"$f":"IF($Q27=$S27, 3, IF($Q27=\"Draw\", 1, 0))","v":0},4.3212937181336286E-2,2.0432129371813361,{"$f":"VLOOKUP(S27, AH24:AI27, 2, FALSE)","v":3},"Italy","ITA",null,4,{"$f":"VLOOKUP(AC27,Y24:Z27,2, FALSE)","v":"Costa Rica"},{"$f":"VLOOKUP(AD27,Z$24:AA$27,2, FALSE)","v":"COS"},null,{"$f":"LARGE(X24:X27, 4)","v":1.0141699301215492},{"$f":"VLOOKUP(AG27, X24:Z27, 3, FALSE)","v":"Costa Rica"},4]
["Costa Rica",5,2.75,0.53300000000000003,"England",0.2,0.36363636363636365,1.8761726078799248,8.1973630860003088E-2,0.14904296520000559,0.76898340393999132,8.1973630860003088E-2,0.23101659606000868,1,null,0.82664475981485819,"England"]
[]
["Switzerland",1.3,2,2.1,"Ecuador",0.76923076923076916,0.5,0.47619047619047616,0.44071353620146902,0.28646379853095488,0.27282266526757604,0.44071353620146902,0.72717733473242396,1,null,0.94048860252040689,"Ecuador",null,"Group E","M1","M2","M3","Ran","Tot","Pos","Group E"]
["France",0.3,3.5,7.5,"Honduras",3.3333333333333335,0.2857142857142857,0.13333333333333333,0.8883248730964467,7.6142131979695424E-2,3.553299492385787E-2,0.8883248730964467,0.96446700507614214,1,null,0.671263849407152,"France",null,"Switzerland",{"$f":"IF($Q30=$S31, 3, IF($Q30=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q32=$S31, 3, IF($Q32=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q34=$S31, 3, IF($Q34=\"Draw\", 1, 0))","v":3},{"$f":"RAND()/10","v":2.3886934613843759E-2},{"$f":"SUM(T31:W31)","v":6.0238869346138442},{"$f":"VLOOKUP(S31, AH31:AI34, 2, FALSE)","v":2},"Switzerland","SWI",null,1,{"$f":"VLOOKUP(AC31,Y31:Z34,2, FALSE)","v":"Ecuador"},{"$f":"VLOOKUP(AD31,Z$31:AA$34,2, FALSE)","v":"ECU"},null,{"$f":"LARGE(X31:X34, 1)","v":9.0986808831071055},{"$f":"VLOOKUP(AG31, X31:Z34, 3, FALSE)","v":"Ecuador"},1]
["Switzerland",3,2.1,0.83299999999999996,"France",0.33333333333333331,0.47619047619047616,1.2004801920768309,0.16583714911407524,0.23691021302010748,0.59725263786581728,0.16583714911407524,0.40274736213418272,1,null,0.11009181054902528,"Switzerland",null,"Ecuador",{"$f":"IF($Q30=$S32, 3, IF($Q30=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q33=$S32, 3, IF($Q33=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q35=$S32, 3, IF($Q35=\"Draw\", 1, 0))","v":3},{"$f":"RAND()/10","v":9.8680883107106113E-2},{"$f":"SUM(T32:W32)","v":9.0986808831071055},{"$f":"VLOOKUP(S32, AH31:AI34, 2, FALSE)","v":1},"Ecuador","ECU",null,2,{"$f":"VLOOKUP(AC32,Y31:Z34,2, FALSE)","v":"Switzerland"},{"$f":"VLOOKUP(AD32,Z$31:AA$34,2, FALSE)","v":"SWI"},null,{"$f":"LARGE(X31:X34, 2)","v":6.0238869346138442},{"$f":"VLOOKUP(AG32, X31:Z34, 3, FALSE)","v":"Switzerland"},2]
["Honduras",4,2.2999999999999998,0.66700000000000004,"Ecuador",0.25,0.43478260869565222,1.4992503748125936,0.11446713574738288,0.19907327956066589,0.68645958469195123,0.11446713574738288,0.31354041530804877,1,null,0.64237860058837859,"Ecuador",null,"France",{"$f":"IF($Q31=$S33, 3, IF($Q31=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q32=$S33, 3, IF($Q32=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q35=$S33, 3, IF($Q35=\"Draw\", 1, 0))","v":0},2.3526423459093847E-2,3.0235264234590939,{"$f":"VLOOKUP(S33, AH31:AI34, 2, FALSE)","v":3},"France","FRA",null,3,{"$f":"VLOOKUP(AC33,Y31:Z34,2, FALSE)","v":"France"},"FRA",null,{"$f":"LARGE(X31:X34, 3)","v":3.0235264234590939},{"$f":"VLOOKUP(AG33, X31:Z34, 3, FALSE)","v":"France"},3]
["Honduras",4.5,2.5,0.57099999999999995,"Switzerland",0.22222222222222221,0.4,1.7513134851138354,9.3624975404997701E-2,0.16852495572899587,0.73785006886600646,9.3624975404997701E-2,0.26214993113399354,1,null,0.83291383932685092,"Switzerland",null,"Honduras",{"$f":"IF($Q31=$S34, 3, IF($Q31=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q33=$S34, 3, IF($Q33=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q34=$S34, 3, IF($Q34=\"Draw\", 1, 0))","v":0},2.0379338457359251E-2,2.0379338457359251E-2,{"$f":"VLOOKUP(S34, AH31:AI34, 2, FALSE)","v":4},"Honduras","HON",null,4,{"$f":"VLOOKUP(AC34,Y31:Z34,2, FALSE)","v":"Honduras"},"HON",null,{"$f":"LARGE(X31:X34, 4)","v":2.0379338457359251E-2},{"$f":"VLOOKUP(AG34, X31:Z34, 3, FALSE)","v":"Honduras"},4]
["Ecuador",2.1,2.2999999999999998,1.05,"France",0.47619047619047616,0.43478260869565222,0.95238095238095233,0.25555555555555554,0.23333333333333336,0.51111111111111107,0.25555555555555554,0.48888888888888893,1,null,6.2149726031871189E-2,"Ecuador"]
[]
["Argentina",0.36399999999999999,3.3330000000000002,6,"Bosnia & Herzegovina",2.7472527472527473,0.30003000300030003,0.16666666666666666,0.85479028785890043,9.335243467765969E-2,5.1857277463439953E-2,0.85479028785890043,0.94814272253656018,1.0000000000000002,null,0.78496058767178822,"Argentina",null,"Group F","M1","M2","M3","Ran","Tot","Pos","Group F"]
["Iran",2.6,2,1,"Nigeria",0.38461538461538458,0.5,1,0.2040816326530612,0.26530612244897961,0.53061224489795922,0.2040816326530612,0.46938775510204078,1,null,1.2488788007311569E-2,"Iran",null,"Argentina",{"$f":"IF($Q37=$S38, 3, IF($Q37=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q39=$S38, 3, IF($Q39=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q41=$S38, 3, IF($Q41=\"Draw\", 1, 0))","v":0},{"$f":"RAND()/10","v":6.7380738206270469E-2},{"$f":"SUM(T38:W38)","v":6.0673807382062703},{"$f":"VLOOKUP(S38, AH38:AI41, 2, FALSE)","v":1},"Argentina","ARG",null,1,{"$f":"VLOOKUP(AC38,Y38:Z41,2, FALSE)","v":"Argentina"},{"$f":"VLOOKUP(AD38,Z$38:AA$41,2, FALSE)","v":"ARG"},null,{"$f":"LARGE(X38:X41, 1)","v":6.0673807382062703},{"$f":"VLOOKUP(AG38, X38:Z41, 3, FALSE)","v":"Argentina"},1]
["Argentina",0.16700000000000001,5,12,"Iran",5.9880239520958076,0.2,8.3333333333333329E-2,0.95482105062142941,3.1891023090755748E-2,1.3287926287814894E-2,0.95482105062142941,0.98671207371218517,1,null,0.24749930708110857,"Argentina",null,"Bosnia & Herzegovina",{"$f":"IF($Q37=$S39, 3, IF($Q37=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q40=$S39, 3, IF($Q40=\"Draw\", 1, 0))","v":1},{"$f":"IF($Q42=$S39, 3, IF($Q42=\"Draw\", 1, 0))","v":1},{"$f":"RAND()/10","v":8.1998491319529548E-2},{"$f":"SUM(T39:W39)","v":2.0819984913195295},{"$f":"VLOOKUP(S39, AH38:AI41, 2, FALSE)","v":4},"Bosnia & Herzegovina","BOS",null,2,{"$f":"VLOOKUP(AC39,Y38:Z41,2, FALSE)","v":"Iran"},{"$f":"VLOOKUP(AD39,Z$38:AA$41,2, FALSE)","v":"IRN"},null,{"$f":"LARGE(X38:X41, 2)","v":4.0998685754318878},{"$f":"VLOOKUP(AG39, X38:Z41, 3, FALSE)","v":"Iran"},2]
["Nigeria",1.625,2,1.5,"Bosnia & Herzegovina",0.61538461538461542,0.5,0.66666666666666663,0.34532374100719426,0.28057553956834536,0.37410071942446044,0.34532374100719426,0.62589928057553967,1,null,0.42245731919944185,"Draw",null,"Iran",{"$f":"IF($Q38=$S40, 3, IF($Q38=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q39=$S40, 3, IF($Q39=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q42=$S40, 3, IF($Q42=\"Draw\", 1, 0))","v":1},9.986857543188736E-2,4.0998685754318878,{"$f":"VLOOKUP(S40, AH38:AI41, 2, FALSE)","v":2},"Iran","IRN",null,3,{"$f":"VLOOKUP(AC40,Y38:Z41,2, FALSE)","v":"Nigeria"},"NIG",null,{"$f":"LARGE(X38:X41, 3)","v":4.0445653493180185},{"$f":"VLOOKUP(AG40, X38:Z41, 3, FALSE)","v":"Nigeria"},3]
["Nigeria",6.5,3.2,0.36399999999999999,"Argentina",0.15384615384615385,0.3125,2.7472527472527473,4.7873477238726231E-2,9.7243000641162647E-2,0.85488352212011121,4.7873477238726231E-2,0.14511647787988888,1,null,9.4589891998153597E-3,"Nigeria",null,"Nigeria",{"$f":"IF($Q38=$S41, 3, IF($Q38=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q40=$S41, 3, IF($Q40=\"Draw\", 1, 0))","v":1},{"$f":"IF($Q41=$S41, 3, IF($Q41=\"Draw\", 1, 0))","v":3},4.4565349318018407E-2,4.0445653493180185,{"$f":"VLOOKUP(S41, AH38:AI41, 2, FALSE)","v":3},"Nigeria","NIG",null,4,{"$f":"VLOOKUP(AC41,Y38:Z41,2, FALSE)","v":"Bosnia & Herzegovina"},"BOS",null,{"$f":"LARGE(X38:X41, 4)","v":2.0819984913195295},{"$f":"VLOOKUP(AG41, X38:Z41, 3, FALSE)","v":"Bosnia & Herzegovina"},4]
["Bosnia & Herzegovina",0.66700000000000004,2.4,3.5,"Iran",1.4992503748125936,0.41666666666666669,0.2857142857142857,0.68097249357534884,0.18925360550614903,0.12977390091850219,0.68097249357534884,0.87022609908149784,1,null,0.71148517510683196,"Draw"]
[]
["Germany",0.83299999999999996,2.25,3,"Portugal",1.2004801920768309,0.44444444444444442,0.33333333333333331,0.60683703054413063,0.22466455397478252,0.16849841548108691,0.60683703054413063,0.83150158451891309,1,null,0.54279647371333084,"Germany",null,"Group G","M1","M2","M3","Ran","Tot","Pos","Group G"]
["Ghana",1.4,2.2000000000000002,1.7,"USA",0.7142857142857143,0.45454545454545453,0.58823529411764708,0.40652173913043482,0.25869565217391305,0.33478260869565224,0.40652173913043482,0.66521739130434787,1,null,0.81538929229574819,"USA",null,"Germany",{"$f":"IF($Q44=$S45, 3, IF($Q44=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q46=$S45, 3, IF($Q46=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q48=$S45, 3, IF($Q48=\"Draw\", 1, 0))","v":0},{"$f":"RAND()/10","v":4.0383765608951072E-2},{"$f":"SUM(T45:W45)","v":6.0403837656089507},{"$f":"VLOOKUP(S45, AH45:AI48, 2, FALSE)","v":2},"Germany","GER",null,1,{"$f":"VLOOKUP(AC45,Y45:Z48,2, FALSE)","v":"Portugal"},{"$f":"VLOOKUP(AD45,Z$45:AA$48,2, FALSE)","v":"POR"},null,{"$f":"LARGE(X45:X48, 1)","v":6.0692478759578297},{"$f":"VLOOKUP(AG45, X45:Z48, 3, FALSE)","v":"Portugal"},1]
["Germany",0.36399999999999999,3.3330000000000002,6,"Ghana",2.7472527472527473,0.30003000300030003,0.16666666666666666,0.85479028785890043,9.335243467765969E-2,5.1857277463439953E-2,0.85479028785890043,0.94814272253656018,1.0000000000000002,null,0.34590156567171271,"Germany",null,"Portugal",{"$f":"IF($Q44=$S46, 3, IF($Q44=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q47=$S46, 3, IF($Q47=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q49=$S46, 3, IF($Q49=\"Draw\", 1, 0))","v":3},{"$f":"RAND()/10","v":6.9247875957829386E-2},{"$f":"SUM(T46:W46)","v":6.0692478759578297},{"$f":"VLOOKUP(S46, AH45:AI48, 2, FALSE)","v":1},"Portugal","POR",null,2,{"$f":"VLOOKUP(AC46,Y45:Z48,2, FALSE)","v":"Germany"},{"$f":"VLOOKUP(AD46,Z$45:AA$48,2, FALSE)","v":"GER"},null,{"$f":"LARGE(X45:X48, 2)","v":6.0403837656089507},{"$f":"VLOOKUP(AG46, X45:Z48, 3, FALSE)","v":"Germany"},2]
["USA",4,2.2999999999999998,0.66700000000000004,"Portugal",0.25,0.43478260869565222,1.4992503748125936,0.11446713574738288,0.19907327956066589,0.68645958469195123,0.11446713574738288,0.31354041530804877,1,null,0.54085205082224663,"Portugal",null,"Ghana",{"$f":"IF($Q45=$S47, 3, IF($Q45=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q46=$S47, 3, IF($Q46=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q49=$S47, 3, IF($Q49=\"Draw\", 1, 0))","v":0},1.0061761704463346E-2,1.0061761704463346E-2,{"$f":"VLOOKUP(S47, AH45:AI48, 2, FALSE)","v":4},"Ghana","GHA",null,3,{"$f":"VLOOKUP(AC47,Y45:Z48,2, FALSE)","v":"USA"},"USA",null,{"$f":"LARGE(X45:X48, 3)","v":6.0069861227285033},{"$f":"VLOOKUP(AG47, X45:Z48, 3, FALSE)","v":"USA"},3]
["USA",6,3,0.4,"Germany",0.16666666666666666,0.33333333333333331,2.5,5.5555555555555552E-2,0.1111111111111111,0.83333333333333337,5.5555555555555552E-2,0.16666666666666666,1,null,4.7062633113191144E-2,"USA",null,"USA",{"$f":"IF($Q45=$S48, 3, IF($Q45=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q47=$S48, 3, IF($Q47=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q48=$S48, 3, IF($Q48=\"Draw\", 1, 0))","v":3},6.9861227285036073E-3,6.0069861227285033,{"$f":"VLOOKUP(S48, AH45:AI48, 2, FALSE)","v":3},"USA","USA",null,4,{"$f":"VLOOKUP(AC48,Y45:Z48,2, FALSE)","v":"Ghana"},"GHA",null,{"$f":"LARGE(X45:X48, 4)","v":1.0061761704463346E-2},{"$f":"VLOOKUP(AG48, X45:Z48, 3, FALSE)","v":"Ghana"},4]
["Portugal",0.75,2.5,3,"Ghana",1.3333333333333333,0.4,0.33333333333333331,0.64516129032258052,0.19354838709677419,0.16129032258064513,0.64516129032258052,0.83870967741935476,0.99999999999999989,null,0.57909938457959087,"Portugal"]
[]
["Belgium",0.4,3,5.5,"Algeria",2.5,0.33333333333333331,0.18181818181818182,0.82914572864321612,0.11055276381909547,6.0301507537688447E-2,0.82914572864321612,0.93969849246231163,1,null,0.51644955024456529,"Belgium",null,"Group H","M1","M2","M3","Ran","Tot","Pos","Group H"]
["Russia",1,2.1,2.5,"South Korea",1,0.47619047619047616,0.4,0.53299492385786806,0.25380710659898476,0.21319796954314721,0.53299492385786806,0.78680203045685282,1,null,0.58764451653972749,"Draw",null,"Belgium",{"$f":"IF($Q51=$S52, 3, IF($Q51=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q53=$S52, 3, IF($Q53=\"Draw\", 1, 0))","v":1},{"$f":"IF($Q55=$S52, 3, IF($Q55=\"Draw\", 1, 0))","v":1},{"$f":"RAND()/10","v":4.7540927797238695E-2},{"$f":"SUM(T52:W52)","v":5.0475409277972387},{"$f":"VLOOKUP(S52, AH52:AI55, 2, FALSE)","v":2},"Belgium","BEL",null,1,{"$f":"VLOOKUP(AC52,Y52:Z55,2, FALSE)","v":"South Korea"},{"$f":"VLOOKUP(AD52,Z$52:AA$55,2, FALSE)","v":"SKO"},null,{"$f":"LARGE(X52:X55, 1)","v":5.0482668720554047},{"$f":"VLOOKUP(AG52, X52:Z55, 3, FALSE)","v":"South Korea"},1]
["Belgium",1.05,2.2000000000000002,2.2000000000000002,"Russia",0.95238095238095233,0.45454545454545453,0.45454545454545453,0.5116279069767441,0.2441860465116279,0.2441860465116279,0.5116279069767441,0.75581395348837199,0.99999999999999989,null,0.60525409076396552,"Draw",null,"Algeria",{"$f":"IF($Q51=$S53, 3, IF($Q51=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q54=$S53, 3, IF($Q54=\"Draw\", 1, 0))","v":0},{"$f":"IF($Q56=$S53, 3, IF($Q56=\"Draw\", 1, 0))","v":1},{"$f":"RAND()/10","v":8.2769730007291195E-2},{"$f":"SUM(T53:W53)","v":1.0827697300072912},{"$f":"VLOOKUP(S53, AH52:AI55, 2, FALSE)","v":4},"Algeria","ALG",null,2,{"$f":"VLOOKUP(AC53,Y52:Z55,2, FALSE)","v":"Belgium"},{"$f":"VLOOKUP(AD53,Z$52:AA$55,2, FALSE)","v":"BEL"},null,{"$f":"LARGE(X52:X55, 2)","v":5.0475409277972387},{"$f":"VLOOKUP(AG53, X52:Z55, 3, FALSE)","v":"Belgium"},2]
["South Korea",1.1499999999999999,2,2.2999999999999998,"Algeria",0.86956521739130443,0.5,0.43478260869565222,0.48192771084337355,0.27710843373493976,0.24096385542168677,0.48192771084337355,0.75903614457831337,1.0000000000000002,null,0.43143226806427137,"South Korea",null,"Russia",{"$f":"IF($Q52=$S54, 3, IF($Q52=\"Draw\", 1, 0))","v":1},{"$f":"IF($Q53=$S54, 3, IF($Q53=\"Draw\", 1, 0))","v":1},{"$f":"IF($Q56=$S54, 3, IF($Q56=\"Draw\", 1, 0))","v":1},8.0857842291240323E-2,3.0808578422912403,{"$f":"VLOOKUP(S54, AH52:AI55, 2, FALSE)","v":3},"Russia","RUS",null,3,{"$f":"VLOOKUP(AC54,Y52:Z55,2, FALSE)","v":"Russia"},"RUS",null,{"$f":"LARGE(X52:X55, 3)","v":3.0808578422912403},{"$f":"VLOOKUP(AG54, X52:Z55, 3, FALSE)","v":"Russia"},3]
["South Korea",4,2.5,0.61499999999999999,"Belgium",0.25,0.4,1.6260162601626016,0.10984104304340062,0.17574566886944099,0.71441328808715843,0.10984104304340062,0.28558671191284157,1,null,0.20792984035309159,"Draw",null,"South Korea",{"$f":"IF($Q52=$S55, 3, IF($Q52=\"Draw\", 1, 0))","v":1},{"$f":"IF($Q54=$S55, 3, IF($Q54=\"Draw\", 1, 0))","v":3},{"$f":"IF($Q55=$S55, 3, IF($Q55=\"Draw\", 1, 0))","v":1},4.8266872055404766E-2,5.0482668720554047,{"$f":"VLOOKUP(S55, AH52:AI55, 2, FALSE)","v":1},"South Korea","SKO",null,4,{"$f":"VLOOKUP(AC55,Y52:Z55,2, FALSE)","v":"Algeria"},"ALG",null,{"$f":"LARGE(X52:X55, 4)","v":1.0827697300072912},{"$f":"VLOOKUP(AG55, X52:Z55, 3, FALSE)","v":"Algeria"},4]
["Algeria",4,2.5,0.61499999999999999,"Russia",0.25,0.4,1.6260162601626016,0.10984104304340062,0.17574566886944099,0.71441328808715843,0.10984104304340062,0.28558671191284157,1,null,0.16245816140081626,"Draw"]

{"sheet":"Knockout Rounds","index":2,"n_rows":30,"n_cols":33,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,4],[12,0,12,4],[19,0,19,4],[28,0,28,4],[24,0,24,4]]}
["Round of 16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1T","2T","1T/2T","2T/1T","1WC","1WE","2WC","2WE","1DC","1DE","2DC","2DE","1DO","2DO"]
["Team 1","1W","D","2W","Team 2",null,null,null,null,null,null,"C1","C2","C3",null,"Rand","Result","Rand2"]
[{"$f":"'Group Stage'!AD3","v":"Brazil"},{"$f":"X3*(V3^Y3)","v":0.20203485821945716},{"$f":"AVERAGE(AF3:AG3)","v":4.2178471059441325},{"$f":"Z3*(W3^AA3)","v":12},{"$f":"'Group Stage'!AD11","v":"Australia"},{"$f":"1/B3","v":4.9496409125288956},{"$f":"1/C3","v":0.23708777840494},8.3333333333333329E-2,{"$f":"F3/($F3+$G3+$H3)","v":0.9391997456077702},{"$f":"G3/($F3+$G3+$H3)","v":4.4987663771928442E-2},{"$f":"H3/($F3+$G3+$H3)","v":1.5812590620301339E-2},{"$f":"I3","v":0.9391997456077702},{"$f":"I3+J3","v":0.98418740937969862},{"$f":"I3+J3+K3","v":1},null,{"$f":"RAND()","v":0.28894327070566805},{"$f":"IF(P3<L3, A3, IF(P3<M3, IF(R3<0.5, A3, E3), E3))","v":"Brazil"},{"$f":"RAND()","v":0.74961024449765123},null,{"$f":"VLOOKUP(A3, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":2.9},{"$f":"VLOOKUP(E3, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":850},{"$f":"T3/U3","v":3.4117647058823529E-3},{"$f":"U3/T3","v":293.10344827586209},{"$f":"VLOOKUP(V3, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(V3, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(W3, KOCoeffs!$J$14:$K$17, 2)","v":12},{"$f":"VLOOKUP(W3, KOCoeffs!$J$14:$L$17, 3)","v":0},{"$f":"VLOOKUP(V3, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(V3, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"VLOOKUP(W3, KOCoeffs!$J$14:$M$17, 4)","v":4.5},{"$f":"VLOOKUP(W3, KOCoeffs!$J$14:$N$17, 5)","v":0},{"$f":"AB3*(V3^AC3)","v":3.9356942118882645},{"$f":"AD3*(W3^AE3)","v":4.5}]
[{"$f":"'Group Stage'!AD17","v":"Colombia"},{"$f":"X4*(V4^Y4)","v":1.5659651136073058},{"$f":"AVERAGE(AF4:AG4)","v":1.9651320486683397},{"$f":"Z4*(W4^AA4)","v":1.631754233055569},{"$f":"'Group Stage'!AD25","v":"Uruguay"},{"$f":"1/B4","v":0.63858383006785691},0.50887165606893658,0.61283738674753307,{"$f":"F4/($F4+$G4+$H4)","v":0.36277135464481314},0.28908351780980934,0.34814512754537769,{"$f":"I4","v":0.36277135464481314},{"$f":"I4+J4","v":0.65185487245462248},{"$f":"I4+J4+K4","v":1.0000000000000002},null,{"$f":"RAND()","v":0.37638314588217114},{"$f":"IF(P4<L4, A4, IF(P4<M4, IF(R4<0.5, A4, E4), E4))","v":"Colombia"},3.8507299218835001E-2,null,{"$f":"VLOOKUP(A4, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":27},{"$f":"VLOOKUP(E4, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":26.2},{"$f":"T4/U4","v":1.0305343511450382},{"$f":"U4/T4","v":0.97037037037037033},{"$f":"VLOOKUP(V4, KOCoeffs!$J$14:$K$17, 2)","v":1.55},{"$f":"VLOOKUP(V4, KOCoeffs!$J$14:$L$17, 3)","v":0.3407},{"$f":"VLOOKUP(W4, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(W4, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(V4, KOCoeffs!$J$14:$M$17, 4)","v":2.0499999999999998},{"$f":"VLOOKUP(V4, KOCoeffs!$J$14:$N$17, 5)","v":4.6699999999999998E-2},{"$f":"VLOOKUP(W4, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(W4, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"AB4*(V4^AC4)","v":2.052881488397412},{"$f":"AD4*(W4^AE4)","v":1.8773826089392676}]
[{"$f":"'Group Stage'!AD31","v":"Ecuador"},0.7043425806334066,2.4462140149012517,3.8408734278867063,{"$f":"'Group Stage'!AD39","v":"Iran"},1.4197636597530598,0.40879497619931993,0.26035744701699576,0.67966524425187935,0.19569717497613476,0.12463758077198581,0.67966524425187935,0.87536241922801405,0.99999999999999989,null,0.70245664166696631,"Iran",0.61741754241071845,null,{"$f":"VLOOKUP(A5, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":145},{"$f":"VLOOKUP(E5, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":1450},0.1,10,{"$f":"VLOOKUP(V5, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(V5, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(W5, KOCoeffs!$J$14:$K$17, 2)","v":2},{"$f":"VLOOKUP(W5, KOCoeffs!$J$14:$L$17, 3)","v":0.28339999999999999},{"$f":"VLOOKUP(V5, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(V5, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"VLOOKUP(W5, KOCoeffs!$J$14:$M$17, 4)","v":1.58},{"$f":"VLOOKUP(W5, KOCoeffs!$J$14:$N$17, 5)","v":0.17499999999999999},2.5283756931732984,2.364052336629205]
[{"$f":"'Group Stage'!AD45","v":"Portugal"},1.8624466726562201,2.0545334473290739,1.3518963109448991,{"$f":"'Group Stage'!AD53","v":"Belgium"},0.53692812507420717,0.48672850826547304,0.73970170042187366,0.30449178411108591,0.27602359596826553,0.41948461992064867,0.30449178411108591,0.58051538007935144,1,null,2.2426605546916889E-2,"Portugal",0.70175596399645224,null,{"$f":"VLOOKUP(A6, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":28.8},{"$f":"VLOOKUP(E6, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":16.8},1.7142857142857142,0.58333333333333337,{"$f":"VLOOKUP(V6, KOCoeffs!$J$14:$K$17, 2)","v":1.55},{"$f":"VLOOKUP(V6, KOCoeffs!$J$14:$L$17, 3)","v":0.3407},{"$f":"VLOOKUP(W6, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(W6, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(V6, KOCoeffs!$J$14:$M$17, 4)","v":2.0499999999999998},{"$f":"VLOOKUP(V6, KOCoeffs!$J$14:$N$17, 5)","v":4.6699999999999998E-2},{"$f":"VLOOKUP(W6, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(W6, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},2.1022557391580343,2.0068111555001136]
[{"$f":"'Group Stage'!AD10","v":"Chile"},1.0440768924274191,2.1856070766188989,2.3631576783640784,{"$f":"'Group Stage'!AD4","v":"Mexico"},0.95778386367220247,0.45753878210670185,0.42316262226406359,0.52096357818071881,0.24886725504944787,0.23016916676983332,0.52096357818071881,0.76983083323016666,1,null,0.98418275132800481,"Mexico",2.6982685573299747E-2,null,{"$f":"VLOOKUP(A7, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":40.6},{"$f":"VLOOKUP(E7, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":140},0.29000000000000004,3.4482758620689653,{"$f":"VLOOKUP(V7, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(V7, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(W7, KOCoeffs!$J$14:$K$17, 2)","v":1.55},{"$f":"VLOOKUP(W7, KOCoeffs!$J$14:$L$17, 3)","v":0.3407},{"$f":"VLOOKUP(V7, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(V7, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"VLOOKUP(W7, KOCoeffs!$J$14:$M$17, 4)","v":2.0499999999999998},{"$f":"VLOOKUP(W7, KOCoeffs!$J$14:$N$17, 5)","v":4.6699999999999998E-2},2.1992138849873033,2.1720002682504944]
[{"$f":"'Group Stage'!AD24","v":"England"},0.94496740303327642,2.2389322925347956,2.5906610213484211,{"$f":"'Group Stage'!AD18","v":"Ivory Coast"},1.0582375612006012,0.44664146536912697,0.3860018704722345,0.559653208647925,0.23620814302362433,0.20413864832845063,0.559653208647925,0.79586135167154937,1,null,0.43493617719440403,"England",0.46676891548512001,null,{"$f":"VLOOKUP(A8, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":31},{"$f":"VLOOKUP(E8, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":140},0.22142857142857142,4.5161290322580649,{"$f":"VLOOKUP(V8, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(V8, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(W8, KOCoeffs!$J$14:$K$17, 2)","v":1.55},{"$f":"VLOOKUP(W8, KOCoeffs!$J$14:$L$17, 3)","v":0.3407},{"$f":"VLOOKUP(V8, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(V8, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"VLOOKUP(W8, KOCoeffs!$J$14:$M$17, 4)","v":2.0499999999999998},{"$f":"VLOOKUP(W8, KOCoeffs!$J$14:$N$17, 5)","v":4.6699999999999998E-2},2.2783266872919468,2.1995378977776445]
[{"$f":"'Group Stage'!AD38","v":"Argentina"},0.51492375390310885,2.7835458984430321,4.8833136181513783,{"$f":"'Group Stage'!AD32","v":"Switzerland"},{"$f":"1/B9","v":1.942035092419073},{"$f":"1/C9","v":0.35925400064692553},{"$f":"1/D9","v":0.20477898373820988},{"$f":"F9/($F9+$G9+$H9)","v":0.77493309555085899},{"$f":"G9/($F9+$G9+$H9)","v":0.14335364788056912},{"$f":"H9/($F9+$G9+$H9)","v":8.1713256568571924E-2},{"$f":"I9","v":0.77493309555085899},{"$f":"I9+J9","v":0.91828674343142813},{"$f":"I9+J9+K9","v":1},null,0.75265609368469977,"Argentina",0.18819372022501957,null,{"$f":"VLOOKUP(A9, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":4.5},{"$f":"VLOOKUP(E9, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":105},4.2857142857142858E-2,23.333333333333332,{"$f":"VLOOKUP(V9, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(V9, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(W9, KOCoeffs!$J$14:$K$17, 2)","v":2},{"$f":"VLOOKUP(W9, KOCoeffs!$J$14:$L$17, 3)","v":0.28339999999999999},{"$f":"VLOOKUP(V9, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(V9, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"VLOOKUP(W9, KOCoeffs!$J$14:$M$17, 4)","v":1.58},{"$f":"VLOOKUP(W9, KOCoeffs!$J$14:$N$17, 5)","v":0.17499999999999999},2.8251828770989658,2.7419089197870985]
[{"$f":"'Group Stage'!AD52","v":"South Korea"},6.798644893368734,3.3278114431247774,0.33440579523890157,{"$f":"'Group Stage'!AD46","v":"Germany"},0.1470881353099322,0.30049779474915539,2.9903787979678818,4.2783491671930365E-2,8.7405723595544146E-2,0.86981078473252549,4.2783491671930365E-2,0.13018921526747451,1,null,0.17092198076198784,"Germany",0.42497415686405671,null,{"$f":"VLOOKUP(A10, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":390},{"$f":"VLOOKUP(E10, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":5.2},75,1.3333333333333334E-2,{"$f":"VLOOKUP(V10, KOCoeffs!$J$14:$K$17, 2)","v":2},{"$f":"VLOOKUP(V10, KOCoeffs!$J$14:$L$17, 3)","v":0.28339999999999999},{"$f":"VLOOKUP(W10, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(W10, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(V10, KOCoeffs!$J$14:$M$17, 4)","v":1.58},{"$f":"VLOOKUP(V10, KOCoeffs!$J$14:$N$17, 5)","v":0.17499999999999999},{"$f":"VLOOKUP(W10, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(W10, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},3.3635106570117008,3.2921122292378535]
[]
[]
["Quarter-finals"]
[{"$f":"Q3","v":"Brazil"},{"$f":"X14*(V14^Y14)","v":0.72319813987483039},{"$f":"AVERAGE(AF14:AG14)","v":2.3899695110016572},{"$f":"Z14*(W14^AA14)","v":3.3148076674487474},{"$f":"Q4","v":"Colombia"},{"$f":"1/B14","v":1.3827469193616537},{"$f":"1/C14","v":0.41841537952544472},{"$f":"1/D14","v":0.30167662812535162},{"$f":"F14/($F14+$G14+$H14)","v":0.65756197566979269},{"$f":"G14/($F14+$G14+$H14)","v":0.19897642855598871},{"$f":"H14/($F14+$G14+$H14)","v":0.14346159577421858},{"$f":"I14","v":0.65756197566979269},{"$f":"I14+J14","v":0.85653840422578142},{"$f":"I14+J14+K14","v":1},null,{"$f":"RAND()","v":0.4381058385080645},"Brazil",{"$f":"RAND()","v":0.36457680890153998},null,{"$f":"VLOOKUP(A14, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":2.9},{"$f":"VLOOKUP(E14, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":27},0.10740740740740741,9.3103448275862064,{"$f":"VLOOKUP(V14, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(V14, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(W14, KOCoeffs!$J$14:$K$17, 2)","v":1.55},{"$f":"VLOOKUP(W14, KOCoeffs!$J$14:$L$17, 3)","v":0.3407},{"$f":"VLOOKUP(V14, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(V14, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"VLOOKUP(W14, KOCoeffs!$J$14:$M$17, 4)","v":2.0499999999999998},{"$f":"VLOOKUP(W14, KOCoeffs!$J$14:$N$17, 5)","v":4.6699999999999998E-2},2.5048176908060991,2.2751213311972154]
[{"$f":"Q5","v":"Iran"},{"$f":"X15*(V15^Y15)","v":6.0725326209882828},{"$f":"AVERAGE(AF15:AG15)","v":3.1307791624600596},{"$f":"Z15*(W15^AA15)","v":0.38749276361155399},{"$f":"Q6","v":"Portugal"},{"$f":"1/B15","v":0.16467593711126965},0.31940930615311558,2.5806933545795454,{"$f":"F15/($F15+$G15+$H15)","v":5.373175642348816E-2},{"$f":"G15/($F15+$G15+$H15)","v":0.10421937375111526},0.84204886982539651,{"$f":"I15","v":5.373175642348816E-2},{"$f":"I15+J15","v":0.15795113017460341},{"$f":"I15+J15+K15","v":0.99999999999999989},null,{"$f":"RAND()","v":9.2524277126513566E-2},"Iran",0.48633504433417563,null,{"$f":"VLOOKUP(A15, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":1450},{"$f":"VLOOKUP(E15, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":28.8},50.347222222222221,1.9862068965517243E-2,{"$f":"VLOOKUP(V15, KOCoeffs!$J$14:$K$17, 2)","v":2},{"$f":"VLOOKUP(V15, KOCoeffs!$J$14:$L$17, 3)","v":0.28339999999999999},{"$f":"VLOOKUP(W15, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(W15, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(V15, KOCoeffs!$J$14:$M$17, 4)","v":1.58},{"$f":"VLOOKUP(V15, KOCoeffs!$J$14:$N$17, 5)","v":0.17499999999999999},{"$f":"VLOOKUP(W15, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(W15, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},3.1369153688908997,3.1246429560292195]
[{"$f":"Q7","v":"Mexico"},2.5906610213484211,2.2389322925347956,0.94496740303327642,{"$f":"Q8","v":"England"},0.3860018704722345,0.44664146536912697,1.0582375612006012,0.20413864832845063,0.23620814302362433,0.559653208647925,0.20413864832845063,0.440346791352075,1,null,0.38083661221050058,"Mexico",0.19377956895495685,null,{"$f":"VLOOKUP(A16, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(E16, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":31},4.5161290322580649,0.22142857142857142,{"$f":"VLOOKUP(V16, KOCoeffs!$J$14:$K$17, 2)","v":1.55},{"$f":"VLOOKUP(V16, KOCoeffs!$J$14:$L$17, 3)","v":0.3407},{"$f":"VLOOKUP(W16, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(W16, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(V16, KOCoeffs!$J$14:$M$17, 4)","v":2.0499999999999998},{"$f":"VLOOKUP(V16, KOCoeffs!$J$14:$N$17, 5)","v":4.6699999999999998E-2},{"$f":"VLOOKUP(W16, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(W16, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},2.1995378977776445,2.2783266872919468]
[{"$f":"Q9","v":"Argentina"},1.5641203786711635,1.9848219602858981,1.6282629237039319,{"$f":"Q10","v":"Germany"},0.63933698047561682,0.50382352674894726,0.6141514281521715,0.36381530655145444,0.28670124899648886,0.34948344445205659,0.36381530655145444,0.6505165555479433,0.99999999999999989,null,0.65203901866000136,"Germany",0.84959373521328752,null,{"$f":"VLOOKUP(A17, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":4.5},{"$f":"VLOOKUP(E17, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":5.2},0.86538461538461531,1.1555555555555557,{"$f":"VLOOKUP(V17, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(V17, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(W17, KOCoeffs!$J$14:$K$17, 2)","v":1.55},{"$f":"VLOOKUP(W17, KOCoeffs!$J$14:$L$17, 3)","v":0.3407},{"$f":"VLOOKUP(V17, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(V17, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"VLOOKUP(W17, KOCoeffs!$J$14:$M$17, 4)","v":2.0499999999999998},{"$f":"VLOOKUP(W17, KOCoeffs!$J$14:$N$17, 5)","v":4.6699999999999998E-2},1.9057556028265326,2.0638883177452638]
[]
[]
["Semi-finals"]
[{"$f":"Q14","v":"Brazil"},{"$f":"X21*(V21^Y21)","v":0.16583444192912505},{"$f":"AVERAGE(AF21:AG21)","v":4.3604578430979437},{"$f":"Z21*(W21^AA21)","v":12},{"$f":"Q15","v":"Iran"},{"$f":"1/B21","v":6.0301104424820497},{"$f":"1/C21","v":0.22933371585804327},{"$f":"1/D21","v":8.3333333333333329E-2},{"$f":"F21/($F21+$G21+$H21)","v":0.95070502637025578},{"$f":"G21/($F21+$G21+$H21)","v":3.615667050580041E-2},{"$f":"H21/($F21+$G21+$H21)","v":1.313830312394379E-2},{"$f":"I21","v":0.95070502637025578},{"$f":"I21+J21","v":0.98686169687605618},{"$f":"I21+J21+K21","v":1},null,{"$f":"RAND()","v":0.11560202143446319},{"$f":"IF(P21<L21, A21, IF(P21<M21, IF(R21<0.5, A21, E21), E21))","v":"Brazil"},{"$f":"RAND()","v":0.72510229370738888},null,{"$f":"VLOOKUP(A21, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":2.9},{"$f":"VLOOKUP(E21, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":1450},2E-3,500,{"$f":"VLOOKUP(V21, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(V21, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(W21, KOCoeffs!$J$14:$K$17, 2)","v":12},{"$f":"VLOOKUP(W21, KOCoeffs!$J$14:$L$17, 3)","v":0},{"$f":"VLOOKUP(V21, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(V21, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"VLOOKUP(W21, KOCoeffs!$J$14:$M$17, 4)","v":4.5},{"$f":"VLOOKUP(W21, KOCoeffs!$J$14:$N$17, 5)","v":0},4.2209156861958874,4.5]
[{"$f":"Q16","v":"Mexico"},{"$f":"X22*(V22^Y22)","v":5.0854259330413285},{"$f":"AVERAGE(AF22:AG22)","v":2.8450422266854973},{"$f":"Z22*(W22^AA22)","v":0.48839009285719071},{"$f":"Q17","v":"Germany"},{"$f":"1/B22","v":0.19664036270840976},0.35148863191567109,2.0475435817089931,{"$f":"F22/($F22+$G22+$H22)","v":7.5756998205915888E-2},{"$f":"G22/($F22+$G22+$H22)","v":0.13541331642537968},0.78882968536870435,{"$f":"I22","v":7.5756998205915888E-2},{"$f":"I22+J22","v":0.21117031463129557},{"$f":"I22+J22+K22","v":0.99999999999999989},null,{"$f":"RAND()","v":0.16764981520337019},{"$f":"IF(P22<L22, A22, IF(P22<M22, IF(R22<0.5, A22, E22), E22))","v":"Mexico"},0.30028721504030131,null,{"$f":"VLOOKUP(A22, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(E22, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":5.2},26.923076923076923,3.7142857142857144E-2,{"$f":"VLOOKUP(V22, KOCoeffs!$J$14:$K$17, 2)","v":2},{"$f":"VLOOKUP(V22, KOCoeffs!$J$14:$L$17, 3)","v":0.28339999999999999},{"$f":"VLOOKUP(W22, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(W22, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(V22, KOCoeffs!$J$14:$M$17, 4)","v":1.58},{"$f":"VLOOKUP(V22, KOCoeffs!$J$14:$N$17, 5)","v":0.17499999999999999},{"$f":"VLOOKUP(W22, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(W22, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},2.811440573299147,2.8786438800718481]
[]
[]
["Third-placed play-off"]
[{"$f":"IF(P21<L21, E21, IF(P21<M21, IF(R21<0.5, E21, A21), A21))","v":"Iran"},{"$f":"X26*(V26^Y26)","v":12},{"$f":"AVERAGE(AF26:AG26)","v":4.2050342995180117},{"$f":"Z26*(W26^AA26)","v":0.20579396272360984},{"$f":"IF(P22<L22, E22, IF(P22<M22, IF(R22<0.5, E22, A22), A22))","v":"Germany"},{"$f":"1/B26","v":8.3333333333333329E-2},{"$f":"1/C26","v":0.23781018863856157},{"$f":"1/D26","v":4.8592290403729823},{"$f":"F26/($F26+$G26+$H26)","v":1.6086359104568491E-2},{"$f":"G26/($F26+$G26+$H26)","v":4.5906001117980912E-2},{"$f":"H26/($F26+$G26+$H26)","v":0.9380076397774505},{"$f":"I26","v":1.6086359104568491E-2},{"$f":"I26+J26","v":6.1992360222549406E-2},{"$f":"I26+J26+K26","v":0.99999999999999989},null,{"$f":"RAND()","v":0.25755174097673561},{"$f":"IF(P26<L26, A26, IF(P26<M26, IF(R26<0.5, A26, E26), E26))","v":"Germany"},{"$f":"RAND()","v":6.5350267988749655E-3},null,{"$f":"VLOOKUP(A26, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":1450},{"$f":"VLOOKUP(E26, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":5.2},{"$f":"T26/U26","v":278.84615384615381},{"$f":"U26/T26","v":3.5862068965517241E-3},{"$f":"VLOOKUP(V26, KOCoeffs!$J$14:$K$17, 2)","v":12},{"$f":"VLOOKUP(V26, KOCoeffs!$J$14:$L$17, 3)","v":0},{"$f":"VLOOKUP(W26, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(W26, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(V26, KOCoeffs!$J$14:$M$17, 4)","v":4.5},{"$f":"VLOOKUP(V26, KOCoeffs!$J$14:$N$17, 5)","v":0},{"$f":"VLOOKUP(W26, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(W26, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"AB26*(V26^AC26)","v":4.5},{"$f":"AD26*(W26^AE26)","v":3.9100685990360242}]
[]
[]
["Final"]
[{"$f":"Q21","v":"Brazil"},{"$f":"X30*(V30^Y30)","v":0.39355818519059949},{"$f":"AVERAGE(AF30:AG30)","v":3.1107153729443247},{"$f":"Z30*(W30^AA30)","v":6.0006609426153661},{"$f":"Q22","v":"Mexico"},{"$f":"1/B30","v":2.5409203457824208},{"$f":"1/C30","v":0.32146946284368327},{"$f":"1/D30","v":0.16664830917178161},{"$f":"F30/($F30+$G30+$H30)","v":0.83885386943551343},{"$f":"G30/($F30+$G30+$H30)","v":0.1061292233183886},{"$f":"H30/($F30+$G30+$H30)","v":5.5016907246098028E-2},{"$f":"I30","v":0.83885386943551343},{"$f":"I30+J30","v":0.94498309275390202},{"$f":"I30+J30+K30","v":1},null,{"$f":"RAND()","v":0.26403530692062949},"Brazil",{"$f":"RAND()","v":6.9872705412446723E-2},null,{"$f":"VLOOKUP(A30, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":2.9},{"$f":"VLOOKUP(E30, KOCoeffs!$A$2:$B$33, 2, FALSE)","v":140},2.0714285714285713E-2,48.275862068965516,{"$f":"VLOOKUP(V30, KOCoeffs!$J$14:$K$17, 2)","v":1.65},{"$f":"VLOOKUP(V30, KOCoeffs!$J$14:$L$17, 3)","v":0.36969999999999997},{"$f":"VLOOKUP(W30, KOCoeffs!$J$14:$K$17, 2)","v":2},{"$f":"VLOOKUP(W30, KOCoeffs!$J$14:$L$17, 3)","v":0.28339999999999999},{"$f":"VLOOKUP(V30, KOCoeffs!$J$14:$M$17, 4)","v":1.87},{"$f":"VLOOKUP(V30, KOCoeffs!$J$14:$N$17, 5)","v":-0.13100000000000001},{"$f":"VLOOKUP(W30, KOCoeffs!$J$14:$M$17, 4)","v":1.58},{"$f":"VLOOKUP(W30, KOCoeffs!$J$14:$N$17, 5)","v":0.17499999999999999},3.1074935901028962,3.1139371557857531]

{"sheet":"OddsCreation","index":3,"n_rows":97,"n_cols":14,"rows_kept":97,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"T1C","T2C","T1/T2","W","D"]
["Brazil",0.3,3.6,"Croatia",{"$f":"VLOOKUP(A2, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},{"$f":"VLOOKUP(D2, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},{"$f":"E2/F2","v":1.7575757575757574E-2},{"$f":"B2","v":0.3},{"$f":"C2","v":3.6}]
["Mexico",1.1499999999999999,2,"Cameroon",{"$f":"VLOOKUP(A3, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D3, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},{"$f":"E3/F3","v":0.17499999999999999},{"$f":"B3","v":1.1499999999999999},{"$f":"C3","v":2}]
["Brazil",0.36399999999999999,3.3330000000000002,"Mexico",{"$f":"VLOOKUP(A4, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},{"$f":"VLOOKUP(D4, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},2.0714285714285713E-2,0.36399999999999999,3.3330000000000002]
["Cameroon",2.4,2,"Croatia",{"$f":"VLOOKUP(A5, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},{"$f":"VLOOKUP(D5, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},4.8484848484848486,2.4,2]
["Cameroon",12,4,"Brazil",{"$f":"VLOOKUP(A6, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},{"$f":"VLOOKUP(D6, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},275.86206896551727,12,4,null,null,"Croatia",3.6,"Brazil"]
["Croatia",1.5,2.2999999999999998,"Mexico",{"$f":"VLOOKUP(A7, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},{"$f":"VLOOKUP(D7, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},1.1785714285714286,1.5,2.2999999999999998,null,null,"Iran",5,"Argentina"]
["Spain",1,2.1,"Netherlands",{"$f":"VLOOKUP(A8, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},{"$f":"VLOOKUP(D8, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},0.21126760563380284,1,2.1,null,null,"Cameroon",4,"Brazil"]
["Chile",0.5,2.75,"Australia",{"$f":"VLOOKUP(A9, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},{"$f":"VLOOKUP(D9, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},4.7764705882352945E-2,0.5,2.75,null,null,"Australia",4,"Spain"]
["Australia",5.5,3.5,"Netherlands",{"$f":"VLOOKUP(A10, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},{"$f":"VLOOKUP(D10, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},29.929577464788736,5.5,3.5,null,null,"Honduras",3.5,"France"]
["Spain",0.7,2.4,"Chile",{"$f":"VLOOKUP(A11, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},{"$f":"VLOOKUP(D11, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},0.14778325123152708,0.7,2.4,null,null,"Costa Rica",3.5,"Italy"]
["Australia",8,4,"Spain",{"$f":"VLOOKUP(A12, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},{"$f":"VLOOKUP(D12, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},141.66666666666666,8,4,null,null,"Costa Rica",3.2,"Uruguay"]
["Netherlands",1.2,2.2999999999999998,"Chile",{"$f":"VLOOKUP(A13, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},{"$f":"VLOOKUP(D13, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},0.6995073891625615,1.2,2.2999999999999998,null,null,"Algeria",3,"Belgium"]
["Colombia",0.7,2.4,"Greece",{"$f":"VLOOKUP(A14, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},{"$f":"VLOOKUP(D14, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},0.1,0.7,2.4,null,null,"Costa Rica",2.8,"England"]
["Ivory Coast",1.5,2,"Japan",{"$f":"VLOOKUP(A15, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D15, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},0.90322580645161288,1.5,2,null,null,"Nigeria",3.2,"Argentina"]
["Colombia",1,2.25,"Ivory Coast",{"$f":"VLOOKUP(A16, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},{"$f":"VLOOKUP(D16, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},0.19285714285714287,1,2.25,null,null,"Mexico",3.3330000000000002,"Brazil"]
["Japan",1.3,2,"Greece",{"$f":"VLOOKUP(A17, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},{"$f":"VLOOKUP(D17, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},0.57407407407407407,1.3,2,null,null,"Ghana",3.3330000000000002,"Germany"]
["Japan",2.75,2.5,"Colombia",{"$f":"VLOOKUP(A18, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},{"$f":"VLOOKUP(D18, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},5.7407407407407405,2.75,2.5,null,null,"Bosnia & Herzegovina",3.3330000000000002,"Argentina"]
["Greece",1.8,2.25,"Ivory Coast",{"$f":"VLOOKUP(A19, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},{"$f":"VLOOKUP(D19, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},1.9285714285714286,1.8,2.25,null,null,"USA",3,"Germany"]
["Uruguay",0.33,3.2,"Costa Rica",{"$f":"VLOOKUP(A20, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},{"$f":"VLOOKUP(D20, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},1.1909090909090909E-2,0.33,3.2,null,null,"Australia",3.5,"Netherlands"]
["England",2,1.8,"Italy",{"$f":"VLOOKUP(A21, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},{"$f":"VLOOKUP(D21, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},1.324786324786325,2,1.8,null,null,"South Korea",2.5,"Belgium"]
["Uruguay",1.6,2.1,"England",{"$f":"VLOOKUP(A22, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},{"$f":"VLOOKUP(D22, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},0.84516129032258058,1.6,2.1,null,null,"Australia",2.75,"Chile"]
["Italy",0.33300000000000002,3.5,"Costa Rica",{"$f":"VLOOKUP(A23, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},{"$f":"VLOOKUP(D23, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},1.0636363636363637E-2,0.33300000000000002,3.5,null,null,"Honduras",2.5,"Switzerland"]
["Italy",1.375,2.25,"Uruguay",{"$f":"VLOOKUP(A24, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},{"$f":"VLOOKUP(D24, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},0.89312977099236635,1.375,2.25,null,null,"Algeria",2.5,"Russia"]
["Costa Rica",5,2.75,"England",{"$f":"VLOOKUP(A25, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},{"$f":"VLOOKUP(D25, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},70.967741935483872,5,2.75,null,null,"Honduras",2.2999999999999998,"Ecuador"]
["Switzerland",1.3,2,"Ecuador",{"$f":"VLOOKUP(A26, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},{"$f":"VLOOKUP(D26, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},0.72413793103448276,1.3,2,null,null,"Greece",2.4,"Colombia"]
["France",0.3,3.5,"Honduras",{"$f":"VLOOKUP(A27, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},{"$f":"VLOOKUP(D27, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},0.01,0.3,3.5,null,null,"Iran",2.4,"Bosnia & Herzegovina"]
["Switzerland",3,2.1,"France",{"$f":"VLOOKUP(A28, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},{"$f":"VLOOKUP(D28, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},5,3,2.1,null,null,"Ghana",2.5,"Portugal"]
["Honduras",4,2.2999999999999998,"Ecuador",{"$f":"VLOOKUP(A29, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},{"$f":"VLOOKUP(D29, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},14.482758620689655,4,2.2999999999999998,null,null,"Ecuador",2.2999999999999998,"France"]
["Honduras",4.5,2.5,"Switzerland",{"$f":"VLOOKUP(A30, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},{"$f":"VLOOKUP(D30, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},20,4.5,2.5,null,null,"Chile",2.4,"Spain"]
["Ecuador",2.1,2.2999999999999998,"France",{"$f":"VLOOKUP(A31, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},{"$f":"VLOOKUP(D31, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},6.9047619047619051,2.1,2.2999999999999998,null,null,"Iran",2,"Nigeria"]
["Argentina",0.36399999999999999,3.3330000000000002,"Bosnia & Herzegovina",{"$f":"VLOOKUP(A32, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},{"$f":"VLOOKUP(D32, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},2.6470588235294117E-2,0.36399999999999999,3.3330000000000002,null,null,"USA",2.2999999999999998,"Portugal"]
["Iran",2.6,2,"Nigeria",{"$f":"VLOOKUP(A33, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},{"$f":"VLOOKUP(D33, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},6.3043478260869561,2.6,2,null,null,"Japan",2.5,"Colombia"]
["Argentina",0.16700000000000001,5,"Iran",{"$f":"VLOOKUP(A34, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},{"$f":"VLOOKUP(D34, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},3.1034482758620688E-3,0.16700000000000001,5,null,null,"Cameroon",2,"Mexico"]
["Nigeria",1.625,2,"Bosnia & Herzegovina",{"$f":"VLOOKUP(A35, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D35, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},1.3529411764705883,1.625,2,null,null,"Portugal",2.25,"Germany"]
["Nigeria",6.5,3.2,"Argentina",{"$f":"VLOOKUP(A36, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D36, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},51.111111111111114,6.5,3.2,null,null,"Ivory Coast",2.25,"Colombia"]
["Bosnia & Herzegovina",0.66700000000000004,2.4,"Iran",{"$f":"VLOOKUP(A37, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},{"$f":"VLOOKUP(D37, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},0.11724137931034483,0.66700000000000004,2.4,null,null,"South Korea",2.1,"Russia"]
["Germany",0.83299999999999996,2.25,"Portugal",{"$f":"VLOOKUP(A38, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},{"$f":"VLOOKUP(D38, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},0.18055555555555555,0.83299999999999996,2.25,null,null,"Switzerland",2.1,"France"]
["Ghana",1.4,2.2000000000000002,"USA",{"$f":"VLOOKUP(A39, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D39, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},1.2777777777777777,1.4,2.2000000000000002,null,null,"Cameroon",2,"Croatia"]
["Germany",0.36399999999999999,3.3330000000000002,"Ghana",{"$f":"VLOOKUP(A40, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},{"$f":"VLOOKUP(D40, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},2.2608695652173914E-2,0.36399999999999999,3.3330000000000002,null,null,"Netherlands",2.1,"Spain"]
["USA",4,2.2999999999999998,"Portugal",{"$f":"VLOOKUP(A41, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},{"$f":"VLOOKUP(D41, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},6.25,4,2.2999999999999998,null,null,"Russia",2.2000000000000002,"Belgium"]
["USA",6,3,"Germany",{"$f":"VLOOKUP(A42, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},{"$f":"VLOOKUP(D42, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},34.615384615384613,6,3,null,null,"Algeria",2,"South Korea"]
["Portugal",0.75,2.5,"Ghana",{"$f":"VLOOKUP(A43, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},{"$f":"VLOOKUP(D43, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},0.12521739130434784,0.75,2.5,null,null,"Greece",2.2999999999999998,"Ivory Coast"]
["Belgium",0.4,3,"Algeria",{"$f":"VLOOKUP(A44, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},{"$f":"VLOOKUP(D44, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},1.2E-2,0.4,3,null,null,"Greece",2,"Japan"]
["Russia",1,2.1,"South Korea",{"$f":"VLOOKUP(A45, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},{"$f":"VLOOKUP(D45, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},0.19794871794871796,1,2.1,null,null,"Chile",2.2999999999999998,"Netherlands"]
["Belgium",1.05,2.2000000000000002,"Russia",{"$f":"VLOOKUP(A46, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},{"$f":"VLOOKUP(D46, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},0.21761658031088082,1.05,2.2000000000000002,null,null,"Ecuador",2,"Switzerland"]
["South Korea",1.1499999999999999,2,"Algeria",{"$f":"VLOOKUP(A47, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},{"$f":"VLOOKUP(D47, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},0.27857142857142858,1.1499999999999999,2,null,null,"Nigeria",2,"Bosnia & Herzegovina"]
["South Korea",4,2.5,"Belgium",{"$f":"VLOOKUP(A48, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},{"$f":"VLOOKUP(D48, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},23.214285714285712,4,2.5,null,null,"England",1.8,"Italy"]
["Algeria",4,2.5,"Russia",{"$f":"VLOOKUP(A49, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},{"$f":"VLOOKUP(D49, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},18.134715025906736,4,2.5,null,null,"Ghana",2.2000000000000002,"USA"]
["Croatia",9,null,"Brazil",{"$f":"VLOOKUP(A50, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},{"$f":"VLOOKUP(D50, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},56.896551724137936,9,null,null,null,"England",2.1,"Uruguay"]
["Cameroon",2.5,null,"Mexico",{"$f":"VLOOKUP(A51, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},{"$f":"VLOOKUP(D51, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},5.7142857142857144,2.5,null,null,null,"Croatia",2.2999999999999998,"Mexico"]
["Mexico",6,null,"Brazil",{"$f":"VLOOKUP(A52, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D52, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},48.275862068965516,6,null,null,null,"Uruguay",2.25,"Italy"]
["Croatia",1.05,null,"Cameroon",{"$f":"VLOOKUP(A53, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},{"$f":"VLOOKUP(D53, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},0.20624999999999999,1.05,null,null,null,"Japan",2,"Ivory Coast"]
["Brazil",0.2,null,"Cameroon",{"$f":"VLOOKUP(A54, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},{"$f":"VLOOKUP(D54, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},3.6249999999999998E-3,0.2]
["Mexico",1.45,null,"Croatia",{"$f":"VLOOKUP(A55, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D55, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},0.84848484848484851,1.45]
["Netherlands",3,null,"Spain",{"$f":"VLOOKUP(A56, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},{"$f":"VLOOKUP(D56, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},4.7333333333333334,3]
["Australia",5.5,null,"Chile",{"$f":"VLOOKUP(A57, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},{"$f":"VLOOKUP(D57, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},20.935960591133004,5.5]
["Netherlands",0.36399999999999999,null,"Australia",{"$f":"VLOOKUP(A58, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},{"$f":"VLOOKUP(D58, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},3.3411764705882349E-2,0.36399999999999999]
["Chile",3.3330000000000002,null,"Spain",{"$f":"VLOOKUP(A59, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},{"$f":"VLOOKUP(D59, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},6.7666666666666666,3.3330000000000002]
["Spain",0.25,null,"Australia",{"$f":"VLOOKUP(A60, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},{"$f":"VLOOKUP(D60, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},7.058823529411765E-3,0.25]
["Chile",1.9,null,"Netherlands",{"$f":"VLOOKUP(A61, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},{"$f":"VLOOKUP(D61, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},1.4295774647887325,1.9]
["Greece",4,null,"Colombia",{"$f":"VLOOKUP(A62, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},{"$f":"VLOOKUP(D62, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},10,4]
["Japan",1.625,null,"Ivory Coast",{"$f":"VLOOKUP(A63, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},{"$f":"VLOOKUP(D63, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},1.1071428571428572,1.625]
["Ivory Coast",2.4,null,"Colombia",{"$f":"VLOOKUP(A64, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D64, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},5.1851851851851851,2.4]
["Greece",1.9,null,"Japan",{"$f":"VLOOKUP(A65, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},{"$f":"VLOOKUP(D65, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},1.7419354838709677,1.9]
["Colombia",0.83299999999999996,null,"Japan",{"$f":"VLOOKUP(A66, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},{"$f":"VLOOKUP(D66, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},0.17419354838709677,0.83299999999999996]
["Ivory Coast",1.25,null,"Greece",{"$f":"VLOOKUP(A67, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D67, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},{"$f":"E67/F67","v":0.51851851851851849},{"$f":"B67","v":1.25}]
["Costa Rica",9,null,"Uruguay",{"$f":"VLOOKUP(A68, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},{"$f":"VLOOKUP(D68, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},83.969465648854964,9]
["Italy",1.5,null,"England",{"$f":"VLOOKUP(A69, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},{"$f":"VLOOKUP(D69, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},0.75483870967741928,1.5]
["England",1.625,null,"Uruguay",{"$f":"VLOOKUP(A70, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},{"$f":"VLOOKUP(D70, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},1.1832061068702291,1.625]
["Costa Rica",6.5,null,"Italy",{"$f":"VLOOKUP(A71, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},{"$f":"VLOOKUP(D71, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},94.017094017094024,6.5]
["Uruguay",1.625,null,"Italy",{"$f":"VLOOKUP(A72, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},{"$f":"VLOOKUP(D72, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},1.1196581196581197,1.625]
["England",0.53300000000000003,null,"Costa Rica",{"$f":"VLOOKUP(A73, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},{"$f":"VLOOKUP(D73, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},1.4090909090909091E-2,0.53300000000000003]
["Ecuador",2.1,null,"Switzerland",{"$f":"VLOOKUP(A74, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},{"$f":"VLOOKUP(D74, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},1.3809523809523809,2.1]
["Honduras",7.5,null,"France",{"$f":"VLOOKUP(A75, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},{"$f":"VLOOKUP(D75, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},100,7.5]
["France",0.83299999999999996,null,"Switzerland",{"$f":"VLOOKUP(A76, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},{"$f":"VLOOKUP(D76, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},0.2,0.83299999999999996]
["Ecuador",0.66700000000000004,null,"Honduras",{"$f":"VLOOKUP(A77, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},{"$f":"VLOOKUP(D77, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},6.9047619047619052E-2,0.66700000000000004]
["Switzerland",0.57099999999999995,null,"Honduras",{"$f":"VLOOKUP(A78, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},{"$f":"VLOOKUP(D78, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},0.05,0.57099999999999995]
["France",1.05,null,"Ecuador",{"$f":"VLOOKUP(A79, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},{"$f":"VLOOKUP(D79, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},0.14482758620689656,1.05]
["Bosnia & Herzegovina",6,null,"Argentina",{"$f":"VLOOKUP(A80, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},{"$f":"VLOOKUP(D80, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},37.777777777777779,6]
["Nigeria",1,null,"Iran",{"$f":"VLOOKUP(A81, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D81, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},0.15862068965517243,1]
["Iran",12,null,"Argentina",{"$f":"VLOOKUP(A82, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},{"$f":"VLOOKUP(D82, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},322.22222222222223,12]
["Bosnia & Herzegovina",1.5,null,"Nigeria",{"$f":"VLOOKUP(A83, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},{"$f":"VLOOKUP(D83, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},0.73913043478260865,1.5]
["Argentina",0.36399999999999999,null,"Nigeria",{"$f":"VLOOKUP(A84, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},{"$f":"VLOOKUP(D84, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},1.9565217391304349E-2,0.36399999999999999]
["Iran",3.5,null,"Bosnia & Herzegovina",{"$f":"VLOOKUP(A85, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},{"$f":"VLOOKUP(D85, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},8.5294117647058822,3.5]
["Portugal",3,null,"Germany",{"$f":"VLOOKUP(A86, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},{"$f":"VLOOKUP(D86, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},5.5384615384615383,3]
["USA",1.7,null,"Ghana",{"$f":"VLOOKUP(A87, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},{"$f":"VLOOKUP(D87, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},0.78260869565217395,1.7]
["Ghana",6,null,"Germany",{"$f":"VLOOKUP(A88, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D88, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},44.230769230769226,6]
["Portugal",0.66700000000000004,null,"USA",{"$f":"VLOOKUP(A89, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},{"$f":"VLOOKUP(D89, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},0.16,0.66700000000000004]
["Germany",0.4,null,"USA",{"$f":"VLOOKUP(A90, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},{"$f":"VLOOKUP(D90, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},2.8888888888888891E-2,0.4]
["Ghana",3,null,"Portugal",{"$f":"VLOOKUP(A91, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D91, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},7.9861111111111107,3]
["Algeria",5.5,null,"Belgium",{"$f":"VLOOKUP(A92, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},{"$f":"VLOOKUP(D92, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},83.333333333333329,5.5]
["South Korea",2.5,null,"Russia",{"$f":"VLOOKUP(A93, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},{"$f":"VLOOKUP(D93, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},5.0518134715025909,2.5]
["Russia",2.2000000000000002,null,"Belgium",{"$f":"VLOOKUP(A94, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},{"$f":"VLOOKUP(D94, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},4.5952380952380949,2.2000000000000002]
["Algeria",2.2999999999999998,null,"South Korea",{"$f":"VLOOKUP(A95, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},{"$f":"VLOOKUP(D95, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},3.5897435897435899,2.2999999999999998]
["Belgium",0.61499999999999999,null,"South Korea",{"$f":"VLOOKUP(A96, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},{"$f":"VLOOKUP(D96, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},4.3076923076923082E-2,0.61499999999999999]
["Russia",0.61499999999999999,null,"Algeria",{"$f":"VLOOKUP(A97, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},{"$f":"VLOOKUP(D97, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},5.5142857142857146E-2,0.61499999999999999]

{"sheet":"OddsCreation (2)","index":4,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"T1C","T2C","T1/T2","W","D"]
["Australia",8,4,"Spain",{"$f":"VLOOKUP(A2, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},{"$f":"VLOOKUP(D2, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},{"$f":"E2/F2","v":141.66666666666666},{"$f":"B2","v":8},{"$f":"C2","v":4}]
["Honduras",7.5,3.5,"France",{"$f":"VLOOKUP(A3, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},{"$f":"VLOOKUP(D3, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},100,{"$f":"B3","v":7.5},{"$f":"C3","v":3.5}]
["Costa Rica",6.5,3.5,"Italy",{"$f":"VLOOKUP(A4, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},{"$f":"VLOOKUP(D4, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},94.017094017094024,{"$f":"B4","v":6.5},{"$f":"C4","v":3.5}]
["Costa Rica",9,3.2,"Uruguay",{"$f":"VLOOKUP(A5, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},{"$f":"VLOOKUP(D5, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},83.969465648854964,9,3.2]
["Algeria",5.5,3,"Belgium",{"$f":"VLOOKUP(A6, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},{"$f":"VLOOKUP(D6, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},83.333333333333329,5.5,3]
["Costa Rica",5,2.75,"England",{"$f":"VLOOKUP(A7, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},{"$f":"VLOOKUP(D7, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},70.967741935483872,5,2.75]
["Croatia",9,3.6,"Brazil",{"$f":"VLOOKUP(A8, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},{"$f":"VLOOKUP(D8, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},56.896551724137936,9,3.6]
["Nigeria",6.5,3.2,"Argentina",{"$f":"VLOOKUP(A9, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D9, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},51.111111111111114,6.5,3.2]
["Mexico",6,3.3,"Brazil",{"$f":"VLOOKUP(A10, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D10, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},48.275862068965516,6,3.3]
["Ghana",6,3.3,"Germany",{"$f":"VLOOKUP(A11, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D11, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},44.230769230769226,6,3.3]
["Bosnia & Herzegovina",6,3.3,"Argentina",{"$f":"VLOOKUP(A12, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},{"$f":"VLOOKUP(D12, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},37.777777777777779,6,3.3]
["USA",6,3,"Germany",{"$f":"VLOOKUP(A13, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},{"$f":"VLOOKUP(D13, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},34.615384615384613,6,3]
["Australia",5.5,3.5,"Netherlands",{"$f":"VLOOKUP(A14, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},{"$f":"VLOOKUP(D14, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},29.929577464788736,5.5,3.5]
["South Korea",4,2.5,"Belgium",{"$f":"VLOOKUP(A15, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},{"$f":"VLOOKUP(D15, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},23.214285714285712,4,2.5]
["Australia",5.5,2.8,"Chile",{"$f":"VLOOKUP(A16, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},{"$f":"VLOOKUP(D16, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},20.935960591133004,5.5,2.8]
["Honduras",4.5,2.5,"Switzerland",{"$f":"VLOOKUP(A17, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},{"$f":"VLOOKUP(D17, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},20,4.5,2.5]
["Algeria",4,2.5,"Russia",{"$f":"VLOOKUP(A18, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},{"$f":"VLOOKUP(D18, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},18.134715025906736,4,2.5]
["Honduras",4,2.2999999999999998,"Ecuador",{"$f":"VLOOKUP(A19, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},{"$f":"VLOOKUP(D19, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},14.482758620689655,4,2.2999999999999998]
["Greece",4,2.4,"Colombia",{"$f":"VLOOKUP(A20, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},{"$f":"VLOOKUP(D20, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},10,4,2.4]

{"sheet":"OddsCreation (3)","index":5,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"T1C","T2C","T1/T2","W","D"]
["Japan",1.625,2,"Ivory Coast",{"$f":"VLOOKUP(A2, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},{"$f":"VLOOKUP(D2, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"E2/F2","v":1.1071428571428572},{"$f":"B2","v":1.625},{"$f":"C2","v":2}]
["Uruguay",1.625,2.2999999999999998,"Italy",{"$f":"VLOOKUP(A3, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},{"$f":"VLOOKUP(D3, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},1.1196581196581197,{"$f":"B3","v":1.625},{"$f":"C3","v":2.2999999999999998}]
["Croatia",1.5,2.2999999999999998,"Mexico",{"$f":"VLOOKUP(A4, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},{"$f":"VLOOKUP(D4, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},1.1785714285714286,1.5,2.2999999999999998]
["England",1.625,2.1,"Uruguay",{"$f":"VLOOKUP(A5, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},{"$f":"VLOOKUP(D5, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},1.1832061068702291,1.625,2.1]
["Ghana",1.4,2.2000000000000002,"USA",{"$f":"VLOOKUP(A6, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D6, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},1.2777777777777777,1.4,2.2000000000000002]
["England",2,1.8,"Italy",{"$f":"VLOOKUP(A7, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},{"$f":"VLOOKUP(D7, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},1.324786324786325,2,1.8]
["Nigeria",1.625,2,"Bosnia & Herzegovina",{"$f":"VLOOKUP(A8, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D8, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},1.3529411764705883,1.625,2]
["Ecuador",2.1,2,"Switzerland",{"$f":"VLOOKUP(A9, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},{"$f":"VLOOKUP(D9, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},1.3809523809523809,2.1,2]
["Chile",1.9,2.2999999999999998,"Netherlands",{"$f":"VLOOKUP(A10, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},{"$f":"VLOOKUP(D10, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},1.4295774647887325,1.9,2.2999999999999998]
["Greece",1.9,2,"Japan",{"$f":"VLOOKUP(A11, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},{"$f":"VLOOKUP(D11, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},1.7419354838709677,1.9,2]
["Greece",1.8,2.25,"Ivory Coast",{"$f":"VLOOKUP(A12, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},{"$f":"VLOOKUP(D12, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},1.9285714285714286,1.8,2.25]
["Algeria",2.2999999999999998,2,"South Korea",{"$f":"VLOOKUP(A13, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},{"$f":"VLOOKUP(D13, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},3.5897435897435899,2.2999999999999998,2]
["Russia",2.2000000000000002,2.2000000000000002,"Belgium",{"$f":"VLOOKUP(A14, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},{"$f":"VLOOKUP(D14, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},4.5952380952380949,2.2000000000000002,2.2000000000000002]
["Netherlands",3,2.1,"Spain",{"$f":"VLOOKUP(A15, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},{"$f":"VLOOKUP(D15, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},4.7333333333333334,3,2.1]
["Cameroon",2.4,2,"Croatia",{"$f":"VLOOKUP(A16, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},{"$f":"VLOOKUP(D16, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},4.8484848484848486,2.4,2]
["Switzerland",3,2.1,"France",{"$f":"VLOOKUP(A17, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},{"$f":"VLOOKUP(D17, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},5,3,2.1]
["South Korea",2.5,2.1,"Russia",{"$f":"VLOOKUP(A18, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},{"$f":"VLOOKUP(D18, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},5.0518134715025909,2.5,2.1]
["Ivory Coast",2.4,2.2999999999999998,"Colombia",{"$f":"VLOOKUP(A19, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D19, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},5.1851851851851851,2.4,2.2999999999999998]
["Portugal",3,2.2999999999999998,"Germany",{"$f":"VLOOKUP(A20, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},{"$f":"VLOOKUP(D20, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},5.5384615384615383,3,2.2999999999999998]
["Cameroon",2.5,2,"Mexico",{"$f":"VLOOKUP(A21, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},{"$f":"VLOOKUP(D21, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},5.7142857142857144,2.5,2]
["Japan",2.75,2.5,"Colombia",{"$f":"VLOOKUP(A22, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},{"$f":"VLOOKUP(D22, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},5.7407407407407405,2.75,2.5]
["USA",4,2.2999999999999998,"Portugal",{"$f":"VLOOKUP(A23, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},{"$f":"VLOOKUP(D23, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},6.25,4,2.2999999999999998]
["Iran",2.6,2,"Nigeria",{"$f":"VLOOKUP(A24, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},{"$f":"VLOOKUP(D24, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},6.3043478260869561,2.6,2]
["Chile",3.3330000000000002,2.4,"Spain",{"$f":"VLOOKUP(A25, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},{"$f":"VLOOKUP(D25, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},6.7666666666666666,3.3330000000000002,2.4]
["Ecuador",2.1,2.2999999999999998,"France",{"$f":"VLOOKUP(A26, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},{"$f":"VLOOKUP(D26, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},6.9047619047619051,2.1,2.2999999999999998]
["Ghana",3,2.5,"Portugal",{"$f":"VLOOKUP(A27, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D27, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},7.9861111111111107,3,2.5]
["Iran",3.5,2.4,"Bosnia & Herzegovina",{"$f":"VLOOKUP(A28, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},{"$f":"VLOOKUP(D28, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},8.5294117647058822,3.5,2.4]
["Greece",4,2.4,"Colombia",{"$f":"VLOOKUP(A29, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},{"$f":"VLOOKUP(D29, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},10,4,2.4]

{"sheet":"OddsCreation (4)","index":6,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"T1C","T2C","T1/T2","W","D"]
["Brazil",0.3,3.6,"Croatia",{"$f":"VLOOKUP(A2, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},{"$f":"VLOOKUP(D2, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},{"$f":"E2/F2","v":1.7575757575757574E-2},{"$f":"B2","v":0.3},{"$f":"C2","v":3.6}]
["Argentina",0.16700000000000001,5,"Iran",{"$f":"VLOOKUP(A3, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},{"$f":"VLOOKUP(D3, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},3.1034482758620688E-3,{"$f":"B3","v":0.16700000000000001},{"$f":"C3","v":5}]
["Brazil",0.2,4,"Cameroon",{"$f":"VLOOKUP(A4, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},{"$f":"VLOOKUP(D4, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},3.6249999999999998E-3,0.2,4]
["Spain",0.25,4,"Australia",{"$f":"VLOOKUP(A5, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},{"$f":"VLOOKUP(D5, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},7.058823529411765E-3,0.25,4]
["France",0.3,3.5,"Honduras",{"$f":"VLOOKUP(A6, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},{"$f":"VLOOKUP(D6, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},0.01,0.3,3.5]
["Italy",0.33300000000000002,3.5,"Costa Rica",{"$f":"VLOOKUP(A7, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},{"$f":"VLOOKUP(D7, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},1.0636363636363637E-2,0.33300000000000002,3.5]
["Uruguay",0.33,3.2,"Costa Rica",{"$f":"VLOOKUP(A8, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},{"$f":"VLOOKUP(D8, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},1.1909090909090909E-2,0.33,3.2]
["Belgium",0.4,3,"Algeria",{"$f":"VLOOKUP(A9, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},{"$f":"VLOOKUP(D9, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},1.2E-2,0.4,3]
["England",0.53300000000000003,2.8,"Costa Rica",{"$f":"VLOOKUP(A10, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},{"$f":"VLOOKUP(D10, KOCoeffs!A$2:B$33, 2, FALSE)","v":2200},1.4090909090909091E-2,0.53300000000000003,2.8]
["Argentina",0.36399999999999999,3.2,"Nigeria",{"$f":"VLOOKUP(A11, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},{"$f":"VLOOKUP(D11, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},1.9565217391304349E-2,0.36399999999999999,3.2]
["Brazil",0.36399999999999999,3.3330000000000002,"Mexico",{"$f":"VLOOKUP(A12, KOCoeffs!A$2:B$33, 2, FALSE)","v":2.9},{"$f":"VLOOKUP(D12, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},2.0714285714285713E-2,0.36399999999999999,3.3330000000000002]
["Germany",0.36399999999999999,3.3330000000000002,"Ghana",{"$f":"VLOOKUP(A13, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},{"$f":"VLOOKUP(D13, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},2.2608695652173914E-2,0.36399999999999999,3.3330000000000002]
["Argentina",0.36399999999999999,3.3330000000000002,"Bosnia & Herzegovina",{"$f":"VLOOKUP(A14, KOCoeffs!A$2:B$33, 2, FALSE)","v":4.5},{"$f":"VLOOKUP(D14, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},2.6470588235294117E-2,0.36399999999999999,3.3330000000000002]
["Germany",0.4,3,"USA",{"$f":"VLOOKUP(A15, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},{"$f":"VLOOKUP(D15, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},2.8888888888888891E-2,0.4,3]
["Netherlands",0.36399999999999999,3.5,"Australia",{"$f":"VLOOKUP(A16, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},{"$f":"VLOOKUP(D16, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},3.3411764705882349E-2,0.36399999999999999,3.5]
["Belgium",0.61499999999999999,2.5,"South Korea",{"$f":"VLOOKUP(A17, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},{"$f":"VLOOKUP(D17, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},4.3076923076923082E-2,0.61499999999999999,2.5]
["Chile",0.5,2.75,"Australia",{"$f":"VLOOKUP(A18, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},{"$f":"VLOOKUP(D18, KOCoeffs!A$2:B$33, 2, FALSE)","v":850},4.7764705882352945E-2,0.5,2.75]
["Switzerland",0.57099999999999995,2.5,"Honduras",{"$f":"VLOOKUP(A19, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},{"$f":"VLOOKUP(D19, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},0.05,0.57099999999999995,2.5]
["Russia",0.61499999999999999,2.5,"Algeria",{"$f":"VLOOKUP(A20, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},{"$f":"VLOOKUP(D20, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},5.5142857142857146E-2,0.61499999999999999,2.5]
["Ecuador",0.66700000000000004,2.2999999999999998,"Honduras",{"$f":"VLOOKUP(A21, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},{"$f":"VLOOKUP(D21, KOCoeffs!A$2:B$33, 2, FALSE)","v":2100},6.9047619047619052E-2,0.66700000000000004,2.2999999999999998]
["Colombia",0.7,2.4,"Greece",{"$f":"VLOOKUP(A22, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},{"$f":"VLOOKUP(D22, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},0.1,0.7,2.4]
["Bosnia & Herzegovina",0.66700000000000004,2.4,"Iran",{"$f":"VLOOKUP(A23, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},{"$f":"VLOOKUP(D23, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},0.11724137931034483,0.66700000000000004,2.4]
["Portugal",0.75,2.5,"Ghana",{"$f":"VLOOKUP(A24, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},{"$f":"VLOOKUP(D24, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},0.12521739130434784,0.75,2.5]
["France",1.05,2.2999999999999998,"Ecuador",{"$f":"VLOOKUP(A25, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},{"$f":"VLOOKUP(D25, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},0.14482758620689656,1.05,2.2999999999999998]
["Spain",0.7,2.4,"Chile",{"$f":"VLOOKUP(A26, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},{"$f":"VLOOKUP(D26, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},0.14778325123152708,0.7,2.4]
["Nigeria",1,2,"Iran",{"$f":"VLOOKUP(A27, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},{"$f":"VLOOKUP(D27, KOCoeffs!A$2:B$33, 2, FALSE)","v":1450},0.15862068965517243,1,2]
["Portugal",0.66700000000000004,2.2999999999999998,"USA",{"$f":"VLOOKUP(A28, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},{"$f":"VLOOKUP(D28, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},0.16,0.66700000000000004,2.2999999999999998]
["Colombia",0.83299999999999996,2.5,"Japan",{"$f":"VLOOKUP(A29, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},{"$f":"VLOOKUP(D29, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},0.17419354838709677,0.83299999999999996,2.5]
["Mexico",1.1499999999999999,2,"Cameroon",{"$f":"VLOOKUP(A30, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D30, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},0.17499999999999999,1.1499999999999999,2]
["Germany",0.83299999999999996,2.25,"Portugal",{"$f":"VLOOKUP(A31, KOCoeffs!A$2:B$33, 2, FALSE)","v":5.2},{"$f":"VLOOKUP(D31, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.8},0.18055555555555555,0.83299999999999996,2.25]
["Colombia",1,2.25,"Ivory Coast",{"$f":"VLOOKUP(A32, KOCoeffs!A$2:B$33, 2, FALSE)","v":27},{"$f":"VLOOKUP(D32, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},0.19285714285714287,1,2.25]
["Russia",1,2.1,"South Korea",{"$f":"VLOOKUP(A33, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},{"$f":"VLOOKUP(D33, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},0.19794871794871796,1,2.1]
["France",0.83299999999999996,2.1,"Switzerland",{"$f":"VLOOKUP(A34, KOCoeffs!A$2:B$33, 2, FALSE)","v":21},{"$f":"VLOOKUP(D34, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},0.2,0.83299999999999996,2.1]
["Croatia",1.05,2,"Cameroon",{"$f":"VLOOKUP(A35, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},{"$f":"VLOOKUP(D35, KOCoeffs!A$2:B$33, 2, FALSE)","v":800},0.20624999999999999,1.05,2]
["Spain",1,2.1,"Netherlands",{"$f":"VLOOKUP(A36, KOCoeffs!A$2:B$33, 2, FALSE)","v":6},{"$f":"VLOOKUP(D36, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},0.21126760563380284,1,2.1]
["Belgium",1.05,2.2000000000000002,"Russia",{"$f":"VLOOKUP(A37, KOCoeffs!A$2:B$33, 2, FALSE)","v":16.8},{"$f":"VLOOKUP(D37, KOCoeffs!A$2:B$33, 2, FALSE)","v":77.2},0.21761658031088082,1.05,2.2000000000000002]
["South Korea",1.1499999999999999,2,"Algeria",{"$f":"VLOOKUP(A38, KOCoeffs!A$2:B$33, 2, FALSE)","v":390},{"$f":"VLOOKUP(D38, KOCoeffs!A$2:B$33, 2, FALSE)","v":1400},0.27857142857142858,1.1499999999999999,2]
["Ivory Coast",1.25,2.2999999999999998,"Greece",{"$f":"VLOOKUP(A39, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D39, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},0.51851851851851849,1.25,2.2999999999999998]
["Japan",1.3,2,"Greece",{"$f":"VLOOKUP(A40, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},{"$f":"VLOOKUP(D40, KOCoeffs!A$2:B$33, 2, FALSE)","v":270},0.57407407407407407,1.3,2]
["Netherlands",1.2,2.2999999999999998,"Chile",{"$f":"VLOOKUP(A41, KOCoeffs!A$2:B$33, 2, FALSE)","v":28.4},{"$f":"VLOOKUP(D41, KOCoeffs!A$2:B$33, 2, FALSE)","v":40.6},0.6995073891625615,1.2,2.2999999999999998]
["Switzerland",1.3,2,"Ecuador",{"$f":"VLOOKUP(A42, KOCoeffs!A$2:B$33, 2, FALSE)","v":105},{"$f":"VLOOKUP(D42, KOCoeffs!A$2:B$33, 2, FALSE)","v":145},0.72413793103448276,1.3,2]
["Bosnia & Herzegovina",1.5,2,"Nigeria",{"$f":"VLOOKUP(A43, KOCoeffs!A$2:B$33, 2, FALSE)","v":170},{"$f":"VLOOKUP(D43, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},0.73913043478260865,1.5,2]
["Italy",1.5,1.8,"England",{"$f":"VLOOKUP(A44, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},{"$f":"VLOOKUP(D44, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},0.75483870967741928,1.5,1.8]
["USA",1.7,2.2000000000000002,"Ghana",{"$f":"VLOOKUP(A45, KOCoeffs!A$2:B$33, 2, FALSE)","v":180},{"$f":"VLOOKUP(D45, KOCoeffs!A$2:B$33, 2, FALSE)","v":230},0.78260869565217395,1.7,2.2000000000000002]
["Uruguay",1.6,2.1,"England",{"$f":"VLOOKUP(A46, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},{"$f":"VLOOKUP(D46, KOCoeffs!A$2:B$33, 2, FALSE)","v":31},0.84516129032258058,1.6,2.1]
["Mexico",1.45,2.2999999999999998,"Croatia",{"$f":"VLOOKUP(A47, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D47, KOCoeffs!A$2:B$33, 2, FALSE)","v":165},0.84848484848484851,1.45,2.2999999999999998]
["Italy",1.375,2.25,"Uruguay",{"$f":"VLOOKUP(A48, KOCoeffs!A$2:B$33, 2, FALSE)","v":23.4},{"$f":"VLOOKUP(D48, KOCoeffs!A$2:B$33, 2, FALSE)","v":26.2},0.89312977099236635,1.375,2.25]
["Ivory Coast",1.5,2,"Japan",{"$f":"VLOOKUP(A49, KOCoeffs!A$2:B$33, 2, FALSE)","v":140},{"$f":"VLOOKUP(D49, KOCoeffs!A$2:B$33, 2, FALSE)","v":155},0.90322580645161288,1.5,2]

{"sheet":"KOCoeffs","index":7,"n_rows":33,"n_cols":28,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["TEAM","Ave","bet365","Betfair","Ladbrokes","SkyBet","Will Hill"]
["Algeria",{"$f":"AVERAGE(C2:G2)","v":1400},1500,2000,1000,1500,1000]
["Argentina",4.5,4.5,4.5,4.5,4.5,4.5]
["Australia",850,500,1000,1000,1000,750]
["Belgium",16.8,18,20,16,16,14]
["Bosnia & Herzegovina",170,150,200,200,150,150]
["Brazil",2.9,2.75,2.75,3,3,3]
["Cameroon",800,500,1000,750,1000,750]
["Chile",40.6,40,40,33,50,40]
["Colombia",27,33,33,22,25,22]
["Costa Rica",2200,2500,2500,2000,1500,2500]
["Croatia",165,150,200,150,175,150]
["Ecuador",145,125,150,150,150,150,null,null,"O1/O2","WC","WE","DC","DE",null,null,null,null,null,null,"W","D","L"]
["England",31,33,28,33,28,33,null,null,0,1.65,0.36969999999999997,1.87,-0.13100000000000001,null,{"$f":"VLOOKUP(R14,J14:K17, 2)","v":12},{"$f":"VLOOKUP(R14,J14:L17, 3)","v":0},{"$f":"S14/Y14","v":724.13793103448279},{"$f":"VLOOKUP(T14, A2:B33, 2, FALSE)","v":2100},"Honduras",{"$f":"P14*(R14^Q14)","v":12},{"$f":"AVERAGE(U16, W16)","v":4.4653798474088182},{"$f":"AA14*(Z14^AB14)","v":0.14461322480249689},"Brazil",{"$f":"VLOOKUP(X14, A2:B33, 2, FALSE)","v":2.9},{"$f":"Y14/S14","v":1.3809523809523809E-3},{"$f":"VLOOKUP(Z14,J14:K17, 2)","v":1.65},{"$f":"VLOOKUP(Z14,J14:L17, 3)","v":0.36969999999999997}]
["France",21,22,18,20,25,20,null,null,1,1.55,0.3407,2.0499999999999998,4.6699999999999998E-2]
["Germany",5.2,5.5,5,5,5,5.5,null,null,10,2,0.28339999999999999,1.58,0.17499999999999999,null,{"$f":"VLOOKUP(R14,J14:M17, 4)","v":4.5},{"$f":"VLOOKUP(R14,J14:N17, 5)","v":0},null,null,null,{"$f":"P16*(R14^Q16)","v":4.5},null,{"$f":"AA16*(Z14^AB16)","v":4.4307596948176364},null,null,null,{"$f":"VLOOKUP(Z14,J14:M17, 4)","v":1.87},{"$f":"VLOOKUP(Z14,J14:N17, 5)","v":-0.13100000000000001}]
["Ghana",230,250,250,200,250,200,null,null,250,12,0,4.5,0]
["Greece",270,300,300,250,250,250]
["Honduras",2100,2000,2000,2000,2000,2500]
["Iran",1450,1500,1500,1500,2000,750]
["Italy",23.4,25,20,22,25,25]
["Ivory Coast",140,125,125,150,150,150]
["Japan",155,150,200,150,150,125]
["Mexico",140,150,150,125,125,150]
["Netherlands",28.4,28,33,28,25,28]
["Nigeria",230,250,250,200,200,250]
["Portugal",28.8,28,33,22,28,33]
["Russia",77.2,80,80,80,80,66]
["South Korea",390,300,500,400,500,250]
["Spain",6,6.5,5.5,6,6,6]
["Switzerland",105,100,100,100,125,100]
["Uruguay",26.2,25,28,28,22,28]
["USA",180,225,200,200,125,150]

{"sheet":"OddsTesting","index":8,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[null,"ActWin","ActDraw","ActLoss",null,"PreWin","PreDraw","PreLoss"]
["Brazil",0.3,3.6,9,"Croatia",0.37036391808873292,3.1899376356156859,6.2866799721750848,{"$f":"ABS(B2-F2)","v":7.0363918088732935E-2},{"$f":"ABS(C2-G2)","v":0.4100623643843142},2.7133200278249152,"Yes"]
["Mexico",1.1499999999999999,2,2.5,"Cameroon",0.86623377036086957,2.2867473522545634,2.8069109515406696,{"$f":"ABS(B3-F3)","v":0.28376622963913034},{"$f":"ABS(C3-G3)","v":0.28674735225456338},{"$f":"ABS(D3-H3)","v":0.30691095154066961}]
["Brazil",0.36399999999999999,3.3330000000000002,6,"Mexico",0.39355818519059949,3.1107153729443247,6.0006609426153661,2.9558185190599495E-2,0.22228462705567553,6.6094261536608911E-4]
["Cameroon",2.4,2,1.05,"Croatia",2.6541024136777969,2.2532318644837712,0.9204821905257986,0.25410241367779696,0.25323186448377122,0.12951780947420144]
["Cameroon",12,4,0.2,"Brazil",12,4.2022807023486664,0.20661417612971777,0,0.20228070234866635,6.6141761297177637E-3]
["Croatia",1.5,2.2999999999999998,1.45,"Mexico",1.6392404273726744,1.9882378267087311,1.5527576044453362,0.13924042737267439,0.31176217329126876,0.10275760444533621]
["Spain",1,2.1,3,"Netherlands",0.92869834405320106,2.2483791417036074,2.632456028397212,7.1301655946798936E-2,0.14837914170360733,0.36754397160278796]
["Chile",0.5,2.75,5.5,"Australia",0.53598155207882958,2.7378602765442537,4.7355567043680553,3.5981552078829582E-2,1.2139723455746321E-2,0.76444329563194469]
["Australia",5.5,3.5,0.36399999999999999,"Netherlands",5.2403090639499608,2.8914271858341891,0.46964484281013447,0.25969093605003923,0.60857281416581088,0.10564484281013448]
["Spain",0.7,2.4,3.3330000000000002,"Chile",0.81375634314135814,2.3218654535785097,2.9733113370948696,0.11375634314135818,7.8134546421490203E-2,0.35968866290513057]
["Australia",8,4,0.25,"Spain",8.141403036960611,3.6688163965253597,0.26433841685508958,0.14140303696061096,0.33118360347464026,1.4338416855089575E-2]
["Netherlands",1.2,2.2999999999999998,1.9,"Chile",1.4457848178378185,2.0220647880773082,1.750696886398913,0.24578481783781858,0.27793521192269166,0.14930311360108695]
["Colombia",0.7,2.4,4,"Greece",0.7043425806334066,2.4462140149012517,3.8408734278867063,4.3425806334066452E-3,4.6214014901251765E-2,0.15912657211329373]
["Ivory Coast",1.5,2,1.625,"Japan",1.5890656878711547,1.9774340181530898,1.6046927333882528,8.9065687871154653E-2,2.2565981846910166E-2,2.0307266611747199E-2]
["Colombia",1,2.25,2.4,"Ivory Coast",0.89791575746707675,2.26685443575334,2.7155129952564971,0.10208424253292325,1.6854435753340002E-2,0.31551299525649723]
["Japan",1.3,2,1.9,"Greece",1.3439230088736207,2.0574245490244389,1.8726271819316851,4.3923008873620661E-2,5.7424549024438942E-2,2.7372818068314819E-2]
["Japan",2.75,2.5,0.83299999999999996,"Colombia",2.811331594135142,2.2876983060131386,0.86475583078167839,6.1331594135141998E-2,0.21230169398686138,3.1755830781678429E-2]
["Greece",1.8,2.25,1.25,"Ivory Coast",1.9387040201232879,2.0759332548043541,1.2942920851767468,0.13870402012328786,0.17406674519564591,4.4292085176746765E-2]
["Uruguay",0.33,3.2,9,"Costa Rica",0.32072754982309598,3.3859288633440796,7.0198203429602843,9.2724501769040346E-3,0.18592886334407943,1.9801796570397157,"Yes"]
["England",2,1.8,1.5,"Italy",1.7058733505967529,2.0086431284521082,1.4870536198136968,0.29412664940324706,0.2086431284521082,1.294638018630323E-2]
["Uruguay",1.6,2.1,1.625,"England",1.5505062221946346,1.9889184661497483,1.6414338198154588,4.9493777805365458E-2,0.11108153385025177,1.6433819815458772E-2]
["Italy",0.33300000000000002,3.5,6.5,"Costa Rica",0.30760216057910328,3.4451133148502406,7.2483108376682512,2.539783942089674E-2,5.4886685149759362E-2,0.74831083766825124]
["Italy",1.375,2.25,1.625,"Uruguay",1.5824757344215257,1.9793711126321545,1.6108500150936547,0.20747573442152567,0.27062888736784552,1.4149984906345336E-2]
["Costa Rica",5,2.75,0.53300000000000003,"England",6.6929977557111213,3.2997521859004424,0.34130818027873611,1.6929977557111213,0.54975218590044239,0.19169181972126392,"No"]
["Switzerland",1.3,2,2.1,"Ecuador",1.4644005308874102,2.0159500266713866,1.7301771907698298,0.16440053088741013,1.5950026671386563E-2,0.3698228092301703]
["France",0.3,3.5,7.5,"Honduras",0.30066573993534967,3.4778634015624528,7.3761543445230888,6.6573993534968512E-4,2.2136598437547228E-2,0.12384565547691118]
["Switzerland",3,2.1,0.83299999999999996,"France",2.6820741391161294,2.2594630003100828,0.91006986443448012,0.31792586088387065,0.15946300031008276,7.7069864434480162E-2]
["Honduras",4,2.2999999999999998,0.66700000000000004,"Ecuador",4.2659450008157531,2.5882143745134947,0.61421047863291134,0.26594500081575312,0.28821437451349485,5.2789521367088699E-2]
["Honduras",4.5,2.5,0.57099999999999995,"Switzerland",4.6745724634261787,2.7188174945284862,0.54512130362827016,0.17457246342617871,0.2188174945284862,2.5878696371729792E-2]
["Ecuador",2.1,2.2999999999999998,1.05,"France",2.9938474190015185,2.3261063985041055,0.80770108643787053,0.89384741900151843,2.6106398504105677E-2,0.24229891356212951]
["Argentina",0.36399999999999999,3.3330000000000002,6,"Bosnia & Herzegovina",0.43090312562357386,2.9961989187150948,5.5978182486558383,6.6903125623573867E-2,0.33680108128490538,0.40218175134416168]
["Iran",2.6,2,1,"Nigeria",2.9024791108316466,2.3070837035732916,0.83532787625451965,0.30247911083164647,0.30708370357329162,0.16467212374548035]
["Argentina",0.16700000000000001,5,12,"Iran",0.19508274600211631,4.2424158128473248,12,2.8082746002116299E-2,0.75758418715267517,0]
["Nigeria",1.625,2,1.5,"Bosnia & Herzegovina",1.7181395079790083,2.0123397564097902,1.4755370859489583,9.3139507979008274E-2,1.2339756409790237E-2,2.4462914051041729E-2]
["Nigeria",6.5,3.2,0.36399999999999999,"Argentina",6.0985029465594538,3.1380028308276646,0.38534154079327643,0.4014970534405462,6.1997169172335553E-2,2.1341540793276437E-2]
["Bosnia & Herzegovina",0.66700000000000004,2.4,3.5,"Iran",0.74700440020637937,2.3710341215805895,3.2173316331636359,8.0004400206379334E-2,2.8965878419410451E-2,0.28266836683636409]
["Germany",0.83299999999999996,2.25,3,"Portugal",0.87630033482212732,2.2803256902166211,2.7771822417951473,4.3300334822127362E-2,3.0325690216621126E-2,0.22281775820485272]
["Ghana",1.4,2.2000000000000002,1.7,"USA",1.6850043617607013,2.002311887435166,1.5070491222693165,0.28500436176070143,0.19768811256483421,0.19295087773068342]
["Germany",0.36399999999999999,3.3330000000000002,6,"Ghana",0.40649911028528174,3.0693425916520485,5.8536710960893634,4.2499110285281749E-2,0.2636574083479517,0.14632890391063658]
["USA",4,2.2999999999999998,0.66700000000000004,"Portugal",2.8939299875230153,2.3052831474475717,0.83800594920501392,1.1060700124769847,5.2831474475718565E-3,0.17100594920501389]
["USA",6,3,0.4,"Germany",5.4608327563819152,2.9564197741796807,0.44505751143714439,0.53916724361808477,4.3580225820319285E-2,4.5057511437144371E-2]
["Portugal",0.75,2.5,3,"Ghana",0.76540371527629214,2.3569281894113425,3.145990097810563,1.540371527629214E-2,0.14307181058865748,0.14599009781056305]
["Belgium",0.4,3,5.5,"Algeria",0.32163051851470947,3.3819841851106927,7.004707913593287,7.8369481485290549E-2,0.38198418511069265,1.504707913593287,"No"]
["Russia",1,2.1,2.5,"South Korea",0.90660784955638762,2.2615553074801134,2.6915112260582315,9.3392150443612376E-2,0.16155530748011326,0.19151122605823145]
["Belgium",1.05,2.2000000000000002,2.2000000000000002,"Russia",0.93892017217462564,2.2424189133360004,2.6060337756447693,0.1110798278253744,4.241891333600023E-2,0.40603377564476917]
["South Korea",1.1499999999999999,2,2.2999999999999998,"Algeria",1.0286721798976941,2.1934550635450538,2.3957517183188597,0.12132782010230581,0.19345506354505382,9.5751718318859869E-2]
["South Korea",4,2.5,0.61499999999999999,"Belgium",4.8762397997758287,2.7813730181247238,0.51589842315172751,0.87623979977582866,0.28137301812472382,9.9101576848272477E-2]
["Algeria",4,2.5,0.61499999999999999,"Russia",4.5466543389069365,2.6785069631359608,0.56521349873668492,0.54665433890693649,0.17850696313596082,4.9786501263315075E-2]

{"sheet":"GroupQuals","index":9,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,"Gr","Tm","Odds (WH)","Sim","Sim%",null,"Odd-1","Tcoeff",1,2,3,4,"Prob"]
["Brazil","A",1,2.5000000000000001E-2,990,{"$f":"E2/1000","v":0.99},null,{"$f":"1/D2","v":40},{"$f":"H2/(SUM(H2:H5))","v":0.94541256171930332},{"$f":"IF(J$1=$C2, $I2, VLOOKUP(J$1, $C$2:$I$5, 7, FALSE)*($I2/(SUM($I$2:$I$5)-VLOOKUP(J$1, $C$2:$I$5, 7, FALSE))))","v":0.94541256171930332},4.490250254261488E-3,2.7608225542969964E-2,2.0759806678857077E-2,{"$f":"J2+K2+L2+M2","v":0.99827084419539192},{"$f":"F2-N2","v":-8.2708441953919243E-3}]
["Cameroon","A",2,5,185,{"$f":"E3/1000","v":0.185},null,{"$f":"1/D3","v":0.2},{"$f":"H3/(SUM(H2:H5))","v":4.7270628085965168E-3},8.1869102123878629E-2,4.7270628085965168E-3,1.3804112771484983E-4,1.0379903339428537E-4,{"$f":"J3+K3+L3+M3","v":8.6838005093584275E-2},{"$f":"F3-N3","v":9.8161994906415723E-2}]
["Croatia","A",3,0.83299999999999996,388,0.38800000000000001,null,1.2004801920768309,{"$f":"H4/(SUM(H2:H5))","v":2.8373726342115949E-2},0.49141117721415745,1.3476141219272175E-4,2.8373726342115949E-2,6.2304341773280548E-4,0.52054270838619887,-0.13254270838619886]
["Mexico","A",4,1.1000000000000001,437,0.437,null,0.90909090909090906,{"$f":"H5/(SUM(H2:H5))","v":2.1486649129984166E-2},0.37213228238126644,1.0205114214230655E-4,6.2745967143113554E-4,2.1486649129984166E-2,0.39434844232482402,4.2651557675175977E-2]
["Australia","B",1,9,31,3.1E-2,null,0.1111111111111111,{"$f":"H6/(SUM(H6:H9))","v":1.2276211016354802E-2},{"$f":"IF(J$1=$C6, $I6, VLOOKUP(J$1, $C$6:$I$9, 7, FALSE)*($I6/(SUM($I$6:$I$9)-VLOOKUP(J$1, $C$6:$I$9, 7, FALSE))))","v":1.2276211016354802E-2},1.8772619256312059E-3,2.9452913814167138E-3,2.40001732628694E-2,{"$f":"J6+K6+L6+M6","v":4.1098937586272116E-2},-1.0098937586272116E-2]
["Chile","B",2,0.83299999999999996,459,0.45900000000000002,null,1.2004801920768309,{"$f":"H7/(SUM(H6:H9))","v":0.13263613343000388},1.6485065769809863E-3,0.13263613343000388,3.1821875669568345E-2,0.25930559347638016,{"$f":"J7+K7+L7+M7","v":0.42541210915293337},3.3587890847066648E-2]
["Netherlands","B",3,0.57099999999999995,631,0.63100000000000001,null,1.7513134851138354,{"$f":"H8/(SUM(H6:H9))","v":0.1934954450914067},2.4049141482051866E-3,2.9589067129038273E-2,0.1934954450914067,0.37828644372298537,0.60377587009163558,2.7224129908364425E-2]
["Spain","B",4,0.16700000000000001,879,0.879,null,5.9880239520958076,{"$f":"H9/(SUM(H6:H9))","v":0.66159221046223471},8.2227902911686298E-3,0.10116980437533442,0.15872827804042167,0.66159221046223471,0.92971308316915935,-5.0713083169159345E-2]
["Colombia","C",1,0.28899999999999998,812,0.81200000000000006,null,3.4602076124567476,{"$f":"H10/(SUM(H10:H13))","v":0.57643784953066235},{"$f":"IF(J$1=$C10, $I10, VLOOKUP(J$1, $C$10:$I$13, 7, FALSE)*($I10/(SUM($I$10:$I$13)-VLOOKUP(J$1, $C$10:$I$13, 7, FALSE))))","v":0.57643784953066235},5.6209646421570537E-2,0.12934788247607901,0.10287992112328827,0.86487529955160014,-5.2875299551600086E-2]
["Greece","C",2,1.875,309,0.309,null,0.53333333333333333,{"$f":"H11/(SUM(H10:H13))","v":8.8848287207659415E-2},0.12091617618740327,8.8848287207659415E-2,1.993682028564631E-2,1.585722517580283E-2,0.24555850885651181,6.3441491143488182E-2]
["Ivory Coast","C",3,0.90900000000000003,455,0.45500000000000002,null,1.1001100110011002,{"$f":"H12/(SUM(H10:H13))","v":0.18326791915771334},0.24941455484200353,1.7870833680785354E-2,0.18326791915771334,3.2708797804873832E-2,0.48326210548537607,-2.8262105485376054E-2]
["Japan","C",4,1.1000000000000001,424,0.42399999999999999,null,0.90909090909090906,{"$f":"H13/(SUM(H10:H13))","v":0.15144594410396492},0.2061071185012556,1.4767807105303531E-2,3.3983216395988031E-2,0.15144594410396492,0.40630408610651214,1.7695913893487847E-2]
["Costa Rica","D",1,8,31,3.1E-2,null,0.125,{"$f":"H14/(SUM(H14:H17))","v":1.8169910269957464E-2},{"$f":"IF(J$1=$C14, $I14, VLOOKUP(J$1, $C$14:$I$17, 7, FALSE)*($I14/(SUM($I$14:$I$17)-VLOOKUP(J$1, $C$14:$I$17, 7, FALSE))))","v":1.8169910269957464E-2},5.0631881741923998E-3,1.4075650232769629E-2,8.84395514733014E-3,4.6152703824249637E-2,-1.5152703824249637E-2]
["England","D",2,0.66700000000000004,587,0.58699999999999997,null,1.4992503748125936,{"$f":"H15/(SUM(H14:H17))","v":0.21792995826035938},4.0330479052796773E-3,0.21792995826035938,0.16882339109768668,0.10607442455568385,0.49686082181900959,9.0139178180990376E-2]
["Italy","D",3,0.33300000000000002,718,0.71799999999999997,null,3.0030030030030028,{"$f":"H16/(SUM(H14:H17))","v":0.43651436083981893},8.0782070655301633E-3,0.12163815433495255,0.43651436083981893,0.21246739092685024,0.77869811316715176,-6.069811316715179E-2]
["Uruguay","D",4,0.44400000000000001,664,0.66400000000000003,null,2.2522522522522523,{"$f":"H17/(SUM(H14:H17))","v":0.32738577062986424},6.0586552991476229E-3,9.1228615751214423E-2,0.25361531950936267,0.32738577062986424,0.67828836118958891,-1.4288361189588872E-2]
["Ecuador","E",1,0.90900000000000003,530,0.53,null,1.1001100110011002,{"$f":"H18/(SUM(H18:H21))","v":0.13761213305898587},{"$f":"IF(J$1=$C18, $I18, VLOOKUP(J$1, $C$18:$I$21, 7, FALSE)*($I18/(SUM($I$18:$I$21)-VLOOKUP(J$1, $C$18:$I$21, 7, FALSE))))","v":0.13761213305898587},0.22979164221932688,2.5038613903595134E-3,3.8603756579519838E-2,0.40851139324819208,0.12148860675180795]
["France","E",2,0.2,842,0.84199999999999997,null,5,{"$f":"H19/(SUM(H18:H21))","v":0.62544714475309071},9.9803254434019176E-2,0.62544714475309071,1.1380050019183987E-2,0.17545407365391763,0.91208452286021147,-7.0084522860211496E-2]
["Honduras","E",3,7,55,5.5E-2,null,0.14285714285714285,{"$f":"H20/(SUM(H18:H21))","v":1.7869918421516875E-2},2.8515215552576906E-3,2.9840086111052586E-2,1.7869918421516875E-2,5.0129735329690756E-3,5.5574499620796226E-2,-5.7449962079622607E-4]
["Switzerland","E",4,0.57099999999999995,573,0.57299999999999995,null,1.7513134851138354,{"$f":"H21/(SUM(H18:H21))","v":0.21907080376640656},3.4957357069708997E-2,0.36581541642271126,3.986007011973376E-3,0.21907080376640656,0.62382958427080015,-5.0829584270800199E-2]
["Argentina","F",1,7.0999999999999994E-2,991,0.99099999999999999,null,14.084507042253522,{"$f":"H22/(SUM(H22:H25))","v":0.84929528863943415},{"$f":"IF(J$1=$C22, $I22, VLOOKUP(J$1, $C$22:$I$25, 7, FALSE)*($I22/(SUM($I$22:$I$25)-VLOOKUP(J$1, $C$22:$I$25, 7, FALSE))))","v":0.84929528863943415},8.4411527420323179E-2,1.0367527631418261E-2,4.304654544277968E-2,0.98712088913395524,3.8791108660447549E-3]
["Bosnia & Herzegovina","F",2,0.66700000000000004,516,0.51600000000000001,null,1.4992503748125936,{"$f":"H23/(SUM(H22:H25))","v":9.0404745867166139E-2},0.5094752781280345,9.0404745867166139E-2,1.103589897797146E-3,4.5821660066527083E-3,0.60556577989965055,-8.9565779899650533E-2]
["Iran","F",3,5,114,0.114,null,0.2,{"$f":"H24/(SUM(H22:H25))","v":1.2059993098679965E-2},6.7964002102279819E-2,1.1986436893685892E-3,1.2059993098679965E-2,6.1126094528747143E-4,8.1833899835615856E-2,3.2166100164384148E-2]
["Nigeria","F",4,1.25,379,0.379,null,0.8,{"$f":"H25/(SUM(H22:H25))","v":4.823997239471986E-2},0.27185600840911928,4.7945747574743569E-3,5.888755694645572E-4,4.823997239471986E-2,0.32547943113077804,5.3520568869221963E-2]
["Germany","G",1,0.14299999999999999,950,0.95,null,6.9930069930069934,{"$f":"H26/(SUM(H26:H29))","v":0.6700060619596081},{"$f":"IF(J$1=$C26, $I26, VLOOKUP(J$1, $C$26:$I$29, 7, FALSE)*($I26/(SUM($I$26:$I$29)-VLOOKUP(J$1, $C$26:$I$29, 7, FALSE))))","v":0.6700060619596081},2.4185865579977255E-2,0.2393604127296915,2.2103884649053055E-2,0.95565622491833002,-5.6562249183300661E-3]
["Ghana","G",2,2.75,197,0.19700000000000001,null,0.36363636363636365,{"$f":"H27/(SUM(H26:H29))","v":3.484031522189962E-2},7.0738337006660726E-2,3.484031522189962E-2,1.2446741461943958E-2,1.1494020017507587E-3,0.11917479569225506,7.782520430774495E-2]
["Portugal","G",3,0.36399999999999999,719,0.71899999999999997,null,2.7472527472527473,{"$f":"H28/(SUM(H26:H29))","v":0.26321666719841746},0.5344242493635083,9.5015900492767796E-3,0.26321666719841746,8.683668969270841E-3,0.81582617558047343,-9.6826175580473461E-2]
["USA","G",4,3,134,0.13400000000000001,null,0.33333333333333331,{"$f":"H29/(SUM(H26:H29))","v":3.1936955620074654E-2},6.4843475589439009E-2,1.1528595926455826E-3,1.1409513006781963E-2,3.1936955620074654E-2,0.10934280380894121,2.46571961910588E-2]
["Algeria","H",1,4,116,0.11600000000000001,null,0.25,{"$f":"H30/(SUM(H30:H33))","v":2.69647681891086E-2},{"$f":"IF(J$1=$C30, $I30, VLOOKUP(J$1, $C$30:$I$33, 7, FALSE)*($I30/(SUM($I$30:$I$33)-VLOOKUP(J$1, $C$30:$I$33, 7, FALSE))))","v":2.69647681891086E-2},4.9177363790586806E-2,9.9554517109636167E-3,1.6458194415235722E-3,8.7743403132182596E-2,2.825659686781741E-2]
["Belgium","H",2,0.16700000000000001,885,0.88500000000000001,null,5.9880239520958076,{"$f":"H31/(SUM(H30:H33))","v":0.64586271111637361},1.7898157967857556E-2,0.64586271111637361,0.23845393319673333,3.9420824946672386E-2,0.94163562722763694,-5.6635627227636931E-2]
["Russia","H",3,0.4,698,0.69799999999999995,null,2.5,{"$f":"H32/(SUM(H30:H33))","v":0.26964768189108601},7.4724809515805297E-3,0.49177363790586814,0.26964768189108601,1.6458194415235723E-2,0.78535199516377041,-8.7351995163770457E-2]
["South Korea","H",4,1.875,301,0.30099999999999999,null,0.53333333333333333,{"$f":"H33/(SUM(H30:H33))","v":5.7524838803431684E-2},1.594129269670513E-3,0.10491170941991854,2.1238296983389048E-2,5.7524838803431684E-2,0.18526897447640978,0.11573102552359021]

{"sheet":"GroupQuals (2)","index":10,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,"Gr","Tm","Odds (WH)","Sim","Sim%",null,"Odd-1","Tcoeff",1,2,3,4,"Prob"]
["Brazil","A",1,2.5000000000000001E-2,25,{"$f":"E2/25","v":1},null,{"$f":"1/D2","v":40},{"$f":"H2/(SUM(H2:H5))","v":0.94541256171930332},{"$f":"IF(J$1=$C2, $I2, VLOOKUP(J$1, $C$2:$I$5, 7, FALSE)*($I2/(SUM($I$2:$I$5)-VLOOKUP(J$1, $C$2:$I$5, 7, FALSE))))","v":0.94541256171930332},4.490250254261488E-3,2.7608225542969964E-2,2.0759806678857077E-2,{"$f":"J2+K2+L2+M2","v":0.99827084419539192}]
["Cameroon","A",2,5,1,0.04,null,{"$f":"1/D3","v":0.2},{"$f":"H3/(SUM(H2:H5))","v":4.7270628085965168E-3},8.1869102123878629E-2,4.7270628085965168E-3,1.3804112771484983E-4,1.0379903339428537E-4,{"$f":"J3+K3+L3+M3","v":8.6838005093584275E-2}]
["Croatia","A",3,0.83299999999999996,16,0.64,null,1.2004801920768309,{"$f":"H4/(SUM(H2:H5))","v":2.8373726342115949E-2},0.49141117721415745,1.3476141219272175E-4,2.8373726342115949E-2,6.2304341773280548E-4,0.52054270838619887]
["Mexico","A",4,1.1000000000000001,8,0.32,null,0.90909090909090906,{"$f":"H5/(SUM(H2:H5))","v":2.1486649129984166E-2},0.37213228238126644,1.0205114214230655E-4,6.2745967143113554E-4,2.1486649129984166E-2,0.39434844232482402]
["Australia","B",1,9,1,0.04,null,0.1111111111111111,{"$f":"H6/(SUM(H6:H9))","v":1.2276211016354802E-2},{"$f":"IF(J$1=$C6, $I6, VLOOKUP(J$1, $C$6:$I$9, 7, FALSE)*($I6/(SUM($I$6:$I$9)-VLOOKUP(J$1, $C$6:$I$9, 7, FALSE))))","v":1.2276211016354802E-2},1.8772619256312059E-3,2.9452913814167138E-3,2.40001732628694E-2,{"$f":"J6+K6+L6+M6","v":4.1098937586272116E-2}]
["Chile","B",2,0.83299999999999996,13,0.52,null,1.2004801920768309,{"$f":"H7/(SUM(H6:H9))","v":0.13263613343000388},1.6485065769809863E-3,0.13263613343000388,3.1821875669568345E-2,0.25930559347638016,{"$f":"J7+K7+L7+M7","v":0.42541210915293337}]
["Netherlands","B",3,0.57099999999999995,11,0.44,null,1.7513134851138354,{"$f":"H8/(SUM(H6:H9))","v":0.1934954450914067},2.4049141482051866E-3,2.9589067129038273E-2,0.1934954450914067,0.37828644372298537,0.60377587009163558]
["Spain","B",4,0.16700000000000001,25,1,null,5.9880239520958076,{"$f":"H9/(SUM(H6:H9))","v":0.66159221046223471},8.2227902911686298E-3,0.10116980437533442,0.15872827804042167,0.66159221046223471,0.92971308316915935]
["Colombia","C",1,0.28899999999999998,19,0.76,null,3.4602076124567476,{"$f":"H10/(SUM(H10:H13))","v":0.57643784953066235},{"$f":"IF(J$1=$C10, $I10, VLOOKUP(J$1, $C$10:$I$13, 7, FALSE)*($I10/(SUM($I$10:$I$13)-VLOOKUP(J$1, $C$10:$I$13, 7, FALSE))))","v":0.57643784953066235},5.6209646421570537E-2,0.12934788247607901,0.10287992112328827,0.86487529955160014]
["Greece","C",2,1.875,8,0.32,null,0.53333333333333333,{"$f":"H11/(SUM(H10:H13))","v":8.8848287207659415E-2},0.12091617618740327,8.8848287207659415E-2,1.993682028564631E-2,1.585722517580283E-2,0.24555850885651181]
["Ivory Coast","C",3,0.90900000000000003,7,0.28000000000000003,null,1.1001100110011002,{"$f":"H12/(SUM(H10:H13))","v":0.18326791915771334},0.24941455484200353,1.7870833680785354E-2,0.18326791915771334,3.2708797804873832E-2,0.48326210548537607]
["Japan","C",4,1.1000000000000001,16,0.64,null,0.90909090909090906,{"$f":"H13/(SUM(H10:H13))","v":0.15144594410396492},0.2061071185012556,1.4767807105303531E-2,3.3983216395988031E-2,0.15144594410396492,0.40630408610651214]
["Costa Rica","D",1,8,2,0.08,null,0.125,{"$f":"H14/(SUM(H14:H17))","v":1.8169910269957464E-2},{"$f":"IF(J$1=$C14, $I14, VLOOKUP(J$1, $C$14:$I$17, 7, FALSE)*($I14/(SUM($I$14:$I$17)-VLOOKUP(J$1, $C$14:$I$17, 7, FALSE))))","v":1.8169910269957464E-2},5.0631881741923998E-3,1.4075650232769629E-2,8.84395514733014E-3,4.6152703824249637E-2]
["England","D",2,0.66700000000000004,9,0.36,null,1.4992503748125936,{"$f":"H15/(SUM(H14:H17))","v":0.21792995826035938},4.0330479052796773E-3,0.21792995826035938,0.16882339109768668,0.10607442455568385,0.49686082181900959]
["Italy","D",3,0.33300000000000002,20,0.8,null,3.0030030030030028,{"$f":"H16/(SUM(H14:H17))","v":0.43651436083981893},8.0782070655301633E-3,0.12163815433495255,0.43651436083981893,0.21246739092685024,0.77869811316715176]
["Uruguay","D",4,0.44400000000000001,19,0.76,null,2.2522522522522523,{"$f":"H17/(SUM(H14:H17))","v":0.32738577062986424},6.0586552991476229E-3,9.1228615751214423E-2,0.25361531950936267,0.32738577062986424,0.67828836118958891]
["Ecuador","E",1,0.90900000000000003,14,0.56000000000000005,null,1.1001100110011002,{"$f":"H18/(SUM(H18:H21))","v":0.13761213305898587},{"$f":"IF(J$1=$C18, $I18, VLOOKUP(J$1, $C$18:$I$21, 7, FALSE)*($I18/(SUM($I$18:$I$21)-VLOOKUP(J$1, $C$18:$I$21, 7, FALSE))))","v":0.13761213305898587},0.22979164221932688,2.5038613903595134E-3,3.8603756579519838E-2,0.40851139324819208]
["France","E",2,0.2,22,0.88,null,5,{"$f":"H19/(SUM(H18:H21))","v":0.62544714475309071},9.9803254434019176E-2,0.62544714475309071,1.1380050019183987E-2,0.17545407365391763,0.91208452286021147]
["Honduras","E",3,7,1,0.04,null,0.14285714285714285,{"$f":"H20/(SUM(H18:H21))","v":1.7869918421516875E-2},2.8515215552576906E-3,2.9840086111052586E-2,1.7869918421516875E-2,5.0129735329690756E-3,5.5574499620796226E-2]
["Switzerland","E",4,0.57099999999999995,13,0.52,null,1.7513134851138354,{"$f":"H21/(SUM(H18:H21))","v":0.21907080376640656},3.4957357069708997E-2,0.36581541642271126,3.986007011973376E-3,0.21907080376640656,0.62382958427080015]
["Argentina","F",1,7.0999999999999994E-2,24,0.96,null,14.084507042253522,{"$f":"H22/(SUM(H22:H25))","v":0.84929528863943415},{"$f":"IF(J$1=$C22, $I22, VLOOKUP(J$1, $C$22:$I$25, 7, FALSE)*($I22/(SUM($I$22:$I$25)-VLOOKUP(J$1, $C$22:$I$25, 7, FALSE))))","v":0.84929528863943415},8.4411527420323179E-2,1.0367527631418261E-2,4.304654544277968E-2,0.98712088913395524]
["Bosnia & Herzegovina","F",2,0.66700000000000004,10,0.4,null,1.4992503748125936,{"$f":"H23/(SUM(H22:H25))","v":9.0404745867166139E-2},0.5094752781280345,9.0404745867166139E-2,1.103589897797146E-3,4.5821660066527083E-3,0.60556577989965055]
["Iran","F",3,5,2,0.08,null,0.2,{"$f":"H24/(SUM(H22:H25))","v":1.2059993098679965E-2},6.7964002102279819E-2,1.1986436893685892E-3,1.2059993098679965E-2,6.1126094528747143E-4,8.1833899835615856E-2]
["Nigeria","F",4,1.25,14,0.56000000000000005,null,0.8,{"$f":"H25/(SUM(H22:H25))","v":4.823997239471986E-2},0.27185600840911928,4.7945747574743569E-3,5.888755694645572E-4,4.823997239471986E-2,0.32547943113077804]
["Germany","G",1,0.14299999999999999,24,0.96,null,6.9930069930069934,{"$f":"H26/(SUM(H26:H29))","v":0.6700060619596081},{"$f":"IF(J$1=$C26, $I26, VLOOKUP(J$1, $C$26:$I$29, 7, FALSE)*($I26/(SUM($I$26:$I$29)-VLOOKUP(J$1, $C$26:$I$29, 7, FALSE))))","v":0.6700060619596081},2.4185865579977255E-2,0.2393604127296915,2.2103884649053055E-2,0.95565622491833002]
["Ghana","G",2,2.75,1,0.04,null,0.36363636363636365,{"$f":"H27/(SUM(H26:H29))","v":3.484031522189962E-2},7.0738337006660726E-2,3.484031522189962E-2,1.2446741461943958E-2,1.1494020017507587E-3,0.11917479569225506]
["Portugal","G",3,0.36399999999999999,22,0.88,null,2.7472527472527473,{"$f":"H28/(SUM(H26:H29))","v":0.26321666719841746},0.5344242493635083,9.5015900492767796E-3,0.26321666719841746,8.683668969270841E-3,0.81582617558047343]
["USA","G",4,3,3,0.12,null,0.33333333333333331,{"$f":"H29/(SUM(H26:H29))","v":3.1936955620074654E-2},6.4843475589439009E-2,1.1528595926455826E-3,1.1409513006781963E-2,3.1936955620074654E-2,0.10934280380894121]
["Algeria","H",1,4,2,0.08,null,0.25,{"$f":"H30/(SUM(H30:H33))","v":2.69647681891086E-2},{"$f":"IF(J$1=$C30, $I30, VLOOKUP(J$1, $C$30:$I$33, 7, FALSE)*($I30/(SUM($I$30:$I$33)-VLOOKUP(J$1, $C$30:$I$33, 7, FALSE))))","v":2.69647681891086E-2},4.9177363790586806E-2,9.9554517109636167E-3,1.6458194415235722E-3,8.7743403132182596E-2]
["Belgium","H",2,0.16700000000000001,23,0.92,null,5.9880239520958076,{"$f":"H31/(SUM(H30:H33))","v":0.64586271111637361},1.7898157967857556E-2,0.64586271111637361,0.23845393319673333,3.9420824946672386E-2,0.94163562722763694]
["Russia","H",3,0.4,13,0.52,null,2.5,{"$f":"H32/(SUM(H30:H33))","v":0.26964768189108601},7.4724809515805297E-3,0.49177363790586814,0.26964768189108601,1.6458194415235723E-2,0.78535199516377041]
["South Korea","H",4,1.875,12,0.48,null,0.53333333333333333,{"$f":"H33/(SUM(H30:H33))","v":5.7524838803431684E-2},1.594129269670513E-3,0.10491170941991854,2.1238296983389048E-2,5.7524838803431684E-2,0.18526897447640978]

{"sheet":"Simulations","index":11,"n_rows":68,"n_cols":78,"rows_kept":68,"cut":false,"hidden":true,"merged":[[0,36,0,42],[0,43,0,49],[0,64,0,70],[0,71,0,77],[0,50,0,56],[0,57,0,63],[0,0,1,0],[0,8,0,14],[0,15,0,21],[0,22,0,28],[0,29,0,35],[0,1,0,7]]}
["TEAM","Overall",null,null,null,null,null,null,"1st simulation",null,null,null,null,null,null,"2nd simulation",null,null,null,null,null,null,"3rd simulation",null,null,null,null,null,null,"4th simulation",null,null,null,null,null,null,"5th simulation",null,null,null,null,null,null,"6th simulation",null,null,null,null,null,null,"7th simulation",null,null,null,null,null,null,"8th simulation",null,null,null,null,null,null,"9th simulation",null,null,null,null,null,null,"10th simulation"]
[null,"1st","2nd","3rd","4th","QF","KO","GS","1st","2nd","3rd","4th","QF","KO","GS","1st","2nd","3rd","4th","QF","KO","GS","1st","2nd","3rd","4th","QF","KO","GS","1st","2nd","3rd","4th","QF","KO","GS","1st","2nd","3rd","4th","QF","KO","GS","1st","2nd","3rd","4th","QF","KO","GS","1st","2nd","3rd","4th","QF","KO","GS","1st","2nd","3rd","4th","QF","KO","GS","1st","2nd","3rd","4th","QF","KO","GS","1st","2nd","3rd","4th","QF","KO","GS"]
["Algeria",{"$f":"I3+P3+W3+AD3+AK3+AR3+AY3+BF3+BM3+BT3","v":0},{"$f":"J3+Q3+X3+AE3+AL3+AS3+AZ3+BG3+BN3+BU3","v":0},1,1,4,110,884,0,0,0,0,0,9,91,0,0,0,0,0,10,90,0,0,0,0,0,11,89,0,0,0,0,0,8,92,0,0,0,0,1,10,89,0,0,1,0,1,10,88,0,0,0,0,1,11,88,0,0,0,1,1,13,85,0,0,0,0,0,14,86,0,0,0,0,0,14,86]
["Argentina",{"$f":"I4+P4+W4+AD4+AK4+AR4+AY4+BF4+BM4+BT4","v":217},146,154,51,245,178,9,23,17,17,6,24,12,1,18,16,13,6,26,21,0,27,16,10,7,21,19,0,18,17,14,6,25,18,2,29,10,14,3,28,15,1,23,20,15,4,19,19,0,20,16,18,5,19,20,2,22,9,18,2,37,12,0,17,13,15,4,28,21,2,20,12,20,8,18,21,1]
["Australia",0,0,0,0,3,28,969,0,0,0,0,0,4,96,0,0,0,0,0,1,99,0,0,0,0,2,3,95,0,0,0,0,0,4,96,0,0,0,0,0,2,98,0,0,0,0,1,4,95,0,0,0,0,0,4,96,0,0,0,0,0,2,98,0,0,0,0,0,1,99,0,0,0,0,0,3,97]
["Belgium",35,58,53,60,274,405,115,2,6,4,8,32,40,8,5,11,7,7,19,39,12,2,3,5,7,30,43,10,8,4,2,7,31,35,13,5,5,7,2,28,42,11,0,4,6,6,34,38,12,4,5,3,5,26,44,13,2,6,6,10,24,40,12,3,5,9,1,23,45,14,4,9,4,7,27,39,10]
["Bosnia & Herzegovina",0,4,7,37,151,317,484,0,0,0,6,14,28,52,0,0,1,3,17,34,45,0,2,0,5,13,34,46,0,1,0,5,16,31,47,0,0,1,4,17,34,44,0,0,1,1,17,27,54,0,0,0,5,14,37,44,0,0,2,1,14,35,48,0,0,1,3,16,29,51,0,1,1,4,13,28,53]
["Brazil",249,128,110,57,172,274,10,27,17,5,3,17,31,0,26,10,11,5,21,26,1,28,7,14,6,15,29,1,26,15,11,6,13,28,1,22,14,10,1,24,26,3,25,13,13,4,16,29,0,19,12,15,5,19,28,2,22,22,9,12,12,23,0,30,12,9,6,16,25,2,24,6,13,9,19,29,0]
["Cameroon",0,0,1,2,21,161,815,0,0,1,0,2,18,79,0,0,0,0,3,22,75,0,0,0,0,2,13,85,0,0,0,0,0,13,87,0,0,0,1,3,16,80,0,0,0,1,2,24,73,0,0,0,0,2,14,84,0,0,0,0,4,13,83,0,0,0,0,0,11,89,0,0,0,0,3,17,80]
["Chile",12,17,23,20,83,304,541,3,2,2,1,6,39,47,0,2,1,5,7,28,57,1,1,4,1,6,35,52,1,4,3,2,10,28,52,2,1,3,2,8,24,60,2,0,4,1,8,31,54,3,2,4,2,17,26,46,0,2,0,3,9,30,56,0,3,1,3,5,30,58,0,0,1,0,7,33,59]
["Colombia",21,48,35,59,261,388,188,0,3,2,5,26,45,19,4,5,6,5,23,36,21,2,5,2,3,28,43,17,2,4,3,5,29,36,21,2,7,5,9,24,37,16,2,3,3,5,33,39,15,4,6,0,10,21,40,19,0,5,4,7,21,40,23,2,6,3,6,29,37,17,3,4,7,4,27,35,20]
["Costa Rica",0,0,0,0,2,29,969,0,0,0,0,0,4,96,0,0,0,0,0,2,98,0,0,0,0,0,1,99,0,0,0,0,0,4,96,0,0,0,0,0,4,96,0,0,0,0,0,3,97,0,0,0,0,0,1,99,0,0,0,0,1,2,97,0,0,0,0,0,4,96,0,0,0,0,1,4,95]
["Croatia",0,2,8,20,42,316,612,0,0,1,1,5,27,66,0,1,2,0,4,33,60,0,1,0,5,5,29,60,0,0,0,2,5,34,59,0,0,1,1,6,32,60,0,0,1,3,3,21,72,0,0,1,2,4,38,55,0,0,0,2,2,40,56,0,0,1,2,5,32,60,0,0,1,2,3,30,64]
["Ecuador",1,9,7,25,120,368,470,0,1,1,1,9,33,55,0,0,0,0,11,35,54,0,1,0,5,10,41,43,0,0,0,4,17,42,37,1,3,2,2,10,40,42,0,0,1,4,14,32,49,0,0,0,2,13,39,46,0,2,0,1,13,41,43,0,1,1,3,11,37,47,0,1,2,3,12,28,54]
["England",13,34,34,42,224,240,413,1,3,3,3,27,23,40,0,2,3,9,23,27,36,1,4,1,1,16,26,51,1,4,5,4,20,22,44,2,4,3,4,23,27,37,2,3,5,6,22,22,40,0,5,5,3,24,23,40,4,0,4,6,35,16,35,0,4,3,3,15,33,42,2,5,2,3,19,21,48]
["France",34,59,63,75,270,341,158,3,3,6,9,34,31,14,2,5,5,9,26,36,17,2,10,8,3,26,34,17,2,4,10,2,29,36,17,3,7,9,9,18,38,16,3,7,6,7,27,38,12,8,8,3,13,25,31,12,5,6,3,11,29,28,18,4,3,8,7,25,36,17,2,6,5,5,31,33,18]
["Germany",170,147,138,88,197,210,50,17,11,20,12,17,21,2,16,13,17,9,18,22,5,16,20,10,8,24,19,3,14,15,18,6,17,23,7,11,17,14,9,21,21,7,21,14,12,10,18,23,2,17,13,12,5,23,21,9,20,16,9,9,20,20,6,20,13,14,9,19,17,8,18,15,12,11,20,23,1]
["Ghana",1,1,3,5,46,141,803,0,0,0,0,3,16,81,0,0,1,0,4,13,82,0,0,0,0,5,6,89,1,0,1,0,3,16,79,0,1,0,1,6,20,72,0,0,0,0,3,16,81,0,0,0,0,7,13,80,0,0,0,1,2,14,83,0,0,0,1,7,16,76,0,0,1,2,6,11,80]
["Greece",0,{"$f":"J19+Q19+X19+AE19+AL19+AS19+AZ19+BG19+BN19+BU19","v":1},{"$f":"K19+R19+Y19+AF19+AM19+AT19+BA19+BH19+BO19+BV19","v":0},{"$f":"L19+S19+Z19+AG19+AN19+AU19+BB19+BI19+BP19+BW19","v":8},{"$f":"M19+T19+AA19+AH19+AO19+AV19+BC19+BJ19+BQ19+BX19","v":63},{"$f":"N19+U19+AB19+AI19+AP19+AW19+BD19+BK19+BR19+BY19","v":237},{"$f":"O19+V19+AC19+AJ19+AQ19+AX19+BE19+BL19+BS19+BZ19","v":691},0,0,0,1,8,24,67,0,0,0,3,7,31,59,0,0,0,0,5,22,73,0,0,0,0,7,29,64,0,0,0,2,10,18,70,0,0,0,0,5,28,67,0,0,0,0,6,26,68,0,0,0,0,3,24,73,0,0,0,2,6,16,76,0,1,0,0,6,19,74]
["Honduras",0,0,0,0,5,50,945,0,0,0,0,0,8,92,0,0,0,0,2,6,92,0,0,0,0,1,4,95,0,0,0,0,1,6,93,0,0,0,0,0,4,96,0,0,0,0,0,9,91,0,0,0,0,0,4,96,0,0,0,0,0,2,98,0,0,0,0,0,2,98,0,0,0,0,1,5,94]
["Iran",0,0,0,0,14,100,886,0,0,0,0,2,12,86,0,0,0,0,3,6,91,0,0,0,0,0,5,95,0,0,0,0,1,12,87,0,0,0,0,2,13,85,0,0,0,0,1,9,90,0,0,0,0,0,14,86,0,0,0,0,0,5,95,0,0,0,0,4,11,85,0,0,0,0,1,13,86]
["Italy",27,62,36,56,295,242,282,5,5,5,5,27,22,31,0,5,5,4,31,26,29,6,5,2,6,40,25,16,5,4,4,6,29,25,27,0,6,2,12,24,24,32,1,9,3,4,25,28,30,3,6,3,7,28,24,29,4,6,5,3,34,20,28,1,5,4,5,30,24,31,2,11,3,4,27,24,29]
["Ivory Coast",0,7,4,17,112,315,545,0,0,1,2,12,29,56,0,0,0,3,8,31,58,0,2,1,2,13,28,54,0,0,1,3,9,28,59,0,0,0,1,9,33,57,0,1,0,3,14,19,63,0,0,1,0,9,39,51,0,1,0,0,9,44,46,0,0,0,0,23,26,51,0,3,0,3,6,38,50]
["Japan",1,4,5,11,107,296,576,0,0,0,1,14,27,58,0,1,0,1,10,26,62,0,0,2,2,8,32,56,0,1,1,1,10,31,56,0,1,0,1,8,33,57,0,1,1,1,9,33,55,0,0,0,1,13,24,62,0,0,1,0,8,33,58,0,0,0,2,11,31,56,1,0,0,1,16,26,56]
["Mexico",1,5,12,21,62,336,563,0,1,1,4,6,33,55,0,1,1,1,6,27,64,0,0,2,0,6,38,54,0,0,2,3,9,33,53,0,0,1,2,7,33,57,0,0,2,2,5,36,55,0,2,1,2,5,31,59,0,0,1,1,4,33,61,1,1,0,3,9,37,49,0,0,1,3,5,35,56]
["Netherlands",23,37,44,57,110,360,369,2,6,6,4,11,28,43,2,2,3,8,16,36,33,2,0,3,7,10,35,43,1,5,3,3,8,39,41,3,6,6,7,16,39,23,3,3,3,7,10,33,41,2,4,5,5,6,33,45,3,1,4,6,8,44,34,3,7,4,4,11,38,33,2,3,7,6,14,35,33]
["Nigeria",0,1,5,20,105,248,621,0,0,2,1,8,28,61,0,1,0,0,11,24,64,0,0,1,4,11,25,59,0,0,0,4,11,21,64,0,0,2,1,7,20,70,0,0,0,2,15,27,56,0,0,0,1,9,22,68,0,0,0,2,11,30,57,0,0,0,4,9,25,62,0,0,0,1,13,26,60]
["Portugal",25,42,47,61,230,314,281,0,3,1,13,29,25,29,6,1,5,4,26,34,24,2,2,5,6,20,44,21,2,3,5,12,19,34,25,4,3,1,5,16,30,41,4,7,4,2,25,31,27,2,5,7,5,24,28,29,1,7,9,5,20,32,26,4,5,5,6,25,27,28,0,6,5,3,26,29,31]
["Russia",7,13,19,42,140,477,302,0,1,1,1,14,57,26,3,6,0,2,14,46,29,0,0,2,2,14,42,40,0,1,3,8,15,45,28,1,1,4,2,15,45,32,1,0,3,5,15,46,30,1,0,0,8,14,53,24,1,2,1,4,12,48,32,0,2,3,7,14,45,29,0,0,2,3,13,50,32]
["South Korea",0,0,2,6,43,250,699,0,0,0,1,1,23,75,0,0,0,0,4,27,69,0,0,1,3,7,28,61,0,0,0,0,3,30,67,0,0,0,1,9,22,68,0,0,1,1,1,27,70,0,0,0,0,9,16,75,0,0,0,0,5,24,71,0,0,0,0,1,28,71,0,0,0,0,3,25,72]
["Spain",146,126,123,79,184,221,121,16,15,12,7,16,20,14,17,14,14,5,12,27,11,10,16,19,9,18,18,10,18,13,9,6,22,21,11,13,6,7,12,15,28,19,13,13,14,11,17,22,10,12,14,14,5,16,26,13,15,9,15,6,28,15,12,12,14,12,9,17,26,10,20,12,7,9,23,18,11]
["Switzerland",1,7,18,28,121,398,427,1,0,0,1,11,48,39,0,0,2,6,17,38,37,0,1,1,3,12,38,45,0,0,1,2,10,34,53,0,2,1,3,12,36,46,0,1,0,3,9,39,48,0,1,5,3,12,33,46,0,0,2,2,8,47,41,0,1,3,3,16,39,38,0,1,3,2,14,46,34]
["Uruguay",16,41,46,49,259,253,336,0,6,9,3,23,26,33,1,4,3,5,29,21,37,1,4,7,5,26,23,34,1,5,4,3,29,25,33,2,6,7,3,23,24,35,0,1,1,7,30,28,33,5,1,3,6,30,23,32,1,5,6,5,22,21,40,3,5,4,5,23,29,31,2,4,2,7,24,33,28]
["USA",0,1,2,3,35,93,866,0,0,0,1,2,9,88,0,0,0,0,2,9,89,0,0,0,0,6,7,87,0,0,0,0,2,9,89,0,0,0,0,10,10,80,0,0,0,0,1,9,90,0,0,0,0,4,14,82,0,1,1,0,4,9,85,0,0,0,2,2,8,88,0,0,1,0,2,9,88]
[]
["Qual"]
["Algeria",{"$f":"1000-H3","v":116},null,null,null,null,null,"Brazil",{"$f":"VLOOKUP(H37, A$37:B$68, 2, FALSE)","v":990},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brazil",249]
["Argentina",{"$f":"1000-H4","v":991},null,null,null,null,null,"Cameroon",{"$f":"VLOOKUP(H38, A$37:B$68, 2, FALSE)","v":185},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Argentina",217]
["Australia",31,null,null,null,null,null,"Croatia",388,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Germany",170]
["Belgium",885,null,null,null,null,null,"Mexico",437,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spain",146]
["Bosnia & Herzegovina",516,null,null,null,null,null,"Australia",31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Belgium",35]
["Brazil",990,null,null,null,null,null,"Chile",459,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"France",34]
["Cameroon",185,null,null,null,null,null,"Netherlands",631,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Italy",27]
["Chile",459,null,null,null,null,null,"Spain",879,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Portugal",25]
["Colombia",812,null,null,null,null,null,"Colombia",812,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netherlands",23]
["Costa Rica",31,null,null,null,null,null,"Greece",309,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colombia",21]
["Croatia",388,null,null,null,null,null,"Ivory Coast",455,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uruguay",16]
["Ecuador",530,null,null,null,null,null,"Japan",424,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"England",13]
["England",587,null,null,null,null,null,"Costa Rica",31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chile",12]
["France",842,null,null,null,null,null,"England",587,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Russia",7]
["Germany",950,null,null,null,null,null,"Italy",718,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",5]
["Ghana",197,null,null,null,null,null,"Uruguay",664]
["Greece",309,null,null,null,null,null,"Ecuador",530]
["Honduras",55,null,null,null,null,null,"France",842]
["Iran",114,null,null,null,null,null,"Honduras",55]
["Italy",718,null,null,null,null,null,"Switzerland",573]
["Ivory Coast",455,null,null,null,null,null,"Argentina",991]
["Japan",424,null,null,null,null,null,"Bosnia & Herzegovina",516]
["Mexico",437,null,null,null,null,null,"Iran",114]
["Netherlands",631,null,null,null,null,null,"Nigeria",379]
["Nigeria",379,null,null,null,null,null,"Germany",950]
["Portugal",719,null,null,null,null,null,"Ghana",197]
["Russia",698,null,null,null,null,null,"Portugal",719]
["South Korea",301,null,null,null,null,null,"USA",134]
["Spain",879,null,null,null,null,null,"Algeria",116]
["Switzerland",573,null,null,null,null,null,"Belgium",885]
["Uruguay",664,null,null,null,null,null,"Russia",698]
["USA",134,null,null,null,null,null,"South Korea",301]