NBA Salary and Roster Sheets - updated 2/20

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

Smitty731
Forum Mod - Celtics
Forum Mod - Celtics
Posts: 17,632
And1: 14,474
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,650
And1: 2,000
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
Starter
Posts: 2,184
And1: 1,848
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: 5,167
And1: 5,496
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: 17,632
And1: 14,474
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
Starter
Posts: 2,184
And1: 1,848
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: 17,632
And1: 14,474
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: 17,632
And1: 14,474
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,706
And1: 5,000
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: 17,957
And1: 8,977
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,580
And1: 711
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,286
And1: 1,479
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
Lead Assistant
Posts: 4,700
And1: 3,250
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,505
And1: 3,717
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: 17,632
And1: 14,474
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: 17,632
And1: 14,474
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,934
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: 17,632
And1: 14,474
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: 145
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: 485
And1: 84
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