OpenSolver - An Open Source Add-in to Solve Linear and Integer Progammes in Excel

被引:108
作者
Mason, Andrew J. [1 ]
机构
[1] Univ Auckland, Dept Engn Sci, Auckland 1, New Zealand
来源
OPERATIONS RESEARCH PROCEEDINGS 2011 | 2012年
关键词
D O I
10.1007/978-3-642-29210-1_64
中图分类号
C93 [管理学]; O22 [运筹学];
学科分类号
070105 ; 12 ; 1201 ; 1202 ; 120202 ;
摘要
OpenSolver is an open source Excel add-in that allows spreadsheet users to solve their LP/IP models using the COIN-OR CBC solver. OpenSolver is largely compatible with the built-in Excel Solver, allowing most existing LP and IP models to be solved without change. However, OpenSolver has none of the size limitations found in Solver, and thus can solve larger models. Further, the CBC solver is often faster than the built-in Solver, and OpenSolver provides novel model construction and on-sheet visualisation capabilities. This paper describes OpenSolver's development and features. OpenSolver can be downloaded free of charge at http://www.opensolver.org.
引用
收藏
页码:401 / 406
页数:6
相关论文
共 2 条
[1]   Tutorial: COIN-OR: Software for the OR Community [J].
Martin, Kipp .
INTERFACES, 2010, 40 (06) :465-476
[2]  
Pieterse J.K., 2010, NAME MANAGER EXCEL