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
Parametric studies COFE
Moderator: jasper
Re: Parametric studies COFE
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:
http://cocosimulator.org/index_help.php ... cument.htm
Please see the existing VBA code to see how to get to these interfaces.
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:
http://cocosimulator.org/index_help.php ... cument.htm
Please see the existing VBA code to see how to get to these interfaces.
Re: Parametric studies COFE
OK, I understand.
Yes, thanks Jasper, that is what I had I mind to implement it.
Kind regards
Yes, thanks Jasper, that is what I had I mind to implement it.
Kind regards