首页   按字顺浏览 期刊浏览 卷期浏览 Interactive Optimization Aspects of Electronic Spreadsheet Models for Design and Planni...
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)



返 回