Collecting Readings from Mettler Toledo Balances

Note - we no longer sell Windmill software as a stand-alone product, although you can still buy it with our data acquisition hardware or it is available to our newsletter subscribers. You can, though, download the free comDebug program to log data from one balance.

This page is provided for our existing customers and comDebug users.

Windmill software lets you continually log data from Mettler Toledo balances, and other instruments, on a PC running Windows. All data is time-stamped and can be imported into Excel either during or after data collection.

Windmill has been used with a Mettler Toledo balance to, amongst other things, monitor ripening grape weight for wine production.

To use Windmill to collect data from a Mettler Toledo balance: download the software then..

  1. Run the Windmill ComDebug, select Create a new Windmill Instrument File, and enter your balance's serial communication settings.
  2. Run the Windmill DDE Panel, Logger, Chart or Graphics program to save or display data from your balance.

After you have entered your configuration settings with ComDebug, you don't need to use this again and can go straight to the logging and display programs.

"I have succeeded in interfacing four different Mettler Balances to Excel using your free Windmill product and am very happy."

Using ComDebug to Enter Data about Your Mettler Toledo Balance | Data Logging Options | Getting the data into Excel | Fault-Finding


Using ComDebug to Enter Data about Your Mettler Toledo Balance

com port settings

For an overview of entering the configuration settings see the Getting Started with ComDebug page. Specific example settings for Mettler Toledo balances are given below.

COM Port Settings

These must be the same as your balance uses. Check the Mettler "Data Interface Operating Instructions" for your model, if in doubt start with...

Comm Port: Select the port to which your instrument is connected.
Baud Rate: 4800
Data Bits: 8
Parity: None
Stop Bits: 1
Flow Control: None

Data Format

In ComDebug's Terminal or Message Screen, enter a command or prompt string to send to the balance to ask for data. Click the Send button, and the instrument should send a reply (see Fault-Finding below if not). Now click the Parse button and enter instructions to extract the data from the balance's reply. Check your balance's Interface Operating Instructions for details of the commands to send, and the format of the balance's reply. The example given below requests a single stable value. Use the non-print menu to enter the carriage return (<CR>) and linefeed (<LF>).

Mettler prompt string
Example prompt command: S<CR><LF>
S is upper case.
Example data text string: S S     100.0 g
Data format: ASCII
Example parsing: Ignore Until 0123456789
Extract Until space

Extracting data from the balances reply

Instrument Timing

Read: Directly
Timeout: 5000 ms
Instrument Idle or Wait Time: 0
Data Persistence Time: 5000 ms

Further Information:
COM Port Settings
Mettler Toledo Standard Interface Command Set

 


Open Windmill DDE Panel

Use DDE Panel to show your data.

  1. From the File menu select Load Hardware Setup and choose the *.ims file you just saved.
  2. Connect your weight channel. You should see the correct weight in DDE Panel.
  3. Proceed similarly for the Logger and Chart programs.

Data Logging Options with Windmill Logger

Logger gives you many choices of how to start and stop collecting data.

  1. Log when you press the Start button in software
  2. Log only when the weight changes on the balance. Even if two items weigh the same, Windmill knows that a change has occurred and so no readings are missed.
  3. Log to a new data file at regular intervals, every hour or every day for example. This is useful in continuous, long-term logging.
  4. Log data only when channels are in an alarm state.
  5. Log data for a fixed duration, for example during an alarm condition and for ten minutes afterwards.
  6. Log data when you press the space key on the keyboard
  7. Use Excel to start and stop logging.
  8. Log from different balances at different rates.
  9. Log from different balancers to the same or different files.

Getting the data into Excel

You can use the Windmill Logger to collect data and after collection has finished import it into Excel. Alternatively, you can collect data with Excel in real-time by using an Excel macro to read data from the Windmill DDE Panel.


Mettler prompt string

Fault-Finding

If you are unable to get data from your balance go back to ComDebug's Terminal screen. Make sure your command is shown in the prompt grid, like in the picture. Click the Send button: does your instrument reply?

  1. If you only see your command being sent, and no data...
    1. Make sure that the balance is switched on and plugged into the PC's com (RS232) port.
    2. Check that the communication settings you entered in ComDebug match those currently in use by the balance: COM port, baud rate, parity, etc.
    3. If using a USB-RS232 converter, its settings must also match those used by the balance - read the USB-Serial page for details, especially point 7.
    4. If your balance says it is using 2400 baud, 7 data bits and even parity you may have it setup to talk to a printer rather than a computer. Use the balance's menu to change the Peripheral Unit from Printer to Host.
    5. Make sure your balance's send mode is not set to off. Check the balance's Send mode menu.
    6. If you still have problems then get the balance to send an identification message. Switch it off and then on and it should send identification string I4, e.g. I4 A "0123456789". If not check your cable. At least three connecting lines are needed: Data line from the balance (TxD signal), Data line to the balance (RxD) and Signal ground line (SG). If possible try swapping the cable between the balance and the PC for another to see if that is the problem.
    7. If still no luck see our Testing Serial Port Communication page.
       
  2. If, in ComDebug you see data coming in but DDE Panel isn't showing it, you may need to edit your parsing settings. Go to ComDebug's Terminal or Message Screen, click the Parse button. Enter your Ignore and Extract Settings and click the Step menu. Is your data shown in the Value column? If not adjust your settings.
     
  3. If you are getting accurate data readings, but much slower than expected, change your sampling rate. With COMIML, Windmill can make 5 readings per second per channel. So it can record one weight measurement every 0.2 seconds. If you have the sampling interval set much smaller than this, then Windmill may slow down considerably and only make a couple of readings per minute.


Success?

We hope Windmill helps with your project - if so, could you let us know? Thanks!

Details of how you 
are using Windmill:

    

              

      

    :        

    


Comments

Monitoring Continually Changing Weights

"Your software works with our Mettler weight. My problem is that I have to take measurements while the weight is changing. (I need to take measurements each second, while i empty a bag of fluid in a container on the weight.) When the weight isn't changing it works fine, but when I start the flow of the fluid, and the weight is changing constantly, I get errors. Is there a way, to get data out, while the weight is changing continuously?"

Instead of using a command to request a stable reading, use a command to immediately transmit the next weighing result without waiting for stability. For example, depending on the model of your balance, the command SI rather than S.

You could alternatively set the balance to continually send weighing results. In this case make sure that, in ComDebug, you choose "Read in the Background".


Learn More

To find out more - or to ask our advice on your project - enter your details below.