Team 862 scouting database

[Dragonking]

Here's our 2013 scouting database. This excel database is focused entirely on quantitative data and analyzing. Many of features include team accuracy as well as a weighted list. The weights can be edited based on what a team believes is more important. You can sort by auto, tele, climb and points contributed in separate tabs in case there is a tie for other scores.
Another feature is a fast input of matches into the database so you can filter by match list. Simply type in your match list or if possible copy and paste it. A macro will assign the correct match number to the correct team in the data input sheet.
There is no quantitative data input. The spreadsheet can be edited to fit a team's needs but there are a lot of functions so be careful.
Make sure to enable macros for the best parts of the database to work (it will work without macros but any match organization will not work).

Input, improvements and general comments are greatly appreciated.

Updates for 64 teams and 100 teams to come (as long as out team makes it that far that is:) ).

[Dragonking]

This database worked really well for us at kettering. We got relevant data throughout the competition and were able to pick a winning alliance.

[flippy147852]

Can you upload it as an .xlsm file instead? The version you have up has no macros at all.

[omsahmad]

I'll mess around with in greater detail later, but it looks very slick and efficient. Thank you for sharing this.

[Dragonking]

you might have to save it as a macro enable copy (save as-macro enabled excel)

When i tried uploading it CD wouldn't let me, xls could be uploaded

[qzrrbz]

Updates for 64 teams and 100 teams to come (as long as out team makes it that far that is:) ).

From your performance at Kettering, I'm pretty sure you'll be needing the larger field versions! Your alliance's auton flurries in the elims were wonderful (and frightening!) to behold -- just depends upon perspective! ;)

[Dragonking]

also make sure you don't use any sorts in the raw data sheet because that will mess up the entire database. I will post updated versions with improvements
With our district win in kettering today we will definitely go to michigan state championships so i will post a 64 team database.

[Arhowk]

With our district win in kettering today we will definitely go to michigan state championships

That match was rigged... the score was like 330 to 90 but you still won!

[Dragonking]

Newest update for 2013 scouting database.

http://www.chiefdelphi.com/media/papers/2784

Works for up to 100 teams.

Enjoy!

[Shane 2429]

nice looking database! i really like the format
my team did something similar to this though not as fancy

here is the link to mine http://www.chiefdelphi.com/forums/showthread.php?p=1244299#post1244299

[Dragonking]

In case one of the macros wasn't working i just fixed the problem and re-updated it.
Any comments?

[marccenter]

Team 862,
How do I enable the macros? I selected the text at the top when opening the spreadsheet but it still complains that the macros are not enabled?

[Dragonking]

Find the "save as" button
Find the "save as type" option and change it to "Excel Macro Enabled Worksheet"

This should work. Also what excel version are you using (what year)? That might have some effect as well (this was made using 2007).

[z_beeblebrox]

I like the database very much and 4183 will probably end up using this at the Phoenix Regional. However, I have a few questions:

What do you change or do if teams play fewer than 12 qualification matches at a regional?

Is collected data intended to be entered in the "Raw Data" sheet?

Is there anywhere to input notes on matches or data or media from pit scouting?

[Dragonking]

For the number of matches it will still work if there are less per team. Just ignore the message in the top left corner of raw data tab. Everything still works just as well. The empty spaces will be taken up with Missing! 1 etc. depending on the number of matches missing (or non existent). There may be an update for this by week 4 or 5.

The raw data is meant to be the input area. Just put in the data in the open spots underneath the appropriate header. You can sort by match or team depending on how you want to input the data.

There is not a place to put pit scouting data or other such data. You could use the notes tab but that is meant for short notes on teams that stick out and for a separate pick list.
Our team just keeps everything in paper form and takes it our when needed. This database is meant mainly for numbers.

[Dragonking]

New update.

http://www.chiefdelphi.com/media/papers/2784

Works no matter how many matches are played per team at a competition.

[Dragonking]

Scouting database 2013- 4.0 is now released.

http://www.chiefdelphi.com/media/papers/2784

Macros run faster and smoother.

[Dragonking]

How does everyone like the database?
Any questions, input, comments?

[Dragonking]

Update 4.1

Check it out!

New features include bugs fixed for any competitions with over 40 teams. Added eliminations bracket. Alliances table moved to notes section. Slightly edited points contr tab and pick list tab for easier analysis.

http://www.chiefdelphi.com/media/papers/2784

[Dragonking]

new update out, please comment if any bugs occur

[Rebellion2638]

This is just a suggestion:

I have an idea on an way to input match data. I made an outline of how the excel sheet could look like. Since I do not know how to make macros I did not put them on the buttons. (File is in the attachment)

Description of how it could work:

(I am not sure how to do it but, I think it would work best if the data could be collected from multiple devices and then it gets inserted into the appropriate locations on the master database)

The user inserts the match number and then a drop-down list gives the user the choice of 1 of the 6 teams (this would give the macro a location to put the data). Then there could be a button the person presses after they put in the match and team numbers to confirm the team that they are scouting. After that it is pretty strait forward. The background button is shots missed and (for the climbing section) if they failed the climb (there can be another button if they didn't attempt the climb). Also you can add a button to time the robot's climb.

If you want to be creative you can make buttons transparent and put them pictures above a picture of the pyramid/goal (I think it would only work with the pyramid though).

[Dragonking]

Honestly I am not sure if I could do that. Our team uses paper scouting plus this database. Also I barely know how to use macros. Basically, I know how to record actions into a macro, use macros I find on the internet, and some very basic commands.

If you can find someone who could do this, that would be great. I would be glad to add any improvements and updates.

Unfortunately, this database is made in such a way that any changes made to how you input data (changing the raw data tab) and you might as well make a completely new database from scratch because all the tabs are connected to each other and are very easily disrupted.

Their are plenty of programs that do exactly what you are talking about. The whole point of this database is to have very simple, basic input and output that allows you to make the most of what you scout. There are programs have high tech input and output but are also complicated to edit and change.
Maybe next year I will find a way to merge the two but there is no way I could make such drastic changes by champs.

Thanks for the suggestions and hope someone can use them.

[Rebellion2638]

No problem. I just thought of that idea because some people aren't that great at collecting data and it takes a heck of a long time to input all of the numbers for each match (especially for the championship).

[Dragonking]

I completely understand. Our scouting team includes 5 people who all do different jobs to make sure everything goes smoothly and quickly. We make the rest of the team do actual match and pit scouting. We have one person inputting data into the computer. 2 people making sure all the sheets get handed out or given back. one person make sure the sheets are in order for the most efficient input into the computer.And the head scouter (me) who makes sure everyone is doing their job, helps any person who needs help, watches matches and takes notes, and gets data to the drivers. This works because our team is huge (over 70 students) so we can distribute the load and let everyone take a rest. We don't have any dedicated match scouters because of this. I understand that some small teams may have problems so I would suggest to those small teams to possibly team up with another team to get enough scouters. Even our team did that at the Michigan State Competition (with 3641 because they didn't have enough scouters). The positive of doing this is that involves cooperation, coopertition, and gracious professionalism.