How to calculate costs with custom columns in the Markups List | Revu 21

Using an older version of Revu?

Applies to:

  • Basics
  • Core
  • Complete

In Revu, users can create custom columns in the Markups List to calculate material costs for quantity takeoffs. This article covers how to create a Choice column that stores materials and their base costs and a Formula column that automates your calculations.

Choice custom columns can store numerical values but are also helpful for standardizing and categorizing your markups. For an overview of custom columns, please see this video.

Create a custom column for materials

Before you can set up a formula to calculate total costs, you’ll need to input the base or unit cost for each material. Follow these steps to get started:

  1. Go to the Markups List.
  2. Select Markups List > Columns > Manage Columns…
  3. In the Manage Columns dialog, select the Custom Columns tab.
  4. To create a custom column, select Add.
    Add Custom Column
  5. In the Add Column dialog, enter a name for the new custom column (ex. Material).
  6. From the Type dropdown, select Choice.
  7. To add a new choice, select Add.
    Add Choice Option
  8. In the Manage Choice Item dialog, enter the name of the material in the Item field. This name will appear in the list of options on the Markups List.
    To further categorize choice options, enter a Subject (ex. Flooring). However, you’ll only be able to select the choice item if measurements and markups on the PDF have a matching Subject in the Properties panel.
  9. Select Assign Numeric Value, and enter the unit or base cost of the material in the numerical field.
    Manage Choice Item
  10. Select OK.

To add more materials manually, select the new choice custom column in Manage Columns… and repeat steps 7 – 10.

Import material choice items

Importing choice items will overwrite any existing choice items you’ve manually added to the custom column.

You can also add choice items to your custom columns by importing them from a spreadsheet saved as a .csv file.

Before importing, ensure that your data is set up as follows:

  • Column A = Item
  • Column B = Subject (optional)
  • Column C = Numeric value (optional)

To import, follow these steps:

  1. Go to Markups List > Columns > Manage Columns…
  2. Double-click the Material custom column, or select Modify.
  3. In the Modify Column dialog, select Import…
    Modify Column Import Choices
  4. Locate the .csv file in the File Explorer, and select Open.

Now all your choice items should appear in the Modify Column dialog.

Create a formula custom column

After you add all necessary materials and their base costs, you can set up a formula custom column to calculate total costs for a takeoff.

  1. Open the Markups List.
  2. Go to Markups List > Columns > Manage Columns…
  3. In the Manage Columns dialog, select the Custom Column tab, and select Add.
  4. In the Add Column dialog, enter a name (for example, Total Cost).
  5. From the Type dropdown, select Formula.
  6. In the Expression field, enter the first variable in the equation. For this example, enter Measurement, and a dropdown list will appear.
    Formula Expression Variable
  7. Double-click the Measurement variable.
  8. Enter a valid operator. For this example, enter * for multiplication.
    • Addition (+)
    • Subtraction (-)
    • Multiplication (*)
    • Division (/)
    • Exponential (^)
    • Modulus (%)
    • Negation (-)
  9. Enter the second part of your formula in the Expression field. For this example, enter Material.
  10. Double-click the Material variable.
  11. For formulas calculating cost, update the Format to currency, and choose the appropriate currency symbol.
    Format Currency
  12. Select OK.
  13. Select OK in the Manage Columns dialog.

Now, whenever a material is selected for a markup, its total cost will be calculated in the new formula column.

Cost Calculation in the Markups List

For more information about how to leverage data in the Markups List, please see Best practices for saving and sharing custom columns.

How-To

Measurement

Markup

Learn how to utilize custom columns in the Markups list to create formulas that calculate material costs for your quantity takeoffs.

Related Articles