Skip to content

Priced bill of quantities

The trench module measures the job: cubic metres of dig, cubic metres of granular, metres of pipe, spoil to tip. A contractor buys none of those. They buy money, and a quantity with no rate beside it is a document that has to be re-keyed before it is of any use.

BIM workflow & handover ▸ Trench & excavation quantities, then the Priced bill of quantities section.

This is deliberate, and it is not a gap waiting to be filled.

Published schedules (RSMeans, Spon’s, the CESMM and NRM libraries) are licensed. More than that, a rate is regional, dated, and specific to one firm’s plant, labour and haul distance in a way no national average survives. A plausible-looking built-in number would make this tool print a price it cannot stand behind, in a document that goes to a client.

So the shipped schedule has the structure of a bill with every rate blank. Until you price it, the bill says it is unpriced, on every line.

Download the template, fill in the rates, import a schedule. The file is CSV, so it opens in a spreadsheet:

# name: Acme Civils 2026
# source: Framework schedule rev C
# currency: GBP
# units: SI
# spoilDensity: 1.8
code,description,class,rate,minDia,maxDia,byMass
E10,Excavate pipe trench,excavation,18.50,,,
G10,Granular bedding,bedding,32.00,,,
D10,Cart away surplus,disposal,14.00,,,yes
P10,Supply and lay up to 225 mm,pipelaying,42.00,0,225,
P20,Supply and lay 226 to 450 mm,pipelaying,58.00,226,450,

The # lines carry the schedule’s identity, and they round-trip, because a schedule that loses its name and source on import is one whose prices nobody can attribute later.

ClassMeasured inNotes
excavationvolumeIn-situ dig
supportareaTrench face. Measured only for a shored trench
beddingvolumeGranular below the pipe
surroundvolumeGranular around and over it
backfillvolumeOrdinary backfill above the pipe zone
disposalvolume or tonnesSpoil carted off, measured loose
pipelayinglengthNeeds a diameter band

This is most of the design, because these are the failures that still add up.

A missing rate never becomes an amount of zero. The line is listed, the quantity is shown, the amount reads not priced, and the item is left out of the total. The total then calls itself partial and says how many items are priced.

A diameter in no band is never priced by the nearest one. A 1200 mm main costs nothing like a 900 mm one, and rounding it into your top band is the quiet kind of error a tender is lost on. The pipes are listed with the diameters that fell through.

Overlapping bands are reported on import. If 0-300 and 250-600 both exist, a 280 mm pipe would be priced by whichever row came first, and that is not a decision this tool should make on your behalf.

Disposal by the tonne needs a density you state. Spoil density is site-specific and the error is large, so if the schedule prices by mass and states no density, the line says so rather than inventing one.

If your rates are typed per cubic yard, the quantities are converted to cubic yards before the rate is applied, whatever units the model is in, and the bill says so. Diameter bands follow the same rule: millimetres for an SI schedule, inches for a US one.

The bill covers what the trench module measures, and nothing else. Chambers, connections, surface reinstatement, testing and traffic management are all real money and none of them is here. It also carries forward the trench module’s own exclusions: pipes with no ground level are absent from the measurement, so they are absent from the bill.