Fiber Optic Test Log Worksheet
Insertion loss results are the core evidence for any fiber installation. This worksheet logs every fiber and wavelength against its loss budget, calculates the margin and keeps the pass or fail status in one table you can export.
| Date | Link ID | Fiber # | Wavelength | Length (m) | Measured loss (dB) | Loss budget (dB) | Margin (dB) | Result | Tester / serial | |
|---|---|---|---|---|---|---|---|---|---|---|
0.98 | ||||||||||
1.19 | ||||||||||
0.86 | ||||||||||
-0.28 | ||||||||||
0.98 | ||||||||||
0.92 |
A negative margin means that the measured loss exceeds the budget. Clean and inspect connectors, then retest before you declare a failure. Set the budget per row from your design calculation or the contract limit.
Want test logs connected to your quality system?
We can discuss a private setup that links test records to assets, work orders or quality records in your ERP.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add one row per fiber and wavelength tested. Record the date, link ID, fiber number, wavelength, link length, measured insertion loss and the loss budget for that link. The margin column calculates itself, so anything negative is visible at a glance. Set the result to Pass, Fail or Retest, and note the tester and its serial. The totals show the average and worst measured loss, the smallest margin and the number of records. Export to Excel, CSV or PDF for the handover pack.
- Reference the tester with a good launch cord before measuring
- Test each fiber at the wavelengths required in the specification
- Set the budget from the link loss calculation for that exact link
- Log retests as new rows so history is kept
Test method behind the log
Insertion loss is measured with a stabilized light source at one end and a power meter at the other. The meter and source are first connected with a reference cord to set a zero or reference power, then the link is inserted and the difference is the loss. Common methods are one-cord, two-cord and three-cord references, and the method changes how connector loss at each end is counted. Specify the method in the log notes so the numbers can be compared fairly with the budget.
Reading the results
Compare measured loss to the budget for the same wavelength. A single-mode link usually shows higher loss at 1310 nm than at 1550 nm because attenuation is greater at the shorter wavelength. A multimode link at 850 nm shows higher loss per kilometer than at 1300 nm. If one fiber in a cable is much higher than the others, suspect a dirty connector or a bad splice on that fiber, not the cable. If all fibers are high, check the reference setup and the budget assumptions.
Common mistakes
Frequent errors are re-referencing with a dirty or damaged reference cord, testing without inspecting the end faces, using the wrong wavelength setting on the meter, and comparing results with a budget that did not include all connectors. Failing to record the reference method makes results hard to defend later. Keep a separate connector inspection log and link it to the failing rows when you investigate.
Frequently Asked Questions
What is Tier 1 fiber testing?
Tier 1 certification measures insertion loss (and length) with a light source and power meter, as defined in TIA-568 test practice. Tier 2 adds OTDR traces for event detail. Many contracts require both.
Which wavelengths should I test?
Test multimode at 850 and 1300 nm and single-mode at 1310 and 1550 nm. Some specifications also add 1625 nm to find bends. Use the wavelengths stated in your contract.
What should I do if a fiber fails?
Clean and inspect the connectors, re-reference the tester, and retest. If it still fails, use an OTDR to locate the event, repair or re-terminate, then retest and log the new result.
Can I keep one log for many links?
Yes. The link ID column lets you group results, and you can sort or filter after exporting to Excel. For large projects consider one log per cable or per building to keep files manageable.
If you want test records attached to work orders, assets or quality records in your ERP, we can discuss a private integration. Reach out if you want to explore it.
Related Tools
Fiber Optic Link Loss Budget Calculator
Calculate total link loss, power budget and remaining margin for a single-mode or multimode fiber link, with a sweep of loss versus distance.
Industry TemplatesFiber Splice Loss Worksheet
Record splice loss from both OTDR directions, calculate the bidirectional average and margin to your acceptance limit for each splice.
Industry TemplatesOTDR Test Report Template
Generate a clean OTDR test report with instrument settings, event table, total loss and sign-off, ready to export as PDF or Word.
Industry TemplatesFiber Optic Certification Test Acceptance Report Template
A handover report for certified fiber links: project data, test equipment, method, results table, pass criteria and customer acceptance.
Quality & InspectionFiber Optic Connector End Face Inspection Log
Log each connector's end face inspection by zone, count defects and record the disposition. Works for production and field teams.
More Industry Templates tools
See all- Fiber Type Reference: OS2, OM3, OM4, OM5
- Fiber Connector Insertion Loss and Return Loss Reference
- dBm to mW Optical Power Converter
- Fiber Optic Bend Radius Reference
- Fiber Optic Splice Closure Record Template
- Fiber Optic Patch Panel Port Map Worksheet
- Fiber Optic Cable Assembly Traveler Template
- Fiber Optic Cable Length from OTDR Distance Calculator
- Fiber Optic Chromatic Dispersion Penalty Calculator