Meta-Heuristic solvers are about finding good decision values for complex models.
Meta-Heuristic Solvers have proven to be valuable in business practice. They usually provide an answer, often the best answer or a very useful answer. However, these solvers have the strange property that it's not clear how good the answer is, nor how long one should let the solver run. Some authorities recommend trying an Optimization Solver first, and if it is unsatisfactory, then try a Meta-Heuristic Solver. (Some of the commercial solvers will even make this choice for you!)
Premium Solver, Premium Solver Platform, RiskSolver Platformby Frontline Systems
'Evolutionary/Classical Solver uses genetic algorithm methods such as mutation, crossover, selection and constraint repair, but it also uses deterministic, gradient-free direct search methods, classical gradient-based quasi-Newton methods, and even the Simplex method for linear subsets of the constraints. The classical methods sometimes yield rapid local improvement of a trial solution, and they also help to solve for sets of constraints. This enables the hybrid Evolutionary / Classical Solver to handle problems with many constraints, which are typically beyond the capabilities of genetic and evolutionary algorithms alone.”
OpenSolver uses the COIN-OR CBC optimization engine. Welcome to OpenSolver, the Open Source linear, integer and non-linear optimizer for Microsoft Excel. The latest stable version, OpenSolver 2.9.3 (1 Mar 2020) is available for download; this adds support for using Gurobi 9.0 as a solver. OpenSolver 2.9.4 Beta Release version is now also available for download. To add Solver to your Excel, perform the following steps: In Excel 2010, Excel 2013, Excel 2016, and Excel 2019, click File Options. In Excel 2007, click the Microsoft Office button, and then click Excel Options. In the Excel Options dialog, click Add-Ins on the left sidebar, make sure Excel Add-ins is selected in the Manage box at the bottom.
“The OptQuest Solver Engine uses tabu search and scatter search to solve nonsmooth optimization problems. It handles integer variables and the alldifferent constraint (i.e. permutations of sets of variables) as native types. ….”
“Evolveris the genetic algorithm optimization add-in for Microsoft Excel. Evolver uses innovative genetic algorithm (GA) technology to quickly solve optimization problems in finance, distribution, scheduling, resource allocation, manufacturing, budgeting, engineering, and more. Virtually any type of problem that can be modeled in Excel can be solved by Evolver, including previously unsolvable, complex nonlinear problems. “
“Generatoremploys all of the basic evolutionary processes: crossover, mutation, and natural selection. What distinguishes Generator from other commercial genetic algorithm software is that in Generator, users can fine-tune these parameters on the fly. In addition, Generator has special hill climbing features, recombination operators and mate selection processes to rapidly find the best solution.”
'OptWorks: Excel software is a non-gradient optimization add-in for Microsoft Excel designed to solve complex optimization problems including financial analysis, logistics management, engineering, scientific analysis, and strategic investment planning. With a suite of eight non-gradient algorithms to choose from, you can rapidly attain optimal solutions for Excel-based problems with OptWorks.'
Premium Solver Excel
Solve XLby Diapason Consulting
“SolveXLis an add-in for Microsoft Excel which uses evolutionary algorithms to solve complex optimization problems. A user friendly Wizard with built-in help allows users to configure the tool easily and to perform optimizations. SolveXL goes much further than many other commercial products of this type and implements many types of single and multiple-objective genetic algorithms. Features: Single and multiple-objective optimization techniques; Support for integration with simulation packages; Suspend, resume and browse optimization interactively; Multiple-objective results browser; Batch runs; User defined constraints & penalty multipliers; Automatic saving of population; Backups of intermediate population; Graphical UI; Visualization of results and progress; Automation using VBA code.”
GANetXLby University of Exeter
“GANetXL is an optimisation add-in for Microsoft Excel. GANetXL uses genetic algorithms to solve complex optimisation and search problems. The application offers a user friendly interface to set up the optimisation problem and configure the algorithm. Unlike many other commercial products GANetXL allows solving single and multiple-objective optimisation problems. The software is provided FREE of charge for academic non-commercial research.”
“SolveXLis an add-in for Microsoft Excel which uses evolutionary algorithms to solve complex optimization problems. A user friendly Wizard with built-in help allows users to configure the tool easily and to perform optimizations. SolveXL goes much further than many other commercial products of this type and implements many types of single and multiple-objective genetic algorithms. Features: Single and multiple-objective optimization techniques; Support for integration with simulation packages; Suspend, resume and browse optimization interactively; Multiple-objective results browser; Batch runs; User defined constraints & penalty multipliers; Automatic saving of population; Backups of intermediate population; Graphical UI; Visualization of results and progress; Automation using VBA code.”
GANetXLby University of Exeter
“GANetXL is an optimisation add-in for Microsoft Excel. GANetXL uses genetic algorithms to solve complex optimisation and search problems. The application offers a user friendly interface to set up the optimisation problem and configure the algorithm. Unlike many other commercial products GANetXL allows solving single and multiple-objective optimisation problems. The software is provided FREE of charge for academic non-commercial research.”
Frontline Excel Premium Solver Crack Free
Editor’s Note: This seems to be a non-commercial version of SolveXL.
Frontline Systems Solver
“GeneHunter is a powerful software solution for optimization problems which utilizes a state-of-the-art genetic algorithm methodology. GeneHunter includes an Excel Add-In which allows the user to run an optimization problem from Microsoft Excel, as well as a Dynamic Link Library of genetic algorithm functions that may be called from programming languages such as Microsoft® Visual Basic or C.”