Help calculating bb/100

#1 23rd August 2008, 9:32 AM

I'm trying to start measuring how many big blinds I make/lose per 100 hands I play. As I'm not the best at excel I need your help. Below is a scenario if you could answer but also show workings this will be really appreciated so I'll thank you in advance

I played 417 hands
Limit was .01 .02
I profited $1.09

How many big blinds have I won per 100 hands and how do you calculate it?

Better yet, how would I write this as a formula in excel, if anyone knows?

Thanks again
Custo

#2 23rd August 2008, 9:53 AM

If I knew the formula I could write it in excel. Let me look in the strategy articles and I'll get back to you.

#3 23rd August 2008, 9:59 AM

ok cool, thanks

#4 23rd August 2008, 10:11 AM

Quote:

Originally Posted by custo80

I'm trying to start measuring how many big blinds I make/lose per 100 hands I play. As I'm not the best at excel I need your help. Below is a scenario if you could answer but also show workings this will be really appreciated so I'll thank you in advance

I played 417 hands
Limit was .01 .02
I profited $1.09

How many big blinds have I won per 100 hands and how do you calculate it?

Better yet, how would I write this as a formula in excel, if anyone knows?

Thanks again
Custo

So you have won $1.09 and your bb is 0.02 (2c), so total bb's won = 1.09/0.02 = 54.5bb's

So total bb/100 =

54.5/(417/100) = 54.5/4.17

= 13.069

=13.07bb/100

Spreadsheet may be something like this (winnings/bb)/(no of hands/100)

(1.09/0.02)/(417/100) I think

#5 23rd August 2008, 10:18 AM

Jagsti, you are an absolute legend, =(1.09/0.02)/(417/100) was the exact formula. Thank you very much

#6 23rd August 2008, 10:20 AM

If I knew the formula I could write it in excel. Let me look in the strategy articles and I'll get back to you.

#7 23rd August 2008, 10:23 AM

Custo just realised this is limit so it's slightly different as the formula above is for BB/100 (big bet)

To get bb/100 you have to change the 0.02BB to 0.01bb, as the blinds are 0.05 and 0.1 I think.

#8 23rd August 2008, 10:24 AM

Ok found it. The formula is (Total Amount Won)/(Total Hands Played/100).

In excel say a1 would be Total Amount Won and a2 would be total hands played, you would write the following formula in a3.... "=A1/(A2/100)" without the quotation marks.

#9 23rd August 2008, 10:31 AM

Jaqsti was right it would be =(a1/.01)/(a2/100)

#10 23rd August 2008, 10:45 AM

Quote:

Originally Posted by custo80

I'm trying to start measuring how many big blinds I make/lose per 100 hands I play.

Why don't you use PT or Holdem Manager ?

#11 23rd August 2008, 10:45 AM

Custo ignore my last post if the blinds are 0.01/0.02, Im rambling

#12 23rd August 2008, 12:07 PM

Quote:

Originally Posted by BelgoSuisse

Why don't you use Poker Tracker or Holdem Manager ?

At 0.01/0.02 would that not be a large investment for little return?

#13 23rd August 2008, 12:47 PM

Quote:

Originally Posted by vagas35

At 0.01/0.02 would that not be a large investment for little return?

if you plan on staying at 0.01/0.02, yes.

But for the amount of hands OP was considering, the trial versions work. And PT still has a beta version that you can download and i guess that that beta requires no license.

Furthermore, if you ever plan to move up, then it's a great investment because it will improve your game much faster.

#14 23rd August 2008, 1:14 PM

Get PT3 over HEM if you dont want to pay anything as with PT3 you get a 60 day trial period where you can import as many hands as your heart desires, whereas HEM restricts you to 5k hands trial.

#15 23rd August 2008, 1:15 PM

Quote:

Originally Posted by ajrobin

Get PT3 over HEM if you dont want to pay anything as with PT3 you get a 60 day trial period where you can import as many hands as your heart desires, whereas HEM restricts you to 5k hands trial.

but if you ever want to buy one, HEM is way better at the moment.

#16 24th August 2008, 1:44 AM

Quote:

Originally Posted by Jagsti

Custo just realised this is limit so it's slightly different as the formula above is for BB/100 (big bet)

To get bb/100 you have to change the 0.02BB to 0.01bb, as the blinds are 0.05 and 0.1 I think.

Don't worry Jagsti I did ignore the rambling It has bought up a new question for me though.

I understand that bb/100 measure big blinds won per hundred hands.
You've said, and I've heard it before about BB/100 which measures big bets per hundred hands. If this is the most obv. question then I apologize in advance but what is a big bet? Bearing in mind I'm on .01/.02.

Thanks again

#17 24th August 2008, 4:23 AM

Quote:

Originally Posted by custo80

Don't worry Jagsti I did ignore the rambling It has bought up a new question for me though.

I understand that bb/100 measure big blinds won per hundred hands.
You've said, and I've heard it before about BB/100 which measures big bets per hundred hands. If this is the most obv. question then I apologize in advance but what is a big bet? Bearing in mind I'm on .01/.02.

Thanks again

Basically it's from limit, but some people use it for NL too, basically a big bet is double the big blind. So if you find out big blinds won/lost per 100 hands, just divide it by 2 to get your big bets won/lost per 100.

#18 24th August 2008, 4:47 AM

Ta Zach

#19 16th September 2008, 7:54 PM

When figuring out bb/100 would the number of tables you play (if you MT) be a factor?
Or does it not matter if you MT because we are figuring out BB/100 for the (total profits/BB)/(hands/100)?

#20 16th September 2008, 7:55 PM

Quote:

Originally Posted by philthy

When figuring out bb/100 would the number of tables you play (if you MT) be a factor?

No

Quote:

Originally Posted by philthy

Or does it not matter if you MT because we are figuring out BB/100 for the (total profits/BB)/(hands/100)?

This. $/hour (and thus BB/hour, or whatever other unit per time) is impacted, but winrate per number of hands is static whether you play a million hands a second or if it takes you an hour to play one hand.

#21 16th September 2008, 7:57 PM

Geez, you're fast. And thanks for clearing that up.

#22 16th September 2008, 8:01 PM

Quote:

Originally Posted by philthy

Geez, you're fast. And thanks for clearing that up.

lol had just gotten online and saw your post, didn't even realize it was a minute before.

#23 16th September 2008, 8:28 PM

PT shows big bet/100, not big blind/100, correct?

#24 16th September 2008, 8:52 PM

Quote:

Originally Posted by Likminutz

Poker Tracker shows big bet/100, not big blind/100, correct?

Correct.

Similar Threads for: Help calculating bb/100 > Texas Hold'em Poker
Thread	Replies	Last Post	Forum	Thread Starter
How do the BB/100 work?	19	26th April 2012 3:59 PM	Learning Poker	jaystun00
ICM Calculator for calculating final table chops	16	21st February 2012 9:05 PM	Poker Software & Tools	Poker Orifice
Sustainable BB/100 for 2NL 6MAX	23	10th August 2011 6:46 PM	Cash Games	Spoolin99DSM
Working out bb/100	5	25th April 2011 12:09 PM	Cash Games	ben_rhyno

Play Texas Hold'em Online Poker \| Help calculating bb/100
BetOnline Poker is a top online poker site accepting all US players with an INSTANT cash bonus of up to $900 FREE. It also has a casino and sports betting available.	PokerStars is one of the best places to play poker online. Use PokerStars marketing code CCHAT for a $600 bonus. Note: No US Players Accepted.