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

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

Graph pass and pass criteria

BG_9641770
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

BG_9641770_0-1630529569085.png

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

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

Capture.JPG

View solution in original post

5 REPLIES 5

HI

Enclosed statement does the trick.

Capture.JPG

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).

 

BG_9641770_0-1630575870246.png

 

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

Capture.JPG

LucMeekes
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:

LucMeekes_0-1630580999467.png

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

LucMeekes_0-1630585021742.png

 

Success!

Luc

ttokoro
20-Turquoise
(To:BG_9641770)

image.png

image.pngimage.pngimage.pngimage.png

Top Tags