Bulk import from excel help

Simulate chemical processes using advanced thermodynamic models

Brought to you by: danwbr

Bulk import from excel help

Forum: Windows Platform (New UI)

Created: 2018-06-28

Updated: 2018-07-03

Evan - 2018-06-28

Hello, I am trying to run a series of flash calculations. All will have the same process set up and end conditions, but each will have differing inlet conditions (T&P) and different components (same componenets, differing mole fractions for each instance). I have 100's to do!
Is there a way to bulk import the inlet conditions and compositions, rather than hand bombing each one in?
Thanks

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gregor Reichert - 2018-07-03

Hi Evan,
you may try the Excel-Addin.
First you may prepare a table, containing all criteria as separate rows. Then you add a table containing the TP-Flash calculation. Then you create a VBA-macro where you write the criteria from one row to the flash calculation sheet and recalculate the flash. Now you can copy the results back the the criteria sheet and advance to the next row.

Gregor

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.