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

How the import reads a file

Column titles by key words, bills, page totals, collections, line types and the checks on every row.

BoQs are written in many ways. The import does not need an exact template: it reads the titles by the words inside them, then reads each row by a fixed set of rules, and tells you every place where it had to guess.

How the columns are found

A row is the title row when it names the description and at least two more columns. Each title is cleaned (capitals, brackets and line breaks do not matter) and read by its key words. A long sentence is never taken as a title, so a description in the data cannot be mistaken for one.

ColumnTitles that name it (examples)
DescriptionDescription, DESCRIPTION OF WORKS, Item description, Particulars, Details, Works
QuantityQty, Qnty, Qtty, Quantity, Quantities, Quant
RateRate, Rates, Unit Rate (Tshs), Rate (TZS), Price, Unit price
AmountAmount, Amount (TZS), Total, TZS, Tshs, Shs, KES, UShs
UnitUnit, Units, UOM, U/M, Unit of measure
Item / RefItem, Items, Item No, Item Ref, Item code, Ref, Ref No, Reference, Code, Bill item

The order of the rules matters: a title is tried as a description first, then a quantity, then a rate before an amount (so Unit Rate (Tshs) is the rate, not the amount) and before a unit. A running count (S/No., Sr No, Serial, No.) is used as the reference only when the sheet has no Item or Ref column.

How bills are found

  • A row that starts with BILL No. 2 - SUBSTRUCTURE or ELEMENT NR. 2 - FRAME (BILL, ELEMENT, No., Nr., Number or # in any capitals) starts a new bill with that number and title. If the row has no title, the next text row is taken as the title.
  • Such a row with a figure after it is a bill listed with its total in a collection or summary: it is skipped.
  • A sheet with no bill row takes its bill from the sheet name (Bill 2, Element 2 - Frame).
  • Failing that, numbered sections (SECTION 2 - CONCRETE, PART 3) are taken as the bills, and the message says so. Lettered sections (SECTION A) stay sections inside a bill.
  • Failing all of these, everything goes into Bill 1 named after the sheet, each line is marked, and when more than 25 lines land in one bill a yellow box warns that everything was read into one bill.

Rows that are left out

RowWhat happens
Empty rowsSkipped.
The column titles printed again on a later pageSkipped.
Page totals: Carried to Collection, Carried forward, Brought forward, C/F, B/F, To collection, Page 2, Page total, Total carried, Total of this pageSkipped, and the total written there is checked against the items of its page.
A collection block: COLLECTION, Collections:, Bill Collection, Element summary, BILL No. 2 - COLLECTIONSkipped up to the next bill.
The summary of the whole BoQ: SUMMARY, GRAND SUMMARY, General SummaryReading of that sheet stops: it only lists the bills again.

A heading spaced out letter by letter (C O L L E C T I O N) is read as the word. Every row left out is listed in the message, with its row number, so you can see nothing priced was dropped.

How each remaining row is read

  • A row with a quantity or an amount is a priced line.
  • A text row continues the item above when that item has a reference but no quantity yet: long descriptions over several rows come in as one item.
  • A text row with a reference starts an item whose quantity comes on a later row.
  • Any other text row is a section when it is bold or in capitals (under 90 characters), else a heading / note.
  • Text merged across the reference and description columns is read as the description.

How the type is chosen

When the description (or its section) saysType
Unit %, or Add ... % / Add ... profit with no unit% addition (the % is taken from the quantity column)
AttendanceMeasured item
Contingency, or a Sum line in a contingencies sectionContingency
Prime cost, P.C. sum, or a Sum line in a PC sectionPrime Cost Sum
Provisional sum, or a Sum line in a provisional sectionProvisional Sum
Daywork in the line or its sectionDayworks
Any line of a bill titled Preliminaries or General itemsPreliminaries
Anything elseMeasured item

Figures and the checks on them

  • Numbers written as text are read: 1,800,000, TZS 1,800,000.00, 1 800 000/=. (500) is minus 500; -, -- and nil are empty.
  • An amount with no quantity is a lump sum: quantity 1, the amount as rate and, when no unit is given, unit Sum for the three QS sums or Item otherwise.
  • A quantity and an amount with no rate: the rate is worked out as amount / quantity and the line says Rate worked out from the amount.
  • Quantity x rate that differs from the amount written by more than 1 shilling is marked: Qty x Rate = ... but the sheet says ....
  • A unit word in the quantity column (Item, LS) is read as quantity 1 in that unit. Quantity and unit swapped (Sets | 4) are read the right way round, with a warning.
  • Marked as well: a quantity, rate or amount that is not a number, a unit that is a number, no unit, a negative quantity, an item with no quantity or amount, no description, a % with no sum above it in the bill, and a reference used twice in a bill. Many BoQs start the letters again on each page: a page whose first item is A (or 1) starts afresh and is not a duplicate.
ExampleA page total checked against its items
A Excavation, 120 m3 x 15,0001,800,000
B Hardcore, 40.5 m3 x 45,0001,822,500
C Concrete, 30 m3 x 380,00011,400,000
Items of the page add up to15,022,500
Carried to Collection, as written in the sheet15,202,500
Reported as not matching (difference 180,000)check with the author

Good to know

A page total that does not match is reported, never corrected: it is the sheet's own arithmetic. The lines themselves are imported as quantity x rate.

← PreviousImport from ExcelNext →Paste and copy

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

On this page

  • How the columns are found
  • How bills are found
  • Rows that are left out
  • How each remaining row is read
  • How the type is chosen
  • Figures and the checks on them