Discussion Closed This discussion was created more than 6 months ago and has been closed. To start a new discussion with a link back to this one, click here.

Issue with Solver

Please login with a confirmed email address before reporting spam

Dear all,

I will try to describe the issue that i have with Solver:

I have random amounts in 2 scenarios below and I am trying to find a particular target amount, which is a sum of count (x) of amounts from 2 lists – with 16 and 24 amounts

Now, the solver is working just fine with the 16 amounts, but when trying with 24 amounts, it is not able to find the particular amount I am looking for, but is finding a slightly different result with tolerance and I am searching for this very amount. I am using GRG Nonlinear method without automatic scaling. The variable cell is SUMPRODUCT function of 2 arrays, the first one with the amounts, the other one is "0"

Below are both scenarios, with 24 amounts and 16 amounts:

Target amount: -916234.3. Should be a sum of x count of amounts from the below list (24):

21150
65467.25
127406.25
161639.53
180016.25
430296.75
437695
1028108
1496043.25
8371345
-50
-12722.38
-33264.46
-44700
-86112.25
-119106.75
-190124
-225991
-634461.5
-666782
-1041289.25
-1900189.83
-2000000
-5578666.75


Target amount: -1622639.78. Should be a sum of x count of amounts from the below list (16):

43,123.00
84,758.75
111188
118110
140019.5
141236.24
411276.5
607640
1870877
-88303
-106648.75
-168775.11
-684223.5
-1458526
-1857152.95
-2334068.46


Any help will be greatly appreciated and hope I have explained myself well.
thanks

0 Replies Last Post Feb 14, 2014, 8:32 a.m. EST
COMSOL Moderator

Hello Vladimir Genadiev

Your Discussion has gone 30 days without a reply. If you still need help with COMSOL and have an on-subscription license, please visit our Support Center for help.

If you do not hold an on-subscription license, you may find an answer in another Discussion or in the Knowledge Base.

Note that while COMSOL employees may participate in the discussion forum, COMSOL® software users who are on-subscription should submit their questions via the Support Center for a more comprehensive response from the Technical Support team.