Part $3$ of $3$

$3.$ a$.$ Develop an Excel spreadsheet to determine the value for x based on the inflow and outflow hydrographs provided for a stream reach of interest.

b$.$ Plot the storage $($ x $-$axis$)$ vs$.$ the weighted discharge $($ y $-$axis$)$ for all x values considered, and include units. Develop a separate plot for each value of x considered. Identify the x $-$value selected.

c$.$ Submit a screenshot of the spreadsheet and all of the storage$-$weighted discharge plots.

d$.$ Submit a hardcopy of the spreadsheet plot where you determine K if x was $0\mathrm{.}1$ by hand drawing your own line of best fit $($not derived by Excel$).$