Open Side Menu Go to the Top
Register
I created a SNG spreadsheet for tracking results I created a SNG spreadsheet for tracking results

07-22-2015 , 04:43 AM
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
I created a SNG spreadsheet for tracking results Quote
07-22-2015 , 08:50 AM
Here's an updated link.

Imgur

Bubble survival% is now automated for 6, 9, 27, 45, 90, and 180 mans as long as you define the number of players under tourney information.

Last edited by Foosa; 07-22-2015 at 08:51 AM. Reason: add information
I created a SNG spreadsheet for tracking results Quote
07-22-2015 , 06:59 PM
Thanks for this. I am way too lazy so I guess I will continue to rely on refresh balance with my safe/solid/sarcasm 5-10 buyin variable BRM strategy. I'll try to take a look at the formulas later and give advice if I see anything. subbed
I created a SNG spreadsheet for tracking results Quote
07-24-2015 , 11:13 PM
Is bubble survival x/xplus1 finishing distribution where x is number of players who cash?

Dont see how that's an important stat. Esp non ev adjusted.
I created a SNG spreadsheet for tracking results Quote
01-04-2017 , 09:01 AM
Bumped this one. I haven't been playing seriously the last 5 years or so and I wanna test the waters again. The link in OP is dead. Has someone a working link to an excel tracking SNG spreadsheet? Thx in advance!!
I created a SNG spreadsheet for tracking results Quote
01-05-2017 , 09:44 PM
Hi Foosa...do you still have this spreadsheet? Can you please post the link? Thank you in advance.
I created a SNG spreadsheet for tracking results Quote

      
m