Example (No data)

When a value is top down spread in cells that contain no data and one of the cells in the lower levels is locked, the new value is spread evenly to the unlocked cells. In the following example, a value of 0 for August is locked.

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

Therefore, when a new Quarter 3 2009 value of 3,000 is top down spread, the number is spread evenly to July and September, the two unlocked cells (3000/2 = 1,500 to each cell).

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