Cp Cpk True Position Template for Excel

What is True Position?

If you are drilling a hole which has an X and Y location, you have to be able to measure Cp and Cpk for both the X and Y dimensions as well as the overall location of the hole:

Cp Cpk True Dimension Diagram

QI Macros Add-in for Excel Contains and Easy to Use Template to Calculate Cp Cpk

  1. Open the template using the menu QI Macros installs on your Excel toolbar.
    capability menu
  2. Input your target and tolerances for X and Y coordinates and allowable offset.
    The target for the offset (D4:E4) is usually zero
    Cp Cpk True Position Tolerances
  3. Enter actual measurements as shown.
  4. Evaluate Cp and Cpk for the X and Y location as well as the Cpk for the True Position:
    Cp Cpk True Position Results
  5. Also review the true position chart for any patterns.
    True Position Chart

Note: Tolerance is 1/2 the diameter of allowable true position. There is no LSL.


Maximum Material Condition Cpk

If you have a cylinder with an inside and an outside diameter, you can determine Cpk using the MMC template. The X and Y offsets are optional. You just need measurements of the outside and inside diameters to calculate Cpk (N4).

True Position Maximum Material Condition (MMC) Cpk

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



  • Only $279 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