A SOLVER-TOPSIS TECHNIQUE FOR MULTI-OBJECTIVE OPTIMIZATION OF INNOVATIVE MULTI-STAGE VCR SYSTEMS BY USING MICROSOFT EXCEL

Mohamed M. El-Awad

doi:10.66411/jer.v38i.66

Authors

Mohamed M. El-Awad Independent researcher, Omdurman, Sudan Author

DOI:

https://doi.org/10.66411/jer.v38i.66

Keywords:

Multi-Stage VCR Systems, Multi-Objective Optimisation, TOPSIS, Excel

Abstract

This paper describes a method for multi-objective optimisation analyses of multi-stage vapour-compression refrigeration (VCR) systems by utilising the single-objective solver of Microsoft Excel and the TOPSIS decision-making method. the paper illustrates the Solver-TOPSIS method by analysing an innovative two-stage VCR system that adds a heat-recovery intercooler to the conventional system after the first-stage compressor. the Excel-aided model developed for the system calculates its coefficient of performance (COP), exergetic efficiency, total cost rate, and total equivalent warming impact (TEWI). Four design parameters are treated as variables which are the evaporator and condenser temperatures, the isentropic efficiency of the compressor, and the flow rate of the cooling water. Comparing the values of the four performance indicators as optimised by the proposed method with those optimised by the MIDACO solver shows that the method yields higher values of the system’s COP and exergetic efficiency and lower TEWI at the expense of slightly increasing the total cost rate. the total rate of exergy destruction in the system optimised by excel method is also lower than in the one optimised by MIDACO

231 128

References

[1] Mahadzir, S. and Ahmed, R. 2021. Parametric Optimization of a Two Stage Vapor Compression Refrigeration System by Comparative Evolutionary Techniques, E3S Web of Conferences 287, 03002 (2021), ICPEAM2020, https://doi.org/10.1051/e3sconf/202128703002 DOI: https://doi.org/10.1051/e3sconf/202128703002

[2] Ahmed, R., Mahadzir, S., Mota-Babiloni, A., Al-Amin, M., Usmani, A.Y., Ashraf Rana, Z., et al. 2023. 4E analysis of a two-stage refrigeration system through surrogate models based on response surface methods and hybrid grey wolf optimizer. PLoS ONE 18(2): e0272160. https://doi.org/10.1371/journal.pone.0272160 DOI: https://doi.org/10.1371/journal.pone.0272160

[3] Goetzler, W., Zogg, R., Young, J., and Johnson, C. 2014. Alternatives to Vapor-Compression HVAC Technology, ASHRAE Journal ashrae.org, October 2014

[4] Roy, R., and Mandal, B.K. 2019. Thermo-economic Assessment and multi-objective optimization of vapour compression refrigeration system using low GWP refrigerants, 8th International Conference on Modeling Simulation and Applied Optimization (ICMSAO) DOI: https://doi.org/10.1109/ICMSAO.2019.8880390

[5] Diyaley, S., Shilal, P.I., Shivakoti, L., Ghadai. R.K., and Kalita, K. 2017. PSI and TOPSIS Based Selection of Process Parameters in WEDM, Periodica Polytechnica. Engineering. Mechanical Engineering, vol. 61. 255-260 DOI: https://doi.org/10.3311/PPme.10431

[6] Aminyavari, M., Najafi, B., Shirazi, A., Rinaldi, F. 2014. Exergetic, Economic and environmental (3E) analyses, and multi-objective optimization of a CO2/NH3 cascade refrigeration systems, Applied Thermal Engineering, 65: 42 – 50 DOI: https://doi.org/10.1016/j.applthermaleng.2013.12.075

[7] Lemmon, E., McLinden, M., Huber, M., 2004, NIST Fluid Thermodynamic and Transport Properties-REFPROP, Version 7.0 User's Guide.

[8] Singh, K.K., Kumar, R., & Gupta, A. 2023. Multi-objective optimization of an ammonia-based multi-stage vapor compression refrigeration system with flash intercooler cum subcooler, International Journal of Energy for a Clean Environment 24(3):1–14 DOI: https://doi.org/10.1615/InterJEnerCleanEnv.2022038969

[9] Schlueter, M., Rueckmann, J., Gerdts, M. 2012. A Numerical Study of MIDACO on 100 MINLP Benchmarks, Optimization: A Journal of Mathematical Programming and Operations Research, 61,2012,7, 873-900. DOI: https://doi.org/10.1080/02331934.2012.668545

[10] Balabanov, T. 2021, Solving multi-objective problems by means of single objective solver, Problems of engineering cybernetics and robotics • Vol. 76, pp. 63-70 https://doi.org/10.7546/PECR.76.21.05 DOI: https://doi.org/10.7546/PECR.76.21.05

[11] El-Awad, M.M. 2024. Multi-objective optimisation of VCR systems by applying TOPSIS to the single-objective solutions obtained with Excel Solver, paper accepted by the electronic Journal of Spreadsheets in Education (eJSiE), April 2024 DOI: https://doi.org/10.31224/3667

[12] Anjum, A., Gupta, M., Ansari N.A., and Mishra, R.S. 2017. Thermodynamic Analysis of a Two Stage Vapour Compression Refrigeration System Utilizing the Waste Heat of the Intercooler for Water Heating, J Fundam. Renewable Energy Appl. 2017, 1-6 DOI: https://doi.org/10.4172/2090-4541.1000232

[13] Grid Electricity Emissions Factors v0.1 – February 2023, Carbon footprint country specific electricity grid greenhouse gas emission factors, https://www.carbonfootprint.com/docs/2023_02_emissions_factors_sources_for_2022_electricity_v10.pdf

[14] Wang, J., Zhai, Z.J., Jing. Y., and Zhang, C. 2010. Particle swarm optimization for redundant building cooling heating and power system, Appl. Energy, vol. 87, 3668-3679 DOI: https://doi.org/10.1016/j.apenergy.2010.06.021

[15] AIRAH, 2012. Methods of Calculating Total Equivalent Warming Impact (TEWI), Best Practice Guidelines. The Australian Institute of Refrigeration, Air Conditioning and Heating

[16] El-Awad, M.M., Al Nabhani, M.S., Al Hinai, K.S., Younis, A. 2019. Development and Validation of an Excel Add-In for Determining the Properties of Various Refrigerants, Proceedings of First National Conference on Recent Trends in Applied Science, Engineering and Technology (CASET 2K19), Ipri College of Technology, June 11, 2019.

[17] Roy, R., and Mandal, B.K. 2019. Thermo-economic analysis and multi-objective optimization of vapour cascade refrigeration system using different refrigerant combination, Journal of Thermal Analysis and Calorimetry, https://doi.org/10.1007/s10973-019-08710-x DOI: https://doi.org/10.1007/s10973-019-08710-x

[18] Dataharnessing.com, TOPSIS in Excel with Example, https://www.dataharnessing.com/multi-criteria-decision-making/topsis-tutorial/ , accessed 11/12/2023