I just finished a worksheet that calculates all LWTS for hitters and pitchers as well as fielding runs using ZR for every player, too. It’s all in one worksheet, includes park factors for pitching and hitting, and calculates wins for each player, too.
There is some stuff I may add later, but it’s stuff you guys can easily do using a simple SUMIF in excel.
If you want it, it will be located here on yousendit: Yousendit
Are you using my formulas to calculate the fielding runs?
I’m using your run values for each position. I’m getting the number of chances each player has had from SI.com. I also include FRAR, and basically use 0.95 X average ZR as a fudge factor comparing how BP seems to have their replacement level on fielding set to average.
I also have FRAA per 150 games and FRAR per 150 games using the average number of chances a player would see if they played that amount.
Oh, I meant to ask you Chris, do you have run values for the average ball in a C’s and P’s zone? It doesn’t make much difference as the numbers are so small, but if you have a more precise number than just the .650 I’m using (figure a bunt hit / inflield single is slightly mroe valuable than a walk plus the value of not getting the out) I’d love to hear it.
No, I don’t have pitchers and catchers run values, but there won’t be any doubles there. Not a percentage points worth anyway.
This is a great database. Can I use it?
After reading Tangotiger’s issue with WARP1, I’d like to get a better idea on replacement level on fielding for each position (batting too I suppose as different positions may have a replacement level closer to average than others). Have you looked into this for fielding before, Chris?
Just going through 2006 fielding stats I defined replacement level as, in the AL, every player save the top 14 in time spent on the field, and in the NL, everyone but the top 16.
A lot of positions seemed to have a replacement level around 98 to 99% of average, which obviously is higher than the 95% I was using.
Anyways, I’ll have a bunch of worksheets with these calculations too, one for each position, which will calculate batting and fielding runs above average, above replacement level (using the same definition on offense as I did on defense), and above an average starter.
What would you suggest for replacement level for DH then? I mean, obviously a below average fielder, at least to a point, is more valuable than someone that just hits. Before I’ve used the average ML hitter, sans pitchers of course, as repalcement level, and I’m pretty sure that’s a higher level than just the typical 80% or so of the average DH.
I updated it using average fielding as replacement level, changed replacement level for DH, added 2006 PF from BR (now all parks that have been around long enough have 4-year park factors) and changed it so pitchers and hitters have separate park factors like on BR. I also deleted pitcher hitting and cleaned up the worksheet so it’s easier to navigate.
The links don’t work any more for the data. I ‘d like to see one of the files. I might be interested in doing something here; I downloaded the SI data, and planned to do something with it after I finished a different project, which is almost done.
I’m trying to standardize all the data so I can set up a database. This will also include more data such as height, weight, DOB, and handedness. dq, let me know which year you’d like and any particular data you need.