PMS Analysis Columns

1.1 Setup PMS Analysis Columns

Prior to configuring or performing any analysis using the system, it is important to define the usage of each variable used in the system, particularly those used in the Network Master table. 

In Pavement Analyst, this configuration is done at the PMS Analysis Column window, located under Pavement Analyst > Utilities > PMS Analysis Columns menu. The system treats each column configured in this window as a variable and will apply the corresponding analysis routine to it.

Summary of  the usage of each PMS Analysis Column is explained as follows.

• Decision Variable — This field determines whether the selected column will be used in developing the treatment decision trees. S
• Class Variable — This field determines whether the selected column will be used in developing the performance model structure.
• Deteriorates — This field determines whether the system will treat the selected column as “performance index” (PI) and apply a performance model to it. Specifically, when selected, the column will appear:
  • In the Condition Attributes drop-down list in the Improvements pane of the Treatments window.
  • In the PMS Analysis Index drop-down list in the Network Analysis window.
  • As columns in the Road Sections pane of the Section Current Needs window.
  • As rows in the Attributes pane of the Performance Model window.
• Upper Level Dec Tree Variable — This field determines whether the select column will be used in developing the upper-level treatment decision trees. 
• Used in Expressions — This field determines whether the selected column will be used in calculated expressions. 
• Analysis Scope Variable — This field determines whether the selected column will be used in defining the scope of the network optimization analysis. 
• Default in Analysis — This field contains a value that is used to supply a value for the column when it has no value in either the Network Master.
• Allow Change After Treatment — This field determines whether the selected column's values will change after a treatment where the values are not based on a performance model (i.e., a non-PI-based attribute, for example, Pavement Type change after a specific type of treatment). 
• Change with Year SQL — This field contains the SQL that determines how the value of the non-PI-based attribute changes annually in the future for scenario analyses, using the value from previous year as input, for example, AADT (to represent an annual growth) and Pavement Age (to calculate the next year from last year).
• Update Order — For non-PI-based attributes, this field contains a number that indicates the order in which the attributes will be updated when multiple attributes either have "Change with Year SQL" in this window or are shown in the Other Improvements pane in the Treatments window.
• Is Constr. Column — This field determines whether that the selected column may be used as a constraint in the network optimization analysis. 
• Is Add Constr. Column — This field determines whether that the selected column may be used to set up the sub-division constraint in the network optimization analysis. 
• Ch with Time Groovy Script — This field is equivalent to the Change with Year SQL field except that Groovy scripts are utilized rather than SQL.
• Groovy Script for Calculated Columns — This column shows the Groovy script that calculates the value of the column. It is used in analysis in all future years.

Analysis Columns Configuration window

1.2 Calculated Expressions

The purpose of the Calculated Expressions window is to supply user-defined information for some parameters used in analysis. This window also provide user-defined information for some parameters used in analysis. The system permits 4 parameters to be defined using Calculated Expressions:

• Analysis index Weight Factor
• Analysis Priority
• Budget Category
• Treatment Cost

The Calculated Expressions window contains three panes: Expressions pane on the left, SQL pane in the bottom left, and Columns pane on the right.

Description of Available Expressions

Analysis Index Weight Factor - This parameter affects the benefits resulting from a scenario analysis regardless of the objective of the analysis. An SQL expression is required for this parameter. 

Analysis Priority - This parameter is a single formula that is the priority to select candidate treatment that are generated from Decision Tree, for each section in Network Master. It is applied in network analysis when the prioritization method is chosen.

Budget Category - When this parameter is selected, every record in the Budget Categories window is entered in the Expressions pane.

Treatment Cost - This parameter is composed of the set of values of all treatment costing methods. An SQL expression is required for each treatment cost method and is entered in the SQL pane.

Expressions Pane

The Expression pane allows you to configure the value of the parameter selected in the drop-down list in the upper left corner of the Calculated Expressions window.

SQL Pane

The SQL pane in the bottom left corner of the window contains the calculated Oracle SQL expression pertinent to the currently selected parameter and record in the Expression pane. It is this expression that is used in analysis to provide the appropriate calculation.

Column Pane

The Columns pane on the right side contains the list of columns that may be used in expressions. If a column is a list, then a hyperlink is provided in the List Column to display the values in the list

1.2.1 How to Add Treatment Cost Calculation

The cost of each treatment is determined by two components: Unit Cost and Cost Calculating Method.

Unit cost - can be defined and stored for each treatment and admin unit in Treatment Costs screen.

Cost - specifies the method by which the cost is calculated. The method is selected from a drop-down list that contains the available unit-cost calculations. Out of the box, the system provides two methods to calculate the total cost from unit cost: “Unit_Cost * Lane Mile”, and “Unit_Cost * Sq Feet”

1.3 Treatments

Treatment Library provides the system with details of all the treatments that can be used when undertaking maintenance of the pavement and enables these to be selected when undertaking analyses. Treatments are used in all analyses, along with decision trees, to provide details of the treatment type and costs of recommended future projects as well as the condition consequences of these projects. 

The Treatments window has 3 panes of information/settings: Treatments, Improvements, and Other Improvements.

Treatments pane - lists all treatments used for long-term projects and the costs associated with each.

Improvement pane - After the treatment selected in the Treatments pane is applied, the condition attributes listed in the Improvements pane will change according to the rules configured in this pane.

Other Improvement - After the treatment selected in the Treatments pane is applied, the non-PI-based attributes listed in the Other Improvements pane will change according to the rules configured in this pane.

1.3.1 Create New Treatment - Click Here for Treatments Exercises

In this example, we add a new record in the Treatments windows by performing the following steps:

1. Open the Treatments window: Pavement Analyst >  Setup > Network Analysis Setup > Treatments.

2. Right-click in the Treatments pane and select Insert.

3. Overwrite the Treatment Name with the new (treatment) name by highlighting the text and then typing the name.

4. Populate priority, unit cost, budget category, work code information, and all other fields that are applicable.

5. Right-click in the Improvements pane and select Insert.

6. Configure condition improvements as a result of the treatment by populate all fields that are applicable.

7. Right-click in the Other Improvements pane and select Insert.

8. Configure other improvements (e.g. reset pavement age) by populate all fields that are applicable.

x

9. Click the Save button to save the record.

LikeBe the first to like this