Borehole Log Columns

Borehole data in a log is presented in various Log Columns. To edit log columns of a borehole log template:

1. Go to Report Templates page.
2. Edit the desired borehole log template from the list. This opens a new page.
3. Scroll to the lower potion of the page to see the list of log columns.

List of Log Columns

The lower portion of the page on log template design page shows the list of log columns. The first row on this table represents the first log column from the left; The last row on this table represents the rightmost log column on the borehole log template.

Order of Log Columns

The order of log columns (rows in the table) determines the order they appear in the borehole log: the first log column in the table will be the first column on the left, then the second columns and so on. To change the order of the log columns in this log template, click on the 'handle' on the left end of that row and drag it to the desired position.

Height of Column-Headers

You can specify the height of the column-header row using the textbox on the top-right corner of the table (see screenshot above).

Blank Space

As you make changes in the list of log columns the program calculates the 'blank space' on the log. This is calculated based on the paper width, left and right margins, and the total width of all log columns. The 'blank space' is shown at the top-right corner of the table.

Log Column Types

When you add a new log column or edit an existing one, the column shows either a Text / Number in the borehole log or presents data in Graphic format.

The following properties should be entered for a log column:

• Column Type: select from Text/Number and Graphic options.
• Column-Header Text: the title of the log column shown on the borehole log. This text can be multi-line and you can format it by selecting part of the text and pressing these shortcuts:
  • Ctrl+B: to make the selected text bold.
  • Ctrl+I: to make the selected text italic.
  • Ctrl+U: to make the selected text underlined.
• Column Width: determines how wide the log column should be displayed (mm / inch).
• Additional Settings: depending on the log column selected, additional settings may be available (see below for details).

Text/Number Columns

These log columns show either a number (e.g. blow counts, moisture content, etc) or a text (e.g. lithologic description, depth related remarks, etc). The log columns available in this category include:

• Comment / Additional Notes: displays comments or remarks at specific depths in the borehole log (e.g., drilling notes, seepage, change in the drill method or casing size etc.). The source of this column is the data entered in the Comments tab of test hole edit page.
• Discontinuities: displays the discontinuities data in a tabular format. This is the data entered in the Discontinuities tab of the test hole edit page.
  • Select Sub-Columns: User can select which sub-columns should be included in log. Please note a minimum 5 mm width is required for each sub-column.
• Drill Run Info: displays the drill run data in a tabular format. This is the data entered in the Drill Runs tab of the test hole edit page.
• Select Sub-Columns: User can select which sub-columns should be included in log. Please note a minimum 5 mm width is required for each sub-column.

• Lithologic Description: displays the data entered for soil/rock layers in the Stratigraphy tab of the test hole edit page.
  • Show Depth & Elevation of the Layers: if selected, the depth and elevation of bottom of each layer will be shown in the log column (see below). You can also define whether these numbers should be presented As Entered (i.e. in project unit system), Always in Feet, or Always in Metres.

• Layer Elevation / Depth Bar: displays a column with the elevation and depth of top of each layer.
• Method of Investigation: displays two sub-columns in the log: Method of Investigation (e.g. auger drilling, etc.), and Drill Rig. The source of this column in the data entered in the Boring Details tab of test hole edit page.
• Samples: displays sample information as a column in the log. The source of this column in the data entered in the Samples tab of test hole edit page.
  • Show Sample Number: if selected the sample number will be shown as a sub-column.
  • Show Moisture Level: if selected, sample moisture conditions will be shown in a sub-column (e.g. D for Dry, DM for Dry to Moist, etc.). The moisture descriptors could be customized on Settings page > Field Investigations tab > Sampling and Boring tab.
  • Show RQD: shows the RQD of the sample.
  • Show Recovery: shows the Sample Recovery.
  • Show Sample Type: if selected, the sample type sub-column will be shown next to the sample number. User can select to show Symbols (e.g. AS, CC, etc defined on the Settings page) or Icons according to the list of sample types defined on Settings page.
  • Show Color: shows the Color of the sample.
  • Show Sample Guide Lines: if selected, lines will be drawn in all lab test log columns at depths corresponding to the top and bottom of the sample.

• Atterberg Limits: displays the results of Atterberg Limits test, as entered in Lab Tests page.
  • Show PI Instead of PL: by default, the Atterberg Limits column shows Liquid Limit (LL) and Plastic Limit (PL) in the log. User can select to show Plasticity Index (PI) instead of PL.
• Field Test Results: displays the results of a field test (e.g. SPT, Hydrocarbon, etc) at each depth, as entered in the Field Tests tab of the test hole data entry page.
  • Select Field Test: click on the dropdown to select the field test for which the results are presented in the log.
