2015 Rock City Regional: Pre-Season Scouting Sheet
Over the past few weeks I’ve been slowly chipping away at making a pre-season scouting sheet for each event our team is attending. I’ve finally finished it up and figured I’d share it so others can use it as well.
Included in the sheet is basic team information (Team #, Name, Location, Years Experience), Attending Midwest (our other regional), 2014 Performance (Each regional seed and elimination finish, Championship seed and elimination finish with what division), and finally 4-Year Performance Statistics.
That last section is something I kind of created on my own. I know a lot of people have been using “BBQ” to look at a teams recent performance over a few years, but I didn’t think that was a great way to look at it as that only accounts for regional championships and it also includes major awards, which don’t always translate to performance on the field.
For these reasons I tried to make my own basic statistic. What I did was assigned point values for each finish in eliminations a team can have. They are as follows:
Regional Champion: 1.0
Regional Finalist: .75
Regional SF: .50
Regional QF: .25
Einstein Champion: 4.0
Einstein Finalist: 3.0
Einstein SF: 2.0 (also Division Champion)
Division Finalist: 1.5
Division SF: 1.0
Division QF: .50
Then, once you have a total for a season, you take the last four seasons and add them together. However, I gave multipliers for more recent seasons. This equation ends up looking as follows:
=(4*[2014 Total])+(3*[2013 Total])+(2*[2012 Total])+(1*[2011 Total])
I did this because I thought that recent performance is more important and pertinent to the current/coming season than say 3 years ago. However I still wanted to account for and look at long-term performance. I thought this provided a good balance.
Of course, this is not perfect, and it does not account for strength of event, where a team was picked (captain, 1st pick, 2nd pick, 3rd pick). I just wanted to be able to have a basic statistic that gave me a rough but reasonably accurate idea of how good a team has been over the past 4 years, and based on the trends of the past few years where they might be this year.
Let me know what everyone thinks of this. Also if you see anything that is wrong, let me know and I’ll update the information. All of the data was pulled from TBA. Finally, if you think a piece of information should be added to the sheet that is easily and readily available, then let me know and I’ll look into adding it.
Note: I thought about taking out the “Attending Midwest” section on this public version, but decided to leave it. I figured anyone who downloads it could change it and update the info for whatever their 2nd event is (and add more columns if they attend more than 2).