#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
How does the data get into the spreadsheet - manually?
|
#4
|
|||
|
|||
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. |
#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
[ QUOTE ]
[ 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. [/ QUOTE ] |
#10
|
|||
|
|||
Re: I\'ve created a \"Studtracker\" Spreadsheet
Can't this be joined with JonIvan's program? --Mike Emery's a fish. |
|
|