Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

PCF for CCI Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
haseo
Posted : Friday, October 10, 2014 3:20:28 AM
Registered User
Joined: 9/5/2012
Posts: 59

I need help with 2 PCFs.

1. CCI(21) is greater than CCI(100) and the difference is less than 100.

2. CCI(21) is lesser than CCI(100) and the differences between them is also less than 100.

 

Bruce_L
Posted : Friday, October 10, 2014 9:36:45 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

QUOTE (haseo)
1. CCI(21) is greater than CCI(100) and the difference is less than 100.

CCI INDICATOR

ABS((H + L + C - AVGH21 - AVGL21 - AVGC21) * 4200 / 3 / (ABS(H + L + C - AVGH21 - AVGL21 - AVGC21) + ABS(H1 + L1 + C1 - AVGH21 - AVGL21 - AVGC21) + ABS(H2 + L2 + C2 - AVGH21 - AVGL21 - AVGC21) + ABS(H3 + L3 + C3 - AVGH21 - AVGL21 - AVGC21) + ABS(H4 + L4 + C4 - AVGH21 - AVGL21 - AVGC21) + ABS(H5 + L5 + C5 - AVGH21 - AVGL21 - AVGC21) + ABS(H6 + L6 + C6 - AVGH21 - AVGL21 - AVGC21) + ABS(H7 + L7 + C7 - AVGH21 - AVGL21 - AVGC21) + ABS(H8 + L8 + C8 - AVGH21 - AVGL21 - AVGC21) + ABS(H9 + L9 + C9 - AVGH21 - AVGL21 - AVGC21) + ABS(H10 + L10 + C10 - AVGH21 - AVGL21 - AVGC21) + ABS(H11 + L11 + C11 - AVGH21 - AVGL21 - AVGC21) + ABS(H12 + L12 + C12 - AVGH21 - AVGL21 - AVGC21) + ABS(H13 + L13 + C13 - AVGH21 - AVGL21 - AVGC21) + ABS(H14 + L14 + C14 - AVGH21 - AVGL21 - AVGC21) + ABS(H15 + L15 + C15 - AVGH21 - AVGL21 - AVGC21) + ABS(H16 + L16 + C16 - AVGH21 - AVGL21 - AVGC21) + ABS(H17 + L17 + C17 - AVGH21 - AVGL21 - AVGC21) + ABS(H18 + L18 + C18 - AVGH21 - AVGL21 - AVGC21) + ABS(H19 + L19 + C19 - AVGH21 - AVGL21 - AVGC21) + ABS(H20 + L20 + C20 - AVGH21 - AVGL21 - AVGC21) + .000001) - (H + L + C - AVGH100 - AVGL100 - AVGC100) * 20000 / 3 / (ABS(H + L + C - AVGH100 - AVGL100 - AVGC100) + ABS(H1 + L1 + C1 - AVGH100 - AVGL100 - AVGC100) + ABS(H2 + L2 + C2 - AVGH100 - AVGL100 - AVGC100) + ABS(H3 + L3 + C3 - AVGH100 - AVGL100 - AVGC100) + ABS(H4 + L4 + C4 - AVGH100 - AVGL100 - AVGC100) + ABS(H5 + L5 + C5 - AVGH100 - AVGL100 - AVGC100) + ABS(H6 + L6 + C6 - AVGH100 - AVGL100 - AVGC100) + ABS(H7 + L7 + C7 - AVGH100 - AVGL100 - AVGC100) + ABS(H8 + L8 + C8 - AVGH100 - AVGL100 - AVGC100) + ABS(H9 + L9 + C9 - AVGH100 - AVGL100 - AVGC100) + ABS(H10 + L10 + C10 - AVGH100 - AVGL100 - AVGC100) + ABS(H11 + L11 + C11 - AVGH100 - AVGL100 - AVGC100) + ABS(H12 + L12 + C12 - AVGH100 - AVGL100 - AVGC100) + ABS(H13 + L13 + C13 - AVGH100 - AVGL100 - AVGC100) + ABS(H14 + L14 + C14 - AVGH100 - AVGL100 - AVGC100) + ABS(H15 + L15 + C15 - AVGH100 - AVGL100 - AVGC100) + ABS(H16 + L16 + C16 - AVGH100 - AVGL100 - AVGC100) + ABS(H17 + L17 + C17 - AVGH100 - AVGL100 - AVGC100) + ABS(H18 + L18 + C18 - AVGH100 - AVGL100 - AVGC100) + ABS(H19 + L19 + C19 - AVGH100 - AVGL100 - AVGC100) + ABS(H20 + L20 + C20 - AVGH100 - AVGL100 - AVGC100) + ABS(H21 + L21 + C21 - AVGH100 - AVGL100 - AVGC100) + ABS(H22 + L22 + C22 - AVGH100 - AVGL100 - AVGC100) + ABS(H23 + L23 + C23 - AVGH100 - AVGL100 - AVGC100) + ABS(H24 + L24 + C24 - AVGH100 - AVGL100 - AVGC100) + ABS(H25 + L25 + C25 - AVGH100 - AVGL100 - AVGC100) + ABS(H26 + L26 + C26 - AVGH100 - AVGL100 - AVGC100) + ABS(H27 + L27 + C27 - AVGH100 - AVGL100 - AVGC100) + ABS(H28 + L28 + C28 - AVGH100 - AVGL100 - AVGC100) + ABS(H29 + L29 + C29 - AVGH100 - AVGL100 - AVGC100) + ABS(H30 + L30 + C30 - AVGH100 - AVGL100 - AVGC100) + ABS(H31 + L31 + C31 - AVGH100 - AVGL100 - AVGC100) + ABS(H32 + L32 + C32 - AVGH100 - AVGL100 - AVGC100) + ABS(H33 + L33 + C33 - AVGH100 - AVGL100 - AVGC100) + ABS(H34 + L34 + C34 - AVGH100 - AVGL100 - AVGC100) + ABS(H35 + L35 + C35 - AVGH100 - AVGL100 - AVGC100) + ABS(H36 + L36 + C36 - AVGH100 - AVGL100 - AVGC100) + ABS(H37 + L37 + C37 - AVGH100 - AVGL100 - AVGC100) + ABS(H38 + L38 + C38 - AVGH100 - AVGL100 - AVGC100) + ABS(H39 + L39 + C39 - AVGH100 - AVGL100 - AVGC100) + ABS(H40 + L40 + C40 - AVGH100 - AVGL100 - AVGC100) + ABS(H41 + L41 + C41 - AVGH100 - AVGL100 - AVGC100) + ABS(H42 + L42 + C42 - AVGH100 - AVGL100 - AVGC100) + ABS(H43 + L43 + C43 - AVGH100 - AVGL100 - AVGC100) + ABS(H44 + L44 + C44 - AVGH100 - AVGL100 - AVGC100) + ABS(H45 + L45 + C45 - AVGH100 - AVGL100 - AVGC100) + ABS(H46 + L46 + C46 - AVGH100 - AVGL100 - AVGC100) + ABS(H47 + L47 + C47 - AVGH100 - AVGL100 - AVGC100) + ABS(H48 + L48 + C48 - AVGH100 - AVGL100 - AVGC100) + ABS(H49 + L49 + C49 - AVGH100 - AVGL100 - AVGC100) + ABS(H50 + L50 + C50 - AVGH100 - AVGL100 - AVGC100) + ABS(H51 + L51 + C51 - AVGH100 - AVGL100 - AVGC100) + ABS(H52 + L52 + C52 - AVGH100 - AVGL100 - AVGC100) + ABS(H53 + L53 + C53 - AVGH100 - AVGL100 - AVGC100) + ABS(H54 + L54 + C54 - AVGH100 - AVGL100 - AVGC100) + ABS(H55 + L55 + C55 - AVGH100 - AVGL100 - AVGC100) + ABS(H56 + L56 + C56 - AVGH100 - AVGL100 - AVGC100) + ABS(H57 + L57 + C57 - AVGH100 - AVGL100 - AVGC100) + ABS(H58 + L58 + C58 - AVGH100 - AVGL100 - AVGC100) + ABS(H59 + L59 + C59 - AVGH100 - AVGL100 - AVGC100) + ABS(H60 + L60 + C60 - AVGH100 - AVGL100 - AVGC100) + ABS(H61 + L61 + C61 - AVGH100 - AVGL100 - AVGC100) + ABS(H62 + L62 + C62 - AVGH100 - AVGL100 - AVGC100) + ABS(H63 + L63 + C63 - AVGH100 - AVGL100 - AVGC100) + ABS(H64 + L64 + C64 - AVGH100 - AVGL100 - AVGC100) + ABS(H65 + L65 + C65 - AVGH100 - AVGL100 - AVGC100) + ABS(H66 + L66 + C66 - AVGH100 - AVGL100 - AVGC100) + ABS(H67 + L67 + C67 - AVGH100 - AVGL100 - AVGC100) + ABS(H68 + L68 + C68 - AVGH100 - AVGL100 - AVGC100) + ABS(H69 + L69 + C69 - AVGH100 - AVGL100 - AVGC100) + ABS(H70 + L70 + C70 - AVGH100 - AVGL100 - AVGC100) + ABS(H71 + L71 + C71 - AVGH100 - AVGL100 - AVGC100) + ABS(H72 + L72 + C72 - AVGH100 - AVGL100 - AVGC100) + ABS(H73 + L73 + C73 - AVGH100 - AVGL100 - AVGC100) + ABS(H74 + L74 + C74 - AVGH100 - AVGL100 - AVGC100) + ABS(H75 + L75 + C75 - AVGH100 - AVGL100 - AVGC100) + ABS(H76 + L76 + C76 - AVGH100 - AVGL100 - AVGC100) + ABS(H77 + L77 + C77 - AVGH100 - AVGL100 - AVGC100) + ABS(H78 + L78 + C78 - AVGH100 - AVGL100 - AVGC100) + ABS(H79 + L79 + C79 - AVGH100 - AVGL100 - AVGC100) + ABS(H80 + L80 + C80 - AVGH100 - AVGL100 - AVGC100) + ABS(H81 + L81 + C81 - AVGH100 - AVGL100 - AVGC100) + ABS(H82 + L82 + C82 - AVGH100 - AVGL100 - AVGC100) + ABS(H83 + L83 + C83 - AVGH100 - AVGL100 - AVGC100) + ABS(H84 + L84 + C84 - AVGH100 - AVGL100 - AVGC100) + ABS(H85 + L85 + C85 - AVGH100 - AVGL100 - AVGC100) + ABS(H86 + L86 + C86 - AVGH100 - AVGL100 - AVGC100) + ABS(H87 + L87 + C87 - AVGH100 - AVGL100 - AVGC100) + ABS(H88 + L88 + C88 - AVGH100 - AVGL100 - AVGC100) + ABS(H89 + L89 + C89 - AVGH100 - AVGL100 - AVGC100) + ABS(H90 + L90 + C90 - AVGH100 - AVGL100 - AVGC100) + ABS(H91 + L91 + C91 - AVGH100 - AVGL100 - AVGC100) + ABS(H92 + L92 + C92 - AVGH100 - AVGL100 - AVGC100) + ABS(H93 + L93 + C93 - AVGH100 - AVGL100 - AVGC100) + ABS(H94 + L94 + C94 - AVGH100 - AVGL100 - AVGC100) + ABS(H95 + L95 + C95 - AVGH100 - AVGL100 - AVGC100) + ABS(H96 + L96 + C96 - AVGH100 - AVGL100 - AVGC100) + ABS(H97 + L97 + C97 - AVGH100 - AVGL100 - AVGC100) + ABS(H98 + L98 + C98 - AVGH100 - AVGL100 - AVGC100) + ABS(H99 + L99 + C99 - AVGH100 - AVGL100 - AVGC100) + .000001) - 50) < 50

