Skip to main content
Cartegraph Campus

Scenario Builder Activity Sequence Types

You must have administrator rights to access this feature.

This feature may not be available in every package. Not sure if you have this feature or you want to learn more about it? Send us a message at support@cartegraph.com.

Activity Sequences determine the recommended order for activities when a Scenario is run. The Activity Sequence is required for each scenario and is set you create or changed when you edit a scenario. There are seven Activity Sequences available and each can be used with any Scenario Type.

Once an activity is locked in a scenario, it always comes first on the Activity list.

Asset Criticality

Asset Criticality is based on assets' Criticality Factor, a field on the asset record. The number is used to compare and prioritize different assets of the same type, a higher number indicating higher priority. The sort order is:

  • Activities are first sorted based on their asset's Criticality Factor, highest to the lowest number. Null values are treated as a value lower than zero, giving them the lowest priority.
  • When a tie exists when more than one activity with the same projected date, a series of sub-sorts are applied until the tie is broken.
  • Subsorts - Install/Replace (Ascending), Asset ID (Ascending), Projected Date (Ascending), Activity (Ascending), Protocol (Ascending)

Example

There are five Pavement segments, each segment qualifies for two activities.

Asset ID Criticality Factor Install/Replace Date Activity
Pavement B* 10 2/1/18 Patch
Pavement B# 10 11/1/18 Seal
Pavement A^ 8 1/1/18 Patch
>Pavement A 8 5/1/18 >Seal
Pavement C+ 8 6/1/18 Patch
Pavement C 8 6/1/18 Seal
Pavement H** 0 5/1/18 Patch
Pavement H 0 12/1/18 Seal
Pavement D (null) 1/1/18 Patch
Pavement D (null) 10/1/18 Seal

*Wins because it has the highest criticality factor and then based on the projected date.

#All activities for the asset with the highest criticality are prioritized above any activities for assets with a lower criticality.

^Wins criticality tie over pavement C because of asset ID.

+Wins over other activities for pavement C because of the alphabetical activity name.

**Wins over pavement D because a nonnull value of 0 is prioritized higher than a null value.

Asset Criticality and Highest Estimated OCI

This type of prioritization is commonly referred to as Do Best First where assets in the best condition receive maintenance priority. Asset Criticality is based on assets' Criticality Factor, a field on the asset record. Estimated OCI is based on assets' estimated OCI at the beginning of a plan year. Assets with the highest criticality and highest estimated OCI is the top priority. The user-specified Asset Criticality Weight and Estimated OCI Weight are factored into this prioritization. A weight of zero can be assigned to Asset Criticality to have the prioritization based strictly on Estimated OCI. On the Activity List results, the Priority Ranking value represents the calculated priority. See the Priority Ranking help topic for details on how this value is calculated including how weighting is applied. The sort order is:

  • Activities are sorted based on the calculated Priority Ranking, highest to the lowest number.
  • When a tie exists, when more than one activity with the same priority ranking, a series of subsorts are applied until the tie is broken.
  • The secondary sort differs based on the defined Asset Criticality Weight and Estimated OCI Weight.
  • If Asset Criticality Weight is higher than Estimated OCI Weight, the activities are sorted based on the asset's Criticality Factor, biggest first.
  • If Estimated OCI weight is greater than or equal to Asset Criticality Weight, the activities are sorted based on the Estimated OCI at the beginning of the plan year, highest first.
  • If a tie still exists between activities, the asset with the earliest install date or replace date takes priority (oldest asset).
  • Finally, all ties are resolved by ordering by asset ID alphabetically, Projected Data (oldest date first), Activity (alphabetically), Protocol (alphabetical), then unique autonumber (smallest first).

Example

There are five pavement segments: Pavement A, Pavement B, Pavement C, and Pavement D, Pavement E. Each Pavement segment qualifies for activities.

Asset ID Priority Ranking Criticality Factor Estimated OCI Install Date
Pavement B* 160 50 60 1/1/2000
Pavement D# 120 30 60 1/1/1990
Pavement A 120 20 80 1/1/2000
Pavement C 75 20 35 1/1/2000
Pavement E^ 75 20 35 1/1/2010

60* Pavement B occurs first due to it having the highest calculated priority ranking.

# Pavement D follows having the second-highest priority ranking and a higher criticality factor when compared with Pavement A; asset criticality is weighted higher than estimated OCI.

^ Activity for Pavement E occurs last as it has the lowest priority ranking and is more recently installed than Pavement C.

Asset Criticality and Lowest Estimated OCI

This type of prioritization is commonly referred to as Do Worst First where high-risk assets (highly critical assets that are in poor condition) are given top priority. Asset Criticality is based on assets' Criticality Factor, a field on the asset record. Estimated OCI is based on assets' estimated OCI at the beginning of a plan year. Assets with the highest criticality and lowest estimated OCI is the top priority. The user-specified Asset Criticality Weight and Estimated OCI Weight are factored into the priority. A weight of zero can be assigned to Asset Criticality to have the prioritization based strictly on Estimated OCI. On the Activity List results, the Priority Ranking value represents the calculated priority. See the Priority Ranking help topic for details on how this value is calculated including how weighting is applied. The sort order is:

  • Activities are sorted based on the calculated Priority Ranking, biggest first.
  • When a tie exists, when more than one activity with the same priority ranking, a series of sub-sorts are applied until the tie is broken.
    • The secondary sort differs based on the defined Asset Criticality Weight and Estimated OCI Weight.
    • If Asset Criticality Weight is higher than Estimated OCI Weight, the activities are sorted based on the asset's Criticality Factor, highest to lowest.
    • If Estimated OCI weight is greater than or equal to Asset Criticality Weight, the activities are sorted based on Estimated OCI at the beginning of the plan year, lowest to highest.
  • If a tie still exists between activities, the asset with the earliest install date or replace date take priority the oldest asset.
  • Finally all ties are resolved by ordering by asset ID (alphabetical), Projected Date (oldest first), Activity (alphabetical, Protocol (alphabetical), then, unique autonumber (smallest first).

Example

There are four Pavement segments: Pavement A, Pavement B, Pavement C, and Pavement D. Each Pavement segment qualifies for activities. The activities sort like this:

Asset ID Priority Ranking Criticality Factor Estimated OCI Install Date
Pavement C* 150 20 35 1/1/2010
Pavement B 150 50 50 1/1/2010
Pavement D 90 50 80 1/1/2010
Pavement A 60 20 80 1/1/2010

*Pavement C is first because it has the highest priority ranking, and the lowest estimated OCI.

Deferred Unit Cost and Asset Criticality

Activities are recommended based on the highest Deferred Unit Cost and the Asset Criticality. The sort order is:

  • Activities are sorted based on highest Deferred Unit Costs.
  • When a tie exists with more than one activity with the same Deferred Unit Cost, a series of sub-sorts are applied until the tie is broken.
    • The secondary sort differs based on the Criticality Factor (biggest first), then Lowest OCI (lowest first).
    • If a tie still exists between activities, the asset with the earliest install date or replace date take priority the oldest asset.
  • Finally, all ties are resolved by ordering by asset ID (alphabetical), Projected Date (oldest first), Activity (alphabetical), Protocol (alphabetical), then unique autonumber (smallest first).

Example

There are six Pavement segments: Pavement A, Pavement B, Pavement C, Pavement D, Pavement E, and Pavement F. Each Pavement segment qualifies for activities. The activities sort like this:

Asset ID Deferred Unit Cost Criticality Factor Estimated OCI Install Date
Pavement C* $18 20 35 1/1/2010
Pavement B* $15 50 50 1/1/2010
Pavement D $15 30 60 1/1/2010
Pavement E $15 30 80  
Pavement A^ $9 20 80 1/1/2010
Pavement F $9 20 80 1/1/2015

^Pavement C sorts the highest because it has the highest Deferred Unit Cost.

*Pavement B wins over Pavement D and Pavement E because Pavement B has the higher Criticality Factor

"Pavement A wins over Pavement F because the Install/Replace Date is older.

Deferred Unit Cost and Lowest Estimated OCI

Activities are recommended based on the highest Deferred Unit Cost and the asset's Estimated OCI. The sort order is:

  • Activities are sorted based on highest Deferred Unit Costs.
  • When a tie exists with more than one activity with the same Deferred Unit Cost, a series of sub-sorts are applied until the tie is broken.
    • The secondary sort differs based on the Lowest OCI (lowest first), then the Criticality Factor (biggest first).
    • If a tie still exists between activities, the asset with the earliest install date or replace date take priority the oldest asset.
  • Finally, all ties are resolved by ordering by asset ID (alphabetical), Projected Date (oldest first), Activity (alphabetical), Protocol (alphabetical), then unique autonumber (smallest first).

Example

There are five Pavement segments: Pavement A, Pavement B, Pavement C, Pavement D, and Pavement E. Each Pavement segment qualifies for activities. The activities sort like this:

Asset ID Deferred Unit Cost Estimated OCI Criticality Factor Install/Replace Date
Pavement C^ $18.00 40 20 1/1/2010
Pavement B* $15.00 60 50 1/1/2010
Pavement D $15.00 80 50 1/1/2010
Pavement A" $9.00 65 20 1/1/2010
Pavement E $9.00 65 20 1/1/2015

^Pavement C sorts the highest because it has the highest Deferred Unit Cost.

*Pavement B wins over Pavement D because Pavement B has the lowest Estimated OCI

"Pavement A wins over Pavement E because the Install/Replace Date is older.

Deferred Unit Cost and Years Remaining

Activities are recommended based on the Deferred Unit Cost (biggest to smallest) and the Years Remaining (smallest to biggest) for the Recommended Activity. The sort order is:

  • Activities are sorted based on the highest Deferred Unit Costs.
  • When a tie exists with more than one activity with the same Deferred Unit Cost, a series of sub-sorts are applied until the tie is broken.
    • The secondary sort differs based on the Years Remaining (smallest to biggest).
    • If a tie still exists between activities, the Criticality Factor (biggest first) and Lowest OCI (lowest first) are considered next.
  • Finally, all ties are resolved by ordering by asset ID (alphabetical), Projected Date (oldest first), Activity (alphabetical), Protocol (alphabetical), then unique autonumber (smallest first).

Example

There are four Pavement segments: Pavement A, Pavement B, Pavement C, and Pavement D. Each Pavement segment qualifies for activities. The activities sort like this:

Asset ID Deferred Unit Cost Years Remaining Criticality Factor Estimated OCI Install/Replace Date
Pavement C* $15.00 0 20 40 1/1/2010
Pavement B^ $15.00 6 50 60 1/1/2010
Pavement D $15.00 6 50 80 1/1/2010
Pavement A $9.00 4 20 65 1/1/2010

*Pavement C, Pavement B, and Pavement D have the same Deferred Unit Cost. Pavement C is at the top because it has the smallest number of Years Remaining.

^Pavement B wins over Pavement D because the Estimated OCI is lower.

Projected Date

The date that an asset qualifies for a particular activity. The earliest Projected Date is the highest priority. The sort order is:

  • Activities are first sorted by Projected Date, soonest to farthest away.
  • When a tie exists when more than one activity with the same projected date, a series of sub-sorts are applied until the tie is broken.
  • Subsorts for Asset Criticality (Biggest First), Install/Replace Date (Older Asset First), Asset ID (Alphabetical), Activity (Alphabetical), Protocol (Alphabetical), then unique autonumber (smallest first)

Example

There are three Pavement segments: Pavement A, Pavement B, and Pavement C. Each Pavement segment qualifies for two activities.

Asset ID Activity Criticality Factor Install/Replace Date
Pavement A* Patch 10 2/1/2018
Pavement C+ Patch 20 3/1/2018
Pavement B Patch 10 3/1/2018
Pavement A# Rehab 10 6/1/2018
Pavement B Seal 10 6/1/2018
Pavement C Seal 20 12/1/2018

* Pavement A is at the top because the date is soonest.

+Wins because next soonest date and asset has the highest criticality

#Wins because next soonest date, the Criticality Factors are the same, Install Date the same, then asset ID ascending