This looks great! I have also been working on updating this year's rosters using TarheelFan's (I think that is his username) ratings spreadsheet. There are some flaws in his system but for the most part, I feel it has given realistic results.
I do have some questions/concerns about the formula you use as well. I will use Kentucky for an example because I am most familiar with them. I notice PJ Washington has a 96 3pt shot rating which seems way too high. What stats/math factor the shot ratings? While PJ does have the highest 3pt % on Kentucky's team, he probably isn't the best shooter on the team and far from the best shooter in the country.
I'm also curious of your thought process on determining the Off. & Def. Awareness rating. The formula's I have been using I feel is very flawed for determining those ratings. It basically gives players who get more MPG a much higher rating than players that don't. IMO (using UK again here) Ashton Hagans and Immanuel Quickley are very close when it comes to an overall rating and both are much better than say a small conference/mid major PG. But because of the Awareness rating formula's I have been using, Hagans ends up being much higher rated than Quickley and Quickley has the overall rating of a small conference PG.
With that being said, I really don't know what Off. & Def. awareness affects in-game or why it has the most influence on a player's overall rating.
I've been meaning to make a forum post with a few questions before I got too far into these rosters so instead of making a new topic I will just ask in here:
- There are some attributes I have no clue how to rate (on-ball def, low post off & def, hustle, consistency, stamina, vertical, shot in traffic, shoot off dribble) and I was wondering if anyone had a good way to come up with those attributes without knowing every player and team.
- The are some attributes that I have no clue what they do or how they affect the game/player (hustle, consistency, quickness, awareness)
- What influences a team's unity. I have completed a few conferences and so far Duke has the highest rating in the game at 87 and also have the highest Unity at 63 and the next highest is below 40. IMO, they shouldn't be one of the highest and I have no clue what attributes contribute to a team's Unity.
- What all attributes influence a team's overall Defense rating? Duke also has the highest (which they should be up there) but Virginia's defense is 78 with an 86 Offense. Virginia has one of the highest Def. Ratings in the country and one could argue is the best defensive team in the country so the rating seems low to me.
I'm not very good when it comes to making rosters and determining ratings and I really don't understand the ratings well enough to come up with my own which is why I've been looking for some advice or a good formula to use for each rating lol.
Sorry for the wall and being nitpicky