© 2021 Jasper van Baten, AmsterCHEM

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:

Function reference

General purpose functions

Thermo-dynamic functions

INDEX
add-In
aggregation state
available properties
capeCompoundConstant
capePropertyUnit
capeFlash
capeFlashedFeed
capeOverallFeedProperty
capeOverallProperty
capePDependentProperty
capeSinglePhaseProperty
capeCompoundNames
compound names
unit of measure
capeStateOfAggregation
capeTDependentProperty
capeTwoPhaseProperty
capeUnitOperationName
compound constants
control sheet
defined phases
Disclaimer
equilibrium calculations
examples
Excel solver
Export Model
feeds
flash calculations
getting started
Import Model
input parameters
Loading and storing models
macros
output parameters
overall properties
parameters
ports
pressure dependent properties
products
property calculations
quick reference
reports
requirements
run-time error
security
single phase properties
solver
state of aggregation
streams
temperature dependent properties
thermodynamic equilibrium calculations
thermodynamic property calculations
two-phase properties
unit operation name
Update links
validation
VBA
welcome
CONTENT
 Introduction
 Ports and streams
 Parameters
 Function reference
 capeUnitOperationName
 capeStateOfAggregation
 capeCompoundConstant
 capePropertyUnit
 capeCompoundNames
 capeTDependentProperty
 capePDependentProperty
 capeSinglePhaseProperty
 capeTwoPhaseProperty
 capeFlash
 capeFlashedFeed
 capeOverallProperty
 capeOverallFeedProperty
 The control sheet
 Using the Excel solver
 Using Macros
 Loading and storing models
 Persistence in AspenPlus
 Examples
 Disclaimer