Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
bedibra
Posted - 08/26/2017 : 07:17:04 AM Dear all, I am looking for a way to apply an fft filter on all columns of sheet1 and report the results in columns of sheet2. I am trying to do that using the before formula script. fft_filters 1!col(1) oy:= (2!col(1));
I have tried this code but it did not work : fft_filters 1! oy:= (2!col(1));
Thanks,
1 L A T E S T R E P L I E S (Newest First)
bedibra
Posted - 08/26/2017 : 09:09:29 AM I just found this script, which is working well: range r1=[book1]sheet1!; for(ii=1; ii<=r1.nCols; ii++) { range ss = [book1]sheet1!col($(ii)); range dd = [book1]sheet2!col($(ii)); fft_filters (ss) oy:= (dd); }