Build a BoQ
The BoQ editor: bills down the left, the lines of one bill as a grid you type like a spreadsheet.
A Bill of Quantities in HodariQ belongs to one contract. It is split into bills (Preliminaries, Substructure, Frame...), each bill holds its lines, and every total works itself out as you type. You build it in the BoQ editor; the full form of the BoQ, with its buttons for tendering, locking and revising, is one click away under Details.
Open or start a BoQ
- From the contract: open the contract's workspace, go to the BoQ tab and click a BoQ. New BoQ at the top of the workspace makes another one; it is offered only while the contract is still a draft and only to QS staff.
- From the menu: Estimating › Bills of Quantities. Clicking a BoQ opens it in the editor. New asks only for the contract, and only contracts not started yet can be chosen: once a contract runs, changes are variation orders.
- A new BoQ is called Bills of Quantities and is dated today. Its name and date can be changed on Details while it is a Draft or Tender.
The editor screen
| Part | What it shows |
|---|---|
| Top bar | The contract, the BoQ name, its status (Draft, Tender, Contract BoQ), the BoQ Total in TZS, and the buttons Quick Measure, Details and Print. While a change is being saved you see Saving. |
| Bills (left) | Every bill with its number, title and total. Click one to open its lines. Add bill is at the foot of the list. |
| Bill head | The bill number and title (type over them to change them), Find a line, Renumber and, for an empty bill, Remove bill. |
| Grid | One row per line: Ref, Description, Type, Unit, Qty / %, Rate, Amount, then a + (insert a line below) and a bin (delete the line). |
| Foot | Add item, Add section and the bill total, e.g. Bill 2 total 15,022,500. |
Step by step
- 1Press Add bill. The new bill takes the next free number (the highest number in the BoQ plus one) and the title New bill. Type its real number and title at the top, e.g. 2 and Substructure.
- 2Press Add section for a heading that groups lines, e.g. EXCAVATION AND EARTHWORK. A section gets its own total on the bill's Collection.
- 3Press Add item. The new line's description is selected, ready to type. Then Tab across: choose the Type, type the Unit, the Qty and the Rate. The Amount and every total update when you leave the cell.
- 4To put a line between two others, press + at the end of the row above it.
- 5Press Enter to go to the same column on the next line, as in a spreadsheet. In the description, Shift+Enter starts a new line of text instead.
- 6Press Renumber when the bill is complete, to give its priced lines the references 2/A, 2/B, 2/C... in order.
Tip
Copy rows in Excel (Ref, Description, Unit, Qty, Rate) and press Ctrl+V anywhere in the grid: they are added at the end of the bill you have open. See Paste and copy.
What is automatic
- References: a priced line saved without a reference gets the next free letter of its bill (2/A, then 2/B). Letters I and O are never used, so they cannot be read as 1 and 0; after Z come AA, AB...
- Renumber gives every priced line of the bill a new reference in grid order and replaces references typed by hand. Sections and headings never get one.
- Units: type the unit as you write it. sq.m becomes m2, cu.m becomes m3, nr becomes No, l.s. becomes LS. A unit the firm does not have yet is added to the unit list (see Units).
- Numbers: 1,800,000 and TZS 1,800,000 and 12,500/= are all read as numbers. Anything else is refused with the message that it is not a number.
- Totals: line amounts, bill totals, section totals on the Collection, the Grand Summary and VAT are worked out again after every change (see Lines, sums and totals).
- Find a line shows only the lines whose reference or description contains every word you type. It hides nothing from the totals.
Rules
- Only QS staff (QS Officer and Senior QS / Manager) can change a BoQ. Accounts and Director users see it read only.
- A BoQ can be changed only while it is a Draft or Tender. A Contract BoQ and a Superseded revision open read only; the grid then shows the figures without input boxes.
- No quantity, rate or % can be below zero. Omissions are made by variation orders, never by negative lines.
- A bill can be removed only when it is empty: delete its lines first.
Quick Measure, Details and Print
Quick Measure works out the quantities of a room, a wall, a strip foundation, a slab, columns or beams from a few sizes and adds them to the measurement sheets of your items (see Measurement sheets). Details opens the BoQ form: the Grand Summary tab (one row per bill, VAT and the total including VAT), Approvals, Notes, the tool buttons (Import from Excel, Paste from Excel, Copy from Another Project, Tender Analysis, Compare Revisions...) and the status buttons. Print in the editor prints the priced BoQ at once; the unpriced tender copy and the Excel file are on Details (see Print the BoQ and Export to Excel).
Good to know
Something cannot be done yet? Getting started › What must come first lists every such message and what to do.
Something unclear? Ask us on WhatsApp: we answer the same day.