325+ Electricians, Engineers and Energy professionals
trust and use our products.
Energy Meter Data Analysis and Reporting Template
R 970.00 Incl. VAT
We have created an Excel spreadsheet that can analyse and visualise data logged by energy usage logging meters. This file can be used as a template to be used repeatedly to analyse your energy logging data and to create reports. Import the .CSV (comma-separated values) in this Excel template and create graphs and tables in this template. Buy this template and save yourself the time of figuring out Excel, Power query editor, pivot tables and pivot graphs.
Sold Out – Get notified when it is back in Stock.
Would you like to be notified when this item is back in stock? Then please complete the form below:
This energy meter data analysis template turns a raw log file into a finished report. First, import the data from your energy meter; then Excel automatically builds the tables and graphs you need to review power demand, energy consumption, load balance and power factor.
Data visualised
- Power over entire time period
- Average power load profile per day
- Peak power per minute, hour, day and week
- Peak power per phase per minute, hour, day and week (Load balance per phase)
- Energy consumption per minute, hour, day and week
- Energy consumption during day and night
- Power factor
- Maximum voltage per minute, hour and day
- Maximum current per minute, hour and day
Energy meter data analysis features
- Limit data displayed to a specific day or hour
- Supports three-phase and single-phase setups
- Supports any brand energy meter; send us your data and we will change the template to be compatible with your data.
- Available languages: English and German
Once payment has been received, we will email you a link where the template can be downloaded and instructions on how it works.
Compatibility
The template can analyse data from the following Meatrol Energy loggers:
- Mi550
- ME440
- ME435 and
- MQ31
If you would like to analyse data from any other energy logger, please get in touch with us, and we will adapt the template to your data.
This template uses “Power Query editor“; it is a recent feature that has been introduced in Excel. So, the minimum Excel version required is: Excel 2021 (v16.0) Desktop
What is included
- Three-phase data analysis Excel template
- Single-phase data analysis Excel template
- Instruction document and videos.
- One hour remote support on WhatsApp, Video call and Screen sharing.
Instructions and Support
We offer remote support to help you with any problems importing or analysing the data. We support a variety of remote support software tools such as Skype, Teams, TeamViewer and AnyDesk. Additionally, we also have this instructional page and videos.
For instruction videos, documents and technical support click here
Energy meter data analysis template video
Energy meter data analysis screenshots
Frequently Asked Questions
You may also like…
-
R 22 050.00 Incl. VAT -
R 31 100.00 Incl. VAT
Related products
-
R 14 970.00 Incl. VAT -
R 28 995.00 Incl. VAT -
Price range: R 1 400.00 through R 1 700.00 Incl. VAT -
R 3 500.00 Incl. VAT -
R 970.00 Incl. VAT
Join our Newsletter
Stay up to date with the latest product developments and get 5% off your first order.