---
title: "PL Internal Corrosion: Test Case 3 (no Schedule, data bulk import)"
slug: "pl-internal-corrosion-appendix-5-test-case-3"
updated: 2026-03-24T09:12:36Z
published: 2026-03-24T09:12:36Z
canonical: "ims-handbook.cenosco.com/pl-internal-corrosion-appendix-5-test-case-3"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://ims-handbook.cenosco.com/llms.txt
> Use this file to discover all available pages before exploring further.

# PL Internal Corrosion: Test Case 3 (no Schedule, data bulk import)

> [!NOTE]
> Take note
> 
> This overview provides detailed instructions for entering data for the Condition History of the Internal Corrosion Test Case, specifically focusing on [Case 3](/v410/docs/pl-internal-corrosion-appendix-1-introduction-test-cases). In this scenario, the data is imported in bulk, and the ECHs (Equipment Condition Histories) are also approved in bulk.

In Case 3, the data will be imported in bulk for Pipelines “IC Internal Corrosion Test Case P3” and “IC Internal Corrosion Test Case P4”*.* The data will be imported from the Excel file, “03 Import Int Corr. Assessment.Case3.ImportTemplate.xlsx.”, from the file “Data for User Manual IMS-PLSS PL 2 Internal Corrosion.zip” that you will find in the attachment of this article. Note: Make sure to download and unzip the file before starting the import.

The file contains the following data:

![Table Description automatically generated](https://cdn.document360.io/e492a0e0-a4ba-4aca-8fc6-76b95f91fdf3/Images/Documentation/pl-2-int-corr-temp-image-kjes7jo0.png?sv=2026-02-06&spr=https&st=2026-10-28T22%3A54%3A33Z&se=2026-10-28T23%3A54%3A33Z&sr=c&sp=r&sig=CC7qtMPeEDuYUcEB0MmtJB%2FdVDfGVIrS3fsv6C2bCo0%3D)

> [!NOTE]
> Take Note
> 
> Confirm that both the ECH Checklist column and Component column is filled in with “GENERAL“. Else the Internal Corrosion Assessment import will not work.

To import these data perform the following steps:

- Click **Settings** in the upper right corner.
- In the menu on the left, click **Data Transfer**.
- Click **Data Import** next.
- Click **Browse** and select file "03 Import Int Corr. Assessment.Case3.ImportTemplate.xlsx"
- Choose the file type for importing as “Int. Corr. Assessment”.

![Graphical user interface, text, application, email Description automatically generated](https://cdn.document360.io/e492a0e0-a4ba-4aca-8fc6-76b95f91fdf3/Images/Documentation/pl-2-int-corr-temp-image-b3645c0l.png?sv=2026-02-06&spr=https&st=2026-10-28T22%3A54%3A33Z&se=2026-10-28T23%3A54%3A33Z&sr=c&sp=r&sig=CC7qtMPeEDuYUcEB0MmtJB%2FdVDfGVIrS3fsv6C2bCo0%3D)
- In Step 2, from the Select Sheet drop-down menu, select “Data 2019”.

![Graphical user interface, text, application Description automatically generated](https://cdn.document360.io/e492a0e0-a4ba-4aca-8fc6-76b95f91fdf3/Images/Documentation/pl-2-int-corr-temp-image-hr57kq9w.png?sv=2026-02-06&spr=https&st=2026-10-28T22%3A54%3A33Z&se=2026-10-28T23%3A54%3A33Z&sr=c&sp=r&sig=CC7qtMPeEDuYUcEB0MmtJB%2FdVDfGVIrS3fsv6C2bCo0%3D)

- Click **Next** in the upper right corner a few times to import the data.
- Pin the Equipment "IC Internal Corrosion Test Case P3” and “IC Internal Corrosion Test Case P4”.
- Navigate to the ECH Main Screen.

The following data will be shown:

![Graphical user interface, text, application Description automatically generated](https://cdn.document360.io/e492a0e0-a4ba-4aca-8fc6-76b95f91fdf3/Images/Documentation/pl-2-int-corr-temp-image-5e30kyiv.png?sv=2026-02-06&spr=https&st=2026-10-28T22%3A54%3A33Z&se=2026-10-28T23%3A54%3A33Z&sr=c&sp=r&sig=CC7qtMPeEDuYUcEB0MmtJB%2FdVDfGVIrS3fsv6C2bCo0%3D)

- Select both rows.
- Click the *Approve* button in the toolbar. Note: Once the RBA assessment is completed, the indicator will change color. The specific color change will be based on the Design Corrosion Rate.

The indicator’s color is determined by comparing the worst Future CR to the design CR calculated in the RBA module. The indicator is colored as follows:
- Red: when the worst Future Corrosion Rate exceeds the Designed CR four times.
- Orange: when the future corrosion rate falls between one and four times the Design Corrosion Rate.
- Green: when the worst Future Corrosion Rate is less or equal to the Design Corrosion Rate.

Corrosion Rate

RCM Criticality

Risk Based Assessment

## Attachments

- [Data for User Manual IMS-PLSS PL 2 Internal Corrosion.zip](https://cdn.document360.io/e492a0e0-a4ba-4aca-8fc6-76b95f91fdf3/Images/Documentation/Data for User Manual IMS-PLSS PL 2 Internal Corrosion.zip)