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

  • Andrew J MasonEmail author
Conference paper
Part of the Operations Research Proceedings book series (ORP)


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


Decision Variable Major League Baseball Model Visualisation Leave Hand Side Integer Program Solver 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    CBC: A COIN-OR Integer Programming Solver, Cited November 2010
  2. 2.
    COIN-OR: Computational Infrastructure for Operations Research, Cited July 2011
  3. 3.
    Frontline Systems: Cited July 2011
  4. 4.
    Martin, K.: ‘COIN-OR: Software for the OR Community,’ Interfaces 40(6), pp. 465-476, INFORMS (2011)Google Scholar
  5. 5.
    Microsoft Excel. In: Wikipedia, Cited July 2011
  6. 6.
    OpenSolver web site, Cited July 2011
  7. 7.
    Pieterse, J.K.: Name Manager for Excel, Cited November 2010

Copyright information

© Springer-Verlag Berlin Heidelberg 2012

Authors and Affiliations

  1. 1.Department of Engineering ScienceUniversity of AucklandAucklandNew Zealand

Personalised recommendations