App Icon
Frontline Systems Inc.
•  74,918
Overview
Solve resource allocation problems with linear and mixed-integer programming, nonlinear optimization, and evolutionary algorithms.
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
Language:
Sort by:
Profile Picture
Georg Israel
January 21, 2021
I tried it, but it keeps failing with the message that it can not access the file This is the message that I keep seeing: Solver Exception: GoogleJsonResponseException: API call to drive.files.get failed with error: File not found: 1IYfMWAC3q3BP-MH9n8czIJMI6R13KFs-
Is this review helpful?
Yes
No
Profile Picture
Mert Oguz
January 3, 2021
I have tried same example on both Google Sheets and MS Excel. It did run fine on Excel, with 0.6sec result time while it kept on running optimization..." for 3 hours on Google Sheets without any result in the end.
Is this review helpful?
Yes
No
Profile Picture
Christopher Walkden
December 25, 2020
Works well for me, with the particular problem I needed to solve.
Is this review helpful?
Yes
No
Profile Picture
Mario Trabucco della Torretta
December 24, 2020
It doesn't appear to work, maybe the connection to the Solver server is not what it needs to be
Is this review helpful?
Yes
No
Profile Picture
David Johnk
December 17, 2020
Didn't work with a simple problem I could have easily solved on Excel Solver.
Is this review helpful?
Yes
No
Profile Picture
Max
November 24, 2020
One day out of the blue the number of variables available was cut in half from 200 to 100. I should be looking for other options.
Is this review helpful?
Yes
No
Profile Picture
Oliver Cairns
November 19, 2020
very helpful!
Is this review helpful?
Yes
No
Profile Picture
Norman Castiello
November 13, 2020
Doesn't work on Google Sheets. I'm getting constant error messages. I don't get why there has to be limits at all. If your a sports bettor like me, we can't have limits....
Is this review helpful?
Yes
No
Profile Picture
Les Purkhardt
November 7, 2020
does not seem to work
Is this review helpful?
Yes
No
Profile Picture
Henry Alexander Vaquiro Herrera
October 21, 2020
It doesn't work
Is this review helpful?
Yes
No
1-10 of 84
Additional information
Frontline Systems Inc.
Terms of Service
Search
Clear search
Close search
Google apps
Main menu