1 / 12

A Tutorial on Gathering Information through a DAQ and outputting it to Excel

A Tutorial on Gathering Information through a DAQ and outputting it to Excel. By Morgan Muren. Setting up the Anemometer through the DAQ. Connect the two terminals from the anemometer to ai0 + and – on the DAQ. Connect the DAQ to your computers USB port. Run LabVIEW.

lucio
Download Presentation

A Tutorial on Gathering Information through a DAQ and outputting it to Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A Tutorial on Gathering Information through a DAQ and outputting it to Excel By Morgan Muren

  2. Setting up the Anemometer through the DAQ • Connect the two terminals from the anemometer to ai0 + and – on the DAQ. • Connect the DAQ to your computers USB port. • Run LabVIEW

  3. Setting up a VI in LabVIEW • Select VI from Template • Select Data Acquisition with NI-DAQmx.vi • Once open Double click on the DAQ Assistant VI to configure it.

  4. Setting up the DAQ • Select Analog Input, then Resistance. • Select the port you have the device connected to. (ai0 for this tutorial)

  5. Setting Up the Front Panel • Switch to Front Panel • On the controls panel, click on Express, then Graph Indicators, then click and drag the Graph icon onto the work space.

  6. Setting up Block View • Switch to Block View • Connect the newly formed Waveform Graph to the data port on the DAQ Assistant. • Right click on open space, go to File I/O, then Write Measurement File.

  7. Setting up Writing to Excel • Select where you want to save the .lvm file. • Make sure to check No headers button under Segment Headers. • Make sure to check One column only under X Value Columns.

  8. Collecting the Data • Connect the signals port on Write To Measurement File to the data port on DAQ Assistant. • Switch to Front Panel, spin up anemometer and hit Go arrow.

  9. Opening .lvm file in Excel • Find where you saved the .lvm file, right click on hit and select open. • On the windows message screen, click the program from a list button and then select Microsoft Office Excel from the list.

  10. Displaying in Excel • Highlight the two columns. • Go to insert, select line graph. • -note- The previous works for Excel 2007, in Excel 2003 highlight both columns, then select chart wizard, then line graph.

  11. The Final Product • Now you should see your newly created waveform graph. From here you can manipulate the graph as you see fit by right clicking on it and selecting properties.

  12. Questions?

More Related