Functions

To aid in the unit operation calculations, the Excel Unit-Operation Add-In provides a number of functions that you can use. Most of them provide access to thermodynamic property and equilibrium calculations.

Nearly all functions require at least one feed or product port to be connected. The unit operation has access to the thermodynamic system of the simulation environment through the streams connected to the ports. The Excel unit operation assumes that all connected ports serve the same thermodynamic; the thermodynamics system that is used for the calculations corresponds to that of the first connected port.

A quick reference of the available functions is given on the control sheet. Tips to work with functions:

• to get assistence with specifying the arguments to a function, enter the function name followed by the open bracket, and use the Excel formula wizard to guide you through the argument specification:
  
  To start the formula wizard, click the button next to the formula bar.
• Some formulas will return vectors or matrices. All vectors are row vectors. To enter a vector or matrix formula, select the region for the results. Then enter the formula, and complete the formula by pressing Ctrl+Enter
• All vector formulas are returned as row vectors. If you require a column vector, use the Excel formula Transpose.

Function reference

General purpose functions

• capeUnitOperationName
• capeStateOfAggregation

Thermo-dynamic functions

• capeCompoundConstant
• capeTDependentProperty
• capePDependentProperty
• capeSinglePhaseProperty
• capeTwoPhaseProperty
• capeFlash
• capeFlashedFeed
• capeOverallProperty
• capeOverallFeedProperty

Obtaining units-of-measure

• capeCompoundConstantUnit
• capeTDependentPropertyUnit
• capePDependentPropertyUnit
• capeSinglePhasePropertyUnit
• capeTwoPhasePropertyUnit