UltimaSerial Excel Data Acquisition
 

Excel data acquisition applications using Excel Link are discussed here, to stream/capture data to 32-bit or 64-bit Excel. 

  1. Window Trigger 
    • This method defines when streaming start and stop, e.g. start streaming when Channel1>3 (V), stop streaming when Channel2*Channel4>23 (Watt)
  2. Slope Trigger 
    • This method sends the readings of all channels to Excel when a trigger condition is met, e.g, when Channel 1 * Channel2 >23 (Watt)
    • Programmable pre- and post- trigger data length 
         
  3. Event Trigger
    • This method records the reading of all channels to a spreadsheet when the reading on a specified channel cross the threshold.
    • Sample Application

      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 a pre-specified channel (a pull-up is needed)

      2. Run WinDaq and Excel Link

      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 

       

  4. Manual Trigger
    • Single click to send readings directly to Excel spread sheet. 
    • Timestamp included




 

Last update: 02/22/24

© www.ultimaserial.com