Below is a prototype of the new horse race table which ranks all 30 MLB teams by value of players currently on their roster. Date for below was taken on 5/18. Horse race data seems to move at a glacial pace throughout the season.
The pitchers column which added starters and relief was eliminated for simplicity. The below table is sorted by Total column which is the sum of values for hitters, starters, and relief according to this data model. Only top half of MLB listed. The off WordPress site will list all 30 teams every day some time in the future.
The UR column at the end was added recently to show Unearned Runs above average which is a fielding indicator for an entire team. A team like SEA went through some terrible defense this season and it’s so underwater I’m still wondering if it’s a bug in this model’s data flow. Haven’t found the bug yet.
Still working on a color scheme for this table.
The values are WAA which is mathematically wins – losses. Teams wins – losses are easy to calculate. The math behind this data model calculates it for players with team totals represented above.
Clarification: The UR column is not measured in wins, it’s measured in runs above average. As of 5/20 SEA is at -29 and in order to make sure that wasn’t a bug in a script I manually checked tables at baseball-reference. Let’s cover how simple the UR calculation is using SEA numbers.
UR = League_Average - Unearned_Runs
where Unearned_Runs = Runs_Against - Earned_Runs
Not too complicated. SEA had 292 runs scored against them, 247 were earned making their total Unearned_Runs = 292 – 247 = 45. League_Average for unearned runs right now is 16. Thus UR for SEA = 16 – 45 = -29. Except for taking league averages and looking up each team’s Runs and Earned Runs you could almost do this calculation in your head. UR is a good defensive indicator at a team level. Unearned Runs are not counted against a pitcher but the MLB Commish counts them when determining who wins a game. End of Clarification.
That’s all for now. While thinking about doing Cubs status I had to fix the scripts that make this table so it ended up here today. New Cubs status showing how the above numbers are calculated coming soon. Until then ….