RealGM

New version posted on 4/18:

https://docs.google.com/spreadsheets/d/1T2Eg_zvqNqQD_5TpE4Ns6xhElatXdLpYG1roZtRLyvE/edit?usp=sharing

Salary Updates and Depth Charts:

Updated with all transactions through 4/18.

Updated Free Agent Alpha sheet:

International signings being update.

G-League Rosters

Updated as of 3/19.

Updated 2019 Free Agents by Team and Free Agents by Position sheets

Updated through 4/18.

Updated NBA Draft Eligible Players

Updated through end of NCAA season.

FAQs

Since posting I've been getting a lot of the same questions, so I figured I would post a little FAQ.

Updates
1. Do you plan to keep updating the sheets?

I've been updating them for over a decade now. I have no plans to stop, as it is a key tool for me. I will continue to post the sheets as long as there is interest from the community at large!

Edits
1. Are you going to allow edits to the Google Doc?

At this time I have no intention of that. Mainly due to integrity issues. I have no challenge with copying the data and editing it yourself, but I don't want the public version of the sheet to get messy.

Salary Sheets
1. Why are some things highlighted in yellow?

These are salary items which have some kind of variable. Either the salary number is not official or I haven't been able to track down the exact number yet. In most cases, these will disappear after the cap is set and everything locks in. New contract estimates will also be in yellow until I have the official numbers.

Free Agents Alpha List
1. How do players get on the Free Agents Alpha list?

Every player on the list has either: played in the NBA, played with an NBA team in Summer League, gone to training camp with an NBA team, was mentioned as a prospect for the NBA Draft, or played in the NBA D-League

2. How do players get removed from the Free Agents Alpha list?

I remove a player once he has gone a year without playing professional basketball anywhere. In this case, if a player did not play anywhere in the 2015-2016 season, he has been removed. Exceptions are occasionally made for injured players.

3. Why are some players in green font on the Free Agents Alpha list?

Those players are currently signed to a contract with team outside of the United States.

4. Is the Free Agents Alpha list comprehensive?

Not even close. There are hundreds, if not thousands, of basketball leagues all over the globe. Accounting for every single player isn't something I wish to try to undertake! This list is players who have some relevance to the NBA, either in the recent past or potentially in the future.

I will add to these FAQs as new ones comes up.

Thanks again to everyone for the interest. We've had massive traffic, I've gotten a lot of questions from all over, and to be honest, it has blown me away. It makes me very happy that so many folks are so interested in my work.

If you have any questions, you can hit me up on here. Quoting a post works best so I see it. You can also PM. You can also get me on Twitter at @KeithSmithNBA

Thanks again!

Smitty

Holy shnikes, Smitty...I hardly have enough time to read it, I can't imagine how long it took you to make it

Well done sir, and thank you for putting in that kind of time and effort, and sharing it with us!

loserX wrote:Holy shnikes, Smitty...I hardly have enough time to read it, I can't imagine how long it took you to make it

Well done sir, and thank you for putting in that kind of time and effort, and sharing it with us!

Years. It started as a quick roster tracker around 2003 or so. In 2006, I wanted to be able to see salary stuff without having to go online all the time. Then track FAs. Then Draft Picks. And so on and so forth. Every year or so, I add something new. Now it is pretty big, so I have to extract it from an overall bigger database.

Probably way more than you wanted to know.

Very cool, thanks for sharing the Google Sheet

Wow. Um. I keep some spreadsheets myself. Now I realize I might as well just toss them all and use Smitty's.

prech wrote:Very cool, thanks for sharing the Google Sheet

Thanks man!

SMTBSI wrote:Wow. Um. I keep some spreadsheets myself. Now I realize I might as well just toss them all and use Smitty's.

Hahaha! Nah man. That is how I started too! I wanted my own stuff and then it just got a little crazy from there.

This is awesome!!! I have a quick suggestion...because there are so many teams, and there are a lot of constants (like soft cap, hard cap, mle, bae, etc.), maybe you can make a "template team" roster's salary and then for all 30 teams you can reference those "constant" values so that you only have to update one time the 2018-19 salary, 2019-2020 salary, lux tax lines, etc. only once instead of 30 times.

