HodariQ
Ctrl K
Back to siteBook a demo

Getting started

  • How HodariQ works
  • Set up your firm
  • Country, currency and dates
  • Users and roles
  • Approvals
  • Sending documents: e-mail and WhatsApp
  • The change log
  • Plans and limits
  • Features and switches
  • What must come first

Contracts

  • Create a contract
  • Commercial terms
  • Key dates and contract states
  • The contract workspace
  • Programme of works
  • Parties
  • Completion and closing
  • Consultant or contractor firm

Bills of Quantities

  • Build a BoQ
  • Lines, sums and totals
  • Units
  • Measurement sheets
  • Import from Excel
  • How the import reads a file
  • Paste and copy
  • Rates and build-ups
  • Price list, regions and the Price Book
  • Print the BoQ
  • Export to Excel
  • Tender, lock and revise
  • Compare revisions

Take-off

  • Start a take-off
  • The screen, keyboard and tablet
  • The scale
  • Lengths, areas and counts
  • Rooms: one click or every room
  • Roofs and wall centre lines
  • Doors, windows and symbols
  • Assemblies
  • Heights from sections
  • Zones
  • Send to the BoQ
  • Print the take-off
  • Check a take-off
  • Revised drawings
  • Revision to a variation order
  • Queries to the architect
  • Quick Measure

Tenders

  • Tender analysis
  • Tenderers and their rates
  • Checks and ranking
  • Award and the tender report

Variations

  • Variation orders
  • Pricing VO lines
  • Approving a variation order
  • VO from revised quantities
  • The VO document and the register
  • Extensions of time

Valuations and certificates

  • The monthly valuation
  • How the certificate is worked out
  • Retention and its release
  • Advance payment and its recovery
  • Liquidated damages
  • Measurement sheets
  • Submitting, certifying and freezing
  • Claimed and certified
  • Printing certificates

Money

  • Invoices and payments
  • Withholding tax and VAT
  • Who owes what
  • Financial statement
  • Cost control
  • Budget line by line
  • Recording costs
  • LPOs (purchase orders)
  • Suppliers and their prices
  • Schedule of materials
  • Subcontracts
  • Subcontractor certificates
  • Cost plans

Site Portal

  • Add your site team
  • On site: the phone pages
  • The daily report from the phone
  • Chats and photos
  • Notifications on the phone
  • Material requests at the office
  • Who approves, and the settings
  • Daily reports at the office
  • Work done, item by item
  • Who sees what

Inbox and Work

  • How the Inbox works
  • Connect the mailbox
  • How e-mails are sorted, summarised and dated
  • Which contract an e-mail is about
  • Check and approve e-mails
  • My work: reply, notes and Done
  • Alerts, the morning e-mail and the contract

Bids and the NeST scout

  • How bids work
  • Bid or no bid, and the documents
  • Results, the win rate and the contract
  • The NeST scout
  • Bid alerts

Team

  • Team: who has how much work

Registers and alerts

  • Bonds, insurance and documents
  • Alerts
  • The dashboard and the financial statement
  • The contractor portal
Ctrl K
Docs/Bills of Quantities

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

PartWhat it shows
Top barThe 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 headThe bill number and title (type over them to change them), Find a line, Renumber and, for an empty bill, Remove bill.
GridOne row per line: Ref, Description, Type, Unit, Qty / %, Rate, Amount, then a + (insert a line below) and a bin (delete the line).
FootAdd item, Add section and the bill total, e.g. Bill 2 total 15,022,500.

Step by step

  1. 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.
  2. 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.
  3. 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.
  4. 4To put a line between two others, press + at the end of the row above it.
  5. 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.
  6. 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.

← PreviousConsultant or contractor firmNext →Lines, sums and totals

Something unclear? Ask us on WhatsApp: we answer the same day.

On this page

  • Open or start a BoQ
  • The editor screen
  • Step by step
  • What is automatic
  • Rules
  • Quick Measure, Details and Print