Damon G. -
I have step-by-step instructions with screenshots for preparing one-way and
two-way data tables.
At
http://www.treeplan.com, on the "Chapters" page, you can download the pdf
file for chapter 2, Sensitivity Analysis Using Excel.
Or, directly, the file is
http://www.treeplan.com/02_decan_20071029_1042.pdf
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
"Damon G." wrote in message
...
I ahve tried all of those remedies and nothing seems to work.
1. I have the Tools-Options set to AUTOMATIC Calc. I have even executed
the
F9 key multiple times.
2. I have tried to swap the order of the rows/columns and even the
references. Still no luck.
3. I have the base formula in the cell that it references for the amount.
It
is a simple "=" the cell with the value and it still just repeats. I am so
confused because it's not making any sense to me.
If you have any other tricks up your sleeve, I am all ears. Thank you so
much for the earlier advice. This is very baffling.
"Max" wrote:
Try some quick diagnostics:
1. It could be calc mode. Press F9, does it now compute properly? The
book
may intentionally or inadvertently been set to either Manual, or the
semi-auto calc mode called: Automatic except tables (the "tables" are the
1/2
way variable tables which are calc-intensive, hence this option is
provided.
You press F9 if/when you want the tables to recalc, everything else is
auto).
Check/correct the calc mode to Automatic via clicking:
Tools Options Calculation tab.
2. If (1) is not it, you've probably set it up wrongly. Re-do the
DataTable
steps, try swapping the row/column inputs around, see whether this
returns
the correct values.
3. The 1/2 way variable tables need to be created on the same sheet as
the
base formula. That's the constraint I observed.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Damon G." wrote:
HELP!! I am building a two-way variable data table and everytime I
press OK,
it just repeats the upper-most left column result which is the formula
that
is referenced. PLEASE HELP!! I need to get this done.