{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Computation","Payments","Adjustments"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":3},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Computation","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10]]}
["Wisconsin Department of Public Instruction | School Financial Services"]
["Special Education and School-Age Parents Aid Computation | 2020-21 Aid Based on 2019-20 Costs (Fund 27 Project 011)"]
["As of 5/7/2021"]
["LEA Name","(All)"]
["LEA Code","(All)"]
["Pmt Month","JUN"]
[]
[null,null,null,"Values"]
["Function","Title","Aid Rate","Salaries","Benefits","Other Costs","Package Pgm","Net Adjustment","Deduct Rcpts","Net Aidable Cost","Prorated Aid"]
["152000","ECSE",0.28181179477489599,39708796.419999987,17985740.730000008,0,0,526649.03,-182291.13,58038895.050000012,16356044]
["156100","H",0.28181179477489599,14712296.019999998,6402260.4700000016,0,0,0,-2120047.4899999998,18994508.999999993,5352876]
["156200","HB",0.28181179477489599,677155.66,187499.12,8552.7700000000023,0,0,0,873207.5500000004,246082]
["156600","SL",0.28181179477489599,110875182.28999998,45267850.430000015,0,0,687738.37000000011,-428636.13,156402134.9600001,44075966]
["156700","V",0.28181179477489599,5732406.919999999,2343527.7600000002,0,0,-8266,-1381350.02,6686318.6600000011,1884285]
["156800","HOS",1,526240.81000000006,221519.3,11102.23,0,0,0,758862.34,758862]
["158000","CCR",0.28181179477489599,440542023.6099999,192257866.61000028,0,510039.61,2385300.31,-1973960.9100000001,633721269.22999966,178590141]
["159100","ASSTS",0.28181179477489599,232504130.80000004,121407279.86999995,0,268716.98,1099706.6999999997,-983799.49,354296034.8599999,99844804]
["159200","SUBS",0.28181179477489599,7373387.9800000004,1268561.0999999999,0,20589.939999999999,1522.58,-1614.75,8662446.8499999959,2441180]
["159300","SPEC",0.28181179477489599,9784122.6499999948,4611659.21,0,0,0,-12205.7,14383576.16,4053464]
["174100","SAPCL",0.28181179477489599,1427705.95,750237.51000000024,0,0,0,0,2177943.4599999995,613771]
["174200","SAPHB",0.28181179477489599,1013.75,114.02,73.09,0,0,0,1200.8599999999999,338]
["212000","SW",0.28181179477489599,22549016.000000007,9339737.290000001,0,0,237196.46,0,32125949.750000004,9053467]
["213000","GUID",0.28181179477489599,11836759.819999995,4987734.2900000019,0,15357,59884.74,0,16899735.84999999,4762546]
["214000","HE",0.28181179477489599,7234734.9799999967,3126023.0799999996,0,0,19442.599999999999,0,10380200.659999995,2925266]
["215000","PS",0.28181179477489599,55452244.000000015,21199238.310000002,0,0,308803.61,0,76960285.919999972,21688319]
["218100","OT",0.28181179477489599,31300362.240000006,12906335.349999998,4110311.5100000002,0,0,-621108.16000000015,47695900.94000002,13441264]
["218200","PT",0.28181179477489599,12189102.519999998,4478779.4499999993,2238106.8000000003,0,0,-483721.37999999995,18422267.390000008,5191609]
["223300","LS",0.28181179477489599,37507824.850000024,13264326.779999992,0,0,188880.53,-840576.76,50120455.399999984,14124541]
["256000","TRANSP",1,0,0,0,0,-832.49,0,-832.49,-832]
[null,null,0.28181179477489599,0,0,0,0,0,-11900,-11900,-3354]
["256200","n/a",0.28181179477489599,4950390.58,1315259.8000000003,556436.33000000019,0,0,0,6822086.71,1922547]
["256300","n/a",0.28181179477489599,0,0,157014.24,0,0,0,157014.24,44249]
["256500","n/a",0.28181179477489599,0,0,104237.64,0,0,0,104237.64,29375]
["256600","n/a",0.28181179477489599,0,0,647521.87999999977,0,0,0,647521.87999999977,182477]
["256700","n/a",0.28181179477489599,0,0,68273187.469999999,0,0,0,68273187.469999999,19240193]
["256800","n/a",0.28181179477489599,0,0,58703.94,0,0,0,58703.94,16544]
["270000","UNEMP",0.28181179477489599,0,0,473886.54999999987,0,0,0,473886.54999999987,133547]
["436000","OST",0.28181179477489599,0,0,11768642.670000002,0,-35148.75,0,11733493.920000002,3306629]
["Grand Total",null,null,1046884897.85,463321550.48000026,88407777.11999999,814703.52999999991,5470877.6900000004,-9041211.9199999999,1595858594.7500002,450276200]

