Junction box schedule Excel template.
11 columns including terminal strip, terminal number, wire number, and wire colour. Signal-class dropdown. Auto-filter on every column. Frozen header. 48 blank rows ready to fill.
- Format.xlsx
- Columns11
- Rows48 blank
- Opens inExcel · Sheets · LibreOffice
What is a junction box schedule?
A junction box schedule (JB schedule) is the wiring termination register inside every field junction box, marshalling cabinet, or panel. Each row records one terminal: the JB tag, the terminal strip and number, the wire number and colour, the cable that lands on it, the instrument it serves, the signal class, and the from / to endpoints. The schedule is handed to the wireman during construction.
Every column, defined.
11 columns mapped to how a JB termination schedule is issued for wiring. Signal class is enforced; wire colour stays free text so IEC and North American codes both fit.
| # | Column | Type | Description |
|---|---|---|---|
| 01 | JB Tag | Text | Junction box tag (JB-101, MJB-3) |
| 02 | Terminal Strip | Text | Strip identifier (TS-1, TB-A) |
| 03 | Terminal Number | Text | Terminal position (1, 2, 17) |
| 04 | Wire Number | Text | Wire tag (1+, 1-, S) |
| 05 | Wire Color | Text | IEC 60757 or project colour code |
| 06 | Cable Number | Text | Cable landing on the terminal (C-101-001) |
| 07 | Instrument Tag | Text | Instrument the wire serves |
| 08 | Signal Class | List | AI, AO, DI, DO, or N/A |
| 09 | From | Text | Origin (instrument terminal or upstream JB) |
| 10 | To | Text | Destination (DCS, MCC, downstream device) |
| 11 | Notes | Text | Spare, shield, intrinsic safety, IS barrier |
What ships in the file.
| # | Feature | Detail |
|---|---|---|
| 01 | Header row | Formatted, frozen, with set column widths so termination lists across many JBs scroll cleanly. |
| 02 | Signal-class dropdown | Enforced values: AI, AO, DI, DO, N/A. Stops mismatch between the JB schedule and the I/O list. |
| 03 | Auto-filter | Enabled on every column. Filter to a single JB or strip to print just that page for the wireman. |
| 04 | Worked example | One filled row (JB-101, terminal TS-1 / 1, wire 1+) shows the format for terminal, wire, and cable mapping. |
| 05 | 48 blank rows | Pre-formatted and ready to paste into. Extends without breaking the dropdown or filter range. |
| 06 | Terminal numbering | Separate Terminal Strip and Terminal Number columns. TS-1 / 1 stays distinct from TS-2 / 1. |
| 07 | Cross-tool | Plain .xlsx. Opens cleanly in Excel, Google Sheets, and LibreOffice. No macros, no add-ins. |
| 08 | Quiet signoff | A single mint-italic line at the bottom: Drag a P&ID at tagsight.io to fill this automatically. Easy to delete. |
How is this different from extracting straight from a P&ID?
Upload a P&ID set instead and the JB tag, instrument tag, cable number, and signal class come back populated from each loop. Terminal strip, terminal number, and wire colour are drawn from JB drawings rather than P&IDs, so those columns stay open for the wiring engineer.
Scanned drawings, CAD-exported PDFs, and image scans all work. ISA 5.1, KKS, IEC 81346, DIN, NORSOK, JIS, GOST, and in-house tag conventions read as drawn.
Common questions
What is a junction box schedule?
What columns are in this template?
Can I edit the template in any spreadsheet tool?
Can I extend the template for a larger project?
How is this different from extracting straight from a P&ID?
What goes in the Wire Color column?
Extract from a P&ID instead.
Upload a P&ID set instead and the JB tag, instrument tag, cable number, and signal class come back populated from each loop.