PPAP Example in Excel: Dimensional Results and Capability
People searching for a PPAP example usually want to see what a finished submission looks like. This worksheet shows the dimensional results and initial process study portion with real calculations, so you can copy the structure into your own package.
| Characteristic | Nominal | Tol + | Tol - | Sample mean | Std deviation | USL | LSL | Ppk | Meets 1.67 (1=yes) | |
|---|---|---|---|---|---|---|---|---|---|---|
25.021 | 24.999 | 2.1176 | 1 | |||||||
120.15 | 119.85 | 1.7333 | 1 | |||||||
8.1 | 7.9 | 1.6296 | 0 | |||||||
6.05 | 5.95 | 1.9167 | 1 | |||||||
80.1 | 79.9 | 2 | 1 | |||||||
18.02 | 17.98 | 1.3333 | 0 |
Example data for a fictional steering bracket. Characteristics 3 and 6 fall below 1.67, which is where a customer would ask for a corrective plan, 100 percent inspection or a design or tolerance review. The PSW for this example would show: part number SB-48213, revision C, submission Level 3, reason Initial submission, and a declaration that all results meet requirements, except the listed open items.
Generate PPAP data from your inspection records
An optional review of drafting capability and dimensional reports from your existing quality data.
Optional. The tool and every export work without this. No spam.
How to use the example
Replace the six sample rows with your own characteristics from the ballooned drawing. Enter nominal, plus and minus tolerance, the sample mean and the standard deviation from your initial study. The sheet computes the specification limits, Ppk and a pass flag against 1.67. Export to Excel and paste the numbers into your own dimensional results and process study forms.
What customers look for
Reviewers cross-check the PSW, the control plan, the dimensional results and the capability study against each other. They look at every special characteristic first. A common acceptance guide for initial studies is Ppk of at least 1.67 for acceptance, between 1.33 and 1.67 for conditional acceptance, and below 1.33 as not acceptable, but your customer's own criteria take priority.
- Every ballooned characteristic appears in the results
- Same part number and revision on all documents
- Sample size and source are stated (often 30 or more consecutive parts)
- Gauge used matches the MSA study
- Out of tolerance results are explained, not hidden
What the PSW and annual items mean
The PSW is the one-page declaration that signs the package. Some people also ask what a PPAP report means in an annual context. PPAP is not an annual report: it is approved at launch and re-submitted on change. Many customers do however require annual layout inspection and re-validation, defined in the control plan and the customer-specific requirements. Keep those records as part of your quality system.
Frequently Asked Questions
What does PPAP report mean?
The PPAP report is the set of documents that show a supplier's production process can consistently make parts that meet all customer requirements. It includes the part submission warrant plus the supporting records for the submission level.
What is a good Ppk for PPAP?
A widely used guide for initial process studies is at least 1.67. Between 1.33 and 1.67 is often conditionally acceptable with a plan, and below 1.33 is not acceptable. Your customer sets the final criteria.
Why Ppk and not Cpk for the initial study?
The initial study uses a short run, so it reports performance index Ppk, which uses overall standard deviation. Cpk is used later for ongoing capability when the process is shown to be stable over time.
How many parts do I measure?
Typical practice is a significant production run of at least 300 consecutive pieces, from which at least 30 are used for the study, but the customer or control plan may specify otherwise. Always follow the stated requirement.
Netray can add an on-prem AI layer that pulls inspection and SPC data from your ERP or QMS and drafts this kind of report for engineer review.
Related Tools
PPAP Dimensional Results Worksheet
An editable dimensional results sheet with five measured values per characteristic and automatic conformance checks.
Quality & InspectionPPAP Initial Process Study Ppk Calculator
Enter spec limits, mean and overall standard deviation from your initial process study to get Pp, Ppk, expected PPM and the sigma reduction needed to hit your target.
Quality & InspectionPPAP Part Submission Warrant Template
A fill-in part submission warrant summary with part details, reason for submission, level and declaration, exported as PDF or Word.
Quality & InspectionPPAP Document Package Template
Build the cover sheet and index for your PPAP package, with all 18 elements, submit or retain guidance and a sign-off block.
Quality & InspectionPPAP 18 Elements Reference Table
Searchable table of the 18 PPAP elements, the evidence a customer expects for each, and the common reasons submissions get rejected.
More Quality & Inspection tools
See all- PPAP Submission Level Requirements Reference
- APQP Timing Plan Worksheet
- IATF 16949 Internal Audit Checklist
- Run at Rate Calculator
- Customer Specific Requirements Matrix Worksheet
- APQP Phase Gate Checklist
- PFMEA Worksheet with RPN for PPAP
- Production Control Plan Worksheet for PPAP
- Initial Process Study Cpk Worksheet
Keep exploring
Free tools
- PPAP Cost Calculator by Submission LevelEstimate what a PPAP will cost by submission level, from documentation labor and CMM layouts to capability studies and testing.
- PPAP Submission Level Requirements ReferenceA searchable table of the 18 PPAP elements and what is normally submitted or retained at each of the five submission levels.
- PPAP Checklist Excel Template with Submission LevelsEditable PPAP requirements checklist: all 18 AIAG elements, what to submit or retain at each level, and a status, owner and due date for every row.
Guides
- PPAP for Turned Parts Suppliers: What to Submit and How to Stay AheadPPAP for turned parts suppliers: the 18 elements, submission levels, Cpk studies, gauge R&R, control plans and how Swiss and screw machine shops stay ahead.
- PPAP for Die Casters and FoundriesWhat PPAP means for die casters and foundries: submission levels, control plans, PFMEA, dimensional layouts, material certs and how to keep records audit ready.
- PPAP and IATF 16949 for Metal Stampers: Elements, Levels and PaperworkPPAP levels, the 18 elements, control plans, capability studies and IATF 16949 expectations for stamping suppliers, plus how to keep the paperwork manageable.