Applying Spreads to a Template Accessed via the Planning Control Panel
  • 1 Minute to read
  • Dark
    Light
  • PDF

Applying Spreads to a Template Accessed via the Planning Control Panel

  • Dark
    Light
  • PDF

Article summary

In the example below, quarterly and seasonal spread methods are defined.

The Quarterly Spread spreads data evenly over the 4 quarters in years 2016 and 2017. The Seasonal Spread, spreads more data during quarters 2 and 3. The budget sheet (Input template) is displayed below.

Click the Methods tab and select Annual Value. The spreads are displayed as shown below.

Select a spread (in this case Quarterly) and click Apply.

The spread code cell is updated for the line to Quarterly.

Now enter data in FY-2016 or FY-2017 and press enter and the data will be reflected in the corresponding periods for that year.


Was this article helpful?