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/Tenders

Tenderers and their rates

Add the tenderers, type their rates or read their priced BoQs from Excel, all at once or one by one.

Each tenderer added to the analysis gets a copy of every priced line of the tender BoQ, with the quantities of the BoQ and an empty rate. Its rates come from its priced Excel file or are typed.

All the tenders at once

  1. 1On the analysis press Read Tenders from Excel.
  2. 2Under Choose the files pick every tenderer's priced BoQ, one Excel file each (.xlsx, .xlsm or .xls, up to 15 MB each).
  3. 3Press Read the Tenders. Each file is read, every tender re-added and the tenderers ranked. The window lists, per tenderer, how many rates were read, the lines not found and the rows that did not match.
  4. 4Press Close and type each tenderer's Tendered total on the Tenders tab.

The tenderer is found from the file name. The extension is dropped, the name is cut at a spaced dash or a bracket, and the words priced, tender, BoQ, bills of quantities, final, signed and rev... are taken out: Example Builders Ltd - priced BoQ (rev 2).xlsx gives Example Builders Ltd. That party is looked up by name (any capitals), then by a name containing it, and is created as a company if there is none. A tenderer already in the analysis is read again, not added twice. A file that cannot be read is named in the result and the others are still read. The files themselves are not kept after reading.

Tip

Name each file after the tenderer before reading them, as the party is written in HodariQ: the right party is then found without a new one being made.

One tenderer at a time

  1. 1On the Tenders tab add a line and choose the Tenderer. A tenderer can be in an analysis once only, and becomes a contractor in Parties if it was not one.
  2. 2Save, then press Enter Rates on its row.
  3. 3Type the rates in Rate (or the % of a % addition in %), or press Read from Excel, choose the tenderer's file and press Read Rates.
  4. 4Type the Total as tendered, and the Amount as tendered of any line where you want the tenderer's own arithmetic checked (a file fills it from its amount column).

On Enter Rates the lines show Ref, Description, Unit, Quantity, Rate, %, Amount as tendered, Correct amount, From average (%) and Check this rate, with the Corrected total, Arithmetic difference, Arithmetic errors, Rates to check and Rank above them. A fixed sum's rate cannot be typed over. Lines with an arithmetic error are red, rates to check amber.

How a priced file is matched to the BoQ

  • Every sheet is read except those named Summary, Collection, Cover or Contents. On each, the column titles are found as in a BoQ import, and the sheet needs at least a description and a rate column.
  • Each priced row is matched to a line of the tender BoQ by its item reference: the same reference (2/A), or the bill number and the letter (A in Bill 2 is 2/A).
  • A row without a matching reference is matched by its bill number and description (the first 80 characters; spaces and capitals do not matter).
  • Only rows of the kinds tenderers price, with a rate or a %, are taken. Rows for Provisional Sums, PC Sums and Contingencies are ignored: your sums stay.
  • The amount the tenderer wrote on a row becomes Amount as tendered, so its arithmetic is checked.
  • A line of the BoQ not found in the file stays at 0 and is marked to check. The result says how many, and lists up to 30 rows of the file that matched no line.

Good to know

The total as tendered is not read from the file: type it from the form of tender, so the arithmetic difference compares the corrected total with the sum the tenderer signed for.

Tip

Give tenderers the Excel export for tender: its references and bills match the tender BoQ exactly, and every row is matched by reference.

Good to know

A tenderer can be added or removed, and rates changed, only while the analysis is Open. Every change ranks the tenders again at once.

← PreviousTender analysisNext →Checks and ranking

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

On this page

  • All the tenders at once
  • One tenderer at a time
  • How a priced file is matched to the BoQ