{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Bets","Sports and Bookies"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Bets","index":0,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["                                                        "]
[]
[]
[]
[]
["Total No. Bets",{"$f":"B7+B8+B9","v":26}]
["Total No. Winners",{"$f":"COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"W\")+COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"EWW\")+COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"P\")","v":18},{"$f":"IF(B7<>0,B7/B6,0)","v":0.69230769230769229}]
["Total No. Losers",{"$f":"COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"L\")","v":8},{"$f":"IF(B8<>0,B8/B6,0)","v":0.30769230769230771}]
["Total No. Void",{"$f":"COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"V\")","v":0},{"$f":"IF(B9<>0,B9/B6,0)","v":0}]
["Total Staked",{"$f":"SUMIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"<> \",INDIRECT(\"G18\"):INDIRECT(\"G10000\"))","v":4180}]
["Return",{"$f":"SUM(INDIRECT(\"L18\"):INDIRECT(\"L10000\"))","v":5318.4400000000005}]
["ROI (Return on Investment)",{"$f":"IF(B10<>0,B11/B10,0)","v":1.2723540669856461}]
["Total Level Staked",{"$f":"SUM((COUNTIF(INDIRECT(\"G18\"):INDIRECT(\"G10000\"),\"<>\"))-(COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\" \")))","v":26}]
["Return",{"$f":"SUM(INDIRECT(\"N18\"):INDIRECT(\"N10000\"))","v":27.760000000000005}]
["ROI",{"$f":"IF(B13<>0,B14/B13,0)","v":1.0676923076923079}]
[]
["Date","Sport","Pick","Bookie","Odds","Back/Lay","Stake/Win","Com.","W/L","Type:",null,"Actual P/L","Total P/L","LS P/L","LS Total P/L"]
["2016-08-08","Tennis","J Sousa +4.5 (Games Handicap)","Marathon Bet",1.9650000000000001,"B",100,0,"W","Elite",null,{"$f":"IF(OR(I18=\"\",I18=\"-\"),\"\",IF(I18=\"V\",0,IF(I18=\"W\",IF(F18=\"B\",ROUND(((E18-1)*G18)-(H18*((E18-1)*G18)),2)*(IF(ISBLANK(K18),1,1-K18)),G18),IF(I18=\"P\",((G18/2)*((E18-1)/J18)) *(IF(ISBLANK(K18),1,1-K18))-(G18/2),IF(I18=\"EWW\",IF(OR(F18=\"B\", F18=\"EW\"),G18/2*(E18-1)+(G18/2)*((E18-1)/J18)) *(IF(ISBLANK(K18),1,1-K18)),IF(I18=\"L\",IF(F18=\"B\",-(G18),IF(F18=\"EW\",-(G18),-(ROUND(((E18-1)*G18)-(H18*((E18-1)*G18)),2))))))))))","v":96.5},{"$f":"IF(ISNUMBER(#REF!),IF(L18<>\"\",#REF!+L18,\"\"),L18)","v":96.5},{"$f":"IF(OR(I18=\"\",I18=\"-\"),\"\",IF(I18=\"V\",0,IF(I18=\"W\",IF(F18=\"B\",ROUND(((E18-1)*1)-(H18*((E18-1)*1)),2) *(IF(ISBLANK(K18),1,1-K18)),1),IF(I18=\"P\",((1/2)*((E18-1)/J18)) *(IF(ISBLANK(K18),1,1-K18))-(1/2),IF(I18=\"EWW\",IF(OR(F18=\"B\", F18=\"EW\"),1/2*(E18-1)+(1/2)*((E18-1)/J18)) *(IF(ISBLANK(K18),1,1-K18)),IF(I18=\"L\",IF(F18=\"B\",-(1),IF(F18=\"EW\",-(1),-(ROUND(((E18-1)*1)-(H18*((E18-1)*1)),2))))))))))","v":0.97},{"$f":"IF(ISNUMBER(#REF!),IF(N18<>\"\",#REF!+N18,\"\"),N18)","v":0.97}]
["2016-08-08","Tennis","M Michalicka","Pinnacle",5.39,"B",100,0,"W","VIP",null,439,{"$f":"IF(ISNUMBER(#REF!),IF(L19<>\"\",#REF!+L19,\"\"),L19)","v":439},4.3899999999999997,{"$f":"IF(ISNUMBER(#REF!),IF(N19<>\"\",#REF!+N19,\"\"),N19)","v":4.3899999999999997}]
["2016-08-07","Tennis","J Isner","Coral",2,"B",200,0,"L","Elite",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L20<>\"\",#REF!+L20,\"\"),L20)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N20<>\"\",#REF!+N20,\"\"),N20)","v":-1}]
["2016-08-07","Tennis","A De Greef","Pinnacle",3.74,"B",200,0,"W","Elite",null,548,{"$f":"IF(ISNUMBER(#REF!),IF(L21<>\"\",#REF!+L21,\"\"),L21)","v":548},2.74,{"$f":"IF(ISNUMBER(#REF!),IF(N21<>\"\",#REF!+N21,\"\"),N21)","v":2.74}]
["2016-08-06","Tennis","Y Uchiyama","Coral",3.5,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L22<>\"\",#REF!+L22,\"\"),L22)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N22<>\"\",#REF!+N22,\"\"),N22)","v":-1}]
["2016-08-04","Tennis","J Isner","Betfair",1.32,"B",100,0,"W","Elite",null,32,{"$f":"IF(ISNUMBER(#REF!),IF(L23<>\"\",#REF!+L23,\"\"),L23)","v":32},0.32,{"$f":"IF(ISNUMBER(#REF!),IF(N23<>\"\",#REF!+N23,\"\"),N23)","v":0.32}]
["2016-08-04","Tennis","Y Nishioka","Pinnacle",3.2629999999999999,"B",100,0,"W","Free",null,226.3,{"$f":"IF(ISNUMBER(#REF!),IF(L24<>\"\",#REF!+L24,\"\"),L24)","v":226.3},2.2599999999999998,{"$f":"IF(ISNUMBER(#REF!),IF(N24<>\"\",#REF!+N24,\"\"),N24)","v":2.2599999999999998}]
["2016-08-03","Tennis","R Opelka +1.5 (Set Handicap)","BetVictor",2.9,"B",100,0,"W","Elite",null,190,{"$f":"IF(ISNUMBER(#REF!),IF(L25<>\"\",#REF!+L25,\"\"),L25)","v":190},1.9,{"$f":"IF(ISNUMBER(#REF!),IF(N25<>\"\",#REF!+N25,\"\"),N25)","v":1.9}]
["2016-08-02","Tennis","Z Zhang","Marathon Bet",2.91,"B",100,0,"W","VIP",null,191,{"$f":"IF(ISNUMBER(#REF!),IF(L26<>\"\",#REF!+L26,\"\"),L26)","v":191},1.91,{"$f":"IF(ISNUMBER(#REF!),IF(N26<>\"\",#REF!+N26,\"\"),N26)","v":1.91}]
["2016-08-01","Tennis","V Galovic","Coral",3.75,"B",800,0,"W","Elite",null,2200,{"$f":"IF(ISNUMBER(#REF!),IF(L27<>\"\",#REF!+L27,\"\"),L27)","v":2200},2.75,{"$f":"IF(ISNUMBER(#REF!),IF(N27<>\"\",#REF!+N27,\"\"),N27)","v":2.75}]
["2016-07-31","Tennis","K Nishikori +1.5 (Set Handicap)","Pinnacle",2.75,"B",500,0,"L","Elite",null,-500,{"$f":"IF(ISNUMBER(#REF!),IF(L28<>\"\",#REF!+L28,\"\"),L28)","v":-500},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N28<>\"\",#REF!+N28,\"\"),N28)","v":-1}]
["2016-07-31","Tennis","G Monfils +1.5 (Set Handicap)","William Hill",3.25,"B",200,0,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L29<>\"\",#REF!+L29,\"\"),L29)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N29<>\"\",#REF!+N29,\"\"),N29)","v":-1}]
["2016-07-30","Tennis","Juan C M Aguilar","Smarkets.com",3.8,"B",100,0.02,"L","Elite",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L30<>\"\",#REF!+L30,\"\"),L30)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N30<>\"\",#REF!+N30,\"\"),N30)","v":-1}]
["2016-07-30","Tennis","G Monfils","Pinnacle",4.3,"B",200,0,"W","VIP",null,660,{"$f":"IF(ISNUMBER(#REF!),IF(L31<>\"\",#REF!+L31,\"\"),L31)","v":660},3.3,{"$f":"IF(ISNUMBER(#REF!),IF(N31<>\"\",#REF!+N31,\"\"),N31)","v":3.3}]
["2016-07-28","Tennis","B Westerhof","Pinnacle",4.5,"B",100,0,"L","Elite",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L32<>\"\",#REF!+L32,\"\"),L32)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N32<>\"\",#REF!+N32,\"\"),N32)","v":-1}]
["2016-07-28","Tennis","D Nguyen","Smarkets.com",3.25,"B",100,0.02,"W","Free",null,220.5,{"$f":"IF(ISNUMBER(#REF!),IF(L33<>\"\",#REF!+L33,\"\"),L33)","v":220.5},2.21,{"$f":"IF(ISNUMBER(#REF!),IF(N33<>\"\",#REF!+N33,\"\"),N33)","v":2.21}]
["2016-07-27","Tennis","R Harrison","Smarkets.com",5,"B",250,0.02,"W","VIP",null,980,{"$f":"IF(ISNUMBER(#REF!),IF(L34<>\"\",#REF!+L34,\"\"),L34)","v":980},3.92,{"$f":"IF(ISNUMBER(#REF!),IF(N34<>\"\",#REF!+N34,\"\"),N34)","v":3.92}]
["2016-07-26","Tennis","A Zverev ","Ladbrokes",1.38,"B",100,0,"L","Elite",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L35<>\"\",#REF!+L35,\"\"),L35)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N35<>\"\",#REF!+N35,\"\"),N35)","v":-1}]
["2016-07-25","Tennis","G Muller -1.5 (Set Handicap)","Pinnacle",1.8420000000000001,"B",150,0,"W","VIP",null,126.3,{"$f":"IF(ISNUMBER(#REF!),IF(L36<>\"\",#REF!+L36,\"\"),L36)","v":126.3},0.84,{"$f":"IF(ISNUMBER(#REF!),IF(N36<>\"\",#REF!+N36,\"\"),N36)","v":0.84}]
["2016-07-24","Tennis","J Donaldson -1.5 (Set Handicap)","Pinnacle",1.95,"B",30,0,"W","VIP",null,28.5,{"$f":"IF(ISNUMBER(#REF!),IF(L37<>\"\",#REF!+L37,\"\"),L37)","v":28.5},0.95,{"$f":"IF(ISNUMBER(#REF!),IF(N37<>\"\",#REF!+N37,\"\"),N37)","v":0.95}]
["2016-07-24","Tennis","J Donaldson","Smarkets.com",1.38,"B",100,0.02,"W","Elite",null,37.24,{"$f":"IF(ISNUMBER(#REF!),IF(L38<>\"\",#REF!+L38,\"\"),L38)","v":37.24},0.37,{"$f":"IF(ISNUMBER(#REF!),IF(N38<>\"\",#REF!+N38,\"\"),N38)","v":0.37}]
["2016-07-23","Tennis","A Krajicek","Smarkets.com",1.45,"B",100,0.02,"W","Elite",null,44.1,{"$f":"IF(ISNUMBER(#REF!),IF(L39<>\"\",#REF!+L39,\"\"),L39)","v":44.1},0.44,{"$f":"IF(ISNUMBER(#REF!),IF(N39<>\"\",#REF!+N39,\"\"),N39)","v":0.44}]
["2016-07-23","Tennis","L Davis ","Pinnacle",2.5,"B",100,0,"W","VIP",null,150,{"$f":"IF(ISNUMBER(#REF!),IF(L40<>\"\",#REF!+L40,\"\"),L40)","v":150},1.5,{"$f":"IF(ISNUMBER(#REF!),IF(N40<>\"\",#REF!+N40,\"\"),N40)","v":1.5}]
["2016-07-22","Tennis","M Krueger -1.5 (Set Handicap)","Marathon Bet",2.69,"B",100,0,"W","Free",null,169,{"$f":"IF(ISNUMBER(#REF!),IF(L41<>\"\",#REF!+L41,\"\"),L41)","v":169},1.69,{"$f":"IF(ISNUMBER(#REF!),IF(N41<>\"\",#REF!+N41,\"\"),N41)","v":1.69}]
["2016-07-22","Tennis","P Carreno-Busta","Coral",1.4,"B",50,0,"L","VIP",null,-50,{"$f":"IF(ISNUMBER(#REF!),IF(L42<>\"\",#REF!+L42,\"\"),L42)","v":-50},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N42<>\"\",#REF!+N42,\"\"),N42)","v":-1}]
["2016-07-21","Tennis","T Monteiro","Pinnacle",4.3,"B",100,0,"W","Elite",null,330,{"$f":"IF(ISNUMBER(#REF!),IF(L43<>\"\",#REF!+L43,\"\"),L43)","v":330},3.3,{"$f":"IF(ISNUMBER(#REF!),IF(N43<>\"\",#REF!+N43,\"\"),N43)","v":3.3}]

{"sheet":"Sports and Bookies","index":1,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Sports (Tennis Tips UK)"]
[]
["Sport","Staked","P/L","ROI","Level Staked","P/L","ROI",null,null,"Bookmaker ","Deposited","Withdrawn","Pending","P/L","Balance"]
["Soccer",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A4,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A4,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},{"$f":"IF(B4<>0,C4/B4,0)","v":0},{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A4))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A4,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},{"$f":"IF(E4<>0,F4/E4,0)","v":0},null,null,"Bet365",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J4),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"(O4+M4)-(K4-L4)","v":0},{"$f":"((K4+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J4,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L4)-M4)","v":0}]
["Tennis",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A5,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":4180},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A5,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":5318.4400000000005},1.2723540669856461,{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A5))","v":26},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A5,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":27.760000000000005},1.0676923076923079,null,null,"Smarkets.com",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J5),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},1181.8399999999999,{"$f":"((K5+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J5,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L5)-M5)","v":1181.8399999999999}]
["Horse Racing",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A6,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A6,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},0,{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A6))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A6,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},0,null,null,"Betbright",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J6),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K6+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J6,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L6)-M6)","v":0}]
["AFL",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A7,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A7,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},0,{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A7))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A7,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},0,null,null,"Betdaq",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J7),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K7+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J7,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L7)-M7)","v":0}]
["Baseball",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A8,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A8,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},0,{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A8))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A8,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},0,null,null,"Betfair",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J8),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},32,{"$f":"((K8+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J8,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L8)-M8)","v":32}]
["Baseketball",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A9,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A9,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},0,{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A9))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A9,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},0,null,null,"Betfred",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J9),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K9+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J9,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L9)-M9)","v":0}]
["Cricket",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A10,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A10,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},0,{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A10))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A10,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},0,null,null,"Bet Internet",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J10),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K10+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J10,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L10)-M10)","v":0}]
["Darts",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A11,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A11,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},0,{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A11))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A11,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},0,null,null,"Betway",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J11),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K11+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J11,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L11)-M11)","v":0}]
["Dogs",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A12,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A12,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},0,{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A12))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A12,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},0,null,null,"BetVictor",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J12),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},190,{"$f":"((K12+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J12,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L12)-M12)","v":190}]
["F1",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A13,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A13,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},{"$f":"IF(B13<>0,C13/B13,0)","v":0},{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A13))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A13,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},{"$f":"IF(E13<>0,F13/E13,0)","v":0},null,null,"Boylesports",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J13),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K13+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J13,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L13)-M13)","v":0}]
["NFL",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A14,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A14,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},{"$f":"IF(B14<>0,C14/B14,0)","v":0},{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A14))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A14,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},{"$f":"IF(E14<>0,F14/E14,0)","v":0},null,null,"Coral",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J14),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},1850,{"$f":"((K14+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J14,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L14)-M14)","v":1850}]
["Rugby",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A15,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A15,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},{"$f":"IF(B15<>0,C15/B15,0)","v":0},{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A15))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A15,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},{"$f":"IF(E15<>0,F15/E15,0)","v":0},null,null,"Ladbrokes",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J15),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},-100,{"$f":"((K15+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J15,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L15)-M15)","v":-100}]
["Other",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A16,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A16,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":0},{"$f":"IF(B16<>0,C16/B16,0)","v":0},{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A16))","v":0},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A16,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":0},{"$f":"IF(E16<>0,F16/E16,0)","v":0},null,null,"Paddy Power",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J16),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K16+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J16,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L16)-M16)","v":0}]
["Total",{"$f":"SUM(B4:B16)","v":4180},{"$f":"SUM(C4:C16)","v":5318.4400000000005},{"$f":"IF(B17<>0,C17/B17,0)","v":1.2723540669856461},{"$f":"SUM(E4:E16)","v":26},{"$f":"SUM(F4:F16)","v":27.760000000000005},{"$f":"IF(E17<>0,F17/E17,0)","v":1.0676923076923079},null,null,"Pinnacle",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J17),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},1908.1,{"$f":"((K17+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J17,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L17)-M17)","v":1908.1}]
[null,null,null,null,null,null,null,null,null,"Racebets",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J18),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K18+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J18,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L18)-M18)","v":0}]
[null,null,null,null,null,null,null,null,null,"Seaniemac",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J19),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K19+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J19,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L19)-M19)","v":0}]
[null,null,null,null,null,null,null,null,null,"Sky Bet",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J20),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K20+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J20,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L20)-M20)","v":0}]
[null,null,null,null,null,null,null,null,null,"Sportingbet",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J21),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K21+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J21,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L21)-M21)","v":0}]
[null,null,null,null,null,null,null,null,null,"Stan James",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J22),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},{"$f":"(O22+M22)-(K22-L22)","v":0},{"$f":"((K22+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J22,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L22)-M22)","v":0}]
[null,null,null,null,null,null,null,null,null,"Titan Bet",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J23),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K23+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J23,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L23)-M23)","v":0}]
[null,null,null,null,null,null,null,null,null,"Totesport",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J24),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K24+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J24,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L24)-M24)","v":0}]
[null,null,null,null,null,null,null,null,null,"Unibet",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J25),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K25+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J25,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L25)-M25)","v":0}]
[null,null,null,null,null,null,null,null,null,"William Hill",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J26),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},-200,{"$f":"((K26+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J26,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L26)-M26)","v":-200}]
[null,null,null,null,null,null,null,null,null,"Marathon Bet",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J27),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},456.5,{"$f":"((K27+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J27,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L27)-M27)","v":456.5}]
[null,null,null,null,null,null,null,null,null,"888Sport",0,0,{"$f":"SUMPRODUCT(--(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\")=J28),--(INDIRECT(\"Bets!I18\"):INDIRECT(\"Bets!I10000\")=\"-\"),INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":0},0,{"$f":"((K28+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J28,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L28)-M28)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Totals",{"$f":"SUM(K4:K28)","v":0},{"$f":"SUM(L4:L28)","v":0},{"$f":"SUM(M4:M28)","v":0},{"$f":"SUM(N4:N28)","v":5318.4400000000005},{"$f":"SUM(O4:O28)","v":5318.4400000000005}]