Rehab Actions and Costs are a fundamental area to many parts of InfoAsset Planner including the Draft Rehab Plan, Rehabilitation Plan and Decision Tree, and Life Cycle Cost Analysis (LCCA). The window is divided into two tabs which together describe the three components of Rehab Cost, Rehab Method, and Rehab Action.
Rehab Costs are defined costs for each Rehab Method. These Rehab Costs may be defined as either static costs or controlled via a look up table which may specify how costs change based on different parameters.
Rehab Methods specify the individual rehabs which can be performed by field crews (CCTV, replace, point repair, etc.). Rehab Methods may be assigned to each individual defect or the the facility as a whole.
Rehab Actions specify the outcomes which can be assigned to each individual pipe, manhole, or lateral during rehab planning (CCTV within 6 months, CCTV within 5 years, point repair, patch and line, send to admin for review, etc.). Many Rehab Methods and their associated costs can be combined into a single Rehab Action.
Notice in the screenshot above, that this Rehab Actions and Costs interface is applicable to all facility types and vertical assets. Users can toggle between different sets of Rehab Actions/Methods/Costs for each type of facility or vertical asset.
In the first tab titled Rehab Action, you can create new Rehab Actions to be assigned to any facility type or vertical asset. In addition, you can associate any combination of Rehab Method to each Rehab action. In the example below, the Rehab Methods/Costs titled ‘REPLACEMENT’, ‘DIG’, and ‘TRAFFIC’ are associated with the overall Rehab Action titled ‘Replace’.
New Rehab Action - Adds a new Rehab Action to the list. You must supply an ID and description. The ID can contain spaces and special characters until ID requirements in other areas of InfoAsset Planner.
Add Rehab Method/Cost Component - Pops up a list of all the Rehab Methods which may be associated to the Rehab Action.
Delete - Deletes the Rehab Action.
Rename Rehab Action - Allows you to rename the action. This renaming will be reflected in other areas of the InfoAsset Planner project.
Note that Rehab Methods cannot be created in this first tab; they can only be associated to Rehab Actions.
On the right-side of this same tab, a preview of the different properties associated with each Rehab Action or Rehab Method is shown. In the example below, the Replace Rehab Action is associated to the Work Order Type of Pipe Repair. This means that if a work order is generated from Replace in the Rehab Summary table, Pipe Repair will be the assigned Work Order Type. Because no Inspection Type is specified in this case, the Replace Rehab Action can never be assigned as an Inspection. The Total Cost Multiplier field can be used to affect the final pricing estimate of the Rehab Action. Contingencies and safety factors could be applied here.
Rehab Method/Cost Component
In the second tab titled, Rehab Method/Cost Component, you can create Rehab Methods and assign associated costs.
On the left-hand side, Rehab Methods can be created, deleted , have their name changed , or be imported from a .csv file . Note that using this import from .csv button will update all Rehab Methods and associated costs within the window.
On the right side, you can set how costs are assigned for each selected Rehab Method on the left side. You can create multiple cost methods for each rehab method. Only one cost method will be used, but you can easily toggle in-between different cost scenarios in this way.
Costs can be applied as a simple Static cost where a cost is applied per linear foot, per pipe, per dia. length, etc. You can also add setup costs to provide a baseline. The example below shows a cost of $50.00 ft per length of pipe with a $500 setup cost.
Additional information to further detail where cost information originated from may also be added in the fields below.
Costs can also be applied to be dynamic; dependent on any number of different parameters. This can be done by choosing the Cost by look up option. With this option, users can choose any number of parameters which can affect how costs are set. In the example below, the cost per foot changes depending on the pipe diameter, the pipe material, and whether there is pavement present. The user may also choose parameters from analysis results such as proximity to hospitals or total risk score.
Notice that you can add parameters with thebutton, auto insert combinations of parameters with the button, and Export and Import cost tables as .csv files for the individual Rehab Method. Note that to import a .csv file into an InfoAsset Planner cost table, the .csv file CANNOT be open in Excel or any other program at the same time.
The Auto Insert button, may prompt you to add rows/parameters based on a certain number of classes. This will occur if one of the parameters is numerical. If, for example, costs are defined for 12" pipes and 16" pipe and a 14" pipe is discovered, the 16" costs will be assigned to this pipe. This is similar to how the numerical breaks work in the risk analysis.
The cost table comes in a pivot table form that allows you to organize the cost table fields in different ways. You may drag the fields names to the baby blue area to organize the fields either by rows or columns and the order in which the fields appear. You may organize the cost pivot table as convenient for a better cost editing experience.
Example 1: Rows by Material and Diameter, and columns Paved
Example 2: Rows by Diameter and Paved, and columns by Material
In addition, block editing is possible within the cost by look up table. Simply hold CTRL, drag the cursor over several cells in a single column, and then right-click to bring up the block editing option.
To specify the cost units, the drop-down option is available at the top of the cost table.
When the Display in cells option in specified, the units will be available in each cell for viewing and editing purposes.
To edit individual cells or a specific group of cells, the Block Editing option is available when right clicking on a cell. Cost values and units may be edited with the Block Editing tool only when in the 'Display in cells' cost unit option.
Once these Rehab Actions, Rehab Methods, and Rehab Costs are set up, they can be applied to many features within InfoAsset Planner. Not only can these rehab methods and costs be applied to individual defects, but they can become components to larger rehab actions costs. You can add costs for social, environmental, and any number of life cycle cost factors not easily quantifiable.