Re: bb/hr calculation
I thought there might be something simple I was missing.
(a + b) / (x + y) does not equal a/x + b/y
What would be the correct formula to use in a spreadsheet to get my overall bb/hr?
Excel format:
column A = session win, rows 1 to x
column B = session hours, rows 1 to x
column C = total win, rows n = 1 to x: =SUM(A$1:An)
column D = total hours, rows n = 1 to x: = SUM(B$1:Bn)
column E = total win/hr, rows n = 1 to x: =Cn/Dn
I can email you an Excel spreadsheet that does this and also computes standard deviation if you want. In exchange you can explain to me how to adjust to PBA lane patterns A-E. [img]/images/graemlins/grin.gif[/img]
|