16-Team Championship
Solved
Rob-in
Posted messages
12
Status
Member
-
Raymond PENTIER Posted messages 58209 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58209 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
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
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
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
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
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
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
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
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.
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.
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 ...
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 ...
If you specify a clear rule for ranking, we can adapt the forms.
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.