Your Cart
Loading

Groundworks Materials Calculator – Excel workbook for drainage, concrete, slabbing, monoblock and aggregates

On Sale
£14.99
£14.99
Added to cart

Built for groundworks and landscaping firms. Metric units, plain UK English, one row per run or area.


WHAT IT WORKS OUT

Drainage (straight runs, 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 if you enter the bag maker's litres per bag. Optional sub-base.

Slabbing: net area, area with your cutting/waste %, slabs to order, whole packs/pallets per product, laying bed and sub-base volumes.

Monoblock / block paving: blocks to order, whole pallets/packs per product, laying course and sub-base volumes. Jointing sand bags appear only if you enter the supplier's coverage per bag.

Hardcore, sand and gravel from the job tabs: volumes from drainage, concrete, slabbing and monoblock are added per material. Tonnes and bags (kg or m³ bags) appear when you enter your supplier's density and bag size.

New in v1.2 – Aggregates tab: a standalone calculator for sand, gravel, Type 1, ballast, pea shingle, topsoil, hardcore, concrete and any material you add. Type in length × width or a measured area, plus depth, and it gives net and order m³, tonnes, bulk bags and 25 kg bags. Concrete can also show a bagged-mix count from your litres-per-bag yield. Optional £/t column for a rough cost estimate (not a quote).


YOUR SUPPLIER'S FIGURES, NOT OURS

On Supplier Rates there is no built-in density, bag yield or standard rate. You type in the supplier's density (and whether it is compacted or loose), any loose-volume factor, 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. The Aggregates tab includes typical starter densities (UK industry rules of thumb) so you can get a first figure quickly – edit them to your supplier's data before ordering. Waste and allowance percentages are your own choice for each area or material.


CLEAR WARNINGS

Input checks flag missing, negative and non-numeric entries, a trench too shallow or too narrow for the pipe, an unknown product, and some common unit mistakes (for example a length typed in millimetres where metres are expected). These are plausibility checks with set input limits – lengths and widths up to 1000 m per row, pipe lengths up to 12 m, whole numbers for units per pallet/pack – not design rules, and they cannot catch every wrong entry, so check your inputs. Flagged rows are kept out of the totals until fixed. A status panel on the summary shows how many rows need attention.


The summary banner tells you separately whether your measured quantities are complete and whether any tonnes/bags conversions are still waiting for a supplier rate. Review any Enter supplier density or Enter loose factor prompts before ordering by weight or by the bag.


SCOPE AND EXCLUSIONS

This is a quantity estimator. Estimates only – check with your supplier, and against the drawings and site measurements, before you order. It does not design drainage, choose pipe sizes or bedding, set falls, choose a concrete mix or specification, design reinforcement, foundations or sub-base thickness, or produce a cutting/laying plan. Take those from your drawings, specification, designer or supplier. Not calculated by this workbook: chambers, gullies, fittings, bends, junctions and branches; trench support, battered or stepped trenches, over-dig and dewatering; spoil bulking or disposal; formwork, reinforcement and DPM; kerbs and edge restraints; curved or irregular shapes (other than user-entered measured paving areas); and prices (the optional Aggregates cost column is an estimate from a £/t you type, not a quote). Measure and calculate excluded items separately. Typical densities on the Aggregates tab are starter figures, not supplier quotes. Always check quantities against the drawings, site measurements and supplier data before ordering.


WHAT'S INCLUDED

Groundworks_Materials_Calculator_v1.2.xlsx – blank master workbook (Start Here, Supplier Rates, Paving Products, Drainage, Concrete, Slabbing, Monoblock, Aggregates, Materials Summary)

Groundworks_Materials_Calculator_v1.2_WORKED_EXAMPLE.xlsx – filled-in example with illustrative figures (not supplier data)

Groundworks_Materials_Calculator_v1.2_Quick_Start_Guide.pdf – 3-page guide covering the steps, formula methods and exclusions

LICENCE.txt

Capacity: 15 rows per trade tab, 10 rows on the Aggregates tab, 15 aggregate materials on Supplier Rates, 10 concrete products, 10 slab products and 10 block products.


COMPATIBILITY

Macro-free .xlsx. It uses standard functions only (no dynamic arrays) and is intended for Microsoft Excel 2010 or later. Calculations have been tested in LibreOffice Calc 25.2 and checked with a second, open-source formula engine. It has not been tested in Microsoft Excel, Apple Numbers, Google Sheets or mobile apps, which may handle drop-downs, sheet protection or printing differently. Sheets are protected without a password, so you can unprotect them to edit.


LICENCE

Single-business licence. The buying business may use, edit and print the workbook and guide for its own jobs, and share completed job outputs with its clients and project team. No reselling, redistributing, sublicensing or uploading the blank files (or modified versions) to other businesses or template sites. Each separate business needs its own licence. Your statutory rights are not affected.


DELIVERY

Instant digital download (ZIP).

You will get a ZIP (218KB) file