{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Bets","Sports and Bookies"],"not_rendered":{"charts":0,"images":1,"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":157,"n_cols":15,"rows_kept":157,"cut":false,"hidden":false,"merged":[]}
["                                                        "]
[]
[]
[]
[]
["Total No. Bets",{"$f":"B7+B8+B9","v":139}]
["Total No. Winners",{"$f":"COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"W\")+COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"EWW\")+COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"P\")","v":60},{"$f":"IF(B7<>0,B7/B6,0)","v":0.43165467625899279}]
["Total No. Losers",{"$f":"COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"L\")","v":71},{"$f":"IF(B8<>0,B8/B6,0)","v":0.51079136690647486}]
["Total No. Void",{"$f":"COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"V\")","v":8},{"$f":"IF(B9<>0,B9/B6,0)","v":5.7553956834532377E-2}]
["Total Staked",{"$f":"SUMIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\"<> \",INDIRECT(\"G18\"):INDIRECT(\"G10000\"))","v":46680}]
["Return",{"$f":"SUM(INDIRECT(\"L18\"):INDIRECT(\"L10000\"))","v":26008.399999999998}]
["ROI (Return on Investment)",{"$f":"IF(B10<>0,B11/B10,0)","v":0.55716366752356461}]
["Total Level Staked",{"$f":"SUM((COUNTIF(INDIRECT(\"G18\"):INDIRECT(\"G10000\"),\"<>\"))-(COUNTIF(INDIRECT(\"I18\"):INDIRECT(\"I10000\"),\" \")))","v":140}]
["Return",{"$f":"SUM(INDIRECT(\"N18\"):INDIRECT(\"N10000\"))","v":51.199999999999989}]
["ROI",{"$f":"IF(B13<>0,B14/B13,0)","v":0.36571428571428566}]
[]
["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-10-29","Tennis","Y Lu","Marathon Bet",1.9750000000000001,"B",100,0,"-","VIP",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":""},{"$f":"IF(ISNUMBER(#REF!),IF(L18<>\"\",#REF!+L18,\"\"),L18)","v":""},{"$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":""},{"$f":"IF(ISNUMBER(#REF!),IF(N18<>\"\",#REF!+N18,\"\"),N18)","v":""}]
["2016-10-28","Tennis","M Zverev","Coral",3.6,"B",1000,0,"W","Premium Investment",null,2600,{"$f":"IF(ISNUMBER(#REF!),IF(L19<>\"\",#REF!+L19,\"\"),L19)","v":2600},2.6,{"$f":"IF(ISNUMBER(#REF!),IF(N19<>\"\",#REF!+N19,\"\"),N19)","v":2.6}]
["2016-10-28","Tennis","G Muguruza ","Smarkets.com",1.93,"B",500,0.02,"W","VIP",null,455.7,{"$f":"IF(ISNUMBER(#REF!),IF(L20<>\"\",#REF!+L20,\"\"),L20)","v":455.7},0.91,{"$f":"IF(ISNUMBER(#REF!),IF(N20<>\"\",#REF!+N20,\"\"),N20)","v":0.91}]
["2016-10-27","Tennis","D Goffin + 1.5 (Set Handicap)","Pinnacle",1.7290000000000001,"B",300,0,"L","Standard",null,-300,{"$f":"IF(ISNUMBER(#REF!),IF(L21<>\"\",#REF!+L21,\"\"),L21)","v":-300},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N21<>\"\",#REF!+N21,\"\"),N21)","v":-1}]
["2016-10-26","Tennis","P Kohlschreiber (Lay / Bet Against)","Smarkets.com",1.3,"L",1000,0,"L","Premium Investment",null,-300,{"$f":"IF(ISNUMBER(#REF!),IF(L22<>\"\",#REF!+L22,\"\"),L22)","v":-300},-0.3,{"$f":"IF(ISNUMBER(#REF!),IF(N22<>\"\",#REF!+N22,\"\"),N22)","v":-0.3}]
["2016-10-26","Tennis","A Mannarino","Marathon Bet",2.7650000000000001,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L23<>\"\",#REF!+L23,\"\"),L23)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N23<>\"\",#REF!+N23,\"\"),N23)","v":-1}]
["2016-10-25","Tennis","M Raonic (Lay / Bet Against)","Smarkets.com",1.1000000000000001,"L",1000,0.02,"W","Premium Investment",null,1000,{"$f":"IF(ISNUMBER(#REF!),IF(L24<>\"\",#REF!+L24,\"\"),L24)","v":1000},1,{"$f":"IF(ISNUMBER(#REF!),IF(N24<>\"\",#REF!+N24,\"\"),N24)","v":1}]
["2016-10-25","Tennis","M Keys","Smarkets.com",2.1800000000000002,"B",300,0.02,"W","VIP",null,346.92,{"$f":"IF(ISNUMBER(#REF!),IF(L25<>\"\",#REF!+L25,\"\"),L25)","v":346.92},1.1599999999999999,{"$f":"IF(ISNUMBER(#REF!),IF(N25<>\"\",#REF!+N25,\"\"),N25)","v":1.1599999999999999}]
["2016-10-25","Tennis","Over 22.5 Games (Sousa vs Cuevas)","Marathon Bet",1.91,"B",200,0,"V","Standard",null,0,{"$f":"IF(ISNUMBER(#REF!),IF(L26<>\"\",#REF!+L26,\"\"),L26)","v":0},0,{"$f":"IF(ISNUMBER(#REF!),IF(N26<>\"\",#REF!+N26,\"\"),N26)","v":0}]
["2016-10-25","Tennis","D Lajovic +2.5 (1st Set Handicap)","Marathon Bet",1.875,"B",200,0,"W","Premium Investment",null,175,{"$f":"IF(ISNUMBER(#REF!),IF(L27<>\"\",#REF!+L27,\"\"),L27)","v":175},0.88,{"$f":"IF(ISNUMBER(#REF!),IF(N27<>\"\",#REF!+N27,\"\"),N27)","v":0.88}]
["2016-10-24","Tennis","G Muller","Marathon Bet",2.77,"B",100,0,"W","VIP",null,177,{"$f":"IF(ISNUMBER(#REF!),IF(L28<>\"\",#REF!+L28,\"\"),L28)","v":177},1.77,{"$f":"IF(ISNUMBER(#REF!),IF(N28<>\"\",#REF!+N28,\"\"),N28)","v":1.77}]
["2016-10-23","Tennis","Yen-Hsun Lu -3.5 (Games Handicap)","Pinnacle",1.869,"B",100,0,"W","VIP",null,86.9,{"$f":"IF(ISNUMBER(#REF!),IF(L29<>\"\",#REF!+L29,\"\"),L29)","v":86.9},0.87,{"$f":"IF(ISNUMBER(#REF!),IF(N29<>\"\",#REF!+N29,\"\"),N29)","v":0.87}]
["2016-10-22","Tennis","F Fognini","William Hill",2,"B",100,0,"W","VIP",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-10-21","Tennis","Over 22 Games (Kuznetsova vs Svitolina)","Pinnacle",1.99,"B",100,0,"W","VIP",null,99,{"$f":"IF(ISNUMBER(#REF!),IF(L31<>\"\",#REF!+L31,\"\"),L31)","v":99},0.99,{"$f":"IF(ISNUMBER(#REF!),IF(N31<>\"\",#REF!+N31,\"\"),N31)","v":0.99}]
["2016-10-20","Tennis","J L Struff","Pinnacle",3.72,"B",200,0,"W","VIP",null,544,{"$f":"IF(ISNUMBER(#REF!),IF(L32<>\"\",#REF!+L32,\"\"),L32)","v":544},2.72,{"$f":"IF(ISNUMBER(#REF!),IF(N32<>\"\",#REF!+N32,\"\"),N32)","v":2.72}]
["2016-10-19","Tennis","E Donskoy","Marathon Bet",1.87,"B",100,0,"L","Standard",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L33<>\"\",#REF!+L33,\"\"),L33)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N33<>\"\",#REF!+N33,\"\"),N33)","v":-1}]
["2016-10-18","Tennis","G Jacq","Pinnacle",2.63,"B",800,0,"W","Premium Investment",null,1304,{"$f":"IF(ISNUMBER(#REF!),IF(L34<>\"\",#REF!+L34,\"\"),L34)","v":1304},1.63,{"$f":"IF(ISNUMBER(#REF!),IF(N34<>\"\",#REF!+N34,\"\"),N34)","v":1.63}]
["2016-10-18","Tennis","D Brown","Marathon Bet",3.2629999999999999,"B",200,0,"W","VIP",null,452.6,{"$f":"IF(ISNUMBER(#REF!),IF(L35<>\"\",#REF!+L35,\"\"),L35)","v":452.6},2.2599999999999998,{"$f":"IF(ISNUMBER(#REF!),IF(N35<>\"\",#REF!+N35,\"\"),N35)","v":2.2599999999999998}]
["2016-10-17","Tennis","J McGee","Coral",1.84,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L36<>\"\",#REF!+L36,\"\"),L36)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N36<>\"\",#REF!+N36,\"\"),N36)","v":-1}]
["2016-10-16","Tennis","M Gawron","Sky Bet",1.84,"B",1000,0,"W","Standard",null,840,{"$f":"IF(ISNUMBER(#REF!),IF(L37<>\"\",#REF!+L37,\"\"),L37)","v":840},0.84,{"$f":"IF(ISNUMBER(#REF!),IF(N37<>\"\",#REF!+N37,\"\"),N37)","v":0.84}]
["2016-10-16","Tennis","Over 20.5 Games (Wozniacki vs Mladenovic)","Pinnacle",1.9339999999999999,"B",100,0,"W","VIP",null,93.4,{"$f":"IF(ISNUMBER(#REF!),IF(L38<>\"\",#REF!+L38,\"\"),L38)","v":93.4},0.93,{"$f":"IF(ISNUMBER(#REF!),IF(N38<>\"\",#REF!+N38,\"\"),N38)","v":0.93}]
["2016-10-15","Tennis","R Bautista-Agut","Betway",6.5,"B",1000,0,"W","VIP",null,5500,{"$f":"IF(ISNUMBER(#REF!),IF(L39<>\"\",#REF!+L39,\"\"),L39)","v":5500},5.5,{"$f":"IF(ISNUMBER(#REF!),IF(N39<>\"\",#REF!+N39,\"\"),N39)","v":5.5}]
["2016-10-14","Tennis","Over 22.5 Games (Zeballos vs Dutra Silva)","Paddy Power",2,"B",500,0,"L","VIP",null,-500,{"$f":"IF(ISNUMBER(#REF!),IF(L40<>\"\",#REF!+L40,\"\"),L40)","v":-500},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N40<>\"\",#REF!+N40,\"\"),N40)","v":-1}]
["2016-10-14","Tennis","J W Tsonga","Smarkets.com",1.71,"B",300,0.02,"L","VIP",null,-300,{"$f":"IF(ISNUMBER(#REF!),IF(L41<>\"\",#REF!+L41,\"\"),L41)","v":-300},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N41<>\"\",#REF!+N41,\"\"),N41)","v":-1}]
["2016-10-13","Tennis","Over 22.5 Games  (Groth v Escobedo)","Bet365",1.8,"B",100,0,"W","VIP",null,80,{"$f":"IF(ISNUMBER(#REF!),IF(L42<>\"\",#REF!+L42,\"\"),L42)","v":80},0.8,{"$f":"IF(ISNUMBER(#REF!),IF(N42<>\"\",#REF!+N42,\"\"),N42)","v":0.8}]
["2016-10-13","Tennis","A Zverev ","Smarkets.com",2.04,"B",1000,0.02,"L","VIP",null,-1000,{"$f":"IF(ISNUMBER(#REF!),IF(L43<>\"\",#REF!+L43,\"\"),L43)","v":-1000},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N43<>\"\",#REF!+N43,\"\"),N43)","v":-1}]
["2016-10-13","Tennis","S Johnson","Smarkets.com",11,"B",100,0.02,"L","Premium Investment",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L44<>\"\",#REF!+L44,\"\"),L44)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N44<>\"\",#REF!+N44,\"\"),N44)","v":-1}]
["2016-10-12","Tennis","V Troicki","Pinnacle",5.04,"B",500,0,"W","Premium Investment",null,2020,{"$f":"IF(ISNUMBER(#REF!),IF(L45<>\"\",#REF!+L45,\"\"),L45)","v":2020},4.04,{"$f":"IF(ISNUMBER(#REF!),IF(N45<>\"\",#REF!+N45,\"\"),N45)","v":4.04}]
["2016-10-12","Tennis","A Bublik +1.5 (Set Handicap)","Paddy Power",2.375,"B",500,0,"V","Standard",null,0,{"$f":"IF(ISNUMBER(#REF!),IF(L46<>\"\",#REF!+L46,\"\"),L46)","v":0},0,{"$f":"IF(ISNUMBER(#REF!),IF(N46<>\"\",#REF!+N46,\"\"),N46)","v":0}]
["2016-10-11","Tennis","M Mmoh + 1.5 (Set Handicap)","Paddy Power",1.5329999999999999,"B",300,0,"L","VIP",null,-300,{"$f":"IF(ISNUMBER(#REF!),IF(L47<>\"\",#REF!+L47,\"\"),L47)","v":-300},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N47<>\"\",#REF!+N47,\"\"),N47)","v":-1}]
["2016-10-11","Tennis","P Gunneswaran","Unibet",2.75,"B",200,0,"W","VIP",null,350,{"$f":"IF(ISNUMBER(#REF!),IF(L48<>\"\",#REF!+L48,\"\"),L48)","v":350},1.75,{"$f":"IF(ISNUMBER(#REF!),IF(N48<>\"\",#REF!+N48,\"\"),N48)","v":1.75}]
["2016-10-11","Tennis","D Goffin","Pinnacle",3.32,"B",100,0,"W","VIP",null,232,{"$f":"IF(ISNUMBER(#REF!),IF(L49<>\"\",#REF!+L49,\"\"),L49)","v":232},2.3199999999999998,{"$f":"IF(ISNUMBER(#REF!),IF(N49<>\"\",#REF!+N49,\"\"),N49)","v":2.3199999999999998}]
["2016-10-11","Tennis","N Broady","Pinnacle",7.13,"B",100,0,"L","Standard",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L50<>\"\",#REF!+L50,\"\"),L50)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N50<>\"\",#REF!+N50,\"\"),N50)","v":-1}]
["2016-10-09","Tennis","D Goffin + 1.5 (Set Handicap)","Betway",1.704,"B",500,0,"W","VIP",null,352,{"$f":"IF(ISNUMBER(#REF!),IF(L51<>\"\",#REF!+L51,\"\"),L51)","v":352},0.7,{"$f":"IF(ISNUMBER(#REF!),IF(N51<>\"\",#REF!+N51,\"\"),N51)","v":0.7}]
["2016-10-09","Tennis","D Goffin","Pinnacle",2.8,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L52<>\"\",#REF!+L52,\"\"),L52)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N52<>\"\",#REF!+N52,\"\"),N52)","v":-1}]
["2016-10-08","Tennis","G Dimitrov","Pinnacle",2.4,"B",300,0,"V","VIP",null,0,{"$f":"IF(ISNUMBER(#REF!),IF(L53<>\"\",#REF!+L53,\"\"),L53)","v":0},0,{"$f":"IF(ISNUMBER(#REF!),IF(N53<>\"\",#REF!+N53,\"\"),N53)","v":0}]
["2016-10-08","Tennis","D Ferrer +1.5 (Set Handicap)","Pinnacle",2.7,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L54<>\"\",#REF!+L54,\"\"),L54)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N54<>\"\",#REF!+N54,\"\"),N54)","v":-1}]
["2016-10-07","Tennis","D Ferrer ","Smarkets.com",2.2000000000000002,"B",300,0.02,"W","Standard",null,352.8,{"$f":"IF(ISNUMBER(#REF!),IF(L55<>\"\",#REF!+L55,\"\"),L55)","v":352.8},1.18,{"$f":"IF(ISNUMBER(#REF!),IF(N55<>\"\",#REF!+N55,\"\"),N55)","v":1.18}]
["2016-10-06","Tennis","R Nadal -5.5 (Games Handicap)","Paddy Power",1.8,"B",500,0,"W","VIP",null,400,{"$f":"IF(ISNUMBER(#REF!),IF(L56<>\"\",#REF!+L56,\"\"),L56)","v":400},0.8,{"$f":"IF(ISNUMBER(#REF!),IF(N56<>\"\",#REF!+N56,\"\"),N56)","v":0.8}]
["2016-10-06","Tennis","G Simon","William Hill",3.4,"B",100,0,"L","Premium Investment",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L57<>\"\",#REF!+L57,\"\"),L57)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N57<>\"\",#REF!+N57,\"\"),N57)","v":-1}]
["2016-10-06","Tennis","R Stepanek +4 (Games Handicap)","Pinnacle",2.0699999999999998,"B",100,0,"V","VIP",null,0,{"$f":"IF(ISNUMBER(#REF!),IF(L58<>\"\",#REF!+L58,\"\"),L58)","v":0},0,{"$f":"IF(ISNUMBER(#REF!),IF(N58<>\"\",#REF!+N58,\"\"),N58)","v":0}]
["2016-10-03","Tennis","A Zverev","BoyleSports",2.25,"B",200,0,"W","VIP",null,250,{"$f":"IF(ISNUMBER(#REF!),IF(L59<>\"\",#REF!+L59,\"\"),L59)","v":250},1.25,{"$f":"IF(ISNUMBER(#REF!),IF(N59<>\"\",#REF!+N59,\"\"),N59)","v":1.25}]
["2016-10-02","Tennis","M Mmoh","William Hill",2,"B",100,0,"L","Standard",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L60<>\"\",#REF!+L60,\"\"),L60)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N60<>\"\",#REF!+N60,\"\"),N60)","v":-1}]
["2016-10-02","Tennis","J Satral","Pinnacle",3,"B",1000,0,"W","Premium Investment",null,2000,{"$f":"IF(ISNUMBER(#REF!),IF(L61<>\"\",#REF!+L61,\"\"),L61)","v":2000},2,{"$f":"IF(ISNUMBER(#REF!),IF(N61<>\"\",#REF!+N61,\"\"),N61)","v":2}]
["2016-10-01","Tennis","Tim Smyczek -1.5 (Set Handicap)","Pinnacle",2.2189999999999999,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L62<>\"\",#REF!+L62,\"\"),L62)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N62<>\"\",#REF!+N62,\"\"),N62)","v":-1}]
["2016-09-30","Tennis","K Khachanov","Smarkets.com",2.6,"B",100,0.02,"W","VIP",null,156.80000000000001,{"$f":"IF(ISNUMBER(#REF!),IF(L63<>\"\",#REF!+L63,\"\"),L63)","v":156.80000000000001},1.57,{"$f":"IF(ISNUMBER(#REF!),IF(N63<>\"\",#REF!+N63,\"\"),N63)","v":1.57}]
["2016-09-30","Tennis","M McDonald","Smarkets.com",3.05,"B",1000,0.02,"W","VIP",null,2009,{"$f":"IF(ISNUMBER(#REF!),IF(L64<>\"\",#REF!+L64,\"\"),L64)","v":2009},2.0099999999999998,{"$f":"IF(ISNUMBER(#REF!),IF(N64<>\"\",#REF!+N64,\"\"),N64)","v":2.0099999999999998}]
["2016-09-30","Tennis","D Medvedev","Marathon Bet",1.444,"B",1000,0,"L","VIP",null,-1000,{"$f":"IF(ISNUMBER(#REF!),IF(L65<>\"\",#REF!+L65,\"\"),L65)","v":-1000},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N65<>\"\",#REF!+N65,\"\"),N65)","v":-1}]
["2016-09-30","Tennis","J Vesely","BetVictor",4,"B",200,0,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L66<>\"\",#REF!+L66,\"\"),L66)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N66<>\"\",#REF!+N66,\"\"),N66)","v":-1}]
["2016-09-29","Tennis","F Volandri","Paddy Power",2.2000000000000002,"B",100,0,"L","Standard",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L67<>\"\",#REF!+L67,\"\"),L67)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N67<>\"\",#REF!+N67,\"\"),N67)","v":-1}]
["2016-09-29","Tennis","D Brands +1.5 (Set Handicap)","Paddy Power",1.5,"B",500,0,"W","VIP",null,250,{"$f":"IF(ISNUMBER(#REF!),IF(L68<>\"\",#REF!+L68,\"\"),L68)","v":250},0.5,{"$f":"IF(ISNUMBER(#REF!),IF(N68<>\"\",#REF!+N68,\"\"),N68)","v":0.5}]
["2016-09-29","Tennis","D Wu +5.5 (Games Handicap)","Pinnacle",2,"B",100,0,"V","Standard",null,0,{"$f":"IF(ISNUMBER(#REF!),IF(L69<>\"\",#REF!+L69,\"\"),L69)","v":0},0,{"$f":"IF(ISNUMBER(#REF!),IF(N69<>\"\",#REF!+N69,\"\"),N69)","v":0}]
["2016-09-29","Tennis","D Wu ","Pinnacle",8.5,"B",100,0,"V","Premium Investment",null,0,{"$f":"IF(ISNUMBER(#REF!),IF(L70<>\"\",#REF!+L70,\"\"),L70)","v":0},0,{"$f":"IF(ISNUMBER(#REF!),IF(N70<>\"\",#REF!+N70,\"\"),N70)","v":0}]
["2016-09-29","Tennis","C Zampieri","Pinnacle",3.8,"B",500,0,"W","VIP",null,1400,{"$f":"IF(ISNUMBER(#REF!),IF(L71<>\"\",#REF!+L71,\"\"),L71)","v":1400},2.8,{"$f":"IF(ISNUMBER(#REF!),IF(N71<>\"\",#REF!+N71,\"\"),N71)","v":2.8}]
["2016-09-28","Tennis","Y Nishioka","Smarkets.com",3.4,"B",300,0.02,"V","VIP",null,0,{"$f":"IF(ISNUMBER(#REF!),IF(L72<>\"\",#REF!+L72,\"\"),L72)","v":0},0,{"$f":"IF(ISNUMBER(#REF!),IF(N72<>\"\",#REF!+N72,\"\"),N72)","v":0}]
["2016-09-27","Tennis","K Kravchuk 2-0 (Set Betting","Pinnacle",2.2799999999999998,"B",100,0,"L","Standard",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L73<>\"\",#REF!+L73,\"\"),L73)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N73<>\"\",#REF!+N73,\"\"),N73)","v":-1}]
["2016-09-25","Tennis","A Zverev +1.5 (Set Handicap)","Pinnacle",2.0099999999999998,"B",100,0,"W","VIP",null,101,{"$f":"IF(ISNUMBER(#REF!),IF(L74<>\"\",#REF!+L74,\"\"),L74)","v":101},1.01,{"$f":"IF(ISNUMBER(#REF!),IF(N74<>\"\",#REF!+N74,\"\"),N74)","v":1.01}]
["2016-09-25","Tennis","H Chung -4.5 (Games Handicap)","Marathon Bet",2,"B",100,0,"W","VIP",null,100,{"$f":"IF(ISNUMBER(#REF!),IF(L75<>\"\",#REF!+L75,\"\"),L75)","v":100},1,{"$f":"IF(ISNUMBER(#REF!),IF(N75<>\"\",#REF!+N75,\"\"),N75)","v":1}]
["2016-09-24","Tennis","A Zverev ","Pinnacle",2.57,"B",100,0,"W","VIP",null,157,{"$f":"IF(ISNUMBER(#REF!),IF(L76<>\"\",#REF!+L76,\"\"),L76)","v":157},1.57,{"$f":"IF(ISNUMBER(#REF!),IF(N76<>\"\",#REF!+N76,\"\"),N76)","v":1.57}]
["2016-09-23","Tennis","N Mahut","Smarkets.com",2.96,"B",1000,0.02,"L","Standard",null,-1000,{"$f":"IF(ISNUMBER(#REF!),IF(L77<>\"\",#REF!+L77,\"\"),L77)","v":-1000},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N77<>\"\",#REF!+N77,\"\"),N77)","v":-1}]
["2016-09-23","Tennis","J Sousa","Smarkets.com",3.3,"B",800,0.02,"L","VIP",null,-800,{"$f":"IF(ISNUMBER(#REF!),IF(L78<>\"\",#REF!+L78,\"\"),L78)","v":-800},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N78<>\"\",#REF!+N78,\"\"),N78)","v":-1}]
["2016-09-22","Tennis","J L Struff","Pinnacle",4.25,"B",500,0,"L","VIP",null,-500,{"$f":"IF(ISNUMBER(#REF!),IF(L79<>\"\",#REF!+L79,\"\"),L79)","v":-500},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N79<>\"\",#REF!+N79,\"\"),N79)","v":-1}]
["2016-09-20","Tennis","E Donskoy","Pinnacle",3,"B",200,0,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L80<>\"\",#REF!+L80,\"\"),L80)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N80<>\"\",#REF!+N80,\"\"),N80)","v":-1}]
["2016-09-20","Tennis","Michal Konecny","Pinnacle",3.4,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L81<>\"\",#REF!+L81,\"\"),L81)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N81<>\"\",#REF!+N81,\"\"),N81)","v":-1}]
["2016-09-18","Tennis","K Edmund","Pinnacle",6.2,"B",500,0,"V","Standard",null,0,{"$f":"IF(ISNUMBER(#REF!),IF(L82<>\"\",#REF!+L82,\"\"),L82)","v":0},0,{"$f":"IF(ISNUMBER(#REF!),IF(N82<>\"\",#REF!+N82,\"\"),N82)","v":0}]
["2016-09-17","Tennis","F Tiafoe","Pinnacle",1.8460000000000001,"B",200,0,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L83<>\"\",#REF!+L83,\"\"),L83)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N83<>\"\",#REF!+N83,\"\"),N83)","v":-1}]
["2016-09-17","Tennis","H Moriya","Pinnacle",4.609,"B",100,0,"W","VIP",null,360.9,{"$f":"IF(ISNUMBER(#REF!),IF(L84<>\"\",#REF!+L84,\"\"),L84)","v":360.9},3.61,{"$f":"IF(ISNUMBER(#REF!),IF(N84<>\"\",#REF!+N84,\"\"),N84)","v":3.61}]
["2016-09-16","Tennis","M Sieber","Unibet",3.75,"B",1000,0,"L","VIP",null,-1000,{"$f":"IF(ISNUMBER(#REF!),IF(L85<>\"\",#REF!+L85,\"\"),L85)","v":-1000},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N85<>\"\",#REF!+N85,\"\"),N85)","v":-1}]
["2016-09-15","Tennis","C Ruud","Marathon Bet",2.2000000000000002,"B",1000,0,"L","VIP",null,-1000,{"$f":"IF(ISNUMBER(#REF!),IF(L86<>\"\",#REF!+L86,\"\"),L86)","v":-1000},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N86<>\"\",#REF!+N86,\"\"),N86)","v":-1}]
["2016-09-15","Tennis","B Kavcic","Smarkets.com",3.1,"B",500,0.02,"L","VIP",null,-500,{"$f":"IF(ISNUMBER(#REF!),IF(L87<>\"\",#REF!+L87,\"\"),L87)","v":-500},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N87<>\"\",#REF!+N87,\"\"),N87)","v":-1}]
["2016-09-14","Tennis","E Sema","Pinnacle",5.32,"B",200,0,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L88<>\"\",#REF!+L88,\"\"),L88)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N88<>\"\",#REF!+N88,\"\"),N88)","v":-1}]
["2016-09-14","Tennis","D Elahi Galan","William Hill",6,"B",200,0,"L","Standard",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L89<>\"\",#REF!+L89,\"\"),L89)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N89<>\"\",#REF!+N89,\"\"),N89)","v":-1}]
["2016-09-12","Tennis","M Viola","Pinnacle",2.17,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L90<>\"\",#REF!+L90,\"\"),L90)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N90<>\"\",#REF!+N90,\"\"),N90)","v":-1}]
["2016-09-11","Tennis","S Wawrinka","Smarkets.com",3.55,"B",600,0.02,"W","VIP",null,1499.4,{"$f":"IF(ISNUMBER(#REF!),IF(L91<>\"\",#REF!+L91,\"\"),L91)","v":1499.4},2.5,{"$f":"IF(ISNUMBER(#REF!),IF(N91<>\"\",#REF!+N91,\"\"),N91)","v":2.5}]
["2016-09-11","Tennis","J De Loore","Smarkets.com",2.92,"B",500,0.02,"L","VIP",null,-500,{"$f":"IF(ISNUMBER(#REF!),IF(L92<>\"\",#REF!+L92,\"\"),L92)","v":-500},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N92<>\"\",#REF!+N92,\"\"),N92)","v":-1}]
["2016-09-10","Tennis","K Pliskova","Pinnacle",2.56,"B",300,0,"L","VIP",null,-300,{"$f":"IF(ISNUMBER(#REF!),IF(L93<>\"\",#REF!+L93,\"\"),L93)","v":-300},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N93<>\"\",#REF!+N93,\"\"),N93)","v":-1}]
["2016-09-10","Tennis","A Pavlasek","Smarkets.com",3.3,"B",200,0.02,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L94<>\"\",#REF!+L94,\"\"),L94)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N94<>\"\",#REF!+N94,\"\"),N94)","v":-1}]
["2016-09-08","Tennis","G Monfils +6.5 (Games Handicap)","Matchbook",2.0299999999999998,"B",100,0.01,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L95<>\"\",#REF!+L95,\"\"),L95)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N95<>\"\",#REF!+N95,\"\"),N95)","v":-1}]
["2016-09-07","Tennis","K Nishikori","Smarkets.com",6.3979999999999997,"B",1000,0.02,"W","VIP",null,5290.04,{"$f":"IF(ISNUMBER(#REF!),IF(L96<>\"\",#REF!+L96,\"\"),L96)","v":5290.04},5.29,{"$f":"IF(ISNUMBER(#REF!),IF(N96<>\"\",#REF!+N96,\"\"),N96)","v":5.29}]
["2016-09-06","Tennis","J W Tsonga","BetVictor",6.7,"B",1000,0,"L","VIP",null,-1000,{"$f":"IF(ISNUMBER(#REF!),IF(L97<>\"\",#REF!+L97,\"\"),L97)","v":-1000},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N97<>\"\",#REF!+N97,\"\"),N97)","v":-1}]
["2016-09-05","Tennis","I Marchenko +7.5 (Games Handicap)","Unibet",1.93,"B",1000,0,"L","VIP",null,-1000,{"$f":"IF(ISNUMBER(#REF!),IF(L98<>\"\",#REF!+L98,\"\"),L98)","v":-1000},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N98<>\"\",#REF!+N98,\"\"),N98)","v":-1}]
["2016-09-05","Tennis","K Edmund +2.5 (Set Handicap)","Unibet",2.5,"B",300,0,"L","VIP",null,-300,{"$f":"IF(ISNUMBER(#REF!),IF(L99<>\"\",#REF!+L99,\"\"),L99)","v":-300},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N99<>\"\",#REF!+N99,\"\"),N99)","v":-1}]
["2016-09-04","Tennis","M Baghdatis +2.5 (Set Handicap)","Ladbrokes",1.85,"B",200,0,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L100<>\"\",#REF!+L100,\"\"),L100)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N100<>\"\",#REF!+N100,\"\"),N100)","v":-1}]
["2016-09-03","Tennis","D Evans","Smarkets.com",8,"B",100,0.01,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L101<>\"\",#REF!+L101,\"\"),L101)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N101<>\"\",#REF!+N101,\"\"),N101)","v":-1}]
["2016-09-03","Tennis","K Edmund","Matchbook",3.4,"B",1000,0.01,"W","VIP",null,2376,{"$f":"IF(ISNUMBER(#REF!),IF(L102<>\"\",#REF!+L102,\"\"),L102)","v":2376},2.38,{"$f":"IF(ISNUMBER(#REF!),IF(N102<>\"\",#REF!+N102,\"\"),N102)","v":2.38}]
["2016-09-02","Tennis","G Melzer","Pinnacle",1.53,"B",1000,0,"L","VIP",null,-1000,{"$f":"IF(ISNUMBER(#REF!),IF(L103<>\"\",#REF!+L103,\"\"),L103)","v":-1000},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N103<>\"\",#REF!+N103,\"\"),N103)","v":-1}]
["2016-09-02","Tennis","S Johnson","Marathon Bet",3.722,"B",300,0,"L","VIP",null,-300,{"$f":"IF(ISNUMBER(#REF!),IF(L104<>\"\",#REF!+L104,\"\"),L104)","v":-300},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N104<>\"\",#REF!+N104,\"\"),N104)","v":-1}]
["2016-09-01","Tennis","M Ymer","BoyleSports",3,"B",200,0,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L105<>\"\",#REF!+L105,\"\"),L105)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N105<>\"\",#REF!+N105,\"\"),N105)","v":-1}]
["2016-08-31","Tennis","C Wozniacki","Marathon Bet",3.0630000000000002,"B",100,0,"W","VIP",null,206.3,{"$f":"IF(ISNUMBER(#REF!),IF(L106<>\"\",#REF!+L106,\"\"),L106)","v":206.3},2.06,{"$f":"IF(ISNUMBER(#REF!),IF(N106<>\"\",#REF!+N106,\"\"),N106)","v":2.06}]
["2016-08-29","Tennis","G Muller","Matchbook",4.3499999999999996,"B",200,0.01,"L","Standard",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L107<>\"\",#REF!+L107,\"\"),L107)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N107<>\"\",#REF!+N107,\"\"),N107)","v":-1}]
["2016-08-29","Tennis","J Donaldson","BoyleSports",6.5,"B",200,0,"W","VIP",null,1100,{"$f":"IF(ISNUMBER(#REF!),IF(L108<>\"\",#REF!+L108,\"\"),L108)","v":1100},5.5,{"$f":"IF(ISNUMBER(#REF!),IF(N108<>\"\",#REF!+N108,\"\"),N108)","v":5.5}]
["2016-08-27","Tennis","E Svitolina +4.5 (Games Handicap)","Marathon Bet",1.9375,"B",200,0,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L109<>\"\",#REF!+L109,\"\"),L109)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N109<>\"\",#REF!+N109,\"\"),N109)","v":-1}]
["2016-08-27","Tennis","J Millman","Marathon Bet",2.024,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L110<>\"\",#REF!+L110,\"\"),L110)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N110<>\"\",#REF!+N110,\"\"),N110)","v":-1}]
["2016-08-26","Tennis","J Eysseric","Marathon Bet",2.66,"B",100,0,"W","VIP",null,166,{"$f":"IF(ISNUMBER(#REF!),IF(L111<>\"\",#REF!+L111,\"\"),L111)","v":166},1.66,{"$f":"IF(ISNUMBER(#REF!),IF(N111<>\"\",#REF!+N111,\"\"),N111)","v":1.66}]
["2016-08-25","Tennis","J Millman","Smarkets.com",4.2,"B",500,0.02,"W","VIP",null,1568,{"$f":"IF(ISNUMBER(#REF!),IF(L112<>\"\",#REF!+L112,\"\"),L112)","v":1568},3.14,{"$f":"IF(ISNUMBER(#REF!),IF(N112<>\"\",#REF!+N112,\"\"),N112)","v":3.14}]
["2016-08-25","Tennis","Fabiano De Paula","Smarkets.com",8,"B",400,0.02,"L","VIP",null,-400,{"$f":"IF(ISNUMBER(#REF!),IF(L113<>\"\",#REF!+L113,\"\"),L113)","v":-400},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N113<>\"\",#REF!+N113,\"\"),N113)","v":-1}]
["2016-08-24","Tennis","S Robert","Smarkets.com",5.0999999999999996,"B",300,0.02,"L","VIP",null,-300,{"$f":"IF(ISNUMBER(#REF!),IF(L114<>\"\",#REF!+L114,\"\"),L114)","v":-300},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N114<>\"\",#REF!+N114,\"\"),N114)","v":-1}]
["2016-08-23","Tennis","B Trinker","Smarkets.com",5.6,"B",100,0.02,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L115<>\"\",#REF!+L115,\"\"),L115)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N115<>\"\",#REF!+N115,\"\"),N115)","v":-1}]
["2016-08-22","Tennis","J McGee","Matchbook",2.42,"B",100,0.01,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L116<>\"\",#REF!+L116,\"\"),L116)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N116<>\"\",#REF!+N116,\"\"),N116)","v":-1}]
["2016-08-21","Tennis","S Rogers","Matchbook",3.2,"B",300,0.01,"W","VIP",null,653.4,{"$f":"IF(ISNUMBER(#REF!),IF(L117<>\"\",#REF!+L117,\"\"),L117)","v":653.4},2.1800000000000002,{"$f":"IF(ISNUMBER(#REF!),IF(N117<>\"\",#REF!+N117,\"\"),N117)","v":2.1800000000000002}]
["2016-08-21","Tennis","M Raonic","Ladbrokes",3.25,"B",200,0,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L118<>\"\",#REF!+L118,\"\"),L118)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N118<>\"\",#REF!+N118,\"\"),N118)","v":-1}]
["2016-08-20","Tennis","B Tomic","Matchbook",6.6,"B",100,0.01,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L119<>\"\",#REF!+L119,\"\"),L119)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N119<>\"\",#REF!+N119,\"\"),N119)","v":-1}]
["2016-08-19","Tennis","M Sieber","Pinnacle",6.5,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L120<>\"\",#REF!+L120,\"\"),L120)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N120<>\"\",#REF!+N120,\"\"),N120)","v":-1}]
["2016-08-18","Tennis","B Tomic","Smarkets.com",4.0999999999999996,"B",200,0.02,"W","VIP",null,607.6,{"$f":"IF(ISNUMBER(#REF!),IF(L121<>\"\",#REF!+L121,\"\"),L121)","v":607.6},3.04,{"$f":"IF(ISNUMBER(#REF!),IF(N121<>\"\",#REF!+N121,\"\"),N121)","v":3.04}]
["2016-08-17","Tennis","J Donaldson","Smarkets.com",6.2,"B",100,0.02,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L122<>\"\",#REF!+L122,\"\"),L122)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N122<>\"\",#REF!+N122,\"\"),N122)","v":-1}]
["2016-08-15","Tennis","L Pouille","Marathon Bet",4.3,"B",1000,0,"L","VIP",null,-1000,{"$f":"IF(ISNUMBER(#REF!),IF(L123<>\"\",#REF!+L123,\"\"),L123)","v":-1000},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N123<>\"\",#REF!+N123,\"\"),N123)","v":-1}]
["2016-08-14","Tennis","Juan M Del Potro","Marathon Bet",4.5,"B",900,0,"L","VIP",null,-900,{"$f":"IF(ISNUMBER(#REF!),IF(L124<>\"\",#REF!+L124,\"\"),L124)","v":-900},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N124<>\"\",#REF!+N124,\"\"),N124)","v":-1}]
["2016-08-13","Tennis","K Nishikori","Coral",3.5,"B",700,0,"L","VIP",null,-700,{"$f":"IF(ISNUMBER(#REF!),IF(L125<>\"\",#REF!+L125,\"\"),L125)","v":-700},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N125<>\"\",#REF!+N125,\"\"),N125)","v":-1}]
["2016-08-13","Tennis","Pablo C Busta","Smarkets.com",2.74,"B",500,0.02,"L","VIP",null,-500,{"$f":"IF(ISNUMBER(#REF!),IF(L126<>\"\",#REF!+L126,\"\"),L126)","v":-500},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N126<>\"\",#REF!+N126,\"\"),N126)","v":-1}]
["2016-08-12","Tennis","R Bautista-Agut","Sportingbet",2.35,"B",200,0,"L","VIP",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L127<>\"\",#REF!+L127,\"\"),L127)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N127<>\"\",#REF!+N127,\"\"),N127)","v":-1}]
["2016-08-12","Tennis","Z Zhang","Pinnacle",2.8889999999999998,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L128<>\"\",#REF!+L128,\"\"),L128)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N128<>\"\",#REF!+N128,\"\"),N128)","v":-1}]
["2016-08-11","Tennis","T Bellucci","Smarkets.com",5.0999999999999996,"B",400,0.02,"W","VIP",null,1607.2,{"$f":"IF(ISNUMBER(#REF!),IF(L129<>\"\",#REF!+L129,\"\"),L129)","v":1607.2},4.0199999999999996,{"$f":"IF(ISNUMBER(#REF!),IF(N129<>\"\",#REF!+N129,\"\"),N129)","v":4.0199999999999996}]
["2016-08-10","Tennis","J Satral","Pinnacle",3,"B",200,0,"L","Standard",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L130<>\"\",#REF!+L130,\"\"),L130)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N130<>\"\",#REF!+N130,\"\"),N130)","v":-1}]
["2016-08-10","Tennis","A Weintraub","Marathon Bet",3.42,"B",100,0,"L","Elite",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L131<>\"\",#REF!+L131,\"\"),L131)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N131<>\"\",#REF!+N131,\"\"),N131)","v":-1}]
["2016-08-08","Tennis","J Sousa +4.5 (Games Handicap)","Marathon Bet",1.9650000000000001,"B",100,0,"W","Elite",null,96.5,{"$f":"IF(ISNUMBER(#REF!),IF(L132<>\"\",#REF!+L132,\"\"),L132)","v":96.5},0.97,{"$f":"IF(ISNUMBER(#REF!),IF(N132<>\"\",#REF!+N132,\"\"),N132)","v":0.97}]
["2016-08-08","Tennis","M Michalicka","Pinnacle",5.39,"B",100,0,"W","VIP",null,439,{"$f":"IF(ISNUMBER(#REF!),IF(L133<>\"\",#REF!+L133,\"\"),L133)","v":439},4.3899999999999997,{"$f":"IF(ISNUMBER(#REF!),IF(N133<>\"\",#REF!+N133,\"\"),N133)","v":4.3899999999999997}]
["2016-08-07","Tennis","J Isner","Coral",2,"B",200,0,"L","Elite",null,-200,{"$f":"IF(ISNUMBER(#REF!),IF(L134<>\"\",#REF!+L134,\"\"),L134)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N134<>\"\",#REF!+N134,\"\"),N134)","v":-1}]
["2016-08-07","Tennis","A De Greef","Pinnacle",3.74,"B",200,0,"W","Elite",null,548,{"$f":"IF(ISNUMBER(#REF!),IF(L135<>\"\",#REF!+L135,\"\"),L135)","v":548},2.74,{"$f":"IF(ISNUMBER(#REF!),IF(N135<>\"\",#REF!+N135,\"\"),N135)","v":2.74}]
["2016-08-06","Tennis","Y Uchiyama","Coral",3.5,"B",100,0,"L","VIP",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L136<>\"\",#REF!+L136,\"\"),L136)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N136<>\"\",#REF!+N136,\"\"),N136)","v":-1}]
["2016-08-04","Tennis","J Isner","Betfair",1.32,"B",100,0,"W","Elite",null,32,{"$f":"IF(ISNUMBER(#REF!),IF(L137<>\"\",#REF!+L137,\"\"),L137)","v":32},0.32,{"$f":"IF(ISNUMBER(#REF!),IF(N137<>\"\",#REF!+N137,\"\"),N137)","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(L138<>\"\",#REF!+L138,\"\"),L138)","v":226.3},2.2599999999999998,{"$f":"IF(ISNUMBER(#REF!),IF(N138<>\"\",#REF!+N138,\"\"),N138)","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(L139<>\"\",#REF!+L139,\"\"),L139)","v":190},1.9,{"$f":"IF(ISNUMBER(#REF!),IF(N139<>\"\",#REF!+N139,\"\"),N139)","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(L140<>\"\",#REF!+L140,\"\"),L140)","v":191},1.91,{"$f":"IF(ISNUMBER(#REF!),IF(N140<>\"\",#REF!+N140,\"\"),N140)","v":1.91}]
["2016-08-01","Tennis","V Galovic","Coral",3.75,"B",800,0,"W","Elite",null,2200,{"$f":"IF(ISNUMBER(#REF!),IF(L141<>\"\",#REF!+L141,\"\"),L141)","v":2200},2.75,{"$f":"IF(ISNUMBER(#REF!),IF(N141<>\"\",#REF!+N141,\"\"),N141)","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(L142<>\"\",#REF!+L142,\"\"),L142)","v":-500},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N142<>\"\",#REF!+N142,\"\"),N142)","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(L143<>\"\",#REF!+L143,\"\"),L143)","v":-200},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N143<>\"\",#REF!+N143,\"\"),N143)","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(L144<>\"\",#REF!+L144,\"\"),L144)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N144<>\"\",#REF!+N144,\"\"),N144)","v":-1}]
["2016-07-30","Tennis","G Monfils","Pinnacle",4.3,"B",200,0,"W","VIP",null,660,{"$f":"IF(ISNUMBER(#REF!),IF(L145<>\"\",#REF!+L145,\"\"),L145)","v":660},3.3,{"$f":"IF(ISNUMBER(#REF!),IF(N145<>\"\",#REF!+N145,\"\"),N145)","v":3.3}]
["2016-07-28","Tennis","B Westerhof","Pinnacle",4.5,"B",100,0,"L","Elite",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L146<>\"\",#REF!+L146,\"\"),L146)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N146<>\"\",#REF!+N146,\"\"),N146)","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(L147<>\"\",#REF!+L147,\"\"),L147)","v":220.5},2.21,{"$f":"IF(ISNUMBER(#REF!),IF(N147<>\"\",#REF!+N147,\"\"),N147)","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(L148<>\"\",#REF!+L148,\"\"),L148)","v":980},3.92,{"$f":"IF(ISNUMBER(#REF!),IF(N148<>\"\",#REF!+N148,\"\"),N148)","v":3.92}]
["2016-07-26","Tennis","A Zverev ","Ladbrokes",1.38,"B",100,0,"L","Elite",null,-100,{"$f":"IF(ISNUMBER(#REF!),IF(L149<>\"\",#REF!+L149,\"\"),L149)","v":-100},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N149<>\"\",#REF!+N149,\"\"),N149)","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(L150<>\"\",#REF!+L150,\"\"),L150)","v":126.3},0.84,{"$f":"IF(ISNUMBER(#REF!),IF(N150<>\"\",#REF!+N150,\"\"),N150)","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(L151<>\"\",#REF!+L151,\"\"),L151)","v":28.5},0.95,{"$f":"IF(ISNUMBER(#REF!),IF(N151<>\"\",#REF!+N151,\"\"),N151)","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(L152<>\"\",#REF!+L152,\"\"),L152)","v":37.24},0.37,{"$f":"IF(ISNUMBER(#REF!),IF(N152<>\"\",#REF!+N152,\"\"),N152)","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(L153<>\"\",#REF!+L153,\"\"),L153)","v":44.1},0.44,{"$f":"IF(ISNUMBER(#REF!),IF(N153<>\"\",#REF!+N153,\"\"),N153)","v":0.44}]
["2016-07-23","Tennis","L Davis ","Pinnacle",2.5,"B",100,0,"W","VIP",null,150,{"$f":"IF(ISNUMBER(#REF!),IF(L154<>\"\",#REF!+L154,\"\"),L154)","v":150},1.5,{"$f":"IF(ISNUMBER(#REF!),IF(N154<>\"\",#REF!+N154,\"\"),N154)","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(L155<>\"\",#REF!+L155,\"\"),L155)","v":169},1.69,{"$f":"IF(ISNUMBER(#REF!),IF(N155<>\"\",#REF!+N155,\"\"),N155)","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(L156<>\"\",#REF!+L156,\"\"),L156)","v":-50},-1,{"$f":"IF(ISNUMBER(#REF!),IF(N156<>\"\",#REF!+N156,\"\"),N156)","v":-1}]
["2016-07-21","Tennis","T Monteiro","Pinnacle",4.3,"B",1000,0,"W","Elite",null,3300,{"$f":"IF(ISNUMBER(#REF!),IF(L157<>\"\",#REF!+L157,\"\"),L157)","v":3300},3.3,{"$f":"IF(ISNUMBER(#REF!),IF(N157<>\"\",#REF!+N157,\"\"),N157)","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":80},{"$f":"((K4+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J4,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L4)-M4)","v":80}]
["Tennis",{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A5,INDIRECT(\"Bets!G18\"):INDIRECT(\"Bets!G10000\"))","v":46680},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A5,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))","v":26008.399999999998},0.55716366752356461,{"$f":"(COUNTIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A5))","v":140},{"$f":"SUMIF(INDIRECT(\"Bets!B18\"):INDIRECT(\"Bets!B10000\"),A5,INDIRECT(\"Bets!N18\"):INDIRECT(\"Bets!N10000\"))","v":51.199999999999989},0.36571428571428566,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},9875.3000000000011,{"$f":"((K5+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J5,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L5)-M5)","v":9875.3000000000011}]
["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},5852,{"$f":"((K11+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J11,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L11)-M11)","v":5852}]
["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},-1010,{"$f":"((K12+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J12,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L12)-M12)","v":-1010}]
["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},1150,{"$f":"((K13+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J13,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L13)-M13)","v":1150}]
["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},3650,{"$f":"((K14+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J14,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L14)-M14)","v":3650}]
["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},-500,{"$f":"((K15+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J15,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L15)-M15)","v":-500}]
["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},-250,{"$f":"((K16+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J16,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L16)-M16)","v":-250}]
["Total",{"$f":"SUM(B4:B16)","v":46680},{"$f":"SUM(C4:C16)","v":26008.399999999998},{"$f":"IF(B17<>0,C17/B17,0)","v":0.55716366752356461},{"$f":"SUM(E4:E16)","v":140},{"$f":"SUM(F4:F16)","v":51.199999999999989},{"$f":"IF(E17<>0,F17/E17,0)","v":0.36571428571428566},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},9476.2999999999993,{"$f":"((K17+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J17,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L17)-M17)","v":9476.2999999999993}]
[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},840,{"$f":"((K20+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J20,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L20)-M20)","v":840}]
[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},-200,{"$f":"((K21+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J21,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L21)-M21)","v":-200}]
[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},-1950,{"$f":"((K25+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J25,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L25)-M25)","v":-1950}]
[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},-500,{"$f":"((K26+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J26,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L26)-M26)","v":-500}]
[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":100},-3066.6000000000004,{"$f":"((K27+SUMIF(INDIRECT(\"Bets!D18\"):INDIRECT(\"Bets!D10000\"),J27,INDIRECT(\"Bets!L18\"):INDIRECT(\"Bets!L10000\"))-L27)-M27)","v":-3166.6000000000004}]
[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":100},{"$f":"SUM(N4:N28)","v":23479},{"$f":"SUM(O4:O28)","v":23379}]