×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

multicomponent distillation procedure in Excel ?
8

multicomponent distillation procedure in Excel ?

multicomponent distillation procedure in Excel ?

(OP)
does anyone know of Excel code capable to solve multicomponent distillations ?
(also with simplified mass+energy balance)
Thanks for help.

RE: multicomponent distillation procedure in Excel ?

(OP)
thanks

RE: multicomponent distillation procedure in Excel ?

apetri,

Make sure you have good physical property data for use in your simulation.

Aspen data banks are based on dippr and others. which have generally good physical property data. And i assume proii is the same.

so if your basing any capital equipment order on this be careful.

I know the wrong physical properties make a massive difference on simulations upto 50% side difference.. (that i've seen)..
 

RE: multicomponent distillation procedure in Excel ?

jamesbanda,
I agree concerning the importance of properties, that is the reason why I suggested two different solutions:

A VBA code for mass balance based on Thiele Geddes method (which could be extended with energy balance based on constant composition method and possibly rigorous properties)

A complete rigorous solution (Prode Properties) based on Newton method and rigorous properties.

Of course for solving a column there are many process simulators with rigorous thermodynamics but these are (in general) much more expensive (with some exception as Chemsep)

RE: multicomponent distillation procedure in Excel ?

in addition I wouldn't underrate the importance of classic short cut methods as Fenske-Underwood-Gilliland, these are easily implemented in Excel and can provide real knowledge about multistage separation...

RE: multicomponent distillation procedure in Excel ?

there is a paper "Shortcut distillation calculations via spreadsheets", Chemical Engineering Progress, Dec. 2002 which describes the procedure.
When most engineers at meetings only say "I did it with my $$$ simulator" I wonder how much Excel (and knowledge of process operations) can be useful in everyday work

RE: multicomponent distillation procedure in Excel ?

(OP)
thanks all,
I use my own procedures and I can discuss the details, codes etc. with my clients, I understand that for such complex things as columns this is unrealistic but anyway it keeps me quite proud of my job...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources