IN District Point Tracker

[logank013]

Hey CD Community. I'm here with another random google sheet. This google sheet keeps track of district points for Indiana events. I filled out the Tippecanoe event already. If you want to edit it, make a copy of it. The blue highlighted stuff is what should be edited. The rest of the sheet is automatic. Basically, this will make it so you can keep track of district points live as you fill it out on your own copy. I plan to update this after each event. I would update it as the event goes on, but hotspots are still banned. I used something similar (on paper) last year at the INDCMPS. With it, I was able to tell who qualified for worlds almost immediately after the last final match. This is perfect for people like me who want to know immediately and can't wait to find out.

If anyone finds an error, please PM me or post a reply to the thread. If anyone from another district wants me to make this same thing for their district, reply in the thread or PM me. Thanks and Enjoy!

Here is the google sheet.

[Hope O'Connor]

you need to add 10 to 135's overall points because they now have 42 instead of 32

[tindleroot]

Originally Posted by Hope O'Connor

you need to add 10 to 135's overall points because they now have 42 instead of 32

Note-this also applies to 292 and 447 I believe. The #6 alliance from Tippecanoe was granted 10 additional points by FIRST due to a wrongly called red card in the quarterfinals that prevented them from advancing to semis. (Phyxt Red Card 2?)

[Theseusgoats]

Why don't you just look at the actual district rankings?

[Knufire]

Here's the official page for district rankings for Indiana: http://frc-districtrankings.firstinspires.org/2016/IN

[Theseusgoats]

Still can't believe how far ahead everyone else 1024 is right now

[Peyton Yeung]

Originally Posted by Theseusgoats

Still can't believe how far ahead everyone else 1024 is right now

That's what happens when you win both the events so far, not to mention they've won some awards to go with that.

[Theseusgoats]

Anyone have any predictions for state

[logank013]

Wow. This thread reappeared out of nowhere. First of all, sorry I'm so late on updating it. Second of all, another wrongly called red card in IN? ouch. I didn't think that deserved to be a red card but glad to see that it got fixed... again.

Working on updates right now. Also, someone asked why not just look at the page that has IN points. The main reason I created this is for someone to download for themselves. This will allow them to keep track of district points live. Like last year, we knew that even if we got knocked out in QF, we'd still be going to worlds after quals. This is basically for 1, messing around and using hypothetical situations 2. gives a 5 minute before period. (last year I knew who was going to worlds about 5 minutes or so before they announced it) 3. I mostly created this because I got bored in class (happens a lot actually). I typically excel random things when I'm bored. Thanks for the comments.

[tindleroot]

Originally Posted by logank013

The main reason I created this is for someone to download for themselves.

Excel can do that. 1) Go to the Data Tab. 2) Choose "From Web". 3) Follow the windows and insert the webpage link when required, and select the table to download. 4) Boom table downloaded.

[logank013]

I believe it is finally updated correctly. Please reply if something is wrong. Thanks

[logank013]

Originally Posted by tindleroot

Excel can do that. 1) Go to the Data Tab. 2) Choose "From Web". 3) Follow the windows and insert the webpage link when required, and select the table to download. 4) Boom table downloaded.

There are 3 main reasons I didn't do that. First of all, my school computer is a Chromebook which doesn't support excel. Secondly, I'm more experienced in google sheets. Last of all, this would be an offline thing done at an event. It would be for keeping track of district points faster than any website would update.

[BoilerMentor]

Originally Posted by logank013

Second of all, another wrongly called red card in IN? ouch. I didn't think that deserved to be a red card but glad to see that it got fixed... again.

Have you considered volunteering to be a referee once you've grown up a little bit?

You know all these folks are volunteers? They do the best they can, for free. All of our referees in Indiana take it seriously and work hard to make the right calls.

Were you there to see it? A team misrepresented the cause and extent of the damage to their robot. Now, I'll give them the benefit of the doubt and say that rarely can a driveteam actually recall what happened in a match, so they may have genuinely believed what they said. Per the teams explanation, the evidence on the field, and the recount from another referee they had to make a decision, and a tough one at that. Don't even begin to think that anyone takes issuance of a red card lightly.

[logank013]

Originally Posted by BoilerMentor

Have you considered volunteering to be a referee once you've grown up a little bit?

You know all these folks are volunteers? They do the best they can, for free. All of our referees in Indiana take it seriously and work hard to make the right calls.

Were you there to see it? A team misrepresented the cause and extent of the damage to their robot. Now, I'll give them the benefit of the doubt and say that rarely can a driveteam actually recall what happened in a match, so they may have genuinely believed what they said. Per the teams explanation, the evidence on the field, and the recount from another referee they had to make a decision, and a tough one at that. Don't even begin to think that anyone takes issuance of a red card lightly.

Sorry sir if I made you mad. Actually, I do plan to be a FIRST referee if I don't mentor a team. I'm a professional soccer referee. I've been doing it since 14 and this is my 6th season doing it. I understand how hard refereeing is. Especially when it's a game that is super complicated and changes from season to season. As a soccer referee, there are times that I have to make a decision on things that I didn't even see! I only work in a crew of 3 people max and sometimes I'm by myself! We (or I) have to watch 22 people on the field. This year, there are 6 referees and 6 robots. The rules is what complicates things a ton. Most soccer calls are opinion based. FIRST rules are very yes or no. So please don't think I'm a snobby teen who doesn't understand how it works. Obviously, I had the luxury of video replay and a rule book right next to me when watching the 447 issue. But when it's as serious as a red card, it is better to not guess and only make decisions off of what you actually saw. I'm not sure what the referee actually saw. I heard a definitely biase opinion from the alliance that was issued the card.

With that said, don't be mad at me and please accept my public apology. I don't think I crossed the line in anyway before, but I'll apologize for my actions since I felt targeted to do so.

Sincerely,
Logan

[Logan Byers]

Originally Posted by tindleroot

Note-this also applies to 292 and 447 I believe. The #6 alliance from Tippecanoe was granted 10 additional points by FIRST due to a wrongly called red card in the quarterfinals that prevented them from advancing to semis. (Phyxt Red Card 2?)

Originally Posted by logank013

Second of all, another wrongly called red card in IN? ouch. I didn't think that deserved to be a red card but glad to see that it got fixed... again.

As the head referee involved in both of these situations, let me suggest an alternative way of addressing this: Come talk to me personally. And consider this an open invitation to anyone in Indiana to discuss either of these situations or any situation in the future with me personally. I volunteer at almost every Indiana event and am not that hard to find (most of the time).

I accept that some people may feel that these calls were wrong and you are more than welcome to that opinion.

But what I will take exception with is being called out publicly, especially if you haven't heard my perspective of the situation.