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

Export to Excel

The BoQ as a workbook with live formulas, priced or for tender, that reads back into HodariQ unchanged.

The export writes the BoQ to an Excel workbook in which every amount and total is a formula. The client can audit the arithmetic, and in the tender version a tenderer types rates and sees Excel add them up.

Export

  1. 1Open the BoQ's Details.
  2. 2In the gear menu choose Export to Excel.
  3. 3Under Version choose Priced or Unpriced, for tender (rates blank, formulas kept).
  4. 4Press Download. The file is BoQ (name).xlsx, or BoQ (name) (for tender).xlsx.

The workbook

SheetContents
Bill 2, Bill 3...One sheet per bill. At the top the firm, the contract title and BILL No. 2 - Substructure; then the columns Item, Description, Unit, Qty, Rate, Amount TZS. Then a COLLECTION block and the Total of Bill No. 2 carried to Grand Summary.
Grand SummaryEach bill with its amount, linked to that bill's sheet; Sub-total; Add VAT 18%; Total carried to Form of Tender.

The formulas

CellFormula
Amount of an item (and of a lump sum)Qty x Rate of the same row
Amount of a % additionAmount of the line it is added to x the % / 100
Each Collection rowSUM of the amounts of one section (or of the whole bill when it has no sections; lines above the first section are totalled under the bill title)
Bill totalThe Collection rows added up
Grand Summary amountA link to the bill total on its sheet
Sub-totalSUM of the bill amounts
VATROUND(Sub-total x VAT % / 100, 0): whole shillings
Total carried to Form of TenderSub-total + VAT

In the unpriced version, the rates of items and the % of % additions are blank, while the Provisional Sums, PC Sums and Contingencies keep their rate, as on the tender print. The formulas are all there, so the totals fill in as the tenderer types.

Layout

  • Calibri 10, black on white, every cell bordered, whole shillings, zero shown blank.
  • A4, fitted to the page width, the column titles repeated on every printed page and frozen on screen, the contract number, page number and sheet name in the footer.
  • A sheet name that would be too long or used twice is shortened or numbered, as Excel requires.

Back into HodariQ

Each bill sheet is written so that the import reads it back: a BILL No. row, a title row, the lines, and a COLLECTION block that the import skips. A hidden column G holds the line type in words (Measured item, Prime Cost Sum, % addition...), which the import reads, so an exported file comes back exactly as it left. This is how a tenderer's priced copy of your tender export is read into the tender analysis (see Tenders).

Good to know

Excel does not lock anything: a tenderer can change a quantity or a fixed sum in the file. The tender analysis reads only the rates (and the amounts written) and prices every line on your quantities: a changed quantity shows up as an arithmetic error on that line, and a changed fixed sum is ignored, the QS's sum being kept.

← PreviousPrint the BoQNext →Tender, lock and revise

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

On this page

  • Export
  • The workbook
  • The formulas
  • Layout
  • Back into HodariQ