Skip to main content
Article
Multi-objective optimization using MS Excel with an application to design of a falling-film evaporator system
Food and Bioproducts Processing (2011)
  • Shivom Sharma, National University of singapore
  • G. P. Rangaiah
  • K. S. Cheah
Abstract
There are a number of multi-objective optimization (MOO) methods and programs, as well as many applications of MOO in food engineering. However, almost all these applications have been done using programs/platforms that are not readily used in the industry. On the other hand, engineers are familiar with MS Excel and use it in both research and industrial practice. Hence, in this work, an Excel-based MOO (EMOO) program is developed based on the elitist non-dominated sorting genetic algorithm (NSGA-II) and tested on benchmark problems. It is then applied for MOO of design of a falling-film evaporator system, consisting of a pre-heater, evaporator, vapor condenser and steam jet ejector, for milk concentration. The EMOO program gave well-distributed Pareto-optimal solutions for the MOO problems tested. Design equations and results for two bi-objective optimization problems are presented and discussed
Disciplines
Publication Date
2011
Citation Information
Shivom Sharma, G. P. Rangaiah and K. S. Cheah. "Multi-objective optimization using MS Excel with an application to design of a falling-film evaporator system" Food and Bioproducts Processing Vol. 90 Iss. 2 (2011)
Available at: http://works.bepress.com/shivom/2/