These are produced as a .csv file which can be viewed in Microsoft Excel. However the file directly retrieved from the data logger must be imported into a blank spreadsheet and have the “Comma Separated” values ticked. Otherwise you will not get the data separated into columns. Every GeoLogger will arrive to the customer partly pre-programmed and ready to install. As the GeoLogger is a bespoke product, it the data file it produces will relate to the sensors that are to be plugged in. This can be a variation of different output types each having their own unique title within the data file. Below is an example of the file you are produced with this particular table being programmed to record Tilt Sensors.
The usual titles apply here with Timestamp, Record Number, Logger Battery Voltage which are all self-explanatory. Cell B1 is usually your project name which will be based on the information provided to us at the time of order. C1 explains the data logger model number which in the above example is a CR800.
Depending on the output of the sensor, the following are the likely titles that would be assigned to each instrument:
Tilt Meter, Tilt Beam, In-Place Inclinometers:
Tilt A (1,1) – “A” being the A axis and usually in Sin θ. The number in brackets are only applied if the output of the sensor is RS485 and they are joined together by one cable (bussed system), the first number referring to the string number and the second number referring to which sensor that is in the string. For example “Tilt A (1,3)” would be the A axis of the third sensor in the first string.
Temp (1,1) – With the numbers in brackets you are able to identify which sensor this relates to as it is the same reference as the Tilt Meter it is reading from. For example “Temp (1,3)” would be the temperature reading of the third sensor in the first string.
Additional calculated columns – Sometimes when you have a string of Tilt beams or IPIs you may require the output file to produce calculated displacement in addition to the angles they produce. This requires additional programming which may be chargeable depending on the detail required. It should be specified at the time of order if this is a requirement to ensure you get the datalogger producing the data you need.
Vibrating Wire sensors:
Freq – This is the raw reading from the Vibrating wire sensor which will be a unit of Hz. The number assigned to this will always relate to the channel the sensor is plugged into.
Lin – This is the Linear version of the “Freq” which is Hz2/1000. The same applies to the number associated with this.
Therm – This is the Temperature reading from the Vibrating Wire sensor and should always output degrees Celcius unless otherwise specified. This along with the “Freq” and “Lin” readings will always relate to each other with a number indicating the channel it is plugged into. For example “Freq (3)”, “Lin (3)” and “Therm (3)” will all be readings from a Vibrating wire sensor plugged into channel 3.