Optimized for newer versions of Microsoft Excel while maintaining the classic, user-friendly interface. How to Get It:
GRADISTAT is an in-house particle size analysis software integrated into a Microsoft Excel spreadsheet. It works by accepting percentage or raw mass data from physical sediment testing methods and running automatic calculations via macros.
Open Microsoft Excel first. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings . Select Disable VBA macros with notification or Enable VBA macros (depending on your organization's security policy).
Speed up your lab work with Gradistat v9.1! 📊🪨 gradistat v 91 free
While GRADISTAT remains popular for its simplicity and integration with Excel, there are other free and open-source options available. For researchers comfortable with programming, tools like the script (written in Python) offer cross-platform compatibility and advanced stereological methods. Another option is QGrain , an open-source software for comprehensive grain-size distribution analysis. However, GRADISTAT's long history and direct integration with Excel continue to make it a preferred choice for many.
The software is designed as a macro-enabled Microsoft Excel spreadsheet.
The program was developed by Simon J. Blott and Kenneth Pye, and its original methodology was published in the journal Earth Surface Processes and Landforms in 2001. GRADISTAT is designed to run within Microsoft Excel, making it accessible and versatile for researchers. Optimized for newer versions of Microsoft Excel while
The original version and Version 8.0 (released for Excel 2007–2010) are available through research-related platforms or directly from the developers.
Unlike standalone specialized software, GRADISTAT is built as a , which allows for a high degree of versatility and ease of use within a familiar spreadsheet environment. It is designed to handle data from various measuring techniques, including: Sieve Analysis : Manual weighing of sediment fractions. Laser Granulometry : Modern light diffraction methods.
Hope this helps save some time during crunch week! Open Microsoft Excel first
GRADISTAT is an integrated, macro-enabled Excel sheet written in Microsoft Visual Basic for Applications (VBA). It allows a user to input raw data from standard grain measurement techniques—such as physical sieve weights, laser granulometer distributions, X-ray sedigraphs, or Coulter counters—and outputs comprehensive statistics and charts almost instantly.
: Runs as a macro-enabled workbook ( .xls or .xlsm ), allowing users to input data directly into a spreadsheet environment for processing up to 50 samples per hour.
: Statistics are provided in metric units (arithmetically/geometrically) and phi units (logarithmically).