• 469K Members
• 9,588 Online
• 567K Conversations

Highlighted
Visitor

Simple Solver Problem - Can't get it to work

Hello

I have a simple solver problem that I can't seem to get to work and I'm not sure why.

It is a simple distribution of resources problem, and what I'm trying to solve for is the smallest number of exchanges required to meet the constraints.

Here's a photo of the excel sheet:

So in the above example, Brad is short 996 units, Matt is owed 294 units, etc.  The red cells are the variable cells.  The blue cells sum the totals next to each person and the corresponding red cells.  The net should equal 0.  So the blue cells are constraints that must = 0.

Finally, the objective is the count cell.  I want this to be the minimum number of "exchanges" that need to occur.  I.e. Brad gives Matt 294 (now Matt's balance = 0), Brad gives John 143 (now Matt's balance = 0), and that's 2 exchanges.

Here is a screenshot of the solver parameter setup:

Here is a solution that I came up on my own...just plugging in numbers:

See how the count = 9, the total number of exchanges.  However, when I run the solver solution, no matter if I use GRG Non Linear or Evolutionary, I get something like this...which is certainly not the minimum since I was able to find a solution for 9 exchanges just guessing...(10 is greater than 9):

What am I missing?  This seems pretty simple for solver, but I can't get it to work.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies