I figure there must be, so I'm trying to come up with something, but it's a process. And it's nowhere near done, but I may as well show what I have to get feedback, or at least to put it out there in case someone else has use for it in its current form.
Pardon the lack of polish, it was created solely in Excel (turned to PNG in Illustrator):
What I want to do is to give a nice graphical review of what happened on the field, coupled with the run expectancy for each part. Each base-out state at the start of the at-bat is shown by the graphic. Red is no outs, yellow one out, blue two outs. To the left of each base graphic is a white dot showing the expected runs (0 to 3) before the at-bat, and to the right is the expected runs (0 to 3) after the at-bat. If the at-bat ended the inning, the dot is black (at zero). Each player's contribution is the gap between the left and the right.
But there's still a lot of stuff missing:
- Color coding the base-out states is ugly. I want to change the background color to correspond to the number of outs (white for 0, light grey for 1, grey for 2, and black for 3 outs)
- I need to show when a player scored runs in his at-bats. For instance, the 3-run HR by Sardinha in the 4th inning makes it look like he dropped the run expectancy (1st and 2nd with 2 outs to bases empty 2 outs). In reality he scored 3 runs minus that drop in expectancy
- I need to figure out a better way of dealing with stolen bases. There is one in the 9th, but there's no way of knowing that it happened, or who did it. That's going to be a challenge (stupid non-discrete events in an otherwise discrete game!)
If anyone has any input, please let me know. And if there are any Excel geniuses out there who know how I can use a custom marker for XY charts with a transparent background (transparent turns black when you add it to the chart), I'd be eternally grateful.
- Game Log from Fangraphs