HydrogeoSieveXL: an Excel-based tool to estimate hydraulic conductivity from grain-size analysis

Devlin, J. F.

HydrogeoSieveXL: an Excel-based tool to estimate hydraulic conductivity from grain-size analysis | HydrogeoSieveXL: un outil développé sous Excel pour estimer la conductivité hydraulique à parrit de l’analyse de la granulométrie HydrogeoSieveXL: una herramienta basada en el Excel para estimar la conductividad hidráulica a partir del análisis del tamaño de grano 水文地质筛网程序XL: 一个基于Excel的通过粒径分析估算水力传导率 HydrogeoSieveXL: uma ferramenta baseada no Excel para estimar condutividade hidráulica a partir de análises do tamanho de partículas

2015

Devlin, J. F.

For over a century, hydrogeologists have estimated hydraulic conductivity (K) from grain-size distribution curves. The benefits of the practice are simplicity, cost, and a means of identifying spatial variations in K. Many techniques have been developed over the years, but all suffer from similar shortcomings: no accounting of heterogeneity within samples (i.e., aquifer structure is lost), loss of grain packing characteristics, and failure to account for the effects of overburden pressure on K. In addition, K estimates can vary by an order of magnitude between the various methods, and it is not generally possible to identify the best method for a given sample. The drawbacks are serious, but the advantages have seen the use of grain-size distribution curves for K estimation continue, often using a single selected method to estimate K in a given project. In most cases, this restriction results from convenience. It is proposed here that extending the analysis to include several methods would be beneficial since it would provide a better indication of the range of K that might apply. To overcome the convenience limitation, an Excel-based spreadsheet program, HydrogeoSieveXL, is introduced here. HydrogeoSieveXL is a freely available program that calculates K from grain-size distribution curves using 15 different methods. HydrogeoSieveXL was found to calculate K values essentially identical to those reported in the literature, using the published grain-size distribution curves.

Show more [+]