Cable cost and quantity calculator

Use this page when a cable route needs to become a traceable material line before it is copied into an estimate, purchase list, variation record or project worksheet. The calculation is intentionally narrow: it sums the measured route sections, adds spare length per run, multiplies by the number of identical runs, applies the entered waste allowance and converts the resulting metres into a material cost from the entered unit rate.

The useful record is not just "allow cable". A stronger estimating row says, for example, "CBL-1, 16 mm2 4C+E submain cable, 38 m + 6 m + 4 m route, one run, 3 m spare, 10% waste, 56.10 m order quantity at $18.50/m". That record can be checked against drawings, site measurements, supplier data, drum lengths and later electrical design checks without hiding where the quantity came from.

Field use cases

The page is strongest when used before a number is rounded and buried in a quote spreadsheet. Once the route basis is separated from the final price, a reviewer can ask precise questions: which drawing revision was measured, whether the same route really repeats, why the waste allowance was chosen and whether supplier pricing still applies.

Cable takeoff data checklist

The checklist is also a quality filter. If the cable description is not confirmed, the result is only a quantity model. If the unit cost came from an old supplier quote, the cost result should not be treated as current buying evidence. If the route was measured from a preliminary drawing, the export should say that.

Waste and spare length matrix

Spare length and waste are not the same decision. Spare length is usually a deliberate project requirement attached to each run. Waste is a percentage applied to the material base. Combining both into a single unexplained uplift can make the estimate look cleaner while making it harder to defend later.

Drum and reel review matrix

The drum count is a planning signal, not a purchase instruction. Supplier stock, available reel lengths, delivery constraints, lifting access and project requirements can change the procurement decision even when the arithmetic is correct.

Takeoff workflow

1. Identify the cable row from the drawing, schedule, board reference, variation request or site instruction.
2. Record the cable description used by the estimate without treating the description as a sizing decision.
3. Break the route into measured sections that another reviewer can follow.
4. Confirm whether the same measured route repeats across several runs.
5. Enter spare length per run separately from the waste percentage.
6. Enter the waste allowance and keep the reason with the estimate record.
7. Enter the current unit cost per metre and note whether it came from a supplier quote or internal rate sheet.
8. Enter a drum length only when it reflects supplier data or a planning basis worth reviewing.
9. Read order quantity, material cost and drum count together.
10. Stop before treating the result as cable sizing, voltage drop, labour pricing, procurement direction or installation standard review.

This workflow keeps the quantity calculation in its proper role. It turns the measured route into a material row that can be reviewed, priced and exported. It does not decide whether the selected cable is suitable for the load, installation conditions or project requirements.

Worked records

These examples show why cable quantity and material cost belong in one worksheet. A route can be correct but the cost stale. A cost can be current but the route poorly recorded. A drum count can reveal a procurement issue even when the measured length looks reasonable.

Using the result in actual work

The result normally leaves the page as one line in a larger estimating file. In a tender estimate, it can support a material row before labour and margin are added. In a variation, it can show how a route change altered both metres and cost. In a site discussion, it can make the difference between a drawing-based allowance and a measured route visible.

A good cable material row does not try to answer every estimating question. It gives the later estimator, project manager or reviewer enough detail to see what was measured, what was assumed and what still needs confirmation.

Boundary with neighbouring calculations

Keeping this boundary clear prevents one estimating worksheet from becoming a weak all-purpose quoting tool. The page owns material quantity arithmetic. It does not replace design checks, procurement controls or commercial review.

Australian context

Australian cable estimating normally uses metric lengths and AUD material rates, but the final material line depends on the project. Current Australian standards, project specifications, site measurements, supplier data, product data, manufacturer information and competent review can govern how the cable is selected, installed and ordered.

This page does not reproduce controlled standards content, publish cable current ratings or recommend a cable size. It records arithmetic from the values entered by the user so the material row can be reviewed in the proper estimating and electrical documents.

Stop points

• The cable description is not confirmed from the cable schedule, project specification, supplier quote or product basis.
• The route was measured from a preliminary drawing without recording the revision or uncertainty.
• Repeated runs are assumed without checking whether each route is genuinely identical.
• Spare length is hidden inside a waste factor and cannot be reviewed.
• A high waste percentage is used without a reason.
• Unit cost is copied from an expired supplier quote or unrelated cable type.
• The entered drum length is a guess rather than a supplier or planning basis.
• The result is used as a cable-sizing, voltage-drop, labour-cost, procurement or installation standard decision.