scopeeconomics

Estimating Spreadsheet

Edit quantities and resource costs in a working estimate, then save or export the result

Project basis and exclusions

A fictional wastewater pumping station upgrade with a 500 m PE rising main. Quantities and GBP rates are illustrative.

Land, design fees, utility diversions, dewatering, temporary works, preliminaries, overhead, profit, contingency and tax are excluded. Add them where the project requires them.

Top-level NRM2 and CESMM groups are editable review aids. Confirm measurement rules against the specification.

SEWastewater pumping station and PE rising mainEstimating workbook

HomeReview checklist Try a connected rate

CESMM4The same estimate grouped for review. Moving a row between groups does not duplicate its cost.

B1fxNumber or formula

Use =2640/18 or a cell formula such as =E1+G1. C is quantity, E to I are rate components, J is unit rate and K is amount. Calculations use full precision; displayed currency is rounded.

	A	B	C	D	E	F	G	H	I	J	K
Row	Cost group	Description	Quantity	Unit	Labour	Material	Plant	Subcontract	Other	Unit rate	Amount
1										14	£5,880.00
2										24	£4,320.00
3										180	£17,280.00
4										1,220	£17,080.00
5										45	£9,450.00
6										16	£9,600.00
7										51	£25,500.00
8										51	£9,180.00
9										670	£5,360.00
10										36,500	£36,500.00
11										28,500	£28,500.00
12										8,200	£8,200.00
13										41	£6,560.00
Direct cost total											£183,410.00

13 items · GBP

B1 selectedTab between cells · Enter moves down · Alt + arrows move sideways · Paste a range

Cost summary

E Earthworks

£19,800.00

F In situ concrete

£17,280.00

G Concrete ancillaries

£26,530.00

I Pipework: pipes

£25,500.00

Unclassified

£88,940.00

J Pipework: fittings and valves

£5,360.00

Edit cells, enter formulas or paste a range.

Changing currency updates labels only. No exchange rate is applied.Direct costs exclude overhead, profit and contingency unless entered explicitly.

Your draft is saved for this browser. Export a copy, or use an authorised account to save to your estimate collection.