Results¶
Sheet visibility: visible.
Stored values and formulas are shown below. Cached formula results are source snapshots and have not been recalculated.
| Cell | Stored value or cached result | Formula |
|---|---|---|
| A1 | This spreadsheet will calculate the height of a groundwater mound beneath a stormwater infiltration basin. More information can be found in the U.S. Geological Survey Scientific Investigations Report 2010-5102 "Simulation of groundwater mounding beneath hypothetical stormwater infiltration basins". | |
| A2 | The user must specify infiltration rate (R), specific yield (Sy), horizontal hydraulic conductivity (Kh), basin dimensions (x, y), duration of infiltration period (t), and the initial thickness of the saturated zone (hi(0), height of the water table if the bottom of the aquifer is the datum). For a square basin the half width equals the half length (x = y). For a rectangular basin, if the user wants the water-table changes perpendicular to the long side, specify x as the short dimension and y as the long dimension. Conversely, if the user wants the values perpendicular to the short side, specify y as the short dimension, x as the long dimension. All distances are from the center of the basin. Users can change the distances from the center of the basin at which water-table aquifer thickness are calculated. | |
| A3 | Cells highlighted in yellow are values that can be changed by the user. Cells highlighted in red are output values based on user-specified inputs. The user MUST click the blue "Re-Calculate Now" button each time ANY of the user-specified inputs are changed otherwise necessary iterations to converge on the correct solution will not be done and values shown will be incorrect. Use consistent units for all input values (for example, feet and days) | |
| A6 | Input Values | |
| A7 | 2 | |
| B7 | R | |
| D7 | Recharge rate (permeability rate) (in/hr) | |
| A8 | 0.15 | |
| B8 | Sy | |
| D8 | Specific yield, Sy (dimensionless) default value is 0.15; max value is 0.2 provided that a lab test data is submitted |
|
| A9 | 2 | |
| B9 | Kh | |
| D9 | Horizontal hydraulic conductivity (in/hr) Kh = 5xRecharge Rate (R) in the coastal plain; Kh=R outside the coastal plain |
|
| A10 | 2.5 | |
| B10 | x | |
| D10 | 1/2 length of basin (x direction, in feet) | |
| A11 | 2.5 | |
| B11 | y | |
| D11 | 1/2 width of basin (y direction, in feet) | |
| A12 | 42 | |
| B12 | t | |
| D12 | Duration of infiltration period (hours) | |
| A13 | 10 | |
| B13 | hi(0) | |
| D13 | Initial thickness of saturated zone (feet) | |
| A15 | 11.11475798761754 | =Model!F67 |
| B15 | h(max) | |
| D15 | Maximum thickness of saturated zone (beneath center of basin at end of infiltration period) | |
| A16 | 1.1147579876175406 | =Model!F67-$A$13 |
| B16 | Δh(max) | |
| D16 | Maximum groundwater mounding (beneath center of basin at end of infiltration period) | |
| A17 | Ground-water Mounding, in feet | |
| B17 | Distance from center of basin in x direction, in feet | |
| A18 | 1.1147579876175406 | =Model!F57-$A$13 |
| B18 | 0 | |
| A19 | 0.48686787939806564 | =Model!F58-$A$13 |
| B19 | 10 | |
| A20 | 0.2470973931653795 | =Model!F59-$A$13 |
| B20 | 20 | |
| A21 | 0.1316617835157512 | =Model!F60-$A$13 |
| B21 | 30 | |
| A22 | 0.07163973761870679 | =Model!F61-$A$13 |
| B22 | 40 | |
| A23 | 0.04109059914050661 | =Model!F62-$A$13 |
| B23 | 50 | |
| A24 | 0.02638769597552937 | =Model!F63-$A$13 |
| B24 | 60 | |
| A25 | 0.01980517217046973 | =Model!F64-$A$13 |
| B25 | 70 | |
| A26 | 0.017089294261095844 | =Model!F65-$A$13 |
| B26 | 80 | |
| A27 | 0.01606277987853666 | =Model!F66-$A$13 |
| B27 | 90 | |
| A37 | Disclaimer | |
| A38 | This spreadsheet solving the Hantush (1967) equation for ground-water mounding beneath an infiltration basin is made available to the general public as a convenience for those wishing to replicate values documented in the USGS Scientific Investigations Report 2010-5102 "Groundwater mounding beneath hypothetical stormwater infiltration basins" or to calculate values based on user-specified site conditions. Any changes made to the spreadsheet (other than values identified as user-specified) after transmission from the USGS could have unintended, undesirable consequences. These consequences could include, but may not be limited to: erroneous output, numerical instabilities, and violations of underlying assumptions that are inherent in results presented in the accompanying USGS published report. The USGS assumes no responsibility for the consequences of any changes made to the spreadsheet. If changes are made to the spreadsheet, the user is responsible for documenting the changes and justifying the results and conclusions. |