App Icon
Frontline Systems Inc.
•  
127,236
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
Alexander Albinus
June 7, 2021
Despite the harsh reviews, I've tried it and it solved my optimization problem quickly.
Is this review helpful?
Yes
No
Profile Picture
Johnny Yip
April 20, 2021
This doesn't work in Google Sheets, as mentioned by others. I tried the same simple scenario (same set up, same formulae, same parameters) in both MS Excel and Google Sheets and run Solver on both. MS Excel returned the solution I expected, whereas Google Sheets simply say the value does not converge, which is not true. OpenSolver seems to do a MUCH better job!!
Is this review helpful?
Yes
No
Profile Picture
Pradip Thakar
March 16, 2021
Just waste of time, does not work for simple calculations. Takes 10 times more time than solver in ms excel
Is this review helpful?
Yes
No
Profile Picture
Soumi Samanta
March 12, 2021
I am not able to view the 'Add-ons' tab in Google sheets. I have installed Solver add-on but not able to use it.
Is this review helpful?
Yes
No
Profile Picture
Jik Lee
February 20, 2021
Absolutely useless. Even copied their example sheet, changed the cells, different error messages each time. Half an hour of my life I can't get back. I even re-installed the app just to leave this review. Just to be fair to the app, I redid the problem on Microsoft Excel with its in-built Solver app. Gave me a solution within seconds. This one still insists that "Problem could not be loaded. No model defined".
Is this review helpful?
Yes
No
Profile Picture
Alan Gonzalez
February 20, 2021
Keeps resetting my parameters. I'm unable to use the solver add-on! Had been working fine until 2 days ago.
Is this review helpful?
Yes
No
Profile Picture
Alec Szwarcewicz
February 16, 2021
Very poor app
Is this review helpful?
Yes
No
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
1-10 of 89
Additional information
Frontline Systems Inc.
Terms of Service
Search
Clear search
Close search
Google apps
Main menu