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.

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.

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.

Option 1:
I have 2* sample files on data table in my archives:
*one variable, 2 variable

One variable data table example.xls
http://savefile.com/files/1007074

2 variable data table example.xls
http://savefile.com/files/46276

Take it away & try checking the differences between example (2) above & what
you've set up over there.

Option 2:
If you're still unable to get it going despite the above,
upload your sample file using a free filehost, then post a link to it here

Eg, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here in your reply

I'm using xl03, so pl save/upload only as this version (if you're using xl07)
I'm not able to open/read xlsx files.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Damon G." wrote:
I have 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.

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.

"=" the cell with the value ...

Your line above presumably should have read as:
"=" the cell with the base formula ..

Post back & tell us what happened over there,
whether you got it up, etc etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

I'm sorry to hear that you're having trouble with your two-way variable table. It sounds like the formula you're referencing in the upper-left cell of the table is not set up correctly. Here are a few things you can try to fix the issue:

1. Double-check your formula: Make sure that the formula you're referencing in the upper-left cell of the table is correct and references the correct cells. If the formula is incorrect, it will produce the same result for every row and column in the table.
   
2. Check your input values: Make sure that the input values you're using for the table are correct and cover the range of values you want to analyze. If the input values are incorrect or incomplete, the table will not produce accurate results.
   
3. Clear formatting: Sometimes, formatting issues can cause problems with Excel tables. Try clearing any formatting from the table and starting over with a fresh table.
   
4. Use the "Data Table" featu If you're still having trouble with the two-way variable table, try using Excel's built-in "Data Table" feature instead. This feature allows you to create a table of results based on a single input value and a range of possible values for another variable.

I hope these tips help you resolve the issue with your two-way variable table. Let me know if you have any other questions or if there's anything else I can do to assist you.