## fun with Excel

Moderator: Baseball Moderators

### fun with Excel

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

Posts: 640
(Past Year: -1)
Joined: 17 Feb 2004
Home Cafe: Baseball

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!

edit: hmm. According to your numbers that player is hitting .026, so you might have an issue with your BA calculations, too.
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

Posts: 4342
(Past Year: -9)
Joined: 16 Apr 2004
Home Cafe: Baseball
Location: at Morimoto's, eating \$50 worth of sushi

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

Posts: 2074
(Past Year: -5)
Joined: 2 Jan 2004
Home Cafe: Baseball
Location: Rays Country

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

Posts: 640
(Past Year: -1)
Joined: 17 Feb 2004
Home Cafe: Baseball

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 */
RugbyD
Hall of Fame Hero

Posts: 5589
(Past Year: -2)
Joined: 7 Dec 2004
Home Cafe: Baseball
Location: punting small dogs and being surly

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

Posts: 2074
(Past Year: -5)
Joined: 2 Jan 2004
Home Cafe: Baseball
Location: Rays Country

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

Posts: 13224
(Past Year: -486)
Joined: 20 Apr 2005
Home Cafe: Baseball
Location: Building a metric. And being ignorable and stupid.

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

Posts: 2074
(Past Year: -5)
Joined: 2 Jan 2004
Home Cafe: Baseball
Location: Rays Country

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
Cooner
Major League Manager

Posts: 1024
(Past Year: -4)
Joined: 2 May 2004
Home Cafe: Baseball
Location: my home is in NYC, my heart is in PNC Park