
My Fake Spreadsheet
Through the years, there have been a few spreadsheets or calculators posted here, which provided varying degrees of help in decision-making.
I use them a bit as well (mostly ahead of the Draft), but in general, my main help has been an Advanced Stats table I run, where the main factor is the WS/48 stat, in general, the one I think is the most trustworthy (at least in BBGM, and I continue hoping that u/dumbmatter will add it to Player and Comparison cards sooner than later).
For people not using WS/48 before, when I have a Top3 team in the league, my rule of thumb is:
- I expect my Max Player to have it around 0.30 or more.
- I expect players earning 10-20% of the Cap to hover around 0.20
- Other rotational players should be above 0.10, with 0.075 being the last acceptable line.
I also added some other stats I tend to look at; fortunately, it was possible to pack them all on 1 screen - it's a big help.
The above table is for HPU25 players - High Potential (65 or more) players, who are 25 years old or younger.
Of course, you can also adjust the age level, if you want to just check the highest-rated players in the league (for example, my max player in this save was 29 years old, 73 OVR and 0.276 WS/48).
I have a similar table for cheap and lowly rated (55 POT or lower, but it's adjustable) veterans, who can give my team a boost at the Deadline. For example, spending potentially #30 pick on them is acceptable, but sometimes a young player, behind the Age vs OVR curve, while still having a decent POT, is enough to make it happen.
And I have one more table, this time for cheap (or not, it's adjustable as well), 3&D players.
I use the following criteria to exclude players not fitting them, so the list is typically very short:
- TS% above the league average (55 if playing in a modern area, lower historically)
- USG% below 20
- TOV% below 15
- 3PAr above 0.30 (in modern games, older ones should have it lower)
- STL% above 0.75
- BLK% above 1.5
I hope, it will be a help for someone trying to improve his decision-making and results.
If not, sorry for wasting anyone's time.
Cheers.