you should also make it interact w/ the poker client so it can click the buttons for you too, imo. that'd be pretty helpful when multitabling.

No need! I have a bunch of monkeys for that.

Thanks for your suggestion but,

one of the great thing about HU poker and one of the reason I really enjoy it is that you win by knowing how to adapt to your villain (specificaly).

You never play against a "standard" villain. I do not believe anyone can be a winning HU player by trying to use strategies designed to beat a "population average".
You have to deduce from his play what your villain's ranges will be. The calculator can help you knowing your 3 bet shove equity once you have develop this skill but he cannot replace that skill. How well you adapt to your opponent IS what constitue your edge!

With this in mind, I think that not only it would be nearly impossible to assign automated standard ranges per stack depth but it would also be pointless.

Sorry

I've just tried to use it with OOo but it told me "protected cells can not be modified" after double clicking one of the cells, even though I have macros enabled.

make sure you have OOo 3.3 or later if it still doesn't work let me know I'll try to fix it.

I was using OOo 3.2 before but I still get the same message after an upgrade to 3.3.

I assume you have precomputed the equities of all 169 hands versus the calling ranges using Pokerstove or some equity calculator and stored it somewhere. Correct?

If this is the case, when you say you have 45% equity it already includes ties. 45% equity can be different from 45% winning percentage because of tied pots which Pokerstove (and every correct equity calculator out there) already adds up to the equity as fractional tie counts.

Example output of Pokerstove for AQs vs 22+:

493,143,552 games 0.040 secs 12,328,588,800 games/sec

Board:
Dead:

	equity	win	tie	pots won	pots tied
Hand 0:	44.569%	44.31%	00.26%	218499192	1291878.00	{ AQs }
Hand 1:	55.431%	55.17%	00.26%	272060604	1291878.00	{ 22+ }

You see that the equity for AQs (44.569%) is calculated as win% (44.31%) + tie equity (00.26%). Note that tie equity is not the same as tie% - check Pokerstove FAQ.
Equity is calculated as [pots won + fractional tie count (shown as pots tied)] / games = (218499192 + 1291878) / 493143552 ~ 0.4456.

So I guess your 3-bet shove calculator is just fine :-)

No worries, just an idea. In general I agree with you, it's just weird to see words being so far from their meanings at most stack depths. My wording was also off. I didn't mean it to include scientific research, just that calling ranges could change tighter when deep and looser when shallow. I get that it's a lot of work and little effect. Not to mention that what you have created already exceeds anything one could have expected from a 3bet calculator, by far.

redownload it and try reopening it with 3.3. it's possible that if you opened it with 3.2 it converted it to a 3.2 version. One of the OOo basic command used in the pop up box was only inroduced with OOo 3.3. If it doesn't work PM me your skype and I'll try to have a look and fix it. Seems to work for everyone else so we should be able to fix it for you too.

Splitpotbug doesn't matter HU.

Q please add 3bet call analysis. It's really important to be able to calc opponent's calling range to do the 3bet shove calcs right.

I believe 3bet call analysis is already there for HU spots?

We can continue this in icmizer thread so we dont derail it too much really.

I think he means the "calling the shove "ranges. Trying to define those was not the easiest bit.

yes please

awesome program. only prob i see with it is that it's not that useful at stack depths where people tend to have a significant jamming/limping range ... maybe i'm missing something tho?

Thanks a lot for your help so far and sorry for the late response. I've completely forgot that I've posted itt. PM'ed you.

you can change the stack deph between 0 and 25 bb deep. Do you mean above 25bb deep?

example:

let's say a player is minraising the button with 40% of hands at 13bb stx. it's pretty rare imo that this 40% is actually simply the top 40% of hands - a lot of players have a jamming and limping range that includes plenty of hands in the top 40% of hands. this 40% could be polarized, it could be the top 40% of hands not including weak AX, etc.

assuming that villain's raise % correlates to the top X% of hands doesn't seem very useful to me, esp when we know that the population tendency is for that to not be the case at certain stack depths.

same goes for the raise/call range - lots of players openjam weak AX <15 (often correctly) for example.

oh I just understood what you meant. If someone is using a strategy similar to ROFL for instance he won't be min raising a top % of hands, he might open shove some of his top % and min R others. Yes, you are right, vs someone doing this we can't input villain's range properly in this calculator.

yes that's I thought you meant. The good news is that the EV of 3 bet shoving vs someone doing that will always be higher than if he was raising his top 40 %. Because his 40% now include some weaker hands than if he was min raisng his top 40%

ya cool. i'm sure that's just absurdly difficult to program obv. i just think it's important people realize it some what bc a bunch of hands are 3bet shoves vs typical ROFL-type 40% pfr that wouldn't be vs just top 40% of top hands.

not hating on the program tho just trying to fig out how to use it best...great stuff, thanks again.

I understand, it's a very good pointyou are making.
I'll have to think if I could include some sort of option "villain minR ROFL 12" or something I'll think it through

I dl'd OOo since I take it the drop downs don't work in excel 03 to change the bbs and ranges? Anyway, when I try opening it with it, it freezes and doesn't respond anymore. What's causing this?

Maybe you could make another slide that would take some top % hands away? Doable?

it only works in excel 07 and later. Excel 03 didn't have some of the programming abilities.

Yeah, I see, but do you know why OOo is freezing and unresponsive every time I try to open it? (I am trying to open the other version designed for OOo too and I dl'd the 3.3 version)