Data Table

Hi, don't have the book ..
but maybe you could experiment
and try re-constructing the data table
along the lines of a simple example set-up below
[for a 2 variable data table] ?

Let's say you have in D7:E9

Var1....1
Var2....2
Result..5

where Result = Var1 + 2 x Var2
i.e. the formula for "Result" in E9: =E7+2*E8

("Result" is an output depending on 2 inputs
: Var1 and Var2)

Put in D12: =E9 (this is the link to the output cell: E9)

Put some values for Var1 vertically down in D1316,
say: 1,2,3,4

Put some values for Var2 horizontally across in E12:H12,
say: 5,4,3,2

Select the table D12:H16

Click Data Table

Input the settings:
----------------------
For row input: E8
For column input: E7

Click OK

Mask D12 by formatting the font color white,
ie = backgrd color

The 2 variable data table in D12:H16 will calculate the
various outputs for "Result" [in E13:H16] for the combo
values of Var1 (in D1316) and Var2 (in E12:H12)

You can also try inputting / changing the values of Var1
and Var2

The data table will recalculate to give the corresponding
values for "Result"

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik atyahoodotcom
----

"David" wrote:
Hi Group,
I purchased a new book, "Microsoft Excel Data Analysis
and Business Modeling," which is pretty good. On page 122,
the author takes you through a Data Table set up, two-way
table. It is pretty complicated, so I will not attempt to
explain it here. I guess this is oriented to anyone that
might have the book. I actuall copy the worksheet out to
another book and close the original, erase the the data in
the table, and then run the Data/Table/Row input=E8 and
Column input = E7. This is right out of the book and can
be verified from the original file, but I am not coming up
with the same table.

Any ideas?

Thanks,
David

Just a bit of clarification on the line:

You can also try inputting / changing the values of Var1
and Var2

means changing the sample values of:

Var1 in D1316

and/or

Var2 in E12:H12

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik atyahoodotcom
----