NBA Salary and Roster Sheets - updated 2/20

Moderators: Knickstape1214, DayofMourning, Dirk Nowitzki, Mr. E, bwgood77, BombsquadSammy, ken6199, Tarik Black, magnumt, GimmeDat, Rhettmatic, KF10, Slava, CoreyGallagher, Yuri Vaultin

Smitty731
Forum Mod - Celtics
Forum Mod - Celtics
Posts: 16,116
And1: 11,806
Joined: Feb 09, 2014
       

NBA Salary and Roster Sheets - updated 2/20 

Post#1 » by Smitty731 » Tue May 24, 2016 2:10 pm

New version posted on 2/20:

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

Salary Updates and Depth Charts:

Updated with latest transactions through 2/20. NOP/SAC trade included!

Updated Free Agent Alpha sheet:

Updated with all signings through 2/20.

D-League Rosters

Updated with latest transactions through 2/20.

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

Updated as of 2/20.

Projected Cap Space for 2017-18

Updated as of 2/20. All new CBA updates/estimates included!

Draft Eligible Players

Updated 1/13 to include more 2017 Draft Prospects.

Overseas Leagues

Other Overseas Leagues will eventually be added.

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. This is also one of the more time consuming updates to do, so it may all out of date at times. Lots and lots of research time on this one!

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
User avatar
CrookedJ
Analyst
Posts: 3,626
And1: 1,972
Joined: Dec 04, 2007
Location: Waterloo, Ontario
       

Re: Projected Cap Space Completed for all 30 Teams 

Post#2 » by CrookedJ » Tue May 24, 2016 2:18 pm

This is amazing!
baldur
Sixth Man
Posts: 1,768
And1: 1,498
Joined: Jul 12, 2015
Location: melbourne
     

Re: Projected Cap Space Completed for all 30 Teams 

Post#3 » by baldur » Tue May 24, 2016 2:23 pm

i dont think we are capable of telling you where you missed. no doubt, you put a great deal of effort on that. thank you .
User avatar
ken6199
Forum Mod
Forum Mod
Posts: 4,742
And1: 4,965
Joined: Jan 05, 2015
Location: St James' Park
   

Re: Projected Cap Space Completed for all 30 Teams 

Post#4 » by ken6199 » Tue May 24, 2016 2:25 pm

Your usual standard Smitty. Great work.

Bye bye hoopshype salary pages.
Smitty731
Forum Mod - Celtics
Forum Mod - Celtics
Posts: 16,116
And1: 11,806
Joined: Feb 09, 2014
       

Re: Projected Cap Space Completed for all 30 Teams 

Post#5 » by Smitty731 » Tue May 24, 2016 2:31 pm

ken6199 wrote:Your usual standard Smitty. Great work.

Bye bye hoopshype salary pages.


This is a huge compliment and you have no idea how much that means to me. Thanks man!
baldur
Sixth Man
Posts: 1,768
And1: 1,498
Joined: Jul 12, 2015
Location: melbourne
     

Re: Projected Cap Space Completed for all 30 Teams 

Post#6 » by baldur » Tue May 24, 2016 2:34 pm

send your resume to the 76ers for the gm position. Why wouldnt they hire you? im serious.
Smitty731
Forum Mod - Celtics
Forum Mod - Celtics
Posts: 16,116
And1: 11,806
Joined: Feb 09, 2014
       

Re: Projected Cap Space Completed for all 30 Teams 

Post#7 » by Smitty731 » Tue May 24, 2016 2:35 pm

baldur wrote:send your resume to the 76ers for the gm position. Why wouldnt they hire you? im serious.


Ha! Huge difference in compiling info and making some educated guesses vs actually building a team. But I'll take the compliment all the same! :)
Smitty731
Forum Mod - Celtics
Forum Mod - Celtics
Posts: 16,116
And1: 11,806
Joined: Feb 09, 2014
       

Re: Projected Cap Space Completed for all 30 Teams 

Post#8 » by Smitty731 » Wed May 25, 2016 2:32 am

Thanks for all the clicks all. We hit a huge amount of traffic for the doc tonight. I hope you are all finding it a useful resource!
User avatar
RalphWiggum
General Manager
Posts: 9,366
And1: 4,381
Joined: Jul 11, 2001
Location: PARTS UNKNOWN

Re: Re: Projected Cap Space Completed for all 30 Teams 

Post#9 » by RalphWiggum » Wed May 25, 2016 2:38 am

Smitty731 wrote:
baldur wrote:send your resume to the 76ers for the gm position. Why wouldnt they hire you? im serious.


Ha! Huge difference in compiling info and making some educated guesses vs actually building a team. But I'll take the compliment all the same! :)

Every team has a numbers guy, maybe a few have guys they don't like? Worst that can happen is you're right where you are now.

Sent from my SM-N900W8 using Tapatalk
MotownMadness
RealGM
Posts: 16,709
And1: 8,394
Joined: Oct 08, 2013
       

Re: Projected Cap Space Completed for all 30 Teams 

Post#10 » by MotownMadness » Wed May 25, 2016 2:59 am

Everyone has money lol
Austincys21
Veteran
Posts: 2,551
And1: 705
Joined: Apr 10, 2013
   

Re: Projected Cap Space Completed for all 30 Teams 

Post#11 » by Austincys21 » Wed May 25, 2016 3:13 am

