Historical Data for Special Education Aid through FY2024
Aid Payment Worksheets for School Districts, CESAs, CCDEBs and Independent Charter Schools
To view information for a specific Local Education Agency (LEA), select it from the pulldown list on a worksheet page.
Note: Data is available in a single Excel workbook file. It can be downloaded in one of two versions: a macro-enabled (.xlsm) file that updates the other worksheets when a specific LEA is selected on one and a standard (.xlsx) file where each worksheet must be updated individually. If your IT system will not permit download of macro-enabled files, use the standard file.
2023-2024 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs "Elig. This Pmt." is the total annual aid eligibility based on the proration rate used for this payment. This amount in the November through March payments will be slightly lower than the June payment, which will use the full and final proration rate. Any other differences are the result of audit changes and adjustments.
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2022-2023 Categorical Aid Computation and Eligibility
- FY23 Summary Of SPED-SAP Payments (6/12/2023)
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs (6/12/2023) "Elig. This Pmt." is the total annual aid eligibility based on the proration rate used for this payment. This amount in the November through March payments will be slightly lower than the June payment, which will use the full and final proration rate. Any other differences are the result of audit changes and adjustments.
- Standard format (.xlsx) - LEA selected separately on each worksheet tab (6/12/2023)
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually (6/12/2023)
2021-2022 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs (6/2/2022)
- Standard format (.xlsx) - LEA selected separately on each worksheet tab (6/2/2022)
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually (6/2/2022)
2020-2021 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2019-2020 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2018-2019 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2017-2018 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2016-2017 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2015-2016 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
There are numerous compatibility problems with Excel 2011/2016 for Mac reading certain types of data executable files created with Windows versions of Excel. Until an alternative workbook format can be developed, we will provide raw data files for Mac users to access their aid computation information.
For questions about this information, contact Rick Cruz (608) 266-8255, dpifin@dpi.wi.gov (608) 267-9114