SABR 201 - Custom Linear Weights (July 11, 2003)
This is an Excel file that will calculate the Custom Linear Weights values for all events. I have provided a "ReadMe" sheet, which you should follow. It is based on the David Smyth BaseRuns model.
Finally, an easy-to-use (I hope) way to generate custom LWTS values for Pedro Martinez, or a horrible pitcher, or a any team you want. If someone wants to convert this Excel spreadsheet into a Javascript application, feel free. Just attribute David Smyth and Tangotiger. This should help those that don't use Excel.
--posted by TangoTiger at 11:12 AM EDT
Posted 8:22 p.m.,
July 12, 2003
(#1) -
studes
(homepage)
Thanks, Tango. What are the default values in this spreadsheet?
Posted 7:42 a.m.,
July 13, 2003
(#2) -
tangotiger
Actual totals from 1974-1990.
Posted 12:55 p.m.,
July 17, 2003
(#3) -
Mr Universe
If only Griffey would use these Custom Linear Weights(TM), he wouldn't get injured so much.
Posted 1:34 p.m.,
July 17, 2003
(#4) -
Joe C
More good stuff, Tango, thanks. Quick question: were these weights figured by a weighted average of the values of the events in each of the 24 base/out states, or the marginal difference between them (i.e. runner on 1st 1 out, batter walks, that walk is "worth" the difference in RE from a "runner at 1st, 1 out" and a "runners at 1st and 2nd, 1 out" situation)? Hope that question wasn't to unclear. Thanks.
Posted 2:44 p.m.,
July 17, 2003
(#5) -
tangotiger
It might be unclear, because it sounds like the same thing.
If the RE in state1 is .60 and the RE in state2 is .90, and a walk will ALWAYS get you from state1 to state2, then it's value is .30.
To expand, there are 24 states to consider, and therefore, 24 (or more) transitions to consider. Each of the 24 start states will give you a run value for the walk (LWTS by the 24 base-out states). The weighted average of the walk (frequency of each walk by start state) will give you the LWTS value of the walk.
I hope that was clear?!?
Posted 3:51 p.m.,
July 17, 2003
(#6) -
Joe C
Made perfect sense actually. Thanks.