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 work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

What's Cool about the QI Macros Cp Cpk Template for Excel?

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:

Here is an Example of the QI Macros Cp Cpk Template

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. See the formulas used for Cp, Cpk.

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

Other Resources

Cp Cpk Dashboard which automatically creates control charts , histograms and probability plots from your data.

Histograms in Excel with Cp, Cpk and Pp, Ppk

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

It's easy to calculate Cp & Cpk using this QI Macros template.

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!