There are two types of spreadsheets you can find on this site:
Player Salary Spreadsheets show the assumed figures for individual players. There is a spreadsheet showing all players in the NBA, sorted by team (click on the button to the left to see this spreadsheet) as well as spreadsheets showing only players for a specific team (click on the team name to the right to see these spreadsheets). Archived spreadsheets for previous years are also available.
Team Salary Spreadsheets show the assumed cap position for all the teams in the NBA, including total player salaries as well as exceptions that count against the cap. The current spreadsheet can be accessed by clicking on the button to the left. Archived spreadsheets for previous years are also available.
Things you should keep in mind as you look at the spreadsheets on this site:
Player Salary Spreadsheets
1) Numbers with a Peach background are there to indicate that there is either a Player Option or an Early Termination Option in his contract for that year. I don’t differentiate between Player Options and Early Termination Options on my spreadsheets – there is a difference between the two in the real world, but not enough to warrant a visual distinction on these spreadsheets. If you look in the “Notes” column for that player, I do try to note whether the player actually has a Player Option or an ETO. You can read more about these types of options here.
2) Numbers with a Gray background are there to indicate that there is a Team Option in his contract for that year. You can read more about Team Options here.
3) Numbers with a Green background are there to indicate that the player is an unsigned 1st round pick. The numbers shown are his rookie scale numbers, although his actual contract might be up to 20% higher or lower than these numbers, depending on what he and the team agree to. You can read more about 1st round draft picks here.
4) Numbers with an Orange background are there to indicate when a player’s salary is either partially guaranteed or not guaranteed at all. Consult the “Notes” column for that player for details. You can read more about guaranteed contracts here.
5) Numbers with a Red background are there to indicate when an unrenounced free agent counts against the cap. These players are not actually earning any salary. You can read more about this type of cap hold here.
6) Numbers with a Yellow background are there to indicate when a Qualifying Offer has either been made or could be made at some point in the future. If you see a yellow background behind a number for a future season (at the very bottom of the team’s page) it means that the team will have the choice to make a Qualifying Offer in that amount before that future season begins. If you see a yellow background behind a number in the current year it means that the team has made a Qualifying Offer to the player in that amount and that he is a Restricted Free Agent. Qualifying Offer amounts are not included in the totals at the bottom of each yearly column, however, Restricted Free Agents will also have a number with a Red background in the “Cap Hold” column that is included in the totals. Restricted free agents who have received offer sheets from another team are listed twice – under the “new team” as a roster player and under their “previous team” as a free agent. Once the “previous team” has either matched the offer or refused to match the offer, the player will once again only appear in one team’s list. You can read more about Qualifying Offers here.
7) Numbers with a Lavender background are there to indicate that the player is considered a Base Year Compensation player if he is traded during that season. You can read more about Base Year Compensation here.
8) Numbers with an Aqua background are there to indicate when the league pays for a portion of the player’s salary. The number in the “Cap Hit” column shows how much the team pays after the reimbursement by the league has been made, while the number in the column labeled by a particular year shows how much money was actually earned by the player. You can read more about this reimbursement here.
9) The “Cap Hit” column refers to what amount actually counts against the salary cap. The other columns show how much salary is earned by the player in that particular year – however due to bonuses, deferred payments, etc., this might not actually be how much money the player is actually paid during the year.
10) The subtotals/totals of the “Cap Hit” column include non-guaranteed amounts of current roster players, as those amounts count against the cap. The subtotals/totals of columns for specific seasons include all options, but do not include any amounts that are not guaranteed. On the individual team pages, I have also included a line below the total that subtracts any option amounts out of the total.
11) Players with their name in parentheses are not on the active roster for that team (because they have been waived or have retired or have become free agents or ??????). On the individual team pages, the subtotals for roster players and non-roster players are calculated separately.
12) Players are sorted by their numbers in the current year column, then by their numbers in the “Cap Hit” column. Unsigned 1st round draft picks are always listed at the bottom of each team’s list.
13) The “Signed Using” column tells, to the best of my knowledge, whether the player was signed using cap space or using an exception.
14) The “Total Guaranteed” column gives the sum of guaranteed money left on the player’s contract, including the current season. This amount does not include future Player Options or Team Options, but it does include salary following an Early Termination Option that has not yet been exercised. This column also includes any signing bonus amounts or trade bonus amounts that have already been paid but still count against the current season’s cap or a future season’s cap. Finally, this column also includes incentives that are currently considered likely.
15) The number underneath each team total – showing how much above or below the cap each team is – does not take into account any exceptions that might count against the cap. This number only takes into account player salary in the “Cap Hit” column. For a more complete picture of team salary, consult the current team salary spreadsheet.
Team Salary Spreadsheets
1) The MLE and BAE begin to reduce in value starting on January 10th of each season. The spreadsheet reflects this reduction.
2) Exceptions are only for teams over the salary cap (thus their name of ‘exceptions’). If a team is under the salary cap, they lose any exceptions that they might have earned up until that point.