Implementation of an Microsoft (MS) Excel add‐in, called bioXL3, is presented in this paper. bioXL3 is an educational tool for undergraduate‐ and graduate‐level education in the environmental engineering field. The add‐in is an open‐source tool and is used for the simulation of conventional biological wastewater treatment plants based on Activated Sludge Model No. 3. The software is developed using visual basic for applications (VBA) in MS Excel and is tested with a number of sample model setups. All formulations used in VBA programming are provided here. Also, simulation results of a sample predenitrification system are summarized. The performance of the software in engineering education was tested by a teaching session. Results indicated that the add‐in can prove useful in undergraduate and graduate‐level education in environmental engineering.

中文翻译：

---

将活性污泥模型 3 用作教育工具：bioXL3

本文介绍了名为 bioXL3 的 Microsoft (MS) Excel 插件的实现。bioXL3 是环境工程领域本科和研究生教育的教育工具。该插件是一个开源工具，用于模拟基于 Activated Sludge Model No. 3 的传统生物污水处理厂。该软件是使用 Visual Basic for Applications (VBA) 在 MS Excel 中开发的，并使用许多示例模型设置。此处提供了 VBA 编程中使用的所有公式。此外，还总结了样品预反硝化系统的模拟结果。该软件在工程教育中的性能通过教学环节进行了测试。结果表明，该插件可用于环境工程的本科和研究生教育。