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.

control chart template 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:

short-run-template-tabs

2. There is 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:

xmr-short-run-template-tab

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.

example of short run data and targets  

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 control chart template in QI Macros  


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

NOTE: As of the July 2018 release, QI Macros now offers a Z-MR Chart option.

Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free