Data Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HiGroup,

I am working out of "Microsoft Excel Data Analysis and Business Modeling,"
pg 123-124. Creating a two way data Table and the book comes with examples,
but when I select the table and have it recalculate with the row and column
inputs, it fails.

growth
Revenue 100000000 0.25 (Column input)
Exp 1.50E+08 0.05 (Row input)

0 1 2 3 4
Rev 100000000 125000000 156250000 195312500 244140625
Exp 150000000 157500000 165375000 173643750 182325937.5
Breakeven 0 0 3 0

Total 3 =IF(SUM(F13:R13)>0,SUM(F13:R13),"No BE")
Controlling formula in B20 is + E15


Exp growth
Control is ----> 3 0.02 0.03 0.04 0.05
0.1 6 7 8 9
Rev 0.11 5 6 7 8
growth 0.12 5 5 6 7
0.13 4 5 5 6
0.14 4 4 5 5
0.44 2 2 2 2
0.45 2 2 2 2
0.46 2 2 2 2
0.47 2 2 2 2
0.48 2 2 2 2
0.49 2 2 2 2
0.5 2 2 2 2

This is the best that I can copy. If I select the table and assign it the
Row Input and Column Input, it fails and turns the whole table to 3s. Using
ver 2003 and can not see why it is failing? At first i thought it might be
because there are multiple tables in the same file, but I coppied the sheet
out into another file and even closed the older one and it is still failing.
The table is larger than copied, E20:X61, with two inputs.

This is right from the book, can not see what I can even be doing wrong. Any
ideas?
 
Hi Again,
After trying several more examples, including one from the knowledge base, I
think something is corrupt in Excel. Can I reinstall Excel alone or do I have
to install the whole suite?

TY in advance,
 
.. turns the whole table to 3s.

Just a hunch that the above obs in the context of Data>Table feature could
be a simple matter of the book's calculation mode being set to either
"Manual", or "Automatic except Tables". Press F9 to force calculate, does it
now compute correctly? To check/change the calc mode: Click Tools > Options >
Calculation tab. Options are there.

---
 
Max,

Something was corrupt and I had to uninstall and reinstall, but you are
correct, I had to use F9 to recalc after that.
 
Thanks for feedback. It's quite usual to use "Manual" or "Auto except
Tables" calc modes when it involves using Data>Table feature, these "tables"
can become very calc-intensive.
 
Back
Top