MOEq — SAIPE and enrollment data used to rank LEAs for High-Need and High-Poverty

Summary

A workbook titled MOEq: SAIPE and enrollment data used to rank LEAs for High-Need and High-Poverty designations, with a Data sources sheet and a Data sheet. The sources sheet lists the SAIPE school district estimates, enrollment files and FY22 and FY23 special education, transportation and other spending files. The Data sheet ranks districts by SAIPE poverty rate and fall 2021 enrollment, for example Winooski SD at 0.2032 and Orleans Central SU at 0.1746, with cumulative enrollment. Total enrollment is 80447, with thresholds of 40,224 (50%) for High-Need and 16,090 (20%) for Highest-Poverty, plus FY2022 and FY2023 totals per ADM.

Summary drafted by a model from the document's text below and checked by script against that text before publication. It is a navigation aid, not a reading of what the document proves. Where AI is used

Cite this document

“MOEq — SAIPE and enrollment data used to rank LEAs for High-Need and High-Poverty.” Original at www.ed.gov. Archived at Pandemic Darlings, https://pandemicdarlings.com/source-documents/moeq-saipe-and-enrollment-data-used-to-rank-leas-for-high-need-and-hig-a2ce2b5088/, SHA-256 a206367c25832217c997f018b21dabb2d8274bdcb704877a7d4027ae290ff6e6.

Full text

Text extracted from the spreadsheet file: one line per row, cells separated by tabs, each sheet headed by its name. Numbers appear as stored, without the workbook’s formatting.

Sheet: Data sources
MOEq
SAIPE and enrollment data used to rank LEAs for High-Need and High-Poverty
				FY2023 done for	FY2024 done for
	File	Path		FY22 vs FY21	FY23 vs FY22
SAIPE year & poverty data	SAIPE School District Estimates 2021 ussd21 (1).xls	J:\FY2024\Brad24\ARPA MOEq\SAIPE files		2020	2021
Enrollment	FY24 Small Schools v02 Westminster Lincoln.xlsm	J:\FY2024\Categoricals24	FY24 SSG has FY23 enrollments	FY2022 (FY2023 SSG)	FY2023 (FY24 SSG)
ADM	FY24 EqPup FRZ v02.xlsm	J:\FY2024\Reports24\EqPup24\FY24 FRZ EqPup	Tab: FY23TORO EC - after early college hold-harmless
Ed spending	FY23Fin v06.xlsm	J:\FY2023\Base23
Census Block Grant	FY23 SpEd calc 05-15-2023 ExtOrd.xlsx	S:\Excel\FY2023\FY23 05-15-23 ExtOrd payment	col. F
EEE grant	FY23 SpEd calc 05-15-2023 ExtOrd.xlsx	S:\Excel\FY2023\FY23 05-15-23 ExtOrd payment	col. G
ExtraOrdinary	FY23 SpEd calc 09-15-2023 ExtOrd.xlsx	S:\Excel\FY2023\FY23 SpEd Calc 09-15-2023 RECON	col V
State-Placed	FY23 SpEd calc 09-15-2023 ExtOrd.xlsx	S:\Excel\FY2023\FY23 SpEd Calc 09-15-2023 RECON	col AB
SSG/MSG	FY23 SpEd calc 05-15-2023 ExtOrd.xlsx	S:\Excel\FY2023\FY23 05-15-23 ExtOrd payment
Transportation aid	FY2023 Final Allowable Transportation Allocations v1.0 (003).xlsx	J:\FY2023\Categoricals23\Transportation	regular + extraordinary
Surplus	Budget Data Convert FY23 v01.xlsm	J:\FY2023\Base23\Budget23\2 Convert	SUMIFS(col I, col A, B3, col G, "6999")
FY2022 LEA data	LEA MOEq data & calcs REWORK surplus.xlsx	J:\FY2023\Brad23\ARPA MOEq for FY23\MOEq FY22 vs FY21	cols. X - AC
Data for 2 columns were updated and revised:
FY2022 SpEd MSBG, SEER, ExtOrd ACTUAL	FY22 SpEd data were based on service plan estimates, not actual State expenditures.
FY2023 ExtOrd UPDATED	SpEd extraordinary costs changed slightly due to minor revisions.

Sheet: Data
			K ÷ J	80447	40223.5	40224	16090	625465	88727	9163	207921568.64	1496610620	20443677	7977303	7050104	44632527	1784635799.64	83786.66	21300	1576870735	186993183	7511638	46307392.03	3777153.6	7856702	21786000	46733179	1897835982.63	83555.27	22714
