Sewage Treatment Plant Design By Using Excel Sheets from Udemy

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's inside

Learning objective

Design of sewage treatment plant by using excel sheets

Syllabus

Introduction

Estimation of future population in defferent phases of the project and at the end design period

Population Forecasting

Projected wastewater generation

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Focuses on practical design skills using Excel, which is valuable for professionals needing quick and efficient solutions in sewage treatment plant design

Covers pre-treatment and secondary treatment units, offering a comprehensive overview of sewage treatment plant components and their design considerations

Emphasizes the use of Excel sheets for calculations, which can streamline the design process and allow for easy adjustments based on changing parameters

Includes population and flow rate forecasting, which are essential steps in the design of sewage treatment plants and infrastructure projects

Relies on Excel, which may not be suitable for complex projects requiring advanced modeling or simulation software commonly used in the field

Requires learners to independently verify that the standard ranges used in the Excel sheets align with current regulations and best practices in their region

Reviews summary

Practical stp design calculations using excel

According to learners, this course offers a practical approach to sewage treatment plant design by focusing on design calculations using provided Excel sheets. Students widely agree the Excel tools are very helpful and time-saving, providing a solid foundation for practical application, particularly for preliminary units and stabilization ponds. While many find the explanations clear and easy to follow, some reviewers note the course assumes some prior engineering knowledge and may be challenging for complete beginners who lack understanding of the underlying theory. The course is seen as a good starting point for applying design principles rather than a deep dive into theoretical concepts or advanced treatment methods.

Covers pre-treatment and stabilization ponds.

"...designing preliminary and secondary treatment units using simple methods."

"It covers the main preliminary and stabilization pond units effectively."

"...for the specific units covered, it's quite good."

"It focuses on specific units but covers them thoroughly..."

Instructor explains concepts clearly for practical use.

"The instructor explains the concepts clearly and the step-by-step process makes it easy to follow along."

"The explanations are clear for the most part..."

"The way the instructor breaks down the design process..."

Teaches hands-on design using provided tools.

"A valuable course for learning the practical side of STP design."

"The focus on using Excel sheets for design is exactly what I needed."

"This course is good for getting hands-on experience with design calculations using a spreadsheet."

"It focuses on specific units but covers them thoroughly for practical purposes."

Excel sheets provided are highly useful.

"The excel sheets provided are very helpful for practical design calculations."

"The practical application with the provided sheets is the main strength."

"The way the instructor breaks down the design process and provides the excel sheets is fantastic."

"Very practical and straight to the point. The focus on using Excel sheets for design is exactly what I needed... apply the sheets to a small project almost immediately."

"Provides useful Excel tools for design."

Doesn't cover advanced topics or theory deeply.

"Some parts could be more detailed, especially on specific regional standards or more advanced treatment types..."

"I would have liked to see more depth on advanced topics or alternative treatment processes..."

"...the explanation of *why* certain formulas are used or the derivation of design criteria is lacking."

May be challenging without engineering background.

"It assumes some prior knowledge, especially in understanding the underlying engineering principles behind the calculations."

"I found the course difficult to follow without a strong background in environmental engineering."

"It feels more like a 'how-to use this sheet' rather than 'how-to design'. Not for beginners."

"having some prior understanding of wastewater treatment makes it easier to grasp the concepts quickly."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Sewage Treatment Plant Design By Using Excel Sheets with these activities:

Review Wastewater Engineering Principles

Show steps

Refresh your understanding of fundamental wastewater engineering principles to better grasp the design concepts covered in the course.

Show steps

Review key concepts in wastewater treatment.
Solve practice problems related to flow rates and pollutant removal.

Explore 'Excel for Scientists and Engineers'

Show steps

Enhance your Excel skills to improve your efficiency in designing sewage treatment plants.

View Putting Knowledge to Work on Amazon

Show steps

Review chapters on formulas, functions, and data analysis.
Practice using Excel to solve engineering problems.

Review 'Wastewater Engineering: Treatment and Resource Recovery'

Show steps

Deepen your understanding of wastewater treatment processes by studying a comprehensive textbook.

View Wastewater Engineering: Treatment and Resource... on Amazon

Show steps

Read chapters related to pre-treatment and secondary treatment units.
Focus on the design considerations for each unit.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Practice Excel-Based Calculations

Show steps

Reinforce your ability to use Excel for sewage treatment plant design calculations by working through practice problems.

