Calculation Search Fields
The following is a list of fields and icons found on the Calculation Search page.
NOTE: When information is calculated, it will be displayed as a list in the panel. Most panels list the first 10 records. Use the arrow icons in the lower-right corner of the panel to view more records. Next to the arrows, the number of records displayed is shown, as well as the total number of calculated records.
- Asset Group: Select the desired asset group to search.
- Asset Type: Select the desired asset type to search.
- Calculation Name: Select the desired calculation to search.
- POF: Probability of Failure; enter a number or use the numeric search icon to search for a range.
- COF: Consequence of Failure; enter a number or use the numeric search icon to search for a range.
- RM: Risk Mitigation; enter a number or use the numeric search icon to search for a range.
- BRE: Business Risk Exposure; enter a number or use the numeric search icon to search for a range.
- MSPU: Maintenance Score Proactive Under-maintained; enter a number or use the numeric search icon to search for a range.
- MSPO: Maintenance Score Proactive Over-maintained; enter a number or use the numeric search icon to search for a range.
- MSR: Threshold; enter a number or use the numeric search icon to search for a range.
- Error Log: Enter text to search for in the error log.
- EURL: Click to generate a service URL that can be used to show the saved search as an event layer on another map outside of Trimble Unity, like ArcGIS Online.
- Add search results to map: Click to view the search results on the map. Note that the map must be open before clicking this icon.
- Clear: Click to clear the search form and start a new search.
- Open: Click to view a list of existing saved searches.
- Search: Click to search the assets based on the search criteria you've entered.
- Save: Click to save the search criteria you've entered as a saved search.
The following options are shown when you click the numeric search icon:
- Between: Search for a single number or for any numbers contained between a set. For example, return any amounts between 1 and 5.
- Not Between: Search for any numbers not contained between the set. For example, return any amounts not between 1 and 5.
- Equal: Search for a single number or for any numbers contained in the set. For example, return any amounts equal to 1, 2, 3, 4, or 5.
- Not Equal: Search for a single number or for any numbers contained in the set that is not equal. For example, return any amounts not equal to 1, 2, 3, 4, or 5.
- Greater Than: Search for any numbers greater than the specified number. For example, return any amounts greater than 5.
- Greater Than or Equal: Search for any numbers greater than or equal to the specified number. For example, return any amounts greater than or equal to 5.
- Less Than: Search for any numbers less than the specified number. For example, return any amounts less than 5.
- Less Than or Equal: Search for any numbers less than or equal to the specified number. For example, return any amounts less than or equal to 5.
- Null: Search for any number not within a range of values. Select Null from the drop-down list to only search for null values.
- Exclusive: Select to search for only the numbers entered in the fields. This check box only appears when the Between and Not Between options are selected.
- Include Null: Select to include null options in the search results. This check box appears for all options except the Null option.
- Curve: Click to view asset curve and information. See Asset Curve for more information.
- UID: The unique ID of the asset.
- POF: Probability of Failure; the likelihood that an asset will fail.
- COF: Consequence of Failure; the impact of the asset's failure.
- RM: Risk Mitigation; the efforts taken to reduce the impact of the asset's failure.
- BRE: Business Risk Exposure; this is calculated by multiplying the Probability of Failure by the Consequence of Failure by the Risk Mitigation (BRE = POF × COF × RM).
- MSPU: Maintenance Score Proactive Under-maintained; the percentage that the asset is under-maintained. The percentage is shown as a decimal value. For example, if the value is 1, that means there hasn't been any proactive maintenance done on the asset, only reactive (the asset is 100% under-maintained). If the value is .77, that means the asset is 77% under-maintained (there has been some proactive maintenance done).
- MSPO: Over-maintained Proactive Maintenance Score; the percentage that the asset is over-maintained. The percentage is shown as a decimal value. For example, if the value is 0, that means the asset has never been over-maintained.
- MSR: Reactive Maintenance Score; the percentage of reactive work that has been performed on the asset. The percentage is calculated based on the Threshold defined for the asset type as part of the maintenance strategy (the number of times that your organization performs a type of reactive work on the asset). The percentage is shown as a decimal value. For example, if the Threshold is defined as 3 on the maintenance strategy and this column shows a 0, that means none of the reactive work activities have been done. A value of .33 means that 1 reactive work activity has been done, a value of .66 means that 2 reactive work activities have been done, and a value of 100 means all 3 reactive work activities have been done and the asset has met its Threshold.
- Average End Year: The average end year that is configured in the calculation search displays here.
- Fast End Year: The fast end year that is configured in the calculation search displays here.
- Slow End Year: The slow end year that is configured in the calculation search displays here.
- Maint. Status: The maintenance status that is configured in the calculation search displays here.
- Error Log: If any of the GIS data is missing, a message is shown in the error log column. Missing data could make the calculation inaccurate.
- CWX: The asset's X coordinate.
- CWY: The asset's Y coordinate.
- Longitude: The longitude of the asset.
- Latitude: The latitude of the asset.
- Filter records: Click to quickly filter the list of fields in the panel.
- CSV: Click to download the .csv file of the records.
- Column Menu: Click to modify the columns shown on the panel.
- Rows: Click to change the number of rows viewed at a time in the panel.
- Sort By: Select any of the properties you want to filter the Search Results panel with.
- Descending: Click the check box to display the records in descending order.
- Highlight: Click to select assets from the calculation search and highlight them on the map.
- Create Work Order: Click to create a work order for the selected assets.