QUOTE (haseo)
2. CCI(21) is lesser than CCI(100) and the differences between them is also less than 100.

ABS((H + L + C - AVGH21 - AVGL21 - AVGC21) * 4200 / 3 / (ABS(H + L + C - AVGH21 - AVGL21 - AVGC21) + ABS(H1 + L1 + C1 - AVGH21 - AVGL21 - AVGC21) + ABS(H2 + L2 + C2 - AVGH21 - AVGL21 - AVGC21) + ABS(H3 + L3 + C3 - AVGH21 - AVGL21 - AVGC21) + ABS(H4 + L4 + C4 - AVGH21 - AVGL21 - AVGC21) + ABS(H5 + L5 + C5 - AVGH21 - AVGL21 - AVGC21) + ABS(H6 + L6 + C6 - AVGH21 - AVGL21 - AVGC21) + ABS(H7 + L7 + C7 - AVGH21 - AVGL21 - AVGC21) + ABS(H8 + L8 + C8 - AVGH21 - AVGL21 - AVGC21) + ABS(H9 + L9 + C9 - AVGH21 - AVGL21 - AVGC21) + ABS(H10 + L10 + C10 - AVGH21 - AVGL21 - AVGC21) + ABS(H11 + L11 + C11 - AVGH21 - AVGL21 - AVGC21) + ABS(H12 + L12 + C12 - AVGH21 - AVGL21 - AVGC21) + ABS(H13 + L13 + C13 - AVGH21 - AVGL21 - AVGC21) + ABS(H14 + L14 + C14 - AVGH21 - AVGL21 - AVGC21) + ABS(H15 + L15 + C15 - AVGH21 - AVGL21 - AVGC21) + ABS(H16 + L16 + C16 - AVGH21 - AVGL21 - AVGC21) + ABS(H17 + L17 + C17 - AVGH21 - AVGL21 - AVGC21) + ABS(H18 + L18 + C18 - AVGH21 - AVGL21 - AVGC21) + ABS(H19 + L19 + C19 - AVGH21 - AVGL21 - AVGC21) + ABS(H20 + L20 + C20 - AVGH21 - AVGL21 - AVGC21) + .000001) - (H + L + C - AVGH100 - AVGL100 - AVGC100) * 20000 / 3 / (ABS(H + L + C - AVGH100 - AVGL100 - AVGC100) + ABS(H1 + L1 + C1 - AVGH100 - AVGL100 - AVGC100) + ABS(H2 + L2 + C2 - AVGH100 - AVGL100 - AVGC100) + ABS(H3 + L3 + C3 - AVGH100 - AVGL100 - AVGC100) + ABS(H4 + L4 + C4 - AVGH100 - AVGL100 - AVGC100) + ABS(H5 + L5 + C5 - AVGH100 - AVGL100 - AVGC100) + ABS(H6 + L6 + C6 - AVGH100 - AVGL100 - AVGC100) + ABS(H7 + L7 + C7 - AVGH100 - AVGL100 - AVGC100) + ABS(H8 + L8 + C8 - AVGH100 - AVGL100 - AVGC100) + ABS(H9 + L9 + C9 - AVGH100 - AVGL100 - AVGC100) + ABS(H10 + L10 + C10 - AVGH100 - AVGL100 - AVGC100) + ABS(H11 + L11 + C11 - AVGH100 - AVGL100 - AVGC100) + ABS(H12 + L12 + C12 - AVGH100 - AVGL100 - AVGC100) + ABS(H13 + L13 + C13 - AVGH100 - AVGL100 - AVGC100) + ABS(H14 + L14 + C14 - AVGH100 - AVGL100 - AVGC100) + ABS(H15 + L15 + C15 - AVGH100 - AVGL100 - AVGC100) + ABS(H16 + L16 + C16 - AVGH100 - AVGL100 - AVGC100) + ABS(H17 + L17 + C17 - AVGH100 - AVGL100 - AVGC100) + ABS(H18 + L18 + C18 - AVGH100 - AVGL100 - AVGC100) + ABS(H19 + L19 + C19 - AVGH100 - AVGL100 - AVGC100) + ABS(H20 + L20 + C20 - AVGH100 - AVGL100 - AVGC100) + ABS(H21 + L21 + C21 - AVGH100 - AVGL100 - AVGC100) + ABS(H22 + L22 + C22 - AVGH100 - AVGL100 - AVGC100) + ABS(H23 + L23 + C23 - AVGH100 - AVGL100 - AVGC100) + ABS(H24 + L24 + C24 - AVGH100 - AVGL100 - AVGC100) + ABS(H25 + L25 + C25 - AVGH100 - AVGL100 - AVGC100) + ABS(H26 + L26 + C26 - AVGH100 - AVGL100 - AVGC100) + ABS(H27 + L27 + C27 - AVGH100 - AVGL100 - AVGC100) + ABS(H28 + L28 + C28 - AVGH100 - AVGL100 - AVGC100) + ABS(H29 + L29 + C29 - AVGH100 - AVGL100 - AVGC100) + ABS(H30 + L30 + C30 - AVGH100 - AVGL100 - AVGC100) + ABS(H31 + L31 + C31 - AVGH100 - AVGL100 - AVGC100) + ABS(H32 + L32 + C32 - AVGH100 - AVGL100 - AVGC100) + ABS(H33 + L33 + C33 - AVGH100 - AVGL100 - AVGC100) + ABS(H34 + L34 + C34 - AVGH100 - AVGL100 - AVGC100) + ABS(H35 + L35 + C35 - AVGH100 - AVGL100 - AVGC100) + ABS(H36 + L36 + C36 - AVGH100 - AVGL100 - AVGC100) + ABS(H37 + L37 + C37 - AVGH100 - AVGL100 - AVGC100) + ABS(H38 + L38 + C38 - AVGH100 - AVGL100 - AVGC100) + ABS(H39 + L39 + C39 - AVGH100 - AVGL100 - AVGC100) + ABS(H40 + L40 + C40 - AVGH100 - AVGL100 - AVGC100) + ABS(H41 + L41 + C41 - AVGH100 - AVGL100 - AVGC100) + ABS(H42 + L42 + C42 - AVGH100 - AVGL100 - AVGC100) + ABS(H43 + L43 + C43 - AVGH100 - AVGL100 - AVGC100) + ABS(H44 + L44 + C44 - AVGH100 - AVGL100 - AVGC100) + ABS(H45 + L45 + C45 - AVGH100 - AVGL100 - AVGC100) + ABS(H46 + L46 + C46 - AVGH100 - AVGL100 - AVGC100) + ABS(H47 + L47 + C47 - AVGH100 - AVGL100 - AVGC100) + ABS(H48 + L48 + C48 - AVGH100 - AVGL100 - AVGC100) + ABS(H49 + L49 + C49 - AVGH100 - AVGL100 - AVGC100) + ABS(H50 + L50 + C50 - AVGH100 - AVGL100 - AVGC100) + ABS(H51 + L51 + C51 - AVGH100 - AVGL100 - AVGC100) + ABS(H52 + L52 + C52 - AVGH100 - AVGL100 - AVGC100) + ABS(H53 + L53 + C53 - AVGH100 - AVGL100 - AVGC100) + ABS(H54 + L54 + C54 - AVGH100 - AVGL100 - AVGC100) + ABS(H55 + L55 + C55 - AVGH100 - AVGL100 - AVGC100) + ABS(H56 + L56 + C56 - AVGH100 - AVGL100 - AVGC100) + ABS(H57 + L57 + C57 - AVGH100 - AVGL100 - AVGC100) + ABS(H58 + L58 + C58 - AVGH100 - AVGL100 - AVGC100) + ABS(H59 + L59 + C59 - AVGH100 - AVGL100 - AVGC100) + ABS(H60 + L60 + C60 - AVGH100 - AVGL100 - AVGC100) + ABS(H61 + L61 + C61 - AVGH100 - AVGL100 - AVGC100) + ABS(H62 + L62 + C62 - AVGH100 - AVGL100 - AVGC100) + ABS(H63 + L63 + C63 - AVGH100 - AVGL100 - AVGC100) + ABS(H64 + L64 + C64 - AVGH100 - AVGL100 - AVGC100) + ABS(H65 + L65 + C65 - AVGH100 - AVGL100 - AVGC100) + ABS(H66 + L66 + C66 - AVGH100 - AVGL100 - AVGC100) + ABS(H67 + L67 + C67 - AVGH100 - AVGL100 - AVGC100) + ABS(H68 + L68 + C68 - AVGH100 - AVGL100 - AVGC100) + ABS(H69 + L69 + C69 - AVGH100 - AVGL100 - AVGC100) + ABS(H70 + L70 + C70 - AVGH100 - AVGL100 - AVGC100) + ABS(H71 + L71 + C71 - AVGH100 - AVGL100 - AVGC100) + ABS(H72 + L72 + C72 - AVGH100 - AVGL100 - AVGC100) + ABS(H73 + L73 + C73 - AVGH100 - AVGL100 - AVGC100) + ABS(H74 + L74 + C74 - AVGH100 - AVGL100 - AVGC100) + ABS(H75 + L75 + C75 - AVGH100 - AVGL100 - AVGC100) + ABS(H76 + L76 + C76 - AVGH100 - AVGL100 - AVGC100) + ABS(H77 + L77 + C77 - AVGH100 - AVGL100 - AVGC100) + ABS(H78 + L78 + C78 - AVGH100 - AVGL100 - AVGC100) + ABS(H79 + L79 + C79 - AVGH100 - AVGL100 - AVGC100) + ABS(H80 + L80 + C80 - AVGH100 - AVGL100 - AVGC100) + ABS(H81 + L81 + C81 - AVGH100 - AVGL100 - AVGC100) + ABS(H82 + L82 + C82 - AVGH100 - AVGL100 - AVGC100) + ABS(H83 + L83 + C83 - AVGH100 - AVGL100 - AVGC100) + ABS(H84 + L84 + C84 - AVGH100 - AVGL100 - AVGC100) + ABS(H85 + L85 + C85 - AVGH100 - AVGL100 - AVGC100) + ABS(H86 + L86 + C86 - AVGH100 - AVGL100 - AVGC100) + ABS(H87 + L87 + C87 - AVGH100 - AVGL100 - AVGC100) + ABS(H88 + L88 + C88 - AVGH100 - AVGL100 - AVGC100) + ABS(H89 + L89 + C89 - AVGH100 - AVGL100 - AVGC100) + ABS(H90 + L90 + C90 - AVGH100 - AVGL100 - AVGC100) + ABS(H91 + L91 + C91 - AVGH100 - AVGL100 - AVGC100) + ABS(H92 + L92 + C92 - AVGH100 - AVGL100 - AVGC100) + ABS(H93 + L93 + C93 - AVGH100 - AVGL100 - AVGC100) + ABS(H94 + L94 + C94 - AVGH100 - AVGL100 - AVGC100) + ABS(H95 + L95 + C95 - AVGH100 - AVGL100 - AVGC100) + ABS(H96 + L96 + C96 - AVGH100 - AVGL100 - AVGC100) + ABS(H97 + L97 + C97 - AVGH100 - AVGL100 - AVGC100) + ABS(H98 + L98 + C98 - AVGH100 - AVGL100 - AVGC100) + ABS(H99 + L99 + C99 - AVGH100 - AVGL100 - AVGC100) + .000001) + 50) < 50



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
haseo
Posted : Wednesday, December 31, 2014 8:27:25 PM
Registered User
Joined: 9/5/2012
Posts: 59

