Share

Applying and Editing Formulas

Product Documentation
Intermediate

Apply or edit a pay item formula by clicking in the Formula cell in any pay item entry in the pay item list.

Use the functions, constants and logical operators in the Pay Item Formula dialog box to create or edit a formula.

You open the Pay Item Formula dialog box, from either the QTO Manager vista or the Pay Item List dialog box, by clicking in the Formula cell for any pay item for which you want to apply or edit a formula.

Corridor objects only recognize formulas entered through the QTO Manager.

To create a formula for a pay item

  1. Open a drawing in which pay items are attached to objects.
  2. Select an object with one or more pay items attached.
  3. Click Analyze tabQTO panelQTO Manager.At the Command prompt, enter QTOManager.
  4. In the QTO Manager vista, click in the Formula cell of a pay item attached to the object you selected.
  5. If a warning dialog box opens (meaning there is no formula file for the drawing), click Specify Pay Item Formula File.
  6. In the Select A Quantity Takeoff Formula File dialog box:
    • Navigate to the folder in which the current drawing is saved.
    • For File Name, enter a unique name for the takeoff formula file.
    • Click Save.
  7. In the Pay Item Formula dialog box:
    • To define additional parameters, click Edit Parameters to display the Pay Item Formula Parameters Dialog Box.
    • Click , and select either Item Area, Item Count, Item Length, Part Depth, or other user-defined parameter (as appropriate to the pay item). Your selection is inserted into the Expression field.
    • Use the keyboard or the numeric and logical operator keys, and functions from the list in the dialog box, to complete the formula.
    • Click OK to apply the formula.

      is displayed in the Formula cell of the selected pay item in the QTO Manager.

To edit or remove a pay item formula

  1. Open a drawing in which formulas have been created for pay items.
  2. Click Analyze tabQTO panelQTO Manager.At the Command prompt, enter QTOManager.
  3. In the QTO Manager vista, click Turn Off Categorization.
  4. Use the filter or scroll down through the pay item list to find the pay item whose formula you want to edit.
  5. In the Formula cell of the pay item, click .
  6. In the Pay Item Formula dialog box:
    • Modify the formula in the Expression field.
    • Alternately, delete the formula from the Expression field.
    • Click OK.

Ribbon

Analyze tab QTO panel QTO Manager

Command

QTOManager

Dialog Boxes


Was this information helpful?