Windmill Software Ltd
Data Acquisition Intelligence

28 June 2009

The Newsletter for PC-Based Data Acquisition and Control
Issue 131          June 2009
--------------------ISSN 1472-0221----------------------

Welcome to Monitor, the data acquisition newsletter.  

Today news of how the T & RVT company have chosen
Windmill software for their people counting systems.

I hope you find the newsletter useful, but should you wish 
to remove yourself from our mailing list please go to 

* Windmill News: New People Counting Resource
* Excel Corner: Quickly Switching between References
* DAQ News Roundup

Windmill News: New People Counting Resource

The company "T & RVT" are using Windmill software in 
their video people counting systems. 

CCTV cameras are mounted above doorways, corridors or 
streets and Windmill's intelligent people detection 
software counts the number of people passing underneath.  
Counts are regularly saved to disk or displayed in 
occupancy meters. 

Excel Corner: 
Quickly Switching between Absolute and Relative References

When writing an Excel formula, there are two ways you 
can reference a cell: absolutely and relatively.  

For example, in cell B1 you may write =A1. The value in 
cell A1 will then be shown in cell B1.  This is a 
relative reference.  If you copy the contents of B1 to 
B2, the formula will now read =A2.  The reference is 
based on the relative position of the cell that contains 
the formula and the cell to which the reference refers.  
In our case, one cell to the left. 

An absolute cell reference always refers to a cell in 
a specific location.  If you copy the formula to a new 
cell, the absolute reference remains the same.  An 
absolute reference is written =$A$1.

You can mix references, for example $A1. In this case the 
column is absolute and fixed, but the row is relative. 

You can quickly switch between types of reference with 
the F4 key. 
1. Select the cell containing the formula.
2. In the formula bar (labelled fx at the top of the 
   spreadsheet), highlight the references to be changed.
3. Press the F4 key. It will change the reference type. Keep 
   pressing and it will switch from one option to another.

You have to highlight the formula otherwise pressing F4 
will just repeat whatever action you last took, just 
like Ctrl Y does.

For more on using Excel for data acquisition see

DAQ News Roundup

Welcome to our roundup of the data acquisition and 
control news.  If you would like to receive more 
timely DAQ news updates then grab our RSS newsfeed 
at  Read for notes
on how to display the news on your own web site, 
read it via e-mail, mobile phone or in your browser.
10 scientific objects that changed the world
   To mark its centenary, the Science Museum in London 
   had its curators select the ten objects in its 
   collection that made the biggest mark on history. 
   Cast your vote in the public poll to decide the most 
   significant of all.
   Source: New Scientist

Texting Hyaenas
   Text messages sent from hyaenas could help wildlife 
   experts better understand their behaviour and 
   movements.  A study being carried out by a team at 
   Nottingham Trent University is aiming to fit brown 
   hyaenas with devices that transmit their location 
   using mobile phone network text messages, whilst radio 
   transmitters will help them to pin point their exact 
   location and record their movements and behaviour.
   Source: Nottingham Trent University

Industrial Controls Shipments plunge
   US association NEMA's Primary Industrial Controls Index   
   experienced its largest quarter-to-quarter decline on  
   record, contracting more than 23 percent in the first  
   quarter of 2009 versus the fourth quarter of 2008.
   Source: NEMA

Sensors check air conditioners' refrigerant
   Engineers at Purdue University have developed a 
   technique that saves energy and servicing costs by 
   indicating when air conditioners are low on refrigerant, 
   preventing the units from working overtime. 
   Source: Purdue University

Lack of frequent data collection impacts sustainability strategies
   IBM survey shows that companies are collecting data 
   infrequently, and not engaging enough with customers 
   and suppliers to attain stated corporate goals.  For 
   example, only 19% are collecting data on CO2 emissions 
   weekly or more frequently.  Respondents who reported 
   outperforming competitors are doing all those things 
   better - collecting and analyzing the right data 
   frequently to make better decisions
   Source: Control Engineering

* Copyright Windmill Software Ltd
* Reprinting permitted with this notice included
* For more articles see

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
and an index of articles at

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]


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.

Subscribe Monitor

You will receive an e-mail confirming your subscription, with details of how to download the free software. If you don't receive this then your spam filter may be blocking our message. Make sure it is set to accept messages from [email protected] If you have problems contact the Editor.

Previous Issue Next Issue