|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sewage-treatment-plant-design-by-using-excel-sheets/
课程评论：没有评论
**课程名称：** 使用Excel表格设计污水处理厂 **课程概述：** 本课程将教授一种简单实用的污水处理厂设计方法，帮助您熟练运用Excel表格完成污水预处理单元（如进水渠、格栅渠、沉砂池、巴歇尔氏流量槽）和二级处理单元（稳定塘，包括厌氧塘、兼性塘和成熟塘）的设计。此外，课程还将涵盖污泥干化床的设计，并通过控制输入数据来提高处理厂的运行效率。 您将学会如何利用Excel表格的公式关联性，在输入不同的人口和污水流量数据时，自动更新设计计算结果，从而实现高效、灵活的设计。课程将提供现成的Excel设计表格，您只需输入项目参数即可获得设计结果，并能根据表格中的标准范围进行校核。 **课程内容（按章节划分）：** * **第一章：污水处理概论** * 污水处理的目的、类型和阶段。 * 污水处理厂各预处理单元和二级处理单元的功能介绍。 * **第二章：人口与流量预测** * 项目不同阶段的人口及污水流量预测。 * 项目设计期的人口及污水流量预测。 * **第三章：预处理单元设计** * 进水渠设计。 * 格栅渠设计。 * 沉砂池设计。 * 巴歇尔氏流量槽设计。 * **第四章：二级处理单元设计** * 稳定塘设计，包括厌氧塘、兼性塘和成熟塘的设计。 * 污泥干化床设计。 * 通过控制输入数据提高处理厂效率的方法。 * **第五章：设计实例** * 使用Excel表格设计高人口密度和高污水流量的污水处理厂实例。 **核心教学工具：** Excel表格。Excel表格在设计中的应用能够极大地简化计算过程，因为单元格之间的关联通过公式实现，改变任何一个输入值，都能自动更新所有设计计算结果。您可以使用提供的Excel设计表格，通过输入自己项目的具体人口或污水流量数值，快速得到设计结果，并需对照表格内的标准范围进行核查。
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.
