table of contents
Getting Support
A few mechanisms available for questions or support on filling in the workbook. Feel free to:
Send an email to info@asint.net (every employee of AsInt monitors this)
Send an email to jarret.reeves@asint.net
Call Jarret Reeves or Rohan Patel, phone numbers are listed here.
Purpose of Import Template
The purpose of the import workbook is to provide a bucket for collecting Mechanical Integrity data, typically hierarchy, design, process, risk, and inspection history. A few notes:
The SAP Intelligent Asset Management (IAM) + AsInt Apps are extremely flexible with regards to data stored, data types, additional columns, renaming fields, etc…
Feel free to modify the workbook to meet your data needs. Just try to highlight the changes (e.g. add new column, change data type, etc..) in a color and use the Revision Control sheet to document the changes.
No limitation on changing the sheet names either.
This will allow AsInt to understand the data management changes and apply them prior to importing.
Using the Template
Each sheet allows for the recording of data, such as RBI, Inspections, and Deficiencies. In each sheet, there are 5 rows (shown in below image) at the top defining the:
Category of data - Design Data, Operating Data, History, etc…
Unit of Measure - Imperial or Metric option
Data Type - Text, Date, or Numeric.
Field Name - Name, and sometimes description, of the data element being collected.
Required, Recommended, or Optional - If the fields is Required for data collection, if it is Recommended for Mechanical Integrity needs, or if it is Optional.
Where applicable, a Pick-list of available values is provided in a drop-down. If a value does not match the Pick-list, it will not allow the value to be saved. For changing values to the Pick-list, review this guideline.
Unit of Measures
As shown in the below image, the Unit of Measure is shown on the 2nd row of each sheet. A few guidelines:
Generally AsInt would suggest to capture all the data in Metrics or Imperial, however there is no limitation if you want to mix Imperial and Metric.
Feel free to change the Unit of Measure you want to track per column, just document the change by highlighting in a color and document in the Revision Control sheet.
Per column, you can track different Unit of Measures if you would like. Just add an additional column denoting the Unit of Measure for that row. With that being said, this complicated the data collection and would advise on setting a single Unit of Measure per column.
Changing Data Types
No problem if you would like to change the data type (e.g. numeric to text, or text to date, etc..). Just document the change by highlighting in a color and document in the Revision Control sheet.
Adding columns to a sheet (if needed)
Feel free to add columns to each sheet, the solution can adapt to any data element. Just document the change by highlighting in a color and document in the Revision Control sheet.
Adding to pick-lists (if needed)
Feel free to add, edit, or remove values from existing pick-lists. Additionally, you are free to add new pick-lists as well for text fields (e.g. manufacturer, etc..).
Just document the change by highlighting in a color and document in the Revision Control sheet.
Use the Picklists sheet to change the values of the Picklists, or add new Picklists if desired.
API 580 for Fixed Equipment
Use this sheet if you want to use a more Semi-Quantitative model. It’s the same input values for the Quantitative model (API 581 3rd), but LESS fields are required.
Used for traditional Fixed Equipment asset families such as vessels, exchangers, tanks, pipe, etc…assets that are designed for a containment barrier.
You can add new types of Fixed Equipment by adding to the Equipment_Type pick list.
If the asset is a multi-component asset family (e.g. exchanger has shell, bundle, etc..). In this case, the asset and the components will take up multiple rows. For example, 1 row for the Shell, 2nd row for the Channel, 3rd row for the Bundle.
API 581 3rd for Fixed Equipment
Use this sheet if you want to use a Quantitative model. It’s the same input values for the Semi-Quantitative model (API 581), but MORE fields are required.
Used for traditional Fixed Equipment asset families such as vessels, exchangers, tanks, pipe, etc…assets that are designed for a containment barrier.
You can add new types of Fixed Equipment by adding to the Equipment_Type pick list.
If the asset is a multi-component asset family (e.g. exchanger has shell, bundle, etc..). In this case, the asset and the components will take up multiple rows. For example, 1 row for the Shell, 2nd row for the Channel, 3rd row for the Bundle.
Pressure Relief Devices
Use this sheet if you want to perform RBI on PRDs (Pressure Relief Devices). This will be for Pressure Relief Devices, Pressure Vacuum Vents, and Rupture disks.
As with any sheet, feel free to add additional columns to track data. Just document the change by highlighting in a color and document in the Revision Control sheet.
Pipe Line List
Use this to define the "lines" that make up the Pipe Circuit. These are the individual lines that typically make up an ISO drawing.
As with any sheet, feel free to add additional columns to track data. Just document the change by highlighting in a color and document in the Revision Control sheet.
Schedule
Use this to define future Inspection or Maintenance plans.
As with any sheet, feel free to add additional columns to track data. Just document the change by highlighting in a color and document in the Revision Control sheet.
CMLS
Used to define the Condition Monitoring Locations (CMLs). For Mechanical Integrity purposes, these are traditionally Thickness Monitoring Locations. However, the AsInt CML and Inspection App is designed to handle other types of locations such as Anodes, Coupons, etc…
If you want to track locations outside of Thickness Monitoring, add the necessary columns of data you would like to track.
CML Readings
The Condition Monitoring Location (CML) readings sheet allow you to define readings against the CMLs defined on the CML sheet.
For one CML, it is more than likely you will define more than one reading.
Please ensure the CML defined in the reading sheet, has a corresponding CML defined on the CMLs sheet.
General Visual Inspection
Use this sheet to record traditional Visual Inspections from Internals, Externals, Partials, etc..The intent is to document the type of Visual, Date, and the large Scope, Summary, and Recommendation text that usually accompanies the visual inspection.
As with any sheet, feel free to add additional columns to track data. Just document the change by highlighting in a color and document in the Revision Control sheet.
Piping 570 External Inspection
A specific form form API 570 External Inspection for Pipe circuits.
As with any sheet, feel free to add additional columns to track data. Just document the change by highlighting in a color and document in the Revision Control sheet.
Piping CUI Inspection
A specific form form CUI (Corrosion Under Insulation) specific too Piping.
As with any sheet, feel free to add additional columns to track data. Just document the change by highlighting in a color and document in the Revision Control sheet.
Deficiencies
Use to record any Deficiencies against a piece of Equipment or Component. Deficiencies are ofter referred to as Non-conformances or Anomalies.
As with any sheet, feel free to add additional columns to track data. Just document the change by highlighting in a color and document in the Revision Control sheet.
Pick-lists
Central location to manage all Pick-lists referenced in the Workbook. For editing the Pick-lists, refer to this guideline.
Revision Control
Version Control is provided for the End User to track aspects of change to the specific workbook. Feel free to use this sheet as you see fit, however below are some general guidelines on using the Revision Control sheet.
Large changes to the dataset (e.g. added Relief Devices on Mid January by John Smith)
Changes to the structure of the Workbook, such as adding columns, changing data types, changing Pick-lists, etc..