How do I read the CSV file from an OWL +USB? (Legacy)

Further information is available in the software user guide attached to the downloaded software.

A CSV file is a comma-separated values file, where the data is stored as numbers and text in plain form with no formatting characters to be interpreted. A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form. This kind of file being plain text can be read using most text editors, such as NOTEPAD, however the data will be difficult to read and interpret.

You can import into a spreadsheet program which has a csv import facility Microsoft EXCEL will do this. Exported data has the following columns:

Sensor

Sensor identification associated with exported data.

Time

Timestamp of when data was recorded.

GHG Factor

GHG Factor applied to recorded data

Tariff Cost

Tariff Rate applied to recorded data.

Amps_Raw_Data

Raw data value relating to Amps measured by the sensor during that time period. (Mul

Amps_Raw_Data_Min

Minimum raw data value relating to Amps measured by the sensor during that time period

(ie Minimum value during that Day, Hour, Minute)

Amps_Raw_Data_Max

Maximum raw data value of Amps measured by the sensor during that time base

(ie Minimum value during that Day, Hour, Minute)

kW_Raw_Data

Raw data value of kW calculated using Amps_Raw_Data and the voltage applied in the settings window when data was recorded.

kW_Raw_Data_Min

Minimum raw data value of kW calculated using Amps_Raw_Data_Min and the voltage applied in the settings window when data was recorded.

kW_Raw_Data_Max

Maximum raw data value of kW calculated using Amps_Raw_Data_Max and the voltage applied in the settings window when data was recorded.

Cost_Raw_Data

Raw data value of cost of electricity using applied tariff during the period between this and previous time stamp.

Cost _Raw_Data_Min

Minimum raw data value of cost of electricity using applied tariff during the period between this and previous time stamp.

Cost_Raw_Data_Max

Maximum raw data value of cost of electricity using applied tariff during the period between this and previous time stamp.

GHG_Raw_Data

Raw data value of calculated weight of Carbon Dioxide emissions using applied conversion factor during the period between this and previous time stamp.

GHG_Raw_Data_Min

Raw data value of calculated weight of Carbon Dioxide emissions using applied conversion factor during the period between this and previous time stamp.

GHG_Raw_Data_Max

Raw data value of calculated weight of Carbon Dioxide emissions using applied conversion factor during the period between this and previous time stamp.

This data is compiled from the Data required by the monitor to display its own readings and the figures in the columns will need to be converted into real world data to make sense. Conversion factors apply to the data to do this.

Take the raw data and using the calculations below, convert the Current, Energy, Cost & GHG data columns.

  • Current (Amps) è Amps Value x 60
    • ie: 0.05 x 60 = 3 Amps
  • Energy (kW) è kW value ÷ 1,000
    • ie: 4.4 ÷ 1,000 = 0.0044kW (or 4.4W)
  • Cost (pence or cents) è Cost value ÷ 100,000
    • ie: 520000 ÷ 100,000, = 5.2pence
  • GHG (kg) è GHG value ÷ 100,000
    • 7100 ÷ 100,000 = 0.071kg (or 71g)
Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    Sergioaguado2004

    is CSV file available in the new Software version (2015)?

Please sign in to leave a comment.
Powered by Zendesk