As a Visual Basic for Applications (VBA) macro within Excel, it requires minimal installation and is easy to use for anyone familiar with spreadsheets. Key Features and Statistics Calculated by Gradistat V9.1
is a widely used software tool for Grain Size Statistics , commonly used in geology and sedimentology to analyze particle size distributions.
is a highly popular, Microsoft Excel-based sedimentology software used by geomorphologists and geologists worldwide to analyze grain size statistics. Originally developed by Simon Blott and Kenneth Pye in 2001, the software streamlines laborious manual math into a rapid automated workflow. The phrase "gradistat v 91 hot" captures the surging interest in the newest modifications, versions, or open-source ports of this essential geological framework.
Geological sample analysis via sieving, laser granulometry, or X-ray sedigraphs yields massive tables of fractional data. GRADISTAT takes these complex raw percentages or weights and rapidly computes descriptive grain size trends. It processes up to 50 samples per hour, rendering high-utility metrics, frequency curves, and distribution charts.
By inputting these sample values into an integrated Microsoft Excel framework, researchers can process up to , converting raw weights directly into exportable tables and publication-ready graphs. Core Statistical Modules in Particle Analysis gradistat v 91 hot
The software operates within as a macro-enabled workbook, allowing researchers to rapidly process large datasets—typically at a rate of approximately 50 samples per hour . It is compatible with data obtained from various measurement techniques, including: Manual Sieving: Weight retained on a series of sieves.
: Automatically classifies samples into gravel, sand, and mud (GSM) or sand, silt, and clay (SSC) trigons.
: It calculates key metrics—such as mean, mode, sorting (standard deviation), and skewness—using both the Folk and Ward (1957) graphical method method of moments
Because GRADISTAT operates entirely on Visual Basic for Applications (VBA) macros inside Microsoft Excel, you must prepare your spreadsheet environment correctly before loading data. Step 1: Enable Excel Macros Open Microsoft Excel. Navigate to > Options > Trust Center . Click on Trust Center Settings and select Macro Settings . As a Visual Basic for Applications (VBA) macro
Before diving into the specifics of version 9.1, we must understand the problem it solved. Traditional sedimentology relies on the analysis of particle size distribution (PSD). Calculating statistical parameters—such as mean grain size, sorting (standard deviation), skewness, and kurtosis—used to be a manual, error-prone nightmare.
: A new graph overlay that compares raw data against expected distributions for oven-dried vs. hot-plate-dried samples to highlight any "drying-induced" outliers.
A quick search through recent scientific publications reveals the widespread adoption of GRADISTAT v9.1. For instance, in a 2024 study from the University of Liverpool, researchers used a Laser Particle Size Analyzer (LPSA) to determine grain size distributions. The raw data produced by the instrument was then "processed using GRADISTAT® version 9.1 software to quantify statistical attributes of the sample's texture". Similarly, a data article published in 2025 provided a clear example of data entry for sediment texture for "GRADISTAT v9.1," showing the aperture in microns and the class weight retained.
It is 2025. Why aren't professionals using R libraries ( G2Sd ), Python ( sedstats ), or modern GUI tools like GRADISTAT Pro ? Originally developed by Simon Blott and Kenneth Pye
The graphical methods calculate central tendency, sorting (variance), symmetry, and peak sharpness based on percentiles extracted from cumulative curves: : Calculates overall average size.
Even as more advanced R packages like "G2Sd" are developed, GRADISTAT's Excel-based ease-of-use keeps it in high demand.
GRADISTAT is an integrated Microsoft Excel macro package designed to instantly process grain size data gathered from sieving, laser granulometers, X-ray sedigraphs, or Coulter counters.