Documentation / Getting started
Files, projects and boreholes in GeoEQ SPT Logs (.sbl)
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 on | Actions |
|---|---|
| A project | Project settings, Add borehole, Import borehole from Excel / CSV, Export project PDF (all boreholes), Rename project, Delete project |
| A borehole | Open borelog, Rename, Import data into this borelog, Export PDF, Delete |
| Empty space | Add 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?
- Choose File → New project file and name the first project.
- 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”.
- 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.