Palisade Corporation
@RISK Helps Keep Endangered Fish from 

@RISK Helps Keep Endangered Fish
from Extinction

The Devils Hole pupfish (Cyprinodon diabolis) is one of the world’s most endangered animals. There is only one wild population living in a single aquifer-fed thermal pool in Nye County, Nevada, and has been perched on the brink of extinction with a population of only 35 to 68 fish in 2013. A major strategy for conserving the pupfish has been to create additional captive populations, but scientists needed to know how to best extract wild pupfish for breeding purposes without unduly accelerating the extinction risk for the population in Devils Hole. Dr. Steven Beissinger, Professor of Conservation Biology at the University of California, Berkeley, constructed a population variability analysis (PVA) using @RISK to better inform this dilemma.

Dr. Beissinger first created models for extinction risk in the wild for the pupfish, which showed that most simulated populations of the pupfish became extinct within 50 years. Median and mean time to extinction were 26 and 27 years, and 17 and 22 years, respectively. Next, to evaluate the effects of different strategies for removing individuals to initiate a captive breeding program on the wild population, Dr. Beissinger modeled the effects of removing different numbers of individuals (0–14) at the start of each simulated year.

Dr. Beissinger then wanted to answer the question of which life-stage should pupfish be harvested. The model showed that removing pupfish eggs had the least effect on the wild population. Indeed, Dr. Beissinger calculated that removing 25 eggs for captive breeding is equivalent to removing a single adult in terms of its influence on population dynamics.

This modeling work has helped to inform decisions made by the U.S. Fish and Wildlife Service to conserve the Devils Hole pupfish, which has now begun to remove pupfish eggs from Devils Hole to start a captive population in its state-of-the-art breeding facility. “The modeling helped everyone to see what some of the trade-offs would be and made the various outcomes more explicit,” says Dr. Beissinger.

Dr. Beissinger uses @RISK for both research and teaching, and finds it to be a valuable tool: “@RISK makes Monte Carlo processes easy for professionals and students to understand,” he says. “The nice thing about it, from my perspective, is that it functions within Excel, which makes visualizing the information a lot easier and more intuitive for people. It makes what would otherwise be a lot of tedious steps a lot easier to do.”

 » Read the full case study  

Licensing Options

There are three easy ways to get the DecisionTools Suite for your students:


Course Licenses available from Palisade. These are economical, annually renewing bulk licenses for both
network lab and laptop installation. Palisade offers a complimentary Live Web Training session to all instructors who order a Course License.
» Learn more

Student Versions from Palisade. These are 12-month versions available for purchase individually by students through either the Palisade web site or the school store.
» Learn more

Textbook Editions available bundled with textbooks.
These are time- and model-limited licenses.
» Learn more

Get DecisionTools Suite 6 for your course by contacting:

AddressPalisade Academic Sales    
800-432-7475 / 607-277-8000

Teaching Tips & Examples

The DecisionTools Suite is a great way to present quantitative techniques in a straightforward, easy-to-understand way for students.

Production Planning
Excerpted from Evolver Solutions for Business,
by Roy L. Nersesian, published by Palisade Corporation

Suppose that you are responsible for production planning at a plant whose product line shows enormous variations in sales. The two key operating questions facing you are what inventory level should trigger a production run and how many should be produced. This example uses Evolver to evaluate two different situations. The first is when an order is placed once the inventory numbers reach a certain trigger point and the other is when there is one order per shipping cycle. RiskOptimizer could also be used for these same two situations. The output under Evolver is discrete whereas the output under RiskOptimizer, while also discrete, is based on probability distributions of costs and stockouts.

» Learn more and download the associated example files

Tech Tip of the Month

Combining Inputs in a Sensitivity Tornado

How can I aggregate multiple inputs in the tornado graph, so that I see the output's sensitivity to the combination instead of sensitivities to the individual inputs?

If you would like to maybe combine countries in a region, or maybe you want an NPV instead of individual cash flows, or some other situation where you would like to see a combination of sensitities, the RiskMakeInput( ) is the function that will help you do just that. If you already have a formula in your workbook that computes the aggregate you're interested in, just wrap it in a RiskMakeInput( ), like this:

=RiskMakeInput(formula, RiskName("name to appear in tornado") )

As an alternative, you could just create that formula in an empty cell.

RiskMakeInput( ) tells @RISK that its contents should be treated as an @RISK input distribution for purposes of sensitivity analysis, and RiskMakeInput( )'s precedents should be ignored in sensitivity analysis.

» Read the complete answer here
» View other Techniques and Tips here

Featured White Paper

Estimation of Mixed Traffic Densities in Congested Roads Using Monte Carlo Analysis
by Brian Freeman, Bahram Gharabaghi, and Jesse Thé, EM Magazine, April 2015

The authors use @RISK to create a novel stochastic Monte Carlo method to estimate the number and type of vehicles on a 1-km stretch congested roadway. This technique can then be linked to vehicle emission data to estimate real-time mobile source pollution on roadways due to traffic conditions. The resulting graphs of the @RISK model yielded a power curve that approximates the expected number of cars at each speed, thus giving researchers a fast, convenient tool for better understanding and estimating vehicle numbers in traffic. For Freeman, the benefit of using @RISK for this research was its efficiency. “You can quickly create a model in Excel that would otherwise require a very complicated statistical tool package to set up,” he says. “You can easily create your model without having to become an expert in statistics.”

