{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["h2h","line","margin","totals","futures"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":77,"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":"h2h","index":0,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Sportpunter's 2013 afl player based bets",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,"AFL Bet Calculator"]
[null,null,null,null,null,null,null,null,null,null,"Version 2.31"]
[]
[]
["Bank Balance:",1000,null,null,1]
["Kelly Fractional: 1/",4]
[]
["Team1","Team2","Probability (Team1)","Probability (Team2)","Odds1","Odds2","Bet1","Bet2"]
["Carlton","Brisbane",0.56799999999999995,{"$f":"IF(C13=\"\",\"\",1-C13)","v":0.43200000000000005},5,5,{"$f":"IF(OR(C13=\"\",F13=\"\"),\"\",IF((E13*C13-1)>0.05,$B$9/$B$10*(E13*C13-1)/(E13-1),0))","v":114.99999999999999},{"$f":"IF(OR(C13=\"\",F13=\"\"),\"\",IF((F13*D13-1)>0.05,$B$9/$B$10*(F13*D13-1)/(F13-1),0))","v":72.500000000000014}]
[null,null,null,{"$f":"IF(C14=\"\",\"\",1-C14)","v":""},2,2,{"$f":"IF(OR(C14=\"\",F14=\"\"),\"\",IF((E14*C14-1)>0.05,$B$9/$B$10*(E14*C14-1)/(E14-1),0))","v":""},{"$f":"IF(OR(C14=\"\",F14=\"\"),\"\",IF((F14*D14-1)>0.05,$B$9/$B$10*(F14*D14-1)/(F14-1),0))","v":""}]
[null,null,null,"",null,null,"",""]
[null,null,null,"",null,null,"",""]
[null,null,null,"",null,null,"",""]
[null,null,null,"",null,null,"",""]
[null,null,null,"",null,null,"",""]
[null,null,null,"",null,null,"",""]
[null,null,null,"",null,null,{"$f":"IF(OR(C21=\"\",F21=\"\"),\"\",IF((E21*C21-1)>0.05,$B$9/$B$10*(E21*C21-1)/(E21-1),0))","v":""},{"$f":"IF(OR(C21=\"\",F21=\"\"),\"\",IF((F21*D21-1)>0.05,$B$9/$B$10*(F21*D21-1)/(F21-1),0))","v":""},{"$f":"IF(G21=\"\",\"\",IF((G21*(1-#REF!)-1)>0.05,$B$9/$B$10*(G21*(1-#REF!)-1)/(G21-1),0))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F22=\"\",\"\",IF((F22*#REF!-1)>0.05,$B$9/$B$10*(F22*#REF!-1)/(F22-1),0))","v":""},{"$f":"IF(G22=\"\",\"\",IF((G22*(1-#REF!)-1)>0.05,$B$9/$B$10*(G22*(1-#REF!)-1)/(G22-1),0))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F23=\"\",\"\",IF((F23*#REF!-1)>0.05,$B$9/$B$10*(F23*#REF!-1)/(F23-1),0))","v":""},{"$f":"IF(G23=\"\",\"\",IF((G23*(1-#REF!)-1)>0.05,$B$9/$B$10*(G23*(1-#REF!)-1)/(G23-1),0))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F24=\"\",\"\",IF((F24*#REF!-1)>0.05,$B$9/$B$10*(F24*#REF!-1)/(F24-1),0))","v":""},{"$f":"IF(G24=\"\",\"\",IF((G24*(1-#REF!)-1)>0.05,$B$9/$B$10*(G24*(1-#REF!)-1)/(G24-1),0))","v":""}]

{"sheet":"line","index":1,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,9,0,21],[1,9,5,18]]}
[null,null,null,null,null,null,null,null,null,"Help:"]
[null,null,null,null,null,null,null,null,null,"Sportpunter's AFL Line Calculator is a little different but twice as useful. Here we can enter the teams playing, the probability, the line given by the bookmaker and the associated odds and the calculator will work out the overlay and amount to bet based on your bank balance and kelly franctional. You may notice that the last game only has one bookmaker line and odds submitted which one can do, however the beauty of this program is that you can insert different lines and their associated odds from several bookmakers, and the program will tell you which option has the greatest overlay and suggested bet size."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bank Balance:",1000]
["Kelly Fractional: 1/",4]
[]
["Team1","Team2","Probability","Line","Odds1","Odds2","Expected","Adj.Line","Adj.Prob","Overlay1","Overlay2","Bet1","Bet2"]
["Carlton","Brisbane",0.56799999999999995,-8,1.93,1.95,{"$f":"IF(OR(D18=\"\",C18=\"\"),\"\",LN(1/(1-C18)-1)/0.0447136)","v":6.1210868835665382},{"$f":"IF(G18<>\"\",G18+D18,\"\")","v":-1.8789131164334618},{"$f":"IF(H18<>\"\",1-1/(1+EXP(0.0447136*H18)),\"\")","v":0.47900910262644902},{"$f":"IF(I18=\"\",\"\",IF((I18*E18-1)>0,I18*E18-1,\"\"))","v":""},{"$f":"IF(I18<>\"\",IF(((1-I18)*F18-1)>0,(1-I18)*F18-1,\"\"),\"\")","v":1.5932249878424454E-2},{"$f":"IF(AND(J18<>\"\",D18<>\"\",J18=$N$18),$B$14/$B$15*J18/(E18-1),0)","v":0},{"$f":"IF(AND(K18<>\"\",D18<>\"\",K18=$N$18),$B$14/$B$15*K18/(F18-1),0)","v":0},{"$f":"MAX(J18:K22)","v":2.6806424748279101E-2}]
[null,null,{"$f":"IF(AND(C18<>\"\",D19<>\"\"),$C$18,\"\")","v":0.56799999999999995},-8.5,1.98,1.95,{"$f":"IF(OR(D19=\"\",C19=\"\"),\"\",LN(1/(1-C19)-1)/0.0447136)","v":6.1210868835665382},{"$f":"IF(G19<>\"\",G19+D19,\"\")","v":-2.3789131164334618},{"$f":"IF(H19<>\"\",1-1/(1+EXP(0.0447136*H19)),\"\")","v":0.47343260269319021},{"$f":"IF(I19=\"\",\"\",IF((I19*E19-1)>0,I19*E19-1,\"\"))","v":""},{"$f":"IF(I19<>\"\",IF(((1-I19)*F19-1)>0,(1-I19)*F19-1,\"\"),\"\")","v":2.6806424748279101E-2},{"$f":"IF(AND(J19<>\"\",D19<>\"\",J19=$N$18),$B$14/$B$15*J19/(E19-1),0)","v":0},{"$f":"IF(AND(K19<>\"\",D19<>\"\",K19=$N$18),$B$14/$B$15*K19/(F19-1),0)","v":7.0543223021787105}]
[null,null,{"$f":"IF(AND(C19<>\"\",D20<>\"\"),$C$18,\"\")","v":0.56799999999999995},-9,1.9,1.9,{"$f":"IF(OR(D20=\"\",C20=\"\"),\"\",LN(1/(1-C20)-1)/0.0447136)","v":6.1210868835665382},{"$f":"IF(G20<>\"\",G20+D20,\"\")","v":-2.8789131164334618},{"$f":"IF(H20<>\"\",1-1/(1+EXP(0.0447136*H20)),\"\")","v":0.46786272300998277},{"$f":"IF(I20=\"\",\"\",IF((I20*E20-1)>0,I20*E20-1,\"\"))","v":""},{"$f":"IF(I20<>\"\",IF(((1-I20)*F20-1)>0,(1-I20)*F20-1,\"\"),\"\")","v":1.1060826281032776E-2},{"$f":"IF(AND(J20<>\"\",D20<>\"\",J20=$N$18),$B$14/$B$15*J20/(E20-1),0)","v":0},{"$f":"IF(AND(K20<>\"\",D20<>\"\",K20=$N$18),$B$14/$B$15*K20/(F20-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C20<>\"\",D21<>\"\"),$C$18,\"\")","v":""},null,null,null,{"$f":"IF(OR(D21=\"\",C21=\"\"),\"\",LN(1/(1-C21)-1)/0.0447136)","v":""},{"$f":"IF(G21<>\"\",G21+D21,\"\")","v":""},{"$f":"IF(H21<>\"\",1-1/(1+EXP(0.0447136*H21)),\"\")","v":""},{"$f":"IF(I21=\"\",\"\",IF((I21*E21-1)>0,I21*E21-1,\"\"))","v":""},{"$f":"IF(D21<>\"\",IF(((1-I21)*F21-1)>0,(1-I21)*F21-1,\"\"),\"\")","v":""},{"$f":"IF(AND(J21<>\"\",D21<>\"\",J21=$N$18),$B$14/$B$15*J21/(E21-1),0)","v":0},{"$f":"IF(AND(K21<>\"\",D21<>\"\",K21=$N$18),$B$14/$B$15*K21/(F21-1),0)","v":0}]
[]
[null,null,null,5,2,1.8,{"$f":"IF(OR(D23=\"\",C23=\"\"),\"\",LN(1/(1-C23)-1)/0.0447136)","v":""},{"$f":"IF(G23<>\"\",G23+D23,\"\")","v":""},{"$f":"IF(H23<>\"\",1-1/(1+EXP(0.0447136*H23)),\"\")","v":""},{"$f":"IF(I23=\"\",\"\",IF((I23*E23-1)>0,I23*E23-1,\"\"))","v":""},{"$f":"IF(I23<>\"\",IF(((1-I23)*F23-1)>0,(1-I23)*F23-1,\"\"),\"\")","v":""},{"$f":"IF(AND(J23<>\"\",D23<>\"\",J23=$N$23),$B$14/$B$15*J23/(E23-1),0)","v":0},{"$f":"IF(AND(K23<>\"\",D23<>\"\",K23=$N$23),$B$14/$B$15*K23/(F23-1),0)","v":0},{"$f":"MAX(J23:K27)","v":0}]
[null,null,{"$f":"IF(AND(C23<>\"\",D24<>\"\"),$C$23,\"\")","v":""},6.5,1.93,2.06,{"$f":"IF(OR(D24=\"\",C24=\"\"),\"\",LN(1/(1-C24)-1)/0.0447136)","v":""},{"$f":"IF(G24<>\"\",G24+D24,\"\")","v":""},{"$f":"IF(H24<>\"\",1-1/(1+EXP(0.0447136*H24)),\"\")","v":""},{"$f":"IF(I24=\"\",\"\",IF((I24*E24-1)>0,I24*E24-1,\"\"))","v":""},{"$f":"IF(I24<>\"\",IF(((1-I24)*F24-1)>0,(1-I24)*F24-1,\"\"),\"\")","v":""},{"$f":"IF(AND(J24<>\"\",D24<>\"\",J24=$N$23),$B$14/$B$15*J24/(E24-1),0)","v":0},{"$f":"IF(AND(K24<>\"\",D24<>\"\",K24=$N$23),$B$14/$B$15*K24/(F24-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C24<>\"\",D25<>\"\"),$C$23,\"\")","v":""},7.5,1.85,1.95,{"$f":"IF(OR(D25=\"\",C25=\"\"),\"\",LN(1/(1-C25)-1)/0.0447136)","v":""},{"$f":"IF(G25<>\"\",G25+D25,\"\")","v":""},{"$f":"IF(H25<>\"\",1-1/(1+EXP(0.0447136*H25)),\"\")","v":""},{"$f":"IF(I25=\"\",\"\",IF((I25*E25-1)>0,I25*E25-1,\"\"))","v":""},{"$f":"IF(I25<>\"\",IF(((1-I25)*F25-1)>0,(1-I25)*F25-1,\"\"),\"\")","v":""},{"$f":"IF(AND(J25<>\"\",D25<>\"\",J25=$N$23),$B$14/$B$15*J25/(E25-1),0)","v":0},{"$f":"IF(AND(K25<>\"\",D25<>\"\",K25=$N$23),$B$14/$B$15*K25/(F25-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C25<>\"\",D26<>\"\"),$C$23,\"\")","v":""},null,null,null,{"$f":"IF(OR(D26=\"\",C26=\"\"),\"\",LN(1/(1-C26)-1)/0.0447136)","v":""},{"$f":"IF(G26<>\"\",G26+D26,\"\")","v":""},{"$f":"IF(H26<>\"\",1-1/(1+EXP(0.0447136*H26)),\"\")","v":""},{"$f":"IF(I26=\"\",\"\",IF((I26*E26-1)>0,I26*E26-1,\"\"))","v":""},{"$f":"IF(I26<>\"\",IF(((1-I26)*F26-1)>0,(1-I26)*F26-1,\"\"),\"\")","v":""},{"$f":"IF(AND(J26<>\"\",D26<>\"\",J26=$N$23),$B$14/$B$15*J26/(E26-1),0)","v":0},{"$f":"IF(AND(K26<>\"\",D26<>\"\",K26=$N$23),$B$14/$B$15*K26/(F26-1),0)","v":0}]
[]
[null,null,null,-10,1.9,1.9,{"$f":"IF(OR(D28=\"\",C28=\"\"),\"\",LN(1/(1-C28)-1)/0.0447136)","v":""},{"$f":"IF(G28<>\"\",G28+D28,\"\")","v":""},{"$f":"IF(H28<>\"\",1-1/(1+EXP(0.0447136*H28)),\"\")","v":""},{"$f":"IF(I28=\"\",\"\",IF((I28*E28-1)>0,I28*E28-1,\"\"))","v":""},{"$f":"IF(I28=\"\",\"\",IF(((1-I28)*F28-1)>0,(1-I28)*F28-1,\"\"))","v":""},{"$f":"IF(AND(J28<>\"\",D28<>\"\",J28=$N$28),$B$14/$B$15*J28/(E28-1),0)","v":0},{"$f":"IF(AND(K28<>\"\",D28<>\"\",K28=$N$28),$B$14/$B$15*K28/(F28-1),0)","v":0},{"$f":"MAX(J28:K32)","v":0}]
[null,null,{"$f":"IF(AND(C28<>\"\",D29<>\"\"),$C$28,\"\")","v":""},-10.5,1.95,2.0299999999999998,{"$f":"IF(OR(D29=\"\",C29=\"\"),\"\",LN(1/(1-C29)-1)/0.0447136)","v":""},{"$f":"IF(G29<>\"\",G29+D29,\"\")","v":""},{"$f":"IF(H29<>\"\",1-1/(1+EXP(0.0447136*H29)),\"\")","v":""},{"$f":"IF(I29=\"\",\"\",IF((I29*E29-1)>0,I29*E29-1,\"\"))","v":""},{"$f":"IF(I29=\"\",\"\",IF(((1-I29)*F29-1)>0,(1-I29)*F29-1,\"\"))","v":""},{"$f":"IF(AND(J29<>\"\",D29<>\"\",J29=$N$28),$B$14/$B$15*J29/(E29-1),0)","v":0},{"$f":"IF(AND(K29<>\"\",D29<>\"\",K29=$N$28),$B$14/$B$15*K29/(F29-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C29<>\"\",D30<>\"\"),$C$28,\"\")","v":""},-11.5,1.9,1.9,{"$f":"IF(OR(D30=\"\",C30=\"\"),\"\",LN(1/(1-C30)-1)/0.0447136)","v":""},{"$f":"IF(G30<>\"\",G30+D30,\"\")","v":""},{"$f":"IF(H30<>\"\",1-1/(1+EXP(0.0447136*H30)),\"\")","v":""},{"$f":"IF(I30=\"\",\"\",IF((I30*E30-1)>0,I30*E30-1,\"\"))","v":""},{"$f":"IF(I30=\"\",\"\",IF(((1-I30)*F30-1)>0,(1-I30)*F30-1,\"\"))","v":""},{"$f":"IF(AND(J30<>\"\",D30<>\"\",J30=$N$28),$B$14/$B$15*J30/(E30-1),0)","v":0},{"$f":"IF(AND(K30<>\"\",D30<>\"\",K30=$N$28),$B$14/$B$15*K30/(F30-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C30<>\"\",D31<>\"\"),$C$28,\"\")","v":""},-12.5,1.95,1.8,{"$f":"IF(OR(D31=\"\",C31=\"\"),\"\",LN(1/(1-C31)-1)/0.0447136)","v":""},{"$f":"IF(G31<>\"\",G31+D31,\"\")","v":""},{"$f":"IF(H31<>\"\",1-1/(1+EXP(0.0447136*H31)),\"\")","v":""},{"$f":"IF(I31=\"\",\"\",IF((I31*E31-1)>0,I31*E31-1,\"\"))","v":""},{"$f":"IF(I31=\"\",\"\",IF(((1-I31)*F31-1)>0,(1-I31)*F31-1,\"\"))","v":""},{"$f":"IF(AND(J31<>\"\",D31<>\"\",J31=$N$28),$B$14/$B$15*J31/(E31-1),0)","v":0},{"$f":"IF(AND(K31<>\"\",D31<>\"\",K31=$N$28),$B$14/$B$15*K31/(F31-1),0)","v":0}]
[]
[null,null,null,6,1.9,1.9,{"$f":"IF(OR(D33=\"\",C33=\"\"),\"\",LN(1/(1-C33)-1)/0.0447136)","v":""},{"$f":"IF(G33<>\"\",G33+D33,\"\")","v":""},{"$f":"IF(H33<>\"\",1-1/(1+EXP(0.0447136*H33)),\"\")","v":""},{"$f":"IF(I33=\"\",\"\",IF((I33*E33-1)>0,I33*E33-1,\"\"))","v":""},{"$f":"IF(I33=\"\",\"\",IF(((1-I33)*F33-1)>0,(1-I33)*F33-1,\"\"))","v":""},{"$f":"IF(AND(J33<>\"\",D33<>\"\",J33=$N$33),$B$14/$B$15*J33/(E33-1),0)","v":0},{"$f":"IF(AND(K33<>\"\",D33<>\"\",K33=$N$33),$B$14/$B$15*K33/(F33-1),0)","v":0},{"$f":"MAX(J33:K37)","v":0}]
[null,null,{"$f":"IF(AND(C33<>\"\",D34<>\"\"),$C$33,\"\")","v":""},6.5,1.95,1.95,{"$f":"IF(OR(D34=\"\",C34=\"\"),\"\",LN(1/(1-C34)-1)/0.0447136)","v":""},{"$f":"IF(G34<>\"\",G34+D34,\"\")","v":""},{"$f":"IF(H34<>\"\",1-1/(1+EXP(0.0447136*H34)),\"\")","v":""},{"$f":"IF(I34=\"\",\"\",IF((I34*E34-1)>0,I34*E34-1,\"\"))","v":""},{"$f":"IF(I34=\"\",\"\",IF(((1-I34)*F34-1)>0,(1-I34)*F34-1,\"\"))","v":""},{"$f":"IF(AND(J34<>\"\",D34<>\"\",J34=$N$33),$B$14/$B$15*J34/(E34-1),0)","v":0},{"$f":"IF(AND(K34<>\"\",D34<>\"\",K34=$N$33),$B$14/$B$15*K34/(F34-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C34<>\"\",D35<>\"\"),$C$33,\"\")","v":""},7,1.9,1.9,{"$f":"IF(OR(D35=\"\",C35=\"\"),\"\",LN(1/(1-C35)-1)/0.0447136)","v":""},{"$f":"IF(G35<>\"\",G35+D35,\"\")","v":""},{"$f":"IF(H35<>\"\",1-1/(1+EXP(0.0447136*H35)),\"\")","v":""},{"$f":"IF(I35=\"\",\"\",IF((I35*E35-1)>0,I35*E35-1,\"\"))","v":""},{"$f":"IF(I35=\"\",\"\",IF(((1-I35)*F35-1)>0,(1-I35)*F35-1,\"\"))","v":""},{"$f":"IF(AND(J35<>\"\",D35<>\"\",J35=$N$33),$B$14/$B$15*J35/(E35-1),0)","v":0},{"$f":"IF(AND(K35<>\"\",D35<>\"\",K35=$N$33),$B$14/$B$15*K35/(F35-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C35<>\"\",D36<>\"\"),$C$33,\"\")","v":""},7.5,1.85,1.85,{"$f":"IF(OR(D36=\"\",C36=\"\"),\"\",LN(1/(1-C36)-1)/0.0447136)","v":""},{"$f":"IF(G36<>\"\",G36+D36,\"\")","v":""},{"$f":"IF(H36<>\"\",1-1/(1+EXP(0.0447136*H36)),\"\")","v":""},{"$f":"IF(I36=\"\",\"\",IF((I36*E36-1)>0,I36*E36-1,\"\"))","v":""},{"$f":"IF(I36=\"\",\"\",IF(((1-I36)*F36-1)>0,(1-I36)*F36-1,\"\"))","v":""},{"$f":"IF(AND(J36<>\"\",D36<>\"\",J36=$N$33),$B$14/$B$15*J36/(E36-1),0)","v":0},{"$f":"IF(AND(K36<>\"\",D36<>\"\",K36=$N$33),$B$14/$B$15*K36/(F36-1),0)","v":0}]
[]
[null,null,null,-4.5,2,2,{"$f":"IF(OR(D38=\"\",C38=\"\"),\"\",LN(1/(1-C38)-1)/0.0447136)","v":""},{"$f":"IF(G38<>\"\",G38+D38,\"\")","v":""},{"$f":"IF(H38<>\"\",1-1/(1+EXP(0.0447136*H38)),\"\")","v":""},{"$f":"IF(I38=\"\",\"\",IF((I38*E38-1)>0,I38*E38-1,\"\"))","v":""},{"$f":"IF(I38=\"\",\"\",IF(((1-I38)*F38-1)>0,(1-I38)*F38-1,\"\"))","v":""},{"$f":"IF(AND(J38<>\"\",D38<>\"\",J38=$N$38),$B$14/$B$15*J38/(E38-1),0)","v":0},{"$f":"IF(AND(K38<>\"\",D38<>\"\",K38=$N$38),$B$14/$B$15*K38/(F38-1),0)","v":0},{"$f":"MAX(J38:K42)","v":0}]
[null,null,{"$f":"IF(AND(C38<>\"\",D39<>\"\"),$C$38,\"\")","v":""},-5,1.95,1.95,{"$f":"IF(OR(D39=\"\",C39=\"\"),\"\",LN(1/(1-C39)-1)/0.0447136)","v":""},{"$f":"IF(G39<>\"\",G39+D39,\"\")","v":""},{"$f":"IF(H39<>\"\",1-1/(1+EXP(0.0447136*H39)),\"\")","v":""},{"$f":"IF(I39=\"\",\"\",IF((I39*E39-1)>0,I39*E39-1,\"\"))","v":""},{"$f":"IF(I39=\"\",\"\",IF(((1-I39)*F39-1)>0,(1-I39)*F39-1,\"\"))","v":""},{"$f":"IF(AND(J39<>\"\",D39<>\"\",J39=$N$38),$B$14/$B$15*J39/(E39-1),0)","v":0},{"$f":"IF(AND(K39<>\"\",D39<>\"\",K39=$N$38),$B$14/$B$15*K39/(F39-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C39<>\"\",D40<>\"\"),$C$38,\"\")","v":""},-6.5,1.9,1.8,{"$f":"IF(OR(D40=\"\",C40=\"\"),\"\",LN(1/(1-C40)-1)/0.0447136)","v":""},{"$f":"IF(G40<>\"\",G40+D40,\"\")","v":""},{"$f":"IF(H40<>\"\",1-1/(1+EXP(0.0447136*H40)),\"\")","v":""},{"$f":"IF(I40=\"\",\"\",IF((I40*E40-1)>0,I40*E40-1,\"\"))","v":""},{"$f":"IF(I40=\"\",\"\",IF(((1-I40)*F40-1)>0,(1-I40)*F40-1,\"\"))","v":""},{"$f":"IF(AND(J40<>\"\",D40<>\"\",J40=$N$38),$B$14/$B$15*J40/(E40-1),0)","v":0},{"$f":"IF(AND(K40<>\"\",D40<>\"\",K40=$N$38),$B$14/$B$15*K40/(F40-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C40<>\"\",D41<>\"\"),$C$38,\"\")","v":""},null,null,null,{"$f":"IF(OR(D41=\"\",C41=\"\"),\"\",LN(1/(1-C41)-1)/0.0447136)","v":""},{"$f":"IF(G41<>\"\",G41+D41,\"\")","v":""},{"$f":"IF(H41<>\"\",1-1/(1+EXP(0.0447136*H41)),\"\")","v":""},{"$f":"IF(I41=\"\",\"\",IF((I41*E41-1)>0,I41*E41-1,\"\"))","v":""},{"$f":"IF(I41=\"\",\"\",IF(((1-I41)*F41-1)>0,(1-I41)*F41-1,\"\"))","v":""},{"$f":"IF(AND(J41<>\"\",D41<>\"\",J41=$N$38),$B$14/$B$15*J41/(E41-1),0)","v":0},{"$f":"IF(AND(K41<>\"\",D41<>\"\",K41=$N$38),$B$14/$B$15*K41/(F41-1),0)","v":0}]
[]
[null,null,null,-2,1.9,1.9,{"$f":"IF(OR(D43=\"\",C43=\"\"),\"\",LN(1/(1-C43)-1)/0.0447136)","v":""},{"$f":"IF(G43<>\"\",G43+D43,\"\")","v":""},{"$f":"IF(H43<>\"\",1-1/(1+EXP(0.0447136*H43)),\"\")","v":""},{"$f":"IF(I43=\"\",\"\",IF((I43*E43-1)>0,I43*E43-1,\"\"))","v":""},{"$f":"IF(I43=\"\",\"\",IF(((1-I43)*F43-1)>0,(1-I43)*F43-1,\"\"))","v":""},{"$f":"IF(AND(J43<>\"\",D43<>\"\",J43=$N$43),$B$14/$B$15*J43/(E43-1),0)","v":0},{"$f":"IF(AND(K43<>\"\",D43<>\"\",K43=$N$43),$B$14/$B$15*K43/(F43-1),0)","v":0},{"$f":"MAX(J43:K46)","v":0}]
[null,null,{"$f":"IF(AND(C43<>\"\",D44<>\"\"),$C$43,\"\")","v":""},null,null,null,{"$f":"IF(OR(D44=\"\",C44=\"\"),\"\",LN(1/(1-C44)-1)/0.0447136)","v":""},{"$f":"IF(G44<>\"\",G44+D44,\"\")","v":""},{"$f":"IF(H44<>\"\",1-1/(1+EXP(0.0447136*H44)),\"\")","v":""},{"$f":"IF(I44=\"\",\"\",IF((I44*E44-1)>0,I44*E44-1,\"\"))","v":""},{"$f":"IF(I44=\"\",\"\",IF(((1-I44)*F44-1)>0,(1-I44)*F44-1,\"\"))","v":""},{"$f":"IF(AND(J44<>\"\",D44<>\"\",J44=$N$43),$B$14/$B$15*J44/(E44-1),0)","v":0},{"$f":"IF(AND(K44<>\"\",D44<>\"\",K44=$N$43),$B$14/$B$15*K44/(F44-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C44<>\"\",D45<>\"\"),$C$43,\"\")","v":""},null,null,null,{"$f":"IF(OR(D45=\"\",C45=\"\"),\"\",LN(1/(1-C45)-1)/0.0447136)","v":""},{"$f":"IF(G45<>\"\",G45+D45,\"\")","v":""},{"$f":"IF(H45<>\"\",1-1/(1+EXP(0.0447136*H45)),\"\")","v":""},{"$f":"IF(I45=\"\",\"\",IF((I45*E45-1)>0,I45*E45-1,\"\"))","v":""},{"$f":"IF(I45=\"\",\"\",IF(((1-I45)*F45-1)>0,(1-I45)*F45-1,\"\"))","v":""},{"$f":"IF(AND(J45<>\"\",D45<>\"\",J45=$N$43),$B$14/$B$15*J45/(E45-1),0)","v":0},{"$f":"IF(AND(K45<>\"\",D45<>\"\",K45=$N$43),$B$14/$B$15*K45/(F45-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C45<>\"\",D46<>\"\"),$C$43,\"\")","v":""},null,null,null,{"$f":"IF(OR(D46=\"\",C46=\"\"),\"\",LN(1/(1-C46)-1)/0.0447136)","v":""},{"$f":"IF(G46<>\"\",G46+D46,\"\")","v":""},{"$f":"IF(H46<>\"\",1-1/(1+EXP(0.0447136*H46)),\"\")","v":""},{"$f":"IF(I46=\"\",\"\",IF((I46*E46-1)>0,I46*E46-1,\"\"))","v":""},{"$f":"IF(I46=\"\",\"\",IF(((1-I46)*F46-1)>0,(1-I46)*F46-1,\"\"))","v":""},{"$f":"IF(AND(J46<>\"\",D46<>\"\",J46=$N$43),$B$14/$B$15*J46/(E46-1),0)","v":0},{"$f":"IF(AND(K46<>\"\",D46<>\"\",K46=$N$43),$B$14/$B$15*K46/(F46-1),0)","v":0}]
[]
[null,null,null,-2,1.9,1.9,{"$f":"IF(OR(D48=\"\",C48=\"\"),\"\",LN(1/(1-C48)-1)/0.0447136)","v":""},{"$f":"IF(G48<>\"\",G48+D48,\"\")","v":""},{"$f":"IF(H48<>\"\",1-1/(1+EXP(0.0447136*H48)),\"\")","v":""},{"$f":"IF(I48=\"\",\"\",IF((I48*E48-1)>0,I48*E48-1,\"\"))","v":""},{"$f":"IF(I48=\"\",\"\",IF(((1-I48)*F48-1)>0,(1-I48)*F48-1,\"\"))","v":""},{"$f":"IF(AND(J48<>\"\",D48<>\"\",J48=$N$48),$B$14/$B$15*J48/(E48-1),0)","v":0},{"$f":"IF(AND(K48<>\"\",D48<>\"\",K48=$N$48),$B$14/$B$15*K48/(F48-1),0)","v":0},{"$f":"MAX(J48:K51)","v":0}]
[null,null,{"$f":"IF(AND(C48<>\"\",D49<>\"\"),$C$48,\"\")","v":""},null,null,null,{"$f":"IF(OR(D49=\"\",C49=\"\"),\"\",LN(1/(1-C49)-1)/0.0447136)","v":""},{"$f":"IF(G49<>\"\",G49+D49,\"\")","v":""},{"$f":"IF(H49<>\"\",1-1/(1+EXP(0.0447136*H49)),\"\")","v":""},{"$f":"IF(I49=\"\",\"\",IF((I49*E49-1)>0,I49*E49-1,\"\"))","v":""},{"$f":"IF(I49=\"\",\"\",IF(((1-I49)*F49-1)>0,(1-I49)*F49-1,\"\"))","v":""},{"$f":"IF(AND(J49<>\"\",D49<>\"\",J49=$N$48),$B$14/$B$15*J49/(E49-1),0)","v":0},{"$f":"IF(AND(K49<>\"\",D49<>\"\",K49=$N$48),$B$14/$B$15*K49/(F49-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C49<>\"\",D50<>\"\"),$C$48,\"\")","v":""},null,null,null,{"$f":"IF(OR(D50=\"\",C50=\"\"),\"\",LN(1/(1-C50)-1)/0.0447136)","v":""},{"$f":"IF(G50<>\"\",G50+D50,\"\")","v":""},{"$f":"IF(H50<>\"\",1-1/(1+EXP(0.0447136*H50)),\"\")","v":""},{"$f":"IF(I50=\"\",\"\",IF((I50*E50-1)>0,I50*E50-1,\"\"))","v":""},{"$f":"IF(I50=\"\",\"\",IF(((1-I50)*F50-1)>0,(1-I50)*F50-1,\"\"))","v":""},{"$f":"IF(AND(J50<>\"\",D50<>\"\",J50=$N$48),$B$14/$B$15*J50/(E50-1),0)","v":0},{"$f":"IF(AND(K50<>\"\",D50<>\"\",K50=$N$48),$B$14/$B$15*K50/(F50-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C50<>\"\",D51<>\"\"),$C$48,\"\")","v":""},null,null,null,{"$f":"IF(OR(D51=\"\",C51=\"\"),\"\",LN(1/(1-C51)-1)/0.0447136)","v":""},{"$f":"IF(G51<>\"\",G51+D51,\"\")","v":""},{"$f":"IF(H51<>\"\",1-1/(1+EXP(0.0447136*H51)),\"\")","v":""},{"$f":"IF(I51=\"\",\"\",IF((I51*E51-1)>0,I51*E51-1,\"\"))","v":""},{"$f":"IF(I51=\"\",\"\",IF(((1-I51)*F51-1)>0,(1-I51)*F51-1,\"\"))","v":""},{"$f":"IF(AND(J51<>\"\",D51<>\"\",J51=$N$48),$B$14/$B$15*J51/(E51-1),0)","v":0},{"$f":"IF(AND(K51<>\"\",D51<>\"\",K51=$N$48),$B$14/$B$15*K51/(F51-1),0)","v":0}]
[]
[null,null,null,-2,1.9,1.9,{"$f":"IF(OR(D53=\"\",C53=\"\"),\"\",LN(1/(1-C53)-1)/0.0447136)","v":""},{"$f":"IF(G53<>\"\",G53+D53,\"\")","v":""},{"$f":"IF(H53<>\"\",1-1/(1+EXP(0.0447136*H53)),\"\")","v":""},{"$f":"IF(I53=\"\",\"\",IF((I53*E53-1)>0,I53*E53-1,\"\"))","v":""},{"$f":"IF(I53=\"\",\"\",IF(((1-I53)*F53-1)>0,(1-I53)*F53-1,\"\"))","v":""},{"$f":"IF(AND(J53<>\"\",D53<>\"\",J53=$N$53),$B$14/$B$15*J53/(E53-1),0)","v":0},{"$f":"IF(AND(K53<>\"\",D53<>\"\",K53=$N$53),$B$14/$B$15*K53/(F53-1),0)","v":0},{"$f":"MAX(J53:K56)","v":0}]
[null,null,{"$f":"IF(AND(C53<>\"\",D54<>\"\"),$C$53,\"\")","v":""},null,null,null,{"$f":"IF(OR(D54=\"\",C54=\"\"),\"\",LN(1/(1-C54)-1)/0.0447136)","v":""},{"$f":"IF(G54<>\"\",G54+D54,\"\")","v":""},{"$f":"IF(H54<>\"\",1-1/(1+EXP(0.0447136*H54)),\"\")","v":""},{"$f":"IF(I54=\"\",\"\",IF((I54*E54-1)>0,I54*E54-1,\"\"))","v":""},{"$f":"IF(I54=\"\",\"\",IF(((1-I54)*F54-1)>0,(1-I54)*F54-1,\"\"))","v":""},{"$f":"IF(AND(J54<>\"\",D54<>\"\",J54=$N$53),$B$14/$B$15*J54/(E54-1),0)","v":0},{"$f":"IF(AND(K54<>\"\",D54<>\"\",K54=$N$53),$B$14/$B$15*K54/(F54-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C54<>\"\",D55<>\"\"),$C$53,\"\")","v":""},null,null,null,{"$f":"IF(OR(D55=\"\",C55=\"\"),\"\",LN(1/(1-C55)-1)/0.0447136)","v":""},{"$f":"IF(G55<>\"\",G55+D55,\"\")","v":""},{"$f":"IF(H55<>\"\",1-1/(1+EXP(0.0447136*H55)),\"\")","v":""},{"$f":"IF(I55=\"\",\"\",IF((I55*E55-1)>0,I55*E55-1,\"\"))","v":""},{"$f":"IF(I55=\"\",\"\",IF(((1-I55)*F55-1)>0,(1-I55)*F55-1,\"\"))","v":""},{"$f":"IF(AND(J55<>\"\",D55<>\"\",J55=$N$53),$B$14/$B$15*J55/(E55-1),0)","v":0},{"$f":"IF(AND(K55<>\"\",D55<>\"\",K55=$N$53),$B$14/$B$15*K55/(F55-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C55<>\"\",D56<>\"\"),$C$53,\"\")","v":""},null,null,null,{"$f":"IF(OR(D56=\"\",C56=\"\"),\"\",LN(1/(1-C56)-1)/0.0447136)","v":""},{"$f":"IF(G56<>\"\",G56+D56,\"\")","v":""},{"$f":"IF(H56<>\"\",1-1/(1+EXP(0.0447136*H56)),\"\")","v":""},{"$f":"IF(I56=\"\",\"\",IF((I56*E56-1)>0,I56*E56-1,\"\"))","v":""},{"$f":"IF(I56=\"\",\"\",IF(((1-I56)*F56-1)>0,(1-I56)*F56-1,\"\"))","v":""},{"$f":"IF(AND(J56<>\"\",D56<>\"\",J56=$N$53),$B$14/$B$15*J56/(E56-1),0)","v":0},{"$f":"IF(AND(K56<>\"\",D56<>\"\",K56=$N$53),$B$14/$B$15*K56/(F56-1),0)","v":0}]
[]
[null,null,null,{"$f":"2","v":2},1.9,1.9,{"$f":"IF(OR(D58=\"\",C58=\"\"),\"\",LN(1/(1-C58)-1)/0.0447136)","v":""},{"$f":"IF(G58<>\"\",G58+D58,\"\")","v":""},{"$f":"IF(H58<>\"\",1-1/(1+EXP(0.0447136*H58)),\"\")","v":""},{"$f":"IF(I58=\"\",\"\",IF((I58*E58-1)>0,I58*E58-1,\"\"))","v":""},{"$f":"IF(I58=\"\",\"\",IF(((1-I58)*F58-1)>0,(1-I58)*F58-1,\"\"))","v":""},{"$f":"IF(AND(J58<>\"\",D58<>\"\",J58=$N$58),$B$14/$B$15*J58/(E58-1),0)","v":0},{"$f":"IF(AND(K58<>\"\",D58<>\"\",K58=$N$58),$B$14/$B$15*K58/(F58-1),0)","v":0},{"$f":"MAX(J58:K61)","v":0}]
[null,null,{"$f":"IF(AND(C58<>\"\",D59<>\"\"),$C$58,\"\")","v":""},null,null,null,{"$f":"IF(OR(D59=\"\",C59=\"\"),\"\",LN(1/(1-C59)-1)/0.0447136)","v":""},{"$f":"IF(G59<>\"\",G59+D59,\"\")","v":""},{"$f":"IF(H59<>\"\",1-1/(1+EXP(0.0447136*H59)),\"\")","v":""},{"$f":"IF(I59=\"\",\"\",IF((I59*E59-1)>0,I59*E59-1,\"\"))","v":""},{"$f":"IF(I59=\"\",\"\",IF(((1-I59)*F59-1)>0,(1-I59)*F59-1,\"\"))","v":""},{"$f":"IF(AND(J59<>\"\",D59<>\"\",J59=$N$58),$B$14/$B$15*J59/(E59-1),0)","v":0},{"$f":"IF(AND(K59<>\"\",D59<>\"\",K59=$N$58),$B$14/$B$15*K59/(F59-1),0)","v":0}]
[null,null,{"$f":"IF(AND(C59<>\"\",D60<>\"\"),$C$58,\"\")","v":""},null,null,null,{"$f":"IF(OR(D60=\"\",C60=\"\"),\"\",LN(1/(1-C60)-1)/0.0447136)","v":""},{"$f":"IF(G60<>\"\",G60+D60,\"\")","v":""},{"$f":"IF(H60<>\"\",1-1/(1+EXP(0.0447136*H60)),\"\")","v":""},{"$f":"IF(I60=\"\",\"\",IF((I60*E60-1)>0,I60*E60-1,\"\"))","v":""},{"$f":"IF(I60=\"\",\"\",IF(((1-I60)*F60-1)>0,(1-I60)*F60-1,\"\"))","v":""},0,0]
[null,null,{"$f":"IF(AND(C60<>\"\",D61<>\"\"),$C$58,\"\")","v":""},null,null,null,{"$f":"IF(OR(D61=\"\",C61=\"\"),\"\",LN(1/(1-C61)-1)/0.0447136)","v":""},{"$f":"IF(G61<>\"\",G61+D61,\"\")","v":""},{"$f":"IF(H61<>\"\",1-1/(1+EXP(0.0447136*H61)),\"\")","v":""},{"$f":"IF(I61=\"\",\"\",IF((I61*E61-1)>0,I61*E61-1,\"\"))","v":""},{"$f":"IF(I61=\"\",\"\",IF(((1-I61)*F61-1)>0,(1-I61)*F61-1,\"\"))","v":""},0,0]
[]
[]
[]
[]
[]
[]
[]
[null,true,false]
[null,false,false]
[null,false,true]
[null,false,false]
[]
[null,false,true]
[null,false,false]
[null,false,true]

{"sheet":"margin","index":2,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[[10,2,10,6],[10,7,10,11],[10,12,10,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Bank Balance:",1000]
["Kelly Fractional: 1/",4]
[null,null,"Probability",null,null,null,null,"Odds",null,null,null,null,"$Bet"]
["Team1","Team2","T1>39","T1<40","Draw","T2<40","T2>39","T1>39","T1<40","Draw","T2<40","T2>39","T1>39","T1<40","Draw","T2<40","T2>39"]
["Carlton","Brisbane",null,null,1,null,null,3,3,3,3,3,{"$f":"IF(C13=\"\",\"\",IF((H13*C13-1)>0.05,$B$9/$B$10*(H13*C13-1)/(H13-1),0))","v":""},{"$f":"IF(D13=\"\",\"\",IF((I13*D13-1)>0.05,$B$9/$B$10*(I13*D13-1)/(I13-1),0))","v":""},{"$f":"IF(E13=\"\",\"\",IF((J13*E13-1)>0.05,$B$9/$B$10*(J13*E13-1)/(J13-1),0))","v":250},{"$f":"IF(F13=\"\",\"\",IF((K13*F13-1)>0.05,$B$9/$B$10*(K13*F13-1)/(K13-1),0))","v":""},{"$f":"IF(G13=\"\",\"\",IF((L13*G13-1)>0.05,$B$9/$B$10*(L13*G13-1)/(L13-1),0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C14=\"\",\"\",IF((H14*C14-1)>0.05,$B$9/$B$10*(H14*C14-1)/(H14-1),0))","v":""},{"$f":"IF(D14=\"\",\"\",IF((I14*D14-1)>0.05,$B$9/$B$10*(I14*D14-1)/(I14-1),0))","v":""},{"$f":"IF(E14=\"\",\"\",IF((J14*E14-1)>0.05,$B$9/$B$10*(J14*E14-1)/(J14-1),0))","v":""},{"$f":"IF(F14=\"\",\"\",IF((K14*F14-1)>0.05,$B$9/$B$10*(K14*F14-1)/(K14-1),0))","v":""},{"$f":"IF(G14=\"\",\"\",IF((L14*G14-1)>0.05,$B$9/$B$10*(L14*G14-1)/(L14-1),0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C19=\"\",\"\",IF((H19*C19-1)>0.05,$B$9/$B$10*(H19*C19-1)/(H19-1),0))","v":""},{"$f":"IF(D19=\"\",\"\",IF((I19*D19-1)>0.05,$B$9/$B$10*(I19*D19-1)/(I19-1),0))","v":""},{"$f":"IF(E19=\"\",\"\",IF((J19*E19-1)>0.05,$B$9/$B$10*(J19*E19-1)/(J19-1),0))","v":""},{"$f":"IF(F19=\"\",\"\",IF((K19*F19-1)>0.05,$B$9/$B$10*(K19*F19-1)/(K19-1),0))","v":""},{"$f":"IF(G19=\"\",\"\",IF((L19*G19-1)>0.05,$B$9/$B$10*(L19*G19-1)/(L19-1),0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
["Sydney","Gold Coast",null,null,1,null,null,null,null,null,null,null,"","",0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,{"$f":"IF(D23=\"\",\"\",IF((D23*C23-1)>0.05,$B$9/$B$10*(D23*C23-1)/(D23-1),0))","v":""},{"$f":"IF(E23=\"\",\"\",IF((E23*(1-C23)-1)>0.05,$B$9/$B$10*(E23*(1-C23)-1)/(E23-1),0))","v":""},null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]

{"sheet":"totals","index":3,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Note totals will be given out one hour before start time for each match."]
[null,null,null,null,null,"When matches are scheduled to start at close times to each other, "]
[null,null,null,null,null,null,"totals will be issued 1 hour before the first scheduled match"]
[null,null,null,null,null,"Please see the AFL members only forum each week to see the schedule of totals predictions"]
[]
[]
[]
["Bank Balance:",1000,null,null,1]
["Kelly Fractional: 1/",4]
[]
["Team1","Team2","Exp.Total","Adj.Total","TotalsLine","ProbOver","OddsOver","OddsUnder","$BetOver","$BetUnder"]
["Carlton","Brisbane",null,-9,168.5,{"$f":"IF(C13=\"\",\"\",1-NORMDIST(E13,C13+D13,32.5,TRUE))","v":""},2,2,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF((G13*F13-1)>0.05,(G13*F13-1)*$B$9/$B$10/(G13-1),0))","v":""},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF((H13*(1-F13)-1)>0.05,(H13*(1-F13)-1)*$B$9/$B$10/(H13-1),0))","v":""}]
[null,null,null,null,null,{"$f":"IF(C14=\"\",\"\",1-NORMDIST(E14,C14+D14,32.5,TRUE))","v":""},{"$f":"IF(OR(C14=\"\",F14=\"\"),\"\",IF((E14*C14-1)>0.05,$B$9/$B$10*(E14*C14-1)/(E14-1),0))","v":""},{"$f":"IF(OR(C14=\"\",F14=\"\"),\"\",IF((F14*D14-1)>0.05,$B$9/$B$10*(F14*D14-1)/(F14-1),0))","v":""},{"$f":"IF(OR(C14=\"\",E14=\"\"),\"\",IF((G14*F14-1)>0.05,(G14*F14-1)*$B$9/$B$10/(G14-1),0))","v":""},{"$f":"IF(OR(C14=\"\",E14=\"\"),\"\",IF((H14*(1-F14)-1)>0.05,(H14*(1-F14)-1)*$B$9/$B$10/(H14-1),0))","v":""}]
[null,null,null,null,null,"","","","",""]
[null,null,null,null,null,"","","","",""]
[null,null,null,null,null,"","","","",""]
[null,null,null,null,null,"","","","",""]
[null,null,null,null,null,"","","","",""]
[null,null,null,null,null,"","","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR(C21=\"\",F21=\"\"),\"\",IF((E21*C21-1)>0.05,$B$9/$B$10*(E21*C21-1)/(E21-1),0))","v":""},{"$f":"IF(OR(C21=\"\",F21=\"\"),\"\",IF((F21*D21-1)>0.05,$B$9/$B$10*(F21*D21-1)/(F21-1),0))","v":""},"",""]
[null,null,null,null,null,null,null,{"$f":"IF(F22=\"\",\"\",IF((F22*#REF!-1)>0.05,$B$9/$B$10*(F22*#REF!-1)/(F22-1),0))","v":""},{"$f":"IF(G22=\"\",\"\",IF((G22*(1-#REF!)-1)>0.05,$B$9/$B$10*(G22*(1-#REF!)-1)/(G22-1),0))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F23=\"\",\"\",IF((F23*#REF!-1)>0.05,$B$9/$B$10*(F23*#REF!-1)/(F23-1),0))","v":""},{"$f":"IF(G23=\"\",\"\",IF((G23*(1-#REF!)-1)>0.05,$B$9/$B$10*(G23*(1-#REF!)-1)/(G23-1),0))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F24=\"\",\"\",IF((F24*#REF!-1)>0.05,$B$9/$B$10*(F24*#REF!-1)/(F24-1),0))","v":""},{"$f":"IF(G24=\"\",\"\",IF((G24*(1-#REF!)-1)>0.05,$B$9/$B$10*(G24*(1-#REF!)-1)/(G24-1),0))","v":""}]

{"sheet":"futures","index":4,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[[11,13,11,15],[11,4,11,6],[11,1,11,3],[11,7,11,9],[11,10,11,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Bank Balance:",1000]
["Kelly Fractional: 1/",4]
[]
[null,"Prob",null,null,"Odds Bet",null,null,"Odds Lay",null,null,"$Bet",null,null,"$Lay"]
["Team1","Premiers",null,"Last","Premiers","Top 8","Last","Premiers","Top 8","Last","Premiers","Top 8","Last","Premiers","Top 8","Last"]
[null,null,null,null,3,3,3,2,2,2,{"$f":"IF(E14=\"\",\"\",IF((E14*B14-1)>0.05,$B$9/$B$10*(E14*B14-1)/(E14-1),0))","v":0},{"$f":"IF(F14=\"\",\"\",IF((F14*C14-1)>0.05,$B$9/$B$10*(F14*C14-1)/(F14-1),0))","v":0},{"$f":"IF(G14=\"\",\"\",IF((G14*D14-1)>0.05,$B$9/$B$10*(G14*D14-1)/(G14-1),0))","v":0},{"$f":"IF((0.95/(H14-1)+1)=\"\",\"\",IF(((0.95/(H14-1)+1)*(1-B14)-1)>0.05,($B$9/$B$10*((0.95/(H14-1)+1)*(1-B14)-1)/((0.95/(H14-1)+1)-1))/(H14-1),\"\"))","v":250},{"$f":"IF((0.95/(I14-1)+1)=\"\",\"\",IF(((0.95/(I14-1)+1)*(1-C14)-1)>0.05,($B$9/$B$10*((0.95/(I14-1)+1)*(1-C14)-1)/((0.95/(I14-1)+1)-1))/(I14-1),\"\"))","v":250},250]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E15=\"\",\"\",IF((E15*B15-1)>0.05,$B$9/$B$10*(E15*B15-1)/(E15-1),0))","v":""},"","",{"$f":"IF((0.95/(H15-1)+1)=\"\",\"\",IF(((0.95/(H15-1)+1)*(1-B15)-1)>0.05,($B$9/$B$10*((0.95/(H15-1)+1)*(1-B15)-1)/((0.95/(H15-1)+1)-1))/(H15-1),\"\"))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E27=\"\",\"\",IF((E27*B27-1)>0.05,$B$9/$B$10*(E27*B27-1)/(E27-1),0))","v":""},"","",{"$f":"IF((0.95/(H27-1)+1)=\"\",\"\",IF(((0.95/(H27-1)+1)*(1-B27)-1)>0.05,($B$9/$B$10*((0.95/(H27-1)+1)*(1-B27)-1)/((0.95/(H27-1)+1)-1))/(H27-1),\"\"))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]