Origin Ver. and Service Release (Select Help-->About Origin): 2015 SR1 Operating System: win7
Hello, I m fighting (again) with ranges and syntax which remains unclear each time I retry using it...
I have 250 time domain acquisitions in a worksheet, one acquisition per column with a sampling interval instead of a X column (same for all). I would like to get, in an other worksheet of 251 columns, 250 Fourier Transforms (fft1) of a part of the acquisitions (same begin and end indexes for all). I also target to get only one frequency scale (first column).
In the before formula section of a "set column value", I tried using range defining the worksheet (r1=[wksname]meas!, trying then to extract from it a range for each column (r2 = r1.col(1) or r1.col1 or hundreds syntax I tried) in a loop, then restrict it with index limits to pass it as argument for fft1 function. I miserably failed ! :-) Help did not... helped me, I haven't found a method for extracting a column range from a worksheet range.
Is there a smart way for doing these multiple FFT with same frequency scale (and same parameters) ?
range r1 = [Book1]Sheet1!;
range rCol1 = %(r1)col(1);
Besides, you can use the Set Multiple Columns Values tool (highlight multiple columns and then right-click on it to select Set Multiple Columns Values... from the context menu) to set the values and use wcol(j) to substitute the corresponding column.
using ranges for multiple FFT
Posted - 03/03/2015 : 12:57:33 PM
