SNG Spreadsheet

ZeeJustin · #1 09-20-2004, 04:42 PM

Anyone have a good spreadsheet for keeping track of SNG results?

I started making one, but I realized I don't know how to calculate %ITM or average finish using spreadsheet. ROI and Net profit otoh are easy.

Jurollo · #2 09-20-2004, 04:47 PM

Zee,
Aleomagus made one, and I, amongst others edited it. I reckon you have played a lot and the current version only houses 750 tournies, but I made one which resides on my computer for 10,000 and I could email it to you if you like. PM me if you want me to.

housenuts · #3 09-20-2004, 05:46 PM

i track my stats with the free services at www.pokercharts.com

unfortunately it doesn't give the ITM%. or maybe i haven't found it. does anyone else use this?

i would however be interested in this spreadsheet.

AleoMagus · #4 09-20-2004, 06:38 PM

http://www.tilthappens.com/files/2Plus2SNGV2.zip

this should work. It is the spreadsheet Jurollo is talking about.

Regards
Brad S

asics · #5 09-20-2004, 08:13 PM

Aleo and Jurollo,

Many thanks for the spreadsheet. One question about the updated chart(somewhat offtopic)...I only have around 110 sngs entered and so the chart doesn't show as much definition as in Aleo's original spreadsheet that was set up for 100 sngs. Is there a way to only chart the number of sngs actually played (and eliminate the long line at the end)? Thanks again.

Jurollo · #6 09-20-2004, 08:36 PM

That version should have automatically updating charts. I might just upload the 10,000 entry version onto the tilthappens server and repost a link, it has dynamic charting and such, and can handle 10,000 SNGs which for most is a lifetime.

asics · #7 09-20-2004, 10:00 PM

Thanks, Jurollo. I was using version 1.1. Version 2.0 does exactly what I was asking. Thanks again.

Daliman · #8 09-20-2004, 10:17 PM

I've got a pretty easy to use one for excel if you want. PM me if ya want it.

redart · #9 09-25-2004, 03:57 PM

Thanks, I love this spreadsheet. But being excel challenged is there a way to imput more than 100 games?

AleoMagus · #10 09-25-2004, 04:16 PM

Did you use the tilthappens link? My old Universal sheet had only 100, but that one has room for 750 tourneys (and it does a lot of other cool things).

Just as a side note, I strongly recommend messing around with the charting functions on these sheets because it is really easy to come up with all kinds of cool new graphs for almost anything you are interested in. Mine now has independent Weekday ROI/ITM bar graphs as well as a Profit graph which uses Date as the x-axis instead of # tourneys. It's just really easy to come up with new stuff if you experiment a bit. You can also make it look more aesthetically pleasing (though I keep mine plain for ease of printing).

Regards
Brad S