Free Excel format
Measurement book format in Excel (free download)
Short answer
A measurement book records each measurement against the agreement item number, with number, length, breadth and depth, and the quantity they give. Download the sheet below; quantities and item totals are already in formulas.
Preview
| Date | Item no | Description / location | Nos | L (m) | B (m) | D (m) | Quantity | Unit | Remarks |
|---|---|---|---|---|---|---|---|---|---|
| 20-10-2026 | 1.1 | Footing pits F1 to F20 (example) | 20 | 2.5 | 2.5 | 1.6 | 200 | cum | |
| 20-10-2026 | 1.2 | PCC below footings F1 to F20 (example) | 20 | 2.7 | 2.7 | 0.1 | 14.58 | cum | |
| 20-10-2026 | 2.1 | Footings F1 to F20 (example) | 20 | 2.5 | 2.5 | 0.5 | 62.5 | cum | |
| … | your items |
Example rows from a sample project. Delete them and type your own.
What's inside
- Measurement sheet with Nos × L × B × D quantity formula
- Abstract sheet that totals each item
- 60 blank rows ready to fill
Measure on site, bill in the office: PRIME ERP keeps the MB on the phone and brings each total into the RA bill. Start 14-day free trial
How to fill it
- One row per measurement: date, item number, where it was measured, then the dimensions that apply.
- Record work that will be covered, such as foundations and reinforcement, before it is covered.
- On the Abstract sheet, type each item number once to get its total for the bill.
Questions
What is recorded in a measurement book?
Each measurement of work done: the date, the agreement item number, where it was measured, the count and dimensions, and the quantity they give. The bill is a summary of these entries.
How is the quantity worked out?
Number × length × breadth × depth, leaving out any dimension that does not apply. For an area, leave depth blank; for a running length, leave breadth and depth blank.
What does the Abstract sheet do?
Type an item number and it adds every measurement of that item, so the total can go straight into the RA bill.
Can steel be measured in this format?
Steel is billed by weight, so use the bar bending schedule format, which works out the weight from the diameter and length.