Example (Existing data, unlocked cells)

When a value is top down spread in cells that contain existing data, the new value is spread to the lower levels based on their previous ratios. In this example, the initial ratios are calculated similar to:

• Ratio for July = 1000/(1000 + 600 + 400) = 1000/2000 = .5
• Ratio for August = 600/(1000 + 600 + 400) = 600/2000 = .3
• Ratio for September = 400/(1000 + 600 + 400) = 400/2000 = .2

	Quarter 3 2009	July 2009	August 2009	September 2009
Los Angeles	2,000	1,000	600	400

Therefore, if 3,000 is specified for Quarter 3 (instead of the existing 2,000 value), the amount spread to the leaf members is calculated similar to:

• Amount spread to July = 3000 * .5 = 1,500
• Amount spread to August = 3000 * .3 = 900
• Amount spread to September = 3000 * .2 = 600

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