Excel library for process calc's including distillation

[carlo.stenali]

Mderra,
Properties base release 1.18 can manage up to 500 streams,
you can redefine the maximum number of streams from Prode Properties Editor, go in Config and then Settings, the first row is the "Max number of streams", this field accepts values up to 500 streams, if you wish to set this value as default save into the archive with the name def.ppp, note that you must exit and restart the software to load the new configuration.

[mderra]

thanks,
I need to define about 100 streams for a simulation of a gas plant which I hope to solve from Excel, an interesting exercise anyway.

[cmarc]

mderra,
according my experience the main problem when simulating a plant in in Excel is the solution of recycles, Properties can solve single equipements as distillation columns, separators, pipelines etc. but with recycles you must find a way to iterate toward the desired solution, Excel has a general purpose minimizer but unfortunately it is quite limited.

[mderra]

thanks cmarc,
that could be difficult to solve, fortunately I have only two parameters to adjust and and I do that with VBA code, very slow but working.

[dbert]

is anyone running Properties from Matlab ?
According Matlab site (see MATLAB Interface to Shared Libraries) it should be able to call external Dlls as Properties.
Help will be appreciated.

[hans23]

dbert,
my copy of Matlab is old but I was able to access methods in Properties, the library adopts the C calling convenction required by Matlab, you need to define in Matlab the passing parameters for each method, not difficult as these are those in ppp.h header, don't know if Prode provides Matlab examples.

[dbert]

thanks, I am not a programmer so it was not easy, however now I can call several methods in Properties from Matlab.
For my work I need to calculate some alcohol and water equilibria, Prode Properties has a VLE/LLE data regression procedure but I have not access to experimental data ,can someone help with VLE data for water-ethanol, water-metrhanol etc. ?

[carlo.stenali]

dbert, in my library (from Dechema) I found this :

VLE methanol-water 760 mmHg, third column temperature in degrees Celsius
0.000000 0.000000 100.000
0.050000 0.278000 92.400
0.100000 0.425000 87.700
0.200000 0.602000 81.700
0.300000 0.692000 78.000
0.400000 0.752000 75.400
0.500000 0.798000 73.200
0.600000 0.838000 71.200
0.700000 0.878000 69.400
0.800000 0.915000 67.700
0.900000 0.960000 66.000
1.000000 1.000000 64.600

VLE ethanol-water 760 mmHg, third column temperature in degrees Celsius
0.000000 0.000000 100.000
0.050000 0.278000 92.400
0.100000 0.425000 87.700
0.200000 0.602000 81.700
0.300000 0.692000 78.000
0.400000 0.752000 75.400
0.500000 0.798000 73.200
0.600000 0.838000 71.200
0.700000 0.878000 69.400
0.800000 0.915000 67.700

[carlo.stenali]

it seems there was an error with copy and paste...
VLE methanol-water 760 mmHg, third column temperature in degrees Celsius
0.000000 0.000000 100.000
0.050000 0.278000 92.400
0.100000 0.425000 87.700
0.200000 0.602000 81.700
0.300000 0.692000 78.000
0.400000 0.752000 75.400
0.500000 0.798000 73.200
0.600000 0.838000 71.200
0.700000 0.878000 69.400
0.800000 0.915000 67.700
0.900000 0.960000 66.000
1.000000 1.000000 64.600

VLE ethanol-water 760 mmHg, third column temperature in degrees Celsius
0.018000 0.179000 95.500
0.054000 0.337500 90.600
0.124000 0.470000 85.400
0.176000 0.514000 83.700
0.230000 0.542000 82.750
0.288000 0.570000 82.000
0.385000 0.612000 81.000
0.440000 0.633000 80.500
0.514000 0.657000 79.800
0.673000 0.735000 78.900
0.840000 0.850000 78.260

[dbert]

thanks,
by chance do you have access to water-2 propanol VLE data ?

[carlo.stenali]

I have several data sets for 2-propanol water equilibria,

see "http://www.prode.com/docs/pppman.pdf" for the data regression procedure in Properties,

VLE 2-propanol-water 760 mmHg, third column temperature in degrees Celsius
0.013000 0.231000 92.200
0.018000 0.245000 91.000
0.033000 0.339000 87.800
0.045000 0.399000 86.200
0.044000 0.409000 86.000
0.046000 0.389000 85.800
0.053000 0.415000 85.500
0.126000 0.505000 82.800
0.241000 0.545000 81.600
0.321000 0.547000 81.000
0.523000 0.596000 80.500
0.581000 0.629000 80.300
0.844000 0.810000 80.500
0.860000 0.810000 80.600
0.926000 0.873000 81.200

[dbert]

thanks Carlo,
may I ask for1-Hexanol-water ?
:-)