Show steps

Create Excel sheets for different treatment units.
Input sample data and verify the results.
Modify input parameters and observe the changes in the design.

Develop an Excel Template for Parshall Flume Design

Show steps

Create a reusable Excel template specifically for designing Parshall Flumes, a key component covered in the course.

Show steps

Research the design equations for Parshall Flumes.
Implement the equations in an Excel sheet with clear input and output cells.
Add error checking and validation to ensure accurate results.

Create a Design Report Template

Show steps

Solidify your understanding of the design process by creating a template for a sewage treatment plant design report.

Show steps

Outline the sections of the report.
Include sections for population forecasting, flow rate estimation, and unit design.
Add placeholders for calculations and results.

Design a Small-Scale Sewage Treatment Plant

Show steps

Apply your knowledge by designing a sewage treatment plant for a small community or industrial facility.

Show steps

Gather data on population, flow rates, and wastewater characteristics.
Select appropriate treatment units based on the data.
Design each unit using Excel sheets.
Prepare a design report.

Career center

Learners who complete Sewage Treatment Plant Design By Using Excel Sheets will develop knowledge and skills that may be useful to these careers:

Sanitary Engineer

Sanitary engineers focus on public health through the design and implementation of sanitation systems, including wastewater treatment facilities. For a sanitary engineer, this comprehensive course helps build a foundation in the design of sewage treatment plants. With the knowledge gained from this course, you can confidently design pre treatment and secondary treatment units using Excel sheets. Sanitary engineers wishing to add proficiency to their arsenal should take this course.

See salaries and explore the career path for Sanitary Engineer

Water Treatment Plant Designer

Water treatment plant designers are responsible for the planning and design of facilities that treat water for various purposes. This course helps build a foundation in the design of sewage treatment plants, a specific type of water treatment process. You will learn to design pre-treatment and secondary treatment units using Excel sheets. Someone aiming to become a Water Treatment Plant Designer should consider focusing on the Excel sheets for designing various components.

See salaries and explore the career path for Water Treatment Plant Designer

Environmental Engineer

Environmental engineers work to protect the environment and human health through the design and implementation of solutions to pollution and environmental problems. This course helps build a foundation in the design of sewage treatment plants, a critical aspect of environmental engineering. With the knowledge gained from this course, you can confidently design pre treatment and secondary treatment units using Excel sheets. This course focusing on the practical application of Excel simplifies calculations and allows for dynamic adjustments based on changing input values in sewage treatment plant design. Someone aspiring to become an Environmental Engineer may find it useful for quickly applying standard ranges to different population sizes.

See salaries and explore the career path for Environmental Engineer

Civil Engineer

Civil engineers design, construct, supervise, operate, and maintain infrastructure projects and systems in the public and private sector, including water and wastewater treatment facilities. For a civil engineer interested in water resources, this course helps build a foundation in the design of sewage treatment plants. It provides the practical skills to design pre-treatment and secondary treatment units using Excel sheets. The course's emphasis on using Excel to simplify calculations and dynamically adjust designs based on changing input parameters is invaluable. Someone wishing to become an Environmental Engineer may find it useful for quickly applying standard ranges to different population sizes within civil engineering projects.

See salaries and explore the career path for Civil Engineer

Water Resource Engineer

Water resource engineers focus on managing and protecting water resources, including designing and managing water and wastewater treatment systems. This course helps build a foundation in the design of sewage treatment plants, a vital component of water resource management. With the knowledge gained from this course, you can confidently design pre treatment and secondary treatment units using Excel sheets. Someone wishing to become a Water Resource Engineer will find it useful to quickly apply standard ranges to different population sizes.

See salaries and explore the career path for Water Resource Engineer

Process Engineer

Process engineers focus on optimizing industrial processes, including those in wastewater treatment plants. This course helps build a foundation in sewage treatment plant design, providing insight into the various stages and units involved. You will learn about pre-treatment and secondary treatment units, and design using Excel sheets. This course may be useful for process engineers to identify areas for improvement and implement process optimization strategies. The hands on work with Excel will be especially relevant.

See salaries and explore the career path for Process Engineer

Wastewater Treatment Plant Operator

Wastewater treatment plant operators control the equipment and processes that remove pollutants from wastewater. This course helps become familiar with sewage treatment plant design, including the various stages and units involved in the process. You will learn about pre-treatment units and secondary treatment units, and you will gain the ability to use Excel sheets for design purposes. This course may be useful for wastewater treatment plant operators to understand the design considerations that influence plant operations and optimization. The course's emphasis on Excel-based design tools provides a practical approach to understanding and managing treatment processes.

See salaries and explore the career path for Wastewater Treatment Plant Operator

Project Engineer

Project engineers oversee engineering projects from conception to completion, including the design and construction of wastewater treatment plants. This course helps build a foundation in the design of sewage treatment plants, providing a practical understanding of the engineering aspects. You will learn to design pre-treatment and secondary treatment units using Excel sheets. The course may be useful for project engineers to manage and coordinate the design and construction phases of wastewater treatment facilities effectively. Excel simplification will be greatly useful.

See salaries and explore the career path for Project Engineer

Environmental Consultant

Environmental consultants advise organizations on environmental issues, such as pollution control and waste management. This course helps build a foundation in the design of sewage treatment plants, providing a practical understanding of treatment processes. You will learn to design pre-treatment and secondary treatment units using Excel sheets. This course may be particularly helpful for consultants who need to assess and recommend improvements to existing wastewater treatment systems. The course's focus on the practical application of Excel simplifies calculations and allows for dynamic adjustments based on changing input values in sewage treatment plant design.

See salaries and explore the career path for Environmental Consultant

Environmental Engineering Technician

Environmental engineering technicians assist environmental engineers with various tasks, including data collection, analysis, and design implementation. This course helps support the design of sewage treatment plants, providing a practical understanding of the underlying principles. You can learn to design pre-treatment and secondary treatment units using Excel sheets. This course may be useful for technicians to understand the design process and contribute effectively to engineering projects. The course's emphasis on Excel-based design tools provides a practical approach to understanding and managing treatment processes.

See salaries and explore the career path for Environmental Engineering Technician

Sustainability Manager

Sustainability managers develop and implement sustainability initiatives for organizations. This course helps build a foundation in sewage treatment plant design, a critical aspect of sustainable water management. You will learn about pre-treatment and secondary treatment units, and design using Excel sheets. This course may be useful for sustainability managers to understand the technical aspects of wastewater treatment and promote sustainable practices. Excel applications are invaluable.

See salaries and explore the career path for Sustainability Manager

Regulatory Affairs Specialist

Regulatory affairs specialists ensure that organizations comply with environmental regulations, including those related to wastewater discharge. This course may be useful for understanding sewage treatment plant design, providing insights into the technologies and processes used to meet regulatory standards. You will gain familiarity with pre-treatment and secondary treatment units, and design using Excel sheets. This course may be useful for regulatory affairs specialists to assess compliance and ensure effective wastewater management practices. A regulatory affairs specialist needs to understand these processes.

See salaries and explore the career path for Regulatory Affairs Specialist

Environmental Compliance Inspector

Environmental compliance inspectors enforce environmental regulations, including those related to wastewater treatment. This course may be useful for understanding sewage treatment plant design, providing insights into the technologies and processes used to meet regulatory standards. You will gain familiarity with pre-treatment and secondary treatment units, and design using Excel sheets. This course may be useful for inspectors to assess compliance and identify potential violations. An inspector should be able to visualize these systems.

See salaries and explore the career path for Environmental Compliance Inspector

Environmental Engineering Professor

Environmental engineering professors teach and conduct research in areas related to environmental protection and sustainability. This course can help enhance the understanding of sewage treatment plant design, providing practical knowledge and skills that can be integrated into teaching and research activities. The ability to use Excel sheets for design purposes may be useful for demonstrating practical applications to students. Someone intending to become a professor should take this course.

See salaries and explore the career path for Environmental Engineering Professor

Research Scientist

Research scientists conduct research to advance knowledge in various fields, including environmental engineering and wastewater treatment. This course can help build a foundation in sewage treatment plant design, providing practical knowledge and skills that can be applied to research projects. The course's emphasis on Excel-based design tools provides a practical approach to modeling and simulating treatment processes. A research scientist should take this course to begin the processes of design.

See salaries and explore the career path for Research Scientist

Sewage Treatment Plant Design By Using Excel Sheets

What's inside

Learning objective

Syllabus

Traffic lights

Save this course

Reviews summary

Practical stp design calculations using excel

Activities

Career center

Reading list

Share

Similar courses