Skip to content
GeoEQ · Geotechnical software research lab · University of Utah

Documentation / Getting started

Files, projects and boreholes in GeoEQ SPT Logs (.sbl)

Applies to 1.0 and later · current 1.2 2 min read

Short answer

A GeoEQ SPT Logs project file (.sbl) holds one or more projects, and each project holds boreholes. Every borehole has one borelog, with its SPT data, strata and header, and draws its sheet live. Right-click any item in the explorer for its actions.

file, project, borehole
the three levels
1 or more
projects per .sbl file
UTF-8 JSON
plain-text file format

How is a GeoEQ SPT Logs file organised?

There are three levels:

  • A project file (.sbl) holds one or more projects.
  • Each project carries the information shared by its boreholes: project name, client, location, coordinate display, water-marker style, units and notes.
  • Each project contains boreholes. Every borehole has one borelog, made of its SPT data, strata and header, and draws its sheet live.

The explorer tree on the left of the editor shows this hierarchy. In version 1.3 a Filter boreholes box above the tree narrows the list.

What can I right-click in the explorer?

Right-click onActions
A projectProject settings, Add borehole, Import borehole from Excel / CSV, Export project PDF (all boreholes), Rename project, Delete project
A boreholeOpen borelog, Rename, Import data into this borelog, Export PDF, Delete
Empty spaceAdd project

The same actions are in the Project and Borehole menus. Double-clicking a project opens its settings, and double-clicking a borehole opens its borelog in a tab.

How do I start a new file and add a borehole?

  1. Choose File → New project file and name the first project.
  2. Right-click the project and choose Add borehole. The dialog asks for a name (BH-01 by default), the borehole depth (15 m by default) and the water table depth, which can be left as “not observed”.
  3. The new borelog opens with four tabs: SPT & samples, Strata, Rock core and Header. See SPT blow counts and samples and strata and soil symbols.

To add a second project to the open file, choose Project → Add project. A file needs at least one project, so the last one cannot be deleted.

How do I save, open and share files?

File → Save and Save as write the .sbl file. File → Open project file opens one, and double-clicking an .sbl file in Windows opens it directly once the app is installed.

Because the format is plain text, a file is easy to back up, email or sync. Files written by earlier versions open unchanged and are upgraded in memory when saved. The layout of the file is documented in project file format.

Is there a way to see all my projects at once?

The explorer shows the file that is open. In version 1.3 the Dashboard and Projects pages list every project found on the computer, with status, depth and borehole counts.

Step-by-step tutorials

Frequently asked questions

What is an .sbl file?

An .sbl file is a GeoEQ SPT Logs project file. It is plain UTF-8 JSON that can hold several projects, each with its own boreholes, client, location and settings.

Can one file hold more than one project?

Yes. A file can hold one or more projects, but it always needs at least one. To remove the last project, add another first or start a new file with File, New project file.

How do I export every borehole in a project as one PDF?

Right-click the project in the explorer and choose Export project PDF (all boreholes). Every borehole's sheets are written, in order, to a single PDF.

Where do the project name, client and location come from in a borehole header?

They are set once in Project settings and pulled into the header of every borehole in that project.