{"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 | 2016-17 Aid Based on 2015-16 Costs (Fund 27 Project 011)"]
["As of 5/24/2017 "]
["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.26236684623184797,36232852.069999993,16641121.389999995,0,188755.18,-247962.66,-152298.01,52662467.970000006,13816889]
["156100","H",0.26236684623184797,15068438.640000004,6636467.1100000003,0,0,-46335.01,-2046888.61,19611682.129999999,5145456]
["156200","HB",0.26236684623184797,1072184.92,244642.52999999997,10485.170000000002,0,0,0,1327312.6199999996,348240]
["156600","SL",0.26236684623184797,102677202.74999988,41611564.99000001,0,603884.03,402468.58,-318580.94,144976539.41,38037034]
["156700","V",0.26236684623184797,5471362.5499999989,2220699.8099999996,0,0,-151589.76000000001,-1526024.9700000002,6014447.6299999999,1577995]
["156800","HOS",1,495583.8,190068.41999999998,13464.939999999999,0,0,0,699117.16,699117]
["158000","CCR",1,0,0,0,0,-22339.69,0,-22339.69,-22340]
[null,null,0.26236684623184797,392204451.50999963,170986908.81000003,0,3283134.3000000003,-93232.659999999538,-1700179.65,564681082.31000042,148153608]
["159100","ASSTS",0.26236684623184797,188319374.70000017,98998010.649999917,0,1496755.34,41278.480000000025,-1189223.8699999999,287666195.29999971,75474080]
["159200","SUBS",0.26236684623184797,10630992.859999998,2216194.9000000004,0,79066.63,-1625.47,-8084.33,12916544.589999998,3388876]
["159300","SPEC",0.26236684623184797,9080643.2500000037,3927174.1200000024,0,59906.400000000001,0,-92361.14,12975362.630000005,3404303]
["174100","SAPCL",0.26236684623184797,1577870.1199999999,740072.08000000007,0,0,0,0,2317942.2000000002,608151]
["174200","SAPHB",0.26236684623184797,10102.460000000001,3751.98,5478.88,0,0,0,19333.320000000003,5072]
["212000","SW",0.26236684623184797,18930571.240000002,7861440.7799999984,0,0,27605.079999999987,0,26819617.099999994,7036577]
["213000","GUID",0.26236684623184797,10603302.839999996,4333997.8099999987,0,90474.02,4711.4400000000023,0,15032486.10999999,3944026]
["214000","HE",0.26236684623184797,5698719.830000001,2358870.5499999993,0,16011.78,7571.23,0,8081173.3899999987,2120232]
["215000","PS",0.26236684623184797,47691301.940000013,17977491.179999992,0,94439.59,219221.25999999998,0,65982453.970000006,17311603]
["218100","OT",0.26236684623184797,25692369.159999989,10784208.000000007,4395617.4699999988,0,-29343.989999999998,-685026.75999999978,40157823.880000025,10536082]
["218200","PT",0.26236684623184797,10863119.459999997,4073307.85,3040382.96,0,0,-442289.54000000004,17534520.729999997,4600477]
["223300","LS",0.26236684623184797,30981709.670000009,10587475.410000009,0,115597.11,25993.390000000029,-976934.28,40733841.29999999,10687208]
["256000","TRANSP",1,0,0,0,0,-6769.76,0,-6769.76,-6770]
[null,null,0.26236684623184797,0,0,0,0,22401.360000000001,-75475.659999999989,-53074.3,-13926]
["256200","n/a",0.26236684623184797,4448044.79,1158571.4899999993,562944.42000000016,0,0,0,6169560.6999999965,1618681]
["256300","n/a",0.26236684623184797,0,0,42212.03,0,0,0,42212.03,11075]
["256500","n/a",0.26236684623184797,0,0,216730.33,0,0,0,216730.33,56863]
["256600","n/a",0.26236684623184797,0,0,420016.32000000007,0,0,0,420016.32000000007,110200]
["256700","n/a",0.26236684623184797,0,0,69797305.710000023,0,0,0,69797305.710000023,18312499]
["256800","n/a",0.26236684623184797,0,0,52117.54,0,0,0,52117.54,13673]
["270000","UNEMP",0.26236684623184797,0,0,112442.94000000002,0,0,-295.39,112147.55,29423]
["436000","OST",0.26236684623184797,0,0,7654890.5600000005,0,-105498.26,-209247.42,7340144.8800000008,1925810]
["256900","n/a",0.26236684623184797,0,0,33869.1,0,0,0,33869.1,8886]
["Grand Total",null,null,917750198.55999982,403552039.86000001,86357958.37000002,6028024.3800000008,46553.560000000507,-9422910.5700000003,1404311864.1600001,368939100]

{"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"]
["2016-17 Aid Based on 2015-16 Costs"]
[{"$f":"Computation!A3","v":"As of 5/24/2017 "}]
[]
["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",54397266,0.14999999999999938,362648339]
["DEC",55217292,0.29999999999999877,365381789]
["JAN",54917701,0.44999999999999701,365627186]
["FEB",55944572,0.59999999999999765,367461397]
["MAR",55110778,0.75,367450077]
["JUN",93351491,1,368939100]

{"sheet":"Adjustments","index":2,"n_rows":49,"n_cols":6,"rows_kept":49,"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 | 2016-17 Aid Based on 2015-16 Costs"]
[{"$f":"Computation!A3","v":"As of 5/24/2017 "}]
[]
["LEA Name","(All)"]
["LEA Code","(All)"]
[]
["Type","Function","Adjustment",null,"Key to Adjustments"]
["NVE","152000",360039.03,null,"Expenditure Adjustments"]
[null,"156600",13751.509999999998,null,"(reduce aid-eligible costs)"]
[null,"156700",151589.76000000001,null,"NVE","No Valid License: Costs of staff identified during audit as not having valid licenses for their assignments."]
[null,"158000",2043283.8599999996]
[null,"159100",716004.91]
[null,"159200",1625.47]
[null,"212000",89540.88,null,"QCE","Questioned Cost: Other ineligible costs identified during audit."]
[null,"213000",23914.989999999998]
[null,"215000",30512.010000000002,null,"STE","State Tuition: Costs funded by this LEA's State Tuition claim."]
[null,"223300",122339.76999999999]
[null,"218100",34788.99,null,"MAE","Miscellaneous: Other reductions to eligible costs."]
[null,"156100",33635.009999999995]
["NVE Total",null,3621026.19,null,"Revenue Adjustments"]
["QCE","256000",3754,null,"(increase aid-eligible costs)"]
["QCE Total",null,3754,null,"NIR","Non-Instrumentality: Costs for non-instrumentality charter schools authorized by a district."]
["STE","156600",21428]
[null,"158000",636652.30999999994]
[null,"159100",95996.84,null,"MAR","Miscellaneous: Other additions to eligible costs."]
[null,"212000",28078.35]
[null,"213000",1245.6400000000001,null,"Prior Year Adjustments"]
[null,"223300",6914.87,null,"(reduce or increase aid received)"]
[null,"156100",12700,null,"PYE","Reduction for aid improperly received in the prior year."]
["STE Total",null,803016.00999999989]
["NIR","152000",112076.37,null,"PYR","Addition for aid improperly withheld in the prior year."]
[null,"156600",437648.09]
[null,"158000",2586703.5099999998]
[null,"159100",853280.2300000001]
[null,"212000",145224.31]
[null,"213000",29872.07]
[null,"214000",7571.23]
[null,"215000",249733.27]
[null,"223300",155248.03000000003]
[null,"256000",26155.360000000001]
[null,"218100",5445]
["NIR Total",null,4608957.47]
["PYE","158000",22339.69]
[null,"256000",6769.76]
["PYE Total",null,29109.449999999997]
["MAE","436000",105498.26]
["MAE Total",null,105498.26]
["Grand Total",null,9171361.3799999971]