{"sheet":"Payments","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[6,0,6,3],[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["Wisconsin Department of Public Instruction"]
["School Financial Services"]
["Special Education and SAP Aid Payments"]
["2020-21 Aid Based on 2019-20 Costs"]
[{"$f":"Computation!A3","v":"As of 5/7/2021"}]
[]
["NOTE: \"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."]
[]
["LEA Name","(All)"]
["LEA Code","(All)"]
[]
[null,"Values"]
["Month","Payment","% to Date","Elig. This Pmt"]
["NOV",67269218,0.14999999999999941,448461418]
["DEC",67546036,0.29999999999999888,449360592]
["JAN",67745543,0.44999999999999696,450119380]
["FEB",67578945,0.59999999999999776,450221124]
["MAR",67547813,0.75,450240588]
["JUN",112595709,1,450276200]

{"sheet":"Adjustments","index":2,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[18,5,19,5],[20,4,20,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,5,13,5],[14,5,15,5],[16,5,17,5],[29,5,30,5],[31,5,32,5],[21,4,21,5],[22,5,24,5],[25,5,26,5],[28,4,28,5]]}
["Wisconsin Department of Public Instruction | School Financial Services"]
["Special Education and SAP Aid Adjustments | 2020-21 Aid Based on 2019-20 Costs"]
[{"$f":"Computation!A3","v":"As of 5/7/2021"}]
[]
["LEA Name","(All)"]
["LEA Code","(All)"]
[]
["Type","Function","Adjustment",null,"Key to Adjustments"]
["NVE","158000",278529.13,null,"Expenditure Adjustments"]
[null,"159100",222850.30999999994,null,"(reduce aid-eligible costs)"]
[null,"159200",199.51000000000002,null,"NVE","No Valid License: Costs of staff identified during audit as not having valid licenses for their assignments."]
["NVE Total",null,501578.94999999995]
["QCE","156700",8266]
["QCE Total",null,8266]
["STE","158000",1159988,null,"QCE","Questioned Cost: Other ineligible costs identified during audit."]
["STE Total",null,1159988]
["NIR","152000",526649.03,null,"STE","State Tuition: Costs funded by this LEA's State Tuition claim."]
[null,"156600",687738.37]
[null,"158000",3823817.4400000004,null,"MAE","Miscellaneous: Other reductions to eligible costs."]
[null,"159100",1322557.01]
[null,"159200",1722.09,null,"Revenue Adjustments"]
[null,"212000",237196.46,null,"(increase aid-eligible costs)"]
[null,"213000",59884.74,null,"NIR","Non-Instrumentality: Costs for non-instrumentality charter schools authorized by a district."]
[null,"214000",19442.599999999999]
[null,"215000",308803.61]
[null,"223300",188880.53,null,"MAR","Miscellaneous: Other additions to eligible costs."]
["NIR Total",null,7176691.8799999999]
["PYE","256000",832.49,null,"Prior Year Adjustments"]
["PYE Total",null,832.49,null,"(reduce or increase aid received)"]
["MAE","436000",35148.75,null,"PYE","Reduction for aid improperly received in the prior year."]
["MAE Total",null,35148.75]
["Grand Total",null,8882506.0700000003,null,"PYR","Addition for aid improperly withheld in the prior year."]