Optimization is a process for making something (as a design, system, or decision) as fully perfect, functional, or effective as possible using mathematical procedures such as as finding the maximum of a function or solve problems like :
The best allocation of your limited resources to maximize your profits?
The most efficient schedule to minimize costs?
The most efficient remediation strategy to minimize environmental damage?
Which projects should we be funding this year?
This category of tools and add-ins enable you to solve tough problems with ease... all within the familiar Excel environment. Of all the tools you can combine with simulation, optimization is the one with the biggest bang for the buck.
Analytica Optimizer is the highest edition level of Analytica. In includes all Enterprise features, plus the addition of powerful solver engines.It discovers decision values that minimize or maximize any quantified objective, subject to constraints.Designed with advanced simulation, modeling and optimization capabilities in mind, it allows for powerful decision modeling an analytics. Using a visual modeling approach you can design your own models as well as applications that can be shared with your peers.
Oracle Crystal Ball is the easiest way to perform Monte Carlo simulations in your own Excel spreadsheets and models. Crystal Ball automatically calculates thousands of different "what if" cases, revealing the range of possible outcomes, their probability
Evolver is an advanced, yet simple-to-use optimization add-in for Microsoft Excel. Evolver uses innovative genetic algorithm (GA), OptQuest, and linear programming technology to quickly solve 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 otherwise unsolvable, complex nonlinear problems. Evolver has a unique ability arrive at the best overall “global” solution to a problem—solutions traditional solvers typically miss.
ModelRisk Industrial is an Excel-based risk analysis, simulation and optimization tool that allows users to build dynamic business and finance models / applications that incorporate advanced risk analysis techniques and live data using data-objects. Includes Data Objects, Application Developer Kit, Advanced Finance and Insurance Functions, 1st year maintenance & OptQuest Optimization
SimWrapperTM is a GUI based version of the popular optimization package OptQuest. It easily integrates with your simulation models (in R, Python, Matlab, Julia,...) and provides an intuitive user interface for simulation, optimization and analysis.
SimWrapperTM is a GUI based version of the popular optimization package OptQuest. It easily integrates with your simulation models (in R, Python, Matlab, Julia,...) and provides an intuitive user interface for simulation, optimization and analysis. .