{"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-23","World cup - Pool C","Australia","United States",42.70562092109756,"Australia",0.9924847652189516,0.00751523478104843,1.0075721411999614,133.06304182561982,{"$nulls":5},""]
["2011-09-24","World cup - Pool B","England","Romania",37.8607197660872,"England",0.9844494581596773,0.015550541840322674,1.0157961810140999,64.30644091172388,{"$nulls":5},""]
["2011-09-24","World cup - Pool A","New Zealand","France",27.452358649034437,"New Zealand",0.9409887908884915,0.05901120911150848,1.0627119150439501,16.945933070281356]
["2011-09-25","World cup - Pool D","Fiji","Samoa",-14.944043701179268,"Samoa",0.19740996546837364,0.8025900345316264,5.065600399794439,1.245966130869763]
["2011-09-25","World cup - Pool C","Ireland","Russia",49.847170742098285,"Ireland",0.997732142445754,0.0022678575542459667,1.0022730124226396,440.9448019024665]
["2011-09-25","World cup - Pool B","Argentina","Scotland",10.059810945168039,"Argentina",0.7166107327466689,0.28338926725333113,1.395457748961057,3.5287151475149785]
["2011-09-26","World cup - Pool D","Wales","Namibia",52.64482044541765,"Wales",0.9986393326645164,0.0013606673354835674,1.0013625212736745,734.9334947065589]
["2011-09-27","World cup - Pool A","Canada","Japan",0.15934221211747968,"Canada",0.5036195111102384,0.4963804888897616,1.9856260091978601,2.014583615558033]
[{"$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},"",""]
[{"$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","Australia",0.9924847652189516,1.0075721411999614,null,0,0,"No",0,1.2090865694399535,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.00751523478104843,133.06304182561982,null,0,0,"No",0,159.67565019074377,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.9844494581596773,1.0157961810140999,null,0,0,"No",0,1.2189554172169197,null,"World cup - Pool B","England",37.8607197660872,null,37.8607197660872,0.984220640209506,1.016032339849259,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool B","Romania",0.015550541840322674,64.30644091172388,null,0,0,"No",0,77.16772909406866,null,"World cup - Pool B","Romania",-37.8607197660872,null,-37.8607197660872,0.015779359790494052,63.37392728711524,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool A","New Zealand",0.9409887908884915,1.0627119150439501,null,0,0,"No",0,1.2752542980527402,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.05901120911150848,16.945933070281356,null,0,0,"No",0,20.335119684337627,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.19740996546837364,5.065600399794439,null,0,0,"No",0,6.078720479753327,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.8025900345316264,1.245966130869763,null,0,0,"No",0,1.4951593570437156,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","World cup - Pool C","Ireland",0.997732142445754,1.0022730124226396,null,0,0,"No",0,1.2027276149071675,null,"World cup - Pool C","Ireland",49.847170742098285,null,49.847170742098285,0.9976770864210531,1.0023283220698993,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool C","Russia",0.0022678575542459667,440.9448019024665,null,0,0,"No",0,529.1337622829598,null,"World cup - Pool C","Russia",-49.847170742098285,null,-49.847170742098285,0.0023229135789468724,430.4938457733606,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool B","Argentina",0.7166107327466689,1.395457748961057,null,0,0,"No",0,1.6745492987532682,null,"World cup - Pool B","Argentina",10.059810945168039,null,10.059810945168039,0.7160867997059863,1.3964787514734023,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool B","Scotland",0.28338926725333113,3.5287151475149785,null,0,0,"No",0,4.234458177017974,null,"World cup - Pool B","Scotland",-10.059810945168039,null,-10.059810945168039,0.2839132002940137,3.5222032612940297,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool D","Wales",0.9986393326645164,1.0013625212736745,null,0,0,"No",0,1.2016350255284094,null,"World cup - Pool D","Wales",52.64482044541765,null,52.64482044541765,0.9986027564568949,1.0013991985642645,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool D","Namibia",0.0013606673354835674,734.9334947065589,null,0,0,"No",0,881.9201936478706,null,"World cup - Pool D","Namibia",-52.64482044541765,null,-52.64482044541765,0.001397243543105109,715.6948442772472,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 1","World cup - Pool A","Canada",0.5036195111102384,1.9856260091978601,null,0,0,"No",0,2.382751211037432,null,"World cup - Pool A","Canada",0.15934221211747968,null,0.15934221211747968,0.5036097375383657,1.9856645443115932,null,-1,"No","",{"$error":"#VALUE!"},null,null,1000]
["Team 2 ","World cup - Pool A","Japan",0.4963804888897616,2.014583615558033,null,0,0,"No",0,2.4175003386696394,null,"World cup - Pool A","Japan",-0.15934221211747968,null,-0.15934221211747968,0.4963902624616343,2.014543949836827,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]