Geochemical Stability Assessment Workbook (Excel)

The workbook operationalizes predictive geochemical assessment methodologies—primarily the static (e.g., Net Acid Generation, NAG, and Acid Base Accounting) and kinetic (e.g., humidity cell, column leach) test interpretation frameworks—within an Excel environment. It standardizes data input (e.g., total S, sulphide-S, carbonate-CaCO3 equivalent, pH, Eh, trace metal concentrations), applies tiered classification logic (e.g., ARD-susceptible, non-ARD, potentially neutralizing), and generates visual outputs including acid–base accounting plots, net acid generation curves, and stability risk matrices. Built-in validation checks, uncertainty flags (e.g., for incomplete sulphide speciation), and sensitivity analysis modules allow engineers to assess confidence in predictions and identify data gaps requiring further testing. The tool is explicitly aligned with regulatory expectations for mine closure planning in jurisdictions such as Australia (MINEDEX guidelines), Canada (MEND Protocol 2021-1), and the U.S. (EPA RCRA Subtitle D guidance), facilitating transparent documentation for regulators and stakeholders.