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.
The XbarR template has several tabs. Click on XbarR Real time
Here's how the real time spc template works:
- 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
- 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

Twenty points parsed into 2 columns

Subgroup size 5
Twenty points parsed into 5 columns

Twenty points parsed into 5 columns

- As data is input and then parsed by subgroup, the charts are automatically populated to the right.
Why Choose QI Macros Over Other Control Chart Software?
Fast and Easy to Use
- Works right in Excel
- Create charts in seconds
- Easy to customize & share charts
- Free Training Anytime
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free
Affordable
- Only $349 USD
Quantity Discounts Available - No annual subscription fees
- Free technical support