Live Chat
Pair of Add-ins Extends Excel's Scope
RISKOptimizer Clarifies Uncertain Choices
By Peter Coffee
PC Week
March 22, 1999

PCWeek Online
Reviewed in
PCWeek Labs Review
March 1999

» Why Plain Old
Spreadsheets Are
Not Enough

Review Excerpts

RISKOptimizer, released last month, will feel familiar to anyone experienced with Palisade's long-established @RISK (the product that practically invented the genre of uncertainty modeling add-ins when Lotus 1-2-3 was on almost every PC). To develop an uncertainty-based model, we entered formulas using Palisade's probabilistic functions such as RiskNormal (for a Gaussian normal bell curve) with additional parameters such as mean and standard deviation.

Stands firmly on uncertain ground

To perform uncertainty-based optimization with RISKOptimizer, we had to define a fitness function: a formula in our spreadsheet that RISKOptimizer could use as a measure of success, either by maximizing (as with an income) or minimizing (as with a cost).

Importantly, however, RISKOptimizer also gave us the option of looking at fitness-function statistics from several trials so that we could, for example, seek a combination of values that produced the most consistent possible result (by minimizing the fitness function's variance or standard deviation).

It was easy to include common-sense considerations such as values that could only be integers. With a formula such as =ROUND(RiskTriang(3,7,15),0), we could concisely describe a quantity that is never less than 3, never more than 15, probably close to 7 and unable to have a fractional value. RISKOptimizer also capitalized on other Excel capabilities, for example by letting us execute named macros at selected times (such as at the end of an optimization process, enabling us to automate report generation).

Excel's Visual Basic for Applications can be used to control RISKOptimizer's own large vocabulary of macro commands. A custom application developer should be able to hide RISKOptimizer behind a custom-built front end, using high-level user input to construct and execute a corresponding model.

An interactive tutorial walked us through a representative RISKOptimizer problem, presenting a realistic decision-making situation involving the overbooking of an airline flight. This clarified options and procedures that could otherwise be opaque to anyone but an operations research specialist.


Executive Summary: RISKOptimizer 1.0

RISKOptimizer 1.0, Palisade's add-in for Microsoft's Excel, works with uncertain quantities and offers an exceptional variety of optimization criteria while sharing the easily documented modeling format familiar to users of Palisade's @RISK.

USABILITY A
CAPABILITY A
PERFORMANCE B
INTEROPERABILITY B
MANAGEABILITY A

+ Formula-based notation makes all assumptions apparent; interactive tutorial clarifies many topics that will be new to most users.

- Interactive tutorial falls short in explaining underlying genetic optimization algorithm.

Related Article in the March 1999 PCWeek:
» Why Plain Old Spreadsheets Are Not Enough

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