Originally Posted by Andrew Schreiber (Post 1470232)

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.

Originally Posted by wilsonmw04 (Post 1470239)

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

Originally Posted by wilsonmw04 (Post 1470239)

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

Originally Posted by Wetzel (Post 1470247)

Originally Posted by wilsonmw04 (Post 1470239)

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

Originally Posted by Jon Stratis (Post 1470234)

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)

Originally Posted by Nate Laverdure (Post 1470262)

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).

Originally Posted by forbes (Post 1470293)

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

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

Originally Posted by forbes (Post 1470387)

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

Originally Posted by lynca (Post 1470400)

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

Originally Posted by BigBen (Post 1470539)

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

Originally Posted by forbes (Post 1470387)

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

Originally Posted by jvriezen (Post 1470275)

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')