{"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 | 2019-20 Aid Based on 2018-19 Costs (Fund 27 Project 011)"]
["As of 5/17/2020"]
["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.25020750239233402,38919062.459999979,17807366.879999988,0,9617.26,280141.12,-380633.20999999996,56635554.509999983,14170643]
["156100","H",0.25020750239233402,14804803.240000002,6470820.2300000023,0,0,-67046.98,-1899612.1599999997,19308964.330000002,4831247]
["156200","HB",1,0,0,0,0,13352.81,0,13352.81,13353]
[null,null,0.25020750239233402,781838.9,188377.98,12590.54,0,0,0,982807.42000000027,245905]
["156600","SL",0.25020750239233402,107527474.91999994,44313241.529999979,0,86098.57,733365.5,-348486.42000000004,152311694.09999999,38109534]
["156700","V",0.25020750239233402,5339470.9400000013,2299985.4099999992,0,0,0,-1326161.2999999996,6313295.0500000007,1579634]
["156800","HOS",1,518282.1,224276.52000000002,12205,0,0,0,754763.62,754764]
["158000","CCR",0.25020750239233402,418352307.27999943,184254027.74000007,0,1184577.98,315084.75000000023,-2101877.7800000003,602004119.97000027,150625944]
["159100","ASSTS",0.25020750239233402,214884105.50999996,114119350.22000001,0,584291.67000000004,827795.51,-862204.67,329553338.23999983,82456720]
["159200","SUBS",0.25020750239233402,9210950.7800000031,1813501.83,0,46658.619999999995,-19490.53,-1181.23,11050439.470000003,2764905]
["159300","SPEC",0.25020750239233402,9274280.5299999993,4173792.6500000013,0,4999.3500000000004,0,-12519,13440553.529999996,3362923]
["174100","SAPCL",0.25020750239233402,1373484.15,717503.01,0,0,0,0,2090987.1600000001,523183]
["174200","SAPHB",0.25020750239233402,13957.55,1871.2700000000004,183.5,0,0,0,16012.319999999998,4007]
["212000","SW",0.25020750239233402,21162304.550000001,8861338.4399999995,0,0,120283.74000000002,0,30143926.730000004,7542240]
["213000","GUID",0.25020750239233402,11623768.400000015,4916452.4700000016,0,20826,-20373.870000000006,0,16540673.000000009,4138602]
["214000","HE",0.25020750239233402,7114479.9899999974,3060621.6300000018,0,0,18860.68,0,10193962.299999995,2550607]
["215000","PS",0.25020750239233402,52958347.68,20059527.269999996,0,72479.86,235376.62,0,73325731.430000007,18346656]
["218100","OT",0.25020750239233402,28995434.509999998,12181353.019999996,4587391.7899999991,0,23079.5,-616232.5,45171026.320000015,11302134]
["218200","PT",0.25020750239233402,11647276.65,4262200.1399999987,2773477.8299999996,0,0,-488738.48,18194216.140000008,4552327]
["223300","LS",0.25020750239233402,37246962.550000027,13136863.94000002,0,0,324947.01,-904388.29999999993,49804385.200000025,12461428]
["256000","TRANSP",0.25020750239233402,0,0,0,0,-146.47999999999999,-22787.54,-22934.02,-5738]
["256200","n/a",0.25020750239233402,4690918.3699999973,1153151.3200000003,783943.21,0,0,0,6628012.8999999994,1658381]
["256300","n/a",0.25020750239233402,0,0,393253.55,0,0,0,393253.55,98395]
["256500","n/a",0.25020750239233402,0,0,135399.92000000001,0,0,0,135399.92000000001,33880]
["256600","n/a",0.25020750239233402,0,0,620425.44000000006,0,0,0,620425.44000000006,155237]
["256700","n/a",0.25020750239233402,0,0,76601609.930000007,0,0,0,76601609.930000007,19166302]
["256800","n/a",0.25020750239233402,0,0,49800.920000000006,0,0,0,49800.920000000006,12462]
["270000","UNEMP",0.25020750239233402,0,0,45349.930000000008,0,0,0,45349.930000000008,11346]
["436000","OST",0.25020750239233402,0,0,12053797.990000002,0,0,-42640,12011157.990000002,3005279]
["Grand Total",null,null,996439511.05999911,444015623.49999994,98069429.550000012,2009549.3100000003,2785229.3800000004,-9007462.5899999999,1534311880.2100008,384472300]

{"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"]
["2019-20 Aid Based on 2018-19 Costs"]
[{"$f":"Computation!A3","v":"As of 5/17/2020"}]
[]
["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",57429834,0.14999999999999927,382865512]
["DEC",56722585,0.29999999999999882,380507983]
["JAN",57439337,0.4499999999999969,381314986]
["FEB",57047912,0.59999999999999787,381066109]
["MAR",57223208,0.75,381150434]
["JUN",98609424,1,384472300]

{"sheet":"Adjustments","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[29,5,30,5],[31,5,32,5],[21,4,21,5],[22,5,24,5],[25,5,26,5],[28,4,28,5],[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]]}
["Wisconsin Department of Public Instruction | School Financial Services"]
["Special Education and SAP Aid Adjustments | 2019-20 Aid Based on 2018-19 Costs"]
[{"$f":"Computation!A3","v":"As of 5/17/2020"}]
[]
["LEA Name","(All)"]
["LEA Code","(All)"]
[]
["Type","Function","Adjustment",null,"Key to Adjustments"]
["NVE","158000",1811475.27,null,"Expenditure Adjustments"]
[null,"159100",670567.16999999993,null,"(reduce aid-eligible costs)"]
[null,"159200",19490.53,null,"NVE","No Valid License: Costs of staff identified during audit as not having valid licenses for their assignments."]
[null,"212000",101955.55]
[null,"213000",88480.87000000001]
[null,"215000",88606.94]
[null,"156100",67046.98,null,"QCE","Questioned Cost: Other ineligible costs identified during audit."]
["NVE Total",null,2847623.3099999996]
["QCE","256000",146.47999999999999,null,"STE","State Tuition: Costs funded by this LEA's State Tuition claim."]
["QCE Total",null,146.47999999999999]
["STE","158000",1400847,null,"MAE","Miscellaneous: Other reductions to eligible costs."]
[null,"159100",20082]
["STE Total",null,1420929,null,"Revenue Adjustments"]
["NIR","152000",280141.12,null,"(increase aid-eligible costs)"]
[null,"156600",733365.5,null,"NIR","Non-Instrumentality: Costs for non-instrumentality charter schools authorized by a district."]
[null,"158000",3527407.02]
[null,"159100",1518444.68]
[null,"212000",222239.29,null,"MAR","Miscellaneous: Other additions to eligible costs."]
[null,"213000",68107]
[null,"214000",18860.68,null,"Prior Year Adjustments"]
[null,"215000",323983.56,null,"(reduce or increase aid received)"]
[null,"223300",324947.01,null,"PYE","Reduction for aid improperly received in the prior year."]
[null,"218100",23079.5]
["NIR Total",null,7040575.3599999985,null,"PYR","Addition for aid improperly withheld in the prior year."]
["PYR","156200",13352.81]
["PYR Total",null,13352.81]
["Grand Total",null,11322626.959999999]