Search Results

Data Entry

The test hole data entry page comprises several tabs:

Test Hole Data Entry Page
Test Hole Data Entry Page

Click the button button next to the tab headers to customize the tabs shown on this page. Use the dialog to re-arrange tabs or hide/show them as needed.

For several datasets on this page, data entry in done in tables. Please see this article for working with tables. If your data in stored in CSV files, you can directly import it to the desired table (read more).

Navigating to a Test Hole

Use the test holes dropdown on the header of the page to easily switch between boreholes of a Project:

Quality Management Status

The badge shown next to the borehole name in the test holes dropdown (on page header) indicates the Quality Management status of that borehole.

Previewing the Log

Click the Preview button on the top-right of the screen to generate the Test Hole Log. 

To select/assign the log templates to a borehole, select the gear icon next to the Preview button; this opens a dialog-box where you can select the following options:

  • Soil Log Template: select from the list of your log templates, 
  • Rock Log Template: select from the list of your log templates, 
  • Start Depth: each log template needs a start depth. For a rock log template, RSLog automatically detects the top of bedrock from the first stratum with ROCK classification assigned to it, 
  • Page Depth: use this field to override the page depth for selected log template,
  • Transition Text: this can be customized on the Settings page → Engine tab → Logs tab,
  • Apply to All Boreholes in This Project: use this checkbox to use the selected log template settings to all boreholes in this project, 
Selecting Soil and Rock Log Templates for a Test Hole

Groundwater Level

Please read this article about groundwater data entry and its presentation on the logs.  

General tab

In RSLog, test hole data is entered in different tabs beginning with the General tab. This tab is where you enter general details such as test hole name, depth, etc. The following provides further details:

Test Hole Type

Generally, a test hole is made either by ‘drilling’ (e.g. a borehole) or by ‘excavating’ (e.g. a test pit, trial pit or trench). As a result, the drop down options for Test Hole Type comprise of:

  • Drill Hole (borehole): any type of hole drilled manually (e.g. hand auger) or by using machinery (i.e. a drill rig).
  • Test Pit (trial pit, trench, pit): typically implies a larger hole dug using shovel or by an excavator.

Investigation Progress Status

The field investigation status of a test hole indicates at which drilling/excavating stage it is. Once user sets this status to Completed, the program will set the Quality Management status to Draft.

Coordinates 

While coordinates are not necessarily required for generating the log, to benefit from all RSLog features such as GIS system and Cross-Section Designer, we recommend that you enter coordinates and elevation for all your boreholes. Please read more about handling coordinates reference system.

If the exact coordinates of test holes are not available, we recommend that you specify their approximate location on the map by clicking Place on Map button.  

Verticality

Simple Plumbness option allows entering the trend (azimuth) and plunge of the test hole. Use Verticality Log option to upload the variation of trend and plunge along the depth of the test hole (CSV format). 

Location Details

More location specific data (e.g. Stationing, Offset etc.) for the test hole could be entered in this tab.

USACE

In this tab enter the data required by United States Army Corps of Engineers for presentation on the logs.

SPT Hammer & Sampler

Enter the details for the hammer and sampler used in Standard Penetration Tests (SPT).

Completion Notes

  • Start Notes: will be displayed in the borehole log at the top of the first page of the log, above the Lithologic Description log column.
  • Termination Notes: will be displayed in the borehole log at the bottom of the test hole (last page) below the Lithologic Description log column.
These data entries accept Rich Text Formatting; select a part of the text and use Ctrl+B (bold), Ctrl+I (italic), or Ctrl+U (underlined) to format the text. Please note that you can customize the default format of the Start Notes or Termination Notes and it accepts the following place-holder variables:
  • {name} for test hole name
  • {depth} for final borehole depth
  • {elevation} for borehole collar elevation
  • {water_depth} for groundwater depth
  • {water_depth_short_after} for groundwater depth short term after drilling
  • {water_depth_long_after} for groundwater depth long term after drilling
  • {spt_energy} for SPT hammer energy (%)

Extra Tags

In this section you can enter data for Extra Tags you created for test holes.

Extra Tags are additional properties that you can add to a test hole or project. User can edit the list of Extra Tags from Settings page → Data Entry → Extra Tags tab.

Samples tab

On the Samples tab, you can enter the list of samples taken from this test hole.

  • Depth: You can specify From (i.e. top depth) and To (i.e. bottom depth) for a sample. If your samples are identified by one depth only, leave the To field empty.
  • Sample No.: enter sample number for the sample (optional).
  • Location / Status: use this dropdown to specify at which location or state the sample is. For example: Collected in the Field, Being Transferred to the Lab, Disposed, etc. This list may be customized on the Settings page → Field Investigation tab → Sampling tab.
  • Color: enter sample color or click on the color-picker button to select from Munsell Colors.
  • Sample Type: select the method of sampling (required). The list of sample types may be customized on the Settings page → Field Investigation tab → Sampling tab.
  • Sampler Diameter: refers to the size of the sampler used.
  • Moisture Level: select the sample moisture level (optional). The list of moisture descriptors may be edited on the Settings page → Engine tab → Calibration tab.
  • Recovery Length (mm or inch): enter the length of sample recovered (optional).
  • Recovery %: enter sample recovery (optional). Click the calculator button to automatically calculate the Recovery % based on sample depth and Recovery Length.
  • Blow Count: refers to the SPT blow count if the sample is a SPT sample. Click the orange button next to the Blow Count to update the value from the SPT test.
  • RQD %: enter sample RQD (optional).
  • Shear Vane: enter the value of shear Vane test conducted on this sample (optional).
  • Torvane: enter the value of torvane test conducted on this sample (optional).
  • Pocket Pen: enter the value of pocket penetrometer test conducted on this sample (optional).
  • Sample Description: enter field description of the sample (optional).
     
RSLog can display long sample numbers in the borehole log with word wrap effect (i.e. in a Samples log column). However, the word wrap effect is only working when the sample has both From and To input data. This reserves a box in the borehole log (with top and bottom of the box being the From and To depths) where the sample number is written.

Field Tests tab

RSLog supports various types of field tests such as Standard Penetration Test (SPT), Vane Shear Test, Manual DCP soundings and more. The list of field tests and their data columns can be customized on the Settings page → Field Investigation tab → Field Tests. 

  • Depth Column: enter a value greater than or equal to zero.
  • Reporting Value Column: this is the legacy column allocated to test results. Most field tests have their own columns. Learn about customizing field tests.
  • Other Columns: additional columns will be available for data entry, depending on the field test selected.
For SPT test please see this article for displaying SPT blow counts in the log.

Comments tab

The Comments tab is used for adding depth-related comments to the test hole. These comment typically capture changes in the drilling advancement, presence of boulders, or equipment mechanical issues, etc. RSLog covers the following types of comments: 

  • Log (default): the comment will be shown in the borehole logs in the Comments/Remarks log column,
  • Internal Note: the comment is an internal note and will not be shown in the log, 
  • POI (depth/elevation): the comment is shown at the Point of Interest (POI), on the right side of the Depth or Elevation scale log column, 
  • POI (well/piezometer): the comment is shown at the Point of Interest (POI), on the Hole Construction log column,
In order for the Point of Interest comments to be displayed on the log, make sure that the Show POI Comment checkbox is selected in your log column. 

Stratigraphy tab

The Stratigraphy tab is used to enter subsurface soil or rock layers that were encountered during the field investigation. 

  • Depth: enter top and bottom depths that represent the stratum (required),
  • Layer Title: if you wish to give the stratum a title, enter it in the Layer Title (optional). The title is shown as the first line in the Lithologic Description in the log,
  • Copy Layer Data: click the copy button next to the Layer Title to start copying a stratum from another test hole,
  • Classification System: select the classification system (USCS, AASHTO, Mod. Burmister, AGS, ROCK) that is used for description of the soil / rock,
    • Soil Stratum: start with selecting the Major Soil Type from the dropdown. Depending on the category selected, other dropdowns will be populated with relevant subcategories. Once the Group Symbol is selected, its corresponding Log Symbol will be automatically selected and the hatch pattern image will be shown. See Settings → Hatch Design tab for hatch colors and default description texts.
    • Rock Stratum: start with selecting Rock Type and finish by Rock Name. The Log Symbol will be automatically selected and the hatch pattern image will be shown.
  • Log Symbol: this is the hatch pattern that will be shown for this stratum in the borehole log. In order to change the Log Symbol click the dropdown, select a category, and then select a hatch pattern from the list or search for a soil or rock type. You can customize this list by uploading your own hatch patterns.
  • Formation: you can assign a geologic category and a geologic unit to each stratum.
  • Lithologic Description: the layer description may be entered manually (Basic Mode) or be compiled by RSLog based on the data entered (Detailed Mode). This is selected using the link located at the top-right of the Layer Description box:
Selecting Layer Description (basic / detailed mode)
Selecting Layer Description (basic / detailed mode)

To format the text of the Layer Description, select part of the text and use the following shortcut keys to format the text:

  • Ctrl + I: makes the text Italic
  • Ctrl + B: makes the text Bold
  • Ctrl + U: makes the text Underlined

Once the depth data, classification system and log symbols are entered, you can enter Layer Description using the following options:

  → 1) Basic View

Is Basic View, you can enter the soil / rock stratum description in the Layer Description textbox. When entered, click Save to close the dialog.

  → 2) Detailed View

Select Detailed View if you would like to enter material description by selecting properties from various dropdowns (ASTM 2488). RSLog will then compile Layer Description for you. Clicking on Detailed View opens additional data entry fields. The compiler configuration may be customized on the Settings page (see how).

Detailed View
Detailed View

General tab

Enter moisture conditions, consistency, structure, color and more. If the stratum is fill, select the Mark as FILL checkbox (the compiler will add the phrase "(FILL)" to the end of the layer description text).

  • Use the Consistency (fine-grained soils) or Apparent Density (for coarse-grained soils) dropdown to describe the material: If the test hole contains Standard Penetration Test (SPT) blow counts within this stratum, the Consistency / Apparent Density will be automatically set. Hover on the info icon above this dropdown for details.
  • If the layer contains moisture content (lab test) data, the Moisture Level will be automatically set. Hover on the info icon above the this dropdown for details.
The list of Consistency or Apparent Density options as well as the list of Moisture Descriptors can be customized on Settings page → Field Investigation tab → Field Tests tab.

The Layer Line Style is used to specify the type, thickness, and color for the line drawn at the bottom of the stratum in the borehole log.

Components tab

Use this tab to provide detailed description of the material for fines content, sand, gravel, cobbles and bounders part of the material. For further details please refer to Section 2.5 and 2.6 of Soil and Rock Logging, Classification, and Presentation. Once various input dropdowns are set, click Compile Data button to automatically generate the layer description.

Interim Changes tab

Use this tab to indicate changes in moisture, color and consistency within the stratum. 

When geology is generally consistent across the site, you can duplicate test holes and just change certain data in the copied test hole (e.g. top & bottom of layers).  

  → Cross-Reference

Utilize the Summary of Field Tests and Summary of Lab Tests hyperlinks, which are positioned beneath the Layer Description textbox, to access comprehensive lists of field and laboratory tests corresponding to this stratum. This functionality enables you to cross-reference the Layer Description against the test results, thereby reducing the likelihood of data entry errors. The following examples illustrate the categories of discrepancies that may be identified through the application of this feature:

  • The silt is described as 'wet' in the field whereas lab tests indicate between 6.5 to 8.3 % of moisture content, and
  • The sand is described as 'lose' in the field while SPT blow counts collected during site investigation show a range of 9 to 11.

Hole Construction tab

This tab captures the details about how the test hole was drilled (or excavated), and how it was backfilled:

  → Drilling Details 

Use this tab to enter the details of drilling methods, equipment used and other details related to the drilling operation. The data entered on this tab will be presented in the test hole log in the "Drilling Details" log column: 

  • Depth: enter the top and bottom depths,
  • Hole Diameter: enter the borehole diameter,
  • Drill Method: select from the list; please note this list can be customized from the Settings → Field Investigation → Drilling tab.
  • Drill Rod: enter the information about the drill rod (size, type, etc.),
  • Drill Rig: select the Type of Drill Rig from the dropdown list and enter the model of rig,
  • Drill Bit: select the Type of Drill Bit from the dropdown list and enter the Drill Bit Information,
  • Casing: select the Type of Casing from the dropdown list and enter the Casing Diameter,
  • Date & Time: enter the date and time when this part of drilling was completed,
  • Notes: any remarks pertaining to this drilling operation,

  → Backfill 

Backfill details are used for the rendering of the "Hole Construction" log column in the borehole log:

  • Depth: enter the top and bottom depths,
  • Backfill Material: select the type of material used for backfilling the hole within this depth range,
  • Instrument Installed: if selected, it shows the selected instrument icon in the borehole log, between the top and bottom depths specified by user, 
  • Date & Time: enter the date and time when this part of backfill was completed,
  • Notes: any remarks pertaining to this backfill operation,
The list of backfill materials and their hatch patterns can be customized on the Settings → Hatch Design → Backfill tab. 

  → Well / Piezometer

A test hole can have multiple wells or piezometers. To add a new piezometer / well to the test hole, click the + button on the tab-header. This will add a new sub-tab with a generic name like "Piezometer #1", "Piezometer #2" etc. that can be used for data entry. The following data should be defined for a piezometer / well: 

General Data

This comprises general data about the piezometer such as:

  • Piezo/Well Type: select from various types of monitoring wells,
  • Plug Type (top): select the type of the plug at the top of the monitoring well (at the ground surface),
  • End Cap Type (bottom): select the type of cap installed at the bottom of the monitoring well.
  • Stickup: indicates if the well is installed with a stickup above the ground surface.
The type of well and list of plug types can be customized from the Settings → Field Investigation → Instrumentation tab.

Showing an Instrument (probe) in the Piezometer / Well

If Vibrating Wire is selected as the type of well or piezometer, you can indicate the depth of the instrument in the borehole log within the subject pipe segment as a box connected with a cable to the ground surface. 

Pipe Installation

Piezometers typically consist of a pipe assembly featuring multiple sections, which may be either solid pipe or perforated/slotted pipe designed to facilitate water entry into the pipe structure. To begin adding pipe sections, select the + New button located on the table toolbar:

  • From: enter the top depth for this pipe segment,
  • To: enter the bottom depth for this pipe segment,
  • Pipe Diameter: enter the diameter of the pipe,
  • Pipe Material: select the pipe material from the dropdown list,
  • Screen Type: select from the following options:
    • No Pipe texture No Pipe: no pipe is installed within the specified depth range.
    • Perforated texture Perforated: a perforated pipe is installed within this depth range.
    • Slotted figure Slotted: a slotted pipe is installed within this depth range.
    • Slotted texture Solid: a solid pipe is installed within this depth range (i.e. no slots or perforations).
  • Notes: enter any notes pertaining to this pipe section.
  • Show vibrating wire instrument: this indicates that the vibrating wire instrument is installed in this depth range. If selected, it shows the instrument symbol inside the subject pipe segment in the borehole log. Please note that this checkbox is only shown if the piezometer/well type is set to Vibrating Wire. 

The image below demonstrates the representation of a monitoring well within a borehole log. This particular borehole contains one monitoring well equipped with a vibrating wire probe. Additionally, a supplementary instrument, such as a tiltmeter, is depicted in the backfill material positioned directly above the sand stratum:

Piezo/well Drawing in the Borehole Log Showing Nested Piezometers
Piezo/well Drawing in the Borehole Log Showing Nested Piezometers

Groundwater Measurements 

Use this page to enter groundwater levels measured in the piezometer / well. To enter a measurement, click + New button:

  • Water Level Present in the Piezometer / Well: check this box if water level was encountered in this well. If this is unchecked:
    • User cannot enter a value for groundwater depth, and
    • the piezometer will be considered "DRY" at the time of the subject measurement.
  • Water Depth: enter the depth (below ground surface) of the groundwater,
  • Water Elevation: If your test hole has a collar elevation (in General tab → Coordinates section → Elevation), the program will automatically calculate Water Elevation,
  • Air Temperature: enter air temperature at the time of water level measurement,
  • Date & Time: enter the date and time of the measurement,
  • Notes (weather condition etc.): enter the weather condition or any other notes pertaining to this groundwater measurement.
In order to show well installation details and groundwater measurements on the borehole log please read this article.

Coring tab

The details of coring including the list of drill runs and discontinuities are entered in this tab. Select a drill run from the table at the top of the page to see the list of discontinuities in the table at the bottom of the page:

  → Drill Runs

Enter the list of drill runs when the borehole includes coring. This page can be used to enter the rock mass unit details instead of drill runs.
  • Depth: enter the top and bottom depths,
  • Run Number: enter the run identification number, 
  • Core Box Number: enter the core box identification number, 
  • Core Diameter: enter the diameter of the core obtained during drilling, 
  • Ref. Angle: This is the same angle referred to as Orient 1 in Dips,
  • Total Core Recovered: enter the total length of core recovered in this drill run; Click on calculator button to automatically calculate the Total Core Recovery (%),
  • Total Lengths >4 inch: enter the total length of core pieces longer than 4 inches (100 mm) in this drill run; Click on calculator button to automatically calculate the RQD (%),
  • Rock Strength Level: select the strength level from the dropdown; Please note that this list is customizable from the Settings → Rock Classification tab → Intact Rock tab,
  • Rock Alteration Level: select the alteration level from the dropdown; Please note this list is customizable from the Settings → Rock Classification tab → Intact Rock tab,
  • Rock Weathering Level: select the weathering from the dropdown; Please note this list is customizable from the Settings → Rock Classification tab →  Intact Rock tab, 
  • Date & Time: enter the date and time of finishing this run,
  • Total Core Recovery (TCR): enter the TCR for this drill run; This could be automatically calculated based on the Total Core Recovered length,
  • Solid Core Recovery (SCR): enter the SCR for this drill run,
  • Total Material Recovery (TMR): enter the TMR for this drill run,
  • Rock Quality Designation (RQD): enter RQD values for the entire drill run or for the rock mass units,
  • Rock Mass Ratio (RMR): enter the RMR76 and RMR89 for this drill run,
  • Q and Q': enter the calculated Q and Q' values (NGI), 
  • Notes: enter the notes pertaining to this drill run,
In the August 2026 update of RSLog the following parameters are automatically calculated based on the list of discontinuities: Joint Spacing, Fractures, Fracture Frequency

  → Discontinuities

To edit the list of joints within a drill run, edit the drill run record. This opens a new dialog with a Discontinuities tab where you can edit the list of discontinuities for that run. 

