Exporting Sensor Data for use in Microsoft Excel

Keywords: exporting sensor data, CSV, Excel, report


Summary:

The following steps will guide you through the process of exporting your sensor data to a CSV file and help you understand the format of the data file.



Exporting Sensor Data

  • Open iMonnit®.
  • Select Sensors from the main navigation menu.

  • Choose the sensor you need an excel export for in the list.
  • Pick the History tab.
  • On the far right of the sensor history data is a cloud icon. Selecting this icon will export an excel file for your sensor into your download folder.



Data File - Column (Field) Definitions

MessageID: Unique identifier of the message in our database.
SensorID: If multiple sensors are exported you can distinguish which reading was from which using this number even if the names for some reason are the same.
Sensor Name: The name you have given the sensor.
Date: The date the message was transmitted from the sensor.
Value: Data presented with transformations applied but without additional labels.
Formatted Value: Data transformed and presented as it is shown in the monitoring portal.
Battery: Estimated life remaining of the battery.
Raw Data: Raw data as it is stored from the sensor.
Sensor State: Binary field represented as an integer containing information about the state or the sensor when the message was transmitted. (See "Sensor State Explained" below).
Gateway ID: The Identifier of the gateway that relayed the data from the sensor.
Alert Sent: Boolean indicating if this reading triggered a notification to be sent from the system.
Signal Strength: Strength of communication signal between the sensor and the gateway, shown as percentage value.
Voltage: Actual voltage measured at the sensor battery used to calculate battery percentage, similar to Received Signal you can use one or the other or both if they help you.

 State (Explained)

The integer presented here is generated from a single byte of stored data. A byte consists of 8 bits of data that we read as Boolean (True (1)/False (0)) fields.

Sensor State Information

Using a temperature sensor as an example.

If the sensor is using factory calibrations the Calibrate Active field is set True (1) so the bit values are 00010000 and it is represented as 16.

If the sensor is outside the Min or Max threshold, the Aware State is set True (1) so the bit values are
00000010 and it is represented as 2.

If the customer has calibrated the sensor this field the Calibrate Active field is set False (0) AND the sensor is operating inside the Min and Max Thresholds, the bits look like 00000000 this is represented as 0.

If the sensor is using factory calibrations and it is outside the threshold the bit values are 00010010 and it is represented as 18 (16 + 2 because both the bit in the 16 value is set and the bit in the 2 value is set).

Note: These two are the only bits that typically observed outside of our testing procedures.

For more information on using Monnit® wireless sensors, visit the support section of our website.