Discussion: Bankroll Management Spreadsheet

RE: http://www.flopturnriver.com/phpBB2/forum/bankroll-management-spreadsheet-siknd-posts-only-t33006.html#290826

We hope this excel tool helps people with Bankroll Management. Please let us know what you like and dislike about it.

I really like it. Would you be able to provide a 'blank' copy of it for us? (I'm an Excel n00b and don't want to screw it up by deleting the wrong cells...)

i left the stats in so you could see what it should look like.

all you have to do it put in your own session stats in rows 31 and 32. then select and delete all my sesssions, ie everything in columns B-V (same for cash, tourney and live). the only other thing you will have to do is reset all the deposits and cashouts to zero on the bankroll page, and youre ready to go.

Very nice spreadsheet, thank you for making it available.

I look forward to using it Smile

the blank one isnt downloading.

just getting an Error404

Hey, I just downloaded it and it looks very promising. However, I have one little issue. When you enter the data "Cash"-page, it also shows up on the "Summary"-page, but it doesn't change the numbers on the "Bankroll" -page. Is it supposed to be like this?

It would almost be TOO good if it changed the "Bankroll"-page, right?

Cheers!
/Oscar

the source data numbers as entered on the cash page will be read on both the summary and bankroll page. the summary page pulls data from the cash page via the month (ie, it is set to read the monthly tags, May 06, in this case)

the bankroll page pulls data from the cash page via the site names. if you have entered the site name differently from how it is set to read on the bankroll page, then it wont work.

check that first:

1. go to bankroll page. say you are playing at Party Poker. so click on cell E4
2. cell E4 contains the formula which will gather the data. in the equation bar at the top of the spreadsheet, you can view the formula.
3. in this case you will see:=SUMIF(Cash!H31:Cash!H9999,"Party Poker",Cash!U31:Cash!U9999)
4. the quotations indicate the correct moniker, ie PartyspacePoker. This is what you will need to enter in column H of the cash page. If youve entered just Party, or PP or PartyPoker or anythign different, this is proably the reason you are having problems.

if this is not the case, and you still cant figure it out, PM me. i will give you my email, you can send me the spreadsheet, and id be glad to help you out with it one-on-one.

lmk.

sic

Thank you so much! Brilliant work with this spread, I'm gonna recommend to it everyone I know.

I especially enjoyed the private e-mail support! :-]

I just started poking around with your Bankroll tracker. Wow you did a great job on that spreadsheet!
One minor suggestion. Can you add a column for number of hands played per session, and have it extrapolate a BB/100? BB/100 is how most online players keep their stats since BB/hr can vary widely due to the ability to multi-table. Otherwise that thing is incredible, Cheers!

i do factor for multitabling. column L on the cash page is where you enter the number of tables played. the subsequent formulas on the summary page compute all figues in big blinds per hour per table. beyond that, and separating longhand from shorthand, i really have no way to refine it further; ie i could only produce BB/100 by rough estimation, which would be worse than what i currently have.

that said, if anyone can suggest a way to incorporate it, my ears are open.

First, let me just say that the spreadsheet looks terrific. I’m using the empty one and I noticed that when I enter my tournament winnings on the tournament page, it doesn’t transfer those winnings into my bankroll for that particular site.

I don’t use spreadsheets, so I don’t know if it would do that or not, but thought it would be cool if it did. Am I doing something wrong, or do I still have to enter my tournament winnings into my bankroll manually? Thanks

Hello?

I figured it out... copy & paste works wonders. Very Happy

Thanks anyway.

Hi I aint got a clue about spreadsheets and am having trouble getting the correct formula in the tournament section so it shows up on the bankroll page.

anyone tell me what formula to put where so it updates the bankroll page too? cheers all help appreciated.

I play sit &go's so its just the tourney page i need.

fantastic spreadsheet though...

cheers

cheers spud. got it now.

Very Happy

Hi folks,
Great spreadsheet - appreciate the effort that has gone into it

Quick question if I may - could i get an explanation of what the values on Tournament page G34, G35, G36 etc represent please ? (values like 0.5, 1.0 etc)

I'm probly a dill, but sobeit

thanks in advance

Oink !

Oops nevermind

Figured it out ... time played ... Embarassed

Oink !

What is the X-Axis on the graph in the tournament worksheet? Right now I want to adjust it because it seems like I am zoomed to far out and I want to know what I am changing before I change it.

anyway to use this without having microsoft excel?

Hi folks,

Looking for some help from somebody who uses this ... and is probly an Excel forumlae expert Surprised

Would like to insert a formula on the Tournament page under column "Q" for representing MTT Final Tables as a percentage

I guess it has to say -
1. Where column "K" is greater than 10
2. AND column "O" is less than or equal to 10
3. Express cell "Q4" as a percentage of all tournaments that meet points 1 and 2

perhaps there is somebody out there that uses this great spreadsheet who already has this set up

help appreciated

Cheers,
Oink !

year old bump.

Nobody seems to know about this yet its really good.

Thanks X and whoever designed it.

Hi,

I'm going to try and use this program for the new year and track my poker bankroll. Been terrible tracking my poker spending the last few years. I was wondering though if there is a way to use Epassporte instead of netteller for that link 16 and hyper link it some how instead.

Thanks for any help

I just found this spreadsheet and I am very impressed. I've tweaked a couple of things to suit my needs but overall this looks like a fantastic way to manage ones bankroll.

I know this thread is old but thank you and well done to the creators!

Ok,
My first question is regarding Rakeback......How should one go about keeping track of ur Rakeback each month
Second question is regarding poker rooms I do not use. Is there any way to delete them or just leave them in there since really they are not hurting anything. Also I use Cake Poker and is it ok if I just put it in "Empires" spot since I do not use that site?

Anychance of a walk through in being able to increase the graphs' data? I've already gone through the 32 games in the cash tab and would hate to leave it at just those first games.

Hello,

Very good spreadsheat Smile

You've done a great job !!

Just a question :

In the Tournament page What is in "English" the PERCENTILE ?
Not sure to understand this formula : Percentile=100-((Rank*100)/(#entries+1))

I'd understand if it was #Rank*100/#entries but here....

Is it a real percentile (like quantile), some explanation would be great

Thanks a ton
Squalito
(sorry for my english)

Poker Forum

Poker Forum Index

Tools Of Poker

Discussion: Bankroll Management Spreadsheet