{"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":16,"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"]
["2011-09-20","World cup - Pool C","Italy","Russia",38.51820819124278,"Italy",0.985851503835379,0.014148496164620994,1.0143515490006125,70.67888971130012,{"$nulls":5},""]
["2011-09-21","World cup - Pool A","Tonga","Japan",4.840956849966304,"Tonga",0.6085852897515146,0.3914147102484854,1.6431550627986753,2.554834996786812,{"$nulls":5},""]
["2011-09-22","World cup - Pool D","South Africa","Namibia",58.70261675651822,"South Africa",0.9995847153118715,0.00041528468812845887,1.000415457221151,2407.986686209516]
["2011-09-23","World cup - Pool C","Australia","United States",42.70562092109756,"Australia",0.9924831556098331,0.007516844390166866,1.0075737752803957,133.03454855446344]
["2011-09-24","World cup - Pool B","England","Romania",36.5807197660872,"England",0.9813665363975844,0.01863346360241558,1.0189872620588996,53.66688777444272]
["2011-09-24","World cup - Pool A","New Zealand","France",27.452358649034437,"New Zealand",0.9409829269648751,0.059017073035124934,1.0627185375461419,16.94424932603544]
["2011-09-25","World cup - Pool D","Fiji","Samoa",-14.944043701179268,"Samoa",0.19741750616268017,0.8025824938373198,5.065406910651372,1.245977837391873]
[]
[]
[]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]

{"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,17.61]
[]
[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","World cup - Pool C","Italy",0.985851503835379,1.0143515490006125,null,0,0,"No",0,1.217221858800735,null,"World cup - Pool C","Italy",38.51820819124278,null,38.51820819124278,0.9856393846743183,1.0145698472980833,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool C","Russia",0.014148496164620994,70.67888971130012,null,0,0,"No",0,84.81466765356015,null,"World cup - Pool C","Russia",-38.51820819124278,null,-38.51820819124278,0.01436061532568167,69.63489915447144,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool A","Tonga",0.6085852897515146,1.6431550627986753,null,0,0,"No",0,1.9717860753584102,null,"World cup - Pool A","Tonga",4.840956849966304,null,4.840956849966304,0.6083027650967074,1.643918221941702,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool A","Japan",0.3914147102484854,2.554834996786812,null,0,0,"No",0,3.065801996144174,null,"World cup - Pool A","Japan",-4.840956849966304,null,-4.840956849966304,0.39169723490329256,2.5529922370958102,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool D","South Africa",0.9995847153118715,1.000415457221151,null,0,0,"No",0,1.2004985486653812,null,"World cup - Pool D","South Africa",58.70261675651822,null,58.70261675651822,0.999571168784877,1.0004290151902284,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool D","Namibia",0.00041528468812845887,2407.986686209516,null,0,0,"No",0,2889.584023451419,null,"World cup - Pool D","Namibia",-58.70261675651822,null,-58.70261675651822,0.0004288312151230489,2331.919796727157,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool C","Australia",0.9924831556098331,1.0075737752803957,null,0,0,"No",0,1.2090885303364747,null,"World cup - Pool C","Australia",42.70562092109756,null,42.70562092109756,0.9923474478195053,1.0077115653366264,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool C","United States",0.007516844390166866,133.03454855446344,null,0,0,"No",0,159.6414582653561,null,"World cup - Pool C","United States",-42.70562092109756,null,-42.70562092109756,0.007652552180494654,130.6753585488601,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool B","England",0.9813665363975844,1.0189872620588996,null,0,0,"No",0,1.2227847144706794,null,"World cup - Pool B","England",36.5807197660872,null,36.5807197660872,0.9811116639169644,1.0192519738350947,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool B","Romania",0.01863346360241558,53.66688777444272,null,0,0,"No",0,64.40026532933126,null,"World cup - Pool B","Romania",-36.5807197660872,null,-36.5807197660872,0.01888833608303564,52.94272590258173,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool A","New Zealand",0.9409829269648751,1.0627185375461419,null,0,0,"No",0,1.2752622450553701,null,"World cup - Pool A","New Zealand",27.452358649034437,null,27.452358649034437,0.9404908462170063,1.0632745698933286,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool A","France",0.059017073035124934,16.94424932603544,null,0,0,"No",0,20.33309919124253,null,"World cup - Pool A","France",-27.452358649034437,null,-27.452358649034437,0.05950915378299371,16.80413745499732,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool D","Fiji",0.19741750616268017,5.065406910651372,null,0,0,"No",0,6.078488292781646,null,"World cup - Pool D","Fiji",-14.944043701179268,null,-14.944043701179268,0.19804882895424636,5.0492598480904025,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool D","Samoa",0.8025824938373198,1.245977837391873,null,0,0,"No",0,1.4951734048702476,null,"World cup - Pool D","Samoa",14.944043701179268,null,14.944043701179268,0.8019511710457536,1.246958712830344,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]
["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]