Your bill, live in Excel

Model in AgileBOQ. The Bill of Quantities, the Bill of Materials or any custom report builds itself in your Excel workbook and follows every change, with real formulas, your notes and your own columns kept in place.

How it works

Three steps, then you just model.

1

Save to the cloud

Projects saved to the cloud in AgileBOQ are live in Excel straight away. Nothing to send.

2

Pick the report

In Excel, open AgileBOQ Live, sign in with the same account, choose the project and the bill, the materials or a custom report.

3

Model, Excel follows

Quantities update a few seconds after each change. Changed cells are highlighted and the panel lists what changed.

Install the add-in

One time per computer or per team. Choose where you use Excel.

  1. Download the add-in file (AgileBOQ-Live.xml).
  2. Open a workbook in Excel for the web (office.com).
  3. Go to Home › Add-ins › More add-ins, open the My add-ins tab and click Upload my add-in.
  4. Choose the file you downloaded and click Upload. AgileBOQ Live appears on the Home tab.

Good to know

What does AgileBOQ write, and what is mine?

AgileBOQ fills columns A to F: item, description, unit, quantity, rate and amount, with totals, preliminaries and VAT as Excel formulas. Column G is for your notes, and any columns from J onwards are yours. When the bill changes, they move with their items.

Can I change rates in Excel?

Yes. With “Keep my rates” on, a rate you type in Excel stays, and the amount uses it. Quantities always come from the model, so the bill stays measured.

Does AgileBOQ have to be open?

No. Every cloud project is live in Excel. The add-in works out the bill and all reports from the saved project itself, and picks up each change a few seconds after it is saved, whoever made it.

Who can connect?

You and anyone you share the project with. People with view-only access can build the sheet; the owner and editors send the updates.

Is my data safe?

You sign in with your own AgileBOQ account inside Excel. The add-in only reads the projects your account can open, and the bill travels over an encrypted connection.