Question $1$:

Water flows in a rectangular channel $)=80m,n=0\mathrm{.}026,S=(0\mathrm{.}0005$ at a discharge of $350\frac{m^3}{s}.$ At the end of the channel there is a vertical Ogee spillway with no piers or abutments. Using EXCEL, calculate the shape of the upstream gradually varied flow profile and present your results graphically and in table form. To what distance upstream is the water level affected by the dam? Note: Use $H_e=H_d$ when determining $C.\frac{P}{H_d}$ will be greater than $1\mathrm{.}33.$ It will be helpful to first sketch the flow profile before you calculate it$.$