So I sort of made a very rough draft of what I was talking about. I did the best I could do in a short amount of time (I didn't want to spend too much time if it wasn't necessary).
Anyways, here's a link to a theoretical template that people could fill out for their team:
Note at the bottom the different worksheets. The input page is what people would have access to. They would fill in the information for each player and then grade the attributes listed 1-10. If you switch over to the calculations worksheet, you'll see the same numbers, and then some identical ones underneath. Just focus on the ones underneath. There are a few calculations going on. First, I adjusted each player's overall so that the average would be exactly 5.0. This is to eliminate bias, so no matter what rating system someone uses, each team is balanced. Then what I did was make it so each players stats averaged out to his overall average. On the calculations page, there is also a "Team Index" and I gave SDSU a 75. This is an arbitrary number, but is a multiplier that will affect players' ratings. Better teams will have a better index. I made sure the team average overall was 5.0, and unless I want each team to be evenly matched, I need a multiplier to make the good teams better than the not-so-good teams.
If you are lost so far, follow with me. The first player I input was Jamaal Franklin. I gave him an overall of 8. Since my teams average overall was >5, I adjusted his overall to 7.7 to avoid bias (I will adjust this formula later). Then, I took all of his stats and adjusted them so their average is 7.7 (again, I will adjust this later and weight accordingly). The team index is 75, and will be used as a multiplier to solve for ratings.
Now, switch to the output worksheet. You will see that everything is a formula! Yay! We like formulas. That means everything is calculated for us. If you understand excel, you can follow it quite easily. If you don't: Position and number are automatically copied from the input page. Height is converted from Feet'Inches to 2k13's method of height (i.e. 6'6 = 198.12), Shoe Brand is changed based upon the school's sponsoring brand (i.e. SDSU = Nike). All Player Overalls are inserted based on a formula using: Player Overall, Team Index, and the player's individual category rating. These are just very rough numbers, as I put little thought into it so far.
Essentially, this will make the rating process automatic. Instead of doing everything by hand, all you will need to do is have several fans grade a team, average those numbers and then put it into excel, and it will output all the ratings.
So yeah, that's my idea. I was bored and had an hour. If this were the real thing, I would actually spend time on the formulas for ratings and such (and create a better method to get rid of bias, etc.) Just let me if you are interested in this at all. If not, I might just start my own project while I wait for this one to be released
