The Calculated Expressions window supplies user-defined information for parameters used in analysis. This information is either the definition of a drop-down list for use in other windows or a formula for direct use in analysis. Each module has its own Calculated Expressions window, and the expressions only apply to analysis in that module.

The parameters are shown in the drop-down list in the top right corner of the window. By selecting from this drop-down list, you can then define the expressions for the parameter. (Multiple expressions are allowed for all parameters other than Analysis Index Weight Factor and Analysis Priority. These two parameters are only allowed one expression.)

Note: Some parameters require SQL expressions and some require Java expressions. The application will know which is required for a selected parameter and will configure the window accordingly. SQL expressions appear in the lower left pane; Java expressions appear in the Java Expression Text column of the left middle pane.

In addition to the parameters drop-down list, the Calculated Expressions window contains three panes: the Expressions Pane on the left, the SQL Pane in the bottom left, and the Columns Pane on the right.

Available Parameters

The available parameters are:

  • 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. This parameter acts as a default when a Groovy script is not selected in the Analysis Weight Groovy Script column in the Optimization Analysis window.
  • Analysis Priority: This parameter is a single formula that is the priority to rehabilitate. It is applied in network analysis when the prioritization method is chosen. The higher the number the sooner that the road section will be rehabilitated. An SQL expression is required for this parameter. This parameter acts as a default when a Groovy script is not selected in the Priority Groovy Script column in the Optimization Analysis window.
  • Budget Category: When this parameter is selected, every record in the Budget Categories window is entered in the Expressions pane. Then, for each record in the Expressions pane, the ID of the budget category record in the Budget Categories window is entered in the SQL 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. For example, if treatment cost is by square feet, then the formula would look like this: "UNIT_COST * NVL(SEC_WIDTH,24)*(LENGTH) * 5280 /900", where unit cost, length, and width are columns in the Network Master file. Treatment costs appear in a drop-down list in the Cost column in the Treatments pane of the Treatments window.

Expressions Pane

In the Expression pane, you configure the value of the parameter selected in the drop-down list in the upper left corner of the Calculated Expressions window. When the selected parameter can have multiple, discrete values that appear in a drop-down list, then multiple records in this pane are configured; when the parameter's values result from a formula, then only one record is configured.

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. The Oracle SQL expression must be limited to columns that exist in the Network Master table and must be valid. (To check that the SQL expression is valid, click the Check button.) The Columns pane lists the columns that can be included in the SQL expression.
Once an SQL expression is completed, activate the new SQL expression in the network analysis process by:

  1. Clicking the Check button to be sure that the expression is valid.
  2. Clicking the Accept button.
  3. Clicking the icon to save the new expression.
Note: An SQL expression must be accepted before it can be saved. The expression will neither be accepted nor saved if it is not valid or it is saved without first being accepted.

Columns Pane

The Columns pane on the right side contains the list of columns that can be used in expressions. If a column is a list, then a hyperlink is provided in the List Column column to display the values in the list. A column of the Network Master file is marked for use in expressions by selecting the Used in Expressions check box in the PMS Columns in Analysis window.

  • No labels