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
- 1In Excel select the rows, with the columns in the order Ref, Description, Unit, Quantity, Rate. Ref may be left out. Copy them.
- 2On Details press Paste from Excel.
- 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.
- 4Paste in the box. The line under it says how many items and headings were read and their total, before anything is added.
- 5Press Add the Rows.
How pasted rows are read
| Cells in the row | Read as |
|---|---|
| 5 or more | Ref, Description, Unit, Quantity, Rate (an Amount after them is ignored: amounts are worked out) |
| 4 | Description, Unit, Quantity, Rate |
| 3 | Description, Unit, Quantity |
| 2 | Ref, Description (a heading) |
| 1 | A 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.
Copy from Another Project
- 1On the new BoQ's Details press Copy from Another Project.
- 2In Copy from choose the earlier BoQ: any BoQ of the firm. The window shows Items in it and Its total.
- 3Leave Keep the rates ticked to keep its rates (and its library rate links), or untick it to price again.
- 4Leave Keep the quantities unticked to measure the new building afresh.
- 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.
Something unclear? Ask us on WhatsApp: we answer the same day.