NCES District ID	State District ID	SU_Name	SAIPE_pov_rate 2020	SU_ENROLLMENT fall 2021	Enr_Cumulative	High-Need LEA (Cumulative Sum ≥ 40,224 50% of enrl)	Highest-Poverty LEA (Cumulative Sum ≥ 16,090 20% of enrl)	Estimated Total Population	Estimated Population 5-17	Estimated number of relevant children 5 to 17 years old in poverty who are related to the householder	FY2022 SpEd MSBG, SEER, ExtOrd ACTUAL	FY2022 EdSpend	FY2022 TransAid	FY2022 SSG/MSG	FY2022 EEE	FY2022 Surplus	FY2022 Total	FY2022 ADM	FY22 Total per ADM	FY2023 Ed Spend	FY2023 CBG	FY2023 EEE grant	FY2023 ExtOrd UPDATED	FY2023 SPS	FY2023 SSG/MSG	FY2023 Transportation	FY2023 Surplus	FY2023 Total	FY2023 ADM	FY23 Total per ADM
5099917	S017	Winooski SD	0.2032	770	770	Y	Y	8240	817	166	2832908.53	16213849	26388	0	74953	0	19148098.53	773.65	24750	18013621	2479902	80248	479255.38	0	0	23428	0	21076454.38	796.19	26472	1722
5099934	S034	Orleans Central SU	0.1746	1140	1910	Y	Y	7636	1191	208	2692339.34	16125144	343839	650179	86742	1517117	21415360.34	1073.5	19949	16451961	2445666	92870	376537.83	107190.33	650179	357107	1180176	21661687.16	1066.61	20309	360
5099940	S040	Rutland City SU	0.1733	2022	3932	Y	Y	15812	1950	338	5586078.01	34318248	466026	0	151382	1000000	41521734.01	1818.14	22837	36272891	5435325	162078	31870.64	0	0	515750	0	42417914.64	1765.78	24022	1185
5099905	S005	Southwest Vermont SU	0.1681	3263	7195	Y	Y	5273	3641	612	8306094.1	57883590	553464	39500	285985	4345001	71413634.1	3380.16	21127	60298486	7605981	269623	2211275.03	47041.92	39500	536453	4755200	75763559.95	3396.72	22305	1178
5099931	S031	North Country SU	0.1492	2588	9783	Y	Y	18901	2681	400	7993114.86	45053924	1089192	686357	221846	386594	55431027.86	2619.67	21160	48677304	6427628	237520	1216976.17	160565.98	686357	924330	470607	58801288.15	2613.58	22498	1338
5099956	S056	Springfield SD	0.147	1227	11010	Y	Y	9131	1204	177	4468881.52	23400709	219415	0	100424	1000000	29189429.52	1227.38	23782	24295181	3207826	107519	2494049.26	325748.29	0	221296	1000000	31651619.55	1237.99	25567	1785
5099947	S047	Windham Northeast SU	0.144	1052	12062	Y	Y	8908	1285	185	2819095.01	25165865	368537	83877	102028	0	28539402.01	1090.48	26171	22090050	3546071	109237	128235.86	8365	95893	372631	0	26350482.86	1092.86	24111	-2060
5099928	S028	Orange Southwest SU	0.1387	879	12941	Y	Y	7289	923	128	1976579.21	15609261	272292	177706	75327	826342	18937507.21	850.27	22272	16914378	1645565	80649	521008.86	599	177706	255435	746171	20341511.86	832.85	24424	2152
5000407	S067	Kingdom East SD	0.1365	1244	14185	Y	Y	12526	1744	238	4101041.02	29995376	473909	0	155769	0	34726095.02	1791.55	19383	32858305	3922092	166774	490417.25	63027.44	428520	477968	0	38407103.69	1756.88	21861	2478
5099920	S020	Franklin Northeast SU	0.1364	1900	16085	Y	Y	11384	1943	265	2665756.32	30771117	549069	213275	170047	911311	35280575.32	1970.45	17905	33013209	3423380	182062	451195.5	86000.4	213275	544611	635366	38549098.9	1957.07	19697	1792
5099915	S015	Burlington SD	0.134	3469	19554	Y	N	44887	3903	523	9231008.69	68895317	134312	0	320784	4175000	82756421.69	3495.78	23673	74097698	8556208	343443	1464651.68	163051.04	0	293825	2100000	87018876.72	3404.84	25557	1884
5099935	S035	Orleans Southwest SU	0.1336	986	20540	Y	N	7925	1123	150	2971573.19	20403482	375849	350670	82853	555304	24739731.19	1057.91	23385	21406089	2496227	88707	467937.72	0	350670	390866	510131	25710627.72	1026.03	25058	1673
5099904	S004	Slate Valley Unified Union SD	0.1335	1252	21792	Y	N	10381	1326	177	2494314.88	21059100	386467	116436	111122	1799336	25966775.88	1254.5	20699	21598121	2507931	118973	73431.44	204241.75	116436	436487	1204087	26259708.19	1283.85	20454	-245
5099949	S049	Windham Southwest SU	0.1301	552	22344	Y	N	6081	830	108	2094261.54	13083559	238352	295026	56785	369090	16137073.54	636	25373	12998583	1787798	60797	930635.15	0	302138	262421	777363	17119735.15	643.65	26598	1225
5099911	S011	St Johnsbury SD	0.1293	680	23024	Y	N	7399	1152	149	3681184.17	18217767	212529	0	79006	0	22190486.17	1066.81	20801	18886265	2940054	84588	1742607.66	0	0	193784	0	23847298.66	1071.04	22266	1465
5099927	S027	Orange East SU	0.1249	1536	24560	Y	N	12770	1834	229	5009189.16	33599073	594955	29303	149103	382959	39764582.16	1747.93	22750	34715808	4034623	159637	1129732.18	118465.61	29303	497524	976680	41661772.79	1780.59	23398	648
5099923	S023	Maple Run SD	0.1248	2624	27184	Y	N	15988	2388	298	5934638.61	43451554	379070	0	233766	0	49999028.61	2397.31	20856	45953936	5817621	250283	850307.81	0	0	549313	0	53421460.81	2404.14	22221	1365
5099948	S048	Windham Southeast SU	0.1233	2572	29756	Y	N	21062	2854	352	7314981.11	49992485	537496	201047	211916	1025000	59282925.11	2415.35	24544	54086949	5958784	226889	1677872.37	140728.57	201047	653624	900000	63845893.94	2470.9	25839	1295
5099919	S019	Essex North SU	0.1211	178	29934	Y	N	2956	413	50	1125934.16	7538582	109201	156871	31273	614407	9576268.16	446.8	21433	8653781	926081	33483	507075.73	0	156871	95623	200000	10572914.73	415.9	25422	3989
5099933	S033	Mill River Unified Union SD	0.118	784	30718	Y	N	6192	839	99	1727377.15	13688744	156417	164691	67628	700000	16504857.15	699.33	23601	13874505	1763789	72406	0	54580.47	164691	196107	700000	16826078.47	705.28	23857	256
5000007	S061	Barre SU	0.1175	2157	32875	Y	N	16458	2273	267	6976625.4	36656975	614660	0	203789	600000	45052049.4	2143.83	21015	37491934	6132513	218188	2118101.04	468559.8	0	517120	700000	47646415.84	2179.32	21863	848
5099924	S024	Grand Isle SU	0.1171	543	33418	Y	N	7421	965	113	3292504.93	16985860	172315	238508	73167	1152788	21915142.93	874	25075	17561095	2060891	78336	213616	95432.04	189374	249595	940250	21388589.04	854.67	25026	-49
5000385	S063	Two Rivers SU	0.1122	929	34347	Y	N	8808	1150	129	3701786.26	18369640	187002	184198	96691	0	22539317.26	992.89	22701	19508660	2885742	103523	1138283.92	5912	184198	258660	0	24084978.92	944.65	25496	2795
5099930	S030	White River Valley SU	0.1096	1242	35589	Y	N	12487	1724	189	3839191.49	30133911	447323	636119	136511	423600	35616655.49	1645.34	21647	31127816	3523339	146156	990342.44	27526	636119	465042	650000	37566340.44	1699.39	22106	459
5099946	S046	Windham Central SU	0.1092	754	36343	Y	N	9799	1218	133	2929451.23	20437181	243909	491477	80816	13000	24195834.23	963.75	25106	22872389	2778862	86526	397076.34	0	491477	251695	0	26878025.34	931.56	28853	3747
5099925	S025	Lamoille North SU	0.1066	1680	38023	Y	N	12819	1895	202	3681188.79	30808536	593085	118251	142457	1300000	36643517.79	1683.06	21772	32380205	3347938	152522	910951.5	219151.21	118251	704528	1273786	39107332.71	1739.51	22482	710
5000404	S068	Central Vermont SU	0.1041	1271	39294	Y	N	11577	1335	139	3484295.67	21569122	336888	645086	117225	625000	26777616.67	1315.67	20353	22439800	2867145	125507	1086529.43	68735	216566	386132	625000	27815414.43	1333.72	20856	503
5099906	S006	Bennington Rutland SU	0.1035	1166	40460	Y	N	15724	2289	237	5622976.04	40255338	512239	175330	158155	926121	47650159.04	2174.18	21916	43050838	4710018	169330	2375828.01	283389.81	156154	499765	6564	51251886.82	2128.34	24081	2165
5099921	S021	Missisquoi Valley SD	0.1009	1793	42253	N	N	11664	1824	184	4080941.28	27829397	578936	68169	155571	2311823	35024837.28	1771.17	19775	29429097	3967545	166563	1188469.18	0	68169	602272	2367222	37789337.18	1813.29	20840	1065
5099936	S036	Rutland Northeast SU	0.0996	1449	43702	N	N	11507	1607	160	3043941.12	25178877	428079	198396	123446	460000	29432739.12	1548.95	19002	27345694	3039698	132168	293674.32	14461.62	224595	436957	507122	31994369.94	1509.23	21199	2197
5099909	S009	Caledonia Central SU	0.0986	1312	45014	N	N	11255	1623	160	4036745.03	28399648	406981	433166	113427	0	33389967.03	1476.95	22607	29412419	3756255	121441	1293020.85	0	433166	384942	475000	35876243.85	1460.74	24560	1953
5000384	S064	Rivendell Interstate SD	0.0971	444	45458	N	N	2302	278	27	1090054.7	6847124	184262	0	27412	0	8148852.7	291.01	28002	7248101	874372	29341	582777.51	0	0	256041	0	8990632.51	289.72	31032	3030
5099926	S026	Lamoille South SU	0.0958	1631	47089	N	N	11624	1796	172	2911879.12	27368669	302605	13106	124269	1100000	31820528.12	1569.16	20279	28465425	2964684	133049	678273.51	5741.12	0	352978	1100000	33700150.63	1541.28	21865	1586
5000405	S066	Greater Rutland County SU	0.0948	1608	48697	N	N	13283	1815	172	3026220.27	30854661	257361	172070	151979	512287	34974578.27	1836.87	19040	31879618	2950928	162717	487726.06	35607.94	172070	327920	967649	36984236	1892.57	19542	502
5099954	S054	Hartford SD	0.0923	1475	50172	N	N	10768	1409	130	3192518.29	23662685	303779	0	112233	668724	27939939.29	1328.47	21032	24976752	3490704	120163	748939.19	218644	0	320373	1090599	30966174.19	1300.35	23814	2782
5099952	S052	Windsor Southeast SU	0.086	1188	51360	N	N	11276	1512	130	4291390	25580111	286654	84046	112748	202950	30557899	1350.16	22633	26847202	3813201	120714	730741.42	0	84046	301009	1063321	32960234.42	1353.12	24359	1726
5099902	S002	Addison Northwest SD	0.0813	922	52282	N	N	7633	910	74	2388606	18100384	195980	84512	71866	266000	21107348	906.17	23293	18532369	2164474	76944	1035285.77	19259.02	0	263158	337763	22429252.79	941.55	23822	529
5099910	S010	Milton SD	0.0804	1537	53819	N	N	10758	1629	131	4233978.05	25368847	484715	0	126862	2720456	32934858.05	1529.29	21536	27151663	4235397	135825	554233.78	13999.94	0	416481	3081068	35588667.72	1461.47	24351	2815
5000406	S069	Montpelier-Roxbury SD	0.0799	1247	55066	N	N	8776	1189	95	2083129.53	21660015	180528	79992	98613	400000	24502277.53	1226.51	19977	22524641	1959989	105580	724537.68	42901	79992	198238	400000	26035878.68	1177.58	22110	2133
5099903	S003	Addison Central SU	0.079	1766	56832	N	N	15576	1734	137	2502488.88	32770107	343667	474113	144391	1173744	37408510.88	1709.55	21882	34563318	2349758	154593	131472.82	0	474113	339661	2323099	40336014.82	1717.57	23484	1602
5099901	S001	Mt Abraham Unified School District	0.078	1433	58265	N	N	10594	1398	109	3003762.45	27325666	289968	72456	118200	365929	31175981.45	1438.16	21678	28617714	2322872	126551	1047482.61	3793.24	72456	418092	0	32608960.85	1435.26	22720	1042
5099916	S016	South Burlington SD	0.0694	2696	60961	N	N	20357	2709	188	6180057.5	43174277	535536	0	208838	500000	50598708.5	2545.31	19879	44744715	5420356	223594	1330945.61	137029.45	0	488921	2000000	54345561.06	2576.65	21092	1213
5099951	S051	Windsor Central SU	0.0683	1067	62028	N	N	9109	1215	83	1917906.45	18054898	217406	245249	71048	0	20506507.45	1018.55	20133	19563697	1617647	76067	433807.74	0	245249	266978	470000	22673445.74	993.34	22825	2692
5099907	S007	Colchester SD	0.0654	2390	64418	N	N	17363	2370	155	5933542.44	35854970	483460	0	205826	1500000	43977798.44	2305.56	19075	37637147	4679819	220369	1436911.6	37370.54	0	530702	1600000	46142319.14	2318.45	19902	827
5099932	S032	Washington Central SU	0.0649	1486	65904	N	N	9878	1433	93	3822203.9	27792291	588781	171302	105049	144000	32623626.9	1427.92	22847	28821017	3326702	112471	1141891.47	189999.71	171302	685560	325468	34774411.18	1365.66	25463	2616
5099942	S042	Harwood Unified Union SD	0.058	1793	67697	N	N	13719	1914	111	4034588.16	33029369	420736	105907	155765	1600000	39346365.16	1785.95	22031	35178064	3572720	166770	1277997.99	64167.53	105907	518234	1524424	42408284.52	1780.58	23817	1786
5000394	S065	Essex-Westford SD	0.0494	3822	71519	N	N	24236	3723	184	9580549.33	63626750	744241	0	285745	4654744	78892029.33	3730.79	21146	67850314	8927588	305934	1176882.55	43172.08	0	784652	4041373	83129915.63	3643.68	22815	1669
5099922	S022	Franklin West SU	0.0482	1775	73294	N	N	11289	2034	98	3085564.41	30189151	459669	78281	167628	368791	34349084.41	2007.06	17114	31674802	2646152	179471	766216.85	68931.24	78281	558629	734190	36706673.09	2050.76	17899	785
5099914	S014	Champlain Valley SD	0.0423	4201	77495	N	N	27302	4446	188	8465170.05	69969649	1143548	0	330466	0	79908833.05	4149.89	19256	75956403	7434993	353815	1423316.18	216580.03	0	1316344	0	86701451.21	4166.44	20809	1553
5099912	S012	Mt Mansfield Unified Union SD	0.0411	2613	80108	N	N	15722	2605	107	5619568.17	42244792	896221	42631	211937	790332	49805481.17	2612.02	19068	43650951	5390641	226911	1286704.56	17183.48	42631	773922	1675000	53063944.04	2612.07	20315	1247
5099955	S055	Sau 70	0.0211	339	80447	N	N	3640	664	14	842393.12	12044973	116364	0	49235	244777	13297742.12	615.5	21605	13209754	851688	52713	60280.58	0	0	112816	298500	14585751.58	620	23525	1920
											207921568.64	1496610620	20443677	7977303	7050104	44632527	1784635799.64	83786.66	21300	1576870735	186993183	7511638	46307392.03	3777153.6	7856702	21786000	46733179	1897835982.63	83555.27	22714

