fun with Excel - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

fun with Excel

Moderator: Baseball Moderators

fun with Excel

Postby reiser » Sun Feb 05, 2006 12:36 pm

hey gurus! what's the formula for WHIP and ERA?
also-is there a way to clean up BA? it is displaying as 0.02858?
reiser
Minor League Mentor
Minor League Mentor

User avatar

Posts: 641
Joined: 17 Feb 2004
Home Cafe: Baseball

Postby George_Foreman » Sun Feb 05, 2006 12:50 pm

Walks + Hits/Innings Pitched = WHIP
Earned Runs/IP*9 = ERA

As for BA, select the BA row or column (you can click the "A" or "1" on the outside of the sheet to select a row or column), select Format --> Cells (also ctrl + F1). Select the "number" tab, choose "number" and it'll give you an option to limitt he decimal places. You'll probably want to limit it to 3. You can also format cells to look other ways with this menu, so feel free to play around wtih it.

Hope this helps! ;-D

edit: hmm. According to your numbers that player is hitting .026, so you might have an issue with your BA calculations, too.
"I don't buy everything I read,
I havn't even read everything I've bought"

"I find it more comforting to believe that this [life] isn't simply a test."
George_Foreman
General Manager
General Manager

User avatar

Posts: 4351
Joined: 16 Apr 2004
Home Cafe: Baseball
Location: at Morimoto's, eating $50 worth of sushi

Postby Grouperman941 » Sun Feb 05, 2006 1:10 pm

On that ERA formula, watch your order of operations.

It's 9(ER/IP) or (9*ER)/IP ; NOT ER/(IP*9)

Test your formula with ones: 1 ER in 1 IP should = ERA 9.00
Be excellent to each other.
Grouperman941
Major League Manager
Major League Manager

User avatar
Cafeholic
Posts: 2079
Joined: 2 Jan 2004
Home Cafe: Baseball
Location: Rays Country

Postby reiser » Sun Feb 05, 2006 1:27 pm

Grouperman941 wrote:On that ERA formula, watch your order of operations.

It's 9(ER/IP) or (9*ER)/IP ; NOT ER/(IP*9)

Test your formula with ones: 1 ER in 1 IP should = ERA 9.00


hmm...it doesn't look like it makes a difference where I multiply.
reiser
Minor League Mentor
Minor League Mentor

User avatar

Posts: 641
Joined: 17 Feb 2004
Home Cafe: Baseball

Postby RugbyD » Sun Feb 05, 2006 1:39 pm

reiser wrote:
Grouperman941 wrote:On that ERA formula, watch your order of operations.

It's 9(ER/IP) or (9*ER)/IP ; NOT ER/(IP*9)

Test your formula with ones: 1 ER in 1 IP should = ERA 9.00


hmm...it doesn't look like it makes a difference where I multiply.

yeah, it won't. order of operations doesn't matter for an equation thats all +- or */
TennCare rocks!!!!
RugbyD
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe Ranker
Posts: 5591
Joined: 7 Dec 2004
Home Cafe: Baseball
Location: punting small dogs and being surly

Postby Grouperman941 » Mon Feb 06, 2006 10:29 am

RugbyD wrote:
reiser wrote:
Grouperman941 wrote:On that ERA formula, watch your order of operations.

It's 9(ER/IP) or (9*ER)/IP ; NOT ER/(IP*9)

Test your formula with ones: 1 ER in 1 IP should = ERA 9.00


hmm...it doesn't look like it makes a difference where I multiply.

yeah, it won't. order of operations doesn't matter for an equation thats all +- or */


The original equation was ambiguous. If it says ER/IP*9, that could mean to multiply the denominator by 9 before dividing, which is wrong.
Be excellent to each other.
Grouperman941
Major League Manager
Major League Manager

User avatar
Cafeholic
Posts: 2079
Joined: 2 Jan 2004
Home Cafe: Baseball
Location: Rays Country

Postby Big Pimpin » Mon Feb 06, 2006 10:51 am

Grouperman941 wrote:
RugbyD wrote:
reiser wrote:
Grouperman941 wrote:On that ERA formula, watch your order of operations.

It's 9(ER/IP) or (9*ER)/IP ; NOT ER/(IP*9)

Test your formula with ones: 1 ER in 1 IP should = ERA 9.00


hmm...it doesn't look like it makes a difference where I multiply.

yeah, it won't. order of operations doesn't matter for an equation thats all +- or */


The original equation was ambiguous. If it says ER/IP*9, that could mean to multiply the denominator by 9 before dividing, which is wrong.


It only means that if the IP*9 is in parentheses.
Big Pimpin
Mod in Retirement
Mod in Retirement

User avatar
EditorCafeholicFantasy ExpertCafe WriterCafe RankerGraphics ExpertMock(ing) DrafterEagle EyeWeb SupporterMatchup Meltdown ChampionPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 13710
(Past Year: 4)
Joined: 20 Apr 2005
Home Cafe: Baseball
Location: Building a metric. And being ignorable and stupid.

Postby Grouperman941 » Mon Feb 06, 2006 10:58 am

When I learned the notation, it was explained to me that you should always use parentheses to clarify exactly what you are looking for.

I don't believe I got 3 posts out of this. :-)

I guess when you plug it into Excel it doesn't really matter.
Be excellent to each other.
Grouperman941
Major League Manager
Major League Manager

User avatar
Cafeholic
Posts: 2079
Joined: 2 Jan 2004
Home Cafe: Baseball
Location: Rays Country

Postby Cooner » Mon Feb 06, 2006 4:07 pm

Grouperman941 wrote:When I learned the notation, it was explained to me that you should always use parentheses to clarify exactly what you are looking for.

I don't believe I got 3 posts out of this. :-)

I guess when you plug it into Excel it doesn't really matter.


plug it into a calculator, computer, or excel, and it simply won't care. For instance-

2*3*4*5

implies

(((2*3)*4)*5)

But in text posts where it's not always clear, a little parenthesis goes a long way :D
Cooner
Major League Manager
Major League Manager

User avatar

Posts: 1028
Joined: 2 May 2004
Home Cafe: Baseball
Location: my home is in NYC, my heart is in PNC Park


Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 12 guests

Forums Articles & Tips Sleepers Rankings Leagues


  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact