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
- 1On the analysis press Read Tenders from Excel.
- 2Under Choose the files pick every tenderer's priced BoQ, one Excel file each (.xlsx, .xlsm or .xls, up to 15 MB each).
- 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.
- 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
- 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.
- 2Save, then press Enter Rates on its row.
- 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.
- 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.
Something unclear? Ask us on WhatsApp: we answer the same day.