# Calculating Thermochemical Properties Using The 7 Term NASA Polynomials

October 28, 2013

### Introduction

The knowledge of thermochemical properties, such as heat capacity, enthalpy and entropy is quite important when solving combustion-related problems. At 1961 Frank Zeleznik and Sanford Gordon invented a method for performing a simultaneous regression of the thermochemical properties in order to approximate more than one property with a single polynomial. They ended up with the famous NASA 7 term polynomials first published by Zeleznik and Gordon (1962) and McBride et al. (1963).

The NASA polynomials have been evolved for more than 50 years and they are widely accepted and extensively used in various applications. The polynomials are usually provided in large databases. One of these databases is the free database named Prof. Burcat’s Thermodynamic Data, which contains polynomial coefficients for more than 1300 species. One major problem with this database is that is provided in a text file, which is quite uncomfortable for calculating purposes. In order to overcome this difficulty, I decided to develop this workbook, so as to automate the procedure of calculating thermochemical properties from Burcat’s database.

### Polynomial functions

The heat capacity, enthalpy, entropy and Gibbs free energy are calculated using the following polynomial functions:

It should be noted that the value HT obtained from the polynomials is the “engineering enthalpy” defined as:

The 7 term polynomials actually include 15 constants. The first set of 7 constants belong to the 200 – 1000 K polynomial, the second set of 7 constants belong to the 1000 – 6000 K polynomial and the fifteenth constant is H298/R ≡ ΔfH298/R.

### How to use it

The usage of the workbook is quite straightforward. After enabling macros just select the specie from the dropdown list and press the Get Properties button. After a few seconds, all the NASA coefficients are loaded from the database (sheet Data). Then you can enter the desired temperature and the workbook will calculate the thermochemical properties using the polynomial functions described above. Note that on the second page of the workbook there are 3 charts that represent the thermochemical properties as a function of temperature for the range 298 – 6000 K.

All the raw data used in this workbook came from the Extended Third Millennium Thermodynamic Database for Combustion and Air-Pollution Use with updates from Active Thermochemical Tables. The database initiated and built since 1972 by Alexander Burcat, Aerospace Engineering, Technion-IIT, Haifa, Israel.

As prof. Burcat states: “This database is provided free of charge for non-commercial use, on condition that proper quotation will be included in the pertinent publications. It is strictly forbidden to include this database as is or parts of it in any commercial database, software, firmware or hardware and any other type of commercial use without written permission from the authors”.

http://garfield.chem.elte.hu/Burcat/burcat.html

The file can be opened with Excel 2007 or newer. Please enable macros before using it.

Category: Useful Stuff

### Christos Samaras

Hi, I am Christos, a Mechanical Engineer by profession (Ph.D.) and a Software Developer by obsession (10+ years of experience)! I founded this site back in 2011 intending to provide solutions to various engineering and programming problems.

• That’s strange.

The workbook was developed in Excel 2013.
I tested a few weeks ago, without a problem.
It also works fine on Office 365.
Try it on a different computer.

Best Regards,
Christos

• 3175379 says:

Dear Sir I have downloaded this file 4 times now, and all with the same end result. Error 191080_01 Lost Visual Basic Project. I am using Excel 2013 so it should be ok. Please advise

• Hi,

I downloaded and tested the Excel file, and the macros seems to work just fine.
Which version of Excel do you have?

Best Regards,
Christos

• student says:

macros not working