Part Administration Software

Because it is almost impossible to keep track of all different parts by head, I developed a software application. This application can keep track all parts(currently 7341 separate pieces), needed to rebuild the Jaguar XK140 FHC. All these parts are taken from the “Jaguar Spare Parts Catalogue”.
For each individual part I store the following specific information:

• Group (The car is divided into 15 groups)
• Part (Each group is divided in several parts, for the whole car 139)
• Item (Specific components, for the whole car 2565)
• Number (Number as used by the jaguar part manuals)
• Reference (Identification to a specific location on a picture)
• Remark (Room for temporary or permanent notes)
• Picture (Exploded view of a part, which shows all items available in this part)
• Count (How many items of this type are in this part)
• State (State of this item; Missing, Have, Cleaned, Finished, Mounted)
• Material (Basis material of the item; Rubber, Bearing, Painted steel,  Washer, Nut, Bolt, Pin, Chrome, Fabric, Glass, Other, Gasket, Clip, Wiring electrics and Screw)
• Price (Value for a specific item)
• Weight factor (Small parts receive 1 and bigger parts for example 50, used for progress calculation)

A lot of parts can be found on one of the 36 available exploded views.

Exploded view of the rack and pinion housing

With the help of the filter, sort and report functionality it is very easy to;

• Select parts based on (Group, Part, Item, Number, Count, Reference or Remark)
• Sort all selected parts on  (Group, Part, Item, Number, Count, Reference or Remark)
• Reduce all Selected parts based on (State or Material)
• Write the selected parts to a report file

In the report file there is also a overview of the current progress , an example is shown in the table below.