Examples of Spreading Data with Cell Locking

Example 1

Before locking and spreading, Account A has the values described in the following table:

 

Jan

Feb

Mar

Q1

Account A

100

100

100

300

You then lock the Feb and Mar values at 100 and change Q1 from 300 to 600. Because Jan, Feb, and Mar must now total 600, and Feb and Mar are locked at 100 each, Planning calculates Jan to be 400 and fills in that value.

After locking and spreading, the data displays as shown in the following table:

 

Jan

Feb

Mar

Q1

Account A

400

100

100

600

Example 2

Before locking and spreading, Account B has the values described in the following table:

 

Q1

Q2

Q3

Q4

YearTotal

Account B

100

100

100

100

400

You then lock Q1 and Q2 values at 100 each and change Year Total from 400 to 800. Because the yearly total must equal 800, and Q1 and Q2 are locked at 100 each, Planning calculates Q3 and Q4 to be 300 each and fills in those values.

After locking and spreading, the data is displayed as shown in the following table:

 

Q1

Q2

Q3

Q4

YearTotal

Account B

100

100

300

300

800