Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What-If with data tables?
I've been learning What-If Analysis with data tables. Data tables strike me
as an overcomplicated and contrived method of doing something that could be done much more easily and naturally without this 'feature'. In both 1 or 2-variable tables you wind up with a value or values (where your formula(s) are entered) that seem out-of-place or spurious, formatting seems less than desirable and requires thought, and you've got to go through--and remember each time--certain steps to get it all right. (see: http://office.microsoft.com/en-us/ex...726561033.aspx ) Why not just enter your non-calculated values somewhere, then Auto Fill your variable(s) and formula(s) however you like, wherever you want, and without having to remember any wacky procedure? What am I missing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What-If with data tables?
SimiusLive -
The AutoFill (or copy and paste) may work fine for a single formula or even a multi-row single-column model. But when you have a multi-row multi-column model, e.g., a cash flow multi-period model with an NPV output formula, the Data Table feature is very useful for sensitivity analysis. I usually use a ";;;" custom format for the cell containing the formula for the data table output. For another set of instructions for using data tables for sensitivity analysis, see my "Sensitivity Analysis Using Excel" chapter, downloadable from the Chapters page at www.treeplan.com. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "SimiusLive" wrote in message ... I've been learning What-If Analysis with data tables. Data tables strike me as an overcomplicated and contrived method of doing something that could be done much more easily and naturally without this 'feature'. In both 1 or 2-variable tables you wind up with a value or values (where your formula(s) are entered) that seem out-of-place or spurious, formatting seems less than desirable and requires thought, and you've got to go through--and remember each time--certain steps to get it all right. (see: http://office.microsoft.com/en-us/ex...726561033.aspx ) Why not just enter your non-calculated values somewhere, then Auto Fill your variable(s) and formula(s) however you like, wherever you want, and without having to remember any wacky procedure? What am I missing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
PLEASE ANYONE ... DATA IMPORT EXTERNAL DATA - WEB TABLES | Excel Discussion (Misc queries) | |||
DATA > TABLE -- 2 variable data tables? | Excel Worksheet Functions | |||
DATA > TABLE -- 2 variable data tables? | Excel Discussion (Misc queries) | |||
How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) |