Results 1 to 4 of 4

SQUAD 23 choose the best 11 players

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2007
    Posts
    9

    SQUAD 23 choose the best 11 players

    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)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1