Cp Cpk Calculator in Excel

Convert PPM to Cp Cpk or Convert Cp Cpk to PPM

Calculating Process Capability metrics or converting them to PPM can be tricky. That is why we created the Cp Cpk Calculator and Cp Cpk Template in Excel. These templates are part of the proven and affordable QI Macros SPC Software for Excel.

  • Use the Cp Cpk Template to calculate Cp Cpk and Pp Ppk for up to 35 data sets.
  • Use the PPM to Cp Cpk Calculator described on this page to convert from one set of metrics to the other.

Instructions for the PPM to Cp Cpk Converter

  1. Click on the QI Macros menu on Excel's toolbar and select Calculators. Then click on the DPMO | Yield | Cp/PPM | OEE.
    dpmo calculator
  2. The template has several tabs, select the tab labeled Cp-Cpk-PPM calculator.
  3. Input areas are shaded in yellow.
    • Enter parts per million above/below the USL/LSL in cells B2 and B3 to calculate Cp Cpk or
    • Enter Cp or Cpk in cells E2 and H2 to calculate PPM.

Cp Cpk Calculator Excel - QI Macros

Learn More...

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