Interactive Optimization Aspects of Electronic Spreadsheet Models for Design and Planning
作者:
TrouttMarvin D.,
TadisinaSuresh K.,
ClintonRoy J.,
期刊:
Journal of the Operational Research Society
(Taylor Available online 1991)
卷期:
Volume 42,
issue 5
页码: 349-355
ISSN:0160-5682
年代: 1991
DOI:10.1057/jors.1991.76
出版商: Taylor&Francis
关键词: electronic spreadsheet models;interactive multicriterion optimization;goal-seeking operation;what-if operation
数据来源: Taylor
摘要:
AbstractThis 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 we argue that use of the spreadsheet model for planning and design problems often may actually be viewed as interactive multi-criterion optimizationper se. This provides a third connection between optimization and spreadsheet models. We base our arguments on a simplified example arising in insurance consulting work and note other examples as well. We also propose a method for incorporating this observation into existing spreadsheet models and indicate desirable innovations in spreadsheet software.
点击下载:
PDF (3688KB)
返 回