Using Custom Columns for Quantity Takeoffs

There are six different types of Custom Columns available:

Type	Description	Example
Checkmark	Displays a Yes/No checkbox
Choice	Creates a dropdown menu of user-defined selections (optional values tied to choices can be used in formulas)
Date	Applies a formatted, dynamic date field
Formula	Calculates field values with a user-defined equation tied to the content of other columns
Number	Adds a number field that can be used for setting up formulas
Text	Adds a text field (cannot be used as a value for formulas, even if a number is entered)

To help you get started, this tutorial will focus on how to work with the Formula and Choice columns.

When dealing with either of these types of columns, it's important to have the end result in mind before you begin. For example, when preparing to set up a Formula column, think about what your equation is going to require. In the first example below, a generic "Column A" is added to "Column B" to make up "Column C." Before that can work, "Column A" and "Column B" need to exist, and if they don't, they need to be created.

The same principle can be applied to Choice columns as well. In the second example below, we're going to create a Choice column for building materials in order to calculate material cost subtotals, so we will need a list of materials and their base costs.

At a basic level, Custom Column formulas simply perform a mathematical operation on two (or more) columns. For example, you might have a number in a "Column A" and another number in a "Column B". You could then create a "Column C" with a formula that adds those two numbers for you; the sum of "Column A" and "Column B" will automatically be inserted as the value of "Column C."

Before getting started, have a clear idea of what the formula is and what variables are going to be used in the calculation. Some variables are standard (for example, measurements like Length, Area, and Volume), and others can be provided by Custom Columns. However, if a Custom Column is going to be used in a formula, it must be created first, or else it won't be available as a variable when it comes time to define the formula.

In our "Column A" + "Column B" = "Column C" example, "Column A" and "Column B" are Number-type Custom Columns; if one or the other didn't already exist, we'd have to create them before we created "Column C." Then, to set up "Column C," you'd do the following:

1. In the Markups list, click Manage Columns. The Manage Columns dialog box appears.

   

2. Select the Custom Columns tab. Existing Custom Columns (if any) are listed.

   

3. Click Add. The Add Column dialog box appears.

   

4. In the Name field, enter a name for the column (in our example, we entered "Column C").

5. From the Type list, select Formula. The fields available under Options automatically update.

   

6. Click in the Expression field and start typing the first part of your equation (in our example, we started typing "Column A"). As soon as you start typing, a dropdown menu appears with available selections.

   

7. Double-click the first Variable of your equation (in our example, we used "Column A"). It will automatically be added to the Expression field, properly formatted.

8. Enter a valid operator (in our example, we entered "+") after the Variable.

   The valid operators are:

   • Addition (+)
   • Subtraction (-)
   • Multiplication (*)
   • Division (/)
   • Exponential (^)
   • Modulus (%)
   • Negation (-)

9. Start typing the second part of your equation. The same dropdown menu appears. Double-click the second Variable of your equation and it will be added to the Expression field as well. Our example ends up looking like this:

   

10. Click OK. The Add Column dialog box closes, leaving the Manage Columns dialog box. Click OK again. "Column C" is automatically added to the current PDF and its value is the sum of "Column A" and "Column B."

    

One common use of Custom Columns in Revu is to calculate material costs. To do this, you need a Choice-type Custom Column that lists materials and stores their base costs, plus a Formula-type Custom Column for the cost calculation. This example is also going to take advantage of another feature in Revu that automatically filters what choice items you see for a given markup depending on its subject, as you'll see below.

Please note: while we're relying on the ability of a Choice-type Custom Column to store associated numeric values (in this case, the base cost of each material), these columns are quite useful without them. Any time you have a situation in which the value of a field should be one of a finite set of options, a Choice-type Custom Column is a great way to ensure consistency and ease of use.

1. In the Markups list, click Manage Columns. The Manage Columns dialog box opens.

   

2. Select the Custom Columns tab. Existing Custom Columns (if any) are listed.

   

3. The first thing to add is a column to track what building materials are used:

   1. Click Add. The Add Column dialog box opens.

   2. In the Name field, enter a name for the column (for example, "Material").

   3. From the Type list, select Choice. The fields available under Options automatically update.

      

   4. To add a choice item, click Add. The Manage Choice Item dialog box opens.

      

   5. Enter the name of the material in the Item field. This will be the name that users will see when choosing a material, so make it something meaningful and recognizable.

   6. To take advantage of Revu's ability to automatically filter choices for you in the Markups list, enter a Subject that matches the Subject of the markup the material applies to. For example:

      Let's say that we're going to create flooring materials. When we define a floor area with the Area markup, we can give it a Subject (for example, "Flooring") in the Properties tab:

      

      Now, if we also set up our material to have the same subject...

      

      ...Then when we go to choose something from the Material menu for our Flooring markup, we're only going to see Flooring materials.

      

      Note: Choice items that have no Subject will show up for any markup, so technically we would see materials that have a Subject equal to "Flooring" or that have no Subject at all.

      Using this feature, you can create as long a list of materials as you need for your project. Users will always be able to select building materials in the same place (the "Material" column), but the list of choices will be manageable and appropriate to the markup.

   7. Check the Assign Numeric Value box and enter the base cost of the material in the field next to it.

      

   8. Click OK.

   9. To add more materials, repeat steps D through H.

      Note: Choice items can also be imported from a Comma Separated Value (CSV) file, which can be very convenient if you already have a list of materials and costs saved in a CSV file. To import this data, click Import and select the desired CSV file. Note that the file must be saved in the .csv format with its data in the following columns:

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

   10. When you've entered all your materials, click OK to close the Add Column dialog box.

4. Now create a Formula-type Custom Column to calculate the total cost of materials when performing an Area takeoff:

   1. Under the Custom Columns tab in the Manage Columns dialog box, click Add. The Add Column dialog box opens.

   2. In the Name field, enter a name for the column (for example, "Cost").

   3. From the Type list, select Formula. The fields available under Options automatically update.

   4. Click in the Expression field and start typing the first part of the equation. For this calculation, we will be multiplying the standard markup measurement of "Measurement" and our custom "Material" column, but it doesn't matter which one is first, so we'll just start with "Measurement". As soon as you start typing, a dropdown menu appears with likely selections.

   5. Double-click the first Variable of your equation (in our example, "Measurement"). It will automatically be added to the Expression field, properly formatted.

   6. Enter a valid operator (in our example, we entered "*") after the Variable.

      The valid operators are:

      • Addition (+)
      • Subtraction (-)
      • Multiplication (*)
      • Division (/)
      • Exponential (^)
      • Modulus (%)
      • Negation (-)

   7. Start typing the second part of your equation. The same dropdown menu appears. Double-click the second Variable of your equation and it will be added to the Expression field as well. Our example ends up looking like this:

      

      Notice that in this example, since this is a cost calculation, we set the Format to Currency and picked a Currency Symbol. This isn't necessary to make the calculation work, so it's up to you whether you do the same.

   8. Click OK. The Add Column dialog box closes.

5. Click OK on the Manage Columns dialog box. "Material" and "Cost" columns are automatically added to the current PDF. Once a "Material" is selected for a markup, "Cost" is automatically calculated based on the selection.