Interactive optimization aspects of electronic spreadsheet models for design and planning

Interactive optimization aspects of electronic spreadsheet models for design and planning

0.00 Avg rating0 Votes
Article ID: iaor1992283
Country: United Kingdom
Volume: 42
Issue: 5
Start Page Number: 349
End Page Number: 355
Publication Date: May 1991
Journal: Journal of the Operational Research Society
Authors: , ,
Abstract:

This paper extends the discussion of the relationship between optimization and electronic spreadsheet modelling. Previous authors have described two connections. These are, first, the use of spreadsheets to facilitate optimization projects and, second, the use of optimization within the spreadsheet model itself such as for cell value computation. In this paper the authors argue that use of the spreadsheet model for planning and design problems often may actually be viewed as interactive multi-criterion optimization per se. This provides a third connection between optimization and spreadsheet models. The authors base our arguments on a simplified example arising in insurance consulting work and note other examples as well. They also propose a method for incorporating this observation into existing spreadsheet models and indicate desirable innovations in spreadsheet software.

Reviews

Required fields are marked *. Your email address will not be published.