Download Excel spreadsheet templates for storm water runoff control structure design in U.S. units or S.I. units, to be used with storm water retention or detention ponds. The control structure will reduce the detention pond discharge to the pre-development, watershed peak storm water runoff rate.

- slide 1 of 11
- slide 2 of 11
### Background on Storm Water Detention Ponds

Storm water retention or detention ponds are used to capture storm water runoff from a developed watershed and to release the captured storm water at a rate no greater than the pre-development peak storm water runoff rate. The fundamental requirements are thus: i) adequate volume to hold the captured storm water runoff as it is being released at a slower rate than it is coming in, and ii) an outlet structure that controls the outflow to a rate no greater than the pre-development peak storm water runoff rate. The diagram shows a storm water detention pond and an outlet control structure with an outlet pipe and a riser with a weir.

The article, "The Storm Water Detention or Retention Pond - Why Is It Needed?" provides more background on storm water detention and retention ponds. The article "Sizing of Storm Water Detention Ponds with Excel Formulas" gives equations and Excel spreadsheets that can be downloaded to calculate the volume needed for detention/retention ponds. This article is devoted to equations and procedures for designing storm water detention/retention pond outlet structures.

- slide 3 of 11
### Types of Outlet Control Structures

In order to control the outflow from a storm water detention or retention pond to less than the pre-development peak storm water runoff rate, some type of flow constriction is needed. The three types of flow constriction/flow control devices that will be covered in this article are a pipe, an orifice, and a weir. It isn't necessary to reinvent the wheel in order to make design calculations for a pipe, an orifice, or a weir as a flow control device, because fluid mechanics/hydraulics equations are already in common use for other applications for all three of these.

A pipe of appropriate diameter and length with an inlet at or near the pond bottom can be used as the outlet control for a detention pond as shown in the diagram at the upper left. An orifice or weir outlet control will typically be used along with a riser pipe for a storm water retention pond, as shown in the diagram at the right. This type of outlet will drain the pond down only to the height of the weir crest or the bottom of the orifice after a storm event.

- slide 4 of 11
### Single Stage and Two Stage Outlet Flow Control

The use of a pipe for the only outlet flow control, as shown in the diagram above, is an example of single stage outlet flow control. The pipe can be sized to properly restrict the flow for a storm of only one selected recurrence interval. If the pipe is sized to provide outflow at pre-development peak storm water runoff rate for a frequent event (such as a 2-yr or 5-yr storm), then it will over control less frequent events (like a 50-yr or 100-yr storm). On the other hand, if the pipe is sized to properly control a 100-yr storm, then it will under-control a more frequent event.

One solution to this dilemma is to design the outlet control for a frequent event, like the 2-yr or 5-yr storm, but provide adequate storage capacity for a less frequent event, like the 100-yr storm. Another approach is two stage outlet flow control. The weir or orifice in a riser with a pipe outlet, as shown in the diagram above can be designed for two stage control. For example, the pipe can be sized to provide the proper restriction for an event with a large recurrence interval, like a 100 year storm. The orifice or weir can then be sized to provide the proper restriction for a more frequent event, such as a 5-year storm.

The design storm recurrence interval or intervals to be used will typically be specified by a state or local agency. See page 2 for discussion and downloadable Excel spreadsheet templates to design single stage pipe outlet flow control and two stage outlet flow control with a pipe and either an orifice or a weir.

- slide 5 of 11
Excel Spreadsheet Templates for Design of Pipe and Orifice Storm Water Control Outflow Control Excel spreadsheet templates for calculations in either U.S. or S.I. units can be downloaded to design storm water detention pond outflow control structures, using a pipe and/or orifice as the control device. Parameters like the Manning roughness coefficient of the pipe, water elevation at design storage, elevation of pipe centerline, pipe length, and pre-development peak storm water runoff rate are used by Excel formulas to calculate the required pipe diameter using a trial and error procedure. Similar parameters are needed to size an orifice for storm water detention pond outlet flow control. - slide 6 of 11
### Excel Spreadsheet Templates for Pipe Outlet Control

The image at the left illustrates the Excel spreadsheet templates that can be downloaded to calculate the pipe diameter needed to control the outlet flow to no more than the pre-development peak storm water runoff rate for the design storm if values are provided for all of the parameters in the

**Inputs**column. Those input parameters are shown in the diagram at the right and are summarized below:- Manning roughness coefficient of pipe, n, dimensionless
- pipe length, L, ft
- water elevation in pond at design storage volume, E
_{s}, ft - pipe centerline elevation, E
_{c}, ft - Pre-development peak runoff rate, q
_{pb}, cfs - trial value for pipe diameter, D, inches

The equations used to calculate the required pipe diameter using the above parameters are:

K

_{p}= 5087 n^{2}D^{-4/3}; C = 0.456 + 0.047(L K_{p}) - 0.0024(L K_{p})^{2}+ 0.00006(L K_{p})^{3}; D = 12C q_{pb}^{0.5}(E_{s}- E_{c})^{-0.25}These calculations require an iterative (trial and error) solution, because a value is needed for D in order to calculate K

_{p}, which is needed to calculate D. A trial value of D is chosen to start the process, then with values entered for all the**inputs**, the Excel formulas will calculate K_{p}, C and the pipe diameter, D. If the calculated value for D is different from the trial value, then repeat with the trial value of D set at the next standard pipe diameter less than the calculated value. Repeat if necessary.Standard U.S. diameters for storm water drainage pipe (all in inches) are:

4, 6, 8, 12, 15, 18, 21, 24, 27, 30, 33, 36, 39, 42, 48, 54, 60, 6" increments up to 180"

