Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 10/29/2004(UTC) Posts: 1,394 Location: Glastonbury, CT
Was thanked: 2 time(s) in 2 post(s)
|
A4:=If(IsUndefined(ExtFml("PowerPivots.Pivots")=4),0, If(IsDefined(ExtFml("PowerPivots.Pivots")=4),1,0)); A3:=If(IsUndefined(ExtFml("PowerPivots.Pivots")=3),0, If(IsDefined(ExtFml("PowerPivots.Pivots")=3),1,0));
A2:=If(IsUndefined(ExtFml("PowerPivots.Pivots")=2),0, If(IsDefined(ExtFml("PowerPivots.Pivots")=2),1,0)); A1:=If(IsUndefined(ExtFml("PowerPivots.Pivots")=1),0, If(IsDefined(ExtFml("PowerPivots.Pivots")=1),1,0));
An4:=If(IsUndefined(ExtFml("PowerPivots.Pivots")=-4),0, If(IsDefined(ExtFml("PowerPivots.Pivots")=-4),1,0)); An3:=If(IsUndefined(ExtFml("PowerPivots.Pivots")=-3),0, If(IsDefined(ExtFml("PowerPivots.Pivots")=-3),1,0));
An2:=If(IsUndefined(ExtFml("PowerPivots.Pivots")=-2),0, If(IsDefined(ExtFml("PowerPivots.Pivots")=-2),1,0)); An1:=If(IsUndefined(ExtFml("PowerPivots.Pivots")=-1),0, If(IsDefined(ExtFml("PowerPivots.Pivots")=-1),1,0));
B4:=If(A4=1,Highest(ValueWhen(1,A4=1,H)),0);
B3:=If(A3=1,Highest(ValueWhen(1,A3=1,H)),0);
B2:=If(A2=1,Highest(ValueWhen(1,A2=1,H)),0);
B1:=If(A1=1,Highest(ValueWhen(1,A1=1,H)),0);
Bn4:=If(An4=1,Lowest(ValueWhen(1,An4=1,L)),0);
Bn3:=If(An3=1,Lowest(ValueWhen(1,An3=1,L)),0);
Bn2:=If(An2=1,Lowest(ValueWhen(1,An2=1,L)),0);
Bn1:=If(An1=1,Lowest(ValueWhen(1,An1=1,L)),0);
Hr:=Max(B4,Max(B3,Max(B2,B1)));
Lr:=Min(Bn4,Min(Bn3,Min(Bn2,Bn1)));
Sto1:=(C-Lr)/(Hr-Lr);
Sto2:=(Hr-C)/(Hr-Lr);
Sto1;Sto2;
|