2015 CMP Representation by District/Region

[wilsonmw04]

Originally Posted by Andrew Schreiber

It was. The query that populates the event counts operates off of the Location of the event. DC regional is "Fairfax, VA USA" which means it snags VA USA as the state.

If a DC team went to the "DC" event they are counted as VA. If they went to Chesapeake they are MD>

[Lil' Lavery]

Originally Posted by wilsonmw04

If a DC team went to the "DC" event they are counted as VA. If they went to Chesapeake they are MD>

What if they went to both?

[Wetzel]

Originally Posted by wilsonmw04

If a DC team went to the "DC" event they are counted as VA. If they went to Chesapeake they are MD>

[wilsonmw04]

Originally Posted by Wetzel

That escalated quickly...

[Nate Laverdure]

Originally Posted by wilsonmw04

If a DC team went to the "DC" event they are counted as VA. If they went to Chesapeake they are MD>

No, this can't be right. The spreadsheet is not that elaborate. There are truly ~75 active teams in VA, like the spreadsheet says. The 13 DC teams are probably filed under "Other" (sorry Wetzel).

[jvriezen]

Originally Posted by Jon Stratis

The remaining problem is... Which key volunteers (almost all of whom live in the cities) are going to be the ones to drive up to Fargo or Duluth (for example) to handle events? A vast majority of our events are staffed by volunteers from the team's at that event - if the teams from the cities don't travel, then we have a real staffing issue in those out-state events. (emphasis mine)

Just to clarify for those outside of MN, 'cities' is local short hand for 'Twin Cities' which is short hand for Minneapolis/St. Paul (and in this case, surrounding suburbs)

Oh, and with the exception of Fargo (ND), Duluth, MN and other potential future locations in MN are actually 'in' state, not 'out' state. (A peeve of some of us from MN but not from the 'cities')

[forbes]

Here is a spreadsheet of ACTUAL championship representation by State/Country:

https://docs.google.com/spreadsheets...it?usp=sharing

[Navid Shafa]

Originally Posted by Nate Laverdure

No, this can't be right. The spreadsheet is not that elaborate. There are truly ~75 active teams in VA, like the spreadsheet says. The 13 DC teams are probably filed under "Other" (sorry Wetzel).

Yep, nailed it Nate.

[forbes]

Originally Posted by forbes

Here is a spreadsheet of ACTUAL championship representation by State/Country:

https://docs.google.com/spreadsheets...it?usp=sharing

Using the same strategy, I built a quick map showing the USA team representation visually at championship.evanforbes.net.

[lynca]

Originally Posted by forbes

Using the same strategy, I built a quick map showing the USA team representation visually at championship.evanforbes.net.

This is amazing stuff ! it would be awesome if we could do this year by year to see how the colors change.

[forbes]

Originally Posted by lynca

This is amazing stuff ! it would be awesome if we could do this year by year to see how the colors change.

I don't have historical data at my fingertips currently.

If someone does and can provide me with a spreadsheet in a form similar to below I can add it to the map eventually.

Year | 2 Letter State Abbr. | Total Number of Teams | Number of Teams at Championship
2015 | OK                   | 48                    | 2
.
.
.

[BigBen]

Poor Nebraska, someone really should help them at least get started down this wonderful rabbit hole of a journey.

[cadandcookies]

Originally Posted by BigBen

Poor Nebraska, someone really should help them at least get started down this wonderful rabbit hole of a journey.

They have a rapidly growing FTC program-- this time last year, there were almost no teams in the state (I think there may have been one), and now I believe there are more than 10. I'd be surprised if a new FRC team didn't spring up sooner rather than later.

[Dunngeon]

Originally Posted by forbes

Using the same strategy, I built a quick map showing the USA team representation visually at championship.evanforbes.net.

One request, could you change the states with no teams from grey to black? The grey is very similar to the light pink that many states have.

[Mr.Paulson]

Originally Posted by jvriezen

Just to clarify for those outside of MN, 'cities' is local short hand for 'Twin Cities' which is short hand for Minneapolis/St. Paul (and in this case, surrounding suburbs)

Oh, and with the exception of Fargo (ND), Duluth, MN and other potential future locations in MN are actually 'in' state, not 'out' state. (A peeve of some of us from MN but not from the 'cities')

As an 'out' state team, we would be willing to travel for the district model. It would be NICE to have a local event but not necessary. We would definitely sacrifice to go to the district model!