Multiple team "All-Play" Won, loss, tie records
 

Forgive me if this is a beginners question... I did some searching and can't
seem to solve this problem. Any help would be appreciated.

I have 96 teams who play in 8 12-team leagues. I am trying to come up with a
formula for determining a weekly W/L/T percentage as if they were all playing
eachother each week.

e.g.
Team A = 37 points
Team B = 35
Team C = 33
Team D = 33
Team E = 30

Where
Team A's record would be 4-0-0
Team B = 3-1-0
Teams C & D = 1-2-1
Team E = 0-4-0

I have tried using a Rank function, then subtracting out the total games
played, but it doesn't account for ties.
And I currently have separate columns for W, L, & T's.
Any help?

How does a 4-0-0 record equate to 37 points???

--

Vasant


"swig via OfficeKB.com" <u14531@uwe wrote in message
news:554da38951dec@uwe...
Forgive me if this is a beginners question... I did some searching and
can't
seem to solve this problem. Any help would be appreciated.

I have 96 teams who play in 8 12-team leagues. I am trying to come up
with a
formula for determining a weekly W/L/T percentage as if they were all
playing
eachother each week.

e.g.
Team A = 37 points
Team B = 35
Team C = 33
Team D = 33
Team E = 30

Where
Team A's record would be 4-0-0
Team B = 3-1-0
Teams C & D = 1-2-1
Team E = 0-4-0

I have tried using a Rank function, then subtracting out the total games
played, but it doesn't account for ties.
And I currently have separate columns for W, L, & T's.
Any help?

Team A has a record of 4-0-0 because he outscored the other 4 teams. Team B
outscored 3 others, but was outscored by team A, therefore his record for the
week was 3-1-0. This is as if all teams were in 'head to head' matches
against eachother each week. In my situation, each team will have a
potential of 95 wins each week (96 total teams).

Vasant Nanavati wrote:
How does a 4-0-0 record equate to 37 points???

Forgive me if this is a beginners question... I did some searching and
can't
[quoted text clipped - 23 lines]
And I currently have separate columns for W, L, & T's.
Any help?