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 :
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.
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
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
Do you already have Oracle Crystal Ball and want to tackle the next generation of problems?
The Crystal Ball Decision Optimizer upgrade provides users with both industry-leading optimization using OptQuest and unparalleled speed (PSI). OptQuest is an optimization tool that runs with Crystal Ball as an add-in and enhances simulation models by automatically searching for and finding optimal solutions.
The DecisionTools Suite Industrial includes @RISK for Monte Carlo simulation, PrecisionTree for decision trees, and TopRank for “what if” sensitivity analysis. In addition, the DecisionTools Suite comes with StatTools for statistical analysis and forecasting, NeuralTools for predictive neural networks, and Evolver and RISKOptimizer for optimization.
Risk Simulator is the most complete simulation and stats package for MS Excel. It includes all 6 modules (Simulation, Forecasting, Optimization, Analytical Tools and BizStats) This is a must try add-in for those who need that extra depth and function
@RISK performs risk analysis using Monte Carlo simulation to show you many possible outcomes in your Microsoft Excel spreadsheet—and tells you how likely they are to occur. New in version 8 is the ability to build efficient frontiers, use copulas and a host of usability enhancements.
The DecisionTools Suite is an integrated set of programs for risk analysis and decision making under uncertainty that runs in Microsoft Excel. The DecisionTools Suite includes @RISK for Monte Carlo simulation, PrecisionTree for decision trees, and TopRank for “what if” sensitivity analysis. In addition, the DecisionTools Suite comes with StatTools for statistical analysis and forecasting, NeuralTools for predictive neural networks, and Evolver and RISKOptimizer for optimization. All programs work together better than ever before, and all integrate completely with Microsoft Excel for ease of use and maximum flexibility.
Build your own risk analysis package with Risk Simulator 2012- Your Edition. Risk simulator is a complete simulation tool for Excel that enables you to add the features you need and want. Check out the modules below.