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 (PDF):

  • 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.

To Windows 7, 8 and 8.1 users: If SoilStats cannot run, please

  • Keep your operation system updated
  • Download and install Microsoft Visual C++ 2019 redistributable package (x64) at
  • Delete msvcp140.dll and vcruntime140.dll and vcruntime140_1.dll from SoilStats folder

Change log: (2022-06-25)

– fixed failing to export xlsx file (2021-10-11)

– fixed temporary file reading problem (2021-06-30)

– fixed temporary file reading problem

0.7.4 (2021-06-27)

+ switched to 64 bit to improve program extensibility
+ added 32 bit bridge to gINT data file

0.7.3 (2020-06-30)

– 3D view bug fix

0.7.2 (2019-06-22)

+ borehole name text removal
– data map file creator

0.7.1 (2018-03-12)

– fixed data file open problem

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

30 Replies to “SoilStats”

  1. First of all, this software is fantastic and brilliant! A fellow colleague introduced me to it this year, and I wish I would have known about it years ago. It makes summarizing data incredibly straightforward and easy.

    Second, I have been having an issue with the latest update ( Whenever I open the program and try to open an existing SoilStats file, an error pops up that says “Temporary data does not exists.” I have gotten around it by reinstalling the program (the latest version), but I need to reinstall it every time I close the program, otherwise it does not work for me. Perhaps I am doing something incorrectly. Any ideas?

    1. Hi Ben, thanks for using SoilStats. I got similar complaints regarding Can you please try the “SoilStats zip”? The zip file doesn’t need installation. I will fix that problem but it may take a bit time.
      Please let me know if you cannot get rid of that error message.

    1. Hi Kumaran, please send me a typical gINT data file and associated pdf borehole log to let me know what your general requirement is.

  2. I Want To Ask, Why Does The Soil Depth We Input In Excel Not According To Results On Soilstast?

    I Look At Your Excel Examples, There Are The Hole Depth
    99 Meters But Into The Soilstats The Depth Only 30 Meters

    1. looks like SoilStats use imperial units for the input data. Did you use metric for the input data? You can send me your file and let me take a look if you don’t mind.

    2. Dear Yong,
      Could you kindly inform me how to add for example in the STRENGTH sheet another field such as UCS, cohesion and friction angle and unit weight so they can also be analyzed statitically?
      Thank you in advance

      Best regards

      1. Hi Yusa, do you use the xlsx file or gINT file? The data map file needs to be changed to reflect the data you added. If you don’t mind you can let me take a look at your data.

      2. Dear Young,
        Apologize for my late reply, I used and modified the xlsx file given in your examples, basically i want to add , visualisize and analyze labaratory result such as cohesion dan friction angle, Cohesion from UCS etc how can send my data to you?to your email?
        Many thanks
        Best regards

    3. Hi Yong,

      I agree this comment. Although its example borehole depth is 99 m Soilstats shows only 30 meters.
      Can you explain this?
      Thank you.

  3. When I trz to start app, it says “api-ms-win-core-rtlsupport-l1-2-0” is missing from your computer. Try reinstalling the program to fix this problem.

    Any hint?

    1. Please keep your operation system updated;
      Download and install Microsoft Visual C++ 2015 redistributable package (x86); and
      Delete msvcp140.dll and vcruntime140.dll from SoilStats folder.

      1. I have done that … unfortunately SoilStats works only if C++ 2015 x86 is installed, but I need x64 version for other programs. When both versions are installed, SoilStats crashes immediately. Can you fix this please? Machine is Win7 x64.

        1. Can you try to copy the msvcp140.dll and vcruntime140.dll of your c++2015 x86 redistributable to the SoilStats folder? Generally, x86 and x64 redistributables should be able to coexist.

          1. Dear Yong, can you please help me to find c++2015 x86 redistributable folder where mentioned dll are located? I cannot find them?

    1. Hi Yong,

      It’s possible to change the Material type of the soil? I want tô translate to my language (Brazilian Portuguese).

      Another question, How can i set the water level?

      Thank you

      1. Hi Hildebrando, the material type is an data column in the gINT file or other database. You don’t need to translate it. Water level is also an data column in you database file. You need a data map file to map your data to the format understood by SoilStats.

    1. It is free to use it for now. But you need to send me a typical data file so that I can create a data map file to let SoilStats know your data format.

      1. How do you make a data map file? I can’t seem to change the data map from the example format using the Data map file creator.

Leave a Reply

Your email address will not be published.