Campbell Scientific LoggerNet Datalogger Support Software User Manual

Page 357

Advertising
background image

Section 8. Working with Data Files on the PC

Time Series functions are used to perform vertical processing on selected

elements, such as calculating the average of an element over a specified range

of data. Time Series results are output in three instances:

1. when a Trigger on Stop Condition (F option) is met

2. at the end of a data file (or within a range specified by Start and Stop

Conditions)

3. when an interval count is met

When the Trigger on Stop Condition (or F option) is used, any time series data

defined in the Select line is output each time the Stop Condition is met. Refer

to Section 8.2.3.1.4.2, Trigger on Stop Condition (F Option) Output of Time

Series, for more information on the Trigger on Stop Condition.

Results which are output at the end of a file or a range of data are referred to as

Final Summaries. A typical select line that would produce a Final Summary is:

1,2,3,4,Avg(4)

This line would output values for elements 1 through 4 each time an array was

output. Additionally, an average value for element 4 would be calculated for

the entire file and output as the last line of data in the output file.

1,2,3,4,Avg(4;24)

This line would output values for elements 1 through 4 each time an array was

output, and an average value for element 4 would be calculated every 24

th

array

and output as an additional column in the file. An additional summary would

occur for an Interval Count if the count was not evenly divisible into the

number of output arrays present in the Input File. The summary, in this case, is

calculated from an incomplete interval count.

The date( ) function can be used for the interval in a time series function to

produce monthly output. Refer to the Monthly summary example in Section

8.2.3.1.12, Special Functions, Details, and Examples.

When Date and Edate are used within other functions they must

be used with the older format Date(doy;y) and Edate(doy;y)

instead of using the extended date functions. For example

AVG(1;Date(2;2002.0)). The decimal is needed to indicate a

fixed number. Numbers without the decimal are interpreted as

element IDs.

The interval count in a Time Series Function is optional and does not require a

decimal point. To determine the interval, Split counts the number of arrays

which meet the specified conditions (Stop, Start, and Copy). If the time

synchronize function is enabled, the Time Series functions remain

synchronized to the starting time even if a complete array is missing from the

input data. When elements are missing, the Time Series calculations are based

on the actual number of elements found.

NOTE

8-59

Advertising