IDEAS home Printed from https://ideas.repec.org/h/spr/oprchp/978-3-642-29210-1_64.html
   My bibliography  Save this book chapter

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

In: Operations Research Proceedings 2011

Author

Listed:
  • Andrew J Mason

    (University of Auckland)

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 .

Suggested Citation

  • Andrew J Mason, 2012. "OpenSolver - An Open Source Add-in to Solve Linear and Integer Progammes in Excel," Operations Research Proceedings, in: Diethard Klatte & Hans-Jakob Lüthi & Karl Schmedders (ed.), Operations Research Proceedings 2011, edition 127, pages 401-406, Springer.
    • Handle: RePEc:spr:oprchp:978-3-642-29210-1_64
    DOI: 10.1007/978-3-642-29210-1_64
    as

    Download full text from publisher

    To our knowledge, this item is not available for download. To find whether it is available, there are three options:
    1. Check below whether another version of this item is available online.
    2. Check on the provider's web page whether it is in fact available.
    3. Perform a search for a similarly titled item that would be available.

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Eduardo Pérez & David P. Dzubay, 2021. "A scheduling-based methodology for improving patient perceptions of quality of care in intensive care units," Health Care Management Science, Springer, vol. 24(1), pages 203-215, March.
    2. Ünal, Berat Berkan & Onaygil, Sermin & Acuner, Ebru & Cin, Rabia, 2022. "Application of energy efficiency obligation scheme for electricity distribution companies in Turkey," Energy Policy, Elsevier, vol. 163(C).
    3. Vishwesh Singbal & Gajendra K. Adil & Rakesh Venkitasubramony, 2020. "Case Article—Forward-Reserve Storage Design: A Case of Carriage Repair Workshop, Indian Railways," INFORMS Transactions on Education, INFORMS, vol. 21(1), pages 30-34, September.
    4. Jakub Jurasz & Jerzy Mikulik, 2017. "A strategy for the photovoltaic-powered pumped storage hydroelectricity," Energy & Environment, , vol. 28(5-6), pages 544-563, September.
    5. Zeenat Begam Sawal Hamid & Roslee Rajikan & Siti Masitah Elias & Nor Aini Jamil, 2019. "Utilization of a Diet Optimization Model in Ensuring Adequate Intake among Pregnant Women in Selangor, Malaysia," IJERPH, MDPI, vol. 16(23), pages 1-14, November.
    6. Sanjay L. Ahire & Pelin Pekgün, 2018. "Harvest Hope Food Bank Optimizes Its Promotional Strategy to Raise Donations Using Integer Programming," Interfaces, INFORMS, vol. 48(4), pages 291-306, August.
    7. Haji Esmaeili, Seyed Ali & Szmerekovsky, Joseph & Sobhani, Ahmad & Dybing, Alan & Peterson, Tim O., 2020. "Sustainable biomass supply chain network design with biomass switching incentives for first-generation bioethanol producers," Energy Policy, Elsevier, vol. 138(C).
    8. Wainwright, Warwick & Drucker, Adam G. & Maxted, Nigel & Brehm, Joana Magos & Ng’uni, Dickson & Moran, Dominic, 2019. "Estimating in situ conservation costs of Zambian crop wild relatives under alternative conservation goals," Land Use Policy, Elsevier, vol. 81(C), pages 632-643.
    9. Liselotte Schäfer Elinder & Patricia Eustachio Colombo & Emma Patterson & Alexandr Parlesak & Anna Karin Lindroos, 2020. "Successful Implementation of Climate-Friendly, Nutritious, and Acceptable School Meals in Practice: The OPTIMAT ™ Intervention Study," Sustainability, MDPI, vol. 12(20), pages 1-16, October.
    10. Dimitrov, Nedialko B. & Solow, Daniel & Szmerekovsky, Joseph & Guo, Jia, 2017. "Emergency relocation of items using single trips: Special cases of the Multiple Knapsack Assignment Problem," European Journal of Operational Research, Elsevier, vol. 258(3), pages 938-942.
    11. Andrea Manno & Laura Palagi & Simone Sagratella, 2019. "Case Article—Production and Distribution Optimization of Beach Equipment for the Marinero Company," INFORMS Transactions on Education, INFORMS, vol. 19(3), pages 152-154, May.
    12. Zhang, Jingran & Onal, Sevilay & Das, Sanchoy, 2020. "The dynamic stocking location problem – Dispersing inventory in fulfillment warehouses with explosive storage," International Journal of Production Economics, Elsevier, vol. 224(C).
    13. Rössert, Sebastian & Gosling, Elizabeth & Gandorfer, Markus & Knoke, Thomas, 2022. "Woodchips or potato chips? How enhancing soil carbon and reducing chemical inputs influence the allocation of cropland," Agricultural Systems, Elsevier, vol. 198(C).
    14. Gautier Stauffer, 2018. "Approximation algorithms for k-echelon extensions of the one warehouse multi-retailer problem," Mathematical Methods of Operations Research, Springer;Gesellschaft für Operations Research (GOR);Nederlands Genootschap voor Besliskunde (NGB), vol. 88(3), pages 445-473, December.
    15. Eyni, Leila & Stanko, Milan & Schümann, Heiner, 2022. "Methods for early-phase planning of offshore fields considering environmental performance," Energy, Elsevier, vol. 256(C).
    16. Takamasa Nishizawa & Sonja Kay & Johannes Schuler & Noëlle Klein & Felix Herzog & Joachim Aurbacher & Peter Zander, 2022. "Ecological–Economic Modelling of Traditional Agroforestry to Promote Farmland Biodiversity with Cost-Effective Payments," Sustainability, MDPI, vol. 14(9), pages 1-21, May.
    17. Okoye, Chiemeka Onyeka & Solyalı, Oğuz & Akıntuğ, Bertuğ, 2015. "Optimal sizing of storage tanks in domestic rainwater harvesting systems: A linear programming approach," Resources, Conservation & Recycling, Elsevier, vol. 104(PA), pages 131-140.
    18. Moritz Julius Ziegler & Kilian Seifried & Philipp Kuske & Moritz Fleischmann, 2019. "TRUMPF Uses a Mixed Integer Model as Decision Support for Strategic Production Network Design," Interfaces, INFORMS, vol. 49(3), pages 213-226, May.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:spr:oprchp:978-3-642-29210-1_64. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.springer.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.