Kinda upsetting seeing the Lakers have sooo much but other teams do as well... This is why a guy like Biyombo will get near 20m, Barnes near 16-18m, Waiters 14m, Speights 10m. My guess and I'm curious to see
User avatar
amcfad27
Bench Warmer
Posts: 1,283
And1: 1,470
Joined: Jun 04, 2010
 

Re: Projected Cap Space Completed for all 30 Teams 

Post#12 » by amcfad27 » Wed May 25, 2016 3:16 am

way to go OP :clap:
Image
User avatar
Johnny Bball
Assistant Coach
Posts: 3,816
And1: 2,649
Joined: Feb 01, 2015
   

Re: Projected Cap Space Completed for all 30 Teams 

Post#13 » by Johnny Bball » Wed May 25, 2016 4:37 am

Maybe I'm just reading the headings wrong. don't think the raptors are over or under by 9 million.

Salaries are 82.7. Derozan's cap hold increased to 15 from the allstar game I thought, not 9.5, so that's about 88.3. BB has an option and will opt out, so 85.3. I think they still have a cap hold on Nando Decolo to keep his rights (1.8) so 87.1 if they don't renounce it. 92 million projected cap so they have about 5 million in space. Minus salaries of two first round picks, including the 9th pick, they pretty much are dead even prior to resigning DD to a max deal, but that does get them to about 9 over if that's what you mean.
Wizenheimer
RealGM
Posts: 30,157
And1: 3,542
Joined: May 28, 2007

Re: Projected Cap Space Completed for all 30 Teams 

Post#14 » by Wizenheimer » Wed May 25, 2016 5:04 am

great job!

obviously, there are tons of variables, but it's a very good, one-stop road map that points out why the 'stupid' potential is so high this summer

I have one suggestion and it's very minor: I've only used xcel in spreadsheets before, but it had a feature that allowed you to lock the column headers in place, so as you scroll down the spreadsheet you can readily see what the columns are as the headers are always visible
Smitty731
Forum Mod - Celtics
Forum Mod - Celtics
Posts: 16,116
And1: 11,806
Joined: Feb 09, 2014
       

Re: Projected Cap Space Completed for all 30 Teams 

Post#15 » by Smitty731 » Wed May 25, 2016 12:37 pm

Johnny Bball wrote:Maybe I'm just reading the headings wrong. don't think the raptors are over or under by 9 million.

Salaries are 82.7. Derozan's cap hold increased to 15 from the allstar game I thought, not 9.5, so that's about 88.3. BB has an option and will opt out, so 85.3. I think they still have a cap hold on Nando Decolo to keep his rights (1.8) so 87.1 if they don't renounce it. 92 million projected cap so they have about 5 million in space. Minus salaries of two first round picks, including the 9th pick, they pretty much are dead even prior to resigning DD to a max deal, but that does get them to about 9 over if that's what you mean.


They have 10 guaranteed contracts for a total of ~$69.9 million.

Then the total for the two draft picks is $3.25 million

Then I have them keeping FA rights (meaning not renouncing) all their FAs, including De Colo. Those cap holds total to ~$28 million

Add all those up and that is a total of ~$101 million, which is $9 million above the project cap of $92 million.
Smitty731
Forum Mod - Celtics
Forum Mod - Celtics
Posts: 16,116
And1: 11,806
Joined: Feb 09, 2014
       

Re: Projected Cap Space Completed for all 30 Teams 

Post#16 » by Smitty731 » Wed May 25, 2016 12:38 pm

Wizenheimer wrote:great job!

obviously, there are tons of variables, but it's a very good, one-stop road map that points out why the 'stupid' potential is so high this summer

I have one suggestion and it's very minor: I've only used xcel in spreadsheets before, but it had a feature that allowed you to lock the column headers in place, so as you scroll down the spreadsheet you can readily see what the columns are as the headers are always visible


I'm not sure this works with a google doc, but I'll play around with it. I have it set up that way in the excel dump from my database, but not sure it translates. Unfortunately you lose some functionality when uploading to google docs.
tsherkin
Retired Mod
Retired Mod
Posts: 71,068
And1: 12,916
Joined: Oct 14, 2003
 

Re: Projected Cap Space Completed for all 30 Teams 

Post#17 » by tsherkin » Wed May 25, 2016 12:40 pm

Very nice work, Smitty!
Smitty731
Forum Mod - Celtics
Forum Mod - Celtics
Posts: 16,116
And1: 11,806
Joined: Feb 09, 2014
       

Re: Projected Cap Space Completed for all 30 Teams 

Post#18 » by Smitty731 » Wed May 25, 2016 4:04 pm

tsherkin wrote:Very nice work, Smitty!


Thanks man! I appreciate the kind words!
DeezRaptors
Junior
Posts: 378
And1: 144
Joined: Nov 15, 2015
     

Re: Projected Cap Space Completed for all 30 Teams 

Post#19 » by DeezRaptors » Wed May 25, 2016 9:21 pm

Nice post
Worm122
Junior
Posts: 458
And1: 82
Joined: Jul 04, 2015
 

Re: Projected Cap Space Completed for all 30 Teams 

Post#20 » by Worm122 » Wed May 25, 2016 9:52 pm

Nice hork man, but i do not understand some concepts of the cap space, if you can explain me one i would be grateful, i want to now how much my team can use to pay free agents wich column says that? thanks for yours attention

Return to The General Board