Generating Reports & Exporting Data

Types of Reports

Mana makes a number of reports available to you depending on your subscription tier. 

PPA and Tenant Billing Reports

General Reports

Device Data

Additionally, you can export the data that Mana acquired from your meter devices in various formats. This is data that is stored on Mana's servers.

Depending on the type of reading, it is available as raw data, normalized data (meaning it has been transformed to be consistent irrespective of device hw/configuration), hourly aggregated data, daily aggregated data, or monthly aggregated data.

→ Learn how to export device data

Remote Readings

Mana also provides a facility to export data directly from your devices. This is data that is extracted from the devices directly, or from your SCADA software.

→ Learn how to export remote readings

Website Table Data Export

→ Learn how to export table data

You can also export any table you see on the Mana website, for example:

→ Portfolio Batch Summary

→ Portfolio Summary

→ Site PPA Contract

→ Client Production

→ Portfolio Overview

→ Portfolio Issues & Readouts Analysis

→ Production Overview

Validate Data in Generated Reports

When you generate a report, the system inspects whether the data in the report has been validated at some point in time. If it finds any indications that the data may not be valid, a warning is displayed and you are given the opportunity to download the reconciliation log and you may also attempt to reload the data:

Hovering over the "Download Log" link you are shown a summary of systems where data may not be valid:

Download the Validation Log

Click on the [Download Log] link to do so.

The report contains the following columns:

  1. Timestamp: this is the date that the energy readouts refer to
  2. Sample Time: this is the date that the measurements were extracted from the device - this may correspond to the Timestamp, but it may fall on a later date if the device was offline for a while and the data was only extracted later, or if the data had to be reread from the device due to data validation failures (during a data reload)
  3. Site ID: the internal ID of the site, you may use this ID when communicating with Mana to identify a site
  4. Site Name
  5. System ID: the internal ID of the system
  6. System Name
  7. Aggregator? This is "1" for systems that have subsystems, 0 otherwise
  8. Device ID: the internal ID of the device that supplied the data (this would be the PRIMARY production/consumption device of the system)
  9. Device Name
  10. Validation Date: this is the date when Mana validated the data
  11. Total Energy Output MANA: this is the sum of energy readings that Mana has for that day for that device, this is the value that appears in reports and on various pages on the Mana website
  12. Total Energy Output Remote: this is the sum of energy readings for that day as returned by the device during validation, it should match the Total Energy Output Mana if validation was successful
  13. Discrepancy: (Total Energy Output MANA - Total Energy Output Remote) / Total Energy Output MANA
  14. Explanation

The validation status for a given device/day can be one of the following:

  1. Data validated successfully: the data was successfully validated on the date shown in the Validation Date column; this does not mean that the data at Mana matches the data on the device in the present
  2. Date has not been validated yet (because system is offline): the data will be validated once the system comes back online
  3. Date has not been validated yet (system is reporting 0 production): the data will be validated once the device starts reporting positive values again
  4. Date has not been validated yet: the data has not been validated yet for an unknown reason
  5. Date will be validated at end of day: not enough time has elapsed for validation to run
  6. Reconciliation invalid: local readings have changed: this indicates that the data was validated at some point in time in the past, BUT the local readings have changed since then, therefore it needs to be revalidated; this may come up if the data was manually reloaded from the device
  7. No production: 0 production was read from the device for the given day, and upon reconciliation the device confirmed that there was no production on that day; this usually implies that Mana is working OK but there is some issue on-site (inverter failure etc.)
  8. Site has not reported energy (because system is offline): the device has not reported any energy for that day, Mana will backload the data and validate it once the system comes back online
  9. Site has not reported energy (system is reporting 0 production): the device has been reporting 0 production, the Mana will backload the data and validate it once the system starts reporting positive values again
  10. Reconciliation failed: this indicates that the data needs to be reloaded (use the [Reload Data] button!)

Note that all information is refreshed when you download the report, so if you download the reconciliation log for a report generated in the past, the validation status will be the status on the day when you download the data, not the status that was known when the report was generated!