In SplitSuit’s video “Going All In Preflop With AK & QQ” he introduced and used a powerful spreadsheet that he created. The goal of this spreadsheet was to simplify the EV calculation in preflop all-in situations, and situations where a 3bet or 4bet would be committing. By simply inputting a few variables (some constants like pot sizes and some variables like equity estimates), you are given the expected value of your play. What used to take a ton of time by hand, can now be done in seconds with just a few inputs
SplitSuit even went further by adding a graph to each sheet that essentially replicates the EV with slight tweaks. It analyzes 12 other “slightly different” scenarios where our equity ranges from +/-10%, our opponent folds +/-10% more often, and/or both. This allows you to see the exact EV with your initial inputs, and then some close scenarios ranging from much to slightly better or worse. This again saves you a massive chunk of time so you don’t need to manually input these changes by hand…it’s just done for you automatically.
Feel free to download and use* this spreadsheet for your own exploration. If you have any questions, or need any help with it, please first consult the video. If you are still unsure, just post a comment below or in the forums!
Want to learn where these equations come from and how EV works? Watch these two videos:
The Basics Of EV
Advanced Poker EV
* Red Chip Poker LLC and SplitSuit LLC make no guarantees that the spreadsheet is 100% correct. Please make sure to test and calibrate the spreadsheet before using it, and understand that any changes to the formulas can break the spreadsheet/graphing functionality. There are cells that appear empty, but actually contain data, so please make sure to keep that in mind before adding data into already occupied cells. To utilize the breakeven calculation you will need to utilize ‘Solver’, a free Excel add-on. For more information about using solver, please see this guide.