Work I want someone else to do...

[Joe Johnson]

We have a lot of data about the teams in the various divisions but I think that there is some more information that would be useful for scouting teams at the Championships.

Specifically, I think there is a lot of information contained in the drafting choices of the teams that went to regionals. I am not saying that teams are perfect in their picks (Lord knows that our team is pretty much in a state of chaos every time we get the opportunity to be a drafting team -- in fact most times we are not sure we will even BE a drafting team until the last one or two matches). Be that as it may, I think the drafting teams have put some serious thought into ranking teams. I would like to have easy access to that collective wisdom (flawed as it is).

To this point, we have really only where teams seeded and whether or not they were on the winning alliance or whether they were on the runner up alliance. I think that in addition to the drafting information, there is other data from the regionals that I think would be useful to have access to in a concise format.

What I would really like is for someone to add the following columns to Ed Spark's AWESOME spreadsheet:

2. 1st regional attended (FL,VA,OH,TX,NY-LI,MI-YP,NJ,NY-NY,PA,WA,CA-SJ,IL,MO,CT,CA-LA,MI-GR,ONT)
3. Seed at 1st regional (1,2,...)
4. Draft Number at 1st regional (1,2,...,16, ND, AC)
   ND=NotDrafted
   AC=AllianceCaptain
5. Alliance Number at 1st regional (1,2,...,8, ND)
   ND=NotDrafted
6. Elimination Finish At 1st regional (QF,SF,F,C,ND)
   QF=Eliminated in Quarter-Finals
   SF=Eliminated in Semi-Finals
   F=Eliminated in Finals (i.e. Runner Up)
   C=Champions
   ND=Not Drafted
   
7. 2nd regional attended (FL,VA,OH,TX,NY-LI,MI-YP,NJ,NY-NY,PA,WA,CA-SJ,IL,MO,CT,CA-LA,MI-GR,ONT)
8. Seed at 2nd regional (1,2,...)
9. Draft Number at 2nd regional (1,2,...,16, ND, AC)
10. Alliance Number at 2nd regional (1,2,...,8, ND)
11. Elimination Finish At 2nd regional (QF,SF,F,C,ND)
    
12. 3rd regional attended (FL,VA,OH,TX,NY-LI,MI-YP,NJ,NY-NY,PA,WA,CA-SJ,IL,MO,CT,CA-LA,MI-GR,ONT)
13. Seed at 3rd regional (1,2,...)
14. Draft Number at 3rd regional (1,2,...,16, ND, AC)
15. Alliance Number at 3rd regional (1,2,...,8, ND)
16. Elimination Finish At 3rd regional (QF,SF,F,C,ND)
    

Anybody have more time on their hands than I do?

Joe J.