bconway6
11-01-2004, 12:50 PM
Is there any program similar to poker tracker that tracks your B&M play? Obviously its not going to be a ridiculous recreation of every hand you’ve ever played like PokerTracker, but something to chart your play.
I started a little spreadsheet a few years ago and it has grown as I have grown in my knowledge of the game. It used to just be the end result of the night, now it has grown to inputting the date, location, hours played, limit, hands played (if the session was online) and the result of the night. From that it calculates the win rate in $/hr as well as in BB’s/hr. It also keeps running totals of total time spent playing, total winnings in terms of dollars as well as BB’s. It also automatically breaks it down into years dated from the first entry, as well as graphs of your winnings and win rate. There is also a separate sheet for tournaments.
The present goal of this sheet is to enter the game on one master sheet, then from there everything else being automatic. For the most part this is the case, however a problem comes up when cutting and pasting the list of results. When a row is pasted over, the calculations get messed up. Excel gives a #ref error. This can be fixed, by using absolute addresses in the calculating cells. This causes a problem for me though. The way I go about extending the master sheet to accommodate more sessions, is by selecting the blank bottom row of the sheet and ‘fill down’ing 20 or 30 rows.
How can I ‘fill down’ the absolute addresses but have them move down. Say I’ve got a cell addressing $B$5 I want to be able to ‘fill down’ the cell addressing $B$5 and have it addressing $B$6 the cell below that addressing $B$7 and so on.
I started a little spreadsheet a few years ago and it has grown as I have grown in my knowledge of the game. It used to just be the end result of the night, now it has grown to inputting the date, location, hours played, limit, hands played (if the session was online) and the result of the night. From that it calculates the win rate in $/hr as well as in BB’s/hr. It also keeps running totals of total time spent playing, total winnings in terms of dollars as well as BB’s. It also automatically breaks it down into years dated from the first entry, as well as graphs of your winnings and win rate. There is also a separate sheet for tournaments.
The present goal of this sheet is to enter the game on one master sheet, then from there everything else being automatic. For the most part this is the case, however a problem comes up when cutting and pasting the list of results. When a row is pasted over, the calculations get messed up. Excel gives a #ref error. This can be fixed, by using absolute addresses in the calculating cells. This causes a problem for me though. The way I go about extending the master sheet to accommodate more sessions, is by selecting the blank bottom row of the sheet and ‘fill down’ing 20 or 30 rows.
How can I ‘fill down’ the absolute addresses but have them move down. Say I’ve got a cell addressing $B$5 I want to be able to ‘fill down’ the cell addressing $B$5 and have it addressing $B$6 the cell below that addressing $B$7 and so on.