Soccer tournament 384 teams

[daroman87]

I would like to do an excel document to manage a soccer tournament.

There are going to be 384 teams.
There will be 6 teams in each group thus a total of 64 groups. All the teams in each group will play against each other and only the first team in each group will qualify to the official league.
1st round of the official league will all play the same day. There will be 64 teams playing. If you win you pass if you loose you are out.
2nd round 32 teams. All play same day. Same rule, you win you pass to the 3rd round and if you loose you are out.
3rd round 16 teams. All play same day. Same rule, you win you pass to the quarterfinals round and if you loose you are out.
4rd round 8 teams. All play same day. Same rule, you win you pass to the semifinals and if you loose you are out.
5th round 4 teams. All play same day. Same rule, you win you pass to the finals and if you loose you are out.

I would like an excel document where I can keep track of the tournament from the beginning to the end. I attached an excel that will help me manage as soon as the 64 teams qualify to the official league. However I don't know how I can approach this problem for the qualification round. If you can help me with a macros will be great.LIGA FUT 7 QUITO.xlsx

What it would be ideal is to have a macro where you can say how many teams you want in the tournament, how many soccer fields you have, from when to when, what days is the tournament going to be played and for it to organize the entire tournament.

[piksi007]

nice its interesting

[CAntosh]

Take a look at the attached. It handles the scheduling of the 5 matchdays and computes all of the point totals. All you would need to do is input the goals for/against for each match. I did the first two groups to demonstrate. It is all based on ROW(), so do not insert rows. You should be able to insert columns if you please, though, perhaps to add goal differential. It isn't as versatile as you requested, but it should fit your specifications. You can adjust the number of teams by increasing/decreasing the number of rows, but it's designed for groups of 6. I hope it helps!