Formula for calculating value of stats

[pjs1856]

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!

[Element]

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

viewtopic.php?t=92352

[pjs1856]

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.

[Skin Blues]

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.

[Element]

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.

[pjs1856]

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]

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

[kab21]

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.

[pjs1856]

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.

[kab21]

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.