2001SensitTreeplan

2001SensitTreeplan - Notes on Sensit and Treeplan EXCEL...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Notes on Sensit and Treeplan E XCEL R EVIEW 2001-2002
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Contents Page SensIt What is SensIt?. ............................................................................................. 1 Running SensIt. ............................................................................................. 1 SensIt’s Plot Command. ................................................................................ 1 The finance.xls Sample Spreadsheet. ............................................................ 3 SensIt’s Tornado Command. ......................................................................... 4 The Tornado Results Spreadsheet. ................................................................ 6 TreePlan What is Treeplan?. ......................................................................................... 7 How to Get Treeplan. .................................................................................... 7 Running TreePlan. ......................................................................................... 7 How to: ±² Build up a tree . ............................................................................ 8 ±² Change tree labels . ...................................................................... 8 ±² Modify a tree’s structure . ............................................................ 8 TreePlan’s Dialog Boxes. .............................................................................. 9 The Copy subtree Command. ........................................................................ 10 Formatting. .................................................................................................... 10 Anatomy of a Decision Tree . ........................................................................ 10 Solving Trees. ................................................................................................ 11 Controlling Calculations . .............................................................................. 11 TreePlan’s Online Help. ................................................................................ 12 The TreePlan Online Help File . .................................................................... 13
Background image of page 2
1 SENSIT What is SensIt? SensIt is an Excel add-in that makes it easy to do sensitivity analysis inside an Excel spreadsheet. SensIt is written as an Excel macro. It was written by Mike Middleton of the University of San Francisco and Jim Smith of Duke University. Download a copy of SensIt from either of these URLs: http://ourworld.compuserve.com/homepages/decision/ http://faculty.fuqua.duke.edu/~pecklund/excelreview/ExcelReview.htm Running SensIt To run SensIt, load the sensit.xla file after starting Excel. When prompted, agree to run the SensIt macros. After SensIt loads you’ll see two new commands at the bottom of the Tools menu: Plot and Tornado. We’ll describe these two commands using the spreadsheet model finance.xls as an example. The finance.xls spreadsheet is also available for download from Fuqua’s web site. This spreadsheet is used to perform a risk analysis in support of a new product launch decision. The outlined cells are “inputs” that refer to values in the upper left corner of the spreadsheet. SensIt’s Plot Command Use SensIt’s Plot command to examine the sensitivity of a single variable. In the example, one might be interested to see how “Volume w/Entry” affects “NPV”. To do this, choose Tools, Plot (or, as a shortcut, hold down the Control key and hit the p key). The Plot dialog displays. When you click the OK button in SensIt’s Plot dialog, SensIt varies the value of the input variable you identified across the range you specified. It records the corresponding result values in the specified output cell. In this example, the program sets cell $C$5 to 1000 and records the value in cell $C$45. It then repeats this process 10 times for input values of 1400, 1800, 2200, …, 5000. When done, SensIt Put cell references in these fields. Either type them in or point to the cell on the spreadsheet while the cursor is in a field. Type numeric values in these fields. The value in the “Steps” field must be an integer.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 produces a spreadsheet (separate from the original) that lists and plots the results (see below). The labels of the input and output variables are taken from cells $B5 and $B45, respectively. A copy of the finance.xls spreadsheet follows.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 21

2001SensitTreeplan - Notes on Sensit and Treeplan EXCEL...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online