Part $2$ of $4$

$2.$ a$.$ Develop a spreadsheet to determine the ordinates of the UH using the dimensionless UH table found in Slide $31$ of presentation Week $6b$ Synthetic Unit Hydrographs if a prior analysis has determined that $T_R=6\mathrm{.}02hr$ and $Q{P}_P=527cfs.$ You must provide at least $10$ additional $(x,y)$ coordinates in order to accurately represent the shape of the UH$.$

b$.$ Plot the unit hydrograph.

c$.$ Print and submit a screenshot of the spreadsheet and plot.

d$.$ Include sample calculations.