mission
	CAPE-OPEN
	COCO
	Excel Unit Operation
»	Help
	Matlab Unit Operation
	Matlab Thermo Import
	OO Calc Thermo Import
	REFPROP PPM
	SciLab Unit Operation
	SciLab Thermo Import
	ScanIt
	WinVI
	downloads
	services
	links
	about us
	contact us

The control sheet

The control sheet performs several functions.

Identifier listing

To see which properties of a certain type are available, or which phases are defined, click the appropriate button on the control sheet. A dialog will pop up that lists the items in the selected category (only available if at least one port is connected). To use an identifier in a function, select it and use the Copy button to copy it to the clipboard.

Quick reference

The control sheet provides a quick reference of all available functions. The number of rows and columns for the outputs of the capeFlash and capeFlashedFeed functions is also listed (if at least one port is connected).

Help

Click the Help button in the control sheet to access the on-line help.

Validation error

Simulation environments will validate the unit operation when something has changed. You can specify a validation error in the control sheet; if this error is a non-empty string value other than "OK", the unit will be considered invalid by the simulation environment, and the user will be presented with the message. Example:

=if('input parameters'!B2<'input parameters'!B3,"pressure drop must be smaller than vessel pressure","OK")

Validation errors typically depend on parameter values and external dependencies. Validation should not depend on feed values (i.e. pressure, temperature, enthalpy, flow, composition).

Run-time error

After the Excel unit is done calculating, it will check for a run-time error on the control sheet. If set to a non-empty string other than "OK", the run results are considered invalid, and the error string is passed to the simulation environment. Example:

=if('calculation'!A30<=0,"run resulted negative or zero yield","OK")

Reports

Textual reports of the unit operation can be made available to the simulation environment. To define a textual report:

• Format any range of Excel cells to contain the textual data that makes up the report. The report values will be formatted exactly like in the cells. Report columns will automatically be padded with spaces so that column values align.
• Select the range of cells that makes up the report; define a name for this range, e.g. MyReport
• Add the defined name (e.g. Myreport) to the list of reports on the control sheet.

As reports depend on the calculated values, the reports are only available after a succesful run of the unit operation.

Note: the default control sheet constains space for up to 10 reports. If you need more reports, redefine the named range "ReportNames".

Solver models

Here you can identify models that need to be solved using the Excel solver. The models should be listed in the order in which they are to be solved during the unit operation's calculation.

Fore more information, see Using the Excel solver.

Note: the default control sheet constains space for up to 20 solver models. If you need more solver models, redefine the named range "SolverModels".

Load and restore models

To store the complete Excel model (including ports, parameters, options and calculations), click the Export model button. To reload the model in a different or the same unit operation, click the Import model button. Note that importing the model will discard all the information that is currently in the model. See Loading and storing models for more information.