Your Cart
Loading

Conduit & Cable Tray Fill Calculator (Excel)

On Sale
$7.00
$7.00
Added to cart
  • 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

You will get a XLSX (33KB) file