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
To Next Page
Loading...