A built-in Excel add-in that allows users to perform optimization and equation solving, finding optimal values for decision variables subject to constraints.
Solver (Excel Add-in)
- Excel
- Data Analytics, Mathematics, Process Control, Simulation
- Design Optimization, Project Management, Simulation, Statistical Analysis
Features:
- Linear programming (LP), nonlinear programming (NLP - GRG Nonlinear, Evolutionary), integer programming (IP), goal seek, sensitivity analysis, finding maximum/minimum/specific value of a target cell by changing variable cells, defining constraints
Pricing:
- Free
- Free and readily available in Excel, useful for solving a variety of optimization problems, simple interface for basic problems, good for introductory operations research and what-if analysis.
- Limited capabilities for very large or complex optimization problems compared to dedicated solvers (e.g., Gurobi, CPLEX, or Frontline Solvers), NLP solvers have limitations, user interface can be clunky for many constraints.
Best for:
- Excel users needing to solve optimization problems, from simple equation solving to more complex linear and nonlinear programming tasks, without needing external software.