Template Library
Process Capability Study Data Sheet
An Excel workbook that turns 25 subgroups of raw measurements into Cp, Cpk, Pp, and Ppk automatically — with sigma-within, sigma-overall, and the d2 constant table built in.
Enter your USL, LSL, and subgroup readings, and the workbook calculates both the short-term capability (Cp, Cpk, from sigma-within) and the long-term performance (Pp, Ppk, from sigma-overall) automatically, along with a plain-language capable / marginal / not capable interpretation.
Download Process Capability Study Data Sheet Back to Templates
What Is Included in the Workbook
| Sheet | Purpose | What Teams Capture |
|---|---|---|
| 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 25 subgroups of up to 5 readings with automatic average and range |
| Capability Calculations | Automatic index calculation | Sigma-within, sigma-overall, Cp, Cpu, Cpl, Cpk, Pp, Ppu, Ppl, Ppk, 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.
Key Features Inside the Template
Short-Term and Long-Term, Side by Side
Cp/Cpk (sigma-within) and Pp/Ppk (sigma-overall) calculate together, making a Cpk-vs-Ppk gap immediately visible.
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 "Capable," "Marginally capable," or "Not capable" using the common 1.33 / 1.0 thresholds.
Shares Data With the SPC Template
Uses the identical 25-subgroup, 5-reading layout as the SPC / Control Chart Data Sheet for direct reuse.
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 25 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 25-subgroup, 5-reading structure, so a control chart study already collected is ready to paste directly into this workbook's Raw Data Collection tab.