Windmill Data Acquisition Software Logo
October 2003

Windmill Software Ltd
Data Acquisition Intelligence


-------------------------Monitor------------------------
The Newsletter for PC-Based Data Acquisition and Control
Issue 63          www.windmill.co.uk        October 2003
--------------------ISSN 1472-0221----------------------

Hello, and welcome to October's edition of Monitor.  This 
month how to chart in Excel without leaving gaps. 

CONTENTS
========
* Excel Corner:
  Ignoring Empty Cells and Zeros when Charting
* Data Acquisition and Control Exhibitions
* Windmill News: 
  Windmill Reduces Train Brake Testing Time by a Third
________________________________________________________
________________________________________________________

EXCEL CORNER: IGNORING EMPTY CELLS AND ZEROS WHEN CHARTING
________________________________________________________

To chart empty cells without leaving gaps, you need to 
ask Excel to plot the cells as interpolated. To do this:
1. Select your Chart
2. From the Tools menu select Options > Chart > 
   Empty Cells Plotted as Interpolated.

To ignore the zeros you could simply search for 0 
(selecting to Find Entire Cells Only) and replace with 
an empty cell. Alternatively you could replace the 0 
with =NA(). This produces #N/A - an error value that 
means "no value is available."  Either way, the zeros 
will not now be plotted.

For more tips on charting with Excel see
http://www.windmill.co.uk/excel/excel-charting.html

________________________________________________________
________________________________________________________

WINDMILL NEWS: 
WINDMILL REDUCES TRAIN BRAKE TESTING TIME BY A THIRD
________________________________________________________

Travelling under the sea through the Channel Tunnel, the 
Eurostar connects the capital cities of France, England 
and Belgium.  It has been described as the world's most 
advanced train, and Windmill Software are pleased to 
have supplied the Eurostar with a single-car brake 
testing system.  And not only Eurostar, we have also 
recently delivered a multi-car brake testing system to 
Alstom Transport.  This reduces the time taken to test 
the brakes from 36 to 12 hours.

When the brakes are applied the Windmill system measures 
pressure waveforms, looking for delays and making sure 
the equipment reaches the correct pressure.  The multi-
car system uses eight single-car boxes communicating 
over RS485.  It can control airbag pressure and adjust 
for the weight of the people in the train. 

The system is set up and run through customised Windmill 
software.  The engineer selects from a menu of tests and 
chooses the thresholds on each measurement.  He can use 
the software to access the train control system, 
switching various relays etc.

The single-car Eurostar system uses our standard 
Streamer software.  This collects data at up 100 000 
samples per second and continually stores it to disk. 

At the end of the tests reports are automatically 
generated that provide a permanent record of the 
procedures and results. 

For more on the Streamer data collection software see
http://www.windmill.co.uk/streamer.html
For more on testing trains contact Windmill Software at 
[email protected]
________________________________________________________
________________________________________________________

DATA ACQUISITION AND CONTROL EXHIBITIONS
________________________________________________________

Continuing our bi-monthly listing of exhibitions and 
conferences related to data acquisition and control.

North West Manufacturing Exhibition
5-6 November
Reebok Stadium Bolton UK
The professional engineering solutions exhibition 
dedicated to manufacturing.
http://www.industry.co.uk/event.asp?CONTSUPREF=NWEST2003

Scanautomatic
18-21 November
The Swedish Exhibition Centre, Goteborg, Sweden
Sweden's industrial sector apparently has lots of money 
to spend, and this is Sweden's only automation 
exhibition.
http://www.swefair.se/scanautomatic/index.asp

Web Seminar - Wireless Networking of Sensors & 
Instrumentation: Applications and Techniques 
6 November 2003 
Seminar conducted over the internet.$195 per site per 
seminar for ISA members, $225 for non-members.
https://www.isa.org/

MERA
3-6 November
Krasnaya Presnya Moscow Russia
10th international fair for measurement, control and 
automation technology.
http://www.msi-fairs.com/merover.htm

Metrology
November 4-6, 2003 
Eilat, Israel 
Trends and Applications in Calibration and Testing 
Laboratories
http://www.isas.co.il/metrology2003/

NOx Emissions & Source Monitoring Technical Conference 
11 November 2003 
Trump Plaza Atlantic City NJ USA
Industry experts discuss measurement and control of low 
level NOx emissions, new concepts for NOx reduction 
techniques and innovative monitoring systems. 
https://www.isa.org/Template.cfm?Section=Events&template=/Conference/

Inspex
11-13 November
NEC Birmingham UK
Show dedicated to metrology, testing, inspection 
equipment and quality management.
http://www.teamshow.co.uk/metrology/index.cfm

Pollutec
2-5 December
Includes analysis, measurement and monitoring of air, 
water and soils.
Paris-Nord Villepinte France
http://www.pollutec.com/index_en.htm

mtec 2004 
Birmingham
11-Feb-04 to 12-Feb-04 
Addresses all aspects of sensor, measurement and 
instrumentation technology.
http://www.mtec-info.co.uk/
________________________________________________________

* Copyright Windmill Software Ltd
* Reprinting permitted with this notice included
* For more articles see http://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 publication, providing the above notice is 
included and a link back to our website is in place.


An archive of previous issues is at 
http://www.windmill.co.uk/newsletter.html
and an index of articles at 
http://www.windmill.co.uk/newsletter.html

Windmill Software Ltd, PO Box 58, North District Office,
Manchester, M8 8QR, UK
Telephone: +44 (0)161 833 2782
Facsimile: +44 (0)161 833 2190
E-mail: [email protected]

http://www.windmill.co.uk/

https://www.windmillsoft.com/


Subscribing

To receive Monitor every month please fill in your e-mail address below. We will not pass your address to any third parties, nor send you any unsolicited e-mail.

Email:
Format:

Previous Issue Next Issue