Creating a Log and Fence Report Column for a new Correlation

Aim

In this tutorial, you will be creating a dynamic log column and fence column for the correlation Undrained Shear Strength, s_u. This tutorial assumes that the relevant fields and formula calculations have been created for Undrained Shear Strength as specified in Creating a New Correlation in the Formula Tool.

Creating the User System Data

  1. Go to DATA DESIGN | User System Data and select File > New. Enter DG CPT Param Undrained Shear Strength in the Name, optionally enter a description and click OK.

  2. Enter the following code in the Data or Expression field then click Save.

    <<Let(Param = <<ListBuildSepTrim(" ","Undrained Shear Strength",<<Get(ParamIndex)>>)>>)>>


    Your screen should look similar to the following:

Adding the Configuration to the Library Table

This step requires adding new records into the CPT Tool Library configuration tables, namely DG_CPT_SYMBOLOGY, DG_CPT_SYMBOLOGY_SCALES_UNITS, DG_CPT_LOG_BLOCK and DG_CPT_FENCE_BLOCK.

The correlation log/fence reports can display up to 6 variations/interpretations of a correlation, and each variation must be configured in these tables.  Each variation is denoted by an index number, starting from 1 to 6 inclusive.  The naming convention that the log and fence blocks utilise is as below:
[Correlation Name] [Index Number]
Therefore, the names of the Undrained Shear Strength correlation are as below:
Undrained Shear Strength 1
Undrained Shear Strength 2
Undrained Shear Strength 3
Undrained Shear Strength 4
Undrained Shear Strength 5
Undrained Shear Strength 6
The field names also follow this naming convention, except that spaces are replaced with underscores.  Therefore, the CPT_DATA field names for Undrained Shear Strength are as below:
Undrained_Shear_Strength_1
Undrained_Shear_Strength_2
Undrained_Shear_Strength_3
Undrained_Shear_Strength_4
Undrained_Shear_Strength_5
Undrained_Shear_Strength_6


  1. Go to DATA DESIGN | Library Data, and select DG_CPT_SYMBOLOGY from the yellow drop down list.
  2. Enter 6 new records in DG_CPT_SYMBOLOGY with the following values, replacing the # with the index number starting from 1 to 6, then click Save.

    Column Name

    Value

    Parameter

    Undrained Shear Strength #

    gINT Field Name

    <<CPT_DATA.Undrained_Shear_Strength_#>>

    SQL Field Name

    [CPT_DATA].[Undrained_Shear_Strength_#]

    SQL Table Name

    [CPT_DATA

    Line Type

    Solid

    Line Thickness

    0.2

    Data Marker Height Log

    0

    Show on Report

    True

    Name

    Undrained Shear Strength

    Abbreviation

    s<<SUB>>u<<SUB>>

  3. Set the following values for each parameter, then click Save.

    Parameter Name

    Line Colour

    Comparison Line Type

    Data Marker

    Undrained Shear Strength 1

    Very Light Blue

    Dash

    1

    Undrained Shear Strength 2

    Very Light Brown

    Dash-Dot

    2

    Undrained Shear Strength 3

    Very Light Red

    Dash-Dot-Dot

    3

    Undrained Shear Strength 4

    Very Light Green

    Dash1

    4

    Undrained Shear Strength 5

    Very Light Yellow

    Dash-Dash-Dot

    5

    Undrained Shear Strength 6

    Very Light Magenta

    Dot2

    6

    Your screen should look similar to the following:

  4. Select DG_CPT_SYMBOLOGY_SCALES_UNITS from the yellow drop down list and enter two sets of 6 records following values, replacing the # with the index number starting from 1 to 6, then click Save.

    1st Set:

    Column Name

    Value

    Unit System

    SI

    Parameter

    Undrained Shear Strength #

    Unit

    kPa

    Minimum Scale

    0

    Maximum Scale

    500

    Number of Divisions

    4

    2nd Set:

    Column Name

    Value

    Unit System

    English

    Parameter

    Undrained Shear Strength #

    Unit

    tsf

    Minimum Scale

    0

    Maximum Scale

    4

    Number of Divisions

    4

    3rd Set:

    Column Name

    Value

    Unit System

    SI_MPa

    Parameter

    Undrained Shear Strength #

    Unit

    kPa

    Minimum Scale

    0

    Maximum Scale

    40

    Number of Divisions

    4

    4th Set:

    Column Name

    Value

    Unit System

    SI_kg/cm2

    Parameter

    Undrained Shear Strength #

    Unit

    kPa

    Minimum Scale

    0

    Maximum Scale

    40

    Number of Divisions

    4



  1. Column Name

    Value

    Unit System

    English

    Parameter

    Undrained Shear Strength #

    Unit

    tsf

    Minimum Scale

    0

    Maximum Scale

    4

    Number of Divisions

    4

  2. Select DG_CPT_LOG_BLOCK from the yellow drop down list and enter a new record with the following values, then click Save. You may right-click and drag the row header to change the position of the record appears on the table.

    Column Name

    Value

    Name

    Undrained Shear Strength

    Description

    Undrained Shear Strength, su

    Log Width

    30

    Parameter

    Undrained Shear Strength

  3. Select DG_CPT_FENCE_BLOCK from the yellow drop down list and enter a new record with the following values, then click Save.

    Column Name

    Value

    Name

    Undrained Shear Strength

    Description

    Undrained Shear Strength, su

    Width

    10

    Parameter

    Undrained Shear Strength

Creating the Dynamic Log Block

To create the Dynamic Log Block, make a copy of an existing correlation Dynamic Log Block and modify it to work with the new correlation parameter. In this tutorial, you will be using the Friction Angle correlation parameter log block as the basis for our new log block.Creating the Dynamic Log Block

  1. Go to REPORT DESIGN | Logs then select Blocks > Edit Log Blocks. Select DG CPT FRICTION ANGLE from the yellow drop down list.
  2. Select File > Copy Page. Enter DG CPT UNDRAINED SHEAR STRENGTH in the Page names to copy to and click OK.

    At this stage, your screen should look similar to this:

    The references to the table fields and User System Data, and User Report Variables will be fixed at a later step.
    A reference must now be added to the new block to the Dynamic Log reports. From the current screen (REPORT DESIGN | Logs > Log Blocks), select DG CPT DYNAMIC COLUMNS from the yellow drop down list.
  3. Select Blocks > Insert Block and enter the following values, then click OK.

    Main Tab:

    Field Name

    Value

    Block Source

    Int!dg cpt undrained shear strength

    Page Range

    All

    Design Mode Colour

    Medium Blue

    Offset X

    <<Let(Block = "Undrained Shear Strength")>>_
    <<User System Data.DG CPT Dynamic Log Col Offset X>>

    Configuration Tab:

    Field Name

    Value

    Design Mode Offset X

    10

    Output Condition

    <<Let(Block = "Undrained Shear Strength")>>_
    <<User System Data.DG CPT Dynamic Log Col Output Condition>>

  4. Left click on a vacant space to place the Block reference, then click Save.
    Add a new User Report Variable to the Dynamic Log reports:
  5. Click on the Logs tab to return to the REPORT DESIGN | Logs screen. Select the log report CPT DYNAMIC A4P from the yellow drop down list, and select File > Page > Properties.
  6. Click on the User Report Variables button, and click on the Add Field button on the bottom left. Enter the following values into the fields and click OK.

    Field Name

    Value

    Name

    Undrained Shear Strength Width

    Type

    Memo

  7. Enter <<Let(Block = "Undrained Shear Strength")>><<User System Data.DG CPT Dynamic Log Col Width>> for the Value in the newly created User Report Variable, and click OK.
  8. Click OK to close the Properties window and save the changes.
    Copy the new User Report Variable to the other Dynamic Log reports:
  9. With the CPT DYNAMIC A4P report currently open, select File > Page > Copy Report Variables, select qe Width and click OK.
  10. Click on the List of pages to copy to button to bring up the selection dialog. Select the Dynamic Log Reports in your library, then click OK. Note you may not have all the reports in your library as shown below.
  11. Click OK to copy to User Report Variables to the selected Reports.

Creating the Fence Block

To create the Fence Block, make a copy of an existing correlation parameter fence block and modify it to work with the new correlation parameter. In this tutorial, you will be using the Friction Angle correlation parameter fence block as the basis for our new fence block.

Note that there are two blocks that need to be created, left and right. The fence blocks are suffixed by L and R to denote this.

  1. Go to REPORT DESIGN | Fences then select Blocks > Edit Fence Blocks. Select DG CPT FRICTION ANGLE L from the yellow drop down list.
  2. Select File > Copy Page. Enter DG CPT UNDRAINED SHEAR STRENGTH L in the Page names to copy to and click OK.
    Create the right block:
  3. From the current screen (REPORT DESIGN | Fences > Fence Blocks), select CPT FRICTION ANGLE R from the yellow drop down list.
  4. Select File > Copy Page. Enter DG CPT UNDRAINED SHEAR STRENGTH R in the Page names to copy to and click OK.
    Add a reference to the new fence block to the Fence reports:
  5. From the current screen (REPORT DESIGN | Fences > Fence Blocks), select DG CPT STICK from the yellow drop down list.
  6. Select Blocks > Insert Block and enter the following values for the left fence block, then click OK.

    Main Tab:

    Field Name

    Value

    Block Source

    Int!dg cpt undrained shear strength l

    Page Range

    All

    Design Mode Colour

    Very Light Blue

    Offset X

    <<Let(Block = "Undrained Shear Strength")>>_
    <<User System Data.DG CPT Fence Col Offset X L>>

    Configuration Tab:

    Field Name

    Value

    Design Mode Offset X

    -11.75

    Output Condition

    <<Let(Block = "Undrained Shear Strength")>>_
    <<User System Data.DG CPT Fence Col Output Cond L>>

  7. Left click on a vacant space to place the Block reference, then click Save.
  8. Repeat the above steps, and enter the following for the right fence block.

    Main Tab:

    Field Name

    Value

    Block Source

    Int!dg cpt undrained shear strength r

    Page Range

    All

    Design Mode Colour

    Very Light Red

    Offset X

    <<Let(Block = "Undrained Shear Strength")>>_
    <<User System Data.DG CPT Fence Col Offset X R>>

    Configuration Tab:

    Field Name

    Value

    Design Mode Offset X

    11.75

    Output Condition

    <<Let(Block = "Undrained Shear Strength")>>_
    <<User System Data.DG CPT Fence Col Output Cond R>>

    Add a new User Report Variable to the CPT Fence reports:

  9. Click on the Fences tab to return to the REPORT DESIGN | Fences screen. Select the log report CPT FENCE A4P from the yellow drop down list, and select File > Page > Properties.
  10. Click on the User Report Variables button, and click on the Add Field button on the bottom left. Enter the following values into the fields for the left fence block and click OK.

    Field Name

    Value

    Name

    Undrained Shear Strength Width L

    Type

    Memo

  11. Enter <<Let(Block = "Undrained Shear Strength")>><<User System Data.DG CPT Fence Col Width L>> for the Value in the newly created User Report Variable.
  12. Click on the Add Field button again, and enter the following values into the fields for the right fence block, and click OK.

    Field Name

    Value

    Name

    Undrained Shear Strength Width R

    Type

    Memo

  13. Enter <<Let(Block = "Undrained Shear Strength")>><<User System Data.DG CPT Fence Col Width R>> for the Value in the newly created User Report Variable.
  14. Click OK to close the Properties window and save the changes.
    Copy the new User Report Variable to the other CPT Fence reports:
  15. With the CPT FENCE A4P report currently open, select File > Page > Copy Report Variables, select Undrained Shear Strength Width L and Undrained Shear Strength Width R then click OK.
  16. Click on the List of pages to copy to button to bring up the selection dialog. Select the CPT Fence Reports in your library, then click OK.
    Note you may not have all the reports in your library as shown below.
  17. Click OK to copy to User Report Variables to the selected Reports.

Replace Field Names in Log and Fence Blocks

All references to the original parameter (Friction Angle) need to be replaced by the new parameter (Undrained Shear Strength). The quickest and least error-prone way to do this is to use the Replace Field Names command.
Go to DATA DESIGN | Project Database, then select Tools > Replace Field Names. Click on the Field List button and enter the following values in the table grid. The <<…>> is optional.

Find

Replace

<<CPT_DATA.Friction_Angle_1>>

<<CPT_DATA.Undrained_Shear_Strength_1>>

<<CPT_DATA.Friction_Angle_2>>

<<CPT_DATA.Undrained_Shear_Strength_2>>

<<CPT_DATA.Friction_Angle_3>>

<<CPT_DATA.Undrained_Shear_Strength_3>>

<<CPT_DATA.Friction_Angle_4>>

<<CPT_DATA.Undrained_Shear_Strength_4>>

<<CPT_DATA.Friction_Angle_5>>

<<CPT_DATA.Undrained_Shear_Strength_5>>

<<CPT_DATA.Friction_Angle_6>>

<<CPT_DATA.Undrained_Shear_Strength_6>>

<<Report Var.Friction Angle Width>>

<<Report Var.Undrained Shear Strength Width>>

<<Report Var.Effective Friction Angle Width L>>

<<Report Var.Undrained Shear Strength Width L>>

<<Report Var.Effective Friction Angle Width R>>

<<Report Var.Undrained Shear Strength Width R>>

<<User System Data.DG CPT Param Friction Angle>>

<<User System Data.DG CPT Param Undrained Shear Strength>>

  1. Click on the Reports to Scan button. Select the following items in the list then Click OK.
    • LogBlk!DG CPT UNDRAINED SHEAR STRENGTH
    • FenceBlk!DG CPT UNDRAINED SHEAR STRENGTH L
    • FenceBlk!DG CPT UNDRAINED SHEAR STRENGTH R
  2. Click OK to run the command. View the report to ensure that replacements were made and click OK.

    At this point, you have completed creating the Dynamic Log Block and Fence Block for the Undrained Shear Strength correlation parameter. Ensure that you have data in Undrained_Shear_Strength_#, and test the output of the new correlation in your Dynamic Log and Fence reports.
On this page