Software tool for the ADM Flow Meter (G6691A)

Version 4

    ADM-FM.jpgAgilent offers the ADM Flow Meter (G6691A) with replaceable calibrated cartridges. The Flow Meter has a black-and-White digital display and works with acoustic displacement measurement.

    The firmware can be updated by connecting the ADM Flow Meter to a computer via its microUSB port. Before this works, a driver needs to be installed that is available online as described in the manual.

    The USB port then emulates a serial COM port. With terminal programs like HyperTerminal or PuTTY, this serial port can be read, and the flow registered. Seeing it more comfortably and logging the results was not easily possible.

     

    I wanted to do just that, have a nice flow display on the computer screen with a graphical representation, and log flow values from time to time.

     

    As we all have Office 365/Office 2016 on our computers, it was an option to use one of these programs for the data acquisition. I chose MS-Access 2016 as I wanted to log data in a database. MS-Access can be programmed in Visual Basic for Applications (VBA) and I was familiar with it.

     

    The tool now comes as a compiled database file, ADMFlowmeter.accde, and a double-click starts it in MS-Access 2016, immediately the tool checks all serial ports and tries to find the one the flow meter is connected to. If it doesn't find it, you still can choose the right port yourself.

     

    And that's how it looks like:

    ADM3.jpg

    The drop-down field lets you choose the serial port COM1 to COM8.

     

    START and STOP will control the reading from the flow meter and the flow, and the time and date will be shown in the appropriate fields.

     

    START LOGGING will start the data logging to the internal table/log file approximately twice a second, the last 60 seconds will be graphically shown in the graphic window.

    The raw input from the flow meter will also be shown in hexadecimal format in the bottom field.

     

    Pressing the red button will empty the log file, pressing the orange button will show the log file and pressing the purple button will export the log file to Excel (XLS) format.

     

    A log file looks like:

     

    ADM2.jpg
    Date/times are in UTC.

     

    The blue buttons will direct you to the PC Connection manual online or the site to request a Certificate of Calibration.

     

    If someone without Office 2016 wants to run the tool a MS-Access 2016 Runtime version can be downloaded free from the Microsoft Download Center. Please read if the runtime library is compatible with your computer system, installation is done on your own risk.

     

    Resources: