Excel Macros


Dr Martin Gill performs the majority of his analysis using Visual Basic Macros within Microsoft Excel. From time to time he will discuss his experiences with this development tool.

Reading Meter Data Exchange format files with Excel

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…