{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["Tournaments","Bankroll Chart","Bankroll Rules","SummaryData","Worksheet","AboutVersion","ROOMS"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Tournaments","index":0,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,12,0,13],[0,14,0,16],[0,3,0,6],[0,0,0,2],[1,0,1,3],[1,5,1,8],[1,10,1,13],[0,7,0,8],[0,9,0,11],[2,10,2,11],[2,12,2,13],[3,12,3,13],[8,12,8,13],[2,0,2,1],[2,2,2,3],[3,10,3,11],[4,10,4,11],[8,10,8,11],[8,0,8,1],[8,2,8,3],[6,10,6,11],[6,12,6,13],[7,12,7,13],[5,10,5,11],[4,12,4,13],[10,1,10,7],[10,8,10,12],[10,14,10,15],[3,2,3,3],[4,2,4,3],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[6,2,6,3],[5,2,5,3],[7,0,7,1],[7,2,7,3],[7,10,7,11],[5,12,5,13]]}
["Current Bankroll:",null,null,{"$f":"N11+C3","v":6.49},null,null,null,"Sugg. Buy In:",null,{"$f":"Worksheet!B8","v":6.4899999999999999E-2}]
["Overall Stats",{"$nulls":4},"Finish Positions",{"$nulls":4},"Buy-ins"]
["Total Profit",null,{"$f":"SUM(I12:I2000)","v":-2.75},null,null,"ITM %",{"$f":"IF($C$5 > 0, COUNTIF(H12:H2000, \">0\")/C5, 0)","v":0},"Late %",{"$f":"IF($C$5 > 0, Worksheet!I5/$C$5, \"\")","v":0},null,"Suggested BI",null,{"$f":"Worksheet!B8","v":6.4899999999999999E-2}]
["Total Time",null,{"$f":"SUM(J12:J2000)","v":5.208333333333337E-2},null,null,"1st",{"$f":"COUNTIF(G12:G2000,\"=1\")","v":0},"Mid Late %",{"$f":"IF($C$5 > 0, Worksheet!I6/$C$5, \"\")","v":0},null,"Allowable BI",null,{"$f":"Worksheet!B9","v":8.4370000000000001E-2}]
["Tourneys Played",null,{"$f":"COUNT(A12:A2000)","v":50},null,null,"2nd",{"$f":"COUNTIF(G12:G2000,\"=2\")","v":0},"Midde %",{"$f":"IF($C$5 > 0, Worksheet!I7/$C$5, \"\")","v":0},null,"Max BI (not recc'd)",null,{"$f":"Worksheet!B10","v":8.4370000000000001E-2}]
["ROI",null,{"$f":"C3/N11","v":-0.29761904761904762},null,null,"3rd",{"$f":"COUNTIF(G12:G2000,\"=3\")","v":0},"Early Mid %",{"$f":"IF($C$5 > 0, Worksheet!I8/$C$5, \"\")","v":0.02},null,"Average BI",null,{"$f":"Worksheet!B5","v":2.75}]
["BuyIn ROI",null,3.566545455,null,null,"4 - 10",{"$f":"COUNTIF(G12:G2000,\"<11\")-SUM(G4:G6)","v":0},"Early %",{"$f":"IF($C$5 > 0, Worksheet!I9/$C$5, \"\")","v":0},null,"Sugg BIs Avail.",null,{"$f":"D1/Worksheet!B8","v":100}]
["$/Hr",null,7.8464,{"$nulls":7},"Allow BIs Avail.",null,{"$f":"D1/M4","v":76.92307692307692}]
["$/Tournament",null,{"$f":"IF(C5>0, C3/C5, 0)","v":-5.5E-2},{"$nulls":7},"Max Bis Avail.",null,{"$f":"D1/Worksheet!B10","v":76.92307692307692}]
["#","Date","Start Time","Finish Time","Size","Total Buy-in","Place Finished","Prize","Profit","Length","Placed %","ROI","$/Hr","Bankroll","BI % of BR","Profit % of BR","Notes"]
[0,{"$nulls":12},{"$f":"'Bankroll Rules'!B3","v":9.24}]
[{"$f":"A11+1","v":1},"2010-01-01","09:30:00","10:45:00",2000,2.75,1224,0,{"$f":"H12-F12","v":-2.75},{"$f":"D12-C12","v":"01:15:00"},{"$f":"G12/E12","v":0.61199999999999999},{"$f":"I12/F12","v":-1},{"$f":"I12/J12/24","v":-2.1999999999999984},{"$f":"N11+I12","v":6.49},{"$f":"F12/N11","v":0.29761904761904762},{"$f":"IF(I12>0, I12/N11, 0)","v":0}]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"Bankroll Chart","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Tournament","Bankroll"]
[{"$f":"Tournaments!A11","v":0},{"$f":"IF('Bankroll Rules'!$B$14,0,Tournaments!N11)","v":0}]
[{"$f":"Tournaments!A12","v":1},{"$f":"IF('Bankroll Rules'!$B$14,SUM(Tournaments!$I$12:I12),Tournaments!N12)","v":-2.75}]
[{"$f":"Tournaments!A13","v":2},{"$f":"IF('Bankroll Rules'!$B$14,SUM(Tournaments!$I$12:I13),Tournaments!N13)","v":-2.75}]
[{"$f":"Tournaments!A14","v":3},{"$f":"IF('Bankroll Rules'!$B$14,SUM(Tournaments!$I$12:I14),Tournaments!N14)","v":-2.75}]
[{"$f":"Tournaments!A15","v":4},{"$f":"IF('Bankroll Rules'!$B$14,SUM(Tournaments!$I$12:I15),Tournaments!N15)","v":-2.75}]
[{"$f":"Tournaments!A16","v":5},{"$f":"IF('Bankroll Rules'!$B$14,SUM(Tournaments!$I$12:I16),Tournaments!N16)","v":-2.75}]

{"sheet":"Bankroll Rules","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,0,12,6],[13,2,13,6],[0,0,0,6],[1,0,1,6],[2,2,2,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[6,2,6,6]]}
["Bankroll Rules"]
["Fill out the parameters in white below to define your bankroll management strategy.\t\t\t\t\t\t\t\n"]
["Starting Bankroll",{"$f":"ROOMS!D12","v":9.24},"How much you will start your MTT challenge with"]
["Buyin % of BR",0.01,"The % of your bankroll you're willing to invest in a single tournament (1-2% is best)"]
["Fudge Factor",0.3,"Gives you a little bit of wiggle room to stay at the same level before dropping down"]
["Max above avg BI",0.75,"Hit a big win Bankroll shoots up. Doesn't mean your skills have. Keeps you from moving up too fast."]
["Recc Buyin",{"$f":"B3*B4","v":9.240000000000001E-2},"The recommended buy-in according to your bankroll rules (for reference)"]
["Max Buyin",{"$f":"(B3*B4)*(1+B5)","v":0.12012000000000002},"The maximum buy-in according to rules and fudge factor (for reference)"]
["Num Games",{"$f":"B3/B7","v":99.999999999999986},"The number of buy-ins according to your bankroll rules (for reference)"]
["Num Games w/FF",{"$f":"B3/B8","v":76.92307692307692},"The number of buy-ins according to your bankroll rules with Fudge Factor (for reference)"]
[]
[]
["Chart Settings"]
["Winnings Only?",true,"Shows only the profit, not the entire bankroll (TRUE or FALSE)"]

{"sheet":"SummaryData","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
["Summary Data"]
["Gathers information to be used in the 'Bankroll Summary Spreadsheet'"]
["Bankroll",{"$f":"Tournaments!D1","v":6.49}]
["Starting Bankroll",{"$f":"'Bankroll Rules'!B3","v":9.24}]
["Profit",{"$f":"Tournaments!C3","v":-2.75}]
["ROI",{"$f":"Tournaments!C6","v":-0.29761904761904762}]
["Buy-in ROI",{"$f":"Tournaments!C7","v":3.566545455}]
["Total Time",{"$f":"Tournaments!C4","v":"01:15:00"}]
["$/hr",{"$f":"Tournaments!C8","v":7.8464}]

{"sheet":"Worksheet","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,4,2,5]]}
["Do not modify anything on this sheet"]
[]
[{"$nulls":4},"Between"]
["Bankroll",{"$f":"Tournaments!D1","v":6.49},null,null,"max","min","> max","> min","btwn"]
["Average BuyIn",{"$f":"IF(Tournaments!C5>0,AVERAGE(Tournaments!F12:F2000),B6)","v":2.75},null,"Late %",0.2,0,{"$f":"COUNTIF(Tournaments!$K$12:$K$2000, \"<\"&E5)","v":0},{"$f":"COUNTIF(Tournaments!$K$12:$K$2000, \"<\"&F5)","v":0},{"$f":"IF(G5-H5<0, 0, G5-H5)","v":0}]
["Max BI",{"$f":"B4*'Bankroll Rules'!B4","v":6.4899999999999999E-2},null,"Mid Late %",0.4,0.2,{"$f":"COUNTIF(Tournaments!$K$12:$K$2000, \"<\"&E6)","v":0},{"$f":"COUNTIF(Tournaments!$K$12:$K$2000, \"<\"&F6)","v":0},0]
["Max based on ABI",{"$f":"IF(B5*(1+'Bankroll Rules'!B6)<B6,B5*(1+'Bankroll Rules'!B6),B6)","v":6.4899999999999999E-2},null,"Midde %",0.6,0.4,{"$f":"COUNTIF(Tournaments!$K$12:$K$2000, \"<\"&E7)","v":0},{"$f":"COUNTIF(Tournaments!$K$12:$K$2000, \"<\"&F7)","v":0},0]
["Suggested BI",{"$f":"IF(B6<B7,B6,B7)","v":6.4899999999999999E-2},null,"Early Mid %",0.8,0.6,{"$f":"COUNTIF(Tournaments!$K$12:$K$2000, \"<\"&E8)","v":1},{"$f":"COUNTIF(Tournaments!$K$12:$K$2000, \"<\"&F8)","v":0},1]
["Sugg BI Fudged",{"$f":"B8*(1+'Bankroll Rules'!B5)","v":8.4370000000000001E-2},null,"Early %",1,0.8,{"$f":"COUNTIF(Tournaments!$K$12:$K$2000, \"<\"&E9)","v":1},{"$f":"COUNTIF(Tournaments!$K$12:$K$2000, \"<\"&F9)","v":1},0]
["Max BI Fudged",{"$f":"B6*(1+'Bankroll Rules'!B5)","v":8.4370000000000001E-2}]

{"sheet":"AboutVersion","index":5,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Version","1.00"]

{"sheet":"ROOMS","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["ROOMS","BANKROLL","Date","euro rate",1.1200000000000001]
["Pokerstars",1,null,{"$f":"B2","v":1}]
["Pokerstars ES",1,null,{"$f":"B3*E1","v":1.1200000000000001}]
["Party",1,null,{"$f":"B4","v":1}]
["American Cardrooms",1,null,{"$f":"B5","v":1}]
["Winamax",1,null,{"$f":"B6*E1","v":1.1200000000000001}]
[888,1,null,{"$f":"B7","v":1}]
["Pokermatch",1,null,{"$f":"B8","v":1}]
["Skrill",null,null,1]
["Card",null,null,1]
[]
[null,null,null,{"$f":"SUM(D2:D10)","v":9.24}]