{"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-14","2007 Rugby World Cup","England","South Africa",-29.06490293324235,"South Africa",0.0553146841072395,0.9446853158927605,18.07838218982293,1.0585535555350145]
["2007-09-15","2007 Rugby World Cup","Wales","Australia",-17.28,"Australia",0.17143796833521074,0.8285620316647893,5.8330135950089606,1.206910239406878]
["2007-09-15","2007 Rugby World Cup","New Zealand","Portugal",83.78007682961285,"New Zealand",0.9999978741504196,2.1258495803699873e-06,1.0000021258540996,470400.1681181779]
["2007-09-15","2007 Rugby World Cup","Ireland","Georgia",40.0163022689336,"Ireland",0.9859716370644317,0.014028362935568306,1.0142279578927194,71.28415515003132]
["2007-09-16","2007 Rugby World Cup","Samoa","Tonga",21.762082037183113,"Samoa",0.8838625531245483,0.11613744687545169,1.1313976324315285,8.61048720205139]
["2007-09-16","2007 Rugby World Cup","Fiji","Canada",1.7164994759255734,"Fiji",0.5375322242465229,0.4624677757534771,1.8603535841999683,2.162312819246156]
["2007-09-16","2007 Rugby World Cup","France","Namibia",67.83862889338054,"France",0.9999018215777251,9.817842227488605e-05,1.000098188062224,10185.537481954414]
["2007-09-18","2007 Rugby World Cup","Scotland","Romania",29.542145952447974,"Scotland",0.9475519019959314,0.05244809800406858,1.055351161127524,19.066468338326143]
[{"$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!"}]
[{"$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.13]
[]
[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,"Tournament","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,"Tournament","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","England",0.0553146841072395,18.07838218982293,null,0,0,"No",0,21.694058627787516,null,"2007 Rugby World Cup","England",-29.06490293324235,null,-29.06490293324235,0.05445202810239258,18.36478887654252,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","South Africa",0.9446853158927605,1.0585535555350145,null,0,0,"No",0,1.2702642666420174,null,"2007 Rugby World Cup","South Africa",29.06490293324235,null,29.06490293324235,0.9455479718976074,1.0575878006412658,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","Wales",0.17143796833521074,5.8330135950089606,null,0,0,"No",0,6.999616314010753,null,"2007 Rugby World Cup","Wales",-17.28,null,-17.28,0.1702655534455475,5.873178571729186,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Australia",0.8285620316647893,1.206910239406878,null,0,0,"No",0,1.4482922872882535,null,"2007 Rugby World Cup","Australia",17.28,null,17.28,0.8297344465544525,1.2052048750688737,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","New Zealand",0.9999978741504196,1.0000021258540996,null,0,0,"No",0,1.2000025510249195,null,"2007 Rugby World Cup","New Zealand",83.78007682961285,null,83.78007682961285,0.9999980912098058,1.0000019087938377,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Portugal",2.1258495803699873e-06,470400.1681181779,null,0,0,"No",0,564480.2017418134,null,"2007 Rugby World Cup","Portugal",-83.78007682961285,null,-83.78007682961285,1.9087901942382857e-06,523892.04587204836,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","Ireland",0.9859716370644317,1.0142279578927194,null,0,0,"No",0,1.2170735494712632,null,"2007 Rugby World Cup","Ireland",40.0163022689336,null,40.0163022689336,0.9863495049655444,1.0138394098296146,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Georgia",0.014028362935568306,71.28415515003132,null,0,0,"No",0,85.54098618003759,null,"2007 Rugby World Cup","Georgia",-40.0163022689336,null,-40.0163022689336,0.01365049503445559,73.25741648752462,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","Samoa",0.8838625531245483,1.1313976324315285,null,0,0,"No",0,1.357677158917834,null,"2007 Rugby World Cup","Samoa",21.762082037183113,null,21.762082037183113,0.8849954598993321,1.1299492995294569,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Tonga",0.11613744687545169,8.61048720205139,null,0,0,"No",0,10.332584642461669,null,"2007 Rugby World Cup","Tonga",-21.762082037183113,null,-21.762082037183113,0.11500454010066785,8.695308890628683,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","Fiji",0.5375322242465229,1.8603535841999683,null,0,0,"No",0,2.232424301039962,null,"2007 Rugby World Cup","Fiji",1.7164994759255734,null,1.7164994759255734,0.537714426117371,1.859723212599326,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Canada",0.4624677757534771,2.162312819246156,null,0,0,"No",0,2.594775383095387,null,"2007 Rugby World Cup","Canada",-1.7164994759255734,null,-1.7164994759255734,0.46228557388262903,2.1631650574800174,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","France",0.9999018215777251,1.000098188062224,null,0,0,"No",0,1.2001178256746687,null,"2007 Rugby World Cup","France",67.83862889338054,null,67.83862889338054,0.9999086424372229,1.000091365909744,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Namibia",9.817842227488605e-05,10185.537481954414,null,0,0,"No",0,12222.644978345297,null,"2007 Rugby World Cup","Namibia",-67.83862889338054,null,-67.83862889338054,9.135756277711682e-05,10946.001289895174,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","2007 Rugby World Cup","Scotland",0.9475519019959314,1.055351161127524,null,0,0,"No",0,1.2664213933530286,null,"2007 Rugby World Cup","Scotland",29.542145952447974,null,29.542145952447974,0.9483923728905677,1.0544159027261464,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","2007 Rugby World Cup","Romania",0.05244809800406858,19.066468338326143,null,0,0,"No",0,22.879762005991367,null,"2007 Rugby World Cup","Romania",-29.542145952447974,null,-29.542145952447974,0.05160762710943234,19.376980807110773,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]
["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]