Excel Replay tips: tracking thirds of innings

Scott Fennessy had a question about Excel…

Hi Tom,
Since you seem to be in a mood to show off your excel skills lately I have a simple challenge for you.  In my personal stat sheets I use decimal points for my innings pitched counts.  (i.e. 1.2, 4.1, etc.)  What I recently noticed that my team inning totals, instead of going from .1 to .2 and .3 rounding up to 1 goes from .1 to .9 before rounding up. 

What do I need to fix in my sum equation?
Scott

Okay, this is how I handle it.

If there is a stat column that involves innings, I highlight the cells which data is entered and right click then “Format Cells”.

See the image above to see how I did this.

This will bring up a formatting window for Excel cells. By default, the Number tab is selected at the top. If not, select it.

Then you can choose “Fraction” then “Up to one digit (1/4)“.

Then all I need to do enter in decimal formats for thirds of an inning.

I usually enter in .333 for one third of an inning and .666 for two thirds of an inning. As soon as I hit enter, it immediately changes to the fraction format.

So far, it has worked fine for me. Even Team totals are resolving themselves to one thirds of an inning.

I hope that helps, Scott!

Thomas Nelshoppen

I am an IT consultant by day and an APBA media mogul by night. My passions are baseball (specifically Illini baseball), photography and of course, APBA. I have been fortunate to be part of the basic game Illowa APBA League since 1980 as well as a frequent participant of the Chicagoland APBA Tournament. I am slogging through a 1966 NL replay and hope to finish before I die.

2 Comments:

  1. What I usually do is let Excel do the work.
    For example, instead of engaging in odd summing, I express 54 1/3 innings as

    =54+1/3

    Then Excel assigns it the 54 1/3 value and things add up just fine.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.