A B C D E F G
DISTRICT
2 COUNTY NAME NUMBER DISTRICT NAME Q1 & Q2 Payment* Q3 Payment* Q4 payment* FY11 total allocation
3 ADAMS 1 MAPLETON 0 0 0 0
4 ADAMS 12 761315
Adams 12-(Adams 12 Five Star Schools) 380657 380657 1522629
5 ADAMS 14 51987
Adams County School District 14 25994 25994 103974
6 ADAMS 27J BRIGHTON 316550 158275 158275 633101
7 ADAMS 29J BENNET 24161 12080 12080 48322
8 ADAMS 31J STRASBURG 0 0 0 0
9 ADAMS 50 114470
Adams County School District 50 57235 57235 228940
10 ALAMOSA RE 11J ALAMOSA 30399 15199 15199 60798
11 ALAMOSA RE 22J SANGRE DE CRISTO 15801 7901 7901 31602
12 ARAPAHOE 1 ENGLEWOOD 6160 3080 3080 12320
13 ARAPAHOE 2 SHERIDAN 40548 20274 20274 81096
14 ARAPAHOE 5 CHERRY CREEK 930193 465096 465096 1860385
15 ARAPAHOE 6 LITTLETON 151816 75908 75908 303632
16 ARAPAHOE 26J DEER TRAIL 0 0 0 0
17 ARAPAHOE 28J AURORA 1082749 541375 541375 2165498
18 ARAPAHOE 32J BYERS 13753 6876 6876 27505
19 ARCHULETA 50JT PAGOSA SPRINGS 12224 6112 6112 24448
20 BACA RE 1 WALSH 9038 4519 4519 18076
21 BACA RE 3 PRITCHETT 4861 2430 2430 9722
22 BACA RE 4 SPRINGFIELD 14477 7239 7239 28955
23 BACA RE 5 VILAS 0 0 0 0
24 BACA RE 6 CAMPO 0 0 0 0
25 BENT RE 1 LAS ANIMAS 18074 9037 9037 36148
26 BENT RE 2 MC CLAVE 30897 15448 15448 61794
27 BOULDER RE 1J ST. VRAIN VALLEY 402548 201274 201274 805097
28 BOULDER RE 2J BOULDER VALLEY 558712 279356 279356 1117424
29 CHAFFEE R31 Buena Vista 0 0 0 0
30 CHAFFEE R-32-J SALIDA 11162 5581 5581 22323
31 CHEYENNE R1 KIT CARSON 15516 7758 7758 31033
32 CHEYENNE RE-5 CHEYENNE WELLS 11686 5843 5843 23373
33 CLEAR CREEK RE 1 IDAHO SPRINGS 0 0 0 0
34 CONEJOS RE 1 North Conejos 135322 67661 67661 270645
35 CONEJOS RE 6J SANFORD 30605 15303 15303 61211
36 CONEJOS RE 10 3036
South Conejos -ANTONITO 1518 1518 6073
37 COSTILLA R1 CENTENNIAL/SAN LUIS7447 3724 3724 14895
38 COSTILLA R 30 SIERRA GRANDE 8389 4194 4194 16777
39 CROWLEY RE 1J ORDWAY 16430 8215 8215 32860
40 CUSTER C1 WESTCLIFFE 10458 5229 5229 20916
41 DELTA 50 J DELTA 84422 42211 42211 168843
42 DENVER 1 DENVER 389163 194581 194581 778325
43 DOLORES RE2J DOLORES COUNTY 8396 4198 4198 16791
44 DOUGLAS RE 1 265624
Douglas county - CASTLE ROCK 132812 132812 531249
45 EAGLE RE 50J EAGLE 30219 15110 15110 60438
46 ELBERT C1 ELIZABETH 21749 10874 10874 43498
47 ELBERT C2 KIOWA 0 0 0 0
48 ELBERT 100J BIG SANDY 30831 15416 15416 61663
49 ELBERT 200 ELBERT 0 0 0 0
50 ELBERT 300 AGATE 4869 2435 2435 9739
51 EL PASO RJ 1 CALHAN 8157 4078 4078 16314
52 EL PASO 2 HARRISON 55417 27708 27708 110834
53 EL PASO 3 Widefield - SECURITY 0 0 0 0
54 EL PASO 8 FOUNTAIN 22729 11364 11364 45457
55 EL PASO 11 COLORADO SPRINGS 184984 92492 92492 369967
56 EL PASO 12 CHEYENNE MOUNTIAN4049 2025 2025 8098
57 EL PASO 14 MANITOU SPRINGS 0 0 0 0
58 EL PASO 20 ACADEMY 263337 131668 131668 526674
59 EL PASO 22 ELLICOTT 19387 9693 9693 38774
60 EL PASO 23 PEYTON 0 0 0 0
4ba3e8a5-eefb-48e4-b7f5-466937ebc22d.xls
A B C D E F G
61 EL PASO 28 HANOVER 1869 935 935 3738
62 EL PASO 38 Lewis-Palmer MONUMENT 3538 1769 1769 7075
63 EL PASO 49 FALCON 98950 49475 49475 197900
64 EL PASO 54JT EDISON 0 0 0 0
65 EL PASO 60JT 0
MIAMI-YODER School District JT-60 0 0 0
66 FREMONT RE 1 CANON CITY 39850 19925 19925 79700
67 FREMONT RE 2J FLORENCE 24042 12021 12021 48083
68 FREMONT RE3 Cotopaxi 0 0 0 0
69 GARFIELD RE 1J 20959
Roaring Fork - GLENWOOD SPRINGS 10480 10480 41918
70 GARFIELD RE 2 Garfield RE2 - RIFLE 53038 26519 26519 106076
71 GARFIELD 16 GRAND VALLEY-Parachute 8592 4296 4296 17185
72 GILPIN RE 1 BLACK HAWK 0 0 0 0
73 GRAND 1J West Grand - KREMMLING 21141 10570 10570 42281
74 GRAND 2 GRANBY-East Grand 5490 2745 2745 10981
75 GUNNISON RE 1J GUNNISON 13563 6782 6782 27126
76 Hinsdale Hinsdale 0 0 0 0
77 HUERFANO RE 1 HUERFANO - Walsenberg 5135 2568 2568 10270
78 HUERFANO RE 2 LA VETA 0 0 0 0
79 JACKSON R1 North Park- WALDEN 19064 9532 9532 38127
80 JEFFERSON R1 LAKEWOOD 1740661 870331 870331 3481323
81 KIOWA RE 1 EADS 5547 2774 2774 11095
82 Kiowa RE2 Plainview 3930 1965 1965 7860
83 KIT CARSON C 20 ARRIBA-FLAGER 11182 5591 5591 22364
84 KIT CARSON R 23 Hi Plains 4681 2341 2341 9363
85 KIT CARSON R4 STRATTON 1519 759 759 3038
86 KIT CARSON R-5 BETHUNE 8198 4099 4099 16395
87 KIT CARSON R 6J BURLINGTON 10257 5129 5129 20515
88 LAKE R1 Lake County 0 0 0 0
89 LA PLATA 9R DURANGO 36259 18129 18129 72517
90 LA PLATA 10 JT BAYFIELD 15559 7780 7780 31118
91 LA PLATA 11 JT IGNACIO 28274 14137 14137 56548
92 LARIMER R1 POUDRE 288326 144163 144163 576651
93 LARIMER R2 LOVELAND-Thompson 255865 127932 127932 511730
94 LARIMER R3 PARK (estes park) 46859 23429 23429 93718
95 LAS ANIMAS 1 Trinidad 25408 12704 12704 50815
96 LAS ANIMAS 2 Primero- Weston 0 0 0 0
97 LAS ANIMAS RE 3 Hoehne 13193 6596 6596 26386
98 LAS ANIMAS RE 6 Aguilar 10613 5306 5306 21226
99 LAS ANIMAS RE 82 Branson 1941 970 970 3882
100 LAS ANIMAS RE 88 KIM 10978 5489 5489 21956
101 LINCOLN C 113 GENOA-HUGO 10861 5430 5430 21721
102 LINCOLN RE 4J LIMON Public Schools 22536 11268 11268 45072
103 LINCOLN RE 23 KARVAL Public Schools 0 0 0 0
104 LOGAN RE 1 Valley - STERLING 106596 53298 53298 213192
105 LOGAN RE 3 FRENCHMAN 16196 8098 8098 32391
106 LOGAN RE 4 Buffalo- MERINO 25129 12564 12564 50257
107 LOGAN RE 5 Plateau - PEETZ 19886 9943 9943 39771
108 MESA 49JT DE BEQUE 0 0 0 0
109 MESA 50 11549
Mesa County - COLBRAN-Plateau Valley 5775 5775 23098
110 MESA 51 MESA COUNTY VALLEY699136 349568 349568 1398272
111 MINERAL RE 1 CREEDE 5226 2613 2613 10452
112 MOFFAT RE 1 CRAIG 36463 18231 18231 72925
113 MONTEZUMA RE 1 CORTEZ 102662 51331 51331 205324
114 MONTEZUMA RE 4A DOLORES 11702 5851 5851 23405
115 MONTEZUMA RE 6 MANCOS 0 0 0 0
116 MONTROSE RE 1 MONTROSE 72622 36311 36311 145244
117 MONTROSE RE 2 (Naturita)
West End Public Schools 0 0 0 0
118 MORGAN RE 2J BRUSH 19041 9521 9521 38083
119 MORGAN RE 3 FORT MORGAN 43405 21703 21703 86810
120 MORGAN RE20J WELDON VALLEY 16077 8039 8039 32154
4ba3e8a5-eefb-48e4-b7f5-466937ebc22d.xls
A B C D E F G
121 MORGAN RE 50 WIGGINS 17645 8823 8823 35290
122 OTERO R1 LA JUNTA East Otero 38020 19010 19010 76039
123 OTERO R2 ROCKY FORD 18061 9030 9030 36121
124 OTERO R 3J MANZANOLA 0 0 0 0
125 OTERO R 4J FOWLER 17339 8669 8669 34678
126 OTERO 31 CHERAW 17355 8678 8678 34710
127 OTERO 33 SWINK 15553 7777 7777 31106
128 OURAY R1 OURAY 18903 9452 9452 37806
129 OURAY R2 Ridgway 0 0 0 0
130 PARK RE 1 Platte Canyon - BAILEY 3624 1812 1812 7248
131 PARK RE 2 FAIR PLAY 0 0 0 0
132 PHILLIPS RE 1J HOLYOKE 8948 4474 4474 17896
133 PHILLIPS RE 2J HAXTUN 21656 10828 10828 43311
134 PITKIN RE 1 ASPEN 8138 4069 4069 16276
135 PROWERS RE 1 GRANADA 11339 5669 5669 22678
136 PROWERS RE 2 LAMAR 3591 1796 1796 7182
137 PROWERS RE 3 HOLLY 10685 5343 5343 21371
138 PROWERS RE 13JT WILEY 2962 1481 1481 5924
139 PUEBLO 60 PUEBLO (CITY) 190827 95413 95413 381654
140 PUEBLO 70 PUEBLO (RURAL) 23818 11909 11909 47636
141 RIO BLANCO RE 1 MEEKER 12171 6085 6085 24342
142 RIO BLANCO RE 4 RANGELY 7205 3603 3603 14410
143 RIO GRANDE C7 DEL NORTE 6049 3025 3025 12099
144 RIO GRANDE C-8 MONTE VISTA 13172 6586 6586 26344
145 RIO GRANDE R 33J SARGENT 11910 5955 5955 23821
146 ROUTT RE 1 HAYDEN 33185 16592 16592 66369
147 ROUTT RE 2 STEAMBOAT SPRINGS 43263 21631 21631 86525
148 ROUTT RE 3J South Routt - OAK CREEK 22341 11170 11170 44681
149 SAGUACHE RE 1 0
Saguache - Mountain Valley 0 0 0
150 SAGUACHE 2 Moffat 4631 2316 2316 9262
151 SAGUACHE 26JT Center 10974 5487 5487 21948
152 San Juan 1 Silverton 0 0 0 0
153 SAN MIGUEL R1 Telluride 5409 2705 2705 10818
154 SAN MIGUEL R 2J Norwood 0 0 0 0
155 SEDGEWICK RE 1 Julesburg 0 0 0 0
156 SEDGEWICK RE 3 Platte Valley 7117 3559 3559 14234
157 SUMMIT RE 1 Summit School District 1770 885 885 3540
158 TELLER RE 1 CRIPPLE CREEK - Victor 0 0 0 0
159 TELLER RE 2 WOODLAND PARK 35122 17561 17561 70244
160 WASHINGTON R1 AKRON 10645 5322 5322 21289
161 WASHINGTON R2 ARICKAREE 11172 5586 5586 22345
162 WASHINGTON R3 OTIS 16319 8160 8160 32639
163 WASHINGTON 101 LONE STAR 5433 2716 2716 10865
164 WASHINGTON 104 WOODLIN 12070 6035 6035 24140
165 WELD RE 1 GILCREST 64563 32282 32282 129126
166 WELD RE 2 EATON 41388 20694 20694 82775
167 WELD RE 3 KEENESBURG 65832 32916 32916 131663
168 WELD RE 4 WINDSOR 50362 25181 25181 100724
169 WELD RE 5J JOHNSTOWN 8974 4487 4487 17948
170 WELD 6 GREELEY 209470 104735 104735 418940
171 WELD RE 7 KERSEY Platte Valley 20596 10298 10298 41192
172 WELD RE 8 FORT LUPTON 60612 30306 30306 121224
173 WELD RE 9 AULT- Highland 15091 7546 7546 30182
174 WELD RE 10J BRIGGSDALE 28699 14350 14350 57398
175 WELD RE 11J Prairie 16919 8459 8459 33837
176 WELD RE-12 Pawnee 15996 7998 7998 31992
177 YUMA RJ 1 YUMA 32223 16112 16112 64446
178 YUMA RJ 2 WRAY 4774 2387 2387 9547
179 YUMA RJ 3 IDALIA 18536 9268 9268 37072
180 YUMA RJ4 LIBERTY 7922 3961 3961 15845
4ba3e8a5-eefb-48e4-b7f5-466937ebc22d.xls
Column Formula What it Does
A Record Number Reference
B County Reference
C District Number Reference
D District Name Reference
E School Code Reference
F PPOR-Per Pupil Operating Revenue Provided by CDE-Copy Attached
G Number From FY08 Final Repotrs from Districts
H Number From FY08 Final Repotrs from Districts
I =IF(H>0,H/G-F*0.7,0) Calculates the Costs/FTE-70% of PPOR
Allocation Formula- If the Cost per FTE is greater than 1250 then the cost per FTE minus 1250
times 50% plus 1000 times the FTE from the final report, otherwise the Cost per FTE times 80%
J =IF(I>1250,((I-1250)*.5+1000)*G,I*.8*G) times the FTE from the final report, or -0- in column I is a negative
K Proration Percentage Calculates the percentage of the appropriation divided by the allocation total in column J
L =J*K Calculates the allocation by the percentage
M =L/4 Divides the prorated allocation by the 4 to get quarterly payments
N same as M Check amount for Quarter 1
4ba3e8a5-eefb-48e4-b7f5-466937ebc22d.xls