{"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-09-28","World cup - Pool B","Georgia","Romania",4.193220856726768,"Georgia",0.5944887430879341,0.4055112569120659,1.6821176374269622,2.466022787172213,{"$nulls":5},""]
["2011-09-30","World cup - Pool D","South Africa","Samoa",22.088080845356956,"South Africa",0.8960775122344479,0.10392248776555213,1.1159748864876793,9.622556402383168,{"$nulls":5},""]
["2011-10-01","World cup - Pool C","Australia","Russia",64.76571805542414,"Australia",0.9998892275155326,0.00011077248446744736,1.0001107847563702,9027.512606651604]
["2011-10-01","World cup - Pool A","France","Tonga",22.93074547704036,"France",0.9044893863695049,0.09551061363049507,1.1055961684789486,10.4700405744301]
["2011-10-01","World cup - Pool B","England","Scotland",16.808559573249326,"England",0.8310852927578537,0.1689147072421463,1.203245934820509,5.9201476077891675]
["2011-10-02","World cup - Pool B","Argentina","Georgia",32.384180453677466,"Argentina",0.9675989337548471,0.03240106624515293,1.03348604996847,30.863181860553617]
["2011-10-02","World cup - Pool A","New Zealand","Canada",55.31635255818218,"New Zealand",0.9991954884055855,0.0008045115944145254,1.0008051593544505,1242.99016563924]
["2011-10-02","World cup - Pool D","Wales","Fiji",26.953900341877294,"Wales",0.9378501120589087,0.06214988794109133,1.0662684656556158,16.09013359682721]
["2011-10-02","World cup - Pool C","Ireland","Italy",12.93539200087453,"Ireland",0.7696230156030963,0.23037698439690368,1.2993374414827945,4.340711389281647]
[{"$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},"",""]
[{"$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 B","Georgia",0.5944887430879341,1.6821176374269622,null,0,0,"No",0,2.0185411649123544,null,"World cup - Pool B","Georgia",4.193220856726768,null,4.193220856726768,0.5941043953906616,1.6832058603815514,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool B","Romania",0.4055112569120659,2.466022787172213,null,0,0,"No",0,2.959227344606655,null,"World cup - Pool B","Romania",-4.193220856726768,null,-4.193220856726768,0.4058956046093384,2.463687678910611,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool D","South Africa",0.8960775122344479,1.1159748864876793,null,0,0,"No",0,1.3391698637852152,null,"World cup - Pool D","South Africa",22.088080845356956,null,22.088080845356956,0.8951320415246131,1.1171536193663372,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool D","Samoa",0.10392248776555213,9.622556402383168,null,0,0,"No",0,11.547067682859801,null,"World cup - Pool D","Samoa",-22.088080845356956,null,-22.088080845356956,0.10486795847538688,9.535801159271216,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool C","Australia",0.9998892275155326,1.0001107847563702,null,0,0,"No",0,1.200132941707644,null,"World cup - Pool C","Australia",64.76571805542414,null,64.76571805542414,0.9998823639476437,1.000117649892225,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool C","Russia",0.00011077248446744736,9027.512606651604,null,0,0,"No",0,10833.015127981924,null,"World cup - Pool C","Russia",-64.76571805542414,null,-64.76571805542414,0.00011763605235626251,8500.795291663522,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool A","France",0.9044893863695049,1.1055961684789486,null,0,0,"No",0,1.3267154021747383,null,"World cup - Pool A","France",22.93074547704036,null,22.93074547704036,0.9035663172772798,1.1067256280793027,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool A","Tonga",0.09551061363049507,10.4700405744301,null,0,0,"No",0,12.56404868931612,null,"World cup - Pool A","Tonga",-22.93074547704036,null,-22.93074547704036,0.09643368272272024,10.369820707515043,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool B","England",0.8310852927578537,1.203245934820509,null,0,0,"No",0,1.4438951217846105,null,"World cup - Pool B","England",16.808559573249326,null,16.808559573249326,0.8300820316255693,1.2047002126304027,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool B","Scotland",0.1689147072421463,5.9201476077891675,null,0,0,"No",0,7.104177129347001,null,"World cup - Pool B","Scotland",-16.808559573249326,null,-16.808559573249326,0.16991796837443074,5.885192776060051,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool B","Argentina",0.9675989337548471,1.03348604996847,null,0,0,"No",0,1.2401832599621638,null,"World cup - Pool B","Argentina",32.384180453677466,null,32.384180453677466,0.9670398613280399,1.0340835367703414,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool B","Georgia",0.03240106624515293,30.863181860553617,null,0,0,"No",0,37.03581823266434,null,"World cup - Pool B","Georgia",-32.384180453677466,null,-32.384180453677466,0.032960138671960126,30.33967817771109,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool A","New Zealand",0.9991954884055855,1.0008051593544505,null,0,0,"No",0,1.2009661912253407,null,"World cup - Pool A","New Zealand",55.31635255818218,null,55.31635255818218,0.9991586852835277,1.0008420231229171,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool A","Canada",0.0008045115944145254,1242.99016563924,null,0,0,"No",0,1491.588198767088,null,"World cup - Pool A","Canada",-55.31635255818218,null,-55.31635255818218,0.0008413147164723078,1188.6158418731468,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool D","Wales",0.9378501120589087,1.0662684656556158,null,0,0,"No",0,1.2795221587867391,null,"World cup - Pool D","Wales",26.953900341877294,null,26.953900341877294,0.9370661002637197,1.0671605767390036,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool D","Fiji",0.06214988794109133,16.09013359682721,null,0,0,"No",0,19.30816031619265,null,"World cup - Pool D","Fiji",-26.953900341877294,null,-26.953900341877294,0.06293389973628027,15.889687500543015,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool C","Ireland",0.7696230156030963,1.2993374414827945,null,0,0,"No",0,1.5592049297793533,null,"World cup - Pool C","Ireland",12.93539200087453,null,12.93539200087453,0.768692621281567,1.3009101067378486,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool C","Italy",0.23037698439690368,4.340711389281647,null,0,0,"No",0,5.2088536671379755,null,"World cup - Pool C","Italy",-12.93539200087453,null,-12.93539200087453,0.231307378718433,4.323251621027123,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]