LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Peak detection (threshold detector) from spreadsheets.

Hello!

 

I am working on VI that reads two signals, detects peaks that are above a specific treshold and then estimates time difference between these peaks in samples and in seconds.

Recently I have obtained two waveforms using an oscilloscope in a laboratory. Then I saved these two graphs in a spreadsheet in Excel format (first number is time, second is amplitude). Time difference between them is really small, just a few nanoseconds according to the oscilloscope. I think treshold should be 0.3.

 

My question is how to make Threshold Detector.vi read values from two excel files? Or maybe I need to use another instrument for this purpose. I am quite confused.


I attached all materials I have.

 

Any help is highly appreciated!

 

Thank you.

Download All
0 Kudos
Message 1 of 30
(2,710 Views)

Here are spreadsheets that I have got.

Download All
0 Kudos
Message 2 of 30
(2,705 Views)

@Ivan899 wrote:

Here are spreadsheets that I have got.


First of all, those aren't Excel files.  They are text files with commas as delimiters.  This casual mistake will only cause you grief on down the road.  Please learn to differentiate.  Now to confuse you even  more, use the "Read From Spreadsheet File.vi" with comma as delimeter to parse out the information, then manipulate the data however you want.  🙂

Bill
CLD
(Mid-Level minion.)
My support system ensures that I don't look totally incompetent.
Proud to say that I've progressed beyond knowing just enough to be dangerous. I now know enough to know that I have no clue about anything at all.
Humble author of the CLAD Nugget.
0 Kudos
Message 3 of 30
(2,686 Views)

PS - Sorry if you have tried this already.  I am crippled with using LV 2009 on this PC so I can't open your file without you saving it as an earlier version.

Bill
CLD
(Mid-Level minion.)
My support system ensures that I don't look totally incompetent.
Proud to say that I've progressed beyond knowing just enough to be dangerous. I now know enough to know that I have no clue about anything at all.
Humble author of the CLAD Nugget.
0 Kudos
Message 4 of 30
(2,683 Views)

I tried Read From Spreadsheet File.vi, but have not got any positive result. Probably it reads my spreadsheets, but peak detection does not work properly. When I set up any threshold in Threshold Detector.vi that is more than zero (for example, 0.01), final results turn to zero. The same occurs when indexes in Index Array  are not zeroes. 

I attached my vi saved for LV2009. Please, have a look.

Thanks.

Download All
0 Kudos
Message 5 of 30
(2,679 Views)

For some reason or other, the VI says it is saved in LV 12 (2012).  Sorry I'm causing you such pain.

Bill
CLD
(Mid-Level minion.)
My support system ensures that I don't look totally incompetent.
Proud to say that I've progressed beyond knowing just enough to be dangerous. I now know enough to know that I have no clue about anything at all.
Humble author of the CLAD Nugget.
0 Kudos
Message 6 of 30
(2,674 Views)

🙂

Sorry. 

Hopefully this one is for LV2009..

 

0 Kudos
Message 7 of 30
(2,667 Views)

Sigh... it says it can't load the front panel.  I guess someone else is going to have to take the lead now.  😞

Bill
CLD
(Mid-Level minion.)
My support system ensures that I don't look totally incompetent.
Proud to say that I've progressed beyond knowing just enough to be dangerous. I now know enough to know that I have no clue about anything at all.
Humble author of the CLAD Nugget.
0 Kudos
Message 8 of 30
(2,657 Views)

Smiley Sad

 

Thanks anyway..

0 Kudos
Message 9 of 30
(2,653 Views)

If no one helps you, you can always wait until I get home (8-ish) and then I can open it up the original file.  😉

Bill
CLD
(Mid-Level minion.)
My support system ensures that I don't look totally incompetent.
Proud to say that I've progressed beyond knowing just enough to be dangerous. I now know enough to know that I have no clue about anything at all.
Humble author of the CLAD Nugget.
0 Kudos
Message 10 of 30
(2,646 Views)