The Excel spreadsheets that can be downloaded from this article use Excel formulas to calculate the volume needed for storm water retention or detention ponds. Parameters needed in the equations include, watershed time of concentration and peak storm water runoff rate.

- slide 1 of 10
### Storm Water Detention/Retention Pond Background

When development takes place on a watershed, the amount of storm water runoff and the peak runoff rate typically increase from the pre-development values. The watershed runoff coefficient typically increases and the watershed time of concentration usually decreases due to development. These two factors both contribute to more storm water runoff and a higher peak rate of storm water runoff.

Many state and local agencies require storm water detention facilities that limit the rate of storm water runoff to the pre-development value whenever development takes place. Detention ponds and retention ponds are both facilities that capture storm water runoff and release it at the pre-development runoff rate or less. A detention pond doesn't hold water between storm events, while a retention pond retains water in the pond between storm events.

For more background on storm water retention/detention ponds and the need for them, see the article, "The Stormwater Detention Pond and Stormwater Retention Pond - Why Are They Needed?" The rest of this article is devoted to the first step in design of storm water retention and storm water detention ponds, that is, determining the volume requirement. The parameters and equations will be presented along with downloadable spreadsheets having Excel formulas for making the calculations.

Image Credit: Brevard County Florida Watershed Management Program

- slide 2 of 10
### Parameters for calculating Volume Needed for Storm Water Detention Ponds

The watershed parameters needed for the storm water detention pond volume calculations considered in this article are as follows: (NOTE: The subscript, b, refers to before development watershed conditions and the subscript, a, refers to after development watershed conditions.)

- watershed area, A, acres
- storm water runoff depth - before, Q
_{b}, inches - storm water runoff depth - after, Q
_{a}, inches - peak storm water runoff rate - before, q
_{pb}, cfs - peak storm water runoff rate - after, q
_{pa}, cfs - runoff rate ratio, α, (α = q
_{pb}/q_{pa}), dimensionless - watershed time of concentration - before, t
_{cb}, hours - watershed time of concentration - after, t
_{ca}, hours - time ratio, γ (γ = t
_{cb}/t_{ca}), dimensionless

Read on for the equations used in several methods of calculating volume needed for storm water detention ponds.

- slide 3 of 10
### Equations for Calculating Volume Needed for Storm Water Detention Ponds

Many methods have been proposed and are in use for estimating the volume requirement for storm water detention/retention ponds. Reference #1 for this article describes 7 methods. Three of them will be presented and discussed here as follows:

- the Generalized Model
- the Natural Storage Lost Model
- the Rational Hydrograph Model

The equation(s) used for each of them are as follows:

**The Generalized Model**equations are- V
_{s}= Q_{a}{[γ + α + αγ(g + α - 4)]/(γ - α)} for α < 2 - γ - V
_{s}= Q_{a}(γ - α)/(γ + α) for α > 2 - γ

where V

_{s}is the storage volume needed for the detention/retention pond in inches over the watershed area and the other parameters are as defined above.**The Natural Storage Model**equation is simply: V_{s}= Q_{a}- Q_{b}.**The Rational Hydrograph Model**equation is: V_{st}= 0.08264 t_{ca}(q_{pa}- q_{pb})Go to page 2 for further discussion of each of these methods and Excel spreadsheets that can be downloaded to make the calculations in either U.S. or S.I. units.

- slide 4 of 10
Excel Spreadsheets for Calculating Storm Water Detention Pond Volume Needed Excel formulas can be downloaded for calculation of volume needed for storm water detention ponds in either U.S units or S.I. units. These Excel spreadsheets are set up to use the equations of the Generalized Model and the Loss of Natural Storage Model. The watershed time of concentration and peak storm water runoff rate are among the parameters needed for the Excel formulas used for these calculations. - slide 5 of 10
### Excel Formulas for Detention Volume Calculation with the Generalized Model

The Excel spreadsheet image at the left shows the inputs needed and the calculations made to get an estimate of the detention pond volume requirement for a given watershed. The calculations use Excel formulas for the Generalized Model equations shown in the box at the right. The equations in the box give the detention pond volume, V

_{s}, as a function of α, γ, and Q_{a}. In order to calculate values for the peak runoff ratio, α, and the time ratio, γ, values are needed for q_{pb}, q_{pa}, t_{cb}, and t_{ca}.For information about determining time of concentration from watershed characteristics and Excel spreadsheets that can be downloaded to make the calculations, see the article, "Excel Spreadsheet Templates for Calculating Watershed Time of Concentration." The peak runoff rates, q

_{pb}and q_{pa}, would typically be calculated using the rational method as described in the article, "The Rational Method for Calculation of Peak Storm Water Runoff Rate," and the other articles in the series with it.The runoff depth after development, Q

_{a}, can be calculated from the equation, Q_{a}= (120/121)(q_{pa}t_{ca}/A). Also, the detention pond volume, V_{s}, as calculated from the Generalized model is in inches over the watershed area. This volume can be converted to the more usable units, acre-ft, with the equation: V_{st}= V_{s}A/12, giving V_{st}in acre-ft, if V_{s}is in inches and A is in acres. The S.I. versions of these equations are presented in a later section on page 3 of this article. - slide 6 of 10
### Loss of Natural Storage Detention Pond Volume Calculations with Excel Formulas

The Excel formulas in the spreadsheet image at the right calculate storm water detention pond volume with the loss of natural storage model. The input parameters needed for this model are the same as those needed for the Generalized model discussed in the last section, A, q

_{pb}, q_{pa}, t_{cb}, and t_{ca}. The last four of these parameters are needed to calculate Q_{b}and Q_{a}. Then the required detention pond storage in inches is V_{s}= Q_{b}- Q_{a}. The watershed area, A, is then needed to calculate the required detention pond volume in acre-ft, using the equation, V_{st}= V_{s}A/12.Information about calculating peak storm water runoff rate and time of concentration can be found in the articles mentioned above in the previous section. The S.I. versions of these equations are given in a later section of this article on page 3.

- slide 7 of 10
S.I. Units for Calculating Volume Needs of Storm Water Detention Ponds Details of the S.I. versions are presented for the equations used in the Excel formulas that calculate storm water detention pond volume needed. Excel spreadsheets can be downloaded to make the volume calculations using the Rational Hydrograph Model in either U.S. units or S.I. units. This includes the use of watershed time of concentration and peak storm water runoff rate for pre-development and after development watershed conditions. - slide 8 of 10
### Detention Pond Volume Calculation by the Rational Hydrograph Model with Excel Formulas

The spreadsheet image at the left shows the calculation of storm water detention pond volume requirement with Excel formulas using the Rational Hydrograph model. This model is the simplest of the three discussed in this article. Only three input parameters are needed, pre-development peak runoff rate, q

_{pb}, after development peak runoff rate, q_{pa}, and after development time of concentration, t_{ca}. Then the single equation, V_{st}= 0.08264 t_{ca}( q_{pa}- q_{pb}), can be used to calculate the detention pond volume requirement directly in acre-ft. The S.I. version of this equation is given in the next section. - slide 9 of 10
### Equations and Parameters For Detention Pond Volume Calculations in S.I. Units

The parameters for storm water detention pond volume calculations in S.I. units are as follows:

- watershed area, A, ha
- storm water runoff depth - before, Q
_{b}, mm - storm water runoff depth - after, Q
_{a}, mm - peak storm water runoff rate - before, q
_{pb}, m^{3}/s - peak storm water runoff rate - after, q
_{pa}, m^{3}/s - runoff rate ratio, α, (α = q
_{pb}/q_{pa}), dimensionless - watershed time of concentration - before, t
_{cb}, hours - watershed time of concentration - after, t
_{ca}, hours - time ratio, γ (γ = t
_{cb}/t_{ca}), dimensionless

The equations for the

**Generalized Model**(shown in the box at the right above) remain the same for either U.S. or S.I. units, because α and γ are dimensionless. In U.S. units, both Q_{a}and V_{s}are in inches, while in S.I. units, both Q_{a}and V_{s}are in mm. The equation for converting detention pond volume in mm over the watershed area, V_{s}, to m^{3}, is: V_{st}= (10)(V_{s})(A) m^{3}. In S.I. units the runoff depth, Q_{b}or Q_{a}, can be calculated from known values for the peak runoff rate, time of concentration, and watershed area, with the equation: Q - 360(q_{p}t_{c}/A). A in ha, q_{p}in m^{3}/s, and t_{c}in hr, will give Q in mm.The basic equation for the

**Loss of Natural Storage Model**: V_{s}= Q_{a}- Q_{b}, remains the same for S.I. units. For S.I. calculations, all three parameters in the equation will be in mm instead of inches, as they were for U.S. units. The equations for V_{st}and Q_{a}or Q_{b}remain the same as shown above for the Generalized Model.The constant in the

**Rational Hydrograph Model**equation changes for S.I. units to become: V_{st}= 3600 t_{ca}(q_{pa}- q_{pb}). This equation will give V_{st}in m^{3}, with units of hr for t_{ca}and m^{3}/s for q_{pa}and q_{pb}.The S.I. version spreadsheets that can be downloaded from previous sections of this article use these equations in the Excel formulas that make the calculations. The equations and units are also shown on the downloadable spreadsheets.

- slide 10 of 10
### References

References for Further Information:

1. McCuen, Richard H.,

*Hydrologic Analysis and Design, 2nd Ed*, Upper Saddle River, NJ, 1998.2. Coefield, S. and Environmental Health News, "EPA to Staunch Flood of Storm Water Runoff Polluting U.S. Waterways,"

*Scientific American,*February 17, 2010.3. Mays, L. W.,

*Urban Stormwater Management Tools*, New York, McGraw-Hill, 2004.