can anyone please tell me how to recover a signal from excel sheet

[Illa]

hi

i have an excel sheet consisting of signal amplitudes as shown in below example with respect to their time,please tell me how to construct a signal from them.i am attaching my saved signal excel file

eg:        time    amplitude 

              712    0.0424805

              713    0.0297852

                to       to

             1800  0.000283

[ZJ.Gu]

Hi illa,

It is not that difficult. In LabVIEW, you could use read from spreadsheet. (Save the xls as csv).

Thanks!

ZJ Gu

[Illa]

i am able to display the graph  i converted my Excel sheet to tabdeliminated format and displayed the graph

but i am unable to get the FFT of that please see the attachement i have attached my sanpshot of VI.

please tell me how to convert cluster of two elements to waveform

[DFGray · Accepted solution]

A waveform is essentially a cluster of three elements - a timestamp, t0, the time interval between the data points, dt, and the data Y.  To create one with your data, drop a Build Waveform primitive from the Analog Waveform palette.  Wire your Y data to the Y input and the difference between your first two X data points to dt.  You can leave t0 at the default (0 = 12PM Jan 1, 1904) or set it to something real.

[Illa]

sir i did it but when i am caluclating FFT for that stored data but why X axis time instaed of frequency. i am attaching my waveform and data please have a look

[ZJ.Gu]

Hi,

You set the dt =1. that means your sampling rate is 1Hz. I don't think it is right. Please set it to right value. And please use Signal Processing  -> Waveform Measure -> FFT Power Spectrum and PSD.vi to calculate the spectrum. I think you are using pure FFT VI. It will not include time/frequency info. Just do a pure "FFT" math calculation.

Thanks!

ZJ Gu