Members: Login | Register | Feedback
 
   
 
LWTS and fielding runs using ZR
Posted: 03 October 2006 01:27 PM   [ Ignore ]

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

Let me know of any errors, too.

Posted: 03 October 2006 02:32 PM   [ Ignore ]   [ # 1 ]
Avatar

Are you using my formulas to calculate the fielding runs?

Posted: 03 October 2006 02:37 PM   [ Ignore ]   [ # 2 ]
Dial Lama - 03 October 2006 02:32 PM

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.

Posted: 03 October 2006 03:00 PM   [ Ignore ]   [ # 3 ]

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.

Posted: 03 October 2006 11:44 PM   [ Ignore ]   [ # 4 ]

my version of excel at home doesn’t have the “PF” function - is this a vb macro/function you wrote?

Posted: 04 October 2006 02:53 AM   [ Ignore ]   [ # 5 ]
Avatar

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?

 Signature 

You’re not qualified to talk about this topic.  Sure, you can say whatever you want, but you’re not qualified.  Please stop pretending you have any idea what you’re talking about.  You’re ####### clueless on this topic.

Posted: 04 October 2006 08:32 AM   [ Ignore ]   [ # 6 ]
Kyle S - 03 October 2006 11:44 PM

my version of excel at home doesn’t have the “PF” function - is this a vb macro/function you wrote?

Yes it is, it’s the park factor.

Posted: 04 October 2006 08:39 AM   [ Ignore ]   [ # 7 ]
Chris Dial - 04 October 2006 02:53 AM

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?

Absolutely.

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.

Posted: 04 October 2006 06:48 PM   [ Ignore ]   [ # 8 ]
Melky has a crush on Philip Hughes - 04 October 2006 08:32 AM
Kyle S - 03 October 2006 11:44 PM

my version of excel at home doesn’t have the “PF” function - is this a vb macro/function you wrote?

Yes it is, it’s the park factor.

do you know why it’s not included in the file i downloaded? or did i just do something wrong?

Posted: 04 October 2006 07:02 PM   [ Ignore ]   [ # 9 ]

never mind, i figured it out.

Posted: 04 October 2006 07:08 PM   [ Ignore ]   [ # 10 ]
Avatar

I wouldn’t even bother with fielding runs above replacement.  For the most part, replacement level hitters are average fielders.

 Signature 

Then Rich Aurilia promptly hit into a double play.

Posted: 04 October 2006 08:22 PM   [ Ignore ]   [ # 11 ]
Avatar

Yes, I have looked ar fielding replacement level, and it’s about average, like Anaheim says.

 Signature 

You’re not qualified to talk about this topic.  Sure, you can say whatever you want, but you’re not qualified.  Please stop pretending you have any idea what you’re talking about.  You’re ####### clueless on this topic.

Posted: 06 October 2006 03:22 AM   [ Ignore ]   [ # 12 ]

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.

Also, what’s the PF for LF in Fenway?

Posted: 06 October 2006 06:20 AM   [ Ignore ]   [ # 13 ]

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.

YouSendIt

Posted: 17 October 2006 06:21 AM   [ Ignore ]   [ # 14 ]

2003-2006 done now:

2006
2005
2004
2003

I’d also like anyone that would be willing to help out grabbing data to set up a fielding database for pre-2002 to either respond in here or email me through BTF.  Thanks.

Posted: 25 October 2006 02:37 AM   [ Ignore ]   [ # 15 ]
Avatar

Kyle,
thanks for the great work.  I really appreciate your ability to get the data.

 Signature 

You’re not qualified to talk about this topic.  Sure, you can say whatever you want, but you’re not qualified.  Please stop pretending you have any idea what you’re talking about.  You’re ####### clueless on this topic.

Posted: 25 October 2006 03:41 AM   [ Ignore ]   [ # 16 ]

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.

Thanks

Posted: 30 October 2006 05:39 PM   [ Ignore ]   [ # 17 ]

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.

Posted: 01 November 2006 05:33 AM   [ Ignore ]   [ # 18 ]

Any year would be okay; I’ve downloaded some of the zone ratings and want to play around with them. I’m also interested in what run factor is used at each position.

Thanks

Posted: 01 November 2006 07:24 AM   [ Ignore ]   [ # 19 ]

2006 - Updated

Posted: 05 October 2009 10:58 AM   [ Ignore ]   [ # 20 ]

Thanks for sharing and uploading it. This is really going to be useful for me. Great job by the way.

Regards,
Marcus
Accessoires téléphones portables

   
 
 
‹‹ EqA vs. wOBA      I solved DIPS. Not joking ››