Live Chat
Evolver Answers Questions That Excel Can't
By Charles Seiter
PCWorld
November 1998
Reviewed in

Nov 1998

Microsoft Excel can’t do everything. If you’re dealing with what-if situations in production scheduling, workflow, logistics, and financial modeling, you need more sophisticated tools. Excel’s built-in Solver can handle some assignments, such as trying to optimize profits across a product line, but it’s generally limited to situations with smoothly varying quantities- --expects you to accept answers like "3.7 trucks" in shipping problems.

On the other hand, Evolver 4.0, a $395 Excel add-on from Palisade, is well suited to handling optimization in many real-world problems where the basic information involves many variables, as in shipping and manufacturing. I tested a shipping version.

Evolver implements a genetic algorithm. The optimizer generates a batch of random inputs as variables for the problem. Then it checks the results that the variables produce, keeps the variables that yield the best results, and creates a new generation of inputs by mixing components of surviving variables. Also, Evolver works impressively fast on big problems (with up to 80 variables). Check this program out if you’ve outgrown Solver

EVOLVER 4.0
PRO: Fast, sophisticated analysis tool for use with Excel.
CON: None significant
VALUE: Excellent choice for complex profit-optimizing

For more information, contact:

Randy Heffernan
Tel: 607-277-8000
Fax: 607-277-8001
rheffernan@palisade.com
Palisade Corporation
798 Cascadilla Street
Ithaca, NY 14850-3239
800 432 RISK (US/Can)
+1 607 277 8000
+1 607 277 8001 fax
sales@palisade.com
Palisade EMEA & India
+44 1895 425050 salesEMEA@palisade.com
salesIndia@palisade.com
Palisade Asia-Pacific
+61 2 9252 5922
salesAP@palisade.com
Palisade アジア・
パシフィック東京事務所
+81 3 5456 5287 tel
sales.jp@palisade.com
www.palisade.com/jp/
Palisade Latinoamérica
+1 607 277 8000 x318
+54-1152528795  Argentina
+56-25813492 Chile
+507-8365675 Panamá
+52 55 5350 2852 México
+511-7086781 Perú
+57-15085187 Colombia
servicioalcliente@palisade.com
ventas@palisade.com
www.palisade-lta.com
Palisade Brasil
+55 (21) 3958 1443
+1 607 277 8000 x318 tel
vendas@palisade.com
www.palisade-br.com