sample xl program for baseball

July 4, 2011 at 06:13:11
Specs: Windows 7
How do you calculate the following stats using XL.
What if I have a tie how does that change my calculations
Thank you in advance for your help.


Softball Standings

Team Wins Loss Tie % Games .Behind

1. The Shock
2. Heart-Breakers
3. Terminators
4. Mustangs
5. All-Stars

See More: sample xl program for baseball

Report •

July 4, 2011 at 08:55:08
Well, first off, softball games don't usually end in a tie.

Even in recreational leagues where there is a time limit there can be rules to ensure that no game will end in a tie, e.g.

1 - No inning may start after 7 PM
2 - If the game is tied when Rule 1 is in effect, the score will revert to the score at the end of the latest inning when one team was in the lead.
3 - If no inning ended with one team in the lead, the Home team will be awarded a Win.

If you must deal with ties, then one method is to give each team a half a win and half a loss.

These formulas gave me the same values as my newspaper shows for the AL East standings as of July 3, 2011.

Based on the lay out in the table below, enter this in D2 and drag it down:


Enter this in E2 and drag it down:


    A            B     C     D     E
1 Team          Win  Lose    %     GB
2 New York      50    32   .610    -
3 Boston        49    34   .590    1.5
4 Tampa Bay     47    37   .560    4
5 Toronto       41    44   .482   10.5
6 Baltimore     36    45   .444   13.5

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

July 4, 2011 at 12:32:38
Thanks for your help.
Have a nice day.

Report •

Related Solutions

Ask Question