Design Optimization of Convective Driers by Using Spreadsheets

Abstract

The optimal design of a convective drier is hereby considered by means of using a well-known spreadsheet: Microsoft Excel 5.0Tm.The degree of freedom analysis enabled a non linear equations system to be set up, in such a way that it was possible for different design variables to be considered. The equations system was keyed in to provide a possible solution via the iterative procedure built in the spreadsheet. Other complementary variables were computed to provide a unit cost for the operation, thus occasioning the opportunity of considering an economic objective function.Constraint and design variables were identified in the program. By giving initial values to the design variables, and by using the optimization capabilities included in Microsoft Excel 5.0TM, an optimal set of values for the design variables was determined.Finally, the influence of constraint and design variables was analyzed, where both the input air temperature and the relative humidity of exhaust air were binding factors.Copyrighl 0 1995 by Marcel Dskkcr, Ins. Downloaded by [University of Auckland Library] at