The
spreadsheet.
Here's a preview on
imgur.
It's a modified version of AleoMagus' old spreadsheet. I modified it so that you could have separate sheets for different game types and buy-ins (up to 180 mans), and have the statistics and graphs corresponding to each game type on the same page. The overall results sheet combines a few statistics from all of the sheets. There are also some new stats from AleoMagus' old spreadsheet, including average duration for each game type and $/hr, which requires you to keep track of your daily session length. The graphs also auto-update/expand when new rows are inserted.
There are some limitations. Results101 is a dummy sheet for example. You also can't rename any of the sheets or else the formulas don't work on the overall results sheet. Also the last row in each table is a dummy row, and it's there for copying and inserting new rows when you reach the table limit, though it will auto-fill with updated references, formulas, and the same format. I was using open office and the insertion of rows is the easiest way to have the graphs auto-expand their range.
I'm sure there are bugs. Please point them out so I can fix them. If you are good with excel, you could probably make it a lot nicer.
Make sure to read the information in the first sheet. Once you understand everything you can delete the tips.
Edit: Fixed spreadsheet problems I found already.
Last edited by Foosa; 07-22-2015 at 05:02 AM.
Reason: found some spreadsheet problems