Find the Best Solutions to any Optimization Problem
Wouldn't you like to know the best allocation of your limited resources to maximize your profits? Or the most efficient schedule to minimize costs? Or the most efficient remediation strategy to minimize environmental damage?
With Evolver, you can tackle tough problems like these, and much more. Evolver is an advanced, yet simple-to-use optimization add-in for Microsoft Excel. Evolver uses innovative genetic algorithm (GA), OptQuest (Industrial edition only), 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.
New in Version 7 Industrial Edition: Efficient Frontier Analysis
Efficient frontier analysis is very common in financial modeling, particularly in the area of portfolio optimization. An efficient frontier is a graph mapping out the optimal return for any risk level one is willing to accept.
For each acceptable risk level you specify, Evolver performs an optimization. In a financial portfolio, we are optimizing the expected return by changing the various allocations of investment funds. The risk level is a constraint that we vary across a range of possible values. The resulting efficient frontier is a 2-dimensional graphical representation of many optimization results. With efficient frontiers, you can greatly enhance the performance of any portfolio.
The efficient frontier feature is also applicable outside the field of portfolio optimization: it can be used whenever you want to perform many optimizations fast in order to analyze tradeoffs between two quantities in an optimization problem.