The EIS2008 EDITOR is available as a component of RKM Engineering's
Windows2000/XP and Office2000-2007 Environmental Information System (EIS2008) package. It
provides a powerful editing tool for hourly data, including automatic QA/QC
screening, single value and block editing, automatic base line correction,
correction based on calibration results, etc. The editing screen includes four
sections, one of which is the main editing panel. The other three are a graphic
trend, a monthly matrix and associated QA/QC flagged data. By clicking on
suspect points on any of those three panels, the user is automatically taken to
the appropriate position in the main editing panel. A full audit log is
automatically maintained, and the user can revert to previous sessions if
desired. In addition to powerful editing functions, this package supports import
from comma delimited and fixed column text files as well.
The Editor Screen
From a parameter and date selection menu, the
authorized user is taken to the Editor Screen. It consists of four resizable
panels. The main editing panel displays a row of four values for each hourly
data point (value, reading, edit and RTU status). The "value" field
displays the data point as it would be displayed on most reports, that is with
applicable flags, and in the colour determined by that flag, eg.
"12.3" for a normal value, "45.6A"
for a value exceeding the high alarm level, and "cal" for a value
invalidated due to a calibration cycle. This field cannot be edited directly.
The "reading" field shows the numerical value of the data point, and
it can be edited in place. The "edit" field shows the edit status
value of the data point. Clicking on this field brings down a list box of
possible values, from which the user can select one to invalidate the data.
Similarly, the "RTU" field shows the RTU status value, and it can be
edited in the same way.
In addition to editing single data points, a group of points can be blocked,
and by choosing "Block Edit" from the pop-up menu which comes up when
the user right-clicks on the selected block, the Block Edit Facility panel will
come up. This enables the user to apply any of a number of operations to the
|Force all readings to a value entered|
|Force edit status to a value selected from a drop down list|
|Force RTU status to a value selected from a drop down list|
|Apply a single or a gradual offset and multiplier from entered or computed
start and end values|
|Apply a single or a gradual offset and multiplier from selected automatic
or manual calibration results|
|Apply a minimum and/or maximum cap|
|Linearly interpolate missing values|
The user may also add a comment to the block edit.
The other three panels assist the user in navigating to any
data to be edited. Immediately to the right of the main editing panel is a
graphical representation of the data, in the form of a vertical chart. Clicking
a point on this chart brings the same point in focus on the main editing panel,
and selecting a block of points on the chart, selects the same block on the main
editing panel. The panel to the right of the chart panel is a monthly matrix,
very similar to the Monthly Matrix Report. It shows all values for the month,
one day per row. Again clicking on a point or selecting a block of data is
immediately reflected on the main editing panel. Finally, the panel immediately
below the main editing panel, shows all QA/QC screening results applicable to
the data set. Clicking on any of these points again brings the same point in
focus on the main editing panel.
QA/QC screening is automatically performed by the EIS2008, as data comes
in. The criteria for this process are set up in the EIS2008 Extended Configuration
Facility. Screening includes:
|Maximum Hour test, with different values for winter and summer, or rush
hour and non-rush hour periods|
|Adjacent Hour test, with different values as above|
|Moving Average test, with different values as above, and with the number
of hours used to compute the moving average selectable|
|Rate of Change test|
A complete audit log of all changed values, including before and after values
and type of edit applied, is maintained. In addition, complete edit sessions can
be rewound or re-instated.