Sheet: LEA_ranking for FY24
			K ÷ J	80447	40223.5	40224	16090	625465	88727	9163			Columns I, J, & K are 2020 SAIPE data
NCES District ID	State District ID	SU_Name	SAIPE_pov_rate 2020	SU_ENROLLMENT fall 2021	Enr_Cumulative	High-Need LEA (Cumulative Sum ≥ 40,224 50% of enrl)	Highest-Poverty LEA (Cumulative Sum ≥ 16,090 20% of enrl)	Estimated Total Population	Estimated Population 5-17	Estimated number of relevant children 5 to 17 years old in poverty who are related to the householder				FY24 rank	FY23 rank			FY23 list
5099917	S017	Winooski SD	0.2032	770	770	Y	Y	8240	817	166				1	1	5099917	SU017	WINOOSKI SD
5099934	S034	Orleans Central SU	0.1746	1140	1910	Y	Y	7636	1191	208				2	2	5099934	SU034	ORLEANS CENTRAL SU
5099940	S040	Rutland City SU	0.1733	2022	3932	Y	Y	15812	1950	338				3	3	5099940	SU040	RUTLAND CITY SU
5099905	S005	Southwest Vermont SU	0.1681	3263	7195	Y	Y	5273	3641	612				19	4	5099919	SU019	ESSEX NORTH SU
5099931	S031	North Country SU	0.1492	2588	9783	Y	Y	18901	2681	400				15	5	5099911	SU011	ST JOHNSBURY SD
5099956	S056	Springfield SD	0.147	1227	11010	Y	Y	9131	1204	177				7	6	5099947	SU047	WINDHAM NORTHEAST SU
5099947	S047	Windham Northeast SU	0.144	1052	12062	Y	Y	8908	1285	185				4	7	5099905	SU005	SOUTHWEST VERMONT SU
5099928	S028	Orange Southwest SU	0.1387	879	12941	Y	Y	7289	923	128				6	8	5099956	SU056	SPRINGFIELD SD
5000407	S067	Kingdom East SD	0.1365	1244	14185	Y	Y	12526	1744	238				5	9	5099931	SU031	NORTH COUNTRY SU
5099920	S020	Franklin Northeast SU	0.1364	1900	16085	Y	Y	11384	1943	265				8	10	5099928	SU028	ORANGE SOUTHWEST SU
5099915	S015	Burlington SD	0.134	3469	19554	Y	Y	44887	3903	523				13	11	5099904	SU004	SLATE VALLEY UNIFIED UNION SCHOOL DISTRICT
5099935	S035	Orleans Southwest SU	0.1336	986	20540	Y	N	7925	1123	150				18	12	5099948	SU048	WINDHAM SOUTHEAST SU
5099904	S004	Slate Valley Unified Union SD	0.1335	1252	21792	Y	N	10381	1326	177				14	13	5099949	SU049	WINDHAM SOUTHWEST SU
5099949	S049	Windham Southwest SU	0.1301	552	22344	Y	N	6081	830	108				10	14	5099920	SU020	FRANKLIN NORTHEAST SU
5099911	S011	St Johnsbury SD	0.1293	680	23024	Y	N	7399	1152	149				16	15	5099927	SU027	ORANGE EAST SU
5099927	S027	Orange East SU	0.1249	1536	24560	Y	N	12770	1834	229				11	16	5099915	SU015	BURLINGTON SD
5099923	S023	Maple Run SD	0.1248	2624	27184	Y	N	15988	2388	298				12	17	5099935	SU035	ORLEANS SOUTHWEST SU
5099948	S048	Windham Southeast SU	0.1233	2572	29756	Y	N	21062	2854	352				9	18	5000407	SU067	KINGDOM EAST SUPERVISORY DISTRICT
5099919	S019	Essex North SU	0.1211	178	29934	Y	N	2956	413	50				25	19	5099946	SU046	WINDHAM CENTRAL SU
5099933	S033	Mill River Unified Union SD	0.118	784	30718	Y	N	6192	839	99				20	20	5099933	SU033	MILL RIVER UNIFIED UNION SUPERVISORY DISTRICT
5000007	S061	Barre SU	0.1175	2157	32875	Y	N	16458	2273	267				24	21	5099930	SU030	WHITE RIVER VALLEY SU
5099924	S024	Grand Isle SU	0.1171	543	33418	Y	N	7421	965	113				21	22	5000007	SU061	BARRE SU
5000385	S063	Two Rivers SU	0.1122	929	34347	Y	N	8808	1150	129				29	23	5099921	SU021	MISSISQUOI VALLEY SCHOOL DISTRICT
5099930	S030	White River Valley SU	0.1096	1242	35589	Y	N	12487	1724	189				17	24	5099923	SU023	MAPLE RUN SD
5099946	S046	Windham Central SU	0.1092	754	36343	Y	N	9799	1218	133				22	25	5099924	SU024	GRAND ISLE SU
5099925	S025	Lamoille North SU	0.1066	1680	38023	Y	N	12819	1895	202				32	26	5000384	SU064	RIVENDELL INTERSTATE SD
5000404	S068	Central Vermont SU	0.1041	1271	39294	Y	N	11577	1335	139				31	27	5099909	SU009	CALEDONIA CENTRAL SU
5099906	S006	Bennington Rutland SU	0.1035	1166	40460	Y	N	15724	2289	237				26	28	5099925	SU025	LAMOILLE NORTH SU
5099921	S021	Missisquoi Valley SD	0.1009	1793	42253	N	N	11664	1824	184				28	29	5099906	SU006	BENNINGTON RUTLAND SU
5099936	S036	Rutland Northeast SU	0.0996	1449	43702	N	N	11507	1607	160				30	30	5099936	SU036	RUTLAND NORTHEAST SU
5099909	S009	Caledonia Central SU	0.0986	1312	45014	N	N	11255	1623	160				23	31	5000385	SU063	TWO RIVERS SU
5000384	S064	Rivendell Interstate SD	0.0971	444	45458	N	N	2302	278	27				34	32	5000405	SU066	GREATER RUTLAND COUNTY SU
5099926	S026	Lamoille South SU	0.0958	1631	47089	N	N	11624	1796	172				36	33	5099952	SU052	WINDSOR SOUTHEAST SU
5000405	S066	Greater Rutland County SU	0.0948	1608	48697	N	N	13283	1815	172				33	34	5099926	SU026	LAMOILLE SOUTH SU
5099954	S054	Hartford SD	0.0923	1475	50172	N	N	10768	1409	130				27	35	5000404	SU068	CENTRAL VERMONT SU
5099952	S052	Windsor Southeast SU	0.086	1188	51360	N	N	11276	1512	130				35	36	5099954	SU054	HARTFORD SD
5099902	S002	Addison Northwest SD	0.0813	922	52282	N	N	7633	910	74				43	37	5099951	SU051	WINDSOR CENTRAL SU
5099910	S010	Milton SD	0.0804	1537	53819	N	N	10758	1629	131				41	38	5099901	SU001	MT ABRAHAM UNIFIED SCHOOL DISTRICT
5000406	S069	Montpelier-Roxbury SD	0.0799	1247	55066	N	N	8776	1189	95				38	39	5099910	SU010	MILTON SD
5099903	S003	Addison Central SU	0.079	1766	56832	N	N	15576	1734	137				40	40	5099903	SU003	ADDISON CENTRAL SU
5099901	S001	Mt Abraham Unified School District	0.078	1433	58265	N	N	10594	1398	109				46	41	5099942	SU042	HARWOOD UNIFIED UNION SD
5099916	S016	South Burlington SD	0.0694	2696	60961	N	N	20357	2709	188				44	42	5099907	SU007	COLCHESTER SD
5099951	S051	Windsor Central SU	0.0683	1067	62028	N	N	9109	1215	83				39	43	5000406	SU069	MONTPELIER-ROXBURY SD
5099907	S007	Colchester SD	0.0654	2390	64418	N	N	17363	2370	155				37	44	5099902	SU002	ADDISON NORTHWEST SD
5099932	S032	Washington Central SU	0.0649	1486	65904	N	N	9878	1433	93				45	45	5099932	SU032	WASHINGTON CENTRAL SU
5099942	S042	Harwood Unified Union SD	0.058	1793	67697	N	N	13719	1914	111				42	46	5099916	SU016	SOUTH BURLINGTON SD
5000394	S065	Essex-Westford SD	0.0494	3822	71519	N	N	24236	3723	184				48	47	5099922	SU022	FRANKLIN WEST SU
5099922	S022	Franklin West SU	0.0482	1775	73294	N	N	11289	2034	98				47	48	5000394	SU065	ESSEX-WESTFORD SUPERVISORY DISTRICT
5099914	S014	Champlain Valley SD	0.0423	4201	77495	N	N	27302	4446	188				49	49	5099914	SU014	CHAMPLAIN VALLEY SUPERVISORY DISTRICT
5099912	S012	Mt Mansfield Unified Union SD	0.0411	2613	80108	N	N	15722	2605	107				50	50	5099912	SU012	MT MANSFIELD UNIFIED UNION SD
5099955	S055	Sau 70	0.0211	339	80447	N	N	3640	664	14				51	51	5099955	SU055	SAU 70

