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.
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.
Learning Spreadsheet Tools: The Case of Temperature Dependent Molar Heat Capacity and Change in Molar Enthalpy,
Spreadsheets in Education (eJSiE):
3, Article 6.
Available at: https://epublications.bond.edu.au/ejsie/vol10/iss3/6