Can I subset an array (from excel) by time values for length?

[TRAVO]

Is it possible to slice portions of an array by time value per iteration? I am looking for a way to take a data sheet (taken from Excel) put into an array and then portion out 10 minutes at a time. The data sheet does not have exact sequential time value otherwise I would just use sample size (i.e. 600 for 10minutes). Instead of sample size can I search and subset by a time delta? I appreciate all the help I can get.

Thanks

[NIquist]

Probably, but you'll need to provide an example of how your data has been stored in Excel.

[GerdW]

Hi Travo,

yes, you can.

I would transform the time values into timestamps and then use standard comparison functions to search the correct data range...

[TRAVO]

Great GerdW, i am glad to hear that its possible. I was having a heck of a time trying to figure out how i would do that. Now I just have to figure out how to do what you are suggesting.Ha

I have attached my VI and a 20minute example. My VI is setup to subset by sample size right now.  

[NIquist]

There's a 'Seconds' column in the spreadsheet already.  It appears to be elapsed time.  It will be much easier to use that. 

[GerdW]

Hi NIquist,

that "Seconds" column is more of a counter when you compare it with those two timestamp columns...

Message Edited by GerdW on 03-16-2010 04:25 PM

[TRAVO]

Hi NIquist and GerdW, yes the "seconds" column is sort of an "elapsed time" (total) since the machine's start date. I have used it previously but for different things, for this instance I am hoping to capture 10minutes at a time in sequential order, once the data is set aside, i want to run it through a set of subvi's to count cycles for that 10min period. I then wish to write each 10min value to another sheet to include ending time-stamp, so each value should have a time-stamp incremented by minutes from indexed stamp.

does that help a bit?

Regards,

Travo 

[NIquist]

They look equivalent to me.  I see the timestamps going for 20 minutes.  The Seconds column goes from 7847295 to 7848495 = 1200 seconds = 20 minutes.

[GerdW]

Hi Travo,

could you please convert the "xlsx" to a more common xls - or even better a tab separated txt? At home I can't open your sheet...

Also all the subVIs are missing in your VI. From what I see I would suggest to use a different conversion as you have different datatype to convert (numbers, timestamps...)

[TRAVO]

Hi GerdW,

 Let me know if this works. I have put the VI into a project and created a shared library too. Dont know if this will work but if it doesnt I can just send all of the VI's together instead. I also included the xls file.

What do you mean by different conversion?

Thanks