Help & Support
Send Feedback
Solver
Solve resource allocation problems with linear and mixed-integer programming, nonlinear optimization, and evolutionary algorithms.
16,527 users
Works with
Install
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.
Reviews
A User of Solver
January 16, 2020
Works
Submit reply
Cancel
A User of Solver
January 14, 2020
Flat out doesn't work even with a super simple request (that could by done by hand in 1 minute)
Submit reply
Cancel
A User of Solver
January 14, 2020
It's not implemented correctly - it gives wildly wrong / bad answers, regardless of the solver used.
Submit reply
Cancel
A User of Solver
January 5, 2020
It is not possible to import constraint from the sheet, like you would do with excel. Quite useless without this feat to be honest, you need to input everything by hand.
Submit reply
Cancel
A User of Solver
December 30, 2019
Seems great, however when it doesn't just report that it is unable to parse the problem, it often fails to optimize the result even for simple linear systems. Excel solver does not work well with many inputs, but it works.
Submit reply
Cancel
A User of Solver
December 27, 2019
Absolute trash. Cannot handle the simplest problems.
Submit reply
Cancel
A User of Solver
November 21, 2019
it doesnt work!
Submit reply
Cancel
A User of Solver
October 18, 2019
values kept resetting and I was never able to get it to compute.
Submit reply
Cancel
A User of Solver
October 14, 2019
no
Submit reply
Cancel
A User of Solver
October 2, 2019
It blows
Submit reply
Cancel
1-10 of 57
Additional information
Search
Clear search
Close search
Google apps
Main menu