Excel 2003 - Data Table
I'm using Data Table to make sensitivity tables for input values. However,
when I use a formula (Y + 0.001) in the input columm the results are not
calculated correctly. When I manually enter the input column, the results are
calculated correctly. Why does Excel data tables not allow formulas in the
input column?
Example
************************************************** ********
Data Table with formula Margin input column
Yearly Yearly Coverage
Margin Revenue Savings Ratio
"271,998,000" "87,849,698" 2.04
0.025 "271,998,000" "87,849,698" 2.04
0.025+.001 "282,877,920" "99,084,398" 2.13
0.026+.001 "304,637,760" "121,553,798" 2.29
0.027+.001 "337,277,520" "155,257,898" 2.55
0.028+.001 "380,797,200" "200,196,698" 2.89
0.029+.001 "435,196,800" "256,370,198" 3.31
Data Table with manually entered Margin input column
Yearly Yearly Coverage
Margin Revenue Savings Ratio
"280,867,500" "87,849,698" 2.04
0.025 "280,867,500" "87,849,698" 2.04
0.026 "292,102,200" "99,084,398" 2.13
0.027 "303,336,900" "110,319,098" 2.21
0.028 "314,571,600" "121,553,798" 2.29
0.029 "325,806,300" "132,788,498" 2.38
0.03 "337,041,000" "144,023,198" 2.46
--
Donna L Bruce
Sr Technical Writer
Elster Electricity, LLC
Raleigh NC
|