Solver does not calculate the minimum

bestox

Board Regular
Joined
Apr 2, 2009
Messages
82
i have three different ranges:

BC1:BH1, contain values (f.e. yields)

CI1:CL1, contain some parameter values to start

CO1:CT1, each contains (different) formula using above CI1:CL1 parameters. Formula look like CI1+(CJ1-CI1)*(1-EXP(-0.5/CL1))/....

CN1, contains SUMMYXMY2(CO1:CT1, BC1:BH1)

i now use the solver with MIN:
target cell is CN1
modifiable cells are CI1:CL1

I now run the solver (i did it some more times, but does not change the results, since the parameters are to some extend calibrated). I now assume that the parameters (CI1:CL1) are changed to deliver the minimum of CN1, CN1 contains f.e. 2.1; with simply changing one of the parameters by hand (from -0,04 to -0,05) i decreased CN to 1.7; so the solved parameters by excel are obviously not the best minimum.

I was wondering that maybe i can change the accuracy of the solver. When i enter the options, accuracy is set to 1; When i press OK, i get the messagebox "accuracy has to be a small, positive value". I tried 0.1, 2, 0.5, always same messagebox.

anyone has an idea how to retrieve better results? what could be the reason for the bad parameters?

Thank you for any advice.
 
Last edited:

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,214,813
Messages
6,121,706
Members
449,048
Latest member
81jamesacct

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top