With the Measure Data Acquisition (DAQ) Add-in, you can acquire analog signals and place them directly into your Excel spreadsheets. With the DAQ Add-in, you can measure low-speed signals such as temperature, pressure, or strain, and high-speed waveforms within the Excel environment. The acquired data is placed directly into the cells that you specify in your worksheet -- no complicated conversion algorithms or programming is required.
Click on the arrow button to learn more about the Measure DAQ Add-in.
!
BEGIN_TEXT
!
Measure Data Acquisition Add-In
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
-1
0
0
0
0
3
3
-1
3
0
0
DAQDEM2.AVI
0
1
2565
3360
5070
2160
0
0
0
0
BEGIN_TEXT
The Measure DAQ Add-in is fully integrated into Excel. You configure analog I/O tasks through the DAQ menu which has been added to the standard Excel toolbar.
Pull-down the DAQ menu and select Configure DAQ Tasks to configure an analog input task.
!
BEGIN_TEXT
!
Measure Data Acquisition Add-In
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
ARR_U1R.BMP
ARR_U1_.BMP
38
444
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
5
2790
420
5070
2640
0
0
0
0
BEGIN_TEXT
Measure automatically senses which National Instruments plug-in DAQ boards you have installed in your system. If you have more than one board in your computer, you can specify which board to use for each Measure task from the Data Acquisition Device selection list that you can access through the DAQ menu.
Click on the arrow button to continue.
!
BEGIN_TEXT
!
Configuring an Analog Input Task
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
ARR_L1R.BMP
ARR_L1_.BMP
77
448
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
-1
0
0
0
0
3
3
-1
3
0
0
DAQDEM2.AVI
0
6
2775
555
4230
1860
0
0
0
0
BEGIN_TEXT
Currently, no I/O tasks are defined.
Click on the AI button to configure an analog input task.
!
BEGIN_TEXT
!
Configuring an Analog Input Task
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
ARR_U1R.BMP
ARR_U1_.BMP
161
461
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
8
3960
2250
7245
3225
0
0
0
0
BEGIN_TEXT
From this dialog box, you can specify parameters for controlling an analog input operation. You can select the input channels, number of points, acquisition rate, and location on your worksheet to place the acquired data. Start by specifying which analog input channels you want to include in your acquisition. You can include multiple channels in your analog input task.
For this example, we will acquire data from channel 1. You can also set the input limits for the data to be acquired. Measure automatically selects a gain setting for your DAQ board based on these expected signal limits.
Click on the Add button to add channel 1 to your channel list.
!
BEGIN_TEXT
!
Specifying an Analog Input Channel
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
ARR_D1R.BMP
ARR_D1_.BMP
70
305
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
9
3390
4215
4965
3015
0
0
0
0
BEGIN_TEXT
Your Scan Information setting specifies how many points are acquired from the channels in your channel list. A scan represents a single datapoint from each channel in your channel list. For this example, because you have selected only one channel in your channel list, the number of scans is equal to the number of total datapoints to be acquired.
Click on the arrow button to set the Number of Scans to 100.
!
BEGIN_TEXT
!
Specifying Scan Information
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
-1
0
0
0
0
3
3
-1
3
0
0
DAQDEM2.AVI
0
11
3465
285
3735
3480
0
0
0
0
BEGIN_TEXT
The Scan Rate determines how fast the datapoints is acquired. This value represents the number of scans, or number of sweeps through your entire channel list, to be performed per second. In other words, the scan rate represents the effective acquisition rate per channel for your analog input operation.
Double-click on the Scans\second control and change the value from 1000 to 5000 scans per second.
!
BEGIN_TEXT
!
Specifying the Scan Rate
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
ARR_L1R.BMP
ARR_L1_.BMP
253
453
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
17
1230
660
5400
2745
0
0
0
0
BEGIN_TEXT
Now that you have configured the channel and scan information, your analog input task is almost complete. The Display section determines where in your worksheet the acquired data will be placed. For this example, leave the input cell set at $A$1. Measure will place the 100 datapoints in the first column starting at cell $A$1.
Click on the arrow button to give a name to your new task.
!
BEGIN_TEXT
!
Naming Your Analog Input Task
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
-1
3
0
0
DAQDEM2.AVI
0
19
3645
4185
4920
1455
0
0
0
0
BEGIN_TEXT
Click on the Description button to add a description for your new analog input task.
!
BEGIN_TEXT
!
Naming Your Analog Input Task
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
21
4800
2460
5145
1965
0
0
0
0
BEGIN_TEXT
Task descriptions are important if other Excel users will be using the Measure tasks that you define.
Click on the arrow button to add a description for your new analog input task.
!
BEGIN_TEXT
!
Task Descriptions
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
-1
0
0
0
0
3
3
-1
3
0
0
DAQDEM2.AVI
0
22
4800
2460
5055
1485
0
0
0
0
BEGIN_TEXT
Click on the OK button to continue.
!
BEGIN_TEXT
!
Task Descriptions
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
24
2745
3555
5055
1485
0
0
0
0
BEGIN_TEXT
Now your analog input task is complete. Click on the OK button to test your new task.
!
BEGIN_TEXT
!
Testing Your Analog Input Task
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
26
2835
540
3435
3075
0
0
0
0
BEGIN_TEXT
As you can see, the Read Waveform task now appears in the task list. Notice that the task description also appears in the lower half of the dialog box. You can interactively experiment with your new task to ensure that it is working properly.
Click on the Run button to run the Read Waveform task.
!
BEGIN_TEXT
!
Testing Your Analog Input Task
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
ARR_D1R.BMP
ARR_D1_.BMP
142
480
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
28
2730
2310
3360
3150
0
0
0
0
BEGIN_TEXT
The Read Waveform task has acquired 100 datapoints from analog input channel 1 and placed them in the worksheet starting at cell A1. Once the data is placed into the worksheet, you can use standard Excel macros, analysis tools, or display utilities to further analyze your data and create reports.
Click on the OK button to close the Measure dialog box.
!
BEGIN_TEXT
!
Testing Your Analog Input Task
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
ARR_L1R.BMP
ARR_L1_.BMP
120
92
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
30
2955
1155
3360
3150
0
0
0
0
BEGIN_TEXT
Notice that Measure automatically highlights the datapoints in the worksheet so you can readily plot the data using the Excel Chart Wizard.
Click on the arrow button to chart the acquired data.
!
BEGIN_TEXT
!
Plotting the Acquired Data
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
-1
3
0
0
DAQDEM2.AVI
0
42
3495
5835
3360
3150
0
0
0
0
BEGIN_TEXT
As you can see, the data acquired forms a sinewave. Now you are assured that the Read Waveform analog input operation is working properly. You can build analog output tasks with Measure as well.
Click on the Measure DAQ menu and select Configure DAQ Tasks.
!
BEGIN_TEXT
!
Plotting the Acquired Data
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
ARR_U1R.BMP
ARR_U1_.BMP
37
440
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
46
2745
270
6885
2955
0
0
0
0
BEGIN_TEXT
You can also build analog output tasks with Measure. For analog output tasks, you specify worksheet cells containing voltage values that you want to output through your DAQ board. We have created an analog output task called "Output Sinewave" which now appears in the task list.
You now can select from two tasks in your task list: Read Waveform and Output Sinewave. If you are going to use these tasks many times, you can add them to the DAQ menu for easier access from your worksheet.
Click on the Edit Menu button to add these tasks to the DAQ menu.
!
BEGIN_TEXT
!
Adding Tasks to the DAQ Menu
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
ARR_R1R.BMP
ARR_R1_.BMP
393
168
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
48
4440
4050
4425
1575
0
0
0
0
BEGIN_TEXT
Click on the Add button to add the Read Waveform and Output Sinewave tasks to the DAQ menu.
!
BEGIN_TEXT
!
Adding Tasks to the DAQ Menu
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
52
5280
1350
4485
1230
0
0
0
0
BEGIN_TEXT
Click on the OK button to continue.
!
BEGIN_TEXT
!
Adding Tasks to the DAQ Menu
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
54
4485
1260
4485
1230
0
0
0
0
BEGIN_TEXT
Click on the OK button to Continue.
!
BEGIN_TEXT
!
Adding Tasks to the DAQ Menu
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
56
2460
3060
4485
2415
0
0
0
0
BEGIN_TEXT
Now you can run the tasks directly from the DAQ menu without having to open the Measure dialog boxes. This way, you can customize your Excel environment to let you perform specific analog I/O tasks through the DAQ menu.
Click on the DAQ menu to display the new task entries.
!
BEGIN_TEXT
!
Running Tasks from the Worksheet
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
58
3915
4770
4485
2415
0
0
0
0
BEGIN_TEXT
As you can see, the Read Waveform and Output Sinewave tasks now appear under the DAQ menu.
Click on the Read Waveform task to acquire waveform data again.
!
BEGIN_TEXT
!
Running Tasks from the Worksheet
0
0
0
0
255
255
255
255
0
0
0
0
0
0
255
255
255
0
5
ARR_R1R.BMP
ARR_R1_.BMP
73
386
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
~~
~~
0
0
0
0
0
3
3
0
3
0
-1
DAQDEM2.AVI
0
60
3555
4140
4860
3615
0
0
0
0
BEGIN_TEXT
New data values have been acquired and displayed in column A. Notice that the Excel macro is still active -- the new datapoints were automatically plotted on the chart.
With Measure, you can configure analog I/O operations with simple, easy-to-use dialog boxes. Your data is automatically placed in the worksheet cells that you specify -- with no programming or conversion algorithms required. You are then free to use the powerful Excel analysis and report generation tools with your data to complete your work.
Click on the arrow button to complete this module.
