Results suggested that the MS Excel tool produces satisfactorily fast and reliable results, and can be used confidently for optimization works in environmental studies.
📌 3 Key Takeaways
🎯
Objective & Hypothesis:This paper presents the implementation of an MS Excel tool for parameter optimization in environmental engineering education.
📊
Key Findings & Data:Visual Basic for Applications v7.0 were used for implementation of the program.
💡
Conclusion & Impact:Results suggested that the MS Excel tool produces satisfactorily fast and reliable results, and can be used confidently for optimization works in environmental studies.
This paper presents the implementation of an MS Excel tool for parameter optimization in environmental engineering education. Visual Basic for Applications v7.0 were used for implementation of the program. A number of test cases were also provided to test the performance of the tool including the fields of air pollution control, water treatment, and anaerobic treatment. For each test case, calculated coefficients of determination were 0.98 and above. Results suggested that the MS Excel tool produces satisfactorily fast and reliable results, and can be used confidently for optimization works in environmental studies.
DEMİR, S., KARADENİZ, A., YÖRÜKLÜ, H. C., DEMİR, N. M. (2017). AN MS EXCEL TOOL FOR PARAMETER ESTIMATION BY MULTIVARIATE NONLINEAR REGRESSION IN ENVIRONMENTAL ENGINEERING EDUCATION. Sigma Mühendislik ve Fen Bilimleri Dergisi, Cilt: 35 - Sayı: 2, 265–273. https://ajindex.com/articles/418979
Li X., Huang Z., (2017) An inverted classroom approach to educate MATLAB in chemical process control, Educ. Chem. Eng. 19(1), 1-12
Dehghanimohammadabadi M., Keyser T.K., (2017) Intellegent simulation: Integration of SIMIO and MATLAB to deploy decision support systems to simulation environment, Simul. Modell. Pract. Theory 71(45), 45-60
Ku H., Fulcher R., (2012) Using computer software packages to enhance the teaching in Engineering Management Science – Part 2: Programming Techniques, Comput. Appl. Eng. Educ. 20(1), 114-123
Orosa J.A., Oliveira A.C., (2012) Improvement in quality control for applications used by marine engineers, Comput. Appl. Eng. Educ. 20(1), 187-192
Norton T., Tiwari B., (2013) Aiding the understanding of novel freezing technology through numerical modelling with visual basic for applications (VBA), Comput. Appl. Eng. Educ. 21(3), 530-538
Niazkar M., Afzali S.H., (2016) Streamline performance of Excel in stewise implementation of numerical solutions, Comput. Appl. Eng. Educ. 24(4), 555-566
Orosa Garcia J.A., (2011) Programming Languages for Marine Engineers, Comput. Appl. Eng. Educ. 19(3), 591-597
Fernandes S., Orosa J.A., Galan J.J., (2012) A new methodology to teach numerical methods with MS Excel, J. Mar. Res. 9(2), 29-32
Leon S.B., Ulfig R., Blanchard J., (1998) Teaching the numerical solution of ordinary differential equations using Excel 5.0, Comput. Appl. Eng. Educ. 4(2), 117-125
Ferreira E.C., Salced, R., (2001) Can spreadhseet solvers solve demanding optimization problems?, Comput. Appl. Eng. Educ. 9(1), 49-56
Rivas A., Gomez-Acebo T., Ramos J.C., (2006) The application of spreadsheets to the analysis and optimization of systems and processes in the teaching of hydraulic and thermal engineering, Comput. Appl. Eng. Educ. 14(4): 256-268
Demir S., Yetilmezsoy K., Manav N., (2008) Development of a modified Hardy-Cross algorithm for time-dependent simulations of water distribution networks, Fresen. Environ. Bull. 17(8a), 1045-1053
Orosa Garcia J.A., (2009) Programming languages for marine engineers, Comput. Appl. Eng. Educ. 19(3), 591-597
Orosa J.A., Oliveira A.C., (2009) Improvement in Quality control for applications used by marine engineers, Comput. Appl. Eng. Educ. 20(1), 187-192
Demir S., Saral A., Ertürk F., Kuzu L., (2010) Combined use of principal component analysis (PCA) and chemical mass balance (CMB) for source identification and source apporti