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 crosssection averaged velocity, flow depth, Froude number, shear stress, and water surface elevation for a canal with the following characteristics: a Steady flow b Spatiallyvarying bedslope bedslope determined from input of cross section elevations and canal stations c Spatiallyvarying trapezoidal cross section ie all cross sections are trapezoidal but may have different bottom widths and side slopes d Spatiallyvarying hydraulic resistance e Spatiallyvarying contractionexpansion loss coefficient f Boundary Conditions a Upstream: subcritical flow with userspecified inflow rate. b Downstream: Free flowing conditions over a suppressed rectangular sharpcrested 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 steadystate discharge, your program should have the following input parameters: 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 For sharpcrested weir: a Weir height P b Weir width b c Weir length L Additional Requirements for CVNG 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
