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

Paste and copy

Paste rows from an Excel sheet into a bill, or start from a BoQ of a past project.

Two quick ways to fill a BoQ without a full import: paste a block of rows copied in Excel, or copy the bills and items of a BoQ the firm has done before.

Paste into the editor

Open the bill in the editor, click anywhere in the grid and press Ctrl+V. Rows copied from Excel (cells separated by tabs) are added at the end of the open bill and the message Rows pasted from Excel. confirms it. Plain text without tabs is pasted into the cell as usual.

Paste from Excel window

  1. 1In Excel select the rows, with the columns in the order Ref, Description, Unit, Quantity, Rate. Ref may be left out. Copy them.
  2. 2On Details press Paste from Excel.
  3. 3In Into bill choose the bill, or leave it empty and type New bill No. and New bill title. A new number that already exists in the BoQ uses that bill.
  4. 4Paste in the box. The line under it says how many items and headings were read and their total, before anything is added.
  5. 5Press Add the Rows.

How pasted rows are read

Cells in the rowRead as
5 or moreRef, Description, Unit, Quantity, Rate (an Amount after them is ignored: amounts are worked out)
4Description, Unit, Quantity, Rate
3Description, Unit, Quantity
2Ref, Description (a heading)
1A heading
  • A row with a description but no quantity, rate or unit becomes a heading / note; every other row a measured item.
  • A first row of column titles (Qty, Rate) is skipped.
  • Units are recognised as everywhere else: sq.m is m2, nr is No. A new unit is added to the list.
  • Numbers may be written 1,800,000 or 12,500/=.
  • A row with no description, a quantity or rate that is not a number, or a value below zero is named by its row number, and nothing at all is added until it is fixed.
  • Pasted items without a reference get the next free letters of the bill. Press Renumber after to put them in order.
ExamplePaste into a new bill 5 Finishes
Cement sand screed, 120 m2 x 12,0001,440,000
Ceramic floor tiles, 95.5 m2 x 45,0004,297,500
Skirting, 80 m x 8,000640,000
Bill 5 total6,377,500

Copy from Another Project

  1. 1On the new BoQ's Details press Copy from Another Project.
  2. 2In Copy from choose the earlier BoQ: any BoQ of the firm. The window shows Items in it and Its total.
  3. 3Leave Keep the rates ticked to keep its rates (and its library rate links), or untick it to price again.
  4. 4Leave Keep the quantities unticked to measure the new building afresh.
  5. 5Press Copy the Items and confirm.
  • Bills are matched by number: a bill with the same number gets the items added at its end; others are made with their number and title.
  • Every line comes across with its type, reference, description, unit and notes.
  • Provisional Sums, Prime Cost Sums and Contingencies keep their quantity even when quantities are not kept, so their sums stay.
  • A % addition stays on the copy of the line it was added to.
  • Measurement sheets are not copied. The old project is not changed.
  • The BoQ's history notes how many items were copied, from which BoQ, and whether rates and quantities were kept.

Tip

A new contract can start this way in one step: when you create a contract from the start window, choose to copy a past BoQ or to import one from Excel (see Contracts).

Good to know

Paste and copy work only on a BoQ in Draft or Tender, for QS staff.

← PreviousHow the import reads a fileNext →Rates and build-ups

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

On this page

  • Paste into the editor
  • Paste from Excel window
  • How pasted rows are read
  • Copy from Another Project