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


Part 1 - General information

1) Select the Criteria for design (ex: City of Houston)
This is done by selecting the pulldown list box with your mouse.
2) Select your design storm (ex: 2-year)
3) Fill in project detail information.
4) Fill in area names for your drainage areas.
(notice as you fill in the area names the program autofills the inlet names.)
5) Fill in the respective drainage area sizes (in acres)
6) Fill in the runoff coefficient for each area.
7) Fill in the Manning "n" value for each area
8) Fill in the Length of each run of pipe
9) Fill in the Grade (ft/100ft) each pipe will be laid at.
10) Fill in the down stream flowline for the last pipe in each grouping.
11) Fill in the Inlet elevation for each inlet
12) Fill in the proposed ground elevation Upstream and Downstream for each pipe
13) Fill in the K factor for each junction.

Part 2 - Link it all together

Each lead coming into the Main Trunk or another lead must be linked in order to link the lead to the main trunk you need to add the Total Area Column for the lead to the Total area Column where the flow is entering the trunk. The downstream flowline of the lead needs to be linked in the same manner.

Calculation Reference
Storm water
| Find on | Find on | Find on | Find on | Find on |
Sewer design
| Find on | Find on | Find on | Find on | Find on |
| Find on | Find on | Find on | Find on | Find on |
Rainwater engineering
| Find on | Find on | Find on | Find on | Find on |

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:
07 Dec 2009
Submitted By:
File Date:
07 Dec 2009
File Version:
File Size:
104.00 Kb
File Type:
stars/0.gifTotal Votes:0
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.

Please sign in or register to add a comment.

We have 9 guests and 40 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.



Real Time Analytics