Hi All,
I'm trying to understand what the Excel engine is doing (under the hood) with the "What if Analysis \ Data Table" algorithm.
Please don't misunderstand, I know what it is used for and what results it produces.

I understand for its parameters it needs:
1) A designated X/Y range of blank rows into which it will write results
2) At formula having one or more argument(s)
3) At least one range of fixed data values (often called variables - however I don't find that accurate since they are actually static values)
4) The Columns/Rows dialog box is used to assign one or more of the formulas arguments to the range of fixed data values.

Here is what I think occurs in its algorithm
A) Take each of the fixed data values (either in a row or column as assigned) and sequentially apply each value into the formula's argument.
B) Apply the result in the adjacent blank field to the right of the data value (if its a row) - under it (if its a column)
C) Sequence to the next fixed data value - moving from left to right, or up to down - repeat the process.

Does it sound like I got it about right?
Thanks!