Btw. There are different pages on the bottom of the spreadsheet. Thats where the meat and potatos are. Don't edit anything on page one. With the exception of your BUDGET. Everything else is automatic...
I used to build engines and developed a spreadsheet for a similar reason as yours.
I added a sheet that listed all the vendors along with contact information that I used.
This was useful when it came time to do the next engine. I see you have a vendor column, but having the vendor info on one sheet was nice.
If you are into macros and VBA, you could create a button on the Overview page that brings up a data entry pop-up with option boxes and then autopopulates the correct worksheets.
I learned a bunch when I developed a question/answer log for a company I worked for a few years ago. Google was my friend during that project. There are many good forums out there with a lot of helpful people on them.
I also picked up a book "Excel 2003 Power Programming with VBA" by John Walkenbach.
That is very cool.
I think using something like that to track parts and vendors, along with order/delivery times is a good thing. I'm not really sure the cost category is a good thing. If my bride ever found out how much I've spent, I'd be graveyard dead.
Yeah, we can add a few columns, tracking #, order number, vendor etc. wouldn't be to hard. Then we could have the vendor link to a vendor page of its own, where you list all of the contact information for each vendor. I may work on that too.
I may continue to tweek this spreadsheet a bit over the next few days/weeks. See if I can get something really good built up. Perhaps we could get a sticky from the moderators once its finished? If you all find it useful enough.
Thanx for sharing that!
Wish I knew how to really use excel like that. I'm a gettin there, self taught on PC's.
I used to run & teach CAD workstations, so it made learning the PC a tad easier. :thumbsup: