# Initial Process Study Cpk Worksheet for PPAP > Source: https://netray.co/tools/ppap-initial-process-study-cpk-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Summarise capability for each characteristic from mean, standard deviation and limits, and flag those below the PPAP acceptance target. ## Category quality ## Industry Automotive ## Audience - Supplier quality engineer - Quality engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Characteristic **Key:** char **Type:** text #### LSL **Key:** lsl **Type:** number #### USL **Key:** usl **Type:** number #### Mean **Key:** mean **Type:** number #### Std dev (sigma) **Key:** sigma **Type:** number #### Upper index **Key:** cpu **Type:** number **Expr:** (usl - mean) / (3 * sigma) **Format:** decimal #### Lower index **Key:** cpl **Type:** number **Expr:** (mean - lsl) / (3 * sigma) **Format:** decimal #### Cpk / Ppk **Key:** cpk **Type:** number **Expr:** min((usl - mean) / (3 * sigma), (mean - lsl) / (3 * sigma)) **Format:** decimal #### Meets 1.67 (1 = yes) **Key:** meets **Type:** number **Expr:** if(gte(min((usl - mean) / (3 * sigma), (mean - lsl) / (3 * sigma)), 1.67), 1, 0) **Format:** integer **Rows:** **Char:** Bore diameter (mm) **Lsl:** 22 **Usl:** 22.021 **Mean:** 22.0105 **Sigma:** 0.0018 **Char:** Overall length (mm) **Lsl:** 49.9 **Usl:** 50.1 **Mean:** 50.012 **Sigma:** 0.022 **Char:** Flange thickness (mm) **Lsl:** 5.9 **Usl:** 6.1 **Mean:** 6.004 **Sigma:** 0.025 **Char:** Surface Ra (um) **Lsl:** 0 **Usl:** 1.6 **Mean:** 0.82 **Sigma:** 0.14 **Summary:** #### Lowest Cpk in study **Key:** min_cpk_out **Expr:** min_cpk **Format:** decimal **Primary:** true #### Characteristics meeting 1.67 **Key:** passing_out **Expr:** sum_meets **Format:** integer #### Characteristics studied **Key:** total_out **Expr:** count **Format:** integer **Notes:** Enter sigma from your study: use overall (long term) sigma for Ppk and within-subgroup sigma for Cpk. For one-sided limits such as surface finish, set the unused limit so it cannot limit the index, or ignore the unused column. Capability targets come from your customer, not from this page. ## Content **Intro:** PPAP asks for initial process study results on characteristics the customer designates, usually special characteristics. This worksheet keeps the summary in one table: enter mean, standard deviation and limits and it calculates the capability indices and flags anything below 1.67. **Sections:** #### How to use it **Body:** Collect data from a significant production run, commonly at least 25 subgroups and 100 readings, from the production process with production tooling. Compute mean and standard deviation in your SPC tool and enter them with the specification limits. The sheet calculates the upper and lower indices as (USL minus mean) over 3 sigma and (mean minus LSL) over 3 sigma. The lower of the two is the Cpk or Ppk value reported. **Bullets:** - Use readings in time order from one stable run - Check the data is stable on a control chart first - Use within-subgroup sigma for Cpk - Use overall sigma for Ppk #### Acceptance targets **Body:** The AIAG PPAP manual's common guidance is that an index of 1.67 or higher is acceptable, between 1.33 and 1.67 may be acceptable with customer agreement, and below 1.33 needs corrective action and a 100 percent inspection plan until capability improves. Your customer's specific requirements win, and some use 1.33 for Cpk and 1.67 for Ppk. The sheet flags against 1.67, so read results in light of your own agreement. #### Reading the example **Body:** In the example the bore diameter has a mean close to the middle of a narrow tolerance and a small sigma, giving a high index. Length is centred in a wide band. Flange thickness has a lower index because sigma is larger relative to tolerance. Surface Ra is one-sided with the lower limit at zero, so the lower index here is not meaningful and the upper index drives the result. Replace all rows with your data. #### Common mistakes **Body:** Calculating capability on unstable data, mixing multiple cavities or machines in one study, and using a gage that is not capable are the usual errors. Check measurement system variation first, because gage noise inflates sigma. For non-normal characteristics such as flatness or position, use a method suitable for the distribution agreed with your customer. **Cta:** If your measurement data sits in an MES or an ERP inspection module, Netray can help build a read-only summary of capability by characteristic. **Faq:** #### What is the difference between Cpk and Ppk? **Answer:** Cpk uses within-subgroup variation and describes potential capability when the process is stable. Ppk uses overall variation including shifts and drift, so it describes actual performance in the study. Ppk is usually used for initial studies. #### Why does my one-sided characteristic show a strange lower index? **Answer:** Features like surface roughness have only an upper limit. The lower index uses an LSL of zero here, which is not a real requirement, so report only the upper index for these characteristics. #### How many parts do I need? **Answer:** A common PPAP expectation is at least 100 consecutive parts from a significant production run, but your customer may require more or use subgroup data. Follow the customer-specific requirement. #### Can this replace my SPC software? **Answer:** No. It summarises results you already calculated. Use SPC software for charts, normality tests and subgroup calculations, then use this sheet as a clean summary for the PPAP file. ## Search terms ppap cpk worksheet, initial process study template, cpk ppk summary excel, ppap capability study format, cpk 1.67 requirement, process capability worksheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json