𝔖 Bobbio Scriptorium
✦   LIBER   ✦

Use of spreadsheets in optimization problems involving iterations

✍ Scribed by Omar Alfredo Iglesias; Carmen Noemí Paniagua

Publisher
John Wiley and Sons
Year
1999
Tongue
English
Weight
611 KB
Volume
7
Category
Article
ISSN
1061-3773

No coin nor oath required. For personal study only.

✦ Synopsis

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.

📜 SIMILAR VOLUMES

Using spreadsheets for studying machine
Using spreadsheets for studying machine design problems involving optimization
✍ Zella L. Kahn-Jetter; Paul A. Sasser 📂 Article 📅 1997 🏛 John Wiley and Sons 🌐 English ⚖ 305 KB 👁 1 views

Advanced machine design problems involving optimization concepts may be analyzed using spreadsheets. In this article, linear and nonlinear examples were modeled on current versions of Microsoft Excel, QuattroPro for Windows, and Lotus 1-2-3. A comparison of data entering and presentation of solution

Solving dynamic optimization problems on
Solving dynamic optimization problems on a personal computer using an electronic spreadsheet
✍ Mahmut Parlar 📂 Article 📅 1989 🏛 Elsevier Science 🌐 English ⚖ 390 KB

Powerful desk top computers of today combined with the easy to manipulate electronic spreadsheet programs (e.g. Lotus 1-2-3) are being used quite extensively in business applications such as planning, forecasting and accounting. Currently we are also witnessing a proliferation of optimization/operat

Computational techniques for optimizatio
Computational techniques for optimization of problems involving non-linear transient simulations
✍ G. A. Galarza; J. Carrera; A. Medina 📂 Article 📅 1999 🏛 John Wiley and Sons 🌐 English ⚖ 273 KB 👁 1 views

Many optimization problems in engineering require coupling a mathematical programming process to a numerical simulation. When the latter is non-linear, the resulting computer time may become una ordably large because three sequential procedures are nested: the outer loop is associated to the optimiz

Numerical solution of time-delayed optim
Numerical solution of time-delayed optimal control problems by iterative dynamic programming
✍ Cheng-Liang Chen; Daim-Yuang Sun; Chia-Yuan Chang 📂 Article 📅 2000 🏛 John Wiley and Sons 🌐 English ⚖ 142 KB 👁 2 views

This work presents a numerical method to solve the optimal control problem with time-delayed arguments and a "xed terminal time. A series of auxiliary states obtained from the linearly truncated Taylor series expansion are used to represent the status of a time-delayed state at di!erent time interva

Optimization of desalination location pr
Optimization of desalination location problem using MILP
✍ A. M. Emhamed; B. Czuczai; L. Horvath; E. Rev; Z. Lelkes 📂 Article 📅 2007 🏛 American Institute of Chemical Engineers 🌐 English ⚖ 296 KB

## Abstract A new mixed‐integer linear programming model for location problem is developed in this work in order to find the optimal co‐ordinates of the desalination plants. The model takes into account the given locations and capacities of the water incomes, the demands, and the costs of plants an