Problems:

For the flow rate information given in the spreadsheet on blackboard, determine the in$-$line

storage volume $(m^3)$ required to provide a constant flow rate from the equalization tank.

Ignore the COD concentration data for this problem.

For the flow rate information used in Problem #$1$ and the COD $($Chemical Oxygen Demand$)$

data, use a spreadsheet to investigate the impact of different equalization tank volumes on

the effluent concentration from the equalization tank. Please turn in a copy of the

spreadsheet as well as prepare a figure showing the following:

a$)$ the influent concentration data vs$.$ time,

b$)$ the effluent concentration from the equalization tank $($vs$.$ time$)$ for a equalization tank

volume equal to that required for flow equalization $($determined in problem #$1).$ Show

your results for two different initial concentrations, and

c$)$ the effluent concentration from the equalization tank $($vs$.$ time$)$ for a equalization tank

volume equal to $2$ times and $5$ times the value required for flow equalization $($from in

problem #$1).$

$\backslash$table$[[,,$Flow Rate,Conc.$],[$Time$,$Flo,$($m$3/$h$),$mg$/$L$],[,1,105,1200],[,2,200,2000],[,3,200,1500],[,4,155,2100],[,5,175,2500],[,6,85,1400],[,7,80,1100],[,8,110,4000],[,9,150,2100],[,10,100,1500],[,11,70,3500],[,12,65,2300]]$