# PPAP Example in Excel: Dimensional Results and Capability > Source: https://netray.co/tools/ppap-example-submission-excel-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A worked PPAP dimensional results and capability example. Edit the numbers to see limits, Ppk and pass or fail flags update, then export to Excel. ## Category quality ## Industry Automotive ## Audience - Supplier quality engineer - Quality engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Characteristic **Key:** char **Type:** text #### Nominal **Key:** nom **Type:** number **Format:** decimal #### Tol + **Key:** tolp **Type:** number **Format:** decimal #### Tol - **Key:** tolm **Type:** number **Format:** decimal #### Sample mean **Key:** avg **Type:** number **Format:** decimal #### Std deviation **Key:** sd **Type:** number **Format:** decimal #### USL **Key:** usl **Type:** number **Expr:** nom + tolp **Format:** decimal #### LSL **Key:** lsl **Type:** number **Expr:** nom - tolm **Format:** decimal #### Ppk **Key:** ppk **Type:** number **Expr:** min(usl - avg, avg - lsl) / (3 * sd) **Format:** decimal #### Meets 1.67 (1=yes) **Key:** ok **Type:** number **Expr:** if(gte(ppk, 1.67), 1, 0) **Format:** integer **Rows:** **Char:** 1 Bore diameter (special) **Nom:** 25.01 **Tolp:** 0.011 **Tolm:** 0.011 **Avg:** 25.0102 **Sd:** 0.0017 **Char:** 2 Overall length **Nom:** 120 **Tolp:** 0.15 **Tolm:** 0.15 **Avg:** 120.02 **Sd:** 0.025 **Char:** 3 Flange thickness **Nom:** 8 **Tolp:** 0.1 **Tolm:** 0.1 **Avg:** 8.012 **Sd:** 0.018 **Char:** 4 Slot width **Nom:** 6 **Tolp:** 0.05 **Tolm:** 0.05 **Avg:** 6.004 **Sd:** 0.008 **Char:** 5 Mounting hole spacing **Nom:** 80 **Tolp:** 0.1 **Tolm:** 0.1 **Avg:** 79.99 **Sd:** 0.015 **Char:** 6 Shaft outside diameter **Nom:** 18 **Tolp:** 0.02 **Tolm:** 0.02 **Avg:** 18.004 **Sd:** 0.004 **Totals:** #### Lowest Ppk **Key:** ppk **Agg:** min **Format:** decimal #### Characteristics meeting target **Key:** ok **Agg:** sum **Format:** integer **Summary:** #### Share meeting Ppk 1.67 **Key:** pass_rate **Expr:** sum_ok / count * 100 **Format:** percent **Primary:** true **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the example **Body:** 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 **Body:** 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. **Bullets:** - 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 **Body:** 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. **Cta:** 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. **Faq:** #### What does PPAP report mean? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms ppap example excel, psw ppap example, ppap report example, ppap report meaning, ppap dimensional results example, ppap automotive annual report, ppap ppk example, ppap sample report --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json