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

## Graph pass and pass criteria  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  20-Turquoise
(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  20-Turquoise
(To:BG_9641770)

HI

Enclosed statement does the trick. Cheers

Tery  11-Garnet
(To:terryhendicott)

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).   20-Turquoise
(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 II
(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  19-Tanzanite
(To:BG_9641770)      