Re: Calculation Operator ">" not ">=" !!

On Oct 24, 4:12 am, monir <mon...@xxxxxxxxxxxx> wrote:

3. The desired condition "A1 > B1" CAN NOT be replaced by "A1 >= B1 OR
"A1 >= B1+something". A singular behaviour exists at A1=B1, and thus
the condition doesn't exist. Keep in mind that the correct solution
could yield A1 value to be a fraction or many-order-of-magnitude
greater than B1.

4. I've done some additional analytical work on the condition A1 > B1
and been able to reformulate the problem such that the constraint is
no longer required. The number of constraints now is less by one.

5. Solver now works correctly and as desired, yet I'm still curious to
why ">", "<", and/or "<>" are not included in the comparison operators
box !! I'm sure, if asked, MS would/could provide a lengthy and
complex reasoning!!

Optimization problems with strict inequality constraints typically
have no solutions (the feasible set is not closed), so it would not
make sense to include such constraints in the solvers. The best
workaround, as you seem to have done, is to circumvent the constraint
by formulating the problem in a slightly different way.

.

Relevant Pages

  • Dana: A different bug in Solver?
    ... The maximum is 1 but Solver founds 0 as the maximum. ... At least B3:B4 are within their constraints in this case. ... it is not a correct solution. ... Can this really be dismissed as simple "confusion"? ...
    (microsoft.public.excel)
  • Re: Calculation Operator ">" not ">=" !!
    ... Keep in mind that the correct solution ... could yield A1 value to be a fraction or many-order-of-magnitude ... The number of constraints now is less by one. ...
    (sci.math.num-analysis)
  • Re: A different bug in Solver?
    ... The developers of Solver clearly state in many places ... At least B3:B4 are within their constraints in this case. ... I am using Office Excel 2003. ... it is not a correct solution. ...
    (microsoft.public.excel)
  • Re: stupid question
    ... Philip Haddad wrote: ... tell Lisp what constraints a correct solution must ...
    (comp.lang.lisp)
  • Re: A Two-Level SOLVER ??
    ... I'm running Excel Solver from a macro. ... ....Subject to constraints: B18=1 ... The correct formulation of the problem should be, I think, something like: ... cells or a vector of cells. ...
    (microsoft.public.excel.programming)
Quantcast