Ground Water 2d Model Instructions

From GeoMod

Jump to: navigation, search

Steady state, 2d model of groundwater flow.

Animation where the upper right cell is set to 10 and the pressure is propagated through the model by Excel's iterative solver.
Enlarge
Animation where the upper right cell is set to 10 and the pressure is propagated through the model by Excel's iterative solver.
  • All boundaries are set as NO FLOW by default.
  • Confined and unconfined aquifer versions.

Contents

Model/software

Below are two versions of the model, one for confined flow and the other for unconfined flow. The only difference between these models is that the cross-sectional areas for cells (A_x and A_y) use are calculated using head in the unconfined model and aquifer thickness (b) in the confined model.

  • Media:2d-model-conf.xls : MS Excel model of a confined aquifer (with no macros but you may need to enable the iterative solver for model to work.

Instructions

Enable the iterative solver if not already enabled.

  • PC (pre-Excel 2007): Tools -> Options -> Calculation (Tab) -> Iteration (checkbox)
  • Mac: Excel -> Preferences -> Calculation (Tab) -> Iteration (checkbox)

Boundaries

Constant Head

The left boundary is set to a constant head of 40 and the right to 30. The top and bottom boundaries are the default NO FLOW boundaries.
Enlarge
The left boundary is set to a constant head of 40 and the right to 30. The top and bottom boundaries are the default NO FLOW boundaries.

To make a cell a constant head.

  • Simply overwrite the equation in the 'h' worksheet cell with the head value.

No Flow

  • All boundaries are by default NO FLOW boundaries.
  • To make internal cells NO FLOW you need to use a high K value ('Kx' and 'Ky' sheets).


Recharge/discharge

Wells

Discharge of -500 at cell (13,13) with constant heads at left (40) and right (30) boundaries. Top and bottom boundaries are no flow.
Enlarge
Discharge of -500 at cell (13,13) with constant heads at left (40) and right (30) boundaries. Top and bottom boundaries are no flow.
  • Enter values in the 'Q' worksheet cells.
    • A value of -500 creates a nice cone of depression in the figure with constant head boundaries.


Recharge

  • Enter the recharge values in the 'R' worksheet cells. These values will be multiplied by the surface area of the cell (dx × dy).

Confined vs. Unconfined aquifer

Unconfined model. Assumes the bottom of the aquifer is at 0 elevation and left and right boundaries are 40 and 30 respectively.
Enlarge
Unconfined model. Assumes the bottom of the aquifer is at 0 elevation and left and right boundaries are 40 and 30 respectively.

There are two versions of the model for confined and unconfined aquifers. The only difference between the two is that in the unconfined version the cross-sectional area for each cell (in 'A' worksheet) is set equal to the head. This makes the implicit assumption that each cell is 1x1 in dimension and the bottom of the aquifer is at 0 elevation.


Model details

Worksheets

Main sheet

  • h - hydraulic heads. [L]
    • The cells in this sheet have the conservation of mass equations. The boundary cells (cells on the edges of the model) are set up to allow no flow into the model (you'll notice the difference by looking at the equations in the cells).
    • Modify the values in these cells to adjust the boundary conditions.

Input parameters

  • Q-well: Recharge or discharge wells [L3/T]
    • Enter the groundwater discharge/recharge rates from wells (negative for discharge wells
  • R: Recharge [L/T]
    • Groundwater recharge.
  • dx: cell length in x direction [L]
  • dy: cell width in y direction [L]
  • Kx: hydraulic conductivity in x direction [L/T]
  • Ky: hydraulic conductivity in y direction [L/T]

Working sheets: For internal calculations

  • a_sum: Source term (a_h)
    • a_h = a_{i-1} + a_{i+1} + a_{j-1} + a_{j+1}
  • a_i+1: a_{i-1} = (K_x A_x / dx)_{i-1}
  • a_i+1: a_{i+1} = (K_x A_x / dx)_{i+1}
  • a_j-1: a_{j-1} = (K_y A_y / dy)_{j-1}
  • a_j+1: a_{j+1} = (K_y A_y / dy)_{j-1}
  • Ax: cross-sectional area
    • A_x = dy * b ;
      • where b = thickness of the aquifer
      • where b = h; for unconfined model.
  • Ay: cross-sectional area
    • A_y = dx * b ;
      • where b = thickness of the aquifer
      • where b = h; for unconfined model.

Applications

Multimedia

  • Animation where the upper right cell is set to 10 and the pressure propagates through the model.
    Enlarge
    Animation where the upper right cell is set to 10 and the pressure propagates through the model.
Personal tools