SYMPOSIA PAPER Published: 01 January 1996

Spreadsheet Solution Method for Groundwater Flow Problems


The spreadsheet block method is a practical tool for the solution of steady state confined groundwater flow problems. The methodology is simple and yet incorporates many of the aspects of the general flow condition, including: anisotropy, heterogeneity, pumping, and complex boundary geometry. In addition, since the spreadsheet equations are programmed manually, the method provides the user with a good physical intuition for a problem. Governing equations are developed for anisotropic and heterogeneous flow conditions. Mathematical treatment of boundary conditions is presented, as well as the means to incorporate pumping wells into the analysis. The sensitivity of solutions to choice of block spacing and number of calculation iterations is illustrated using two example problems. Lastly, advantages and limitations of the technique are discussed in comparison to other numerical solution methods.

Author Information

Fox, PJ
Purdue University, West Lafayette, IN
Price: $25.00
Contact Sales
Reprints and Permissions
Reprints and copyright permissions can be requested through the
Copyright Clearance Center
Developed by Committee: D18
Pages: 137–153
DOI: 10.1520/STP38383S
ISBN-EB: 978-0-8031-5563-3
ISBN-13: 978-0-8031-2021-1