App Icon
Solve resource allocation problems with linear and mixed-integer programming, nonlinear optimization, and evolutionary algorithms.
Works with:
131,472
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.
Additional information
SupportNot available
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:
Profile Picture
A User of Solver
November 8, 2017
Honestly, this doesn't work. Tried to run a basic model for excess capacity for 9 resources over 3 months that is 27 variable cells and it couldn't find the optimal solution when you set the value to a fixed amount.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
October 14, 2015
The interface to the solver is extremely brittle. If you need to modify constraints you might be okay, but if you need to delete constraints you might was well start over. The constraint list gets corrupted very quickly. I am not sure if this is an issue as well, but I was only able to get it to work with a binary constraint if I entered it last. I know this is freeware, but if Frontline wants people to buy their optimizer this should be better. It is maddening when the solver says that it cannot find a solution, and it looks like you have the constraints correctly entered. Then when you wipe it out and re-input with no mistakes it works. I hope this gets fixed. It would be useful to have a decent solver in Google Sheets.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
May 29, 2017
Very simple solver tasks work fine. Mimics basic Excel interface, great for me. Others below should remember the days when Excel solver was an add-in. For free, this is a very feasible solution.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
August 21, 2019
The solver does not work and returns an error "The PSI Interpreter was not able to parse the model correctly." Every single time.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
May 28, 2017
Asks for way too broad permissions, and also doesn't work "decision variable cell with TABLE" or something.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
April 8, 2016
The interface is clunky, and failed to solve very simple problems that take Excel's "Goal Seek" zero time to reconcile. Throws errors at nearly every run.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
February 4, 2016
This version of the Add-on has problems with adding integer constraints. It gets buggy and the first of the int constraints is replaced by a blank "<=" constraint- deleting the erroneous constraint only transfers the problem to the next int constraint.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
December 9, 2016
does not seem to work if you objective formula contains a division; a 'division by 0' error keeps coming up even when I've set a constraint of objective value >= 1. Also it's buggy, each time you enter a constraint your objective cell value changes to a different sheet, also prompting an error.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
1-10 of 91
Search
Clear search
Close search
Google apps
Main menu