excel report multiple data

[kmarcella]

Hi,

I am trying to collect data from a DAQ system to report in Excel. I have multiple sensors collecting temperature, pH, etc. that I want to be reported each time the DAQ takes a sample. I have figured out how to set up the reporting to excel and am using Append Table to Report to write the data in excel. However,my table only reports one data set for each run when there should be multiple data points (samples taken) per run. How do I fix this? 

Thanks!

[natasftw]

You should post the code you already have.  It's much easier to determine what isn't going right when we can see what you're currently trying.

It sounds like you successfully report all of the different measurements and the problem you are running into relates to only showing each thing once.  If I had to guess, I'd suspect you're using either a while loop or a for loop and you're writing the data outside of the loop.  The fixes for this are either to build an array of your outputs and output that or to move the write inside of the loop.  Otherwise, you'll only write the last data set.  Again, I'd want to see the code before I recommended either of these as a fix.

[kmarcella]

I have attached my code and the excel template I want the data in. Excuse the mess as I am new to LabView and have been working it out as I go. Currently, I only have it set up for temperature (for simplicity while I figure out the problem) but will eventually hook up the other sensors. 

I am wondering if my problem has anything to do with the MS Office Parameters I am requesting the data to be sent to? Or maybe the Input area within Excel?

Any help would be much appreciated. Thanks!

[kmarcella]

So I actually solved the problem by taking the reporting out of the while loop and setting the tunnel loop as concatenting. 

However, now I want to also write the elapsed time but can't figure out how to add this to my excel report. Thoughts on this?

[Bob_Schor]

Sure.  You've already done it (but probably didn't realize it).  Notice the first three Text writes ("Date", "Time", and "Operator_Name").  You probably figured out that the first two numbers in the top Cluster are the row and column of the Cell to write, and the Text becomes the header.  So figure out where you want to put Elapsed Time and make another cluster where you wire in the value as text (you know how to transform a Time value to text, I presume).  Don't get in the way of the Temperature array (you can always move it by changing the row/column in its cluster).

Bob Schor

[kmarcella]

Thanks for the quick response!

Do you mean transform the time into a Timestamp? I guess I'm confused because the input into "Append Report Text" is a string and I can't seem to figure out how to convert the time into an array for the string.

[Bob_Schor]

I don't know what you mean by Elapsed Time, but you are right that you need to convert time to a string.  If you have a number (like 5.3 "seconds"), you can use functions on the String Palette to convert the number to a string.  If you have a TimeStamp, there are functions on the Time Palette that can return strings such as "Dec 16, 2014, 8:15 pm".

BS

[kmarcella]

I guess what I'm having trouble with is reporting time for each measurement taken. The elapsed time should start at 0.0 and then go up from there. Unfortunately, I can't seem to figure out how to report the time each time a measurement has been taken?