Browse > Article
http://dx.doi.org/10.11001/jksww.2014.28.6.735

Modelling of effluent and GHGs for wastewater treatment plants using by MS Excel simulator(PKES)  

Bin, Jung-In (Department of Environmental Engineering, Pukyong National University)
Lee, Byung-Hun (Department of Environmental Engineering, Pukyong National University)
Publication Information
Journal of Korean Society of Water and Wastewater / v.28, no.6, 2014 , pp. 735-745 More about this Journal
Abstract
This paper presents PKES(PuKyung -Excel based Simulator) for WWTPs(wastewater treatment plants) by using MS Excel and VBA(Visual Basic for Application). PKES is a user-friendly simulator for the design and optimization of the whole plant including biological and physico-chemical processes for the wastewater and sludge treatment. PKES calculates the performance under steady or dynamic state and allows changing the mathematical model by the user. Mathematical model implemented in PKES is a improved integration model based on ASM2d and ADM1 for simulation of AS(activated sludge) and AD(anaerobic digestion). Gaseous components of $N_2$, $N_2O$, $CO_2$ and $CH_4$ are added for estimation of GHGs(greenhouse gases) emission. The simulation results for comparison between PKES and Aquasim(EAWAG) showed about the same effluent concentrations. As a result of verification using by measured data of BOD, TSS, TN and TP for 2 years of operation, calculated effluent concentrations were similar to measured effluent concentrations. The values of average RMSE(root mean square error) were 1.9, 0.8, 1.6 and 0.2 mg/L for BOD, TSS, TN and TP, respectively. Total GHGs emission of WWTP calculated by PKES was 138.5 ton-$CO_2$/day and GHGs emissions of $N_2O$, $CO_2$ and $CH_4$ were calculated at 21.7, 28.9 and 87.9 ton-$CO_2$/day, respectively. GHGs emission of activated sludge was 32.5 % and that of anaerobic digestion was 67.5 %.
Keywords
PKES; MS Excel; simulator; WWTP; GHGs;
Citations & Related Records
Times Cited By KSCI : 4  (Citation Analysis)
연도 인용수 순위
1 Oh, T. S., Kim, M. J., Lim, J. J., Kim, Y. S., and Yoo, C. K. (2011) Estimate and Environmental Assessment of Greenhouse Gas(GHG) Emissions and Sludge Emissions in Wastewater Treatment Processes for Climate Change, Korean Chemical Engineering Research, 19(2), pp.187-194.
2 Rieger, L., Koch, G., Kuhni, M., Gujer, W., and Siegrist, H. (2001), "The EAWAG Bio-P Module for Activated Sludge Model No.3," Water Research, 35, p.3887-3903.   DOI   ScienceOn
3 Ruano, M. V., Serralta, J., Ribes, J., Garcia-Usach, F., Bouzas, A., Barat, R., Seco, A. and Ferrer, J. (2012) Application of the General Model 'Biological Nutrient Removal Model No. 1' to Upgrade Two Fullscale WWTPs, Environmental Technology, 33(9), pp.1005-1012.   DOI   ScienceOn
4 Shahabadi, M. B., Yerushalmi, L., and Haghighat, F. (2010) Estimation of Greenhouse Gas Generation in Wastewater Treatment Plants -Model Development and Application, Chemosphere, 78, pp.1085-1092.   DOI   ScienceOn
5 Shin, K. S. (2006) Evaluation Methodology of Mass Balance Analysis for Wastewater Treatment Plants, Master's thesis, Donkuk University, Seoul.
6 Snowling, S., Monteith, H., Schraa, O., and Andres, H. (2006) Modeling Greenhouse Gas Emissions from Activated Sludge Processes, The Water Environment Federation's 79th Annual Technical Exhibition & Conference (WEFTEC.06), pp.7206-7212.
7 Van Hullea, S. W. H., Callensa, J., Mampaeyb, K. E., van Loosdrechtc M. C. M., and Volckeb, E. I. P. (2012) $N_2O$ and NO Emissions during Autotrophic Nitrogen Removal in a Granular Sludge Reactor -a Simulation Study, Environmental Technology, 33(20), pp.2281-2290.   DOI   ScienceOn
8 Batstone, D. J., Keller, J., Angelidaki, I., Kalyuzhnyi, S. V., Pavlostathis, S. G., Rozzi, A., Sanders, W. T. M., Siegrist, H., and Vavilin, V. A. (2002) Anaerobic Digestion Model No.1 ( ADM1), IWA Scientific and Technical Report No. 13, IWA Publishing, London.
9 Christoulas, D. G., Yannakopoulos, P. H., and Andreadakis, A. D. (1998) An Empirical Model for Primary Sedimentation of Sewage, Environment International, 24(8), pp.925-934.   DOI   ScienceOn
10 GRI (2010) Application of Watershed Model in Total Maximum Daily Load, Gyeonggi Research Institute(GRI), Suwon.
11 Han, K. Y., Kim, J. S., Choi, H. G., and Kim, D. I. (2005) Analysis of Urban Inundation using Excel-VBA, Korean Society Civil Engineers Annual Conference, pp.2652-2655.
12 Henze, M., Gujer, W., Mino, T., and van Loosdrecht M. V. (2000) Activated sludge models: ASM1, ASM2, ASM2d and ASM3, IWA Scientific and Technical Report No.9, IWA Publishing, London.
13 IPCC ( 2006) Guideline for National Greenhouse Gas Inventories, The Institute for Global Environmental Strategies (IGES), Hayama.
14 Jung, C. W. (2013) Plant-wide model(Pukyong plant-wide model No.1) for Wastewater Treatment Plants, Ph. D. thesis, Pukyong National University, Busan.
15 KEI (2011) A Study on the Improvement of Energy Management for Wastewater Utilities, Korea Environment Institute(KEI), Seoul.
16 Lee, E. M. (2011) Mass Balance-based Model for the Emission of Greenhouse Gas from Biological Wastewater Treatment Process, Master's thesis, Pukyong National University, Busan.
17 Kim, S. H., Lee, D. W., and Kim, D. H. (2012) Performance Evaluation of Hybrid SBR Aerobic Digestion Combined with Ultrasonication by Using a Mathematical Model, Journal of Korean Society of Water and Wastewater, 26(6), pp.897-905.   과학기술학회마을   DOI   ScienceOn
18 Kim, Y. J., Lee, J. Y. and Kang, Y. T. (2010) Study on Energy Independence Plan for Sewage Treatment Plant, Korean Journal of Air-Conditioning and Refrigeration Engineering, 22(1), pp.49-55.   과학기술학회마을
19 KIWE (2006) Development of Advanced Treatment Process for Biosolids Reduction and Self-diagnosis and Management System in Sewage Treatment Plan, Korea Institute of Water and Environment(KIWE), Daejeon.
20 Lee, W. Y., Kim, M. H., Kim, Y. W., Lee, I. B., and Yoo, C. K. (2008) Sensitivity Analysis and Parameter Estimation of Activated Sludge Model Using Weighted Effluent Quality Index, J. of Institute of Control, Robotics and Systems, 14(11), pp.1174-1179.   과학기술학회마을   DOI   ScienceOn
21 Metcalf & Eddy Inc. (2003), Wastewater Engineering Treatment Disposal and Reuse, 4th edition, revised by George Tchobanoglous, McGraw-Hill Inc., New York.
22 O, W. K., Choo, Y. Y., Jung., Y. M., Kim, K. K., and Jin, B. B. (2009) Estimating the Greenhouse Gases Emission Rates and Their Emission Factors of a Wastewater Treatment Plant with an MLE Process, J. of the Korean Society for Environmental Analysis, 12(2), pp.87-95.