Jump to content



Featured Articles

Check out the latest featured articles.

File Library

Check out the latest downloads available in the File Library.

New Article

Product Viscosity vs. Shear

Featured File

Vertical Tank Selection

New Blog Entry

Low Flow in Pipes- posted in Ankur's blog

Distillation Column Trays With Excel Vba Code

distillation column excel prode

This topic has been archived. This means that you cannot reply to this topic.
2 replies to this topic
Share this topic:
| More

#1 neriet

neriet

    Junior Member

  • Members
  • 16 posts

Posted 14 April 2017 - 02:05 PM

with reference to Prode VBA code for columns I wish to modify the number of trays, the position of feed(s) etc. by code (writing a specific method) with the goal to optimize the projects,

do you think the Excel Solver can manage this kind of problems or should I write my own code ?



#2 marchem

marchem

    Gold Member

  • Members
  • 153 posts

Posted 14 April 2017 - 03:33 PM

Prode includes several solvers for columns but you can access most data (input spec, results) and it shouldn't be difficult to modify something by code, the column.xls  page included in distribution provides a good example of how to enter data and extract results with VBA , there was a discussion (about optimization) in the manual but the last version "http://www.prode.com/docs/pppman.pdf"doesn't mention the topic...

anyway, If you  wish to investigate different configurations  with different position of feed(s), number of trays etc. I suggest to create your own code instead to use a generic Solver,  it requires time but there are many advantages when dealing with errors (for example Prode can't solve the column due to unfeasible specifications or similar problems...)

In my experience the Excel Solver is good for solving continuous functions (of several vars) but little more...



#3 twell

twell

    Junior Member

  • Members
  • 28 posts

Posted 22 April 2017 - 01:06 AM

neriet,

if you do not wish to write the optimization procedure you may consider different tools,

for example, I have Matlab code (working with Prode dll) for column optimization,

also there is Mathcad (which links Prode dll) etc.






Similar Topics