Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 9/20/2005 Posts: 149
|
I need help with 2 indicators please.
First Indicator: Bollinger Bands inside Keltner Channel.
Settings: Bollinger Bands period 21 and std. dev. 2.0, Keltner Channels period 21 and ATR multiplier 1.50.
Second Indicator: Bollinger Bands inside Keltner Channel.
Settings: Bollinger Bands period 21 and std. dev. 2.0, Keltner Channels period 21 and ATR multiplier 2.25.
Thanks in advance.
|
|
Registered User Joined: 9/20/2005 Posts: 149
|
Change of indicator settings.
First indicator: Bollinger Bands stay the same, Keltner Channels period 21 and ATR multiplier 1.20.
Second indicator: Bollinger Bands stay the same, Keltner Channels period 21 and ATR multiplier 1.80.
Thanks.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The following Condition Formula is for the Simple Bollinger Bands 21, 2.00 to be completely inside the Exponential Keltner Channels 21, 1.80. You can change the sections which are bolded to change the width of the Keltner Channels (in blue) or Bollinger Bands (in red). Both appear twice in the formula.
(XAVGC21 + XAVGH21 + XAVGL21) / 3 - 1.8 * ((XAVGH21 - XAVGL21) / 2 + .04549783 * (ABS(H - C1) + ABS(L - C1) + 10 / 11 * ABS(H1 - C2) + ABS(L1 - C2) + 10 / 11 * (ABS(H2 - C3) + ABS(L2 - C3) + 10 / 11 * (ABS(H3 - C4) + ABS(L3 - C4) + 10 / 11 * (ABS(H4 - C5) + ABS(L4 - C5) + 10 / 11 * (ABS(H5 - C6) + ABS(L5 - C6) + 10 / 11 * (ABS(H6 - C7) + ABS(L6 - C7) + 10 / 11 * (ABS(H7 - C8) + ABS(L7 - C8) + 10 / 11 * (ABS(H8 - C9) + ABS(L8 - C9) + 10 / 11 * (ABS(H9 - C10) + ABS(L9 - C10) + 10 / 11 * (ABS(H10 - C11) + ABS(L10 - C11) + 10 / 11 * (ABS(H11 - C12) + ABS(L11 - C12) + 10 / 11 * (ABS(H12 - C13) + ABS(L12 - C13) + 10 / 11 * (ABS(H13 - C14) + ABS(L13 - C14) + 10 / 11 * (ABS(H14 - C15) + ABS(L14 - C15) + 10 / 11 * (ABS(H15 - C16) + ABS(L15 - C16) + 10 / 11 * (ABS(H16 - C17) + ABS(L16 - C17) + 10 / 11 * (ABS(H17 - C18) + ABS(L17 - C18) + 10 / 11 * (ABS(H18 - C19) + ABS(L18 - C19) + 10 / 11 * (ABS(H19 - C20) + ABS(L19 - C20) + 10 / 11 * (ABS(H20 - C21) + ABS(L20 - C21) + 10 / 11 * (ABS(H21 - C22) + ABS(L21 - C22) + 10 / 11 * (ABS(H22 - C23) + ABS(L22 - C23) + 10 / 11 * (ABS(H23 - C24) + ABS(L23 - C24) + 10 / 11 * (ABS(H24 - C25) + ABS(L24 - C25) + 10 / 11 * (ABS(H25 - C26) + ABS(L25 - C26) + 10 / 11 * (ABS(H26 - C27) + ABS(L26 - C27) + 10 / 11 * (ABS(H27 - C28) + ABS(L27 - C28) + 10 / 11 * (ABS(H28 - C29) + ABS(L28 - C29) + 10 / 11 * (ABS(H29 - C30) + ABS(L29 - C30) + 10 / 11 * (ABS(H30 - C31) + ABS(L30 - C31) + 10 / 11 * (ABS(H31 - C32) + ABS(L31 - C32) + 10 / 11 * (ABS(H32 - C33) + ABS(L32 - C33) + 10 / 11 * (ABS(H33 - C34) + ABS(L33 - C34) + 10 / 11 * (ABS(H34 - C35) + ABS(L34 - C35) + 10 / 11 * (ABS(H35 - C36) + ABS(L35 - C36) + 10 / 11 * (ABS(H36 - C37) + ABS(L36 - C37) + 10 / 11 * (ABS(H37 - C38) + ABS(L37 - C38) + 10 / 11 * (ABS(H38 - C39) + ABS(L38 - C39) + 10 / 11 * (ABS(H39 - C40) + ABS(L39 - C40) + 10 / 11 * (ABS(H40 - C41) + ABS(L40 - C41) + 10 / 11 * (ABS(H41 - C42) + ABS(L41 - C42) + 10 / 11 * (ABS(H42 - C43) + ABS(L42 - C43) + 10 / 11 * (ABS(H43 - C44) + ABS(L43 - C44) + 10 / 11 * (ABS(H44 - C45) + ABS(L44 - C45) + 10 / 11 * (ABS(H45 - C46) + ABS(L45 - C46) + 10 / 11 * (ABS(H46 - C47) + ABS(L46 - C47) + 10 / 11 * (ABS(H47 - C48) + ABS(L47 - C48) + 10 / 11 * (ABS(H48 - C49) + ABS(L48 - C49) + 10 / 11 * (ABS(H49 - C50) + ABS(L49 - C50) + 10 / 11 * (ABS(H50 - C51) + ABS(L50 - C51) + 10 / 11 * (ABS(H51 - C52) + ABS(L51 - C52) + 10 / 11 * (ABS(H52 - C53) + ABS(L52 - C53) + 10 / 11 * (ABS(H53 - C54) + ABS(L53 - C54) + 10 / 11 * (ABS(H54 - C55) + ABS(L54 - C55) + 10 / 11 * (ABS(H55 - C56) + ABS(L55 - C56) + 10 / 11 * (ABS(H56 - C57) + ABS(L56 - C57) + 10 / 11 * (ABS(H57 - C58) + ABS(L57 - C58) + 10 / 11 * (ABS(H58 - C59) + ABS(L58 - C59) + 10 / 11 * (ABS(H59 - C60) + ABS(L59 - C60) + 10 / 11 * (ABS(H60 - C61) + ABS(L60 - C61) + 10 / 11 * (ABS(H61 - C62) + ABS(L61 - C62) + 10 / 11 * (ABS(H62 - C63) + ABS(L62 - C63) + 10 / 11 * (ABS(H63 - C64) + ABS(L63 - C64) + 10 / 11 * (ABS(H64 - C65) + ABS(L64 - C65) + 10 / 11 * (ABS(H65 - C66) + ABS(L65 - C66) + 10 / 11 * (ABS(H66 - C67) + ABS(L66 - C67) + 10 / 11 * (ABS(H67 - C68) + ABS(L67 - C68) + 10 / 11 * (ABS(H68 - C69) + ABS(L68 - C69) + 10 / 11 * (ABS(H69 - C70) + ABS(L69 - C70) + 10 / 11 * (ABS(H70 - C71) + ABS(L70 - C71) + 10 / 11 * (ABS(H71 - C72) + ABS(L71 - C72) + 10 / 11 * (ABS(H72 - C73) + ABS(L72 - C73)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) < AVGC21 - 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 21) AND AVGC21 + 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 21) < (XAVGC21 + XAVGH21 + XAVGL21) / 3 + 1.8 * ((XAVGH21 - XAVGL21) / 2 + .04549783 * (ABS(H - C1) + ABS(L - C1) + 10 / 11 * ABS(H1 - C2) + ABS(L1 - C2) + 10 / 11 * (ABS(H2 - C3) + ABS(L2 - C3) + 10 / 11 * (ABS(H3 - C4) + ABS(L3 - C4) + 10 / 11 * (ABS(H4 - C5) + ABS(L4 - C5) + 10 / 11 * (ABS(H5 - C6) + ABS(L5 - C6) + 10 / 11 * (ABS(H6 - C7) + ABS(L6 - C7) + 10 / 11 * (ABS(H7 - C8) + ABS(L7 - C8) + 10 / 11 * (ABS(H8 - C9) + ABS(L8 - C9) + 10 / 11 * (ABS(H9 - C10) + ABS(L9 - C10) + 10 / 11 * (ABS(H10 - C11) + ABS(L10 - C11) + 10 / 11 * (ABS(H11 - C12) + ABS(L11 - C12) + 10 / 11 * (ABS(H12 - C13) + ABS(L12 - C13) + 10 / 11 * (ABS(H13 - C14) + ABS(L13 - C14) + 10 / 11 * (ABS(H14 - C15) + ABS(L14 - C15) + 10 / 11 * (ABS(H15 - C16) + ABS(L15 - C16) + 10 / 11 * (ABS(H16 - C17) + ABS(L16 - C17) + 10 / 11 * (ABS(H17 - C18) + ABS(L17 - C18) + 10 / 11 * (ABS(H18 - C19) + ABS(L18 - C19) + 10 / 11 * (ABS(H19 - C20) + ABS(L19 - C20) + 10 / 11 * (ABS(H20 - C21) + ABS(L20 - C21) + 10 / 11 * (ABS(H21 - C22) + ABS(L21 - C22) + 10 / 11 * (ABS(H22 - C23) + ABS(L22 - C23) + 10 / 11 * (ABS(H23 - C24) + ABS(L23 - C24) + 10 / 11 * (ABS(H24 - C25) + ABS(L24 - C25) + 10 / 11 * (ABS(H25 - C26) + ABS(L25 - C26) + 10 / 11 * (ABS(H26 - C27) + ABS(L26 - C27) + 10 / 11 * (ABS(H27 - C28) + ABS(L27 - C28) + 10 / 11 * (ABS(H28 - C29) + ABS(L28 - C29) + 10 / 11 * (ABS(H29 - C30) + ABS(L29 - C30) + 10 / 11 * (ABS(H30 - C31) + ABS(L30 - C31) + 10 / 11 * (ABS(H31 - C32) + ABS(L31 - C32) + 10 / 11 * (ABS(H32 - C33) + ABS(L32 - C33) + 10 / 11 * (ABS(H33 - C34) + ABS(L33 - C34) + 10 / 11 * (ABS(H34 - C35) + ABS(L34 - C35) + 10 / 11 * (ABS(H35 - C36) + ABS(L35 - C36) + 10 / 11 * (ABS(H36 - C37) + ABS(L36 - C37) + 10 / 11 * (ABS(H37 - C38) + ABS(L37 - C38) + 10 / 11 * (ABS(H38 - C39) + ABS(L38 - C39) + 10 / 11 * (ABS(H39 - C40) + ABS(L39 - C40) + 10 / 11 * (ABS(H40 - C41) + ABS(L40 - C41) + 10 / 11 * (ABS(H41 - C42) + ABS(L41 - C42) + 10 / 11 * (ABS(H42 - C43) + ABS(L42 - C43) + 10 / 11 * (ABS(H43 - C44) + ABS(L43 - C44) + 10 / 11 * (ABS(H44 - C45) + ABS(L44 - C45) + 10 / 11 * (ABS(H45 - C46) + ABS(L45 - C46) + 10 / 11 * (ABS(H46 - C47) + ABS(L46 - C47) + 10 / 11 * (ABS(H47 - C48) + ABS(L47 - C48) + 10 / 11 * (ABS(H48 - C49) + ABS(L48 - C49) + 10 / 11 * (ABS(H49 - C50) + ABS(L49 - C50) + 10 / 11 * (ABS(H50 - C51) + ABS(L50 - C51) + 10 / 11 * (ABS(H51 - C52) + ABS(L51 - C52) + 10 / 11 * (ABS(H52 - C53) + ABS(L52 - C53) + 10 / 11 * (ABS(H53 - C54) + ABS(L53 - C54) + 10 / 11 * (ABS(H54 - C55) + ABS(L54 - C55) + 10 / 11 * (ABS(H55 - C56) + ABS(L55 - C56) + 10 / 11 * (ABS(H56 - C57) + ABS(L56 - C57) + 10 / 11 * (ABS(H57 - C58) + ABS(L57 - C58) + 10 / 11 * (ABS(H58 - C59) + ABS(L58 - C59) + 10 / 11 * (ABS(H59 - C60) + ABS(L59 - C60) + 10 / 11 * (ABS(H60 - C61) + ABS(L60 - C61) + 10 / 11 * (ABS(H61 - C62) + ABS(L61 - C62) + 10 / 11 * (ABS(H62 - C63) + ABS(L62 - C63) + 10 / 11 * (ABS(H63 - C64) + ABS(L63 - C64) + 10 / 11 * (ABS(H64 - C65) + ABS(L64 - C65) + 10 / 11 * (ABS(H65 - C66) + ABS(L65 - C66) + 10 / 11 * (ABS(H66 - C67) + ABS(L66 - C67) + 10 / 11 * (ABS(H67 - C68) + ABS(L67 - C68) + 10 / 11 * (ABS(H68 - C69) + ABS(L68 - C69) + 10 / 11 * (ABS(H69 - C70) + ABS(L69 - C70) + 10 / 11 * (ABS(H70 - C71) + ABS(L70 - C71) + 10 / 11 * (ABS(H71 - C72) + ABS(L71 - C72) + 10 / 11 * (ABS(H72 - C73) + ABS(L72 - C73))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 9/20/2005 Posts: 149
|
Thank you.
|
|
Registered User Joined: 9/20/2005 Posts: 149
|
Bruce, would you pleasse review the code for the squeeze indicator with the settings of 1.2. It dosen't appear to pick up all charts that are in the squeeze. Please review WFM on 7/16/12 and 7/17/12. Thank you.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The Simple Bollinger Bands 21, 2.00 are not completely inside the Exponential Keltner Channels 21, 1.20 on either 7/16/12 or 7/17/12. The Upper Bollinger Band is outside the Keltner Channel on both dates.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 9/20/2005 Posts: 149
|
It is on my charts. Any advice as to what I may be doing wrong?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The Upper Simple Bollinger Band 21, 2.00 is definitely above the Upper Exponential Keltner Channel 21, 1.20 on my charts on both 7/16/12 and 7/17/12.
Are you viewing a Daily Chart?
Are you using something other than the following settings?
Bollinger Bands
- Period: 21
- Std Dev: 2.00
- Average Type: Simple
Keltner Channels
- Period: 21
- ATR Multiplier: 1.20
- Average Type: Exponential
Are the Bollinger Bands and Keltner Channels both of Price History? If so, make sure Price History isn't using the Heiken-Ashi Plot Style as this would actually changes the prices being used to calculated the Bollinger Bands and Keltner Channels.
If none of the above addresses your issue, then please contact technical support.
All e-mail communication sent to support@worden.com during business hours (Monday through Friday 9AM-11PM and Saturday and Sunday 9AM-3PM ET) should be answered within 20 minutes of arrival.
For an even quicker response to tech support questions, we recommend calling our voice line at (919) 408-0542 (there is no phone support on Sundays, some Market Holidays or after 9PM ET on weekdays).
You can also contact us using Live Chat Support during business hours.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 9/20/2005 Posts: 149
|
Thanks Bruce, I have it worked out. Must have been the way I set up the chart.
If I wanted to use the exponential average for the bollinger band setting, What changes should I make to the chart? Thanks again for your help.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You just have to edit the Bollinger Bands and change the Average Type to Exponential to change the chart. The Formula actually becomes much shorter.
2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 21) < 1.2 * ((XAVGH21 - XAVGL21) / 2 + .04549783 * (ABS(H - C1) + ABS(L - C1) + 10 / 11 * (ABS(H1 - C2) + ABS(L1 - C2) + 10 / 11 * (ABS(H2 - C3) + ABS(L2 - C3) + 10 / 11 * (ABS(H3 - C4) + ABS(L3 - C4) + 10 / 11 * (ABS(H4 - C5) + ABS(L4 - C5) + 10 / 11 * (ABS(H5 - C6) + ABS(L5 - C6) + 10 / 11 * (ABS(H6 - C7) + ABS(L6 - C7) + 10 / 11 * (ABS(H7 - C8) + ABS(L7 - C8) + 10 / 11 * (ABS(H8 - C9) + ABS(L8 - C9) + 10 / 11 * (ABS(H9 - C10) + ABS(L9 - C10) + 10 / 11 * (ABS(H10 - C11) + ABS(L10 - C11) + 10 / 11 * (ABS(H11 - C12) + ABS(L11 - C12) + 10 / 11 * (ABS(H12 - C13) + ABS(L12 - C13) + 10 / 11 * (ABS(H13 - C14) + ABS(L13 - C14) + 10 / 11 * (ABS(H14 - C15) + ABS(L14 - C15) + 10 / 11 * (ABS(H15 - C16) + ABS(L15 - C16) + 10 / 11 * (ABS(H16 - C17) + ABS(L16 - C17) + 10 / 11 * (ABS(H17 - C18) + ABS(L17 - C18) + 10 / 11 * (ABS(H18 - C19) + ABS(L18 - C19) + 10 / 11 * (ABS(H19 - C20) + ABS(L19 - C20) + 10 / 11 * (ABS(H20 - C21) + ABS(L20 - C21) + 10 / 11 * (ABS(H21 - C22) + ABS(L21 - C22) + 10 / 11 * (ABS(H22 - C23) + ABS(L22 - C23) + 10 / 11 * (ABS(H23 - C24) + ABS(L23 - C24) + 10 / 11 * (ABS(H24 - C25) + ABS(L24 - C25) + 10 / 11 * (ABS(H25 - C26) + ABS(L25 - C26) + 10 / 11 * (ABS(H26 - C27) + ABS(L26 - C27) + 10 / 11 * (ABS(H27 - C28) + ABS(L27 - C28) + 10 / 11 * (ABS(H28 - C29) + ABS(L28 - C29) + 10 / 11 * (ABS(H29 - C30) + ABS(L29 - C30) + 10 / 11 * (ABS(H30 - C31) + ABS(L30 - C31) + 10 / 11 * (ABS(H31 - C32) + ABS(L31 - C32) + 10 / 11 * (ABS(H32 - C33) + ABS(L32 - C33) + 10 / 11 * (ABS(H33 - C34) + ABS(L33 - C34) + 10 / 11 * (ABS(H34 - C35) + ABS(L34 - C35) + 10 / 11 * (ABS(H35 - C36) + ABS(L35 - C36) + 10 / 11 * (ABS(H36 - C37) + ABS(L36 - C37) + 10 / 11 * (ABS(H37 - C38) + ABS(L37 - C38) + 10 / 11 * (ABS(H38 - C39) + ABS(L38 - C39) + 10 / 11 * (ABS(H39 - C40) + ABS(L39 - C40) + 10 / 11 * (ABS(H40 - C41) + ABS(L40 - C41) + 10 / 11 * (ABS(H41 - C42) + ABS(L41 - C42) + 10 / 11 * (ABS(H42 - C43) + ABS(L42 - C43) + 10 / 11 * (ABS(H43 - C44) + ABS(L43 - C44) + 10 / 11 * (ABS(H44 - C45) + ABS(L44 - C45) + 10 / 11 * (ABS(H45 - C46) + ABS(L45 - C46) + 10 / 11 * (ABS(H46 - C47) + ABS(L46 - C47) + 10 / 11 * (ABS(H47 - C48) + ABS(L47 - C48) + 10 / 11 * (ABS(H48 - C49) + ABS(L48 - C49) + 10 / 11 * (ABS(H49 - C50) + ABS(L49 - C50) + 10 / 11 * (ABS(H50 - C51) + ABS(L50 - C51) + 10 / 11 * (ABS(H51 - C52) + ABS(L51 - C52) + 10 / 11 * (ABS(H52 - C53) + ABS(L52 - C53) + 10 / 11 * (ABS(H53 - C54) + ABS(L53 - C54) + 10 / 11 * (ABS(H54 - C55) + ABS(L54 - C55) + 10 / 11 * (ABS(H55 - C56) + ABS(L55 - C56) + 10 / 11 * (ABS(H56 - C57) + ABS(L56 - C57) + 10 / 11 * (ABS(H57 - C58) + ABS(L57 - C58) + 10 / 11 * (ABS(H58 - C59) + ABS(L58 - C59) + 10 / 11 * (ABS(H59 - C60) + ABS(L59 - C60) + 10 / 11 * (ABS(H60 - C61) + ABS(L60 - C61) + 10 / 11 * (ABS(H61 - C62) + ABS(L61 - C62) + 10 / 11 * (ABS(H62 - C63) + ABS(L62 - C63) + 10 / 11 * (ABS(H63 - C64) + ABS(L63 - C64) + 10 / 11 * (ABS(H64 - C65) + ABS(L64 - C65) + 10 / 11 * (ABS(H65 - C66) + ABS(L65 - C66) + 10 / 11 * (ABS(H66 - C67) + ABS(L66 - C67) + 10 / 11 * (ABS(H67 - C68) + ABS(L67 - C68) + 10 / 11 * (ABS(H68 - C69) + ABS(L68 - C69) + 10 / 11 * (ABS(H69 - C70) + ABS(L69 - C70) + 10 / 11 * (ABS(H70 - C71) + ABS(L70 - C71) + 10 / 11 * (ABS(H71 - C72) + ABS(L71 - C72) + 10 / 11 * (ABS(H72 - C73) + ABS(L72 - C73)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 9/20/2005 Posts: 149
|
Thank you.
|
|
Platinum Customer
Joined: 4/27/2012 Posts: 106
|
What changes to the above formula are needed to bring the BB 21-2 inside or outside KC 25-2.5. Another words change the Keltner Channels: Period: 25 ATR Multiplier: 2.5 Average Type: Exponential
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Note that the centerlines won't match, so since I'm assuming you still want the shorter formula from my Wednesday, November 14, 2012 12:39:49 PM ET post, we are going to have to assume they match even though they don't. The following Condition Formula checks for the width of the Bollinger Bands to be less than the width of the Keltner Channels. You can change < 2.5 * to a > 2.5 * to check for the width of the Bollinger Bands to be greater than the width of the Keltner Channels.
2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 21) < 2.5 * (XAVGH25 - XAVGL25 + .0769958824343713 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 12 / 13 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 12 / 13 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 12 / 13 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 12 / 13 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 12 / 13 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 12 / 13 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 12 / 13 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 12 / 13 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 12 / 13 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 12 / 13 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 12 / 13 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 12 / 13 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 12 / 13 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 12 / 13 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 12 / 13 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 12 / 13 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 12 / 13 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 12 / 13 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 12 / 13 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 12 / 13 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 12 / 13 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 12 / 13 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 12 / 13 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 12 / 13 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 12 / 13 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 12 / 13 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 12 / 13 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 12 / 13 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 12 / 13 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 12 / 13 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 12 / 13 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 12 / 13 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 12 / 13 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 12 / 13 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 12 / 13 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 12 / 13 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 12 / 13 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 12 / 13 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 12 / 13 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 12 / 13 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 12 / 13 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 12 / 13 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 12 / 13 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 12 / 13 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 12 / 13 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 12 / 13 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 12 / 13 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 12 / 13 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 12 / 13 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 12 / 13 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 12 / 13 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + 12 / 13 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + 12 / 13 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + 12 / 13 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + 12 / 13 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + 12 / 13 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + 12 / 13 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + 12 / 13 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + 12 / 13 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + 12 / 13 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + 12 / 13 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + 12 / 13 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + 12 / 13 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + 12 / 13 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + 12 / 13 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + 12 / 13 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66) + 12 / 13 * ((H67 < C68) * (H67 - C68) + (C68 < L67) * (C68 - L67) + 12 / 13 * ((H68 < C69) * (H68 - C69) + (C69 < L68) * (C69 - L68) + 12 / 13 * ((H69 < C70) * (H69 - C70) + (C70 < L69) * (C70 - L69) + 12 / 13 * ((H70 < C71) * (H70 - C71) + (C71 < L70) * (C71 - L70) + 12 / 13 * ((H71 < C72) * (H71 - C72) + (C72 < L71) * (C72 - L71) + 12 / 13 * ((H72 < C73) * (H72 - C73) + (C73 < L72) * (C73 - L72) + 12 / 13 * ((H73 < C74) * (H73 - C74) + (C74 < L73) * (C74 - L73) + 12 / 13 * ((H74 < C75) * (H74 - C75) + (C75 < L74) * (C75 - L74) + 12 / 13 * ((H75 < C76) * (H75 - C76) + (C76 < L75) * (C76 - L75) + 12 / 13 * ((H76 < C77) * (H76 - C77) + (C77 < L76) * (C77 - L76) + 12 / 13 * ((H77 < C78) * (H77 - C78) + (C78 < L77) * (C78 - L77) + 12 / 13 * ((H78 < C79) * (H78 - C79) + (C79 < L78) * (C79 - L78) + 12 / 13 * ((H79 < C80) * (H79 - C80) + (C80 < L79) * (C80 - L79) + 12 / 13 * ((H80 < C81) * (H80 - C81) + (C81 < L80) * (C81 - L80) + 12 / 13 * ((H81 < C82) * (H81 - C82) + (C82 < L81) * (C82 - L81) + 12 / 13 * ((H82 < C83) * (H82 - C83) + (C83 < L82) * (C83 - L82) + 12 / 13 * ((H83 < C84) * (H83 - C84) + (C84 < L83) * (C84 - L83) + 12 / 13 * ((H84 < C85) * (H84 - C85) + (C85 < L84) * (C85 - L84) + 12 / 13 * ((H85 < C86) * (H85 - C86) + (C86 < L85) * (C86 - L85) + 12 / 13 * ((H86 < C87) * (H86 - C87) + (C87 < L86) * (C87 - L86)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |