Présentations Colloques

Oral Presentation
3.01
Session 3.01: Groundwater data in the New Digital Age
Carlos Molano
Groundwater Spreadsheets- a powerful learning tool in Hydrogeology
Spreadsheets is a simple tool for solving efficiently groundwater flow and pollution analytical and numerical problems. It's a cheap, easy to use, and a powerful tool for Hydrogeology teaching research and practice. It also helps to understand concepts and solve practical day-to-day groundwater problems. No complex programing is required and it is suitable for use by students, practitioners and researchers. In this paper various recent advances using spreadsheets are presented.****Convolution is suitable for spreadsheets to solve a wide range of superposition problems with input varying arbitrary in time or space. This procedure can be applied for pumping tests analysis with discharge rate varying in time, for example for step or intermittent tests, which can include well storage in large diameter wells. Superposition can also be applied for well field analysis with input varying in space (steady state) and varying in time and space (transient state). Other superposition problems are presented as earth resistivity soundings interpretation, unit hydrograph and base flow generation. Convolution coupled with forward and inverse particle tracking are implemented in spreadsheets for advective contaminant transport problems, risk analysis, delineation of capture zones and forensic hydrogeology+ furthermore, with random walk particle tracking, dispersion can also be included. ****Spreadsheets are also suitable for 1-D, 2-D and 3-D finite difference models to simulate well fields, sea water intrusion, the effect of climate change in groundwater dependable ecosystems, and Flow System Analysis+ also coupled with surface hydrology models, can be used for more applications, for example, to simulated SUDS (Sustainable Urban Drainage Systems). There are hundreds of more groundwater applications using spreadsheets- land subsidence, unsaturated flow and hydrogeochemical analysis are some that are including in this paper.**
Colombia