# PPAP Dimensional Results Worksheet > Source: https://netray.co/tools/dimensional-results-worksheet-ppap > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable dimensional results sheet with five measured values per characteristic and automatic conformance checks. ## Category quality ## Industry Automotive ## Audience - Quality engineer - Supplier quality engineer - CMM programmer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Char. no. **Key:** no **Type:** text #### Characteristic **Key:** desc **Type:** text #### Nominal **Key:** nominal **Type:** number #### Lower limit **Key:** lsl **Type:** number #### Upper limit **Key:** usl **Type:** number #### Sample 1 **Key:** m1 **Type:** number #### Sample 2 **Key:** m2 **Type:** number #### Sample 3 **Key:** m3 **Type:** number #### Sample 4 **Key:** m4 **Type:** number #### Sample 5 **Key:** m5 **Type:** number #### Average **Key:** avg **Type:** number **Expr:** (m1 + m2 + m3 + m4 + m5) / 5 **Format:** decimal #### Lowest **Key:** lowest **Type:** number **Expr:** min(min(m1, m2), min(min(m3, m4), m5)) **Format:** decimal #### Highest **Key:** highest **Type:** number **Expr:** max(max(m1, m2), max(max(m3, m4), m5)) **Format:** decimal #### Within limits (1 = yes) **Key:** ok **Type:** number **Expr:** if(and(gte(lowest, lsl), lte(highest, usl)), 1, 0) **Format:** integer **Rows:** **No:** 1 **Desc:** Overall length (mm) **Nominal:** 120 **Lsl:** 119.7 **Usl:** 120.3 **M1:** 120.04 **M2:** 119.98 **M3:** 120.11 **M4:** 120.02 **M5:** 119.95 **No:** 2 **Desc:** Hole diameter A (mm) **Nominal:** 10 **Lsl:** 9.98 **Usl:** 10.04 **M1:** 10.01 **M2:** 10.02 **M3:** 10 **M4:** 10.03 **M5:** 10.01 **No:** 3 **Desc:** Hole position to datum B (mm) **Nominal:** 35 **Lsl:** 34.9 **Usl:** 35.1 **M1:** 35.02 **M2:** 34.97 **M3:** 35.04 **M4:** 35.01 **M5:** 34.99 **No:** 4 **Desc:** Flange thickness (mm) **Nominal:** 4 **Lsl:** 3.9 **Usl:** 4.1 **M1:** 4.02 **M2:** 4.05 **M3:** 4.11 **M4:** 4.03 **M5:** 4.04 **No:** 5 **Desc:** Bend angle (deg) **Nominal:** 90 **Lsl:** 89 **Usl:** 91 **M1:** 90.2 **M2:** 89.8 **M3:** 90.4 **M4:** 90.1 **M5:** 90 **Totals:** #### Characteristics within limits **Key:** ok **Agg:** sum **Format:** integer **Summary:** #### Characteristics conforming **Key:** pass_rate **Expr:** sum_ok / count * 100 **Format:** percent **Primary:** true **Description:** Share of rows where all five samples are within limits. #### Characteristics listed **Key:** lines **Expr:** count **Format:** integer **Notes:** Use one row per ballooned characteristic and add rows until the whole drawing is covered. Many customers require measurements on a set number of pieces from different cavities or lines; extend the sample columns outside this sheet if needed. A zero in the last column flags a characteristic that needs investigation. ## Content **Intro:** Dimensional results are element 9 of PPAP. Every characteristic on the ballooned drawing must be measured on production parts, with actual values recorded against the tolerance. This worksheet records five measurements per characteristic and checks conformance for you. **Sections:** #### How to use it **Body:** Number each characteristic to match the ballooned drawing. Enter nominal and limits exactly as printed, including any unilateral tolerances. Enter measurements from parts built with production tooling, process and gauges, ideally spread across cavities, fixtures or lines. The sheet calculates average, lowest and highest per row, then flags whether all samples sit within limits. Export to Excel for the PPAP package. #### What good looks like **Body:** Every row should show 1 in the last column. In the example, the flange thickness has one sample at 4.11, above the 4.10 limit, so that row fails. That is exactly the kind of finding to resolve before warrant submission: adjust the process, confirm the measurement, or request a deviation. Attach capability studies for special characteristics, since a result that passes on five parts does not prove the process is capable. **Bullets:** - One row per ballooned characteristic - Values from production tooling and process - Units consistent with the drawing - Failed rows investigated before submission #### Measurement quality **Body:** Results are only as reliable as the gauge. Use calibrated equipment appropriate for the tolerance, with gauge repeatability and reproducibility studies on key characteristics. Record the gauge or CMM program ID in a separate column when the customer requires it. Take care with datum alignment on position characteristics, because a wrong setup can create false failures or false passes. #### Common mistakes **Body:** Missing characteristics, such as notes and reference dimensions that carry tolerances, mixing units, reporting average only, and measuring prototype parts. Another common error is to round away the failure, for example showing 4.11 as 4.1. Report the resolution the gauge supports, and keep raw data available in the PPAP file. **Cta:** Netray can discuss a private workflow that reads CMM or inspection exports and drafts the dimensional layout for engineer review. **Faq:** #### How many parts must be measured for PPAP dimensional results? **Answer:** It depends on the customer. Many ask for at least a handful of parts per cavity, line or tool, and some require thirty or more for capability. Check the customer specific requirements, and measure more when multiple cavities are present. #### Do I measure every dimension on the drawing? **Answer:** Yes, every characteristic in the design record, including notes and reference items with tolerances, unless the customer says otherwise. Each should be ballooned and cross referenced to the dimensional results and the control plan. #### What if a measurement is out of tolerance? **Answer:** Do not submit it as a pass. Fix the process, confirm the measurement, or ask the customer for a deviation or interim approval with a corrective action plan. Disclose it on the warrant explanation field. #### Does the worksheet calculate capability? **Answer:** No. It checks conformance for five samples per row. Capability studies, such as Ppk or Cpk, require many more samples and are submitted as initial process studies, element 11 of PPAP. ## Search terms ppap dimensional results template, dimensional results excel, ppap dimensional layout, ppap measurement results sheet, dimensional inspection report template, ppap ballooned drawing results, dimensional results ppap element 9, dimensional report template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json