UltimaSerial Excel Data logger: Manual Note Taker with Excel Link

 

 WinDaq Add-on ID

7011

Menu Name Appeared under WinDaq->View->Add-ons

Manual Note Taker

Configuration file

C:\Windows\wdqnotetaker.ini

Manual Note Taker with Excel Link

A handy Windaq add-on records the reading of all channels to a text file or Excel spreadsheet with a single mouse click

The name NOTE TAKER was derived from the add-on's original application, in which it logs to a notepad compatible text file. Live Excel link was added per users' request.

Youtube Demo

For other Excel Links, please see:

Event controlled logger for Excel data acquisition

Paced logger for Excel data acquisition

Advanced Analog Trigger with Excel Link

Features

  • If log file extension is .csv, the file can be opened by spreadsheet program, such as Excel, immediately

  • Excel Link

    • Supports both 32-bit and 64-bit version Microsoft Excel 

    • If Send to Excel Cell option is checked, the readings will be sent to Excel immediately

  • To get stable readings, increase the average length in WinDaq.

  • Global Key option. When checked, you can use Alt+Ctrl+N (default) to take notes even when the addon is out of focus, ie, minimized or behind WinDaq.

  • The global keys stored in c:\windows\wdqnotetaker.ini can be reprogrammed

    • Open c:\windows\wdqnotetaker.ini and you will see multiple sections for different WinDaq configurations
      Under the section matching the device, you will see something like this

      NoteTakerKey=78
      HKey0=17
      HKey1=18

    • The numbers are Microsoft Virtual Key codes. The HKey0 and HKey1 are the two hot keys to mark the commands, which are Ctrl and Shift by default.

    • You can use change it to avoid conflict with other Windows application or add a new sets of command different Devices

    • For example, assign 49 to NoteTakerKey for WinDaq device 1 and 50 to NoteTakerKey for WinDaq device 2 , you can use Alt+Ctrl+1 to send the data from Device 1 to Excel book 1 and use Alt+Ctrl+2 to send the data from Device 2 to Excel book 2

  • Excel compatible time stamp format to calculate time difference between events (See example below)

    chn0(Volt)  chn1(Volt)  chn2(Volt)  chn3(Volt)  Comment  TimeStamp
    0 -0.0078125 -0.0078125 -0.0078125 test1 7/13/2010 14:37
    0 -0.0078125 -0.0078125 -0.0078125 test2 7/13/2010 14:37
    0 -0.015625 0 0   7/13/2010 14:38
    -0.0078125 -0.015625 -0.0078125 -0.0078125   7/13/2010 14:38
    -0.0078125 -0.0078125 -0.0078125 -0.0078125   TimeStamp disabled
    0 -0.015625 -0.0078125 0   TimeStamp disabled
    0 -0.015625 -0.015625 0   TimeStamp disabled
    -0.0078125 -0.015625 -0.0078125 0.0078125   TimeStamp disabled
    0.0078125 -0.015625 0.0078125 0   TimeStamp disabled
    0 -0.015625 0 0   TimeStamp disabled
    -0.0078125 -0.015625 0 0.0078125   TimeStamp disabled
    0 0 -0.0078125 0   TimeStamp disabled

 

Video Demo

To Use This WinDaq Add-ons

  1. Confirm WinDaq 3.16 or higher is installed on your computer

  2. Install WinDaq add-ons.

  3. Start WinDaq, and you will find the WinDaq add-ons integrated into Windaq->View->Add-ons menu (see the screen capture above).

  4. Do not change WinDaq's configurations while WinDaq add-ons are running, or some add-ons may terminate.

 

Last update: 02/28/22

© www.UltimaSerial.com