SolverStudio: A New Tool for Better Optimisation and Simulation Modelling in Excel

INFORMS Transactions on Education

Andrew J Mason¹ 

[1] Department of Engineering Science, University of Auckland, Auckland 1142, New Zealand

关键词: teaching optimisation;    spreadsheet optimisation;    spreadsheet simulation;    open source;    solver;    AMPL;    GAMS;    GMPL;    PuLP;    NEOS;   

DOI  :  10.1287/ited.2013.0112

学科分类：社会科学、人文和艺术（综合）

来源: INFORMS

【 摘 要 】

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.

【 授权许可】

CC BY