Quote:
Originally Posted by Grim Tuesday
Crowd sourcing is awesome. What would you say to a column with "2012 record", "highest finish" and "highest draft position"?
|
IMHO, it's more of a "novelty" - something that would be nice to know, but wouldn't be particularly critical to scouting (and would in turn clutter the spreadsheet), because such records are highly dependent on the environment and because most, if not all teams, will be making additions and/or changes to their robot that will change their comparative performance.
If someone were to do it, though, I don't think it would be particularly hard. I believe that Ed Law's database already contains data like that sorted by team (although it may not be cumulative, but rather per regional/district).
If you want to do it yourself, the gist of the process I used was to first sort the data into columns of text values (I had to create columns of the original values, and then input =TEXT(<cellref>,0) to do this), and then use VLOOKUP with a list of teams in said division to look up the corresponding stats.
There is one thing I'd like to make a note of though. While I understand that everyone wants to contribute as much as they can to these spreadsheets - which is exactly what we want, after all - I've had to revert a number of changes (to the formulas that summarize/filter the data) recently, because the editor didn't properly assess the changes they made. Because of this, I'm requesting that people please refrain from editing the formulas in the current spreadsheets until they have tested the formula in a duplicate worksheet to ensure that it properly works.
That being said, I really am amazed by how fast this has gone - once we figured out a way to display which teams didn't have data entered, the data for those teams was filled in within less than a day!
As an aside about TFA, I'd just like to say that although it was a bit tricky to work with, it really helped me with adding OPR and CCWM to the spreadsheet.