Template Library
Process Capability Study Data Sheet
An Excel workbook that turns raw subgroup measurements into Cp, Cpk, Pp, Ppk, and Cpm automatically — with a live Dashboard, an embedded X-bar/R control chart, a distribution histogram, and estimated defect rates built in.
Enter your USL, LSL, and subgroup readings, and the workbook calculates short-term capability (Cp, Cpk, from sigma-within), long-term performance (Pp, Ppk, from sigma-overall), Cpm against a target value, and estimated short- and long-term defect rates in PPM — all summarized on a Dashboard tab with a plain-language interpretation and out-of-control flagging on the companion control chart.
Download Process Capability Study Data Sheet Back to Templates
What Is Included in the Workbook
| Sheet | Purpose | What Teams Capture |
|---|---|---|
| Dashboard | Live summary | Key indices (Cp, Cpk, Cpm, Pp, Ppk), overall Cpk rating, study details, subgroups collected, out-of-control point count, and estimated short-term defect rate |
| How-To | Method guidance and orientation | How the workbook is structured and when capability numbers can be trusted |
| Raw Data Collection | Subgroup data entry | USL, LSL, subgroup size, and subgroups of readings with automatic average and range |
| X-bar R Control Chart | Stability check | Embedded X-bar and R charts with CL/UCL/LCL lines and out-of-control flagging, so capability isn't trusted on an unstable process |
| Capability Calculations | Automatic index calculation | Sigma-within, sigma-overall, Cp, Cpu, Cpl, Cpk, Pp, Ppu, Ppl, Ppk, Cpm, estimated PPM defect rates, a distribution histogram, and a plain-language interpretation |
| d2 Constants Reference | Lookup table | d2 constants for subgroup sizes 2 through 10 |
How the Workbook Is Structured
The Raw Data Collection tab uses the same subgroup layout as the SPC / Control Chart Data Sheet, so a study already run for control-chart purposes needs no re-entry. The Capability Calculations tab pulls the grand average and R-bar from that data, looks up d2 automatically by subgroup size, and builds both the short-term (Cp/Cpk) and long-term (Pp/Ppk) index sets side by side.
Keeping both sets visible together is deliberate: comparing Cpk against Ppk is one of the fastest ways to spot a process that looks fine on average but drifted during the study window. A dedicated X-bar R Control Chart tab checks that assumption directly, flagging any subgroup that falls outside its control limits before the capability numbers are trusted.
Key Features Inside the Template
Live Dashboard
Cp, Cpk, Cpm, Pp, and Ppk, an overall rating, and an out-of-control point count summarized on one tab, formula-linked to the data.
Built-In Stability Check
An embedded X-bar/R control chart with out-of-control flagging, so capability isn't calculated on an unstable process by accident.
Cpm and Estimated Defect Rate
Cpm against a target value and estimated short- and long-term PPM defect rates round out the standard Cp/Cpk/Pp/Ppk set.
Distribution Histogram
A built-in histogram shows the actual shape of the data against the spec limits, not just the summary indices.
Automatic d2 Lookup
Sigma-within pulls the correct d2 constant automatically based on the subgroup size entered in the header.
Plain-Language Interpretation
A single cell reads out "Excellent," "Capable," "Marginally capable," or "Not capable" using standard Cpk thresholds.
Best Use Cases
- New process or product launches requiring a formal capability study
- Confirming capability after a corrective action or process change
- Customer or internal requests for Cpk/Ppk on a specific characteristic
- Comparing short-term setup capability against sustained long-term performance
How to Use the Template Effectively
- Confirm the process is in statistical control before running the study — a capability index on an unstable process is not meaningful.
- Enter the real USL and LSL, not a target value.
- Collect at least 20-25 subgroups spanning normal production conditions, not just a best-case setup run.
- Compare Cpk against Ppk. A large gap points to special-cause variation within the study period worth investigating.
- Re-run the study after any meaningful process change rather than assuming the old numbers still apply.
Who Should Use This Template
- Quality engineers running a first-article or launch capability study
- Process engineers confirming capability after a corrective action
- APQP and PPAP teams documenting customer-facing capability results
Common Mistakes to Avoid
- Running a capability study before confirming the process is stable
- Using a target value instead of the actual specification limits
- Reporting Cpk alone without checking whether Ppk tells a different story
Example Filled-Out Case
Example: A CNC bore-machining cell runs subgroups against a 25.000mm ± 0.030mm specification. The workbook calculates Cpk = 1.21 from sigma-within, adequate at setup, while Ppk from sigma-overall comes in lower — the gap traced in the Process Capability guide to a tool-wear special cause partway through the shift.
Related Guides and Tools
Read the Process Capability Guide
The full Cp/Cpk/Pp/Ppk formula set and a hand-worked example behind this template.
Use the Process Capability Analyzer
Run the same calculations interactively in the browser without downloading a file.
Use the SPC / Control Chart Data Sheet
Confirm the process is in statistical control before trusting the capability numbers here.
Read the SPC & Control Charts Guide
Verify stability first — capability on an out-of-control process isn't meaningful.
Process Capability Study Data Sheet Frequently Asked Questions
Do I need to confirm the process is stable before running this study?
Yes. Capability indices calculated on an out-of-control process aren't meaningful, since they assume the variation observed is representative of ongoing performance. Confirm stability with a control chart first, such as the companion SPC / Control Chart Data Sheet.
What is the difference between Cpk and Ppk in this workbook?
Cpk uses sigma-within (from R-bar and the d2 constant), a short-term estimate of variation. Ppk uses sigma-overall (the sample standard deviation of every individual reading), a long-term estimate. A Cpk noticeably higher than Ppk usually signals a shift or drift within the study period.
What Cpk is generally considered capable?
1.33 is a common minimum threshold for an established process, and 1.67 or higher is often required for safety or critical characteristics. The workbook's interpretation cell uses 1.33 as the capable threshold and 1.0 as the marginal threshold.
Can I reuse data from the SPC / Control Chart Data Sheet?
Yes. Both templates use the same subgroup, 5-reading structure, so a control chart study already collected is ready to paste directly into this workbook's Raw Data Collection tab.