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 physical and thermodynamic property calculations and phase 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:

most functions can be inserted using a button on the Unit Operation ribbon:
to get assistance with specifying or modifying 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.
all inputs and outputs are in pure SI units and molar basis. Temperatures are in K, pressures in Pa, compositions in mol/mol. The unit of measure for other properties is available from the caperopertyUnit function.

Function reference

General purpose functions

Thermo-dynamic functions