15-January-2021: we’ve recently revealed the beta form of OpenSolver 2.9.4. Totally free think to read through the release records for the variations and new features included. Please inform us if they are any issues or problems which you have experienced by placing comments on the bottom of this OpenSolver 2.9.4 article.

Please read the site web page for release info. You may also utilize the integrated revision checker to help keep current using the latest release.

OpenSolver will come in two forms, an easier “linear” type and an “advanced” (non-linear) version with service for much more solvers, including non-linear solvers. Both forms are offered for Mac computer and house windows. On Microsoft windows, OpenSolver should make use of Excel 2007 and later; we test drive it on 32 and 64 little bit house windows 7/10 in succeed 2010/2013/2016. (earlier models caused Excel 2003, but we don’t try this any more.) On Mac computer OS X, it ought to operate making use of Excel for Mac 2011 with any version of OS X more recent than 10.7.

OpenSolver for Mac computer: OpenSolver at this time have restricted support for succeed 2016 for Mac computer. Adaptation 2.8.3 of OpenSolver include first service for shine 2016 for Mac, and helps product creation and customization, including fixing using CBC and Gurobi solvers. Ensure that your version of Excel 2016 reaches minimum 15.28 for this to operate. Unfortuitously, the belated 2018 launch of shine 16.16.7 keeps damaged OpenSolver; whenever you help us debug this, kindly e-mail us at e-mail concealed; JavaScript is . But our user Alexander reported in April 2019 that “OpenSolver works well with MacOS HighSierra utilizing the newest Excel inform 16.24, in case your upgrade your OS to Mojave they don’t work.” (Thanks A Lot, Alexander.)

Windowpanes July 2016 Office protection inform Microsoft up-to-date the safety requirement for add-ins in July 2016. At this point you must “Unblock” the .zip file before getting the documents; please see the directions the following and this support product.

Offered Packages

OpenSolver Linear: This is basically the straightforward type that resolves linear models making use of the COIN-OR CBC optimization engine, using the option of using Gurobi if you have a permit. A lot of people make use of this variation.

OpenSolver state-of-the-art (Non-Linear): plus the linear solvers, this variation contains different non-linear solvers and help for fixing versions in cloud making use of NEOS; more info is here. Much of this signal still is brand-new and fresh, and so cannot meet your needs.

You can find our downloads, like earlier incarnations, on our very own start Solver Resource Forge website.

To install and make use of OpenSolver:

1. Get the OpenSolver Linear zip document (either Mac or windowpanes, selected automatically according to maker you might be utilizing to go to this page). You may also experiment our very own fresh cutting-edge Non-linear OpenSolver for Microsoft windows (in addition designed for Mac) for entry to non-linear solvers.
2. Correct click the downloaded zip file, pick land, and click the “Unblock” key or checkbox. Should you decide don’t see this button (or an equivalent checkbox), possible miss this task. (this action try another necessity soon after a July 2016 enhance to succeed.) Near the Characteristics screen.
3. Extract the data to a convenient venue. (All data and sub-folders, such as OpenSolver.xlam, must stay with each other; please you should never push any documents or files from the unzipped OpenSolver folder.) OpenSolver on screens may well not work if installed to an unmapped service such as for example \\server\myfiles\ or one that contains unicode characters.
4. Increase select OpenSolver.xlam. There could subsequently getting limited wait as succeed checks the electronic trademark about OpenSolver code.
5. If asked in a shine Security see, render Excel permissions to enable the OpenSolver macros. You are able to hit count on all from Publisher if you don’t want to be found the succeed safety Notice once more.
6. The OpenSolver instructions will show up under Excel’s facts loss on Microsoft windows, or in the diet plan pub on a Mac computer.
7. If using shine for Mac computer 2016, follow the directions more down the page to setup the solvers
8. OpenSolver relies on open origin solvers created by COIN-OR; please consider giving to COIN-OR.

Finalized rule: remember that as of Oct 2014, the OpenSolver code are signed of the author “The University of Auckland”. This is why the code safer. However, succeed will occasionally want to look into the digital signature by calling hosts online, that could grab a couple of seconds.

Support the Solver society: OpenSolver contains available supply solvers developed by COIN-OR. Without these, OpenSolver will never occur. Be sure to support our solver builders by donating to COIN-OR.

Making OpenSolver construction lasting: OpenSolver is readily available before you give up shine. Should you desire, there are two methods render OpenSolver once and for all in Excel. Oftentimes, make use of OpenSolver… About OpenSolver…. and check “Load OpenSolver when shine starts”, you can also duplicate the files from the .zip in to the Excel add-in directory. This is exactly generally:

Or windows 7: C:\Documents and Setup\”user label”\Application Data\Microsoft\Addins

Screens Vista and later (7, 8, 8.1): C:\Users\”user name”\AppData\Roaming\Microsoft\Addins

Mac Computer OSX: /Applications/Microsoft Workplace 2011/Office/Add-Ins

The Excel Solver was a product manufactured by Frontline Systems for Microsoft. OpenSolver does not have any association with, nor is advised by, Microsoft or Frontline Systems. All signature words are residential property of the particular owners.

Setting up Solvers on succeed for Mac 2016

If you find yourself working Excel 2016 on Mac computer, you should install the solvers after unzipping OpenSolver. In the unzipped folder, choose Solvers/osx there are a file known as “OpenSolver Solvers.pkg”. Open up this document and then click through the prompt to set up the solvers on your pc (you will have to enter the administrator code to take action). Next you can make use of OpenSolver as typical.

Making use of Gurobi on shine for Mac 2016

Due to the sandbox, Gurobi is not able to look for their licenses file once we start they from OpenSolver. This might be set by duplicating the licenses document “gurobi.lic” (which generally is during your home folder) with the soon after folder:

Instead, you are able to open a terminal and paste the next demand to put the license file in the best source for information (when your permit file is during a non-default venue you need to modify this order basic):

Exactly why do we truly need an installer for succeed 2016 on Mac?

Workplace for Mac 2016 was sandboxed, which means that it can best operated executables being situated in some whitelisted sites using the pc. We should instead place the Solvers directory into one of these whitelisted areas to make sure that we could work the solver binaries for OpenSolver. This folder is actually write-protected and requires admin privilege to modify, so we give you the installer to improve the build process.