{"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-14","World cup - Pool D","Samoa","Namibia",41.63040589641917,"Samoa",0.9911261506403101,0.008873849359689934,1.0089532995915373,112.69066663927926,{"$nulls":5},""]
["2011-09-14","World cup - Pool A","Tonga","Canada",11.86016888994287,"Tonga",0.7502997706724628,0.24970022932753722,1.332800620615599,4.004802088861033,{"$nulls":5},""]
["2011-09-14","World cup - Pool B","Scotland","Georgia",33.09654865074941,"Scotland",0.9702742403186998,0.0297257596813002,1.030636451475344,33.64085596874004]
["2011-09-15","World cup - Pool C","Russia","United States",-25.16390751623056,"United States",0.07591781958286092,0.9240821804171391,13.172138049994237,1.0821548355673203]
["2011-09-16","World cup - Pool A","New Zealand","Japan",45.613427200295575,"New Zealand",0.9953070984767364,0.004692901523263626,1.0047150286885784,213.08778695713204]
["2011-09-17","World cup - Pool B","Argentina","Romania",33.30100915324275,"Argentina",0.9710519236688073,0.028948076331192674,1.0298110488487802,34.54460975434355]
["2011-09-17","World cup - Pool D","South Africa","Fiji",27.34337681675065,"South Africa",0.9402882422405929,0.05971175775940707,1.0635036737427677,16.74712045874179]
["2011-09-17","World cup - Pool C","Australia","Ireland",21.598520557995897,"Australia",0.8906570390534858,0.10934296094651419,1.1227666275031234,9.145536130937193]
[{"$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 D","Samoa",0.9911261506403101,1.0089532995915373,null,0,0,"No",0,1.2107439595098448,null,"World cup - Pool D","Samoa",41.63040589641917,null,41.63040589641917,0.9909611006649732,1.0091213462657225,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool D","Namibia",0.008873849359689934,112.69066663927926,null,0,0,"No",0,135.2287999671351,null,"World cup - Pool D","Namibia",-41.63040589641917,null,-41.63040589641917,0.009038899335026773,110.63293913727804,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool A","Tonga",0.7502997706724628,1.332800620615599,null,0,0,"No",0,1.5993607447387188,null,"World cup - Pool A","Tonga",11.86016888994287,null,11.86016888994287,0.7496823761153677,1.333898237253094,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool A","Canada",0.24970022932753722,4.004802088861033,null,0,0,"No",0,4.805762506633239,null,"World cup - Pool A","Canada",-11.86016888994287,null,-11.86016888994287,0.2503176238846323,3.994924466288819,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool B","Scotland",0.9702742403186998,1.030636451475344,null,0,0,"No",0,1.236763741770413,null,"World cup - Pool B","Scotland",33.09654865074941,null,33.09654865074941,0.9699062707575821,1.0310274612606762,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool B","Georgia",0.0297257596813002,33.64085596874004,null,0,0,"No",0,40.36902716248805,null,"World cup - Pool B","Georgia",-33.09654865074941,null,-33.09654865074941,0.030093729242417933,33.229514093935315,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool C","Russia",0.07591781958286092,13.172138049994237,null,0,0,"No",0,15.806565659993083,null,"World cup - Pool C","Russia",-25.16390751623056,null,-25.16390751623056,0.076508502532047,13.070442720809123,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool C","United States",0.9240821804171391,1.0821548355673203,null,0,0,"No",0,1.2985858026807844,null,"World cup - Pool C","United States",25.16390751623056,null,25.16390751623056,0.923491497467953,1.0828470026435755,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool A","New Zealand",0.9953070984767364,1.0047150286885784,null,0,0,"No",0,1.2056580344262942,null,"World cup - Pool A","New Zealand",45.613427200295575,null,45.613427200295575,0.9952039948074018,1.0048191177061405,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool A","Japan",0.004692901523263626,213.08778695713204,null,0,0,"No",0,255.70534434855844,null,"World cup - Pool A","Japan",-45.613427200295575,null,-45.613427200295575,0.004796005192598152,208.50686349200294,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool B","Argentina",0.9710519236688073,1.0298110488487802,null,0,0,"No",0,1.2357732586185362,null,"World cup - Pool B","Argentina",33.30100915324275,null,33.30100915324275,0.9706897197077252,1.0301953133912864,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool B","Romania",0.028948076331192674,34.54460975434355,null,0,0,"No",0,41.45353170521226,null,"World cup - Pool B","Romania",-33.30100915324275,null,-33.30100915324275,0.029310280292274782,34.11772217898465,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool D","South Africa",0.9402882422405929,1.0635036737427677,null,0,0,"No",0,1.276204408491321,null,"World cup - Pool D","South Africa",27.34337681675065,null,27.34337681675065,0.9397548270461085,1.0641073301461592,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool D","Fiji",0.05971175775940707,16.74712045874179,null,0,0,"No",0,20.096544550490147,null,"World cup - Pool D","Fiji",-27.34337681675065,null,-27.34337681675065,0.060245172953891535,16.59884022186055,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool C","Australia",0.8906570390534858,1.1227666275031234,null,0,0,"No",0,1.347319953003748,null,"World cup - Pool C","Australia",21.598520557995897,null,21.598520557995897,0.8899931699620298,1.1236041283807419,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool C","Ireland",0.10934296094651419,9.145536130937193,null,0,0,"No",0,10.97464335712463,null,"World cup - Pool C","Ireland",-21.598520557995897,null,-21.598520557995897,0.11000683003797018,9.090344660007364,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]