LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

I need help structuring my VI

Hello!

 

This is a pretty lengthy problem, so I hope that doesn't dissuade anyone!

 

Anyways, I am currently working on putting together this VI that will allow me to take thermocouple data at a very high sampling rate and post it straight to an Excel file.

 

It starts by checking the current temperature of the TC to make sure it has reached a stable (room) temperature. The next sequence block is for gathering data and the final block is for writing that data to an excel file.

 

What I'd like to be able to do is:

First check to make sure that the TC is up to room temperature, because I will be dipping these TC's in liquid Nitrogen repeatedly during testing. The next step is to gather the data that is taken as the TC is near entering the liquid N2 and then stopping as I would like to isolate the data that surrounds this event so that I don't have a huge amount of samples to work with. After that I would like to take that gathered data that shows the sharp drop in temperature and put it into an excel file. 

 

I'm not sure how to go about setting up this buffering of the data and how to have it be triggered. It might not be possible for all I know as it seems like it would hinge on an analog trigger of some sort. I am also a bit confused as to how to put this data straight to an excel file. I have looked through the example of exporting a table to excel but that just uses a prepopulated table for data, I would like to use data that is gathered, written to a table and then sent to excel.

 

Any help with this would be very much appreciated!

 

Have a good day,

 

~Neill

 

0 Kudos
Message 1 of 4
(2,534 Views)

My first thought is to use the Stream to TDMS function.  It's a DAQmx function.  This will save the data to a TDMS file automatically for you.  You can then use the TDMS Excel plugin to read the data in Excel.


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
0 Kudos
Message 2 of 4
(2,526 Views)

I was hoping to have the data be sent directly to the excel file instead of having to open the data by hand every time after a test. Is there a way where I can get the TDMS file to be sent right to an excel sheet?

0 Kudos
Message 3 of 4
(2,510 Views)

Add an Open file after done writing to it?

G# - Award winning reference based OOP for LV, for free! - Qestit VIPM GitHub

Qestit Systems
Certified-LabVIEW-Developer
0 Kudos
Message 4 of 4
(2,488 Views)