Step 3 of 3 – Campbell Scientific RTDAQ Software User Manual

Page 365

Advertising
background image

Appendix B. Importing Files into Excel

Step 3 of 3

A quick look at the columns of data is provided in the Data Preview group
box. Highlight the column with the year/month/day and from the Column
Data Format
group box, select the Date option. From the drop-down list box
to the right of this option select the YMD format.

To complete the import, select the Finish button.

As imported, the Date and Time fields have a quotation mark in the field.

"TOACI1"

"CR10T"

"FiveSecond"

"TMSTAMP" "RECNBR" "counter" "SineOut" "IntTemp_C" "BattVolt"
"2002-01-17 16:31:45"

19787

340

-0.342

23.83

13.96

"2002-01-17 16:31:50"

19788

22

0.375

23.83

13.97

"2002-01-17 16:31:55"

19789

62

0.883

23.83

13.97

"2002-01-17 16:32:00"

19790

102

0.978

23.83

13.97

"2002-01-17 16:32:05"

19791

142

0.616

23.83

13.96

"2002-01-17 16:32:10"

19792

182

-0.035

23.83

13.97

B-3

Advertising