Count to zero

[steel108]

This is what I'm trying to do, but I can't figure out how to do it in Excel (could be very easy, but I'm a little incompetent)...kind of a poker simulation

(1) The pot is $24 on the flop and I have $80 left. What do I have to bet to leave one pot sized bet on turn. (Example: if I bet $19 I will have $61 left and the pot will be $62 so that's the wrong size)

(2) The pot is $24 on the flop and I have $80 left. What do I have to bet on the flop AND turn to leave myself a pot sized bet on the river (same as above but now there are 2 bets needed before having a pot sized bet left)

I'm trying to find a function for this, but have had no luck. Ideally, I want to be able to input the size of the pot and amount left to be bet and have excel calculate both scenarios (1 bet or 2 bets).

Thanks for any help.

[zbor]

Can you upload example?

[steel108]

Can you upload example?

I provided 2 in my OP, but maybe it wasn't clear... I'll give it another go:

There is $24 in the pot and I have $100 left to bet.

There are 3 more opportunities to bet. What do I have to bet in order to have a pot sized bet left on the last bet?

If I bet $15, then $25..... I have $60 (100-25-15) and the pot is $104 (24+15+15+25+25.... pot was 24 at start, I bet 15 and got called, I bet 25 and got called); in this case, I don't have a pot sized bet left since 60 doesn't = 104

[steel108]

I just realized that you wanted a template, not another example. Here is what I was to trying to work. The Stacks and Pot size are the variables; once I input these figures and Excel will do the rest. The first is 1 bet in order to have a pot sized bet left and the second is 2 bets in order to have a pot sized bet left

[zbor]

I ment... can you upload example?

With expected input and output...

[ChemistB]

It looks like you are assuming that there are only two players (based on pot size increases)? Look at the attached and see if this is what you are looking for. I protected the formulas without password so they can't be accidently erased. When setting up for more than 1 bet, there's a range you can choose from (i.e. if you have 25 to play with you can bet 1 and then 24 or 12 and then 13, etc). I set it up to split it up into more or less equal increments. Is this what you are looking for?

[shg]

Maybe like this:

Please Login or Register  to view this content.

You'd use the formula in D2, D3, or D4.

[steel108]

It looks like you are assuming that there are only two players (based on pot size increases)? Look at the attached and see if this is what you are looking for. I protected the formulas without password so they can't be accidently erased. When setting up for more than 1 bet, there's a range you can choose from (i.e. if you have 25 to play with you can bet 1 and then 24 or 12 and then 13, etc). I set it up to split it up into more or less equal increments. Is this what you are looking for?

For the increments, I basically want the max bet that will still allow for a pot sized bet on the last betting street (Example: Pot is 25 and I have 200 left with 3 betting opportunities left. What is the max I can bet on each street and still have a pot sized bet on the river?)

Your upload is basically exactly want I was looking for. It seems to bets the max. I'm googling the ROUND function you used to try and learn how you do it. Thanks for your help.

[steel108]

I have been playing around with the Excel sheet and the numbers are off. For triple bet, If I set the reserve to 360 and the pot to 80, on teh final bet the pot is 196 and the reserve is 302

[shg]

Pot = 80, Reserve = 360, Bet 66
Pot = 146, Reserve = 294, Bet 74
Pot = 220, Reserve = 220, Bet 220

[steel108]

Pot = 80, Reserve = 360, Bet 66
Pot = 146, Reserve = 294, Bet 74
Pot = 220, Reserve = 220, Bet 220

I am a complete idiot, it is working fine. I just confused which function did what.

What would I have to change in order to have the minimum bet required to have a pot sized pot left? I thought the maximum would be the most efficient, but after reanalyzing, the minimum would give me the best results

[shg]

The minimum bet would be zero, no?

[steel108]

The minimum bet would be zero, no?

Pot = 100

Money Left = 900

Betting Opportunities Left = 3

What is the least amount I can bet on the first and second to leave a pot sized bet on the third?

Using the maximum is resulting in a large 1st bet and a small 2nd bet (relative to the pot size). If I bet zero, I will never have a pot sized bet left by the 3rd bet...

Sorry for all the confusion; I know this is probably very simple, but I just started learning Excel and it's kicking my ***.

[ChemistB]

Isn't betting zero, the same as "checking"? Then what you are doing is changing the calculations from a 3 round hand to a 2 round hand? (not familiar with poker lingo) You will always have enough to cover the river as long as you don't bet more than the max in each round provided there's no maximum bet requirement.

[steel108]

Isn't betting zero, the same as "checking"? Then what you are doing is changing the calculations from a 3 round hand to a 2 round hand? (not familiar with poker lingo) You will always have enough to cover the river as long as you don't bet more than the max in each round provided there's no maximum bet requirement.

I can bet as much as want on a street; I'm trying to find the smallest bet possible in order to leave myself a pot sized bet for the last round of betting.

For example.....

If I have 1000 and the the pot is 150 (there are still 3 betting opportunities), what is the least that I can bet in the first opportunity and 2nd opportunity, so that by the 3 opportunity, My money = the pot size (pot sized bet).