Instructions for use of the Depreciation Forecast spreadsheet (Note: files are in Excel’s *.xlsx file type) Initial Set-up Download District Depreciation Forecast spreadsheet. This file has been updated to include all new school bus categories (Propane and Diesel/Electric Hybrid). Please see the notes at the end of this document to see what assumptions have been made in the currently posted spreadsheet for previous categories not currently offered. Note the version number of the spreadsheet to ensure you have the latest. This is a fairly file (16.0 MB). Download the District Fleet Data spreadsheet (about 1 MB) from the same site. The file name will indicate the date the data was queried from the School Bus Information System (SBIS) (i.e.: DistrictFleetDataMarch2016.xlsx). New data will be provided on a routine basis. If your district has had buses entered into the system after the date indicated in the filename, it is possible to update data manually (details below). Open both workbooks. In the District Data workbook, on the worksheet, use the ‘Selection’ dropdown list (cell B1) to select your school district. Select the range of cells shaded yellow (current range is B6:JY32) and ‘copy’. In the District Depreciation Forecast workbook, select the FleetHistory worksheet, select cell B2 and use the command values’ (available under the Special’ options). ‘paste ‘Paste, Select the Summary worksheet of the District Depreciation Forecast and you should see the current year depreciation payment and the forecasted amounts for depreciation. Compare this value with the total provided at the bottom of your Depreciation Report on SBIS: If your values do not match, please see the for Variation” section below. “Reasons Using the spreadsheet for purchasing scenarios After the initial set-up process is complete and variations in values are reconciled, select the ‘Future’ worksheet of the District Depreciation Forecast workbook. Enter proposed school bus purchase information into the proper year and category. Enter the number into the month of expected delivery, not the likely order date. Delivery of school buses after order may take up to 6 months, depending on market conditions.
Instructions for use of the Depreciation Forecast spreadsheet (Note: files are in Excel’s *.xlsx file type) Initial Set-up Download District Depreciation Forecast spreadsheet. This file has been updated to include all new school bus categories (Propane and Diesel/Electric Hybrid). Please see the notes at the end of this document to see what assumptions have been made in the currently posted spreadsheet for previous categories not currently offered. Note the version number of the spreadsheet to ensure you have the latest. This is a fairly file (16.0 MB). Download the District Fleet Data spreadsheet (about 1 MB) from the same site. The file name will indicate the date the data was queried from the School Bus Information System (SBIS) (i.e.: DistrictFleetDataMarch2016.xlsx). New data will be provided on a routine basis. If your district has had buses entered into the system after the date indicated in the filename, it is possible to update data manually (details below). Open both workbooks. In the District Data workbook, on the ‘Selection’ worksheet, use the dropdown list (cell B1) to select your school district. Select the range of cells shaded yellow (current range is B6:JY32) and ‘copy’. In the District Depreciation Forecast workbook, select the FleetHistory worksheet, select cell B2 and use the command ‘paste values’ (available under the ‘Paste, Special’ options). Select the Summary worksheet of the District Depreciation Forecast and you should see the current year depreciation payment and the forecasted amounts for depreciation. Compare this value with the total provided at the bottom of your Depreciation Report on SBIS: If your values do not match, please see the “Reasons for Variation” section below. Using the spreadsheet for purchasing scenarios After the initial set-up process is complete and variations in values are reconciled, select the ‘Future’ worksheet of the District Depreciation Forecast workbook. Enter proposed school bus purchase information into the proper year and category. Enter the number into the month of expected delivery, not the likely order date. Delivery of school buses after order may take up to 6 months, depending on market conditions.
DeprForecastInstructionsMarch2016.docx