CAPE-OPEN

Hi Jasper,

May be you already have this in your todo list, but is it feasible to run parametric studies with COFE embedded in the excel ?

Thanks in advance !!

Marcelo

When running in Excel I do not have the option to present multiple windows. All items that open a new window (calculator, plots, parametric study) are therefore disabled. Without the ability to switch back and forth to the result window, it is not straight forward to represent the results.

You can in principle set stream values and unit operation parameters from VBA and call the Calculate method of the flowsheet, and pull the results out. In other words, it is not so difficult to do the parametric study directly from VBA in Excel.

Setting stream values can be done via the CAPE-OPEN material object interface. Setting unit operation parameters can be done via the CAPE-OPEN unit operation and parameter interfaces. Solving the flowsheet:



Please see the existing VBA code to see how to get to these interfaces.

OK, I understand.
Yes, thanks Jasper, that is what I had I mind to implement it.

Kind regards