Chief Delphi

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   District Events (http://www.chiefdelphi.com/forums/forumdisplay.php?f=190)
-   -   2016 Michigan Teams Registration (http://www.chiefdelphi.com/forums/showthread.php?t=138283)

Ed Law 24-09-2015 14:15

2016 Michigan Teams Registration
 
I will be retiring and leaving Michigan the end of October so I will no longer be on FRC Team 2834. Here is my parting gift to all Michigan Teams. Happy Registering!

http://www.chiefdelphi.com/media/papers/3169

Ed Law 25-09-2015 08:31

2016 Michigan Teams Registration
 
Event code for Woodhaven changed from mifla to mibro. Please download new file or change cell W23 in sheet "Teams List for Events" to mibro.

logank013 25-09-2015 15:54

Re: 2016 Michigan Teams Registration
 
Quote:

Originally Posted by Ed Law (Post 1497328)
I will be retiring and leaving Michigan the end of October so I will no longer be on FRC Team 2834. Here is my parting gift to all Michigan Teams. Happy Registering!

http://www.chiefdelphi.com/media/papers/3169

If you are retiring, does that mean you won't be making your scouting databases anymore? I'll be lost without your databases. haha. But seriously, thanks for this file and thanks for all your databases I used all of the 2015 season.

Ed Law 25-09-2015 22:16

Re: 2016 Michigan Teams Registration
 
I think this was addressed in another post some time ago. Team 2834 mentors will continue to publish the scouting database. I already gave them all my spreadsheets and macros. I will still be available to help them through Skype if they need help.

I am moving to California and will still be involved in FIRST Robotics one way or another, probably volunteering at regional events to get to know the teams.

Ed Law 30-09-2015 08:39

Re: 2016 Michigan Teams Registration
 
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 07-10-2015 23:19

Re: 2016 Michigan Teams Registration
 
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 08-10-2015 11:29

Re: 2016 Michigan Teams Registration
 
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 08-10-2015 14:31

Re: 2016 Michigan Teams Registration
 
Awesome job on the spreadsheet!

Ed Law 08-10-2015 14:43

Re: 2016 Michigan Teams Registration
 
Quote:

Originally Posted by RCB (Post 1499127)
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 17-11-2015 02:32

Re: 2016 Michigan Teams Registration
 
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 23-11-2015 02:54

Re: 2016 Michigan Teams Registration
 
Michigan added two more district events. I updated the spreadsheet again. It is now version 6.

418 teams, 75 rookie teams


All times are GMT -5. The time now is 09:01.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi