Pricing a Bill of Quantities without losing your weekend

Every estimator knows the drill. A client sends through a Bill of Quantities, and what should be a pricing exercise turns into a data-entry marathon: retyping refs, re-keying quantities, and praying you didn't fat-finger a number in row 214.

The pricing isn't the hard part. The shuffling is.

The copy-paste trap

A BoQ arrives as a spreadsheet — someone else's spreadsheet, with its own columns, its own numbering, its own quirks. To price it you copy it into your own template, line by line, then start pricing against rates you keep in yet another file. By the time the structure matches, half your weekend is gone and you haven't priced a thing.

Worse, when you send it back, the client wants it in their format, with their item refs intact. So you shuffle it all back again.

Import once, keep the structure

The fix is to stop retyping. Import the BoQ as-is — CSV or Excel, whatever layout it came in — and let the tool map the columns. Refs, descriptions, units and quantities come across locked, so the structure you price against is exactly the structure you export back.

That does two things:

• You price, you don't transcribe. Every line is already there, waiting for a rate.
• Export is faithful. Because the refs never moved, the priced BoQ goes back in the client's own numbering — no reformatting round-trip.

Price from a library, not from memory

Once the lines are in, pricing should be a matter of pulling from rates you already trust. A rate library means you price the same labour, material and plant items the way you did last job — and when a supplier's price moves, you update it once and refresh every estimate that uses it.

Set wastage and markup per line or in bulk, watch the total move live, and you've got a defensible number instead of a guess.

The point

The weekend wasn't the price of a good estimate. It was the price of moving data around. Take that away and pricing a BoQ is an afternoon — a focused one, spent on the numbers that actually matter.