Question: Standard Step Program: Develop a computer program in Excel ( with Visual Basic for Applications ) using only English units to calculate cross - section

Standard Step Program: Develop a computer program in Excel (with Visual Basic for Applications) using only English units to calculate cross-section averaged velocity, flow depth, Froude number, shear stress, and water surface elevation for a canal with the following characteristics: a. Steady flow b. Spatially-varying bedslope (bedslope determined from input of cross section elevations and canal stations) c. Spatially-varying trapezoidal cross section (i.e., all cross sections are trapezoidal but may have different bottom widths and side slopes) d. Spatially-varying hydraulic resistance e. Spatially-varying contraction/expansion loss coefficient f. Boundary Conditions a. Upstream: subcritical flow with user-specified inflow rate. b. Downstream: Free flowing conditions over a suppressed rectangular sharp-crested weir (entire downstream cross section is rectangular). i. For your example problem, you must ensure your example application scenario has a weir height that causes critical depth. Input Parameters: In addition to the steady-state discharge, your program should have the following input parameters: 1. For each cross section: a. Station along the channel b. Bed elevation c. Channel bottom width (B) d. Channel side slopes (m) e. Mannings roughness coefficient (n) f. Expansion coefficient (Ce) g. Contraction coefficient (CC)2. For sharp-crested weir: a. Weir height (P) b. Weir width (b) c. Weir length (L) Additional Requirements for CVNG 5330 Students: Your example problem must have both supercritical and subcritical sections with a hydraulic jump. GIVE THE CODE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!