Registered User Joined: 4/29/2006 Posts: 75
|
Hi Bruce,
You hleped me some time back with this PCF and need help to verify I have it coded corectly for yesterday. Please review and let me know if I need corrections.
Is this correct for yesterday's value?
((11 * V.1 *
((L.1 < xavgL4.1) - (H.1 > xavgH4.1)) + 9 * V1.1 *
((L1.1 < xavgL4.2) - (H1.1 > xavgH4.2)) + 8 * V2.1 *
((L2.1 < xavgL4.3) - (H2.1 > xavgH4.3)) + 7 * V3.1 *
((L3.1 < xavgL4.4) - (H3.1 > xavgH4.5)) + 6 * V4.1 *
((L4.1 < xavgL4.5) - (H4.1 > xavgH4.6)) + 5 * V5.1 *
((L5.1 < xavgL4.6) - (H5.1 > xavgH4.7)) + 4 * V6.1 *
((L6.1 < xavgL4.7) - (H6.1 > xavgH4.8)) + 3 * V7.1 *
((L7.1 < xavgL4.8) - (H7.1 > xavgH4.9)) + 2 * V8.1 *
((L8.1 < xavgL4.9) - (H8.1 > xavgH4.8)) + 1 * V9.1 *
((L9.1 < xavgL4.10) - (H9.1 > xavgH4.10))) / 11)
Thnaks, Richard
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Without seeing the original formula, my best guess would be as follows.
((11 * V1 * ((L1 < xavgL4.1) - (H1 > xavgH4.1)) +
9 * V2 * ((L2 < xavgL4.2) - (H2 > xavgH4.2)) +
8 * V3 * ((L3 < xavgL4.3) - (H3 > xavgH4.3)) +
7 * V4 * ((L4 < xavgL4.4) - (H4 > xavgH4.5)) +
6 * V5 * ((L5 < xavgL4.5) - (H5 > xavgH4.6)) +
5 * V6 * ((L6 < xavgL4.6) - (H6 > xavgH4.7)) +
4 * V7 * ((L7 < xavgL4.7) - (H7 > xavgH4.8)) +
3 * V8 * ((L8 < xavgL4.8) - (H8 > xavgH4.9)) +
2 * V9 * ((L9 < xavgL4.9) - (H9 > xavgH4.8)) +
V10 * ((L10 < xavgL4.10) - (H10 > xavgH4.10))) / 11)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 4/29/2006 Posts: 75
|
Thanks Bruce, I'll give it a try :-)
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|