Rehab Actions and Costs are a fundamental area to many parts of InfoMaster 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.
In the first tab titled Rehab Action, users can create new Rehab Actions to be assigned to pipes, manholes, or laterals. In addition, users 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. Users must supply an ID and description. The ID can contain spaces and special characters until ID requirements in other areas of InfoMaster.
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 users to rename the action. This renaming will be reflected in other areas of the InfoMaster 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.
In the second tab titled, Rehab Method/Cost Component, users 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, users can set how costs are assigned for each selected Rehab Method on the left side. Users can create multiple cost methods for each rehab method. Only one cost method will be used, but users 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. Users 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 inch/ft changes depending on the Proximity to Hospital CoF, the pipe material, and the CCTV Peak Score.
Notice that users can add parameters with the button, 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 InfoMaster cost table, the .csv file CANNOT be open in Excel or any other program at the same time.
The auto insert button, may prompt users 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.
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.
Once these Rehab Actions, Rehab Methods, and Rehab Costs are set up, they can be applied to many features within InfoMaster. Not only can these rehab methods and costs be applied to individual defects, but they can become components to larger rehab actions costs. Users can add costs for social, environmental, and any number of life cycle cost factors not easily quantifiable.