1Project details
2Works, items & measurements
Quantity = F × No. × % × L × B × H (blank boxes are skipped). Tick Deduct for openings (F = −1). Use + Heading for location lines like “Fish market”.
Faster entry: Enter moves to the next box and makes a new row at the end · an empty box shows the value from the row above in grey, press = or double-click to take it · ⧉ copies a whole row · paste rows straight from Excel (Particulars, No., %, L, B, H).
3Bill of quantity & charges
Charges on the Summary sheet
Each charge is worked on the last Total line, unless set to “on works total”. Tick Total after to print a Total line under it.