# Special Characteristics Ppk Tracker Worksheet

> Source: https://netray.co/tools/special-characteristics-ppk-tracker-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

One row per special characteristic: enter limits, mean and standard deviation to see Pp, Ppk, PPM and the shortfall against 1.67.

## Category

quality

## Industry

Automotive

## Audience

- Supplier quality engineer
- APQP team leader
- Quality engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Characteristic

**Key:** char

**Type:** text

#### Class

**Key:** cls

**Type:** select

**Options:**

- Safety or regulatory
- Critical
- Significant
- Standard

#### USL

**Key:** usl

**Type:** number

#### LSL

**Key:** lsl

**Type:** number

#### Mean

**Key:** mean

**Type:** number

#### Overall std dev

**Key:** sd

**Type:** number

#### Pp

**Key:** pp

**Type:** number

**Expr:** (usl - lsl) / (6 * sd)

**Format:** decimal

#### Ppk

**Key:** ppk

**Type:** number

**Expr:** min(usl - mean, mean - lsl) / (3 * sd)

**Format:** decimal

#### Ppk minus 1.67

**Key:** gap

**Type:** number

**Expr:** min(usl - mean, mean - lsl) / (3 * sd) - 1.67

**Format:** decimal

#### Expected PPM

**Key:** ppm

**Type:** number

**Expr:** (normsdist((lsl - mean) / sd) + normsdist((mean - usl) / sd)) * 1000000

**Format:** integer

**Rows:**

**Char:** Bore diameter

**Cls:** Critical

**Usl:** 25.021

**Lsl:** 25

**Mean:** 25.0105

**Sd:** 0.0021

**Char:** Flange thickness

**Cls:** Significant

**Usl:** 6.2

**Lsl:** 5.8

**Mean:** 6.01

**Sd:** 0.045

**Char:** Hole position offset

**Cls:** Critical

**Usl:** 0.3

**Lsl:** -0.3

**Mean:** 0.02

**Sd:** 0.055

**Char:** Seal groove depth

**Cls:** Safety or regulatory

**Usl:** 3.3

**Lsl:** 3.1

**Mean:** 3.198

**Sd:** 0.016

**Char:** Overall length

**Cls:** Standard

**Usl:** 120.5

**Lsl:** 119.5

**Mean:** 120.02

**Sd:** 0.11

**Totals:**

#### Lowest Ppk

**Key:** ppk

**Agg:** min

**Format:** decimal

#### Highest expected PPM

**Key:** ppm

**Agg:** max

**Format:** integer

**Summary:**

#### Characteristics tracked

**Key:** n_chars

**Expr:** count

**Format:** integer

#### Weakest Ppk across characteristics

**Key:** worst

**Expr:** min_ppk

**Format:** decimal

**Primary:** true

**Notes:** Enter the overall standard deviation of all readings per characteristic. Rows with a negative gap column are below 1.67 and need an action plan or customer agreement. Use signed values for position or runout only if the customer accepts bilateral treatment; many treat them as one-sided.

## Content

**Intro:** A PPAP package for a part with many special characteristics needs one consolidated view of capability. This worksheet gives each characteristic a row, computes Pp, Ppk, PPM and the gap to 1.67, and flags the weakest one so you know where to spend effort first.

**Sections:**

#### How to use the worksheet

**Body:** Replace the example rows with your own characteristics from the control plan. For each, enter the specification limits, the mean and the overall standard deviation from the initial process study. Pp, Ppk, the gap to 1.67 and expected PPM calculate automatically. Add or remove rows as needed, sort in the exported Excel file, and attach the result to the PPAP package as a capability summary. Update the means and deviations after any process change and resubmit as needed.

#### What each column means

**Body:** Pp measures how the process spread compares to the tolerance without regard to centering. Ppk adds centering by using the nearer limit. The gap column subtracts 1.67 from Ppk, so a negative value is a shortfall against a common initial study target. Expected PPM uses the normal distribution to estimate the fraction outside both limits. Class is for your internal sorting; use the names your customer defines, since their symbols for special characteristics differ.

#### Using the summary

**Body:** The weakest Ppk is where the action plan starts. If several characteristics are below target, rank them by class first and then by gap. For marginal values, look at centering: a large difference between Pp and Ppk means moving the mean is the fastest improvement. For low Pp, the work is on variation, which usually means fixturing, tooling wear, material consistency or measurement error, and takes longer.

#### Common mistakes

**Body:** Entering subgroup standard deviation instead of overall deviation overstates Ppk. Using different units for limits and data silently ruins the numbers. Treating one-sided characteristics such as flatness as bilateral by giving them an LSL of zero produces misleading results, since the data are not normal near zero. Finally, copying means from a trial run on a different cavity or setup than the one submitted.

**Cta:** Netray can help feed inspection results from your ERP or MES into a tracker like this, so the capability summary is built from records, not re-keyed numbers.

**Faq:**

#### Can I export this for my PPAP package?

**Answer:** Yes. The worksheet exports to Excel, CSV and PDF. Attach it as a capability summary, and confirm the customer's required format before submission.

#### Why 1.67 as the gap reference?

**Answer:** 1.67 is a common initial study target for special characteristics. If your customer requires a different value, subtract it from Ppk yourself or edit the exported sheet.

#### What about one-sided specs?

**Answer:** For one-sided limits, use only the relevant index. Enter a far-away dummy limit on the open side only if you understand it will drive that side to a very large number, and then read Ppk accordingly.

#### Does this replace statistical software?

**Answer:** No. It is a fast summary for reporting. Use statistical software for normality tests, control charts and non-normal capability methods, and bring the results here.

## Search terms

special characteristics tracker, ppk tracker excel, ppap capability summary, key characteristics capability worksheet, ppk summary spreadsheet, control plan capability tracker, ppk gap to target, apqp characteristic capability

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json