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: | Troutt Marvin D., Tadisina Suresh K., Clinton Roy J. |
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