What is a detailed measurement sheet, or measurement book?
A detailed measurement sheet records how every quantity in a bill was arrived at. Each dimension is scaled off a drawing and tagged to its item and drawing sheet, and openings are deducted as lines of their own, so every quantity can be checked and defended if the bill is disputed.
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.
How does one grid handle linear, area and volume 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.
How are deductions recorded?
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 detailed measurement sheet 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.
What are the common mistakes when measuring quantities?
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 does each column mean?
| 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. Once work is under way, the same measurements support the running account bill you raise for payment and the deviation statement that records changes against the agreement.
Get the quantities from your drawings
The arithmetic in this workbook is the quick part. Reading dimensions off a full drawing set, item by item, is what takes days. Upload your drawings and InstaBOQ measures them for you and abstracts the quantities into this same structure.