Five Year Forecast

The Five Year Forecast option allows you to extract forecast data for the fiscal year that is current.  The grid contains the accounts included in the forecast along with its associated forecast line number and description as well as the three prior year's actual values and current year FYTD expendable or receivable values.

From the Periodic menu,

  1. Click on 'Five Year Forecast'.

  2. Select CSV or Excel under Format Type.

  3. Click 

     to save it in CSV or Excel format on your computer. 

 

Format Types

  • The CSV option generates a comma separated formatted file of the forecast data containing the forecast line numbers, prior year actual values and current year estimates. This is similar to the CSV file automatically generated in Classic's USASFF program. 

  • The Excel option will automatically upload the forecast data into the SSDT's Five Year Forecast spreadsheet.

 

More Information

Legacy Spreadsheets

As noted above, when using the Excel option, it will automatically upload your data from USAS-R into the SSDT's Five Year Forecast Standard spreadsheet format.  However, we have also provided template spreadsheet formats below which you can import your own data into.

The template spreadsheets listed below are legacy spreadsheets that have not been updated and may refer to Classic terminology.  Please ensure the correct fiscal year is entered in the parameters worksheet in order for the forecast years to display correctly in the forecast worksheet.

 

SSDT Forecast Basic

 

SSDT Forecast Standard

 

SSDT Forecast Standard with Locks