|
|
|
 But if we just re-play "Triple Play" then what in the world will the Game Design Committee do with all that new-found free time? Since they wouldn't have to come up with a new game, they would have to concentrate on other things - like how to enforce the proposed "no metal on robots" rule. - dlavery [more] |
 |
|
|||||||
|
||||||||
Hi all,
This falls under the better late than never catagory, but perhaps some folks will be able to us this.
It is a spread sheet that boils down all the data from FIRST's website from the regionals.
Essentially, all you have to do is type in a team number and this spreadsheet gets the fo...
Hi all,
This falls under the better late than never catagory, but perhaps some folks will be able to us this.
It is a spread sheet that boils down all the data from FIRST's website from the regionals.
Essentially, all you have to do is type in a team number and this spreadsheet gets the following:
Team Name (long and short)
All Awards FIRST has given that team
Percentile Ranking of the team during the seeding matches
All the teams seeding matches with data like, W/L/T, Score, Partners, Opponents, THE %RANK of the partners and the opponents
All Elimination Matches (that first posted -- weeks 3-5) allong with the same data from the seeding matches, plus what PICK they were in the draft, plus what alliance they were on.
I think that it is an easy way to get a handle on what a team has done this season.
It is kind of kluggie if you look at the formulas, but it works pretty well considering I am trying to do database stuff with a program intended to add up columns of numbers.
Finally, I have renamed the regionals in my spreadsheetMy shorthand is this WSS where W is the WEEK the regional ran (1-5) and SS is the STATE (or Province) that the regional was held in. So the Great Lakes Regional becomes 2MI, the Canadian Regional becomes 5ON. . It works for me and I hope that it does not confuse others.
I hope some other folks find this type of data useful.
Joe J.
Attached Files
-
Team Regional Perfomance at your finger tips...
1081953314drjoesdataminer2004.zip
download file
uploaded: 14-04-2004 10:35
filetype: ZIP
filesize: 769.38kb
downloads: 137
Discussion
view entire thread
14-04-2004 10:43
Joe Johnson
White Paper Discuss: Team Regional Perfomance at your finger tips...
|
Originally Posted by CD47-Bot
Thread created automatically to discuss a document in the White Papers.
Team Regional Perfomance at your finger tips... by Joe Johnson |
Sorry for the shameless plug of my own work here, but I put a lot of work into it and, while would be fine for just my team to gain the benefit, it would be even better if more folks took a look at it and perhaps got some small benefit from it.
The spread sheet basically boils down all the match, awards and standings data from the FIRST website into a one pager on the team of interest. All you have to do is type in a team number and all the data about how a team did during the regionals is available for you.
One thing I really like about it is that it tells you not only a teams win-loss-tie record, but it tells you who were their partners and who were their opponents for every match they played. More importantly, it tells you the PERCENTILE RANKING of their partners and opponents.
It also tells you stuff like what awards they won, where they were picked in the draft (for me a very good metric of a teams overall strength), what matches they played in the elimination rounds, plus other stuff.
I hope folks find it useful.
Joe J.
P.S. Note that the elimination round data was not posted for weeks 1 & 2 so the spread sheet only has draft data and elimination round data for weeks 3-5. Also, I hope that FIRST posts which robots played which matches next year. It would have been a very good bit of data to have. As it is, all we can tell from the data FIRST posted is that this alliance beat that alliance not that Alliance1 played robots XXX & YYY against Alliance2 who played ZZZ & AAA. I don't know if this is on purpose, because FIRST is trying to protect folks from the knowledge that their robot screwed up but I hope that it is put in the data next year anyway.
For example, you cannot tell from the data that the alliance lost both matches it played team 47 in the elims in San Jose -- I say that not to put my team down, though I AM mortified about the programming error that cost us the last match, but to point out that that is an important part of the story when a team is evaluating us and it would be nice if it was available.
14-04-2004 13:19
Joe Johnson
Re: White Paper Discuss: Team Regional Perfomance at your finger tips...
UGH! I just found a problem in my spreadsheet.
I will upload a new version that fixes my error, but if you want to you can fix it myself: in column D of TeamSheet, replace "MatchesWinSc" with "MatchesLossSc"
Basically, I display the winning score in both columns, by mistake.
Sorry for the mistake.
Joe J.
14-04-2004 13:50
Joe Johnson
Link to updated/fixed spreadsheet
|
Originally Posted by Joe Johnson
UGH! I just found a problem in my spreadsheet.
I will upload a new version that fixes my error, but if you want to you can fix it myself: in column D of TeamSheet, replace "MatchesWinSc" with "MatchesLossSc" Basically, I display the winning score in both columns, by mistake. Sorry for the mistake. Joe J. |
http://www.chiefdelphi.com/forums/pa...le&paperid=328
Joe J.
14-04-2004 13:56
Jessica Boucher
Re: Link to updated/fixed spreadsheet
Joe, this is awesome. You always put out quality stuff, so waiting for a few bugs to be fixed is no problem at all (for me, at least) 
Are you posting from Atl? Or are you still in MI?
PS - I wish I knew how to do spreadsheets as well as you, because if I did I wouldn't even mess with Access.
view entire thread
Tags
loading ...