Fiber Optic Patch Panel Port Map Worksheet
A fiber panel with no map becomes a guessing game the first time a link fails. This worksheet keeps every port, strand pair and far end in one editable table you can export to Excel.
| Panel | Port | Strand pair | Far end | Connector | Polish | Polarity | Status | Port label | |
|---|---|---|---|---|---|---|---|---|---|
Keep the label column identical to the physical label on the panel. Check polarity against the TIA-568 methods or your cabling standard before pulling trunks.
Keep port maps in sync with your systems
Optional conversation about syncing cabling records with your asset and change data.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add one row per port or per duplex pair. Enter the panel name, port number, the strand pair inside the trunk or cable, and where the other end lands. Pick the connector type and polish, then set polarity and status. Export the sheet to Excel or PDF and tape a printed copy inside the rack door as a backup to your asset database.
- One row per duplex pair, not per single fiber, for LC and SC links
- Use the same panel naming as your DCIM or CMDB
- Mark spare and dark ports so nobody patches into a reserved strand
Polarity and polish
Polarity errors are the most common cause of a new link not coming up. In a duplex system the transmit on one end must reach receive on the other, which means an odd number of crossovers in the full channel. For MPO trunking, polarity method A, B or C describes how the trunk and cassettes cross fibers. Polish matters too: APC connectors are green by convention and must never be mated to UPC, as the angled end face and flat end face do not mate correctly and cause high loss.
Keeping the map accurate
A port map is only valuable if it is updated at every move, add or change. Tie updates to your change ticket, and re-export after each batch of work. During audits, sample a few ports with a visual fault locator or a power meter to confirm the map matches reality. Record the date of the last verification in your own document control system.
Common mistakes
Typical errors are labelling the front of the panel but not the rear, using different names on the panel and in the spreadsheet, and recording only the near end. Always record the far end including the far panel and port. Do not reuse a strand pair that is marked Reserved without updating status first, and never assume a spare strand is dark until verified.
Frequently Asked Questions
Does one row mean one fiber or one port?
For duplex connectors like LC and SC, use one row per duplex port and list the strand pair. For simplex or MPO connectors, one row per connector with the trunk or fiber range in the strand column works well.
Why record polish type?
UPC and APC connectors cannot be mated together without high loss and possible end face damage. Recording polish for each port prevents mismatched patch cords from being used during later moves.
How do I show a cross connect across two panels?
Add a row on each panel and write the other panel and port in the far end column. That gives you a trace in both directions from either row.
Can I import this into a CMDB?
Export to Excel or CSV and map the columns to your CMDB fields. Most tools accept panel, port and far end as the minimum set for a cable connection record.
If port and strand data should flow into your ERP or CMDB automatically, we can help design the import and the approval step.
Related Tools
Fiber 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.
Quality & InspectionFiber Optic Jumper Final Test Batch Worksheet
Batch test sheet for patch cords and jumpers: insertion loss, return loss, limits, margin and automatic pass flag with batch yield.
Industry TemplatesFiber Optic Splice Closure Record Template
A fill-in record for each splice closure: location, cable ID, tray and splice map, closure sealing and sign-off. Exports to PDF or Word.
Industry TemplatesFiber Optic Cable Assembly Traveler Template
A production traveler for fiber cable assemblies, covering kit, strip, terminate, cure, polish, inspect, test and pack with operator sign-offs.
More Industry Templates tools
See all- Fiber Optic Link Loss Budget Calculator
- Fiber Type Reference: OS2, OM3, OM4, OM5
- Fiber Splice Loss Worksheet
- OTDR Test Report Template
- Fiber Connector Insertion Loss and Return Loss Reference
- dBm to mW Optical Power Converter
- Fiber Optic Bend Radius Reference
- Fiber Optic Test Log Worksheet
- Fiber Optic Certification Test Acceptance Report Template