Thanks for the inputs!
Some of what you've mentioned has jogged my memory about other similar circumstances, so I've gone back looking for those missing links too.
I'm adding in the team relationships you've all provided. I'll keep updating the file linked to in the original post and add a revision number to the Notes. I'll post an update this evening if you want to grab a new version tomorrow.
Some of you have noted that your team name, sponsor, school, etc. are incorrect. What I did was pull the name of your team as it was first incorporated (or the earliest data I could find), not what it may be today. Teams know where they are today, but may not know where they came from.
Some of you will be surprised to learn of other schools that started along with your team. That may also be why the location is different than today's. Some Team Leaders obviously entered the information incorrectly in TIMS (a couple of teams had full mailing addresses in there
).
I do want to hear about school changes though.
I will expand the list of original un-numbered teams because they aren't all here. I was doing something else and started removing them if they could be associated with a later school, but I should have left them all alone and give them A1 kind of designations.
- I have a separate spreadsheet that contains rosters for every year and you can track team sponsors and school changes over the years there. Every un-numbered team and numbered team is listed.
- I have yet another spreadsheet that tracks the teams through the years, from un-numbered in 1992 to temporary numbers in 1997 and permanent ones starting in 1998.
If anyone wants to see those let me know and I'll link them. I don't want to overload people though. We actually have a webpage dedicated to this stuff, but all the spreadsheets are changing.
Our webmaster is designing an updated database structure to let us add more of this information to make it searchable. That's a summer project.
Nica:
I'll think of a way to reflect team relationships in that extra column. Maybe color coded - 1)
parent, 2)
child, 3)
same team/
new number.
FYI, No team number has ever been reassigned. Numbers have followed schools or primary sponsors.