The Five Year Forecast Spreadsheet Import option provides a means for districts to convert their Five Year Forecast spreadsheet data into a flat file for EMIS-R reporting. The spreadsheet Import option will only handle files in CSV format. There are no specified formatting requirements such as column A has to be the line number, the columns may be organized however the district wishes. Any spreadsheet utility should be able to create a CSV file using "File - Save As" and selecting the CSV format when saving.
Select the Menu option specific to the Five Year Forecast Spreadsheet Import, not the generic "Import" option.
The default values provided for the spreadsheet columns are based on the SSDT Forecast templates. If your district utilizes another format, the appropriate values for the various columns will need to be entered. An example is a district that places a blank column between the various amount columns to provide a visual separation between the amount columns. Those blank columns need to be taken into account, only the columns containing actual data are specified. If a blank column is indicated, it will result in all zeroes being loaded for the element is was specified for.
...