CAPE-OPEN

Jasper
Thanks for providing the links. I can see possibilities for flowsheet monitoring, I will certainly start to try the WAR add in.

My current goal is to model the steam usage in a cane sugar factory, there will be at least 50 items of plant where heat loss is significant.
Would be good if each individual item was modelled and there was some Excel VBA code that changed the ambient temperature for each item.
What would the VBA code be to change the value for an information stream called AmbientT?
All my trials using Call and .SetProp have been unsuccessful.

You can look at the VBA code that obtains parameter values (note that the VBA code that comes with COFE.xlt is unprotected, you can just open the VBA editor and see it, and edit it). You can use the same code for setting parameter values.

I tried restarting, uninstalling and then reinstalling but it doesn't work, would anyone have a tutorial please?

Can you elaborate on what does not work? Are you not able to start a new Excel document based on COFE.xlt? Or when you do there is a problem with it?

To be clear the . What is missing is an implementation in COFE. The WAR algorithm by US EPA is a Flowsheet Monitoring Component and is a tool openly available for use to evaluate chemical processes in eight environmental impact categories. You are looking at something slightly different, but that goes along also the Flowsheet Monitoring approach. How to access many different objects in a Flowsheet to extract from them some pieces of information and to combine all these pieces of information to get a result. What you are considering is an approach that was . Cumbersome as a solution.
You may want to look at the scenarios of use described in the (see section 3.7). CO-LaN would be happy to have your feedback on how Flowsheet Monitoring as per the CAPE-OPEN standard could fit your needs.

The monitoring implementation in COFE is there - but using a prototype set of the interfaces - the published set of interfaces is pending its actual publication, which should be any day now.