#1
|
|||
|
|||
SNG Spreadsheet
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. |
#2
|
|||
|
|||
Re: SNG Spreadsheet
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. |
#3
|
|||
|
|||
Re: SNG Spreadsheet
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. |
#4
|
|||
|
|||
Re: SNG Spreadsheet
http://www.tilthappens.com/files/2Plus2SNGV2.zip
this should work. It is the spreadsheet Jurollo is talking about. Regards Brad S |
#5
|
|||
|
|||
Re: SNG Spreadsheet
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. |
#6
|
|||
|
|||
Re: SNG Spreadsheet
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.
|
#7
|
|||
|
|||
Re: SNG Spreadsheet
Thanks, Jurollo. I was using version 1.1. Version 2.0 does exactly what I was asking. Thanks again.
|
#8
|
|||
|
|||
Re: SNG Spreadsheet
I've got a pretty easy to use one for excel if you want. PM me if ya want it.
|
#9
|
|||
|
|||
Re: SNG Spreadsheet
Thanks, I love this spreadsheet. But being excel challenged is there a way to imput more than 100 games?
|
#10
|
|||
|
|||
Re: SNG Spreadsheet
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 |
|
|