# Laser Module Final Test Data Worksheet

> Source: https://netray.co/tools/laser-module-final-test-data-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable test log by serial number with output power, limits, efficiency and automatic pass or fail, exportable to Excel.

## Category

quality

## Industry

Photonics

## Audience

- Test engineer
- Production supervisor
- Quality engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Serial number

**Key:** serial

**Type:** text

#### Test date

**Key:** date

**Type:** date

#### Drive current (A)

**Key:** current

**Type:** number

**Format:** decimal

#### Voltage (V)

**Key:** voltage

**Type:** number

**Format:** decimal

#### Optical power (W)

**Key:** power

**Type:** number

**Format:** decimal

#### Min power (W)

**Key:** min_p

**Type:** number

**Format:** decimal

#### Max power (W)

**Key:** max_p

**Type:** number

**Format:** decimal

#### Wall-plug efficiency (%)

**Key:** wpe

**Type:** number

**Expr:** power / max(current * voltage, 0.0001) * 100

**Format:** percent

#### Pass (1=yes)

**Key:** pass

**Type:** number

**Expr:** if(and(gte(power, min_p), lte(power, max_p)), 1, 0)

**Format:** integer

#### Tester

**Key:** tester

**Type:** text

**Rows:**

**Serial:** SN-000271

**Date:** 2026-10-20

**Current:** 12

**Voltage:** 1.9

**Power:** 10.4

**Min p:** 9.5

**Max p:** 11.5

**Tester:** RK

**Serial:** SN-000272

**Date:** 2026-10-20

**Current:** 12

**Voltage:** 1.92

**Power:** 9.1

**Min p:** 9.5

**Max p:** 11.5

**Tester:** RK

**Serial:** SN-000273

**Date:** 2026-10-20

**Current:** 12

**Voltage:** 1.88

**Power:** 10.9

**Min p:** 9.5

**Max p:** 11.5

**Tester:** SP

**Serial:** SN-000274

**Date:** 2026-10-21

**Current:** 12

**Voltage:** 1.91

**Power:** 11.8

**Min p:** 9.5

**Max p:** 11.5

**Tester:** SP

**Serial:** SN-000275

**Date:** 2026-10-21

**Current:** 12

**Voltage:** 1.9

**Power:** 10.2

**Min p:** 9.5

**Max p:** 11.5

**Tester:** RK

**Totals:**

#### Units passing

**Key:** pass

**Agg:** sum

**Format:** integer

#### Average wall-plug efficiency

**Key:** wpe

**Agg:** avg

**Format:** percent

**Summary:**

#### First pass yield

**Key:** fpy

**Expr:** sum_pass / max(count, 1) * 100

**Format:** percent

**Notes:** Wall-plug efficiency is optical output power divided by electrical input power (current times voltage). Adapt columns to your module, for example wavelength, beam quality or thermal data.

## Content

**Intro:** Laser and optical modules are usually tested one serial number at a time against a power window. This worksheet logs the test, computes efficiency and shows pass or fail so first pass yield is visible at a glance.

**Sections:**

#### How to use the worksheet

**Body:** Enter each unit with drive current, voltage and measured optical power, together with the minimum and maximum power from the product specification. The sheet computes wall-plug efficiency and a pass flag. The summary calculates first pass yield from the number of passing units. Export the table to Excel to attach to the build record.

**Bullets:**

- One row per serial number and test
- Use the same calibrated power meter
- Keep the spec window per product revision
- Retest failures in new rows to preserve history

#### Reading the results

**Body:** Wall-plug efficiency equals optical power divided by electrical power. For the first example row, 10.4 W out and 22.8 W in gives about 45.6 percent. A unit above the maximum power can fail too if the specification is a window, because it may indicate a measurement or alignment problem rather than a good unit.

#### Common mistakes

**Body:** Frequent errors are testing before thermal stabilization, using an uncalibrated meter, changing spec limits between rows without noting the revision, and overwriting failed test results instead of retesting in a new row. Keep traceability to the meter calibration ID in your records.

**Cta:** If test data is retyped into your ERP, Netray can help capture results from your stations and attach them to the work order.

**Faq:**

#### What is first pass yield?

**Answer:** The share of units that pass test the first time without rework or retest. Here it is calculated as passing rows divided by total rows, so enter only first attempts if you want a true first pass figure.

#### Can I log more parameters?

**Answer:** Yes. Export to Excel and add columns such as center wavelength, spectral width or slope efficiency, or request a custom layout.

#### Why does a high power reading fail?

**Answer:** The formula treats the spec as a window. If you only have a minimum limit, set the maximum to a very high number so only low readings fail.

#### How is efficiency computed?

**Answer:** Optical power divided by the product of drive current and voltage, shown as a percentage. It describes electrical to optical conversion at the test point.

## Search terms

laser module test data sheet, final test record template excel, laser power test log, optical module test worksheet, production test data template, laser diode test record, pass fail test log excel, photonics production test

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