"How many hands do I need to play..."

[itsmarty]

That tripped me up as well. Column A is the label and B is the value, so you have to use B's.

I also found out that if you forget the decimal in your confidence interval (95 instead of .95), it really messes things up [img]/images/graemlins/smile.gif[/img]

Martin

[itsmarty]

For those without Excel who are interested in trying this out, try OpenOffice (www.openoffice.org). That's what I use for my bankroll spreadsheet, and it handled these additions nicely.

It's free, and mostly compatible with MS Office (only a power user is likely to encounter incompatibilities).

Martin

[RedWave]

I'm pretty much Excel illiterate as far as calculations go, so how do I get the values to appear after I enter all of the information? I put in the values for everything but the equations I enter into cells B5 and B6 don't change to the numbers.

Nevermind, it seems to be working now [img]/images/graemlins/confused.gif[/img]

Another stupid question, is EV/hr the same as the win rate/hr?
Nevermind again, the answer is yes and yes the question is stupid. Got it to work, thanks for the great post Homer.

[Jim C]

There is a problem with the given formula. In the original post, you put the numbers in column B, but the formula references the cells in column A. Put the numbers in column A and the labels in column B and the formulae will work.

FWIW,
Jim

[Number4]

Thanks a lot Homer - great post.

[Spicymoose]

What are the limitations on this formula? I have my numbers in, and things seem to look alright, but my .50/1 limit results seem way off.

Now I just started over at a new site (for a rakeback), and only have 674 hands. I have won 17.54 BB/100 hands, with EV/hr of 10.28 and SD/hr of 11.

Now according to your post I can now say that "I am %90 sure that that I will be winning $5-$15.6 at .5/1" which seems completely absurd. My only thought here is that we need the true SD/hr instead of the statistic, which we can never truly have. How big does our sample size need to get before we can use this formula?

Thanks,
Spicymoose

[Alobar]

will someone explain to the mathmatically challanged (me), what "normsinv" in the equation is? and where am I supposed to plug (h) in?

[bisonbison]

For those working in BB/100 and Pokertracker:

A1: Hands
B1: Hand Count from PT
A2: EV/100
B2: BB/100 from PT
A3: SD/100
B3: SD/100 from PT session tab, 'more detail' button.
A4: Confidence Interval
B4: an integer between 0-99 (note: Homer originally used 0-.99)
A5: Upper Bound
B5: =B2-NORMSINV((100-B4)/200)*B3*(1/SQRT(B1/100))
A6: Lower Bound
B6: =B2+NORMSINV((100-B4)/200)*B3*(1/SQRT(B1/100))

[Homer]

[ QUOTE ]
What are the limitations on this formula? I have my numbers in, and things seem to look alright, but my .50/1 limit results seem way off.

Now I just started over at a new site (for a rakeback), and only have 674 hands. I have won 17.54 BB/100 hands, with EV/hr of 10.28 and SD/hr of 11.

Now according to your post I can now say that "I am %90 sure that that I will be winning $5-$15.6 at .5/1" which seems completely absurd. My only thought here is that we need the true SD/hr instead of the statistic, which we can never truly have. How big does our sample size need to get before we can use this formula?

Thanks,
Spicymoose

[/ QUOTE ]

I'm not sure what the limitations are. I'm thinking that once your SD levels off, it should be safe, but I'm not 100% sure.

[Homer]

[ QUOTE ]
will someone explain to the mathmatically challanged (me), what "normsinv" in the equation is? and where am I supposed to plug (h) in?

[/ QUOTE ]

You don't plug number of hands in directly (I don't know why I put an "h" there), you use either sets of 100 hands (if using WR/100 and SD/100) or hours played (if using WR/hr and SD/hr).

normsinv is the inverse normal distribution function. I'm too lazy to explain it further right now, and even if I tried I probably wouldn't do it justice.

-- Homer