Thanks for your quick reply,
But I still think you are mistaken.

In the example I posted Hero has 400 BEFORE he posts the blinds. (look at the screenshot from the Pushbot Rev4.2).

If you put the 420 stack before posting like in your example- the sheet will say 44 will have an M of 14.7 (again, vs. a 20% Villain's calling range. try it yourself), not 14.3 like you just calculated.

hence it is biased towards pushing, not folding.

lol, it's funny. I think I just figured it out.
If you put your M AFTER posting the SB- it works out!
(if you put 410 in your example at the "Hero's effective stack" bracket, 44 will get 14.3 in the sheet like it should when starting stack before posting is 420).

I'm trying to figure Rev Bot's Resteal Bot out. I know I'm making a mistake somewhere.
The situation is this: A player raises in LP with a stack that has me covered and is over 30 bb's. I have 2900 chips, the blinds are 125-250. I am right to the villians immediate left and there is 3 people behind me.
Villian opens to 580 and I go all in with 33. So in the pushbot revs resteal screen I put 250 in for the bb, 25 in for the ante, 580 in for villians raise size, and 2900 for the resteal amount. I am giving villian an opening range of 25% of hands and a calling range of 10%.
So with 169 hands possible, I expect villian to be opening 169*.25 or around 42 hands, and I expect him to be calling with 169*.10 of hands or around 16 hands.
16/42 equals around 40%. So in the resteal fold % box below the hands chart I put 60 for the % of times we expect villian to fold to our reraise.
What doesnt make sense is that when I reshove 2900 over a raise when the blinds are 125-250, there's no way its +cev to do this with 100% of hands, so if you guys can folllow all that let me know where you think I made a mistake because I should be seeing some red or -cev hands in that chart with a little fold equity reshove stack.

You are so short stacked, that if you feel villain is folding 60% of the time (with only a top 11% hand), you can +cEV shove ATC.

IMHO, if you are shoving 2900 over a raise to 580, villain is getting 1.75:1 odds to call your shove, so if he's opening 25%, I would expect villain to call 100% and fold 0%. So just rerun with 27% calling range and 0% fold, and you will see 33 is a borderline +cEV resteal.

Thanks for the opinion. Yeh I did not account for the positon and how that will adjust his calling range. I assumed perfect calling ranges like he was raising UTG and I was shoving in MP or something.
I gave him a calling range of 20%, as 27% will give him any pair, any A-x, and all broadways. But either way 3-3 is super close and probably a fold with a 20% tighter calling range and a shove with a wider 27% calling range, thanks for the help.

Hi JIT, thank you for the software, its really great.

I have a few questions, what do you mean by ''+cEV shove that will greater than ''X%'' ROI''? What is X? Does the green cells refer to $EV? Basically what is the main difference between the yellow and green cells? And how should we interpret their meanings in our game? Thanks.

The X is the percentage you enter into the spreadsheet, so if you enter 10% in the "Green Cells", all cells colored green will have a greater than 10% long term ROI.

As for cEV to $EV, if you are in the ICM tabs, it's $EV. The standard Push/Call/RestealBot are all cEV.

JIT is there a way to set a min edge for a jam using the resteal bot?

Very much this. JIT, as the others have already said, I sincerely thank you for your contribution to the community. It is very generous of you and helpful. I have a quick question about the blue square--calling hands--when using the pushbot.

Lets say there are 3 players left to act after I shove, but they will all call with different ranges, e.g. if I shove from the CO, the BTN will call me less often than the BB. In this case, should I enter what I assume to be the average calling range? Im just a bit confused because w/ SnG Wiz, you are supposed to put in a calling range for each individual left to act, but with PB, there is only a slot for one call percentage.

Thanks again!

You are describing what makes Wiz much better than this static spreadsheet, programmable ranges for multiple villains. Going with an average is not a bad strategy. My other thought is go with the most loose calling range, so taht pushbot calculates more showdowns. This way you know how the weaker part of your shoving range will do.

Is it easy to convert it to BBs instead of M ?

Another question:

For the resteal tab. Raiser opens in MP (who has me covered) to 400 (BB=200) and my stack is 3000. Do I need to fill in 3000 or 2600 (3000-400) in the resteal amount?

Hello

First of all, big respect for the awesome program.

I have a question that statistics used to calling hands (pushbot)?
VPIP or gap VPIP/PFR.

I ask because the difference in calling hands are huge. From 3% to 36% and I have a problem with the selection of stats.

This would be great and also, change within the matrix to show u just the edge on the play? I mean Stack - Result, thanks.

Is there a way to get this spread sheet to work with numbers on mac i cant change any of the values without getting errors?

Firstly, thank you so much for spending time and effort creating this.

I would like to ask something about the resteal bot part.

How can we figure out, mathematically speaking, the percentage of expected villain fold (resteal fold)?

Thank you for this contribution. It's great.

But I wonder one thing (as quite a beginner when it comes to advanced SNG/MTT theory): shouldn't the Call bot have much looser push ranges for the villain available. It seem odd that they both offer the exact same ranges, considering that the villain is supposed to push a much wider range of hands than 36% most of the time (according to the program).

You guys are better off pming the op with your questions rather than bumping the thread.

Thanks bro... I needed this.

Does this work with mac? Is it a program? Works on excel?

works on my Mac

Thanks for this...wanted to see if there is an updated version but if not no biggie mine seems to be working fine

Great stuff.

Question just about the proper entry for callbot, kind of feel dumb for asking though. You have the warning for villain covering if stack size is covered. What then are we entering as the pot?

If villain shoves 2000, I have 1000, I'm entering the put entry as the already shoved 2000, or as 1000+blinds?

Enter the latter amount. So in your ex., enter 1000+blinds.

You can't win the extra money villian has more than you, so that won't be in the pot when you call.

For anyone new to MTT and looking for shoving maths, this program is awesome. Go back to page 1 of this thread and d/l it and the PDF help manual.

OP, wherever you are, this Bud's for you.

OP, thank you very much for a great effort!!!!
guys could smb please answer my nube question:
i open pokerstove i put there lets say 3,02% of the hands. Based on the pokerstove the range is: 99+, AKs, however in excel in Pushbot tab or Callbot tab in villain shoving or calling range 3,02% of the hands refer to the range JJ+, AKs, AKo.
could anybody please explain why the difference arrise?
many thanks in advance!!

Spreadsheet is perfect! Thank you!
I'm a newbie here and I wonder if I could subscribe JITxpert's activity.
I don't understand how to subscribe a topic too.