App Icon
opensolver.org
•  32,094
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
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
Profile Picture
Daniel Eichling
August 26, 2020
Doesn't work due to sign in issues.
Is this review helpful?
Yes
No
Profile Picture
Justin Miller
August 11, 2020
Sign in with Google temporarily disabled for this app This app has not been verified yet by Google in order to use Google Sign In.
Is this review helpful?
Yes
No
1-10 of 38
Additional information
opensolver.org
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu