)
Restorations Spreadsheet Version 1.1 Released!
Thread Starter
Drifting
Joined: Aug 2002
Posts: 1,452
Likes: 190
From: Zion NC
Restorations Spreadsheet Version 1.1 Released!
This is the newest edition of my Restoration Spreadsheet. Available free to you all. I hope that this helps to get a few more of our old beauties on the road.
Version 1.1 Additions and changes.
-Locked the cells that you shouldn't be changing. They are not password protected so anyone who wants to change stuff can simply unlock them and you are good to go.
-Added a Vendor page.
-Added a lookup from the Vendor page on the Overview page.
-Added expenditure graph to the Overview page.
Version 1.2 Additions and Changes
- Added Shipment page.
- Fixed a minor error in spreadshet lock.
Version 1.2a Bug repair.
- Fixed missing variable in totalizer for overview page. If you do not wish to download this spreadsheet. Simply unlock the overview page. then input in cell E2 =SUM(B8:B21)
The file link is here:
Restoration Spreadsheet
It has been great working on this project for you all. I hope this helps! Also, feel free to post additions and changes that you would like here. I will continue to update this as interest dictates.
Enjoy!
Version 1.1 Additions and changes.
-Locked the cells that you shouldn't be changing. They are not password protected so anyone who wants to change stuff can simply unlock them and you are good to go.
-Added a Vendor page.
-Added a lookup from the Vendor page on the Overview page.
-Added expenditure graph to the Overview page.
Version 1.2 Additions and Changes
- Added Shipment page.
- Fixed a minor error in spreadshet lock.
Version 1.2a Bug repair.
- Fixed missing variable in totalizer for overview page. If you do not wish to download this spreadsheet. Simply unlock the overview page. then input in cell E2 =SUM(B8:B21)
The file link is here:
Restoration Spreadsheet
It has been great working on this project for you all. I hope this helps! Also, feel free to post additions and changes that you would like here. I will continue to update this as interest dictates.
Enjoy!
Last edited by ElCid79; Jan 25, 2016 at 11:49 PM. Reason: request for donation removed
Thread Starter
Drifting
Joined: Aug 2002
Posts: 1,452
Likes: 190
From: Zion NC
Any chance of a sticky for this one moderators? It's something that most people will find useful. Cheers!
Per the request on another forum I just posted version 1.2
Version 1.2 Changes
- added shipments page.
Per the request on another forum I just posted version 1.2
Version 1.2 Changes
- added shipments page.
Last edited by ElCid79; Mar 31, 2011 at 11:06 AM.
Corvette Stories
The Best of Corvette for Corvette Enthusiasts
Every 2027 Corvette Engine Explained
Joe Kucinski
Designer Imagines A Corvette That Looks More Like a Corvette Than the Corvette
Verdad Gallardo
10 Ugly Corvettes That We Still Kinda Love
Joe Kucinski
Top 10 Most Expensive Corvettes Ever Sold on Bring A Trailer
Brett Foote
10 Things Every Corvette Owner Needs (2026 Edition)
Michael S. Palmer
8 Most "Only Corvette Owners Understand" Quirks and Problems
Pouria Savadkouei
10 Reasons the C6 Z06 is Still A Performance Benchmark After 20 Years
Joe Kucinski
How Much Horsepower Every Corvette Engine "LOST" in 1972
Joe Kucinski
Top 10 DOs and DON'Ts for Protecting Your Convertible Top!
Michael S. Palmer
Race Director
Joined: Feb 2006
Posts: 12,239
Likes: 19
From: Chino CA
Race Director
Joined: Feb 2006
Posts: 12,239
Likes: 19
From: Chino CA
Drifting
Joined: Apr 2008
Posts: 1,992
Likes: 56
From: Antioch IL
thanks that is very neat. i guess i will have to pull out all of the receipts that I have laying around! I hope that I will not faint when I see How much I have already put in to the car. LOL I guess I will be safe as long as my wife does not see it.
Safety Car
Joined: Jun 2004
Posts: 4,652
Likes: 80
From: Lakeland Florida
I think the question about the cost of the car could go into the other seciton. But then the weighting factor of the orignal price of the car would make the percentages of the pie chart extremely small. So it should be added to the total restoration price as a subtotal. I like the way you did this and kept the original purchase price out so it does not skew the graph.
kdf
kdf
Melting Slicks
Joined: Aug 2010
Posts: 2,207
Likes: 26
From: Ocean County NJ
Nice job! Thanks for sharing. Now I can get real organized. Just need to hide it from the mrs so she doesn't see how much I'm really spending - I'll just password protect the file I guess :-)
Race Director
Joined: Dec 2005
Posts: 13,515
Likes: 12
From: Fisher, IL
I've had my car a year now and have been tracking what i've been doing.
Obviously not in as serious an excel file but i'll transfer all my stuff over and see what happens. Mine really wasn't to say "look at how much i've wasted" but more for information to pass on or use later if I need to know about stuff i've done to the car and when...
First thing I also noticed was no start up car purchase price...
I just added it to the overview page at the top(no need for a tab) I linked it to the overall total but didn't want it taking up 50% of my pie chart so i left it out of that.
Left out transmission(i'll lump anything i do with that into engine work i guess) and the vendors and shipping. Might see what others do with the vendor info but for now I didn't like it.
I added a Tools and Paint, Powder, Media/Solvents tab.
I will also be adding an Optional tab as a lot of the tools i've bought can be used for future projects so I don't want it to be lumped in with this one alone. So if I do another project I might do a percentage or something with them...
This is only for 2010, haven't entered my receipts for 2011 yet.. although I don't like getting behind on this.
Obviously not in as serious an excel file but i'll transfer all my stuff over and see what happens. Mine really wasn't to say "look at how much i've wasted" but more for information to pass on or use later if I need to know about stuff i've done to the car and when...
First thing I also noticed was no start up car purchase price...
I just added it to the overview page at the top(no need for a tab) I linked it to the overall total but didn't want it taking up 50% of my pie chart so i left it out of that.
Left out transmission(i'll lump anything i do with that into engine work i guess) and the vendors and shipping. Might see what others do with the vendor info but for now I didn't like it.
I added a Tools and Paint, Powder, Media/Solvents tab.
I will also be adding an Optional tab as a lot of the tools i've bought can be used for future projects so I don't want it to be lumped in with this one alone. So if I do another project I might do a percentage or something with them...
This is only for 2010, haven't entered my receipts for 2011 yet.. although I don't like getting behind on this.
