# Crimp Pull Force and Crimp Height Test Log Worksheet > Source: https://netray.co/tools/crimp-pull-force-and-height-test-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log pull force and crimp height by applicator and terminal, compare with your limits, and see pass or fail, margin and first pass yield. ## Category quality ## Industry Wire Harness & Cable Assembly ## Audience - Quality technician - Process engineer - Operator ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Date **Key:** date **Type:** date #### Harness / part **Key:** pn **Type:** text #### Terminal PN **Key:** term **Type:** text #### Wire **Key:** awg **Type:** select **Options:** - 16 AWG - 18 AWG - 20 AWG - 22 AWG - 24 AWG - 26 AWG - Other #### Applicator / press ID **Key:** tool **Type:** text #### Operator **Key:** op **Type:** text #### Pull force **Key:** pull **Type:** number **Unit:** lbf #### Minimum pull **Key:** pull_min **Type:** number **Unit:** lbf #### Crimp height **Key:** ht **Type:** number **Unit:** mm #### Height min **Key:** ht_min **Type:** number **Unit:** mm #### Height max **Key:** ht_max **Type:** number **Unit:** mm #### Pull margin over minimum **Key:** margin **Type:** number **Expr:** pull - pull_min **Format:** decimal **Unit:** lbf #### Pass (1) / Fail (0) **Key:** ok **Type:** number **Expr:** if(and(gte(pull, pull_min), and(gte(ht, ht_min), lte(ht, ht_max))), 1, 0) **Format:** integer **Rows:** #### T-2201 **Date:** 2026-10-19 **Pn:** WH-2210-A **Awg:** 22 AWG **Tool:** APP-07 **Op:** JL **Pull:** 14.2 **Pull min:** 8 **Ht:** 0.82 **Ht min:** 0.78 **Ht max:** 0.86 #### T-2201 **Date:** 2026-10-19 **Pn:** WH-2210-A **Awg:** 22 AWG **Tool:** APP-07 **Op:** JL **Pull:** 13.5 **Pull min:** 8 **Ht:** 0.84 **Ht min:** 0.78 **Ht max:** 0.86 #### T-2204 **Date:** 2026-10-19 **Pn:** WH-2210-A **Awg:** 20 AWG **Tool:** APP-11 **Op:** MK **Pull:** 18.9 **Pull min:** 11 **Ht:** 0.95 **Ht min:** 0.9 **Ht max:** 0.98 #### T-2204 **Date:** 2026-10-19 **Pn:** WH-2210-A **Awg:** 20 AWG **Tool:** APP-11 **Op:** MK **Pull:** 9.8 **Pull min:** 11 **Ht:** 0.99 **Ht min:** 0.9 **Ht max:** 0.98 #### T-3110 **Date:** 2026-10-20 **Pn:** WH-3105-B **Awg:** 18 AWG **Tool:** APP-03 **Op:** JL **Pull:** 26.4 **Pull min:** 16 **Ht:** 1.12 **Ht min:** 1.08 **Ht max:** 1.16 #### T-3110 **Date:** 2026-10-20 **Pn:** WH-3105-B **Awg:** 18 AWG **Tool:** APP-03 **Op:** JL **Pull:** 25.1 **Pull min:** 16 **Ht:** 1.13 **Ht min:** 1.08 **Ht max:** 1.16 **Totals:** #### Passing samples **Key:** ok **Agg:** sum **Format:** integer #### Average pull force **Key:** pull **Agg:** avg **Format:** decimal #### Lowest pull margin **Key:** margin **Agg:** min **Format:** decimal **Summary:** #### First pass yield **Key:** fpy **Expr:** sum_ok / count * 100 **Format:** percent #### Failing samples **Key:** fails **Expr:** count - sum_ok **Format:** integer **Notes:** Minimum pull force and crimp height limits in the example rows are illustrative. Take the limits from your terminal manufacturer's application specification and your customer or IPC/WHMA-A-620 requirements. A sample passes only when pull force is at or above the minimum and crimp height is within the min and max limits. Record the applicator ID so a failing sample can be traced to a tool. ## Content **Intro:** Crimp quality is verified by two quick measurements that every harness shop already makes: crimp height with a micrometer and pull force with a force gauge. This log records both against your limits, flags failures and tracks first pass yield by day. **Sections:** #### How to use the log **Body:** At setup, after an applicator change, and at the sampling interval defined in your control plan, crimp a sample, measure height, then pull test it and enter the readings. Enter the limits from the terminal supplier application specification. The sheet calculates the margin of pull over the minimum and a pass or fail flag. The summary shows first pass yield and the number of failures so a trend is visible at a glance. **Bullets:** - Log the applicator or press ID on every row - Record every setup and changeover sample, not only passing ones - Enter limits from the terminal application specification - Hold material from a failing sample until the cause is understood #### What the checks tell you **Body:** Crimp height reflects how well the crimp barrel was compressed, and a height outside the supplier window signals wrong applicator setup, wrong wire gauge or wear. Pull force tests the mechanical strength of the connection, and a value near the minimum, even if passing, warns that the process may be drifting. Neither check replaces cross-section analysis when it is required for a qualification, but together they catch most day-to-day process drift. #### Reading the summary **Body:** First pass yield equals passing samples divided by samples taken. A single failure out of six is a 17 percent drop, so look at the failure rows rather than the percentage. Watch the lowest pull margin: a shrinking margin over several samples often precedes failures, for example from worn crimp dies or wire strand damage during stripping. Sort or filter by applicator ID in Excel to separate tool problems from operator or material problems. #### Common mistakes **Body:** Using one minimum pull value for all gauges instead of the value for that wire and terminal combination. Measuring crimp height at the wrong location or with a micrometer without crimp anvils. Pulling too fast, which changes the reading. Recording only the passing samples. Not recalibrating the force gauge and micrometer on schedule, which makes the whole log unreliable. **Cta:** If crimp and pull data are captured on paper or in standalone files, we can talk through bringing them into your MES or quality system so process drift shows up automatically. **Faq:** #### Where do I get the minimum pull force? **Answer:** Use the terminal manufacturer's application specification for that terminal and wire combination, and any stricter requirement from your customer or the workmanship standard. Do not use a single value for every gauge. #### How often should I pull test crimps? **Answer:** Follow your control plan. Common practice is at setup, after applicator or wire changes, at shift start, and at intervals during a run. Higher classes and critical circuits justify more frequent sampling. #### What if the height passes but the pull fails? **Answer:** Treat it as a failure. Check wire strand damage, wire gauge, insulation position and terminal lot. Height alone does not prove the strands are properly captured, so investigate before continuing production. #### Can I export this log for audits? **Answer:** Yes. Export to Excel or PDF and store it with the work order or lot record. Keep calibration records for the gauges used with the log. ## Search terms crimp pull test log, crimp height log excel, terminal pull force test record, crimp quality inspection log, wire harness crimp verification, applicator setup log, crimp pull test spreadsheet, ipc whma a 620 crimp record --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json