Excel workbook (.xlsx)
Cable Schedule & Junction Box Termination List – Excel Template (Gland Sizing, Cross-Reference Checks)
Cable schedule, terminal-by-terminal JB termination list and JB summary in one workbook. Cores and gland size are looked up automatically, and terminated cores are counted and cross-checked. No macros.

Description
Stop finding termination errors at loop check. Enter your cables once and list the terminations per JB. The workbook tells you which cables are complete, which have spare cores, and where something does not add up.
What it does
- Cable schedule (1,000 cables): cable type → number of cores and outer diameter → gland size (from an editable gland table). From / to with locations, route, estimated and installed length, gland type, status (Planned → Tested) and an insulation-resistance PASS / FAIL against your project minimum.
- Automatic cross-reference: for every cable it counts the cores terminated at the From end and at the To end, as a field cable or as a multicore (screens excluded). It then reports *OK – all cores used*, *OK – n spare cores*, *MORE TERMINATIONS THAN CORES*, *No terminations listed* or *STATUS SAYS TERMINATED – NONE LISTED*.
- JB termination list (3,000 terminals): JB, strip, terminal, field cable + core, multicore + pair / core, loop / tag, signal. Flags duplicate terminals, cables not in the schedule and spare terminals.
- JB summary: terminals installed / used / spare / spare % per JB. It also compares the cables routed to each JB with the cables actually terminated there.
- KPIs: number of cables, total estimated and installed length, cables terminated / tested and open issues.
What's included
Cable_Schedule_and_JB_Termination_List.xlsx
- Instructions sheet - Blank sheets: Cable Schedule, JB Terminations, JB Summary - EXAMPLE versions of all three: two Ex e junction boxes with home-run multicores and deliberate errors that show every check - Lists: cable types with cores / OD, gland size table, gland types, statuses
Example_Cable_Schedule_PREVIEW.pdf
Who it's for
E&I and instrumentation contractors, commissioning teams, site supervisors, panel builders and maintenance engineers who need a reliable cable and termination record.
Compatibility
Excel 2016 / 2019 / 2021 / 365 (Windows / Mac), LibreOffice Calc 7+. No macros. Formula cells are protected without a password. The file has frozen headers, filters, dropdowns and A4 / Letter print setup.
Please note
The cable ODs and gland ranges in the Lists sheet are example values. Replace them with your own cable and gland manufacturer's data. Hazardous-area glanding must follow IEC 60079-14 and the gland certificate.
Licence
Single user / single company. Reselling or redistributing the template is not allowed.
---
More in Excel templates
- Instrument Calibration Certificate & Log – Excel Template (4-20 mA / HART, As-Found / As-Left)
- Loop Check & Commissioning Pack – Excel Template (AI / AO Control Valve / DI / DO Loop Sheets, Punch List, Progress Dashboard)
- Instrument Index & I/O List – Excel Template (ISA Tag List, Tag Validation, I/O Count & Spare Capacity)