App Icon
opensolver.org
•  48,272
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:
Profile Picture
Thuận Võ Quốc
April 21, 2021
Can not choose sheet, can not choose anything. The add-on is like freezing except the Select Constraint session but can not select anything. 1.5 stars
Is this review helpful?
Yes
No
Profile Picture
J F
April 18, 2021
Doesn't work at all. Every time I try to add variables to be changed, it clears everything so I can't even set it up. I've uninstalled and re-installed twice but no change. Total waste of time.... I'd give it zero stars but Google won't let me submit the review without at least 1 star.
Is this review helpful?
Yes
No
Profile Picture
Richy Lim
January 4, 2021
This app is blocked This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access.
Is this review helpful?
Yes
No
Profile Pciture
Andrew Mason
February 3, 2021
We have fixed this now. We spent many frustrating months trying to pin down an incorrect flagging by Google of our code as using sensitive data. In the end, changing a comment in our code fixed the problem, indicating a bug in Google's checking. OpenSolver is now up and running again on Google Sheets. Sorry about the inconvenience. Andrew
Profile Picture
jo vito
December 13, 2020
"This app has not been verified yet by Google in order to use Google Sign In." Why is it here, then??????
Is this review helpful?
Yes
No
Profile Picture
John Downing
December 4, 2020
"This app has not been verified yet by Google in order to use Google Sign In." when attempting to "Open Sidebar" (i.e. actually use the addon)
Is this review helpful?
Yes
No
Profile Picture
Steve Manley
December 4, 2020
Borked. Partially installs then doesn't finish.
Is this review helpful?
Yes
No
Profile Picture
Guy Tomer
December 2, 2020
sign in not working
Is this review helpful?
Yes
No
Profile Picture
Jared Kelly
November 9, 2020
Can't sign in with google with it, so its broken
Is this review helpful?
Yes
No
Profile Picture
James O'Connor
September 20, 2020
does not work
Is this review helpful?
Yes
No
Profile Picture
Cam Kehler
August 31, 2020
Needs an update
Is this review helpful?
Yes
No
1-10 of 40
Additional information
opensolver.org
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu