This is an individual assignment.

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$.$ Manning$$s 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.

Report Requirements: Your report should include the following sections:

a$.$ Introduction

b$.$ Input Parameters

c$.$ Calculation Methods

d$.$ Output Parameters

e$.$ Example Application

a$.$ Input Data

b$.$ Output Data, include the following plots:

i$.$ Profile plot of bed elevation, water surface elevation, energy grade line, normal

depth line, and critical depth

ii$.$ Profile plot of Froude number

iii. Profile plot of cross$-$section averaged flow velocity

c$.$ Verification using HEC$-$RAS

Submission Requirements: An electronic copy of the report and program along with all input data must

be submitted to Canvas. The computer code is due by November $26$ at $10$:$00$ pm and the report is due

by December $13$ at $2$:$00$ pm$.$