Spreadsheet: 0bc0c2c5-6e15-41b9-9da3-1c420673ebf0
Sheet: County Revenue Sources

Traditional Public School District Revenue and Public Charter School Revenue By Source**
Aggregated by County & State for Public School Districts & by Total State for Public Charter Schools
2006-2007 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAVE A COPY OF THIS FILE
County |  | Total | Enroll- |  | Federal |  |  | State |  |  | County/Intermediate* |  |  | Local |  |  |  |  | BEFORE YOU BEGIN TO SORT
# | Name | Revenue | ment | $PP | Amount | % | $PP | Amount | % | $PP | Amount | % | $PP | Amount | % | $PP
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q
0 | ~Total-C | 675226730 | 88587 | 7622.187567024507 | 58677202.837 | 0.0869 | 662.3680995744297 | 568675952.0059999 | 0.8421999999999998 | 6419.406368948039 | 1215408.114 | 0.0018 | 13.71993762064411 | 46658167.043 | 0.0691 | 526.6931608813934 |  | About Excel 2007 Tables
0 | ~Total-D | 8953120539 | 935219 | 9573.287688765948 | 955251395 | 0.1066947988512947 | 1021.420004298458 | 4365833746 | 0.487632633446889 | 4668.24748641762 | 4074850 | 0.0004551318149074236 | 4.357107800418939 | 3627960548 | 0.4052174358869089 | 3879.26309024945 |  |  | 1) Click the the arrow buttons in row 6 (purple) to sort.
01 | Apache |  | 12885 |  | 77676166 |  |  | 78896695 |  |  | 61698 |  |  | 24180411 |  |  |  |  | 2) Select a sort order to sort the list.
02 | Cochise |  | 18844 |  | 26240638 |  |  | 95406241 |  |  | 120996 |  |  | 47206753 |  |  |  |  | The last button used displays an up or down arrow.
03 | Coconino |  | 17937 |  | 39779807 |  |  | 71999887 |  |  | 1121484 |  |  | 74378163 |  |  |  |  | Always use buttons to sort (not Data | Sort).
04 | [NAME] |  | 7585 |  | 16969152 |  |  | 35924121 |  |  | 0 |  |  | 25537508 |  |  |  |  | For lowest to highest revenue per pupil ($PP) by county:
05 | [NAME] |  | 5744 |  | 7804918 |  |  | 33115297 |  |  | 22392 |  |  | 9433236 |  |  |  |  | 1) Click the arrow button in cell E6.
06 | [NAME] |  | 1620 |  | 990720 |  |  | 4079074 |  |  | 0 |  |  | 8803196 |  |  |  |  | 2) Select "Sort Smallest to Largest"
15 | La Paz |  | 2514 |  | 9104245 |  |  | 11527455 |  |  | 10287 |  |  | 6420711 |  |  |  |  | To return tor original sort order:
07 | Maricopa |  | 587562 |  | 452851159 |  |  | 2615985743 |  |  | 1465513 |  |  | 2546583549 |  |  |  |  |  | Use button at B6 to sort A to Z.
08 | Mohave |  | 23158 |  | 21858795 |  |  | 85494623 |  |  | 488878 |  |  | 71485358
09 | [NAME] |  | 20947 |  | 62747791 |  |  | 106962377 |  |  | 162264 |  |  | 44965105
10 | Pima |  | 127936 |  | 124072911 |  |  | 619064850 |  |  | 310694 |  |  | 462030092
11 | Pinal |  | 40439 |  | 36208180 |  |  | 270879276 |  |  | 154352 |  |  | 130541283
12 | Santa Cruz |  | 9976 |  | 12160176 |  |  | 50186210 |  |  | 40682 |  |  | 26793512
13 | Yavapai |  | 23707 |  | 16917820 |  |  | 86553264 |  |  | 19126 |  |  | 89302977
14 | Yuma |  | 34365 |  | 49868917 |  |  | 199758633 |  |  | 96484 |  |  | 60298694
* For traditional school districts these amounts represent "County" revenues (with zero Intermediate revenue dollars); for public charter schools these amounts represent "Intermediate" revenues (with zero County revenue dollars).
$PP = Dollars Per Pupil |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Highlighting Legend:
DATA SOURCE:  Annual Report of the Arizona Superintendent of Public Instruction; Volume II, Fiscal Year 2006-2007. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Purple = Drop-down arrow buttons.
DATA PRESENTATION:  By EduAnalytics, LLC; November, 2008. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yellow = Total for 337 state-sponsored public
~Total-C = The total of 337 state-sponsored public charter schools ([NAME]). |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | charter schools.
~Total-D = The total of all public school districts ([NAME]). |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Green = Total for all public school districts.
** Includes 337 state-sponsored public charter schools.