{"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":32,"n_cols":16,"rows_kept":32,"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-10-08","World cup - Qrt Final 1","Ireland","Wales",-10.638230238066512,"Wales",0.2723878204825054,0.7276121795174946,3.671236100896907,1.3743585225073272,{"$nulls":5},""]
["2011-10-08","World cup - Qrt Final 2","England","France",4.108876379576927,"England",0.5924717196917249,0.40752828030827515,1.687844274694361,2.453817436285769,{"$nulls":5},""]
["2011-10-09","World cup - Qrt Final 3","South Africa","Australia",4.696101795721944,"South Africa",0.6053951622263587,0.3946048377736413,1.6518136622077888,2.534180791198596]
["2011-10-09","World cup - Qrt Final 4","New Zealand","Argentina",31.294764294119574,"New Zealand",0.9625871016129803,0.037412898387019666,1.0388670265000726,26.728749792530056]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$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},"",""]
[{"$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 - Qrt Final 1","Ireland",0.2723878204825054,3.671236100896907,null,0,0,"No",0,4.4054833210762885,null,"World cup - Qrt Final 1","Ireland",-10.638230238066512,null,-10.638230238066512,0.27288802788136945,3.664506676103513,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Qrt Final 1","Wales",0.7276121795174946,1.3743585225073272,null,0,0,"No",0,1.6492302270087926,null,"World cup - Qrt Final 1","Wales",10.638230238066512,null,10.638230238066512,0.7271119721186305,1.375303994907743,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Qrt Final 2","England",0.5924717196917249,1.687844274694361,null,0,0,"No",0,2.025413129633233,null,"World cup - Qrt Final 2","England",4.108876379576927,null,4.108876379576927,0.5922459863747782,1.6884875930036132,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Qrt Final 2","France",0.40752828030827515,2.453817436285769,null,0,0,"No",0,2.944580923542923,null,"World cup - Qrt Final 2","France",-4.108876379576927,null,-4.108876379576927,0.4077540136252218,2.4524589987705876,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Qrt Final 3","South Africa",0.6053951622263587,1.6518136622077888,null,0,0,"No",0,1.9821763946493465,null,"World cup - Qrt Final 3","South Africa",4.696101795721944,null,4.696101795721944,0.6051393150909178,1.652512033282381,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Qrt Final 3","Australia",0.3946048377736413,2.534180791198596,null,0,0,"No",0,3.0410169494383155,null,"World cup - Qrt Final 3","Australia",-4.696101795721944,null,-4.696101795721944,0.3948606849090822,2.5325387870161165,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Qrt Final 4","New Zealand",0.9625871016129803,1.0388670265000726,null,0,0,"No",0,1.246640431800087,null,"World cup - Qrt Final 4","New Zealand",31.294764294119574,null,31.294764294119574,0.9622242614134444,1.0392587675258422,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Qrt Final 4","Argentina",0.037412898387019666,26.728749792530056,null,0,0,"No",0,32.074499751036065,null,"World cup - Qrt Final 4","Argentina",-31.294764294119574,null,-31.294764294119574,0.037775738586555585,26.47201715748586,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]
["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]