Cable Tray Material Takeoff Calculator

Converts entered cable-tray route rows, stock lengths, fittings, splices, covers, partitions, supports, and allowances into a planning takeoff.

Inputs
Tray route rows

Enter one row per tray route or tray system segment.

Row 1
Row 2
Result

Formulas

  • \(N_{\mathrm{row}} = \left\lceil\frac{L_{\mathrm{route}}}{L_{\mathrm{stock}}}\right\rceil\)
  • \(N_{\mathrm{plan}} = \left\lceil N_{\mathrm{straight}}\left(1+\frac{W}{100}\right)\right\rceil\)
  • \(N_{\mathrm{splice\ plates}} = N_{\mathrm{joints}}\times N_{\mathrm{plates/joint}}\)
  • \(L_{\mathrm{cover,plan}} = \left\lceil L_{\mathrm{cover}}\left(1+\frac{W}{100}\right)\right\rceil\)
  • \(L_{\mathrm{partition,plan}} = \left\lceil L_{\mathrm{partition}}\left(1+\frac{W}{100}\right)\right\rceil\)

The Cable Tray Material Takeoff Calculator produces a planning quantity for straight tray sections, fittings, splice plates, covers, partitions, and supports after tray routes and fittings have already been defined. Its primary result is the number of Straight sections to plan, along with the related accessories required to develop a procurement or estimating schedule.

Apply this takeoff after the tray routing, elevation changes, branches, and equipment entry points have been laid out. The resulting quantities support material purchasing, labor estimating, support planning, and coordination with the selected tray manufacturer’s catalog. It does not determine conductor ampacity, voltage drop, raceway fill, cable tray fill, cable spacing, support spacing, or the required tray width and loading classification.

Route Sections and Waste Allowance

Each tray route is entered as a separate row. The calculator rounds that route upward to the entered Stock section length (ft), because a partial run normally requires a full straight section to be furnished.

For each route row:

\(\displaystyle \text{Straight sections before waste} = \left\lceil \frac{\text{Route length (ft)}}{\text{Stock section length (ft)}} \right\rceil\)

The calculator then applies Length and section waste allowance (%) to the combined straight-section quantity and rounds upward to establish the purchase quantity:

\(\displaystyle \text{Straight sections to plan} = \left\lceil \text{Straight sections before waste} \times \left(1+\frac{\text{Waste allowance}}{100}\right) \right\rceil\)

The difference between those values is reported as Straight-section waste allowance.

Waste is useful for normal cutting, route adjustments, damaged material, and field trim pieces. The percentage should reflect project conditions rather than being treated as a fixed installation rule. Long continuous tray runs with standardized dimensions may need less allowance than congested work with multiple offsets, equipment connections, and field changes.

Takeoff Inputs

FieldElectrical takeoff purpose
Route labelIdentifies the tray run in the material schedule, such as a main feeder route or branch route
Route length (ft)Installed linear distance of the tray route before purchasing waste is applied
Stock section length (ft)Available nominal straight-section length used to round the route into purchasable sections
Fitting count (fittings)Entered quantity of elbows, tees, crosses, reducers, risers, drops, or other catalog fittings already selected for the route
Splice joint count (joints)Entered quantity of joints requiring splice hardware
Cover length (ft)Linear cover length required on the route
Partition length (ft)Linear divider or partition length required within the tray
Support count (supports)Entered quantity of tray supports, trapezes, wall brackets, cantilever brackets, or other support assemblies
Splice plates per joint (plates)Hardware multiplier used to calculate total splice plate quantity
Length and section waste allowance (%)Percentage added to straight tray sections and length-based covers or partitions

The calculator sums entered Fitting count (fittings), Splice joint count (joints), and Support count (supports) across all route rows. Those entered counts are not derived from route length or stock-section length.

Splice Hardware, Covers, and Partitions

Splice plate quantity is calculated directly from the entered joint count:

\(\displaystyle \text{Splice plate count} = \text{Splice joint count} \times \text{Splice plates per joint}\)

For covers and partitions, the calculator applies the same entered length allowance and rounds the result upward to whole feet:

\(\displaystyle \text{Cover length to plan} = \left\lceil \text{Total cover length} \times \left(1+\frac{\text{Waste allowance}}{100}\right) \right\rceil\)

\(\displaystyle \text{Partition length to plan} = \left\lceil \text{Total partition length} \times \left(1+\frac{\text{Waste allowance}}{100}\right) \right\rceil\)

This approach treats covers and partitions as length-based material. It does not convert those lengths into manufacturer-specific cover section counts, partition kits, fasteners, clamps, or package quantities.

Calculation Example

Assume two known cable tray routes with Splice plates per joint (plates) set to 2 and Length and section waste allowance (%) set to 5%.

InputMain routeBranch route
Route labelMain routeBranch route
Route length (ft)120 ft75 ft
Stock section length (ft)10 ft12 ft
Fitting count (fittings)21
Splice joint count (joints)115
Cover length (ft)60 ft20 ft
Partition length (ft)40 ft0 ft
Support count (supports)85

The straight-section calculation is:

\(\displaystyle \left\lceil \frac{120}{10} \right\rceil = 12 \text{ sections}\)

\(\displaystyle \left\lceil \frac{75}{12} \right\rceil = 7 \text{ sections}\)

\(\displaystyle 12 + 7 = 19 \text{ straight sections before waste}\)

Applying the 5% allowance:

\(\displaystyle \left\lceil 19 \times 1.05 \right\rceil = 20 \text{ straight sections to plan}\)

The resulting takeoff is:

ResultQuantity
Total route length195 ft
Straight sections before waste19 sections
Straight sections to plan20 sections
Straight-section waste allowance1 section
Fitting count3 fittings
Splice joint count16 joints
Splice plate count32 plates
Cover length to plan84 ft
Partition length to plan42 ft
Support count13 supports
Counted route rows2 rows

The 84 ft cover quantity comes from 80 ft of entered Cover length (ft) plus 5% allowance, rounded up:

\(\displaystyle \left\lceil 80 \times 1.05 \right\rceil = 84 \text{ ft}\)

The 42 ft partition quantity comes from 40 ft of entered Partition length (ft) plus 5% allowance, rounded up:

\(\displaystyle \left\lceil 40 \times 1.05 \right\rceil = 42 \text{ ft}\)

Field Verification

The takeoff is a planning schedule based on known route data. Verify the selected tray series, tray width and depth, material type, finish, fitting geometry, splice hardware, cover compatibility, partition system, support configuration, project drawings, stock lengths, and supplier procurement units separately.

Confirm that the installed tray system is suitable for the actual cable installation, including feeder and branch-circuit conductor quantities, AWG or kcmil conductor sizes, conductor weight, cable tray fill, cable separation requirements, equipment grounding conductor arrangement, thermal conditions, and future capacity. Support locations and support count must also be coordinated with the selected tray system, fitting locations, structural attachment points, loading requirements, manufacturer instructions, project specifications, and AHJ requirements.

FAQs

Does this create a bill of materials from drawings?

No. Enter route rows and known accessory quantities. Drawing measurement, fitting identification, product selection, and procurement review remain separate.

How are straight sections rounded?

Each route is divided by its entered stock section length and rounded up. The waste allowance can add more sections for planning.

Does it calculate support spacing?

No. Enter support quantities from the project layout or schedule. Structural loading and support spacing need the selected tray system and engineering review.