Results 1 to 4 of 4

basketball league table

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2008
    Location
    argentina
    Posts
    2

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. update league table
    By stevesunfold in forum Excel General
    Replies: 8
    Last Post: 08-17-2008, 07:24 AM
  2. League Table In Excel
    By cesc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-11-2008, 03:28 AM
  3. League table
    By fowkesy in forum Excel General
    Replies: 2
    Last Post: 11-29-2007, 12:48 AM
  4. Sorting Data Table (league table)
    By Cul in forum Excel General
    Replies: 2
    Last Post: 09-13-2007, 05:32 AM
  5. League Table
    By johnwoodh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-15-2007, 02:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1