Cp Cpk Template for Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2008

It's easy to calculate Cp Cpk and analyze process capability using our Cp Cpk template.

Just enter your target value, tolerances and measurements in the yellow shaded areas. The worksheet will automatically calculate Cp, Cpk, Pp, and Ppk. It has space for up to eight characteristics and 100 measurements:

One Sided Spec Limits
If you need to perform a one tailed capability analysis, just delete the formula in either the USL or LSL field.

Cp and Cpk Calculations
While most people try to calculate Cp as the upper spec limit minus the lower spec limit divided by six times the standard deviation:

Cp = (USL-LSL)/6*Stdev

this is actually the formula for process performance (Pp).

The template uses the correct formula which estimates the standard deviation from the average of the ranges divided by a constant (Rbar/d2).

Cp = (USL-LSL)/6*Rbar/d2

The same is true for Cpk. To see the formulas used for Cp, Cpk click here.

To open the template from the QI Macros pull down menu, select Fill in the Blank Templates, SPC Charts, Cp Cpk Worksheet.

You can also calculate Cp, Cpk, Pk, Ppk and other metrics using the Histogram macro in the QI Macros for Excel.

The Cp, Cpk template is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
FREE
30-Day Trial

Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee