Halytech
hydroSpider2 User’s Manual v1.23
Page 124
Appendix I5.
Multi-column Report Format
Multi-column reports consist of the following columns:
1.
Date and time in d/mm/yyyy hh:MM format
2.
One column for each channel
3.
Modem signal strength
Below is a snippet of a sample multi-column report:
Sample multi-column report
Multi-column reports make it easy to view the data logged on each logging period. All of the records
that were logged during the same second line up in the same row.
Observe that the Float Switch channel has blank cells in the first 2 data rows. This happens whenever
there is no data for that particular second. Blank cells are a common occurrence for switches they
only log when they change value, and not at a regular interval like the rest of the channels.
Conversely, the next two data rows show the switch value changing to on and off, while the rest of
the channels show blank cells.
Aligned multi-column
reports have the same columns as standard multi-column reports. The
difference is that all records in this type of report are moved to be reported on the closest general
logging period timestamp.
This is useful if you have late-running sensors (eg: SDI-12, Modbus, etc) which cause normal multi-
column records to have multiple rows per logging period.
For example: multiple registers are being read from an SDI-12 channel. Each of these channels take
approximately 0.3 seconds to read. This means that SDI-12 channels 1-3 are logged at 06:00:00,
channels 4-6 at 06:00:01, and channels 7-9 are logged at 06:00:02.
In a standard multi-column report, this results in 3 disjointed rows produced per logging period.
However, the aligned multi column report causes all of these records to me reported on a single line
on the logging period time of 06:00:00. This results in a much easier-to-handle report file.
Note: this report format is not suitable for Switch and Event-type channels, as their records will also
be moved from their actual activation time to the logging period time.
