NewNPPE, FE and CPD prep built for Canadian engineersCreate a free accountGet 10 Coins free upon signup for a limited time

  • N/A
  • No ratings yet

Activated Sludge Calculations with Excel


Course Description

The activated sludge process is a biological treatment system that uses microorganisms to degrade organic pollutants present in wastewater. These microorganisms, primarily bacteria, metabolize organic matter under aerobic conditions, converting it into carbon dioxide, water, and new cell mass. This process is highly efficient and adaptable, which is why it is extensively used in municipal wastewater treatment plants. However, its performance depends heavily on maintaining the right environmental and operational conditions, making proper calculations essential.

What you'll learn in this course?

  • Understand fundamentals of activated sludge process (ASP)

  • Perform key design and operational calculations

  • Calculate MLSS, F/M ratio, SRT, and oxygen demand

  • Develop Excel sheets for wastewater calculations

  • Analyze process performance using real data

  • Apply calculations to optimize treatment efficiency


Prerequisites

  • Basic understanding of wastewater-treatment processes and engineering calculations

  • Basic familiarity with Microsoft Excel or equivalent spreadsheet software

Course Curriculum

  • Introduction to Activated Sludge Process
    5 Minutes
  • Process Flow Overview
    5 Minutes
  • Key Components
    5 Minutes

  • Important Terminologies
    9 Minutes
  • Design Parameters Overview
    8 Minutes
  • Food to Microorganism Ratio (F/M)
    8 Minutes

  • F/M Calculation Concept
    4 Minutes
  • Sludge Retention Time (SRT)
    4 Minutes
  • SRT Calculation Concept
    4 Minutes
  • Hydraulic Retention Time (HRT)
    4 Minutes
  • MLSS Calculation
    4 Minutes
  • MLVSS Calculation
    4 Minutes
  • Oxygen Requirement
    4 Minutes
  • Oxygen Demand Calculation
    3 Minutes
  • Sludge Volume Index (SVI)
    3 Minutes
  • Return Sludge Ratio
    3 Minutes
  • Waste Sludge Calculation
    3 Minutes

  • Introduction to Excel
    5 Minutes
  • Excel Sheet Structure
    4 Minutes
  • Excel Formula Basics
    4 Minutes
  • F/M in Excel
    4 Minutes
  • SRT in Excel
    4 Minutes
  • Dashboard Creation
    4 Minutes

  • Case Study
    5 Minutes
  • Practical Considerations
    5 Minutes

  • Summary
    5 Minutes

  • Activated Sludge Calculations with Excel
    5 Minutes

Reviews

—
0 Ratings
5
0
4
0
3
0
2
0
1
0
Course thumbnail
This Course Fee:

2

Course includes:
  • imgLevelintermediate
  • imgDuration120 minutes
  • imgLessons27
  • imgQuizzes0
  • imgCertificationsYes
  • imgEnrolled0
Share this course: