Poker spreadsheet

matt berkey · #1 10-01-2005, 10:01 PM

I'd like to keep track of my live sessions but can't seem to find a spreadsheet. So I tried creating one in Excel but can't seem to figure out how to keep a running balance of my profits. Any suggestions???

#2 10-01-2005, 11:59 PM

See if this helps.

Crix · #3 10-02-2005, 02:42 PM

Another great one worth having a look at:

http://www.chrishalverson.com/images...nkroll1.01.xls

BigBiceps · #4 10-03-2005, 05:32 PM

You can insert a row at the top and it will sum the columns with the function c1=sum(c2:c60000) to sum column c for example.

If you want to see the grand total for each day, create a new column that is for example d4=d3+c4, where d4 is the new total, d3 is the previous total, and c4 is the current session result. Then using the fill feature you can drag this down so it does it automatically for each new session.

smartalecc5 · #5 10-04-2005, 07:36 PM

[ QUOTE ]
Another great one worth having a look at:

http://www.chrishalverson.com/images...nkroll1.01.xls

[/ QUOTE ]

that's badass though I can't create a new webiste. It gives me an error.

Crix · #6 10-05-2005, 12:34 PM

[ QUOTE ]
[ QUOTE ]
Another great one worth having a look at:

http://www.chrishalverson.com/images...nkroll1.01.xls

[/ QUOTE ]

that's badass though I can't create a new webiste. It gives me an error.

[/ QUOTE ]

I had problems with that as well. In the end, I justed edited the sites that I don't use with details of those that I do.

It would be great if someone with a bit of Excel expertise could do some fine tuning on this. It has become a bit of an opensource project anyway as it is a mix of different peoples work brought together.

Any takers?

smokylosecannon · #7 10-05-2005, 01:15 PM

hey matt, this is diceman. check this web page