i want to use the Savitzky-Golay-Filter on a worksheet with 1 X axis and 800 y axes. is it possible to smooth all 800 curves at once? and when yes: how? :) thanks a lot
The easiest way is to loop over all the columns using a script:
int numcols = wks.ncols; for (ii=2; ii<=numcols; ii++) { smooth iy:=Sheet1!$(ii) method:=sg npts:=4 polyorder:=2 oy:=Sheet2!<new>; }
Highlight the entire script in the script window and hit enter to run it. The script above assumes you have your input data in Sheet1, with X data in column 1, and n Y data columns to the right. The output data is sent to Sheet2, and will create a new X for each. If you only care about generating new Y columns, the following will work:
int numcols = wks.ncols; for (ii=2; ii<=numcols; ii++) { smooth iy:=Sheet1!$(ii) method:=sg npts:=4 polyorder:=2 oy:=Sheet2!(<autoX>,<new>); }
Savitzky-Golay-Smoothing with 800 curves
Posted - 02/03/2011 : 2:49:50 PM
