Page 2 of 3

Re: COFE functions in Excel

Posted: 09 December 2014, 15:26
by 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

Re: COFE functions in Excel

Posted: 09 December 2014, 16:34
by jasper
This is now fixed; the fix is available via CUP.

Re: COFE functions in Excel

Posted: 11 December 2014, 03:56
by 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.

Re: COFE functions in Excel

Posted: 11 December 2014, 08:19
by 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?

Re: COFE functions in Excel

Posted: 11 December 2014, 12:25
by Usseglio
Just great, thanks !!
I did not realise about using Transpose formula ...
Now is working ...

Re: COFE functions in Excel

Posted: 11 December 2014, 14:01
by jasper
Glad to hear it.

Re: COFE functions in Excel

Posted: 12 December 2014, 19:56
by 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 !!

Re: COFE functions in Excel

Posted: 13 December 2014, 07:54
by 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

Re: COFE functions in Excel

Posted: 13 December 2014, 08:51
by HenkF
It was simply that...
Wow, did you make some excellent software!
Thanks.

Re: COFE functions in Excel

Posted: 13 December 2014, 13:44
by Usseglio
Yes, it Works (sorry for the silly question ...)
I was using COFE_ObtainProperty, but doing something wrong in the formula fields.