2013 Scouting database team 862
by: Dragonking
This is the 2013 scouting database for team 862.
Newest update for database.
New features include:
-100 team database (works with less)
-redone pick list and related tabs (includes more info like points/disc and average points)
-match lookup (type in match number and get avg and total stats for each team in that match, projected alliance score)
-team lookup (type in team number and get all raw data on specific team, makes it easier when you have a lot of teams to keep track of)
-projected alliance score for each match based on average score of each team
-ranks teams based on projected qualification score
-new color schemes for all tables
-now works when teams get assigned less than 12 matches at a competition
-also included example match scouting sheet with quantitative and qualitative data, feel to edit for team’s needs
Note:
1.0 and 1.1 are both non working databases used only for troubleshooting. These were my first stages in designing the final database
2.0 and 2.1 were used in week 1 for our team
3.0 has many updates and works for up to 100 teams
4.0 faster macros
4.1 occasional bugs that occurred with over 40 teams have been fixed, Output tabs have been slightly changed, eliminations bracket added
4.3 changed match lookup tab to more efficient mach prep tab. Match prep tab has less congested data, graphs to show team performance and ability to print off data as strategy sheets for drivers to use. Also increased database to 105 teams. Updated Elims Bracket tab to make it easier to use.
5.1 new and improved features, faster and more efficient, easier to edit and change, no instruction and some bugs may still exist, this is all the updates I have added during the summer
Match scouting sheet 2013.doc (82.5 KB)
Scouting database 2013- 1.0.xls (442 KB)
Scouting database 2013- 1.1.xlsx (452 KB)
Scouting database 2013- 2.0.xlsm (497 KB)
Scouting database 2013- 2.1.xlsm (616 KB)
Scouting database 2013- 3.0.xlsm (3.25 MB)
Scouting database 2013- 4.0.xlsm (3.31 MB)
Scouting database 2013- 4.1.xlsm (3.12 MB)
Scouting database 2013- 4.3.xlsm (3.39 MB)
Scouting Database 2013- 5.1.xlsm (2.67 MB)