Windmill Software Ltd
Windows Engineering Software

January 2004

The Newsletter for PC-Based Data Acquisition and Control
Issue 66       January 2004
--------------------ISSN 1472-0221----------------------

Welcome to the first Monitor of 2004, and a happy and 
prosperous New Year to you.  This month we would be 
very grateful if you could complete a short survey to 
help us improve the newsletter and our service.  It also 
gives you a chance to comment on our performance or 
anything else you'd like to talk to us about.

We hope you find the newsletter useful, but should you 
wish to cancel your subscription please do so at

* New Year Survey
* Windmill News: New Version of People Counting Software
* Excel Corner: How to Show Live Data in a Form

New Year Survey

As an aid to improving Monitor, and our technical 
support service, we are again seeking your views. We 
would be very grateful if you could answer these few 
questions and return the survey to us at 
[email protected] 
(Just press the Reply button and fill in the blanks.)

All information is confidential and won't be passed to 
any third parties. Miss out any questions you don't 
want to answer. 
1. Which sections of Monitor do you find the most interesting or useful? Please rank from 3 (very) - 2 (fairly) - 1 (not very) - 0 (not at all) - New product announcements - Real world examples of how Windmill is being used - Tips on using Windmill - Excel corner - Exhibition dates - Major articles and tutorials 2. Are there any topics you would like us to cover in Monitor? 3. Have you downloaded either the free Windmill 4.3 data acquisition software suite, the free ComDebug trouble-shooting software, or the demo software? (If none please go to question 5) Windmill 4.3 ComDebug Windmill Demo Streamer Demo 4. Did you experience any problems with the software and if so what were they? (Please say if you resolved the problems, or if you would like our assistance.) 5. Please could you tell us the make, model and type of instrument you are using? 6. Monitor features real-world examples of how people are using their PC for measurement and control. If you would be happy for your application to be featured, please give details here. 7. In what field of work are you? 8. Any other comments or suggestions on the Monitor newsletter or Windmill software? E-mail: Many thanks for your help.
________________________________________________________ ________________________________________________________ Windmill News: New version of VTupload, the people counting program ________________________________________________________ We've improved our people counting program, VTupload. Previously the software could count people passing through up to 120 entrances per site. The new version, however, has no such limit. Additionally, much more flexibility has been built into VTupload by means of "calculated channels". A simple use of these is to combine readings from several doorways to calculate people going through multiple entrances into a store. Previously you would have to have performed these calculations using other analysis software, like Excel. Now VTupload will record all the counts from individual doorways and the total count for several doorways. VTupload saves its counts in a text file, which you can open using any word processing, spreadsheet or other analysis program. The software monitors logging units connected to a PC's COM ports. The connections may be over RS232, RS485 or Ethernet. For more details contact [email protected] Related Topics: Monitor Issue 61, Windmill Chosen for New People Counting System ________________________________________________________ ________________________________________________________ Excel Corner: How to Show Live Data in a Form ________________________________________________________ Using the Windmill DDE Panel, it's very easy to set up live data links in an Excel worksheet. But one of our readers wanted to have a live link in the text box of an Excel form. Here's how. 1. Set up a data link from the Windmill DDE Panel to Excel. - Start displaying data in DDE Panel - Select a channel and choose to Copy to Clipboard. - Select Data as the type if information to copy, and press the Copy Selected Channels button. - In Excel open a new blank workbook and go to cell A2 of Sheet1. - Choose Paste Special from the Edit menu and paste the data as a link. Excel will now show live data from DDE Panel updating at the Panel's refresh rate. 2. In Excel Visual Basic Editor, create a form and call it UserForm1. 3. Add a text box and call it LinkChannel 4. Still in Visual Basic Editor, select Sheet 1 and insert this code Private Sub Worksheet_Calculate() UserForm1.Show 0 UserForm1.LinkChannel.Text = Worksheets("Sheet1").Cells(2, 1).Text End Sub 5. From the File menu select Close and Return to Microsoft Excel. The Worksheet_Calculate subroutine runs whenever a change in a cell's data causes Excel to recalculate. In our example it means that whenever a DDE link updates, the form will also update. One thing to be aware of is that if the DDE link should be lost (apart from by closing the DDE Panel) the spreadsheet can freeze. To stop the form being updated, close down DDE Panel. If you have trouble editing your form, due to repeated returns to the spreadsheet on every data update, either set a long refresh rate in DDE Panel or close it down. * Further Reading: For more on using Windmill with Excel see For notes on creating a form in Excel see ________________________________________________________ ________________________________________________________ * 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.


Previous Issue Next Issue