Published April 8, 2022 | Version v1
Journal article Open

Teaching Numerical Groundwater Flow Modeling with Spreadsheets


The use of spreadsheets for numerical groundwater flow modeling is not a novelty; however, its potential in the classroom has not been emphasized enough. This Teachers Aid provides a step-by-step implementation of a steady-state, vertically integrated two-dimensional groundwater flow model in a confined irregular aquifer with boundary conditions of the three kinds and subject to pumping and recharge that will enhance the learning experience of students that are confronted for the first time with the numerical solution of the groundwater flow partial differential equation.


This journal article is partially supported by the PRIMA Programme supported by the European Union's Horizon 2020 Research and Innovation Programme under Grant Agreement No 1923 (InTheMED).



Files (3.3 MB)