Related Resources: excel calculators

Air-Water Properties Excel Calculators


  • Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
  • This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
  • Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

Engineering and Physics Excel Spreadsheet Calculators

Five state and transport properties of air and seven of water, all of which are functions of temperature, are included in this module. These user-defined functions may be invoked in a worksheet exactly as are the supplied functions (sine, cosine, sum, etc.) and allow the design engineer to do multiple calculations readily without cumbersome table lookups. These functions were developed for use in the Sweaty Runner and Lister Bag projects. A discussion of the former project assignment may be found in: Ribando, R.J. and Galbis-Reig, V., "Convective Heat and Mass Transfer from a Runner Using Some Modern Spreadsheet Features," Computers in Education Journal, Vol. VIII, No. 4, Oct. - Dec. 1998, pp. 22-28.

As with all items in the HTT software collection, the user is urged to verify the accuracy of these property functions before using them.


Download: Air-Water Properties Calculator