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 →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
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.
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.
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.
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 ID | Cable type | Length | From device | From port | To device | To port | Route / zone | Notes |
|---|---|---|---|---|---|---|---|---|
| V01 | SDI | 20m | Camera 1 | SDI Out | Video switcher | SDI 1 | Rear wall to rack | Example row, replace with your own |
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 ID | Cable type | Length | From device | From port | To device | To port | Route / zone | Notes |
|---|---|---|---|---|---|---|---|---|
| V01 | HDMI | 2m | Lectern laptop | HDMI Out | HDMI to SDI converter | HDMI In | Lectern | Keep a USB-C adapter on the lectern |
| V02 | SDI | 20m | HDMI to SDI converter | SDI Out | Video switcher | SDI 1 | Floor box to rack | Under-floor trunking |
| V03 | SDI | 15m | PTZ camera | SDI Out | Video switcher | SDI 2 | Rear wall to rack | Ceiling void |
| V04 | SDI | 15m | Video switcher | Program Out | SDI to HDMI converter | SDI In | Rack to ceiling | Converter at projector |
| V05 | HDMI | 1m | SDI to HDMI converter | HDMI Out | Projector | HDMI 1 | Ceiling | |
| V06 | HDMI | 2m | Video switcher | Multiview Out | Operator monitor | HDMI In | Rack | |
| A01 | XLR | 10m | Lectern gooseneck mic | XLR Out | Stage box | Input 1 | Lectern to stage box | Phantom power on |
| A02 | XLR | 1m | Wireless receiver 1 | XLR Out | Stage box | Input 2 | Stage | Handheld |
| A03 | XLR | 1m | Wireless receiver 2 | XLR Out | Stage box | Input 3 | Stage | Lapel |
| N01 | Ethernet | 25m | Stage box | Network | Audio mixer | Stage box port | Stage to rack | Digital snake link |
| A04 | XLR | 15m | Audio mixer | Main L | Speaker left | Input | Rack to front left | |
| A05 | XLR | 15m | Audio mixer | Main R | Speaker right | Input | Rack to front right | |
| N02 | Ethernet | 15m | PTZ camera | Ethernet | Network switch | Port 1 | Rear wall to rack | Camera control |
| N03 | Ethernet | 1m | Control laptop | Ethernet | Network switch | Port 2 | Rack | |
| P01 | Power | 10m | Floor box socket | Outlet | Lectern power strip | Inlet | Floor box to lectern | Tape across walkway |
| P02 | Power | 2m | Rack power strip | Outlet 1 | Video switcher | Power In | Rack |
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.
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.
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 column | H2R Gear patch list column |
|---|---|
| Cable ID | Cable label |
| Cable type | Cable type |
| Length | Cable length |
| From device | From item |
| From port | Output |
| To device | To item |
| To port | Input |
| Route / zone | Shown on the canvas with zones (add as a column after export) |
| Notes | Add as a column after export |
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.
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.
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.
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.
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.
Ready to get organised?
Start using H2R Gear to plan your next setup.