Home

Finding the optimal division of two groups

%3CLINGO-SUB%20id%3D%22lingo-sub-650791%22%20slang%3D%22en-US%22%3EFinding%20the%20optimal%20division%20of%20two%20groups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650791%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20project%20portfolio%20management%20problem%2C%20which%20%E2%80%93%20I%20think%20%E2%80%93%20can%20be%20handled%20as%20a%20mathematical%20problem.%20Therefore%20I%20would%20like%20to%20solve%20it%20in%20excel.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20be%20warned%2C%20I%20am%20far%20from%20an%20expert%20user%20in%20excel.%3CBR%20%2F%3E%3CBR%20%2F%3EHere%20is%20the%20situation%3A%20I%20have%20a%20list%20of%2022%20projects%20that%20I%20want%20to%20divide%20into%20two%20groups%20for%20portfolio%20management%20reasons.%3CBR%20%2F%3E%3CBR%20%2F%3EEach%20project%20is%20staffed%20by%201-5%20of%20my%20colleagues.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20find%20the%20optimal%20division%20of%20the%2022%20individual%20projects%20into%20two%20groups%20in%20the%20way%20that%20minimizes%20the%20number%20of%20people%20who%20are%20part%20of%20both%20groups.%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20do%20I%20do%20that%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20an%20excel%20sheet%20with%20the%20projects%20in%20column%20a%2C%20colleagues%20in%20row%201%20and%20then%20an%20x%20in%20relevant%20the%20intersections%20between%20names%20and%20projects%20(if%20the%20person%20in%20question%20is%20working%20on%20that%20specific%20project).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20wrong%20in%20thinking%20that%20some%20formula%20or%20function%20can%20solve%20this%20problem%20for%20me%20and%20find%20the%20optimal%20solution%3F%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%3CBR%20%2F%3EMartin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-650791%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
MartinSkovbjerg
Occasional Contributor

I have a project portfolio management problem, which – I think – can be handled as a mathematical problem. Therefore I would like to solve it in excel.

But be warned, I am far from an expert user in excel.

Here is the situation: I have a list of 22 projects that I want to divide into two groups for portfolio management reasons.

Each project is staffed by 1-5 of my colleagues.

I want to find the optimal division of the 22 individual projects into two groups in the way that minimizes the number of people who are part of both groups.

How do I do that?

I have an excel sheet with the projects in column a, colleagues in row 1 and then an x in relevant the intersections between names and projects (if the person in question is working on that specific project).

 

Am I wrong in thinking that some formula or function can solve this problem for me and find the optimal solution?

Best,
Martin

Related Conversations
Outlook "new Group" button grayed out
Domoffice365 in Office 365 Groups on
0 Replies
O365 Group Calendar
Jeff Harlow in Office 365 Groups on
7 Replies
How do I know email received in Group has been replied to?
sam919 in Outlook on
4 Replies