Sheet: 24HighNeedsSummary
				40460		40224
NCES District ID	State District ID	SU_Name	SAIPE_pov_rate 2020	SU_ENROLLMENT fall 2021	Enr_Cumulative	High-Need LEA (Cumulative Sum ≥ 40,224 50% of enrl)	Total FY22	ADM for FY22	State funds per ADM FY22	Total FY23 ESTIMATE ONLY	ADM for FY23	State funds per ADM FY23	Per Pupil change FY22 to FY23	Exceptions for LEA MOEq
5099917	S017	Winooski SD	0.2032	770	770	Y	19148098.53	773.65	24750	21076454.38	796.19	26472	1722	less than 1,000 and 1 school per grade span
5099934	S034	Orleans Central SU	0.1746	1140	1910	Y	21415360.34	1073.5	19949	21661687.16	1066.61	20309	360	0
5099940	S040	Rutland City SU	0.1733	2022	3932	Y	41521734.01	1818.14	22837	42417914.64	1765.78	24022	1185	0
5099905	S005	Southwest Vermont SU	0.1681	3263	7195	Y	71413634.1	3380.16	21127	75763559.95	3396.72	22305	1178	0
5099931	S031	North Country SU	0.1492	2588	9783	Y	55431027.86	2619.67	21160	58801288.15	2613.58	22498	1338	0
5099956	S056	Springfield SD	0.147	1227	11010	Y	29189429.52	1227.38	23782	31651619.55	1237.99	25567	1785	one school per grade span
5099947	S047	Windham Northeast SU	0.144	1052	12062	Y	28539402.01	1090.48	26171	26350482.86	1092.86	24111	-2060
5099928	S028	Orange Southwest SU	0.1387	879	12941	Y	18937507.21	850.27	22272	20341511.86	832.85	24424	2152	less than 1,000
5000407	S067	Kingdom East SD	0.1365	1244	14185	Y	34726095.02	1791.55	19383	38407103.69	1756.88	21861	2478
5099920	S020	Franklin Northeast SU	0.1364	1900	16085	Y	35280575.32	1970.45	17905	38549098.9	1957.07	19697	1792
5099915	S015	Burlington SD	0.134	3469	19554	Y	82756421.69	3495.78	23673	87018876.72	3404.84	25557	1884
5099935	S035	Orleans Southwest SU	0.1336	986	20540	Y	24739731.19	1057.91	23385	25710627.72	1026.03	25058	1673	less than 1,000
5099904	S004	Slate Valley Unified Union SD	0.1335	1252	21792	Y	25966775.88	1254.5	20699	26259708.19	1283.85	20454	-245
5099949	S049	Windham Southwest SU	0.1301	552	22344	Y	16137073.54	636	25373	17119735.15	643.65	26598	1225	less than 1,000
5099911	S011	St Johnsbury SD	0.1293	680	23024	Y	22190486.17	1066.81	20801	23847298.66	1071.04	22266	1465	less than 1,000 and 1 school per grade span
5099927	S027	Orange East SU	0.1249	1536	24560	Y	39764582.16	1747.93	22750	41661772.79	1780.59	23398	648
5099923	S023	Maple Run SD	0.1248	2624	27184	Y	49999028.61	2397.31	20856	53421460.81	2404.14	22221	1365
5099948	S048	Windham Southeast SU	0.1233	2572	29756	Y	59282925.11	2415.35	24544	63845893.94	2470.9	25839	1295
5099919	S019	Essex North SU	0.1211	178	29934	Y	9576268.16	446.8	21433	10572914.73	415.9	25422	3989	less than 1,000 and 1 school per grade span
5099933	S033	Mill River Unified Union SD	0.118	784	30718	Y	16504857.15	699.33	23601	16826078.47	705.28	23857	256	less than 1,000
5000007	S061	Barre SU	0.1175	2157	32875	Y	45052049.4	2143.83	21015	47646415.84	2179.32	21863	848
5099924	S024	Grand Isle SU	0.1171	543	33418	Y	21915142.93	874	25075	21388589.04	854.67	25026	-49	less than 1,000	-0.00195413758723829
5000385	S063	Two Rivers SU	0.1122	929	34347	Y	22539317.26	992.89	22701	24084978.92	944.65	25496	2795	less than 1,000
5099930	S030	White River Valley SU	0.1096	1242	35589	Y	35616655.49	1645.34	21647	37566340.44	1699.39	22106	459
5099946	S046	Windham Central SU	0.1092	754	36343	Y	24195834.23	963.75	25106	26878025.34	931.56	28853	3747	less than 1,000
5099925	S025	Lamoille North SU	0.1066	1680	38023	Y	36643517.79	1683.06	21772	39107332.71	1739.51	22482	710
5000404	S068	Central Vermont SU	0.1041	1271	39294	Y	26777616.67	1315.67	20353	27815414.43	1333.72	20856	503
5099906	S006	Bennington Rutland SU	0.1035	1166	40460	Y	47650159.04	2174.18	21916	51251886.82	2128.34	24081	2165
				40460			962911306.39	43605.69	22082	1017044071.86	43533.91	23362	1280
