Viewing Spreadsheet Data

We had ended the last section with the observation that we are able to view data logs in the form of a computer-friendly spreadsheet. Again, this is useful for quality control and a quick reference when needed. These displays can also be printed up and distributed to any relevant stakeholders; ideal for multiple users or from a safety standpoint. So, let us take a look at how these work and the method that they can be downloaded.

Viewing a Data Log File

You will first need to deactivate the detector before removing the memory card (M5-MMC). As previously, insert the card into your computer at the appropriate port. You will then need to select the “my computer” option. After finding the removable disk drive, double click on the icon. Then, select the logfile0.csv icon. You will then see the spreadsheet data.

However, there are a couple of things worth noting here. First, you should refer to table 15 in your owner's manual. This is found on page 70 and provides an excellent example of the standard format for the spreadsheet. Secondly, different operating systems will support different file sizes. There may be instances when not all data will be able to be displayed. You will need to check the data limit on your software to determine as to whether or not this is the case.

Your spreadsheet will contain various metrics that are displayed from left to right. Some of these will include the date, the day, the time and the levels of gases that are observed. These are toxic 1, 2 and 3 levels, the percentage of LEL readings, the status codes, the serial number of the device and the STEL and TWA readings.

One important notation here are the status codes. For the sake of brevity in formatting and storing the data, different occurrences have been assigned unique letter and numerical codes on the GasAlertMicro 5 data logs. Thus, instead of the spreadsheet stating “High Alarm” it will simply read “H”. Obviously, proper knowledge of these codes is essential in appropriately interpreting data. A comprehensive table that lists all associated status codes can be found on page 71 of your owner's manual. You will also find pump codes, battery status codes and alarm status codes.

Following these codes, there are other metrics that you will need to determine from their code form. These include gas sensor codes (the type of sensor in an abbreviated letter format), the correction factor codes for PID (these may or may not be applicable for your device), the correction factor codes for LEL readings and LEL unit codes (in percentage by volume of methane and simple %LEL). Finally, any TWA readings that are over 99 are simply recorded as “OL” on the spreadsheet (over the limit).

So, it is clear to see that the spreadsheet will offer a massive amount of information for those who wish to regularly monitor the performance of the detector. Due to the sheer variety of codes that will be displayed, it is advisable to use your owner's manual as a quick reference guide.