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.
NOTE
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.
8-59
Содержание LoggerNet
Страница 2: ......
Страница 30: ...Preface What s New in LoggerNet 4 xxvi...
Страница 32: ...Section 1 System Requirements 1 2...
Страница 44: ...Section 2 Installation Operation and Backup Procedures 2 12...
Страница 136: ...Section 4 Setting up Datalogger Networks 4 80...
Страница 227: ...Section 7 Creating and Editing Datalogger Programs 7 9...
Страница 298: ...Section 7 Creating and Editing Datalogger Programs 7 80...
Страница 402: ...Section 9 Automating Tasks with Task Master 9 12...
Страница 406: ...Section 9 Automating Tasks with Task Master 9 16...
Страница 450: ...Section 11 Utilities Installed with LoggerNet Admin and LoggerNet Remote 11 22...
Страница 454: ...Section 12 Optional Client Applications Available for LoggerNet 12 4...
Страница 462: ...Section 13 Implementing Advanced Communications Links 13 8...
Страница 482: ...Section 14 Troubleshooting Guide 14 20...
Страница 570: ...Appendix F Calibration and Zeroing F 16...
Страница 578: ...Appendix G Importing Files into Excel G 8...
Страница 579: ......