• Gradation Test: displays the results of gradation test as percent clay, silt, sand and gravel, as entered in Lab Tests page. This columns displays three sub-columns: Fines (%), Sand (%), and Gravel (%).
• Lab. Test Results: displays the results of a lab test carried out on samples, as entered in Lab Tests page.
  • Select Test Category: refers to the data entry tabs on the Lab Tests page.
  • Select Lab. Test: depending on the selected Test Category, select the lab test for which the results should be shown in the borehole log.
• Summary List of Lab Tests: displays a list of lab. tests carried out on a specific sample (includes acronym of lab. tests, not the test results).

Graphic Columns

These log columns show either a graph or some sort of drawing, and are further broken down below:

• Depth Scale: shows a depth scale in the log. User can select to show metres and/or feet on the depth scale.
  • Feet: if selected, the depth scale shows feet only (left half of the scale).
  • Metres: if selected, the depth scale shows metres only (right half of the scale).
  • Show Water Level Symbol: if selected, groundwater level symbol (hollow triangle) will be shown on the depth scale column. The source of this water level is General tab of test hole edit page.
  • Depth Label Interval: determines how often the depth labels are printed along the column.
  • Tick-Marks: determines the frequency of minor and major tick-marks along the depth scale.
• Drill Run: displays the results of TCR, SCR, TMR, RMR, etc as a stepped graph in the borehole log. The source of this column in the data entered in the Drill Runs tab of test hole edit page.
• Select Sub-Columns: for each sub-column selected, you can specify the color and direction of the plot:
  • → means the horizontal axis increases to the right; and
  • ← means the horizontal axis increases to the left.

• Elevation: displays the variation of elevation along the depth of the borehole. The top of Elevation log column on the first page of the borehole log matches with the borehole collar elevation entered in the General tab > Coordinates section. User can set the depth interval as well as the frequency of tick-marks.
• Lithological Symbol (hatch pattern): displays the hatch pattern (legend) of a stratum. This is based on the hatch patterns selected in Stratigraphy tab of test hole edit page.
  • Hatch Options: during defining a stratum, hatch pattern may be selected from the main categories: USCS (Unified Soil Classification System), AASHTO (American Association of State Highway and Transportation Officials), AGS (Association of Geotechnical & Geoenvironmental Specialists - UK), Rock, and Other.
  • Color Settings: user can select both foreground and background colors of a hatch pattern on the Settings page > Hatch Designs tab.
• Piezometer / Well: displays the details of piezometer/well construction for a test hole entered in the Instrumentation > Piezometer / Well tab of test hole data entry page.
  • Include Water Level Measurements: if selected, groundwater level measurements entered in Groundwater Monitoring section of the Piezometer / Well tab will be displayed in the log.

• Atterberg Limits & Moisture Plot: displays the variation of Atterberg limits tests along the depth of a test hole. The source of this graph is the Liquid Limit and Plastic Limit entered in the Lab Tests page.
  • Show Gridlines: if selected, gridlines will be show at every 1 ft or 1 m of depth.
• Field Tests: displays the variation of field tests along the depth as a graph. This is based on the data entered in Field Tests tab of test hole edit page.
  • Select Field Test to Show: user can select the field test from the dropdown list.
  • Show Gridlines: if selected, gridlines will be show at every 1ft/1m of depth.
  • Draw the Graph Line: if selected the line connecting data points will be drawn in the graph (see below screenshot).
  • Draw Data Points: if selected, for each data entry a black circle will be drawn in the graph.
  • Draw Data Labels: if selected, for each data entry the value of the field test will be printed in the graph.
  • Min. (X Axis Range): determines the minimum value used for the horizontal axis (i.e. field test result) of the graph. If not entered, zero will be used.
  • Max. (X Axis Range): determines the maximum value used for the horizontal axis (i.e. field test result) of the graph. If not entered, 100 will be used.
  • Divisions (X Axis Range): determines the number of divisions used for the horizontal axis (i.e. field test result) of the graph.

• Graph (customizable): This log column allows plotting multiple soil parameters on the same graph (e.g. SPT blows, moisture, pocket penetrometer, LL and PL).
  • Graph Settings: Click on the cogwheel icon next to the Select Log Column dropdown to select the gridline settings.
  • New Data Series: click on this button to add a new parameter to the graph.
  • Test Category: select the soil parameter from the list of field tests or lab tests.
  • Graph Settings: click on the cogwheel button. This will open a new dialog box with the following options:
    • Legend Settings: enter legend title, minimum, maximum and number of divisions for selected parameter.
    • Graph Type: select the type of graph.
    • Marker Settings: select the settings of the marker shown at each data point.
    • Line Settings: select the settings of the line drawn between the data points.
    • Data Labels: if selected, the value associated with each data point will be shown beside its marker.

Multiple Datasets On the Same Graph

In order to show multiple parameters (e.g. SPT blow counts, moisture, pocket pen, etc) on the same graph, please use the new Graph (customizable) log column described above.