Detailed Measurement Sheet in Excel — Free Measurement Book Format
A detailed measurement sheet — the measurement book, in departmental language — is the record of how every quantity in a bill was arrived at. Not the total, but the working: each dimension scaled off a drawing, tagged to the item it belongs to and the sheet it came from, with openings and voids deducted as lines of their own. It is the document that gets read when a final bill is disputed, and the one thing that makes a quantity defensible rather than merely stated.
This workbook does the arithmetic and the bookkeeping so the takeoff is the only part left to you. Item codes come from a dropdown, and picking one fills in the description and the unit — a full specification is written once, on the Item List, and never retyped. Enter Nos, Length, Breadth and Depth and the quantity computes itself.
One grid for 1D, 2D and 3D items
Skirting is measured in running metres, plaster in square metres, brickwork in cubic metres, and most formats make you keep three separate sheets. Here a blank dimension means not applicable, not zero: leave Breadth and Depth blank for a linear item, leave Depth blank for an area item, and the same grid handles all three. A blank cell stays blank and never collapses into a silent zero quantity.
Deductions stay visible
Openings are entered as ordinary lines with Add/Deduct set to Deduct. The line carries a negative net quantity and remains in the sheet, so a checker can see the four door openings and six window openings that came out of the external brickwork. A deduction netted off invisibly inside another line is the same number and a far weaker record.
What is in the workbook
Five tabs: a Read Me, Project Details that feed the page headers, an Item List pre-loaded with common residential items and room to extend, the Measurement Sheet itself, and an Abstract that totals every line by item code and applies your rates.
Common mistakes
Measuring straight into the bill. A quantity typed directly into a BOQ with no measurement behind it cannot be checked, corrected, or defended. It is also the easiest way to double-count a wall.
Netting deductions off mentally. Subtracting the openings in your head and writing the reduced figure loses the audit trail entirely, and the arithmetic is never revisitable.
Leaving the drawing reference blank. It costs two seconds during takeoff and saves an afternoon when a dimension is queried against a revised drawing.
Mixing units mid-sheet. Dimensions here are metres throughout. A single length entered in millimetres produces a quantity a thousand times too large, which is obvious in the abstract and invisible in the line.
Forgetting to delete the worked example. The pale blue rows are there to show how the sheet behaves. Clear them before the sheet becomes a record.
What each column means
| Column | What goes in it |
|---|---|
| Sr | Line number. Measurement lines are numbered continuously, deductions included, so the sheet reads as an audit trail. |
| Item code | Chosen from a dropdown fed by the Item List tab. Picking it fills in the description and the unit — you never retype a specification. |
| Description / location measured | Where on the building this measurement comes from: 'footing type F1, grid A1–A3'. The item description is already handled; this column says which part of the job. |
| Nos | How many identical instances. For an irregular quantity you cannot express in the grid, put the derived figure here, leave the dimensions blank, and write the derivation in Remarks. |
| Length (m) | All dimensions are in metres. Used by linear, area and volume items alike. |
| Breadth (m) | Leave blank for a running-metre item. Blank means 'not applicable' and is treated as 1 in the multiplication — it never becomes a silent zero. |
| Depth or Height (m) | Leave blank for an area item. Same rule: blank is not zero. |
| Quantity | Auto-calculated. Nos × whichever dimensions you filled in, so one-, two- and three-dimensional items live in the same grid. |
| Add / Deduct | Set to Deduct for an opening or a void. The line stays visible and carries a negative quantity rather than being subtracted invisibly somewhere else. |
| Net quantity | Auto-calculated. The signed quantity that the Abstract totals. |
| Unit | Auto-filled from the Item List, so a quantity can never be recorded against a unit the item is not measured in. |
| Drawing ref. | The sheet the dimensions were scaled from. The single most useful column when a quantity is queried three months later. |
| Remarks | Assumptions, derivations for irregular shapes, anything you would otherwise have to explain in a phone call. |
Measured quantities feed the bill. Carry them into the BOQ format in Excel to price the work before it starts.
Frequently asked questions
What is a detailed measurement sheet?
It is the record of how each quantity in a bill was arrived at — every measured dimension, item by item and location by location, with additions and deductions shown separately. A BOQ states that there are 24.52 cubic metres of brickwork; the measurement sheet shows the wall lengths and the openings deducted that produce that figure.
How do you record deductions for doors and windows?
As ordinary measurement lines with the Add/Deduct column set to Deduct. The line carries a negative net quantity and stays visible in the sheet, so anyone checking the takeoff can see what was taken out and why — which is not true of a deduction quietly netted off inside another line.
Can one sheet handle linear, area and volume items?
Yes. Fill Length only for a running-metre item, Length and Breadth for an area item, and all three for a volume item. A blank dimension is treated as not applicable rather than as zero, so the three kinds of item share one grid without a separate sheet for each.
Does the abstract total the quantities automatically?
Yes. The Abstract tab totals every measurement line by item code and carries the result against the description and unit from the Item List. Nothing on the Abstract is typed in except your rates.
What is the difference between a measurement sheet and a BOQ?
The measurement sheet is the working; the BOQ is the result. Measurement produces the quantity, the bill prices it. On a disputed final bill it is the measurement sheet, with its drawing references, that gets read.