Skip to main content
S
SFares14-Alexandrite
14-Alexandrite
June 12, 2014
Solved

iteration

  • June 12, 2014
  • 2 replies
  • 4491 views

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!

Best answer by RichardJ

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

2 replies

R
RichardJ19-Tanzanite
19-Tanzanite
June 12, 2014

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

M
MikeArmstrong1-Visitor
1-Visitor
June 12, 2014

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.

W
Werner_E25-Diamond I
25-Diamond I
June 12, 2014

In which way is this a maximization?

W
Werner_E25-Diamond I
25-Diamond I
June 12, 2014

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

M
MikeArmstrong1-Visitor
1-Visitor
June 12, 2014

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.

S
SFares14-AlexandriteAuthor
14-Alexandrite
June 12, 2014

Thank you all so much for your efforts!!

Terms & ConditionsAccessibility statement