
User Manual for V2.8
–
2/21/2020
29
5.6.1. Sample Report from CSV File (Excel)
The user can select acoustic data in their portal to be exported as a Comma-Separated Values (CSV) file. The file can be viewed directly using Microsoft
Office Excel and/or imported into a Microsoft Office Word report template. Please note, access to Microsoft products such as Word or Excel are not
provided as part of SL-DOG package. Table 3 is an example export as viewed in Microsoft Excel (the following fields were hidden for formatting
purposes but they are included in exports: RX Operator ID, RX Device Num, TX Operator ID, TX Device num, Notes, User Fields 1-5, GPS Coordinates
Edited). For definition of terms, please reference pages 25-27.
Table 3. Sample Report from SL-DOG Generated CSV File
Record
Number
Measurement
Time
Test
Duration
Pipe
Length
Eval
Pipe
Length
Meas.
Status
Meas.
Status
Text
Assessment
Assessment
Text
GPS
Assessment
GPS
Assessment
Text
Pipe
Status
Current
RxLat
Current
RxLon
Current
TxLat
Current
TxLon
336
6/18/2015
14:45
79
150
106
1 Valid
10 GOOD
10 GOOD
Reject
41.754103
-88.350225
41.754063
-88.35061
335
6/18/2015
14:41
80
150
106
1 Valid
10 GOOD
10 GOOD
Good
41.754103
-88.350225
41.754063
-88.35061
334
6/18/2015
14:03
111
50
98
2 Late
10 GOOD
10 GOOD
Reject
41.754115
-88.350261
41.754098
-88.350621
333
6/18/2015
13:59
80
150
98
1 Valid
10 GOOD
9 GOOD
Reject
41.754115
-88.350261
41.754098
-88.350621
332
6/18/2015
13:52
79
50
79
1 Valid
4 FAIR
4 FAIR
Close
41.754071
-88.350706
41.753973
-88.350965
331
3/26/2015
9:51
80
250
293
1 Valid
8 GOOD
8 GOOD
Good
41.825467
-88.089827
41.825056
-88.088901
330
3/26/2015
8:54
79
250
293
1 Valid
1 POOR
1 POOR
Poor
41.825525
-88.089826
41.825106
-88.088906
329
3/26/2015
8:47
111
450
293
1 Valid
2 POOR
1 POOR
Poor
41.825525
-88.089826
41.825106
-88.088906
328
3/26/2015
8:32
79
250
234
1 Valid
7 GOOD
7 GOOD
Good
41.823533
-88.09129
41.822893
-88.09128
327
3/26/2015
8:25
80
50
82
1 Valid
6 FAIR
6 FAIR
Fair
41.82289
-88.091225
41.822686
-88.091099