Posted by stingray001 on 8/25/2014 7:23:00 AM (view original):
Posted by bhazlewood on 8/22/2014 1:46:00 PM (view original):1 SQL statement using a GROUP BY will do the trick.
In the STAGG thread, someone asked if it were possible to give class rankings for SO/JR/SR classes, instead of just overall and recruits.
It's *possible*, but it would take a sizable amount of new code to do so, and I'd have decide what to do with previously red-shirted players, and have to figure out the best way to present the data. However, if there's enough interest, I'd tackle the project.
So... what do you think? Useful information? Worthless Fluff? Mildly interesting?
The "Group By" would pull the player pool, but it wouldn't do the calculations of where your class ranks in relation to the other classes. Remember that class scores are no longer just an average of all your recruit ratings, but the relative value of each player in relation to the best and worst players at that position. Those calculations COULD be done by the web site - the underlying code is in Ruby - but I'm afraid it would be horribly slow. Currently I calculate all those values in Excel and store all of the ratings/ ranks in fields in the database.
Right now, the VBA code in the spreadsheet that does the heavy lifting only calculates a relative score for a player overall, and a class score if they are Freshmen. I'd have to modify that to do the calculations for all 2nd year players, 3rd year players, etc. (although that shouldn't be TOO difficult) and then calculate and store the school's score for each class. Add a few fields to the database (easy) and then figure out the best way to display the results.