Hi Bruce,

I tried to breakdown the formula but just cant do it myself.

Can you help me with another similar problem

1. CCI(21) is greater than CCI(100) and the difference is less than 150.

Bruce_L
Posted : Tuesday, January 6, 2015 4:11:26 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Change both 50s at the end of the formula to 75 instead.

ABS((H + L + C - AVGH21 - AVGL21 - AVGC21) * 4200 / 3 / (ABS(H + L + C - AVGH21 - AVGL21 - AVGC21) + ABS(H1 + L1 + C1 - AVGH21 - AVGL21 - AVGC21) + ABS(H2 + L2 + C2 - AVGH21 - AVGL21 - AVGC21) + ABS(H3 + L3 + C3 - AVGH21 - AVGL21 - AVGC21) + ABS(H4 + L4 + C4 - AVGH21 - AVGL21 - AVGC21) + ABS(H5 + L5 + C5 - AVGH21 - AVGL21 - AVGC21) + ABS(H6 + L6 + C6 - AVGH21 - AVGL21 - AVGC21) + ABS(H7 + L7 + C7 - AVGH21 - AVGL21 - AVGC21) + ABS(H8 + L8 + C8 - AVGH21 - AVGL21 - AVGC21) + ABS(H9 + L9 + C9 - AVGH21 - AVGL21 - AVGC21) + ABS(H10 + L10 + C10 - AVGH21 - AVGL21 - AVGC21) + ABS(H11 + L11 + C11 - AVGH21 - AVGL21 - AVGC21) + ABS(H12 + L12 + C12 - AVGH21 - AVGL21 - AVGC21) + ABS(H13 + L13 + C13 - AVGH21 - AVGL21 - AVGC21) + ABS(H14 + L14 + C14 - AVGH21 - AVGL21 - AVGC21) + ABS(H15 + L15 + C15 - AVGH21 - AVGL21 - AVGC21) + ABS(H16 + L16 + C16 - AVGH21 - AVGL21 - AVGC21) + ABS(H17 + L17 + C17 - AVGH21 - AVGL21 - AVGC21) + ABS(H18 + L18 + C18 - AVGH21 - AVGL21 - AVGC21) + ABS(H19 + L19 + C19 - AVGH21 - AVGL21 - AVGC21) + ABS(H20 + L20 + C20 - AVGH21 - AVGL21 - AVGC21) + .000001) - (H + L + C - AVGH100 - AVGL100 - AVGC100) * 20000 / 3 / (ABS(H + L + C - AVGH100 - AVGL100 - AVGC100) + ABS(H1 + L1 + C1 - AVGH100 - AVGL100 - AVGC100) + ABS(H2 + L2 + C2 - AVGH100 - AVGL100 - AVGC100) + ABS(H3 + L3 + C3 - AVGH100 - AVGL100 - AVGC100) + ABS(H4 + L4 + C4 - AVGH100 - AVGL100 - AVGC100) + ABS(H5 + L5 + C5 - AVGH100 - AVGL100 - AVGC100) + ABS(H6 + L6 + C6 - AVGH100 - AVGL100 - AVGC100) + ABS(H7 + L7 + C7 - AVGH100 - AVGL100 - AVGC100) + ABS(H8 + L8 + C8 - AVGH100 - AVGL100 - AVGC100) + ABS(H9 + L9 + C9 - AVGH100 - AVGL100 - AVGC100) + ABS(H10 + L10 + C10 - AVGH100 - AVGL100 - AVGC100) + ABS(H11 + L11 + C11 - AVGH100 - AVGL100 - AVGC100) + ABS(H12 + L12 + C12 - AVGH100 - AVGL100 - AVGC100) + ABS(H13 + L13 + C13 - AVGH100 - AVGL100 - AVGC100) + ABS(H14 + L14 + C14 - AVGH100 - AVGL100 - AVGC100) + ABS(H15 + L15 + C15 - AVGH100 - AVGL100 - AVGC100) + ABS(H16 + L16 + C16 - AVGH100 - AVGL100 - AVGC100) + ABS(H17 + L17 + C17 - AVGH100 - AVGL100 - AVGC100) + ABS(H18 + L18 + C18 - AVGH100 - AVGL100 - AVGC100) + ABS(H19 + L19 + C19 - AVGH100 - AVGL100 - AVGC100) + ABS(H20 + L20 + C20 - AVGH100 - AVGL100 - AVGC100) + ABS(H21 + L21 + C21 - AVGH100 - AVGL100 - AVGC100) + ABS(H22 + L22 + C22 - AVGH100 - AVGL100 - AVGC100) + ABS(H23 + L23 + C23 - AVGH100 - AVGL100 - AVGC100) + ABS(H24 + L24 + C24 - AVGH100 - AVGL100 - AVGC100) + ABS(H25 + L25 + C25 - AVGH100 - AVGL100 - AVGC100) + ABS(H26 + L26 + C26 - AVGH100 - AVGL100 - AVGC100) + ABS(H27 + L27 + C27 - AVGH100 - AVGL100 - AVGC100) + ABS(H28 + L28 + C28 - AVGH100 - AVGL100 - AVGC100) + ABS(H29 + L29 + C29 - AVGH100 - AVGL100 - AVGC100) + ABS(H30 + L30 + C30 - AVGH100 - AVGL100 - AVGC100) + ABS(H31 + L31 + C31 - AVGH100 - AVGL100 - AVGC100) + ABS(H32 + L32 + C32 - AVGH100 - AVGL100 - AVGC100) + ABS(H33 + L33 + C33 - AVGH100 - AVGL100 - AVGC100) + ABS(H34 + L34 + C34 - AVGH100 - AVGL100 - AVGC100) + ABS(H35 + L35 + C35 - AVGH100 - AVGL100 - AVGC100) + ABS(H36 + L36 + C36 - AVGH100 - AVGL100 - AVGC100) + ABS(H37 + L37 + C37 - AVGH100 - AVGL100 - AVGC100) + ABS(H38 + L38 + C38 - AVGH100 - AVGL100 - AVGC100) + ABS(H39 + L39 + C39 - AVGH100 - AVGL100 - AVGC100) + ABS(H40 + L40 + C40 - AVGH100 - AVGL100 - AVGC100) + ABS(H41 + L41 + C41 - AVGH100 - AVGL100 - AVGC100) + ABS(H42 + L42 + C42 - AVGH100 - AVGL100 - AVGC100) + ABS(H43 + L43 + C43 - AVGH100 - AVGL100 - AVGC100) + ABS(H44 + L44 + C44 - AVGH100 - AVGL100 - AVGC100) + ABS(H45 + L45 + C45 - AVGH100 - AVGL100 - AVGC100) + ABS(H46 + L46 + C46 - AVGH100 - AVGL100 - AVGC100) + ABS(H47 + L47 + C47 - AVGH100 - AVGL100 - AVGC100) + ABS(H48 + L48 + C48 - AVGH100 - AVGL100 - AVGC100) + ABS(H49 + L49 + C49 - AVGH100 - AVGL100 - AVGC100) + ABS(H50 + L50 + C50 - AVGH100 - AVGL100 - AVGC100) + ABS(H51 + L51 + C51 - AVGH100 - AVGL100 - AVGC100) + ABS(H52 + L52 + C52 - AVGH100 - AVGL100 - AVGC100) + ABS(H53 + L53 + C53 - AVGH100 - AVGL100 - AVGC100) + ABS(H54 + L54 + C54 - AVGH100 - AVGL100 - AVGC100) + ABS(H55 + L55 + C55 - AVGH100 - AVGL100 - AVGC100) + ABS(H56 + L56 + C56 - AVGH100 - AVGL100 - AVGC100) + ABS(H57 + L57 + C57 - AVGH100 - AVGL100 - AVGC100) + ABS(H58 + L58 + C58 - AVGH100 - AVGL100 - AVGC100) + ABS(H59 + L59 + C59 - AVGH100 - AVGL100 - AVGC100) + ABS(H60 + L60 + C60 - AVGH100 - AVGL100 - AVGC100) + ABS(H61 + L61 + C61 - AVGH100 - AVGL100 - AVGC100) + ABS(H62 + L62 + C62 - AVGH100 - AVGL100 - AVGC100) + ABS(H63 + L63 + C63 - AVGH100 - AVGL100 - AVGC100) + ABS(H64 + L64 + C64 - AVGH100 - AVGL100 - AVGC100) + ABS(H65 + L65 + C65 - AVGH100 - AVGL100 - AVGC100) + ABS(H66 + L66 + C66 - AVGH100 - AVGL100 - AVGC100) + ABS(H67 + L67 + C67 - AVGH100 - AVGL100 - AVGC100) + ABS(H68 + L68 + C68 - AVGH100 - AVGL100 - AVGC100) + ABS(H69 + L69 + C69 - AVGH100 - AVGL100 - AVGC100) + ABS(H70 + L70 + C70 - AVGH100 - AVGL100 - AVGC100) + ABS(H71 + L71 + C71 - AVGH100 - AVGL100 - AVGC100) + ABS(H72 + L72 + C72 - AVGH100 - AVGL100 - AVGC100) + ABS(H73 + L73 + C73 - AVGH100 - AVGL100 - AVGC100) + ABS(H74 + L74 + C74 - AVGH100 - AVGL100 - AVGC100) + ABS(H75 + L75 + C75 - AVGH100 - AVGL100 - AVGC100) + ABS(H76 + L76 + C76 - AVGH100 - AVGL100 - AVGC100) + ABS(H77 + L77 + C77 - AVGH100 - AVGL100 - AVGC100) + ABS(H78 + L78 + C78 - AVGH100 - AVGL100 - AVGC100) + ABS(H79 + L79 + C79 - AVGH100 - AVGL100 - AVGC100) + ABS(H80 + L80 + C80 - AVGH100 - AVGL100 - AVGC100) + ABS(H81 + L81 + C81 - AVGH100 - AVGL100 - AVGC100) + ABS(H82 + L82 + C82 - AVGH100 - AVGL100 - AVGC100) + ABS(H83 + L83 + C83 - AVGH100 - AVGL100 - AVGC100) + ABS(H84 + L84 + C84 - AVGH100 - AVGL100 - AVGC100) + ABS(H85 + L85 + C85 - AVGH100 - AVGL100 - AVGC100) + ABS(H86 + L86 + C86 - AVGH100 - AVGL100 - AVGC100) + ABS(H87 + L87 + C87 - AVGH100 - AVGL100 - AVGC100) + ABS(H88 + L88 + C88 - AVGH100 - AVGL100 - AVGC100) + ABS(H89 + L89 + C89 - AVGH100 - AVGL100 - AVGC100) + ABS(H90 + L90 + C90 - AVGH100 - AVGL100 - AVGC100) + ABS(H91 + L91 + C91 - AVGH100 - AVGL100 - AVGC100) + ABS(H92 + L92 + C92 - AVGH100 - AVGL100 - AVGC100) + ABS(H93 + L93 + C93 - AVGH100 - AVGL100 - AVGC100) + ABS(H94 + L94 + C94 - AVGH100 - AVGL100 - AVGC100) + ABS(H95 + L95 + C95 - AVGH100 - AVGL100 - AVGC100) + ABS(H96 + L96 + C96 - AVGH100 - AVGL100 - AVGC100) + ABS(H97 + L97 + C97 - AVGH100 - AVGL100 - AVGC100) + ABS(H98 + L98 + C98 - AVGH100 - AVGL100 - AVGC100) + ABS(H99 + L99 + C99 - AVGH100 - AVGL100 - AVGC100) + .000001) - 75) < 75



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.