Here are ratings based on all games weighted equally.
| Team | Off | Def | Overall |
| Boston Celtics | -0.37 | -7.33 | 6.96 |
| San Antonio Spurs | 3.98 | -2.89 | 6.87 |
| Los Angeles Lakers | 3.25 | -3.07 | 6.31 |
| Miami Heat | 1.92 | -4.07 | 5.99 |
| Orlando Magic | 1.36 | -4.26 | 5.63 |
| Chicago Bulls | -3.08 | -7.55 | 4.48 |
| Dallas Mavericks | -1.85 | -5.07 | 3.22 |
| New Orleans Hornets | -4.63 | -7.51 | 2.87 |
| Portland Trail Blazers | -3.01 | -5.81 | 2.79 |
| Denver Nuggets | 7.05 | 4.76 | 2.30 |
| Oklahoma City Thunder | 5.08 | 2.82 | 2.26 |
| New York Knickerbockers | 8.30 | 6.91 | 1.39 |
| Memphis Grizzlies | 0.19 | -0.85 | 1.03 |
| Utah Jazz | 1.19 | 0.19 | 1.00 |
| Atlanta Hawks | -2.60 | -2.95 | 0.34 |
| Houston Rockets | 4.68 | 4.55 | 0.13 |
| Milwaukee Bucks | -6.44 | -5.99 | -0.45 |
| Philadelphia 76ers | -0.72 | -0.16 | -0.56 |
| Phoenix Suns | 6.87 | 8.13 | -1.27 |
| Indiana Pacers | -1.72 | 0.19 | -1.91 |
| Golden State Warriors | 4.22 | 6.57 | -2.35 |
| Los Angeles Clippers | -0.25 | 2.14 | -2.39 |
| Charlotte Bobcats | -6.43 | -3.43 | -3.01 |
| Detroit Pistons | -3.61 | 0.13 | -3.74 |
| Minnesota Timberwolves | 4.07 | 9.13 | -5.06 |
| New Jersey Nets | -6.20 | -0.93 | -5.27 |
| Toronto Raptors | 1.05 | 6.54 | -5.49 |
| Sacramento Kings | -3.07 | 2.74 | -5.81 |
| Washington Wizards | -3.61 | 2.32 | -5.93 |
| Cleveland Cavaliers | -5.64 | 4.73 | -10.37 |
Here are ratings with more weight given to more recent games.
| Rank | Team | Off | Def | Overall |
| 1 | Boston Celtics | -0.82 | -7.50 | 6.68 |
| 2 | San Antonio Spurs | 3.18 | -3.31 | 6.49 |
| 3 | Los Angeles Lakers | 2.88 | -3.30 | 6.19 |
| 4 | Orlando Magic | 2.18 | -3.98 | 6.17 |
| 5 | Miami Heat | 2.01 | -3.25 | 5.26 |
| 6 | Chicago Bulls | -3.16 | -7.97 | 4.81 |
| 7 | New Orleans Hornets | -4.82 | -8.26 | 3.44 |
| 8 | Oklahoma City Thunder | 5.18 | 2.41 | 2.78 |
| 9 | Portland Trail Blazers | -2.96 | -5.65 | 2.69 |
| 10 | Denver Nuggets | 7.30 | 5.02 | 2.28 |
| 11 | New York Knickerbockers | 8.04 | 6.09 | 1.95 |
| 12 | Dallas Mavericks | -2.82 | -4.48 | 1.66 |
| 13 | Memphis Grizzlies | 0.46 | -0.96 | 1.42 |
| 14 | Atlanta Hawks | -2.54 | -2.98 | 0.45 |
| 15 | Utah Jazz | 1.17 | 0.76 | 0.41 |
| 16 | Houston Rockets | 4.85 | 4.69 | 0.16 |
| 17 | Philadelphia 76ers | -0.27 | -0.14 | -0.13 |
| 18 | Milwaukee Bucks | -6.48 | -5.99 | -0.49 |
| 19 | Golden State Warriors | 5.10 | 7.02 | -1.92 |
| 20 | Indiana Pacers | -1.66 | 0.35 | -2.01 |
| 21 | Los Angeles Clippers | 0.18 | 2.35 | -2.17 |
| 22 | Phoenix Suns | 5.87 | 8.16 | -2.29 |
| 23 | Charlotte Bobcats | -6.49 | -3.30 | -3.19 |
| 24 | Detroit Pistons | -3.87 | -0.06 | -3.81 |
| 25 | Minnesota Timberwolves | 4.49 | 8.70 | -4.21 |
| 26 | Sacramento Kings | -2.49 | 2.35 | -4.84 |
| 27 | New Jersey Nets | -6.16 | -1.10 | -5.06 |
| 28 | Toronto Raptors | 1.16 | 6.92 | -5.76 |
| 29 | Washington Wizards | -3.90 | 2.36 | -6.26 |
| 30 | Cleveland Cavaliers | -5.63 | 5.07 | -10.70 |
How do you go about accumulating the data and calculating these ratings?
I’m less interested in your formula (actually I am but that’s not what I’m getting to here) as I am whether the data is entered manually into a spreadsheet or database, imported somehow, your source of data, software used etc…
I would like to build something for personal use next season where I can calculate daily ratings, look at the moving average of the rating, note injuries, etc… for personal analysis but it would be a very labor intensive task without a good source for importing much of the information.
Thanks
Comment by Italian Stallion — January 23, 2011 @ 5:33 pm
[...] Raptors continue to slide towards the bottom of the league in Wayne Winston’s NBA Ratings… but at least they don’t have any players on this list of the NBA’s worst [...]
Pingback by Lunchbox Links – Toronto Update — January 25, 2011 @ 1:23 pm
Use Excel web queries from say pro football reference.com and each week the data will come into Excel automaticallu. These are explained in many books iucluding mu Data Analysis and Business Modeling books
Comment by wwinston — January 25, 2011 @ 1:34 pm
Wayne,
I have come accross alot of artcles on the “DanVAL” +- ranking system. It appears to be a slight modification of your Winval syetem. Any opinions on Danval system?
Comment by JOHN — January 25, 2011 @ 5:32 pm
Thanks. I’ll pick up the books.
Comment by Italian Stallion — January 25, 2011 @ 5:37 pm
Wayne,
I know I am going way past the limit here, but if you are bored and care to respond I would appreciate the help until I pick up one of your books. I did some investigation on the web.
I was able to import the table of scores for Knicks games here:
http://www.basketball-reference.com/teams/NYK/2011_games.html
Now I have a nice “Knicks” spreadsheet to which I can add notes on game injuries, your rating for the Knicks and their opponent on the night of each game, and anything else I deem relevant for a specific game.
The potential problem I see is that when I update it weekly I suspect it will simply overlay any incremental information I added. That would be a problem.
Also, I assume I will have to do this import manually for each team weekly or is there a way to automate the update for all 30 teams after an initial setup?
Wayne
Comment by Italian Stallion — January 25, 2011 @ 7:03 pm
Under league they have each game listed. when you refresh web query it puts in the new games. Just make your notes where it does not intersect the results of the query.
Comment by wwinston — January 25, 2011 @ 7:56 pm
italian - if you want a good stat data base that makes it easy to transfer to excel try http://www.dougstats.com/.. there is a section on the site that tells you how to load to excel .
Comment by JOHN — January 25, 2011 @ 10:53 pm
Thanks guys.
I’ll try multiple approaches and see what works best.
I really appreciate the time and help.
Wayne
Comment by Italian Stallion — January 25, 2011 @ 11:59 pm
Wayne
I still have to do these updates for each of the 30 teams daily/weekly correct?
I don’t see a single page where every game is listed. Each game is listed by team.
Wayne
Comment by Italian Stallion — January 26, 2011 @ 12:10 am
Here it is http://www.basketball-reference.com/leagues/NBA_2011_games.html
Comment by wwinston — January 26, 2011 @ 8:03 am
Thanks. Great site
Comment by wwinston — January 26, 2011 @ 8:04 am
Wayne,
I may have to buy two of your books just to make up for all the help you’ve given me. Your generosity is very appreciated.
Wayne
Comment by Italian Stallion — January 26, 2011 @ 4:56 pm
Buy Mathletics. The data in that book is highly respected and sought after from the NBA offices all the way to the sports books of Vegas. My copy has so many notes and folded pages that I will be buying a new by summer.
Comment by JOHN — January 26, 2011 @ 10:47 pm
WAYNE,
I found that Bosch makes the Heat about 8.5 pts better on the court. Does this appear accurate given your data?
Thanks for you help.
Comment by JOHN — January 27, 2011 @ 11:03 am
Teams with an +0.5 or better improvement in the heavier weight to recent games list compared to equal weighted:
Sacramento Kings (almost +1)
Minnesota Timberwolves
New Orleans Hornets
New York Knickerbockers
Orlando Magic
Oklahoma City Thunder
Teams with an -0.5 or greater loss in the heavier weight to recent games list compared to equal weighted:
Utah Jazz
Miami Heat
Phoenix Suns
Dallas Mavericks (almost -1.6)
Comment by Crow — January 30, 2011 @ 6:29 pm