Modeling Steady-State Groundwater Flow Using Microcomputer Spreadsheets

Abstract

Widely available electronic spreadsheets operating on microcomputers provide an instructor with groundwater modeling capability. The spreadsheet set-ups and results of five groundwater models are presented and discussed. All are based on steady-state conditions in isotropic and homogeneous aquifers both confined and unconfined. Spreadsheet modeling has been used in physical geology and environmental geology courses. The printed output provides useful exercise in contouring water table and piezometric surfaces of single and multiple cones of depression.