 Modeling optimization problems in the unstructured world of spreadsheetsD. G. Conway and C. T. Ragsdale Omega, 1997, vol. 25, issue 3, 313-322 Abstract: Electronic spreadsheets are the most common software tool managers use to analyze data and model quantitative problems. Increasingly, these software packages are being used in introductory OR/MS courses to introduce students to a variety of quantitative modeling tools. Because spreadsheets are inherently free-form, they impose no particular guidelines or structure on the way problems may be modeled. Thus, academics and practitioners accustomed to solving problems using very structured, dedicated OR/MS software packages are facing the challenge of dealing with these problems in the unstructured spreadsheet environment where there is often a variety of ways to implement and solve the same problem. This challenge is particularly acute in the case of optimization problems. Some are responding to this challenge by devising rules for implementing models that impose an artificial structure on spreadsheets, sometimes resembling the operation of dedicated OR/MS optimization packages. This paper offers a critique of this approach and provides some guidelines we believe to be more helpful in creating effective spreadsheet models for optimization problems. Keywords: spreadsheet; design; optimization; education (search for similar items in EconPapers) Downloads: (external link) Related works: Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text Persistent link: https://EconPapers.repec.org/RePEc:eee:jomega:v:25:y:1997:i:3:p:313-322 Ordering information: This journal article can be ordered from Access Statistics for this article Omega is currently edited by B. Lev More articles in Omega from Elsevier |
Is your work missing from RePEc? Here is how to contribute.
Questions or problems? Check the EconPapers FAQ or send mail to .
EconPapers is hosted by the
School of Business at Örebro University.