Section 8. Working with Data Files on the PC
Count(x;n) returns the number of data points (non blanks) in element x
over a full data set or every n
th
value.
Example:
Count(1) = 24 (24 data points in data set).
Blanks and Count are functions designed for checking the
integrity of the data file. A common use for these two functions
is “100.*BLANKS(x;n)/BLANKS(x;n)+COUNT(x;n)” which
gives the percentage of holes (bad data) in the file.
NOTE
Max(x;n) returns the maximum value of element x over a full data set
or every n
th
value.
Examples:
Max(5) = 17.12 (max WS for day)
Max(5;12) = 10.41 (max WS for 12 hours)
17.12 (max WS for 12 hours)
Min(x;n) returns the minimum value of element x over a full data set
or every n
th
value.
Examples:
Min(7) = 4.23 (min std. dev. of WS for day)
Min(3;8) = 55.33 (min temp for 8 hours)
59.79 (min temp for 8 hours)
55.22 (min temp for 8 hours)
RunTotal(x;n) returns a running total of element x for every line in the data
set. If an n
th
value is specified, a running total will be output
every n
th
value.
Example: RunTotal(5) =
5.85
14.12
21.87
29.47
39.88
48.87
:
:
:
166.76
182.38
199.50
211.36
211.36
Running total of hourly average wind speed provides up-to-
the-hour wind run for that day. Because an n
th
value was not
specified, the Final Summary output, which is daily wind, is
the same as the “total” output.
Sd(x;n) returns the standard deviation of element x over a full data
set or every n
th
value.
Examples:
Sd(3) = 3.6593 (std. dev. temp for day)
Sd(3;8) = 1.011 (Sd temp for 8 hours)
8-61
To Next Page
Loading...