Windmill Data Acquisition Software Logo
19 December 2017

Windmill Software
Data Acquisition Intelligence
Call now: +44 (0)161 834 6688

Monitor - ISSN 1472-0221
The Newsletter for PC-Based Data Acquisition and Control
Issue 232, December 2017

Welcome to Monitor, the data acquisition and control newsletter. Thanks for subscribing and our complements of the season to you. If you wish to download our free data acquisition software please do so from https://www.windmill.co.uk/jsarrpsrr.htm.

You can download this issue of Monitor as a pdf file from https://www.windmill.co.uk/monitor/monitor232.pdf.

Follow @DataAcquisition on Twitter Google+ Data Acquisition News Feed (RSS)

Contents

* Your Data Acquisition Questions Answered
* Spreadsheet Corner
* Data Acquisition News Round-Up
* Measurement and Control Exhibitions


Your Data Acquisition Questions Answered

Question

"I have been trying to get a comparator (Heidenhain ND1200 Quadra-Chek) to communicate with a computer and stumbled across your ComDebug software. I'm completely new to this, and if all I can do is get the data to output into something I can port to Excel, I'll be happy. Right now I'm not sure how to parse the data because the sections of data are broken up by "009" characters. If I try to parse up to the next "009", the program tries to look for a 0, 0, 9 string, not the single unit "009". Do you have any advice on this?

Thanks immensely (because even if you can't help with this issue - your website/program has been quite helpful already)."

Answer

Thanks for your question and kind words! To parse the 009 you need to use the NonPrint menu in the Reply Parser. You could first search for the "009" character.

  • Choose Search as the Action then select NonPrint Decimal from the NonPrint menu.
  • Type 009 into the box that appears. It will be shown as \C(009) in the Parameters column.

Entering the 009 character

The next action will occur after the 009 character, and so you could extract until the next 009 character if you wished.

More on the ComDebug software is at https://www.windmillsoft.com/daqshop/rs232-modbus.html


Spreadsheet Corner: Automatically Resizing Columns

This tip applies to both Excel and Calc (OpenOffice and LibreOffice).

To quickly automatically size the column to its contents just double-click the column separator next to the column letter. A simple but little-used trick.

Calc

For more spreadsheet tips see https://www.windmill.co.uk/excel/ and https://www.windmill.co.uk/openoffice.html

If you have an Excel question contact monitor@windmillsoft.com.


DAQ News Round-up

Welcome to our round-up of the data acquisition and control news. If you would like to receive more timely DAQ news updates then follow us on Twitter - @DataAcquisition - or grab our rss feed.

Scientists track sharks by sampling seawater

Current methods of baiting, hooking and filming sharks and other large fish are invasive, costly and require teams of scientists spending much time at sea. New study shows that a sample of seawater can provide the identifiable tracks of numerous species of shark.
Source: SCUBA News
http://news.scubatravel.co.uk/

Simple system to locate marine mammals

Researchers have developed an underwater acoustic system that locates marine mammals, underwater vehicles and other sound sources in the ocean, using no more than a single hydrophone as a receiver.
SCUBA News
http://news.scubatravel.co.uk/

Pan-European drone project detects toxic gases in disaster zones

Drone project is using photonics to detect toxic gases in the atmosphere following events such as wildfires, chemical explosions and volcanic eruptions.
Source: The Engineer
https://www.theengineer.co.uk/

Professor develops sensor network to help manage winter roads

A road surface temperature sensor which provides real-time data on road conditions is set for adoption on the UK's road and motorway network.
Source: University of Birmingham
https://www.birminghamresearchpark.co.uk/

Future cars could automatically detect and report potholes to keep roads safe

Connected road vehicles could be used to look out for potholes and transmit their location
Source: Engineering and Technology
https://eandt.theiet.org/

Robofish floats about tracking antibiotics in the Great Lakes

The idea is to put sensors on the robots, which do actually look like fish, so that you can gather data from different locations in an automated manner
Source: New Scientist
https://www.newscientist.com/


Measurement and Control Exhibitions

The quarterly update of data acquisition and control exhibitions around the world.

Electrotest Japan

17-19 January 2018
Tokyo Japan
Asia's leading exhibition specialising in test, inspection, measurement and analysis for electronics manufacturing.
http://www.nepconjapan.jp/

Smart Factory Expo

17-19 January 2018
Tokyo Japan
Exhibition for smart factory technologies and IoT solutions.
sma-fac.jp/en/

Euro Lab

14-16 March 2018
Warsaw Poland
International trade fair of analytical measurement and control.
http://targieurolab.pl/en/

DATE

19-23 March 2018
Dresden Germany
Design, automation and test exhibition.
https://www.date-conference.com/

Metromeet

19-23 March 2018
Dresden Germany
International industrial dimensional metrology conference.
http://metromeet.org/

MACH 2018

9-13 April 2018
Birmingham UK
Biennial exhibition of the best innovations and latest developments in the manufacturing technologies sectors.
http://automationworldkorea.com/

Smart Factory Expo + Automation World 2018

28-30 April 2018
Dresden Germany
Sensors, control, measuring instruments, SCADA, process control systems, environmental control, etc.
http://automationworldkorea.com/


* Copyright Windmill Software Ltd
* Reprinting permitted with this notice included
* For more articles see https://www.windmill.co.uk/
We are happy for you to copy and distribute this
newsletter, and use extracts from it on your own web
site or other publication, providing the above notice
is included and a link back to our website is in place.

For previous issues by subject see https://www.windmill.co.uk/monitorindex.html

DOWNLOAD DATA ACQUISITION SOFTWARE
As a thank you for subscribing we offer you the ComDebug data logging and Com port trouble-shooting software. Log data over RS232, RS422, RS485 or Modbus. Also included is a month's trial of the Windmill 7 logging, charting and control programs.

SUBSCRIBING OR CANCELLING SUBSCRIPTION Visit https://www.windmill.co.uk/newsletter.html and add or remove your e-mail address.

Windmill Software Ltd, PO Box 58, North District Office,
Manchester, M8 8QR, UK
Telephone: +44 (0)161 834 6688
Facsimile: +44 (0)161 833 2190
E-mail: monitor@windmillsoft.com
https://www.windmill.co.uk/
https://www.windmillsoft.com/


Subscribe to Monitor

Previous Issue Next Issue