|
#1
|
|||
|
|||
I\'ve created a \"Studtracker\" Spreadsheet
Hello all,
My eventual aim is to create an actual Studtracker, however for now I'm using Excel to create a spreadsheet, so I can just get the standard data in. If anyones interested in it i'll upload it, but I'm more looking for feedback as to what information you would be interested in. Here is an example for November: http://img512.imageshack.us/img512/2...tracker9ux.jpg |
#2
|
|||
|
|||
Re: I\'ve created a \"Studtracker\" Spreadsheet
Oh I should mention, there are different worksheets for different months, and there will be a MAIN sheet which gives you all the overall information.
|
#3
|
|||
|
|||
Re: I\'ve created a \"Studtracker\" Spreadsheet
[ QUOTE ]
Oh I should mention, there are different worksheets for different months, and there will be a MAIN sheet which gives you all the overall information. [/ QUOTE ] I do a simple excel sheet too but only update it every couple weeks (since i am doing it manually). I don't get in the number of hands though to get a BB/hr partially out of laziness and because I play at work and at home and don't write down what i do at work. Basically i have each site and the balance and then do some simple amount of inc. and % inc. from the last two week period. If there was a way to auto import everything that would be awesome. |
#4
|
|||
|
|||
Re: I\'ve created a \"Studtracker\" Spreadsheet
How does the data get into the spreadsheet - manually?
|
#5
|
|||
|
|||
Re: I\'ve created a \"Studtracker\" Spreadsheet
[ QUOTE ]
How does the data get into the spreadsheet - manually? [/ QUOTE ] At the moment, yes. It's basically v.01 [img]/images/graemlins/smile.gif[/img] I'm still inputting all my old data, and then I'm going to work on being able to import automatically. Should be by this weekend it will auto-import. |
#6
|
|||
|
|||
Re: I\'ve created a \"Studtracker\" Spreadsheet
[ QUOTE ]
[I'm going to work on being able to import automatically. [/ QUOTE ] How? I want that too… |
#7
|
|||
|
|||
Re: I\'ve created a \"Studtracker\" Spreadsheet
I'll write some VB Macros most probably, and failing that I'll write a quick software program.
Importing the older ones right now I am doing manually, and the process is this: (1) Check Date / Time of first hand. (2) Check Buy-In. (3) Run search, "MYUSERNAME posts ante" and count how many times. (4) Check Date/Time of last hand. (5) Check last amount I had at table. There's some slight variations from that, but generally it's the whole process. I should be able to automate that super easy, then account for the variations and make a few extra tweaks. |
#8
|
|||
|
|||
Re: I\'ve created a \"Studtracker\" Spreadsheet
[ QUOTE ]
There's some slight variations from that, but generally it's the whole process. I should be able to automate that super easy, then account for the variations and make a few extra tweaks. [/ QUOTE ] Sounds good. Keep me/us updated. |
#9
|
|||
|
|||
Re: I\'ve created a \"Studtracker\" Spreadsheet
Picture Wars!
...that's like half of it... [img]/images/graemlins/grin.gif[/img] Edit: sucks...you have to click on the image and then hit the "back"-button. At least that works for me. |
|
|