**New FREE 3 bet Shoving Equity calculator available on HUSNG.com** - Page 6 - Heads Up SNG and Spin and Gos -- Two Plus Two Poker Forums

It appears that you have used active-x controls in your workbook. Active-x is not supported on the mac. Use radio buttons from the forms tools instead of the ones you did use. Unfortunately there is no equivalent for the xmlmaps on the mac.

does 'active-x controls' mean anything to you, genher?

might give that link that you gave a go, thanks.

Quote

05-24-2012 , 04:53 PM

#127

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

Can't you get Openoffice on the Mac?

Quote

05-24-2012 , 05:19 PM

#128

genher

veteran

Join Date: May 2007 Posts: 2,931

Quote:

Originally Posted by phos77

think i've found the answer (http://answers.microsoft.com/en-us/m...c-7f7c54b243e7)

does 'active-x controls' mean anything to you, genher?

might give that link that you gave a go, thanks.

yes all the sliders and drop downs menu are "activeX" so the link I gave you won't help. Dave's suggestion is an option (use the open office version) otherwise I could probably make a version without activeX. I'll look into it ! (might not be today tho, I am busy all day)

Quote

05-24-2012 , 07:19 PM

#129

phos77

Pooh-Bah

Join Date: Dec 2008 Posts: 5,496

i tried d/ling openoffice on windows the other day and it was a complete ballache - made me install chrome widgets, only let me d/l 3.1 for some reason and not 3.3, and wouldn't connect when i tried to check for updates in 3.1. just got fed up with it and gave up in the end!

please don't go to any trouble on my account, genher.

Quote

05-24-2012 , 07:25 PM

#130

genher

veteran

Join Date: May 2007 Posts: 2,931

Quote:

Originally Posted by phos77

well if it doesn't work on macs you are probably not going to be the only one, so I might as well do it.

Quote

05-24-2012 , 07:38 PM

#131

slayerv1fan

Go to my Twitch Channel

Join Date: Oct 2009 Posts: 18,907

Hey,

I get an error message when I try to open it in open-office (windows 7 user) saying that it's password protected. Did I DL it incorrectly or am i just blind and missing something easy?

Thx, I'm terrible with computers

Quote

05-24-2012 , 08:23 PM

#132

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

Quote:

Originally Posted by phos77

Sounds like you weren't at the right website. openoffice is an easy download, just have to choose the language you want. and version 3.4 was released recently, maybe there was oddness about the time of release? here's the link: http://www.openoffice.org/download/other.html Mac or Win version should be just fine.

Quote:

Originally Posted by jdawg91

Make sure you're using the openoffice version of the sheet? I don't remember a password popup, tho maybe it was there - I think excel people get it to stop them messing up the formulas.

Quote

05-24-2012 , 09:03 PM

#133

slayerv1fan

Go to my Twitch Channel

Join Date: Oct 2009 Posts: 18,907

upgraded to apache 3.4 open office and it works now, wasn't working on 3.3 for some reason

thx

Quote

05-24-2012 , 09:34 PM

#134

phos77

Pooh-Bah

Join Date: Dec 2008 Posts: 5,496

thanks for the link dave, think i went to the .com site as opposed to .org and got linked to a 3rd party site to d/l the software, hence the dodgy addons. may do a virus scan tomorrow! lol

all sorted now, works a treat!

Quote

05-24-2012 , 10:14 PM

#135

genher

veteran

Join Date: May 2007 Posts: 2,931

Quote:

Originally Posted by phos77

all sorted now, works a treat!

still, wait for the update to be posted on HUSNG.com

Quote

05-24-2012 , 11:35 PM

#136

genher

veteran

Join Date: May 2007 Posts: 2,931

Update 5.01 is now available on HUSNG.com

http://www.husng.com/content/free-so...#comment-30969

As mentioned previously:

There was a bug in one of the hand calc (T6o). When I checked it all, I also found an other small one in the "call your shove calc" formula (luckily it made the results a bit too conservative and not the opposite! ).

I fixed it all and while I was at it I also removed the slider for the effective stack. I figured out that it was easier and quicker to type than click endlessly on the slider . That way you guys can also use it for stack> at 25BB if you wish or use more precise effective stacks (decimals other than .5).

I also ran many more tests to make sure there wasn't any other bug hanging around. All good!

Enjoy it!

Quote

06-02-2012 , 02:32 PM

#137

chuBuBBawuB

centurion

Join Date: Dec 2011 Posts: 115

Hi, looks like a good tool. Not sure if this question has been asked already but with regards to the numbers in the chart is the ev of folding going to be 0BB or -1BB the way you set it up. The boxes go red at 0 and lower so I assume you have the ev of folding as 0BB and the difference between green and red as the point where folding becomes preferable to shoving.
Clarification would be great thanks.

Quote

06-02-2012 , 06:43 PM

#138

lucky1lucky

stranger

Join Date: Jun 2012 Posts: 1

good stuff

Quote

06-02-2012 , 06:57 PM

#139

genher

veteran

Join Date: May 2007 Posts: 2,931

Quote:

Originally Posted by chuBuBBawuB

YES it's the EV from the decision to 3 bet shove and therefore so EV of folding is 0.

and guys make sure you are using version 5.1

Quote

06-12-2012 , 03:53 PM

#140

genher

veteran

Join Date: May 2007 Posts: 2,931

Quote:

Bump. Please help me with this.

If you select 15bb stacks, uncheck 'Exclude 22-55 from raising range', select Min raise, put opening range to 50.53%, and select 'Calling shove range' as 'Super Tight = 66+, A9s+, ATo+, KQs'.

