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/Valuations and certificates

Measurement sheets

Dimension rows behind a quantity to date, and how they carry over from one valuation to the next.

A measurement sheet (dimension sheet) keeps the rows of measurement behind a quantity, so anyone checking the certificate sees where the figure came from. On a valuation line the sheet gives the quantity to date; on a VO line or a BoQ line it gives the quantity. Measurement sheets are on plans that include them.

Measure a line

  1. 1On the valuation, open Details and the Work Done tab.
  2. 2Press the calculator button at the end of the line (lines valued by quantity only).
  3. 3Add a row for each part measured: Location / description (for example Grid A-B, ground floor), Times, No., Length, Width, Height / depth.
  4. 4Tick Deduct for something to take off, for example a door opening in a wall.
  5. 5The Quantity of each row and the Total are worked out as you type; the total becomes the line's Qty to date.

The formula

Row quantity = times × no. × length × width × height, using only the dimensions filled in (an empty dimension is left out, not taken as 0). A deducted row counts negative. Each row and the total are rounded to 3 decimals. Dimensions cannot be negative: to take a row off, tick Deduct. A line with a measurement sheet is valued by quantity.

ExampleBlockwork 200 mm, IPC No. 3
Grid A-B ground floor: times 2, length 12.000, height 3.00072.000 m2
Door D1 openings, deduct: no. 3, length 0.900, height 2.100(5.670) m2
Qty to date66.330 m2
Value to date at 45,0002,984,850

Carry-over to the next valuation

When the next valuation is made, each line starts with everything the previous certificate had: its method, its quantity or % to date, and every measurement row, copied. Add the rows for the work done since; the new total is the new quantity to date, and the previous value is what was certified.

ExampleThe same line on IPC No. 4
Rows carried from IPC No. 366.330 m2
New row, Grid B-C ground floor: length 10.000, height 3.00030.000 m2
Qty to date: 96.330 m2 at 45,0004,334,850
Previous (IPC No. 3)2,984,850
This period1,350,000

With a contractor whose applications are certified by the employer's QS, the next valuation starts from the figures the employer certified, not from what was applied for.

Locks

  • A valuation's rows can be changed while it is a draft, and again while it is sent to the employer's QS; not once submitted or certified.
  • A VO's rows lock when it is submitted or approved; a BoQ's rows when the BoQ is locked.
  • Excel Progress never overwrites a line that has a measurement sheet: it is kept as measured and listed in the result.

Printing

Measurement Sheets in the Print menu of the valuation prints one block per measured line: its reference, description and unit, every row with its dimensions (times and no. shown only when not 1), deductions in brackets, and the total.

Tip

Measure the whole line to date on the sheet every month, by adding rows, rather than typing a new total over it: the sheet is then the record of how the quantity grew.

← PreviousLiquidated damagesNext →Submitting, certifying and freezing

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

On this page

  • Measure a line
  • The formula
  • Carry-over to the next valuation
  • Locks
  • Printing