Differential Evolution: A Tool for Global Optimization
File(s)0-DEv1.1_AddIn.xlsm (190.14 KB) 1-Example_DEv1.1.xlsx (164.27 KB)
Differential Evolution Add-in
Differential Evolution Example
Permanent Link(s)
Collections
Author
Ukhov, Andrey D.
Abstract
This report describes a tool for global optimization that implements the Differential Evolution optimization algorithm as a new Excel add-in. The tool takes a step beyond Excel’s Solver add-in, because Solver often returns a local minimum, that is, a minimum that is less than or equal to nearby points, while Differential Evolution solves for the global minimum, which includes all feasible points. Despite complex underlying mathematics, the tool is relatively easy to use, and can be applied to practical optimization problems, such as establishing pricing and awards in a hotel loyalty program. The report demonstrates an example of how to develop an optimum approach to that problem.
Date Issued
2016-10-20
Rights
Required Publisher Statement: © Cornell University. Reprinted with permission. All rights reserved.
Type
article