# Poker Video: Misc/Other by PygmyHero (Micro/Small Stakes)

## Tool Time: Excel for Poker Math

This is a free video. Like what you see? Log In or to view the rest of our Poker Videos.
Get the Flash Player to see this player.

### Tool Time: Excel for Poker Math by PygmyHero

DeucesCracked member teaches the use of Excel for mathematical analysis of poker statistics. He describes what information we can learn from winrates, standard deviations, and confidence intervals. He also uses Excel to analyze proper bankroll management decisions for the amateur and the pro.

Videos to help you get the most out of the DeucesCracked experience. Quick tips on tools from RSS readers to next-gen trackers and everything in-between. Good stuff IMO.

### Video Details

• Game:
• Stakes: Micro/Small Stakes
• 42 minutes long
• Posted about 5 years ago

## Comments for Tool Time: Excel for Poker Math

or track by Email or RSS

32 posts
Joined 02/2008

Sure it's relevant.

Maybe someone else can pipe in on whether the existence of higher rake means that someone winning for 0.5bb/100 is really "beating" the game for someone playing at a lower rake site.

#### PygmyHero

4246 posts
Joined 08/2007

I think this conversation is definitely still relevant to the thread. As I mentioned in the video a few times, people should be aware that I'm just presenting one way of looking at win rate, moving up, etc. There are different perspectives and I'm always glad that jajvirta presents his.

I will say that I disagree on this point though - I think rakeback and bonuses should be excluded when we talk about someone beating the game. I realize the semantics are starting to be a problem here, so I mean, 'beating the game' to mean the same thing as when I said, 'a winning player' in my previous post. That is, someone with a 0.0 BB/100 win rate (w/o rb and bonuses) is NOT a winning player. I think you're talking about whether or not a person is 'a profitable player.'

I think this is an important distinction because players with a lower win rate will have larger swings. Your hypothetical 0.5 BB/100 winner who makes an extra 2 BB/100 in rakeback and bonuses will have larger swings then the 2.5 BB/100 winner.

Let's say both players get exactly the same card, situations, and opponents and that they run cold for a while. At first I'd expect them to both dip below their normal win rate by about the same amount. But note that the rakeback player is now losing at the tables, while the winner is still in the black. I think the rakeback player is much more likely to exacerbate the bad run and end up losing more than the other player.

Also, is it really run to just grind a bunch of hands in order to break even? I know people do it, but I guess I just don't really understand why.

#### jajvirta

725 posts
Joined 03/2007

Also, is it really fun to just grind a bunch of hands in order to break even? I know people do it, but I guess I just don't really understand why.

Heh, I see that this discussion isn't going anywhere anymore, and I'm fine with that, but I just wanted to say that I guess it boils down to me thinking that the "rakeback winner" isn't grinding in order to break even. But I'll leave it at that and hope that both viewpoints have been presented here somewhat objectively. I guess both views have their merits.

32 posts
Joined 02/2008

Heh, I see that this discussion isn't going anywhere anymore, and I'm fine with that, but I just wanted to say that I guess it boils down to me thinking that the "rakeback winner" isn't grinding in order to break even. But I'll leave it at that and hope that both viewpoints have been presented here somewhat objectively. I guess both views have their merits.

Well, the people I'm referring to play 10 tables 12hrs/day and are MAYBE 1-2ptbb/100 winners, but since they get 1.5ptbb/100 in rb and basically play 10k hands/day, they're making good \$\$. But, BORING!

#### ShLiM

16 posts
Joined 01/2008

Sorry for bother you but, can u look at the pic, and tell me is it supposed to look like this, I mean the b12 cell, Im NL player

http://img265.imageshack.us/img265/5674/wonderingzd1.jpg

#### PygmyHero

4246 posts
Joined 08/2007

ShLiM, it's no bother. And this will be easy to fix. When I said enter the big blind*2 in cell B12, I didn't literally mean, enter "big blind*2" in the cell. Rather, I meant enter the value, depending on the limit you are playing.

For 50NL enter 1 (\$0.50 big blind * 2 = \$1).
For 100NL enter 2 (\$1 big blind * 2 = \$2).

And so on...

You won't need to enter an equal sign, the dollar sign, or anything else fancy. Just "1" (or "2" or whatever the case may be - leave off the quotes too).

Let me know if you need any other help.

#### Busting you

572 posts
Joined 12/2007

pygmyhero,

great video i used this in excel immediately. You are running pretty sick.

#### pkr_brat

797 posts
Joined 01/2008

pkr_brat, I just wanted to let you know that I'm working on this and that I did see your post and am not ignoring it. I'm not a tournament player so I'm not very familiar with the stuff that goes into it. I'm going to do some research and see if I can get you some answers.

Thanks for trying

#### fourscoreseven

8 posts
Joined 06/2008

Wow, what a great video! Thank you very much, hope to see more videos from you.
fourscore

#### daveshoelace

4 posts
Joined 03/2008

Great video, really made some taxing content seem easy to understand

Is it at all possible to make up some blank templates that we can download?

#### PygmyHero

4246 posts
Joined 08/2007

Wow, what a great video! Thank you very much, hope to see more videos from you.
fourscore

Thanks fourscore. I may have something else in the works. I have a lot of the preliminary work on it done, but have not yet pitched the idea to the DC powers-that-be.

#### PygmyHero

4246 posts
Joined 08/2007

Great video, really made some taxing content seem easy to understand

Is it at all possible to make up some blank templates that we can download?

Thanks dave - I'm hoping that everyone was able to create whatever they needed while watching the video, but I'd certainly be willing to share the file if anyone was struggling or just didn't want to put in the work. It's really not very elaborate at all.

Anyway, I think the best thing is if DC had a page where members could download files from - maybe you could make a suggestion to this effect in the All About DC forum. I think it's been brought up before but hasn't happened for whatever reason. I don't know that there are a lot of non-video files that people are interested in downloading, so it may just be that they're way busier with a ton of other stuff.

#### internist

1 posts
Joined 12/2008

I wonder if anyone can send me the spread sheet as it was made in the video? I would be very gratefull if someone could do this, the Spreadsheet can be your own version og eg the numbers etc. I just want the formatting and formulas etc.

#### tanglewizard

57 posts
Joined 10/2008

Great vid PygmyHero, you are very articulate and a great teacher!

internist, did you get a copy of the spreadsheet yet?

HomePoker ForumsSoftware and Tools → Tool Time : Excel for Poker Math