Formula for calculating value of stats - Fantasy Baseball Cafe 2014

## Formula for calculating value of stats

Moderator: Baseball Moderators

### Re: Formula for calculating value of stats

If I'm reading your question right, just use a Z score formula. It's what sites like baseballmonster.com and Ziguana use to compare stats relatively. If you pay for baseballmonster.com you can enter your own projections in I think, but Z score formulas can be done in excel if you have the time and don't want to pay.
Last edited by silentjim on Wed Mar 16, 2011 11:55 am, edited 1 time in total.
silentjim
Major League Manager

Posts: 1290
(Past Year: 76)
Joined: 22 Jul 2005

### Re: Formula for calculating value of stats

Thanks for the site i'll take a look.

And sorry I mis spoke - while I understand its easier to find steals later then it would other cats - i'm trying to just get a formula that would account as best as possible for the variance of value between each category. it may not be doable in excel without spending 2 days on it.
pjs1856
Softball Supervisor

Posts: 40
Joined: 15 Mar 2011
Home Cafe: Baseball

### Re: Formula for calculating value of stats

Here's a good thread on the basketball side that has some baseball links in it as well. It's not as complicated as you think, but it does take some excel know how:

Calculating Values
silentjim
Major League Manager

Posts: 1290
(Past Year: 76)
Joined: 22 Jul 2005

### Re: Formula for calculating value of stats

pjs1856 wrote:That's part of the problem. I'm trying to find something that evens everything out . I know for my league I will need about 270 HR, 1100 R, 185 SB and around 1050 RBi - the problem is coming up with a formula that adds all those into a value. Actually the bigger problem is the %. I figured someone had something they could help with since this seems to be a great site for knowledge.

I'm not really sure what the hard part is. Pick any of the stats as your numerator and then use the 4 stats in the denominator. This will give you 4 ratios that you can use in an equation.

This gives you the following numbers HR - 4, SB - 6, R - 1.05 and RBI - 1

Value = HRx4 + SBx6 + Rx1.05 + RBIx1

Juan Pierre = 560
Albert Pujols = 497

I have gone as far as making an equation for BA (and it works) but I'll have to find the old spreadsheet that I used to remember it. But I haven't spent much time working on this because I find it to be of little value.
kab21
Hall of Fame Hero

Posts: 5336
(Past Year: 168)
Joined: 24 Nov 2007
Home Cafe: Baseball

### Re: Formula for calculating value of stats

silentjim wrote:Here's a good thread on the basketball side that has some baseball links in it as well. It's not as complicated as you think, but it does take some excel know how:

Calculating Values

Thanks all for the look at this! I appreciate the help and I think this log from the bball one will probalby give me what i'm looking for.
pjs1856
Softball Supervisor

Posts: 40
Joined: 15 Mar 2011
Home Cafe: Baseball

### Re: Formula for calculating value of stats

I have used the following hitting formula for 6 years and it seems to work well. I averaged fangraphs, mine & J35J projections this year and I like the results. For hitting categories, take your projections and use this formula.

(BA x 333)+(HR x 3.33)+(RBI)+(RUNS)+(SB x 2.5)

It uses a baseline that every category is 100 points. So 30 HR is 100 pts, and 40 SB is 100pts, etc.
If you use less than 40 for SB, then the rankings come out with too much emphasis on speed.
From the previous example above:
Pujols comes out to be 511

Pierre comes out to be 354
rotoquest
Major League Manager

Posts: 1649
(Past Year: 193)
Joined: 18 Nov 2006
Home Cafe: Baseball

### Re: Formula for calculating value of stats

rotoquest wrote:I have used the following hitting formula for 6 years and it seems to work well. I averaged fangraphs, mine & J35J projections this year and I like the results. For hitting categories, take your projections and use this formula.

(BA x 333)+(HR x 3.33)+(RBI)+(RUNS)+(SB x 2.5)

It uses a baseline that every category is 100 points. So 30 HR is 100 pts, and 40 SB is 100pts, etc.
If you use less than 40 for SB, then the rankings come out with too much emphasis on speed.
From the previous example above:
Pujols comes out to be 511

Pierre comes out to be 354

Thanks! that's almost exactly what i'm looking for. Have a formula for pitching as well?
pjs1856
Softball Supervisor

Posts: 40
Joined: 15 Mar 2011
Home Cafe: Baseball

### Re: Formula for calculating value of stats

TheRock
General Manager

Posts: 3055
(Past Year: 6)
Joined: 16 Apr 2003
Home Cafe: Baseball
Location: America's Heartland

Previous

### Who is online

Users browsing this forum: No registered users and 10 guests

Forums Articles & Tips Sleepers Rankings Leagues

Today's Games
Wednesday, Sep. 3
(All times are EST, weather icons show forecast for game time)

 • Pittsburgh at St. Louis(1:45 pm)
 • San Francisco at Colorado(3:10 pm)
 • Washington at LA Dodgers(3:10 pm)
 • Seattle at Oakland(3:35 pm)
 • Boston at NY Yankees(7:05 pm)
 • Detroit at Cleveland(7:05 pm)
 • Cincinnati at Baltimore(7:05 pm)
 • NY Mets at Miami(7:10 pm)
 • Toronto at Tampa Bay(7:10 pm)
 • Milwaukee at Chi Cubs(8:05 pm)
 • LA Angels at Houston(8:10 pm)
 • Texas at Kansas City(8:10 pm)
 • Chi White Sox at Minnesota(8:10 pm)
 • Arizona at San Diego(10:05 pm)