Supporting Documentation · Jul 16, 2024
Drainage Report
49ec4d438ccec1138eb1cca049f5c30de587fe1769e55e2560bd7c9eea462d6cIndexed text
0.000 0 10 20 30 40 50 60 70 80 90 100 Disclaimer 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.
Input Values 0.45 R Recharge rate (permeability rate) (in/hr) Basin 2-2 Specific yield, Sy (dimensionless) 0.150 Sy default value is 0.15; max value is 0.2 provided that a lab test data is submitted Horizontal hydraulic conductivity (in/hr) R = 0.45 in/hr 0.45 Kh Kh = 5xRecharge Rate (R) in the coastal plain; Kh=R outside the coastal plain 21.500 x 1/2 length of basin (x direction, in feet) Kh = 0.45 in/hr 83.000 y 1/2 width of basin (y direction, in feet) 48.23 t Duration of infiltration period (hours) 10.00 hi(0) Initial thickness of saturated zone (feet) t = 48.23 hrs. 20.665 h(max) Maximum thickness of saturated zone (beneath center of basin at end of infiltration period) 10.665 Δh(max) Maximum groundwater mounding (beneath center of basin at end of infiltration period) Distance from Ground-water center of basin in x Mounding, in feet direction, in feet 10.665 0 9.817 10 Re-Calculate Now 6.764 20 2.452 30 Groundwater Mounding, in feet 0.617 40 12.000 0.118 50 0.020 60 10.000 0.006 70 0.004 80 8.000 0.004 90 6.000 4.000 2.000 0.000 0 10 20 30 40 50 60 70 80 90
0.000 0 10 20 30 40 50 60 70 80 90 100 Disclaimer 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.
Input Values 0.45 R Recharge rate (permeability rate) (in/hr) Basin 2-3 Specific yield, Sy (dimensionless) 0.150 Sy default value is 0.15; max value is 0.2 provided that a lab test data is submitted Horizontal hydraulic conductivity (in/hr) R = 0.45 in/hr 0.45 Kh Kh = 5xRecharge Rate (R) in the coastal plain; Kh=R outside the coastal plain 26.500 x 1/2 length of basin (x direction, in feet) Kh = 0.45 in/hr 97.500 y 1/2 width of basin (y direction, in feet) 48.38 t Duration of infiltration period (hours) 10.00 hi(0) Initial thickness of saturated zone (feet) t = 48.38 hrs. 21.312 h(max) Maximum thickness of saturated zone (beneath center of basin at end of infiltration period) 11.312 Δh(max) Maximum groundwater mounding (beneath center of basin at end of infiltration period) Distance from Ground-water center of basin in x Mounding, in feet direction, in feet 11.312 0 10.754 10 Re-Calculate Now 8.730 20 4.320 30 Groundwater Mounding, in feet 1.287 40 12.000 0.280 50 0.048 60 10.000 0.009 70 0.004 80 8.000 0.004 90 6.000 4.000 2.000 0.000 0 10 20 30 40 50 60 70 80 90 100 Disclaimer This
0.000 0 10 20 30 40 50 60 70 80 90 100 Disclaimer 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.
Input Values 0.45 R Recharge rate (permeability rate) (in/hr) Specific yield, Sy (dimensionless) Basin 2-4 0.150 Sy default value is 0.15; max value is 0.2 provided that a lab test data is submitted Horizontal hydraulic conductivity (in/hr) R = 0.45 in/hr 0.45 Kh Kh = 5xRecharge Rate (R) in the coastal plain; Kh=R outside the coastal plain 25.500 x 1/2 length of basin (x direction, in feet) 109.000 y 1/2 width of basin (y direction, in feet) Kh = 0.45 in/hr 37.08 t Duration of infiltration period (hours) 10.00 hi(0) Initial thickness of saturated zone (feet) t = 37.08 hrs. 18.905 h(max) Maximum thickness of saturated zone (beneath center of basin at end of infiltration period) 8.905 Δh(max) Maximum groundwater mounding (beneath center of basin at end of infiltration period) Distance from Ground-water center of basin in x Mounding, in feet direction, in feet 8.905 0 8.467 10 Re-Calculate Now 6.704 20 2.755 30 Groundwater Mounding, in feet 0.630 40 10.000 0.099 50 9.000 0.013 60 8.000 0.004 70 7.000 0.003 80 0.003 90 6.000 5.000 4.000 3.000
5.000 4.000 3.000 2.000 1.000 0.000 0 10 20 30 40 50 60 70 80 90 100 Disclaimer 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.
Input Values 0.45 R Recharge rate (permeability rate) (in/hr) Basin 2-5 Specific yield, Sy (dimensionless) 0.150 Sy default value is 0.15; max value is 0.2 provided that a lab test data is submitted Horizontal hydraulic conductivity (in/hr) R = 0.45 in/hr 0.45 Kh Kh = 5xRecharge Rate (R) in the coastal plain; Kh=R outside the coastal plain 26.500 x 1/2 length of basin (x direction, in feet) Kh = 0.45 in/hr 108.500 y 1/2 width of basin (y direction, in feet) 44.31 t Duration of infiltration period (hours) 10.00 hi(0) Initial thickness of saturated zone (feet) t = 44.31 hrs. 20.491 h(max) Maximum thickness of saturated zone (beneath center of basin at end of infiltration period) 10.491 Δh(max) Maximum groundwater mounding (beneath center of basin at end of infiltration period) Distance from Ground-water center of basin in x Mounding, in feet direction, in feet 10.491 0 9.988 10 Re-Calculate Now 8.108 20 3.882 30 Groundwater Mounding, in feet 1.079 40 12.000 0.215 50 0.034 60 10.000 0.007 70 0.004 80 8.000 0.004 90 6.000 4.000 2.000 0.000 0 10 20
2.000 0.000 0 10 20 30 40 50 60 70 80 90 100 Disclaimer 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.
Input Values 0.45 R Recharge rate (permeability rate) (in/hr) Specific yield, Sy (dimensionless) Basin 2-6 0.150 Sy default value is 0.15; max value is 0.2 provided that a lab test data is submitted Horizontal hydraulic conductivity (in/hr) 0.45 Kh Kh = 5xRecharge Rate (R) in the coastal plain; Kh=R outside the coastal plain R = 0.45 in/hr 29.000 x 1/2 length of basin (x direction, in feet) 109.000 y 1/2 width of basin (y direction, in feet) Kh = 0.45 in/hr 53.02 t Duration of infiltration period (hours) 10.00 hi(0) Initial thickness of saturated zone (feet) t = 53.02 hrs. 22.471 h(max) Maximum thickness of saturated zone (beneath center of basin at end of infiltration period) 12.471 Δh(max) Maximum groundwater mounding (beneath center of basin at end of infiltration period) Distance from Ground-water center of basin in x Mounding, in feet direction, in feet 12.471 0 11.969 10 Re-Calculate Now 10.185 20 6.081 30 Groundwater Mounding, in feet 2.115 40 14.000 0.537 50 0.107 60 12.000 0.019 70 10.000 0.006 80 0.005 90 8.000 6.000 4.000
File revisions (1)
- Sep 29, 2026
49ec4d438cce35,736,806 bytes