Using a spreadsheet program you have written, compute and plot the unequalized and the e...

Using a spreadsheet program you have written, compute and plot the unequalized and the equalized hourly BOD mass loadings to the Metuchen WWTP ( Problem 13-19 ). Determine the following ratios for BOD mass loading: peak to average, minimum to average, peak to minimum.

Problem 13-19

A treatment plant being designed for Metuchen requires an equalization basin to even out flow and BOD variations. The following flows and BOD₅ have been found to be typical of the average variation over a day. What volume of equalization basin is required to provide for a uniform outflow equal to the average daily flow? Assume the flows are hourly averages and that an addition of 25% to the estimated volume will be provided to account for contingencies.