P110 Energy Monitoring Export
This thread has been locked for further replies. You can start a new thread to share your ideas or ask questions.
Please correct/improve data export for P110:
Background:
The option "Export all data" on the P110 Energy Monitoring screen does not correctly export "All" data.
The email received after export includes the file Energy Usage.xls. This has 3 tabs - Day, Month, and Year.
The day tab includes Date and time (Hourly) for the last 7 days and Energy Usage(kWh). This is correct, but fails to display cost in place at the time for each row.
The Month tab includes Date for the last 3 months and Energy Usage(kWh) Daily. This is correct, but fails to display cost for each row. This would need to be calculated for each row as the cost could be changed at any point during the day.
The Year tab is incorrect as it only displays the current year to date and not the previous year (which now displays in the app). Again, cost should be calculated per row from the month tab.
This would be of great help when using the exported data, as well as being able to see and validate how "the cost is calculated", a question often asked in the forums.
Many thanks,,,
