Exclude Fines Layers

A fines layer is defined by consecutive rows that have been classified as "fine" in the Soil_Type_1 field. If the fines layer is thicker than a predetermined length, then the Exclude field is checked and records within a buffer distance are also have Exclude checked. The Exclude field can be used to control what records print on the CPT reports.

The minimum thickness to exclude the Fines layer can be defined in the Exclude_Fines_Layer_Thickness field in the CPT_PROJECT_PARAMETERS table or the CPT_POINT_PARAMETERS table. The value in the CPT_POINT_PARAMETERS table takes precedence. Likewise, the buffer thickness of the records above and below the fines layer to exclude can be defined in the field in the Exclude_Fines_Layer_Buffer field in the CPT_PROJECT_PARAMETERS or the CPT_POINT_PARAMETERS table.

This function requires the following fields to be present:

  • CPT_DATA table
  • Exclude, type Boolean, cell colour Field - Calculated
  • CPT_POINT_PARAMETERS table,
  • Exclude_Fines_Layer_Thickness, type Double, Unit m, Cell colour Field – Enter Data
  • Exclude_Fines_Layer_Buffer, type Double, Unit m, Cell colour Field – Enter Data
  • CPT_PROJECT_PARAMETERS table
  • Exclude_Fines_Layer_Thickness, type Double, Unit m, Cell colour Field – Enter Data
  • Exclude_Fines_Layer_Buffer, type Double, Unit m, Cell colour Field – Enter Data

You may wish to add a Body Data Output Condition on plot vs. depth entities on reports to reference the Exclude field to determine whether or not to output the record.