How To: Export Data to a Spreadsheet

Follow these steps to export data to a spreadsheet through the Modern Interface

Overview

It is possible to export data from the eGauge directly into a spreadsheet file. This file is in the CSV format, which is compatible with most common spreadsheet software. Note that certain software may attempt to truncate rows, which can lead to cells filled with # symbols - if this happens, the cell should be resized to fit the text it contains.

Prerequisites

  • The Export function for the Modern User Interface was introduced in firmware v. 4.6. If running an earlier version, upgrade firmware.

 

Instructions

Step 1: Click the menu(≡) in the upper left, then select Export

Step 2: Set the options for the data that you would like to export. Details regarding available options can be found at the end of this instruction section.

 

 

Step 3: Click ‘Download’ to download the requested data in .CSV format. The file will save to your computer with a filename of: export-eGaugexxxx.csv (eGaugexxxx will be your eGauge meter name) 


Export Option Details

Metric to Export

  • average (e.g., kW for energy) - export average values.
  • accrued value (e.g., kWh for energy) - export cumulative values relative to the start of the chosen date range.  Note that not all readings will make sense as accrued values such as temperature, or irradiance.  Cumulative values behave like a meter read. Take the difference between timestamped  values to calculate the accrued kWh over the elapsed time between them.
  • value accrued since epoch (e.g., kWh for energy) - export cumulative values relative to the start of recording for the meter.

Date Range

The date range defines the time frame that your data export will include. Choose one of the pre-set time ranges from the list or set a custom range by choosing 'custom range' from the list and setting the start and end dates with the calendar pop-up.  Any pre-set ranges that reference billing cycles (current or previous) will use the date set in the Preferences page of the Classic interface.

Include

  • final values only - This option will return simply the total accrued value for the entire date range chosen.
  • subtotals - Any of these options will return subtotals or averages at the granularity specified. Available intervals are: 
    • hourly subtotals/averages
    • daily subtotals/averages
    • weekly subtotals/averages

Options

  • Use metric units - metric units will be used where applicable when this slider is enabled.
  • Include peak demands - enabling this option will include a demand register as well as a peak demand time for each power register included in the export.  Options visible when this slider is enabled include:
    • calculate peak using
      • set demand
      • rolling demand
    • demand polarity:
      • positive
      • negative
      • positive or negative, whichever is (greater)
  • Demand interval length- can be set to 15, 30 or 60 minutes
  • Export all registers - enabling this slider will automatically include all configured registers in the export. Disabling it will enable the Filter option covered in the next section.

Export All Registers/Filter

Enable the filter option to choose which registers will be included in your data export by turning off the ‘Export all Registers’ option. When this option is enabled all registers will be included.

To add a new filter, tap the 'Add a filter' icon. You can choose to add or remove registers in the 'Append new filter' dialog based on the following options:

Disable ‘Export all registers’ to enable the filter. Click the ‘add a filter’ icon to add registers to export

Filter by:

  • Register Name - Filter available registers by register names that exist in the Installation Settings of the meter. This option is useful when you have a list of specific registers that you would like to include, and you would like to specify them by name.
  • Register type - Filter available registers by type. Using this option, you can choose to add all registers of a specific type, e.g. all registers recording 'Current' readings. 
  • Regular expression matching register names - advanced feature. This field can accept a regular expression (regex) that may exist within the Installation Settings register names.

Troubleshooting and Tips

  • Issue: Some of the cells in my export are filled with # symbols
    • Solution: Some spreadsheet software may attempt to truncate rows, which can lead to cells filled with # symbols - if this happens, the cell should be resized to fit the text it contains.