Part $2$ of $3$

$2.$ a$.$ Develop an Excel spreadsheet to implement the Muskingum method to route the following storm hydrograph over a stream reach that is characterized by $\backslash (\backslash$mathrm$\{$K$\}=2\backslash$mathrm$\{$hr$\}\backslash )$ and $\backslash (\backslash$mathrm$\{$x$\}=0\mathrm{.}15\backslash ).$ The spreadsheet needs to be created to accept different values for K and x $.$

b$.$ Plot both the inflow and outflow hydrograph on the same graph, with axes labeled and with units indicated.

c$.$ Submit a screenshot of the spreadsheet and the plot.

d$.$ Perform and submit sample calculations for the determination of $\backslash ($ D$,$ C$\_\{0\},$ C$\_\{1\}\backslash )$ and $\backslash ($ C$\_\{2\}\backslash ),$ as well as one routing calculation.

e$.$ You need to continue the routing until the outflow hydrograph reaches $\backslash (105\backslash \%\backslash )$ of the baseflow. At what time would you stop routing?

f$.$ If K were changed from $2$ hr to $3$ hr $,$ would the outflow peak discharge increase or decrease, and by how much? Why would this change occur? Type your response.