MS Office Tools

 

Modeling

Others

Finance

 
MODEL ADVISOR Business Software for Everyone  
Why Buy with Us
Check Out
 
Advanced Search
 




Related Sponsors
 
  Evolver    

Price:

850.00

FREE Trial Buy Now
What is this Product?

Evolver is the genetic algorithm optimization add-in for Microsoft Excel. Evolver uses innovative genetic algorithm (GA) technology to quickly solve optimization 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 previously unsolvable, complex nonlinear problems. Evolver’s genetic algorithms arrive at the best overall “global” solution to a problem—solutions traditional solvers typically miss.

New Evolver 5.7 Is fully compatible with 64-bit Excel 2010. 64-bit technology enables Excel and Evolver to access much more computer memory than ever before. This allows for vastly larger models and greater computational power.

See what is new in 5.7

Buy Evolver in order to get benefits and guarantee

Excel Ease of Use
Evolver is a true add-in to Microsoft Excel, integrating completely with your spreadsheet. Define your models, adjust your settings, run optimizations, monitor progress, and generate reports – while never leaving Excel. Streamlined dialog boxes mean fewer open windows to navigate.

Why Evolver?
Standard optimization programs such as Excel’s Solver are good at finding the best “local” solution, or combination of values to maximize or minimize the outcome of a straightforward spreadsheet model given certain constraints. They find a solution which seems to be producing favorable results and continue to work on that basis, without trying new solutions. This is known as “hill climbing.” However, these programs are not set up to handle more complicated, nonlinear problems where the best local solution may not be the best absolute answer. Evolver, using innovative “mutations” and combinations of solutions, or “organisms,” is well-suited to finding the best overall answer by exploring the entire universe of possible answers.

Optimization 1-2-3
Using Evolver involves three simple steps:

1. Set Up Your Model.
The Evolver Model window provides one-stop setup for all optimization problems. Here you specify the target cell, identify cells to adjust, and define constraints. Adjustable cells and constraints support cell ranges for easy setup and changes, while target cells can be maximized, minimized, or approach a specific goal.

Defining Ranges and Stopping Conditions
When defining adjustable cells, you can specify the maximum and minimum boundaries of ranges of cells directly in Excel, greatly simplifying setup and making changes easy. For example, you can tell Evolver to adjust cells B1:B5, with a minimum value for each in A1:A5, and a maximum value for each in C1:C5. Multiple groups of cells may be specified, with multiple ranges in each group.

You must also define constraints in your model. For example, there may be limited resources which must be modeled. When defining constraints (hard or soft), you can also specify minimums and maximums with cell ranges.

Finally, set stopping conditions for your optimization, telling Evolver when to stop the optimization.

Solving Methods
Evolver uses six different solving methods that you can specify to find the optimal combination of adjustable cells. Different methods are used to solve different types of problems. The six methods are:

  • Recipe - a set of variables which can change independently.
  • Grouping - a collection of elements to be placed into groups.
  • Order - an ordered list of elements.
  • Budget - recipe algorithm, but total is kept constant.
  • Project - order algorithm, but some elements precede others.
  • Schedule - group algorithm, but assign elements to blocks of time while meeting constraints.

Evolver also allows a great degree of control over how it performs the optimization itself. You can set optimization parameters, runtime settings, control macros and more in the Evolver Settings dialog.

2. Run the Optimization.
Click the Start icon to start the optimization. Evolver will start generating trial solutions in an effort to achieve the target set in Step 1. The summary Evolver Progress window appears, showing optimization status and best answer achieved thus far. This window lets you pause, stop, and run the optimization using playback controls. You can also monitor progress in detail with the Evolver Watcher. Tabbed reports show real-time updates on best answers achieved, all solutions tried, the diversity of solutions being tried, and more.

How Evolver Works
During an optimization, Evolver generates a number of trial solutions and uses genetic algorithms to continually improve results of each trial. Each possible solution becomes an independent "organism" that can "breed" with other organisms. The spreadsheet model acts as an environment for the organisms, determining which are "fit" enough to survive based on their results. Here is a brief description of the process:

  1. Randomly generate many organisms (possible solutions), and calculate the result each organism produces. This entire "population" of organisms is ranked from best to worst.
  2. Select good organisms and swap their variables ("genes") using "crossover" and "mutation" to produce "offspring". If offspring do not produce a good result, two more parents are selected.
  3. If the offspring organism is good, it is re-inserted into the population.
    As Evolver repeats steps 2 and 3, the population "evolves" increasingly optimal solutions.

