)
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
150 hp to 1,250 hp: Every Corvette Generation Compared by the Specs That Matter
Joe Kucinski
8 Coolest Corvette Pace Cars (and Replicas) of All Time
Verdad Gallardo
Top 10 Corvette Engines RANKED by Peak Torque (70+ Years of Muscle!)
Joe Kucinski
Corvette ZR1X Will Be Pacing the Indy 500, And Could Probably Race, Too!
Verdad Gallardo
Top 10 Corvettes Coming to Mecum Indy 2026!
Brett Foote
Top 10 C9 Corvette MUST-HAVES to Fix These C8 Generation Flaws!
Michael S. Palmer
10 Revolutionary 'Corvette Firsts' Most People Don't Know
Joe Kucinski
5 Reasons to Upgrade to an LS6-Powered Corvette; 5 Reasons to Stay LT2
Michael S. Palmer
2027 Corvette vs The World: Every C8 vs Its Closest Competitor
Joe Kucinski
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: 11
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.
