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.

To use this template:

Click on the QI Macros menu and select Control Chart templates and then XbarR Six Pack.
Select the tab labeled XbarR Realtime.
Click on Cell A1 and enter the number of samples per subgroup. If you have a USL and LSL, enter it in cells AM3 and AM5.
Clear contents of cells B2:B21
Click on Cell B2 and start entering data. You can type this manually or use a gage interface (USB or RS232)
As you add new data your charts and calculations will update automatically.
You can add more rows by copying cells C21:L21 down to row 22 and beyond.