Registered User Joined: 3/10/2012 Posts: 465
|
Bruce this below formula i picked up from forum ... can u please give me a new formula based on this for the WIDTH value IN TERMS OF PERCENTAGE , i m looking for how wide or narrow resistance or support was in terms of percentage for sorting , thanks
Reisitance
ABS(MAXH3 < H3 AND H3 > MAXH3.4) * H3 + ABS(MAXH3 >= H3 OR H3 <= MAXH3.4) * (ABS(MAXH3.1 < H4 AND H4 > MAXH3.5) * H4 + ABS(MAXH3.1 >= H4 OR H4 <= MAXH3.5) * (ABS(MAXH3.2 < H5 AND H5 > MAXH3.6) * H5 + ABS(MAXH3.2 >= H5 OR H5 <= MAXH3.6) * (ABS(MAXH3.3 < H6 AND H6 > MAXH3.7) * H6 + ABS(MAXH3.3 >= H6 OR H6 <= MAXH3.7) * (ABS(MAXH3.4 < H7 AND H7 > MAXH3.8) * H7 + ABS(MAXH3.4 >= H7 OR H7 <= MAXH3.8) * (ABS(MAXH3.5 < H8 AND H8 > MAXH3.9) * H8 + ABS(MAXH3.5 >= H8 OR H8 <= MAXH3.9) * (ABS(MAXH3.6 < H9 AND H9 > MAXH3.10) * H9 + ABS(MAXH3.6 >= H9 OR H9 <= MAXH3.10) * (ABS(MAXH3.7 < H10 AND H10 > MAXH3.11) * H10 + ABS(MAXH3.7 >= H10 OR H10 <= MAXH3.11) * (ABS(MAXH3.8 < H11 AND H11 > MAXH3.12) * H11 + ABS(MAXH3.8 >= H11 OR H11 <= MAXH3.12) * (ABS(MAXH3.9 < H12 AND H12 > MAXH3.13) * H12 + ABS(MAXH3.9 >= H12 OR H12 <= MAXH3.13) * (ABS(MAXH3.10 < H13 AND H13 > MAXH3.14) * H13 + ABS(MAXH3.10 >= H13 OR H13 <= MAXH3.14) * (ABS(MAXH3.11 < H14 AND H14 > MAXH3.15) * H14 + ABS(MAXH3.11 >= H14 OR H14 <= MAXH3.15) * (ABS(MAXH3.12 < H15 AND H15 > MAXH3.16) * H15 + ABS(MAXH3.12 >= H15 OR H15 <= MAXH3.16) * (ABS(MAXH3.13 < H16 AND H16 > MAXH3.17) * H16 + ABS(MAXH3.13 >= H16 OR H16 <= MAXH3.17) * (ABS(MAXH3.14 < H17 AND H17 > MAXH3.18) * H17 + ABS(MAXH3.14 >= H17 OR H17 <= MAXH3.18) * (ABS(MAXH3.15 < H18 AND H18 > MAXH3.19) * H18 + ABS(MAXH3.15 >= H18 OR H18 <= MAXH3.19) * (ABS(MAXH3.16 < H19 AND H19 > MAXH3.20) * H19 + ABS(MAXH3.16 >= H19 OR H19 <= MAXH3.20) * (ABS(MAXH3.17 < H20 AND H20 > MAXH3.21) * H20 + ABS(MAXH3.17 >= H20 OR H20 <= MAXH3.21) * (ABS(MAXH3.18 < H21 AND H21 > MAXH3.22) * H21 + ABS(MAXH3.18 >= H21 OR H21 <= MAXH3.22) * (ABS(MAXH3.19 < H22 AND H22 > MAXH3.23) * H22 + ABS(MAXH3.19 >= H22 OR H22 <= MAXH3.23) * (ABS(MAXH3.20 < H23 AND H23 > MAXH3.24) * H23 + ABS(MAXH3.20 >= H23 OR H23 <= MAXH3.24) * (ABS(MAXH3.21 < H24 AND H24 > MAXH3.25) * H24 + ABS(MAXH3.21 >= H24 OR H24 <= MAXH3.25) * (ABS(MAXH3.22 < H25 AND H25 > MAXH3.26) * H25 + ABS(MAXH3.22 >= H25 OR H25 <= MAXH3.26) * (ABS(MAXH3.23 < H26 AND H26 > MAXH3.27) * H26 + ABS(MAXH3.23 >= H26 OR H26 <= MAXH3.27) * (ABS(MAXH3.24 < H27 AND H27 > MAXH3.28) * H27 + ABS(MAXH3.24 >= H27 OR H27 <= MAXH3.28) * (ABS(MAXH3.25 < H28 AND H28 > MAXH3.29) * H28 + ABS(MAXH3.25 >= H28 OR H28 <= MAXH3.29) * (ABS(MAXH3.26 < H29 AND H29 > MAXH3.30) * H29 + ABS(MAXH3.26 >= H29 OR H29 <= MAXH3.30) * (ABS(MAXH3.27 < H30 AND H30 > MAXH3.31) * H30 + ABS(MAXH3.27 >= H30 OR H30 <= MAXH3.31) * (ABS(MAXH3.28 < H31 AND H31 > MAXH3.32) * H31 + ABS(MAXH3.28 >= H31 OR H31 <= MAXH3.32) * (ABS(MAXH3.29 < H32 AND H32 > MAXH3.33) * H32 + ABS(MAXH3.29 >= H32 OR H32 <= MAXH3.33) * (ABS(MAXH3.30 < H33 AND H33 > MAXH3.34) * H33 + ABS(MAXH3.30 >= H33 OR H33 <= MAXH3.34) * (ABS(MAXH3.31 < H34 AND H34 > MAXH3.35) * H34 + ABS(MAXH3.31 >= H34 OR H34 <= MAXH3.35) * (ABS(MAXH3.32 < H35 AND H35 > MAXH3.36) * H35 + ABS(MAXH3.32 >= H35 OR H35 <= MAXH3.36) * (ABS(MAXH3.33 < H36 AND H36 > MAXH3.37) * H36 + ABS(MAXH3.33 >= H36 OR H36 <= MAXH3.37) * (ABS(MAXH3.34 < H37 AND H37 > MAXH3.38) * H37 + ABS(MAXH3.34 >= H37 OR H37 <= MAXH3.38) * (ABS(MAXH3.35 < H38 AND H38 > MAXH3.39) * H38 + ABS(MAXH3.35 >= H38 OR H38 <= MAXH3.39) * (ABS(MAXH3.36 < H39 AND H39 > MAXH3.40) * H39 + ABS(MAXH3.36 >= H39 OR H39 <= MAXH3.40) * (ABS(MAXH3.37 < H40 AND H40 > MAXH3.41) * H40 + ABS(MAXH3.37 >= H40 OR H40 <= MAXH3.41) * (ABS(MAXH3.38 < H41 AND H41 > MAXH3.42) * H41 + ABS(MAXH3.38 >= H41 OR H41 <= MAXH3.42) * (ABS(MAXH3.39 < H42 AND H42 > MAXH3.43) * H42 + ABS(MAXH3.39 >= H42 OR H42 <= MAXH3.43) * (ABS(MAXH3.40 < H43 AND H43 > MAXH3.44) * H43 + ABS(MAXH3.40 >= H43 OR H43 <= MAXH3.44) * (ABS(MAXH3.41 < H44 AND H44 > MAXH3.45) * H44 + ABS(MAXH3.41 >= H44 OR H44 <= MAXH3.45) * (ABS(MAXH3.42 < H45 AND H45 > MAXH3.46) * H45 + ABS(MAXH3.42 >= H45 OR H45 <= MAXH3.46) * (ABS(MAXH3.43 < H46 AND H46 > MAXH3.47) * H46 + ABS(MAXH3.43 >= H46 OR H46 <= MAXH3.47) * (ABS(MAXH3.44 < H47 AND H47 > MAXH3.48) * H47 + ABS(MAXH3.44 >= H47 OR H47 <= MAXH3.48) * (ABS(MAXH3.45 < H48 AND H48 > MAXH3.49) * H48 + ABS(MAXH3.45 >= H48 OR H48 <= MAXH3.49) * (ABS(MAXH3.46 < H49 AND H49 > MAXH3.50) * H49 + ABS(MAXH3.46 >= H49 OR H49 <= MAXH3.50) * (ABS(MAXH3.47 < H50 AND H50 > MAXH3.51) * H50 + ABS(MAXH3.47 >= H50 OR H50 <= MAXH3.51) * (ABS(MAXH3.48 < H51 AND H51 > MAXH3.52) * H51 + ABS(MAXH3.48 >= H51 OR H51 <= MAXH3.52) * (ABS(MAXH3.49 < H52 AND H52 > MAXH3.53) * H52 + ABS(MAXH3.49 >= H52 OR H52 <= MAXH3.53) * (ABS(MAXH3.50 < H53 AND H53 > MAXH3.54) * H53 + ABS(MAXH3.50 >= H53 OR H53 <= MAXH3.54) * (ABS(MAXH3.51 < H54 AND H54 > MAXH3.55) * H54 + ABS(MAXH3.51 >= H54 OR H54 <= MAXH3.55) * (ABS(MAXH3.52 < H55 AND H55 > MAXH3.56) * H55 + ABS(MAXH3.52 >= H55 OR H55 <= MAXH3.56) * (ABS(MAXH3.53 < H56 AND H56 > MAXH3.57) * H56 + ABS(MAXH3.53 >= H56 OR H56 <= MAXH3.57) * (ABS(MAXH3.54 < H57 AND H57 > MAXH3.58) * H57 + ABS(MAXH3.54 >= H57 OR H57 <= MAXH3.58) * (ABS(MAXH3.55 < H58 AND H58 > MAXH3.59) * H58 + ABS(MAXH3.55 >= H58 OR H58 <= MAXH3.59) * (ABS(MAXH3.56 < H59 AND H59 > MAXH3.60) * H59 + ABS(MAXH3.56 >= H59 OR H59 <= MAXH3.60) * (ABS(MAXH3.57 < H60 AND H60 > MAXH3.61) * H60 + ABS(MAXH3.57 >= H60 OR H60 <= MAXH3.61) * (ABS(MAXH3.58 < H61 AND H61 > MAXH3.62) * H61 + ABS(MAXH3.58 >= H61 OR H61 <= MAXH3.62) * (ABS(MAXH3.59 < H62 AND H62 > MAXH3.63) * H62 + ABS(MAXH3.59 >= H62 OR H62 <= MAXH3.63) * MAXH63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Support
ABS(MINL3 > L3 AND L3 < MINL3.4) * L3 + ABS(MINL3 <= L3 OR L3 >= MINL3.4) * (ABS(MINL3.1 > L4 AND L4 < MINL3.5) * L4 + ABS(MINL3.1 <= L4 OR L4 >= MINL3.5) * (ABS(MINL3.2 > L5 AND L5 < MINL3.6) * L5 + ABS(MINL3.2 <= L5 OR L5 >= MINL3.6) * (ABS(MINL3.3 > L6 AND L6 < MINL3.7) * L6 + ABS(MINL3.3 <= L6 OR L6 >= MINL3.7) * (ABS(MINL3.4 > L7 AND L7 < MINL3.8) * L7 + ABS(MINL3.4 <= L7 OR L7 >= MINL3.8) * (ABS(MINL3.5 > L8 AND L8 < MINL3.9) * L8 + ABS(MINL3.5 <= L8 OR L8 >= MINL3.9) * (ABS(MINL3.6 > L9 AND L9 < MINL3.10) * L9 + ABS(MINL3.6 <= L9 OR L9 >= MINL3.10) * (ABS(MINL3.7 > L10 AND L10 < MINL3.11) * L10 + ABS(MINL3.7 <= L10 OR L10 >= MINL3.11) * (ABS(MINL3.8 > L11 AND L11 < MINL3.12) * L11 + ABS(MINL3.8 <= L11 OR L11 >= MINL3.12) * (ABS(MINL3.9 > L12 AND L12 < MINL3.13) * L12 + ABS(MINL3.9 <= L12 OR L12 >= MINL3.13) * (ABS(MINL3.10 > L13 AND L13 < MINL3.14) * L13 + ABS(MINL3.10 <= L13 OR L13 >= MINL3.14) * (ABS(MINL3.11 > L14 AND L14 < MINL3.15) * L14 + ABS(MINL3.11 <= L14 OR L14 >= MINL3.15) * (ABS(MINL3.12 > L15 AND L15 < MINL3.16) * L15 + ABS(MINL3.12 <= L15 OR L15 >= MINL3.16) * (ABS(MINL3.13 > L16 AND L16 < MINL3.17) * L16 + ABS(MINL3.13 <= L16 OR L16 >= MINL3.17) * (ABS(MINL3.14 > L17 AND L17 < MINL3.18) * L17 + ABS(MINL3.14 <= L17 OR L17 >= MINL3.18) * (ABS(MINL3.15 > L18 AND L18 < MINL3.19) * L18 + ABS(MINL3.15 <= L18 OR L18 >= MINL3.19) * (ABS(MINL3.16 > L19 AND L19 < MINL3.20) * L19 + ABS(MINL3.16 <= L19 OR L19 >= MINL3.20) * (ABS(MINL3.17 > L20 AND L20 < MINL3.21) * L20 + ABS(MINL3.17 <= L20 OR L20 >= MINL3.21) * (ABS(MINL3.18 > L21 AND L21 < MINL3.22) * L21 + ABS(MINL3.18 <= L21 OR L21 >= MINL3.22) * (ABS(MINL3.19 > L22 AND L22 < MINL3.23) * L22 + ABS(MINL3.19 <= L22 OR L22 >= MINL3.23) * (ABS(MINL3.20 > L23 AND L23 < MINL3.24) * L23 + ABS(MINL3.20 <= L23 OR L23 >= MINL3.24) * (ABS(MINL3.21 > L24 AND L24 < MINL3.25) * L24 + ABS(MINL3.21 <= L24 OR L24 >= MINL3.25) * (ABS(MINL3.22 > L25 AND L25 < MINL3.26) * L25 + ABS(MINL3.22 <= L25 OR L25 >= MINL3.26) * (ABS(MINL3.23 > L26 AND L26 < MINL3.27) * L26 + ABS(MINL3.23 <= L26 OR L26 >= MINL3.27) * (ABS(MINL3.24 > L27 AND L27 < MINL3.28) * L27 + ABS(MINL3.24 <= L27 OR L27 >= MINL3.28) * (ABS(MINL3.25 > L28 AND L28 < MINL3.29) * L28 + ABS(MINL3.25 <= L28 OR L28 >= MINL3.29) * (ABS(MINL3.26 > L29 AND L29 < MINL3.30) * L29 + ABS(MINL3.26 <= L29 OR L29 >= MINL3.30) * (ABS(MINL3.27 > L30 AND L30 < MINL3.31) * L30 + ABS(MINL3.27 <= L30 OR L30 >= MINL3.31) * (ABS(MINL3.28 > L31 AND L31 < MINL3.32) * L31 + ABS(MINL3.28 <= L31 OR L31 >= MINL3.32) * (ABS(MINL3.29 > L32 AND L32 < MINL3.33) * L32 + ABS(MINL3.29 <= L32 OR L32 >= MINL3.33) * (ABS(MINL3.30 > L33 AND L33 < MINL3.34) * L33 + ABS(MINL3.30 <= L33 OR L33 >= MINL3.34) * (ABS(MINL3.31 > L34 AND L34 < MINL3.35) * L34 + ABS(MINL3.31 <= L34 OR L34 >= MINL3.35) * (ABS(MINL3.32 > L35 AND L35 < MINL3.36) * L35 + ABS(MINL3.32 <= L35 OR L35 >= MINL3.36) * (ABS(MINL3.33 > L36 AND L36 < MINL3.37) * L36 + ABS(MINL3.33 <= L36 OR L36 >= MINL3.37) * (ABS(MINL3.34 > L37 AND L37 < MINL3.38) * L37 + ABS(MINL3.34 <= L37 OR L37 >= MINL3.38) * (ABS(MINL3.35 > L38 AND L38 < MINL3.39) * L38 + ABS(MINL3.35 <= L38 OR L38 >= MINL3.39) * (ABS(MINL3.36 > L39 AND L39 < MINL3.40) * L39 + ABS(MINL3.36 <= L39 OR L39 >= MINL3.40) * (ABS(MINL3.37 > L40 AND L40 < MINL3.41) * L40 + ABS(MINL3.37 <= L40 OR L40 >= MINL3.41) * (ABS(MINL3.38 > L41 AND L41 < MINL3.42) * L41 + ABS(MINL3.38 <= L41 OR L41 >= MINL3.42) * (ABS(MINL3.39 > L42 AND L42 < MINL3.43) * L42 + ABS(MINL3.39 <= L42 OR L42 >= MINL3.43) * (ABS(MINL3.40 > L43 AND L43 < MINL3.44) * L43 + ABS(MINL3.40 <= L43 OR L43 >= MINL3.44) * (ABS(MINL3.41 > L44 AND L44 < MINL3.45) * L44 + ABS(MINL3.41 <= L44 OR L44 >= MINL3.45) * (ABS(MINL3.42 > L45 AND L45 < MINL3.46) * L45 + ABS(MINL3.42 <= L45 OR L45 >= MINL3.46) * (ABS(MINL3.43 > L46 AND L46 < MINL3.47) * L46 + ABS(MINL3.43 <= L46 OR L46 >= MINL3.47) * (ABS(MINL3.44 > L47 AND L47 < MINL3.48) * L47 + ABS(MINL3.44 <= L47 OR L47 >= MINL3.48) * (ABS(MINL3.45 > L48 AND L48 < MINL3.49) * L48 + ABS(MINL3.45 <= L48 OR L48 >= MINL3.49) * (ABS(MINL3.46 > L49 AND L49 < MINL3.50) * L49 + ABS(MINL3.46 <= L49 OR L49 >= MINL3.50) * (ABS(MINL3.47 > L50 AND L50 < MINL3.51) * L50 + ABS(MINL3.47 <= L50 OR L50 >= MINL3.51) * (ABS(MINL3.48 > L51 AND L51 < MINL3.52) * L51 + ABS(MINL3.48 <= L51 OR L51 >= MINL3.52) * (ABS(MINL3.49 > L52 AND L52 < MINL3.53) * L52 + ABS(MINL3.49 <= L52 OR L52 >= MINL3.53) * (ABS(MINL3.50 > L53 AND L53 < MINL3.54) * L53 + ABS(MINL3.50 <= L53 OR L53 >= MINL3.54) * (ABS(MINL3.51 > L54 AND L54 < MINL3.55) * L54 + ABS(MINL3.51 <= L54 OR L54 >= MINL3.55) * (ABS(MINL3.52 > L55 AND L55 < MINL3.56) * L55 + ABS(MINL3.52 <= L55 OR L55 >= MINL3.56) * (ABS(MINL3.53 > L56 AND L56 < MINL3.57) * L56 + ABS(MINL3.53 <= L56 OR L56 >= MINL3.57) * (ABS(MINL3.54 > L57 AND L57 < MINL3.58) * L57 + ABS(MINL3.54 <= L57 OR L57 >= MINL3.58) * (ABS(MINL3.55 > L58 AND L58 < MINL3.59) * L58 + ABS(MINL3.55 <= L58 OR L58 >= MINL3.59) * (ABS(MINL3.56 > L59 AND L59 < MINL3.60) * L59 + ABS(MINL3.56 <= L59 OR L59 >= MINL3.60) * (ABS(MINL3.57 > L60 AND L60 < MINL3.61) * L60 + ABS(MINL3.57 <= L60 OR L60 >= MINL3.61) * (ABS(MINL3.58 > L61 AND L61 < MINL3.62) * L61 + ABS(MINL3.58 <= L61 OR L61 >= MINL3.62) * (ABS(MINL3.59 > L62 AND L62 < MINL3.63) * L62 + ABS(MINL3.59 <= L62 OR L62 >= MINL3.63) * MINL63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
100 * ((ABS(MAXH3 < H3 AND H3 > MAXH3.4) * H3 + ABS(MAXH3 >= H3 OR H3 <= MAXH3.4) * (ABS(MAXH3.1 < H4 AND H4 > MAXH3.5) * H4 + ABS(MAXH3.1 >= H4 OR H4 <= MAXH3.5) * (ABS(MAXH3.2 < H5 AND H5 > MAXH3.6) * H5 + ABS(MAXH3.2 >= H5 OR H5 <= MAXH3.6) * (ABS(MAXH3.3 < H6 AND H6 > MAXH3.7) * H6 + ABS(MAXH3.3 >= H6 OR H6 <= MAXH3.7) * (ABS(MAXH3.4 < H7 AND H7 > MAXH3.8) * H7 + ABS(MAXH3.4 >= H7 OR H7 <= MAXH3.8) * (ABS(MAXH3.5 < H8 AND H8 > MAXH3.9) * H8 + ABS(MAXH3.5 >= H8 OR H8 <= MAXH3.9) * (ABS(MAXH3.6 < H9 AND H9 > MAXH3.10) * H9 + ABS(MAXH3.6 >= H9 OR H9 <= MAXH3.10) * (ABS(MAXH3.7 < H10 AND H10 > MAXH3.11) * H10 + ABS(MAXH3.7 >= H10 OR H10 <= MAXH3.11) * (ABS(MAXH3.8 < H11 AND H11 > MAXH3.12) * H11 + ABS(MAXH3.8 >= H11 OR H11 <= MAXH3.12) * (ABS(MAXH3.9 < H12 AND H12 > MAXH3.13) * H12 + ABS(MAXH3.9 >= H12 OR H12 <= MAXH3.13) * (ABS(MAXH3.10 < H13 AND H13 > MAXH3.14) * H13 + ABS(MAXH3.10 >= H13 OR H13 <= MAXH3.14) * (ABS(MAXH3.11 < H14 AND H14 > MAXH3.15) * H14 + ABS(MAXH3.11 >= H14 OR H14 <= MAXH3.15) * (ABS(MAXH3.12 < H15 AND H15 > MAXH3.16) * H15 + ABS(MAXH3.12 >= H15 OR H15 <= MAXH3.16) * (ABS(MAXH3.13 < H16 AND H16 > MAXH3.17) * H16 + ABS(MAXH3.13 >= H16 OR H16 <= MAXH3.17) * (ABS(MAXH3.14 < H17 AND H17 > MAXH3.18) * H17 + ABS(MAXH3.14 >= H17 OR H17 <= MAXH3.18) * (ABS(MAXH3.15 < H18 AND H18 > MAXH3.19) * H18 + ABS(MAXH3.15 >= H18 OR H18 <= MAXH3.19) * (ABS(MAXH3.16 < H19 AND H19 > MAXH3.20) * H19 + ABS(MAXH3.16 >= H19 OR H19 <= MAXH3.20) * (ABS(MAXH3.17 < H20 AND H20 > MAXH3.21) * H20 + ABS(MAXH3.17 >= H20 OR H20 <= MAXH3.21) * (ABS(MAXH3.18 < H21 AND H21 > MAXH3.22) * H21 + ABS(MAXH3.18 >= H21 OR H21 <= MAXH3.22) * (ABS(MAXH3.19 < H22 AND H22 > MAXH3.23) * H22 + ABS(MAXH3.19 >= H22 OR H22 <= MAXH3.23) * (ABS(MAXH3.20 < H23 AND H23 > MAXH3.24) * H23 + ABS(MAXH3.20 >= H23 OR H23 <= MAXH3.24) * (ABS(MAXH3.21 < H24 AND H24 > MAXH3.25) * H24 + ABS(MAXH3.21 >= H24 OR H24 <= MAXH3.25) * (ABS(MAXH3.22 < H25 AND H25 > MAXH3.26) * H25 + ABS(MAXH3.22 >= H25 OR H25 <= MAXH3.26) * (ABS(MAXH3.23 < H26 AND H26 > MAXH3.27) * H26 + ABS(MAXH3.23 >= H26 OR H26 <= MAXH3.27) * (ABS(MAXH3.24 < H27 AND H27 > MAXH3.28) * H27 + ABS(MAXH3.24 >= H27 OR H27 <= MAXH3.28) * (ABS(MAXH3.25 < H28 AND H28 > MAXH3.29) * H28 + ABS(MAXH3.25 >= H28 OR H28 <= MAXH3.29) * (ABS(MAXH3.26 < H29 AND H29 > MAXH3.30) * H29 + ABS(MAXH3.26 >= H29 OR H29 <= MAXH3.30) * (ABS(MAXH3.27 < H30 AND H30 > MAXH3.31) * H30 + ABS(MAXH3.27 >= H30 OR H30 <= MAXH3.31) * (ABS(MAXH3.28 < H31 AND H31 > MAXH3.32) * H31 + ABS(MAXH3.28 >= H31 OR H31 <= MAXH3.32) * (ABS(MAXH3.29 < H32 AND H32 > MAXH3.33) * H32 + ABS(MAXH3.29 >= H32 OR H32 <= MAXH3.33) * (ABS(MAXH3.30 < H33 AND H33 > MAXH3.34) * H33 + ABS(MAXH3.30 >= H33 OR H33 <= MAXH3.34) * (ABS(MAXH3.31 < H34 AND H34 > MAXH3.35) * H34 + ABS(MAXH3.31 >= H34 OR H34 <= MAXH3.35) * (ABS(MAXH3.32 < H35 AND H35 > MAXH3.36) * H35 + ABS(MAXH3.32 >= H35 OR H35 <= MAXH3.36) * (ABS(MAXH3.33 < H36 AND H36 > MAXH3.37) * H36 + ABS(MAXH3.33 >= H36 OR H36 <= MAXH3.37) * (ABS(MAXH3.34 < H37 AND H37 > MAXH3.38) * H37 + ABS(MAXH3.34 >= H37 OR H37 <= MAXH3.38) * (ABS(MAXH3.35 < H38 AND H38 > MAXH3.39) * H38 + ABS(MAXH3.35 >= H38 OR H38 <= MAXH3.39) * (ABS(MAXH3.36 < H39 AND H39 > MAXH3.40) * H39 + ABS(MAXH3.36 >= H39 OR H39 <= MAXH3.40) * (ABS(MAXH3.37 < H40 AND H40 > MAXH3.41) * H40 + ABS(MAXH3.37 >= H40 OR H40 <= MAXH3.41) * (ABS(MAXH3.38 < H41 AND H41 > MAXH3.42) * H41 + ABS(MAXH3.38 >= H41 OR H41 <= MAXH3.42) * (ABS(MAXH3.39 < H42 AND H42 > MAXH3.43) * H42 + ABS(MAXH3.39 >= H42 OR H42 <= MAXH3.43) * (ABS(MAXH3.40 < H43 AND H43 > MAXH3.44) * H43 + ABS(MAXH3.40 >= H43 OR H43 <= MAXH3.44) * (ABS(MAXH3.41 < H44 AND H44 > MAXH3.45) * H44 + ABS(MAXH3.41 >= H44 OR H44 <= MAXH3.45) * (ABS(MAXH3.42 < H45 AND H45 > MAXH3.46) * H45 + ABS(MAXH3.42 >= H45 OR H45 <= MAXH3.46) * (ABS(MAXH3.43 < H46 AND H46 > MAXH3.47) * H46 + ABS(MAXH3.43 >= H46 OR H46 <= MAXH3.47) * (ABS(MAXH3.44 < H47 AND H47 > MAXH3.48) * H47 + ABS(MAXH3.44 >= H47 OR H47 <= MAXH3.48) * (ABS(MAXH3.45 < H48 AND H48 > MAXH3.49) * H48 + ABS(MAXH3.45 >= H48 OR H48 <= MAXH3.49) * (ABS(MAXH3.46 < H49 AND H49 > MAXH3.50) * H49 + ABS(MAXH3.46 >= H49 OR H49 <= MAXH3.50) * (ABS(MAXH3.47 < H50 AND H50 > MAXH3.51) * H50 + ABS(MAXH3.47 >= H50 OR H50 <= MAXH3.51) * (ABS(MAXH3.48 < H51 AND H51 > MAXH3.52) * H51 + ABS(MAXH3.48 >= H51 OR H51 <= MAXH3.52) * (ABS(MAXH3.49 < H52 AND H52 > MAXH3.53) * H52 + ABS(MAXH3.49 >= H52 OR H52 <= MAXH3.53) * (ABS(MAXH3.50 < H53 AND H53 > MAXH3.54) * H53 + ABS(MAXH3.50 >= H53 OR H53 <= MAXH3.54) * (ABS(MAXH3.51 < H54 AND H54 > MAXH3.55) * H54 + ABS(MAXH3.51 >= H54 OR H54 <= MAXH3.55) * (ABS(MAXH3.52 < H55 AND H55 > MAXH3.56) * H55 + ABS(MAXH3.52 >= H55 OR H55 <= MAXH3.56) * (ABS(MAXH3.53 < H56 AND H56 > MAXH3.57) * H56 + ABS(MAXH3.53 >= H56 OR H56 <= MAXH3.57) * (ABS(MAXH3.54 < H57 AND H57 > MAXH3.58) * H57 + ABS(MAXH3.54 >= H57 OR H57 <= MAXH3.58) * (ABS(MAXH3.55 < H58 AND H58 > MAXH3.59) * H58 + ABS(MAXH3.55 >= H58 OR H58 <= MAXH3.59) * (ABS(MAXH3.56 < H59 AND H59 > MAXH3.60) * H59 + ABS(MAXH3.56 >= H59 OR H59 <= MAXH3.60) * (ABS(MAXH3.57 < H60 AND H60 > MAXH3.61) * H60 + ABS(MAXH3.57 >= H60 OR H60 <= MAXH3.61) * (ABS(MAXH3.58 < H61 AND H61 > MAXH3.62) * H61 + ABS(MAXH3.58 >= H61 OR H61 <= MAXH3.62) * (ABS(MAXH3.59 < H62 AND H62 > MAXH3.63) * H62 + ABS(MAXH3.59 >= H62 OR H62 <= MAXH3.63) * MAXH63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(MINL3 > L3 AND L3 < MINL3.4) * L3 + ABS(MINL3 <= L3 OR L3 >= MINL3.4) * (ABS(MINL3.1 > L4 AND L4 < MINL3.5) * L4 + ABS(MINL3.1 <= L4 OR L4 >= MINL3.5) * (ABS(MINL3.2 > L5 AND L5 < MINL3.6) * L5 + ABS(MINL3.2 <= L5 OR L5 >= MINL3.6) * (ABS(MINL3.3 > L6 AND L6 < MINL3.7) * L6 + ABS(MINL3.3 <= L6 OR L6 >= MINL3.7) * (ABS(MINL3.4 > L7 AND L7 < MINL3.8) * L7 + ABS(MINL3.4 <= L7 OR L7 >= MINL3.8) * (ABS(MINL3.5 > L8 AND L8 < MINL3.9) * L8 + ABS(MINL3.5 <= L8 OR L8 >= MINL3.9) * (ABS(MINL3.6 > L9 AND L9 < MINL3.10) * L9 + ABS(MINL3.6 <= L9 OR L9 >= MINL3.10) * (ABS(MINL3.7 > L10 AND L10 < MINL3.11) * L10 + ABS(MINL3.7 <= L10 OR L10 >= MINL3.11) * (ABS(MINL3.8 > L11 AND L11 < MINL3.12) * L11 + ABS(MINL3.8 <= L11 OR L11 >= MINL3.12) * (ABS(MINL3.9 > L12 AND L12 < MINL3.13) * L12 + ABS(MINL3.9 <= L12 OR L12 >= MINL3.13) * (ABS(MINL3.10 > L13 AND L13 < MINL3.14) * L13 + ABS(MINL3.10 <= L13 OR L13 >= MINL3.14) * (ABS(MINL3.11 > L14 AND L14 < MINL3.15) * L14 + ABS(MINL3.11 <= L14 OR L14 >= MINL3.15) * (ABS(MINL3.12 > L15 AND L15 < MINL3.16) * L15 + ABS(MINL3.12 <= L15 OR L15 >= MINL3.16) * (ABS(MINL3.13 > L16 AND L16 < MINL3.17) * L16 + ABS(MINL3.13 <= L16 OR L16 >= MINL3.17) * (ABS(MINL3.14 > L17 AND L17 < MINL3.18) * L17 + ABS(MINL3.14 <= L17 OR L17 >= MINL3.18) * (ABS(MINL3.15 > L18 AND L18 < MINL3.19) * L18 + ABS(MINL3.15 <= L18 OR L18 >= MINL3.19) * (ABS(MINL3.16 > L19 AND L19 < MINL3.20) * L19 + ABS(MINL3.16 <= L19 OR L19 >= MINL3.20) * (ABS(MINL3.17 > L20 AND L20 < MINL3.21) * L20 + ABS(MINL3.17 <= L20 OR L20 >= MINL3.21) * (ABS(MINL3.18 > L21 AND L21 < MINL3.22) * L21 + ABS(MINL3.18 <= L21 OR L21 >= MINL3.22) * (ABS(MINL3.19 > L22 AND L22 < MINL3.23) * L22 + ABS(MINL3.19 <= L22 OR L22 >= MINL3.23) * (ABS(MINL3.20 > L23 AND L23 < MINL3.24) * L23 + ABS(MINL3.20 <= L23 OR L23 >= MINL3.24) * (ABS(MINL3.21 > L24 AND L24 < MINL3.25) * L24 + ABS(MINL3.21 <= L24 OR L24 >= MINL3.25) * (ABS(MINL3.22 > L25 AND L25 < MINL3.26) * L25 + ABS(MINL3.22 <= L25 OR L25 >= MINL3.26) * (ABS(MINL3.23 > L26 AND L26 < MINL3.27) * L26 + ABS(MINL3.23 <= L26 OR L26 >= MINL3.27) * (ABS(MINL3.24 > L27 AND L27 < MINL3.28) * L27 + ABS(MINL3.24 <= L27 OR L27 >= MINL3.28) * (ABS(MINL3.25 > L28 AND L28 < MINL3.29) * L28 + ABS(MINL3.25 <= L28 OR L28 >= MINL3.29) * (ABS(MINL3.26 > L29 AND L29 < MINL3.30) * L29 + ABS(MINL3.26 <= L29 OR L29 >= MINL3.30) * (ABS(MINL3.27 > L30 AND L30 < MINL3.31) * L30 + ABS(MINL3.27 <= L30 OR L30 >= MINL3.31) * (ABS(MINL3.28 > L31 AND L31 < MINL3.32) * L31 + ABS(MINL3.28 <= L31 OR L31 >= MINL3.32) * (ABS(MINL3.29 > L32 AND L32 < MINL3.33) * L32 + ABS(MINL3.29 <= L32 OR L32 >= MINL3.33) * (ABS(MINL3.30 > L33 AND L33 < MINL3.34) * L33 + ABS(MINL3.30 <= L33 OR L33 >= MINL3.34) * (ABS(MINL3.31 > L34 AND L34 < MINL3.35) * L34 + ABS(MINL3.31 <= L34 OR L34 >= MINL3.35) * (ABS(MINL3.32 > L35 AND L35 < MINL3.36) * L35 + ABS(MINL3.32 <= L35 OR L35 >= MINL3.36) * (ABS(MINL3.33 > L36 AND L36 < MINL3.37) * L36 + ABS(MINL3.33 <= L36 OR L36 >= MINL3.37) * (ABS(MINL3.34 > L37 AND L37 < MINL3.38) * L37 + ABS(MINL3.34 <= L37 OR L37 >= MINL3.38) * (ABS(MINL3.35 > L38 AND L38 < MINL3.39) * L38 + ABS(MINL3.35 <= L38 OR L38 >= MINL3.39) * (ABS(MINL3.36 > L39 AND L39 < MINL3.40) * L39 + ABS(MINL3.36 <= L39 OR L39 >= MINL3.40) * (ABS(MINL3.37 > L40 AND L40 < MINL3.41) * L40 + ABS(MINL3.37 <= L40 OR L40 >= MINL3.41) * (ABS(MINL3.38 > L41 AND L41 < MINL3.42) * L41 + ABS(MINL3.38 <= L41 OR L41 >= MINL3.42) * (ABS(MINL3.39 > L42 AND L42 < MINL3.43) * L42 + ABS(MINL3.39 <= L42 OR L42 >= MINL3.43) * (ABS(MINL3.40 > L43 AND L43 < MINL3.44) * L43 + ABS(MINL3.40 <= L43 OR L43 >= MINL3.44) * (ABS(MINL3.41 > L44 AND L44 < MINL3.45) * L44 + ABS(MINL3.41 <= L44 OR L44 >= MINL3.45) * (ABS(MINL3.42 > L45 AND L45 < MINL3.46) * L45 + ABS(MINL3.42 <= L45 OR L45 >= MINL3.46) * (ABS(MINL3.43 > L46 AND L46 < MINL3.47) * L46 + ABS(MINL3.43 <= L46 OR L46 >= MINL3.47) * (ABS(MINL3.44 > L47 AND L47 < MINL3.48) * L47 + ABS(MINL3.44 <= L47 OR L47 >= MINL3.48) * (ABS(MINL3.45 > L48 AND L48 < MINL3.49) * L48 + ABS(MINL3.45 <= L48 OR L48 >= MINL3.49) * (ABS(MINL3.46 > L49 AND L49 < MINL3.50) * L49 + ABS(MINL3.46 <= L49 OR L49 >= MINL3.50) * (ABS(MINL3.47 > L50 AND L50 < MINL3.51) * L50 + ABS(MINL3.47 <= L50 OR L50 >= MINL3.51) * (ABS(MINL3.48 > L51 AND L51 < MINL3.52) * L51 + ABS(MINL3.48 <= L51 OR L51 >= MINL3.52) * (ABS(MINL3.49 > L52 AND L52 < MINL3.53) * L52 + ABS(MINL3.49 <= L52 OR L52 >= MINL3.53) * (ABS(MINL3.50 > L53 AND L53 < MINL3.54) * L53 + ABS(MINL3.50 <= L53 OR L53 >= MINL3.54) * (ABS(MINL3.51 > L54 AND L54 < MINL3.55) * L54 + ABS(MINL3.51 <= L54 OR L54 >= MINL3.55) * (ABS(MINL3.52 > L55 AND L55 < MINL3.56) * L55 + ABS(MINL3.52 <= L55 OR L55 >= MINL3.56) * (ABS(MINL3.53 > L56 AND L56 < MINL3.57) * L56 + ABS(MINL3.53 <= L56 OR L56 >= MINL3.57) * (ABS(MINL3.54 > L57 AND L57 < MINL3.58) * L57 + ABS(MINL3.54 <= L57 OR L57 >= MINL3.58) * (ABS(MINL3.55 > L58 AND L58 < MINL3.59) * L58 + ABS(MINL3.55 <= L58 OR L58 >= MINL3.59) * (ABS(MINL3.56 > L59 AND L59 < MINL3.60) * L59 + ABS(MINL3.56 <= L59 OR L59 >= MINL3.60) * (ABS(MINL3.57 > L60 AND L60 < MINL3.61) * L60 + ABS(MINL3.57 <= L60 OR L60 >= MINL3.61) * (ABS(MINL3.58 > L61 AND L61 < MINL3.62) * L61 + ABS(MINL3.58 <= L61 OR L61 >= MINL3.62) * (ABS(MINL3.59 > L62 AND L62 < MINL3.63) * L62 + ABS(MINL3.59 <= L62 OR L62 >= MINL3.63) * MINL63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 3/10/2012 Posts: 465
|
Thank you Bruce
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|