| QIS (Quality Information System) |
| There
are two important aspects to the collection of assembly and test data.
First, the data must be stored permanently in a secure place.
Second, and nearly as importantly, that data must be easily
accessible and presented in a clear format. Advanced Systems and
Controls has tools available to automatically build reports in Microsoft Excel from production databases.
The following are a sample of myriad possible reports available for
monitoring part quality and data trends. Click on a report below to see
an example in Microsoft Excel. |
 | Machine Data Report --
oftentimes, it's necessary to have a look at a large group of results
from a single machine. This report permits the analysis of test results
from a process. |
 | Part Report --
when a part can be tracked by a unique identifier (such as a printed
barcode, a pin-stamped serial number, or some other permanent tracking
identifier), then results from many machines can be combined into a
single 'birth history' report. This history can include the date and
time the part was processed at the station, all data from that station,
and pass / fail status. In addition, this report will show rejects,
failures, and rebuilds through line sections. This report is especially useful for tracking problems with individual parts. |
 | First Time Through
-- the percentage of acceptable assemblies versus all assemblies run
through a process can be monitored, and 'First Time Through' can help
to pick out the stations in a process that reject the most parts. The
station that has rejected the most parts through the process will be
displayed first. |