Using a spreadsheet you have developed, complete a Type II settling analysis. The following data were gathered to design a settling basin. The initial suspended solids concentration for the test was $25\mathrm{.}0m\frac{g}{L}.$ Develop a detention time versus percent removal $($at least $5$ data points$)$ and a overflow versus percent removal $($at least $5$ data points generated from total fraction removed$).$ You will submit a PDF of your spreadsheet in GradeScope; in addition, you will need to submit the actual spreadsheet in CANVAS NOTE: GradeScope only accepts PDFs$.$ For full credit, you will need to submit your spreadsheet to CANVAS. See additional submission folder below.

The data given are suspended solids concentration, in $m\frac{g}{L}.$

$\backslash$table$[[,,,$Time $($min$),,,],[$Depth ${?}^a,m,10,25,30,50,75,90],[0\mathrm{.}3,16\mathrm{.}0,11\mathrm{.}0,7\mathrm{.}5,7\mathrm{.}0,6\mathrm{.}1,4\mathrm{.}5],[0\mathrm{.}6,17\mathrm{.}0,14\mathrm{.}2,11\mathrm{.}1,9\mathrm{.}0,8\mathrm{.}1,6\mathrm{.}5],[0\mathrm{.}9,17\mathrm{.}4,15\mathrm{.}3,12\mathrm{.}5,10\mathrm{.}8,8\mathrm{.}9,7\mathrm{.}5],[1\mathrm{.}2,18\mathrm{.}1,15\mathrm{.}7,13\mathrm{.}1,11\mathrm{.}8,10\mathrm{.}1,8\mathrm{.}5],[1\mathrm{.}5,18\mathrm{.}9,16\mathrm{.}0,13\mathrm{.}5,12\mathrm{.}2,11\mathrm{.}0,9\mathrm{.}2]]$

aDepths from top of column, column depth $=1\mathrm{.}5m$

Hint: to plot Isopleths try to linearly interpolate between two data points within the same HRT$.$ Use equally spaced percent removal $,$ etc$).$