Pages are spreadsheet like views onto the relational database which underlies p:IGI+ and Metis Transform and show the values of properties (columns) across samples (rows). Pages within the applications provide a comprehensive and flexible way to view, organise, validate, interact with and edit project data.
Version: 1.14+ (Nov 2018)
Usage: Existing pages accessed and opened from the artefact manager
How to use in practice
In contrast to p:IGI-3 where a properties associated analytical technique was loosely inferred from the page title on which it was located (in certain cases several analytical techniques were present on a single page e.g. Pyrolysis / Hydrocarbons), in p:IGI+ and Metis Transform properties are clearly and individually linked to an analytical method. The concept of pages within the software has thus changed from an association with analysis type, as was the case in p:IGI-3, to being just a view onto a desired selection of properties (any property or group of properties from any analysis group can be arranged as wished on any page).
Every project contains a preliminary set of data pages organised into categorised folders, sub-divided to provide Analysis views and Interpretation views (the default structure was updated in version 2.0 as illustrated below):
- Analysis View folder: pages are divided into folders based on analytical approach and each page relates to an associated property Analysis Group.
- Interpretation View folder: Pages gather properties from a common Petroleum Systems Analysis (PSA) interpretation theme e.g maturation or source deposition.
The first set of pages provide an overview of the samples, for properties associated with well and non-well (e.g. outcrop) locations respectively, providing information relating to the sample: location, stratigraphy, and any reference information for the samples.
There is no limit to the number of pages a user can have within a project and the initial set of pages present when a project is started are completely customisable.
Pages are a collection of either predefined (either by IGI or another user) or user chosen geochemical properties for which there may or may not be data loaded in the project. There are a variety of different columns types which may be encountered.
- Key Columns: A reference information column which appears at the beginning of every page (if activated) - these are frozen to ensure they are always visible on a horizontal scroll. Column behaviour is exactly the same as if on the page, depending on the column type e.g. text column with pick list. Data can be edited in a Key Column and changes will update the property on all other pages on which that property occurs. Manual copy of the column contents is permitted.
- Well Name Column: A special text column with a pick list. The pick list displays all pre-existing project wells. Manual import is permitted on a single cell basis only and if this consists of a new entry the system will auto create a new well (in p:IGI+). Data can be copied.
- Text Column: A column capable of accepting alphanumeric data. There are no strong limitations on the length of text that can be entered here, but care should be taken to avoid inserting special characters, for example end of line or line feed characters.
- Text Column with Pick List: An alphanumeric column, accompanied with a suggested pick list of entries created from the associate property codelist. Text here is limited to 430 characters.
- Numeric Column: A column capable of accepting numerical data. Data should always be entered using a full stop "." as the decimal separator, even when the computer on which the software is running uses a locale that employs a different decimal separator.
- Calculated Column: Calculation columns possess associated formulae to derive a value from raw data. If the required equation input raw data is present, and there is an absence of manual data, then the cell will auto-calculate (green italicised text). Manual typing (black text) is permitted to the column cells and this will overwrite the auto-calculated values. To force calculation of a value delete the contents of the cell. Note for any calculated value, if any of the inputs change the value will immediately and automatically be recalculated.
- Date-time Column: A column for date-time values. From version 2.0 onward date-times are managed fully across the system including pages. A date-time column, for example Sam date.Sample, allows the user to enter and view date time data. The formatting selection (in the header) allows the user flexibility to say how date-times are shown, and the display will respect your local windows system date-time preferences (e.g. if your region settings are US, dates will be shown in MM/DD/YYYY format). When typing into date-time cells the application will try and convert what you type to a valid date. We recommend using the standard ISO8601 format: e.g. 2021-08-01 12:34, however the system will try and parse what you type according to your windows region settings, so is flexible in terms of what will be recognised. We always store dates in ISO8601 format and convert times to UTC (Universal Time Coordinates). If you need to enter time values in different time zones use the format: 2021-08-01 12:34-05:00 which would be Houston time for example (Houston is 5 hours behind UTC in daylight saving time!).
- Well Information Column: Apart from the Well Name column (B), all well information columns are display only columns. They are locked for edit through the page, and can only be accessed and edited through well artefacts. These columns can be copied.
- Collated Any Column: Any columns are display only columns which gather information from the relevant properties that contribute to the selected .Any property. These columns are locked for manual edit (grey text, darker column header). Editing of the property values needs to happen in the individual property columns, and automatically updates the .Any column. Manual copy of the columns contents is permitted, however the source is not copied, only the value.
© 2022 Integrated Geochemical Interpretation Ltd. All rights reserved.