If you can somewhat model a villain's range into one of the pre canned ranges, then it's close enough and I would not compensate for the variance using the red cells. (Prove it to yourself by using pokerstove and doing the math long hand).

This is a great use of the "Red Cells" portion of the spreadsheet, to take away those marginally +cEV/$EV spots. A small change in % will start removing hand, try it when you review some spots, start with 1%, then 2%...

Here's the thing, if you are playing turbo SnGs, then I would advocate pressing each and every edge, no matter how small. You get so short, so fast in them, that the "skill" edge is being able to ID each and every +EV play (no matter how small) and taking it. In the long run (put in volume), this is the best way to increase your hourly.

If you told me you played MTTs with great structures and long levels, I may give you a slightly different answer.

Awesome JIT!

Thanks for the quick response!

But I have another question...

I was searching through the threads and I found out there is no quick formula to calculate the bubble factor. I do understand that it raises exponentially as we approach the bubble and that the higher this bubble factor is, less hands should we push...

So, would it be a close enough aproximation if I just used the cEV spreadsheet and raise the red zone exponentially when players bust out (lets say we start at 0% with 9plrs, go up to 1% at 7, 3% at 6, 7% at 5 and 11% at 4...or something like that...). Because I really dont have the time for calculating the bubble factor during play...do you think this would make a good approximation??

Ow and, is the importance of bubble factor (ICM in general) different in different formats (MTTs, 1 table SNGs, turbos, super-turbos...)??

Hope its not to much

There is no quick way to calc a bubble factor, but it is not that hard to do long hand! When reviewing one of your final tables, try calculating your bubble factor against someone who has you covered. Remember:

Bubble Factor = Loss of equity/Gain in equity

I think I cover this in the instruction manual for PushBot.

No. The better way is to become comfortable with estimating bubble factors on the fly. Doing some hand calcs, and getting the book Kill Everyone, where they go into some depth of bubble factors, and actually plot bubble factors for some tournaments (like the Sunday Million and Stars 180s) will give you an idea.

Well kinda.... In a slow structure, perhaps making a borderline ICM call would not be good, where in a turbo you would snap it in a heartbeat. Again, depends on tons of things (your edge relative to the field, table dynamics, the strength of your read on villain's holding, your position relative to the blinds, your stack size....)

Just do a search on this site. It's out there.... And thanks!

This is fantastic, thank you so much for posting this. It really is helping me so much as a new player, like so many things at 2p2. I would love to donate some money to you as soon as ive managed to build a bit of a bankroll.

Bump. This thing is really really useful and if people would just use this instead of posting a thread about "should I shove X with Y amount of chips in Z position?" then ssmtt would be alot less cluttered.

I was delighted to come across this excellent work. As it happens, I had looked at some similar, but complimentary things; for example:
> The Harville formula, used for bubble factor calculations is a bit of a pig in Excel, but my spreadsheet calculates it exactly to the 3rd prize level and then has a (fairly good) estimate for 4th place: I believe that this allows bubble factor calculations with stack size inputs.
> I believe that you developed your sheet by running Poker Stove on various scenarios and then copying and pasting each result. I took the hand versus hand equity data (a text file I got from somewhere, probably Poker Stove) and then used filters, and Sumif and Countif statements to extract information based on various scenarios. I remember a small (0.5%) compiling error which I am pretty sure I could resolve if spent some time looking at it.
Two minor things I noticed that you might want to consider for future editions:
> I noticed that it is possible to have a nonsensical relation between the # of players left to play and the number of players to your left. It might be helpful to have a conditional format statement to change one of the cells to red if they were inconsistent.
> Rather than manually inputting the blinds and antes, it might be helpful to select a tournament from a dropdown list and then select a tournament level so that the antes and blinds would be calculated automatically.
You have inspired me to clean up some of the things that I had started. I am fairly busy right now but I might get a chance to look at them sometime this weekend. If you are at all interested let me know as I can make them available to you. Either way, good luck and continued success on this fantastic effort.

Great job mate!
Looked over it and seems great material to study!

Great stuff! thanks

GREAT STUFF!!

thanks a million for taking the time out to do this. i've only started plyaing $4 180 mans but this is going to help so much.

I really appreciate the time you have taken to do this, thanks

thanks for sharing my friend!!

thanks for everything

Hello guys,

Im new here and I just found this thread and found that chart quite useful.

I have a question about it tho. It may sound stupid but when I open it with excel I cannot really change anything.. There's no such options. Can anyone tell me what may be the problem?

Thanks alot!

You have to enable editing on the file. There should be an option near the top in your menu bar I think.

Thank you sir,

Great stuff!!!...

Thanks

so im just curious what differences are there between this one and the old one that is available on the pdf file? is the old one still ok to use in tournaments?

You are a legend!

Never heard of pushbot until today...seems like this is just what I need to help my late MTT play. Is it tough to use while playing? Should I just use it to check past HHs? Any tips for beginners? Thanks!

Just mark a hand your unsure about and review it after your session.

Just took 8th outta 210. Got a new perspective on late play thanks to the chart. Only wondered about a few hands that the chart said 'shove' on...don't have the HH yet I'll try to sum them up...

A-T utg with 31k blinds 800/1600 18 left. Chart says shove, 1st to act with AT looks like a fold to me.

10-6s cutoff - 37k - blinds 1250/2500 12 left. Folded to me. Monster stacks to my left.

7-6s utg+1 54k blinds 2/4k 9 left. Just 'scared' to shove early I guess, I folded.
KQ utg (very next hand) 54k 2.4k 9 left. Again, don't like a shove with KQ early, but I did...and lost. Would have lost the previous hand as well.

I'll try to post full HHs here or in another post for some more feedback later

Thanks for the chart, It definitely improved my game.

how many players are to act? what calling range for them?
the chat is just "programmed" to do te math, you have to put in stacksizes/etc for it to work correctly.

Twice I was one of the first to act. UTG and UTG+1. On the other hand It was folded to me and I was in the CO with the chip leader to my left.
I put it on 15% calling range, table was playing just a bit loose, put all the numbers in correctly...just over cautious about shoving in early position I guess.