View Single Post
  #11   Spotlight this post!  
Unread 17-03-2005, 00:26
Joe Johnson's Avatar Unsung FIRST Hero
Joe Johnson Joe Johnson is offline
Engineer at Medrobotics
AKA: Dr. Joe
FRC #0088 (TJ2)
Team Role: Engineer
 
Join Date: May 2001
Rookie Year: 1996
Location: Raynham, MA
Posts: 2,633
Joe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond repute
Re: **FIRST EMAIL**/A note on the FRC scoring system

Please Please test it. I did my best, but anyone who knows Excel, knows that it is pretty ugly at some things. This one is uglier that usual because I didn't want to use Macros or VB to make some of the uglier bits go away.

Also, I wanted it to allow for relatively easy cut and pastes to from the "Hatch" pages FIRST publishes (or DID publish, I think they took them down). I would have never put that extra line between the Matches on the MATCH DATA sheet except that that is how it comes into Excel if you copy and paste the page from usfirst.org. By the way, when you cut and paste, go to an intermediate sheet first rather than trying to paste right on that page. Also, try using "paste special" to paste the values only.

Like I said, it is pretty ugly, but I think it gets the sums right and implements the logic that FIRST published for ranking teams.

Keep me honest here.

Joe J.
__________________
Joseph M. Johnson, Ph.D., P.E.
Mentor
Team #88, TJ2
Reply With Quote