First off, a big thanks to spamz0r for making this post on various endgame strategies (as well as the HH review, with a hand where I folded Kx from the button 7 BB deep which inspired this post). Also as I play mostly HUSNG, this is a HUSNG-oriented post, cash players will really only find this utility helpful against shortstackers.

What I've created here is an Excel spreadsheet which will do all the calculations required for Sklansky-Chubukov (I have posted this one before), Nash, SAGE, as well as the math for the 3-bet shoving dynamic seen in this thread, only with the math done correctly this time.

What I am hoping to accomplish with this spreadsheet is a way for players who aren't as familiar with the pure mathematical parts of the game to visualise various proper shoving/calling ranges, and for everyone else to play with this and eventually be able to instinctively know these ranges well enough to do them without the chart (in case you're ever HU in a live tournament or something).

Also, I would like to integrate Pokerstove's calculator directly into the Excel table with VBA or whatever eventually, so you can just enter your hand instead of manually running the equity calculation for a more streamlined table. If anyone knows how to do this and can help, I'd be very appreciative.

If you have questions, comments for improvement/addition, or anything else, post them here. This isn't a finalised spreadsheet. Enjoy!

Download the spreadsheet here - Version 2.21

1st

edit: nice, this will be useful. thanks steve

insane_steve I thank you for everthing you do. this is exactly what I've been looking for.

nice. Thank you

This is awesome.

As far as integrating pokerstove, I think there's a command line version of pokerstove that you can purchase if you email them...

This is great. Thanks, Steve.

I volunteer to port this to a web format. Give me a holler on aim, steve (sejje).

I haven't opened the spreadsheet or whatever, I want to know about the inputs required and maths.

nice post tyty.

Steve - ur the man!

tyty

good stuff.. ty

very nice, congrats, and ty

ty

ty a lot, very useful

thanks steve. this is pretty cool.

I was playing with similar spreadsheed some time ago so maybe I could help a bit.

- I'm using chubukov to like 9-8 BB and below NASH. The charts I'm using now looks like this . Can be usefull as a visual presentation of those two.

- As for 'Three-Bet Shove Math' and intergration of pokerstove.
You can download to excel equity vs typical ranges (5%, 10%, 15% etc.). Holdem Ranger + AHK does it. Than via vlookup incorporate it into calculation. In my spredsheet (unfortunatelly I've lost it) I did this calculation in excel in 13x13 table for all 2 card combinations, than I've put conditional formatting for all >0. As an output we get whole range with given conditions that have positive equity presented in a table.

If you like the idea and need any help with this let me know.