Now, double click on A2o for example, and you will get 82.59% and 17.41% for fold equity and call range percentages, respectively.

Now, the problem is, the only two number of combos for this percentages to be correct is 626 combos for opening range and 109 combos for calling range (I've written a program to confirm this, 109 / 626 = 17.41214057%).

What I don't understand is how can calling range of 66+, A9s+, ATo+, KQs be 109 combos. I only get 106, like this:
AA 3 combos
AKo 9
AQo 9
AJo 9
ATo 9
AKs 3
KK 6
AQs 3
KQs 4
QQ 6
AJs 3
JJ 6
ATs 3
TT 6
A9s 3
99 6
88 6
77 6
66 6

This sums up to 106. Am I missing something or is this a bug?

your calling range count of combos is correct but not your opening range one! you forgot to take away some combos for your A2o that he cannot have. he doesn't have 626 combos in his opening range because you have taken away an A and a 2.

Quote

06-12-2012 , 04:56 PM

#141

genher

veteran

Join Date: May 2007 Posts: 2,931

Quote:

Originally Posted by genher

Sorry about the double post I was in a hurry. So just to confirm he raises 588 combos and call with 106 combos so he folds 81.97% of the time

confirmation from CardrunnersEV

Hope this help

Quote

06-13-2012 , 05:08 PM

#142

SoWhat

centurion

Join Date: Feb 2011 Posts: 105

Quote:

Originally Posted by genher

Sorry about the double post I was in a hurry. So just to confirm he raises 588 combos and call with 106 combos so he folds 81.97% of the time
Hope this help

1. Wait, are we talking about opening range of 50.3% against A2o? If you get 588 combos, and he folds 81.97, why does the table show 82.59%?

2. If he calls 17.41%, as the calculator shows, then the number of opening combos should be 609 (106/609 = 17.41%). Right?

3. Which one of these is 50.3%?

Quote

06-13-2012 , 05:47 PM

#143

genher

veteran

Join Date: May 2007 Posts: 2,931

@above

1. he opens his top 50.53% but we have A2o so he opens 588 combos and call with 106 combos therefore calls 106/588= 18.03% and folds 81.97% as the calculator (and cardrunnerEV) show.

2. The calculator shows 18.03% (see above). have you upgraded to the latest version of it? (5.01)

3. this is 50.53% with the combos

Hope this helps

Quote

06-13-2012 , 06:04 PM

#144

SoWhat

centurion

Join Date: Feb 2011 Posts: 105

Quote:

Originally Posted by genher

@above

1. he opens his top 50.53% but we have A2o so he opens 588 combos and call with 106 combos therefore calls 106/588= 18.03% and folds 81.97% as the calculator (and cardrunnerEV) show.

2. The calculator shows 18.03% (see above). have you upgraded to the latest version of it? (5.01)

3. this is 50.53% with the combos

Hope this helps

Ok, this was pretty much a misunderstanding, I was working with 22-55 included, the numbers are fine now.

Thank you for you answers.

Quote

06-13-2012 , 06:17 PM

#145

genher

veteran

Join Date: May 2007 Posts: 2,931

Quote:

Originally Posted by SoWhat

Ok, this was pretty much a misunderstanding, I was working with 22-55 included, the numbers are fine now.

Thank you for you answers.

no worries. It's easy to make a mistake. That's why I tried to keep the calculator as simple as possible.

Quote

07-20-2012 , 07:03 PM

#146

Craggoo

banned

Join Date: Sep 2006 Posts: 12,644

I wanted to add that anyone who is having trouble getting it to work I had the same problem. Unfortunately, I have vista which has all sorts of weird quirks. I dont know about this OpenOffice program, but in order to get the spreadsheet to work properly (the preflop raise scroll bar was greyed out for me before) you have to run Excel in administrative mode. Don't forget to also enable macros in the TrustCenter. Once you do those 2 things, it should work like a charm.

Quote

07-20-2012 , 07:19 PM

#147

genher

veteran

Join Date: May 2007 Posts: 2,931

Quote:

Originally Posted by Craggoo

any issue post on here I will try to help

Quote

08-06-2012 , 08:50 PM

#148

LiveForever

banned

Join Date: Jun 2008 Posts: 309

brilliant tool

Last edited by LiveForever; 08-06-2012 at 09:07 PM.

Quote

08-06-2012 , 09:51 PM

#149

LiveForever

banned

Join Date: Jun 2008 Posts: 309

Quote:

Originally Posted by genher

YES it's the EV from the decision to 3 bet shove and therefore so EV of folding is 0.

I know this has been asked a ton, but im still confused (mainly because of this thread here http://www.pocketfives.com/f7/equity...3/#post6879425).

We are proceeding from the point after the blinds are posted, so EV of folding is 0 as the blinds are a sunk cost etc.

So say the EV calculation comes out at -0.5BB.

If the blinds are 50/100 and our stack BEFORE posting is 1000, we fold and we are now at 900. An overall EV of -1BB.

If we make the call at -0.5BB (calculated after posting the BB using the tool), is our expected stack at 950 or 850?

Quote

08-06-2012 , 10:38 PM

#150

genher

veteran

Join Date: May 2007 Posts: 2,931

Quote:

Originally Posted by LiveForever

first of all thanks

now for your question: 850

-0.5BB after posting is = to -1.5BB before posting (the-0.5BB you lose on average + cost of BB)

Hope this help

Quote

Page 6 of 9

First

1 2 3 4 5 6 7 8 9

Last

Post Reply Subscribe

...

Page 6 of 9

First

1 2 3 4 5 6 7 8 9

Last