H2R Gear

New in H2R Gear v2.12

A rewritten cable engine that routes around your gear, plus cable shortcuts and a long list of fixes.

Read more →

Free Template

AV Cable Schedule Template

A free cable schedule template for Excel and Google Sheets. Download the blank CSV, or start from a filled example for a small conference room with SDI, HDMI, XLR, Ethernet and power runs.

What is an AV cable schedule?

A cable schedule is a list of every cable in an AV system, one row per cable. Each row gives the cable a unique ID, says what type and length it is, which device and port it starts at, which device and port it ends at, and how it gets there. It is the document you hand to whoever is pulling cable, and the one you reach for months later when a feed goes down and you need to know which run to check.

On a permanent install, like a conference room, lecture theatre or church, the cable schedule becomes part of the handover pack. On a live event it doubles as the cable pull list and tells the crew what to lay first.

Cable schedule vs patch list

The two overlap, and on small jobs one document can do both. The difference is the question each one answers:

If you already have a patch list with cable labels and lengths, you are most of the way to a cable schedule. Add a route column and a notes column and you are done.

Cable schedule columns

Blank cable schedule template (CSV)

Headers plus one example row to show the format. Open it in Excel or Google Sheets, delete the example and add your own rows.

Cable IDCable typeLengthFrom deviceFrom portTo deviceTo portRoute / zoneNotes
V01SDI20mCamera 1SDI OutVideo switcherSDI 1Rear wall to rackExample row, replace with your own
Download blank template CSV

Example cable schedule: small conference room

A typical meeting or training room: a lectern with a laptop input and a gooseneck mic, two wireless mics, a digital stage box on stage linked to the mixer in the rack over Ethernet, a PTZ camera on the rear wall, a video switcher, a ceiling projector and a pair of speakers. The laptop's HDMI is converted to SDI at the lectern for the 20 metre floor run, and back to HDMI at the projector.

Cable IDCable typeLengthFrom deviceFrom portTo deviceTo portRoute / zoneNotes
V01HDMI2mLectern laptopHDMI OutHDMI to SDI converterHDMI InLecternKeep a USB-C adapter on the lectern
V02SDI20mHDMI to SDI converterSDI OutVideo switcherSDI 1Floor box to rackUnder-floor trunking
V03SDI15mPTZ cameraSDI OutVideo switcherSDI 2Rear wall to rackCeiling void
V04SDI15mVideo switcherProgram OutSDI to HDMI converterSDI InRack to ceilingConverter at projector
V05HDMI1mSDI to HDMI converterHDMI OutProjectorHDMI 1Ceiling
V06HDMI2mVideo switcherMultiview OutOperator monitorHDMI InRack
A01XLR10mLectern gooseneck micXLR OutStage boxInput 1Lectern to stage boxPhantom power on
A02XLR1mWireless receiver 1XLR OutStage boxInput 2StageHandheld
A03XLR1mWireless receiver 2XLR OutStage boxInput 3StageLapel
N01Ethernet25mStage boxNetworkAudio mixerStage box portStage to rackDigital snake link
A04XLR15mAudio mixerMain LSpeaker leftInputRack to front left
A05XLR15mAudio mixerMain RSpeaker rightInputRack to front right
N02Ethernet15mPTZ cameraEthernetNetwork switchPort 1Rear wall to rackCamera control
N03Ethernet1mControl laptopEthernetNetwork switchPort 2Rack
P01Power10mFloor box socketOutletLectern power stripInletFloor box to lecternTape across walkway
P02Power2mRack power stripOutlet 1Video switcherPower InRack
Download example schedule CSV

A few things this example gets right. Every ID is unique and the prefix tells you the signal type. Long runs use SDI rather than HDMI. Ethernet runs carry both the digital stage box link and camera control, and each one is named so nobody unplugs the wrong port. Power is on the schedule too, because a lectern with no power is a failed show.

Using a cable schedule template in Excel

Once the CSV is open in Excel, turn the range into a table so you can sort and filter. Useful views: sort by Cable type to count how many of each cable to pull or pack; filter by Route / zone to hand each installer only their runs; sort by To device to check every input on the switcher or mixer is accounted for. Freeze the header row and print in landscape so the whole row fits on one line.

Generate the cable schedule from your diagram

The problem with any spreadsheet is keeping it in step with the design. Change a camera position and the diagram, the patch list and the cable schedule all need editing. In H2R Gear you draw the system once: real gear from the community library, cables dragged between real outputs and inputs. Give each cable a label (up to 7 characters, like V01) and a length, and they show on the diagram and in the lists.

On Pro and team plans, the Patches view lists every cable in the plan with these columns: Cable type, Cable label, Cable length, From item, Output, To item, Input. Sort it, filter it, hide columns you do not need, then export a CSV or copy it to the clipboard. The columns map straight onto the cable schedule:

Cable schedule columnH2R Gear patch list column
Cable IDCable label
Cable typeCable type
LengthCable length
From deviceFrom item
From portOutput
To deviceTo item
To portInput
Route / zoneShown on the canvas with zones (add as a column after export)
NotesAdd as a column after export
Download column mapping CSV

Route and notes are not columns in the patch list, so add them in your spreadsheet after export. On the diagram itself, zones (also Pro) mark areas like Stage, Lectern and Rack so the route is visible at a glance. Cable lengths also feed the packlist, which is on every plan including the free Starter tier. See the patch list docs and cable docs for details, or try the free patch list tool if you just need a quick list.

Frequently asked questions

What is a cable schedule in AV? +

A cable schedule is a table listing every cable in a system, with its ID, type, length, the device and port at each end, and the route it takes. Installers and crews use it to pull, label and terminate cables and to find faults later.

What is the difference between a cable schedule and a patch list? +

A patch list records which output connects to which input. A cable schedule records the same connections plus the physical detail of each cable: its length, route, zone and installation notes. On small shows one document often does both jobs.

Can I open this cable schedule template in Excel? +

Yes. The downloads are CSV files, which open directly in Excel, Google Sheets and Numbers. Save as .xlsx in Excel if you want to add formatting, filters or extra columns.

Can H2R Gear generate a cable schedule? +

The H2R Gear patch list (Pro and team plans) lists every cable in a plan with its type, label, length, from item, output, to item and input, and exports to CSV. That covers most of a cable schedule; add route and notes columns in your spreadsheet.

Related

How to make a patch list

What goes in a patch list and how to keep it accurate.

Read more →

Cable labelling for live events

A labelling scheme your crew will actually follow.

Read more →

Cable length calculator

Estimate run lengths with slack for routing and dressing.

Read more →

Ready to get organised?

Start using H2R Gear to plan your next setup.

Get started