Notes:
1	S047, Windham Northeast SU - we believe there was a significant reporting error by the SU in the FY22 budgets and are still investigating.  But, the FY22 data reflect the dollars the State paid.
2	S004, Slate Valley Unified School District - while the total spending in FY23 is greater than FY22, the per pupil amount in FY23 is lower.  That is due to an increase in student count of 29 students for FY23.
3	S024, Grand Isle SU - per pupil spending decreased by $49 in FY23.  That is largely due to a significant decrease in special education funding due to a decrease in eligible students from 183 in FY22 to 159
	in FY23, a decrease of 24 special education students.

Sheet: 24HighPovertySummary
				19554		16090
NCES District ID	State District ID	SU_Name	SAIPE_pov_rate 2020	SU_ENROLLMENT fall 2021	Enr_Cumulative	Highest-Poverty LEA (Cumulative Sum ≥ 16,090 20% of enrl)	Total FY19	ADM for FY19	State funds per ADM FY19	Total FY23 ESTIMATE ONLY	ADM for FY23	State funds per ADM FY23	Per Pupil change FY19 to FY23	Exceptions for LEA MOEq
5099917	S017	Winooski SD	0.2032	770	770	Y	16491369.98	873.59	18878	21076454.38	796.19	26472	7594	less than 1,000 and 1 school per grade span
5099934	S034	Orleans Central SU	0.1746	1140	1910	Y	20073064.54	1087.73	18454	21661687.16	1066.61	20309	1855
5099940	S040	Rutland City SU	0.1733	2022	3932	Y	38707334.17	1948.92	19861	42417914.64	1765.78	24022	4161
5099905	S005	Southwest Vermont SU	0.1681	3263	7195	Y	66486334.09	3562.09	18665	75763559.95	3396.72	22305	3640
5099931	S031	North Country SU	0.1492	2588	9783	Y	47443742.82	2683.67	17679	58801288.15	2613.58	22498	4819
5099956	S056	Springfield SD	0.147	1227	11010	Y	26824256.32	1199.24	22368	31651619.55	1237.99	25567	3199	one school per grade span
5099947	S047	Windham Northeast SU	0.144	1052	12062	Y	26752424.75	1215.19	22015	26350482.86	1092.86	24111	2096
5099928	S028	Orange Southwest SU	0.1387	879	12941	Y	15440593.61	883	17487	20341511.86	832.85	24424	6937	less than 1,000
5000407	S067	Kingdom East SD	0.1365	1244	14185	Y	33719607.81	1862.2	18107	38407103.69	1756.88	21861	3754
5099920	S020	Franklin Northeast SU	0.1364	1900	16085	Y	26239174.67	1998.67	13128	38549098.9	1957.07	19697	6569
5099915	S015	Burlington SD	0.134	3469	19554	Y	72411089.9	3843.7	18839	87018876.72	3404.84	25557	6718
				19554			390588992.66	21158	18461	462039597.86	19921.37	23193	4732

File and source

File: department-of-education-excel-www-ed-gov-d3e5039e06.xlsx
Size: 69,003 bytes
SHA-256: a206367c25832217c997f018b21dabb2d8274bdcb704877a7d4027ae290ff6e6
Our copy: department-of-education-excel-www-ed-gov-d3e5039e06.xlsx
Original: www.ed.gov