Thanks for sharing, Smitty! Hope Celts make good use of all our potential cap

This is really cool. I was trying to do something in that mold, but I'm amateur hour next to this

RR9 wrote:This is awesome!!! I have a quick suggestion...because there are so many teams, and there are a lot of constants (like soft cap, hard cap, mle, bae, etc.), maybe you can make a "template team" roster's salary and then for all 30 teams you can reference those "constant" values so that you only have to update one time the 2018-19 salary, 2019-2020 salary, lux tax lines, etc. only once instead of 30 times.

Thanks for sharing, Smitty! Hope Celts make good use of all our potential cap

Thanks man! I actually have code in the full database that updates all the "constants" whenever I need it. I plug it in once and it updates all the necessary cells.

aramada wrote:This is really cool. I was trying to do something in that mold, but I'm amateur hour next to this

Ha! Thanks man. But that is how it starts. My sheets were crap for a while. Then I learned more and more and they got to be the out of control monster they are today.

Smitty731 wrote:

RR9 wrote:This is awesome!!! I have a quick suggestion...because there are so many teams, and there are a lot of constants (like soft cap, hard cap, mle, bae, etc.), maybe you can make a "template team" roster's salary and then for all 30 teams you can reference those "constant" values so that you only have to update one time the 2018-19 salary, 2019-2020 salary, lux tax lines, etc. only once instead of 30 times.

Thanks for sharing, Smitty! Hope Celts make good use of all our potential cap

Thanks man! I actually have code in the full database that updates all the "constants" whenever I need it. I plug it in once and it updates all the necessary cells.

Ok cool, I'm not a complete novice but still nooby with Excel. I just know how to not enter something a bunch of times hahah.

Hornets fan here - Jason Maxiell and Jeffery Taylor's cap holds extend until the 2021-22 season? Why is there a hold at all?

Just incredible, Smitty.

yosemiteben wrote:Hornets fan here - Jason Maxiell and Jeffery Taylor's cap holds extend until the 2021-22 season? Why is there a hold at all?

They never renounced either guy. The Cap Holds stay until a player is renounced.

Smitty731 wrote:

yosemiteben wrote:Hornets fan here - Jason Maxiell and Jeffery Taylor's cap holds extend until the 2021-22 season? Why is there a hold at all?

They never renounced either guy. The Cap Holds stay until a player is renounced.

Do you know this for a fact? Why would they not renounce them? They're just tying up cap space for no reason?

yosemiteben wrote:

Smitty731 wrote:

yosemiteben wrote:Hornets fan here - Jason Maxiell and Jeffery Taylor's cap holds extend until the 2021-22 season? Why is there a hold at all?

They never renounced either guy. The Cap Holds stay until a player is renounced.

Do you know this for a fact? Why would they not renounce them? They're just tying up cap space for no reason?

I do know it for fact. Most teams don't renounce guys until they have to. There isn't a real reason to keep either guy, but there hasn't been a reason to renounce them yet either. Considering the Hornets should have space this summer, they will likely renounce both of them to maximize their space.

A new version of the Roster/Salary Sheets has been uploaded.

Updates include:

1. More Cap Space Projections added - 10 teams left to complete
2. Future Draft Picks all brought to current after 2016 Draft Lottery
3. Draft Order brought to current after 2016 Draft Lottery
4. Draft Eligible Players updated
5. New Coaches added


https://docs.google.com/spreadsheets/d/1T2Eg_zvqNqQD_5TpE4Ns6xhElatXdLpYG1roZtRLyvE/edit?usp=sharing

https://docs.google.com/spreadsheets/d/1T2Eg_zvqNqQD_5TpE4Ns6xhElatXdLpYG1roZtRLyvE/edit#gid=2099125088

The link above will take you to an updated version of my Salary and Roster sheets. Projected Cap Space has been updated for all 30 teams. Let me know what you think about where I missed!

I have uploaded a new version. This version has cleaned a few things up and I also updated the Draft Eligible tab with all the withdrawals yesterday.

https://docs.google.com/spreadsheets/d/1T2Eg_zvqNqQD_5TpE4Ns6xhElatXdLpYG1roZtRLyvE/edit?usp=sharing

Keep the feedback coming!