Remote (Event Controlled) Note Taker with Excel and SMS Link

This add-on records the reading of all channels to a text/spreadsheet file, SMS/Email to smartphone/PC or Excel directly when the Event flag is changed or the reading on a specified channel cross the threshold.

Video Demo of Remote (Event Controlled) Note Taker with Excel Link

Also see:

Manual logger for Excel data acquisition

Paced logger for Excel data acquisition

Configuration file

C:\Windows\remotenotetaker.ini

Sample Applications

1. Automatically logs the cargo weight while it is being moved through a conveyor belt.

Setup:

1. At the end of the scale, create a mechanical switch that connects to the Event inputs or a pre-specified channel (a pull-up is needed in this case)

2. Run WinDaq and this add-on

3. The cargo will be sent to the scale through a conveyor belt

4. The cargo will trip the switch set up in step 1

5. The weight will be logged to Excel spread sheet as well as a specified text file (as backup, in case Excel was closed accidentaly by the user)

2. See SMS/Emal alert system

Highlights

• Two trigger sources
  • Event Flag input
    • Same as the push-button on DI-145 and 149
    • This is not available to devices running non-standard HiRes firmware 
    • The EVENT flag on the device has internal pull-up
    • For 710 series, if Event Flag is used as trigger source, the digital channels must be enabled at channel 17 by entering letter "I"  to use this add-on; For 718B(x), digital channels must be enabled at channel 9 by entering letter "I"  to use this add-on
  • Analog Channel
    • This is available to ALL devices
    • The Analog Channel can be any channel in Windaq's scanlist.  When entering the channel number, please use the zero-based index to WinDaq's scanlist. For example, in the scanlist below, 0 select the first channel in the list, or channel 3, 1 selects 4, 2 selects Rate channel, and 3 selects Counter channel.
      
      
  • Trigger method includes rises, falls or changes.
  • Software de-bouncing optional
• Two trigger levels
  • TTL trigger level for Event flag
  • Any level within the range of the channel for Analog Channel trigger

• 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 

    • You need full version of Microsoft Excel to use this feature. Click here to learn more about this requirement.

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

• SMS and Email Link

  • Sends out SMS or email when an event is captured

  • Use SMS/Email Manager to configure it first

• Since all data points are examined during the operation, it may not keep up with high-speed operation

• Time stamp can be added to every row of data, with 1 second resolution.

• Excel compatible time stamp format to calculate time difference between events, see example below
  

  chn0(Volt)	chn1(Volt)	chn2(Volt)	chn3(Volt)	TimeStamp
  0	-0.0078125	-0.015625	0.015625	7/13/2010 14:39
  0	-0.0078125	-0.0078125	0	7/13/2010 14:39
  -0.0078125	0	-0.0078125	0	7/13/2010 14:39
  -0.0078125	-0.0078125	-0.0078125	0	7/13/2010 14:39
  0	-0.015625	-0.0078125	0	7/13/2010 14:39
  0	-0.0078125	0	0	7/13/2010 14:39
  0	-0.0078125	-0.0078125	-0.0078125	7/13/2010 14:39
  0	-0.0078125	0	-0.0078125	7/13/2010 14:39

© www.UltimaSerial.com