Cooperative County Challenge - March/April 2013 Hits

April Hit : Richland, SC

UPDATE:

Tim, Your suggestion has been implemented. A very good idea.
For now, I have only done this for Alaska - the other states will follow.

Your formula didn't quite work out on EditGrid...for some reason Count and Counta returned the same results on EditGrid...so your formula always resulted in 100%

Count DID return the numbe of filled in Counties however.

So I had to alter your formula and do the following: =count(C2:C30)/29
The last number will change accrding to how many Counties are in the state. Likewise, the inside-the-parenthesis numbers will change in accord with how many counties that state has.

I may actually choose to move this total up to the TOP line in each state - let me know if you think that would be a good idea.


Additionally, I apologize for the lack of an update as yet, however, my mother (Tracker yellowrose) is in the hospital - so I have been spending much of my spare time there...and handling her financial affairs while she is in there. She is expected to make it out of there tomorrow...and once things get back to normal here, I will do a full update. For now, I will just implement the percentages.

Thanks for the updates - hope yellowrose feels better soon.

The formula at the top sounds okay to me and will look at it when I get a chance.

dctim wrote:Thanks for the updates - hope yellowrose feels better soon.

The formula at the top sounds okay to me and will look at it when I get a chance.

Just brought her home from the hospital.

The formula works. I tested it with a calculator to see if it came up with the answer it was supposed to, and it did.

Update: I decided to move this information to the top of each state.

All states have now been done with Percentages at the top of each state in the Spreadsheet.

Thanks for the idea, tim...and for the mechanics of how to do it!

Sorry about the lack of an update presently, I will TRY to do this soon.

That incredible 7 mile trip to Arlington, VA

Wow, Tim. 7 miles would get me to Phoenix, Scottsdale, or Mesa. Nowhere near getting me out of the county.

In Arizona, Tony, you have Counties bigger in land area than entire STATES back East!

That's what I'm getting at. Counties here are huge. Small countries in other parts of the world.

Tony wrote:That's what I'm getting at. Counties here are huge. Small countries in other parts of the world.

That's because, when the Counties were drawn, almost no one lived in a lot of the big ones out West. they didn't want to put everyone in their own individual Counties, LOL.

You got a lot of landmass in your Counties...but not many more people in each one than we do.

New Jersey, for example, averages 1100 people per square mile.
9 million people crammed into 21 counties. in Arizona, you got Counties bigger than the entire state of New Jersey.
But, about 400,000 people in each NJ County. Probably similar numbers in Arizona Counties.

Most of the population of AZ is in Maricopa and Pima counties, where the Phoenix metro area and Tucson are. Here's a list of the largest cities and each county's population:

Phoenix: 1,445,632 (9.4%)
Tucson: 520,116 (6.9%)
Mesa: 439,041 (10.8%)
Chandler: 236,123 (33.7%)
Glendale: 226,721 (3.6%)
Scottsdale: 217,385 (7.2%)
Gilbert: 208,453 (90%)
Tempe: 161,719 (2.0%)
Peoria: 154,065 (42.2%)
Surprise: 117,517 (281%)
Yuma: 93,064 (20.1%)
Avondale: 76,238 (112.5%)
Flagstaff: 65,870 (24.5%)
Goodyear: 65,275 (245.2%)
Lake Havasu City: 52,527 (25.2%)
Buckeye: 50,876 (678.3%)
Casa Grande: 48,571 (92.6%)
Sierra Vista: 43,888 (16.2%)
Maricopa: 43,482 (4,081%)
Oro Valley: 41,011 (38.1%)


Apache: 71,518 (3%)
Cochise: 131,346 (11.5%)
Coconino: 134,421 (15.6%)
Gila: 53,597 (4.4%)
Graham: 37,220 (11.1%)
Greenlee: 8,437 (-1.3%)
La Paz: 20,489 (3.9%)
Maricopa: 3,817,117 (24.2%)
Mohave: 200,186 (29.1%)
Navajo: 107,449 (10.2%)
Pima: 980,263 (16.2%)
Pinal: 375,770 (109.1%)
Santa Cruz: 47,420 (23.6%)
Yavapai: 211,033 (26%)
Yuma: 195,751 (22.3%)

Read more: http://www.azcentral.com/community/pinal/articles/20110310census-arizona-new-2010-numbers-brk10-ONbox.html#ixzz2QDzfmBRK

The only city over 100k outside of the Phoenix metro area is Tucson, though Yuma is close. The percentages are the end of each counties population is the growth since the last census in 2000. These stats are from 2010.

Outside of these metro areas there isn't much for civilization. Very few people and lots of untouched land.