Data import utilizes the standard import system with CPT specific file readers and the ability to define and run internal methods.
Export of data uses a limited Excel process to create files for each test that can be imported into 3rd party applications.
All use data mappings.
Data Mapping
During the data mapping process there's the opportunity to define system values (i.e. water depth, predrill depth, sleeve offset) and correction methods to automate the generation of ranges.
System Values
Values can be defined for water depth, predrill depth and sleeve offset. These can be expressions, that are evaluated from data stored in the file, or constant values:
**CPT_Setup
[CPT_Setup].[WaterLevel] = <<[SoundingHeader].[WaterLevel]>>
[CPT_Setup].[Predrill] = <<[SoundingHeader].[Predrill]>>
[CPT_Setup].[SleeveOffsetApplied] = <<0.07>>
Corrections
Multiple corrections can be defined in the data mapping header, with the order defining the processing order:
Source Type: gru
Source Template: C:\ProgramData\Geroc\DATA\Templates\External\CPT\GorillaTemplate.xlsx
Destination Type: mdf
Destination Template:
Procedures: usp_CPT_MaxDepth
Corrections: CptFilterInterval(0.5, 0.88, 0.05)
Shifts the original sleeve data relative to tip data. This can be used in combination with [CPT_Setup].[SleeveOffsetApplied] to reverse files that already have the sleeve data moved. Parameters •records (integer) - specifies the number of records to move the sleeve data |
Creates ranges at constant intervals, in the absence of time stamp or flag data without the sensitivity of the tip variance filter. Parameters •startDepth (decimal) - sets the depth to start creating ranges. •interval (decimal) - sets the value that is used to increment the creation of ranges. •thickness (decimal) - sets the thickness of the range. |
Creates ranges based on changes in tip data that fall outside an accepted variance ratio. Parameters •minimumValue (decimal) - sets a value below which the check is not performed. •varianceRatio (decimal) - the difference between adjacent values. •records (integer) - sets the number of records included in the range. |
Creates ranges based on gaps in time stamp data, indicating possible pauses in the push. Parameters •difference (decimal) - sets a value that is used to infer a pause in penetration. •records (integer) - sets the number of records included in the range. |
Creates range when a row that match the search condition is identified. Parameters •column (string) - name of the column to search. •value (integer) - value used to search using a wildcard format. |