Excel file for a championship of a dozen teams

Question

Hello,

I want to create an Excel file with formulas for a football-type championship.
I don't master Excel or formulas at all.
The goal is simple, about a dozen teams, each team needs to meet twice (home/away). I would like the championship to generate once the teams are registered, and every time I add a score, it should update the standings along with the number of matches played, wins, draws, losses, goals for, goals against, goal difference, in short, a basic football ranking. Is there someone to help me?! :s

Configuration: Windows 7 / Chrome 23.0.1271.97

lynyrd1960 · Accepted Answer

Re
Here is the file.
- Enter the team names in column "AF" of the "J01" tab
- Fill in the first 11 matchdays (first leg matches).
- Copy and paste for the matchdays from 12 to 22 (second leg matches)
j01 ---> j12
j02 ---> j13
j03 ---> j14 etc...
here is the link
A+

https://www.cjoint.com/?BLClga4kjSW

Raymond PENTIER · Answer

Look at links 2 and 3 above.  -- Retirement is great! Especially in the Caribbean... :-) &#9787; Raymond &#9794;

lynyrd1960 · Answer

Hello If you can wait until this afternoon, I will prepare the file for you See you later

celtom · Answer

Thank you very much, it's really perfect :) Just one more question, maybe a silly one but I really don't know anything about it, once the teams are back, the days don't generate automatically?

lynyrd1960 · Answer

Hi
No, you have to enter them manually while being careful not to have the same teams meet twice in the first 11 matches.
Otherwise, let me know the names of the 12 teams and I'll do it for you.
See you!

celtom · Answer

A, B, C, ... that's good ;) I will assign teams to the letters later. Thank you very much.

celtom · Answer

Small change of plan... and at the last minute, of course.
There are finally 14 teams!!
Is it possible to make this change?
And here is the list of teams for the matches:
Borussia Dortmund
Arsenal
Real Madrid
FC Bayern Munich
Sedan Ardennes
Manchester City
Atletico Madrid
Manchester United
Nîmes
Germany
Chelsea
FC Barcelona
West Ham United
Inter Milan

lynyrd1960 · Answer

Hi and happy new year I'm sending you the file this afternoon See you later

lynyrd1960 · Answer

Re Here is the file A+ https://www.cjoint.com/c/CAclP16rrZx

celtom · Answer

Last small question, can't I change the team name?? (I have two teams to change)

celtom · Answer

Someone to reply to me?

ping 13 · Answer

Good evening You need to display column AF and from there you change your team names.  Best regards

celtom · Answer

How to display column AF?

ping 13 · Answer

Hello  The solution below    select the entire sheet by clicking in the empty box to the left of A and at the top of 1 ------ then go to Format/Column/Show.  Best regards

celtom · Answer

Thank you, I succeeded. However, do I have to do it for all the pages or is there a special procedure to apply it to all at once?

lynyrd1960 · Answer

On sheet "J01" only A+

celtom · Answer

It's therefore impossible for me to change the matches? :s My tournament starts tomorrow evening and 3 teams are incorrect. Damn it.

lynyrd1960 · Answer

What are the names of the 3 teams to change and replace? A+

celtom · Answer

nîmes --> naples sedan --> juventus de turin inter --> lazio de rome

lynyrd1960 · Answer

HERE IS THE NEW FILE a+  https://www.cjoint.com/c/CAkuC77C16l

celtom · Answer

There's really something I'm missing ^^ Thank you very much ;)

ping 13 · Answer

re

I couldn't intervene earlier, the main thing is done since lynyrd1960 has intervened

For your information, to display the columns:

In the left corner of your sheet, next to column A and above cell 1
there's a small triangle; click on this triangle and then click on format
there you have the visibility section, hide and show, click on show columns
Reverse operation to hide them.
Best regards
PS Click on resolved if everything is okay

celtom · Answer

Small problem, second day, does Juventus' victory give them 6 points?!

lynyrd1960 · Answer

new file A+ https://www.cjoint.com/c/CAlvQrEvUu9

Loic5002 · Answer

Hello everyone, I would like to have the same type of file but in the form of 2 championships, one will be Division 1 and the other Division 2.  Each division will have 8 teams.  I tried to modify the file that was provided, but I can't change the team names in the dropdown lists... If anyone knows the solution, it could simplify things.  Otherwise, is it possible for you to create the same file but blank regarding the team names (which I will add myself) and containing only 8 teams for each?  Thank you very much in advance ;-)  Best regards, Loïc

vqmos · Answer

Hello, would it be possible to have an identical file but with 16 teams?  Thank you in advance.

lynyrd1960 · Answer

Hello vqmos 16 teams in home/away matches? A+

celtom · Answer

One of the people who helped me is still following the topic? I'm receiving 18 people from my association on Saturday for a tournament like we did last year. I would like to have a file if possible like I had before, but I have 18 teams this year... I'll leave you my email (xxxxxxx@hotmail.fr) send me an email and I will forward the file from last year, I don't think there will be many changes?!  "4 pools (2 with 4 and 2 with 5)  The top two qualify for the main tournament: quarter-finals, semi-finals, and final (as well as a match for 3rd place).  The 3rd and 4th will go into the consolation (same system as the main)  The two 5th will have a ranking match."  (Email address removed by moderation).

xander · Answer

BON    Hello, does anyone know how to open the AF file? I need to modify the teams.

xander · Answer

Hello, I can display column AF but I can't modify the team names. What should I do to change them, please?

GoTAtitO · Answer

Hello, I know the topic is from 2013, I've read your messages, and I'm not asking you to create a file but rather to tell me if you know the formula to put in the "Match Winner (MW)" box. Basically, I'm having trouble finding the formula that includes that if it’s 1-0 = 3 points, if it’s 1-1 = 1 point, and for example, 0-1 = 0 points.  So I'm doing it manually, but if I could have this formula that would be better to avoid forgetting errors. Thank you anyway.

Excel file for a championship of a dozen teams

31 réponses

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

My tv turns off and then on again repeatedly?

Executable from a python file

Pay in 4 installments cdiscount

The alt gr key is not working on my keyboard.

Code 80072efe how to get windows update working again

Video in ".3gp" format