- The customer returned a part because it had malfunctioned.
- The part has a number engraved.
- The customer requested report (numbers) for the part.
- QC people want all the numbers for all parts produced that week.
- The part was made several months ago.
- You had better days.
For this we need part serialization. This means that each part ever made has to have a unique number assigned to it. In our case the engraved number is in the following format:
- nnnn = part number for the day
- ddd = Julian day
- yy = last two digits of the year
- s = shift
The Excel program has a ‘Decode Engraving’ feature, which is actually a database search by an engraved number. We type the number into the form. As we type the number is decoded into year, month, day, etc.Based on this a file name which contains the part data is constructed.
By clicking on the file name the file is opened and the particular part data is displayed in the ‘Form View’. This can now be printed, faxed or e-mailed.
File names are coded as MachineNo_yyyy_mm_dd.txt where:
- MachineNo = machine number
- yyyy = year
- mm = month
- dd = day
- .txt = file format is a plain text file
From this and the calendar we can find all the files that QC people need.