OpenSolver - Google Workspace Marketplace

Solve linear and mixed-integer optimization problems in Google Sheets with no artificial limits on problem size.

By:

Works with:

345,593

Overview

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

Additional information

PricingNot available

Developer

Trader status unspecified

Support

ReportFlag as inappropriate

Reviews

Language:

Sort by:

Google doesn't verify reviews or ratings. Learn more about reviews

Pink Eye

February 12, 2023

Can't even load in 2023. Just opens up a blank sidebar.

Is this review helpful?

Yes

Zbigniew Popielecki

September 6, 2022

use variables ignoring their constraints, no matter what method / solver solution is used, useless add-on

Is this review helpful?

Yes

mickias h

March 20, 2023

its not even launching for me

Is this review helpful?

Yes

starrychloe S.

March 25, 2022

It just doesn't work sometimes. Will give wrong answers for 'target value' mode. It is faster, easier, and more accurate to just manually do a binary search to hone into the correct value for your variable cell. My target value was 2, and it stopped with a ridiculous value like 28. By updating the variable cell myself about 5 times, I was able to find the target value 2.

Is this review helpful?

Yes

Pavel Golota

September 9, 2021

Doesn't work. The results of calculations are always 0.

Is this review helpful?

Yes

John Paravantis

November 19, 2021

Works well, with an interface different but simpler than the Solver of Excel.

Is this review helpful?

Yes

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

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

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

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

1-10 of 52

Clear search

Close search

Google apps

Main menu