Rocscience International Conference 2025 is going to take place in Sydney, Australia Read more

Search Results

Data Entry

On the Settings page > Data Entry tab, you can change the default selections that are automatically loaded on data entry pages (i.e., Projects, Test Holes, etc).

To adjust the default Data Entry settings:

  1. Go to the left-hand navigation menu and select Settings page > Data Entry tab.
  2. Change the desired settings for any of the fields listed above.
  3. Click Save.

These data entry settings include the following:

General tab

For New Projects

  • Unit System: Determines the depth unit used in the program. Choose between Imperial (feet) and Metric (metres) unit systems.
  • Coordinate Reference System: Used to specify the coordinate reference system for project and borehole locations. See this page for detailed discussion of options.
  • Site UTM Zone: If UTM is used as the coordinate reference system for a project, the UTM zone needs to be specified. RSLog can automatically detect your UTM Zone based on your location (see Location Services page).

For New Test Holes

  • Sample Type: Select the default Sample Type assigned to a new sample. List of Sample Types may be edited on Settings page > Field Investigation tab.
  • Field Test Type: Select the default Field Test Type when adding field test data. List of Field Tests may be edited on Settings page > Field Investigation tab.
  • Drill Method: Select the default Drill Method when a test hole is created. List of Boring Methods may be edited on Settings page > Field Investigation tab.

Test Hole Completion Notes

  • Start Notes: Enter a default text that will be presented at the top of the first layer in the borehole log (i.e. at depth = zero). During borehole data entry you can override this text from General tab > Completion Notes section (on the right side of the page).
  • Termination Notes: Enter a default text that will be presented at the bottom of the last layer in the borehole log. During borehole data entry you can override this text from General tab > Completion Notes section (on the right side of the page).
Note: The following keywords may be used when entering the default text for Start Notes / Termination Notes; Please enclose the keywords in { }:
  • {name} represents test hole name (e.g. "BH-01").
  • {depth} represents borehole depth (e.g. "34.5 ft").
  • {elevation} represents borehole collar elevation (e.g. "652.8 ft").
  • {water_depth} represents groundwater depth (e.g. "7.8 m").
  • {spt_energy} represents SPT hammer energy (e.g. "60 %").

Sample Data

Using this feature you can import demo projects and demo borehole log templates to your RSLog account. Use this if you accidentally deleted the demo projects and templates from your account.

SPT Rules tab

