Interfacing a Process Simulator with Excel

Global SOO and MOO optimization methods, particularly recent ones, have been implemented and are readily available in Excel, MATLAB, C-i-i-, FORTRAN, and so on (Table 4.1). But, they may not be available in process simulators. So, interfacing between a process simulator (for example. Aspen HYSYS, Aspen Plus or ACM) and a global optimization program (for example, I-MODE in Excel) is necessary for improving the design of chemical processes. In particular, students and practitioners are familiar with Excel, and can easily use worksheets in Excel for computations, data analysis, plotting, and so on. 

7 Algorithm Parameters N Save Data Transferred from Simulator after 

Calculate Objectives Save Optimization Results at Different Generations / 

Transfer Required Data after Simulation Converged 

Interfacing between a process simulator and Excel (containing an optimization 

---