opensolver.org
•  13,499
Overview
Solve linear and mixed-integer optimization problems in Google Sheets with no artificial limits on problem size.
The OpenSolver Add-on for Google Sheets lets you solve complex optimization problems from within your Google Sheet. Made by the developers of the popular OpenSolver addin for Microsoft Excel, this add-on brings the same Open Source optimization engine to the cloud!

OpenSolver for Google Sheets uses the excellent, Open Source, SCIP and Glop optimization engines to quickly solve large Linear and Integer problems.  SCIP is one of the fastest non-commercial solvers for mixed integer programs, and Glop is an Open Source Linear Programming solver by the Operations Research team at Google.  We also support using the Open Source COIN-OR Cbc solver via the NEOS optimization cloud, and the Open Source GLPK solver running locally in your browser via GLPK.js.

There are no artificial limits on the size of problem you can solve with OpenSolver.

OpenSolver is free, Open Source software developed and maintained by Andrew Mason and students at the Engineering Science department, University of Auckland, New Zealand.

For more information, see www.opensolver.org
Reviews
Language:
Sort by:
A User of OpenSolver
May 25, 2020
While opening OpenSolver, it shows the following message "Sign in with Google temporarily disabled for this app". Can you please help how to use the google solver and tackle this issue.
Is this review helpful?
Yes
No
A User of OpenSolver
April 11, 2020
Doesn't work with Google.
Is this review helpful?
Yes
No
A User of OpenSolver
March 31, 2020
I can't use it as the app doesn't support Google Sign In
Is this review helpful?
Yes
No
A user of OpenSolver
April 4, 2020
Just read this on their website from December 11th 2019. Seems like we're stuck. Would be great to get this working, as OpenSolver doesn't work for the challenge I have. 'Changes made by Google mean that OpenSolver for Googlesheets is currently not working for new users who want to add it to their Googlesheets. (Apparently the first 100 users each month can sign in, but then further sign ins are blocked by Google.) We are working on fixing this, But we don’t know how long it will take, sorry. We suggest you use OpenSolver for Excel until we get it working properly for Googlesheets. Cheers, Andrew'
A User of OpenSolver
March 23, 2019
Can't get it started. I can install it, but can't select any page on the dropdown menu, then all fields stays gray and inactive. I can't find help anywhere. Neither the official website, or the internet, offers a troubleshoot page. Nowhere can I find any assistance.
Is this review helpful?
Yes
No
A user of OpenSolver
April 17, 2019
I am dealing with the same situation, I contacted them on their help page, i will respond here with their answer if they ever reply to me. For now we should just look for alternatives.
A User of OpenSolver
March 7, 2019
Does not work. I tired using this to see if it would be able to do something my other solver cant but it does not even follow the constrants i set for it and it only inputs into the first of 5 Variables, while ignoring the constraint limiting the costs. Went back to using other solver cause it could atleast handle a basic 5 variable 3 constrant Maximization
Is this review helpful?
Yes
No
James Ball
April 5, 2018
This is a linear programming and solver alternative NOT a security appliance. Why would it be? I just have to say thanks, especially for not limiting the number of inputs. Solver in Excel is an intro level product. One of the paid versions is needed if you have a large number of inputs.
Is this review helpful?
Yes
No
A User of OpenSolver
February 15, 2018
This works better than the Solver plugin in my limited testing. I'm excited someone is working on this since lack of Solver had been a huge limitation for sheets. The permissions are too broad, but from what I can tell that is because Google doesn't offer enough granularity in permissions.
Is this review helpful?
Yes
No
A User of OpenSolver
September 14, 2017
Great add-on but WAY too many permissions - end up adding it only when I need it... Removing again now.
Is this review helpful?
Yes
No
A User of OpenSolver
September 11, 2017
I like this tool for its simplicity but I believe the permissions are a bit too wide. It would be five starts if this app used "View and manage spreadsheets that this application has been installed in" vs a blanket permission of full sheet access. Overall great tool for linear problems
Is this review helpful?
Yes
No
A User of OpenSolver
July 20, 2017
Loved it! Very intuitive interface: I had a linear maximization problem involving ~50 variables. I managed to define the problem and had it solved within 5 minutes after installation.
Is this review helpful?
Yes
No
1-10 of 22
Additional information
opensolver.org
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu