Asee peer logo

Excel In Me: Extending And Refining Ubiquitous Software Tools

Download Paper |


2009 Annual Conference & Exposition


Austin, Texas

Publication Date

June 14, 2009

Start Date

June 14, 2009

End Date

June 17, 2009



Conference Session

Thermodynamics, Fluids, and Heat Transfer I

Tagged Division

Mechanical Engineering

Page Count


Page Numbers

14.600.1 - 14.600.21



Permanent URL

Download Count


Request a correction

Paper Authors

author page

Kenny Mahan University of Alabama

author page

Jesse Huguet University of Alabama

author page

Joseph Chappell University of Alabama

author page

Keith Woodbury University of Alabama

author page

Robert Taylor University of Alabama

Download Paper |

NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

Excel in ME: Extending and Refining Ubiquitous Software Tools (Excel Modules for Thermodynamic Properties of Refrigerants R134a and R22 and Compressible Ideal Gas Flow)

Abstract Microsoft Excel is a ubiquitous software tool that provides an excellent electronic format for engineering computation and organization of information. This paper reports on the second year of an NSF CCLI Phase I project to implement a sequence of Excel modules for use in the Thermal Mechanical Engineering Curriculum.

A collection of Excel Add-ins has been developed for use in solving thermodynamics problems. This paper reports on development of three Add-ins to compute properties of refrigerants R134 and R22 and to compute gas dynamics relations for isentropic, Fanno, and Rayleigh flows of ideal gases. All of the Excel Add-ins developed can be downloaded at the project website

Intro Under a National Science Foundation (NSF) Curriculum, Classroom, and Laboratory Improvement (CCLI) grant a number of software modules have been developed to facilitate engineering analysis in a computational spreadsheet. The ubiquitous spreadsheet of choice is Microsoft Excel.

In an earlier paper by Chappell, et al. (2008), a Microsoft Excel module called XSteam, developed by Magnus Holmgren (Holmgren 2007), was adapted and extended to compute thermodynamic properties of steam/water from a wide range of input properties. After the successful implementation of these expanded steam Excel modules in the classroom, attention was turned toward adding capability for other substances, in particular the refrigerants R134a and R22. This paper addresses the implementation and testing process of modules to calculate the thermodynamic properties of R134a and R22.

Another topic of interest in thermodynamics is compressible flow of ideal gases. An Excel module has been developed to compute basic functions for this area, including isentropic flow, normal shock, Fanno Flow, and Rayleigh Flow. This paper will also present a summary of this development.

Mahan, K., & Huguet, J., & Chappell, J., & Woodbury, K., & Taylor, R. (2009, June), Excel In Me: Extending And Refining Ubiquitous Software Tools Paper presented at 2009 Annual Conference & Exposition, Austin, Texas. 10.18260/1-2--5780

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2009 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015