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
Posted Feb 14, 2014, 8:32 a.m. EST 0 Replies
Please login with a confirmed email address before reporting spam
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
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.