MS Excel Spreadsheet Add-in for Thermodynamic Properties and Process Simulation of R152a

C.O.C. Oko, E.O. Diemuodeke


Microsoft Excel add-in has been developed for the thermodynamic properties of refrigerant DiflouroEthane (R152a) an alternative refrigerant to R134a, which has no Ozone Depletion Potential. Thermodynamic properties’ equations for R152a were formulated from a popular equation of state. The equations were transformed into a computer program in Microsoft Excel-Visual Basic for Application in Integrated Development Environment as an Excel add-in. The add-in is able to compute the thermodynamic properties of R152a refrigerant - specific volume, internal energy, enthalpy, and entropy in the wet, subcooled and superheated-vapor regions. The calculated values are accurate compared to the standard reference properties tables for refrigerants. Computed properties’ data can easily be used in the Excel spreadsheet for process analysis, simulation and design of R152a refrigerating plants. The solution scheme and computer language adopted in this work are easy to apply and use as opposed to the available sophisticated and expensive computer software packages; and the MS Excel add-in presented in this paper would be useful to both practicing engineers and engineering students in the area. An application was illustrated by solving a typical problem in R152a refrigerating process analysis.


Excel add-in; Excel-VBA; Thermodynamic Properties; R152a; Refrigeration.

Full Text:



Arora, C. P. (2000). Refrigeration and Air Conditioning. Tata McGraw-Hill, New Delhi.
Beckman, W and Klein, S. (1996). Engineering Equation Solver (EES) User manual. McGraw Hill, New York.
Dromey, R. G. (1982). How to Solve It by Computer. Prentice Hall International, New York.
Deane A. (2005). Developing Mathematics Creativity with Spreadsheets. Journal of the Korea Society of Mathematical Education, Research in Mathematical Education, 9(3), 187–201.
Deane A., Erich N., & Robert S. S. (2005). Mathematical Modeling and Visualization with Microsoft Excel, KAIST. Retrieved from, 21/06/2006.
Ghodbane, M. (1999). An Investigation of R152a and Hydrocarbon Refrigerants in Mobile Air Conditioning. SAE Technical Paper Series, No. 1999-01-0874.
Huayamave, V. A. (2010). Designing of Energy Efficient Indoor Environments Using a Localized Radial Basis Function Meshless Method. M.Eng thesis, University of Central Florida, Florida.
Internet World Stats (2012). Internet Users, Population and Facebook Statistics for Africa 2012. Retrieved from, 31/01/2013.
Kamei, A., Piao, C. C., Sato, H. and Watanabe, K. (1990). Thermodynamic Charts and Cycle Performance of HCF-134a and HCF-152a, ASHRAE Trans, 96(1), 141-149.
Kreyszig, E. (2005). Advanced Engineering Mathematics, 8th ed. John Willy & Sons Inc, New York.
Liengme, V. B. (2000) A Guide to Microsoft Excel For Scientist and Engineers. Butterworth Heinemann, Woburn.
Oko, C. O. C. & Diemuodeke, E. O. (2010). Analysis of Air-conditioning and Drying Processes Using Spreadsheet Add-in for Psychrometric Data. Journal of Engineering Science and Technology, 3(1), 7–13.
Oko, C. O. C. (2012). Engineering Thermodynamics: An Algorithmic Approach, (2nd ed). University of Port Harcourt Press, Port Harcourt.

Tan, F. L. & Chua, P. S. K. (2003). Java Applet on Computation of Thermodynamic Properties of Steam and R134a refrigerant. Computer Applications in Engineering Education, 11(4), 211 – 225.
Zhang, M. and Muehlbauer, J. (2012). Life Cycle Climate Performance Model for Residential Heat Pump Systems. International Refrigeration and Air Conditioning Conference, July 16-19, Purdue, USA.



  • There are currently no refbacks.


If you have already registered in Journal A and plan to submit article(s) to Journal B, please click the CATEGORIES, or JOURNALS A-Z on the right side of the "HOME".

We only use three mailboxes as follows to deal with issues about paper acceptance, payment and submission of electronic versions of our journals to databases:;;

Copyright © 2010 Canadian Research & Development Centre of Sciences and Cultures
Address: 758, 77e AV, Laval, Quebec, H7V 4A8, Canada

Telephone: 1-514-558 6138
Http:// Http://