I have attached my assignment.
1. Create a general EXCEL program to route any storm hydrograph through any reservoir reach. The inputs will be:
- The spillway constant
- The spillway length (ft)
- The surface area of the reservoir (constant) (acres)
- The routing time (Δt) (hours)
- The (inflow) storm hydrograph to be routed (Q in cfs)
2. Run the program for the following inputs:
-
- Spillway constant = (1st digit of your student number/3)+2
- Spillway length = 2nd digit of your student number*3
- Surface area = 3rd digit of your student number*100
- Routing time = 4th digit of your student number
- Inflow = (please see the table in the attachment file)
Skip any zeros in your student number.
"Looking for a Similar Assignment? Order now and Get 10% Discount. Discount Code - "Newclient"!