Baseball Formula for Games Back

[chawk]

I have a spreadsheet I have created for our local Youth Baseball
League and I need to know how to write a formula to determine the
number of games back a team is in the standings. Example: The Hornets
record is 5-1 and the Badgers record is 3-4. The answer is 2.5 games
back for the Badgers. If anyone could help me with this I would
greatly appreciate it. Thanks and have a great day.

 

[Vasant Nanavati]

=((5-1)-(3-4))/2

You can substitute cell references for the numbers.

 

[Gord Dibben]

Chris

Column A is team names.

Column B is Wins

Column C is Losses

Select all three columns and sort by Wins(Column B) descending.

In D1 enter =(((B1+C1)-($B$1+$C$1))*0.5)+($B$1-B1)

Note: no error checking if missing data in Columns B or C.

Drag/copy down Column D as far as you have team names.

Gord Dibben Excel MVP

 

[Sue Harsevoort]

As long as the number of games played is the same you can sort by wins, but
if they aren't you should sort by win %, because the team with the most wins
isn't necessarily the team in first place.

Sue

 

[Dave Peterson]

How about magic numbers? Baseball's, not algebras...

(trailing teams wins + remaining games for that team) - leading team's wins + 1

Any combination of leading team's wins + trailing team's losses will result in
the clinch.

Remember this in September for the NL Central champions Chicago Cubs. (Maybe in
August????)

(I hope I didn't offend the Baseball gods!)