You are being redirected because this document is part of your ASTM Compass® subscription.
    This document is part of your ASTM Compass® subscription.


    Spreadsheet Solution Method for Groundwater Flow Problems

    Published: Jan 1996

      Format Pages Price  
    PDF (292K) 17 $25   ADD TO CART
    Complete Source PDF (8.0M) 17 $112   ADD TO CART


    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.


    groundwater, seepage, hydraulic conductivity, numerical modeling, spreadsheet

    Author Information:

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

    Committee/Subcommittee: D18.21

    DOI: 10.1520/STP38383S

    CrossRef ASTM International is a member of CrossRef.