COFE functions in Excel

[HenkF]

hmm, obviously the wrong xlsm file. A new one is attached.

To repeat: please save to an fsd file from the COFE Excel add-in menu ('save a copy'). Then reload this copy into COFE (not Excel).
At my place the flowsheet takes ages to load or crashes, when selected from the Document Explorer. It can't be viewed or used.

regards, Henk

[jasper]

This is now fixed; the fix is available via CUP.

[Usseglio]

Dear all,

Related to the topic.
I am trying to use the function COFE_GetStreamNames(), not with the array in a column format but in a row.
I first insert the formula in column array, to then copy it and paste it by using Excel function "Transpose", but it is not working.

Am I missing any step ?

Thanks in advance.

[jasper]

Which transpose are you using? Simply on the formula bar? This works ok for me:

Code: Select all

=TRANSPOSE(COFE_GetStreamNames(20))

(note that the last number just pads the array with blanks up to a length of 20)

Are you using Ctrl+Enter (or on the formula editor, Ctrl+OK) to enter the formula with the target range selected?

[Usseglio]

Just great, thanks !!
I did not realise about using Transpose formula ...
Now is working ...

[jasper]

Glad to hear it.

[Usseglio]

Another question of COFE functions.
Is it possible to get other info of phase/overall properties from streams, like liquid density, heat capacity, viscosity, ...?

I was trying to add new functions in COFE stream module, so far without success.

Thanks !!

[jasper]

Does this it not simply work with COFE_ObtainProperty, passing material type, phase name, phase composition, temperature and pressure of the stream?

http://cocosimulator.org/index_help.php ... _therm.htm

[HenkF]

It was simply that...
Wow, did you make some excellent software!
Thanks.

[Usseglio]

Yes, it Works (sorry for the silly question ...)
I was using COFE_ObtainProperty, but doing something wrong in the formula fields.