Export Consumption Data From Component

Loading video please wait.

You can export the consumption data (kWh) from the components to a CSV file. By default this file will open using Table Analysis, but the file can be opened using most spreadsheet programs or text editors.

In the video the Half Hour consumption values are exported first. This is the consumption of the component aggregated into half hour periods.

Column #1. The period start time in seconds
Column #2. The period end time in seconds
Column #3. The period length in seconds (half an hour)
Column #4. The consumption in kWh.

Next in the video the raw consumption cycles are exported. This is the consumption information with no prior processing. 

Column #1. Component Name
Column #2. Circuit Name
Column #3. Cycle Start Time (seconds)
Column #4. Cycle End Time (seconds)
Column #5. Cycle Period (seconds) the difference between start and end times 
Column #6. Cycle Consumption Rate (kWh) 
Column #7. Cycle Consumption (kW)
Column #8. Cycle State 

The Cycle Consumption Rate is the amount of power that would be consumed if the device was on for one hour. The Cycle Consumption is the amount of power used for the given period. For example if a 60 watt light bulb was on for 10 minutes the Cycle Consumption Rate would be 0.06 kWh and the Cycle Consumption would be 0.01 kW.


Tags

export, half hour, consumption, data


Open in new browser new tab