This is a discussion on Help calculating bb/100 within the online poker forums, in the General Poker section; 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 


#1




Help calculating bb/100
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 
#4




Quote:
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 
#8




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. 
#10




Quote:

#13




Quote:
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. 
#15




Quote:

#16




Quote:
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




Quote:

#19




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




Quote:
Quote:

#21




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