cancel
Showing results for
Did you mean:
cancel
Showing results for
Did you mean:

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

11-Garnet

## 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?

Thank you Br Stefan

1 ACCEPTED SOLUTION

Accepted Solutions
24-Ruby V
(To: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.

6 REPLIES 6
23-Emerald III
(To:sm�ller-2)

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

Success!
Luc

24-Ruby V
(To:sm�ller-2)

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 ??

24-Ruby V
(To:Werner_E)

Is it this what you are looking for:

24-Ruby V
(To: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.