Multi-objective optimization using MS Excel with an application to design of a falling-film evaporator system

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.

[1]  Kalyanmoy Deb,et al.  MULTI-OBJECTIVE FUNCTION OPTIMIZATION USING NON-DOMINATED SORTING GENETIC ALGORITHMS , 1994 .

[2]  Don W. Green,et al.  Perry's Chemical Engineers' Handbook , 2007 .

[3]  Kalyanmoy Deb,et al.  Muiltiobjective Optimization Using Nondominated Sorting in Genetic Algorithms , 1994, Evolutionary Computation.

[4]  Zacharias B. Maroulis,et al.  Food Process Design , 2003 .

[5]  Santosh K. Gupta,et al.  A comparative parametric study of two theoretical models of a single-stage, single-fluid, steam jet ejector , 1979 .

[6]  A. Abakarov,et al.  OPTIMUM DESIGN AND OPERATING CONDITIONS OF MULTIPLE EFFECT EVAPORATORS: TOMATO PASTE , 2008 .

[7]  J. Thibault.  Net Flow and Rough Sets: Two Methods for Ranking the Pareto Domain , 2008 .

[8]  Kalyanmoy Deb,et al.  A fast and elitist multiobjective genetic algorithm: NSGA-II , 2002, IEEE Trans. Evol. Comput..

[9]  Richard Turton,et al.  Analysis, Synthesis and Design of Chemical Processes , 2002 .

[10]  J. M. QCoulson J. M. Coulson,et al.  Coulson & Richardson's Chemical engineering. Vol.1, Fluid flow, heat transfer and mass transfer , 1996 .

[11]  Ferruh Erdogdu,et al.  Optimization in Food Engineering , 2008 .

[12]  Ignacio E. Grossmann,et al.  Retrospective on optimization , 2004, Comput. Chem. Eng..

[13]  G. P. Rangaiah,et al.  Optimization of Recovery Processes for Multiple Economic and Environmental Objectives , 2009 .

[14]  Gade Pandu Rangaiah,et al.  Multi-Objective Optimization Applications in Chemical Engineering , 2013 .

[15]  Tong Heng Lee,et al.  Multiobjective Evolutionary Algorithms and Applications , 2005, Advanced Information and Knowledge Processing.

[16]  Gade Pandu Rangaiah,et al.  Optimize Your Process Plant For More Than One objective , 2008 .

[17]  Gade Pandu Rangaiah,et al.  Multi-Objective Optimization in Food Engineering , 2008 .

[18]  Paul E. Minton,et al.  Handbook of Evaporation Technology , 1988 .

[19]  Hirokazu Nishitani,et al.  MULTI-OBJECTIVE ANALYSIS FOR ENERGY AND RESOURCE CONSERVATION IN PROCESS SYSTEMS , 1983 .

[20]  Ajay K. Ray,et al.  APPLICATIONS OF MULTIOBJECTIVE OPTIMIZATION IN CHEMICAL ENGINEERING , 2000 .

[21]  Hong Chen,et al.  Performances of falling film evaporators on whole milk and a comparison with performance on skim milk , 1997, Journal of Dairy Research.

[22]  H. Nishitani,et al.  The optimal flow-pattern of multiple effect evaporator systems , 1979 .

[23]  Lothar Thiele,et al.  Comparison of Multiobjective Evolutionary Algorithms: Empirical Results , 2000, Evolutionary Computation.

[24]  Kalyanmoy Deb,et al.  Multi-objective optimization using evolutionary algorithms , 2001, Wiley-Interscience series in systems and optimization.

[25]  Gary B. Lamont,et al.  Evolutionary Algorithms for Solving Multi-Objective Problems , 2002, Genetic Algorithms and Evolutionary Computation.

[26]  C. F. King.  Analysis, Synthesis, and Design of Chemical Processes. Richard Turton, Richard Bailie, Wallace Whiting, Joseph Shaeiwitz Prentice Hall, 1998 , 1999 .