# Wafer Probe Bin Yield Log Worksheet

> Source: https://netray.co/tools/wafer-probe-bin-yield-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable wafer sort log that totals bin counts per wafer and calculates probe yield and loss percentages, ready for Excel.

## Category

quality

## Industry

Semiconductors

## Audience

- Yield engineer
- Test engineer
- Product engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Lot

**Key:** lot

**Type:** text

#### Wafer #

**Key:** wafer

**Type:** text

#### Gross die

**Key:** gross

**Type:** number

#### Bin 1 pass

**Key:** bin1

**Type:** number

#### Bin 2 parametric fail

**Key:** bin2

**Type:** number

#### Bin 3 functional fail

**Key:** bin3

**Type:** number

#### Bin 4 contact/open-short

**Key:** bin4

**Type:** number

#### Die tested

**Key:** tested

**Type:** number

**Expr:** bin1 + bin2 + bin3 + bin4

#### Sort yield

**Key:** yield_pct

**Type:** number

**Expr:** bin1 / tested * 100

**Format:** percent

#### Functional fail loss

**Key:** loss_pct

**Type:** number

**Expr:** bin3 / tested * 100

**Format:** percent

#### Untested die

**Key:** untested

**Type:** number

**Expr:** max(gross - tested, 0)

**Rows:**

**Lot:** A24Q1187.1

**Wafer:** 01

**Gross:** 612

**Bin1:** 541

**Bin2:** 22

**Bin3:** 31

**Bin4:** 12

**Lot:** A24Q1187.1

**Wafer:** 02

**Gross:** 612

**Bin1:** 553

**Bin2:** 18

**Bin3:** 27

**Bin4:** 10

**Lot:** A24Q1187.1

**Wafer:** 03

**Gross:** 612

**Bin1:** 498

**Bin2:** 41

**Bin3:** 52

**Bin4:** 21

**Lot:** A24Q1187.1

**Wafer:** 04

**Gross:** 612

**Bin1:** 507

**Bin2:** 38

**Bin3:** 49

**Bin4:** 18

**Lot:** A24Q1188.2

**Wafer:** 01

**Gross:** 612

**Bin1:** 560

**Bin2:** 16

**Bin3:** 24

**Bin4:** 12

**Lot:** A24Q1188.2

**Wafer:** 02

**Gross:** 612

**Bin1:** 566

**Bin2:** 14

**Bin3:** 22

**Bin4:** 10

**Totals:**

#### Total gross die

**Key:** gross

**Agg:** sum

**Format:** integer

#### Total good die

**Key:** bin1

**Agg:** sum

**Format:** integer

#### Total die tested

**Key:** tested

**Agg:** sum

**Format:** integer

#### Average wafer sort yield

**Key:** yield_pct

**Agg:** avg

**Format:** percent

#### Worst wafer yield

**Key:** yield_pct

**Agg:** min

**Format:** percent

**Summary:**

#### Pooled sort yield

**Key:** lot_yield

**Expr:** sum_bin1 / sum_tested * 100

**Format:** percent

**Primary:** true

**Description:** Total good die divided by total die tested across all wafers.

#### Parametric fail share

**Key:** param_loss

**Expr:** sum_bin2 / sum_tested * 100

**Format:** percent

#### Functional fail share

**Key:** func_loss

**Expr:** sum_bin3 / sum_tested * 100

**Format:** percent

#### Contact fail share

**Key:** contact_loss

**Expr:** sum_bin4 / sum_tested * 100

**Format:** percent

**Notes:** Bin numbers differ by product and test program. Rename the columns to match your own bin table, and keep a bin 4 style contact or open-short bucket separate from device failures, since high contact failures usually point to probe card or test setup problems rather than fabrication.

## Content

**Intro:** Wafer sort produces a bin map for every wafer, and yield engineers constantly summarize those maps into lot and product trends. This worksheet turns bin counts into sort yield and loss shares you can export to Excel.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per wafer. Enter the gross die count from the wafer map and the number of die in each bin from the probe summary or datalog. Tested die, sort yield, functional fail loss and untested die are calculated automatically. The summary shows pooled yield across all rows and the share lost to each fail bin. Rename the bin columns to match your test program, delete the example rows, and export to Excel or CSV. Use the same layout for every lot so trend charts line up.

**Bullets:**

- One row per wafer
- Match bin names to your bin table
- Check untested die is near zero
- Export to CSV for trend charts

#### Sort yield formula

**Body:** Sort yield is good die divided by die tested, shown as a percentage. Some teams divide by gross die instead, which hides test coverage problems. This worksheet uses tested die in the denominator and shows untested die separately so that missing die are visible. Pooled yield adds counts across wafers before dividing, which is more accurate than averaging per-wafer percentages when wafers have different tested counts. The sheet shows both so you can see the difference.

#### Reading the loss buckets

**Body:** Each bin tells a different story. A rise in contact failures often follows a probe card change, worn needles or contamination on the pads. Parametric failures such as leakage or threshold voltage shifts trace to process drift and are often clustered on specific wafers. Functional failures can be random, caused by defects, or systematic, caused by a layer problem. Compare edge versus center on the bin map, and compare wafers within a lot. One bad wafer in a lot usually points to a single-wafer process such as a chamber step.

#### Common mistakes

**Body:** Do not mix retests and first-pass results in the same row without labeling them. Counting reprobe passes as first-pass inflates yield and hides contact problems. Keep the gross die count consistent with the product's reticle map, including partial edge die rules. Watch for mixed products in the same lot log. Finally, avoid comparing yield across test programs without confirming that the limits and bin definitions are the same.

**Cta:** If your sort data lives in test databases and your ERP holds lot and cost data, Netray can help you query both in plain language on your own servers.

**Faq:**

#### Is sort yield the same as final test yield?

**Answer:** No. Sort yield is measured at wafer probe on whole wafers. Final test yield is measured after packaging on individual units. Overall yield through the flow combines wafer sort, assembly and final test losses.

#### Should I divide by gross die or tested die?

**Answer:** Using tested die is common for sort yield, because it measures how many of the die actually tested were good. Track untested die separately so that missing data does not disappear from view.

#### How do I add more bins?

**Answer:** Add a column in your Excel export and extend the tested formula. Inside the tool, rename the four existing bin columns to the groups you track most, such as leakage, speed and memory test.

#### Can this be used for final test lots?

**Answer:** Yes. Replace wafer number with tray, reel or strip number and gross die with units tested. The bin and yield logic works the same way.

## Search terms

wafer probe yield log excel, wafer sort bin summary template, probe yield worksheet, bin map yield calculation, wafer test bin report, sort yield tracking spreadsheet, wafer acceptance yield log, bin loss pareto data

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