• Gossen Metrawatt
  • Camille Bauer

U1600 Excel-Makro

Vielen Dank für Ihr Interesse! Wir werden uns umgehend um Ihre Anfrage kümmern.


Wir legen großen Wert auf den Datenschutz!
Lesen Sie hier mehr in unserer Datenschutzerklärung

Item number: Z302G

Macros for MS Excel for data transfer from U16xx summators

  • Macros for MS Excel for data transfer from U16xx summators
  • Technical characteristics

    Data from U160x summators included in the Energy Control System can be exported to an Excel spreadsheet and made available for customer-specific evaluations with Macro U1600.XLM for Microsoft Excel as of version 4.x. Connection of the PC to the summator is configured in Excel, and is established directly via the serial port, or with a dial-up modem.

    The following energy and power data, which are stored to memory at the summators, can be transferred to Excel:

    • Interval values from a period which can be specified with date and time
    • Maximum values from the interval, 11 absolute maximum values
    • Mean value and maximum measured interval value per day for the last 10 days and the current day
    • Mean value and maximum measured interval value per month for the last 12 months and the current month
    • Mean value and maximum measured interval value per year for the last 2 years and the current year

    The IP variant accesses the summators via Ethernet TCP/IP instead of the otherwise utilized RS 232 interface.

    Type designation, article number
    U1600.XLM for access to summators via RS 232, Z302G
    and Ethernet TCP/IP
    U1600.XLM update from any version *, Z302i
    U1600.XLM add-on license for one additional workstation*, Z302K
    U1600.XLM update additional license from any version *, Z302L

    * Proof of purchase of basic version or previous version required


Do you have any questions on the product or do you need technical information or details on the current delivery period? Our sales backoffice will be pleased to assist you.

We wish to spare you long waiting times on account of increased telephone traffic and therefore kindly ask you to send us a message. We assure you to get back to you as soon as possible. Thank you very much for your attention.

Sales Back Office

Telephone:+49 911 8602-111

Send message


Under myGMC you can register your product and receive up-to-date information on firmware updates, modifications of standards and many more topics.

Dialogue, Information and Actions: