하수처리 통합 모델 적용을 위한 MS Excel 시뮬레이터

Abstract

Biological nutrient removal (BNR) needs to avoid eutrophication in the aquatic environment. Biological wastewater treatments are complex systems in which a range of physical, chemical and biological processes occur. Mathematical models are needed for a quantitative evaluation of these processes. These models have been shown to be useful tools for research, development and optimization of wastewater treatment processes. Mathematical models are very complex and they are incorporated in commercial simulation packages called simulators such as BioWin, GPS-X, WEST AQUASIM and EFOR. This study presents a user-friendly simulator by using MS Excel and VBA and able to design, upgrade, simulate and optimize wastewater treatment plants. The simulator is called PKES(PuKyung national university - Excel based Simulator for WWTP). The mathematical model implemented is the modified ASM2d, ASM3+BioP and ADM1 for simulation of whole treatment plants and GHGs emission(CO2, CH4 and N2O). PKES calculates the performance under steady or dynamic state of whole treatment plants including primary settler, activated sludge systems for biological organic matter and nutrient removal, secondary settlers, gravity thickeners, anaerobic digester and dewatering. So PKES can estimated the effect of side-streams on nutrient removal efficiency. PKES include of database for various wastewater treatment processes, model matrixes and parameters. PKES was verified by comparing with Aquasim and measured data of wastewater treatment plant. Simulations for removal efficiency and GHGs emission with different design and operation parameters and BNR processes using by PKES was successfully conducted. Key word: PKES, BNR, WWTP, MS Excel, simulator, mathematical model.