Graph pass and pass criteria

[BG_9641770]

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

[terryhendicott]

HI

Enclosed statement does the trick.

Cheers

Tery

[BG_9641770]

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

[terryhendicott · Accepted solution]

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

[LucMeekes]

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

[ttokoro]