basketball league table

Hi. First, sorry for my poor english. It was very difficult to me to "explain" what i'm trying to do :S

Please patience and if someone can understand a word and have time...

I've attached the xls file. The importants words are translated, the rest is still in spanish but doesn't matter.

Glossary:

P= games played
W=wins
L=losses
PF=points for
PA=points against
Pts=points (given by the tournament punctuation system). 2 points for a win, 1 point for a lost game.

OK, what i need is make an "automatic" league standings. I've done the most of the work (i supose) but i need a way the standings table order by itself automatically while i'm updating the results in the "schedule" sheet.

I thinks that could be "easy" for some advanced users in this excellent forum, buuuuuuuuut i have another problem. There are some rules in the case of a tie in a position. I mean, two teams (A & B) tie in the first place with the same number of points (Pts).

tiebreaker rules:

1- head to head games between tied teams. I mean, team A and B tied in the 1st place, but team A had won the two games vs team B, so team A is 1st. If each team won a game, so...

2- point difference in head to head games. same example, both teams won a game, team A won 80-70 but team B had won 100-50 so team B is 1st.

3- points coefficient (?). A division between points for/againts in the tournament. Example: team A has 700 points for and 650 against, the coefficient is 700/650 = 1.07. (in fact, i dont understand that )

4- MorePoints For in the tournament

5- LessPoints Against in the tournament

What do you think? Too Difficult? Imposible?

Thanks in advice!

Thank you very much my friend.

I'm very grateful to you, ratcat

Thread closed No reaction to mod's request