Solve resource allocation problems with linear and mixed-integer programming, nonlinear optimization, and evolutionary algorithms.
Listing updated:November 29, 2023
Works with:
570K+
Overview
With the Solver Add-on, created by Frontline Systems, developers of the Solver in Microsoft Excel (www.solver.com), you can define and solve many types of optimization problems in Google Sheets ™ , just as you can with the Excel Solver and with Frontline's Solver App for Excel Online.

You can solve linear programming and mixed-integer programming problems with the Simplex LP Solver, nonlinear optimization problems with the GRG Nonlinear Solver, global optimization problems with the multistart method, and 'arbitrary' Sheets models containing any numeric formulas with the Evolutionary Solver. To learn more about optimization problems and what you can (and cannot) expect from solutions, visit www.solver.com/solver-addon-google-sheets-help-and-support.

You can use the Solver Add-on to find better ways to allocate scarce resources, maximize profits or minimize costs or risks, in a wide range of applications in finance and investment, marketing, manufacturing and production, distribution and logistics, purchasing, and human resources, as well as science and engineering. To see examples, visit www.solver.com. Many textbooks also include examples and discussions of Solver models -- see www.solver.com/recommended-books.

Problem size limits in the Solver Add-on are the same as in the Excel Solver (200 decision variables and 100 constraints in addition to bounds on the variables). There are no fixed limits on iterations or subproblems, but the backend server currently limits solving time to 30 seconds.

When you click the Solve button in the Add-on, your model is queued for solution by Frontline's backend Solver Server. This server has a finite capacity, as currently provisioned (and paid for) by Frontline Systems. To solve larger models (up to hundreds of thousands or millions of decision variables), please contact Frontline Systems at info@solver.com or 775-831-0300.

Google Chat™ is a trademark of Google LLC
Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
Solver will ask for the permissions shown below. Learn more
Solver will need access to your Google account
This will allow Solver to :
See, edit, create, and delete all of your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Elena Baron
November 4, 2023
I wish I saw all the negative reviews before installing
Is this review helpful?
Yes
No
Profile Picture
Greg Stauffer
December 4, 2023
Doesn't do anything useful. Uninstalling.
Is this review helpful?
Yes
No
Profile Picture
Garrett Williams
October 19, 2022
Just absolutely terrible...Have a good amount of experience using solver in Excel and this add-on is garbage. Even simple models didn't work.
Is this review helpful?
Yes
No
Profile Picture
AMANDA BABIC
September 1, 2022
It worked great for awhile, now it just doesn't. I will put in the necessary constraints, tell it to find an exact value of let's say 25,172.63 and it will return a value of 4153.87. Not even close to accurate!! Super frustrating.
Is this review helpful?
Yes
No
Profile Picture
LeShaq Kisito
July 8, 2023
Unuseful plugin. It does not work. Don't install it, they just grab your personal data
Is this review helpful?
Yes
No
Profile Picture
Enrico Altini
November 24, 2022
It doesn't work at all!!!
Is this review helpful?
Yes
No
Profile Picture
Zbigniew Popielecki
September 6, 2022
Useless add-on, doesn't work at all on custom data, works only on the included example sheet. Old 2007 excel solver add-on is solving my problem with no issues but this garbage cant handle it.
Is this review helpful?
Yes
No
Profile Picture
Andrey Lappo
May 21, 2022
Кликаю в поле "Set Objective:", после — ячейку, которую хочу в этой опле внести — никакой реакции. Аналогично с полем "By Changing:". С десятого раза удалось добавить адреса ячеек, но после успешного нахождения значения ("Solver. Solver found a solution. All constraints and optimality conditions are satisfied.") в таблице никаких изменений, найденное значение не отобразилось в панели дополнения и не вставилось в таблицу.
Is this review helpful?
Yes
No
Profile Picture
Jik Lee
February 20, 2021
Absolutely useless. Even copied their example sheet, changed the cells, different error messages each time. Half an hour of my life I can't get back. I even re-installed the app just to leave this review. Just to be fair to the app, I redid the problem on Microsoft Excel with its in-built Solver app. Gave me a solution within seconds. This one still insists that "Problem could not be loaded. No model defined".
Is this review helpful?
Yes
No
Profile Picture
Jason Wisnieski (home)
January 8, 2022
Based on the error messages I received, it appears that the extension downloads and processes the spreadsheet as an Excel file. That means you can't use any functions that Excel doesn't support.
Is this review helpful?
Yes
No
1-10 of 134
Search
Clear search
Close search
Google apps
Main menu