Cp Cpk Template for Excel

You Don't Have to be a Statistician to Calculate Cp and Cpk

Just Drop Your Data Into QI Macros Fill in the Blank Template

Input 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 35 characteristics and 100 measurements:

Here is an Example of the QI Macros Cp Cpk Template

Four Worksheets in the Template

  • Cp Cpk 8 Worksheet - 8 Characteristics and 100 measurements
  • Cp Cpk 35 Worksheet - 35 Characteristics and 100 measurements
  • Attribtue Cp Cpk Worksheet for Go/NoGo data - for when you don't have measurements, just pass/fail (binary) data.
  • Cp Cpk True Position - when there are two aspects to your measurement (e.g. horizontal and vertical for the position of a hole.)
  • MMC Cpk True Position - when you are measuring something like the inside and outside of a cylinder

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.

To open the template from the QI Macros menu, select Capability Templates, then Cp Cpk Templates.

Cp Cpk Template On QI Macros Menu

To expand the template, follow these instructions (Click Here).

See how it works! Add or paste data in yellow cells below...

Learn More ...

To create a Cp Cpk Template using QI Macros...
Try It Now!