Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 1/15/2011 Posts: 41
|
Hello Bruce
Can you please give some help?
some time ago you provided a formula for Wilder RSI 14 since it's not possible to create pcf conditions based on RSI, since it's not wilder RSI.
Is it possible to have a formula to calculate Wilder RSI28 minus Wilder RSI14?
Thank you in advance
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It is possible to create conditions based on RSI as long as the desired condition is listed when clicking on the RSI indicator on the chart and selecting Create Scan Condition.
Create Conditions from Your Chart (5:25)
An Indicator formula for Wilder's RSI28 minus Wilder's RSI14 can be written as follows.
50 * ((C - XAVGC55.1) / 28 / (.035717762 * (ABS(C - C1) + 27 / 28 * (ABS(C1 - C2) + 27 / 28 * (ABS(C2 - C3) + 27 / 28 * (ABS(C3 - C4) + 27 / 28 * (ABS(C4 - C5) + 27 / 28 * (ABS(C5 - C6) + 27 / 28 * (ABS(C6 - C7) + 27 / 28 * (ABS(C7 - C8) + 27 / 28 * (ABS(C8 - C9) + 27 / 28 * (ABS(C9 - C10) + 27 / 28 * (ABS(C10 - C11) + 27 / 28 * (ABS(C11 - C12) + 27 / 28 * (ABS(C12 - C13) + 27 / 28 * (ABS(C13 - C14) + 27 / 28 * (ABS(C14 - C15) + 27 / 28 * (ABS(C15 - C16) + 27 / 28 * (ABS(C16 - C17) + 27 / 28 * (ABS(C17 - C18) + 27 / 28 * (ABS(C18 - C19) + 27 / 28 * (ABS(C19 - C20) + 27 / 28 * (ABS(C20 - C21) + 27 / 28 * (ABS(C21 - C22) + 27 / 28 * (ABS(C22 - C23) + 27 / 28 * (ABS(C23 - C24) + 27 / 28 * (ABS(C24 - C25) + 27 / 28 * (ABS(C25 - C26) + 27 / 28 * (ABS(C26 - C27) + 27 / 28 * (ABS(C27 - C28) + 27 / 28 * (ABS(C28 - C29) + 27 / 28 * (ABS(C29 - C30) + 27 / 28 * (ABS(C30 - C31) + 27 / 28 * (ABS(C31 - C32) + 27 / 28 * (ABS(C32 - C33) + 27 / 28 * (ABS(C33 - C34) + 27 / 28 * (ABS(C34 - C35) + 27 / 28 * (ABS(C35 - C36) + 27 / 28 * (ABS(C36 - C37) + 27 / 28 * (ABS(C37 - C38) + 27 / 28 * (ABS(C38 - C39) + 27 / 28 * (ABS(C39 - C40) + 27 / 28 * (ABS(C40 - C41) + 27 / 28 * (ABS(C41 - C42) + 27 / 28 * (ABS(C42 - C43) + 27 / 28 * (ABS(C43 - C44) + 27 / 28 * (ABS(C44 - C45) + 27 / 28 * (ABS(C45 - C46) + 27 / 28 * (ABS(C46 - C47) + 27 / 28 * (ABS(C47 - C48) + 27 / 28 * (ABS(C48 - C49) + 27 / 28 * (ABS(C49 - C50) + 27 / 28 * (ABS(C50 - C51) + 27 / 28 * (ABS(C51 - C52) + 27 / 28 * (ABS(C52 - C53) + 27 / 28 * (ABS(C53 - C54) + 27 / 28 * (ABS(C54 - C55) + 27 / 28 * (ABS(C55 - C56) + 27 / 28 * (ABS(C56 - C57) + 27 / 28 * (ABS(C57 - C58) + 27 / 28 * (ABS(C58 - C59) + 27 / 28 * (ABS(C59 - C60) + 27 / 28 * (ABS(C60 - C61) + 27 / 28 * (ABS(C61 - C62) + 27 / 28 * (ABS(C62 - C63) + 27 / 28 * (ABS(C63 - C64) + 27 / 28 * (ABS(C64 - C65) + 27 / 28 * (ABS(C65 - C66) + 27 / 28 * (ABS(C66 - C67) + 27 / 28 * (ABS(C67 - C68) + 27 / 28 * (ABS(C68 - C69) + 27 / 28 * (ABS(C69 - C70) + 27 / 28 * (ABS(C70 - C71) + 27 / 28 * (ABS(C71 - C72) + 27 / 28 * (ABS(C72 - C73) + 27 / 28 * (ABS(C73 - C74) + 27 / 28 * (ABS(C74 - C75) + 27 / 28 * (ABS(C75 - C76) + 27 / 28 * (ABS(C76 - C77) + 27 / 28 * (ABS(C77 - C78) + 27 / 28 * (ABS(C78 - C79) + 27 / 28 * (ABS(C79 - C80) + 27 / 28 * (ABS(C80 - C81) + 27 / 28 * (ABS(C81 - C82) + 27 / 28 * (ABS(C82 - C83) + 27 / 28 * (ABS(C83 - C84) + 27 / 28 * (ABS(C84 - C85) + 27 / 28 * (ABS(C85 - C86) + 27 / 28 * (ABS(C86 - C87) + 27 / 28 * (ABS(C87 - C88) + 27 / 28 * (ABS(C88 - C89) + 27 / 28 * (ABS(C89 - C90) + 27 / 28 * (ABS(C90 - C91) + 27 / 28 * (ABS(C91 - C92) + 27 / 28 * (ABS(C92 - C93) + 27 / 28 * (ABS(C93 - C94) + 27 / 28 * (ABS(C94 - C95) + 27 / 28 * (ABS(C95 - C96) + 27 / 28 * (ABS(C96 - C97) + 27 / 28 * (ABS(C97 - C98) + 27 / 28 * (ABS(C98 - C99) + 27 / 28 * (ABS(C99 - C100) + 27 / 28 * (ABS(C100 - C101) + 27 / 28 * (ABS(C101 - C102) + 27 / 28 * (ABS(C102 - C103) + 27 / 28 * (ABS(C103 - C104) + 27 / 28 * (ABS(C104 - C105) + 27 / 28 * (ABS(C105 - C106) + 27 / 28 * (ABS(C106 - C107) + 27 / 28 * (ABS(C107 - C108) + 27 / 28 * (ABS(C108 - C109) + 27 / 28 * (ABS(C109 - C110) + 27 / 28 * (ABS(C110 - C111) + 27 / 28 * (ABS(C111 - C112) + 27 / 28 * (ABS(C112 - C113) + 27 / 28 * (ABS(C113 - C114) + 27 / 28 * (ABS(C114 - C115) + 27 / 28 * (ABS(C115 - C116) + 27 / 28 * (ABS(C116 - C117) + 27 / 28 * (ABS(C117 - C118) + 27 / 28 * (ABS(C118 - C119) + 27 / 28 * (ABS(C119 - C120) + 27 / 28 * (ABS(C120 - C121) + 27 / 28 * (ABS(C121 - C122) + 27 / 28 * (ABS(C122 - C123) + 27 / 28 * (ABS(C123 - C124) + 27 / 28 * (ABS(C124 - C125) + 27 / 28 * (ABS(C125 - C126) + 27 / 28 * (ABS(C126 - C127) + 27 / 28 * (ABS(C127 - C128) + 27 / 28 * (ABS(C128 - C129) + 27 / 28 * (ABS(C129 - C130) + 27 / 28 * (ABS(C130 - C131) + 27 / 28 * (ABS(C131 - C132) + 27 / 28 * (ABS(C132 - C133) + 27 / 28 * (ABS(C133 - C134) + 27 / 28 * (ABS(C134 - C135) + 27 / 28 * (ABS(C135 - C136) + 27 / 28 * (ABS(C136 - C137) + 27 / 28 * (ABS(C137 - C138) + 27 / 28 * (ABS(C138 - C139) + 27 / 28 * (ABS(C139 - C140) + 27 / 28 * (ABS(C140 - C141) + 27 / 28 * (ABS(C141 - C142) + 27 / 28 * (ABS(C142 - C143) + 27 / 28 * (ABS(C143 - C144) + 27 / 28 * (ABS(C144 - C145) + 27 / 28 * (ABS(C145 - C146) + 27 / 28 * (ABS(C146 - C147) + 27 / 28 * (ABS(C147 - C148) + 27 / 28 * (ABS(C148 - C149) + 27 / 28 * (ABS(C149 - C150) + 27 / 28 * (ABS(C150 - C151) + 27 / 28 * (ABS(C151 - C152) + 27 / 28 * (ABS(C152 - C153) + 27 / 28 * (ABS(C153 - C154) + 27 / 28 * (ABS(C154 - C155) + 27 / 28 * (ABS(C155 - C156) + 27 / 28 * (ABS(C156 - C157) + 27 / 28 * (ABS(C157 - C158) + 27 / 28 * (ABS(C158 - C159) + 27 / 28 * (ABS(C159 - C160) + 27 / 28 * (ABS(C160 - C161) + 27 / 28 * (ABS(C161 - C162) + 27 / 28 * (ABS(C162 - C163) + 27 / 28 * (ABS(C163 - C164) + 27 / 28 * (ABS(C164 - C165) + 27 / 28 * (ABS(C165 - C166) + 27 / 28 * (ABS(C166 - C167) + 27 / 28 * (ABS(C167 - C168) + 27 / 28 * (ABS(C168 - C169) + 27 / 28 * (ABS(C169 - C170) + 27 / 28 * (ABS(C170 - C171) + 27 / 28 * (ABS(C171 - C172) + 27 / 28 * (ABS(C172 - C173) + 27 / 28 * (ABS(C173 - C174) + 27 / 28 * (ABS(C174 - C175) + 27 / 28 * (ABS(C175 - C176) + 27 / 28 * (ABS(C176 - C177) + 27 / 28 * (ABS(C177 - C178) + 27 / 28 * (ABS(C178 - C179) + 27 / 28 * (ABS(C179 - C180) + 27 / 28 * (ABS(C180 - C181) + 27 / 28 * (ABS(C181 - C182) + 27 / 28 * (ABS(C182 - C183) + 27 / 28 * (ABS(C183 - C184) + 27 / 28 * (ABS(C184 - C185) + 27 / 28 * (ABS(C185 - C186) + 27 / 28 * (ABS(C186 - C187) + 27 / 28 * (ABS(C187 - C188) + 27 / 28 * (ABS(C188 - C189) + 27 / 28 * (ABS(C189 - C190) + 27 / 28 * (ABS(C190 - C191) + 27 / 28 * (ABS(C191 - C192) + 27 / 28 * (ABS(C192 - C193) + 27 / 28 * (ABS(C193 - C194) + 27 / 28 * (ABS(C194 - C195) + 27 / 28 * (ABS(C195 - C196) + 27 / 28 * (ABS(C196 - C197) + 27 / 28 * (ABS(C197 - C198) + 27 / 28 * (ABS(C198 - C199) + 27 / 28 * (ABS(C199 - C200) + 27 / 28 * (ABS(C200 - C201) + 27 / 28 * (ABS(C201 - C202) + 27 / 28 * (ABS(C202 - C203) + 27 / 28 * (ABS(C203 - C204) + 27 / 28 * (ABS(C204 - C205) + 27 / 28 * (ABS(C205 - C206) + 27 / 28 * (ABS(C206 - C207) + 27 / 28 * (ABS(C207 - C208) + 27 / 28 * (ABS(C208 - C209) + 27 / 28 * (ABS(C209 - C210) + 27 / 28 * (ABS(C210 - C211) + 27 / 28 * (ABS(C211 - C212) + 27 / 28 * (ABS(C212 - C213) + 27 / 28 * (ABS(C213 - C214) + 27 / 28 * (ABS(C214 - C215) + 27 / 28 * (ABS(C215 - C216) + 27 / 28 * (ABS(C216 - C217) + 27 / 28 * (ABS(C217 - C218) + 27 / 28 * (ABS(C218 - C219) + 27 / 28 * (ABS(C219 - C220) + 27 / 28 * (ABS(C220 - C221) + 27 / 28 * (ABS(C221 - C222) + 27 / 28 * (ABS(C222 - C223) + 27 / 28 * (ABS(C223 - C224) + 27 / 28 * (ABS(C224 - C225) + 27 / 28 * (ABS(C225 - C226) + 27 / 28 * (ABS(C226 - C227) + 27 / 28 * (ABS(C227 - C228) + 27 / 28 * (ABS(C228 - C229) + 27 / 28 * (ABS(C229 - C230) + 27 / 28 * (ABS(C230 - C231) + 27 / 28 * (ABS(C231 - C232) + 27 / 28 * (ABS(C232 - C233) + 27 / 28 * (ABS(C233 - C234) + 27 / 28 * (ABS(C234 - C235) + 27 / 28 * (ABS(C235 - C236) + 27 / 28 * (ABS(C236 - C237) + 27 / 28 * (ABS(C237 - C238) + 27 / 28 * (ABS(C238 - C239) + 27 / 28 * (ABS(C239 - C240) + 27 / 28 * (ABS(C240 - C241) + 27 / 28 * (ABS(C241 - C242) + 27 / 28 * (ABS(C242 - C243) + 27 / 28 * (ABS(C243 - C244) + 27 / 28 * (ABS(C244 - C245) + 27 / 28 * (ABS(C245 - C246) + 27 / 28 * (ABS(C246 - C247) + 27 / 28 * (ABS(C247 - C248) + 27 / 28 * (ABS(C248 - C249) + 27 / 28 * (ABS(C249 - C250) + 27 / 28 * (ABS(C250 - C251) + 27 / 28 * (ABS(C251 - C252) + 27 / 28 * (ABS(C252 - C253) + 27 / 28 * (ABS(C253 - C254)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - (C - XAVGC27.1) / 14 / (.071435345 * (ABS(C - C1) + 13 / 14 * (ABS(C1 - C2) + 13 / 14 * (ABS(C2 - C3) + 13 / 14 * (ABS(C3 - C4) + 13 / 14 * (ABS(C4 - C5) + 13 / 14 * (ABS(C5 - C6) + 13 / 14 * (ABS(C6 - C7) + 13 / 14 * (ABS(C7 - C8) + 13 / 14 * (ABS(C8 - C9) + 13 / 14 * (ABS(C9 - C10) + 13 / 14 * (ABS(C10 - C11) + 13 / 14 * (ABS(C11 - C12) + 13 / 14 * (ABS(C12 - C13) + 13 / 14 * (ABS(C13 - C14) + 13 / 14 * (ABS(C14 - C15) + 13 / 14 * (ABS(C15 - C16) + 13 / 14 * (ABS(C16 - C17) + 13 / 14 * (ABS(C17 - C18) + 13 / 14 * (ABS(C18 - C19) + 13 / 14 * (ABS(C19 - C20) + 13 / 14 * (ABS(C20 - C21) + 13 / 14 * (ABS(C21 - C22) + 13 / 14 * (ABS(C22 - C23) + 13 / 14 * (ABS(C23 - C24) + 13 / 14 * (ABS(C24 - C25) + 13 / 14 * (ABS(C25 - C26) + 13 / 14 * (ABS(C26 - C27) + 13 / 14 * (ABS(C27 - C28) + 13 / 14 * (ABS(C28 - C29) + 13 / 14 * (ABS(C29 - C30) + 13 / 14 * (ABS(C30 - C31) + 13 / 14 * (ABS(C31 - C32) + 13 / 14 * (ABS(C32 - C33) + 13 / 14 * (ABS(C33 - C34) + 13 / 14 * (ABS(C34 - C35) + 13 / 14 * (ABS(C35 - C36) + 13 / 14 * (ABS(C36 - C37) + 13 / 14 * (ABS(C37 - C38) + 13 / 14 * (ABS(C38 - C39) + 13 / 14 * (ABS(C39 - C40) + 13 / 14 * (ABS(C40 - C41) + 13 / 14 * (ABS(C41 - C42) + 13 / 14 * (ABS(C42 - C43) + 13 / 14 * (ABS(C43 - C44) + 13 / 14 * (ABS(C44 - C45) + 13 / 14 * (ABS(C45 - C46) + 13 / 14 * (ABS(C46 - C47) + 13 / 14 * (ABS(C47 - C48) + 13 / 14 * (ABS(C48 - C49) + 13 / 14 * (ABS(C49 - C50) + 13 / 14 * (ABS(C50 - C51) + 13 / 14 * (ABS(C51 - C52) + 13 / 14 * (ABS(C52 - C53) + 13 / 14 * (ABS(C53 - C54) + 13 / 14 * (ABS(C54 - C55) + 13 / 14 * (ABS(C55 - C56) + 13 / 14 * (ABS(C56 - C57) + 13 / 14 * (ABS(C57 - C58) + 13 / 14 * (ABS(C58 - C59) + 13 / 14 * (ABS(C59 - C60) + 13 / 14 * (ABS(C60 - C61) + 13 / 14 * (ABS(C61 - C62) + 13 / 14 * (ABS(C62 - C63) + 13 / 14 * (ABS(C63 - C64) + 13 / 14 * (ABS(C64 - C65) + 13 / 14 * (ABS(C65 - C66) + 13 / 14 * (ABS(C66 - C67) + 13 / 14 * (ABS(C67 - C68) + 13 / 14 * (ABS(C68 - C69) + 13 / 14 * (ABS(C69 - C70) + 13 / 14 * (ABS(C70 - C71) + 13 / 14 * (ABS(C71 - C72) + 13 / 14 * (ABS(C72 - C73) + 13 / 14 * (ABS(C73 - C74) + 13 / 14 * (ABS(C74 - C75) + 13 / 14 * (ABS(C75 - C76) + 13 / 14 * (ABS(C76 - C77) + 13 / 14 * (ABS(C77 - C78) + 13 / 14 * (ABS(C78 - C79) + 13 / 14 * (ABS(C79 - C80) + 13 / 14 * (ABS(C80 - C81) + 13 / 14 * (ABS(C81 - C82) + 13 / 14 * (ABS(C82 - C83) + 13 / 14 * (ABS(C83 - C84) + 13 / 14 * (ABS(C84 - C85) + 13 / 14 * (ABS(C85 - C86) + 13 / 14 * (ABS(C86 - C87) + 13 / 14 * (ABS(C87 - C88) + 13 / 14 * (ABS(C88 - C89) + 13 / 14 * (ABS(C89 - C90) + 13 / 14 * (ABS(C90 - C91) + 13 / 14 * (ABS(C91 - C92) + 13 / 14 * (ABS(C92 - C93) + 13 / 14 * (ABS(C93 - C94) + 13 / 14 * (ABS(C94 - C95) + 13 / 14 * (ABS(C95 - C96) + 13 / 14 * (ABS(C96 - C97) + 13 / 14 * (ABS(C97 - C98) + 13 / 14 * (ABS(C98 - C99) + 13 / 14 * (ABS(C99 - C100) + 13 / 14 * (ABS(C100 - C101) + 13 / 14 * (ABS(C101 - C102) + 13 / 14 * (ABS(C102 - C103) + 13 / 14 * (ABS(C103 - C104) + 13 / 14 * (ABS(C104 - C105) + 13 / 14 * (ABS(C105 - C106) + 13 / 14 * (ABS(C106 - C107) + 13 / 14 * (ABS(C107 - C108) + 13 / 14 * (ABS(C108 - C109) + 13 / 14 * (ABS(C109 - C110) + 13 / 14 * (ABS(C110 - C111) + 13 / 14 * (ABS(C111 - C112) + 13 / 14 * (ABS(C112 - C113) + 13 / 14 * (ABS(C113 - C114) + 13 / 14 * (ABS(C114 - C115) + 13 / 14 * (ABS(C115 - C116) + 13 / 14 * (ABS(C116 - C117) + 13 / 14 * (ABS(C117 - C118) + 13 / 14 * (ABS(C118 - C119) + 13 / 14 * (ABS(C119 - C120) + 13 / 14 * (ABS(C120 - C121) + 13 / 14 * (ABS(C121 - C122) + 13 / 14 * (ABS(C122 - C123) + 13 / 14 * (ABS(C123 - C124) + 13 / 14 * (ABS(C124 - C125))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/15/2011 Posts: 41
|
Thank you so much
Regards
|
|
Registered User Joined: 1/15/2011 Posts: 41
|
I'm sorry but I've made a mistake.
What I wanted was 14 minus 28 and I've ask exactaly the opposite
I've tried to put the last part of the formula in the beginning keeping the initial 50* but when I plot it I have the oscilator but without values in the scale.
I apologize but can you give the correct formula for 14 minus 28
Thank you again
|
|
Registered User Joined: 1/15/2011 Posts: 41
|
Ok
Thanks anyway
It already works!
Regards
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I'm happy to read you were able to figure it out on your own. Here's the reversed formula for anybody else following the topic.
50 * ((C - XAVGC27.1) / 14 / (.071435345 * (ABS(C - C1) + 13 / 14 * (ABS(C1 - C2) + 13 / 14 * (ABS(C2 - C3) + 13 / 14 * (ABS(C3 - C4) + 13 / 14 * (ABS(C4 - C5) + 13 / 14 * (ABS(C5 - C6) + 13 / 14 * (ABS(C6 - C7) + 13 / 14 * (ABS(C7 - C8) + 13 / 14 * (ABS(C8 - C9) + 13 / 14 * (ABS(C9 - C10) + 13 / 14 * (ABS(C10 - C11) + 13 / 14 * (ABS(C11 - C12) + 13 / 14 * (ABS(C12 - C13) + 13 / 14 * (ABS(C13 - C14) + 13 / 14 * (ABS(C14 - C15) + 13 / 14 * (ABS(C15 - C16) + 13 / 14 * (ABS(C16 - C17) + 13 / 14 * (ABS(C17 - C18) + 13 / 14 * (ABS(C18 - C19) + 13 / 14 * (ABS(C19 - C20) + 13 / 14 * (ABS(C20 - C21) + 13 / 14 * (ABS(C21 - C22) + 13 / 14 * (ABS(C22 - C23) + 13 / 14 * (ABS(C23 - C24) + 13 / 14 * (ABS(C24 - C25) + 13 / 14 * (ABS(C25 - C26) + 13 / 14 * (ABS(C26 - C27) + 13 / 14 * (ABS(C27 - C28) + 13 / 14 * (ABS(C28 - C29) + 13 / 14 * (ABS(C29 - C30) + 13 / 14 * (ABS(C30 - C31) + 13 / 14 * (ABS(C31 - C32) + 13 / 14 * (ABS(C32 - C33) + 13 / 14 * (ABS(C33 - C34) + 13 / 14 * (ABS(C34 - C35) + 13 / 14 * (ABS(C35 - C36) + 13 / 14 * (ABS(C36 - C37) + 13 / 14 * (ABS(C37 - C38) + 13 / 14 * (ABS(C38 - C39) + 13 / 14 * (ABS(C39 - C40) + 13 / 14 * (ABS(C40 - C41) + 13 / 14 * (ABS(C41 - C42) + 13 / 14 * (ABS(C42 - C43) + 13 / 14 * (ABS(C43 - C44) + 13 / 14 * (ABS(C44 - C45) + 13 / 14 * (ABS(C45 - C46) + 13 / 14 * (ABS(C46 - C47) + 13 / 14 * (ABS(C47 - C48) + 13 / 14 * (ABS(C48 - C49) + 13 / 14 * (ABS(C49 - C50) + 13 / 14 * (ABS(C50 - C51) + 13 / 14 * (ABS(C51 - C52) + 13 / 14 * (ABS(C52 - C53) + 13 / 14 * (ABS(C53 - C54) + 13 / 14 * (ABS(C54 - C55) + 13 / 14 * (ABS(C55 - C56) + 13 / 14 * (ABS(C56 - C57) + 13 / 14 * (ABS(C57 - C58) + 13 / 14 * (ABS(C58 - C59) + 13 / 14 * (ABS(C59 - C60) + 13 / 14 * (ABS(C60 - C61) + 13 / 14 * (ABS(C61 - C62) + 13 / 14 * (ABS(C62 - C63) + 13 / 14 * (ABS(C63 - C64) + 13 / 14 * (ABS(C64 - C65) + 13 / 14 * (ABS(C65 - C66) + 13 / 14 * (ABS(C66 - C67) + 13 / 14 * (ABS(C67 - C68) + 13 / 14 * (ABS(C68 - C69) + 13 / 14 * (ABS(C69 - C70) + 13 / 14 * (ABS(C70 - C71) + 13 / 14 * (ABS(C71 - C72) + 13 / 14 * (ABS(C72 - C73) + 13 / 14 * (ABS(C73 - C74) + 13 / 14 * (ABS(C74 - C75) + 13 / 14 * (ABS(C75 - C76) + 13 / 14 * (ABS(C76 - C77) + 13 / 14 * (ABS(C77 - C78) + 13 / 14 * (ABS(C78 - C79) + 13 / 14 * (ABS(C79 - C80) + 13 / 14 * (ABS(C80 - C81) + 13 / 14 * (ABS(C81 - C82) + 13 / 14 * (ABS(C82 - C83) + 13 / 14 * (ABS(C83 - C84) + 13 / 14 * (ABS(C84 - C85) + 13 / 14 * (ABS(C85 - C86) + 13 / 14 * (ABS(C86 - C87) + 13 / 14 * (ABS(C87 - C88) + 13 / 14 * (ABS(C88 - C89) + 13 / 14 * (ABS(C89 - C90) + 13 / 14 * (ABS(C90 - C91) + 13 / 14 * (ABS(C91 - C92) + 13 / 14 * (ABS(C92 - C93) + 13 / 14 * (ABS(C93 - C94) + 13 / 14 * (ABS(C94 - C95) + 13 / 14 * (ABS(C95 - C96) + 13 / 14 * (ABS(C96 - C97) + 13 / 14 * (ABS(C97 - C98) + 13 / 14 * (ABS(C98 - C99) + 13 / 14 * (ABS(C99 - C100) + 13 / 14 * (ABS(C100 - C101) + 13 / 14 * (ABS(C101 - C102) + 13 / 14 * (ABS(C102 - C103) + 13 / 14 * (ABS(C103 - C104) + 13 / 14 * (ABS(C104 - C105) + 13 / 14 * (ABS(C105 - C106) + 13 / 14 * (ABS(C106 - C107) + 13 / 14 * (ABS(C107 - C108) + 13 / 14 * (ABS(C108 - C109) + 13 / 14 * (ABS(C109 - C110) + 13 / 14 * (ABS(C110 - C111) + 13 / 14 * (ABS(C111 - C112) + 13 / 14 * (ABS(C112 - C113) + 13 / 14 * (ABS(C113 - C114) + 13 / 14 * (ABS(C114 - C115) + 13 / 14 * (ABS(C115 - C116) + 13 / 14 * (ABS(C116 - C117) + 13 / 14 * (ABS(C117 - C118) + 13 / 14 * (ABS(C118 - C119) + 13 / 14 * (ABS(C119 - C120) + 13 / 14 * (ABS(C120 - C121) + 13 / 14 * (ABS(C121 - C122) + 13 / 14 * (ABS(C122 - C123) + 13 / 14 * (ABS(C123 - C124) + 13 / 14 * (ABS(C124 - C125))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - (C - XAVGC55.1) / 28 / (.035717762 * (ABS(C - C1) + 27 / 28 * (ABS(C1 - C2) + 27 / 28 * (ABS(C2 - C3) + 27 / 28 * (ABS(C3 - C4) + 27 / 28 * (ABS(C4 - C5) + 27 / 28 * (ABS(C5 - C6) + 27 / 28 * (ABS(C6 - C7) + 27 / 28 * (ABS(C7 - C8) + 27 / 28 * (ABS(C8 - C9) + 27 / 28 * (ABS(C9 - C10) + 27 / 28 * (ABS(C10 - C11) + 27 / 28 * (ABS(C11 - C12) + 27 / 28 * (ABS(C12 - C13) + 27 / 28 * (ABS(C13 - C14) + 27 / 28 * (ABS(C14 - C15) + 27 / 28 * (ABS(C15 - C16) + 27 / 28 * (ABS(C16 - C17) + 27 / 28 * (ABS(C17 - C18) + 27 / 28 * (ABS(C18 - C19) + 27 / 28 * (ABS(C19 - C20) + 27 / 28 * (ABS(C20 - C21) + 27 / 28 * (ABS(C21 - C22) + 27 / 28 * (ABS(C22 - C23) + 27 / 28 * (ABS(C23 - C24) + 27 / 28 * (ABS(C24 - C25) + 27 / 28 * (ABS(C25 - C26) + 27 / 28 * (ABS(C26 - C27) + 27 / 28 * (ABS(C27 - C28) + 27 / 28 * (ABS(C28 - C29) + 27 / 28 * (ABS(C29 - C30) + 27 / 28 * (ABS(C30 - C31) + 27 / 28 * (ABS(C31 - C32) + 27 / 28 * (ABS(C32 - C33) + 27 / 28 * (ABS(C33 - C34) + 27 / 28 * (ABS(C34 - C35) + 27 / 28 * (ABS(C35 - C36) + 27 / 28 * (ABS(C36 - C37) + 27 / 28 * (ABS(C37 - C38) + 27 / 28 * (ABS(C38 - C39) + 27 / 28 * (ABS(C39 - C40) + 27 / 28 * (ABS(C40 - C41) + 27 / 28 * (ABS(C41 - C42) + 27 / 28 * (ABS(C42 - C43) + 27 / 28 * (ABS(C43 - C44) + 27 / 28 * (ABS(C44 - C45) + 27 / 28 * (ABS(C45 - C46) + 27 / 28 * (ABS(C46 - C47) + 27 / 28 * (ABS(C47 - C48) + 27 / 28 * (ABS(C48 - C49) + 27 / 28 * (ABS(C49 - C50) + 27 / 28 * (ABS(C50 - C51) + 27 / 28 * (ABS(C51 - C52) + 27 / 28 * (ABS(C52 - C53) + 27 / 28 * (ABS(C53 - C54) + 27 / 28 * (ABS(C54 - C55) + 27 / 28 * (ABS(C55 - C56) + 27 / 28 * (ABS(C56 - C57) + 27 / 28 * (ABS(C57 - C58) + 27 / 28 * (ABS(C58 - C59) + 27 / 28 * (ABS(C59 - C60) + 27 / 28 * (ABS(C60 - C61) + 27 / 28 * (ABS(C61 - C62) + 27 / 28 * (ABS(C62 - C63) + 27 / 28 * (ABS(C63 - C64) + 27 / 28 * (ABS(C64 - C65) + 27 / 28 * (ABS(C65 - C66) + 27 / 28 * (ABS(C66 - C67) + 27 / 28 * (ABS(C67 - C68) + 27 / 28 * (ABS(C68 - C69) + 27 / 28 * (ABS(C69 - C70) + 27 / 28 * (ABS(C70 - C71) + 27 / 28 * (ABS(C71 - C72) + 27 / 28 * (ABS(C72 - C73) + 27 / 28 * (ABS(C73 - C74) + 27 / 28 * (ABS(C74 - C75) + 27 / 28 * (ABS(C75 - C76) + 27 / 28 * (ABS(C76 - C77) + 27 / 28 * (ABS(C77 - C78) + 27 / 28 * (ABS(C78 - C79) + 27 / 28 * (ABS(C79 - C80) + 27 / 28 * (ABS(C80 - C81) + 27 / 28 * (ABS(C81 - C82) + 27 / 28 * (ABS(C82 - C83) + 27 / 28 * (ABS(C83 - C84) + 27 / 28 * (ABS(C84 - C85) + 27 / 28 * (ABS(C85 - C86) + 27 / 28 * (ABS(C86 - C87) + 27 / 28 * (ABS(C87 - C88) + 27 / 28 * (ABS(C88 - C89) + 27 / 28 * (ABS(C89 - C90) + 27 / 28 * (ABS(C90 - C91) + 27 / 28 * (ABS(C91 - C92) + 27 / 28 * (ABS(C92 - C93) + 27 / 28 * (ABS(C93 - C94) + 27 / 28 * (ABS(C94 - C95) + 27 / 28 * (ABS(C95 - C96) + 27 / 28 * (ABS(C96 - C97) + 27 / 28 * (ABS(C97 - C98) + 27 / 28 * (ABS(C98 - C99) + 27 / 28 * (ABS(C99 - C100) + 27 / 28 * (ABS(C100 - C101) + 27 / 28 * (ABS(C101 - C102) + 27 / 28 * (ABS(C102 - C103) + 27 / 28 * (ABS(C103 - C104) + 27 / 28 * (ABS(C104 - C105) + 27 / 28 * (ABS(C105 - C106) + 27 / 28 * (ABS(C106 - C107) + 27 / 28 * (ABS(C107 - C108) + 27 / 28 * (ABS(C108 - C109) + 27 / 28 * (ABS(C109 - C110) + 27 / 28 * (ABS(C110 - C111) + 27 / 28 * (ABS(C111 - C112) + 27 / 28 * (ABS(C112 - C113) + 27 / 28 * (ABS(C113 - C114) + 27 / 28 * (ABS(C114 - C115) + 27 / 28 * (ABS(C115 - C116) + 27 / 28 * (ABS(C116 - C117) + 27 / 28 * (ABS(C117 - C118) + 27 / 28 * (ABS(C118 - C119) + 27 / 28 * (ABS(C119 - C120) + 27 / 28 * (ABS(C120 - C121) + 27 / 28 * (ABS(C121 - C122) + 27 / 28 * (ABS(C122 - C123) + 27 / 28 * (ABS(C123 - C124) + 27 / 28 * (ABS(C124 - C125) + 27 / 28 * (ABS(C125 - C126) + 27 / 28 * (ABS(C126 - C127) + 27 / 28 * (ABS(C127 - C128) + 27 / 28 * (ABS(C128 - C129) + 27 / 28 * (ABS(C129 - C130) + 27 / 28 * (ABS(C130 - C131) + 27 / 28 * (ABS(C131 - C132) + 27 / 28 * (ABS(C132 - C133) + 27 / 28 * (ABS(C133 - C134) + 27 / 28 * (ABS(C134 - C135) + 27 / 28 * (ABS(C135 - C136) + 27 / 28 * (ABS(C136 - C137) + 27 / 28 * (ABS(C137 - C138) + 27 / 28 * (ABS(C138 - C139) + 27 / 28 * (ABS(C139 - C140) + 27 / 28 * (ABS(C140 - C141) + 27 / 28 * (ABS(C141 - C142) + 27 / 28 * (ABS(C142 - C143) + 27 / 28 * (ABS(C143 - C144) + 27 / 28 * (ABS(C144 - C145) + 27 / 28 * (ABS(C145 - C146) + 27 / 28 * (ABS(C146 - C147) + 27 / 28 * (ABS(C147 - C148) + 27 / 28 * (ABS(C148 - C149) + 27 / 28 * (ABS(C149 - C150) + 27 / 28 * (ABS(C150 - C151) + 27 / 28 * (ABS(C151 - C152) + 27 / 28 * (ABS(C152 - C153) + 27 / 28 * (ABS(C153 - C154) + 27 / 28 * (ABS(C154 - C155) + 27 / 28 * (ABS(C155 - C156) + 27 / 28 * (ABS(C156 - C157) + 27 / 28 * (ABS(C157 - C158) + 27 / 28 * (ABS(C158 - C159) + 27 / 28 * (ABS(C159 - C160) + 27 / 28 * (ABS(C160 - C161) + 27 / 28 * (ABS(C161 - C162) + 27 / 28 * (ABS(C162 - C163) + 27 / 28 * (ABS(C163 - C164) + 27 / 28 * (ABS(C164 - C165) + 27 / 28 * (ABS(C165 - C166) + 27 / 28 * (ABS(C166 - C167) + 27 / 28 * (ABS(C167 - C168) + 27 / 28 * (ABS(C168 - C169) + 27 / 28 * (ABS(C169 - C170) + 27 / 28 * (ABS(C170 - C171) + 27 / 28 * (ABS(C171 - C172) + 27 / 28 * (ABS(C172 - C173) + 27 / 28 * (ABS(C173 - C174) + 27 / 28 * (ABS(C174 - C175) + 27 / 28 * (ABS(C175 - C176) + 27 / 28 * (ABS(C176 - C177) + 27 / 28 * (ABS(C177 - C178) + 27 / 28 * (ABS(C178 - C179) + 27 / 28 * (ABS(C179 - C180) + 27 / 28 * (ABS(C180 - C181) + 27 / 28 * (ABS(C181 - C182) + 27 / 28 * (ABS(C182 - C183) + 27 / 28 * (ABS(C183 - C184) + 27 / 28 * (ABS(C184 - C185) + 27 / 28 * (ABS(C185 - C186) + 27 / 28 * (ABS(C186 - C187) + 27 / 28 * (ABS(C187 - C188) + 27 / 28 * (ABS(C188 - C189) + 27 / 28 * (ABS(C189 - C190) + 27 / 28 * (ABS(C190 - C191) + 27 / 28 * (ABS(C191 - C192) + 27 / 28 * (ABS(C192 - C193) + 27 / 28 * (ABS(C193 - C194) + 27 / 28 * (ABS(C194 - C195) + 27 / 28 * (ABS(C195 - C196) + 27 / 28 * (ABS(C196 - C197) + 27 / 28 * (ABS(C197 - C198) + 27 / 28 * (ABS(C198 - C199) + 27 / 28 * (ABS(C199 - C200) + 27 / 28 * (ABS(C200 - C201) + 27 / 28 * (ABS(C201 - C202) + 27 / 28 * (ABS(C202 - C203) + 27 / 28 * (ABS(C203 - C204) + 27 / 28 * (ABS(C204 - C205) + 27 / 28 * (ABS(C205 - C206) + 27 / 28 * (ABS(C206 - C207) + 27 / 28 * (ABS(C207 - C208) + 27 / 28 * (ABS(C208 - C209) + 27 / 28 * (ABS(C209 - C210) + 27 / 28 * (ABS(C210 - C211) + 27 / 28 * (ABS(C211 - C212) + 27 / 28 * (ABS(C212 - C213) + 27 / 28 * (ABS(C213 - C214) + 27 / 28 * (ABS(C214 - C215) + 27 / 28 * (ABS(C215 - C216) + 27 / 28 * (ABS(C216 - C217) + 27 / 28 * (ABS(C217 - C218) + 27 / 28 * (ABS(C218 - C219) + 27 / 28 * (ABS(C219 - C220) + 27 / 28 * (ABS(C220 - C221) + 27 / 28 * (ABS(C221 - C222) + 27 / 28 * (ABS(C222 - C223) + 27 / 28 * (ABS(C223 - C224) + 27 / 28 * (ABS(C224 - C225) + 27 / 28 * (ABS(C225 - C226) + 27 / 28 * (ABS(C226 - C227) + 27 / 28 * (ABS(C227 - C228) + 27 / 28 * (ABS(C228 - C229) + 27 / 28 * (ABS(C229 - C230) + 27 / 28 * (ABS(C230 - C231) + 27 / 28 * (ABS(C231 - C232) + 27 / 28 * (ABS(C232 - C233) + 27 / 28 * (ABS(C233 - C234) + 27 / 28 * (ABS(C234 - C235) + 27 / 28 * (ABS(C235 - C236) + 27 / 28 * (ABS(C236 - C237) + 27 / 28 * (ABS(C237 - C238) + 27 / 28 * (ABS(C238 - C239) + 27 / 28 * (ABS(C239 - C240) + 27 / 28 * (ABS(C240 - C241) + 27 / 28 * (ABS(C241 - C242) + 27 / 28 * (ABS(C242 - C243) + 27 / 28 * (ABS(C243 - C244) + 27 / 28 * (ABS(C244 - C245) + 27 / 28 * (ABS(C245 - C246) + 27 / 28 * (ABS(C246 - C247) + 27 / 28 * (ABS(C247 - C248) + 27 / 28 * (ABS(C248 - C249) + 27 / 28 * (ABS(C249 - C250) + 27 / 28 * (ABS(C250 - C251) + 27 / 28 * (ABS(C251 - C252) + 27 / 28 * (ABS(C252 - C253) + 27 / 28 * (ABS(C253 - C254)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/15/2011 Posts: 41
|
Thank you
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |