LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to filter data in spread sheet file?

Hi again - it's the peaks I need, and I want to get rid of the noise. The noise is much larger in some files (peak to peak 600 mV) then in others I have (then it is less then 20 mV).

It looks as if the filtering will work fine for me! I am curious about seeing the vi!

Thanks a lot!
0 Kudos
Message 11 of 31
(1,491 Views)

Hi,

this is the vi !
Say me if it's good for you !

Best regards,
Vincent

V-F
0 Kudos
Message 12 of 31
(1,472 Views)

Hey,
I was thinking about your problem, and my method modifies the values of the peaks : it's good to clean a signal, but it is not exactly a denoised signal.
If you want to count peaks over 1V on your signal, you don't have to use cubic spline, just one for loop, and two shift registers.
Let me know what you need.
best regards,

vincent

V-F
0 Kudos
Message 13 of 31
(1,464 Views)
Hej,

I don't need the amplitude values, it is more a question of signal yes/no. The problem is, that the signals don't have a min value, but they have a value, that is, an amplitude between 0 and 10 volts (minus baseline shift). What I do is scrolling through the file at a resolution of 10 seconds (x-axis) and write down the times of the amplitudes of the peaks into a table (I then calculate the times between two peaks as well as the number of peaks in a certain time interval). If a peak is a peak or just noise is the decision I have to make, and quite often it is easy, b/c most of my files have a good noise-to-signal-ratio. But many files have (for unknown reason) a strong noise - it looks for me like two or more sine waves of changing frequency are superimposed to the signal. Maybe something was wrong with the low and high pass filters during recording.

Your scipt really helps me with the noisy files, but is it possible to modify it so that I can see the original values and the new values at the same time in two rows, or saving the new values to a new file? (Then I can copy and paste the new values next to the old values in a table in a second column and read the new file with Labview afterwards.)

But the other proposed script with the counting of the peaks above a certain threshold might really help me with the other files with almost no noise. Is it difficult to write a script which reads a file and writes the times of the peaks (that is, the high-low or up/down times, when the signal crosses the threshold) into two colums of a spread sheet?

By the way:
I have now installed the evaluation version of Labview 8.5 on my computer, so that I don't have to walk to the other building. I looked for my old script in the examples folder, but the old "daq"-folder is not there anymore, and the old strmdsk.llb is not included in V 8.5. I think that is because after V 6 NI changed the programming, like with the Nidaq-MX and the traditional Nidaq-drivers?


Sven
0 Kudos
Message 14 of 31
(1,454 Views)
Hi,

If I try to open one of the large files (120 MB) with the script I get an "Not enough memory" error from Labview (my PC has 2 GB Ram)?


Torsten
0 Kudos
Message 15 of 31
(1,423 Views)
Hey,
it's normal to have this problem  when you open such a big file.
What would you like to do ? count the peaks and create a file with all peaks, and the time from the beggining of the file ?
I'm in WE, I will do you a vi monday.
Best regards,
Vincent
V-F
0 Kudos
Message 16 of 31
(1,413 Views)
Well, I am interested into the interval times between the peaks - are they randomly distributed, or are there clusters, and if so, how do these look like? Are there pairings (like always two in a certain time interval, and random distribution between those pairs), and if so, how many peaks are clustered, and how many are not? So I scroll through the file and write down the times of the peaks, or, if it is not a peak but more a "flat hill", the "start" and "stop" times.
0 Kudos
Message 17 of 31
(1,388 Views)
Hi Sven,
to read such a big file you can load it piece by piece, then you shouldn´t have the memory problems.

Mike
0 Kudos
Message 18 of 31
(1,383 Views)
Hi Mike,

I am not sure, but it might be a problem because I have now Labview 8.5 and 6i installed, and now even 6i cannot read them anymore... Probably both installations interact with each other? At least, with 6i I had never trouble to read even the truly large files.

Regards,

Sven
0 Kudos
Message 19 of 31
(1,373 Views)


..., and now even 6i cannot read them anymore... Probably both installations interact with each other? ...

Hi Sven,
they don´t interact with each other, but if you open your 6.x vi´s with labview 8.5 and you save them, then you can´t open without saving for previous version.
Mike
0 Kudos
Message 20 of 31
(1,351 Views)