[Rachel Lim]

Originally Posted by ebarker

How can I get a list, preferable in spreadsheet of ALL current teams, by team number and location.

I need to run an analytic s exercise so I can calculate team density, by program, state population, etc... it is an update for a thing I did a few years ago,,,, need it for an upcoming briefing.

I need a table that looks like

1311, FRC, GA
... and so on for the 3,000+ FRC entries, and FTC, FLL, JrFLL

actually all I need to know is how may teams exist by program by type by geographical area

so how many FRC teams are in each state / province, country
ditto for FTC, FLL, JRFLL

I don't really need the team numbers.

Thanks,

-eb

You can use the My Area search: https://my.usfirst.org/myarea/index....age=searchform

You'll probably need to use excel or something to extract the state abbreviation from the location, but I think it has team data for all levels.