Page Comparison

When you create a forecast, the forecast workbook opens

You can quickly differentiate a forecast from a budget workbook by the green Forecast button in the top left corner and the green Forecast flag pole in the grid. The forecast workbook has all the same elements as a budget workbook, along with some additional elements, the extras. The most notable being additions are the three total columns, which also act as buttons you can use to switch between different views of data. These and the flag pole.

[need to change screenshot to match]

the other key elements of a forecast are identified by the numbers in the image below.

1. Total Budget column - Click this column to display your budget values for the entire period in the grid. The cells are not editable in this view, as the information is for reference purposes only. In this view there is no flagpole but a dotted vertical line displays at the end of the last fully completed month (period).

2. Actual + Budget column - Click this column to view the actual and budget values in the grid according to the period that was selected in the forecast setup, for example 1+11, 3+9 and so on. The actual values display to the left of the flagpole and the budget values display to the right. The cells are not editable in this view, as the information is for reference purposes only. This view is useful when you start reforecasting, as you can use the flagpole to see what your original budget was.

3. Actual + Forecast column - This column is selected by default and it displays the actual and forecast values in the grid, according to the

1. period that was selected in the forecast setup

1. . The default position of the flagpole identifies

1. the current period. The actual values display to the left of the flagpole and the forecast values displays to the right of the flagpole. You can drag the flagpole back to the left to see what your forecast was (budget values). The default forecast values are the same as those in the Actual + Budget column but the cells are editable, so

1. this is where you do your reforecasting.

2. Flag pole -

1. This tool allows you to switch between the different data. The default position of the flagpole identifies the latest current actual data, as defined in the forecast setup

1. . You can drag the flag pole back to view the different data (from actual to forecast/budget). You cannot drag the flagpole forward past a certain period because you do not have any actuals for those periods (future periods)

1. .

Image Removed

Initially the cells in the forecast are black color to signify that they have not yet been edited but when you enter a forecast values, the cells change to blue.

The other change to note is that for working some and comparison lines we now show empty budget for actual plus budget totals. As there is no data for these cells.

there are several types of spread.

2. Period columns (grid) - This is where the actuals, budget and/or forecast values display. Any formulas that were in the underlying budget workbook are retained in the forecast.

Image Added