Help a foreigner! - Fantasy Baseball Cafe 2014

## Help a foreigner!

Moderator: Baseball Moderators

xeifrank wrote:You need to convert ratio categories like WHIP, ERA and Average into counting stats like Runs, HRs, Wins etc... are.

Yes! You and the others are correct and that has been my biggest problem: how to assign a value above and below league average: i.e.
1) HOW do i recognise above and below what level a player is making a contribution to a Yahoo category ratio stat (eg, ERA, AVG, OPS)
2) HOW do I convert that into a rankable quantity i can then use in excel

xeifrank wrote: To convert average to a counting stat, use the following formula:

Counting Stat = Hits - (AB * .280)

There is a similiar formula for ERA and WHIP and any other ratio category.

Now this is the missing link! I was tinkering by multiplying the player's AVG by his AB was was unhappy with that.

Now I need to find the same formula for the others.
Would the following be correct?

ERA is, following your example above,
9*ER-(IP*ERAAVG) where ERAAVG is the avg ERA for the pitchers that can be drafted

WHIP:
(W+H)-(IP*WHIPAVG)

k/9
K*IP-(9*K9AVG)

OBP:
(H+BB)-((AB+BB)*OBPAVG) (yes, i know that i need to take into account HBB and Sacflys but this approx should be sufficient)

SLG:
TB-(AB*SLGAVG).

PS

I saw your piece of software and i found it very interesting. The only thing that would prevent me from throwing out my excel attempts and using your software is that i cannot choose the scoring categories (some, especially these famous ratios, are missing) except one by one.

vr,

Xeifrank

[/quote]
Coppernob
College Coach

Posts: 129
(Past Year: 3)
Joined: 26 Feb 2004
Home Cafe: Baseball
Location: San Francisco

Previous

### Who is online

Users browsing this forum: joiingds and 6 guests

Forums Articles & Tips Sleepers Rankings Leagues

Today's Games
Sunday, Aug. 31
(All times are EST, weather icons show forecast for game time)

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