Applying Spreads to a Template Accessed via the Planning Control Panel

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.