1-Visitor

Solved

Finding Maximum in Matrix under side condition

Hallo guys,

i have a question regarding finding a maximum value out of a matrix.

I have an overlap , maximum transmissible force, NOKOK Matrix

i now need to find the overlap for the maximum transmissible force under the condition "OK"

The values in the matrix are only valid for "OK"

For the given example the correct overlap is 0,127 mm with 649,736 kN

Can anyone help me out how to determine this problem?

I have Mathcad 15

Thank you Br Stefan

Best answer by Werner_E

And here is a more classic, straightforward approach using a loop. Again w/o using an augmented matrix.

It works without using match,trim, max and lookup.

It's your choice now.

23-Emerald IV

Use the csort () function twice. First on the NOKOK column, then on the force column.

Success!
Luc

25-Diamond I

For the given example the correct overlap is 0,127 mm with 649,736 kN

Why?? What about 0,121 mm with 655,656 kN ??

25-Diamond I

Is it this what you are looking for:

Sign up