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.

Column-Header Height

The height of the column-header row is specified using the textbox on the right side of the table (see screenshot below).

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 size, margins, and log column widths. The 'blank space' is shown at the top-right corner of the table.

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 icon on the left end of that row and drag it to the desired position.

Types of Log Columns

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

The following properties should be entered for all log columns:

• Column-Header Text: the title of the log column shown on the borehole log.
• Column Width: determines how wide the log column should be displayed (mm / inch).
• Additional Settings: depending on the type of log column selected, additional settings may be available (see below for details).

Text / Number Log 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). These types of columns are further broken down into two categories:

General tab

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.

Test Results tab

The log columns available in this category include:

• 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).

Graphical Log Columns

These log columns show either a graph or some sort of drawing, and are further broken down into these two categories:

Basic tab

• 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.
• 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.

• 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.

Test Results tab

• 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.