Excel-chart for different SPRs

Posted by LazySummerDays

Posted by LazySummerDays posted in Gen. Poker

Posted 11 years, 2 months ago

Excel-chart for different SPRs

Hi,

Backstory: Often while multitabling I make errors with flop betting size, which leads me into a situation where I have an awkward SPR at turn or river. This is probably because I don't have most of the betting patterns memorized by heart.

Because I'm totally helpless with Excel functions, I'm asking a small favor from RIO community. It shouldn't take more than ~10min to make if you're familiar with Excel.

The chart should have:
- variable x, which is our betsizing throughout the hand in fractions of the pot (e.g. x=0.75 means we bet 3/4 pot every street) (Actually, even better than having static betsizing on every street postflop would be to have two variables, x for bet size on the flop and y for bet size on the turn)

- let's say 32 rows for different SPR's on the flop between 2-33 (SPR=33 is roughly the equivalent of BTN opening for minraise and BB calling with 150bb stacks)

- 4 different columns: pot size on turn, left to bet on turn, pot size on river, left to bet on river.

So this would produce a 32x4 matrix.

For example, if we have SPR=13 and and we choose variable x=1 (and variable y=1), then that row would be: 3 12 9 9 (respectively pot size on turn, left to bet on turn, pot size on river, left to bet on river)

Cheers!

6 Comments

Loading 6 Comments...

jonna102 11 years, 2 months ago

Don't have exactly what you're asking for, but I found this:

LazySummerDays 11 years, 2 months ago

Hmm, not quite cause it doesn't show how big of a stack we have still have on the river.

When SPR>13 on the flop, we need to slide in an overbet at some point to get our stack in. So with the chart I could play around with the betting fractions and see what kind of betting pattern seems most sensible if we want to end up shoving the river. Chart works also for check-raises, you'd just put the total number of bets to that variable. (E.g. pot is 1 on the flop, villain bets 0,5, we check-raise to 1,5 and villain calls. This would equal to us just betting 1,5x times the pot on the flop and villain calling.)

Ever since Sauce & Gandalf talked about overbetting the flop in some vid, it made me realize I need to work on some SPR math.