Free Cable Test Results & Patch Panel Port Map Template (Excel)

Free Cable Test & Port Map Template

Cable certification results, patch panel port map, 42U rack elevation with power and heat, and a camera / access control / WAP device schedule with switch PoE budget: the complete low-voltage as-built package.

✓Cable test log: limit, result, worst margin, length check

✓PASS / PASS* / FAIL counts, first-pass yield, open retests

✓Port map with auto port labels + duplicate checks

✓Rack elevation RU 42→1 with U used / free

✓Rack watts, amps, % of circuit, BTU/hr

✓Device schedule: IP, MAC, VLAN, switch port, mounting

✓Switch PoE budget: allocated vs. available

Cable Test & Port Map

We'll email you a copy + send the file to your browser right now.

By downloading you agree to receive occasional Field PM updates. Unsubscribe anytime. We don't share your email — read our privacy policy.

What's inside the workbook

Pre-formatted, print-ready, with embedded Field PM branding. Works in Excel, Google Sheets, and Numbers.

Cable Test Results

Cable ID, from/to, category, length, test limit (your entry), result, worst margin and parameter, tester, date, retest. Flags fails, thin margins, and over-length links.

Port Map

Rack, panel, port, cable ID, room/outlet, jack, switch port, VLAN, device, patch cord. Auto port label and duplicate cable / switch-port checks.

Rack Elevation

RU 42 to 1 grid with devices, height, mount, watts, and PDU outlets. U used/free, amps, % of circuit rating, BTU/hr.

Device Schedule

Cameras, access control, WAPs, and intercoms with tag, model, location, mounting, IP, MAC, PoE class and watts, plus a per-switch PoE budget.

Instructions

How to fill each tab and how they cross-reference.

Stop re-typing the same form on every job.

Field PM has this exact form built in — crews fill it out from a phone, the data flows into the project record, and you get a clean PDF for the GC or owner with one click. No re-typing, no lost paperwork, no missed signatures.

30 days free · no credit card · every feature unlocked from day one.

Frequently asked questions

What should a cable test results log include?

For each link: the cable ID, both ends (panel and port, room and outlet), category or media, length, the exact test limit used on the tester (for example a Cat 6 permanent link limit), the overall result, the worst-case margin and the parameter that set it, tester and date, and whether a retest is open. The native tester files remain the official record; the log is the index the owner and PM actually read.

What do PASS* and FAIL* mean on a cable certifier?

The asterisk means the measured result is within the tester's accuracy band of the limit, so the tester cannot say with full confidence which side of the line it falls. How PASS* is treated depends on the owner's spec and the cabling manufacturer's warranty program. Many accept it; some require a re-termination. The template tracks PASS* separately and flags thin margins for a second look.

Permanent link or channel?

A permanent link test covers the installed cable from patch panel to outlet, without patch cords. It's what installers normally certify. A channel test includes the patch cords and equipment cords end to end. The limits differ, so the template records the limit used for every row rather than assuming one.

How does the rack elevation calculate power?

Enter each device's input watts (nameplate or measured — PoE switches include their PoE load). The sheet totals watts, converts to amps at your circuit voltage, compares it with your circuit rating and planning limit (commonly 80% for continuous load — verify NEC 210.19/210.20), and gives heat load in BTU/hr (W × 3.412) for the room HVAC.

How is the switch PoE budget checked?

Each device gets its PoE watts from its datasheet. The device schedule sums that by switch with SUMIF and compares it with the switch's PoE budget, flagging over 80% amber and over 100% red. If your switch reserves power by PoE class instead of actual draw, enter the class allocation. Class-based switches often run out of budget before the actual watts do.

The as-built package the owner's IT team asks for

Low-voltage closeout means proving every link was certified and documenting where every cable, port, and device ended up. Owners and their IT groups want a readable index of test results, a port map, rack elevations, and a device schedule, not just a folder of tester files.

This free template gives structured cabling, security, and electrical contractors all four in one workbook, with checks for failed or marginal links, duplicate cable IDs, duplicate IPs, rack circuit load, and switch PoE budget. Plan the pulls first with our cable schedule & pull sheet.

Field PM keeps daily reports, QA/QC checklists, punch lists, and turnover documents in one place, so the as-built package fills in as the job goes.

