This section provides an overview of the bulk data update workflows available within the Capital Budgets module of the Metrix Asset Management system. These workflows are useful for processing the impacts of capital intervention works on the underlying component records.
The concepts discussed in this section include:
Additionally, a How-To document is provided to guide you through the following:
This section outlines the bulk data update workflows featured in the Capital Budgets module of the Metrix Asset Management system. These workflows facilitate the handling of changes resulting from capital intervention works on related component records.
The topics discussed in this section include:
Following the completion of a project using a Budget Bucket in the Metrix Asset Management system, it is often necessary to update the intervention attributes of the underlying Asset Components to reflect the work that was completed throughout the project.
This section discusses the common attributes that you may consider updating as the result of a capital intervention project:
Condition: The condition of an Asset Component is often updated to reflect the current state of the Component following the completion of the project. In many cases, the condition of all Components can be set to the same value of ‘Excellent’, or equivalent.
Intervention Date: The date of the intervention is often updated to reflect the projects completion date as the most recent intervention date for the underlying Asset Components. Once again, this is often the same value for all Components in the Budget Bucket.
Treatment Useful Life: In the event that the project had an effect on the useful life of the Asset Component, it is important to update the Treatment Useful Life attribute to reflect the new useful life of each Component. Note; this is different to the Remaining/Residual Life of the Asset Component.
Residual Life: This attribute is relevant mostly in Renewal projects where the remaining useful life of the Asset
Component has been restored (typically to match the Treatment Useful Life). In this case, the Residual Life attribute
can typically be updated to match the Treatment Useful Life.
Cost Units: This attribute is relevant mostly in Upgrade projects where the size/scale of the underlying Asset Component may have changed. Such changes are NOT typically done in a bulk update, but rather, on a Component by Component basis.
Report Categories: Some users have implemented various Report Categories/Tags to track the Capital status of various Asset Components. If this pertains to you, don’t forget to update the Report Categories/Tags of the underlying Asset Component upon completion of the project.
It is important to note that Metrix will NOT automatically adjust any of the above attribute information. Whilst we do provide the ability to update many of these attributes in bulk, it is still up to the user to determine the correct values, and apply the changes to the underlying Asset Components.
In the data update tab, you will find a list of the unique Asset Classifications that pertain to the underlying Asset Components within the Budget Bucket. For each of the Asset Classifications, you will find the related Component Groups listed. Clicking on one of the Asset Classification tiles will show you Asset level attributes that you can edit. Clicking on one of the Component Group tiles will show you Component level attributes that you can edit.
As you might have presumed, when you edit attributes on a given tile, those changes will apply to the Asset/Component entities that are associated with that tile. For example, if you edit the ‘Condition’ attribute on the Component Group tile for ‘Sealed Road Surface’, the changes will apply to all the underlying Asset Components that are associated with that Component Group.
This form of grouping was chosen so that the bulk update process aligns with the classification configuration structure of Metrix. That is, each Asset Classification, and its child Component Groups, could potentially have a different set of Custom Attributes defined for them. Therefore, the Bulk Update tool is designed to allow you to edit the attributes for each Asset Classification and Component Group as independent groups.
The following topics are covered in this section:
This section provides guidance on how to use the Bulk Update helper tool within each Budget Bucket.
Before starting, it should be noted that Metrix will save/store any adjustments you make in the Bulk Update tool for the life of the Budget Bucket. The changes will NOT be applied to the underlying Asset Components until you actually save those changes. This allows you to make multiple changes to the Bulk Update tool, and then apply them all at once when you are ready.
To use the Bulk Update tool provided within each Budget Bucket, follow these steps:
Navigate to the Budget Bucket with the Asset Components that you want to update.
Navigate to the ‘Post Processes’ tab of the Budget Bucket.
The tab panel is divided into three (3) sub tabs:
Data Updates: This section allows you to set values for attribute values of the underlying Assets and/or Components.
Report Category Updates: This section allows you to modify the Report Categories/Tags of the underlying Asset Components.
Update Summary: This is where you can review the changes you have made, and apply them to the underlying Asset Components.
Each of the above sub tabs are described in more detail below.
To update a particular attribute, or set of attributes, navigate to the respective Asset Classification or Component Group tile within the Data Updates tab. For the listed attributes, you can set a value for any of the attributes that are enabled. Remember, any changes you make will flow through to all the underlying Assets or Components that associate with the respective Classification tile you have selected.
At present, the following attribute classes are supported:
When you have finished making the changes you need to make, there is nothing more you need to do until you want commit those changes to the underlying Asset Components. See the Update Summary section below for more.
Remember, changes are stored in the Budget Bucket until such time you are ready to save them.
The Report Category/Tag update section is NOT grouped by Asset Classification or Component Group. Instead, it is grouped by the Report Category/Tag name itself. For each of the Report Categories/Tags, you have the option to:
To assign a specific Report Category/Tag to all underlying Asset Components, click on the tile for the Report Category/Tag you want to assign. This will expand the tile and show you the available options to Assign or Unassign the Category/Tag. On the left-hand side, use the drop-down menu to select the Option you wish to apply for the Report Category/Tag.
To unassign a specific Report Category/Tag from all underlying Asset Components, click on the tile for the Report Category/Tag you want to unassign. This will expand the tile and show you the available options to Assign or Unassign the Category/Tag. On the right-hand side, click inside the input control. A drop-down menu will appear with the Category/Tag Options that pertain to the selected Report Category/Tag. Select the Option you wish to unassign from the underlying Asset Components. You may select more than one Option to unassign from the underlying Asset Components.
Remember, only one Option for any given Report Category/Tag can be assigned to the underlying Asset Components at any one time. If you select to Assign an Option for a Report Category/Tag, then the option to Unassign for that Report Category/Tag will be disabled - as the assignment of one option, immediately precludes any other options.
When you have finished making the changes you need to make, there is nothing more you need to do until you want commit those changes to the underlying Asset Components. See the Update Summary section below for more.
Remember, changes are stored in the Budget Bucket until such time you are ready to save them.
The Update Summary tab provides a summary of the changes you have made in the Data Updates and Report Category Updates tabs. This is where you can review the changes you have made, and apply them to the underlying Asset Components.
To apply the changes you have made, firstly enter an Effective Date for the Changes to take effect. This can be any date that is NOT in the future. The principal attribute this value is linked to is the Residual Life. It is the date at which you are saying the Residual Life value is true - i.e. 6 years, 3 months remaining as of today.
Once you have entered the Effective Date, and are satisfied with the reviewed changes, click on the Save Changes button. This will apply the changes to the underlying Asset Components.
Whilst this is termed a ‘Post Process’ step, there is no limit to the number of times you can perform a bulk update on the underlying Asset Components using this tool. It is simply a means of Bulk Updating all the Asset Components that have been assigned to the Budget Bucket.