During data entry for Standard Penetration Test (i.e. SPT blow counts) or Dynamic Cone Penetration Test (i.e. DCPT blow counts), you can use the following keywords:

  • If the blow count data starts with the word "REF" (e.g. REF 35/3"), this blow count will be considered as refusal. In this case, the SPT / DCPT graph in the borehole log uses a blow count of 50 to show this data on the graph. The keyword "REF" and the refusal number for the graph (i.e. 50) can be set in the SPT Rules tab.
  • For cases where the SPT sampler is driven into the soil with no blows (i.e. under the self weight of the hammer), user can enter "WH" or "WR" as the test result. In this case, the SPT / DCPT graph in the borehole log users a blow count of zero to show this data on the graph. The keywords "WH" and "WR" can be set in the SPT Rules tab.

SPT Blow Counts on the Log

SPT blow counts may be shown in the borehole log in different ways depending on the details. The following table summarizes these options:

The split character forces the data (when entered in Reporting Value column during data entry) to split into multiple rows.
Select Character Menu Bar
Select Character Menu Bar
Appearance on the Log
Log Template Design
Data Entry Method

SPT Blow Counts
Add a Text/Number » Field Test Results log column and link it to the Reporting Value of your SPT test.
Use Reporting Value column as shown below. This column allows alphanumeric values (e.g. use of comma etc.)
Reporting Value Column

SPT Blow Counts
Add a Text/Number » Field Test Results log column and link it to the Reporting Value of your SPT test.
Use Reporting Value column as shown below. Use the Split Character between the numbers to force the data to show in multiple rows in the log.
Reporting Value Column

SPT Log Column

Add 3 separate Text/Number » Field Test Results log columns and link them to corresponding columns of your SPT test.
Enter data in separate columns. You can customize the columns of your field tests to accept data in multiple columns.

Field Test Columns

SPT Graph on the Log

SPT blow counts may be shown in the borehole log in different ways depending on the details. The following table summarizes these options:

Appearance on the Log
Log Template Design
Data Entry Method

A graph showing SPT blow counts only

SPT Graph

Add a Graphic » Field Test Results log column and link it to the desired data column (e.g. N60) in your SPT field test.
Enter blow count details in separate columns. You can customize the columns of your field tests to accept data in multiple columns.

Field Test Column

A graph showing SPT blow counts along with other field / lab tests

SPT Graph 2

Add a Graphic » Graph (customizable) log column and add different data series linked to the desired data sources (e.g. various field / lab tests).
Enter blow count details in separate columns. You can customize the columns of your field tests to accept data in multiple columns.

Field Test Column

Status Options tab

In RSLog, projects and test holes can have Status; This allows determining at what stage the project or test hole is. User can change / update the status as the project proceeds to the next phase, or as the subsurface investigation of the test hole advances.

Project Status

Use the table to edit the list of project statuses. The following statuses cannot be altered:

  • Active (site investigation): is used to show that the project is in site investigation phase,
  • Archived: a project with Archived status will not be shown in the list of current projects. You can see the Archived projects by going to the Archived tab on Projects page.

Test Hole Status

Use the table to edit the list of test hole statuses. The default options in this list are meant to represent the natural flow of drilling a borehole/excavating a test pit. The status of test holes is used to show the investigation progress visually at the top of the Test Holes page:

Test hole status bar

The following statuses cannot be altered:

  • Planned: refers to a test hole that is created by RSLog Pre-Investigation Planner feature. A Planned test hole is 'planned' to be drilled/excavated but its investigation has not started yet. The default color of this test hole status may be changed by editing this record.
  • Completed: indicates that the field investigation for this test hole is completed. The default color of this test hole status may be changed by editing this record.

Extra Tags

You can expand the list of data that you enter for project and test hole by using Extra Tags. An example of Extra Tag is the Contract Number for a project; since Contract Number is not a default data entry item in RSLog, you can add it from Settings page > Data Entry tab > Extra Tags tab. For each Extra Tag determine the following data:

  • Tag Name: this is the label of the Extra Tag shown on RSLog user interface (e.g. during data entry on project page).
  • Data Type: determines the type of data expected for this Extra Tag. Options are Number, String (text), Boolean (checkbox true / false), and Pick List (dropdown list).
  • Value: only applies to a Pick List tag. For a Pick List, enter the dropdown options in comma separated format. For example if you add an Extra Tag for Department and would like the user to choose from Civil, Geotechnical and Environmental, in Value field write Civil, Geotechnical, Environmental.
  • Description: will be shown as the tooltip of the Extra Tag on data entry pages.

Data Entry for Project Extra Tags

  1. On project data entry page, click Additional Settings tab to see the list of Extra Tags (more details),
  2. Click on a cell in Enter Value column to enter data.

Data Entry for Borehole Extra Tags

  1. On borehole data entry page > General tab, open the Extra Tags tab (right side of the page) to see the list of Extra Tags (more details),
  2. Click on a cell in Enter Value column to enter data.

Presenting Extra Tags on Borehole Logs

  1. Open the desired log template for edit,
  2. Click Customize Layout button to open the header/footer designer,
  3. Add or select a Database Field element, and from its property grid click Open Menu,
  4. Choose whether you would like to link this label to a Project or Borehole,
  5. In the list of source items, scroll to the bottom of see the list of Extra Tags,
  6. Select the desired tag and click Apply.
Rocscience logo, click here to return to the homepage Portal Account Portal Account Log In Log Out Home Shopping Cart icon Click here to search our site Click here to close Learning Tech Support Documentation Info Chevron Delete Back to Top View More" Previous Next PDF File Calendar Location Language 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 Settle3 Slide2 Slide3 SWedge UnWedge RocTunnel RocSlope2 Commercial License Education License Trial License Shop safe & secure Money-back guarantee