Data irregularities may be present in data imported from files. These are typically related to rod changes, but may also represent data transmission errors:
Ranges can be applied to data with an action that determines what operation is performed on the data in the range:
•Average - averages values between the start and end of the range (default setting)
•Delete - sets data in the range to -888
•Maintain - uses the original data without deleting the range
Ranges can be created manually or using filters.
Manual
Ranges can be added by defining a start and end depth on the qc chart by double-clicking.
 Double-click on the start depth:
 Double-click on the end depth:
 Note
|
If the new range intersects with one of more existing ranges, these will be replaced with the new range.
|
|
Filters
Four filter methods can be used to automatically create ranges based on test data:
•Constant Increment - creates ranges at constant intervals, in the absence of time stamp or flag data without the sensitivity of the tip variance filter
•Tip Variance - creates ranges based on changes in tip data that fall outside an accepted variance ratio
•Time Stamp - creates ranges based on gaps in time stamp data, indicating possible pauses in the push
•Flag - creates ranges using a specific flag value
|
Filters can be run during import.
|
Click the Constant Variance button:
Enter the Start Depth, Interval and Thickness, then click the OK button:
|
Start Depth - sets the depth to start creating ranges.
Interval - sets the value that is used to increment the creation of ranges.
Thickness - sets the thickness of the range.
|
|
Click the Tip Variance button:
Enter the Minimum Value, Variance Ratio and Records, then click the OK button:
|
Minimum Value - sets a value below which the check is not performed.
Variance Ratio - the difference between adjacent values.
Records - sets the number of records included in the range.
Examples
|
•if the current value is 10 MPa the next value cannot be less than 9 MPa or greater than 11 MPa. •if the current value is less 1 MPa, the check is not performed. |
|
|
Click the Time Stamp button:
Enter the Difference and Records, then click the OK button:
|
Difference - sets a value that is used to infer a pause in penetration.
Records - sets the number of records included in the range.
|
|
Click the Time Stamp button:
Enter the Column, Value and Records, then click the OK button:
|
Column - sets the column to search.
Value - sets the value to search for.
Records - sets the number of records included in the range.
|
|
Select the Range to delete in the grid:
Right-click the grid to show the contextual menu:
 Click Delete (or Delete All to removal all Ranges).
|
How To: Create ranges during import