 Quote:
Originally Posted by FMD159
Anyone done some similar planning with spreadsheets?
Maybe we can collectively create a template audit of most components for these cars which would be a great starting point for any restorer......if it hasn't already been done before...???
.basically similar to a complete "bill of materials" of the car that would need to have been created and checked off when the cars were first produced on the production line...if we could recreate or source something like this...that would be special!!   |
Ok here is what I did, and I will have to describe it in words as I am a MAC user and refuse to use any MS products when ever possible, so this might be tricky for the moment.
Basically down one axis I listed every single engine component that I required, highlighting mulitples were necessary (ie inlet valves or springs).
Now on the across axis I listed every single parts place that I planned to deal with and set up a subsection and macro to show contact and ph details. I grouped these suppliers as follows UK, QLD,NSW,VIC,SA, OTHER. Each supplier was colour coded, more on this later.
I should stress that I left provision on the down axis for parts that my mechanic suddenly decided that we should replace (ie Oil pump) or the part that arrived was wrong (i.e big end size) and on the across axis for new leads incase I had to find a new supplier for a specific part.
In the cells I set them up to include. Price inc GST, shipping cost an asterix and ref number denoted a choice where multiple brands were available for a specific part ie Borgo or Mondial pistons and liners. From memory I also had some coding for New, reconditioned or 2nd hand
It worked very well and because each supplier was colour coded after making my calls and getting quotes, I was able to look across each row and see the best price for each component. The best price was then highlighted in the colour of the correct supplier, so you could go across the sheet and see in one step. Then the calls were made and the parts got digitally cross off as they arrived and were approved.
I didn't get a lot of time to whip this up at work as my job as a Business Analyst keep me on my toes with deadlines and the usual stress, so I wanted to keep this as simple as possible. It worked well, I wanted to do another sheet where I group all parts by supplier and see if it would be easier to buy a part here in Brisbane like engine mounts that were say 60 AUD each as opposed to 55 AUD in Adelaide which may have been the best price but the weight would have killed on postage. I ended up just working this out visually and felt that it didn't warrant the time in setting it up.
My advice is spreadsheets are great but keep em simple. But an engine one was pretty straight forward as there as way less variables with a motor (less engineering) than body work. In anycase this was simply a components sheet, I imagine that doing one to manage time scales for work done and to be done will need a hell of a lot more planning and adhoc tweaking.
__________________
Phil
1961 MGA 1600 Roadster, British Racing Green
1966 Giulia Sprint GT ,Argento
1970 1750 GTV s2, Verde Olivo Metallica (AR213)
2005 Holden Rodeo LT Crew Cab, Fox Fire Red
{Oo==V==oO}
Previously owned
1983 Ford Laser KB, Beige
1985 Volvo 360 GLT Dark Mettalic Blue
1970 GT Junior stepnose Resprayed Red, Giallo Ochre
1923 Amilcar Sports, rusty
I may only own two ALFAs now, but the handle stays as I am always chasing another one.
Last edited by Threealfas; 07-05-2007 at 01:37 AM.
|