Help & Support
Send Feedback
Solver
Solve resource allocation problems with linear and mixed-integer programming, nonlinear optimization, and evolutionary algorithms.
3,677 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.
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
Reviews
A User of Solver
March 21, 2019
Doesnt work at all. Keep saying "The PSI Interpreter was not able to parse the model correctly."
Submit reply
Cancel
A User of Solver
March 7, 2019
The Alldifferent constraint that is available in the Excel Solver isn't here.
Submit reply
Cancel
A User of Solver
February 23, 2019
complete garbage, works if you have populations under 100, don't even think about a sample size larger than that.
Submit reply
Cancel
A User of Solver
October 12, 2018
Does not work. It does not even try to give a solution.
Submit reply
Cancel
Paul Symes
April 11, 2018
It's free, simple, works perfectly, and is exactly what I needed for some school assignments. The built in example really helps show how the solver should be used. This tool makes adding a large set of constraints simple and able to be done in one or two steps, unlike other optimization solvers I have used in the past. My only complaint is that you can't save a problem to quickly edit it again later.
Submit reply
Cancel
A User of Solver
March 24, 2018
Did not work. It told me that it had a solution that met all the constraints but it wouldn't show it. USE OPEN SOLVER instead.
Submit reply
Cancel
A User of Solver
March 10, 2018
It doesn't work
Submit reply
Cancel
A User of Solver
February 15, 2018
Very clunky interface. l wasn't able to get Solver to solve. Open Solver seems to be much better refined.
Submit reply
Cancel
A User of Solver
January 7, 2018
Worked well to solve HS71, instead of AP Monitor, in a class for Dynamic Optimization. I promptly disabled the add-on out of concern for privacy & security because the Solver requires access to 'View and manage the files in your Google Drive'.
Submit reply
Cancel
Greg Anderson
December 16, 2017
Simply does not work.
Submit reply
Cancel
1-10 of 45
Additional information
Search
Clear search
Close search
Google apps
Main menu