Formula for calculating value of stats - Fantasy Baseball Cafe 2015

## Formula for calculating value of stats

Moderator: Baseball Moderators

### Formula for calculating value of stats

Hola all!

I have been playing with excel trying to make a formula that will rate players based on the projections I have. (5x5 15 team, AVE HR RBI R SB x K W WHIP ERA and SV + CG). its more for the lower level folks.

I've seen a few on here but it was from 2005 and couldn't find an update. Anyone have a formula they care to share to help out? Looking for something that I can plug in their projected HR/SB etc and it gives me a number value of say X that i can compare to others. Thanks all!
pjs1856
Softball Supervisor

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

### Re: Formula for calculating value of stats

You mean this one for 2005? I still use it!

viewtopic.php?t=92352
Element
General Manager

Posts: 4909
(Past Year: 610)
Joined: 25 Feb 2006
Home Cafe: Baseball

### Re: Formula for calculating value of stats

Element wrote:You mean this one for 2005? I still use it!

viewtopic.php?t=92352

Actually no - sorry just looked -t here is another one that has a formula that involves multiplying items together - it didn't account for AB/INN variance though. i'm trying to find the post but lost it and well it was 2005....

Would you still use this for a Roto snake draft? (the one you quoted)? I'm switching from H2H shallow (10 team) to the 15 team roto so i'm trying to figure the best way to account for this.
pjs1856
Softball Supervisor

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

### Re: Formula for calculating value of stats

Just put your projections into lastplayerpicked.com. Since you have SV + CG as a category you'll have to manually create a column for that stat and simply use a header for saves.

If your league requires daily lineup changes and no GP limit then you'll want to add a couple UT spots since people will be cycling in their bench players on off days for their regulars, and probably add another pitching spot or two. You'll find that with the added utility spots, positional scarcity is eliminated for every position except catcher.
Skin Blues
General Manager

Posts: 3082
(Past Year: 109)
Joined: 11 Apr 2010
Home Cafe: Baseball

### Re: Formula for calculating value of stats

pjs1856 wrote:
Element wrote:You mean this one for 2005? I still use it!

viewtopic.php?t=92352

Actually no - sorry just looked -t here is another one that has a formula that involves multiplying items together - it didn't account for AB/INN variance though. i'm trying to find the post but lost it and well it was 2005....

Would you still use this for a Roto snake draft? (the one you quoted)? I'm switching from H2H shallow (10 team) to the 15 team roto so i'm trying to figure the best way to account for this.

the dollar value just create a ranking. so it's universal. I would try skin blue's suggestion first though.
Element
General Manager

Posts: 4909
(Past Year: 610)
Joined: 25 Feb 2006
Home Cafe: Baseball

### Re: Formula for calculating value of stats

Thanks! I will check that out.

I found the formula - its under the Header of "Absolute Values of stats..." anyone have any luck with this or does it not work well enough?

http://www.fantasybaseballcafe.com/forums/viewtopic.php?t=99864
pjs1856
Softball Supervisor

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

### Re: Formula for calculating value of stats

Only problem w/ LPP is that it calculates for auction not for snake...
pjs1856
Softball Supervisor

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

### Re: Formula for calculating value of stats

pjs1856 wrote:Only problem w/ LPP is that it calculates for auction not for snake...

Can you use the auction dollars to create a ranking?

I used to do this but I found that different stats have different costs to acquire. SB's for example are much cheaper for example than HR's even though the math works out to something like 1 SB = 1 HR. So if you followed your rankings you would end up winning SB's by a mile and struggling a lot in HR's/RBI's.
kab21
Hall of Fame Hero

Posts: 5342
(Past Year: 159)
Joined: 24 Nov 2007
Home Cafe: Baseball

### Re: Formula for calculating value of stats

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.
pjs1856
Softball Supervisor

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

### Re: Formula for calculating value of stats

that's not the problem. it's incredibly easy to come up with a formula for that and you include BA (although my method was imperfect). The problem is that you can easily acquire the SB's needed for that category in rds 10-20 at a relatively low cost compared to how much HR's cost.
kab21
Hall of Fame Hero

Posts: 5342
(Past Year: 159)
Joined: 24 Nov 2007
Home Cafe: Baseball

Next