View Single Post
  #26   Spotlight this post!  
Unread 23-02-2014, 23:16
Nemo's Avatar
Nemo Nemo is offline
Team 967 Mentor
AKA: Dan Niemitalo
FRC #0967 (Iron Lions)
Team Role: Coach
 
Join Date: Nov 2009
Rookie Year: 2009
Location: Iowa
Posts: 805
Nemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond reputeNemo has a reputation beyond repute
Re: New FRC Stat: aWAR

I've been looking through the aWAR numbers and having a lot of fun checking it out! Thanks for putting this out there!

Quote:
Unless I'm mistaken, couldn't the aWAR of 4 be a 4-8 team that won Chairmans award, though? I'd be curious to see the rankings based only on on-field preformance.
You can actually do that with the spreadsheet. Go to the Point System tab and change all of the award values to zero (or any other value you like), then check the new totals in the aWAR tab. The Team Lookup tab isn't going to update, because it's looking at a table of static values, but the aWAR tab will have the numbers you want.

Speaking more broadly, you can also change the point system in various other ways in that tab if you're into playing with numbers.

Quote:
Any chance of saving a copy as .xls (2003 era)? It's too big for Google Docs, and I won't have access to newer Excel until Monday
The spreadsheet uses functions that aren't available in Excel 2003, so here are just the aWAR numbers for each team:
aWAR.xls

Quote:
I did a quick linear regression using the aWAR data from 2008-2012 to predict aWAR in 2013. The R^2 was 0.50.
Thanks for running those numbers! One of these summers I want to go more in depth into this type of thing.