Energy Meter Data Analysis and Reporting Template – Instructions

How to import data for data analysis, visualisation and reporting

Step by step guide

If anything is still unclear, you can follow this step by step guide.

Technical support

If you have any difficulty with the data import, transformation, analysis, or anything else, we will gladly support you.

Please contact: Johann Fritz for technical support on WhatsApp at +27 82 940 1858, or by email: Johann at AmpX.co 

Sample Data

Three-phase: To download sample data for testing click here. This data is for the ME435, make sure you change the source of the data of the ME435 tab.

Frequently Asked Questions

One common problem is the following. If you browse to the dot CSV file and open it in Excel, and only the first column is displayed and not the other columns, then it could be a problem with the list separator settings on your system. So in other words, you just see one column an not the other columns. That means Excel did not know how to seperate the data and is just showing you the first column. This setting can be changed under the advanced setting of your system regional settings.

To resolve this, refer to this article: https://www.ablebits.com/office-addins-blog/change-excel-csv-delimiter/

Or watch this video.

We are mostly able to resolve the problem through WhatsApp. Otherwise we can schedule a video call we prefer using MS Teams, but also have most of the other applications installed like Skype or Zoom.

Yes, as the data for 3-phase, 3-wire are very different from the data for a 3-phase, 4-wire recording. Please contact us for a template compatilble with 3-phase, 3-wire data.