Cp/Cpk Capability Free Template

In process improvement efforts, the process capability index or process capability ratio is a statistical measure of process capability: the ability of a process to produce output within specification limits. The concept of process capability only holds meaning for processes that are in a state of statistical control.

Process capability indices measure how much “natural variation” a process experiences relative to its specification limits and allows different processes to be compared to how well an organization controls them.

This template will significantly support you in calculating Cp/Cpk for any metrics or process parameters. You just input the measured values, the tolerances and the formulas will automatically calculate all the Cp/Cpk values.

Main Features

  • 2 different templates :
    • calculation for a bilateral tolerance
    • calculation for a unilateral tolerance
  • Based on the measured values, the template automatically generates:
    • Cp/Cpk values
    • The mean
    • UCL/LCL values
    • Sample size
    • 2 visual graphs


This slideshow requires JavaScript.

Download link

To download this tool, click on the following link :


  • This tool is free
  • It can be modified by the user
  • Cannot be redistributed or sold


  • PC Excel 2016: OK
  • PC Excel 2013: OK
  • PC Excel 2010: OK
  • PC Excel 2007: OK
  • MAC – Excel 2016: OK
  • MAC – Excel 2011: not tested

Additional details

  • Language(s): English
  • Revision 2

If you like this tool, you will love:

Gantt Chart Maker: Our most popular tool for project managers. It will help you make awesome project schedules and meet your deadlines. It has more than 10 years in service and 150,000+ downloads. Try the free version first.


  1. Super!

  2. Thank you so much

  3. good help

  4. Best CpCpk template I found on the internet. Keep pushing!

  5. Thanks for the Cp & CpK software

  6. Thank you so much for this valuable example, great job.

  7. This CPK template is user friendly and very comprehensive!

  8. Thanks for sharing the Best Cp & Cpk Template and the Gantt Chart Maker!

  9. Thanks and it is useful

  10. Thank you so much. I appreciate this template, it is doing exactly what is expected and supports usage of statistical tools in my scope of work. Cheers from Malaysia

  11. Thanks, nice tool

Leave a Reply