2016 Michigan Teams Registration

[Ed Law]

It was brought to my attention that there is a small error in the spreadsheet.

In sheet "Teams List for Events", cell S3 should say "=SUM(A3:R3)" and cell S4 should say "=SUM(A4:R4)".

Thanks Scott.

[Ed Law]

There is a new event that will be in Week 2. Since it is quite a bit of work to change the spreadsheet to add an event, I have updated it which will be v3. Please download it again.

[RCB]

After updating to v3, I noticed that the Woodhaven column no longer updates. It's not a huge fix, so if you'd like to fix it yourself just do these three steps:

1. Press ALT + F11 to open up the visual basic editor
2. On the 15th line, change the 18 to a 19 so that it reads: For i = 1 To 19
3. Save and close the window

The woodhaven column should now update with the rest when you press the Update button.

Thanks again to Ed for providing this great tool for all Michigan teams.

[sciencenuetzel]

Awesome job on the spreadsheet!

[Ed Law]

Originally Posted by RCB

After updating to v3, I noticed that the Woodhaven column no longer updates. It's not a huge fix, so if you'd like to fix it yourself just do these three steps:

1. Press ALT + F11 to open up the visual basic editor
2. On the 15th line, change the 18 to a 19 so that it reads: For i = 1 To 19
3. Save and close the window

The woodhaven column should now update with the rest when you press the Update button.

Thanks again to Ed for providing this great tool for all Michigan teams.

Sorry for the careless mistake. I was on the phone with someone discussing which event to register while I updated the spreadsheet. I normally would count the number of rows of events and not put a hard number for a loop like that. I'm traveling to Houston right now. I will update it tonight when I get to the hotel, or you can edit the macro as suggested.

[Ed Law]

There has been some changes to the Michigan district events. Since I need to get an updated list of all Michigan teams registered, I have to update the spreadsheet. For those folks who do not know how to update the spreadsheet due to the changes, I am posting the latest for them. It is now version 5.

[Ed Law]

Michigan added two more district events. I updated the spreadsheet again. It is now version 6.

418 teams, 75 rookie teams