Section 8. Working with Data Files on the PC
VALID EXPRESSION
INVALID EXPRESSION
Arctan (2/3)
Arctan ((2/3))
Arctan (2/3, 3/4, 4/5)
Arctan ((2/3, 3/4), 4/5)
Arctan (COS(2))
Arctan (COS(2), COS(3))
•
A single expression can operate on a set of elements. For example, the
expression (3..6,8)/2.0 is the same as 3/2.0, 4/2.0, 5/2.0, 6/2.0, 8/2.0;
(3..6)/(2..5) is the same as 3/2, 4/3, 5/4, 6/5.
•
The element or expression that is the argument of a math or Time Series
function, must be enclosed in parentheses. A range of elements can be
specified, resulting in as many outputs as elements (e.g., Avg(3..5,7) will
output 4 averages).
•
Square brackets are used to enclose an allowable range for a value (e.g.,
3[3.6..12] ) to indicate that the allowable range for element 3 is from 3.6 to
12. Whole numbers within brackets do not require a decimal point. TABLE
8-5 explains how values outside the specified range are treated.
•
The interval in a Time Series function is optional and does not require a
decimal point.
•
Semicolons are used in Time Series functions to separate the elements or
expressions from the number that determines the interval. Sample on
maximum and sample on minimum require two elements or expressions
also separated by a semicolon.
8.2.3.1.15 Time Synchronization
The time synchronize function is useful when data is missing from a file or if
several files of data need to be merged together. The files are synchronized
according to time; any missing data in the file (or files) will be replaced with
blank data.
This function synchronizes according to day, hrmn (hour-minute), and/or
seconds. The syntax used to identify the time elements for array data is:
e
i
[day]:e
i
[hrmn]:e
i
[seconds]
Referring to TABLE 8–1, to identify the day of year for a mixed-array data
file, type:
2[189]::
for hrmn type:
:3[1200]:
and seconds are expressed as:
::4[5]
A single colon is assumed to be between day and hrmn (e.g., 2[189]: means
day, :3[1200] means hours, and 2[189]:3[1200] means day and hour-minute).
When the time synchronize function is used, a time interval must be specified
in the Copy line of the first data file. For example, 4[60] in the Copy line will
create a synchronized file containing the data from the input files that occurred
every 60 minutes. If no time interval is specified in the Copy line then the time
specified in the Start Condition becomes simply a starting time with no time
synchronization.
8-71
Summary of Contents for LoggerNet
Page 2: ......
Page 30: ...Preface What s New in LoggerNet 4 xxvi...
Page 32: ...Section 1 System Requirements 1 2...
Page 44: ...Section 2 Installation Operation and Backup Procedures 2 12...
Page 136: ...Section 4 Setting up Datalogger Networks 4 80...
Page 227: ...Section 7 Creating and Editing Datalogger Programs 7 9...
Page 298: ...Section 7 Creating and Editing Datalogger Programs 7 80...
Page 402: ...Section 9 Automating Tasks with Task Master 9 12...
Page 406: ...Section 9 Automating Tasks with Task Master 9 16...
Page 450: ...Section 11 Utilities Installed with LoggerNet Admin and LoggerNet Remote 11 22...
Page 454: ...Section 12 Optional Client Applications Available for LoggerNet 12 4...
Page 462: ...Section 13 Implementing Advanced Communications Links 13 8...
Page 482: ...Section 14 Troubleshooting Guide 14 20...
Page 570: ...Appendix F Calibration and Zeroing F 16...
Page 578: ...Appendix G Importing Files into Excel G 8...
Page 579: ......