Poker Video: Misc/Other by Sugar Nut (Micro/Small Stakes)

Here's a direct link to "The Dude" : http://software.deucescracked.com/thedude.xls

Second post to say that this is really incredible. Nice work Sugar Nut, and shoutouts to WiltOnTilt, EatMyRaise, and sthief09 for indirectly helping to make this vid possible. The openshoving 20BB section is really very cool.

Rob

Cracking bit of kit!

Will be nice to see it included in future vids.

Awesome, love this kind of thing.

One thing is that in 20bb situations I did the maths and used a an open shove strategy on rathole short stacks which works well. However I then changed to minraising and found that a lot of them just fold the same % anyway.

Btw, you asked for suggestions. How difficult in excel would it be to automate the part that you did in stove?
Like, if you could enter or select pre-flop match ups like the 88 vs QQ+AK in the example.
I dont mean incorporate a poker stove like equity calculator but simply have quick method of bringing up your equity% vs a common preflop calling ranges.

I know its lazy but software is for lazy people like me.

A+ name imo

Thanks for the feedback guys.

First things first:

I realized that I made some minor mistakes in the video which are stated and corrected below

5:35

Obv I mean $50 in the pot, not $50 in effective stacks.

7:23

Obv we're losing $15 on average, not 15%

8:44

Obv we're not 0EV, we just have 0 equity

Btw, you asked for suggestions. How difficult in excel would it be to automate the part that you did in stove?
Like, if you could enter or select pre-flop match ups like the 88 vs QQ+AK in the example.
I dont mean incorporate a poker stove like equity calculator but simply have quick method of bringing up your equity% vs a common preflop calling ranges.

I know its lazy but software is for lazy people like me.

I'm sure this would be possible somehow. Even incorporating pokerstove directly into "The Dude!" should work.

What you guys need to understand, however, is that I'm in no way an excel expert. I'm pretty much your average "learning by klicking" kinda guy.

Probably guys like Pygmy Hero or Josh (Sthief09) who have shown expertise in excel in their past videos might be able to answer if that is possible and if yes, how.

Sugar Nut

One more thing.

If you guys find "The Dude!" helpful in any way and feel the need to thank me for it, please send all the karma you got my way ASAP.

I've been running like crappidy-crap-crap lately and could really use it

Sugar Nut

One more thing.

If you guys find "The Dude!" helpful in any way and feel the need to thank me for it, please send all the karma you got my way ASAP.

I've been running like crappidy-crap-crap lately and could really use it

Sugar Nut

stop semi-bluffing obv

Its actually pretty good.
Can you add a rake correction?

I thought about adding a rake correction, however I havent quite figured out how by now.

The problem here is that the amount of money we will win if villain folds will be different most of the time than the money we will win if he calls if the rake isn't capped already at the decision point.

I'll think about it though and maybe there will be a Dude! 2.0 at some time

Furthermore there would have to be quite a lot of variables.

For example "The Dude!" would have to know the no. of players dealt in at a 6-max of fullring table or if this is a HU table as the rake differs weather it's a HU or a multihanded table and how many players are actually dealt in (if you're playing HU on a 6-max table the rake will be capped at $1 at most sites while it will be capped at $.50 at a HU table)

I Cant download the excel file.

it just makes my internet close.

my computer is wack.

is there anyway I could get someone to send on aim?

This looks pretty useful, however there is one thing I don't like too much: it's the combos. I think that these cells would be much more intuitive if converted to percentages.

Take the Pokerstars 3-bet example you showed: Pokerstove showed us that his calling range is only 2.6% of all hands. Why not use this percentage instead of counting combos? The Dude would then tell us that villain's total range needs to be 6.35% of all hands. We can either use Stove again to assign him a full range and compare the perecentages or simply pull up his 3-betting stats (which is a percentage as well). Much easier and more straightforward than counting combos imo!

Just cap it at 3 for simplicity. It does not have to be precise.
Another great add would be a poker stove type table for choosing combos.

