Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users Joined: 10/28/2004(UTC) Posts: 3,111 Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
I could get the formula slightly shorter (849 characters vs 1150, and only two variables):
[code:1:5de08f2dc9]x1:=
Max(LinearReg(C,13),
Max(LinearReg(C,14),
Max(LinearReg(C,15),
Max(LinearReg(C,16),
Max(LinearReg(C,17),
Max(LinearReg(C,18),
Max(LinearReg(C,19),
Max(LinearReg(C,20),
Max(LinearReg(C,21),
Max(LinearReg(C,22),
Max(LinearReg(C,23),
Max(LinearReg(C,24),
Max(LinearReg(C,25),
Max(LinearReg(C,26),
Max(LinearReg(C,27),
Max(LinearReg(C,28),
Max(LinearReg(C,29),
Max(LinearReg(C,30),
Max(LinearReg(C,31),LinearReg(C,32))))))))))))))))))));
x2:=
Max(LinearReg(C,33),
Max(LinearReg(C,34),
Max(LinearReg(C,35),
Max(LinearReg(C,36),
Max(LinearReg(C,37),
Max(LinearReg(C,38),
Max(LinearReg(C,39),
Max(LinearReg(C,40),
Max(LinearReg(C,41),
Max(LinearReg(C,42),
Max(LinearReg(C,43),
Max(LinearReg(C,44),
Max(LinearReg(C,45),
Max(LinearReg(C,46),
Max(LinearReg(C,47),
Max(LinearReg(C,48),
Max(LinearReg(C,49),
Max(LinearReg(C,50),
Max(LinearReg(C,51),LinearReg(C,52))))))))))))))))))));
Max(x1,x2);[/code:1:5de08f2dc9]
The joys of Excel formula, and cut and paste!
I guess the next step is to find how often one LinReg variable is greater than another, to find those redundant values that are not worth looking for. If LinearReg(C,13) is ALWAYS going to be greater than, say LinearReg(C,52) then we dont need add LinearReg(C,52) into the formula.
wabbit :D
|