{"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-21","Rugby World Cup 2007","France","Ireland",23.5986337140274,"France",0.9025892938363635,0.09741070616363645,1.0262450753026142,39.102386389434024]
["2007-09-22","Rugby World Cup 2007","South Africa","Tonga",54.53782904930258,"South Africa",0.9986330120704836,0.0013669879295163945,1.0179122943324892,56.82757749721725]
["2007-09-22","Rugby World Cup 2007","England","Samoa",9.735479269413261,"England",0.7036203785277712,0.29637962147222885,1.0077184129281553,130.56031366917145]
["2007-09-22","Rugby World Cup 2007","Argentina","Namibia",57.70229761835747,"Argentina",0.9992378410178404,0.0007621589821595887,1.1082544714846725,10.23749371536665]
["2007-09-23","Rugby World Cup 2007","Australia","Fiji",49.088489192979424,"Australia",0.9964994660622394,0.0035005339377606193,1.0013851912263718,722.9219851827339]
["2007-09-23","Rugby World Cup 2007","Scotland","New Zealand",-34.67148014726851,"New Zealand",0.028405597691462225,0.9715944023085378,1.421671637081402,3.371513547654034]
["2007-09-25","Rugby World Cup 2007","Canada","Japan",10.61609734253075,"Canada",0.7201276232970452,0.27987237670295484,1.0007728447643665,1294.9209089676503]
["2007-09-25","Rugby World Cup 2007","Romania","Portugal",14.069037633594377,"Romania",0.7802140127394495,0.21978598726055054,1.0035474110811795,282.89571975614484]
[{"$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","Rugby World Cup 2007","Scotland",0.9744261132801293,1.0262450753026142,null,0,0,"No",0,1.231494090363137,null,"Rugby World Cup 2007","Scotland",35.542145952447974,null,35.542145952447974,0.9750257746788019,1.025613912954686,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Romania",0.02557388671987071,39.102386389434024,null,0,0,"No",0,46.92286366732083,null,"Rugby World Cup 2007","Romania",-35.542145952447974,null,-35.542145952447974,0.024974225321198085,40.041282047343486,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Italy",0.9824029099243414,1.0179122943324892,null,0,0,"No",0,1.2214947531989868,null,"Rugby World Cup 2007","Italy",38.38297009755768,null,38.38297009755768,0.982874195351628,1.0174242082347529,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Portugal",0.017597090075658572,56.82757749721725,null,0,0,"No",0,68.1930929966607,null,"Rugby World Cup 2007","Portugal",-38.38297009755768,null,-38.38297009755768,0.01712580464837199,58.39141696008204,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Wales",0.9923407046758947,1.0077184129281553,null,0,0,"No",0,1.2092620955137865,null,"Rugby World Cup 2007","Wales",44.19004825949889,null,44.19004825949889,0.9926033318678387,1.0074517865240715,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Japan",0.007659295324105253,130.56031366917145,null,0,0,"No",0,156.67237640300573,null,"Rugby World Cup 2007","Japan",-44.19004825949889,null,-44.19004825949889,0.0073966681321613326,135.1960074634032,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","France",0.9023198423556555,1.1082544714846725,null,0,0,"No",0,1.329905365781607,null,"Rugby World Cup 2007","France",23.5986337140274,null,23.5986337140274,0.9034793220371238,1.1068321937299526,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Ireland",0.09768015764434446,10.23749371536665,null,0,0,"No",0,12.28499245843998,null,"Rugby World Cup 2007","Ireland",-23.5986337140274,null,-23.5986337140274,0.09652067796287622,10.360474264225743,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","South Africa",0.9986167248741962,1.0013851912263718,null,0,0,"No",0,1.2016622294716461,null,"Rugby World Cup 2007","South Africa",54.53782904930258,null,54.53782904930258,0.9986857997454204,1.0013159296496603,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Tonga",0.001383275125803829,722.9219851827339,null,0,0,"No",0,867.5063822192807,null,"Rugby World Cup 2007","Tonga",-54.53782904930258,null,-54.53782904930258,0.0013142002545796228,760.9190429809139,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","England",0.7033973063237964,1.421671637081402,null,0,0,"No",0,1.7060059644976824,null,"Rugby World Cup 2007","England",9.735479269413261,null,9.735479269413261,0.7043598925427645,1.4197287644956105,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Samoa",0.2966026936762036,3.371513547654034,null,0,0,"No",0,4.045816257184841,null,"Rugby World Cup 2007","Samoa",-9.735479269413261,null,-9.735479269413261,0.29564010745723546,3.382490990822856,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Argentina",0.9992277520634081,1.0007728447643665,null,0,0,"No",0,1.2009274137172397,null,"Rugby World Cup 2007","Argentina",57.70229761835747,null,57.70229761835747,0.9992704490464789,1.000730083586698,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Namibia",0.0007722479365919188,1294.9209089676503,null,0,0,"No",0,1553.9050907611804,null,"Rugby World Cup 2007","Namibia",-57.70229761835747,null,-57.70229761835747,0.0007295509535211187,1370.7061791552474,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Australia",0.996465128560934,1.0035474110811795,null,0,0,"No",0,1.2042568932974154,null,"Rugby World Cup 2007","Australia",49.088489192979424,null,49.088489192979424,0.9966112492359946,1.003400273443234,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Fiji",0.0035348714390659453,282.89571975614484,null,0,0,"No",0,339.4748637073738,null,"Rugby World Cup 2007","Fiji",-49.088489192979424,null,-49.088489192979424,0.003388750764005355,295.09399470206057,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]