About the Risk Based Inspection (RBI) 580 Data Loader Workbook Layout and Use

To import data using the Risk Based Inspection (RBI) 580 Data Loader, GE Digital APM provides an Excel workbook, Risk Based Inspection (RBI) 580.xlsx, which supports baseline Risk Based Inspection in GE Digital APM. This workbook must be used to perform the data load. You can modify the Excel workbook to include custom fields used by your organization.

Note: The Excel workbook is referred to throughout this documentation as the data loader workbook.

The following table lists the worksheets that are included in the data loader workbook.

Worksheet

Description

Assets

This worksheet is used to specify existing Equipment records to which components will be linked.

RBI_Components

This worksheet is used to specify the following types of RBI Component records that will be updated or created and linked to assets.

  • Cylindrical Shell
  • Exchanger Header
  • Exchanger Tube
  • Piping
  • Pump Compressor Casing
  • Tank Bottom

RBI_Criticality_Analysis

This worksheet is used to define RBI Criticality Analysis records that will be linked to components.

Consequence_Evaluation

This worksheet is used to define Consequence Evaluation records that will be linked to analyses.

DME_Environmental_Cracking

This worksheet is used to define Criticality Env. Crack. Deg. Mech. Eval. records and Degradation Mechanisms that will be linked to analyses.

DME_External_Corrosion

This worksheet is used to define Criticality Ext. Corr. Deg. Mech. Eval. records and Degradation Mechanisms that will be linked to analyses.

DME_Internal_Corrosion

This worksheet is used to define Criticality Int. Corr. Deg. Mech. Eval. records and Degradation Mechanisms that will be linked to analyses.

DME_Other

This worksheet is used to define Criticality Other Damage Mech. Eval. records and Degradation Mechanisms that will be linked to analyses.

DME_Custom This worksheet is used to define custom Criticality Other Damage Mech. Eval. records and Degradation Mechanisms that will be linked to analyses.
Degradation_Mechanism This worksheet is used to define or update Damage Mechanisms that are or will be linked to the specified analyses.
(PickList)

This worksheet details the valid values available for fields that have pick lists. The field values listed in the (PickList) worksheet have been detailed in the corresponding worksheet. When you load data using the data loader, the data on this worksheet is not loaded.

Color Coding

Certain columns on the worksheets have different functions and requirements. To illustrate this, certain columns are color-coded. The following table lists the colors and what they represent.

Color

Description

Comments

 

Required Key Fields

Indicates columns that contain values that are used by the Risk Based Inspection (RBI) 580 Data Loader to look up and create records. If these columns are removed from the worksheets, the data load will fail. While the worksheets require that these columns be present, values are not necessarily required in these columns.

 

Fields Required for Calculation

Indicates columns that contain values that are required to perform calculations in Risk Based Inspection. Some cells only require values in certain cases. Such cases are found in parentheses in the first row of each worksheet.

 

Recommended Fields

Indicates columns that, according to GE Digital Best Practice for Risk Based Inspection, should contain values.

 

Custom Fields

Indicates columns where you can specify custom fields.

Limitations

The Risk Based Inspection (RBI) 580 Data Loader has the following limitations:

Copyright © 2018 General Electric Company. All rights reserved.