Does this choose cable size?

No. It only estimates reel count from entered length and reel assumptions.

Can optional run rows be left blank?

Yes. Blank optional rows are treated as zero so one, two or three runs can be recorded.

Where should reel length come from?

Use the supplier, project procurement or warehouse length that applies to the cable row.

Why show leftover length?

Leftover length helps a reviewer see how much ordered cable remains after the entered runs and waste allowance.

Is this the same as cable cost and quantity?

No. Cable cost and quantity handles material cost rows, while this page focuses on reel count and logistics.

Cable reel count calculator

order length = sum(run lengths) x (1 + waste percent / 100); reel count = ceil(order length / reel length); leftover length = reel count x reel length - order length; reel utilisation = order length / ordered reel length x 100

Run lengths are entered by the user from drawings, takeoff records or site measurements.
Waste allowance is an estimating assumption, not a standards value.
Reel length is entered from supplier or project planning data.
The calculator estimates quantity only and does not select cable size or supplier stock.

Formula variables
Variable	Meaning	Unit	Use
Lrun	Run length total	m	Sum of the entered cable run lengths.
waste	Waste allowance	%	Entered allowance applied to the summed run lengths.
Lorder	Order length	m	Run length total plus waste allowance.
Lreel	Reel length	m	Entered length available per reel.
Nreel	Reel count	reels	Order length divided by reel length, rounded up.
Lleftover	Leftover length	m	Ordered reel length minus order length.
utilisation	Reel utilisation	%	Order length divided by ordered reel length times 100.

Cable reel count calculator technical guide

Estimate cable reel count from entered run lengths, waste allowance and reel length for Australian estimating records.

Use this calculator when the estimating question is how many reels are needed for a cable row. It starts from entered run lengths, applies an entered waste allowance, then rounds the order length up to whole reels using the entered reel length. The result is a procurement worksheet, not a cable-sizing decision.

The page is useful for feeders, submains, final-circuit batches and staged material takeoffs where the run length has already been measured or taken from drawings. It keeps the supplier reel basis visible because a reel-count answer changes quickly when the available length changes.

Cable Reel Use Cases

Cable reel count use cases
Work setting	Useful input	Output to record
Feeder takeoff	Measured route lengths and supplier reel length.	Reel count, order length and leftover length.
Final-circuit batch	Repeated run lengths from a cable schedule.	Whether one reel covers the entered row.
Procurement check	Waste allowance and available reel length.	Ordered length and utilisation percentage.
Site logistics	Long submain runs and handling notes.	Multi-reel review flag before ordering.

A strong reel-count record names the cable row, the length source and the supplier or planning reel length. A weak record only lists a total length without showing how the reel count was derived.

Input Responsibility

Values to confirm before calculating reels
Input	Calculator treatment	Outside the calculator
Cable description	Kept with the result so the reel count is traceable.	Cable selection, current capacity and product suitability.
Run lengths	Summed as entered, with blank optional rows treated as zero.	Drawing accuracy, site measurement and route changes.
Waste allowance	Applied as a percentage to the run-length total.	Contractor estimating policy and project packaging rules.
Reel length	Used as the divisor for whole-reel count.	Supplier stock, delivery, drum handling and cut-length availability.

The calculator does not know whether a long run must be continuous. If a single run cannot be jointed or split, the ordering note must be checked against the actual reel availability before procurement.

Review Workflow

Name the takeoff reference and cable description.
Enter up to three run lengths from the cable schedule, drawings or site measurements.
Enter the waste allowance used by the estimator for that cable row.
Enter the reel length that applies to the supplier, warehouse or project planning basis.
Review the order length, reel count, leftover length and reel utilisation together.
If the result needs multiple reels, check delivery, handling, continuous-run requirements and supplier availability before relying on the row.

This workflow keeps the arithmetic transparent. It does not hide supplier decisions or installation constraints inside the calculator.

Worked Australian Examples

Cable reel examples
Situation	Inputs	Output reading	Practical note
Feeder reels	120 m, 85 m and 42 m with 10% waste on 100 m reels.	271.70 m order length and 3 reels.	Review delivery and leftover length.
Final-circuit reel	52 m with 5% waste on a 100 m reel.	54.60 m order length and 1 reel.	One reel covers the entered quantity.
Long submain row	Long runs with a larger waste allowance.	Multi-reel result.	Confirm whether continuous length is required.

These examples use metric lengths and Australian estimating language. They do not decide cable size, installation method, supplier selection or final ordering rules.

Boundary With Related Tools

Use the cable cost and quantity calculator when the row also needs material cost, GST or material total. Use the cable drum capacity calculator when the question is how much cable can fit on a physical drum geometry. Use the cable quantity estimating guide when the process needs a wider takeoff method and documentation boundary.

Next tool selection
Next question	Use next
Material total and unit cost are needed.	Cable cost and quantity calculator.
Drum geometry limits are being checked.	Cable drum capacity calculator.
Estimating method needs explanation.	Cable quantity estimating guide.
Cable size or voltage drop needs review.	Cable sizing or voltage drop calculator.

Australian Estimating Boundary

Cable reel count is an estimating and procurement worksheet. Site measurements, product data, supplier lengths, delivery constraints, installation method and project requirements can override the result. Do not use the result to decide cable current rating, voltage drop, installation method, jointing acceptability or compliance.

Keep the exported record with the takeoff source and supplier basis. If the source lengths change, recalculate the reel count before ordering.

Stop Points

The cable description does not identify the row being ordered.
Run lengths are not from drawings, site measurement or a controlled takeoff record.
Supplier reel length is unknown.
A long run may require one continuous cable length.
Delivery, lifting, storage or drum handling constraints affect the ordering decision.
The worksheet is being used as a cable-sizing or installation approval decision.

Reference: REEL-1
Cable: 25 mm2 4C+E feeder cable
Run lengths: 120 m + 85 m + 42 m
Reel length: 100 m

Order length271.7 m
Reels3
Leftover28.3 m

Reel count3 reels

271.7 m order length from entered runs and waste.

The estimate spans multiple reels, so delivery, handling and continuous-run requirements need review.

Run lengths are entered takeoff values.
Waste allowance is an estimating assumption.
Supplier reel length is entered by the user.

Reference: REEL-FINAL
Cable: 2.5 mm2 TPS final-circuit cable
Run lengths: 52 m + 0 m
Reel length: 100 m

Order length54.6 m
Reels1
Leftover45.4 m

Reel count1 reels

54.6 m order length from entered runs and waste.

A single reel covers the entered quantity, but supplier availability and project packaging still need confirmation.

Blank optional rows are treated as zero.
The result is a quantity record only.
Cable selection remains separate.