Originally Posted by BDW
Excel spreadsheet


A. I made 2 big spreadsheets. One for disassembly and one for fasteners. Awesome.

Disassembly Spreadsheet - Two of the biggest advantages, but there are many others:
1. Enables finding any component in numbered storage boxes or numbered Ziplok bags quickly. For example, it enables you to quickly pick every big and small part that goes in the dash when that's your next assembly project.
2. Enables making a sort of every part by final finish. For example, every part that needs to be painted body color, every part that needs the same paint as the dash, to be chrome plated, polished, to be semi-gloss black dip painted, etc., so that you can put the correct final finish on each and every part that needs it all at the same time in one batch, nothing left out.

Fastener Spreadsheet - The really big advantage is it allows you to restore all fasteners of the same finish all at once in bulk and still be able to know where each one came from and where it belongs.

I found out the hard way that components need to be in closed up, numbered boxes due to a mouse that chewed up my pristine factory heater ducts and other things that were in unsealed boxes. The critter even ruined a paint job on a body part by chewing on the steel. Maybe you never heard that mice chew on steel? This one did.

B. Here are some smart ways to organize your spreadsheets for magical multiple sort levels of columns.
1. Make use of the chapter headings and page numbers in the factory service manual (FSM). For example, have a column headed "FSM Index", and on the row that lists the master cylinder, that column would say, "05-10 Master Cylinder", which appears in the FSM at chapter 05, page 10. Parts belonging to the master cylinder would also be coded the same way as "05-10 Master Cylinder". Or, omit the page numbers if you wish, but keep the chapter numbers. This is useful to find brake related parts in the spreadsheet quickly by simply looking for "05", or electrical parts by "08", for example.
2. Multiple level sort your spreadsheet simultaneously according to both a column for Car Area and another column for FSM Index to locate components. Such Car Areas could be named like these: Body, Engine Bay, Front, Interior-all, Interior-front, Interior-instrument panel, Interior-rear, Rear, Side, Trunk, and Under. So, for example, if you want to find out which box the master cylinder is in, scan the rows sorted to "Engine Bay" and next level sorted to "05". Just as there are only a few brake parts in the engine bay, there will be only a few rows in the spreadsheet that are both "Engine Bay" and "05", enabling you to quickly find the row with the master cylinder. On that row, under the column headed "Box Number", you would have listed that box number. Same for bag number, below.

C. Like nibbling an elephant with lots of little bites, it's relatively painless to grow a big spreadsheet of your whole car as you disassemble by using 3 x 5 cards and making photos. As you go about this job, write down the component names on 3 x 5 cards along with your disassembly notes, list of fasteners, and quick sketches as needed, and take lots of photos. Bring your daily stack of 3 x 5 cards to your computer and write a row in your spread sheet with the name of the component, say, "master cylinder" for example. Write a row in your spread sheet as follows: under the column for FSM Index, put "05" or “05-10”, under the column for Car Area, put "Engine Bay", under the column for Components, put "master cylinder", under the column for Final Finish, put "flat black" for example, under the column for Bag Number (see below) put that, and under the column for Box Number, put that. Later you can sort your spread sheet by Car Area and sub sort each Car Area by FSM Index for your main sort. But whenever you are ready to paint, polish, or plate with a certain finish, do a re-sort on every part by Final Finish to know every piece that has that one particular finish. Or do a re-sort by Box Numbers to know all the contents of each box. Also, sort your photos similarly by naming your photo "05-10 Master Cylinder" and put that photo in a file folder named "Engine Bay" that is inside another folder named "Disassembly Photos" or later, "Assembly Photos" when the time comes.

D. Three categories of small and big. In a quart sized Ziplok bag, store your numbered 3 x 5 cards (your component number or 3 x 5 card number, 1 up) along with small parts that fit, such as your new reproduction master cylinder lid and gasket. Store the bags in numerical sequence in copy paper box lids or similar trays. You can see your part or card numbers on the 3 x 5 cards inside the plastic bags. There is no need to have a separate number for every little part. For example, if the 3 x 5 card number for master cylinder is "161", use "161" for all parts that belong to the master cylinder, even if more than one Ziplok bag is needed for all the 161s. Simply make another 3 x 5 card numbered the 161 and stick it in the next bag. Now that I have finished disassembly, I keep my 300 Ziplok bags and fasteners in my home office, 75 boxes in the garage. Bulk store fasteners by finish such as phosphated and oiled or blue zinc plated or yellow zinc plated. I used AMKproducts.com web site for fastener photos, organization, and finish codes. Such bulk storage and bulk restoration of fasteners is possible only if you first enter the fastener attributes into a spreadsheet along with your 3 x 5 card number so that you know where each fastener that has those particular attributes belongs. Parts too big for a quart sized Ziplok bag, such as a master cylinder, are stored in a closed and numbered cardboard or other kind of box. Boxes can store either unrelated items together or related items together, because your spreadsheet tells which box. Long skinny parts can be stored in long skinny boxes, even if they are unrelated. Your spread sheet also lists your Ziplok bag numbers, which are the same as your card numbers. Later you may find it a good idea to re-do some of your disassembly boxes into assembly boxes, because the way things got boxed during disassembly might not quite fit the logic of restoration and re-assembly. You can number your boxes D1 up for disassembly and A1 up for assembly, for example. Parts too big to box, such as fenders or engine, can be kept wherever they fit, in the guest bedroom or garage. Fenders, wheels/tires, doors, hood and trunk store well up high on a garage wall or on the floor leaning against the wall. Maybe put the grille panel or tail panel in the breakfast room as wall art. Nice.


If you don't see two dolphins, you need a vacation.