FIFA Tournament Creation for 4 Teams
WallooBZH
Posted messages
2
Status
Member
-
ilias 234 -
ilias 234 -
Hello everyone!
Well, my request is quite simple, I'm just looking to create a file that allows me to organize a football tournament/championship when I do one with my friends, since this feature has disappeared in the Xbox One version of FIFA 14 (what a drag...).
If you're not familiar, the principle is very simple: X players on the couch each choose a team, play home and away matches, and the one with the most points at the end wins the right to have drinks paid for.
I don't fiddle enough with Excel to set up something like that myself, which is why I'm reaching out to you.
So, it should include:
- the ability to choose 4 teams (manual entry of the name)
- home and away matches
- a standings table, obviously, following 'normal' rules (win 3 points, draw 1, loss 0), taking into account goal difference (goals for, goals against, and difference)
- a display of the upcoming matchday, just to put a little pressure
- no need for groups or knockout phases, just a league format
In short, a classic FIFA tournament, that's all ^^
Thanks for your help :)
Well, my request is quite simple, I'm just looking to create a file that allows me to organize a football tournament/championship when I do one with my friends, since this feature has disappeared in the Xbox One version of FIFA 14 (what a drag...).
If you're not familiar, the principle is very simple: X players on the couch each choose a team, play home and away matches, and the one with the most points at the end wins the right to have drinks paid for.
I don't fiddle enough with Excel to set up something like that myself, which is why I'm reaching out to you.
So, it should include:
- the ability to choose 4 teams (manual entry of the name)
- home and away matches
- a standings table, obviously, following 'normal' rules (win 3 points, draw 1, loss 0), taking into account goal difference (goals for, goals against, and difference)
- a display of the upcoming matchday, just to put a little pressure
- no need for groups or knockout phases, just a league format
In short, a classic FIFA tournament, that's all ^^
Thanks for your help :)
1 answer
-
Good evening WallooBZH
In return, a file that I hope will meet your request.
- Enter the players' names in the "Player Names" sheet; the rest will be calculated automatically
Good matches.
See you later
https://www.cjoint.com/c/CKEagcZxP9n-
Owai, it's perfect Lynyrd1960!
Just 2 - 3 small things to modify if you have the time:
- regarding the ranking, put the points first and remove column R ('well, Y ^^)
- in terms of aesthetics and just to nitpick a bit, could you apply a brushed aluminum style on the gray boxes?
- is the order of the matches determined randomly?
Otherwise, it's great! Just a bit of training to do and I'm ready for the tournament tonight, thank you very much! -
-
-
-
