Skip to content
CH 22 · Part D: Vendors and pricing

The BOQ formulas, issuing a version, and the Excel export

See where every quantity on the BOQ comes from, check the figures add up, then issue it as a version that cannot change and export the client's copy and your costs to Excel.

Who can do this
JuniorTeam leadProcurementAdmin

In this guide

  1. 01Rules used
  2. 02From the sheets
  3. 03From the schedule and riser
  4. 04Issue and export

Where every quantity comes from

Open Rules used, on the BOQ page, to see every rule this version was made with, and any rule this BOQ did not need. When the riser and the cable schedule give real quantities, the estimating rules are set aside. A line made with its workings has How this was worked out under its description.

On the BOQ Comes from
Cameras, card readers, contacts and locks The approved drawings, one line per type, per floor
CAT6 cable Every run in the cable schedule, plus 10% waste, ordered in whole 305 m boxes
Cabinets, patch panels, cable organisers and switches The riser, once each rack is checked
The backbone between floors The cable schedule, such as 3 links and 54 m

Check the figures add up

Only needed if a figure looks wrong. Open More and click Check the figures add up. It works the version out again from the counts it was made from. Figures match means every figure is what a fresh calculation gives. If they do not match, it lists each one, and tells you to make a new version.

Issue the BOQ

  1. Click Issue BOQ. It asks first: Issue BOQ version 1?
  2. If lines have no price, it tells you how many, and they show as zero. Tick the box to say you understand, or click Go back and add prices.
  3. Click Issue BOQ. The version is issued. Its quantities and rates can no longer be changed, and it cannot go back to a draft. A later change makes a new version, from More, then Make a new version.

On a project split into packages, each package's team issues its own BOQ, and a team lead or admin then clicks Mark ready to join. The project's own team joins the ready packages into one BOQ, and issues that joined BOQ the same way, with Issue BOQ.

Export to Excel

There are two exports, one for the client and one for you. A read-only seat can export too.

  • Export to Excel, at the top of the page, is the client's copy. Every line is at its sell price, with your markup applied, and your company name is at the top. There is no cost, no markup and no vendor anywhere in it, so it can go to the client. A line with no price says To quote.
  • Export costs and margin, under More, is the internal copy, titled Costs and margin: INTERNAL, not for the client. For every line it gives the cost rate, the markup, the sell rate, the cost, sell and margin, and where the cost came from, with the margin as a share of sell at the foot.

On the BOQ by floor tab, Export to Excel downloads BOQ by floor instead: the counts floor by floor, a sheet for each system. See Reading BOQ by floor.

On a project split into packages, the proposal is made from the newest joined BOQ, and the project's own team exports it from Joined BOQ, on the BOQ page, with the same two exports.

Watch it done

Open on YouTube

The same steps, on the sample tender, in 1:28.

TrueQty Academy/CH 22/BOQ formulas, issue and export

Finished this guide?

Mark it done to track your way through the Academy.

Follow along on your own tender. Every guide works the same on a real drawing.

Start free trial