Dam Spillway Design
 

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Description:
Calculation Preview



A spillway is a structure used to provide the controlled release of flows from a dam or levee into a downstream area, typically being the river that was dammed. In the UK they may be known as overflow channels. Spillways release floods so that the water does not overtop and damage or even destroy the dam. Except during flood periods, water does not normally flow over a spillway. In contrast, an intake is a structure used to release water on a regular basis for water supply, hydroelectricity generation, etc. Floodgates and fuse plugs may be designed into spillways to regulate water flow and dam height. Other uses of the term "spillway" include bypasses of dams or outlets of a channels used during highwater, and outlet channels carved through natural dams such as moraines.

Energy dissipation
As water passes over a spillway and down the chute, potential energy converts into increasing kinetic energy. Failure to dissipate the water's energy can lead to scouring and erosion at the dam's toe (base). This can cause spillway damage and undermine the dam's stability. The energy can be dissipated by addressing one or more parts of a spillway's design.
  1. Steps - First, on the spillway surface itself by baffles and/or steps along the spillway.
  2. Flip bucket - Second, at the base of a spillway, a flip bucket can create a hydraulic jump and deflect water upwards.
  3. Ski jump - A ski jump can also direct water horizontally and eventually down into a plunge pool or two ski jumps can direct their water discharges to collide with one another.
  4. Stilling basin - Third, a stilling basin at the terminus of a spillway serves to further dissipate energy and prevent erosion. They are usually filled with a relatively shallow depth of water and sometimes lined with concrete. A number of velocity-reducing components can be incorporated into the their design to include chute blocks, baffle blocks, wing walls, surface boils or an end sill.

This download is a zip file which includes four separate Excel files:

  1. Bucket design.xls
  2. Spillway Stability.xls
  3. Optimiasation of spillway - ungated.xls
  4. length of spillway.xls

Calculation Reference
Water Resource Engineering
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Hydraulics Engineering
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Open Channel Hydraulics
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
31 May 2012
Submitted By:
HarishKumarMahavar
File Date:
31 May 2012
File Author:
Harish Kumar Mahavar
File Version:
1.0
File Size:
139.39 Kb
File Type:
zip
Downloads:
126
Rating:
stars/4.gifTotal Votes:8
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

Comments  

 
#2 hades3 2013-11-28 06:21
Thank you for this spreadsheet! It is clearly written and definitely worth checking out!Keep up the good work!
 
 
#1 JohnDoyle 2012-05-31 08:14
Thank you for your debut calculation Harish. I have awarded a 6 month XLC Pro subscription by way of thanks.[Admin]
 

Please sign in or register to add a comment.

We have 13 guests and 38 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative