...
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.
...
- Negative numbers need to be formatted using a minus (-) sign. Use of parentheses to represent a negative number will cause an error when attempting to import the CSV file.
- Dollar amounts may be formatted using dollar ($) signs
- Percentage values may include the percent (%) sign
- Whole dollar values, no decimal values, must be supplied for the Prior Years Actual and Forecasted amounts. Formatting these values with decimals included (0.00) will cause an error during the import. Average Annual Change and the Line numbers are the two columns which may contain decimal values.