文章基本信息

标题：SolverStudio: A New Tool for Better Optimisation and Simulation Modelling in Excel
本地全文：下载
作者：Andrew J Mason
期刊名称：INFORMS : Transactions on Education
印刷版ISSN：1532-0545
电子版ISSN：1532-0545
出版年度：2013
卷号：14
期号：1
DOI：10.1287/ited.2013.0112
出版社：Institute for Operations Research and the Management Sciences
摘要：Excel's built-in Solver optimiser provides millions of spreadsheet users with easy access to optimisation, and is often used in teaching introductory optimisation courses. However, more sophisticated users often prefer to use modelling languages such as AMPL, GAMS, or PuLP, and so these are often taught in more advanced courses. Unfortunately, the command line and text file interfaces these systems employ present unnecessary barriers to their use. We have developed a new free Excel add-in, SolverStudio, that combines the power of modelling languages—including AMPL, GAMS, PuLP, GMPL, and Gurobi's Python environment—with the familiarity and ease of use of Excel. SolverStudio also brings cloud-based optimisation to Excel by providing easy access to the NEOS online solvers, and simulation capabilities via the Python-based SimPy software. We believe that SolverStudio will support and encourage the greater use in classrooms of Excel-based optimisation and simulation.
关键词：teaching optimisation ; spreadsheet optimisation ; spreadsheet simulation ; open source ; solver ; AMPL ; GAMS ; GMPL ; PuLP ; NEOS