Frontline Systems Inc.
•  45,194
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
A User of Solver
July 11, 2020
Not working today
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
July 11, 2020
Would be great if it actually worked. Clicking "solve" even on the provided example returns a cryptic error message and fails.
Is this review helpful?
Yes
No
Profile Picture
Deborah Fassi
June 18, 2020
Does the job. Works. Cannot scale.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
June 8, 2020
Works OK, but the server it connects to has been down since June 7, 2020.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
April 29, 2020
This add-on gives negative values even with "Assume non-negative" tick. Just not working as it's supposed to.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
April 27, 2020
Currently not functioning as it is supposed to
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
April 20, 2020
It worked, and then it stopped working. Creating __Solver__ Conflict sheets. I deleted the conflict ones. It looks like it should be working again, but it gives an error that previously worked fine. I can't help but feel something changed in the back end (of either my sheet or their solver). Saying the PSI interpreter failed... something something
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
April 9, 2020
Useless, especially when compared to the solver add-on in ordinary Excel. Fails to converge problems with two parameters, sometimes even ignoring constraints.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
April 2, 2020
On excel the solver tool works 10000 times better. It is able to run when its simple. But when it's complex and difficult (which is why I am using the solver tool) it does nothing.
Is this review helpful?
Yes
No
Profile Picture
A User of Solver
March 31, 2020
This solver add-on is NOTHING like what is shown on the advertisement overview pictures. I needed to use "simplex lp" and that is not even an option on the add-on. Lastly, when I clicked "solve" to get the report nothing happened at all. What is the purpose of a "solver add-on" when it does not work???
Is this review helpful?
Yes
No
1-10 of 70
Additional information
Frontline Systems Inc.
Terms of Service
Search
Clear search
Close search
Google apps
Main menu