Using Excel and server_toonname_eq2_storelog.txt
Hey All,
I too followed the link to no avail.
I currently use Microsoft Excel to import the sales from all of the stores that I maintain. I do not sort them by date as much as I sort them by whatever sold. Isn't it possible to sort the sales by date since it is one of the fields you import? I will try next time.
I maintain a LOT of stores as well, and have 80 crafters duplicated, and way the heck too much time on my hands. Just some thoughts on some of the tricks I do:
1. Importing the sales log of toon X into excel will duplicate information if you do not delete the storelog file after you import. I learned this the hard way duplicating a lot of unnecessary things.
2. I keep a separate sheet for each crafter, Armorer, Carpenter, etc, and cut and paste the imported data from the main sheet to the appropriate crafter. Then I log that crafter and remake whatever is selling well and profitably. This requires that you know that a "smoldering intellectual backing" is made by a Jeweler, but you sound like me, on top of your crafting game.
3. Backup said excel file. A lot. No more than that. Use lots of different hard drives and cds and removable media. hehe
If anybody has any suggestions or maybe kodansoftware's program moved somewhere, please let me know I would like to take a look at it.
Remember to break or the carpal tunnel will get worse!
Ret
|