Low-voltage turnover without the shoebox of test files

On most low-voltage jobs the install goes fine and the closeout drags. The certifier holds 600 test results named by whoever keyed them in, the patch panel labels don't match the drawings, the rack got two more switches than the design showed, and the owner's IT group wants to know which switch port camera 104 is on. The free workbook above is the as-built package in four tabs: Cable Test Results, Port Map, Rack Elevation, and Device Schedule. They share cable IDs and switch names so they cross-reference.

1. Cable test results: the index to your certifier files

Every certified link gets one row: cable ID, from (telecom room, panel, port), to (room and outlet), category or media, length, test limit, result, worst margin, worst parameter, tester, date, and retest status. A few things matter more than people think:

Record the exact limit. "Cat 6" isn't enough. Permanent link and channel limits differ, and so do TIA and ISO/IEC limits. Warranty programs often require specific limits and adapters. The template has a default limit and a per-row override.
Watch the margin, not just PASS. A link that passes by 0.4 dB is one bad patch cord away from failing in service. The margin threshold is your call; thin margins flag amber.
Length. Copper horizontal links have a maximum permanent-link length in the standard (commonly 90 m ≈ 295 ft; verify for your spec). Over-length links flag red. Fiber rows are skipped and checked against their own loss budget.

The summary gives links tested, PASS / PASS* / FAIL counts, first-pass yield, worst margin, over-length count, and open retests. That's the status line the GC's PM asks for every week.

2. Port map: the document IT actually uses

One row per patch panel port: rack, panel, port, cable ID, room, outlet, jack, switch, switch port, VLAN, device/use, and patch cord. The port label builds itself as Rack-Panel-Port (R1-PP-A1-07), matching the labeling scheme on the faceplates and panels (TIA-606 or the owner's standard). The Check column catches the two most common as-built errors: a cable ID used twice, or two ports patched to the same switch port.

3. Rack elevation with power and heat

The rack elevation lists RU 42 down to 1. Place each device on its top RU with its height, mount, input watts, and PDU outlets; multi-U devices show continuation rows. The summary gives U used and free, total watts, amps at your circuit voltage, % of the circuit rating against your planning limit, and heat load in BTU/hr for the mechanical engineer. PoE switches draw their PoE load from the rack circuit, so a 48-port PoE+ switch feeding cameras and APs can draw several hundred watts by itself. For dual-corded gear on A and B feeds, size each circuit to carry the whole rack when the other feed is down.

4. Device schedule and PoE budget

Cameras, access-control controllers and readers, wireless APs, and intercoms each get a row: tag, type, make/model, location, mounting and height, cable ID, switch and port, VLAN, IP, MAC, PoE class, PoE watts from the datasheet, installed, and online/programmed. Duplicate IPs flag red. The switch table below sums PoE watts by switch and compares them with each switch's PoE budget. PoE classes and power levels are defined in IEEE 802.3af/at/bt; use the device and switch datasheets for the numbers. Heated PTZ cameras and Wi-Fi 6E APs are where budgets get used up.

How the tabs tie together

A failed cable in Cable Test Results (2A-01-007) shows up as the PTZ camera in the Device Schedule that isn't online yet.
The Port Map tells you which switch port that camera lands on; the Rack Elevation tells you which switch, circuit, and PDU outlet feed it.
Filter any tab by room, switch, or cable ID to answer the owner's question in seconds.

Standards references

TIA-568, TIA-606, ISO/IEC 11801, IEEE 802.3, and NEC references are for orientation. The workbook doesn't embed standard tables or limits. Verify against the editions in your specification and adopted by your AHJ.

From spreadsheets to closeout on schedule

For low-voltage and electrical contractors, the as-built package is often what holds up the final payment. Field PM gives crews daily reports, QA/QC checklists, photos, and punch lists on their phones, and keeps test results and as-builts in the project's Job Book, so the closeout package fills in as the work gets done. Start a free 30-day trial. No credit card required.

Related free templates and references

Cable schedule & pull sheet: plan the pulls before you test them
Panel schedule template: document the circuits feeding your racks
NEC working space requirements: clearances in front of electrical equipment in telecom rooms
Submittal log: track cable, connectivity, and device submittals
Project closeout checklist
Browse all free construction templates