Thread: White Paper Discuss: Spreedsheet to Calculate the Ranking of Teams
View Single Post
  #17   Spotlight this post!  
Unread 17-03-2005, 20:38
Kevin Sevcik's Avatar
Kevin Sevcik Kevin Sevcik is online now
(Insert witty comment here)
FRC #0057 (The Leopards)
Team Role: Mentor
  
Join Date: Jun 2001
Rookie Year: 1998
Location: Houston, Texas
Posts: 3,626
Kevin Sevcik has a reputation beyond reputeKevin Sevcik has a reputation beyond reputeKevin Sevcik has a reputation beyond reputeKevin Sevcik has a reputation beyond reputeKevin Sevcik has a reputation beyond reputeKevin Sevcik has a reputation beyond reputeKevin Sevcik has a reputation beyond reputeKevin Sevcik has a reputation beyond reputeKevin Sevcik has a reputation beyond reputeKevin Sevcik has a reputation beyond reputeKevin Sevcik has a reputation beyond repute
Send a message via AIM to Kevin Sevcik Send a message via Yahoo to Kevin Sevcik
Re: White Paper Discuss: Spreedsheet to Calculate the Ranking of Teams
Just noticed something fiddling in OO with the spreadsheet. I don't think there's a ruling from FIRST on this, and it will rarely be important, buuut...

Currently a Surrogate team has its entry removed from the Tie Breaker column. However, a DQ'd team still gets the high score from that match. Logic would suggest that a DQ'd team not benefit from the match and not have it counted towards their high score. The formula to implement this in cell T2 on the MATCHDATA sheet would be:

=IF(OR(F2="X",E2="X"),"",IF(N2="X",D2,""))

I think. That's what it is in OOo, except with semicolons instead of commas. Then fill that down the column.

EDIT: And posted seconds after poor Joe thanks me. Don't I feel silly now...
__________________
The difficult we do today; the impossible we do tomorrow. Miracles by appointment only.

Lone Star Regional Troubleshooter
Last edited by Kevin Sevcik : 17-03-2005 at 20:42.
Reply With Quote