NBA Rosters and Team Changes: 2013-2014
I have downloaded statistics for all NBA players from basketball-reference.com, and accounted for roster changes (as of Sunday, October 5).
- Click here to download a CSV file with 2013-2014 NBA rosters.
- Click here to download an XLSX file with 2013-2014 NBA rosters.
The Tm2013 column is a three-letter abbreviation for the player’s 2013-2014 team. For players that played on two or more teams, the entry represents the team for which the player played the most minutes. The Tm2014 is the player’s current NBA team (as of Sunday, October 5) according to nba.com. Rookies are not included in this spreadsheet.
If you’ve read my previous two posts, you may have guessed that I am leading up to a prediction of the upcoming 2014-2015 NBA season. You’d be correct – I will post my model and predictions tomorrow.
In the meantime, you can actually use the spreadsheet above to create a very crude prediction. The last column in this spreadsheet is “win shares”. If you create a pivot table based on Tm2014 and Win Shares, you get the sum of player win shares for current rosters – a crude measure of team strength. Here is what that table looks like:
| Team | Sum of WS |
|---|---|
| CLE | 60.7 |
| SAS | 59.4 |
| TOR | 58.6 |
| LAC | 58 |
| IND | 56.6 |
| OKC | 54.1 |
| GSW | 53.8 |
| PHO | 52.6 |
| POR | 50.8 |
| DAL | 48.6 |
| HOU | 47.9 |
| WAS | 46.8 |
| NYK | 44.3 |
| DET | 43.9 |
| MEM | 43.5 |
| MIA | 40.8 |
| CHI | 40.4 |
| ATL | 38.9 |
| DEN | 36.9 |
| MIN | 34.3 |
| SAC | 32.6 |
| CHA | 32.1 |
| NOP | 31 |
| LAL | 26.9 |
| BRK | 26.1 |
| BOS | 25.9 |
| UTA | 23.8 |
| ORL | 23.1 |
| MIL | 21.3 |
| PHI | 7.2 |
I can think of at least five weaknesses in this “pivot table model”. Can you?