how to average(running average) intensity and time data read from a spreadsheet.

[luke_sh]

The time and intensity are two seperate columns. what i want to do is generate a running average of N data points, where the user specifies N, and write the runnning average values back to a file with their corresponding times.

All suggestions are welcome.

thanks,

luke S.

[GerdW]

Hi luke,

have a look at functions like "Read from Spreadsheet File", "Write to Spreadsheet File" and "Pt-by-Pt Mean"... Combine them with an autoindexing FOR-loop and you're done!

[luke_sh]

well i have to calculate the running average not simply one average point. THe user has control over how points to select the calculate the running averages. the intention of calculating the running averages is to smooth out the data. So i understand how to read in and write to files in spreadsheet format.  But i am having trouble wrapping my mind around how i will write back to the spreadsheet since i want to write back the time that corresponds to a particular intensity.

[luke_sh]

Clad:

Thanks for the reply. but i could not find the point by point mean function anywhere. I was able to mind the mean function under statistics(not sure if that is what you  meant)

thanks,

Luke.s

[GerdW]

Hi Luke,

my nick is GerdW - CLAD is a certification status

You will find "Mean PtByPt" here (atleast in the FullDevelopmentSystem)...