SoilStats

SoilStats provides an intuitive way to analyze geotechnical borehole logs in gINT format, MDB format and XLSX format. It automates data summarization and borehole visualization. SoilStats provides engineers with an innovative way to significantly reduce geotechnical report preparation time.

Flexible data map mechanism allows SoilStats to be able to analyze different gINT files generated with different templates, MDB files and XLSX (Excel spreadsheet) files input manually or exported from other borehole log software in the market.

Main features:

  • Soil layer regrouping
  • Data map file setting to accommodate files generated with different template
  • User defined data map file with data map file creator
  • Multiple-files (with different data map files) analysis
  • MDB and XLSX files reading
  • 3D borehole visualization
  • Water / moisture content analysis
  • SPT N value analysis
  • SPT N value estimate based on depth range
  • Sample view to check sample info
  • Pocket penetrometer reading analysis
  • Soil layer thickness, depth and elevation analysis
  • Water level analysis
  • Atterberg Limits summarization
  • Search text in soil descriptions, remarks / comments, and soil symbols
  • Borehole coordinates and elevation display
  • Duplicated borehole numbers from different projects differentiation
  • PNG, PDF and SVG file formats for exported graph

Example files and XLSX file template are provided in the program bundle. Any questions please don’t hesitate to contact Yong.

Change log:

0.7.0 (2017-06-10)

+ data map file 0.2 format
+ data map file creator
+ borehole drill date
+ borehole sample view
+ sample information checking
+ user defined data extract and data query
- water content estimate error

0.6.2 (2017-04-08)

+ added current graph printing
+ added mouse coordinates on graphs
- fixed no SPT data in detailed view with multiple files
- fixed duplicated legends
- fixed unchanged soil colors when second file was opened
- fixed failure to show esimated SPT N value if the 1st depth was empty
- fixed failure to show naturally sorted search results

0.6.1 (2016-12-14)

+ showed soil description when 3D borehole clicked
- fixed no response on graph height setting

0.6.0 (2016-12-12)

+ added view choosing with tab bar
+ added double clicking to highlight a certain soil layer
+ added ignoring out of range value for stats
+ added graph width atuo resizing
+ added soil details view. show soil symbols, spt n and water content along boreholes
+ added sigle left clicking or pressing left or right mouse button to select borehole in soil details view
+ added icons in soil combobox
- merged borehole depth view into soil thickness view
- removed borehole serial number

0.5.4 (2016-11-27)

+ support soil regroup wildcard, e.g., *sand*=>sand
+ display default data map file on status bar
+ record recent gINT files, xlsx files in recent file list
- fix 3D view deletion bug
+ other minor improvements

0.5.3 (2016-11-16)

- fixed searching graph legend error
- fixed regroup rule range error

0.5.2 (2016-11-08)

- fixed reference plane range error

0.5.1 (2016-11-05)

- fixed missing soil layers in 3D view after soil layers regrouped

0.5.0 (2016-11-03)

+ 3D borehole view
+ read xlsx files
+ double click on 3D borehole to show borehole information
+ open gInt files, xlsx files and mdb files from File menu
+ drag and drop gInt files and SoilStats files to program
+ export gInt file to xlsx files

0.4.2 (2016-08-30)

- fixed soil name drag and drop issue
+ added general soil name extraction

0.4.1 (2016-08-09)

+ show borehole names or serial number on x axis
+ automatically open graph image once it is saved
+ added 10px margin for graph

0.4.0 (2016-08-01)

+ customize soil layer colors
+ customize borehole line width
+ sort borehole names naturally (e.g. TH-9, TH-10 instead of TH-10, TH-9)
+ sort soil layer names by depth
+ hide detailed data by default

0.3.2 (2016-07-13)

+ added SPT N and water content range percentage estimate
+ added custom data eport to xlsx file

0.3.1 (2016-06-29)

- bug fixes
+ remove unwanted letters from soil layer names

0.3.0 (2016-06-27)

+ show borehole serial number in thickness summary
+ differentiate duplicated borehole numbers from different borehole files
+ show borehole coordinates and elevation in text and graph
+ Atterberg Limits text summary ordered by borehole name
- fix first time data map file setup failure
+ multiple data map files for multiple borehole log files

0.2.2 (2016-06-21)

- bug fixes
- redefined spt N value estimate percentage

0.2.1 (2016-06-18)

+ text search including searching soil description, remarks and soil symbol
- bug fixes

0.2.0 (2016-05-31)

+ data map file setting
+ pocket pen reading view
+ water content display in limits view
+ appending gint files

0.1.0 (2016-04-27)

+ water content view
+ spt N value view
+ soil layer thickness view
+ water level view
+ borehole depth and elevation view
+ single borehole view
+ Atterberg Limits view
+ spt N value estimate
+ graph export

4 thoughts on “SoilStats

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>