# Fiber Optic Test Log Worksheet > Source: https://netray.co/tools/fiber-optic-test-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log insertion loss test results per fiber and wavelength against the loss budget, with automatic margin and pass or fail tracking. ## Category industry-templates ## Industry Fiber Optics ## Audience - Test technician - Fiber optic engineer - Quality inspector ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Date **Key:** date **Type:** date #### Link ID **Key:** link **Type:** text #### Fiber # **Key:** fiber **Type:** text #### Wavelength **Key:** wave **Type:** select **Options:** - 850 nm - 1300 nm - 1310 nm - 1550 nm - 1625 nm #### Length (m) **Key:** length **Type:** number **Format:** integer #### Measured loss (dB) **Key:** measured **Type:** number **Format:** decimal #### Loss budget (dB) **Key:** budget **Type:** number **Format:** decimal #### Margin (dB) **Key:** margin **Type:** number **Expr:** budget - measured **Format:** decimal #### Result **Key:** result **Type:** select **Options:** - Pass - Fail - Retest #### Tester / serial **Key:** tester **Type:** text **Rows:** **Date:** 2026-10-15 **Link:** BB-02-A **Fiber:** 1 **Wave:** 1310 nm **Length:** 2418 **Measured:** 1.62 **Budget:** 2.6 **Result:** Pass **Tester:** LS/PM 7741 **Date:** 2026-10-15 **Link:** BB-02-A **Fiber:** 1 **Wave:** 1550 nm **Length:** 2418 **Measured:** 1.31 **Budget:** 2.5 **Result:** Pass **Tester:** LS/PM 7741 **Date:** 2026-10-15 **Link:** BB-02-A **Fiber:** 2 **Wave:** 1310 nm **Length:** 2418 **Measured:** 1.74 **Budget:** 2.6 **Result:** Pass **Tester:** LS/PM 7741 **Date:** 2026-10-15 **Link:** BB-02-A **Fiber:** 3 **Wave:** 1310 nm **Length:** 2418 **Measured:** 2.88 **Budget:** 2.6 **Result:** Retest **Tester:** LS/PM 7741 **Date:** 2026-10-16 **Link:** MM-11-C **Fiber:** 1 **Wave:** 850 nm **Length:** 186 **Measured:** 0.92 **Budget:** 1.9 **Result:** Pass **Tester:** LS/PM 7741 **Date:** 2026-10-16 **Link:** MM-11-C **Fiber:** 2 **Wave:** 850 nm **Length:** 186 **Measured:** 0.98 **Budget:** 1.9 **Result:** Pass **Tester:** LS/PM 7741 **Totals:** #### Average measured loss (dB) **Key:** measured **Agg:** avg **Format:** decimal #### Worst measured loss (dB) **Key:** measured **Agg:** max **Format:** decimal #### Smallest margin (dB) **Key:** margin **Agg:** min **Format:** decimal #### Test records **Key:** link **Agg:** count **Format:** integer **Summary:** #### Loss spread, worst minus best (dB) **Key:** range **Expr:** max_measured - min_measured **Format:** decimal **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the worksheet **Body:** 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. **Bullets:** - 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 **Body:** 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 **Body:** 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 **Body:** 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. **Cta:** 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. **Faq:** #### What is Tier 1 fiber testing? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms fiber optic test log, fiber optic test results spreadsheet, insertion loss test record, fiber certification test log excel, tier 1 fiber test report, fiber test results template, light source power meter test sheet, fiber link test record --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json