fun with Excel

[reiser]

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?

[George_Foreman]

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.

[Grouperman941]

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

[reiser]

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.

[RugbyD]

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 */

[Grouperman941]

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.

[Big Pimpin]

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.

[Grouperman941]

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.

[Cooner]

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