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

Screenshots

This slideshow requires JavaScript.

Download link

To download this tool, click on the following link :

License

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

Compatibility

  • 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
  • 12872 Downloads

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.

Comments

  1. Super!
    Thanks!

  2. Thank you so much

  3. good help

Leave a Reply