Excel based CAPE-OPEN Unit Operation
The excel cape-open unit operation is a unit operation implementation for which the calculations can be entered in microsoft excel. It will allow you to create an excel workbook that defines the equations for calculating a unit operation, and use it in a cape-open compliant simulation environment that supports cape-open version 1.0 or 1.1 thermodynamics.
The principle is simple; the workbook contains multiple worksheets that have specific functionality. There is the feeds page, that will allow you to add and feeds simply by adding names of feeds to a table. During calculation, the feeds page will contain pressure, temperature, enthalpy, composition and flow for each feed.
These numbers are automatically populated from the feed streams in the simulator host. There is a products worksheet. Here you can add product streams by adding rows to a table. This worksheet has cells for pressure, temperature, enthalpy, composition and flow as well.
The values of flow rate and composiation as well as two out of three of pressure, temperature and enthalpy is specified by excel formulas. There are additional worksheet for in- And output parameters. Complex, non-linear models can be solved using the excel solver add-in.
The excel cape-open unit operation allows to define multiple solver scenarios that will be solved sequentially during calculation. You can even specify which initial guess to use for your solver models.