Conduit & Cable Tray Fill Calculator (Excel)
- Size conduits and cable trays for ELV / low-voltage cabling in one Excel workbook: CCTV, access control, structured cabling, fire alarm, PA and fiber.
What it does
- Conduit Fill: up to 40 conduit runs. Pick the conduit size and up to 3 cable types with quantities -> conduit area, cable area, fill %, allowed fill (NEC Chapter 9 Table 1: 1 cable 53%, 2 cables 31%, 3+ cables 40%) and PASS / OVER.
- Jam check: warns when exactly 3 cables have a conduit-ID / cable-OD ratio between 2.8 and 3.2 (jamming risk during the pull).
- Tray Fill: up to 30 tray sections. Width x usable depth (capped at the 150 mm TIA-569 stacking depth) vs. total cable area -> fill % against the 25% design target and 50% maximum, plus how many more Cat6 cables fit at the design target.
- Max Cables: quick table of the maximum number of each cable type per conduit size.
- Conduit Sizes: EMT 1/2" to 4" inside diameters pre-filled (NEC Chapter 9 Table 4), plus custom rows for metric PVC conduit or duct.
- Cable Library: typical ODs for Cat5e, Cat6, Cat6A, RG59, RG6, alarm cable, fire alarm cable, speaker cable and fiber - replace with your datasheet values.
Worked example: 6 x Cat6 (6.2 mm) in 1" EMT = 32.6% fill -> PASS (40% allowed). Yellow cells are inputs, blue cells are calculated, all formulas visible and editable. Works in Excel and LibreOffice.
Made by an experienced ELV / low-voltage design engineer (30,000+ CAD drawings). A design aid - always confirm against your local code, the project specification and manufacturers' data.
Want every calculator? The Complete ELV Engineer Excel Library: https://payhip.com/b/R0uyW
Free quick calculator (CCTV storage, PoE budget, voltage drop): https://payhip.com/b/PUG1b
Step-by-step guide: Conduit and Cable Tray Fill for Low-Voltage Cabling