Excel spreadsheet templates can be downloaded through the links below to make these calculations in either U.S. or S.I. units. The last section of this article (on page 3) gives information about the parameters and equations in S.I. units.

Click here to download this Excel spreadsheet template in U.S. units.

Click here to download this Excel spreadsheet template in S.I units.

- slide 7 of 11
### Excel Spreadsheet Templates for Orifice Outlet Control

The image at the left shows an orifice outlet control structure with the orifice area, A

_{o}; width, W_{o}; height, H_{o}; and bottom elevation, E_{o}, shown. The image at the right below illustrates the Excel spreadsheet templates that can be downloaded to calculate the orifice size required to control the outlet flow to no more than the pre-development peak storm water runoff rate for the design storm. The Excel formulas proceed with the calculations if values are provided for the input parameters, which are only the following three:- water elevation in pond at design storage volume, E
_{s}, ft - orifice bottom elevation, E
_{c}, ft - Pre-development peak runoff rate, q
_{pb}, cfs

The equations used by the Excel formulas to calculate the orifice height and width are as follows:

A

_{o}= ( 0.2283 q_{pb})/[( E_{s}- E_{o})^{0.5}] ; H_{o}= A_{o}/W_{o}Two stage outlet flow control can be accomplished with an orifice as described here to control a low return period storm and a pipe designed as described in the previous section to control a high return period storm.

Excel spreadsheet templates can be downloaded through the links below to make these calculations in either U.S. or S.I. units. The last section of this article (on page 3) gives information about the parameters and equations in S.I. units.

Click here to download this Excel spreadsheet template in U.S. units.

Click here to download this Excel spreadsheet template in S.I units.

- water elevation in pond at design storage volume, E
- slide 8 of 11
Excel Spreadsheet Templates for Weir Outlet Control Design in US and SI Units Excel spreadsheet templates can be downloaded for design of storm water detention pond outflow control with a weir, using either S.I. units or U.S. units. Details of the S.I. units for the parameters and the S.I. versions of the equations for design of pipes, orifices and/or weirs for storm water detention pond outflow control are presented. The required weir length will be calculated by the Excel formulas based on input values for design pond water elevation, weir crest elevation, weir coefficient, and pre-development peak storm water runoff rate. - slide 9 of 11
### Excel Spreadsheet Templates for Weir Outlet Control

The image at the left illustrates the Excel spreadsheet templates that can be downloaded to calculate the weir length needed to control the outlet flow to no more than the pre-development peak storm water runoff rate for the design storm if values are provided for the parameters in the

**Inputs**column. Those input parameters are shown in the diagram at the right and are summarized below- water elevation in pond at design storage volume, E
_{s}, ft - weir crest elevation, E
_{w}, ft - Pre-development peak runoff rate, q
_{pb}, cfs - weir coefficient, C
_{w}

The equation used by the Excel formulas to calculate the weir length is:

L

_{w}= q_{pb}/[ C_{w}(E_{s}- E_{w})^{1.5}]A value often used for the weir coefficient, C

_{w}, is 3.1Two stage outlet flow control can be accomplished with a weir as described here to control a low return period storm and a pipe designed as described in a previous section to control a high return period storm.

Excel spreadsheet templates can be downloaded through the links below to make these calculations in either U.S. or S.I. units. The next section of this article gives information about the parameters and equations in S.I. units.

Click here to download this Excel spreadsheet template in U.S. units.

Click here to download this Excel spreadsheet template in S.I units.

- water elevation in pond at design storage volume, E
- slide 10 of 11
### S.I. units for Outlet Flow Control Design Parameters and Equations

**Pipe Outlet Flow Control:**The S.I. units for the parameters used with pipe outlet flow control calculations are:- Manning roughness coefficient of pipe, n, dimensionless
- pipe length, L, m
- water elevation in pond at design storage volume, E
_{s}, m - pipe centerline elevation, E
_{c}, m - Pre-development peak runoff rate, q
_{pb}, m^{3}/s - trial value for pipe diameter, D, mm

The equations remain nearly the same as with U.S. units, but some of the constants change, giving the following:

K

_{p}= 115,768 n^{2}D^{-4/3}; C = 0.456 + 0.047(LK_{p}) - 0.0024(LK_{p})2 + 0.00006(LK_{p})^{3};D = 1346 C q

_{pb}^{0.5}(E_{s}- E_{c})^{-0.25}**Orifice Outlet Flow Control:**- water elevation in pond at design storage volume, E
_{s}, m - orifice bottom elevation, E
_{c}, m - Pre-development peak runoff rate, q
_{pb}, m^{3}/s - A
_{o}= orifice area, m^{2} - W
_{o}= orifice width, m - H
_{o}= orifice height, m

The equations for S.I. units are:

A

_{o}= 0.4135 q_{pb}/(E_{s}- E_{o})^{0.5}; H_{o}= A_{o}/W_{o}**Weir Outlet Flow Control:**The parameters for weir outlet flow control calculations and their S.I. units are:- water elevation in pond at design storage volume, E
_{s}, m - Weir crest elevation, E
_{w}, m - Pre-development peak runoff rate, q
_{pb}, m^{3}/s - Weir coefficient, C
_{w} - Length of weir, L
_{w}, m

The equation for calculating the required weir length remains the same ( L

_{w}= q_{pb}/[ C_{w}(E_{s}- E_{w})^{1.5}], but the value typically used for the weir coefficient, C_{w}, is 1.71, instead of the 3.1 value used for U.S. units. - slide 11 of 11
### References and Image Credits

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.Image Credits:

All images drawn by H. Bengtson