# Hydraulics in Civil Engineering

### Excel Spreadsheet Templates for Storm water Detention Pond Outlet Structure Design

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.

### Litter Traps are a Must to Prevent Litter from Polluting and Clogging Waterways

Litter traps prevent litter from going further downstream and polluting water sources. They are a must if a river has to maintain its pristine quality.

### Excel Formulas for Calculating the Volume of Storm Water Detention Ponds

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.

### Broad Crested Weir Flow Rate Calculations for Open Channel Flow Measurement with Excel Spreadsheets

Broad crested weir flow rate calculations can be made with the Excel spreadsheets that can be downloaded from this article. The open channel flow rate can be found using a broad crested weir equation for critical flow over the weir, along with the minimum weir height needed for critical flow.

### Excel Formulas for Open Channel Flow Measurement Calculations with Parshall Flume Equations

Download spreadsheets with Excel formulas to make Parshall flume open channel flow measurement calculations. These have been built into the Excel spreadsheets for free flow and submerged flow with U.S. units or S.I. units.

Get Excel spreadsheet templates for calculating a watershed time of concentration. This parameter is of interest primarily for its use to calculate peak storm water runoff rate for storm water management facilities.

### Use of Excel Formulas for Design Rainfall Intensity Calculation

Download Excel spreadsheets to calculate design rainfall intensity and design peak storm water runoff rate. The Excel formulas derive an equation for rainfall intensity and then calculate the design values in either U.S. units or S.I. units.

### Rational Method Runoff Coefficient Tables for Storm Water Runoff Calculation

Rational method runoff coefficient tables are provided in this article. Watershed runoff coefficients depend upon the land use, soil type and slope of the watershed. Runoff coefficients are needed to calculate storm water runoff rate using the Rational Method.

### Excel Templates Serve as a Rectangular Weir Flow Calculator

This rectangular weir flow template calculates the water flow rate over a suppressed or a contracted rectangular weir. Two equations are used to calculate the weir flow in each case.

### Excel Spreadsheet Templates for Manning Equation Calculations with Partially Full Pipe Flow

Make open channel flow calculations for partially full pipe flow with these excel spreadsheet templates. We use the Manning equation and equations for partially full pipe flow to calculate flow rate and velocity or normal depth