
50 CHAPTER 5 WORKBOOKS PAGE
collapsed by clicking on the node.
Update Properties – Refreshes lter properties updating changed values.
e individual lters and their properties are outlined below:
Consecutive Zero Volumes – Checks the volume counts for each data record. Flags
data if the number of consecutive zero volume records is equal to or greater than the
set value; the default value is eight.
Volume Reality Check – Checks each full day of data within the workbook to see
whether any data between 1 a.m. and 2 a.m. has a higher volume than the data from 1
p.m. to 2 p.m. indicating either awed data or an abnormal event.
Missing Intervals – Flags all missing data records.
Out of Bounds – Checks the given data value (Volume, Speed or Occupancy) against a
comparable value set in the Value eld. e Operator eld can be set to adjust the type
of comparison performed: greater than, less than, equal or not equal. Data is agged if
the given data value for a data record meets the comparison criteria for the lter. e
Auto Adjust Value can be used either to provide a suggested change to the data (when
the lter is run in Flag Items mode) or to automatically edit the data to the given value
(in Auto-Fix mode).
Over Speed – Checks the speed value for each data record, agging it if the speed is
above the given Speed value. e Auto Adjust Speed eld can be used either to pro-
vide a suggested change to the speed (when the lter is run in Flag Items mode) or to
automatically edit the speed to the given value (in Auto-Fix mode).
Repeated Values – Checks the given data value (Speed, Volume or Occupancy) for
each data record for multiple sequential entries that are the same value, indicating
potentially invalid or awed data. Congure the number of sequential entries in the
Repeated Intervals eld. e Auto Adjust Value can be used either to provide a sug-
gested change to the data (when the lter is run in Flag Items mode) or automatically
edit all sequential data records to the given value (in Auto-Fix mode).
To run one or more lters aer all properties have been set, click the Run Selected Filters
button. A sub-window will pop up listing the lter properties (see Figure 5.6).
Figure 5.6 – Run Data Filters Sub-window
It is not necessary to remain on the lter page while this operation is run—the DataView
system will run the lters and update the data in the workbook when completed. In cases
Kommentare zu diesen Handbüchern