Erschienen in:Vanderbilt Owen Graduate School of Management Research Paper ; No. 2709788
Umfang:
1 Online-Ressource (16 p)
Sprache:
Englisch
DOI:
10.2139/ssrn.2709788
Identifikator:
Entstehung:
Anmerkungen:
Nach Informationen von SSRN wurde die ursprüngliche Fassung des Dokuments December 30, 2015 erstellt
Beschreibung:
Spreadsheet optimization models are commonly understood to be difficult to scale up and down in size, reducing their utility for models that are large or will be reused. In contrast, an equivalent algebraic optimization model scales up and down very easily. In this paper, we show how to overcome this spreadsheet scalability disadvantage. We provide a technique to program an optimization model in a spreadsheet that can easily be scaled up or down in size and re-optimized using the Excel Solver. Our technique enables a spreadsheet model to be scaled and reused as easily as its equivalent algebraic implementation. We give examples involving transportation models and are working on examples involving manufacturing optimization and other extensions and generalizations, and on techniques for sharing spreadsheet optimization models with other systems