Send data directly to Excel—No Software Wedge Required.
Getting data from your Mettler Toledo Digital Analytical Balance straight into Excel is actually pretty simple. Here's how to do it.
Grab an Advanced Systems and Designs SmartCable™ USB Keyboard single gage interface and plug it into your balance's RS232 port. The beauty of this setup? You don't need any extra cables.
The ASDQMS SmartCable™ Keyboard interface works through a standard USB 2.0 keyboard signal. Once you connect it to your computer, the operating system will see your Mettler Toledo Balance as just another keyboard that can type numbers into any program—no special software needed.
The numeric readings from your balance will show up exactly as if someone typed them on a keyboard, which completely eliminates those frustrating data entry mistakes. Using Excel or any SPC software? Just click where you want the number to appear.
You've got options for sending the data:
-
Hit the Print/Transmit button right on your Mettler Toledo Balance
-
Press the button on the SmartCable™ Keyboard gage interface
-
Step on a footswitch if you've got one connected (these are sold separately)
The LED lights on the interface help guide you during operation. Need your data formatted differently in your spreadsheet? You can easily configure the SmartCable™ single gage interface to output with CR, TAB, or directional commands (up, down, left, right). Just remove the top cover by loosening two Phillips screws to adjust the rotary switch.
The standard cable runs six feet, but if you need something different, just ask—custom lengths are available.
Every SmartCable™ Keyboard comes with detailed instructions. Usually, Advanced Systems and Designs configures the SmartCable™ to match your Mettler Toledo Balance's default settings. Make sure both devices are using the same settings. Check your Mettler Toledo Digital Balance manual for more about RS232 external communication options.
In summary,
-
ASDQMS SmartCable™ Keyboard: Specifically made for Mettler Toledo Digital Balances
-
Data Transfer: Works with Excel or any SPC program that can receive keyboard input
-
Triggering Options: Several ways to send data when you need it
-
Custom Cable Lengths: Available if the standard length doesn't work for your setup
-
Warranty: Comes with a lifetime warranty against manufacturing defects
Learn more HERE.