Interlinking Between Process Simulators and Optimization Programs

  • José María Ponce-Ortega
  • Luis Germán Hernández-Pérez


In this chapter, the methodology to achieve a successful link between the process simulator software and optimization programs using MS Excel® as a linker program will be described, as well as the direct linking of process simulator software with MS Excel® where it has been included a routine containing a stochastic optimization algorithm.


  1. Birnbaum, D. (2005). Excel VBA programming for the absolute beginner. Boston, MA: Thomson Course Technology PTR.Google Scholar
  2. Contreras-Zarazúa, G., et al. (2016). Multi-objective optimization involving cost and control properties in reactive distillation processes to produce diphenyl carbonate. Computers & Chemical Engineering, 105, 185–196.CrossRefGoogle Scholar
  3. González-Bravo, R., Nápoles-Rivera, F., Ponce-Ortega, J. M., & El-Halwagi, M. M. (2016). Multiobjective optimization of dual-purpose power plants and water distribution networks. ACS Sustainable Chemistry & Engineering, 4(12), 6852–6866.CrossRefGoogle Scholar
  4. Martinez-Gomez, J., Nápoles-Rivera, F., Ponce-Ortega, J. M., & El-Halwagi, M. M. (2017). Optimization of the production of syngas from shale gas with economic and safety considerations. Applied Thermal Engineering, 110, 678–685.CrossRefGoogle Scholar
  5. Medina-Herrera, N., Tututi-Avila, S., Jiménez-Gutiérrez, A., & Segovia-Hernández, J. G. (2017). Optimal design of a multi-product reactive distillation system for silanes production. Computers & Chemical Engineering, 105, 132–141.CrossRefGoogle Scholar
  6. Quiroz-Ramírez, J. J., et al. (2017a). Multiobjective stochastic optimization approach applied to a hybrid process production–separation in the production of biobutanol. Industrial & Engineering Chemistry Research, 56(7), 1823–1833.CrossRefGoogle Scholar
  7. Quiroz-Ramírez, J. J., et al. (2017b). Optimal selection of feedstock for biobutanol production considering economic and environmental aspects. ACS Sustainable Chemistry & Engineering, 5, 4018–4030.CrossRefGoogle Scholar
  8. Santibañez-Aguilar, J. E., Morales-Rodriguez, R., González-Campos, J. B., & Ponce-Ortega, J. M. (2016). Stochastic design of biorefinery supply chains considering economic and environmental objectives. Journal of Cleaner Production, 136, 224–245.CrossRefGoogle Scholar
  9. Segovia-Hernández, J. G., & Gómez-Castro, F. I. (2017). Stochastic process optimization using Aspen Plus®. s.l.: s.n.CrossRefGoogle Scholar
  10. Woinaroschy, A. (2009). Simulation and optimization of citric acid production with SuperPro designer using a client-server interface. CHIM, 9, 979–983.Google Scholar

Copyright information

© Springer International Publishing AG, part of Springer Nature 2019

Authors and Affiliations

  • José María Ponce-Ortega
    • 1
  • Luis Germán Hernández-Pérez
    • 1
  1. 1.Universidad Michoacana de San Nicolás de HidalgoMoreliaMexico

Personalised recommendations