View original (French)

16-Team Championship

Solved
Rob-in Posted messages 12 Status Member -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello,
I would like to create a football championship with 16 teams.
I am looking for software that will allow all the teams to face each other in a round-robin format (and a return match if possible), with a ranking that can generate automatically if possible too.
Thank you to anyone who can help me!

Configuration: Windows / Chrome 61.0.3163.100

3 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello Robin,

    See if this works for you: https://www.cjoint.com/c/GJCxsE4M2J6
    The team names need to be changed in column J
    The hidden column in S sets a value for each team according to the formula: number of points + number of goals scored/100 + difference/1000 to break any ties and allow for ranking

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    1
    1. Rob-in Posted messages 12 Status Member
       
      Thank you so much, it's exactly what I was looking for! But there's just a small issue with the ranking, but I'll manage with the points.
      0
    2. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759 > Rob-in Posted messages 12 Status Member
       
      What problem?
      If you specify a clear rule for ranking, we can adapt the forms.
      0
    3. Rob-in Posted messages 12 Status Member > via55 Posted messages 14393 Registration date   Status Member Last intervention  
       
      The problem is that the ranking consists of only one team: the first one I noted in the table at the top, and then all the other places have the same name.
      0
    4. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784 > Rob-in Posted messages 12 Status Member
       
      It's because the ranking does not consider ties.
      0
    5. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759 > Rob-in Posted messages 12 Status Member
       
      Strange, it works well on my original file
      Did you enter scores for all the teams for the first day?
      Resend me your file on cjoint.com, create a link that you copy and come back to paste it here, I will take a look.
      0
  2. JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
     
    Good evening,

    you can start by using this meeting schedule:

    First leg matches
    home visitors
    AA PP
    BB OO
    CC NN
    DD MM
    EE LL
    FF KK
    GG JJ
    HH II
    PP BB
    AA CC
    OO DD
    NN EE
    MM FF
    LL GG
    KK HH
    JJ II
    CC PP
    DD BB
    EE AA
    FF OO
    GG NN
    HH MM
    II LL
    JJ KK
    PP DD
    CC EE
    BB FF
    AA GG
    OO HH
    NN II
    MM JJ
    LL KK
    EE PP
    FF DD
    GG CC
    HH BB
    II AA
    JJ OO
    KK NN
    LL MM
    PP FF
    EE GG
    DD HH
    CC II
    BB JJ
    AA KK
    OO LL
    NN MM
    GG PP
    HH FF
    II EE
    JJ DD
    KK CC
    LL BB
    MM AA
    NN OO
    PP HH
    GG II
    FF JJ
    EE KK
    DD LL
    CC MM
    BB NN
    AA OO
    II PP
    JJ HH
    KK GG
    LL FF
    MM EE
    NN DD
    OO CC
    AA BB
    PP JJ
    II KK
    HH LL
    GG MM
    FF NN
    EE OO
    DD AA
    CC BB
    KK PP
    LL JJ
    MM II
    NN HH
    OO GG
    AA FF
    BB EE
    CC DD
    PP LL
    KK MM
    JJ NN
    II OO
    HH AA
    GG BB
    FF CC
    EE DD
    MM PP
    NN LL
    OO KK
    AA JJ
    BB II
    CC HH
    DD GG
    EE FF
    PP NN
    MM OO
    LL AA
    KK BB
    JJ CC
    II DD
    HH EE
    GG FF
    OO PP
    AA NN
    BB MM
    CC LL
    DD KK
    EE JJ
    FF II
    GG HH

    Return matches
    home visitors
    PP AA
    OO BB
    NN CC
    MM DD
    LL EE
    KK FF
    JJ GG
    II HH
    BB PP
    CC AA
    DD OO
    EE NN
    FF MM
    GG LL
    HH KK
    II JJ
    PP CC
    BB DD
    AA EE
    OO FF
    NN GG
    MM HH
    LL II
    KK JJ
    DD PP
    EE CC
    FF BB
    GG AA
    HH OO
    II NN
    JJ MM
    KK LL
    PP EE
    DD FF
    CC GG
    BB HH
    AA II
    OO JJ
    NN KK
    MM LL
    FF PP
    GG EE
    HH DD
    II CC
    JJ BB
    KK AA
    LL OO
    MM NN
    PP GG
    FF HH
    EE II
    DD JJ
    CC KK
    BB LL
    AA MM
    OO NN
    HH PP
    II GG
    JJ FF
    KK EE
    LL DD
    MM CC
    NN BB
    OO AA
    PP II
    HH JJ
    GG KK
    FF LL
    EE MM
    DD NN
    CC OO
    BB AA
    JJ PP
    KK II
    LL HH
    MM GG
    NN FF
    OO EE
    AA DD
    BB CC
    PP KK
    JJ LL
    II MM
    HH NN
    GG OO
    FF AA
    EE BB
    DD CC
    LL PP
    MM KK
    NN JJ
    OO II
    AA HH
    BB GG
    CC FF
    DD EE
    PP MM
    LL NN
    KK OO
    JJ AA
    II BB
    HH CC
    GG DD
    FF EE
    NN PP
    OO MM
    AA LL
    BB KK
    CC JJ
    DD II
    EE HH
    FF GG
    PP OO
    NN AA
    MM BB
    LL CC
    KK DD
    JJ EE
    II FF
    HH GG

    Best regards
    0
    1. Rob-in Posted messages 12 Status Member
       
      Thank you for your help, but I am looking more for an Excel file with automatic ranking because I have a rough idea of how the matches will unfold.

      Best regards.
      0
  3. gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    Welcome to the forum.

    With a minimum of research, you would have FOUND!
    --
    Always zen
    Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
    -1
    1. Rob-in Posted messages 12 Status Member
       
      Yes, I tried but there is a problem with the matches that are the same after a while.
      So I would like the same thing but with the correct matches because I am not very good at Excel.
      0
    2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482 > Rob-in Posted messages 12 Status Member
       
      It's not very clear! Please clarify your thoughts...
      0
    3. Rob-in Posted messages 12 Status Member > Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention  
       
      Do you want me to explain exactly what I would like to do?

      Let me clarify then, I would like an Excel software for a football championship with
      16 teams that can:
      - Generate at least the first matches with a return if possible
      - An automatic ranking that updates based on match results
      - A point system with W=4 D=2 L=1
      - The ability to input the team names you want

      There it is, if someone can help me find this, I would be extremely grateful because I'm really struggling to figure out how to do it.
      0
    4. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482 > Rob-in Posted messages 12 Status Member
       
      No, Rob-in!
      What I don't understand is:
      "problem with the matches that are the same after a while" and
      "I would like the same thing but with the right matches" ...

      And I don’t understand why you are asking for a software when you are in the Excel forum, and you certainly have this software!
      So you need an Excel file?
      Then go on the Internet and find thousands of links on the subject ...
      0
    5. Rob-in Posted messages 12 Status Member
       
      Just not, as I was saying, all the championships had a problem with matches that repeated after a while, so I couldn't do what I wanted.
      0