End-user optimization with spreadsheet models

Asim Roy, Leon Lasdon, Donald Plane

Research output: Contribution to journalArticle

14 Citations (Scopus)

Abstract

End-user optimization is becoming more widespread. Current software coupling optimization with spreadsheet systems now makes it possible for a user without a mathematical background to develop useful and substantive decision support tools utilizing mathematical programming. This paper briefly compares three existing spreadsheet optimization systems, and describes industrial and educational experience with one, ifps/Optimum. Problems encountered in using such systems are also described.

Original languageEnglish (US)
Pages (from-to)131-137
Number of pages7
JournalEuropean Journal of Operational Research
Volume39
Issue number2
DOIs
StatePublished - Mar 24 1989

Fingerprint

Spreadsheet
Spreadsheets
Optimization
Mathematical programming
Decision Support
Mathematical Programming
programming
Model
Software
End users
experience

Keywords

  • Decision
  • finance optimization
  • linear programming
  • mathematical programming
  • nonlinear programming
  • planning
  • practice

ASJC Scopus subject areas

  • Information Systems and Management
  • Management Science and Operations Research
  • Statistics, Probability and Uncertainty
  • Applied Mathematics
  • Modeling and Simulation
  • Transportation

Cite this

End-user optimization with spreadsheet models. / Roy, Asim; Lasdon, Leon; Plane, Donald.

In: European Journal of Operational Research, Vol. 39, No. 2, 24.03.1989, p. 131-137.

Research output: Contribution to journalArticle

Roy, Asim ; Lasdon, Leon ; Plane, Donald. / End-user optimization with spreadsheet models. In: European Journal of Operational Research. 1989 ; Vol. 39, No. 2. pp. 131-137.
@article{28159d4a3efb4340bf21dc39ae9544b8,
title = "End-user optimization with spreadsheet models",
abstract = "End-user optimization is becoming more widespread. Current software coupling optimization with spreadsheet systems now makes it possible for a user without a mathematical background to develop useful and substantive decision support tools utilizing mathematical programming. This paper briefly compares three existing spreadsheet optimization systems, and describes industrial and educational experience with one, ifps/Optimum. Problems encountered in using such systems are also described.",
keywords = "Decision, finance optimization, linear programming, mathematical programming, nonlinear programming, planning, practice",
author = "Asim Roy and Leon Lasdon and Donald Plane",
year = "1989",
month = "3",
day = "24",
doi = "10.1016/0377-2217(89)90186-0",
language = "English (US)",
volume = "39",
pages = "131--137",
journal = "European Journal of Operational Research",
issn = "0377-2217",
publisher = "Elsevier",
number = "2",

}

TY - JOUR

T1 - End-user optimization with spreadsheet models

AU - Roy, Asim

AU - Lasdon, Leon

AU - Plane, Donald

PY - 1989/3/24

Y1 - 1989/3/24

N2 - End-user optimization is becoming more widespread. Current software coupling optimization with spreadsheet systems now makes it possible for a user without a mathematical background to develop useful and substantive decision support tools utilizing mathematical programming. This paper briefly compares three existing spreadsheet optimization systems, and describes industrial and educational experience with one, ifps/Optimum. Problems encountered in using such systems are also described.

AB - End-user optimization is becoming more widespread. Current software coupling optimization with spreadsheet systems now makes it possible for a user without a mathematical background to develop useful and substantive decision support tools utilizing mathematical programming. This paper briefly compares three existing spreadsheet optimization systems, and describes industrial and educational experience with one, ifps/Optimum. Problems encountered in using such systems are also described.

KW - Decision

KW - finance optimization

KW - linear programming

KW - mathematical programming

KW - nonlinear programming

KW - planning

KW - practice

UR - http://www.scopus.com/inward/record.url?scp=0024620263&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0024620263&partnerID=8YFLogxK

U2 - 10.1016/0377-2217(89)90186-0

DO - 10.1016/0377-2217(89)90186-0

M3 - Article

AN - SCOPUS:0024620263

VL - 39

SP - 131

EP - 137

JO - European Journal of Operational Research

JF - European Journal of Operational Research

SN - 0377-2217

IS - 2

ER -