Re: Calculation Operator ">" not ">=" !!
- From: monir <monirg@xxxxxxxxxxxx>
- Date: Sun, 21 Oct 2007 21:03:33 -0700
On Oct 21, 10:28 pm, Tim Wescott <t...@xxxxxxxxxxxxxxxx> wrote:
On Sun, 21 Oct 2007 10:44:02 -0700, monir wrote:
Hello;
I was a bit hesitant to post this question for obvious reasons, but I
decided to post it anyway!! You never know!
I've two real variables: A & B. The MS application has the following
built-in comparison operators to choose from:
<= , = , >= , int(eger)
One may choose one or more operators from the above list.
I need to specify : A > B
Is there an intelligent way of doing so ???
(choosing the constraint A >= B appears to force the built-in
procedure to first try A = B and fails)
Thank you.
Monir
_What_ Microsoft application? There's a lot of them.
A > B = not(A <= B).
--
Tim Wescott
Control systems and communications consultinghttp://www.wescottdesign.com
Need to learn how to apply control theory in your embedded system?
"Applied Control Theory for Embedded Systems" by Tim Wescott
Elsevier/Newnes,http://www.wescottdesign.com/actfes/actfes.html- Hide quoted text -
- Show quoted text -
Hi Tim;
1. It's MS Excel 2003 add-in Solver module.
2. For the current Solver optimization scenario to be successful, it
must satisfy the constraint A1 > B1 (together with the other specified
constraints).
3. Solver has the following comparison operators to choose from in
"Subject to the Contraints" box: <= , = , >= , int(eger), bin
One may choose one or more operators from the above list.
4. A glimmer of hope might reside in the fact that the Solver
constraint box allows for a formula to be entered and not only a
numerical value or a cell reference. Somehow, one might be able to
manipulate the available conditions { <=, =, >=, int } together with
some Excel functions and end up with the constraint A1 >
B1 !!!!!!!!!!!
5. Depending on the problem parameters, a successful solution by
Solver could yield a value in A1 that's a fraction or many-order-of-
magnitude greater than the value in B1.
Your expert suggestion would be greatly appreciated.
Monir
.
- Follow-Ups:
- Re: Calculation Operator ">" not ">=" !!
- From: Tim Wescott
- Re: Calculation Operator ">" not ">=" !!
- References:
- Re: Calculation Operator ">" not ">=" !!
- From: Tim Wescott
- Re: Calculation Operator ">" not ">=" !!
- Prev by Date: how to solve this kind of optimization problem
- Next by Date: Re: Free sending and sharing any whole solution manual Ebook
- Previous by thread: Re: Calculation Operator ">" not ">=" !!
- Next by thread: Re: Calculation Operator ">" not ">=" !!
- Index(es):
Relevant Pages
|
