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

cp cpk template in Excel

There are Five Worksheets in the Template

  • Cp Cpk 8 Worksheet - for up to 8 Characteristics with 100 measurements each
  • Cp Cpk 35 Worksheet - for up to 35 Characteristics with 100 measurements each
  • Attribute Cp Cpk Worksheet for Go/No-go data - for pass/fail (binary) data where there are no measurements.
  • 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

To expand the template, follow these instructions.

You Can Try and Build Your Own Cp Cpk Calculations, But ...

  • It will suck up a bunch of your time.
  • You'll probably make mistakes and aggravate customers (based on our tech support calls, most people who try to perform manual calculations or build their own Excel formulas end up with incorrect results.)
  • You'll find your homegrown template hard to maintain.

Instead, Use Proven Software like QI Macros Add-in for Excel

  • QI Macros is an easy to use add-in for Excel that installs a new tab on Excel's tool-bar.
  • QI Macros calculations are tested and accurate.
  • QI Macros contains advanced features like one-sided spec limits.
cp cpk template on QI Macros menu


QI Macros can also draw histograms, control charts, Pareto charts and more.

If you're providing these results to your customers shouldn't you use a tool that's proven and affordable?

Why Choose QI Macros to Perform Capability Analysis and Draw Histograms?



  • Only $299 USD - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Calculates Cp Cpk Pp Ppk
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free