Entering Data you go to the sheet, you will notice that there are warnings ‘Data’ in red that data is missing. Once data is entered, the warnings will disappear. If you only have 3 years’ worth of data, as the warnings cover all 5 years, you will need to enter or into the earlier years. ‘-‘ ‘0’ This is shown in the screen shot below. after entering the data, you have missed a month or not included any values in the cells required, the red warnings will still appear (as shown in the screen shot below). The forecast won’t run even if there are blanks in the current year policy adjustment column. If you don’t know what the Policy adjustment will be, carry the cumulative value from the previous March over the whole year. Once you know the policy adjustment, edit the table in the sheet, and this will change the ‘Data’ predicted monthly spend without having to re-run the forecast. Entering data for less than 5 years you don’t have 5 years’ worth of data to enter, you can add less, but the remaining years need to have either or entered (as illustrated ‘-‘ ‘0’ below). Only enter full years data always start at April even if you – have data for August the previous year. The Forecast sheet and running the forecast you ignore the red warnings on the and try to run the ‘Data’ forecast, you will receive a pop-up window (as below) stating that the forecast can’t run. If you receive this message, you will need to return to the sheet and add the missing data. ‘Data’
Entering Data you go to the ‘Data’ sheet, you will notice that there are warnings in red that data is missing. Once data is entered, the warnings will disappear. If you only have 3 years’ worth of data, as the warnings cover all 5 years, you will need to enter ‘-‘ or ‘0’ into the earlier years. This is shown in the screen shot below. after entering the data, you have missed a month or not included any values in the cells required, the red warnings will still appear (as shown in the screen shot below). The forecast won’t run even if there are blanks in the current year policy adjustment column. If you don’t know what the Policy adjustment will be, carry the cumulative value from the previous March over the whole year. Once you know the policy adjustment, edit the table in the ‘Data’ sheet, and this will change the predicted monthly spend without having to re-run the forecast. Entering data for less than 5 years you don’t have 5 years’ worth of data to enter, you can add less, but the remaining years need to have either ‘-‘ or ‘0’ entered (as illustrated below). Only enter full years data – always start at April even if you have data for August the previous year. The Forecast sheet and running the forecast you ignore the red warnings on the ‘Data’ and try to run the forecast, you will receive a pop-up window (as below) stating that the forecast can’t run. If you receive this message, you will need to return to the ‘Data’ sheet and add the missing data.
20170809_Guide%20to%20using%20the%20Forecast%20Template%202017-18.docx