Coming soon · Excel workbook
Groundworks Materials Calculator v1.1
Work out the materials before you order. Type in your measurements and your supplier's figures, and the workbook turns them into a materials list.
What it works out
Metric units, plain UK English, one row per run or area.
Drainage
Straight runs in a rectangular trench: pipes per run rounded up to whole supplied lengths, trench excavation, granular bed and surround with the pipe's own volume deducted, and backfill.
Concrete
Rectangular slabs, bases, strips and pads: net m³ and order m³ with your waste %, optional rounding to your supplier's order step, optional bag count and optional sub-base.
Slabbing
Net area, area with your cutting/waste %, slabs to order, whole packs or pallets per product, and laying bed and sub-base volumes.
Monoblock / block paving
Blocks to order, whole pallets or packs per product, and laying course and sub-base volumes. Jointing sand bags if you enter the coverage per bag.
Hardcore, sand and gravel
Volumes from every tab added up per material in m³. Tonnes and bags appear when you enter your supplier's density and bag size.
Pallets rounded up
Blocks and slabs are rounded up to whole pallets or packs per product, using the pack sizes you enter.
Your supplier's figures, not ours
There's no built-in density, bag yield or "standard" rate. You enter your supplier's density, bag sizes, pack and pallet quantities and coverage. Leave a rate blank and the workbook shows the volume and asks for the rate instead of guessing.
Clear warnings
Input checks flag missing, negative and non-numeric entries, a trench too shallow or narrow for the pipe, an unknown product, and some common unit mistakes, such as a length typed in millimetres where metres are expected. They can't catch every wrong entry, so check your inputs. Flagged rows stay out of the totals until fixed.
Quantities only, not prices or design
This is a quantity estimator. It doesn't price your job or design anything: no pipe sizing or falls, concrete mix or reinforcement, foundation or sub-base thickness, or cutting plans. Take those from your drawings, specification, designer or supplier.
Not included: chambers, gullies and fittings; trench support, over-dig and dewatering; spoil bulking and disposal; formwork, reinforcement and DPM; kerbs and edgings; curved or irregular shapes; and prices. Always check quantities against the drawings, site measurements and supplier data before ordering.
In the download
- Blank master workbook (.xlsx, no macros)
- Filled-in worked example with illustrative figures
- Two-page PDF quick-start guide
- Single-business licence
Built as a macro-free .xlsx using standard functions, for Microsoft Excel 2010 or later. Full compatibility notes will be on the Payhip listing.