Reading Meter Data Exchange format files with Excel

itron

Summary

Analysis of meter data provides useful insights into how electricity is both generated and consumed. Microsoft Excel provides a convenient and easy to use platform to test and develop algorithms. The wide use of Itron’s Meter Data Management solutions means suitable meter data may be provided in Meter Data Exchange (MDE) format. When this occurs a separate module is required to enable Excel to read the MDE formatted files.

A simple implementation resulted in intermittent problems. While not conclusively proved evidence suggests the problem was related to Excel’s Visual Basic Environment (VBE), specifically the lack of control over how the VBE stores user defined binary data. An implementation reading each element individually proved successful.

Download Full Article

Citation

Copyright of this article remains with Dr Martin Gill. All references to this article should include the author’s name and website www.drmartingill.com.au.

Comments or Questions?

The author is happy to receive comments or questions about this article. He can be contacted here