{"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-25","Rugby World Cup 2007","Canada","Japan",10.61609734253075,"Canada",0.7201276232970452,0.27987237670295484,1.388642745603317,3.573057161912622]
["2007-09-25","Rugby World Cup 2007","Romania","Portugal",14.069037633594377,"Romania",0.7802140127394495,0.21978598726055054,1.2816996153258626,4.549880601871703]
["2007-09-26","Rugby World Cup 2007","Samoa","United States",14.556893982291896,"Samoa",0.7880628290294027,0.21193717097059728,1.2689343579770465,4.718379486809009]
["2007-09-26","Rugby World Cup 2007","Georgia","Namibia",18.680548390596527,"Georgia",0.8476156104696326,0.15238438953036737,1.1797800649824475,6.562351977665787]
["2007-09-28","Rugby World Cup 2007","England","Tonga",23.25369505469778,"England",0.8992866348473127,0.10071336515268725,1.111992507449849,9.929168770043008]
["2007-09-29","Rugby World Cup 2007","Australia","Canada",54.415708836608815,"Australia",0.9986026311082292,0.0013973688917707783,1.0013993242639667,715.630644054754]
["2007-09-29","Rugby World Cup 2007","Wales","Fiji",25.385915830299098,"Wales",0.9184371760088925,0.08156282399110748,1.0888061003209193,12.260487696073724]
["2007-09-29","Rugby World Cup 2007","New Zealand","Romania",72.28013939493314,"New Zealand",0.999964196507483,3.580349251697257e-05,1.0000358047744529,27930.236122242884]
["2007-09-29","Rugby World Cup 2007","Scotland","Italy",11.257277214919782,"Scotland",0.7318591190803367,0.26814088091966326,1.3663831930612718,3.7293828399840545]
["2007-09-30","Rugby World Cup 2007","South Africa","United States",55.57650724630996,"South Africa",0.9988680316173746,0.0011319683826254145,1.001133251187139,883.4169004620645]
["2007-09-30","Rugby World Cup 2007","France","Georgia",52.08971925690225,"France",0.997892944150891,0.002107055849108974,1.0021115049078755,474.5958681744849]
["2007-09-30","Rugby World Cup 2007","Ireland","Argentina",-10.530663684886093,"Argentina",0.28145412796926705,0.718545872030733,3.5529768464052993,1.3916995962607506]
[{"$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","Canada",0.7201276232970452,1.388642745603317,null,0,0,"No",0,1.6663712947239804,null,"Rugby World Cup 2007","Canada",10.61609734253075,null,10.61609734253075,0.7209124274546757,1.3871310327257063,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Japan",0.27987237670295484,3.573057161912622,null,0,0,"No",0,4.2876685942951465,null,"Rugby World Cup 2007","Japan",-10.61609734253075,null,-10.61609734253075,0.27908757254532435,3.583104725444549,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Romania",0.7802140127394495,1.2816996153258626,null,0,0,"No",0,1.538039538391035,null,"Rugby World Cup 2007","Romania",14.069037633594377,null,14.069037633594377,0.7811280739064417,1.2801997948927557,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Portugal",0.21978598726055054,4.549880601871703,null,0,0,"No",0,5.459856722246043,null,"Rugby World Cup 2007","Portugal",-14.069037633594377,null,-14.069037633594377,0.21887192609355832,4.568881984309596,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Samoa",0.7880628290294027,1.2689343579770465,null,0,0,"No",0,1.5227212295724555,null,"Rugby World Cup 2007","Samoa",14.556893982291896,null,14.556893982291896,0.7889887851063152,1.2674451384822298,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","United States",0.21193717097059728,4.718379486809009,null,0,0,"No",0,5.66205538417081,null,"Rugby World Cup 2007","United States",-14.556893982291896,null,-14.556893982291896,0.2110112148936848,4.739084605071047,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Georgia",0.8476156104696326,1.1797800649824475,null,0,0,"No",0,1.4157360779789367,null,"Rugby World Cup 2007","Georgia",18.680548390596527,null,18.680548390596527,0.8485810520424502,1.1784378140344984,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Namibia",0.15238438953036737,6.562351977665787,null,0,0,"No",0,7.874822373198945,null,"Rugby World Cup 2007","Namibia",-18.680548390596527,null,-18.680548390596527,0.15141894795754984,6.604193289470939,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","England",0.8992866348473127,1.111992507449849,null,0,0,"No",0,1.3343910089398188,null,"Rugby World Cup 2007","England",23.25369505469778,null,23.25369505469778,0.900185393145735,1.1108822778221925,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Tonga",0.10071336515268725,9.929168770043008,null,0,0,"No",0,11.915002524051609,null,"Rugby World Cup 2007","Tonga",-23.25369505469778,null,-23.25369505469778,0.09981460685426502,10.018573749031107,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Australia",0.9986026311082292,1.0013993242639667,null,0,0,"No",0,1.20167918911676,null,"Rugby World Cup 2007","Australia",54.415708836608815,null,54.415708836608815,0.9986563731002965,1.001345434661907,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Canada",0.0013973688917707783,715.630644054754,null,0,0,"No",0,858.7567728657049,null,"Rugby World Cup 2007","Canada",-54.415708836608815,null,-54.415708836608815,0.001343626899703465,744.2542272863824,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Wales",0.9184371760088925,1.0888061003209193,null,0,0,"No",0,1.3065673203851031,null,"Rugby World Cup 2007","Wales",25.385915830299098,null,25.385915830299098,0.9192756749475253,1.0878129675922108,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Fiji",0.08156282399110748,12.260487696073724,null,0,0,"No",0,14.712585235288469,null,"Rugby World Cup 2007","Fiji",-25.385915830299098,null,-25.385915830299098,0.08072432505247473,12.387839716838158,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","New Zealand",0.999964196507483,1.0000358047744529,null,0,0,"No",0,1.2000429657293434,null,"Rugby World Cup 2007","New Zealand",72.28013939493314,null,72.28013939493314,0.9999665105456754,1.0000334905759056,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Romania",3.580349251697257e-05,27930.236122242884,null,0,0,"No",0,33516.28334669146,null,"Rugby World Cup 2007","Romania",-72.28013939493314,null,-72.28013939493314,3.348945432457562e-05,29860.146131618767,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Scotland",0.7318591190803367,1.3663831930612718,null,0,0,"No",0,1.639659831673526,null,"Rugby World Cup 2007","Scotland",11.257277214919782,null,11.257277214919782,0.7326738260951697,1.3648638239604676,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Italy",0.26814088091966326,3.7293828399840545,null,0,0,"No",0,4.475259407980865,null,"Rugby World Cup 2007","Italy",-11.257277214919782,null,-11.257277214919782,0.26732617390483027,3.7407485596827716,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","South Africa",0.9988680316173746,1.001133251187139,null,0,0,"No",0,1.2013599014245666,null,"Rugby World Cup 2007","South Africa",55.57650724630996,null,55.57650724630996,0.9989132661324649,1.0010879161428525,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","United States",0.0011319683826254145,883.4169004620645,null,0,0,"No",0,1060.1002805544774,null,"Rugby World Cup 2007","United States",-55.57650724630996,null,-55.57650724630996,0.0010867338675351057,920.1884931295713,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","France",0.997892944150891,1.0021115049078755,null,0,0,"No",0,1.2025338058894506,null,"Rugby World Cup 2007","France",52.08971925690225,null,52.08971925690225,0.9979678205235671,1.002036317639347,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Georgia",0.002107055849108974,474.5958681744849,null,0,0,"No",0,569.5150418093818,null,"Rugby World Cup 2007","Georgia",-52.08971925690225,null,-52.08971925690225,0.0020321794764328605,492.0825210553386,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","Rugby World Cup 2007","Ireland",0.28145412796926705,3.5529768464052993,null,0,0,"No",0,4.263572215686359,null,"Rugby World Cup 2007","Ireland",-10.530663684886093,null,-10.530663684886093,0.28067350572942784,3.5628585512592355,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","Rugby World Cup 2007","Argentina",0.718545872030733,1.3916995962607506,null,0,0,"No",0,1.6700395155129006,null,"Rugby World Cup 2007","Argentina",10.530663684886093,null,10.530663684886093,0.7193264942705722,1.3901893061982136,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]