Spreading Values Using Grid Spread

If your administrator has enabled Grid Spread as a form property, you can specify an amount or percentage by which Planning increases or decreases values across multiple dimensions on the form, based on the existing values in the target cells. You immediately see the result in the form and can save the new data or discard it. When calculating the spread data, Planning ignores read-only and locked cells and cells having supporting detail. Data integrity is ensured by spreading values only to cells to which you have access.

Note:

The Time Balance property setting affects how data is spread with the Fill option. See How Spreading Data Works.

  To spread values using Grid Spread:

  1. Put the cursor in the Subtotal or Total source cell whose value you want to spread to target cells.

  2. Select Edit, and then Grid Spread.

  3. Perform an action:

    • To increase or decrease values by a specified amount, from Adjust Data, select By Value, select Increase by or Decrease by, and then enter the value to spread.

    • To increase or decrease values by a percentage, from Adjust Data, select By Percentage, select Increase by or Decrease by, and then enter the percent value.

    • To replace values with a new value, enter it in the Spread Value text box.

  4. Select a spreading pattern, as described in the following table:

    Spread TypeDescription
    Proportional SpreadSpreads the value proportionally, based on the existing values in the target cells (the default)
    Evenly SplitSpreads the value evenly among the target cells
    FillReplaces the value in all target cells
  5. Click Spread.

    The specified value or percentage is spread across the target cells, replacing former values with new ones.

  6. To save the new values, click Save.