Solver (iennicjichkeiajiflbcmaaohildohpb): Solve resource allocation problems with linear and mixed-integer programming, nonlinear optimization, and evolutionary algorithms.... Read More > or Download Now >
Solver for Google Sheets
Tech Specs
- • Type: Google Sheets Add-on
- • Latest Version: 22
- • Price: Freeware
- • Offline: No
- • Developer: Frontline Systems Inc.
User Reviews
- • Rating Average
- 2.1 out of 5
- • Rating Users
- 333
Download Count
- • Total Downloads
- 24
- • Current Version Downloads
- 24
- • Updated: July 17, 2019
Solver is a free Business Tools Add-on for Google Sheets. You could download the latest version crx file or old version crx files and install it.
More About Solver
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.