{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Module1","Sheet1"],"not_rendered":{"charts":1,"macros":1},"unopened":[{"sheet":"Module1","index":0,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":1,"n_rows":34,"n_cols":4,"rows_kept":34,"flags":["formulas_cached_only"]}
["When this workbook (TORNDIAG.XLS) is open, you can make a tornado diagram"]
["in any workbook by the menu command sequence Tools>TornadoDiagram."]
[]
["The TornadoDiagram procedure will ask you to specify six ranges in your workbook:"]
["(1) A single cell containing output for sensitivity analysis in the tornado diagram."]
["(2) A range of parameter cells, in one column, that affect this output cell."]
["     The values of these parameter cells should be your best estimates of these parameters."]
["(3) A range, the same size as (2), containing labels for these parameters."]
["(4) A range, the same size as (2), containing low alternative values for these parameters."]
["(5) A range, the same size as (2), containing high alternative values for these parameters."]
["(6) An empty range, with 4 columns and one more row than (2), to store data for the tornado diagram."]
["     In this data range, the TornadoDiagram procedure will write:"]
["     a label for each parameter in column 1,"]
["     the output cell value when the parameter is at its low value (with others at best estimate) in column 2,"]
["     the output cell value when the parameter is at its high value (with others at best estimate) in column 3,"]
["     the absolute value of the difference between columns 2 and 3 in column 4."]
["     The TornadoDiagram procedure will sort this range by column 4, and then make the tornado diagram."]
[]
["EXAMPLE"]
["(1) Output Cell (profit)",null,"Formula of cell A21.  =(A23-A26)*A24*A25-A27"]
[225]
["(2) Parameters","(3) Labels","(4) Low Parameter Values","(5) High Parameter Values"]
[175,"Selling Price",140,200]
[12,"Market Size",8,20]
[0.25,"Our Share",0.18,0.35]
[40,"Variable Cost",30,60]
[180,"Fixed Costs",150,300]
["(6) Tornado Table"]
["Parameters:","Output A21 with low value from C23:C27 for parameter in A23:A27","Output A21 with high value from D23:D27 for parameter in A23:A27","Output Differences:"]
["Market Size",90,495,405]
["Our Share",111.6,387,275.4]
["Selling Price",120,300,180]
["Fixed Costs",255,105,150]
["Variable Cost",255,165,90]