Sounded Simple who is a programmer has offered to help improving "The Dude!" so be patient and wait for good things to come when we release The Dude! 2.0

This looks pretty useful, however there is one thing I don't like too much: it's the combos. I think that these cells would be much more intuitive if converted to percentages.

Take the Pokerstars 3-bet example you showed: Pokerstove showed us that his calling range is only 2.6% of all hands. Why not use this percentage instead of counting combos? The Dude would then tell us that villain's total range needs to be 6.35% of all hands.

I haven't tried it, but won't this work? All that should matter is the ratio right?

I haven't tried it, but won't this work? All that should matter is the ratio right?

Of course that would work. I just like it the way it is. Like I said in the video: Do whatever you like with this so it suits your needs best. If you want a % range in the "needed combos in villain's entire range" cell, go ahead and make it a percentage.

Sugar Nut

Nice work

Could anyone that knows, tell me how to change the combo field into range percentage? Thanks

Could anyone that knows, tell me how to change the combo field into range percentage? Thanks

Same question here. Am a excel n00b but would really like to do this tho.

And great vid/tool

Maybe I didn't make myself clear enough the first time.

I'll teach you the very complicated way to make the sheet calculate range percentages.

Go to cell L9 and change the text to: "Villain's calling range percentage"

Then go to cell L15 and change the text to:"needed width of villain's entire range to achieve 0EV FE"

Done!

Look at it this way:

The header of the input cell says: "Combos in villain's calling range"

Guess what: Excel doesn't know what combos are or what the context is or what you are talking about at all. All it does is it takes your input value and puts it through the formula in the output cell of which the header is: "Needed combos in villain's entire range to achieve 0EV FE"

Example:

Villain with 9% 3bet stat over 6 billion hands 3bets you and you ship pocket 4's (100BB eff)

After 6 billion hands he has called 4bet shoves only and exclusively with QQ+, AK

Effstacks: 100BB
pot (dead money) will be the blinds = 1.5
your bet will be 3.5
his raise will be 12.5
Our equity vs this calling range is 35.14%

Before we continue, please enter these values into "The Dude!"

OK, we now know that he needs to fold 59.48% of the time for us to break even.

We count the combos in his calling range:

3 pocket pairs = 6 combos each = 18 + all AK's = 16

18 + 16 = 34 combos in his calling range

Enter this in cell L11

We find out that he needs to have 84 combos in his entire 3betting range in order for us to break even.

Let's use pokerstove and give him any random 84 combos (what these combos are doesnt matter right now, all we're concerned with right now is the percentage that pokerstove displays in the bottom right.

For simplicity's sake lets give him 5 unpaired hands (suited and ofsuit) and one suited hand (84 combos). (A9s+, A9+, KQs works just fine)

Pokerstove tells us that this is 6.3% of all hands.

Now we do the magic trick:

Instead of entering the number of combos in his calling range, we just enter the % of total hands in his calling range, so again we check pokerstove: QQ+, AK = 2.6% of all hands.

Enter 2.6 in cell L11 instead of 34

The output in cell L17 will switch from 84 to 6 which is pretty close to what we have found out earlier and actually due to the cell being formatted to have no decimals.

We know from a massive samplesize that he 3bets 9% so our shove is +EV since 9% > 6.3%

Cliffnotes:

Just enter a range % in the combos input cell and the output will give you a % of his entire range needed to break even.

Sugar Nut

mm I do not have excel and tried the microsoft excel viewer but it will not let me input any numbers... is there another program i can use with this excel sheet?

mm I do not have excel and tried the microsoft excel viewer but it will not let me input any numbers... is there another program i can use with this excel sheet?

www.openoffice.org should work.

Rob

Yeah, OpenOffice works fine. In fact if you look at the video you'll see that I use OpenOffice aswell. I just saved it as an .xls since most ppl use Excel, but OpenOffice is capable of opening .xls files aswell.

Very interesting video! I need to watch it a few times

Hey Sugar Nut, really nice job. I wanted to say that I'm especially impressed by all the effort you put into the conditional formatting for the cells with error message outputs.