Collecting Data points and saving it to a file

[MechTom]

So I have been trying to make a testor for my pumps.

It records voltage, current, temperature, and flowrate.

It sets the input voltage at predefined times and values.

The hardware is NI USB-6009, a remote controlled power supply, a flow meter, and a current sensor.

I am currently using LV 2009

I had the data accurately calibrated, collected, and ready to be stored and saved in an external document.

I tried using write to spreadsheet but i am having issues controlling the collection and formation of points.

I have also tried using write to measurement file but i am having issues using dynamic data and the final files presentation.

My ultimate goal would be:

A: several user input fields that will be corelated to be a header of a data set

B: a name updated based on certain aspect

C: data with a time stamp averaged over a certain number of collected points before it is put into the file

Attached is my current 2 files:

!Test is me trying to dabble in collecting dynamic data and using a waveform - not really working but looks better

This file has an automatically corrected voltage, waveform display, and the ability to turn on and off saving of the data.

NTW is me having a time controlled data collection run - working but the data isn't as accurate as I would like

This is my stable working code that has better formating control and actually outputs file in a useful way to a file.

I will be trying to combine the advantageous features of each and eventually save the data of pumps with different volutes, gearing, and motors. I am trying to do an optimization project.

Any tips or recommendations would be greatly appretiated.

[Samuel_S]

MechTom,

Write to spreedsheet should work if it is set up correctly 🙂 I would also consider looking at getting the report generation toolkit

Here are some examples of using write to spreedsheet which may be useful to look at (some of them maybe older but the programming practise should be similar in LabVIEW 2009)

http://zone.ni.com/devzone/cda/epd/p/id/4226

http://zone.ni.com/devzone/cda/epd/p/id/4456

http://zone.ni.com/devzone/cda/epd/p/id/4235

http://zone.ni.com/devzone/cda/epd/p/id/4503

Let me know if these work for you 🙂

[MechTom]

Thanks for responding.

I cannot open any of those files they all seem to be too old (versions 4 and 5) to be opened.

Today I tried redoing it all and it works really well. I had to change how and when i stores the information.

It saves the file with the information in the formated spots.

Once I am satisfied with its opperation. I will be adding notes and writing an explination for it, so that others might be able to learn from it. Sorry that it is kind of messy, but I was trying to avoid using sub Vi's.

Is there a way that i can make the VI none editable or at least parts of it? or even make it an .exe file?

I saw the Application builder, but I do not have the money for that upgrade as of now.

[Samuel_S]

MechTom,

That's great to hear! Yeah I was worried that they were too old. I have a very simple example of using the VI as well. I appreciate the help when you are done editing it feel free to post it or private messgae it and I can go through it and post it officially on the website for other users. 

The only way to make an exe or installer is the Application Builder but you can password protect a VI

http://zone.ni.com/devzone/cda/epd/p/id/3988

http://zone.ni.com/devzone/cda/epd/p/id/1353

🙂