Creating PLSS Campaign Type Corrosion Assessment Pipelines

The import files used in this part of the handbook are available in the IMS-PLSS Campaign Import Excelfiles.zip.

In this example the Corrosion Assessment should be performed on the following Pipelines with Plancodes:

In this example, we will create the FLOCs and Equipment first. Normally, these are already available in PLSS.

To create the Workpack and import data after the inspection has been performed:

1. Import the FLOCs, only needed to run this example.
2. Import the Equipment, only needed to run this example.
3. Import MAOP
4. Create the inspection schedules
5. Add the scope, Plancode and Inspection Locations to the Schedules.
6. Final approved the Schedules.
7. Create the Campaign.
8. Select the Equipment for this Campaign.
9. Select the Schedules for this Campaign.
10. Review Anomalies.
11. Review the Scope.
12. Final approve the Campaign.
13. Create the Workpack.
14. Execute the work.
15. Import the data.

Note: steps 1 to 9 are normally a once-off setup for the Campaign. Once a campaign has been completed and a new one created the user will start at step 10. Steps 1 to 9, with the new schedule numbers, will automatically be copied to the new campaign.

Step 1: Import the FLOCs

The FLOCs can be created in your test environment by importing the file
 Step 1 ImportFlocs.xlsx

The file has the following layout:

Note that in this import file the specified "Unit ID", in column A, is set to Example Campaign. So, this unit has to be added to the hierarchy, otherwise, you will get an error during the import.

Under this FLOC both the pipelines will be added for the CP test post survey and this example Corrosion Assessment Campaign.

To import the file Browse (1) to the import file, select the FLOC (2) and click Next (3):

After clicking Next you will be guided through the steps. All fields are filled in, only the Next button has to be clicked.

Step 2: Import the Equipment (pipelines)

The Equipment, in this example four pipelines, are in file Step 2 Import PipelineEquipments.xlsx. 

To import the Equipment: 

• Browse to the file.
• Select the option "Pipeline Equipment".
• Click Next.

After importing, the four pipelines will be shown on the Equipment Main screen. In the example, only Unit "Example Campaign" has been selected and the pipelines have been pinned:

Step 3: Import the MAOP

The MAOP are in the Excel file Step 3 Import MAOP history.xlsx with the following layout:

To import the MAOP:

• Browse to the file.
• Select the import option "MAOP history".
• click Next a few times,

Step 4: Import the Schedules

The Schedules are defined in Excel file Step 4 Import Schedules.xlsx with the following layout:

To import the Schedules:

• Browse to the file
• Select Schedules
• Click Next a few times.

After the Schedules have been imported, they are shown in the Schedule Main screen (in the example below the 4 pieces of Equipment have been pinned):

Note that Scope and Plancode are empty. These will be specified in the next step.

Step 5: Import the Scope and Plancodes

This is not an easy step and requires some knowledge of Excel functions, for example, the VLOOKUP function.

In this import:

• The Schedule number from the previous step should be used.
• The Scope and Plancodes should be linked to the schedule number.

For example:

Note that in Excel:

• Column A is the Schedule number (can be extracted from PLSS by an export).
• Column B, the Scope is always "ASSESSMENT".
• Column C, the Plancodes, because on the first Schedule, both the Internal and External Corrosion Assessments have to be performed the same schedule number is on rows 2 and 3.

Some tricks are explained in Creating PLSS Campaigns Type Underwater Eq. Activities 

After the import file has been updated, import it. 

To import the file:

• Browse to the file.
• Select "Scope and plan codes".
• Click Next a few times.

After the import the Scope and plancodes will be available in the Schedule Main screen (sometimes you have to press the Refresh or F5 function key):

Step 6: Approve Schedules

To approve the Schedules in bulk:

• Select the four Schedules.
• Click the Approval button.

•  Clicking Approve.

After the Approval the green vertical line is visible and the Next Insp date has been filled in.

Step 7: Create the Campaign

• Click the Plus button in the Main menu.

 

• Fill in the data in the dialog below with Campaign type "Corrosion assessment pipelines":

Step 8: Add Equipment IDs to the Campaign

In this section, the pieces of Equipment that are part of the Campaign should be selected. To select the Equipment:

• Click the Plus button.

Only the Equipment with a Schedule with Plancode "Internal or External Corrosion Assessment" will be shown. 

• Select the four pipelines.
• Click the OK button.

This will show an overview of the Equipment and the Schedules that are available for this Equipment:

The Equipment section shows an overview of the selected pipelines. The Schedule section shows an overview of corresponding Schedules based on the Campaign type.

Note that one piece of Equipment can be part of more than one Campaign, a Schedule can only belong to one Campaign.

Step 9: Add Schedules to the Campaign

To add the Schedules to the Campaign:

• Select the four Schedules.
• Click Add to the Campaign button.

This will result in a selection in the column In Campaign and an overview in the Workpack Scope:

Step 10: Review Anomalies

An overview of Anomalies for the selected Equipment and Schedules will be shown here.

In a future release, the Anomalies will be exported to the Workpack in a separate worksheet. The Anomaly number will be shown in the Workpack.

Step 11: Review Campaign Scope

This section provides an overview of Equipment, Schedules, Inspection Locations (if any) and Plancodes that will be exported to the Campaign Workpack.

Before the Workpack can be exported the campaign has to be Final Approved.

Step 12: Final Approve the Campaign

To Final Approve the Campaign:

• Clicking the green Approve button.

The following screen will be shown:

This will adapt the Next inspection date on the Schedules. Before Approval it looks as follows on the Schedule:

After Approval the Next inspection date has been set to the Campaign date, in this example 8-Dec-2021:

Step 13: Create the Workpack

After clicking the Export button to create the Workpack,

two Excel files will be created:

• Int. Corr. Assessment.xlsx
• Ext. Corr. Assessment.xlsx

It should be in one Excel file, currently two.

There is no hidden lookup table in the Excel file needed for the corrosion morphology column which is available in the current templates:

The column titles in the Excel file are self-explanatory. The user should not change or remove column titles.

In the Excel file, the you have to :

• Fill in the past and future corrosion rates.
• Review the corrosion morphology and the confidence rating. These have been copied from the last specified ECH.

Step 14: Fill in the data in the Workpack

An example:

For testing the two Excel files will have the following data:

For Internal:

For external:

The problem if you split it is that there will be two ECHs created and then two Schedules with separate Schedules while in the example above one Schedule had two plancodes.

Step 15: Import the Workpack

Currently imported via Import Wizard

Excel file names in this example:

• Ext. Corr. Assessment[20210628_0713].xlsx
• Int. Corr. Assessment[20210628_0713].xlsx

See also Importing Campaing Workpack Excel Files.

Step 16: Review the created ECHs

Schedules with the same number will be shown on one ECH.

Step 17: Close the Campaign and create a new one

After all the Schedules have been credited in an ECH and all these ECHs have been Final Approved then the Campaign will automatically become inactive and Status will be set to "Closed".