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
- Read first
- Video
- 1:28below the steps
In this guide
- 01Rules used
- 02From the sheets
- 03From the schedule and riser
- 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
- Click Issue BOQ. It asks first: Issue BOQ version 1?
- 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.
- 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 YouTubeThe same steps, on the sample tender, in 1:28.
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