{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Predictions","Betting Tool"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Predictions","index":0,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Date","Tournament","Team 1","Team 2","Predicted margin (negative indicates away Team 2 is predicted to win)","Predicted winner","Chance Team 1 wins","Chance Team 2 wins","Fair price Team 1","Fair price Team 2"]
["2007-09-07","2007 Rugby World Cup","France","Argentina",11.47570334967439,"France",0.7366199101525404,0.26338008984745964,1.3575522277057628,3.796794209384484]
["2007-09-08","2007 Rugby World Cup","England","United States",24.358199791072742,"England",0.9104469559125545,0.08955304408744547,1.0983616272270196,11.166566253443428]
["2007-09-08","2007 Rugby World Cup","Australia","Japan",57.39617278297264,"Australia",0.9992266365644105,0.0007733634355895358,1.0007739619894926,1293.0531157549476]
["2007-09-08","2007 Rugby World Cup","New Zealand","Italy",35.635934521229046,"New Zealand",0.9753248424805052,0.024675157519494784,1.0252994248118805,40.52659032510503]
["2007-09-09","2007 Rugby World Cup","South Africa","Samoa",28.158918540275792,"South Africa",0.9398059582737479,0.06019404172625209,1.0640494361589465,16.612939940928996]
["2007-09-09","2007 Rugby World Cup","Wales","Canada",25.922184284818073,"Wales",0.9236093909369063,0.0763906090630937,1.0827087834020432,13.090614308023971]
["2007-09-09","2007 Rugby World Cup","Scotland","Portugal",78.37430550293817,"Scotland",0.999992298696353,7.701303647023039e-06,1.0000077013629576,129848.14595468559]
["2007-09-09","2007 Rugby World Cup","Ireland","Namibia",68.63003370506124,"Ireland",0.9999232664093117,7.673359068827157e-05,1.000076739479184,13032.102251834882]
["2007-09-11","2007 Rugby World Cup","Argentina","Georgia",50.06558980344963,"Argentina",0.9971226590670312,0.002877340932968764,1.0028856439143214,347.54310430923687]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Betting Tool","index":1,"n_rows":69,"n_cols":27,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,17,1,19],[3,17,3,19]],"flags":["formulas_cached_only"]}
[]
[null,null,"Head to head bet",{"$nulls":10},"Line betting",null,null,null,"Standard deviation of errors",null,null,18.43]
[]
[null,null,"Overlay",null,0.2,{"$nulls":8},"Overlay",null,0.2,null,"Current pool",null,null,1000]
[null,null,"Kelly percent",null,1,{"$nulls":8},"Kelly percent",null,1]
[]
[null,"Tournamnet","Team","Predicted chance of team winning (%)","Predicted fair price","Bookmakers Price","Return for each $","Overlay %","Bet?","Kelly bet (percent of pool to bet)","Watch price for your Overlay amount (i.e.20%)",null,"Tournamnet","Team","Predicted margin","Bookies start","Differential","Probability","Predicted fair price","Bookmakers Price","Overlay %","Bet?","Kelly bet (percent of pool to bet)","Amount to bet",null,null," Upper point"]
["Team 1","2007 Rugby World Cup","France",0.7366199101525404,1.3575522277057628,null,0,0,"No",0,1.6290626732469153,null,"2007 Rugby World Cup","France",11.47570334967439,null,11.47570334967439,0.733247431701354,1.3637961167892536,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Argentina",0.26338008984745964,3.796794209384484,null,0,0,"No",0,4.556153051261381,null,"2007 Rugby World Cup","Argentina",-11.47570334967439,null,-11.47570334967439,0.266752568298646,3.7487923973066986,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","England",0.9104469559125545,1.0983616272270196,null,0,0,"No",0,1.3180339526724234,null,"2007 Rugby World Cup","England",24.358199791072742,null,24.358199791072742,0.9068593571303172,1.1027068223284577,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","United States",0.08955304408744547,11.166566253443428,null,0,0,"No",0,13.399879504132112,null,"2007 Rugby World Cup","United States",-24.358199791072742,null,-24.358199791072742,0.09314064286968282,10.736451555301633,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","Australia",0.9992266365644105,1.0007739619894926,null,0,0,"No",0,1.2009287543873912,null,"2007 Rugby World Cup","Australia",57.39617278297264,null,57.39617278297264,0.9990780266518783,1.000922824167409,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Japan",0.0007733634355895358,1293.0531157549476,null,0,0,"No",0,1551.6637389059372,null,"2007 Rugby World Cup","Japan",-57.39617278297264,null,-57.39617278297264,0.0009219733481217185,1084.630051440468,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","New Zealand",0.9753248424805052,1.0252994248118805,null,0,0,"No",0,1.2303593097742567,null,"2007 Rugby World Cup","New Zealand",35.635934521229046,null,35.635934521229046,0.973417789889062,1.0273081203025554,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Italy",0.024675157519494784,40.52659032510503,null,0,0,"No",0,48.631908390126036,null,"2007 Rugby World Cup","Italy",-35.635934521229046,null,-35.635934521229046,0.026582210110937976,37.61914437613006,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","South Africa",0.9398059582737479,1.0640494361589465,null,0,0,"No",0,1.276859323390736,null,"2007 Rugby World Cup","South Africa",28.158918540275792,null,28.158918540275792,0.9367294399166315,1.0675441140069213,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Samoa",0.06019404172625209,16.612939940928996,null,0,0,"No",0,19.935527929114794,null,"2007 Rugby World Cup","Samoa",-28.158918540275792,null,-28.158918540275792,0.06327056008336851,15.805139051754072,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","Wales",0.9236093909369063,1.0827087834020432,null,0,0,"No",0,1.2992505400824519,null,"2007 Rugby World Cup","Wales",25.922184284818073,null,25.922184284818073,0.9202152815315957,1.0867022316078163,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Canada",0.0763906090630937,13.090614308023971,null,0,0,"No",0,15.708737169628765,null,"2007 Rugby World Cup","Canada",-25.922184284818073,null,-25.922184284818073,0.07978471846840429,12.533728503360102,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","Scotland",0.999992298696353,1.0000077013629576,null,0,0,"No",0,1.200009241635549,null,"2007 Rugby World Cup","Scotland",78.37430550293817,null,78.37430550293817,0.9999894320104106,1.000010568101273,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Portugal",7.701303647023039e-06,129848.14595468559,null,0,0,"No",0,155817.7751456227,null,"2007 Rugby World Cup","Portugal",-78.37430550293817,null,-78.37430550293817,1.0567989589427285e-05,94625.37709163218,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","Ireland",0.9999232664093117,1.000076739479184,null,0,0,"No",0,1.200092087375021,null,"2007 Rugby World Cup","Ireland",68.63003370506124,null,68.63003370506124,0.9999018852269987,1.0000981244004545,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Namibia",7.673359068827157e-05,13032.102251834882,null,0,0,"No",0,15638.522702201857,null,"2007 Rugby World Cup","Namibia",-68.63003370506124,null,-68.63003370506124,9.81147730012566e-05,10192.14507062247,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","Argentina",0.9971226590670312,1.0028856439143214,null,0,0,"No",0,1.2034627726971856,null,"2007 Rugby World Cup","Argentina",50.06558980344963,null,50.06558980344963,0.9967014577819184,1.0033094586070157,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Georgia",0.002877340932968764,347.54310430923687,null,0,0,"No",0,417.05172517108423,null,"2007 Rugby World Cup","Georgia",-50.06558980344963,null,-50.06558980344963,0.0032985422180815682,303.16422646292517,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ",0,0,0,{"$error":"#DIV/0!"},null,0,0,"No",0,{"$error":"#DIV/0!"},null,0,0,0,null,0,0.5,2,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]