0 |
Subject: Statistic Text Files
Posted by: philliephan
- [30425416] Wed, Nov 01, 21:13
I have posted two text files, they are both fixed format:
1) SW prices for each day is http://www3.ewebcity.com/swp/db/files/swprices.txt a) Pos 1-4 is the SW id # b) Pos 5-29 is the player name c) Pos 30-34 is the current price d) pos 35-39 is the prev day price e) Pos 40-44 is the day before price etc. If you download this file to your c:\ directory, the macro routine in http://www3.ewebcity.com/swp/db/files/importswprices.txt will put these all into separate cells of an Excel spreadsheet.
2) SW points YTD for each day is http://www3.ewebcity.com/swp/db/files/swpoints.txt a) Pos 1-4 is the SW id # b) Pos 5-29 is the player name c) Pos 30-33 is the current SWP d) pos 34-37 is the prev day SWP e) Pos 38-41 is the day before price etc. If you download this file to your c:\ directory, the macro routine in http://www3.ewebcity.com/swp/db/files/importswpoints.txt will put these all into separate cells of an Excel spreadsheet. (You may calculate each days SWP by subtracting the previous days from it.)
Currently the prices file has Oct 4 - Nov 1 prices and the SWP file has Oct 4 - Oct 31 SWP.
|
1 | The Beezer
ID: 1593319 Thu, Nov 02, 00:38
|
Awesome! Thanks, philliephan, you rule! ;)
|
2 | philliephan
ID: 5843138 Fri, Nov 03, 06:40
|
These files are now updated with statistics and proces through 11/2.
|
3 | Cyclone
ID: 5839127 Fri, Nov 03, 10:46
|
philliephan,
These files are great!
Could you add a date time stamp to the file so we can see when the file was updated.
Is a new macro required daily to work with the information added for that day?
Cyclone
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|