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.
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.
1. There is a Short Run Template which contains all of the short run spc charts. Click on Control Chart Templates, then Special (Cusum, EWMA) then Short Run Charts.
A template with several choices will open. Select the worksheet tab for the chart you want:
2. There is also a Short Run tab on each of these control chart templates:
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:
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 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
Why Choose QI Macros Over Other Control Chart Software?
- Only $299 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free