Short Run Control Charts (DNOM)

Traditional SPC uses 20 or more data points to develop a control chart. So what do you do if you only produce three of this widget, then four of another, and then six of something else? The answer: Short Run SPC.

Short Run SPC (DNOM)

In short run SPC, we're making a few parts of different sizes, so we can't really use the actual measurements. Instead of evaluating the variation of each measurement, we use the variation of parts from a target value. These are also known as Deviation from Nominal (DNOM) charts.

So, if the first group of parts has a target value of 74mm, we measure each part and determine the variation from the target. If the next group of parts has a target value of 60mm, we measure those and determine their variation. Ideally, the variation from the target value will remain stable even though the parts vary in size.

Short Run SPC Templates for Excel

Since you're only doing a few parts at a time, it doesn't make sense to have a macro to handle short run SPC. So QI Macros provides templates for each type of short run chart. You can access these templates in one of two places under the Control Chart Templates tab on the QI Macros menu.

control charts on QI Macros menu

1. There is a Short Run Template which contains all of the short run spc charts. Click on Control Chart Templates, then Short Run Charts. Select the worksheet tab for the chart you want:


2. There is a Short Run tab on each of these control chart templates:

  • XmR Five Pack
  • XbarR Six Pack
  • c, p, u, and np attribute control charts

Click on one of the templates like the XmR Five Pack to open it. Then click on the tab title Short Run:



Input your target values and measurement values into the yellow cells. In the example below, you'll notice there are three parts at 74mm, five at 33.5mm, and seven at 22.5mm. QI Macros will calculate the difference between the target and your data.
Short Run SPC X Chart Template in QI Macros for Excel 

The "Difference" is used to create the short run chart. Even though the pieces vary in size, the variation from target is in control:
Short Run SPC X Chart in QI Macros for Excel 

I've only included the X chart, but the Range chart is also in control.

Short Run SPC isn't for everyone, but if your shop does a lot of small jobs, you might consider using short run charts to control the end product.

Short Run Control Charts in Excel with QI Macros

Learn More About Control Chart Template Options ...

Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!