Real Time SPC Template for Excel

XbarR chart Six Pack performs analysis as data is imported

This Real Time SPC template for Excel, parses your data into subgroups and automatically performs statistical analysis. It creates control charts, histograms and calculates Cp and Cpk.

This template is part of QI Macros SPC Addin for Excel.

QI Macros adds a new tab to Excel's toolbar. To open the template, click on QI Macros, Control Chart templates > Variable (XmR, XbarR/S) > XbarR Six Pack.

variable control chart templates on menu

The XbarR template has several tabs. Click on XbarR Real time

Here's how the real time spc template works:

  1. All input areas are shaded in yellow.
    • Cell A1 defines the number of samples per subgroup.
    • Column B is where you input your data (either manually or via a USB or RS 232 gage interface.
    • Input spec limits for your histogram in cells AX1 and AX2
  2. As data is input into column B, it is parsed by subgroup based on the value in cell A1. Here are two examples:
Subgroup size 2
Twenty points parsed into 2 columns

subgroup size 2 example
Subgroup size 5
Twenty points parsed into 5 columns

subgroup size 5 example
  1. As data is input and then parsed by subgroup, the charts are automatically populated to the right.

real time spc charts

Learn more about control chart template options.

Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $299 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

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free