Assuming Leaders are Person1 and Person2, you need to calculate the sum of those binary variables and constraint it to be <= 1, for each Task, e.g.
SUM(C13:C14) <= 1.
Same reasoning goes for newbies.
Extra: yes, there is. In M13
=SUMPRODUCT(C4:G4,C13:G13)
HTH,
Francesco
Last edited by Hydraulics; 12-27-2020 at 06:56 AM.
Aim high or don't even try.
---------------------------------
If your question has been answered, don't forget to mark the thread as SOLVED.
If you find an answer helpful, click on the star icon at the bottom of the post.
Thank you for replying. I found a working solution by assigning values (2 for Leaders, 1 for members and 0 for newbies) and using sumproduct function to calculate the team value. Then I added min and max team value constraints.
I attached the work file for anyone interested.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ciprian 
Register To Reply
Bookmarks