Top down spreading in formula map vs. source worksheet

  • A formula map may also include sensitivity decimal values, contribution percent, or variance percent. Whereas you can top down spread on a variance percent or contribution percent, you cannot top down spread on a sensitivity value. You can also top down spread on a primary data value or variance data value from any parent node, specifying a new value from a leaf node will write data to the leaf node and consolidate to the parent levels.

    ../images/image7.png

  • Top down spreading from a variance percent only changes the variance percent and variance data values in the map, not the primary data values.
  • After a top down spread, or Undo Last Spread command, is performed in a formula map, the values in the source worksheet automatically refresh.
  • When the last spread is undone, the values displayed in the formula map automatically refresh, except for the sensitivity values. To refresh sensitivity values, you must generate a new formula map.
  • Although a formula map respects locked cells and constraints on leaf nodes during a top down spread (as the worksheet does), the map does not identify which cells are locked or limited by constraints.