Premium
Use of spreadsheets in optimization problems involving iterations
Author(s) -
Iglesias Omar Alfredo,
Paniagua Carmen Noemí
Publication year - 1999
Publication title -
computer applications in engineering education
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.478
H-Index - 29
eISSN - 1099-0542
pISSN - 1061-3773
DOI - 10.1002/(sici)1099-0542(1999)7:4<227::aid-cae4>3.0.co;2-w
Subject(s) - computer science , solver , relation (database) , process (computing) , mathematical optimization , industrial engineering , programming language , mathematics , data mining , engineering
The use of spreadsheets in an undergraduate course in process engineering is analyzed mainly as a tool to solve optimization problems with iteration cycles in the calculation of the variables involved and as an introductory approach for the basic aspects of process simulators. The significance of using routines such as Solver in Excel to solve problems is clear. The advantages of using spreadsheets are analyzed in relation to other systems available for simulation and optimization problems. The way to add new functions to the spreadsheets used in the course are also considered, as well as the convenience of adopting certain norms when posing the problems. © 2000 John Wiley & Sons, Inc. Comput Appl Eng Educ 7: 227–234, 1999