So, basically, I totally screwed up before, by weighing the individual ORtg by minutes played, instead of possessions used. Stupid, I know. So let's try that, and cross our fingers for better results!
The T-Wolves, yeah, I know, had 7323.49 possessions in 2003-04 (According to Oliver's formula). Assuming they didn't change their pace depending on the players on the court, that would mean that a player's total possessions will equal his USG%*MP/(Team MP/5).
Some Excel wizardry later, and the KG-less T-Wolves will have an ORtg of 104.75, and a DRtg of 101.42. Considering pace, that's a scoring margin of 2.96 per 48 minutes, as opposed to the T-Wolves normal, calculated, 5.896. So that's + 2.93. As to the calculations, here they are:
First, all the players, and their Minutes Played, USG%, ORtg, DRtg and Possessions (Since I don't have Oliver's book, I'll use the rounded USG% for each player, and multiply it by his MP divided by the team's MP divided by 5). The total team possessions came out as 7323.48893 using Oliver's formula, while the actual sum of all player possessions was 7293.88, a discrepancy that is related to the rounding of the numbers at each step. I re-calculated pace using the total team possessions I came up with, just to make sure there are less rounding errors, and came up with 88.9717714 (as opposed to 89.0, big deal, right?).
Code: Select all
Player MP USG% Ortg Drtg Possessions
Garnett 3231 29.6 112 92 1772.718059
Cassell 2838 27.2 113 102 1430.844028
Hoiberg 1804 12.5 121 100 417.9819678
Sprewell 3100 23.6 100 103 1356.078083
Hassell 2264 9.5 107 103 398.6676791
Madsen 1246 11.5 106 101 265.5992735
Trent 1025 19.4 103 102 368.5840989
Johnson 965 7.1 107 97 126.9979358
Szczerbiak 622 22.1 107 103 254.7966175
Miller 506 13.3 103 96 124.7421307
Olowokandi 925 18.6 90 96 318.9081932
Hudson 503 23.9 98 106 222.8316551
McLeod 391 15.7 89 102 113.7856277
Goldwire 66 11.7 105 101 14.31333373
Martin 172 21.4 89 107 68.22652004
Ebi 32 27.6 81 102 16.37080594
Lewis 65 16.7 77 101 20.12059539
Team 19755 105.9 99.7 7323.488934
Next, I calculated points produced, by multiplying the player possessions with their ORtg, just to verify everything(points produced != points scored). The next column is Poss*ORtg, with the last entry, for team, being the weighed average of ORtg, that came out as 106.5, higher than the team's actual 105.7, which would suggest that, at least that season, the T-Wolves were worse than the sum of their parts.
Code: Select all
Player Points Produced
Garnett 1985.444227 198544.4227
Cassell 1616.853751 161685.3751
Hoiberg 505.758181 50575.8181
Sprewell 1356.078083 135607.8083
Hassell 426.5744166 42657.44166
Madsen 281.5352299 28153.52299
Trent 379.6416218 37964.16218
Johnson 135.8877913 13588.77913
Szczerbiak 272.6323808 27263.23808
Miller 128.4843946 12848.43946
Olowokandi 287.0173738 28701.73738
Hudson 218.375022 21837.5022
McLeod 101.2692087 10126.92087
Goldwire 15.02900041 1502.900041
Martin 60.72160284 6072.160284
Ebi 13.26035281 1326.035281
Lewis 15.49285845 1549.285845
Team 7800.055496 106.5073705
And now to calculate the team D&ORtg without each player. There are probably better ways to do this, but none that came to mind for me, so I just did a weighed average for everyone except the player in question each time, weighed by possessions for ORtg and minutes for DRtg, and here are the results:
Code: Select all
Player Team Ortg without Team DRtg without
Garnett 104.7532208 101.422779
Cassell 104.9308391 99.52627534
Hoiberg 105.6301492 99.86975656
Sprewell 107.986153 99.30123086
Hassell 106.4790095 99.47801727
Madsen 106.5264637 99.80636447
Trent 106.6932481 99.76572344
Johnson 106.498677 100.0296434
Szczerbiak 106.4896133 99.78027492
Miller 106.5681474 99.98368746
Olowokandi 107.2589267 100.0723314
Hudson 106.7743474 99.72179514
McLeod 106.7836769 99.83887627
Goldwire 106.5103224 99.87790137
Martin 106.6720051 99.81912884
Ebi 106.564517 99.87821325
Lewis 106.5886626 99.87795835
Now, using the same method as before to calculate the team's scoring difference, without each player, i.e. (Team ORtg-Team Drtg)*Pace/100, we get the following results for each player -
Code: Select all
Player TPM RPM
Garnett 2.963153051 297252 2.933738038
Cassell 4.80853609 289476 1.088354998
Hoiberg 5.12512341 180400 0.771767679
Sprewell 7.727129081 319300 -1.830237993
Hassell 6.228906766 233192 -0.332015678
Madsen 5.978991302 125846 -0.082100214
Trent 6.16354144 104550 -0.266650352
Johnson 5.755613769 93605 0.141277319
Szczerbiak 5.969417226 64066 -0.072526138
Miller 5.858310598 48576 0.03858049
Olowokandi 6.394041143 88800 -0.497150054
Hudson 6.274780711 53318 -0.377889622
McLeod 6.178912178 39882 -0.28202109
Goldwire 5.90098246 6666 -0.004091372
Martin 6.097125408 18404 -0.200234319
Ebi 5.948922918 3264 -0.05203183
Lewis 5.970632441 6565 -0.073741353
Team 5.896891088 99.88165022
Now, the first column is the players' names (

), followed by the TPM - Team's +/- when removing that player, while the last entry is the team's regular, calculated +/-, then a column of the player's DRtg, multiplied by his MP, to recalculate the team's DRtg, the last entry in that column, and finally, for each player, the team's regular +/- minus his own TPM, or as I like to call it - RPM: Rating Plus Minus (if it actually sticks, that will change to RK's RPM

).
What we see, first of all, is that the results aren't as far apart as they are for APM and SPM, with just ~3.5 separating Garnett from the team's "worst" player, Sprewell, but that's mainly because the "On Court" +/- is basically the team's +/-, and, especially for the low minutes players, the "Off Court" +/- isn't really affected by them.. Other than that, KG's the biggest contributor, and only he, Cassell, Fred Hoiberg, Ervin Johnson and Oliver Miller were positive contributors, with the rest holding them back some.
It still might be interesting to compare the results for different players, across the same season or through the times, so in the next post I'll show some of the results.
EDIT: Since doing the T-Wolves' RPMs, I also separated those numbers to Offensive and Defensive RPM (should have from the start...), so here they are:
Code: Select all
Player ORPM DRPM
Garnett 1.560698121 1.371169569
Cassell 1.402667969 -0.316183318
Hoiberg 0.780479327 -0.010581996
Sprewell -1.31569896 -0.51640938
Hassell 0.02523336 -0.359119385
Madsen -0.016987501 -0.06698306
Trent -0.165378592 -0.103142107
Johnson 0.007734789 0.131672182
Szczerbiak 0.015798913 -0.090195398
Miller -0.054074205 0.090784348
Olowokandi -0.668672817 0.169652416
Hudson -0.237534076 -0.142225894
McLeod -0.245834696 -0.038056741
Goldwire -0.002626302 -0.003335417
Martin -0.146478288 -0.055626378
Ebi -0.050844252 -0.003057926
Lewis -0.072326987 -0.003284714