RoboDragons Scouting Database

VEX Robotics Competition Discussion VRC > Previous Games
1

https://dl.dropboxusercontent.com/u/30869408/screenshot.png

Our club has been working on this database now for a couple months. We first created this program to be able to offline view the data here, however we found that calculating it ourselves would be easier.

This program allows you to import a .csv file from robotevents.com and retrieve all of the match data and all of the teams from the file. It will then calculate OPR (Offensive Power Ranking) as well as CCWM (Calculated Contribution to Winning Margin). This allows us to rank teams based on their performance during competitions. We also added several other features such as average score per match, average opponent score per match as well as win-loss margin.

But we didn’t stop there. You also have the option of importing as many .csv files as you want. It will then calculate everything out based off of all of the competitions a team has been to. But you say, “I don’t want to go a download all of the .csv files from robotevents.com one by one.” and to that I say, “Use our program”. With the RoboDragons Scouting Database, you have the option of downloading any competition from this season and importing it into the database. However, since having 100-200 csv files is an inefficient way of storing all of that competition data, we have developed a new file type (.cdf) that holds all of the competitions that you downloaded if you download more than one at a time.

But what use is this information if you can’t find it easy. We implemented a search bar just for that reason. Type in a team number, or multiple, separated by commas, and it will show you only those teams.

Oh, and if you want to see how a team did at the skills challenges, we implemented that for you as well. On launch of the program, it goes and retrieves both robot and programming skills data from the robotevents.com skills page. All of this information should be helpful to you at the world championship or any event that you may attend. The database has the ability to even download incomplete competition data (not tested) so that during the world championship you can get updated and see how your team is doing compared to the others.

I hope you all like this. Let me know what you think.

**Link to the application: **https://www.dropbox.com/s/1utzzemullpzgo1/RoboDragons%20Scouting%20Database.exe

**Link to a .cdf of all of the competitions so far this season: **https://www.dropbox.com/s/q6gtjfvp23ch8j0/All%20Comps%20New.cdf

Changelog:
1.1.0 (4/11/13):
-Added who won autonomous for each match
-Added average autonomous winning in the ‘More Info’ screen

1.2.0 (4/12/13):
-Added a breakout of all of the sacks scored (F-T-H)
-Added a total sacks scored for each team per competition in the ‘More Info’ screen

2

Thanks for making this available! Now I have no need to make an off-line version of my Power Rankings pages. I know my teams will definitely be using this in preparation for (and during) Worlds next week.

Jay

3

Does this work on Windows XP? I try running the app and this pops up:

4

Try this: https://www.dropbox.com/s/1usn5ti371rek7q/RoboDragons%20Scouting%20Database%20%28x86%29.exe

I haven’t tried running it on a 32-bit machine. Let me know

5

The only problem I have had is that the tournament that I went to that had 2 divisions is showing all ties for my team. I really like it though and it seems like all of the scouting databases have a problem with multiple divisions.

How would I take that competition out of my list?

6

What was the name of the competition that had 2 divisions. Could you try clearing the database and downloading the competition through the dialog?

7

Upper Midwest Regional VEX HS Robotics Tournament- Bradbury
Bradbury was the division I was in and it shows all ties.

8

Same thing is happening.

9

What it looks like is that robotevents doesn’t have any data for that division. Look here: http://www.robotevents.com/upper-midwest-regional-vex-robotics-tournament.html

10

What XP Service Pack do you have installed? If you have SP3, download this: http://www.microsoft.com/en-us/download/details.aspx?id=17851

and then try this: https://www.dropbox.com/s/z3kp5gy4dttv5nr/RoboDragons%20Scouting%20Database%20XP.exe

11

YAY! It works now!

12

Oh, wow! This is truly stellar! I will definitely be using this. Great to have an offline version, as Internet will be hard to come by at Worlds (at least easily).

If you plan on making any future releases, could you possibly include autonomous winner for a given match? Perhaps add statistics about that (i.e. # of times autonomous won), too. I can imagine that updating a database like this might take a lot of effort, so please don’t make a point of adding only this feature.

13

Your wish has been granted. The file now calculates percentage of autonomous won and will display it per competition in the More Info screen. The link is the same: https://www.dropbox.com/s/1utzzemullpzgo1/RoboDragons%20Scouting%20Database.exe

If anyone wants any more features, feel free to ask. It will be a lot easier to add them now than next week.

14

This is a great tool. Thanks for making it. Could you add an option to delete a tournament? (or tell me where the option is). I ask because there was a tournament we were not present at but is still listed on robotevents as six losses.

Better yet, add a way to delete a particular team from a competition. You don’t have to though, it’s great as it is.

15

Thank you so much. The RoboDragons Scouting Database has officially earned a pinned spot on my taskbar (a very esteemed position, if I do say so myself)

16

Version 1.2.0:

https://vexforum.com/attachment.php?attachmentid=7401&stc=1&d=1365775198

I have recently got a request from someone to add a breakout of the scores. The Red Score and Blue Score column will now show how many sacks in the floor, trough, and high goals. On the More Info screen, it will now give a breakout of total scored per match.

Here is the download (same as above): https://www.dropbox.com/s/1utzzemullpzgo1/RoboDragons%20Scouting%20Database.exe
screenshot3.jpg

17

I have been working on it all day and will have to work a little longer. Sorry, maybe a future addition.

18

Can I upload the .csv file from the Robot Events page? I want to look at all the teams in my division (Engineering) to see stats of all the teams. I want to be able to see only the teams in my division, and see how well they have done throughout the year.

Is this an option?

19

Yes, actually just added that feature today. What you will do is load in all of the data you want and then go to Competition → Add Team List. You will then select your downloaded list of teams. It will then remove all of the teams not in the list.
You will have to re-download the program: https://www.dropbox.com/s/1utzzemullpzgo1/RoboDragons%20Scouting%20Database.exe

20

Thank you so much!