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
Solved! Go to 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
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).
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
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