Props.xlsx has a lot of data, but usually we are only interested in a few components at a time. Adding a few lines at the top and applying the VLookup function makes it easy to tabulate the properties you need. (8min, uakron.edu)

Comprehension questions

1. Download the latest version of Props.xlsx from sourceforge. Add lines to support 8 components of interest and cells to compute Psat given T as input and Tsat given P as input by appropriately arranging Eqn. 2.47. Add a column for computing Hvap at Tsat for each component by Eqn. 2.45.

2. Insert a sheet(tab) called Hrxn in Props.xlsx. Types the names for components in the reaction CO+0.5O2=CO2. Use VLookup to tabulate the Hf values for each component. To the left of the name column, insert cells to represent the stoichiometric coefficients. Then calculate the heat of reaction by using the sumproduct() function applied to the stoichiometric coefficients and Hf values. Check your result with a hand calculation.

3. Download the latest versions of PREOS.xls and Props.xlsx from sourceforge. Update the Props tab appropriately. Then implement the VLookup function on the ThermoProps tab of PREOS so all you need to do is type the name of the compound of interest in order to update the ThermoProps sheet to all properties of interest. We discuss how to use PREOS.xls to solve problems in Unit II.

Use VLookup and Eqn. 2.47 to tabulate shortcut estimates of Antoine coefficients. (5min, uakron.edu) By calculating these in a distinct location, then referencing those estimates in the cells that will actually be used for later calculations, you can type in precise estimates when you have them. When no precise values are available, recover the shortcut estimates by simply typing "=" and referencing the cell with the shortcut estimate.

## Comments

Elliott replied on Permalink

## Using Excel's VLookup To Quickly Tabulate Properties

Props.xlsx has a lot of data, but usually we are only interested in a few components at a time. Adding a few lines at the top and applying the VLookup function makes it easy to tabulate the properties you need. (8min, uakron.edu)

Comprehension questions

1. Download the latest version of Props.xlsx from sourceforge. Add lines to support 8 components of interest and cells to compute Psat given T as input and Tsat given P as input by appropriately arranging Eqn. 2.47. Add a column for computing Hvap at Tsat for each component by Eqn. 2.45.

2. Insert a sheet(tab) called Hrxn in Props.xlsx. Types the names for components in the reaction CO+0.5O2=CO2. Use VLookup to tabulate the Hf values for each component. To the left of the name column, insert cells to represent the stoichiometric coefficients. Then calculate the heat of reaction by using the sumproduct() function applied to the stoichiometric coefficients and Hf values. Check your result with a hand calculation.

3. Download the latest versions of PREOS.xls and Props.xlsx from sourceforge. Update the Props tab appropriately. Then implement the VLookup function on the ThermoProps tab of PREOS so all you need to do is type the name of the compound of interest in order to update the ThermoProps sheet to all properties of interest. We discuss how to use PREOS.xls to solve problems in Unit II.

Elliott replied on Permalink

## Shortcut Estimation of Antoine Coefficients

Use VLookup and Eqn. 2.47 to tabulate shortcut estimates of Antoine coefficients. (5min, uakron.edu) By calculating these in a distinct location, then referencing those estimates in the cells that will actually be used for later calculations, you can type in precise estimates when you have them. When no precise values are available, recover the shortcut estimates by simply typing "=" and referencing the cell with the shortcut estimate.