Design of Wastewater Treatment Plant By Using Excel Sheets

Forecast future populations with linear and exponential models to estimate wastewater design flow, then multiply by per-capita daily use to obtain flow in cubic meters per day.

Use Excel to forecast wastewater generation with an exponential population model, applying 3% growth from 2021, and convert 60.8 L/capita.day to cubic meters per day.

Calculate peak flow, detention time, and chamber dimensions for the inlet chamber in pretreatment design, perform unit conversions, and ensure effective screening.

Explain screen channel design to remove rags, paper, plastics and metals, using manual or mechanical bar screens (fine and coarse) in a two-channel system.

Analyze screen channel design for wastewater treatment, including bar count, opening area, and screen inclination. Apply velocity calculations (Vb = Q/A) and headloss equations for normal and clogged conditions.

Apply Bernoulli calculations using excel to determine downstream depth under normal and clogged conditions. Design a screen channel of 4 m by 0.5 m by 1 m with free board.

Design a manual grit chamber to slow flow and settle grit and sand; it covers chamber profile, inlet, outlet, and settling velocity using stocks law and transitions law.

Compute the actual surface overflow rate for a grit chamber by applying removal efficiency and settling index, then determine grit channel dimensions and volume.

Compute the critical displacement velocity Vc for the grit chamber and compare with the horizontal velocity Vh to ensure Vh remains less than Vc for grit removal and velocity control.

Describe grit chamber weir design by calculating curve points from three opening distances, then apply rectangular weir design with C = 0.62 and L = 0.9 to compute head.

Explains Parshall Flume design for open channel flow metering using a millimeter dimension table and a flow range conversion to million liters per day to determine throat and total length.

Use a Parshall flume to measure flow from upstream height h1 and downstream height h2, applying a Q equation, then determine flume dimensions and a distribution box with 30-second detention.

Design excel sheets for anaerobic ponds within stabilization ponds, using phase one and phase two populations to estimate sewage flow, BOD load, and volumetric organic loading, and set desludging intervals.

Calculate anaerobic pond dimensions and volumes using Excel-based equations, determining surface and bed widths and lengths from depth, slope, and free board for two ponds.

Calculate the sludge volume and net pond volume for anaerobic pond design, applying detention time and organic loading rate to phase one and phase two.

Assess anaerobic pond performance by fecal coliform and BOD removal, using Ne and Le equations with retention times and a trial-and-error method, achieving FC removals around 95.5–96.1% across phases.

Examine anaerobic ponds design, tracing bod removal from 700 to about 346 across two phases and showing how pond dimension changes boost efficiency.

Calculate influent flow rate and BOD load to design facultative ponds, then apply surface loading rate, depth, and surface area to determine volume and a series and parallel arrangement.

Calculate facultative pond dimensions and volumes using surface width, surface length, bed width, bed length, average width, average length, side slope, and free board; compare parallel and series configurations.

Use excel sheets to design facultative ponds for wastewater treatment, computing detention time and surface BOD loading, and adjust pond count or dimensions to meet 10–15 day retention and 100–400 kg BOD/ha/day.

Calculate fecal coliform and BOD removal in facultative ponds using temperature-adjusted rate constants, retention time, and pond count across phase one and phase two.

Designs maturation ponds with specified depth, dimensions, and configurations, calculating surface length, surface width, bed length, bed width, volume, and retention time for phase one and phase two arrangements.

Design maturation ponds for wastewater treatment, assessing fecal coliform and BOD removal with Kt, T3, and n in series to determine retention time.

Explore how changing pond dimensions, numbers, and retention time in stabilization ponds raises treatment efficiency, reducing fecal coliform and BOD for irrigation reuse.

Explain the design of sludge drying beds, where sludge is spread on sand and dewatered by evaporation and gravity drainage, with a piping network beneath the sand to collect effluent.

Showcases using an excel design sheet to adjust population and flow rate inputs and automatically update pretreatment, inlet chamber, and screen channel design parameters.

Redesign the grit chamber using the new flow, updating dimensions, retention time, and horizontal velocity. Ensure the rectangular weir meets the critical displacement velocity requirements.

Use the same Excel sheet to update Parshall flume dimensions as flow increases, recalculating throat width and total depth, and design the distribution box with detention time.

Adjust the anaerobic pond design for high flow using Excel sheets, increasing pond numbers and dimensions to meet detention time, organic loading, and fecal coliform and BOD removal.

Design facultative ponds for wastewater treatment using excel sheets, adjusting surface area, depth, and volume to control retention time and BOD loading, with ponds in series and parallel.

Increase the number of maturation ponds and adjust dimensions to improve retention time, fecal coliform and BOD removal, and design sludge drying beds for irrigation-ready effluent.