Spares Data Loader
About the Spares Data Loader
The Spares Data Loader allows the creation of Spares Analysis with its spares defined in Reliability Analytics.
Using the Spares Data Loader, you can import the following types of primary and third-party data from a fixed-format Excel workbook into the Spares Reliability Data Model
About the Spares Data Loader Requirements
To use the Spares Data Loader, your organization must have completed the deployment of the Reliability Analytics module.
Security Settings
The Security User performing the data load operation must be associated with either the MI Data Loader User or MI Data Loader Admin Security Role and must also be associated with the MI Reliability Administrator Security Group, the MI Reliability User Security Group, or a Security Role that is associated with this Security Group.
About the Spares Data Loader Data Model
Spares Data Loader Data Model
The following diagram shows how the families used in Spares Data Loader are related to one another.
About the System Reliability Data Loader General Loading Strategy
Best Practices
When importing data using the Spares Data Loader, you must use the following best practices:
- ID fields (row 2 of each worksheet) must not include special characters or spaces.
- Columns in the worksheets should be formatted as either text or dates.
- The first two rows of each worksheet should not be edited.
- Only import a maximum of 500 analyses in each data load.
Limitations
This section documents a list of the limitations for the Spares Data Loader:
- The user must use the Spares Data Loader workbook (Spares Analysis.xlsx). Any modifications made by the user to the values in column headings in any of the worksheets will not be imported.Note: Any column values in a customized format will not be imported by the Spares Data Loader.
- If the user imports the same data multiple times, multiple analyses will be created.
- The Spare Name, Application Name, Population Name, and Failure Distribution Name cannot be updated by Spares Data Loader.
Load Sequence
- Create System Analysis record.
- Link a Spares Analysis record to Equipment or Functional Locations records through the Spares Analysis key relationship.
- Link a Spare parts record to a Spares Analysis through the Spares Analysis key relationship.
- Link an Application record to a Spares Analysis record through the Spares Analysis key relationship.
- Link a Population record to an Application record for a Spare parts record through the through the Application record relationship.
- Link a Failure Distribution record to an Application record for a Spare parts record through the through the Application record relationship.
- Link a Failure Consequence record to an Application record for a Spare parts record through the through the Application record relationship.
- Link a Preventive Maintenance record to an Application record for a Spare parts record through the through the Application record relationship.
About the Spares Data Loader Workbook Layout and Use
In order to import data using the Spares Data Loader, APM provides an Excel workbook (Spares Analysis.xlsx) that supports baseline Spares Analysis in APM. This template must be used to perform the data load.
| Worksheet | Description |
|---|---|
| Spares Analysis | This worksheet is used to define Spares Analysis. |
| Link Asset | This worksheet is used to link equipment, or functional locations associated with the analysis. |
| Spare | This worksheet is used to define the spare parts associated with the analysis. |
| Application | This worksheet is used to define the application of the spare parts. |
| Population | This worksheet is used to define the population and age of the spare parts. |
| Failure Distribution | This worksheet is used to define failure distribution of the spare parts. |
| Failure Consequence | This worksheet is used to define the failure consequences of the spare parts. |
| Preventive Maintenance | This worksheet is used to define the preventive maintenance schedule for the spare parts. |
Spares Analysis Worksheet
The following table lists the fields from the Spares Analysis worksheet that must be configured.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
| BatchKey | MI_Batch_Key | Character (50) | This field is required and must be unique. |
| SiteId | MI_SITE_KEY | Character (50) | This field is required and must be unique. If the value in this field is blank, then the site will be set to Global by default. |
| Analysis Name | MI_AN_ANALY_ID_CHR | Character (255) | This field is required and must be unique. |
| Simulation Start Date | MI_AN_ANALY_START_DATE_DT | Date | This field is required. |
| Simulation End Date | MI_AN_ANALY_END_DATE_DT | Date | This field is required. |
| Iteration Number | MI_SPARANAL_ITERA_NBR_N | Numeric | Standard is 1000. Must be a whole number. |
Link Asset Worksheet
The following table lists the fields from the Link Asset worksheet that must be configured.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BatchKey | MI_Batch_Key | Character (50) | This field is required and must match the Batch Key in the Spares Analysis worksheet. |
| Asset Category | MI_Asset_Category | Character (50) | This field is a drop down of either Equipment or Functional Location. |
| Asset Id | MI_ASSET_ID | Character (255) | This field is required. |
Spares Worksheet
The following table lists the fields from the Spares worksheet that must be configured.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BatchKey | MI_Batch_Key | Character (50) | This field is required and must match the Batch Key in the Spares Analysis worksheet. |
| Spare Name | MI_SPARE_SPARE_ID_C | Character (255) | This field is required and must be unique. |
| Onsite Delivery Time | MI_SPARE_ONSIT_DT_VALUE_N | Numeric | This field is required. |
| Onsite Delivery Time Unit | MI_SPARE_ONSIT_DT_UNIT_C | Character (50) | This field is a drop-down list. |
| Normal Order Time | MI_SPARE_NORM_OT_VALUE_N | Numeric | This field is required. |
| Normal Order Time Unit | MI_SPARE_NORM_OT_UNIT_C | Character (50) | This field is a drop-down list. |
| Expedited Order Time Value | MI_SPARE_EXPE_OT_VALUE_N | Numeric | This field is required. |
| Expedited Order Time Unit | MI_SPARE_EXPE_OT_UNIT_C | Character (50) | This field is a drop-down list. |
| Holding Cost Rate($) Per | MI_SPARE_HOLDI_COST_RAT_N | Numeric | This field is required. |
| Holding Cost Unit | MI_SPARE_HOLDI_COST_UNI_C | Character (50) | This field is a drop-down list. |
| Normal Cost ($) | MI_SPARE_NORM_COST_N | Numeric | This field is required. |
| Expedited Cost ($) | MI_SPARE_EXPE_COST_N | Numeric | This field is required. |
| Minimum Holding Level | MI_SPARE_MIN_INVEN_LEVE_N | Numeric | Must be a whole number. |
| Maximum Holding Level | MI_SPARE_MAX_INVEN_LEVE_N | Numeric | Must be a whole number. |
| Current Holding Level | MI_SPARE_CUR_HOLDI_LEVE_N | Numeric | Must be a whole number. |
Application Worksheet
The following table lists the fields from the Application worksheet that must be configured.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BatchKey | MI_Batch_Key | Character (50) | This field is required and must match the Batch Key in the Spares Analysis worksheet. |
| Spare Name | MI_SPARE_SPARE_ID_C | Character (255) | This field is required and must match the Spare Name in the Spare worksheet. |
| Application Name | MI_SPARAPPL_APPL_ID_C | Character (50) | This field is required. |
Population Worksheet
The following table lists the fields from the Population worksheet that must be configured.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BatchKey | MI_Batch_Key | Character (50) | This field is required and must match the Batch Key in the Spares Analysis worksheet. |
| Spare Name | MI_SPARE_SPARE_ID_C | Character (255) | This field is required and must match the Spare Name in the Spare worksheet. |
| Application Name | MI_SPARAPPL_APPL_ID_C | Character (50) | This field is required and must match the Application Name in the Application worksheet. |
| Name | MI_SPAPPOPU_NAME_C | Character (50) | This field is required and must be unique. |
| Age | MI_SPAPPOPU_AGE_N | Numeric | This field is required. |
| Population Size | MI_SPAPPOPU_POPU_SIZE_N | Numeric | This field is required. |
| Age Time Unit | MI_SPAPPOPU_AGE_TIME_UNIT_C | Character (50) | This field is required. |
Failure Distribution Worksheet
The following table lists the fields from the Failure Distribution worksheet that must be configured. Based on what Distribution Type is selected, fields associated with that will also be required. For instance, if Lognormal is selected, then the Sigma-Lognormal field and Gamma-Lognormal field will also be required for numeric values to be entered.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BatchKey | MI_Batch_Key | Character (50) | This field is required and must match the Batch Key in the Spares Analysis worksheet. |
| Spare Name | MI_SPARE_SPARE_ID_C | Character (255) | This field is required and must match the Spare Name in the Spare worksheet. |
| Application Name | MI_SPARAPPL_APPL_ID_C | Character (50) | This field is required and must match the Application Name in the Application worksheet. |
| Analysis Name | MI_AN_ANALY_ID_CHR | Character (255) | This field is required and must match the Analysis Name in the Spares Analysis worksheet. |
| Distribution Type | MI_AN_ANALY_TYPE_CHR | Character (50) | Select from the dropdown list of distribution types. |
| Time Unit | MI_DISTRIB_UNITS_CHR | Character (50) | This field is a drop-down list. |
Failure Consequences Worksheet
The following table lists the fields from the Failure Consequences worksheet that must be configured.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BatchKey | MI_Batch_Key | Character (50) | This field is required and must match the Batch Key in the Spares Analysis worksheet. |
| Spare Name | MI_SPARE_SPARE_ID_C | Character (255) | This field is required and must match the Spare Name in the Spare worksheet. |
| Application Name | MI_SPARAPPL_APPL_ID_C | Character (50) | This field is required and must match the Application Name in the Application worksheet. |
| Preparation Time | MI_SPARAPPL_PREP_TIME_VALU_N | Numeric | This field is required. |
| Preparation Time Unit | MI_SPARAPPL_PREP_TIME_UNIT_C | Character (50) | Select from the dropdown list of distribution types. |
| Repair Time | MI_SPARAPPL_REP_TIME_VALUE_N | Numeric | This field is required. |
| Repair Time Unit | MI_SPARAPPL_REP_TIME_UNIT_C | Character (50) | Select from the dropdown list of distribution types. |
| Labor Cost ($) | MI_SPARAPPL_PM_LABOR_COST_N | Numeric | This field is required. |
| Fixed Lost Production ($) | MI_SPARAPPL_FIXED_LP_COST_N | Numeric | This field is required. |
| Variable Lost Production Cost Rate ($) | MI_SPARAPPL_VARIA_LP_COST_N | Numeric | This field is required. |
| Unit | MI_SPARAPPL_VARIA_LP_UNIT_C | Character (50) | Select from the dropdown list. |
| # of Required Spares | MI_SPARAPPL_REQUI_SPARE_N | Numeric | Must be a whole number. |
Preventive Maintenance Worksheet
The following table lists the fields from the Preventive Maintenance worksheet that must be configured.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BatchKey | MI_Batch_Key | Character (50) | This field is required and must match the Batch Key in the Spares Analysis worksheet. |
| Spare Name | MI_SPARE_SPARE_ID_C | Character (255) | This field is required and must match the Spare Name in the Spare worksheet. |
| Application Name | MI_SPARAPPL_APPL_ID_C | Character (50) | This field is required and must match the Application Name in the Application worksheet. |
| Enable Preventive Maintenance | MI_SPARAPPL_ENABL_PM_F | Boolean | Select from the dropdown list. |
| Time-Based Replacement Interval | MI_SPARAPPL_PM_INTER_VALUE_N | Numeric | This field is required. |
| Time-Based Replacement Interval Unit | MI_SPARAPPL_PM_INTER_UNIT_C | Character (50) | Select from the dropdown list. |
| Labor Cost ($) | MI_SPARAPPL_PM_LABOR_COST_N | Numeric | This field is required. |
| Downtime | MI_SPARAPPL_PM_DURAT_VALUE_N | Numeric | This field is required. |
| Unit | MI_SPARAPPL_VARIA_LP_UNIT_C | Character (50) | Select from the dropdown list. |
About the Spares Data Loader Load Verification
Following a successful data load, you can navigate to the Spares Analysis section of the RA Overview page and view the analysis created from the imported workbook.
A successful import can also be defined as an event where partial data on a worksheet was loaded into APM, and where the user was given appropriate messaging that enabled him or her to identify and correct issues resulting from the import.