Get Results Fast
Evolver uses genetic operators to generate trial solutions that move toward an optimal solution as quickly as possible. Genetic algorithms search the entire solution space, finding the global solution and zeroing in on it.

3. View Optimization Results.
After optimization, Evolver can display the results of the original, best, and last solution on your entire model, updating it with each scenario in a single click. This makes it easy to decide the best course of action. You can also generate reports directly in Excel for an optimization summary, log of all simulations, and log of progress steps.

 

Features
Screenshots

Click to enlarge

Support
Palisade
Versions

Two Editions to Meet Your Needs 
Evolver is available in Professional and Industrial editions. The Professional edition allows up to 250 adjustable variables per model, while the Industrial edition allows unlimited variables. Use Evolver Industrial for your largest models where you can control hundreds or thousands of adjustable cells.

Evolver is available in Professional and Industrial editions. The Professional edition allows up to 250 adjustable variables per model, while the Industrial edition allows unlimited variables. Use Evolver Industrial for your largest models where you can control hundreds or thousands of adjustable cells.

Evolver Developer's Kit Also Available
The Evolver Developer’s Kit (EDK) allows developers to add the power of Evolver to their custom Windows applications. The EDK can be used by any Windows programming environment that can access Dynamic Link Libraries (DLLs), such as Visual Basic, C++, Delphi and more. The EDK gives programmers access to Evolver’s powerful GA technology and allows them to use Evolver where they need it instead of linking to Excel. Programs developed with the EDK can run faster than similar models designed in Excel. EDK users can also develop new solving methods that can be accessed by Evolver. The EDK comes with complete documentation and examples in Visual Basic and Visual C++. Contact your Palisade Sales Representative for more information on the EDK and on distributing EDK-developed programs.

Compatibility: Compatible with PC Excel 2000 and higher and PC Windows 2000 and higher.

Technical Support: Personalized technical support is free with a current maintenance plan. Contact more details to sales@palisade.com

If you want 5 or more licenses, you will receive a special discount. Please contact to sales@modeladvisor.com for more details.

Guarantee

You can download a 10 days FREE trial version to test if it will suit your needs.
FREE Trial

System Requirements
  • Minimum Platform: IBM PC compatible Pentium-equivalent or higher, 16MB RAM, Windows 98, NT 4.0, Windows 2000, Windows XP.
  • Recommended: 32 MB RAM, or greater.
  • Spreadsheet: Windows Excel 97 or higher.

100% Excel
Evolver optimizations are calculated 100% within Excel, supported by Palisade sampling and statistics proven in over twenty years of use. Palisade does not attempt to rewrite Excel in an external recalculator to gain speed. A single recalculation from an unsupported or poorly reproduced macro or function can dramatically change your results. Where will it occur, and when? Get correct results using Evolver!

Shipping

Palisade products not include shipment charges. When you buy this product using Model Advisor shopping cart, you will receive an e-mail indicating the procedures to pay the shipment charges. For more information please send an e-mail to sales@modeladvisor.com

  • Shipping in the US and Canada is $10 for the first item, $5 for each additional.
  • International shipping is $50 for the first item, $10 for each additional.
Prices
   
Product With 12 months maintenance ORDER NOW!!
Evolver 5.7 Professional US$850.00 Buy Now
Evolver 5.7 Industrial US$1195.00 Buy Now

These prices are corresponding to the downloading version. The prices for products in CD are $25 higher.

WARNING, take into account that if you are not USA's resident, you should contact us to: sales@jabsoft.com in order to obtain a applicable quotation for you.

Related Sponsors
 
Our Sponsors





Related Sponsors
 

 
Help, Comments, Suggestions? Tell Us at: webmaster@modeladvisor.com

©2003-2012 MODEL ADVISOR is a registered trademark of JABS All rights reserved.
Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation.