Using a spreadsheet program you have written, rework Example 16-1 using the following ML...

Using a spreadsheet program you have written, rework Example 16-1 using the following MLVSS concentrations instead of the 2,000 mg/L used in the example: 1,000 mg/L; 1,500 mg/L; 2,500 mg/L; and 3,000 mg/L.

Example 16-1

The town of Lawrence has been directed to upgrade its primary WWTP to a secondary plant that can meet an effluent standard of 30.0 mg/L BOD₅ and 30.0 mg/L total suspended solids (TSS). They have selected a completely mixed activated sludge system. Assuming that the BOD₅ of the TSS may be estimated as equal to 63% of the TSS concentration, estimate the required volume of the aeration tank. The following data are available from the existing primary plant.