Measurement sheets
Dimension rows behind a quantity to date, and how they carry over from one valuation to the next.
A measurement sheet (dimension sheet) keeps the rows of measurement behind a quantity, so anyone checking the certificate sees where the figure came from. On a valuation line the sheet gives the quantity to date; on a VO line or a BoQ line it gives the quantity. Measurement sheets are on plans that include them.
Measure a line
- 1On the valuation, open Details and the Work Done tab.
- 2Press the calculator button at the end of the line (lines valued by quantity only).
- 3Add a row for each part measured: Location / description (for example Grid A-B, ground floor), Times, No., Length, Width, Height / depth.
- 4Tick Deduct for something to take off, for example a door opening in a wall.
- 5The Quantity of each row and the Total are worked out as you type; the total becomes the line's Qty to date.
The formula
Row quantity = times × no. × length × width × height, using only the dimensions filled in (an empty dimension is left out, not taken as 0). A deducted row counts negative. Each row and the total are rounded to 3 decimals. Dimensions cannot be negative: to take a row off, tick Deduct. A line with a measurement sheet is valued by quantity.
Carry-over to the next valuation
When the next valuation is made, each line starts with everything the previous certificate had: its method, its quantity or % to date, and every measurement row, copied. Add the rows for the work done since; the new total is the new quantity to date, and the previous value is what was certified.
With a contractor whose applications are certified by the employer's QS, the next valuation starts from the figures the employer certified, not from what was applied for.
Locks
- A valuation's rows can be changed while it is a draft, and again while it is sent to the employer's QS; not once submitted or certified.
- A VO's rows lock when it is submitted or approved; a BoQ's rows when the BoQ is locked.
- Excel Progress never overwrites a line that has a measurement sheet: it is kept as measured and listed in the result.
Printing
Measurement Sheets in the Print menu of the valuation prints one block per measured line: its reference, description and unit, every row with its dimensions (times and no. shown only when not 1), deductions in brackets, and the total.
Tip
Measure the whole line to date on the sheet every month, by adding rows, rather than typing a new total over it: the sheet is then the record of how the quantity grew.
Something unclear? Ask us on WhatsApp: we answer the same day.