{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["coeff","NblBets","Line","Multiple Lines","Multiple Totals"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"coeff","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Bank h2h",10000]
["Bank line",10000]
["Bank totals",10000]
[null,null,null,"Calc Version 1.57"]
["Kelly h2h",10]
["Kelly line",10]
["Kelly totals",10]
[]
["min Overlay h2h",0.05]
["min Overlay line",0.05]
["min Overlay totals",0.05]

{"sheet":"NblBets","index":1,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Date","Team1","Team2","Prob(Team1)","Odds(Team1)","Odds(Team2)","$Bet(Team1)","$Bet(Team2)","Exp.Total","TotalLine","OddsOver","OddsUnder","ProbOver","$Bet(Over)","$Bet(Under)"]
["2014-11-09","Sydney","Adelaide",0.48099999999999998,1.92,1.99,{"$f":"IF(OR(D7=\"\",E7=\"\"),\"\",IF((D7*E7-1)>=coeff!$B$10,coeff!$B$2*(D7*E7-1)/coeff!$B$6/(E7-1),0))","v":0},{"$f":"IF(OR(D7=\"\",F7=\"\"),\"\",IF(((1-D7)*F7-1)>=coeff!$B$10,coeff!$B$2*((1-D7)*F7-1)/coeff!$B$6/(F7-1),0))","v":0},174.3,172,1.94,1.95,{"$f":"IF(OR(I7=\"\",J7=\"\"),\"\",NORMDIST((I7-J7),0,19.25,TRUE))","v":0.54755266366235433},{"$f":"IF(OR(K7=\"\",M7=\"\"),\"\",IF((K7*M7-1)>=coeff!$B$12,coeff!$B$4*(K7*M7-1)/coeff!$B$8/(K7-1),0))","v":66.225710111667482},{"$f":"IF(OR(L7=\"\",M7=\"\"),\"\",IF((L7*(1-M7)-1)>=coeff!$B$12,coeff!$B$4*(L7*(1-M7)-1)/coeff!$B$8/(L7-1),0))","v":0}]
["2014-11-09","Townsville","New Zealand",0.71499999999999997,1.81,2.11,{"$f":"IF(OR(D8=\"\",E8=\"\"),\"\",IF((D8*E8-1)>=coeff!$B$10,coeff!$B$2*(D8*E8-1)/coeff!$B$6/(E8-1),0))","v":363.14814814814804},{"$f":"IF(OR(D8=\"\",F8=\"\"),\"\",IF(((1-D8)*F8-1)>=coeff!$B$10,coeff!$B$2*((1-D8)*F8-1)/coeff!$B$6/(F8-1),0))","v":0},171.7,167.5,1.95,1.94,{"$f":"IF(OR(I8=\"\",J8=\"\"),\"\",NORMDIST((I8-J8),0,19.25,TRUE))","v":0.58635627458392547},{"$f":"IF(OR(K8=\"\",M8=\"\"),\"\",IF((K8*M8-1)>=coeff!$B$12,coeff!$B$4*(K8*M8-1)/coeff!$B$8/(K8-1),0))","v":150.94182677753122},{"$f":"IF(OR(L8=\"\",M8=\"\"),\"\",IF((L8*(1-M8)-1)>=coeff!$B$12,coeff!$B$4*(L8*(1-M8)-1)/coeff!$B$8/(L8-1),0))","v":0}]
["2014-11-09","Perth","Melbourne",0.81,1.21,5.12,{"$f":"IF(OR(D9=\"\",E9=\"\"),\"\",IF((D9*E9-1)>=coeff!$B$10,coeff!$B$2*(D9*E9-1)/coeff!$B$6/(E9-1),0))","v":0},{"$f":"IF(OR(D9=\"\",F9=\"\"),\"\",IF(((1-D9)*F9-1)>=coeff!$B$10,coeff!$B$2*((1-D9)*F9-1)/coeff!$B$6/(F9-1),0))","v":0},158.19999999999999,159.5,1.94,1.96,0.4730789078304769,{"$f":"IF(OR(K9=\"\",M9=\"\"),\"\",IF((K9*M9-1)>=coeff!$B$12,coeff!$B$4*(K9*M9-1)/coeff!$B$8/(K9-1),0))","v":0},{"$f":"IF(OR(L9=\"\",M9=\"\"),\"\",IF((L9*(1-M9)-1)>=coeff!$B$12,coeff!$B$4*(L9*(1-M9)-1)/coeff!$B$8/(L9-1),0))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(OR(D10=\"\",E10=\"\"),\"\",IF((D10*E10-1)>=coeff!$B$10,coeff!$B$2*(D10*E10-1)/coeff!$B$6/(E10-1),0))","v":""},{"$f":"IF(OR(D10=\"\",F10=\"\"),\"\",IF(((1-D10)*F10-1)>=coeff!$B$10,coeff!$B$2*((1-D10)*F10-1)/coeff!$B$6/(F10-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K10=\"\",M10=\"\"),\"\",IF((K10*M10-1)>=coeff!$B$12,coeff!$B$4*(K10*M10-1)/coeff!$B$8/(K10-1),0))","v":""},{"$f":"IF(OR(L10=\"\",M10=\"\"),\"\",IF((L10*(1-M10)-1)>=coeff!$B$12,coeff!$B$4*(L10*(1-M10)-1)/coeff!$B$8/(L10-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D11=\"\",E11=\"\"),\"\",IF((D11*E11-1)>=coeff!$B$10,coeff!$B$2*(D11*E11-1)/coeff!$B$6/(E11-1),0))","v":""},{"$f":"IF(OR(D11=\"\",F11=\"\"),\"\",IF(((1-D11)*F11-1)>=coeff!$B$10,coeff!$B$2*((1-D11)*F11-1)/coeff!$B$6/(F11-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K11=\"\",M11=\"\"),\"\",IF((K11*M11-1)>=coeff!$B$12,coeff!$B$4*(K11*M11-1)/coeff!$B$8/(K11-1),0))","v":""},{"$f":"IF(OR(L11=\"\",M11=\"\"),\"\",IF((L11*(1-M11)-1)>=coeff!$B$12,coeff!$B$4*(L11*(1-M11)-1)/coeff!$B$8/(L11-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D12=\"\",E12=\"\"),\"\",IF((D12*E12-1)>=coeff!$B$10,coeff!$B$2*(D12*E12-1)/coeff!$B$6/(E12-1),0))","v":""},{"$f":"IF(OR(D12=\"\",F12=\"\"),\"\",IF(((1-D12)*F12-1)>=coeff!$B$10,coeff!$B$2*((1-D12)*F12-1)/coeff!$B$6/(F12-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K12=\"\",M12=\"\"),\"\",IF((K12*M12-1)>=coeff!$B$12,coeff!$B$4*(K12*M12-1)/coeff!$B$8/(K12-1),0))","v":""},{"$f":"IF(OR(L12=\"\",M12=\"\"),\"\",IF((L12*(1-M12)-1)>=coeff!$B$12,coeff!$B$4*(L12*(1-M12)-1)/coeff!$B$8/(L12-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D13=\"\",E13=\"\"),\"\",IF((D13*E13-1)>=coeff!$B$10,coeff!$B$2*(D13*E13-1)/coeff!$B$6/(E13-1),0))","v":""},{"$f":"IF(OR(D13=\"\",F13=\"\"),\"\",IF(((1-D13)*F13-1)>=coeff!$B$10,coeff!$B$2*((1-D13)*F13-1)/coeff!$B$6/(F13-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K13=\"\",M13=\"\"),\"\",IF((K13*M13-1)>=coeff!$B$12,coeff!$B$4*(K13*M13-1)/coeff!$B$8/(K13-1),0))","v":""},{"$f":"IF(OR(L13=\"\",M13=\"\"),\"\",IF((L13*(1-M13)-1)>=coeff!$B$12,coeff!$B$4*(L13*(1-M13)-1)/coeff!$B$8/(L13-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D14=\"\",E14=\"\"),\"\",IF((D14*E14-1)>=coeff!$B$10,coeff!$B$2*(D14*E14-1)/coeff!$B$6/(E14-1),0))","v":""},{"$f":"IF(OR(D14=\"\",F14=\"\"),\"\",IF(((1-D14)*F14-1)>=coeff!$B$10,coeff!$B$2*((1-D14)*F14-1)/coeff!$B$6/(F14-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K14=\"\",M14=\"\"),\"\",IF((K14*M14-1)>=coeff!$B$12,coeff!$B$4*(K14*M14-1)/coeff!$B$8/(K14-1),0))","v":""},{"$f":"IF(OR(L14=\"\",M14=\"\"),\"\",IF((L14*(1-M14)-1)>=coeff!$B$12,coeff!$B$4*(L14*(1-M14)-1)/coeff!$B$8/(L14-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D15=\"\",E15=\"\"),\"\",IF((D15*E15-1)>=coeff!$B$10,coeff!$B$2*(D15*E15-1)/coeff!$B$6/(E15-1),0))","v":""},{"$f":"IF(OR(D15=\"\",F15=\"\"),\"\",IF(((1-D15)*F15-1)>=coeff!$B$10,coeff!$B$2*((1-D15)*F15-1)/coeff!$B$6/(F15-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K15=\"\",M15=\"\"),\"\",IF((K15*M15-1)>=coeff!$B$12,coeff!$B$4*(K15*M15-1)/coeff!$B$8/(K15-1),0))","v":""},{"$f":"IF(OR(L15=\"\",M15=\"\"),\"\",IF((L15*(1-M15)-1)>=coeff!$B$12,coeff!$B$4*(L15*(1-M15)-1)/coeff!$B$8/(L15-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D16=\"\",E16=\"\"),\"\",IF((D16*E16-1)>=coeff!$B$10,coeff!$B$2*(D16*E16-1)/coeff!$B$6/(E16-1),0))","v":""},{"$f":"IF(OR(D16=\"\",F16=\"\"),\"\",IF(((1-D16)*F16-1)>=coeff!$B$10,coeff!$B$2*((1-D16)*F16-1)/coeff!$B$6/(F16-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K16=\"\",M16=\"\"),\"\",IF((K16*M16-1)>=coeff!$B$12,coeff!$B$4*(K16*M16-1)/coeff!$B$8/(K16-1),0))","v":""},{"$f":"IF(OR(L16=\"\",M16=\"\"),\"\",IF((L16*(1-M16)-1)>=coeff!$B$12,coeff!$B$4*(L16*(1-M16)-1)/coeff!$B$8/(L16-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D17=\"\",E17=\"\"),\"\",IF((D17*E17-1)>=coeff!$B$10,coeff!$B$2*(D17*E17-1)/coeff!$B$6/(E17-1),0))","v":""},{"$f":"IF(OR(D17=\"\",F17=\"\"),\"\",IF(((1-D17)*F17-1)>=coeff!$B$10,coeff!$B$2*((1-D17)*F17-1)/coeff!$B$6/(F17-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K17=\"\",M17=\"\"),\"\",IF((K17*M17-1)>=coeff!$B$12,coeff!$B$4*(K17*M17-1)/coeff!$B$8/(K17-1),0))","v":""},{"$f":"IF(OR(L17=\"\",M17=\"\"),\"\",IF((L17*(1-M17)-1)>=coeff!$B$12,coeff!$B$4*(L17*(1-M17)-1)/coeff!$B$8/(L17-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D18=\"\",E18=\"\"),\"\",IF((D18*E18-1)>=coeff!$B$10,coeff!$B$2*(D18*E18-1)/coeff!$B$6/(E18-1),0))","v":""},{"$f":"IF(OR(D18=\"\",F18=\"\"),\"\",IF(((1-D18)*F18-1)>=coeff!$B$10,coeff!$B$2*((1-D18)*F18-1)/coeff!$B$6/(F18-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K18=\"\",M18=\"\"),\"\",IF((K18*M18-1)>=coeff!$B$12,coeff!$B$4*(K18*M18-1)/coeff!$B$8/(K18-1),0))","v":""},{"$f":"IF(OR(L18=\"\",M18=\"\"),\"\",IF((L18*(1-M18)-1)>=coeff!$B$12,coeff!$B$4*(L18*(1-M18)-1)/coeff!$B$8/(L18-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D19=\"\",E19=\"\"),\"\",IF((D19*E19-1)>=coeff!$B$10,coeff!$B$2*(D19*E19-1)/coeff!$B$6/(E19-1),0))","v":""},{"$f":"IF(OR(D19=\"\",F19=\"\"),\"\",IF(((1-D19)*F19-1)>=coeff!$B$10,coeff!$B$2*((1-D19)*F19-1)/coeff!$B$6/(F19-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K19=\"\",M19=\"\"),\"\",IF((K19*M19-1)>=coeff!$B$12,coeff!$B$4*(K19*M19-1)/coeff!$B$8/(K19-1),0))","v":""},{"$f":"IF(OR(L19=\"\",M19=\"\"),\"\",IF((L19*(1-M19)-1)>=coeff!$B$12,coeff!$B$4*(L19*(1-M19)-1)/coeff!$B$8/(L19-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D20=\"\",E20=\"\"),\"\",IF((D20*E20-1)>=coeff!$B$10,coeff!$B$2*(D20*E20-1)/coeff!$B$6/(E20-1),0))","v":""},{"$f":"IF(OR(D20=\"\",F20=\"\"),\"\",IF(((1-D20)*F20-1)>=coeff!$B$10,coeff!$B$2*((1-D20)*F20-1)/coeff!$B$6/(F20-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K20=\"\",M20=\"\"),\"\",IF((K20*M20-1)>=coeff!$B$12,coeff!$B$4*(K20*M20-1)/coeff!$B$8/(K20-1),0))","v":""},{"$f":"IF(OR(L20=\"\",M20=\"\"),\"\",IF((L20*(1-M20)-1)>=coeff!$B$12,coeff!$B$4*(L20*(1-M20)-1)/coeff!$B$8/(L20-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D21=\"\",E21=\"\"),\"\",IF((D21*E21-1)>=coeff!$B$10,coeff!$B$2*(D21*E21-1)/coeff!$B$6/(E21-1),0))","v":""},{"$f":"IF(OR(D21=\"\",F21=\"\"),\"\",IF(((1-D21)*F21-1)>=coeff!$B$10,coeff!$B$2*((1-D21)*F21-1)/coeff!$B$6/(F21-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K21=\"\",M21=\"\"),\"\",IF((K21*M21-1)>=coeff!$B$12,coeff!$B$4*(K21*M21-1)/coeff!$B$8/(K21-1),0))","v":""},{"$f":"IF(OR(L21=\"\",M21=\"\"),\"\",IF((L21*(1-M21)-1)>=coeff!$B$12,coeff!$B$4*(L21*(1-M21)-1)/coeff!$B$8/(L21-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D22=\"\",E22=\"\"),\"\",IF((D22*E22-1)>=coeff!$B$10,coeff!$B$2*(D22*E22-1)/coeff!$B$6/(E22-1),0))","v":""},{"$f":"IF(OR(D22=\"\",F22=\"\"),\"\",IF(((1-D22)*F22-1)>=coeff!$B$10,coeff!$B$2*((1-D22)*F22-1)/coeff!$B$6/(F22-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K22=\"\",M22=\"\"),\"\",IF((K22*M22-1)>=coeff!$B$12,coeff!$B$4*(K22*M22-1)/coeff!$B$8/(K22-1),0))","v":""},{"$f":"IF(OR(L22=\"\",M22=\"\"),\"\",IF((L22*(1-M22)-1)>=coeff!$B$12,coeff!$B$4*(L22*(1-M22)-1)/coeff!$B$8/(L22-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D23=\"\",E23=\"\"),\"\",IF((D23*E23-1)>=coeff!$B$10,coeff!$B$2*(D23*E23-1)/coeff!$B$6/(E23-1),0))","v":""},{"$f":"IF(OR(D23=\"\",F23=\"\"),\"\",IF(((1-D23)*F23-1)>=coeff!$B$10,coeff!$B$2*((1-D23)*F23-1)/coeff!$B$6/(F23-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K23=\"\",M23=\"\"),\"\",IF((K23*M23-1)>=coeff!$B$12,coeff!$B$4*(K23*M23-1)/coeff!$B$8/(K23-1),0))","v":""},{"$f":"IF(OR(L23=\"\",M23=\"\"),\"\",IF((L23*(1-M23)-1)>=coeff!$B$12,coeff!$B$4*(L23*(1-M23)-1)/coeff!$B$8/(L23-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D24=\"\",E24=\"\"),\"\",IF((D24*E24-1)>=coeff!$B$10,coeff!$B$2*(D24*E24-1)/coeff!$B$6/(E24-1),0))","v":""},{"$f":"IF(OR(D24=\"\",F24=\"\"),\"\",IF(((1-D24)*F24-1)>=coeff!$B$10,coeff!$B$2*((1-D24)*F24-1)/coeff!$B$6/(F24-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K24=\"\",M24=\"\"),\"\",IF((K24*M24-1)>=coeff!$B$12,coeff!$B$4*(K24*M24-1)/coeff!$B$8/(K24-1),0))","v":""},{"$f":"IF(OR(L24=\"\",M24=\"\"),\"\",IF((L24*(1-M24)-1)>=coeff!$B$12,coeff!$B$4*(L24*(1-M24)-1)/coeff!$B$8/(L24-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D25=\"\",E25=\"\"),\"\",IF((D25*E25-1)>=coeff!$B$10,coeff!$B$2*(D25*E25-1)/coeff!$B$6/(E25-1),0))","v":""},{"$f":"IF(OR(D25=\"\",F25=\"\"),\"\",IF(((1-D25)*F25-1)>=coeff!$B$10,coeff!$B$2*((1-D25)*F25-1)/coeff!$B$6/(F25-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K25=\"\",M25=\"\"),\"\",IF((K25*M25-1)>=coeff!$B$12,coeff!$B$4*(K25*M25-1)/coeff!$B$8/(K25-1),0))","v":""},{"$f":"IF(OR(L25=\"\",M25=\"\"),\"\",IF((L25*(1-M25)-1)>=coeff!$B$12,coeff!$B$4*(L25*(1-M25)-1)/coeff!$B$8/(L25-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D26=\"\",E26=\"\"),\"\",IF((D26*E26-1)>=coeff!$B$10,coeff!$B$2*(D26*E26-1)/coeff!$B$6/(E26-1),0))","v":""},{"$f":"IF(OR(D26=\"\",F26=\"\"),\"\",IF(((1-D26)*F26-1)>=coeff!$B$10,coeff!$B$2*((1-D26)*F26-1)/coeff!$B$6/(F26-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K26=\"\",M26=\"\"),\"\",IF((K26*M26-1)>=coeff!$B$12,coeff!$B$4*(K26*M26-1)/coeff!$B$8/(K26-1),0))","v":""},{"$f":"IF(OR(L26=\"\",M26=\"\"),\"\",IF((L26*(1-M26)-1)>=coeff!$B$12,coeff!$B$4*(L26*(1-M26)-1)/coeff!$B$8/(L26-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D27=\"\",E27=\"\"),\"\",IF((D27*E27-1)>=coeff!$B$10,coeff!$B$2*(D27*E27-1)/coeff!$B$6/(E27-1),0))","v":""},{"$f":"IF(OR(D27=\"\",F27=\"\"),\"\",IF(((1-D27)*F27-1)>=coeff!$B$10,coeff!$B$2*((1-D27)*F27-1)/coeff!$B$6/(F27-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K27=\"\",M27=\"\"),\"\",IF((K27*M27-1)>=coeff!$B$12,coeff!$B$4*(K27*M27-1)/coeff!$B$8/(K27-1),0))","v":""},{"$f":"IF(OR(L27=\"\",M27=\"\"),\"\",IF((L27*(1-M27)-1)>=coeff!$B$12,coeff!$B$4*(L27*(1-M27)-1)/coeff!$B$8/(L27-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D28=\"\",E28=\"\"),\"\",IF((D28*E28-1)>=coeff!$B$10,coeff!$B$2*(D28*E28-1)/coeff!$B$6/(E28-1),0))","v":""},{"$f":"IF(OR(D28=\"\",F28=\"\"),\"\",IF(((1-D28)*F28-1)>=coeff!$B$10,coeff!$B$2*((1-D28)*F28-1)/coeff!$B$6/(F28-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K28=\"\",M28=\"\"),\"\",IF((K28*M28-1)>=coeff!$B$12,coeff!$B$4*(K28*M28-1)/coeff!$B$8/(K28-1),0))","v":""},{"$f":"IF(OR(L28=\"\",M28=\"\"),\"\",IF((L28*(1-M28)-1)>=coeff!$B$12,coeff!$B$4*(L28*(1-M28)-1)/coeff!$B$8/(L28-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D29=\"\",E29=\"\"),\"\",IF((D29*E29-1)>=coeff!$B$10,coeff!$B$2*(D29*E29-1)/coeff!$B$6/(E29-1),0))","v":""},{"$f":"IF(OR(D29=\"\",F29=\"\"),\"\",IF(((1-D29)*F29-1)>=coeff!$B$10,coeff!$B$2*((1-D29)*F29-1)/coeff!$B$6/(F29-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K29=\"\",M29=\"\"),\"\",IF((K29*M29-1)>=coeff!$B$12,coeff!$B$4*(K29*M29-1)/coeff!$B$8/(K29-1),0))","v":""},{"$f":"IF(OR(L29=\"\",M29=\"\"),\"\",IF((L29*(1-M29)-1)>=coeff!$B$12,coeff!$B$4*(L29*(1-M29)-1)/coeff!$B$8/(L29-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D30=\"\",E30=\"\"),\"\",IF((D30*E30-1)>=coeff!$B$10,coeff!$B$2*(D30*E30-1)/coeff!$B$6/(E30-1),0))","v":""},{"$f":"IF(OR(D30=\"\",F30=\"\"),\"\",IF(((1-D30)*F30-1)>=coeff!$B$10,coeff!$B$2*((1-D30)*F30-1)/coeff!$B$6/(F30-1),0))","v":""},null,null,null,null,"",{"$f":"IF(OR(K30=\"\",M30=\"\"),\"\",IF((K30*M30-1)>=coeff!$B$12,coeff!$B$4*(K30*M30-1)/coeff!$B$8/(K30-1),0))","v":""},{"$f":"IF(OR(L30=\"\",M30=\"\"),\"\",IF((L30*(1-M30)-1)>=coeff!$B$12,coeff!$B$4*(L30*(1-M30)-1)/coeff!$B$8/(L30-1),0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(D31=\"\",E31=\"\"),\"\",IF((D31*E31-1)>=coeff!$B$10,coeff!$B$2*(D31*E31-1)/coeff!$B$6/(E31-1),0))","v":""},{"$f":"IF(OR(D31=\"\",F31=\"\"),\"\",IF(((1-D31)*F31-1)>=coeff!$B$10,coeff!$B$2*((1-D31)*F31-1)/coeff!$B$6/(F31-1),0))","v":""}]

{"sheet":"Line","index":2,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[{"$f":"IF(NblBets!A6=\"\",\"\",NblBets!A6)","v":"Date"},{"$f":"IF(NblBets!B6=\"\",\"\",NblBets!B6)","v":"Team1"},{"$f":"IF(NblBets!C6=\"\",\"\",NblBets!C6)","v":"Team2"},{"$f":"IF(NblBets!D6=\"\",\"\",NblBets!D6)","v":"Prob(Team1)"},"Line","ProbLine(Team1)","OddsLine(Team1)","OddsLine(Team2)",{"$f":"IF(NblBets!G6=\"\",\"\",NblBets!G6)","v":"$Bet(Team1)"},{"$f":"IF(NblBets!H6=\"\",\"\",NblBets!H6)","v":"$Bet(Team2)"},"Overlay"]
[{"$f":"IF(NblBets!A7=\"\",\"\",NblBets!A7)","v":"2014-11-09"},{"$f":"IF(NblBets!B7=\"\",\"\",NblBets!B7)","v":"Sydney"},{"$f":"IF(NblBets!C7=\"\",\"\",NblBets!C7)","v":"Adelaide"},{"$f":"IF(NblBets!D7=\"\",\"\",NblBets!D7)","v":0.48099999999999998},null,{"$f":"IF(AND(E7<>\"\",D7<>\"\"),NORMDIST(((LN((D7/(1-D7)))/0.1453)+E7),0,13.486,TRUE),\"\")","v":""},1.96,1.93,{"$f":"IF(OR(F7=\"\",G7=\"\"),\"\",IF((F7*G7-1)>=coeff!$B$11,coeff!$B$3*(F7*G7-1)/coeff!$B$6/(G7-1),0))","v":""},{"$f":"IF(OR(F7=\"\",H7=\"\"),\"\",IF(((1-F7)*H7-1)>=coeff!$B$11,coeff!$B$3*((1-F7)*H7-1)/coeff!$B$7/(H7-1),0))","v":""},{"$f":"IF(F7=\"\",\"\",IF(I7>0,G7*F7-1,IF(J7>0,H7*(1-F7)-1,\"\")))","v":""}]
[{"$f":"IF(NblBets!A8=\"\",\"\",NblBets!A8)","v":"2014-11-09"},{"$f":"IF(NblBets!B8=\"\",\"\",NblBets!B8)","v":"Townsville"},{"$f":"IF(NblBets!C8=\"\",\"\",NblBets!C8)","v":"New Zealand"},{"$f":"IF(NblBets!D8=\"\",\"\",NblBets!D8)","v":0.71499999999999997},-1.5,{"$f":"IF(AND(E8<>\"\",D8<>\"\"),NORMDIST(((LN((D8/(1-D8)))/0.1453)+E8),0,13.486,TRUE),\"\")","v":0.63989263691779463},1.93,1.98,{"$f":"IF(OR(F8=\"\",G8=\"\"),\"\",IF((F8*G8-1)>=coeff!$B$11,coeff!$B$3*(F8*G8-1)/coeff!$B$6/(G8-1),0))","v":252.68041854983196},{"$f":"IF(OR(F8=\"\",H8=\"\"),\"\",IF(((1-F8)*H8-1)>=coeff!$B$11,coeff!$B$3*((1-F8)*H8-1)/coeff!$B$7/(H8-1),0))","v":0},{"$f":"IF(F8=\"\",\"\",IF(I8>0,G8*F8-1,IF(J8>0,H8*(1-F8)-1,\"\")))","v":0.2349927892513437}]
[{"$f":"IF(NblBets!A9=\"\",\"\",NblBets!A9)","v":"2014-11-09"},{"$f":"IF(NblBets!B9=\"\",\"\",NblBets!B9)","v":"Perth"},{"$f":"IF(NblBets!C9=\"\",\"\",NblBets!C9)","v":"Melbourne"},{"$f":"IF(NblBets!D9=\"\",\"\",NblBets!D9)","v":0.81},-9.5,{"$f":"IF(AND(E9<>\"\",D9<>\"\"),NORMDIST(((LN((D9/(1-D9)))/0.1453)+E9),0,13.486,TRUE),\"\")","v":0.51417928698906046},1.96,1.94,{"$f":"IF(OR(F9=\"\",G9=\"\"),\"\",IF((F9*G9-1)>=coeff!$B$11,coeff!$B$3*(F9*G9-1)/coeff!$B$6/(G9-1),0))","v":0},{"$f":"IF(OR(F9=\"\",H9=\"\"),\"\",IF(((1-F9)*H9-1)>=coeff!$B$11,coeff!$B$3*((1-F9)*H9-1)/coeff!$B$7/(H9-1),0))","v":0},{"$f":"IF(F9=\"\",\"\",IF(I9>0,G9*F9-1,IF(J9>0,H9*(1-F9)-1,\"\")))","v":""}]
[{"$f":"IF(NblBets!A10=\"\",\"\",NblBets!A10)","v":""},{"$f":"IF(NblBets!B10=\"\",\"\",NblBets!B10)","v":""},{"$f":"IF(NblBets!C10=\"\",\"\",NblBets!C10)","v":""},{"$f":"IF(NblBets!D10=\"\",\"\",NblBets!D10)","v":""},{"$f":"IF(NblBets!E10=\"\",\"\",NblBets!E10)","v":""},{"$f":"IF(AND(E10<>\"\",D10<>\"\"),NORMDIST(((LN((D10/(1-D10)))/0.1453)+E10),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F10=\"\",G10=\"\"),\"\",IF((F10*G10-1)>=coeff!$B$11,coeff!$B$3*(F10*G10-1)/coeff!$B$6/(G10-1),0))","v":""},{"$f":"IF(OR(F10=\"\",H10=\"\"),\"\",IF(((1-F10)*H10-1)>=coeff!$B$11,coeff!$B$3*((1-F10)*H10-1)/coeff!$B$7/(H10-1),0))","v":""},""]
[{"$f":"IF(NblBets!A11=\"\",\"\",NblBets!A11)","v":""},{"$f":"IF(NblBets!B11=\"\",\"\",NblBets!B11)","v":""},{"$f":"IF(NblBets!C11=\"\",\"\",NblBets!C11)","v":""},{"$f":"IF(NblBets!D11=\"\",\"\",NblBets!D11)","v":""},{"$f":"IF(NblBets!E11=\"\",\"\",NblBets!E11)","v":""},{"$f":"IF(AND(E11<>\"\",D11<>\"\"),NORMDIST(((LN((D11/(1-D11)))/0.1453)+E11),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F11=\"\",G11=\"\"),\"\",IF((F11*G11-1)>=coeff!$B$11,coeff!$B$3*(F11*G11-1)/coeff!$B$6/(G11-1),0))","v":""},{"$f":"IF(OR(F11=\"\",H11=\"\"),\"\",IF(((1-F11)*H11-1)>=coeff!$B$11,coeff!$B$3*((1-F11)*H11-1)/coeff!$B$7/(H11-1),0))","v":""},""]
[{"$f":"IF(NblBets!A12=\"\",\"\",NblBets!A12)","v":""},{"$f":"IF(NblBets!B12=\"\",\"\",NblBets!B12)","v":""},{"$f":"IF(NblBets!C12=\"\",\"\",NblBets!C12)","v":""},{"$f":"IF(NblBets!D12=\"\",\"\",NblBets!D12)","v":""},{"$f":"IF(NblBets!E12=\"\",\"\",NblBets!E12)","v":""},{"$f":"IF(AND(E12<>\"\",D12<>\"\"),NORMDIST(((LN((D12/(1-D12)))/0.1453)+E12),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F12=\"\",G12=\"\"),\"\",IF((F12*G12-1)>=coeff!$B$11,coeff!$B$3*(F12*G12-1)/coeff!$B$6/(G12-1),0))","v":""},{"$f":"IF(OR(F12=\"\",H12=\"\"),\"\",IF(((1-F12)*H12-1)>=coeff!$B$11,coeff!$B$3*((1-F12)*H12-1)/coeff!$B$7/(H12-1),0))","v":""},""]
[{"$f":"IF(NblBets!A13=\"\",\"\",NblBets!A13)","v":""},{"$f":"IF(NblBets!B13=\"\",\"\",NblBets!B13)","v":""},{"$f":"IF(NblBets!C13=\"\",\"\",NblBets!C13)","v":""},{"$f":"IF(NblBets!D13=\"\",\"\",NblBets!D13)","v":""},{"$f":"IF(NblBets!E13=\"\",\"\",NblBets!E13)","v":""},{"$f":"IF(AND(E13<>\"\",D13<>\"\"),NORMDIST(((LN((D13/(1-D13)))/0.1453)+E13),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F13=\"\",G13=\"\"),\"\",IF((F13*G13-1)>=coeff!$B$11,coeff!$B$3*(F13*G13-1)/coeff!$B$6/(G13-1),0))","v":""},{"$f":"IF(OR(F13=\"\",H13=\"\"),\"\",IF(((1-F13)*H13-1)>=coeff!$B$11,coeff!$B$3*((1-F13)*H13-1)/coeff!$B$7/(H13-1),0))","v":""},""]
[{"$f":"IF(NblBets!A14=\"\",\"\",NblBets!A14)","v":""},{"$f":"IF(NblBets!B14=\"\",\"\",NblBets!B14)","v":""},{"$f":"IF(NblBets!C14=\"\",\"\",NblBets!C14)","v":""},{"$f":"IF(NblBets!D14=\"\",\"\",NblBets!D14)","v":""},{"$f":"IF(NblBets!E14=\"\",\"\",NblBets!E14)","v":""},{"$f":"IF(AND(E14<>\"\",D14<>\"\"),NORMDIST(((LN((D14/(1-D14)))/0.1453)+E14),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F14=\"\",G14=\"\"),\"\",IF((F14*G14-1)>=coeff!$B$11,coeff!$B$3*(F14*G14-1)/coeff!$B$6/(G14-1),0))","v":""},{"$f":"IF(OR(F14=\"\",H14=\"\"),\"\",IF(((1-F14)*H14-1)>=coeff!$B$11,coeff!$B$3*((1-F14)*H14-1)/coeff!$B$7/(H14-1),0))","v":""},""]
[{"$f":"IF(NblBets!A15=\"\",\"\",NblBets!A15)","v":""},{"$f":"IF(NblBets!B15=\"\",\"\",NblBets!B15)","v":""},{"$f":"IF(NblBets!C15=\"\",\"\",NblBets!C15)","v":""},{"$f":"IF(NblBets!D15=\"\",\"\",NblBets!D15)","v":""},{"$f":"IF(NblBets!E15=\"\",\"\",NblBets!E15)","v":""},{"$f":"IF(AND(E15<>\"\",D15<>\"\"),NORMDIST(((LN((D15/(1-D15)))/0.1453)+E15),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F15=\"\",G15=\"\"),\"\",IF((F15*G15-1)>=coeff!$B$11,coeff!$B$3*(F15*G15-1)/coeff!$B$6/(G15-1),0))","v":""},{"$f":"IF(OR(F15=\"\",H15=\"\"),\"\",IF(((1-F15)*H15-1)>=coeff!$B$11,coeff!$B$3*((1-F15)*H15-1)/coeff!$B$7/(H15-1),0))","v":""},""]
[{"$f":"IF(NblBets!A16=\"\",\"\",NblBets!A16)","v":""},{"$f":"IF(NblBets!B16=\"\",\"\",NblBets!B16)","v":""},{"$f":"IF(NblBets!C16=\"\",\"\",NblBets!C16)","v":""},{"$f":"IF(NblBets!D16=\"\",\"\",NblBets!D16)","v":""},{"$f":"IF(NblBets!E16=\"\",\"\",NblBets!E16)","v":""},{"$f":"IF(AND(E16<>\"\",D16<>\"\"),NORMDIST(((LN((D16/(1-D16)))/0.1453)+E16),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F16=\"\",G16=\"\"),\"\",IF((F16*G16-1)>=coeff!$B$11,coeff!$B$3*(F16*G16-1)/coeff!$B$6/(G16-1),0))","v":""},{"$f":"IF(OR(F16=\"\",H16=\"\"),\"\",IF(((1-F16)*H16-1)>=coeff!$B$11,coeff!$B$3*((1-F16)*H16-1)/coeff!$B$7/(H16-1),0))","v":""},""]
[{"$f":"IF(NblBets!A17=\"\",\"\",NblBets!A17)","v":""},{"$f":"IF(NblBets!B17=\"\",\"\",NblBets!B17)","v":""},{"$f":"IF(NblBets!C17=\"\",\"\",NblBets!C17)","v":""},{"$f":"IF(NblBets!D17=\"\",\"\",NblBets!D17)","v":""},{"$f":"IF(NblBets!E17=\"\",\"\",NblBets!E17)","v":""},{"$f":"IF(AND(E17<>\"\",D17<>\"\"),NORMDIST(((LN((D17/(1-D17)))/0.1453)+E17),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F17=\"\",G17=\"\"),\"\",IF((F17*G17-1)>=coeff!$B$11,coeff!$B$3*(F17*G17-1)/coeff!$B$6/(G17-1),0))","v":""},{"$f":"IF(OR(F17=\"\",H17=\"\"),\"\",IF(((1-F17)*H17-1)>=coeff!$B$11,coeff!$B$3*((1-F17)*H17-1)/coeff!$B$7/(H17-1),0))","v":""},""]
[{"$f":"IF(NblBets!A18=\"\",\"\",NblBets!A18)","v":""},{"$f":"IF(NblBets!B18=\"\",\"\",NblBets!B18)","v":""},{"$f":"IF(NblBets!C18=\"\",\"\",NblBets!C18)","v":""},{"$f":"IF(NblBets!D18=\"\",\"\",NblBets!D18)","v":""},{"$f":"IF(NblBets!E18=\"\",\"\",NblBets!E18)","v":""},{"$f":"IF(AND(E18<>\"\",D18<>\"\"),NORMDIST(((LN((D18/(1-D18)))/0.1453)+E18),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F18=\"\",G18=\"\"),\"\",IF((F18*G18-1)>=coeff!$B$11,coeff!$B$3*(F18*G18-1)/coeff!$B$6/(G18-1),0))","v":""},{"$f":"IF(OR(F18=\"\",H18=\"\"),\"\",IF(((1-F18)*H18-1)>=coeff!$B$11,coeff!$B$3*((1-F18)*H18-1)/coeff!$B$7/(H18-1),0))","v":""}]
[{"$f":"IF(NblBets!A19=\"\",\"\",NblBets!A19)","v":""},{"$f":"IF(NblBets!B19=\"\",\"\",NblBets!B19)","v":""},{"$f":"IF(NblBets!C19=\"\",\"\",NblBets!C19)","v":""},{"$f":"IF(NblBets!D19=\"\",\"\",NblBets!D19)","v":""},{"$f":"IF(NblBets!E19=\"\",\"\",NblBets!E19)","v":""},{"$f":"IF(AND(E19<>\"\",D19<>\"\"),NORMDIST(((LN((D19/(1-D19)))/0.1453)+E19),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F19=\"\",G19=\"\"),\"\",IF((F19*G19-1)>=coeff!$B$11,coeff!$B$3*(F19*G19-1)/coeff!$B$6/(G19-1),0))","v":""},{"$f":"IF(OR(F19=\"\",H19=\"\"),\"\",IF(((1-F19)*H19-1)>=coeff!$B$11,coeff!$B$3*((1-F19)*H19-1)/coeff!$B$7/(H19-1),0))","v":""}]
[{"$f":"IF(NblBets!A20=\"\",\"\",NblBets!A20)","v":""},{"$f":"IF(NblBets!B20=\"\",\"\",NblBets!B20)","v":""},{"$f":"IF(NblBets!C20=\"\",\"\",NblBets!C20)","v":""},{"$f":"IF(NblBets!D20=\"\",\"\",NblBets!D20)","v":""},{"$f":"IF(NblBets!E20=\"\",\"\",NblBets!E20)","v":""},{"$f":"IF(AND(E20<>\"\",D20<>\"\"),NORMDIST(((LN((D20/(1-D20)))/0.1453)+E20),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F20=\"\",G20=\"\"),\"\",IF((F20*G20-1)>=coeff!$B$11,coeff!$B$3*(F20*G20-1)/coeff!$B$6/(G20-1),0))","v":""},{"$f":"IF(OR(F20=\"\",H20=\"\"),\"\",IF(((1-F20)*H20-1)>=coeff!$B$11,coeff!$B$3*((1-F20)*H20-1)/coeff!$B$7/(H20-1),0))","v":""}]
[{"$f":"IF(NblBets!A21=\"\",\"\",NblBets!A21)","v":""},{"$f":"IF(NblBets!B21=\"\",\"\",NblBets!B21)","v":""},{"$f":"IF(NblBets!C21=\"\",\"\",NblBets!C21)","v":""},{"$f":"IF(NblBets!D21=\"\",\"\",NblBets!D21)","v":""},{"$f":"IF(NblBets!E21=\"\",\"\",NblBets!E21)","v":""},{"$f":"IF(AND(E21<>\"\",D21<>\"\"),NORMDIST(((LN((D21/(1-D21)))/0.1453)+E21),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F21=\"\",G21=\"\"),\"\",IF((F21*G21-1)>=coeff!$B$11,coeff!$B$3*(F21*G21-1)/coeff!$B$6/(G21-1),0))","v":""},{"$f":"IF(OR(F21=\"\",H21=\"\"),\"\",IF(((1-F21)*H21-1)>=coeff!$B$11,coeff!$B$3*((1-F21)*H21-1)/coeff!$B$7/(H21-1),0))","v":""}]
[{"$f":"IF(NblBets!A22=\"\",\"\",NblBets!A22)","v":""},{"$f":"IF(NblBets!B22=\"\",\"\",NblBets!B22)","v":""},{"$f":"IF(NblBets!C22=\"\",\"\",NblBets!C22)","v":""},{"$f":"IF(NblBets!D22=\"\",\"\",NblBets!D22)","v":""},{"$f":"IF(NblBets!E22=\"\",\"\",NblBets!E22)","v":""},{"$f":"IF(AND(E22<>\"\",D22<>\"\"),NORMDIST(((LN((D22/(1-D22)))/0.1453)+E22),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F22=\"\",G22=\"\"),\"\",IF((F22*G22-1)>=coeff!$B$11,coeff!$B$3*(F22*G22-1)/coeff!$B$6/(G22-1),0))","v":""},{"$f":"IF(OR(F22=\"\",H22=\"\"),\"\",IF(((1-F22)*H22-1)>=coeff!$B$11,coeff!$B$3*((1-F22)*H22-1)/coeff!$B$7/(H22-1),0))","v":""}]
[{"$f":"IF(NblBets!A23=\"\",\"\",NblBets!A23)","v":""},{"$f":"IF(NblBets!B23=\"\",\"\",NblBets!B23)","v":""},{"$f":"IF(NblBets!C23=\"\",\"\",NblBets!C23)","v":""},{"$f":"IF(NblBets!D23=\"\",\"\",NblBets!D23)","v":""},{"$f":"IF(NblBets!E23=\"\",\"\",NblBets!E23)","v":""},{"$f":"IF(AND(E23<>\"\",D23<>\"\"),NORMDIST(((LN((D23/(1-D23)))/0.1453)+E23),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F23=\"\",G23=\"\"),\"\",IF((F23*G23-1)>=coeff!$B$11,coeff!$B$3*(F23*G23-1)/coeff!$B$6/(G23-1),0))","v":""},{"$f":"IF(OR(F23=\"\",H23=\"\"),\"\",IF(((1-F23)*H23-1)>=coeff!$B$11,coeff!$B$3*((1-F23)*H23-1)/coeff!$B$7/(H23-1),0))","v":""}]
[{"$f":"IF(NblBets!A24=\"\",\"\",NblBets!A24)","v":""},{"$f":"IF(NblBets!B24=\"\",\"\",NblBets!B24)","v":""},{"$f":"IF(NblBets!C24=\"\",\"\",NblBets!C24)","v":""},{"$f":"IF(NblBets!D24=\"\",\"\",NblBets!D24)","v":""},{"$f":"IF(NblBets!E24=\"\",\"\",NblBets!E24)","v":""},{"$f":"IF(AND(E24<>\"\",D24<>\"\"),NORMDIST(((LN((D24/(1-D24)))/0.1453)+E24),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F24=\"\",G24=\"\"),\"\",IF((F24*G24-1)>=coeff!$B$11,coeff!$B$3*(F24*G24-1)/coeff!$B$6/(G24-1),0))","v":""},{"$f":"IF(OR(F24=\"\",H24=\"\"),\"\",IF(((1-F24)*H24-1)>=coeff!$B$11,coeff!$B$3*((1-F24)*H24-1)/coeff!$B$7/(H24-1),0))","v":""}]
[{"$f":"IF(NblBets!A25=\"\",\"\",NblBets!A25)","v":""},{"$f":"IF(NblBets!B25=\"\",\"\",NblBets!B25)","v":""},{"$f":"IF(NblBets!C25=\"\",\"\",NblBets!C25)","v":""},{"$f":"IF(NblBets!D25=\"\",\"\",NblBets!D25)","v":""},{"$f":"IF(NblBets!E25=\"\",\"\",NblBets!E25)","v":""},{"$f":"IF(AND(E25<>\"\",D25<>\"\"),NORMDIST(((LN((D25/(1-D25)))/0.1453)+E25),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F25=\"\",G25=\"\"),\"\",IF((F25*G25-1)>=coeff!$B$11,coeff!$B$3*(F25*G25-1)/coeff!$B$6/(G25-1),0))","v":""},{"$f":"IF(OR(F25=\"\",H25=\"\"),\"\",IF(((1-F25)*H25-1)>=coeff!$B$11,coeff!$B$3*((1-F25)*H25-1)/coeff!$B$7/(H25-1),0))","v":""}]
[{"$f":"IF(NblBets!A26=\"\",\"\",NblBets!A26)","v":""},{"$f":"IF(NblBets!B26=\"\",\"\",NblBets!B26)","v":""},{"$f":"IF(NblBets!C26=\"\",\"\",NblBets!C26)","v":""},{"$f":"IF(NblBets!D26=\"\",\"\",NblBets!D26)","v":""},{"$f":"IF(NblBets!E26=\"\",\"\",NblBets!E26)","v":""},{"$f":"IF(AND(E26<>\"\",D26<>\"\"),NORMDIST(((LN((D26/(1-D26)))/0.1453)+E26),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F26=\"\",G26=\"\"),\"\",IF((F26*G26-1)>=coeff!$B$11,coeff!$B$3*(F26*G26-1)/coeff!$B$6/(G26-1),0))","v":""},{"$f":"IF(OR(F26=\"\",H26=\"\"),\"\",IF(((1-F26)*H26-1)>=coeff!$B$11,coeff!$B$3*((1-F26)*H26-1)/coeff!$B$7/(H26-1),0))","v":""}]
[{"$f":"IF(NblBets!A27=\"\",\"\",NblBets!A27)","v":""},{"$f":"IF(NblBets!B27=\"\",\"\",NblBets!B27)","v":""},{"$f":"IF(NblBets!C27=\"\",\"\",NblBets!C27)","v":""},{"$f":"IF(NblBets!D27=\"\",\"\",NblBets!D27)","v":""},{"$f":"IF(NblBets!E27=\"\",\"\",NblBets!E27)","v":""},{"$f":"IF(AND(E27<>\"\",D27<>\"\"),NORMDIST(((LN((D27/(1-D27)))/0.1453)+E27),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F27=\"\",G27=\"\"),\"\",IF((F27*G27-1)>=coeff!$B$11,coeff!$B$3*(F27*G27-1)/coeff!$B$6/(G27-1),0))","v":""},{"$f":"IF(OR(F27=\"\",H27=\"\"),\"\",IF(((1-F27)*H27-1)>=coeff!$B$11,coeff!$B$3*((1-F27)*H27-1)/coeff!$B$7/(H27-1),0))","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(E28<>\"\",D28<>\"\"),NORMDIST(((LN((D28/(1-D28)))/0.1453)+E28),0,13.486,TRUE),\"\")","v":""},null,null,{"$f":"IF(OR(F28=\"\",G28=\"\"),\"\",IF((F28*G28-1)>=coeff!$B$11,coeff!$B$3*(F28*G28-1)/coeff!$B$6/(G28-1),0))","v":""},{"$f":"IF(OR(F28=\"\",H28=\"\"),\"\",IF(((1-F28)*H28-1)>=coeff!$B$11,coeff!$B$3*((1-F28)*H28-1)/coeff!$B$7/(H28-1),0))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(F29=\"\",G29=\"\"),\"\",IF((F29*G29-1)>=coeff!$B$11,coeff!$B$3*(F29*G29-1)/coeff!$B$6/(G29-1),0))","v":""},{"$f":"IF(OR(F29=\"\",H29=\"\"),\"\",IF(((1-F29)*H29-1)>=coeff!$B$11,coeff!$B$3*((1-F29)*H29-1)/coeff!$B$7/(H29-1),0))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(F30=\"\",G30=\"\"),\"\",IF((F30*G30-1)>=coeff!$B$11,coeff!$B$3*(F30*G30-1)/coeff!$B$6/(G30-1),0))","v":""},{"$f":"IF(OR(F30=\"\",H30=\"\"),\"\",IF(((1-F30)*H30-1)>=coeff!$B$11,coeff!$B$3*((1-F30)*H30-1)/coeff!$B$7/(H30-1),0))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(F31=\"\",G31=\"\"),\"\",IF((F31*G31-1)>=coeff!$B$11,coeff!$B$3*(F31*G31-1)/coeff!$B$6/(G31-1),0))","v":""},{"$f":"IF(OR(F31=\"\",H31=\"\"),\"\",IF(((1-F31)*H31-1)>=coeff!$B$11,coeff!$B$3*((1-F31)*H31-1)/coeff!$B$7/(H31-1),0))","v":""}]

{"sheet":"Multiple Lines","index":3,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["Date","Team1","Team2","ProbT1","Line","ProbLine(Team1)","OddsLine(Team1)","OddsLine(Team2)","$BetT1","$BetT2","Overlay","ExpReturn","Change cells my colour only"]
[{"$f":"IF(Line!A7=\"\",\"\",Line!A7)","v":"2014-11-09"},{"$f":"IF(Line!B7=\"\",\"\",Line!B7)","v":"Sydney"},{"$f":"IF(Line!C7=\"\",\"\",Line!C7)","v":"Adelaide"},{"$f":"IF(Line!D7=\"\",\"\",Line!D7)","v":0.48099999999999998},-5,{"$f":"IF(AND(E3<>\"\",D3<>\"\"),NORMDIST(((LN((D3/(1-D3)))/0.1453)+E3),0,13.486,TRUE),\"\")","v":0.34106487361190096},1.9,1.9,{"$f":"IF(E3=\"\",\"\",IF((F3*G3-1)>=coeff!$B$11,IF(L3=MAX($L$3:$L$7),coeff!$B$3/coeff!$B$7*(F3*G3-1)/(G3-1),0),0))","v":0},{"$f":"IF(E3=\"\",\"\",IF((H3*(1-F3)-1)>=coeff!$B$11,IF(L3=MAX($L$3:$L$7),coeff!$B$3/coeff!$B$7*((1-F3)*H3-1)/(H3-1),0),0))","v":279.97415570820891},{"$f":"IF(F3=\"\",\"\",IF(I3>0,G3*F3-1,IF(J3>0,H3*(1-F3)-1,\"\")))","v":0.25197674013738802},{"$f":"IF(F3=\"\",\"\",IF((F3*G3-1)>=coeff!$B$11,F3*(F3*G3-1)-(F3*G3-1)/(G3-1)*(1-F3),IF((H3*(1-F3)-1)>=coeff!$B$11,(1-F3)*((1-F3)*H3-1)-((1-F3)*H3-1)/(H3-1)*(1-(1-F3)),0)))","v":7.0546975078071991E-2}]
[{"$f":"IF(A3=\"\",\"\",A3)","v":"2014-11-09"},{"$f":"IF(B3=\"\",\"\",B3)","v":"Sydney"},{"$f":"IF(C3=\"\",\"\",C3)","v":"Adelaide"},{"$f":"IF(D3=\"\",\"\",D3)","v":0.48099999999999998},-4.5,{"$f":"IF(AND(E4<>\"\",D4<>\"\"),NORMDIST(((LN((D4/(1-D4)))/0.1453)+E4),0,13.486,TRUE),\"\")","v":0.35476657850561333},1.85,1.95,{"$f":"IF(E4=\"\",\"\",IF((F4*G4-1)>=coeff!$B$11,IF(L4=MAX($L$3:$L$7),coeff!$B$3/coeff!$B$7*(F4*G4-1)/(G4-1),0),0))","v":0},{"$f":"IF(E4=\"\",\"\",IF((H4*(1-F4)-1)>=coeff!$B$11,IF(L4=MAX($L$3:$L$7),coeff!$B$3/coeff!$B$7*((1-F4)*H4-1)/(H4-1),0),0))","v":0},{"$f":"IF(F4=\"\",\"\",IF(I4>0,G4*F4-1,IF(J4>0,H4*(1-F4)-1,\"\")))","v":""},{"$f":"IF(F4=\"\",\"\",IF((F4*G4-1)>=coeff!$B$11,F4*(F4*G4-1)-(F4*G4-1)/(G4-1)*(1-F4),IF((H4*(1-F4)-1)>=coeff!$B$11,(1-F4)*((1-F4)*H4-1)-((1-F4)*H4-1)/(H4-1)*(1-(1-F4)),0)))","v":7.0178853477017009E-2}]
[{"$f":"IF(A4=\"\",\"\",A4)","v":"2014-11-09"},{"$f":"IF(B4=\"\",\"\",B4)","v":"Sydney"},{"$f":"IF(C4=\"\",\"\",C4)","v":"Adelaide"},{"$f":"IF(D4=\"\",\"\",D4)","v":0.48099999999999998},-4,{"$f":"IF(AND(E5<>\"\",D5<>\"\"),NORMDIST(((LN((D5/(1-D5)))/0.1453)+E5),0,13.486,TRUE),\"\")","v":0.36865879448300298},1.8,2,{"$f":"IF(E5=\"\",\"\",IF((F5*G5-1)>=coeff!$B$11,IF(L5=MAX($L$3:$L$7),coeff!$B$3/coeff!$B$7*(F5*G5-1)/(G5-1),0),0))","v":0},{"$f":"IF(E5=\"\",\"\",IF((H5*(1-F5)-1)>=coeff!$B$11,IF(L5=MAX($L$3:$L$7),coeff!$B$3/coeff!$B$7*((1-F5)*H5-1)/(H5-1),0),0))","v":0},"",{"$f":"IF(F5=\"\",\"\",IF((F5*G5-1)>=coeff!$B$11,F5*(F5*G5-1)-(F5*G5-1)/(G5-1)*(1-F5),IF((H5*(1-F5)-1)>=coeff!$B$11,(1-F5)*((1-F5)*H5-1)-((1-F5)*H5-1)/(H5-1)*(1-(1-F5)),0)))","v":6.9002049066632196E-2}]
["2014-11-09","Sydney","Adelaide",0.48099999999999998,-3.5,{"$f":"IF(AND(E6<>\"\",D6<>\"\"),NORMDIST(((LN((D6/(1-D6)))/0.1453)+E6),0,13.486,TRUE),\"\")","v":0.38272482432177651},1.75,2.0499999999999998,{"$f":"IF(E6=\"\",\"\",IF((F6*G6-1)>=coeff!$B$11,IF(L6=MAX($L$3:$L$7),coeff!$B$3/coeff!$B$7*(F6*G6-1)/(G6-1),0),0))","v":0},{"$f":"IF(E6=\"\",\"\",IF((H6*(1-F6)-1)>=coeff!$B$11,IF(L6=MAX($L$3:$L$7),coeff!$B$3/coeff!$B$7*((1-F6)*H6-1)/(H6-1),0),0))","v":0},"",{"$f":"IF(F6=\"\",\"\",IF((F6*G6-1)>=coeff!$B$11,F6*(F6*G6-1)-(F6*G6-1)/(G6-1)*(1-F6),IF((H6*(1-F6)-1)>=coeff!$B$11,(1-F6)*((1-F6)*H6-1)-((1-F6)*H6-1)/(H6-1)*(1-(1-F6)),0)))","v":6.709014272533162E-2}]
["2014-11-09","Sydney","Adelaide",0.48099999999999998,-3,{"$f":"IF(AND(E7<>\"\",D7<>\"\"),NORMDIST(((LN((D7/(1-D7)))/0.1453)+E7),0,13.486,TRUE),\"\")","v":0.39694728144051761},1.7,2.1,{"$f":"IF(E7=\"\",\"\",IF((F7*G7-1)>=coeff!$B$11,IF(L7=MAX($L$3:$L$7),coeff!$B$3/coeff!$B$7*(F7*G7-1)/(G7-1),0),0))","v":0},{"$f":"IF(E7=\"\",\"\",IF((H7*(1-F7)-1)>=coeff!$B$11,IF(L7=MAX($L$3:$L$7),coeff!$B$3/coeff!$B$7*((1-F7)*H7-1)/(H7-1),0),0))","v":0},"",{"$f":"IF(F7=\"\",\"\",IF((F7*G7-1)>=coeff!$B$11,F7*(F7*G7-1)-(F7*G7-1)/(G7-1)*(1-F7),IF((H7*(1-F7)-1)>=coeff!$B$11,(1-F7)*((1-F7)*H7-1)-((1-F7)*H7-1)/(H7-1)*(1-(1-F7)),0)))","v":6.4522423505923479E-2}]
[]
["Date","Team1","Team2","ProbT1","Line","ProbLine(Team1)","OddsLine(Team1)","OddsLine(Team2)","$BetT1","$BetT2","Overlay","ExpReturn"]
[{"$f":"IF(Line!A8=\"\",\"\",Line!A8)","v":"2014-11-09"},{"$f":"IF(Line!B8=\"\",\"\",Line!B8)","v":"Townsville"},{"$f":"IF(Line!C8=\"\",\"\",Line!C8)","v":"New Zealand"},{"$f":"IF(Line!D8=\"\",\"\",Line!D8)","v":0.71499999999999997},-5,{"$f":"IF(AND(E10<>\"\",D10<>\"\"),NORMDIST(((LN((D10/(1-D10)))/0.1453)+E10),0,13.486,TRUE),\"\")","v":0.53928930756004889},1.9,1.9,{"$f":"IF(F10=\"\",\"\",IF((F10*G10-1)>=coeff!$B$11,IF(L10=MAX($L$10:$L$14),coeff!$B$3/coeff!$B$7*(F10*G10-1)/(G10-1),0),0))","v":0},{"$f":"IF(F10=\"\",\"\",IF((H10*(1-F10)-1)>=coeff!$B$11,IF(L10=MAX($L$10:$L$14),coeff!$B$3/coeff!$B$7*((1-F10)*H10-1)/(H10-1),0),0))","v":0},{"$f":"IF(F10=\"\",\"\",IF(I10>0,G10*F10-1,IF(J10>0,H10*(1-F10)-1,\"\")))","v":""},{"$f":"IF(F10=\"\",\"\",IF((F10*G10-1)>=coeff!$B$11,F10*(F10*G10-1)-(F10*G10-1)/(G10-1)*(1-F10),IF((H10*(1-F10)-1)>=coeff!$B$11,(1-F10)*((1-F10)*H10-1)-((1-F10)*H10-1)/(H10-1)*(1-(1-F10)),0)))","v":0}]
[{"$f":"IF(A10=\"\",\"\",A10)","v":"2014-11-09"},{"$f":"IF(B10=\"\",\"\",B10)","v":"Townsville"},{"$f":"IF(C10=\"\",\"\",C10)","v":"New Zealand"},{"$f":"IF(D10=\"\",\"\",D10)","v":0.71499999999999997},-4.5,{"$f":"IF(AND(E11<>\"\",D11<>\"\"),NORMDIST(((LN((D11/(1-D11)))/0.1453)+E11),0,13.486,TRUE),\"\")","v":0.55397825379609289},1.85,1.95,{"$f":"IF(F11=\"\",\"\",IF((F11*G11-1)>=coeff!$B$11,IF(L11=MAX($L$10:$L$14),coeff!$B$3/coeff!$B$7*(F11*G11-1)/(G11-1),0),0))","v":0},{"$f":"IF(F11=\"\",\"\",IF((H11*(1-F11)-1)>=coeff!$B$11,IF(L11=MAX($L$10:$L$14),coeff!$B$3/coeff!$B$7*((1-F11)*H11-1)/(H11-1),0),0))","v":0},"",{"$f":"IF(F11=\"\",\"\",IF((F11*G11-1)>=coeff!$B$11,F11*(F11*G11-1)-(F11*G11-1)/(G11-1)*(1-F11),IF((H11*(1-F11)-1)>=coeff!$B$11,(1-F11)*((1-F11)*H11-1)-((1-F11)*H11-1)/(H11-1)*(1-(1-F11)),0)))","v":0}]
[{"$f":"IF(A11=\"\",\"\",A11)","v":"2014-11-09"},{"$f":"IF(B11=\"\",\"\",B11)","v":"Townsville"},{"$f":"IF(C11=\"\",\"\",C11)","v":"New Zealand"},{"$f":"IF(D11=\"\",\"\",D11)","v":0.71499999999999997},-4,{"$f":"IF(AND(E12<>\"\",D12<>\"\"),NORMDIST(((LN((D12/(1-D12)))/0.1453)+E12),0,13.486,TRUE),\"\")","v":0.56859348160519596},1.8,2,{"$f":"IF(F12=\"\",\"\",IF((F12*G12-1)>=coeff!$B$11,IF(L12=MAX($L$10:$L$14),coeff!$B$3/coeff!$B$7*(F12*G12-1)/(G12-1),0),0))","v":0},{"$f":"IF(F12=\"\",\"\",IF((H12*(1-F12)-1)>=coeff!$B$11,IF(L12=MAX($L$10:$L$14),coeff!$B$3/coeff!$B$7*((1-F12)*H12-1)/(H12-1),0),0))","v":0},"",{"$f":"IF(F12=\"\",\"\",IF((F12*G12-1)>=coeff!$B$11,F12*(F12*G12-1)-(F12*G12-1)/(G12-1)*(1-F12),IF((H12*(1-F12)-1)>=coeff!$B$11,(1-F12)*((1-F12)*H12-1)-((1-F12)*H12-1)/(H12-1)*(1-(1-F12)),0)))","v":0}]
["2014-11-09","Townsville","New Zealand",0.71499999999999997,-3.5,{"$f":"IF(AND(E13<>\"\",D13<>\"\"),NORMDIST(((LN((D13/(1-D13)))/0.1453)+E13),0,13.486,TRUE),\"\")","v":0.58311538782595607},1.75,2.0499999999999998,{"$f":"IF(F13=\"\",\"\",IF((F13*G13-1)>=coeff!$B$11,IF(L13=MAX($L$10:$L$14),coeff!$B$3/coeff!$B$7*(F13*G13-1)/(G13-1),0),0))","v":0},{"$f":"IF(F13=\"\",\"\",IF((H13*(1-F13)-1)>=coeff!$B$11,IF(L13=MAX($L$10:$L$14),coeff!$B$3/coeff!$B$7*((1-F13)*H13-1)/(H13-1),0),0))","v":0},"",{"$f":"IF(F13=\"\",\"\",IF((F13*G13-1)>=coeff!$B$11,F13*(F13*G13-1)-(F13*G13-1)/(G13-1)*(1-F13),IF((H13*(1-F13)-1)>=coeff!$B$11,(1-F13)*((1-F13)*H13-1)-((1-F13)*H13-1)/(H13-1)*(1-(1-F13)),0)))","v":0}]
["2014-11-09","Townsville","New Zealand",0.71499999999999997,-3,{"$f":"IF(AND(E14<>\"\",D14<>\"\"),NORMDIST(((LN((D14/(1-D14)))/0.1453)+E14),0,13.486,TRUE),\"\")","v":0.59752475000177774},1.7,2.1,{"$f":"IF(F14=\"\",\"\",IF((F14*G14-1)>=coeff!$B$11,IF(L14=MAX($L$10:$L$14),coeff!$B$3/coeff!$B$7*(F14*G14-1)/(G14-1),0),0))","v":0},{"$f":"IF(F14=\"\",\"\",IF((H14*(1-F14)-1)>=coeff!$B$11,IF(L14=MAX($L$10:$L$14),coeff!$B$3/coeff!$B$7*((1-F14)*H14-1)/(H14-1),0),0))","v":0},"",{"$f":"IF(F14=\"\",\"\",IF((F14*G14-1)>=coeff!$B$11,F14*(F14*G14-1)-(F14*G14-1)/(G14-1)*(1-F14),IF((H14*(1-F14)-1)>=coeff!$B$11,(1-F14)*((1-F14)*H14-1)-((1-F14)*H14-1)/(H14-1)*(1-(1-F14)),0)))","v":0}]
[]
["Date","Team1","Team2","ProbT1","Line","ProbLine(Team1)","OddsLine(Team1)","OddsLine(Team2)","$BetT1","$BetT2","Overlay","ExpReturn"]
[{"$f":"IF(Line!A9=\"\",\"\",Line!A9)","v":"2014-11-09"},{"$f":"IF(Line!B9=\"\",\"\",Line!B9)","v":"Perth"},{"$f":"IF(Line!C9=\"\",\"\",Line!C9)","v":"Melbourne"},{"$f":"IF(Line!D9=\"\",\"\",Line!D9)","v":0.81},-5,{"$f":"IF(AND(E17<>\"\",D17<>\"\"),NORMDIST(((LN((D17/(1-D17)))/0.1453)+E17),0,13.486,TRUE),\"\")","v":0.64402150119739443},1.9,1.9,{"$f":"IF(F17=\"\",\"\",IF((F17*G17-1)>=coeff!$B$11,IF(L17=MAX($L$17:$L$21),coeff!$B$3/coeff!$B$7*(F17*G17-1)/(G17-1),0),0))","v":248.48983586116589},{"$f":"IF(F17=\"\",\"\",IF((H17*(1-F17)-1)>=coeff!$B$11,IF(L17=MAX($L$17:$L$21),coeff!$B$3/coeff!$B$7*((1-F17)*H17-1)/(H17-1),0),0))","v":0},{"$f":"IF(F17=\"\",\"\",IF(I17>0,G17*F17-1,IF(J17>0,H17*(1-F17)-1,\"\")))","v":0.22364085227504926},{"$f":"IF(F17=\"\",\"\",IF((F17*G17-1)>=coeff!$B$11,F17*(F17*G17-1)-(F17*G17-1)/(G17-1)*(1-F17),IF((H17*(1-F17)-1)>=coeff!$B$11,(1-F17)*((1-F17)*H17-1)-((1-F17)*H17-1)/(H17-1)*(1-(1-F17)),0)))","v":5.5572478673678261E-2}]
[{"$f":"IF(A17=\"\",\"\",A17)","v":"2014-11-09"},{"$f":"IF(B17=\"\",\"\",B17)","v":"Perth"},{"$f":"IF(C17=\"\",\"\",C17)","v":"Melbourne"},{"$f":"IF(D17=\"\",\"\",D17)","v":0.81},-4.5,{"$f":"IF(AND(E18<>\"\",D18<>\"\"),NORMDIST(((LN((D18/(1-D18)))/0.1453)+E18),0,13.486,TRUE),\"\")","v":0.65774057683573961},1.85,1.95,{"$f":"IF(F18=\"\",\"\",IF((F18*G18-1)>=coeff!$B$11,IF(L18=MAX($L$17:$L$21),coeff!$B$3/coeff!$B$7*(F18*G18-1)/(G18-1),0),0))","v":0},{"$f":"IF(F18=\"\",\"\",IF((H18*(1-F18)-1)>=coeff!$B$11,IF(L18=MAX($L$17:$L$21),coeff!$B$3/coeff!$B$7*((1-F18)*H18-1)/(H18-1),0),0))","v":0},"",{"$f":"IF(F18=\"\",\"\",IF((F18*G18-1)>=coeff!$B$11,F18*(F18*G18-1)-(F18*G18-1)/(G18-1)*(1-F18),IF((H18*(1-F18)-1)>=coeff!$B$11,(1-F18)*((1-F18)*H18-1)-((1-F18)*H18-1)/(H18-1)*(1-(1-F18)),0)))","v":5.5306990020290853E-2}]
[{"$f":"IF(A18=\"\",\"\",A18)","v":"2014-11-09"},{"$f":"IF(B18=\"\",\"\",B18)","v":"Perth"},{"$f":"IF(C18=\"\",\"\",C18)","v":"Melbourne"},{"$f":"IF(D18=\"\",\"\",D18)","v":0.81},-4,{"$f":"IF(AND(E19<>\"\",D19<>\"\"),NORMDIST(((LN((D19/(1-D19)))/0.1453)+E19),0,13.486,TRUE),\"\")","v":0.67125456127755079},1.8,2,{"$f":"IF(F19=\"\",\"\",IF((F19*G19-1)>=coeff!$B$11,IF(L19=MAX($L$17:$L$21),coeff!$B$3/coeff!$B$7*(F19*G19-1)/(G19-1),0),0))","v":0},{"$f":"IF(F19=\"\",\"\",IF((H19*(1-F19)-1)>=coeff!$B$11,IF(L19=MAX($L$17:$L$21),coeff!$B$3/coeff!$B$7*((1-F19)*H19-1)/(H19-1),0),0))","v":0},"",{"$f":"IF(F19=\"\",\"\",IF((F19*G19-1)>=coeff!$B$11,F19*(F19*G19-1)-(F19*G19-1)/(G19-1)*(1-F19),IF((H19*(1-F19)-1)>=coeff!$B$11,(1-F19)*((1-F19)*H19-1)-((1-F19)*H19-1)/(H19-1)*(1-(1-F19)),0)))","v":5.4214352696486029E-2}]
["2014-11-09","Perth","Melbourne",0.81,-3.5,{"$f":"IF(AND(E20<>\"\",D20<>\"\"),NORMDIST(((LN((D20/(1-D20)))/0.1453)+E20),0,13.486,TRUE),\"\")","v":0.68454823665786579},1.75,2.0499999999999998,{"$f":"IF(F20=\"\",\"\",IF((F20*G20-1)>=coeff!$B$11,IF(L20=MAX($L$17:$L$21),coeff!$B$3/coeff!$B$7*(F20*G20-1)/(G20-1),0),0))","v":0},{"$f":"IF(F20=\"\",\"\",IF((H20*(1-F20)-1)>=coeff!$B$11,IF(L20=MAX($L$17:$L$21),coeff!$B$3/coeff!$B$7*((1-F20)*H20-1)/(H20-1),0),0))","v":0},"",{"$f":"IF(F20=\"\",\"\",IF((F20*G20-1)>=coeff!$B$11,F20*(F20*G20-1)-(F20*G20-1)/(G20-1)*(1-F20),IF((H20*(1-F20)-1)>=coeff!$B$11,(1-F20)*((1-F20)*H20-1)-((1-F20)*H20-1)/(H20-1)*(1-(1-F20)),0)))","v":5.2250572868149478E-2}]
["2014-11-09","Perth","Melbourne",0.81,-3,{"$f":"IF(AND(E21<>\"\",D21<>\"\"),NORMDIST(((LN((D21/(1-D21)))/0.1453)+E21),0,13.486,TRUE),\"\")","v":0.69760723344962783},1.7,2.1,{"$f":"IF(F21=\"\",\"\",IF((F21*G21-1)>=coeff!$B$11,IF(L21=MAX($L$17:$L$21),coeff!$B$3/coeff!$B$7*(F21*G21-1)/(G21-1),0),0))","v":0},{"$f":"IF(F21=\"\",\"\",IF((H21*(1-F21)-1)>=coeff!$B$11,IF(L21=MAX($L$17:$L$21),coeff!$B$3/coeff!$B$7*((1-F21)*H21-1)/(H21-1),0),0))","v":0},"",{"$f":"IF(F21=\"\",\"\",IF((F21*G21-1)>=coeff!$B$11,F21*(F21*G21-1)-(F21*G21-1)/(G21-1)*(1-F21),IF((H21*(1-F21)-1)>=coeff!$B$11,(1-F21)*((1-F21)*H21-1)-((1-F21)*H21-1)/(H21-1)*(1-(1-F21)),0)))","v":4.9386884310370291E-2}]
[]
["Date","Team1","Team2","ProbT1","Line","ProbLine(Team1)","OddsLine(Team1)","OddsLine(Team2)","$BetT1","$BetT2","Overlay","ExpReturn"]
[{"$f":"IF(Line!A10=\"\",\"\",Line!A10)","v":""},{"$f":"IF(Line!B10=\"\",\"\",Line!B10)","v":""},{"$f":"IF(Line!C10=\"\",\"\",Line!C10)","v":""},{"$f":"IF(Line!D10=\"\",\"\",Line!D10)","v":""},-5,{"$f":"IF(AND(E24<>\"\",D24<>\"\"),NORMDIST(((LN((D24/(1-D24)))/0.1453)+E24),0,13.486,TRUE),\"\")","v":""},1.9,1.9,{"$f":"IF(F24=\"\",\"\",IF((F24*G24-1)>=coeff!$B$11,IF(L24=MAX($L$24:$L$28),coeff!$B$3/coeff!$B$7*(F24*G24-1)/(G24-1),0),0))","v":""},{"$f":"IF(F24=\"\",\"\",IF((H24*(1-F24)-1)>=coeff!$B$11,IF(L24=MAX($L$24:$L$28),coeff!$B$3/coeff!$B$7*((1-F24)*H24-1)/(H24-1),0),0))","v":""},{"$f":"IF(F24=\"\",\"\",IF(I24>0,G24*F24-1,IF(J24>0,H24*(1-F24)-1,\"\")))","v":""},{"$f":"IF(F24=\"\",\"\",IF((F24*G24-1)>=coeff!$B$11,F24*(F24*G24-1)-(F24*G24-1)/(G24-1)*(1-F24),IF((H24*(1-F24)-1)>=coeff!$B$11,(1-F24)*((1-F24)*H24-1)-((1-F24)*H24-1)/(H24-1)*(1-(1-F24)),0)))","v":""}]
[{"$f":"IF(A24=\"\",\"\",A24)","v":""},{"$f":"IF(B24=\"\",\"\",B24)","v":""},{"$f":"IF(C24=\"\",\"\",C24)","v":""},{"$f":"IF(D24=\"\",\"\",D24)","v":""},-4.5,{"$f":"IF(AND(E25<>\"\",D25<>\"\"),NORMDIST(((LN((D25/(1-D25)))/0.1453)+E25),0,13.486,TRUE),\"\")","v":""},1.85,1.95,{"$f":"IF(F25=\"\",\"\",IF((F25*G25-1)>=coeff!$B$11,IF(L25=MAX($L$24:$L$28),coeff!$B$3/coeff!$B$7*(F25*G25-1)/(G25-1),0),0))","v":""},{"$f":"IF(F25=\"\",\"\",IF((H25*(1-F25)-1)>=coeff!$B$11,IF(L25=MAX($L$24:$L$28),coeff!$B$3/coeff!$B$7*((1-F25)*H25-1)/(H25-1),0),0))","v":""},"",{"$f":"IF(F25=\"\",\"\",IF((F25*G25-1)>=coeff!$B$11,F25*(F25*G25-1)-(F25*G25-1)/(G25-1)*(1-F25),IF((H25*(1-F25)-1)>=coeff!$B$11,(1-F25)*((1-F25)*H25-1)-((1-F25)*H25-1)/(H25-1)*(1-(1-F25)),0)))","v":""}]
["","","","",-4,{"$f":"IF(AND(E26<>\"\",D26<>\"\"),NORMDIST(((LN((D26/(1-D26)))/0.1453)+E26),0,13.486,TRUE),\"\")","v":""},1.8,2,{"$f":"IF(F26=\"\",\"\",IF((F26*G26-1)>=coeff!$B$11,IF(L26=MAX($L$24:$L$28),coeff!$B$3/coeff!$B$7*(F26*G26-1)/(G26-1),0),0))","v":""},{"$f":"IF(F26=\"\",\"\",IF((H26*(1-F26)-1)>=coeff!$B$11,IF(L26=MAX($L$24:$L$28),coeff!$B$3/coeff!$B$7*((1-F26)*H26-1)/(H26-1),0),0))","v":""},"",{"$f":"IF(F26=\"\",\"\",IF((F26*G26-1)>=coeff!$B$11,F26*(F26*G26-1)-(F26*G26-1)/(G26-1)*(1-F26),IF((H26*(1-F26)-1)>=coeff!$B$11,(1-F26)*((1-F26)*H26-1)-((1-F26)*H26-1)/(H26-1)*(1-(1-F26)),0)))","v":""}]
["","","","",-3.5,{"$f":"IF(AND(E27<>\"\",D27<>\"\"),NORMDIST(((LN((D27/(1-D27)))/0.1453)+E27),0,13.486,TRUE),\"\")","v":""},1.75,2.0499999999999998,{"$f":"IF(F27=\"\",\"\",IF((F27*G27-1)>=coeff!$B$11,IF(L27=MAX($L$24:$L$28),coeff!$B$3/coeff!$B$7*(F27*G27-1)/(G27-1),0),0))","v":""},{"$f":"IF(F27=\"\",\"\",IF((H27*(1-F27)-1)>=coeff!$B$11,IF(L27=MAX($L$24:$L$28),coeff!$B$3/coeff!$B$7*((1-F27)*H27-1)/(H27-1),0),0))","v":""},"",{"$f":"IF(F27=\"\",\"\",IF((F27*G27-1)>=coeff!$B$11,F27*(F27*G27-1)-(F27*G27-1)/(G27-1)*(1-F27),IF((H27*(1-F27)-1)>=coeff!$B$11,(1-F27)*((1-F27)*H27-1)-((1-F27)*H27-1)/(H27-1)*(1-(1-F27)),0)))","v":""}]
["","","","",-3,{"$f":"IF(AND(E28<>\"\",D28<>\"\"),NORMDIST(((LN((D28/(1-D28)))/0.1453)+E28),0,13.486,TRUE),\"\")","v":""},1.7,2.1,{"$f":"IF(F28=\"\",\"\",IF((F28*G28-1)>=coeff!$B$11,IF(L28=MAX($L$24:$L$28),coeff!$B$3/coeff!$B$7*(F28*G28-1)/(G28-1),0),0))","v":""},{"$f":"IF(F28=\"\",\"\",IF((H28*(1-F28)-1)>=coeff!$B$11,IF(L28=MAX($L$24:$L$28),coeff!$B$3/coeff!$B$7*((1-F28)*H28-1)/(H28-1),0),0))","v":""},"",{"$f":"IF(F28=\"\",\"\",IF((F28*G28-1)>=coeff!$B$11,F28*(F28*G28-1)-(F28*G28-1)/(G28-1)*(1-F28),IF((H28*(1-F28)-1)>=coeff!$B$11,(1-F28)*((1-F28)*H28-1)-((1-F28)*H28-1)/(H28-1)*(1-(1-F28)),0)))","v":""}]

{"sheet":"Multiple Totals","index":4,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["Date","Team1","Team2","Exp.Total","Line","ProbLine(Team1)","OddsLine(Team1)","OddsLine(Team2)","$BetT1","$BetT2","Overlay","ExpReturn","Change cells my colour only"]
[{"$f":"IF(NblBets!A7=\"\",\"\",NblBets!A7)","v":"2014-11-09"},{"$f":"IF(NblBets!B7=\"\",\"\",NblBets!B7)","v":"Sydney"},{"$f":"IF(NblBets!C7=\"\",\"\",NblBets!C7)","v":"Adelaide"},{"$f":"IF(NblBets!I7=\"\",\"\",NblBets!I7)","v":174.3},165.5,{"$f":"IF(OR(D3=\"\",E3=\"\"),\"\",NORMDIST((D3-E3),0,19.25,TRUE))","v":0.67621581618447246},1.9,1.9,{"$f":"IF(E3=\"\",\"\",IF((F3*G3-1)>=coeff!$B$12,IF(L3=MAX($L$3:$L$7),coeff!$B$4/coeff!$B$8*(F3*G3-1)/(G3-1),0),0))","v":316.45561194499732},{"$f":"IF(E3=\"\",\"\",IF((H3*(1-F3)-1)>=coeff!$B$12,IF(L3=MAX($L$3:$L$7),coeff!$B$4/coeff!$B$8*((1-F3)*H3-1)/(H3-1),0),0))","v":0},{"$f":"IF(F3=\"\",\"\",IF(I3>0,G3*F3-1,IF(J3>0,H3*(1-F3)-1,\"\")))","v":0.28481005075049759},{"$f":"IF(F3=\"\",\"\",IF((F3*G3-1)>=coeff!$B$11,F3*(F3*G3-1)-(F3*G3-1)/(G3-1)*(1-F3),IF((H3*(1-F3)-1)>=coeff!$B$11,(1-F3)*((1-F3)*H3-1)-((1-F3)*H3-1)/(H3-1)*(1-(1-F3)),0)))","v":9.0129738898334491E-2}]
[{"$f":"IF(A3=\"\",\"\",A3)","v":"2014-11-09"},{"$f":"IF(B3=\"\",\"\",B3)","v":"Sydney"},{"$f":"IF(C3=\"\",\"\",C3)","v":"Adelaide"},{"$f":"IF(D3=\"\",\"\",D3)","v":174.3},166,{"$f":"IF(OR(D4=\"\",E4=\"\"),\"\",NORMDIST((D4-E4),0,19.25,TRUE))","v":0.66682719228627008},1.85,1.95,{"$f":"IF(E4=\"\",\"\",IF((F4*G4-1)>=coeff!$B$12,IF(L4=MAX($L$3:$L$7),coeff!$B$4/coeff!$B$8*(F4*G4-1)/(G4-1),0),0))","v":0},{"$f":"IF(E4=\"\",\"\",IF((H4*(1-F4)-1)>=coeff!$B$12,IF(L4=MAX($L$3:$L$7),coeff!$B$4/coeff!$B$8*((1-F4)*H4-1)/(H4-1),0),0))","v":0},{"$f":"IF(F4=\"\",\"\",IF(I4>0,G4*F4-1,IF(J4>0,H4*(1-F4)-1,\"\")))","v":""},{"$f":"IF(F4=\"\",\"\",IF((F4*G4-1)>=coeff!$B$11,F4*(F4*G4-1)-(F4*G4-1)/(G4-1)*(1-F4),IF((H4*(1-F4)-1)>=coeff!$B$11,(1-F4)*((1-F4)*H4-1)-((1-F4)*H4-1)/(H4-1)*(1-(1-F4)),0)))","v":6.4215435006242591E-2}]
[{"$f":"IF(A4=\"\",\"\",A4)","v":"2014-11-09"},"Sydney","Adelaide",174.3,166.5,0.65733283840556922,1.8,2,{"$f":"IF(E5=\"\",\"\",IF((F5*G5-1)>=coeff!$B$12,IF(L5=MAX($L$3:$L$7),coeff!$B$4/coeff!$B$8*(F5*G5-1)/(G5-1),0),0))","v":0},{"$f":"IF(E5=\"\",\"\",IF((H5*(1-F5)-1)>=coeff!$B$12,IF(L5=MAX($L$3:$L$7),coeff!$B$4/coeff!$B$8*((1-F5)*H5-1)/(H5-1),0),0))","v":0},"",{"$f":"IF(F5=\"\",\"\",IF((F5*G5-1)>=coeff!$B$11,F5*(F5*G5-1)-(F5*G5-1)/(G5-1)*(1-F5),IF((H5*(1-F5)-1)>=coeff!$B$11,(1-F5)*((1-F5)*H5-1)-((1-F5)*H5-1)/(H5-1)*(1-(1-F5)),0)))","v":4.1952391982543344E-2}]
["2014-11-09","Sydney","Adelaide",174.3,167,0.64773803881590053,1.75,2.0499999999999998,{"$f":"IF(E6=\"\",\"\",IF((F6*G6-1)>=coeff!$B$12,IF(L6=MAX($L$3:$L$7),coeff!$B$4/coeff!$B$8*(F6*G6-1)/(G6-1),0),0))","v":0},{"$f":"IF(E6=\"\",\"\",IF((H6*(1-F6)-1)>=coeff!$B$12,IF(L6=MAX($L$3:$L$7),coeff!$B$4/coeff!$B$8*((1-F6)*H6-1)/(H6-1),0),0))","v":0},"",{"$f":"IF(F6=\"\",\"\",IF((F6*G6-1)>=coeff!$B$11,F6*(F6*G6-1)-(F6*G6-1)/(G6-1)*(1-F6),IF((H6*(1-F6)-1)>=coeff!$B$11,(1-F6)*((1-F6)*H6-1)-((1-F6)*H6-1)/(H6-1)*(1-(1-F6)),0)))","v":2.3777800486162876E-2}]
["2014-11-09","Sydney","Adelaide",174.3,167.5,0.63804826989059749,1.7,2.1,{"$f":"IF(E7=\"\",\"\",IF((F7*G7-1)>=coeff!$B$12,IF(L7=MAX($L$3:$L$7),coeff!$B$4/coeff!$B$8*(F7*G7-1)/(G7-1),0),0))","v":0},{"$f":"IF(E7=\"\",\"\",IF((H7*(1-F7)-1)>=coeff!$B$12,IF(L7=MAX($L$3:$L$7),coeff!$B$4/coeff!$B$8*((1-F7)*H7-1)/(H7-1),0),0))","v":0},"",{"$f":"IF(F7=\"\",\"\",IF((F7*G7-1)>=coeff!$B$11,F7*(F7*G7-1)-(F7*G7-1)/(G7-1)*(1-F7),IF((H7*(1-F7)-1)>=coeff!$B$11,(1-F7)*((1-F7)*H7-1)-((1-F7)*H7-1)/(H7-1)*(1-(1-F7)),0)))","v":1.0244358692829178E-2}]
[]
["Date","Team1","Team2","Exp.Total","Line","ProbLine(Team1)","OddsLine(Team1)","OddsLine(Team2)","$BetT1","$BetT2","Overlay","ExpReturn"]
[{"$f":"IF(NblBets!A8=\"\",\"\",NblBets!A8)","v":"2014-11-09"},{"$f":"IF(NblBets!B8=\"\",\"\",NblBets!B8)","v":"Townsville"},{"$f":"IF(NblBets!C8=\"\",\"\",NblBets!C8)","v":"New Zealand"},{"$f":"IF(NblBets!I8=\"\",\"\",NblBets!I8)","v":171.7},165,{"$f":"IF(OR(D10=\"\",E10=\"\"),\"\",NORMDIST((D10-E10),0,19.25,TRUE))","v":0.63609941469239961},1.9,1.9,{"$f":"IF(F10=\"\",\"\",IF((F10*G10-1)>=coeff!$B$12,IF(L10=MAX($L$10:$L$14),coeff!$B$4/coeff!$B$8*(F10*G10-1)/(G10-1),0),0))","v":231.76543101728814},{"$f":"IF(F10=\"\",\"\",IF((H10*(1-F10)-1)>=coeff!$B$12,IF(L10=MAX($L$10:$L$14),coeff!$B$4/coeff!$B$8*((1-F10)*H10-1)/(H10-1),0),0))","v":0},{"$f":"IF(F10=\"\",\"\",IF(I10>0,G10*F10-1,IF(J10>0,H10*(1-F10)-1,\"\")))","v":0.2085888879155593},{"$f":"IF(F10=\"\",\"\",IF((F10*G10-1)>=coeff!$B$11,F10*(F10*G10-1)-(F10*G10-1)/(G10-1)*(1-F10),IF((H10*(1-F10)-1)>=coeff!$B$11,(1-F10)*((1-F10)*H10-1)-((1-F10)*H10-1)/(H10-1)*(1-(1-F10)),0)))","v":4.8343693513166391E-2}]
[{"$f":"IF(A10=\"\",\"\",A10)","v":"2014-11-09"},{"$f":"IF(B10=\"\",\"\",B10)","v":"Townsville"},{"$f":"IF(C10=\"\",\"\",C10)","v":"New Zealand"},{"$f":"IF(D10=\"\",\"\",D10)","v":171.7},165,{"$f":"IF(OR(D11=\"\",E11=\"\"),\"\",NORMDIST((D11-E11),0,19.25,TRUE))","v":0.63609941469239961},1.85,1.95,{"$f":"IF(F11=\"\",\"\",IF((F11*G11-1)>=coeff!$B$12,IF(L11=MAX($L$10:$L$14),coeff!$B$4/coeff!$B$8*(F11*G11-1)/(G11-1),0),0))","v":0},{"$f":"IF(F11=\"\",\"\",IF((H11*(1-F11)-1)>=coeff!$B$12,IF(L11=MAX($L$10:$L$14),coeff!$B$4/coeff!$B$8*((1-F11)*H11-1)/(H11-1),0),0))","v":0},"",{"$f":"IF(F11=\"\",\"\",IF((F11*G11-1)>=coeff!$B$11,F11*(F11*G11-1)-(F11*G11-1)/(G11-1)*(1-F11),IF((H11*(1-F11)-1)>=coeff!$B$11,(1-F11)*((1-F11)*H11-1)-((1-F11)*H11-1)/(H11-1)*(1-(1-F11)),0)))","v":3.6767709851573183E-2}]
[{"$f":"IF(A11=\"\",\"\",A11)","v":"2014-11-09"},"Townsville","New Zealand",171.7,165,0.63609941469239961,1.8,2,{"$f":"IF(F12=\"\",\"\",IF((F12*G12-1)>=coeff!$B$12,IF(L12=MAX($L$10:$L$14),coeff!$B$4/coeff!$B$8*(F12*G12-1)/(G12-1),0),0))","v":0},{"$f":"IF(F12=\"\",\"\",IF((H12*(1-F12)-1)>=coeff!$B$12,IF(L12=MAX($L$10:$L$14),coeff!$B$4/coeff!$B$8*((1-F12)*H12-1)/(H12-1),0),0))","v":0},"",{"$f":"IF(F12=\"\",\"\",IF((F12*G12-1)>=coeff!$B$11,F12*(F12*G12-1)-(F12*G12-1)/(G12-1)*(1-F12),IF((H12*(1-F12)-1)>=coeff!$B$11,(1-F12)*((1-F12)*H12-1)-((1-F12)*H12-1)/(H12-1)*(1-(1-F12)),0)))","v":2.6273618640855909E-2}]
["2014-11-09","Townsville","New Zealand",171.7,165,0.63609941469239961,1.75,2.0499999999999998,{"$f":"IF(F13=\"\",\"\",IF((F13*G13-1)>=coeff!$B$12,IF(L13=MAX($L$10:$L$14),coeff!$B$4/coeff!$B$8*(F13*G13-1)/(G13-1),0),0))","v":0},{"$f":"IF(F13=\"\",\"\",IF((H13*(1-F13)-1)>=coeff!$B$12,IF(L13=MAX($L$10:$L$14),coeff!$B$4/coeff!$B$8*((1-F13)*H13-1)/(H13-1),0),0))","v":0},"",{"$f":"IF(F13=\"\",\"\",IF((F13*G13-1)>=coeff!$B$11,F13*(F13*G13-1)-(F13*G13-1)/(G13-1)*(1-F13),IF((H13*(1-F13)-1)>=coeff!$B$11,(1-F13)*((1-F13)*H13-1)-((1-F13)*H13-1)/(H13-1)*(1-(1-F13)),0)))","v":1.7077798371189751E-2}]
["2014-11-09","Townsville","New Zealand",171.7,165,0.63609941469239961,1.7,2.1,{"$f":"IF(F14=\"\",\"\",IF((F14*G14-1)>=coeff!$B$12,IF(L14=MAX($L$10:$L$14),coeff!$B$4/coeff!$B$8*(F14*G14-1)/(G14-1),0),0))","v":0},{"$f":"IF(F14=\"\",\"\",IF((H14*(1-F14)-1)>=coeff!$B$12,IF(L14=MAX($L$10:$L$14),coeff!$B$4/coeff!$B$8*((1-F14)*H14-1)/(H14-1),0),0))","v":0},"",{"$f":"IF(F14=\"\",\"\",IF((F14*G14-1)>=coeff!$B$11,F14*(F14*G14-1)-(F14*G14-1)/(G14-1)*(1-F14),IF((H14*(1-F14)-1)>=coeff!$B$11,(1-F14)*((1-F14)*H14-1)-((1-F14)*H14-1)/(H14-1)*(1-(1-F14)),0)))","v":9.4584499585142132E-3}]
[]
["Date","Team1","Team2","Exp.Total","Line","ProbLine(Team1)","OddsLine(Team1)","OddsLine(Team2)","$BetT1","$BetT2","Overlay","ExpReturn"]
[{"$f":"IF(NblBets!A9=\"\",\"\",NblBets!A9)","v":"2014-11-09"},{"$f":"IF(NblBets!B9=\"\",\"\",NblBets!B9)","v":"Perth"},{"$f":"IF(NblBets!C9=\"\",\"\",NblBets!C9)","v":"Melbourne"},{"$f":"IF(NblBets!I9=\"\",\"\",NblBets!I9)","v":158.19999999999999},165.5,{"$f":"IF(OR(D17=\"\",E17=\"\"),\"\",NORMDIST((D17-E17),0,19.25,TRUE))","v":0.35226196118409947},1.9,1.9,{"$f":"IF(F17=\"\",\"\",IF((F17*G17-1)>=coeff!$B$12,IF(L17=MAX($L$17:$L$21),coeff!$B$4/coeff!$B$8*(F17*G17-1)/(G17-1),0),0))","v":0},{"$f":"IF(F17=\"\",\"\",IF((H17*(1-F17)-1)>=coeff!$B$12,IF(L17=MAX($L$17:$L$21),coeff!$B$4/coeff!$B$8*((1-F17)*H17-1)/(H17-1),0),0))","v":256.33585972245658},{"$f":"IF(F17=\"\",\"\",IF(I17>0,G17*F17-1,IF(J17>0,H17*(1-F17)-1,\"\")))","v":0.23070227375021091},{"$f":"IF(F17=\"\",\"\",IF((F17*G17-1)>=coeff!$B$12,F17*(F17*G17-1)-(F17*G17-1)/(G17-1)*(1-F17),IF((H17*(1-F17)-1)>=coeff!$B$12,2,0)))","v":2}]
[{"$f":"IF(A17=\"\",\"\",A17)","v":"2014-11-09"},"Perth","Melbourne",158.19999999999999,166,{"$f":"IF(OR(D18=\"\",E18=\"\"),\"\",NORMDIST((D18-E18),0,19.25,TRUE))","v":0.34266716159443078},1.85,1.95,{"$f":"IF(F18=\"\",\"\",IF((F18*G18-1)>=coeff!$B$12,IF(L18=MAX($L$17:$L$21),coeff!$B$4/coeff!$B$8*(F18*G18-1)/(G18-1),0),0))","v":0},{"$f":"IF(F18=\"\",\"\",IF((H18*(1-F18)-1)>=coeff!$B$12,IF(L18=MAX($L$17:$L$21),coeff!$B$4/coeff!$B$8*((1-F18)*H18-1)/(H18-1),0),0))","v":296.63056304301045},0.28179903489085989,{"$f":"IF(F18=\"\",\"\",IF((F18*G18-1)>=coeff!$B$12,F18*(F18*G18-1)-(F18*G18-1)/(G18-1)*(1-F18),IF((H18*(1-F18)-1)>=coeff!$B$12,2,0)))","v":2}]
["2014-11-09",{"$f":"IF(B18=\"\",\"\",B18)","v":"Perth"},"Melbourne",158.19999999999999,166.5,0.33317280771372987,1.8,2,{"$f":"IF(F19=\"\",\"\",IF((F19*G19-1)>=coeff!$B$12,IF(L19=MAX($L$17:$L$21),coeff!$B$4/coeff!$B$8*(F19*G19-1)/(G19-1),0),0))","v":0},{"$f":"IF(F19=\"\",\"\",IF((H19*(1-F19)-1)>=coeff!$B$12,IF(L19=MAX($L$17:$L$21),coeff!$B$4/coeff!$B$8*((1-F19)*H19-1)/(H19-1),0),0))","v":333.65438457254015},0.33365438457254015,{"$f":"IF(F19=\"\",\"\",IF((F19*G19-1)>=coeff!$B$12,F19*(F19*G19-1)-(F19*G19-1)/(G19-1)*(1-F19),IF((H19*(1-F19)-1)>=coeff!$B$12,2,0)))","v":2}]
["2014-11-09",{"$f":"IF(B19=\"\",\"\",B19)","v":"Perth"},"Melbourne",158.19999999999999,167,0.32378418381552748,1.75,2.0499999999999998,{"$f":"IF(F20=\"\",\"\",IF((F20*G20-1)>=coeff!$B$12,IF(L20=MAX($L$17:$L$21),coeff!$B$4/coeff!$B$8*(F20*G20-1)/(G20-1),0),0))","v":0},{"$f":"IF(F20=\"\",\"\",IF((H20*(1-F20)-1)>=coeff!$B$12,IF(L20=MAX($L$17:$L$21),coeff!$B$4/coeff!$B$8*((1-F20)*H20-1)/(H20-1),0),0))","v":367.84992683635102},0.38624242317816848,{"$f":"IF(F20=\"\",\"\",IF((F20*G20-1)>=coeff!$B$12,F20*(F20*G20-1)-(F20*G20-1)/(G20-1)*(1-F20),IF((H20*(1-F20)-1)>=coeff!$B$12,2,0)))","v":2}]
["2014-11-09",{"$f":"IF(B20=\"\",\"\",B20)","v":"Perth"},"Melbourne",158.19999999999999,167.5,0.31450637351589655,1.7,2.1,{"$f":"IF(F21=\"\",\"\",IF((F21*G21-1)>=coeff!$B$12,IF(L21=MAX($L$17:$L$21),coeff!$B$4/coeff!$B$8*(F21*G21-1)/(G21-1),0),0))","v":0},{"$f":"IF(F21=\"\",\"\",IF((H21*(1-F21)-1)>=coeff!$B$12,IF(L21=MAX($L$17:$L$21),coeff!$B$4/coeff!$B$8*((1-F21)*H21-1)/(H21-1),0),0))","v":399.5787414696519},0.43953661561661717,{"$f":"IF(F21=\"\",\"\",IF((F21*G21-1)>=coeff!$B$12,F21*(F21*G21-1)-(F21*G21-1)/(G21-1)*(1-F21),IF((H21*(1-F21)-1)>=coeff!$B$12,2,0)))","v":2}]
[]
["Date","Team1","Team2","Exp.Total","Line","ProbLine(Team1)","OddsLine(Team1)","OddsLine(Team2)","$BetT1","$BetT2","Overlay","ExpReturn"]
[{"$f":"IF(NblBets!A10=\"\",\"\",NblBets!A10)","v":""},{"$f":"IF(NblBets!B10=\"\",\"\",NblBets!B10)","v":""},{"$f":"IF(NblBets!C10=\"\",\"\",NblBets!C10)","v":""},{"$f":"IF(NblBets!I10=\"\",\"\",NblBets!I10)","v":""},165.5,{"$f":"IF(OR(D24=\"\",E24=\"\"),\"\",NORMDIST((D24-E24),0,19.25,TRUE))","v":""},1.9,1.9,{"$f":"IF(F24=\"\",\"\",IF((F24*G24-1)>=coeff!$B$12,IF(L24=MAX($L$24:$L$28),coeff!$B$4/coeff!$B$8*(F24*G24-1)/(G24-1),0),0))","v":""},{"$f":"IF(F24=\"\",\"\",IF((H24*(1-F24)-1)>=coeff!$B$12,IF(L24=MAX($L$24:$L$28),coeff!$B$4/coeff!$B$8*((1-F24)*H24-1)/(H24-1),0),0))","v":""},{"$f":"IF(F24=\"\",\"\",IF(I24>0,G24*F24-1,IF(J24>0,H24*(1-F24)-1,\"\")))","v":""},{"$f":"IF(F24=\"\",\"\",IF((F24*G24-1)>=coeff!$B$12,F24*(F24*G24-1)-(F24*G24-1)/(G24-1)*(1-F24),IF((H24*(1-F24)-1)>=coeff!$B$12,2,0)))","v":""}]
[{"$f":"IF(A24=\"\",\"\",A24)","v":""},"","","",166,{"$f":"IF(OR(D25=\"\",E25=\"\"),\"\",NORMDIST((D25-E25),0,19.25,TRUE))","v":""},1.85,1.95,{"$f":"IF(F25=\"\",\"\",IF((F25*G25-1)>=coeff!$B$12,IF(L25=MAX($L$24:$L$28),coeff!$B$4/coeff!$B$8*(F25*G25-1)/(G25-1),0),0))","v":""},{"$f":"IF(F25=\"\",\"\",IF((H25*(1-F25)-1)>=coeff!$B$12,IF(L25=MAX($L$24:$L$28),coeff!$B$4/coeff!$B$8*((1-F25)*H25-1)/(H25-1),0),0))","v":""},"",{"$f":"IF(F25=\"\",\"\",IF((F25*G25-1)>=coeff!$B$12,F25*(F25*G25-1)-(F25*G25-1)/(G25-1)*(1-F25),IF((H25*(1-F25)-1)>=coeff!$B$12,2,0)))","v":""}]
[{"$f":"IF(A25=\"\",\"\",A25)","v":""},"","","",166.5,"",1.8,2,{"$f":"IF(F26=\"\",\"\",IF((F26*G26-1)>=coeff!$B$12,IF(L26=MAX($L$24:$L$28),coeff!$B$4/coeff!$B$8*(F26*G26-1)/(G26-1),0),0))","v":""},{"$f":"IF(F26=\"\",\"\",IF((H26*(1-F26)-1)>=coeff!$B$12,IF(L26=MAX($L$24:$L$28),coeff!$B$4/coeff!$B$8*((1-F26)*H26-1)/(H26-1),0),0))","v":""},"",{"$f":"IF(F26=\"\",\"\",IF((F26*G26-1)>=coeff!$B$12,F26*(F26*G26-1)-(F26*G26-1)/(G26-1)*(1-F26),IF((H26*(1-F26)-1)>=coeff!$B$12,2,0)))","v":""}]
[{"$f":"IF(A26=\"\",\"\",A26)","v":""},"","","",167,"",1.75,2.0499999999999998,{"$f":"IF(F27=\"\",\"\",IF((F27*G27-1)>=coeff!$B$12,IF(L27=MAX($L$24:$L$28),coeff!$B$4/coeff!$B$8*(F27*G27-1)/(G27-1),0),0))","v":""},{"$f":"IF(F27=\"\",\"\",IF((H27*(1-F27)-1)>=coeff!$B$12,IF(L27=MAX($L$24:$L$28),coeff!$B$4/coeff!$B$8*((1-F27)*H27-1)/(H27-1),0),0))","v":""},"",{"$f":"IF(F27=\"\",\"\",IF((F27*G27-1)>=coeff!$B$12,F27*(F27*G27-1)-(F27*G27-1)/(G27-1)*(1-F27),IF((H27*(1-F27)-1)>=coeff!$B$12,2,0)))","v":""}]
[{"$f":"IF(A27=\"\",\"\",A27)","v":""},"","","",167.5,"",1.7,2.1,{"$f":"IF(F28=\"\",\"\",IF((F28*G28-1)>=coeff!$B$12,IF(L28=MAX($L$24:$L$28),coeff!$B$4/coeff!$B$8*(F28*G28-1)/(G28-1),0),0))","v":""},{"$f":"IF(F28=\"\",\"\",IF((H28*(1-F28)-1)>=coeff!$B$12,IF(L28=MAX($L$24:$L$28),coeff!$B$4/coeff!$B$8*((1-F28)*H28-1)/(H28-1),0),0))","v":""},"",{"$f":"IF(F28=\"\",\"\",IF((F28*G28-1)>=coeff!$B$12,F28*(F28*G28-1)-(F28*G28-1)/(G28-1)*(1-F28),IF((H28*(1-F28)-1)>=coeff!$B$12,2,0)))","v":""}]