I will need the MS Excel and formulas

#1 A trapezoidal channel to be excavated into the ground will be sized to carry Q = 200 cfs at normal flow. The bottom slope is S0 = 0.0004 and the Manning roughness factor is n = 0.020. The land surface also has a slope of 0.0004. If the bottom width of the channel is 10 ft and if cost of excavation is the main concern, which of the following alternatives for t he channel side slope “m” is the best: (a) 1.5, (b) 2.0, or (c) 2.5? Neglect free board. Solve this problem using Excel. Show the results of your trial and error calculations for each case (i.e. include the excel tables). In addition, show a summary table of the final results for the 3 cases. #2 A trapezoidal channel lined with Bermuda grass has a bottom width of 7 ft, side slopes “m” of 2.5 and a longitudinal bottom slope of 0.0009. Determine the normal flow depth in the channel for Q = 70 cfs if the grass has a good stand and is about 30 cm tall. Use Excel to solve this problem and show the details of your calculations. #3 A trapezoidal channel has a bottom width of 1.0 m, side slopes “m” of 3, and a longitudinal bottom slope of 0.01. The c hannel is lined with riprap of d50 = 15 cm. The normal flow depth is 0.60 m. Is equation 3.34 or 3.35 more suitable for this channel? Determine the discharge at a normal depth of 0.60 m.