Quality & InspectionFree worksheetPDF, Excel, Word exportFiber Optics

Fiber Optic Jumper Final Test Batch Worksheet

Final test is where a cable assembly line proves each jumper meets its loss limits. This worksheet gives you the table, the margin math and the batch yield in one place.

Download:

IL margin (dB)	RL margin (dB)	Pass (1 = yes)
0.16	7	1
0.08	4	1
-0.05	2	0
0.12	11	1
0.18	-2	0

Units passed

Units tested

Average insertion loss

0.202

First pass yield

60%

Limits shown are examples only. Set IL and RL limits from the customer drawing or the applicable standard. Return loss is a positive number in dB, higher is better.

Automate test data capture

Optional review of how tester output could post into serial-level records in your ERP.

Optional. The tool and every export work without this. No spam.

How to use the worksheet

Enter one row per tested jumper with the measured insertion loss and return loss, then the limits that apply to that product. The sheet computes margin to each limit and flags pass only if both insertion loss and return loss meet their requirements. The batch yield updates as you edit rows, and the whole table exports to Excel for the build record.

Set limits per row so mixed fiber types can share a sheet
Record the reference method in your work instruction
Retest failures only after re-clean and re-inspection

Insertion loss and return loss

Insertion loss is the power lost through the assembly, measured in dB, where a lower number is better. Return loss is the ratio of launched power to reflected power, where a higher number is better. APC connectors reach much higher return loss than UPC. The measurement method matters: insertion loss depends on the reference you set, so follow your reference procedure and keep it consistent across operators.

Reading margin and yield

A small positive margin on many units is a warning that the process sits near the limit. Look at the average insertion loss and the spread. If most units pass with under 20 percent of the limit left as margin, a small drift in polish, ferrule geometry or cleaning could move yield sharply. Track yield by lot, and investigate any unit that fails return loss, since that often points to end face damage or contamination.

Common mistakes

Measuring with a dirty reference lead, failing to re-reference after a connector change, and testing multimode with a source that does not meet launch conditions. Also avoid mixing wavelengths in one row. Test at all wavelengths required by the customer and add a row per wavelength, so every number maps to one condition.

Frequently Asked Questions

What insertion loss limit should I use?

Use the limit on the customer drawing or the applicable standard for the connector grade. Many premium single mode assemblies specify a tighter loss than standard grade. The 0.3 dB shown is an example only, not a universal limit.

Is return loss entered as a positive or negative number?

As a positive number of dB where a higher value means less reflection. Some test equipment shows it as negative, so check your instrument and enter the magnitude.

How do I handle jumpers tested at two wavelengths?

Add one row per wavelength with the same serial number. The pass flag works per row, and you can filter by serial in Excel to confirm both wavelengths passed before shipping.

How is yield calculated?

First pass yield is the number of rows flagged pass divided by the number of rows, as a percent. If you list a unit twice for two wavelengths, count each row as a test rather than a unit.

If your test results should flow into serial-level traceability in your ERP, we can help connect tester output to the build record.

Talk to an Expert Explore More Free Tools

Related Tools

Quality & Inspection

More Quality & Inspection tools

See all

Back to All Tools