Array to spreadsheet problem

[Dennis_Knutson · Accepted solution]

It would take no more than 30 seconds to reduce all of the mulitple samples to a single one if that is all that concerns you. No changing of the timebase/clocking etc. Just use a Mean function. This is a trivial way solve the issue.

[Oesen]

Hmmm.. Isn't the mean function used to calculate average value og the samples ?

[RavensFan]

---

@Oesen wrote:

Hmmm.. Isn't the mean function used to calculate average value og the samples ?

---

Yes.  So you'd be taking the average of all the samples you've collected in that 1 second interval and thus reducing it down to the 1 sample you are actually looking for.  Or you could just use index array to get the first sample,  or get the last sample, or do whatever other data reduction you might like to go from hundreds or thousands of samples in 1 second to have just 1 value that represents that data.

Mean seems like a perfectly valid method to me.

[Dennis_Knutson]

---

@Oesen wrote:

Hmmm.. Isn't the mean function used to calculate average value og the samples ?

---

Of course. Why would that not be a simple and reasonable solution to this?

[Oesen]

Thanks for the help Dennis. It was very simple 🙂