Five Year Forecast Spreadsheets

  • Standard:  Includes several optional sheets including "Percentage" and "Summary" presentations of the Forecast similar to ones provided by AOS.  Also included is a "Charts" sheet which contains several sample Excel charts showing graphical presentations of the forecast data.  These additional views and charts work without any additional effort and update automatically when as the Forecast data is updated.
  • Standard with Locks:  Includes several optional sheets including "Percentage" and "Summary" presentations of the Forecast similar to ones provided by AOS.  Also included is a "Charts" sheet which contains several sample Excel charts showing graphical presentations of the forecast data.  These additional views and charts work without any additional effort and update automatically when as the Forecast data is updated.  Included with this version is a locked "Forecast" page that prohibits the user from modifying any cell containing a formula.
  • Basic:   The basic sheet contains just what you need to import data from USAS and complete the forecast as required by SF and EMIS, without the extra fluff.  We recommend this sheet if you have a slower PC/Mac without much memory, or if you just don't want to deal with anything "extra".

 

Note: This spreadsheet was developed for OECN State Software users. However, the spreadsheet can function as stand-alone with data entered manually or imported from other sources. Therefore, non-state software users are welcome to download and use this spreadsheet.

If you have questions, comments or suggestions regarding the spreadsheet or the USASFF program, please visit us in the "State Software: USAS" forum.