Alternatively you can select the desired drill run by selecting a row from the table at the top of the page, and the table at the bottom of the page will be populated with the list of Discontinuities. 

  • Depth: enter the depth at which the joint is present,
  • Joint Set ID: enter the identification for the joint set,
  • Aperture: enter the aperture of this joint,
  • Alpha & Beta: enter the alpha and beta (discontinuity orientation):
    • Alpha: Refers to the angle between the discontinuity trace and the axis of the borehole (the apparent dip angle). It describes how steeply the discontinuity cuts across the core.
    • Beta: Represents the angle between the discontinuity and a reference direction (usually north) in the plane perpendicular to the borehole axis. It indicates the orientation (azimuth) of the discontinuity’s trace as viewed along the core.
  • JRC-RMR: enter the Joint Roughness Coefficient; click the icon to open the JRC chart,
  • Jr and Ja: these parameters are used for calculation of Q or Q',
  • Defect Details: this includes defect type, shape, roughness, infill type, infill character and infill thickness; Please note this list can be customized from the Settings → Rock Classification tab,
  • Notes: enter the additional information pertaining to this joint, 

  → RMR & Q

This feature is planned for release in November 2026

To calculate the values of RMR and Q based on drill run and its discontinuities:

  • complete the drill run data entry and add discontinuities, 
  • click the calculate button at the bottom of the page,
  • for a full control of the parameters used in RMR and Q analysis click the icon next to the calculate button, 
  • this will open a new dialog box where you can select representative parameters used in RMR and Q calculations. To edit, use one of the following options:
    • Option 1) manually edit parameters, and click Calculate button, or
    • Option 2) have RSLog to calculate relevant parameters from your drill run and its discontinuities:
      • select the statistical mode and click the 'Update' button,
      • this will update relevant dropdowns and numerical values, 
      • review all data entries and click Calculate button,

Stress Reduction Factor (SRF)

NGI handbook recommends the following table for selection of Stress Reduction Factor (SRF):

Recommended SRF values (source: NGI Handbook- Using the Q-system Rock mass classification and support design)

Instrumentation tab

This tab is intended to store borehole survey data as well as data collected by an instrument installed to capture any deviations in the boreholes (e.g. hole diameter). Examples of borehole surveys include inclinometer, sonar caliper, gyro survey and more. Multiple borehole surveys can be added as separate 'datasets'. In order to add a 'dataset' click on New Dataset button:

  • Type: select the type of instrument. The list of borehole surveys may be customized from the Settings → Field Investigation → Instrumentation tab,
  • Title: enter a title for this borehole survey dataset, 
  • Contractor: enter the name of the contractor who installed the instrument in the borehole, 
  • Date & Time: reflects the date and time pertaining to installation of the instrument or conducting the borehole survey, 

This feature supports importing the instrument dataset from a CSV file.

The first row of the CSV file should contain a header line with a title for each column. The first column of the CSV file should always store the depth.

To add a new survey to the borehole:

  1. Click + NEW button from the left side of the page,
  2. Select the type of the borehole survey and add any other details pertaining to this dataset,
  3. Click Import CSV File and upload the file (see more about importing CSV files),
  4. The data will be populated in the table and plotted on the right side of the page.

Photos tab

Use this tab to upload photos (more details on this page).

Rocscience logo, click here to return to the homepage Portal Account Portal Account Portal Help Log In Log Out Home Shopping Cart icon Click here to search our site Click here to close Learning Tech Support RSInsight+ Logo Documentation Info Chevron Delete Back to Top View More" Previous Next Edit PDF File Calendar Location Language External Link Apply to ACC External Link Fees Video Click here to visit Rocscience's LinkedIn page Click here to visit Rocscience's YouTube page Click here to visit Rocscience's X page Click here to visit Rocscience's Facebook page Click here to visit Rocscience's Instagram page Click here to visit Rocscience's Reddit page Bookmark Network Scroll down for more Checkmark Download Print Back to top Single User Multiple Users RSLog RocFall3 CPillar Dips EX3 RocFall RocPlane RocSlope3 RocSupport RocTopple RS2 RS3 RSData RSPile RSWall NovoTech Bundle RSSeismic Settle3 Slide2 Slide3 SWedge UnWedge RocTunnel3 RocSlope2 BlastMetrix ShapeMetriX FragMetriX RSGeo RSRunout 2D Bundle 3D Bundle TestLicense Commercial License Education License Trial License Shop safe & secure Money-back guarantee