Sharing_MasterRunsPrevented_July1.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
This is a test spreadsheet meant to portray park factor variance in Runs Prevented, as well as DRA Runs Prevented
3
4
Basics on Runs Prevented:
5
Runs Prevented Rankings
6
Exploring Runs Prevented
7
8
Spreadsheet Method:
9
First, CSV data were downloaded from Baseball Reference (2018 MLB Pitching Basic) and Baseball Prospectus (Individual by Team)
10
Data were cleaned by pairing team names to allow for data to be joined between spreadsheets. Baseball Reference park factors and League run environments were added.
11
Runs Prevented figures were calculated against Multi-Year Park Factors (B R), Single Year Factors (B R), Baseball Prospectuis PPF, basic MLB run environment, and DRA.
12
13
Most importantly, the average Runs Prevented and standard deviation Runs Prevented figures were calculated.
14
15
Once these analyses were complete, individual player ranking and team ranking worksheets could be created. These are the worksheets that appear in this spreadsheet.
16
17
Team Analysis Worksheet
18
This worksheet sorts individual players by runs prevented by team, and also summarizes individual runs prevented per team (sorted by Direction). This should not be construed as the same thing as basic, overall team Runs Prevented.
19
Key stats: Standard deviation (Prv_StDv), average runs prevented (Prv_Avg), and DRA runs prevented (DRA_Prv). Comparing DRA and RA can also provide a potential "Direction of Change" metric (Direction)
20
21
Rank
22
This worksheet ranks every MLB player, including the range of variance among Runs Prevented measurements (Low_Prv, High_Prv), as well as a direction of change stat (Direction) and the difference in pace between May 31 Production and July 1 actual production. Sorted by Average Runs Prevented.
23
24
Brewers Worksheet: This is a worksheet that simply includes the Brewers. Sorted by "Difference" between May 31 Pace and July 1 production.
25
26
Reference:
27
Please cite Baseball Prospectus Milwaukee, Baseball Prospectus, and Baseball Reference.
28
Baseball Prospectus. Individual stats - by Team (Pitching) [CSV]. Retrieved July 2, 2018.
29
Baseball Reference. Standard Pitching [CSV]. Retrieved July 2, 2018.
30
Baseball Reference. Park Factors. Retrieved July 2, 2018.
31
32
This spreadsheet was prepared by Nicholas Zettel, Baseball Prospectus Milwaukee.
33
Twitter
[at] bpmilwaukee
34
35
Please consider a membership to Baseball Prospectus and ad-free browsing at Baseball Reference to support the work of these websites.
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Directions
Brewers
Rank
TeamAnalysis
 
 
Main menu