About Evolver
The Evolver add-in enables finding optimal solutions to virtually any type of deterministic problem, that is, any problem that doesn’t include explicit uncertainty. Simply put, Evolver finds the best inputs for optimizing a specified output. Evolver can be used to find the right mix, ordering, or grouping of variables that produces the highest profit, the lowest cost, the shortest project completion time, the lowest risk, and so on. Evolver can be utilized in Excel by first setting up a typical spreadsheet model and then evoking Evolver to find an optimal solution.
Excel provides all of the formulas, functions, graphs, and macro capabilities that most users need to create realistic models of their problems. Evolver provides the interface to describe what needs to be optimized, and it provides the engines to perform the optimization. Together, they can find optimal solutions to virtually any problem that can be modeled.