An SPC (Statistical Process Control) Software customer recently inquired if I could discern any issues in a process, as their customer had identified problems with three recent shipments. They provided data for the customer’s current year shipments for a variety of KPI (key process indicators) in an Excel file. 

The Excel file provided 45 data values for each characteristic (KPI), with lot number, date, and occasional zero values where data records were missing. After opening the file in our software, I setup the following characteristic properties in one of the characteristics, then copied that to the other characteristics: