posted on February 15, 2001 01:16:41 PM
Was wondering if any kind souls would be willing to help me out with sending me a template of how they have their database (calculations, etc) set up in Excel or Access. Just don't want to reinvent the wheel. Any tips or tricks would be great too.
I couldn't find a 'search' field for the message boards to see if anything showed up previously on this topic.
posted on February 15, 2001 01:37:28 PM
There has been some excel threads. I built my own database in Access, but it's still a work in progress after a couple hundred hours of fiddling. Your best bet is to fiqure out your requirements and roll up your sleeves with a big Que book. The best help is available on the Microsoft user groups and Microsoft's awesome Knowledge Base. A database is best for tracking, a spreadsheet exported from the Access tables can let you do the beancounting if you need to.
posted on February 16, 2001 07:17:01 AM
I use MS Excel to track everything in all of my auctions. I'd be happy to send you a blank copy of my current version (it gets tweaked every once in awhile) if you'd like me to.
Current fields are:
Date auction closed
ID
Title
Bid Price
S/H
Cost of Item
High Bidder
Email of High Bidder
Payment Rec'd
Item Shipped
FVF Fee
I have a separate sheet set up for Ebay, Amazon, Yahoo, and Other (direct sales via website, other auction sites), and an invoice page that I copy the info into for printing invoices to include with the shipment.
posted on February 16, 2001 11:16:39 AM
I've already had 3 people email me about my template file - if anyone has any questions after receiving my file, please don't hesitate to email me.
I'm happy to answer questions and help modify the spreadsheet format for your specific needs, if I can.
posted on February 16, 2001 02:04:16 PM
If you look at your End of Auction (EOA) e-mail, you can extract the following information:
Date auction closed
ID
Title
Bid Price
High Bidder
Email of High Bidder
FVF Fee can be easily calculated by taking the final high bid and running it through a formula.
I use a program called MsgParse 2.0 that will take the the EOA e-mail and automatically import it into an Access database. You can even have the program write to a text file which you can import into Excel. It is a work in progress, but the investment in time will automate a lot of your processes. If you download the evaluation version:
