Import from APT-IGI Excel File

Importing APT generated, IGI ready, Excel files

To assist users who receive geochemical data from APT, IGI has been working with APT to produce an import friendly, flat format, Excel file. Below are notes to assist users importing their data from these files.

How to import APT generated, IGI ready, Excel files (Version 2.0)

Drag and drop the APT provided, IGI ready, Excel file onto the p:IGI+ (or Transform) workspace to start import.

In the first stage of import (steps to allow the linking template to work):
  1. Select Indicators are present: Contained in the property row: [ ]
  2. Select Ratios are present: Contained in the property row: { }
  3. Default Datums should read:
  1. The format of Date-Time in the Excel file is not ambiguous:
  1. Click Next to proceed to the property linking stage of import.
In the second stage of import (steps to link properties using a linking template):
  1. Load and apply the linking file provided below
  1. Click Import
Post import project edit:

SARA Fractionation: 

During import, the automatic calculations assume 100% of the extract/asphaltene precipitated sample is used during the respective SARA or SAR fractionation process. This is not always the case in APT’s practices. As a result, there might be a reason to manually copy and paste the sample weight data into the Sam Wt.SARA-Wt,  Sam Wt.SARA-Un or Sam Wt.SAR-Wt properties post-import.

 

How to import APT generated, IGI ready, Excel files (Version 1.28.7)

Drag and drop the APT provided, IGI ready, Excel file onto the p:IGI+ (or Transform) workspace to start import.

On the first stage of import (steps to allow the linking template to work):
  1. Set the First and Last header row as: 1
  2. Select Units are present: Contained in the property row: < >
  3. Set the First data row as: 2
  4. Default Datums should read:
  1. Click Next to proceed to the property linking stage of import.
On the second stage of import (steps to link properties using a linking template):
  1. Load and apply the appropriate linking file
  1. Click Import
Post import project edit:

SARA Fractionation: 

During import, the automatic calculations assume 100% of the extract/asphaltene precipitated sample is used during the respective SARA or SAR fractionation process. This is not always the case in APT’s practices. As a result, there might be a reason to manually copy and paste the sample weight data into the Sam Wt.SARA-Wt,  Sam Wt.SARA-Un or Sam Wt.SAR-Wt properties post-import.

 

© 2022 Integrated Geochemical Interpretation Ltd. All rights reserved.

search exit shift Show/Hide Sidebar Show/Hide Sidebar