Sewage Treatment Plant Design By Using Excel Sheets


Sewage Treatment Plant Design By Using Excel Sheets


updated on icon Updated on Nov, 2023

language icon Language - English


architecture icon Design,Excel sheets

Lectures -32

Duration -3.5 hours


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 8,500+ top Tutorials Point courses anytime, anywhere.

Course Description

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.


What will you learn in this course:

  • Ability of Design of Sewage Treatment Plant as pre-treatment units and secondary treatment units By Using Excel Sheets


What are the prerequisites for this course?

  • Able to use Excel Program
  • Basic information about sewage treatment
Sewage Treatment Plant Design By Using Excel Sheets


Check out the detailed breakdown of what’s inside the course

3 Lectures
  • play icon Introduction 03:42 03:42
  • play icon Population Forecasting 07:29 07:29
  • play icon Projected Wastewater Generation 05:16 05:16
Pre-Treatment Units Design
10 Lectures
Secondary Treatment Units Design
13 Lectures
Treatment Plant Design for High Amount of Sewage Flow
6 Lectures

Instructor Details



Wastewater Collection Networks Design, Water Supply Networks Design, Sewage Treatment Plants Design, Water Clarification Plants Design, Air Pollution, Solid Waste Management, Occupational Health and Safety training, teaching the subjects of Hydraulic, Fluid Mechanics, Hydraulic Structures, Environmental Engineering, Water Pollution, Air Pollution, Environmental and Social Impact Assessment for the Projects, Medical Waste Management, Design of waste landfills.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us