Skip to main content
SFares14-Alexandrite
14-Alexandrite
Jun 12, 2014 6:49 PM UTC
Solved

iteration

Hello,

Please scroll down in my sheet until you see the red arrow where i have my question. i am trying to maxamize the value for (Lpm_v) so that the ratio at the bottom does not exceed a certain value which i listed inside my sheet. Thanks!

RichardJAnswer
19-Tanzanite
Jun 12, 2014 9:20 PM UTC

I only just realized what you meant . I'm being dense today . Let's try that again (the answer happens to be the same).

View in thread

18 replies

RichardJ19-Tanzanite
19-Tanzanite
Jun 12, 2014 7:02 PM UTC

Create a function, and then maximize it with a constraint using a solve block.

Translate
MikeArmstrong1-Visitor
1-Visitor
Jun 12, 2014 7:45 PM UTC

I have plagiarized Richards method and shown a slightly different approach using a standard Given / Find solve block, as I am bored waiting for the WC.

In interesting to see that the two approaches converge to a slightly different result.

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
Jun 12, 2014 7:55 PM UTC

In which way is this a maximization?

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
Jun 12, 2014 9:22 PM UTC

As the function Comb_V_Pos_etc(L.PM_etc.) is strictly increasing, maximizing Comb or maximizing L.PM is the same.

Here is another slightly different approach using solve and the result is of course the same as Mike's. If you set CTOL to something low as 10^-7 in Richards sheet, his sheet also returns the same value.

12.06.png

Translate
MikeArmstrong1-Visitor
1-Visitor
Jun 12, 2014 9:28 PM UTC

Werner Exinger wrote:

Here is another slightly different approach using solve

And the most elegant in my opinion.

Multiple variations for Sameer to work with.

Translate
SFares14-AlexandriteAuthor
14-Alexandrite
Jun 12, 2014 9:31 PM UTC

Thank you all so much for your efforts!!

Translate
Terms & ConditionsAccessibility statement