Campbell Scientific LoggerNet Datalogger Support Software User Manual

Page 358

Advertising
background image

Section 8. Working with Data Files on the PC

Semicolons are used in Time Series functions to separate the elements or

expressions from the count which determines the interval. SmplMax and

SmplMin require two elements separated by a semicolon. The first is checked

for a maximum or minimum, while the second is sampled on the maximum or

minimum.

The following set of weather data from Mt. Logan in northern Utah gives a

total of seven elements each hour. This Field Formatted output, with title and

column headers, was generated by Split. These data are used in the following

examples of Time Series functions.

Mt. Logan Weather Data

Day

Time

Airtemp

deg F

RH

Mean Wind

Speed mph

Mean

Wind

Direction

Std Dev of

Direction

178

100

58.56

17.42

5.855

338.3

6.562

178

200

57.48

17.65

8.27

344.8

7.51

178

300

56.85

17.76

7.75

330.8

5.065

178

400

56.55

18.89

7.6

319.7

10.93

178

500

56.57

19.6

10.41

307.3

4.23

178

600

55.33

23.32

8.99

317.7

6.258

178

700

55.95

24.79

9.52

322.3

4.609

178

800

58.12

23.98

6.588

315.6

9.43

178

900

59.79

23.46

5.458

312

15.32

178

1000

61.09

24.12

4.622

299.3

18.3

178

1100

61.34

25.03

5.926

303

17.26

178

1200

60.61

27.46

6.815

309.7

18.71

178

1300

61.01

25.44

8.35

310.2

18.37

178

1400

60.93

25.48

10.92

317.5

12.68

178

1500

62.3

23.79

8.43

310.6

19.21

178

1600

63.75

24.31

8.88

321.4

15.22

178

1700

66.15

22.45

7.97

341

17.77

178

1800

67.33

23.06

6.758

344.1

20.74

178

1900

66.59

24.75

7.08

341.8

16.09

178

2000

64.52

26.03

8.76

337.2

14.91

178

2100

59.84

27.45

11.81

305.4

12.36

178

2200

56.19

35.46

15.62

316.7

19.01

178

2300

55.48

38.8

17.12

338.7

11.41

179

0

55.22

37.13

11.86

351.6

8.22

Avg(x;n)

returns the average of element x over a full data set or every

n

th

value.

Examples:

Avg(3) = 59.898 (average daily temp)

Avg(3;4) = 57.36 (average 4 hour temp)

56.493 (average 4 hour temp)

60.708 (average 4 hour temp)

61.998 (average 4 hour temp)

66.148 (average 4 hour temp)

56.683 (average 4 hour temp)

Blanks(x;n)

returns the number of blanks or bad data in element x over a

full data set or every nth value. Refer to TABLE 8-9 for

definition of blank or bad data. Example:

Blanks(3) = 0 (no holes in data set).

8-60

Advertising