How to pick the best grouping

[Daniel777]

I have a challenge I am trying to figure out.

I have a matrix in excel containing groups (all across the first column and the first line) and the values within represent the level of connectivity between them. This is a 100 by 100 matrix.

The challenge is to try and identify the best grouping of 5 groups that yields the highest connectivity between the 5 chosen groups.

Could I do that with Solver or any formula?

A next step would be to factor in the size of the group to identify the most connected group of 5 that also doesn't contain more than 500 people.

The file is attached with the raw data and a mock result in the bottom of what I am trying to achieve. Maybe in this sample, we can choose the best grouping of 3 groups? And maybe that doesn't surpass 100 people as a second exercise?

Would really appreciate some input.

[alansidman]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

To attach a file:

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Daniel777]

Anyone got any input?

[alansidman]

Can you explain how you achieved a 150 score for group 7. I don't see any correlation. Maybe I'm a bit slow, but if you could explain how you would do this manually, then maybe someone here can offer a solution.

[Alf]

What is the difference between this posting and
https://www.excelforum.com/excel-pro...ed-scores.html
the one you asked about an hour ago?

Alf

[alansidman]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.