Exercise 6: Working with Pay Item Formulas

In this exercise, you will build a mathematical formula that applies a pay item to a corridor at a specified interval.

In the example used in this exercise, the pay item formula adds recessed pavement markers at 10-foot intervals along the corridor. Similar applications of this formula include lane striping and quantity of posts along a guardrail or fence.

Formulas can also be used to convert pay item quantities from one unit of measure to another. For example, you could create a formula that converts square yards of a given pay item to tonnage.

Pay item formulas, label expressions, and design checks are created in a similar manner. However, unlike label expressions and design checks, pay item formulas are not saved in the current drawing. You will learn how to save and manage pay item formula files in this exercise.

This exercise continues from Exercise 5: Working with Quantity Reports.

Create a pay item formula

  1. Open Quantities-6.dwg, which is located in the tutorials drawings folder.

    This drawing contains a commercial site, which consists of a building footprint, a parking lot, and access roads.

  2. In the drawing, select the side road corridor. Click Corridor tab Modify panel Corridor Properties drop-down Corridor Properties.
  3. In the Corridor Properties dialog box, on the Feature Lines tab, in the Crown row, click .
  4. In the Pay Item List dialog box, expand the Favorites category.
  5. In the Favorites category, select Pay Item ID63407-0000.
  6. In the Pay Item ID number 63407-0000 row, click the Formula cell.

    You are notified that pay item formulas must be written to an external file. After the formula file has been saved, it remains associated with the current drawing. Other formulas that you write in the current drawing will be saved to the same formula file.

  7. Click OK.
  8. In the Specify A Quantity Takeoff Formula File dialog box, navigate to the My Civil 3D Tutorial Data folder.
    BestPractice:

    Save the pay item formula file in the same location as either the drawing with which it is used, or the master pay item list. If you send the drawing to another user, you must also send the formula file.

  9. For File Name, enter Tutorial_QTO_Pay-Item-Formulas.for. Click Save.
  10. In the Pay Item Formula dialog box, click . Click TRUNC.
  11. Click . Click Item Length.
  12. Using either your keyboard or the buttons on the QTO Pay Item Formula dialog box, enter /10)+1 in the Expression field.

    When you are finished, the formula in the Expression field should look like this:

    TRUNC({Item Length}/10)+1

    This formula truncates the feature line length to an integer value, and then divides it by ten. The resulting value is used as the pay item count for the recessed pavement marker. If there is a remainder from dividing the feature line length by ten, then one recessed pavement marker is added to the sum.

  13. Click OK.

    In the Pay Item List dialog box, in the Pay Item ID number 63407-0000 row, a is displayed in the Formula cell. This indicates that a formula has been added to this pay item.

  14. Click OK twice.

Generate a detailed quantity takeoff report

  1. Click Analyze tab QTO panel QTO Manager.
  2. In the QTO Manager vista, in the Favorites category, select the Pay Item ID63407-0000 row.
  3. Click Analyze tab QTO panel Takeoff.
  4. In the Compute Quantity Takeoff dialog box, specify the following parameters:
    • Report Type: Detailed
    • Report Extents: Drawing
    • Limit Extents to Alignment Station Range: Selected
    • Alignment: Side Road
    • Report Selected Pay Items Only: Selected
    • Report Station And Offset Relative To: Side Road
  5. Click Compute.
  6. In the Quantity Takeoff Report dialog box, in the drop-down menu, select Detailed Count (HTML).xsl

    Scroll through the report and examine the Recessed Pavement Marker pay items. The alignment is 1090 feet long. The formula you created divided the alignment length by ten, which resulted in the quantity of 110.

  7. Click Close twice.

Load a different formula file

  1. Click Analyze tab QTO panel QTO Manager.
  2. In the QTO Manager vista, click OpenFormula File.

    Use the Open dialog box to navigate to an existing pay item formula file. You can have several formula files available, and switch between them as needed.

  3. Click Cancel.

To continue this tutorial, go to Exercise 7: Creating a Pay Item List.

Parent topic: Tutorial: Calculating and Reporting Quantities