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.

[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

[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]

Originally Posted by Dragonking

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/sh...99#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?

[omsahmad]

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

[qzrrbz]

Originally Posted by Dragonking

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!