Question

# 2.(40 points) Perform a demonstration of the calculations below (just one calculation of each type) for part (a-e) to demonstrate master of the concepts, then do the rest in MS

Excel(excel file must be submitted). Make a single table of the results, but also create plots of the data below for parts a-e with appropriate axes to show the results at each step. Recorded flow rates at the outlet of a watershed for an excess rainfall of 1.92 in over a 12-hourtimespan are shown in the table of 6-hour average observed flows below. If the base flow is 375cfs throughout the storm, determine the following for this watershed: a. The surface runoff for each 6-hour time block b. The 12-hour unit hydrograph (i.e. 1 inch of rainfall in 12 hours) c. The S-hydrograph (for continuous excess rainfall of 1 inch per 12 hours) d. The 6-hour unit hydrograph (1 inch of rainfall in 6 hours; Note! – This is probablynot as straightforward as you may think. The simplest approach is explained here:https://www.youtube.com/watch?v=wSyFrX48JOo Give it a try, maybe I will domy own video to show you as well) e. The hydrograph for a 24-hour storm having four 6-hour blocks of net rainfall of0.7, 3.8, 10.8, and 1.8 in/hour, including 375 ft’/s of base flow

Fig: 1

Fig: 2

Fig: 3

Fig: 4

Fig: 5

Fig: 6

Fig: 7

Fig: 8