Can somebody help me ?!
I need a spreadsheet that can do this.
I have a football squad with 23 players
3 GoalKeeper (GR)
4 Full-back (FB)
4 Centre-back (CB)
3 Centre midfielder (CM)
3 Side midfielder (SM)
2 Attacking midfielder (AT
4 Forward (F)
that every week gain points resulting of there performance.
I would like to have a formula that would allow me to choose every week the best 11 team respectin this criteria:
- the team to be valid have always to have:
- 1 GoalKeeper and 1 Attacking Midfielder
- But then there is 5 possibilities to the other nine players:
a) 1 FB; 2 DC, 2MC, 2SM, 2F
b) 2 FB; 1 DC, 2MC, 2SM, 2F
c) 2FB; 2DC; 1MC, 2SM, 2F
d) 2FB, 2DC, 2MC, 1SM, 2 F
e) 2FB, 2DC, 2MC, 2SM, 1 F
I will send a Excel spreadsheet with a example.
Tjakns in advance. (sorry my English)
Bookmarks