{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["coeff","h2h","line","multiple Lines","totals","futures","Sheet1","Sheet4","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":72,"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":74,"n_cols":8,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["Verson 2018.1"]
[null,null,null,null,null,"LineCoeff"]
[null,"Kelly","Bank",null,null,-35.5,-3.7962769781706847,0.12113639625034371]
["h2h",10,10000,null,null,-34.5,-3.7241716989922953,0.11454654809718384]
["line",10,10000,null,null,-33.5,-3.556536628534277,0.12113125246214561]
["futures",25,10000,null,null,-32.5,-3.5503096194370567,0.12111879837671764]
["totals",10,10000,null,null,-31.5,-3.2686880953212731,0.11437369202153286]
[null,null,null,null,null,-30.5,-3.2558039073775817,0.11374583120122937]
[null,null,null,null,null,-29.5,-3.0286186871482714,0.11198968400773601]
[null,null,null,null,null,-28.5,-2.9981131931794418,0.11061597752237738]
[null,null,null,null,null,-27.5,-2.8253124147792756,0.11191964779703405]
[null,null,null,null,null,-26.5,-2.7980897914898248,0.10962928503751761]
[null,null,null,null,null,-25.5,-2.5830184482308245,0.10643638475835139]
[null,null,null,null,null,-24.5,-2.5457465317777745,0.10575246298768598]
[null,null,null,null,null,-23.5,-2.3705778433019611,0.10518662479216075]
[null,null,null,null,null,-22.5,-2.3555134796603454,0.10382937829805261]
[null,null,null,null,null,-21.5,-2.1706383984503494,9.900913678062126E-2]
[null,null,null,null,null,-20.5,-2.1641365619768478,9.9025976813578526E-2]
[null,null,null,null,null,-19.5,-1.9084709412960119,9.8563211923086202E-2]
[null,null,null,null,null,-18.5,-1.8654932710583885,9.820212821563952E-2]
[null,null,null,null,null,-17.5,-1.704944248495436,9.8289371908903175E-2]
[null,null,null,null,null,-16.5,-1.6805957502423914,9.8848172008021887E-2]
[null,null,null,null,null,-15.5,-1.5141257714175573,9.4623342369154664E-2]
[null,null,null,null,null,-14.5,-1.5051123221782312,9.4536662296245785E-2]
[null,null,null,null,null,-13.5,-1.3042609016711257,9.4196041654897839E-2]
[null,null,null,null,null,-12.5,-1.2553891069434675,9.2156062752271284E-2]
[null,null,null,null,null,-11.5,-1.1240564165690377,8.7882033992157674E-2]
[null,null,null,null,null,-10.5,-1.0937198711451714,8.7162699474894328E-2]
[null,null,null,null,null,-9.5,-0.93575757006339855,8.3017134045395014E-2]
[null,null,null,null,null,-8.5,-0.91541540541574473,8.2163049175431005E-2]
[null,null,null,null,null,-7.5,-0.73145570054556375,8.1436794857094111E-2]
[null,null,null,null,null,-6.5,-0.66772664998603659,8.0358786048895306E-2]
[null,null,null,null,null,-5.5,-0.51900397030136869,8.180356677089809E-2]
[null,null,null,null,null,-4.5,-0.50529919236636356,8.2106908388804328E-2]
[null,null,null,null,null,-3.5,-0.31942790081843486,7.8927696990407012E-2]
[null,null,null,null,null,-2.5,-0.2965705947800924,7.9294037785806237E-2]
[null,null,null,null,null,-1.5,-0.10734047164846805,7.8622550251390005E-2]
[null,null,null,null,null,-0.5,-1.1297987861580042E-2,7.9046782496900433E-2]
[null,null,null,null,null,0.5,1.1297987861580093E-2,7.904678249690042E-2]
[null,null,null,null,null,1.5,0.10734047164846792,7.8622550251390061E-2]
[null,null,null,null,null,2.5,0.29657059478009229,7.9294037785806251E-2]
[null,null,null,null,null,3.5,0.31942790081843492,7.8927696990407012E-2]
[null,null,null,null,null,4.5,0.50529919236636356,8.2106908388804328E-2]
[null,null,null,null,null,5.5,0.51900397030136869,8.180356677089809E-2]
[null,null,null,null,null,6.5,0.66772664998603648,8.0358786048895306E-2]
[null,null,null,null,null,7.5,0.73145570054556375,8.1436794857094152E-2]
[null,null,null,null,null,8.5,0.91541540541574473,8.2163049175430977E-2]
[null,null,null,null,null,9.5,0.93575757006339866,8.3017134045395097E-2]
[null,null,null,null,null,10.5,1.0937198711451714,8.7162699474894315E-2]
[null,null,null,null,null,11.5,1.1240564165690377,8.7882033992157632E-2]
[null,null,null,null,null,12.5,1.2553891069434677,9.2156062752271298E-2]
[null,null,null,null,null,13.5,1.3042609016711257,9.4196041654897839E-2]
[null,null,null,null,null,14.5,1.5051123221782314,9.4536662296245758E-2]
[null,null,null,null,null,15.5,1.5141257714175573,9.4623342369154692E-2]
[null,null,null,null,null,16.5,1.6805957502423914,9.8848172008021928E-2]
[null,null,null,null,null,17.5,1.7049442484954358,9.8289371908903161E-2]
[null,null,null,null,null,18.5,1.8654932710583882,9.8202128215639548E-2]
[null,null,null,null,null,19.5,1.9084709412960119,9.8563211923086244E-2]
[null,null,null,null,null,20.5,2.1641365619768478,9.9025976813578553E-2]
[null,null,null,null,null,21.5,2.1706383984503499,9.9009136780621371E-2]
[null,null,null,null,null,22.5,2.355513479660345,0.10382937829805262]
[null,null,null,null,null,23.5,2.3705778433019611,0.10518662479216075]
[null,null,null,null,null,24.5,2.545746531777775,0.10575246298768604]
[null,null,null,null,null,25.5,2.5830184482308245,0.10643638475835142]
[null,null,null,null,null,26.5,2.7980897914898248,0.10962928503751759]
[null,null,null,null,null,27.5,2.8253124147792752,0.11191964779703398]
[null,null,null,null,null,28.5,2.9981131931794418,0.11061597752237741]
[null,null,null,null,null,29.5,3.028618687148271,0.11198968400773601]
[null,null,null,null,null,30.5,3.2558039073775817,0.1137458312012293]
[null,null,null,null,null,31.5,3.2686880953212736,0.11437369202153294]
[null,null,null,null,null,32.5,3.5503096194370576,0.12111879837671782]
[null,null,null,null,null,33.5,3.556536628534277,0.12113125246214568]
[null,null,null,null,null,34.5,3.7241716989922957,0.11454654809718388]
[null,null,null,null,null,35.5,3.7962769781706851,0.12113639625034382]

{"sheet":"h2h","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Team1","Team2","PlayerProb","Odds1","Odds2","$Bet1","$Bet2","Overlay"]
["Penrith","Canterbury",0.50600000000000001,2.25,1.72,{"$f":"IF(D4=\"\",\"\",IF((C4*D4-1)>=0.05,coeff!$C$4/coeff!$B$4*(C4*D4-1)/(D4-1),0))","v":110.80000000000004},{"$f":"IF(E4=\"\",\"\",IF((E4*(1-C4)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E4*(1-C4)-1)/(E4-1),0))","v":0},{"$f":"IF(C4=\"\",\"\",IF(F4>0,C4*D4-1,IF(G4>0,E4*(1-C4)-1,\"\")))","v":0.13850000000000007}]
["Brisbane","New Zealand",0.71299999999999997,1.33,3.52,{"$f":"IF(D5=\"\",\"\",IF((C5*D5-1)>=0.05,coeff!$C$4/coeff!$B$4*(C5*D5-1)/(D5-1),0))","v":0},{"$f":"IF(E5=\"\",\"\",IF((E5*(1-C5)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E5*(1-C5)-1)/(E5-1),0))","v":0},{"$f":"IF(C5=\"\",\"\",IF(F5>0,C5*D5-1,IF(G5>0,E5*(1-C5)-1,\"\")))","v":""}]
[null,null,null,null,null,{"$f":"IF(D6=\"\",\"\",IF((C6*D6-1)>=0.05,coeff!$C$4/coeff!$B$4*(C6*D6-1)/(D6-1),0))","v":""},{"$f":"IF(E6=\"\",\"\",IF((E6*(1-C6)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E6*(1-C6)-1)/(E6-1),0))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D7=\"\",\"\",IF((C7*D7-1)>=0.05,coeff!$C$4/coeff!$B$4*(C7*D7-1)/(D7-1),0))","v":""},{"$f":"IF(E7=\"\",\"\",IF((E7*(1-C7)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E7*(1-C7)-1)/(E7-1),0))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D8=\"\",\"\",IF((C8*D8-1)>=0.05,coeff!$C$4/coeff!$B$4*(C8*D8-1)/(D8-1),0))","v":""},{"$f":"IF(E8=\"\",\"\",IF((E8*(1-C8)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E8*(1-C8)-1)/(E8-1),0))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D9=\"\",\"\",IF((C9*D9-1)>=0.05,coeff!$C$4/coeff!$B$4*(C9*D9-1)/(D9-1),0))","v":""},{"$f":"IF(E9=\"\",\"\",IF((E9*(1-C9)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E9*(1-C9)-1)/(E9-1),0))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D10=\"\",\"\",IF((C10*D10-1)>=0.05,coeff!$C$4/coeff!$B$4*(C10*D10-1)/(D10-1),0))","v":""},{"$f":"IF(E10=\"\",\"\",IF((E10*(1-C10)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E10*(1-C10)-1)/(E10-1),0))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D11=\"\",\"\",IF((C11*D11-1)>=0.05,coeff!$C$4/coeff!$B$4*(C11*D11-1)/(D11-1),0))","v":""},{"$f":"IF(E11=\"\",\"\",IF((E11*(1-C11)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E11*(1-C11)-1)/(E11-1),0))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D12=\"\",\"\",IF((C12*D12-1)>=0.05,coeff!$C$4/coeff!$B$4*(C12*D12-1)/(D12-1),0))","v":""},{"$f":"IF(E12=\"\",\"\",IF((E12*(1-C12)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E12*(1-C12)-1)/(E12-1),0))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D13=\"\",\"\",IF((C13*D13-1)>=0.05,coeff!$C$4/coeff!$B$4*(C13*D13-1)/(D13-1),0))","v":""},{"$f":"IF(E13=\"\",\"\",IF((E13*(1-C13)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E13*(1-C13)-1)/(E13-1),0))","v":""}]
[null,null,null,null,null,{"$f":"IF(D14=\"\",\"\",IF((C14*D14-1)>=0.05,coeff!$C$4/coeff!$B$4*(C14*D14-1)/(D14-1),0))","v":""},{"$f":"IF(E14=\"\",\"\",IF((E14*(1-C14)-1)>=0.05,coeff!$C$4/coeff!$B$4*(E14*(1-C14)-1)/(E14-1),0))","v":""}]

{"sheet":"line","index":2,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Team1","Team2","PlayerProb","Line","Odds1","Odds2","LineProb","$Bet1","$Bet2","Overlay"]
["Penrith","Canterbury",{"$f":"IF(h2h!C4=\"\",\"\",h2h!C4)","v":0.50600000000000001},4.5,1.77,2.11,{"$f":"IF(D4=\"\",\"\",IF(ISERROR(VLOOKUP(D4,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D4,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089))/(1+EXP(VLOOKUP(D4,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089))),(EXP(VLOOKUP(D4+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089))/(1+EXP(VLOOKUP(D4+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089)))+EXP(VLOOKUP(D4-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089))/(1+EXP(VLOOKUP(D4-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089))))/2))","v":0.62888617196959873},{"$f":"IF(D4=\"\",\"\",IF((G4*E4-1)>=0.05,coeff!$C$5/coeff!$B$5*(G4*E4-1)/(E4-1),0))","v":146.92016154050609},{"$f":"IF(D4=\"\",\"\",IF((F4*(1-G4)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F4*(1-G4)-1)/(F4-1),0))","v":0},{"$f":"IF(C4=\"\",\"\",IF(H4>0,E4*G4-1,IF(I4>0,F4*(1-G4)-1,\"\")))","v":0.1131285243861897}]
["Brisbane","New Zealand",{"$f":"IF(h2h!C5=\"\",\"\",h2h!C5)","v":0.71299999999999997},-9.5,1.93,1.93,{"$f":"IF(D5=\"\",\"\",IF(ISERROR(VLOOKUP(D5,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089))/(1+EXP(VLOOKUP(D5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089))),(EXP(VLOOKUP(D5+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089))/(1+EXP(VLOOKUP(D5+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089)))+EXP(VLOOKUP(D5-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089))/(1+EXP(VLOOKUP(D5-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089))))/2))","v":0.47828081713072385},{"$f":"IF(D5=\"\",\"\",IF((G5*E5-1)>=0.05,coeff!$C$5/coeff!$B$5*(G5*E5-1)/(E5-1),0))","v":0},{"$f":"IF(D5=\"\",\"\",IF((F5*(1-G5)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F5*(1-G5)-1)/(F5-1),0))","v":0},{"$f":"IF(C5=\"\",\"\",IF(H5>0,E5*G5-1,IF(I5>0,F5*(1-G5)-1,\"\")))","v":""}]
[null,null,{"$f":"IF(h2h!C6=\"\",\"\",h2h!C6)","v":""},null,null,null,{"$f":"IF(D6=\"\",\"\",IF(ISERROR(VLOOKUP(D6,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D6,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089))/(1+EXP(VLOOKUP(D6,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089))),(EXP(VLOOKUP(D6+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089))/(1+EXP(VLOOKUP(D6+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089)))+EXP(VLOOKUP(D6-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089))/(1+EXP(VLOOKUP(D6-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089))))/2))","v":""},{"$f":"IF(D6=\"\",\"\",IF((G6*E6-1)>=0.05,coeff!$C$5/coeff!$B$5*(G6*E6-1)/(E6-1),0))","v":""},{"$f":"IF(D6=\"\",\"\",IF((F6*(1-G6)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F6*(1-G6)-1)/(F6-1),0))","v":""},""]
[null,null,{"$f":"IF(h2h!C7=\"\",\"\",h2h!C7)","v":""},null,null,null,{"$f":"IF(D7=\"\",\"\",IF(ISERROR(VLOOKUP(D7,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D7,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089))/(1+EXP(VLOOKUP(D7,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089))),(EXP(VLOOKUP(D7+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089))/(1+EXP(VLOOKUP(D7+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089)))+EXP(VLOOKUP(D7-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089))/(1+EXP(VLOOKUP(D7-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089))))/2))","v":""},{"$f":"IF(D7=\"\",\"\",IF((G7*E7-1)>=0.05,coeff!$C$5/coeff!$B$5*(G7*E7-1)/(E7-1),0))","v":""},{"$f":"IF(D7=\"\",\"\",IF((F7*(1-G7)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F7*(1-G7)-1)/(F7-1),0))","v":""},""]
[null,null,{"$f":"IF(h2h!C8=\"\",\"\",h2h!C8)","v":""},null,null,null,{"$f":"IF(D8=\"\",\"\",IF(ISERROR(VLOOKUP(D8,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D8,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089))/(1+EXP(VLOOKUP(D8,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089))),(EXP(VLOOKUP(D8+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089))/(1+EXP(VLOOKUP(D8+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089)))+EXP(VLOOKUP(D8-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089))/(1+EXP(VLOOKUP(D8-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089))))/2))","v":""},{"$f":"IF(D8=\"\",\"\",IF((G8*E8-1)>=0.05,coeff!$C$5/coeff!$B$5*(G8*E8-1)/(E8-1),0))","v":""},{"$f":"IF(D8=\"\",\"\",IF((F8*(1-G8)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F8*(1-G8)-1)/(F8-1),0))","v":""},""]
[null,null,{"$f":"IF(h2h!C9=\"\",\"\",h2h!C9)","v":""},null,null,null,{"$f":"IF(D9=\"\",\"\",IF(ISERROR(VLOOKUP(D9,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D9,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D9,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C9)-1)/0.089))/(1+EXP(VLOOKUP(D9,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D9,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C9)-1)/0.089))),(EXP(VLOOKUP(D9+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D9+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C9)-1)/0.089))/(1+EXP(VLOOKUP(D9+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D9+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C9)-1)/0.089)))+EXP(VLOOKUP(D9-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D9-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C9)-1)/0.089))/(1+EXP(VLOOKUP(D9-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D9-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C9)-1)/0.089))))/2))","v":""},{"$f":"IF(D9=\"\",\"\",IF((G9*E9-1)>=0.05,coeff!$C$5/coeff!$B$5*(G9*E9-1)/(E9-1),0))","v":""},{"$f":"IF(D9=\"\",\"\",IF((F9*(1-G9)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F9*(1-G9)-1)/(F9-1),0))","v":""},""]
[null,null,{"$f":"IF(h2h!C10=\"\",\"\",h2h!C10)","v":""},null,null,null,{"$f":"IF(D10=\"\",\"\",IF(ISERROR(VLOOKUP(D10,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D10,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D10,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C10)-1)/0.089))/(1+EXP(VLOOKUP(D10,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D10,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C10)-1)/0.089))),(EXP(VLOOKUP(D10+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D10+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C10)-1)/0.089))/(1+EXP(VLOOKUP(D10+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D10+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C10)-1)/0.089)))+EXP(VLOOKUP(D10-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D10-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C10)-1)/0.089))/(1+EXP(VLOOKUP(D10-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D10-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C10)-1)/0.089))))/2))","v":""},{"$f":"IF(D10=\"\",\"\",IF((G10*E10-1)>=0.05,coeff!$C$5/coeff!$B$5*(G10*E10-1)/(E10-1),0))","v":""},{"$f":"IF(D10=\"\",\"\",IF((F10*(1-G10)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F10*(1-G10)-1)/(F10-1),0))","v":""},""]
[null,null,{"$f":"IF(h2h!C11=\"\",\"\",h2h!C11)","v":""},null,null,null,{"$f":"IF(D11=\"\",\"\",IF(ISERROR(VLOOKUP(D11,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D11,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089))/(1+EXP(VLOOKUP(D11,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089))),(EXP(VLOOKUP(D11+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089))/(1+EXP(VLOOKUP(D11+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089)))+EXP(VLOOKUP(D11-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089))/(1+EXP(VLOOKUP(D11-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089))))/2))","v":""},{"$f":"IF(D11=\"\",\"\",IF((G11*E11-1)>=0.05,coeff!$C$5/coeff!$B$5*(G11*E11-1)/(E11-1),0))","v":""},{"$f":"IF(D11=\"\",\"\",IF((F11*(1-G11)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F11*(1-G11)-1)/(F11-1),0))","v":""},""]
[null,null,{"$f":"IF(h2h!C13=\"\",\"\",h2h!C13)","v":""},null,null,null,{"$f":"IF(D12=\"\",\"\",IF(ISERROR(VLOOKUP(D12,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D12,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089))/(1+EXP(VLOOKUP(D12,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089))),(EXP(VLOOKUP(D12+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089))/(1+EXP(VLOOKUP(D12+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089)))+EXP(VLOOKUP(D12-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089))/(1+EXP(VLOOKUP(D12-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089))))/2))","v":""},{"$f":"IF(D12=\"\",\"\",IF((G12*E12-1)>=0.05,coeff!$C$5/coeff!$B$5*(G12*E12-1)/(E12-1),0))","v":""},{"$f":"IF(D12=\"\",\"\",IF((F12*(1-G12)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F12*(1-G12)-1)/(F12-1),0))","v":""}]
[null,null,{"$f":"IF(h2h!C14=\"\",\"\",h2h!C14)","v":""},null,null,null,{"$f":"IF(D13=\"\",\"\",IF(ISERROR(VLOOKUP(D13,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D13,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089))/(1+EXP(VLOOKUP(D13,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089))),(EXP(VLOOKUP(D13+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089))/(1+EXP(VLOOKUP(D13+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089)))+EXP(VLOOKUP(D13-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089))/(1+EXP(VLOOKUP(D13-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089))))/2))","v":""},{"$f":"IF(D13=\"\",\"\",IF((G13*E13-1)>=0.05,coeff!$C$5/coeff!$B$5*(G13*E13-1)/(E13-1),0))","v":""},{"$f":"IF(D13=\"\",\"\",IF((F13*(1-G13)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F13*(1-G13)-1)/(F13-1),0))","v":""}]
[null,null,{"$f":"IF(h2h!C15=\"\",\"\",h2h!C15)","v":""},null,null,null,{"$f":"IF(D14=\"\",\"\",IF(ISERROR(VLOOKUP(D14,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D14,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089))/(1+EXP(VLOOKUP(D14,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089))),(EXP(VLOOKUP(D14+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089))/(1+EXP(VLOOKUP(D14+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089)))+EXP(VLOOKUP(D14-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089))/(1+EXP(VLOOKUP(D14-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089))))/2))","v":""},{"$f":"IF(D14=\"\",\"\",IF((G14*E14-1)>=0.05,coeff!$C$5/coeff!$B$5*(G14*E14-1)/(E14-1),0))","v":""},{"$f":"IF(D14=\"\",\"\",IF((F14*(1-G14)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F14*(1-G14)-1)/(F14-1),0))","v":""}]
[null,null,{"$f":"IF(h2h!C16=\"\",\"\",h2h!C16)","v":""},null,null,null,{"$f":"IF(D15=\"\",\"\",IF(ISERROR(VLOOKUP(D15,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D15,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089))/(1+EXP(VLOOKUP(D15,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089))),(EXP(VLOOKUP(D15+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089))/(1+EXP(VLOOKUP(D15+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089)))+EXP(VLOOKUP(D15-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089))/(1+EXP(VLOOKUP(D15-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089))))/2))","v":""},{"$f":"IF(D15=\"\",\"\",IF((G15*E15-1)>=0.05,coeff!$C$5/coeff!$B$5*(G15*E15-1)/(E15-1),0))","v":""},{"$f":"IF(D15=\"\",\"\",IF((F15*(1-G15)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F15*(1-G15)-1)/(F15-1),0))","v":""}]
[null,null,{"$f":"IF(h2h!C17=\"\",\"\",h2h!C17)","v":""},null,null,null,{"$f":"IF(D16=\"\",\"\",IF(ISERROR(VLOOKUP(D16,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D16,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089))/(1+EXP(VLOOKUP(D16,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089))),(EXP(VLOOKUP(D16+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089))/(1+EXP(VLOOKUP(D16+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089)))+EXP(VLOOKUP(D16-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089))/(1+EXP(VLOOKUP(D16-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089))))/2))","v":""},{"$f":"IF(D16=\"\",\"\",IF((G16*E16-1)>=0.05,coeff!$C$5/coeff!$B$5*(G16*E16-1)/(E16-1),0))","v":""},{"$f":"IF(D16=\"\",\"\",IF((F16*(1-G16)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F16*(1-G16)-1)/(F16-1),0))","v":""}]
[null,null,{"$f":"IF(h2h!C18=\"\",\"\",h2h!C18)","v":""},null,null,null,{"$f":"IF(D17=\"\",\"\",IF(ISERROR(VLOOKUP(D17,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D17,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D17,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C17)-1)/0.089))/(1+EXP(VLOOKUP(D17,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D17,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C17)-1)/0.089))),(EXP(VLOOKUP(D17+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D17+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C17)-1)/0.089))/(1+EXP(VLOOKUP(D17+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D17+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C17)-1)/0.089)))+EXP(VLOOKUP(D17-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D17-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C17)-1)/0.089))/(1+EXP(VLOOKUP(D17-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D17-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C17)-1)/0.089))))/2))","v":""},{"$f":"IF(D17=\"\",\"\",IF((G17*E17-1)>=0.05,coeff!$C$5/coeff!$B$5*(G17*E17-1)/(E17-1),0))","v":""},{"$f":"IF(D17=\"\",\"\",IF((F17*(1-G17)-1)>=0.05,coeff!$C$5/coeff!$B$5*(F17*(1-G17)-1)/(F17-1),0))","v":""},"x"]

{"sheet":"multiple Lines","index":3,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
["Team1","Team2","PlayerProb","Line","Odds1","Odds2","LineProb","$Bet1","$Bet2","Exp Profit","Max"]
[{"$f":"line!A4","v":"Penrith"},{"$f":"line!B4","v":"Canterbury"},{"$f":"IF(line!C4=\"\",\"\",line!C4)","v":0.50600000000000001},5,1.92,1.99,{"$f":"IF(OR(C3=\"\",D3=\"\"),\"\",IF(ISERROR(VLOOKUP(D3,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D3,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D3,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C3)-1)/0.089))/(1+EXP(VLOOKUP(D3,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D3,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C3)-1)/0.089))),(EXP(VLOOKUP(D3+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D3+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C3)-1)/0.089))/(1+EXP(VLOOKUP(D3+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D3+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C3)-1)/0.089)))+EXP(VLOOKUP(D3-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D3-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C3)-1)/0.089))/(1+EXP(VLOOKUP(D3-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D3-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C3)-1)/0.089))))/2))","v":0.6304730828549816},{"$f":"IF(OR(C3=\"\",D3=\"\"),\"\",IF(AND((G3*E3-1)>=0.05,K3=1),coeff!$C$5/coeff!$B$5*(G3*E3-1)/(E3-1),0))","v":0},{"$f":"IF(OR(C3=\"\",D3=\"\"),\"\",IF(AND((F3*(1-G3)-1)>=0.05,K3=1),coeff!$C$5/coeff!$B$5*(F3*(1-G3)-1)/(F3-1),0))","v":0},{"$f":"IF(OR(C3=\"\",D3=\"\"),\"\",IF((G3*E3-1)>0,1000*(G3*E3-1)/(E3-1)*G3*(E3-1)-(1-G3)*1000*(G3*E3-1)/(E3-1),IF(((1-G3)*F3-1)>0,1000*((1-G3)*F3-1)/(F3-1)*(1-G3)*(F3-1)-G3*1000*((1-G3)*F3-1)/(F3-1),0)))","v":48.16712217668028},{"$f":"IF(J3=MAX($J$3:$J$8),1,0)","v":0}]
[null,null,{"$f":"C3","v":0.50600000000000001},5.5,1.89,2.1,{"$f":"IF(OR(C4=\"\",D4=\"\"),\"\",IF(ISERROR(VLOOKUP(D4,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D4,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089))/(1+EXP(VLOOKUP(D4,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089))),(EXP(VLOOKUP(D4+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089))/(1+EXP(VLOOKUP(D4+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089)))+EXP(VLOOKUP(D4-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089))/(1+EXP(VLOOKUP(D4-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D4-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C4)-1)/0.089))))/2))","v":0.63205999374036437},{"$f":"IF(OR(C4=\"\",D4=\"\"),\"\",IF(AND((G4*E4-1)>=0.05,K4=1),coeff!$C$5/coeff!$B$5*(G4*E4-1)/(E4-1),0))","v":0},{"$f":"IF(OR(C4=\"\",D4=\"\"),\"\",IF(AND((F4*(1-G4)-1)>=0.05,K4=1),coeff!$C$5/coeff!$B$5*(F4*(1-G4)-1)/(F4-1),0))","v":0},{"$f":"IF(OR(C4=\"\",D4=\"\"),\"\",IF((G4*E4-1)>0,1000*(G4*E4-1)/(E4-1)*G4*(E4-1)-(1-G4)*1000*(G4*E4-1)/(E4-1),IF(((1-G4)*F4-1)>0,1000*((1-G4)*F4-1)/(F4-1)*(1-G4)*(F4-1)-G4*1000*((1-G4)*F4-1)/(F4-1),0)))","v":42.546726650790347},{"$f":"IF(J4=MAX($J$3:$J$8),1,0)","v":0}]
[null,null,{"$f":"C4","v":0.50600000000000001},6,2.0499999999999998,2.1,{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(ISERROR(VLOOKUP(D5,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089))/(1+EXP(VLOOKUP(D5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089))),(EXP(VLOOKUP(D5+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089))/(1+EXP(VLOOKUP(D5+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089)))+EXP(VLOOKUP(D5-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089))/(1+EXP(VLOOKUP(D5-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D5-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C5)-1)/0.089))))/2))","v":0.64894643622790338},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND((G5*E5-1)>=0.05,K5=1),coeff!$C$5/coeff!$B$5*(G5*E5-1)/(E5-1),0))","v":0},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND((F5*(1-G5)-1)>=0.05,K5=1),coeff!$C$5/coeff!$B$5*(F5*(1-G5)-1)/(F5-1),0))","v":0},103.92823233189776,0]
[null,null,0.50600000000000001,6.5,2,1.91,{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(ISERROR(VLOOKUP(D6,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D6,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089))/(1+EXP(VLOOKUP(D6,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089))),(EXP(VLOOKUP(D6+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089))/(1+EXP(VLOOKUP(D6+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089)))+EXP(VLOOKUP(D6-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089))/(1+EXP(VLOOKUP(D6-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D6-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C6)-1)/0.089))))/2))","v":0.66583287871544228},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND((G6*E6-1)>=0.05,K6=1),coeff!$C$5/coeff!$B$5*(G6*E6-1)/(E6-1),0))","v":0},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND((F6*(1-G6)-1)>=0.05,K6=1),coeff!$C$5/coeff!$B$5*(F6*(1-G6)-1)/(F6-1),0))","v":0},110.00217465220238,0]
[null,null,0.50600000000000001,7,2,1.91,{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(ISERROR(VLOOKUP(D7,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D7,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089))/(1+EXP(VLOOKUP(D7,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089))),(EXP(VLOOKUP(D7+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089))/(1+EXP(VLOOKUP(D7+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089)))+EXP(VLOOKUP(D7-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089))/(1+EXP(VLOOKUP(D7-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D7-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C7)-1)/0.089))))/2))","v":0.67287786037300434},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND((G7*E7-1)>=0.05,K7=1),coeff!$C$5/coeff!$B$5*(G7*E7-1)/(E7-1),0))","v":345.75572074600871},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND((F7*(1-G7)-1)>=0.05,K7=1),coeff!$C$5/coeff!$B$5*(F7*(1-G7)-1)/(F7-1),0))","v":0},119.54701842859197,1]
[null,null,0.50600000000000001,7,2,1.91,{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(ISERROR(VLOOKUP(D8,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D8,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089))/(1+EXP(VLOOKUP(D8,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089))),(EXP(VLOOKUP(D8+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089))/(1+EXP(VLOOKUP(D8+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089)))+EXP(VLOOKUP(D8-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089))/(1+EXP(VLOOKUP(D8-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D8-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C8)-1)/0.089))))/2))","v":0.67287786037300434},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND((G8*E8-1)>=0.05,K8=1),coeff!$C$5/coeff!$B$5*(G8*E8-1)/(E8-1),0))","v":345.75572074600871},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND((F8*(1-G8)-1)>=0.05,K8=1),coeff!$C$5/coeff!$B$5*(F8*(1-G8)-1)/(F8-1),0))","v":0},119.54701842859197,1]
[]
["Team1","Team2","PlayerProb","Line","Odds1","Odds2","LineProb","$Bet1","$Bet2","Exp Profit","Max"]
[{"$f":"line!A5","v":"Brisbane"},{"$f":"line!B5","v":"New Zealand"},{"$f":"IF(line!C5=\"\",\"\",line!C5)","v":0.71299999999999997},-9,1.92,1.99,{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(ISERROR(VLOOKUP(D11,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D11,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089))/(1+EXP(VLOOKUP(D11,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089))),(EXP(VLOOKUP(D11+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089))/(1+EXP(VLOOKUP(D11+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089)))+EXP(VLOOKUP(D11-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089))/(1+EXP(VLOOKUP(D11-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D11-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C11)-1)/0.089))))/2))","v":0.47972960225582029},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND((G11*E11-1)>=0.05,K11=1),coeff!$C$5/coeff!$B$5*(G11*E11-1)/(E11-1),0))","v":0},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND((F11*(1-G11)-1)>=0.05,K11=1),coeff!$C$5/coeff!$B$5*(F11*(1-G11)-1)/(F11-1),0))","v":0},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF((G11*E11-1)>0,1000*(G11*E11-1)/(E11-1)*G11*(E11-1)-(1-G11)*1000*(G11*E11-1)/(E11-1),IF(((1-G11)*F11-1)>0,1000*((1-G11)*F11-1)/(F11-1)*(1-G11)*(F11-1)-G11*1000*((1-G11)*F11-1)/(F11-1),0)))","v":1.261394658216151},{"$f":"IF(J11=MAX($J$11:$J$16),1,0)","v":0}]
[null,null,{"$f":"C11","v":0.71299999999999997},-9.5,1.89,2,{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(ISERROR(VLOOKUP(D12,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D12,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089))/(1+EXP(VLOOKUP(D12,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089))),(EXP(VLOOKUP(D12+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089))/(1+EXP(VLOOKUP(D12+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089)))+EXP(VLOOKUP(D12-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089))/(1+EXP(VLOOKUP(D12-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D12-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C12)-1)/0.089))))/2))","v":0.47828081713072385},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND((G12*E12-1)>=0.05,K12=1),coeff!$C$5/coeff!$B$5*(G12*E12-1)/(E12-1),0))","v":0},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND((F12*(1-G12)-1)>=0.05,K12=1),coeff!$C$5/coeff!$B$5*(F12*(1-G12)-1)/(F12-1),0))","v":0},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF((G12*E12-1)>0,1000*(G12*E12-1)/(E12-1)*G12*(E12-1)-(1-G12)*1000*(G12*E12-1)/(E12-1),IF(((1-G12)*F12-1)>0,1000*((1-G12)*F12-1)/(F12-1)*(1-G12)*(F12-1)-G12*1000*((1-G12)*F12-1)/(F12-1),0)))","v":1.8868916180362412},{"$f":"IF(J12=MAX($J$11:$J$16),1,0)","v":0}]
[null,null,{"$f":"C12","v":0.71299999999999997},-10,2.0499999999999998,1.9,{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(ISERROR(VLOOKUP(D13,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D13,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089))/(1+EXP(VLOOKUP(D13,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089))),(EXP(VLOOKUP(D13+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089))/(1+EXP(VLOOKUP(D13+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089)))+EXP(VLOOKUP(D13-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089))/(1+EXP(VLOOKUP(D13-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D13-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C13)-1)/0.089))))/2))","v":0.46391324472855727},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND((G13*E13-1)>=0.05,K13=1),coeff!$C$5/coeff!$B$5*(G13*E13-1)/(E13-1),0))","v":0},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND((F13*(1-G13)-1)>=0.05,K13=1),coeff!$C$5/coeff!$B$5*(F13*(1-G13)-1)/(F13-1),0))","v":0},0.38294788795743528,0]
[null,null,0.71299999999999997,-10.5,2,1.91,{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(ISERROR(VLOOKUP(D14,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D14,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089))/(1+EXP(VLOOKUP(D14,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089))),(EXP(VLOOKUP(D14+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089))/(1+EXP(VLOOKUP(D14+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089)))+EXP(VLOOKUP(D14-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089))/(1+EXP(VLOOKUP(D14-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D14-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C14)-1)/0.089))))/2))","v":0.4495456723263907},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND((G14*E14-1)>=0.05,K14=1),coeff!$C$5/coeff!$B$5*(G14*E14-1)/(E14-1),0))","v":0},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND((F14*(1-G14)-1)>=0.05,K14=1),coeff!$C$5/coeff!$B$5*(F14*(1-G14)-1)/(F14-1),0))","v":0},2.8996124935141161,0]
[null,null,0.71299999999999997,-11,2,1.91,{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(ISERROR(VLOOKUP(D15,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D15,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089))/(1+EXP(VLOOKUP(D15,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089))),(EXP(VLOOKUP(D15+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089))/(1+EXP(VLOOKUP(D15+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089)))+EXP(VLOOKUP(D15-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089))/(1+EXP(VLOOKUP(D15-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D15-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C15)-1)/0.089))))/2))","v":0.44670564695466686},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND((G15*E15-1)>=0.05,K15=1),coeff!$C$5/coeff!$B$5*(G15*E15-1)/(E15-1),0))","v":0},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND((F15*(1-G15)-1)>=0.05,K15=1),coeff!$C$5/coeff!$B$5*(F15*(1-G15)-1)/(F15-1),0))","v":0},3.5443468208583084,0]
[null,null,0.71299999999999997,-11.5,2,1.91,{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(ISERROR(VLOOKUP(D16,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D16,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089))/(1+EXP(VLOOKUP(D16,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089))),(EXP(VLOOKUP(D16+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089))/(1+EXP(VLOOKUP(D16+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089)))+EXP(VLOOKUP(D16-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089))/(1+EXP(VLOOKUP(D16-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D16-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C16)-1)/0.089))))/2))","v":0.44386562158294307},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND((G16*E16-1)>=0.05,K16=1),coeff!$C$5/coeff!$B$5*(G16*E16-1)/(E16-1),0))","v":0},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND((F16*(1-G16)-1)>=0.05,K16=1),coeff!$C$5/coeff!$B$5*(F16*(1-G16)-1)/(F16-1),0))","v":68.369959095141525},4.2537506890709054,1]
[]
["Team1","Team2","PlayerProb","Line","Odds1","Odds2","LineProb","$Bet1","$Bet2","Exp Profit","Max"]
[{"$f":"line!A6","v":0},{"$f":"line!B6","v":0},{"$f":"IF(line!C6=\"\",\"\",line!C6)","v":""},33.5,1.92,1.99,{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(ISERROR(VLOOKUP(D19,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D19,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D19,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C19)-1)/0.089))/(1+EXP(VLOOKUP(D19,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D19,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C19)-1)/0.089))),(EXP(VLOOKUP(D19+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D19+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C19)-1)/0.089))/(1+EXP(VLOOKUP(D19+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D19+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C19)-1)/0.089)))+EXP(VLOOKUP(D19-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D19-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C19)-1)/0.089))/(1+EXP(VLOOKUP(D19-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D19-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C19)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND((G19*E19-1)>=0.05,K19=1),coeff!$C$5/coeff!$B$5*(G19*E19-1)/(E19-1),0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND((F19*(1-G19)-1)>=0.05,K19=1),coeff!$C$5/coeff!$B$5*(F19*(1-G19)-1)/(F19-1),0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF((G19*E19-1)>0,1000*(G19*E19-1)/(E19-1)*G19*(E19-1)-(1-G19)*1000*(G19*E19-1)/(E19-1),IF(((1-G19)*F19-1)>0,1000*((1-G19)*F19-1)/(F19-1)*(1-G19)*(F19-1)-G19*1000*((1-G19)*F19-1)/(F19-1),0)))","v":""},{"$f":"IF(J19=MAX($J$19:$J$24),1,0)","v":0}]
[null,null,{"$f":"C19","v":""},34.5,1.89,2,{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(ISERROR(VLOOKUP(D20,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D20,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D20,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C20)-1)/0.089))/(1+EXP(VLOOKUP(D20,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D20,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C20)-1)/0.089))),(EXP(VLOOKUP(D20+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D20+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C20)-1)/0.089))/(1+EXP(VLOOKUP(D20+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D20+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C20)-1)/0.089)))+EXP(VLOOKUP(D20-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D20-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C20)-1)/0.089))/(1+EXP(VLOOKUP(D20-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D20-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C20)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND((G20*E20-1)>=0.05,K20=1),coeff!$C$5/coeff!$B$5*(G20*E20-1)/(E20-1),0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND((F20*(1-G20)-1)>=0.05,K20=1),coeff!$C$5/coeff!$B$5*(F20*(1-G20)-1)/(F20-1),0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF((G20*E20-1)>0,1000*(G20*E20-1)/(E20-1)*G20*(E20-1)-(1-G20)*1000*(G20*E20-1)/(E20-1),IF(((1-G20)*F20-1)>0,1000*((1-G20)*F20-1)/(F20-1)*(1-G20)*(F20-1)-G20*1000*((1-G20)*F20-1)/(F20-1),0)))","v":""},{"$f":"IF(J20=MAX($J$19:$J$24),1,0)","v":0}]
[null,null,{"$f":"C20","v":""},30.5,2.0499999999999998,1.9,{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(ISERROR(VLOOKUP(D21,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D21,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D21,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C21)-1)/0.089))/(1+EXP(VLOOKUP(D21,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D21,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C21)-1)/0.089))),(EXP(VLOOKUP(D21+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D21+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C21)-1)/0.089))/(1+EXP(VLOOKUP(D21+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D21+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C21)-1)/0.089)))+EXP(VLOOKUP(D21-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D21-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C21)-1)/0.089))/(1+EXP(VLOOKUP(D21-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D21-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C21)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND((G21*E21-1)>=0.05,K21=1),coeff!$C$5/coeff!$B$5*(G21*E21-1)/(E21-1),0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND((F21*(1-G21)-1)>=0.05,K21=1),coeff!$C$5/coeff!$B$5*(F21*(1-G21)-1)/(F21-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(ISERROR(VLOOKUP(D22,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D22,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D22,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C22)-1)/0.089))/(1+EXP(VLOOKUP(D22,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D22,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C22)-1)/0.089))),(EXP(VLOOKUP(D22+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D22+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C22)-1)/0.089))/(1+EXP(VLOOKUP(D22+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D22+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C22)-1)/0.089)))+EXP(VLOOKUP(D22-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D22-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C22)-1)/0.089))/(1+EXP(VLOOKUP(D22-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D22-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C22)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND((G22*E22-1)>=0.05,K22=1),coeff!$C$5/coeff!$B$5*(G22*E22-1)/(E22-1),0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND((F22*(1-G22)-1)>=0.05,K22=1),coeff!$C$5/coeff!$B$5*(F22*(1-G22)-1)/(F22-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(ISERROR(VLOOKUP(D23,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D23,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D23,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C23)-1)/0.089))/(1+EXP(VLOOKUP(D23,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D23,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C23)-1)/0.089))),(EXP(VLOOKUP(D23+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D23+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C23)-1)/0.089))/(1+EXP(VLOOKUP(D23+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D23+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C23)-1)/0.089)))+EXP(VLOOKUP(D23-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D23-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C23)-1)/0.089))/(1+EXP(VLOOKUP(D23-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D23-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C23)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND((G23*E23-1)>=0.05,K23=1),coeff!$C$5/coeff!$B$5*(G23*E23-1)/(E23-1),0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND((F23*(1-G23)-1)>=0.05,K23=1),coeff!$C$5/coeff!$B$5*(F23*(1-G23)-1)/(F23-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(ISERROR(VLOOKUP(D24,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D24,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D24,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C24)-1)/0.089))/(1+EXP(VLOOKUP(D24,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D24,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C24)-1)/0.089))),(EXP(VLOOKUP(D24+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D24+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C24)-1)/0.089))/(1+EXP(VLOOKUP(D24+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D24+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C24)-1)/0.089)))+EXP(VLOOKUP(D24-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D24-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C24)-1)/0.089))/(1+EXP(VLOOKUP(D24-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D24-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C24)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND((G24*E24-1)>=0.05,K24=1),coeff!$C$5/coeff!$B$5*(G24*E24-1)/(E24-1),0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND((F24*(1-G24)-1)>=0.05,K24=1),coeff!$C$5/coeff!$B$5*(F24*(1-G24)-1)/(F24-1),0))","v":""},"",0]
[]
["Team1","Team2","PlayerProb","Line","Odds1","Odds2","LineProb","$Bet1","$Bet2","Exp Profit","Max"]
[{"$f":"line!A7","v":0},{"$f":"line!B7","v":0},{"$f":"IF(line!C7=\"\",\"\",line!C7)","v":""},33.5,1.92,1.99,{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(ISERROR(VLOOKUP(D27,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D27,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D27,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C27)-1)/0.089))/(1+EXP(VLOOKUP(D27,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D27,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C27)-1)/0.089))),(EXP(VLOOKUP(D27+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D27+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C27)-1)/0.089))/(1+EXP(VLOOKUP(D27+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D27+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C27)-1)/0.089)))+EXP(VLOOKUP(D27-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D27-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C27)-1)/0.089))/(1+EXP(VLOOKUP(D27-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D27-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C27)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND((G27*E27-1)>=0.05,K27=1),coeff!$C$5/coeff!$B$5*(G27*E27-1)/(E27-1),0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND((F27*(1-G27)-1)>=0.05,K27=1),coeff!$C$5/coeff!$B$5*(F27*(1-G27)-1)/(F27-1),0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF((G27*E27-1)>0,1000*(G27*E27-1)/(E27-1)*G27*(E27-1)-(1-G27)*1000*(G27*E27-1)/(E27-1),IF(((1-G27)*F27-1)>0,1000*((1-G27)*F27-1)/(F27-1)*(1-G27)*(F27-1)-G27*1000*((1-G27)*F27-1)/(F27-1),0)))","v":""},{"$f":"IF(J27=MAX($J$27:$J$32),1,0)","v":0}]
[null,null,{"$f":"C27","v":""},34.5,1.89,2,{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(ISERROR(VLOOKUP(D28,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D28,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D28,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C28)-1)/0.089))/(1+EXP(VLOOKUP(D28,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D28,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C28)-1)/0.089))),(EXP(VLOOKUP(D28+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D28+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C28)-1)/0.089))/(1+EXP(VLOOKUP(D28+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D28+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C28)-1)/0.089)))+EXP(VLOOKUP(D28-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D28-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C28)-1)/0.089))/(1+EXP(VLOOKUP(D28-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D28-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C28)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND((G28*E28-1)>=0.05,K28=1),coeff!$C$5/coeff!$B$5*(G28*E28-1)/(E28-1),0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND((F28*(1-G28)-1)>=0.05,K28=1),coeff!$C$5/coeff!$B$5*(F28*(1-G28)-1)/(F28-1),0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF((G28*E28-1)>0,1000*(G28*E28-1)/(E28-1)*G28*(E28-1)-(1-G28)*1000*(G28*E28-1)/(E28-1),IF(((1-G28)*F28-1)>0,1000*((1-G28)*F28-1)/(F28-1)*(1-G28)*(F28-1)-G28*1000*((1-G28)*F28-1)/(F28-1),0)))","v":""},{"$f":"IF(J28=MAX($J$27:$J$32),1,0)","v":0}]
[null,null,{"$f":"C28","v":""},30.5,2.0499999999999998,1.9,{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(ISERROR(VLOOKUP(D29,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D29,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D29,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C29)-1)/0.089))/(1+EXP(VLOOKUP(D29,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D29,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C29)-1)/0.089))),(EXP(VLOOKUP(D29+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D29+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C29)-1)/0.089))/(1+EXP(VLOOKUP(D29+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D29+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C29)-1)/0.089)))+EXP(VLOOKUP(D29-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D29-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C29)-1)/0.089))/(1+EXP(VLOOKUP(D29-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D29-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C29)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND((G29*E29-1)>=0.05,K29=1),coeff!$C$5/coeff!$B$5*(G29*E29-1)/(E29-1),0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND((F29*(1-G29)-1)>=0.05,K29=1),coeff!$C$5/coeff!$B$5*(F29*(1-G29)-1)/(F29-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(ISERROR(VLOOKUP(D30,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D30,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D30,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C30)-1)/0.089))/(1+EXP(VLOOKUP(D30,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D30,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C30)-1)/0.089))),(EXP(VLOOKUP(D30+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D30+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C30)-1)/0.089))/(1+EXP(VLOOKUP(D30+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D30+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C30)-1)/0.089)))+EXP(VLOOKUP(D30-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D30-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C30)-1)/0.089))/(1+EXP(VLOOKUP(D30-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D30-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C30)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND((G30*E30-1)>=0.05,K30=1),coeff!$C$5/coeff!$B$5*(G30*E30-1)/(E30-1),0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND((F30*(1-G30)-1)>=0.05,K30=1),coeff!$C$5/coeff!$B$5*(F30*(1-G30)-1)/(F30-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(ISERROR(VLOOKUP(D31,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D31,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D31,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C31)-1)/0.089))/(1+EXP(VLOOKUP(D31,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D31,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C31)-1)/0.089))),(EXP(VLOOKUP(D31+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D31+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C31)-1)/0.089))/(1+EXP(VLOOKUP(D31+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D31+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C31)-1)/0.089)))+EXP(VLOOKUP(D31-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D31-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C31)-1)/0.089))/(1+EXP(VLOOKUP(D31-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D31-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C31)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND((G31*E31-1)>=0.05,K31=1),coeff!$C$5/coeff!$B$5*(G31*E31-1)/(E31-1),0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND((F31*(1-G31)-1)>=0.05,K31=1),coeff!$C$5/coeff!$B$5*(F31*(1-G31)-1)/(F31-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(ISERROR(VLOOKUP(D32,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D32,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D32,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C32)-1)/0.089))/(1+EXP(VLOOKUP(D32,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D32,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C32)-1)/0.089))),(EXP(VLOOKUP(D32+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D32+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C32)-1)/0.089))/(1+EXP(VLOOKUP(D32+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D32+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C32)-1)/0.089)))+EXP(VLOOKUP(D32-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D32-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C32)-1)/0.089))/(1+EXP(VLOOKUP(D32-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D32-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C32)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND((G32*E32-1)>=0.05,K32=1),coeff!$C$5/coeff!$B$5*(G32*E32-1)/(E32-1),0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND((F32*(1-G32)-1)>=0.05,K32=1),coeff!$C$5/coeff!$B$5*(F32*(1-G32)-1)/(F32-1),0))","v":""},"",0]
[]
["Team1","Team2","PlayerProb","Line","Odds1","Odds2","LineProb","$Bet1","$Bet2","Exp Profit","Max"]
[{"$f":"line!A8","v":0},{"$f":"line!B8","v":0},{"$f":"IF(line!C8=\"\",\"\",line!C8)","v":""},33.5,1.92,1.99,{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(ISERROR(VLOOKUP(D35,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D35,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D35,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C35)-1)/0.089))/(1+EXP(VLOOKUP(D35,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D35,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C35)-1)/0.089))),(EXP(VLOOKUP(D35+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D35+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C35)-1)/0.089))/(1+EXP(VLOOKUP(D35+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D35+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C35)-1)/0.089)))+EXP(VLOOKUP(D35-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D35-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C35)-1)/0.089))/(1+EXP(VLOOKUP(D35-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D35-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C35)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND((G35*E35-1)>=0.05,K35=1),coeff!$C$5/coeff!$B$5*(G35*E35-1)/(E35-1),0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND((F35*(1-G35)-1)>=0.05,K35=1),coeff!$C$5/coeff!$B$5*(F35*(1-G35)-1)/(F35-1),0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF((G35*E35-1)>0,1000*(G35*E35-1)/(E35-1)*G35*(E35-1)-(1-G35)*1000*(G35*E35-1)/(E35-1),IF(((1-G35)*F35-1)>0,1000*((1-G35)*F35-1)/(F35-1)*(1-G35)*(F35-1)-G35*1000*((1-G35)*F35-1)/(F35-1),0)))","v":""},{"$f":"IF(J35=MAX($J$35:$J$40),1,0)","v":0}]
[null,null,{"$f":"C35","v":""},34.5,1.89,2,{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(ISERROR(VLOOKUP(D36,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D36,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D36,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C36)-1)/0.089))/(1+EXP(VLOOKUP(D36,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D36,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C36)-1)/0.089))),(EXP(VLOOKUP(D36+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D36+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C36)-1)/0.089))/(1+EXP(VLOOKUP(D36+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D36+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C36)-1)/0.089)))+EXP(VLOOKUP(D36-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D36-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C36)-1)/0.089))/(1+EXP(VLOOKUP(D36-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D36-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C36)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND((G36*E36-1)>=0.05,K36=1),coeff!$C$5/coeff!$B$5*(G36*E36-1)/(E36-1),0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND((F36*(1-G36)-1)>=0.05,K36=1),coeff!$C$5/coeff!$B$5*(F36*(1-G36)-1)/(F36-1),0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF((G36*E36-1)>0,1000*(G36*E36-1)/(E36-1)*G36*(E36-1)-(1-G36)*1000*(G36*E36-1)/(E36-1),IF(((1-G36)*F36-1)>0,1000*((1-G36)*F36-1)/(F36-1)*(1-G36)*(F36-1)-G36*1000*((1-G36)*F36-1)/(F36-1),0)))","v":""},{"$f":"IF(J36=MAX($J$35:$J$40),1,0)","v":0}]
[null,null,{"$f":"C36","v":""},30.5,2.0499999999999998,1.9,{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(ISERROR(VLOOKUP(D37,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D37,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D37,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C37)-1)/0.089))/(1+EXP(VLOOKUP(D37,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D37,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C37)-1)/0.089))),(EXP(VLOOKUP(D37+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D37+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C37)-1)/0.089))/(1+EXP(VLOOKUP(D37+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D37+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C37)-1)/0.089)))+EXP(VLOOKUP(D37-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D37-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C37)-1)/0.089))/(1+EXP(VLOOKUP(D37-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D37-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C37)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND((G37*E37-1)>=0.05,K37=1),coeff!$C$5/coeff!$B$5*(G37*E37-1)/(E37-1),0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND((F37*(1-G37)-1)>=0.05,K37=1),coeff!$C$5/coeff!$B$5*(F37*(1-G37)-1)/(F37-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(ISERROR(VLOOKUP(D38,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D38,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D38,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C38)-1)/0.089))/(1+EXP(VLOOKUP(D38,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D38,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C38)-1)/0.089))),(EXP(VLOOKUP(D38+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D38+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C38)-1)/0.089))/(1+EXP(VLOOKUP(D38+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D38+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C38)-1)/0.089)))+EXP(VLOOKUP(D38-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D38-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C38)-1)/0.089))/(1+EXP(VLOOKUP(D38-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D38-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C38)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND((G38*E38-1)>=0.05,K38=1),coeff!$C$5/coeff!$B$5*(G38*E38-1)/(E38-1),0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND((F38*(1-G38)-1)>=0.05,K38=1),coeff!$C$5/coeff!$B$5*(F38*(1-G38)-1)/(F38-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(ISERROR(VLOOKUP(D39,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D39,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D39,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C39)-1)/0.089))/(1+EXP(VLOOKUP(D39,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D39,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C39)-1)/0.089))),(EXP(VLOOKUP(D39+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D39+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C39)-1)/0.089))/(1+EXP(VLOOKUP(D39+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D39+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C39)-1)/0.089)))+EXP(VLOOKUP(D39-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D39-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C39)-1)/0.089))/(1+EXP(VLOOKUP(D39-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D39-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C39)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND((G39*E39-1)>=0.05,K39=1),coeff!$C$5/coeff!$B$5*(G39*E39-1)/(E39-1),0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND((F39*(1-G39)-1)>=0.05,K39=1),coeff!$C$5/coeff!$B$5*(F39*(1-G39)-1)/(F39-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(ISERROR(VLOOKUP(D40,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D40,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D40,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C40)-1)/0.089))/(1+EXP(VLOOKUP(D40,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D40,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C40)-1)/0.089))),(EXP(VLOOKUP(D40+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D40+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C40)-1)/0.089))/(1+EXP(VLOOKUP(D40+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D40+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C40)-1)/0.089)))+EXP(VLOOKUP(D40-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D40-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C40)-1)/0.089))/(1+EXP(VLOOKUP(D40-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D40-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C40)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND((G40*E40-1)>=0.05,K40=1),coeff!$C$5/coeff!$B$5*(G40*E40-1)/(E40-1),0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND((F40*(1-G40)-1)>=0.05,K40=1),coeff!$C$5/coeff!$B$5*(F40*(1-G40)-1)/(F40-1),0))","v":""},"",0]
[]
["Team1","Team2","PlayerProb","Line","Odds1","Odds2","LineProb","$Bet1","$Bet2","Exp Profit","Max"]
[{"$f":"line!A9","v":0},{"$f":"line!B9","v":0},{"$f":"IF(line!C9=\"\",\"\",line!C9)","v":""},33.5,1.92,1.99,{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(ISERROR(VLOOKUP(D43,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D43,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D43,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C43)-1)/0.089))/(1+EXP(VLOOKUP(D43,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D43,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C43)-1)/0.089))),(EXP(VLOOKUP(D43+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D43+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C43)-1)/0.089))/(1+EXP(VLOOKUP(D43+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D43+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C43)-1)/0.089)))+EXP(VLOOKUP(D43-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D43-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C43)-1)/0.089))/(1+EXP(VLOOKUP(D43-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D43-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C43)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND((G43*E43-1)>=0.05,K43=1),coeff!$C$5/coeff!$B$5*(G43*E43-1)/(E43-1),0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND((F43*(1-G43)-1)>=0.05,K43=1),coeff!$C$5/coeff!$B$5*(F43*(1-G43)-1)/(F43-1),0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF((G43*E43-1)>0,1000*(G43*E43-1)/(E43-1)*G43*(E43-1)-(1-G43)*1000*(G43*E43-1)/(E43-1),IF(((1-G43)*F43-1)>0,1000*((1-G43)*F43-1)/(F43-1)*(1-G43)*(F43-1)-G43*1000*((1-G43)*F43-1)/(F43-1),0)))","v":""},{"$f":"IF(J43=MAX($J$43:$J$48),1,0)","v":0}]
[null,null,{"$f":"C43","v":""},34.5,1.89,2,{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(ISERROR(VLOOKUP(D44,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D44,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D44,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C44)-1)/0.089))/(1+EXP(VLOOKUP(D44,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D44,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C44)-1)/0.089))),(EXP(VLOOKUP(D44+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D44+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C44)-1)/0.089))/(1+EXP(VLOOKUP(D44+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D44+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C44)-1)/0.089)))+EXP(VLOOKUP(D44-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D44-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C44)-1)/0.089))/(1+EXP(VLOOKUP(D44-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D44-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C44)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND((G44*E44-1)>=0.05,K44=1),coeff!$C$5/coeff!$B$5*(G44*E44-1)/(E44-1),0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND((F44*(1-G44)-1)>=0.05,K44=1),coeff!$C$5/coeff!$B$5*(F44*(1-G44)-1)/(F44-1),0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF((G44*E44-1)>0,1000*(G44*E44-1)/(E44-1)*G44*(E44-1)-(1-G44)*1000*(G44*E44-1)/(E44-1),IF(((1-G44)*F44-1)>0,1000*((1-G44)*F44-1)/(F44-1)*(1-G44)*(F44-1)-G44*1000*((1-G44)*F44-1)/(F44-1),0)))","v":""},{"$f":"IF(J44=MAX($J$43:$J$48),1,0)","v":0}]
[null,null,{"$f":"C44","v":""},30.5,2.0499999999999998,1.9,{"$f":"IF(OR(C45=\"\",D45=\"\"),\"\",IF(ISERROR(VLOOKUP(D45,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D45,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D45,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C45)-1)/0.089))/(1+EXP(VLOOKUP(D45,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D45,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C45)-1)/0.089))),(EXP(VLOOKUP(D45+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D45+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C45)-1)/0.089))/(1+EXP(VLOOKUP(D45+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D45+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C45)-1)/0.089)))+EXP(VLOOKUP(D45-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D45-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C45)-1)/0.089))/(1+EXP(VLOOKUP(D45-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D45-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C45)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C45=\"\",D45=\"\"),\"\",IF(AND((G45*E45-1)>=0.05,K45=1),coeff!$C$5/coeff!$B$5*(G45*E45-1)/(E45-1),0))","v":""},{"$f":"IF(OR(C45=\"\",D45=\"\"),\"\",IF(AND((F45*(1-G45)-1)>=0.05,K45=1),coeff!$C$5/coeff!$B$5*(F45*(1-G45)-1)/(F45-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C46=\"\",D46=\"\"),\"\",IF(ISERROR(VLOOKUP(D46,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D46,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D46,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C46)-1)/0.089))/(1+EXP(VLOOKUP(D46,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D46,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C46)-1)/0.089))),(EXP(VLOOKUP(D46+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D46+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C46)-1)/0.089))/(1+EXP(VLOOKUP(D46+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D46+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C46)-1)/0.089)))+EXP(VLOOKUP(D46-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D46-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C46)-1)/0.089))/(1+EXP(VLOOKUP(D46-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D46-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C46)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C46=\"\",D46=\"\"),\"\",IF(AND((G46*E46-1)>=0.05,K46=1),coeff!$C$5/coeff!$B$5*(G46*E46-1)/(E46-1),0))","v":""},{"$f":"IF(OR(C46=\"\",D46=\"\"),\"\",IF(AND((F46*(1-G46)-1)>=0.05,K46=1),coeff!$C$5/coeff!$B$5*(F46*(1-G46)-1)/(F46-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C47=\"\",D47=\"\"),\"\",IF(ISERROR(VLOOKUP(D47,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D47,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D47,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C47)-1)/0.089))/(1+EXP(VLOOKUP(D47,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D47,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C47)-1)/0.089))),(EXP(VLOOKUP(D47+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D47+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C47)-1)/0.089))/(1+EXP(VLOOKUP(D47+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D47+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C47)-1)/0.089)))+EXP(VLOOKUP(D47-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D47-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C47)-1)/0.089))/(1+EXP(VLOOKUP(D47-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D47-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C47)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C47=\"\",D47=\"\"),\"\",IF(AND((G47*E47-1)>=0.05,K47=1),coeff!$C$5/coeff!$B$5*(G47*E47-1)/(E47-1),0))","v":""},{"$f":"IF(OR(C47=\"\",D47=\"\"),\"\",IF(AND((F47*(1-G47)-1)>=0.05,K47=1),coeff!$C$5/coeff!$B$5*(F47*(1-G47)-1)/(F47-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C48=\"\",D48=\"\"),\"\",IF(ISERROR(VLOOKUP(D48,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D48,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D48,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C48)-1)/0.089))/(1+EXP(VLOOKUP(D48,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D48,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C48)-1)/0.089))),(EXP(VLOOKUP(D48+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D48+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C48)-1)/0.089))/(1+EXP(VLOOKUP(D48+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D48+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C48)-1)/0.089)))+EXP(VLOOKUP(D48-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D48-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C48)-1)/0.089))/(1+EXP(VLOOKUP(D48-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D48-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C48)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C48=\"\",D48=\"\"),\"\",IF(AND((G48*E48-1)>=0.05,K48=1),coeff!$C$5/coeff!$B$5*(G48*E48-1)/(E48-1),0))","v":""},{"$f":"IF(OR(C48=\"\",D48=\"\"),\"\",IF(AND((F48*(1-G48)-1)>=0.05,K48=1),coeff!$C$5/coeff!$B$5*(F48*(1-G48)-1)/(F48-1),0))","v":""},"",0]
[]
["Team1","Team2","PlayerProb","Line","Odds1","Odds2","LineProb","$Bet1","$Bet2","Exp Profit","Max"]
[{"$f":"line!A10","v":0},{"$f":"line!B10","v":0},{"$f":"IF(line!C10=\"\",\"\",line!C10)","v":""},33.5,1.92,1.99,{"$f":"IF(OR(C51=\"\",D51=\"\"),\"\",IF(ISERROR(VLOOKUP(D51,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D51,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D51,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C51)-1)/0.089))/(1+EXP(VLOOKUP(D51,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D51,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C51)-1)/0.089))),(EXP(VLOOKUP(D51+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D51+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C51)-1)/0.089))/(1+EXP(VLOOKUP(D51+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D51+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C51)-1)/0.089)))+EXP(VLOOKUP(D51-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D51-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C51)-1)/0.089))/(1+EXP(VLOOKUP(D51-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D51-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C51)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C51=\"\",D51=\"\"),\"\",IF(AND((G51*E51-1)>=0.05,K51=1),coeff!$C$5/coeff!$B$5*(G51*E51-1)/(E51-1),0))","v":""},{"$f":"IF(OR(C51=\"\",D51=\"\"),\"\",IF(AND((F51*(1-G51)-1)>=0.05,K51=1),coeff!$C$5/coeff!$B$5*(F51*(1-G51)-1)/(F51-1),0))","v":""},{"$f":"IF(OR(C51=\"\",D51=\"\"),\"\",IF((G51*E51-1)>0,1000*(G51*E51-1)/(E51-1)*G51*(E51-1)-(1-G51)*1000*(G51*E51-1)/(E51-1),IF(((1-G51)*F51-1)>0,1000*((1-G51)*F51-1)/(F51-1)*(1-G51)*(F51-1)-G51*1000*((1-G51)*F51-1)/(F51-1),0)))","v":""},{"$f":"IF(J51=MAX($J$51:$J$56),1,0)","v":0}]
[null,null,{"$f":"C51","v":""},34.5,1.89,2,{"$f":"IF(OR(C52=\"\",D52=\"\"),\"\",IF(ISERROR(VLOOKUP(D52,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D52,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D52,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C52)-1)/0.089))/(1+EXP(VLOOKUP(D52,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D52,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C52)-1)/0.089))),(EXP(VLOOKUP(D52+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D52+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C52)-1)/0.089))/(1+EXP(VLOOKUP(D52+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D52+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C52)-1)/0.089)))+EXP(VLOOKUP(D52-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D52-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C52)-1)/0.089))/(1+EXP(VLOOKUP(D52-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D52-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C52)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C52=\"\",D52=\"\"),\"\",IF(AND((G52*E52-1)>=0.05,K52=1),coeff!$C$5/coeff!$B$5*(G52*E52-1)/(E52-1),0))","v":""},{"$f":"IF(OR(C52=\"\",D52=\"\"),\"\",IF(AND((F52*(1-G52)-1)>=0.05,K52=1),coeff!$C$5/coeff!$B$5*(F52*(1-G52)-1)/(F52-1),0))","v":""},{"$f":"IF(OR(C52=\"\",D52=\"\"),\"\",IF((G52*E52-1)>0,1000*(G52*E52-1)/(E52-1)*G52*(E52-1)-(1-G52)*1000*(G52*E52-1)/(E52-1),IF(((1-G52)*F52-1)>0,1000*((1-G52)*F52-1)/(F52-1)*(1-G52)*(F52-1)-G52*1000*((1-G52)*F52-1)/(F52-1),0)))","v":""},{"$f":"IF(J52=MAX($J$51:$J$56),1,0)","v":0}]
[null,null,{"$f":"C52","v":""},30.5,2.0499999999999998,1.9,{"$f":"IF(OR(C53=\"\",D53=\"\"),\"\",IF(ISERROR(VLOOKUP(D53,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D53,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D53,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C53)-1)/0.089))/(1+EXP(VLOOKUP(D53,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D53,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C53)-1)/0.089))),(EXP(VLOOKUP(D53+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D53+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C53)-1)/0.089))/(1+EXP(VLOOKUP(D53+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D53+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C53)-1)/0.089)))+EXP(VLOOKUP(D53-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D53-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C53)-1)/0.089))/(1+EXP(VLOOKUP(D53-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D53-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C53)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C53=\"\",D53=\"\"),\"\",IF(AND((G53*E53-1)>=0.05,K53=1),coeff!$C$5/coeff!$B$5*(G53*E53-1)/(E53-1),0))","v":""},{"$f":"IF(OR(C53=\"\",D53=\"\"),\"\",IF(AND((F53*(1-G53)-1)>=0.05,K53=1),coeff!$C$5/coeff!$B$5*(F53*(1-G53)-1)/(F53-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C54=\"\",D54=\"\"),\"\",IF(ISERROR(VLOOKUP(D54,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D54,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D54,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C54)-1)/0.089))/(1+EXP(VLOOKUP(D54,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D54,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C54)-1)/0.089))),(EXP(VLOOKUP(D54+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D54+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C54)-1)/0.089))/(1+EXP(VLOOKUP(D54+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D54+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C54)-1)/0.089)))+EXP(VLOOKUP(D54-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D54-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C54)-1)/0.089))/(1+EXP(VLOOKUP(D54-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D54-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C54)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C54=\"\",D54=\"\"),\"\",IF(AND((G54*E54-1)>=0.05,K54=1),coeff!$C$5/coeff!$B$5*(G54*E54-1)/(E54-1),0))","v":""},{"$f":"IF(OR(C54=\"\",D54=\"\"),\"\",IF(AND((F54*(1-G54)-1)>=0.05,K54=1),coeff!$C$5/coeff!$B$5*(F54*(1-G54)-1)/(F54-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C55=\"\",D55=\"\"),\"\",IF(ISERROR(VLOOKUP(D55,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D55,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D55,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C55)-1)/0.089))/(1+EXP(VLOOKUP(D55,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D55,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C55)-1)/0.089))),(EXP(VLOOKUP(D55+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D55+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C55)-1)/0.089))/(1+EXP(VLOOKUP(D55+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D55+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C55)-1)/0.089)))+EXP(VLOOKUP(D55-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D55-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C55)-1)/0.089))/(1+EXP(VLOOKUP(D55-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D55-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C55)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C55=\"\",D55=\"\"),\"\",IF(AND((G55*E55-1)>=0.05,K55=1),coeff!$C$5/coeff!$B$5*(G55*E55-1)/(E55-1),0))","v":""},{"$f":"IF(OR(C55=\"\",D55=\"\"),\"\",IF(AND((F55*(1-G55)-1)>=0.05,K55=1),coeff!$C$5/coeff!$B$5*(F55*(1-G55)-1)/(F55-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C56=\"\",D56=\"\"),\"\",IF(ISERROR(VLOOKUP(D56,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D56,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D56,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C56)-1)/0.089))/(1+EXP(VLOOKUP(D56,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D56,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C56)-1)/0.089))),(EXP(VLOOKUP(D56+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D56+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C56)-1)/0.089))/(1+EXP(VLOOKUP(D56+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D56+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C56)-1)/0.089)))+EXP(VLOOKUP(D56-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D56-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C56)-1)/0.089))/(1+EXP(VLOOKUP(D56-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D56-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C56)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C56=\"\",D56=\"\"),\"\",IF(AND((G56*E56-1)>=0.05,K56=1),coeff!$C$5/coeff!$B$5*(G56*E56-1)/(E56-1),0))","v":""},{"$f":"IF(OR(C56=\"\",D56=\"\"),\"\",IF(AND((F56*(1-G56)-1)>=0.05,K56=1),coeff!$C$5/coeff!$B$5*(F56*(1-G56)-1)/(F56-1),0))","v":""},"",0]
[]
["Team1","Team2","PlayerProb","Line","Odds1","Odds2","LineProb","$Bet1","$Bet2","Exp Profit","Max"]
[{"$f":"line!A11","v":0},{"$f":"line!B11","v":0},{"$f":"IF(line!C11=\"\",\"\",line!C11)","v":""},33.5,1.92,1.99,{"$f":"IF(OR(C59=\"\",D59=\"\"),\"\",IF(ISERROR(VLOOKUP(D59,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D59,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D59,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C59)-1)/0.089))/(1+EXP(VLOOKUP(D59,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D59,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C59)-1)/0.089))),(EXP(VLOOKUP(D59+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D59+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C59)-1)/0.089))/(1+EXP(VLOOKUP(D59+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D59+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C59)-1)/0.089)))+EXP(VLOOKUP(D59-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D59-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C59)-1)/0.089))/(1+EXP(VLOOKUP(D59-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D59-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C59)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C59=\"\",D59=\"\"),\"\",IF(AND((G59*E59-1)>=0.05,K59=1),coeff!$C$5/coeff!$B$5*(G59*E59-1)/(E59-1),0))","v":""},{"$f":"IF(OR(C59=\"\",D59=\"\"),\"\",IF(AND((F59*(1-G59)-1)>=0.05,K59=1),coeff!$C$5/coeff!$B$5*(F59*(1-G59)-1)/(F59-1),0))","v":""},{"$f":"IF(OR(C59=\"\",D59=\"\"),\"\",IF((G59*E59-1)>0,1000*(G59*E59-1)/(E59-1)*G59*(E59-1)-(1-G59)*1000*(G59*E59-1)/(E59-1),IF(((1-G59)*F59-1)>0,1000*((1-G59)*F59-1)/(F59-1)*(1-G59)*(F59-1)-G59*1000*((1-G59)*F59-1)/(F59-1),0)))","v":""},{"$f":"IF(J59=MAX($J$59:$J$64),1,0)","v":0}]
[null,null,{"$f":"C59","v":""},34.5,1.89,2,{"$f":"IF(OR(C60=\"\",D60=\"\"),\"\",IF(ISERROR(VLOOKUP(D60,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D60,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D60,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C60)-1)/0.089))/(1+EXP(VLOOKUP(D60,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D60,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C60)-1)/0.089))),(EXP(VLOOKUP(D60+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D60+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C60)-1)/0.089))/(1+EXP(VLOOKUP(D60+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D60+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C60)-1)/0.089)))+EXP(VLOOKUP(D60-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D60-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C60)-1)/0.089))/(1+EXP(VLOOKUP(D60-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D60-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C60)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C60=\"\",D60=\"\"),\"\",IF(AND((G60*E60-1)>=0.05,K60=1),coeff!$C$5/coeff!$B$5*(G60*E60-1)/(E60-1),0))","v":""},{"$f":"IF(OR(C60=\"\",D60=\"\"),\"\",IF(AND((F60*(1-G60)-1)>=0.05,K60=1),coeff!$C$5/coeff!$B$5*(F60*(1-G60)-1)/(F60-1),0))","v":""},{"$f":"IF(OR(C60=\"\",D60=\"\"),\"\",IF((G60*E60-1)>0,1000*(G60*E60-1)/(E60-1)*G60*(E60-1)-(1-G60)*1000*(G60*E60-1)/(E60-1),IF(((1-G60)*F60-1)>0,1000*((1-G60)*F60-1)/(F60-1)*(1-G60)*(F60-1)-G60*1000*((1-G60)*F60-1)/(F60-1),0)))","v":""},{"$f":"IF(J60=MAX($J$59:$J$64),1,0)","v":0}]
[null,null,{"$f":"C60","v":""},30.5,2.0499999999999998,1.9,{"$f":"IF(OR(C61=\"\",D61=\"\"),\"\",IF(ISERROR(VLOOKUP(D61,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D61,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D61,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C61)-1)/0.089))/(1+EXP(VLOOKUP(D61,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D61,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C61)-1)/0.089))),(EXP(VLOOKUP(D61+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D61+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C61)-1)/0.089))/(1+EXP(VLOOKUP(D61+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D61+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C61)-1)/0.089)))+EXP(VLOOKUP(D61-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D61-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C61)-1)/0.089))/(1+EXP(VLOOKUP(D61-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D61-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C61)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C61=\"\",D61=\"\"),\"\",IF(AND((G61*E61-1)>=0.05,K61=1),coeff!$C$5/coeff!$B$5*(G61*E61-1)/(E61-1),0))","v":""},{"$f":"IF(OR(C61=\"\",D61=\"\"),\"\",IF(AND((F61*(1-G61)-1)>=0.05,K61=1),coeff!$C$5/coeff!$B$5*(F61*(1-G61)-1)/(F61-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C62=\"\",D62=\"\"),\"\",IF(ISERROR(VLOOKUP(D62,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D62,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D62,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C62)-1)/0.089))/(1+EXP(VLOOKUP(D62,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D62,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C62)-1)/0.089))),(EXP(VLOOKUP(D62+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D62+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C62)-1)/0.089))/(1+EXP(VLOOKUP(D62+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D62+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C62)-1)/0.089)))+EXP(VLOOKUP(D62-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D62-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C62)-1)/0.089))/(1+EXP(VLOOKUP(D62-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D62-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C62)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C62=\"\",D62=\"\"),\"\",IF(AND((G62*E62-1)>=0.05,K62=1),coeff!$C$5/coeff!$B$5*(G62*E62-1)/(E62-1),0))","v":""},{"$f":"IF(OR(C62=\"\",D62=\"\"),\"\",IF(AND((F62*(1-G62)-1)>=0.05,K62=1),coeff!$C$5/coeff!$B$5*(F62*(1-G62)-1)/(F62-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C63=\"\",D63=\"\"),\"\",IF(ISERROR(VLOOKUP(D63,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D63,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D63,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C63)-1)/0.089))/(1+EXP(VLOOKUP(D63,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D63,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C63)-1)/0.089))),(EXP(VLOOKUP(D63+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D63+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C63)-1)/0.089))/(1+EXP(VLOOKUP(D63+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D63+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C63)-1)/0.089)))+EXP(VLOOKUP(D63-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D63-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C63)-1)/0.089))/(1+EXP(VLOOKUP(D63-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D63-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C63)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C63=\"\",D63=\"\"),\"\",IF(AND((G63*E63-1)>=0.05,K63=1),coeff!$C$5/coeff!$B$5*(G63*E63-1)/(E63-1),0))","v":""},{"$f":"IF(OR(C63=\"\",D63=\"\"),\"\",IF(AND((F63*(1-G63)-1)>=0.05,K63=1),coeff!$C$5/coeff!$B$5*(F63*(1-G63)-1)/(F63-1),0))","v":""},"",0]
[null,null,"",31.5,2,1.91,{"$f":"IF(OR(C64=\"\",D64=\"\"),\"\",IF(ISERROR(VLOOKUP(D64,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(D64,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D64,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C64)-1)/0.089))/(1+EXP(VLOOKUP(D64,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D64,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C64)-1)/0.089))),(EXP(VLOOKUP(D64+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D64+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C64)-1)/0.089))/(1+EXP(VLOOKUP(D64+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D64+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C64)-1)/0.089)))+EXP(VLOOKUP(D64-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D64-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C64)-1)/0.089))/(1+EXP(VLOOKUP(D64-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(D64-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-C64)-1)/0.089))))/2))","v":""},{"$f":"IF(OR(C64=\"\",D64=\"\"),\"\",IF(AND((G64*E64-1)>=0.05,K64=1),coeff!$C$5/coeff!$B$5*(G64*E64-1)/(E64-1),0))","v":""},{"$f":"IF(OR(C64=\"\",D64=\"\"),\"\",IF(AND((F64*(1-G64)-1)>=0.05,K64=1),coeff!$C$5/coeff!$B$5*(F64*(1-G64)-1)/(F64-1),0))","v":""},"",0]

{"sheet":"totals","index":4,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Team1","Team2","TotalLine","OddsOver","OddsUnder","ProbOver","$BetOver","$BetUnder","Overlay"]
["Penrith","Canterbury",4.5,1.77,2.11,{"$f":"IF(C4=\"\",\"\",IF(ISERROR(VLOOKUP(C4,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(C4,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C4,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089))/(1+EXP(VLOOKUP(C4,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C4,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089))),(EXP(VLOOKUP(C4+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C4+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089))/(1+EXP(VLOOKUP(C4+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C4+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089)))+EXP(VLOOKUP(C4-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C4-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089))/(1+EXP(VLOOKUP(C4-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C4-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089))))/2))","v":{"$error":"#REF!"}},{"$f":"IF(C4=\"\",\"\",IF((F4*D4-1)>=0.05,coeff!$C$5/coeff!$B$5*(F4*D4-1)/(D4-1),0))","v":{"$error":"#REF!"}},{"$f":"IF(C4=\"\",\"\",IF((E4*(1-F4)-1)>=0.05,coeff!$C$5/coeff!$B$5*(E4*(1-F4)-1)/(E4-1),0))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",IF(G4>0,D4*F4-1,IF(H4>0,E4*(1-F4)-1,\"\")))","v":{"$error":"#REF!"}}]
["Brisbane","New Zealand",-9.5,1.93,1.93,{"$f":"IF(C5=\"\",\"\",IF(ISERROR(VLOOKUP(C5,coeff!$F$3:$H$74,2,FALSE))=FALSE,EXP(VLOOKUP(C5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089))/(1+EXP(VLOOKUP(C5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089))),(EXP(VLOOKUP(C5+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C5+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089))/(1+EXP(VLOOKUP(C5+0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C5+0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089)))+EXP(VLOOKUP(C5-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C5-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089))/(1+EXP(VLOOKUP(C5-0.5,coeff!$F$3:$H$74,2,FALSE)+VLOOKUP(C5-0.5,coeff!$F$3:$H$74,3,FALSE)*(LN(1/(1-#REF!)-1)/0.089))))/2))","v":{"$error":"#REF!"}},{"$f":"IF(C5=\"\",\"\",IF((F5*D5-1)>=0.05,coeff!$C$5/coeff!$B$5*(F5*D5-1)/(D5-1),0))","v":{"$error":"#REF!"}},{"$f":"IF(C5=\"\",\"\",IF((E5*(1-F5)-1)>=0.05,coeff!$C$5/coeff!$B$5*(E5*(1-F5)-1)/(E5-1),0))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",IF(G5>0,D5*F5-1,IF(H5>0,E5*(1-F5)-1,\"\")))","v":{"$error":"#REF!"}}]

{"sheet":"futures","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Sportpunter's NRL Betting Predictions as at 10/03/2016"]
[]
["Team","P(Prem)","P(Finals)","P(Spoon)"]
["South Sydney Rabbitohs",0.11799999999999999,0.74099999999999999,1.2999999999999999E-2]
["Canterbury Bulldogs",9.0999999999999998E-2,0.66700000000000004,1.4999999999999999E-2]
["Gold Coast Titans",2.1000000000000001E-2,0.35699999999999998,9.0999999999999998E-2]
["Brisbane Broncos",0.14899999999999999,0.79400000000000004,2E-3]
["Canberra Raiders",3.7999999999999999E-2,0.47599999999999998,0.05]
["Wests Tigers",2.8000000000000001E-2,0.37,6.9000000000000006E-2]
["North Queensland Cowboys",0.14099999999999999,0.78100000000000003,6.0000000000000001E-3]
["Melbourne Storm",9.5000000000000001E-2,0.71399999999999997,1.4999999999999999E-2]
["St. George Illawarra Dragons",4.2000000000000003E-2,0.41699999999999998,0.08]
["Cronulla Sharks",3.5999999999999997E-2,0.38500000000000001,7.3999999999999996E-2]
["New Zealand Warriors",1.4999999999999999E-2,0.30299999999999999,0.123]
["Penrith Panthers",2.5999999999999999E-2,0.37,9.0999999999999998E-2]
["Parramatta Eels",1.2999999999999999E-2,0.23799999999999999,0.161]
["Newcastle Knights",2.1999999999999999E-2,0.24399999999999999,0.159]
["Manly Sea Eagles",4.2000000000000003E-2,0.47599999999999998,3.5999999999999997E-2]
["Sydney Roosters",0.12,0.66700000000000004,1.4999999999999999E-2]

{"sheet":"Sheet1","index":6,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Sportpunter's NRL Suggested Bets as at 27/03/2015"]
[]
["Team1","Team2","Venue","Prob"," Odds1 "," Odds2 "," Overlay1 "," Overlay2 "," Bet1 "," Bet2 "," Result "," Profit/Loss "]
["Parramatta","South Sydney","Pirtek Stadium",0.23699999999999999,3.59,1.34,0,0.02," $                 -  "," $                 -  ",null,"  "]
["Wests","Canterbury","ANZ Stadium",0.20200000000000001,3.52,1.35,0,0.08," $                 -  ",220.66,null,"  "]
["Newcastle","Penrith","Hunter Stadium",0.38600000000000001,2.1,1.83,0,0.12," $                 -  ",148.65,null,"  "]
["Cronulla","Gold Coast","Remondis Stadium",0.876,1.46,2.93,0.28000000000000003,0,607.78," $                 -  ",null,"  "]
["St. George Illawarra","Manly","WIN Jubilee",0.36899999999999999,2.4700000000000002,1.61,0,0.02," $                 -  "," $                 -  ",null,"  "]
["New Zealand","Brisbane","Mt. Smart Stadium",0.48699999999999999,1.75,2.2000000000000002,0,0.13," $                 -  ",106.32,null,"  "]
["Sydney","Canberra","Allianz Stadium",0.82299999999999995,1.17,5.98,0,0.06," $                 -  ",11.68,null,"  "]
["North Queensland","Melbourne","1300SMILES Stadium",0.502,1.88,2.0299999999999998,0,0.01," $                 -  "," $                 -  ",null,"  "]
[null,null,null,null,null,null,null,null,null,1095.0899999999999,null," $              -  "]

{"sheet":"Sheet4","index":7,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["h2hbets_2: Failed ..."]
[]
[]
[]
[]
[]
[]
[null,null,null,"h2hbets: Failed ..."]

{"sheet":"Sheet3","index":8,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["h2hbets: Failed ..."]