»  Read the full article here

Palisade Corporation

The Academic Global Leader in
Risk and Decision Analysis
Palisade Corporation is the world's leading provider of risk and decision analysis software and solutions. Founded in 1984, its products @RISK and the DecisionTools Suite are used by over 95% of the Fortune 100, in nearly every industry around the world. Palisade is headquartered in New York State, and has offices in London, Sydney, Rio de Janeiro, and Tokyo.

What is The DecisionTools Suite?
The DecisionTools Suite is the world’s only integrated set of risk and decision analysis programs. The Suite includes @RISK for Monte Carlo simulation, PrecisionTree for decision trees, and TopRank for “what if” sensitivity analysis. In addition, DecisionTools Suite comes with StatTools for statistical analysis and forecasting, NeuralTools for predictive neural networks, and Evolver and RISKOptimizer for optimization. All programs work together seamlessly, and all integrate completely with Microsoft Excel for ease of use and maximum flexibility.

The Suite is offered in three affordable and flexible licensing options for those in academia: Student Versions, Course Licenses and Full Academic Versions.

» Schools using Palisade software
Textbooks using Palisade software

In This Issue

» @RISK Helps Keep
   Endangered Fish
   from Extinction

» Licensing Options

» Teaching Tips &

   Production Planning

» Tech Tip
   Combining Inputs in a
   Sensitivity Tornado

» Featured White Paper
   Estimation of Mixed Traffic
   Densities in Congested Roads
   Using Monte Carlo Analysis

» About Palisade and the
   DecisionTools Suite

Keep in Touch
Palisade CorporationPalisade CorporationPalisade CorporationPalisade Corporation

Palisade CorporationClick to chat live with
a sales representative


2014 Palisade Risk Conferences
An intensive day of networking, software training presented by Palisade trainers and consultants, and real-world case studies presented by industry experts. Join us at an event near you. More dates to come for 2015.
» Melbourne: 21 May
» Rio de Janeiro: 5 May
EMEA & India
» Mumbai: 13 January
» Johannesburg: 12 May
» Madrid: 19 May
» Munich: 18 June
» Oslo: 29 September
» Moscow: 1 October
» Zurich: 6 October
» London: 22 October
» Dubai: 2 November
North America
» Toronto: 23 June
» Chicago: 24 June
» New York: 4 August
» San Francisco: 25 August
» Calgary: 27 August
» New Orleans:
   11-12 November

» Training Seminars
Adelaide: 29-30 June
Brisbane: 14-15 July
Melbourne: 29-30 July
Perth: 18-19 August
Sydney: 1-3 September

London: 14-16 July
London: 15-17 September
Amsterdam: 6-8 October
London: 27-29 October

» Latin America
Medellin, Colombia:
  21 al 23 de julio
San José, Costa Rica:
  11 al 13 de agosto
México, DF:
  8 al 10 de septiembre
Quito, Ecuador:
  23 al 25 de septiembre

» North America
Houston, TX: 23-25 June
Denver, CO: 4-6 August
Ithaca, NY: 5-6 August
Cincinnati, OH: 11-13 August
Dallas, TX: 22-24 September


» Trade Shows
North America
Society of Petroleum Engineers / ATCE 2015
Houston, TX
28-30 September

EMEA & India
27th European Conference on Operational Research
University of Strathclyde, Glasgow
12-15 July


» Live Web Training
Decision-Making & Quantitative Risk Analysis using the DecisionTools Suite

18-19 June, 11am - 3pm ET
1-2 July, 11am - 3pm ET

Project Risk Assessment using @RISK
18-19 August

Decision-Making and Quantitative Risk Analysis using @RISK

2-3 Sept, 11am - 3pm ET
23-24 Sept, 11am - 3pm ET

Trial Versions

Palisade software is available in fully functional trial versions. Try @RISK or any of our software today!

The DecisionTools Suite
The complete risk and
decision analysis toolkit

» English
» Español
» Português
» Deutsch
» Français
» 日本語版
» 中文版
» русский

The world's most widely
used risk analysis tool
@RISK» @RISK for Excel
@RISK» For Project Management
@RISK» For Six Sigma

Visual decision analysis
for spreadsheets

Sophisticated neural networks for spreadsheets

Advanced statistical analysis for spreadsheets

The Innovative Optimizer
for Windows

Intel and the Intel logo are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.

Palisade Corporation
©2015 Palisade Corporation, visit

Palisade Corporation
798 Cascadilla Street, Ithaca, NY 14850 USA, +1 607 277 8000
Palisade Brasil
Av. Presidente Vargas 435, Sala 501, Centro, Rio de Janeiro CEP 20071-001, +55 (21) 2586-6334
Palisade Europe UK Ltd
31 The Green, West Drayton, Middlesex, UB7 7PN, UK, +44 1895 425050
Palisade Asia-Pacific Pty Limited
Suite 404, L4, 20 Loftus Street, Sydney NSW 2000 Australia, +61 2 9252 5922

Palisade Asia-Pacific, Tokyo Office
〒 150-8512 東京都渋谷区桜丘町 26-1 セルリアンタワー15F 電話 03-5456-5287