STP1288: Spreadsheet Solution Method for Groundwater Flow Problems

    Fox, PJ
    Assistant professor, Purdue University, West Lafayette, IN

    Pages: 17    Published: Jan 1996


    Abstract

    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.

    Keywords:

    groundwater, seepage, hydraulic conductivity, numerical modeling, spreadsheet


    Paper ID: STP38383S

    Committee/Subcommittee: D18.21

    DOI: 10.1520/STP38383S


    CrossRef ASTM International is a member of CrossRef.