Cannot use the Excel Unit Operation

Moderator: jasper

Re: Cannot use the Excel Unit Operation

Postby jasper » 25 February 2014, 10:11

I am afraid I am not sure how to help you here, as this is clearly an Excel issue and not a COFE issue.
User avatar
jasper
 
Posts: 1128
Joined: 24 October 2012, 15:33
Location: Spain

Re: Cannot use the Excel Unit Operation

Postby jasper » 25 February 2014, 10:32

As a side remark, Excel is not always as stable while executing either. The Scilab and Matlab unit operations have much fewer stability issues (as Scilab and Matlab themselves run much stabler). For this reason I personally prefer setting up custom models in Scilab or Matlab over Excel.
User avatar
jasper
 
Posts: 1128
Joined: 24 October 2012, 15:33
Location: Spain

Re: Cannot use the Excel Unit Operation

Postby arvind.prasad » 25 February 2014, 10:38

Then, I will try to lean Scilab and learn to write models in Scilab. I guess you must have surely uploaded some tutorials in scilab. I'll go through them.
arvind.prasad
 
Posts: 54
Joined: 02 December 2012, 14:39

Re: Cannot use the Excel Unit Operation

Postby jasper » 25 February 2014, 11:45

Please note that I just uploaded version 1.0.0.22, which fixes an important issue. Please make sure to use this version rather than 1.0.0.21

A function reference is included in the help file, here are some examples:

http://cocosimulator.org/downcs.php?dl= ... 8p3484.fsd

http://cocosimulator.org/down.php?dl=Sa ... p_COCO.pdf
http://cocosimulator.org/down.php?dl=Wa ... Scilab.fsd
http://cocosimulator.org/down.php?dl=Wa ... abatic.fsd
User avatar
jasper
 
Posts: 1128
Joined: 24 October 2012, 15:33
Location: Spain

Re: Cannot use the Excel Unit Operation

Postby rhsrxs » 25 February 2014, 23:13

I also prefer using Scilab. This website has some great engineering examples in Scilab - http://www.scilab.in/Completed_Books.

Also, attached is an example for quick calculation of pressure drop in a pipe for gas flow. Scilab tutorials are easily located using google search.
Attachments
Scilab pressure drop calculation.fsd
Gas flow pressure drop
(100.69 KiB) Downloaded 859 times
rhsrxs
 
Posts: 26
Joined: 24 October 2012, 21:29

Re: Cannot use the Excel Unit Operation

Postby jasper » 26 February 2014, 08:18

Nice example. This example is still explicit in its calculations and does not require a solver. The strength of units like the Excel unit, Matlab unit and Scilab unit is that you can use the solvers that are available with Excel, Matlab and Scilab.

Note that the first setProduct in this example seems redundant.
User avatar
jasper
 
Posts: 1128
Joined: 24 October 2012, 15:33
Location: Spain

Previous

Return to Microsoft Excel Unit Operation (AmsterCHEM)

Who is online

Users browsing this forum: No registered users and 1 guest

cron