Solution Display Script

Revision Date: 06-Dec-2004 - No changes for 2004
Revision Date: 07-Sep-2004 - Updated for 12.1
Creation Date: 15-Aug-2000 03:23PM

Applicable Version(s)

Aspen Properties 10.2 and higher

Problem Statement

How is the Aspen Properties Excel Calculator used?

Solution:

The Aspen Properties Excel calculator provides rigorous physical properties as Excel built-in functions. These functions are easy-to-use, can be integrated in spreadsheet calculations, and provide full access to all the property methods and models available in Aspen Properties. You can use these functions to calculate physical properties of pure components and mixtures, as well as to perform phase equilibrium calculations.

To use the Aspen Properties Excel Calculator:

1. Add the Aspen Properties Excel Calculator to Excel menu:

A. Open Microsoft Excel.

B. Go to the Tools menu and select Add-ins. The Add-ins dialog box appears.

C. Click on the Browse button, go to the \Aspen Properties\Engine\xeq directory where the Aspen Properties calculation engine was installed (e.g., C:\Program Files\AspenTech\Aspen Properties\Engine\xeq), select the "Aspen Properties.xla" file.

A new menu item "Aspen Properties" will appear on the main menu bar of Microsoft Excel. (If you installed Aspen Properties with the Lite Client option, in step (C), you need to locate the Aspen Properties.xla file in the \Engine\xeq directory on the file server. You must respond No, when asked whether or not to copy the Excel Add-In file to your local drive.)

2. Run the examples delivered with installation. These example files (with extension aprbkp) are stored in \Aspen Properties\GUI\xmp\ directory. Let us take "drex1.aprbkp" for the exercise.

A. Copy drex1.aprbkp to a new directory C:\temp\..

B. In Excel, place your prompt at Cell A1, go to Aspen Properties\Select Properties Package, select Aspen Properties. Browse to C:\temp directory and open drex1.aprbkp. The path and file name will display in Cell A1.

C. Move to Cell A2, from Aspen Properties click "Select Components". Select H2O and click OK. H2O displays in Cell A2.

D. Move to Cell B2, from Aspen Properties click "Select Properties". Select VaporPressure and click OK. VaporPressure displays in Cell B2.

E. Move to Cell C2, from Aspen Properties click "Select Property Methods". Select STEAM-TA and click OK. Steam-TA displays in Cell C2.

F. Move to Cell A3, click the "Paste Function" button "fx" on the menu bar. Under Function Category click Aspen Properties, under Function Name click VaporPressure. Click OK, an input window pops up. Enter A2 at ComponentList and 373 at Temperature (water at 373 K). Click OK. The calculated pressure of "100605.3297" in N/m^2 displays in Cell A3.

For multiple components and multiple properties, a table can be arranged by the user. The above procedures can also be followed to open an Cape-Open property packages.

For more information see the Aspen Properties User Guide, Chapter 21, Aspen Properties Excel Calculator.

KeyWords

Aspen Properties
Excel calculator
calculator
Cape-Open.

How is the Aspen Properties Excel Calculator used?
Solution ID:		103634
Product(s):		Aspen Properties
Primary subject:		Overall Application
Converted from "103634_Default.txt" Revision Date: 06-Dec-2004 - No changes for 2004 Revision Date: 07-Sep-2004 - Updated for 12.1 Creation Date: 15-Aug-2000 03:23PM Applicable Version(s) Aspen Properties 10.2 and higher Problem Statement How is the Aspen Properties Excel Calculator used? Solution: The Aspen Properties Excel calculator provides rigorous physical properties as Excel built-in functions. These functions are easy-to-use, can be integrated in spreadsheet calculations, and provide full access to all the property methods and models available in Aspen Properties. You can use these functions to calculate physical properties of pure components and mixtures, as well as to perform phase equilibrium calculations. To use the Aspen Properties Excel Calculator: 1. Add the Aspen Properties Excel Calculator to Excel menu: A. Open Microsoft Excel. B. Go to the Tools menu and select Add-ins. The Add-ins dialog box appears. C. Click on the Browse button, go to the \Aspen Properties\Engine\xeq directory where the Aspen Properties calculation engine was installed (e.g., C:\Program Files\AspenTech\Aspen Properties\Engine\xeq), select the "Aspen Properties.xla" file. A new menu item "Aspen Properties" will appear on the main menu bar of Microsoft Excel. (If you installed Aspen Properties with the Lite Client option, in step (C), you need to locate the Aspen Properties.xla file in the \Engine\xeq directory on the file server. You must respond No, when asked whether or not to copy the Excel Add-In file to your local drive.) 2. Run the examples delivered with installation. These example files (with extension aprbkp) are stored in \Aspen Properties\GUI\xmp\ directory. Let us take "drex1.aprbkp" for the exercise. A. Copy drex1.aprbkp to a new directory C:\temp\.. B. In Excel, place your prompt at Cell A1, go to Aspen Properties\Select Properties Package, select Aspen Properties. Browse to C:\temp directory and open drex1.aprbkp. The path and file name will display in Cell A1. C. Move to Cell A2, from Aspen Properties click "Select Components". Select H2O and click OK. H2O displays in Cell A2. D. Move to Cell B2, from Aspen Properties click "Select Properties". Select VaporPressure and click OK. VaporPressure displays in Cell B2. E. Move to Cell C2, from Aspen Properties click "Select Property Methods". Select STEAM-TA and click OK. Steam-TA displays in Cell C2. F. Move to Cell A3, click the "Paste Function" button "fx" on the menu bar. Under Function Category click Aspen Properties, under Function Name click VaporPressure. Click OK, an input window pops up. Enter A2 at ComponentList and 373 at Temperature (water at 373 K). Click OK. The calculated pressure of "100605.3297" in N/m^2 displays in Cell A3. For multiple components and multiple properties, a table can be arranged by the user. The above procedures can also be followed to open an Cape-Open property packages. For more information see the Aspen Properties User Guide, Chapter 21, Aspen Properties Excel Calculator. KeyWords Aspen Properties Excel calculator calculator Cape-Open.