This section explains the power consumption data file format (CSV format).
Each defined item of the exported power consumption data is separated by a comma (",").
Each line is exported in the following format.
Data format
Data is exported using the following format:
Time,power_monitoring_device_name(data_type)[,power_monitoring_device_name(data_type)]... |
Header line
The header line contains column titles identifying the data (from line 2 and later) that is displayed under each column. Each column title is set according to the data types that have been selected in the [Export Environmental Data] dialog.
Time
This column displays the date and time at which each power consumption data sample was collected.
Within data lines, the entry corresponding to this column is displayed in the following format: "YYYY-MM-DD hh:mm:ss" ("YYYY": Year, "MM": Month, "DD": Date, "hh:mm:ss": Hours:Minutes:Seconds). The time is displayed according to the time zone set in the Admin Server operating system.
Power monitoring device name (data type)
This column title defines the device and data type of the value displayed in the data lines under each column.
The "power_monitoring_device_name" part displays the name of the selected power monitoring device.
The "data_type" part displays the selected data type. Power (W) is shown as "power", Average Power (W) as "power-average", and Energy (Wh) as "energy".
Data lines
Each data line contains data values corresponding to each of the column titles shown in the header line.
A hyphen ("-") is displayed for any data that could not be collected.
Note
Regardless of the specified power monitoring device(s), the data held within Resource Coordinator VE that fits the conditions given for the selected time span and rate will be exported.
Depending on the status(es) of specified power monitoring device(s), the data corresponding to the specified time span and rate may not have been collected.
In this case, a hyphen ("-") will be displayed for any data that could not be collected.
Hyphens can be displayed when another power monitoring device (including a deleted one) has collected data at the same collection time, and the data was not collected by the specified power monitoring device.
If the "Finest sampling" rate is selected in the [Export Environmental Data] dialog, the power and average power values will be equal for each data sample.
If a rate other than "Finest sampling" has been selected in the [Export Environmental Data] dialog, values for each sample are displayed as follows. If data was collected at the displayed sample time, that value is displayed. If no data was collected at the displayed sample time, the data that was last collected in the time interval between that sample and the previous sample will be displayed.
The energy (Wh) value of a finest sample is calculated under the assumption that the power value (W) collected for the sample stayed at the same value until the next sampling (in other words it is assumed that power values (W) do not vary during the duration of the polling interval).
For rates other than "Finest sampling", the energy value is calculated as the sum of energy samples. The energy value of samples for which no data could be collected will be deemed to be 0.
The average power (W) of each sample is calculated from the energy value (Wh) of that sample and its corresponding time interval.
