Sewage Treatment Plant Design By Using Excel Sheets

Design of Pre-treatment and Secondary Sewage Treatment Units by Using Excel Sheets

In this course I would like to teach you simple method of sewage treatment design. After this course you will be able to confidently use excel sheets in design of sewage treatment plants as Pre-treatment units, and stabilization ponds as secondary treatment units.

What you’ll learn

  • Design of Sewage Treatment Plant By Using Excel Sheets.

Course Content

  • Introduction –> 1 lecture • 4min.
  • Population Forecasting and Projected wastewater generation –> 2 lectures • 13min.
  • Pre-treatment Units Design –> 10 lectures • 1hr 17min.
  • Secondary Treatment Units Design (Stabilization Ponds Design) –> 13 lectures • 1hr 31min.
  • Treatment Plant Design for high amount of Sewage Flow –> 6 lectures • 35min.

Sewage Treatment Plant Design By Using Excel Sheets

Requirements

  • Be able to use Excel Program.

In this course I would like to teach you simple method of sewage treatment design. After this course you will be able to confidently use excel sheets in design of sewage treatment plants as Pre-treatment units, and stabilization ponds as secondary treatment units.

The course consists of 5 sections:

section 1: Introduction about Sewage Treatment purpose, and types and stages of Sewage Treatment Plants, and the purpose of each unit in Pre-treatment units and Secondary treatment units.

section 2: Population and flow rate forecasting for phases of the project and for project design period.

section 3: Design of Pre-treatment units as Inlet Channel, Bar Screen Channel, Grit Chamber, and Parshall Flume.

section 4: Design of Secondary treatment units as Stabilization Ponds that consists of Anaerobic Ponds, Facultative Ponds, and Maturation Ponds. In addition to sludge drying bed design, and raising the efficiency of treatment plant by control the input data.

section 5: Example of treatment plant design for high value of population and high amount of sewage flow rate by using the same excel sheets.

 

In this course the excel sheet will be used in the design, because excel sheet simplify the calculation due to the relationships between the cells are by equations so when you change any value, all calculations of design will be automatically changed. You can use the same excel sheet of design, just you have to insert your values of population or sewage flow rate and you will get the results, but just you have to check the standard ranges that exist in the same sheet.