No worries, thanks for that.

Hi,

Thank you for sharing this work!
A question : do you think will make an update which will take into account the antes in the SC calculations?

The S-C table was never generated for antes -- it always assumes there's a small blinds and a big blind which is twice the small blind. Since an ante means that the button (that's you in the case of S-C play) puts in more proportionally than they would in anteless play, you'd, if my intuition is right, be able to shove a bit wider than S-C says because there's more dead money in the pot to win if opponent folds.

Since the official S-C tables don't account for antes, and I have no means to obtaining the calculations done in the table, I wouldn't be able to update the table for a variable ante, sorry. It's probably not going to be a huge difference, and what difference there is is going to be on the side of shoving too wide, which isn't going to be a mistake if you're planning on shoving wider than S-C to take blinds.

Thank you for answering.
As you might read in NLHTaP where the SC has first been exposed if I'm not wrong, page 222, there is an 'Adjusting for an Ante' paragraph.
Of course, as you said, we intuitively know than we can push a bit wider than the SC say in case the ante exist.
More precisely, as explained in the book, you now have to compare the ((blinds+Ante)*SCnumber)/3 to the Effective Stack, instead of directly compare the SC to the effective stack.

There is a small (but not completely negligible) difference, for instance, at 100/200 with A2o, you can push with 4517, at 100/200/25 you can push with 5270.

I'm just saying, not criticizing your GREAT work .

Thanks again.

A good approximation in these case (but always and only an approximation) is to consider the total pot preflop and divide by three.
In this way you obtain the so called True Small Blind; multiplied by two you are able to obtain the True Big Blind and you can consider it as the big blind of the chart.

gl

OK so I'm just trying this for the first time. I know nothing about Excel really so when I open the file should I enable or disable macros or do it not matter? I don't even know what macros are.

I'm trying to use this for reshoving but I'm a little confused. I enter stacks, opening range, calling range, ect but how do I get my EV for shoving? Say if I want to check out the EV of shoving K2 over a minraise at 13bb effective do I just enter the info and look at the bottom right table called "Total Equity"? Is that my EV of shoving?

Also what's the "Calling Equity" table all about? BTW this looks pretty awesome and once I figure out what I'm doing will be using this a lot.

I'll answer the q's I can:

Yes, enable macros. I'm not sure since I use it in OpenOffice but I think this makes the PokerStove stuff functional if you're in Excel. Do not enable macros, however, if you are opening a random file from an unknown source.

Yes, the table at the bottom right is where you find the shoving equity.

I think calling equity is there for computational purposes. The calculator is essentially performing the math for the EV calculation (%villainFolds * pot) + [ %calls * ((%wewin * chipswon) + (%welose * chipslost))]

Obv would be glad to be corrected if I'm wrong about any of the above.

I'm sorry if this has been asked before - but the results of the calculation (total equity), for example +0.34, is it +0.34 compared to when we started the hand before the blinds posted, or is it compared to our stack after posting the BB?

i believe after posting bb

After playing with this I wish I had used this earlier..it's the nuts. Everyone involved in making this thanks.

So if BB is 100, +30 expectation means we lost -70 from the start of the hand? can some1 confirm this?

I thought it was before the blinds are posted

I thought it was after Steve?

Folding is considered to be EV 0, so it's .34 BB more than what you have after posting. It's possible for a play to be correct which leaves you with fewer chips than you started the hand with on average due to the dead money in the blinds.

There are predefined categories (tight, normal, loose, etc.) that you can select from the drop-down menu but if I was to come up with a new category called "range1" and fill out all the values in the Arkusz1 tab in a new column, could I get that as an option in the drop-down menu so that the tables display the relevant info?

edit: ok so I can get the option in the drop down menu but just unsure of how to tell it to go and get the values from the arkusz sheet.

nvm think i figured it out, just had to alter the formula to include the new column of values.

i figured that i can calc 4b shove ranges w this stuff if i change the values in a way that:
-"Big Blind" --> my pf open size otb
-"Size of villain's raise preflop" --> his 3b size
-"% villain is raising from the button" --> his 3b%
-"% villain is calling a shove (estimate)" --> % villain calls my 4b shove
obv i calc my equity vs his stack off range facing a 4b shove.

do u guys think its correct or am i missing something?

That seems fine, you could also just do the equity calcs or use another calculator/make ur own for it too.

getting all sort of errors is this because I'm using windows works ?
( well aware this could sound like a stupid question )

I'm guessing yes.
the macros are broken with open office too.
you have to use it manually, i.e. use pokerstove and enter the values manually.

already did that but got wrong results
guess I'm gonna have to forget about it
isn't there any other program i can use for 3bet shoving calc.

Yea, to my knowledge this only works with Excel type programs. I might be able to get an old version that doesn't use Stove directly to be useable in Works's spreadsheet program, but I just had all my programs reset on this computer again so it'd be a while for it to work.

Been busy with personal statistics type things right now, though, so I can't work on this for a while sadly.

tx anyway for the answer at least now i know its waist of time trying to get this to work

Wow, cool thing Steve!
Didnt know that I get the calculator here in the forum (for free)
ty,ty,ty

For clarification I wanted to make sure that the total equity resulting from plugging all necessary fields into the endgame calculator, is in denominations of chips right?