This paper presents a simple spread sheet tool to calculate a temperature dependent molar heat capacity and change in molar enthalpy from one temperature to another. It assumes a polynomial relationship between temperature and molar heat capacity and tabulates necessary data for seventy compounds. While being a great tool for simple energy balances, the paper provides a detailed step by step account of how the spreadsheet was made using Microsoft Excel®. It pays special attention to features utilized in the creation, including, FREEZE PANE, creating a list from tabulated data, VLOOKUP, IF and AND statements, conditional formatting, and locking cells.

Distribution License

Creative Commons License
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.

Enthalpy_Cp Calculator_Final.xlsx (25 kB)
Specific Heat Capacity and Enthalpy Calculator