# PCBA AOI Defect Log and DPMO Worksheet

> Source: https://netray.co/tools/pcba-aoi-defect-log-dpmo-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable defect log that computes defects per million opportunities (DPMO) and defect rate for each lot or shift.

## Category

quality

## Industry

Electronics Manufacturing

## Audience

- Quality engineer
- SMT process engineer
- Production supervisor

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Lot / shift

**Key:** lot

**Type:** text

#### Date

**Key:** date

**Type:** date

#### Boards inspected

**Key:** boards

**Type:** number

#### Opportunities per board

**Key:** opps

**Type:** number

**Help:** Components plus solder joints plus placement checks, per your counting rule

#### Defects found

**Key:** defects

**Type:** number

#### Top defect

**Key:** top

**Type:** select

**Options:**

- Insufficient solder
- Bridging
- Tombstone
- Missing component
- Misalignment
- Wrong polarity
- Solder balls
- Lifted lead

#### DPMO

**Key:** dpmo

**Type:** number

**Expr:** if(gt(boards * opps, 0), defects / (boards * opps) * 1000000, 0)

**Format:** integer

#### Defects per board

**Key:** dpb

**Type:** number

**Expr:** if(gt(boards, 0), defects / boards, 0)

**Format:** decimal

#### Short-term sigma level

**Key:** sigma

**Type:** number

**Expr:** if(and(gt(boards * opps, 0), gt(defects, 0)), normsinv(1 - defects / (boards * opps)) + 1.5, 0)

**Format:** decimal

**Rows:**

**Lot:** WO-118201 Shift 1

**Date:** 2026-10-19

**Boards:** 250

**Opps:** 1420

**Defects:** 38

**Top:** Insufficient solder

**Lot:** WO-118202 Shift 1

**Date:** 2026-10-19

**Boards:** 300

**Opps:** 640

**Defects:** 11

**Top:** Tombstone

**Lot:** WO-118202 Shift 2

**Date:** 2026-10-19

**Boards:** 300

**Opps:** 640

**Defects:** 24

**Top:** Bridging

**Lot:** WO-118203 Shift 1

**Date:** 2026-10-20

**Boards:** 120

**Opps:** 2310

**Defects:** 61

**Top:** Misalignment

**Lot:** WO-118204 Shift 1

**Date:** 2026-10-20

**Boards:** 400

**Opps:** 640

**Defects:** 9

**Top:** Solder balls

**Totals:**

#### Total boards

**Key:** boards

**Agg:** sum

**Format:** integer

#### Total defects

**Key:** defects

**Agg:** sum

**Format:** integer

#### Worst DPMO

**Key:** dpmo

**Agg:** max

**Format:** integer

**Notes:** DPMO is defects divided by total opportunities, times one million. Agree on one counting rule for opportunities (for example IPC-9261 style: each component termination, each placement and each solder joint) and keep it fixed, otherwise comparisons between lines or customers are meaningless. The sigma column uses the common 1.5 sigma shift convention.

## Content

**Intro:** Raw defect counts are hard to compare across assemblies that have 300 or 3,000 solder joints. DPMO normalizes the count to a million opportunities so you can compare lots, shifts and products, and show a trend. This worksheet keeps the log and calculates it for you.

**Sections:**

#### How to use the log

**Body:** Enter one row per lot or shift. Add the number of boards inspected, the opportunities per board according to your counting rule, and the defects found at AOI or final inspection. Choose the dominant defect type so a Pareto of causes is easy to build later in Excel. The sheet returns DPMO, defects per board and a short-term sigma level for each row, plus totals for the log.

**Bullets:**

- Use the same inspection point for all rows (post-reflow AOI, for example).
- Count each defect once, not once per inspector.
- Do not drop lots with zero defects; they pull the average to its true value.
- Record false calls separately from true defects.

#### The formula and standard

**Body:** DPMO equals defects divided by boards times opportunities per board, times 1,000,000. IPC-7912 describes DPMO and related metrics for printed board assemblies, and IPC-9261 covers in-process DPMO and estimated yield. The sigma level here is the normal inverse of one minus the defect fraction plus the usual 1.5 sigma shift. It is a convenience figure for dashboards, not a capability study.

#### Reading the example

**Body:** WO-118201 shows 38 defects over 250 boards at 1,420 opportunities per board, about 107 DPMO. WO-118203 has fewer boards, but with 61 defects over 2,310 opportunities it lands near 220 DPMO and is the worst lot, with misalignment as the main cause. Shift 2 on WO-118202 is more than twice as bad as shift 1 for the same assembly, which points to a shift-dependent cause such as setup, material handling or paste age.

#### Common mistakes

**Body:** The biggest mistake is inconsistent opportunity counting, which makes DPMO look better or worse for no real reason. Another is mixing AOI false calls into defect counts, which inflates DPMO and teaches operators to ignore the data. Last, do not set a target without a baseline; collect several weeks of data first, then set DPMO goals by assembly family.

**Cta:** If your inspection results sit in AOI, MES or ERP systems, we can consolidate them into one on-prem view with trend and Pareto analysis.

**Faq:**

#### What is a good DPMO for SMT assembly?

**Answer:** It depends on the opportunity counting rule, the product complexity and the customer. Many high volume lines target well under 100 DPMO at final inspection, while complex boards with fine pitch and BGA may run higher. Trend and compare within your own rules.

#### How do I count opportunities?

**Answer:** A common rule is one opportunity per component placement plus one per solder termination, and sometimes per through-hole joint. Document the rule, apply it to every assembly and keep it stable. IPC-9261 gives a framework many EMS companies follow.

#### Why is sigma level shown with a 1.5 shift?

**Answer:** Six Sigma convention assumes the process mean drifts by 1.5 sigma over the long term, so a short-term sigma figure is reported with that adjustment. It is useful for quick comparison but should not replace a proper process capability study.

#### Should DPMO include rework?

**Answer:** Count defects found before rework, since that reflects the process. Final escapes after test belong in a separate metric. Mixing the two hides where defects actually arise.

## Search terms

dpmo calculator pcb assembly, aoi defect log template, smt defect tracking excel, defects per million opportunities electronics, pcba defect rate sheet, ipc-9261 dpmo, solder defect log, smt quality dashboard excel

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json