Your Cart
Loading

Fiber Optic Link Loss Budget Calculator (Excel)

On Sale
$7.00
$7.00
Added to cart

Calculate the maximum allowable loss of every fiber link in a project, then check the test results against it, in one Excel workbook. Useful for CCTV, access control, network backbone and ELV fiber designers, installers and testers.


What it does

- Loss Values: component losses pre-filled with the TIA-568.3-D maximums (multimode 3.5 dB/km @ 850 nm and 1.5 dB/km @ 1300 nm; single-mode 1.0 dB/km inside plant, 0.5 dB/km outside plant; 0.75 dB per mated connector pair; 0.3 dB per splice). Replace them with your datasheet values.

- Link Budget: up to 40 links. Pick fiber type / wavelength from a drop-down, enter length, connector pairs, splices and other losses -> fiber, connector, splice and total allowable loss per link.

- Test results: enter the measured loss (light source / power meter) -> PASS / FAIL and headroom per link, plus a count of failed links.

- Power Budget: transmitter minimum output minus receiver sensitivity vs. the link loss, with your safety margin (3 dB default) -> OK / below margin / fail.


Formula is visible and editable: loss = km x dB/km + connector pairs x dB + splices x dB + other. Worked example: 300 m OM3 at 850 nm with 2 connector pairs = 2.55 dB. Yellow cells are inputs, blue cells are calculated. Works in Excel and LibreOffice.


Made by an experienced ELV / low-voltage design engineer (30,000+ CAD drawings). A design aid - always confirm limits against your project specification and the transceiver datasheet.


Want every calculator? The Complete ELV Engineer Excel Library: https://payhip.com/b/R0uyW

Free quick calculator (CCTV storage, PoE budget, voltage drop): https://payhip.com/b/PUG1b

Step-by-step guide: Fiber Optic Link Loss Budget

You will get a XLSX (13KB) file