{"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":41,"n_cols":11,"rows_kept":41,"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 | 2017-18 Aid Based on 2016-17 Costs (Fund 27 Project 011)"]
["As of 5/21/2018 "]
["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.256665920009921,36878278.699999996,16439783.439999994,0,152760.85,276741.95,-277495.61,53470069.329999998,13723938]
["156100","H",0.256665920009921,14787828.859999999,6412599.5500000017,0,45570.67,-85719,-2016133.93,19144146.149999991,4913645]
["156200","HB",0.256665920009921,1075709.8700000001,256874.09000000005,11236.380000000003,0,0,0,1343820.3400000003,344913]
["156600","SL",0.256665920009921,104141108.34,42001008.910000026,0,613908.7699999999,892293.25,-263807.47000000003,147384511.79999992,37828583]
["156700","V",0.256665920009921,5531313.5700000003,2180575.2799999998,0,0,0,-1452434.24,6259454.6099999994,1606589]
["156800","HOS",1,489178.59,196184.09999999998,12237.720000000001,0,0,0,697600.40999999992,697601]
["158000","CCR",1,0,0,0,0,29936,0,29936,29936]
[null,null,0.256665920009921,396881465.72000021,171321012.5200001,0,3280872.27,2236006.9400000004,-2015792.22,571703565.22999978,146736822]
["159100","ASSTS",0.256665920009921,195861334.88000003,101931813.61999997,0,1584128.8499999999,198847.11,-820634.83,298755489.63000005,76680362]
["159200","SUBS",0.256665920009921,10738896.060000004,2021382.3800000001,0,89829.14,-4468.7099999999991,-10904.44,12834734.430000009,3294242]
["159300","SPEC",0.256665920009921,8783138.7400000002,3693293.5399999996,0,62654.43,0,-3748.97,12535337.739999991,3217395]
["174100","SAPCL",0.256665920009921,1393997.7500000002,653295.71,0,0,0,0,2047293.4600000007,525471]
["174200","SAPHB",0.256665920009921,12452.789999999999,3633.6600000000003,310.92,0,0,0,16397.37,4208]
["212000","SW",0.256665920009921,19501378.410000008,7873915.7699999986,0,0,262372.18,0,27637666.359999996,7093643]
["213000","GUID",0.256665920009921,10914583.119999999,4377742.0500000007,0,71782.52,33372.47,0,15397480.160000002,3952010]
["214000","HE",0.256665920009921,5851886.3999999994,2388412.0200000009,0,30167.71,15303.86,0,8285769.9900000002,2126682]
["215000","PS",1,0,0,0,0,-11673.49,0,-11673.49,-11673]
[null,null,0.256665920009921,49027850.689999968,18294186.369999994,0,69196.600000000006,265905.04000000004,0,67657138.700000048,17365273]
["218100","OT",0.256665920009921,26785553.070000011,11102657.810000001,4827847.2600000026,0,-2022.4199999999983,-710287.6100000001,42003748.110000029,10780931]
["218200","PT",0.256665920009921,11125010.580000002,4116762.01,2960463.3200000008,0,0,-479584.81,17722651.099999979,4548798]
["223300","LS",0.256665920009921,32050733.219999995,11098516.829999993,0,252775.71,140657.03,-1097323.17,42445359.620000005,10894279]
["256000","TRANSP",0.256665920009921,0,0,0,0,-15550.77,-59703.14,-75253.91,-19314]
["256200","n/a",0.256665920009921,4447051.8699999992,1159267.4499999997,576335.12000000023,0,0,0,6182654.4399999995,1586878]
["256300","n/a",0.256665920009921,0,0,208477.66,0,0,0,208477.66,53509]
["256500","n/a",0.256665920009921,0,0,125976.18999999999,0,0,0,125976.18999999999,32333]
["256600","n/a",0.256665920009921,0,0,596760.75000000012,0,0,0,596760.75000000012,153170]
["256700","n/a",0.256665920009921,0,0,72711872.600000009,0,0,0,72711872.600000009,18662655]
["256800","n/a",0.256665920009921,0,0,44925.599999999999,0,0,0,44925.599999999999,11531]
["270000","UNEMP",0.256665920009921,0,0,66698.959999999992,0,0,0,66698.959999999992,17119]
["436000","OST",0.256665920009921,0,0,8147453.2800000003,0,0,-43792.89,8103660.3899999997,2079937]
["256900","n/a",0.256665920009921,0,0,29738.1,0,0,0,29738.1,7633]
["Grand Total",null,null,936278751.23000026,407522917.11000007,90320333.859999999,6253647.5199999986,4232001.4400000013,-9251643.3300000019,1435356007.8299997,368939099]

{"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"]
["2017-18 Aid Based on 2016-17 Costs"]
[{"$f":"Computation!A3","v":"As of 5/21/2018 "}]
[]
["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",55128181,0.14999999999999936,367521154]
["DEC",55268170,0.29999999999999877,367987774]
["JAN",55153481,0.44999999999999701,367888491]
["FEB",55192194,0.59999999999999754,367903365]
["MAR",55058757,0.75,367734294]
["JUN",93138316,1,368939099]

{"sheet":"Adjustments","index":2,"n_rows":42,"n_cols":6,"rows_kept":42,"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 | 2017-18 Aid Based on 2016-17 Costs"]
[{"$f":"Computation!A3","v":"As of 5/21/2018 "}]
[]
["LEA Name","(All)"]
["LEA Code","(All)"]
[]
["Type","Function","Adjustment",null,"Key to Adjustments"]
["NVE","152000",29719.62,null,"Expenditure Adjustments"]
[null,"158000",654451.80000000005,null,"(reduce aid-eligible costs)"]
[null,"159100",513784.32999999996,null,"NVE","No Valid License: Costs of staff identified during audit as not having valid licenses for their assignments."]
[null,"159200",20091.419999999998]
[null,"215000",25319.38]
[null,"223300",2858.75]
[null,"218100",18365.919999999998,null,"QCE","Questioned Cost: Other ineligible costs identified during audit."]
[null,"156100",85719]
["NVE Total",null,1350310.2199999997,null,"STE","State Tuition: Costs funded by this LEA's State Tuition claim."]
["QCE","256000",15550.77]
["QCE Total",null,15550.77,null,"MAE","Miscellaneous: Other reductions to eligible costs."]
["STE","158000",569337.05000000005]
[null,"159100",63957.05,null,"Revenue Adjustments"]
[null,"213000",9290.58,null,"(increase aid-eligible costs)"]
[null,"223300",7107.32,null,"NIR","Non-Instrumentality: Costs for non-instrumentality charter schools authorized by a district."]
["STE Total",null,649692]
["NIR","152000",306461.57]
[null,"156600",892293.25,null,"MAR","Miscellaneous: Other additions to eligible costs."]
[null,"158000",3459795.79]
[null,"159100",776588.49000000011,null,"Prior Year Adjustments"]
[null,"159200",15622.71,null,"(reduce or increase aid received)"]
[null,"212000",262372.18,null,"PYE","Reduction for aid improperly received in the prior year."]
[null,"213000",42663.05]
[null,"214000",15303.86,null,"PYR","Addition for aid improperly withheld in the prior year."]
[null,"215000",291224.42000000004]
[null,"223300",150623.1]
[null,"218100",16343.5]
["NIR Total",null,6229291.9199999999]
["PYE","158000",4114]
[null,"215000",11673.49]
["PYE Total",null,15787.49]
["PYR","158000",34050]
["PYR Total",null,34050]
["Grand Total",null,8294682.3999999994]