CFP last date
20 May 2024
Reseach Article

Excel Add-In Program for Computation of Thermodynamic Properties of R134a and R718 Refrigerants

by Celestine Ebieto Ebieto, Akuro Big-Alabo
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 175 - Number 38
Year of Publication: 2020
Authors: Celestine Ebieto Ebieto, Akuro Big-Alabo
10.5120/ijca2020920936

Celestine Ebieto Ebieto, Akuro Big-Alabo . Excel Add-In Program for Computation of Thermodynamic Properties of R134a and R718 Refrigerants. International Journal of Computer Applications. 175, 38 ( Dec 2020), 9-16. DOI=10.5120/ijca2020920936

@article{ 10.5120/ijca2020920936,
author = { Celestine Ebieto Ebieto, Akuro Big-Alabo },
title = { Excel Add-In Program for Computation of Thermodynamic Properties of R134a and R718 Refrigerants },
journal = { International Journal of Computer Applications },
issue_date = { Dec 2020 },
volume = { 175 },
number = { 38 },
month = { Dec },
year = { 2020 },
issn = { 0975-8887 },
pages = { 9-16 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume175/number38/31699-2020920936/ },
doi = { 10.5120/ijca2020920936 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T00:40:36.248575+05:30
%A Celestine Ebieto Ebieto
%A Akuro Big-Alabo
%T Excel Add-In Program for Computation of Thermodynamic Properties of R134a and R718 Refrigerants
%J International Journal of Computer Applications
%@ 0975-8887
%V 175
%N 38
%P 9-16
%D 2020
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Thermodynamic properties of R134a (1,1,1,2-Tetrafluoroethane) and R718 (water) have been developed as a Microsoft Excel add-in called ThermoAnalysis. The mathematical correlations for the thermodynamic properties of R134a and R718 were formulated from well-known equations of state and used to develop ThermoAnalysis based on a computer program in Microsoft Excel Visual Basic for Application language. ThermoAnalysis provides thermodynamic properties for the saturated regions for R134a and R718 refrigerants, and the subcooled and superheated regions of R718 refrigerant. The calculated values are accurate compared to the standard properties tables for refrigerants. A typical thermo-fluid problem was discussed to illustrate how ThermoAnalysis can be used for practical problem solving. Generated properties’ data can be easily used in the Excel spreadsheet for process analysis, simulation and design of systems that use R134a and R718. ThermoAnalysis is handy for both students and practicing thermo-fluid engineers.

References
  1. Oko, C., Engineering thermodynamics: An algorithmic approach. 2008, University of Port Harcourt Press, Port Harcourt.
  2. Dromey, R.G., How to Solve it by Computer. 1982: Prentice-Hall, Inc.
  3. Taftan, D., Thermo Utilities v3.5, MS Excel Add-ins. 1995.
  4. Lemmon, E.W., M.L. Huber, and M.O. McLinden, NIST reference fluid thermodynamic and transport properties—REFPROP. NIST standard reference database, 2002. 23: p. v7.
  5. Tan, F. and P.S. Chua, Java applet on computation of thermodynamic properties of steam and R134a refrigerant. Computer Applications in Engineering Education, 2003. 11(4): p. 211-225.
  6. Oko, C. and E. Diemuodeke, MS Excel spreadsheet add-in for thermodynamic properties and process simulation of R152a. Energy Science and Technology, 2013. 5(2): p. 63-69.
  7. Arora, R.C., Refrigeration and air conditioning. 2012: PHI Learning Pvt. Ltd.
  8. Refrigerants, D.S., Thermodynamics Properties of HFC 134a. Technical Information.
  9. Wagner, W. and H.-J. Kretzschmar, IAPWS industrial formulation 1997 for the thermodynamic properties of water and steam. International Steam Tables: Properties of Water and Steam Based on the Industrial Formulation IAPWS-IF97, 2008: p. 7-150.
  10. Wagner, W. and A. Pruß, The IAPWS formulation 1995 for the thermodynamic properties of ordinary water substance for general and scientific use. Journal of physical and chemical reference data, 2002. 31(2): p. 387-535.
  11. Douglas, T. and Big-Alabo, A., A generic algorithm of Sustainability (GAS) function for industrial complex steam turbineand utility system optimization. Energy 164, 2018: p. 881-897, Elsevier.
  12. Rogers, G.F.C. and Y.R. Mayhew, Thermodynamic and transport properties of fluids. 1981: Blackwell Oxford.
  13. Lngacademy, Properties of Compressed Liquid Water [online], Website: http://lngacademy.weebly.com/uploads/2/0/8/5/20853058/steam_tables.pdf, retrieved: 23/05/2020.
Index Terms

Computer Science
Information Sciences

Keywords

R134a R718 MS Excel add-in Visual Basic for Application Thermodynamic properties