How to Use Quantity Link to Improve Your Takeoffs (2017)

Related Products

Bluebeam® Revu® eXtreme 2017
Microsoft® Excel® (2010 & Above)


Quickly Add Measurement Totals with Quantity Link

The Quantity Link tool helps create accurate bid calculations and improve quantity takeoffs by transferring measurement totals from a local PDF to an Excel spreadsheet in real-time. Since a PDF may contain multiple types of measurement totals, you can use filters to transfer the totals you need and create detailed estimates much faster.

Set Custom Filters for Your Project

Revu’s default filters include Subject, Label, Color, Author, and Layer. But what happens if you want to use a filter that isn’t on the list? For example, say you’re creating a bid proposal for a concrete project, but PSI Strength isn’t a filter option. With Revu, you can create a column in the Markups List and then use it as a custom filter with Quantity Link.

Before continuing, make sure you’ve enabled Quantity Link via the Bluebeam Plugin.

Set Up Quantity Link in Excel

Follow these steps to set up Quantity Link in Excel and add measurement totals:

  1. Open the Excel file you want to link.
  2. Right-click on a cell and go to Quantity Link Bluebeam Revu IconCreate Create Quantity Link Icon.
  3. From the dialog, click Add to select the source PDF(s).
  4. Click OK to add the file(s).
  5. From the Create Link dialog, go to Total and select a measurement type (e.g. length, area, volume) from the dropdown. Use the subsequent dropdowns to add more filters for that Total.

Make a Custom Column in the Markups List

Since Quantity Link filters are based off existing columns in the Markups List, you can make a custom filter by creating a new column in Revu. Follow the steps below to learn how:

  1. Open the source PDF in Revu Revu eXtreme Icon Gray.
  2. Expand the Markups List Revu Markups List Red Icon and select the gear  symbol next to Columns Revu Columns Icon.
  3. Go to the Custom Columns tab and click Add.
  4. From the Add Column dialog, type a name for your custom column. This will be the filter label in Excel.
  5. Under Type, select the measurement type for your new column, then click OK to go back to the Manage Columns dialog.
  6. Click OK. Your new column should appear in the Markups List Revu Markups List Red Icon.
  7. Save (Ctrl+S) your changes to make them part of the source PDF.

Use the Custom Filter in Excel

After a custom column is created in Revu, follow these steps to use it as filter for Quantity Link:

  1. Open the linked Excel file.
  2. Right-click on a cell and go to Quantity Link Bluebeam Revu IconCreate Create Quantity Link Icon.
  3. From the Create Link dialog, select a measurement Total.
  4. In the next dropdown, select your custom filter and click OK. The measurement total will appear in the selected cell.

Editing Filters

While the measurements can change in real-time for Excel, your filtering criteria need to be changed manually. To do this, right-click on a linked cell and select Quantity Link Bluebeam Revu Icon > Manage . Click to highlight a cell name and click Edit. Here, you’ll be able to change the filter for any linked cell, or remove the link altogether.

Related Articles