Applying Spreads to a Template Accessed via the Planning Control Panel
- 1 Minute to read
- Print
- DarkLight
- PDF
Applying Spreads to a Template Accessed via the Planning Control Panel
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Applying Spreads to a Template Accessed via the Planning Control Panel
In the example below, quarterly and seasonal spread methods are defined.
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.
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?