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

Applying Spreads to a Template Accessed via the Planning Control Panel

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

coreimage1532.png

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

coreimage1542.png

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

coreimage1552.png

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

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

coreimage1562.png

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?