School enrollment calculator.ods

	A	B	C	D	E	F	G	H	I	J	K	L
1					Oct 2014 USOE			(Link Downloads a USOE sheet)
2	Growth Rate		1.00%
3		You can also modify the Kindergarten enrollment, if you have a crystal ball
4			Any changes made will remain, until the next change
5	Grade	base	next yr.	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
6	K	450	450	400	475	470	450	480	485	500	485	485
7	1	421	425	455	404	480	475	455	485	490	505	490
8	2	474	479	429	459	408	485	479	459	490	495	510
9	3	495	500	484	434	464	412	489	484	464	495	500
10	4	436	440	505	488	438	468	416	494	489	468	499
11	Elem	2,276	2,294	2,272	2,260	2,260	2,290	2,320	2,407	2,432	2,448	2,484
12			0.8%	-1.0%	-0.5%	0.0%	1.3%	1.3%	3.8%	1.0%	0.6%	1.5%
13	5	477	482	445	510	493	442	473	420	499	494	473
14	6	495	500	487	449	515	498	447	478	425	504	499
15	Mid	972	982	931	959	1,008	941	920	898	924	998	972
16			1.0%	-5.1%	3.0%	5.1%	-6.7%	-2.2%	-2.4%	2.9%	8.0%	-2.6%
17	7	422	426	505	491	454	520	503	451	482	429	509
18	8	495	500	430	510	496	458	525	508	456	487	433
19	Int	917	926	935	1,001	950	978	1,029	960	938	916	942
20			1.0%	1.0%	7.1%	-5.1%	3.0%	5.1%	-6.7%	-2.2%	-2.4%	2.9%
21	9	461	466	505	435	515	501	463	531	513	460	492
22	10	498	503	470	510	439	520	506	467	536	518	465
23	11	439	443	508	475	515	444	525	511	472	541	524
24	12	464	469	448	513	480	520	448	531	517	477	547
25	High	1,862	1,881	1,931	1,933	1,949	1,985	1,943	2,040	2,038	1,997	2,028
26			1.0%	2.7%	0.1%	0.8%	1.9%	-2.2%	5.0%	-0.1%	-2.0%	1.5%
27		6,027	6,083	6,070	6,154	6,167	6,194	6,211	6,305	6,332	6,359	6,426
28			0.9%	-0.2%	1.4%	0.2%	0.4%	0.3%	1.5%	0.4%	0.4%	1.1%
29	Line 2 is the estimated growth Rate for the entire period
30	Line 6 is the estimated size of incoming Kindergarten class
31	Col B is the enrollment from the previous year, moved up one grade
32	Col D – L automatically moves each grade enrollment up one year.
33	Projections are automatically calculated from the previous year, adjusted for the growth rate
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100