Skip to main content
B
BG_964177012-Amethyst
12-Amethyst
September 1, 2021
Solved

Graph pass and pass criteria

  • September 1, 2021
  • 1 reply
  • 2734 views

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

 

Best answer by terryhendicott

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

1 reply

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
September 1, 2021

HI

Enclosed statement does the trick.

Capture.JPG

Cheers

Tery

B
BG_964177012-AmethystAuthor
12-Amethyst
September 2, 2021

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

 

T
21-Topaz II
terryhendicott21-Topaz IIAnswer
21-Topaz II
September 2, 2021

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

    Terms & ConditionsAccessibility statement