|
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
|