Operations Research Proceedings 2011

Part of the series Operations Research Proceedings pp 401-406


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

  • Andrew J MasonAffiliated withDepartment of Engineering Science, University of Auckland Email author 

* Final gross prices may vary according to local VAT.

Get Access


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 Open- Solver’s development and features. OpenSolver can be downloaded free of charge at http://​www.​opensolver.​org.