After looking at that 30 team table in Part 1 of this series it seemed that sorting based upon the output of this data model will be useful. Last April when we did this 9 of the top 12 teams made the playoffs. Sorting on simple W-L will depress certain teams like Atlanta and others who have improved even though they had a bad run these last three years. Here is the same table as in Part 1 but sorting on Total, as measured by value assigned by this data model, instead of simple win/loss records.
Team Ranking by Total value
| TeamID | W-L | Total | Hitters | Pitchers | Starters | Relief | |
|---|---|---|---|---|---|---|---|
| CHN | 94 | 118.9 | 45.8 | 73.1 | 42.7 | 30.4 | |
| HOU | 90 | 106.1 | 50.5 | 55.7 | 29.3 | 26.3 | |
| BOS | 102 | 103.3 | 65.8 | 37.5 | 25.1 | 12.4 | |
| NYA | 64 | 98.9 | 48.3 | 50.6 | 23.7 | 27.0 | |
| WAS | 62 | 86.4 | 45.0 | 41.4 | 29.0 | 12.5 | |
| COL | 19 | 82.9 | 75.4 | 7.6 | -2.0 | 9.6 | |
| CLE | 89 | 77.0 | 15.7 | 61.3 | 47.0 | 14.3 | |
| LAN | 87 | 73.2 | 33.1 | 40.1 | 18.4 | 21.7 | |
| MIL | 23 | 61.3 | 32.3 | 28.9 | 12.0 | 16.9 | |
| NYN | -18 | 58.9 | 8.4 | 50.5 | 31.5 | 19.0 | |
| SLN | 28 | 56.9 | 38.9 | 18.0 | 3.8 | 14.2 | |
| PHI | -52 | 37.9 | 14.2 | 23.6 | 3.0 | 20.7 | |
| OAK | -4 | 37.8 | 23.5 | 14.3 | -14.1 | 28.4 | |
| MIN | -42 | 36.5 | 39.3 | -2.8 | -3.5 | 0.8 | |
| ATL | -25 | 30.2 | 25.2 | 5.0 | 4.9 | 0.1 | |
| CIN | -80 | 28.5 | 8.3 | 20.2 | 2.2 | 18.0 | |
| SFN | -38 | 27.6 | -5.0 | 32.6 | 13.4 | 19.2 | |
| SDN | -76 | 21.6 | 6.5 | 15.2 | 3.2 | 12.0 | |
| TBA | -10 | 19.1 | 1.6 | 17.5 | 13.1 | 4.3 | |
| PIT | -14 | 15.1 | 0.9 | 14.2 | 5.0 | 9.2 | |
| SEA | 20 | 10.2 | 5.9 | 4.3 | -4.3 | 8.7 | |
| ARI | 2 | 9.8 | -0.5 | 10.3 | 5.8 | 4.5 | |
| ANA | -18 | 9.5 | 11.9 | -2.4 | -7.9 | 5.5 | |
| TEX | -6 | 2.1 | 5.2 | -3.1 | -6.9 | 3.8 | |
| CHA | -72 | -8.1 | -8.3 | 0.1 | -5.0 | 5.1 | |
| TOR | -10 | -17.8 | -10.4 | -7.4 | 0.2 | -7.6 | |
| BAL | -64 | -23.5 | -17.6 | -5.9 | -9.1 | 3.2 | |
| MIA | -46 | -28.8 | -16.9 | -11.8 | -2.6 | -9.3 | |
| KCA | -48 | -29.3 | -25.4 | -3.9 | -0.6 | -3.3 | |
| DET | -57 | -47.2 | -9.1 | -38.1 | -28.9 | -9.2 |
This provides a different perspective on the situation and most likely 8 teams in the top half of this table will make the playoffs. This post could be considered an addendum to Part 1. If we had the web site built you would be able to drill down into each team to see how the sausage is made.
The above does not take into account the potential of new guys or new guys from AAA or AA in waiting to come up mid season and help propel their teams into the playoffs. That is fodder for a different kind of data model. That is all for now. Until then ….