# Fiber Optic Patch Panel Port Map Worksheet > Source: https://netray.co/tools/fiber-optic-patch-panel-port-map-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Document every port on a fiber patch panel: strand, far end, connector, polarity and label. Edit rows and export to Excel. ## Category industry-templates ## Industry Fiber Optics ## Audience - Fiber optic technician - Network engineer - Data center technician ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Panel **Key:** panel **Type:** text #### Port **Key:** port **Type:** number #### Strand pair **Key:** strand **Type:** text #### Far end **Key:** far_end **Type:** text #### Connector **Key:** connector **Type:** select **Options:** - LC duplex - SC duplex - LC simplex - SC simplex - MPO-12 - MPO-24 - ST - FC #### Polish **Key:** polish **Type:** select **Options:** - UPC - APC #### Polarity **Key:** polarity **Type:** select **Options:** - A-B - A-A - B-B - Method A - Method B - Method C - n/a #### Status **Key:** status **Type:** select **Options:** - In service - Reserved - Spare - Dark #### Port label **Key:** label **Type:** text **Rows:** #### FP-A01-01 **Panel:** FP-A01 **Port:** 1 **Strand:** S1-S2 **Far end:** Core switch 1, Eth1/1 **Connector:** LC duplex **Polish:** UPC **Polarity:** A-B **Status:** In service #### FP-A01-02 **Panel:** FP-A01 **Port:** 2 **Strand:** S3-S4 **Far end:** Core switch 2, Eth1/1 **Connector:** LC duplex **Polish:** UPC **Polarity:** A-B **Status:** In service #### FP-A01-03 **Panel:** FP-A01 **Port:** 3 **Strand:** S5-S6 **Far end:** Building B, panel FP-B01 port 3 **Connector:** LC duplex **Polish:** UPC **Polarity:** A-B **Status:** Reserved #### FP-A01-04 **Panel:** FP-A01 **Port:** 4 **Strand:** S7-S8 **Far end:** Unassigned **Connector:** LC duplex **Polish:** UPC **Polarity:** A-B **Status:** Spare #### FP-A02-01 **Panel:** FP-A02 **Port:** 1 **Strand:** Trunk 1 **Far end:** Row C cassette 1 **Connector:** MPO-12 **Polish:** UPC **Polarity:** Method B **Status:** In service **Totals:** #### Ports listed **Key:** port **Agg:** count **Format:** integer **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the worksheet **Body:** 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. **Bullets:** - 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 **Body:** 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 **Body:** 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 **Body:** 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. **Cta:** If port and strand data should flow into your ERP or CMDB automatically, we can help design the import and the approval step. **Faq:** #### Does one row mean one fiber or one port? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms fiber patch panel port map, fiber patch panel documentation excel, fiber cross connect record, fiber panel labeling worksheet, fiber port assignment spreadsheet, fiber strand assignment sheet, fiber patch panel template, fiber termination schedule --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json