Baseball Formula for Games Back

  • Thread starter Thread starter chawk
  • Start date Start date
C

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.
 
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
 
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
 
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!)
 
Back
Top