Data missing from measurement file

[cooljet]

I switch to Write to Spreadsheet file and this speeds thing up considerably. I have the following question:

- with the LVM file, I could easily perform post processing like spectral analysis, signal conditioning etc. How can I do that with the spreadsheet file since it does not contain the time-stamp? Is there an easy way to get around this?

Thanks

[cooljet]

Sorry repost

Message Edited by cooljet on 03-28-2006 07:45 PM

[Nishant]

Hii, Cooljet

    I am not sure, whether wat you want? if you want to timestamp your data in the spreadsheet file, there is the way, that you can time stamp the data before writing it into the file, i have attach the figure in which i ve shown that by taking Format Date/Time string and assigning them date and time format, you can get a time stamp for each record.

Thanks,

Nishant

[cooljet]

Hi Nishant,

Can you attach the figure again?

Thanks much

[Nishant]

Hiii, Cooljet

      i am really sorry that i forgot to attach a figure, actually this becomes "Data missing from the post".

   Dont worry here i am attaching it.

Thanks,

Nishant

[cooljet]

Hi Nishant,

Thank you very much for the figure. As I am scanning in kHz, is there any way to have the time-stamping in ms resolution? I don't need the date but just the time relative to the start of the measurement/scan, i.e. 0, 0.001, 0.002... sec

Message Edited by cooljet on 03-29-2006 07:30 AM

[cooljet]

I am using the Write to Spreadsheet file which takes numbers. How can I convert the time string to numbers?

Thanks.

[cooljet]

I tried adding the timestamp to the first column but there is only timestamp at 0.1 sec intervals with the rest of the entries blank or zero. Attached is the VI I use.

[Nishant]

Hiiii, Cooljet

           What is the minimum resolution time you require for the time stamp, actually i have achieved minimum of 15ms of time in Labview and i am not sure that LabVIEW will support time less than that and i think these fundas might go to the OS and system we are using, so left it. another thing here i am attaching the vi in which time has been converted to the numeric format, and you can simply understand what it has been done to do so. and about relative time i dont know what you can do?

             In the Vi i have read the time from the file and converted to the numeric, instead you can directly give the time,and i think it can solve your  problem.

Thanks,

Nishant

[cooljet]

Hi Nishant,

Thank you so much, you have been a great help 🙂

As I am scanning at 1kHz, the time resolution should be 1ms. But I guess I will just have to manually add in the column of ms timing.

Have a good one!