Example (No data, unlocked cells)

When a value is top down spread in cells that contain no data, the new value is spread equally to the leaf members.

Quarter 3 2009 July 2009 August 2009 September 2009
Los Angeles 0 0 0 0

In this example, if 3,000 is specified for Quarter 3, then the 3,000 is spread equally to the three leaf members. Therefore, the amount spread to each of the three months is 1,000 (3000/3).

Quarter 3 2009 July 2009 August 2009 September 2009
Los Angeles 3,000 1,000 1,000 1,000