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

Graph pass and pass criteria

Hi all i want to interpret a pass/fail criteria based on if the point of intersection is above or below the  x-y axis line

i.e. for example this would be classed as a pass where the lines intersect below the loading envelop

thanks

Ben

1 ACCEPTED SOLUTION

Accepted Solutions
21-Topaz I
(To:BG_9641770)

Hi,

The formula does work.   Enclosed is a revised sheet.  After the definition of the function "pass(X,L)" it can then be used.

180,50 gets a zero or false for outside the region,

150,50 gets a 1 as it is within the region.

then use X,L from the top of the worksheet in the pass function.

Cheers

Terry

5 REPLIES 5
21-Topaz I
(To:BG_9641770)

HI

Enclosed statement does the trick.

Cheers

Tery

Thanks Terry

that equation hasn't worked as shown below, if i make X=180 if is outside the loading envelope and therefore should be a fail (i.e. a pass in the underside of the line).

21-Topaz I
(To:BG_9641770)

Hi,

The formula does work.   Enclosed is a revised sheet.  After the definition of the function "pass(X,L)" it can then be used.

180,50 gets a zero or false for outside the region,

150,50 gets a 1 as it is within the region.

then use X,L from the top of the worksheet in the pass function.

Cheers

Terry

23-Emerald III
(To:BG_9641770)

You had failed to specify the borderline cases: those cases where a point ON the line is reached.

Terry set X>180 as false, meaning that X=180 would be allowed.

Same for L=150 and opposite for the slope.

But I think that the function should first test for the slope, then consider the single cases of X and L.

A more versatile method may be:

This will also help if your limit is, e.g., along the product of X and L...

Success!

Luc

20-Turquoise
(To:BG_9641770)

Announcements
Top Tags