Originally posted by Kexia
I have finally decided to start using Excel to track my SnG progress. However I have no idea how I should do this...
I was wondering if any of you could give me some tips? What do you guys take into consideration? BR? RoI? Anything else? Can anyone tell me how to set this up in Excel?
Thanks
I'm using excel for tracking progress and I can tell you how I'm tracking it. You might not want to track it that way (cause it's a little complicated), but maybe it helps you find your own way to track.
I'm using 2-3 sheets.
1st sheet is daily profit. Columns:
A - Date
B - Starting bank (before first tournament that day)
C - Ending bank (after last tournament that day)
D - Profit (c2-b2)
2nd sheet is every single tournament. Columns:
A - Date
B - Tournament type (if you are playing more then one type of tournament)
C - Place you finished in tournament. I'm not writing every single place. If I'm not in the money, I'm putting 0 there, So, it looks something like 1-2-2-0-0-1-2 ...
D - Totaly buy in (summary of all buy ins. If, for example, I played 7 $5,50 sng's then in that column is 38,50 (7*5,50)
E - Totaly cash out from all of those tournament.
F - Profit (E2-D2)
G - ROI - (F2/D2)