Match schedule model to a soccer tournament

[husspetakel]

hi
i hope this is the rigth place to make this q:

i have to make a match schedule model to a soccer tournament. the problem is that i have to calculate how to make the schedule.
the goal is to record each indivudual player's score ( how many goals and how many wins )

the terms are :

*there are 20 players
*there are 2 matches of 2 teams playing at once
*everybody have to play on the same team an ecual amount of times
*everybody have to play on the opersit team an ecual amount of times

is it possible to make an equation for this in a program like mathcad or excell

regards Thomas

 

[Valkarie]

Yes, it is possible to make an equation for this in a program like Mathcad or Excel. You could use a combination of equations and logic statements to structure the schedule. For example, you could define a series of variables and equations that would indicate which players are on each team in each match, then use logic statements to ensure that each player appears the same number of times on each team.