feb 192013
 

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)

JaguarApplication1

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

JaguarApplication2

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.

MissingHaveCleanedFinishedMountedTotal
Unknown000000
Rubber194104781323
Bearing207601145269
Painted Steel97923897189513
Washer131611521112161706
Nut5497379136774
Bolt969499951961318
Pin61039653213
Chrome623727134143
Fabric1060000106
Glass 10013115
Other9608821831711323
Gasket660051384
Clip1440131920196
Wiring Electrics2814019162
Screw2860019296
Total504630516668911357341

 Posted by at 20:24