Skip to main content
SpringerLink
Log in
Book cover

Operations Research Proceedings 2011 pp 401–406Cite as

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

  • Conference paper
  • First Online:

Part of the book series: Operations Research Proceedings ((ORP))

Abstract

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.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   169.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. CBC: A COIN-OR Integer Programming Solver, https://projects.coin-or.org/Cbc. Cited November 2010

  2. COIN-OR: Computational Infrastructure for Operations Research, http://www.coin-or.org. Cited July 2011

  3. Frontline Systems: http://www.solver.org. Cited July 2011

  4. Martin, K.: ‘COIN-OR: Software for the OR Community,’ Interfaces 40(6), pp. 465-476, INFORMS (2011)

    Google Scholar 

  5. Microsoft Excel. In: Wikipedia, http://en.wikipedia.org/wiki/MicrosoftExcel. Cited July 2011

  6. OpenSolver web site, http://opensolver.org. Cited July 2011

  7. Pieterse, J.K.: Name Manager for Excel, http://www.jkp-ads.com/officemarketplacenmen.asp. Cited November 2010

Download references

Author information

Authors and Affiliations

  1. Department of Engineering Science, University of Auckland, 92019, Auckland, New Zealand

    Andrew J Mason

Authors
  1. Andrew J Mason
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Andrew J Mason .

Editor information

Editors and Affiliations

  1. Institut für, Betriebswirtschaftslehre, Universität Zürich, Moussonstrasse, Zurich, 8044, Switzerland

    Diethard Klatte

  2. Inst. Operations Research, ETH Zürich, Rämistr. 101, Zürich, 8092, Switzerland

    Hans-Jakob Lüthi

  3. Institut für, Betriebswirtschaftslehre, Universität Zürich, Moussonstrasse 15, Zurich, 8044, Switzerland

    Karl Schmedders

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Mason, A.J. (2012). OpenSolver - An Open Source Add-in to Solve Linear and Integer Progammes in Excel. In: Klatte, D., Lüthi, HJ., Schmedders, K. (eds) Operations Research Proceedings 2011. Operations Research Proceedings. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-29210-1_64

Download citation

Publish with us

Policies and ethics

Search

Navigation