Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

PCF for Avg( (Avg(AvgC2,3)-AvgC19), 5 ) Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
mjtran
Posted : Tuesday, January 13, 2015 4:57:05 PM
Gold Customer Gold Customer

Joined: 2/1/2006
Posts: 98

Hello Worden trainers,

Please help me with the following equation that I am trying to accomplish:

AVG(  (Avg(AvgC2,3)-AvgC19), 5 )

I got Avg( AvgC2, 3 ) - AvgC19 the same as

(C0+2*(C1+C2)+C3)/6 - AvgC19

Then I translate it further with the next Avg( ***, 5 ), of the equation above, and got the following, but when I try to plot it out, it does not seem to be correct.

( (AvgC5.0+AvgC5.3)*0.83+(AvgC5.1+AvgC5.2)*0.6-Avg(AvgC19.0,5))

Your help is very much appreciated.

Thank you,

-mjtran

mjtran
Posted : Tuesday, January 13, 2015 6:36:32 PM
Gold Customer Gold Customer

Joined: 2/1/2006
Posts: 98

I think it came out to:

((C0+C7+3*(C1+C6)+5*(C2+C5)+6*(C3+C4))/30-Avg(AvgC19.0,5))

I wish it something much simpler than the equation above.

Please correct me if I am wrong!

 

Thank you,

-mjtran

 

Bruce_L
Posted : Wednesday, January 14, 2015 9:46:22 AM


Worden Trainer

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

Your Indicator Formula should work, but the following might be a bit more intuitive.

(AVG(AVGC5,3) + AVG(AVGC5.1,3)) / 2 - AVG(AVGC19,5)



-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.