Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Table edit functionality

By pressing the right mouse button a list with edit actions appears on the screen. These includes the option to copy and fill in data. The display that pops up after clicking the right mouse button on an equidistant timeseries is shown below (figures 1, 1.1, 1.2):

...

[Select All]

Select all data displayed in the editor

[Select Column]

Select all data in the column in which the cursor is placed

[Select Row]

Select all data in the row in which the cursor is placed

[Save As]

Save selected timeseries to file of format: PI xml, GIN xml, csv, Dutch csv, iBever csv, Hymos transfer DB 4.50 mdb or Hymos transfer DB 4.03 mdb

[Save as special]

Filter selected timeseries by reliability and status and save to file of format: PI xml, GIN xml, csv, Dutch csv, iBever csv, Hymos transfer DB 4.50 mdb or Hymos transfer DB 4.03 mdb (see also Export Timeseries from FEWS Explorer). From 2015.01 [Save As Special] has been merged into [Save As].

[Expand Selection]

Select all data in the row in which the cursor is placed

[Edit Value]

The cell on which the cursor is place can be edited

[Cut]

Move the selected data (including the date / time field) to the clipboard

[Copy]

Copy the selected data (included the date / time field) to the clipboard

[Copy Values Only]

Copy the data values in the selection to the clipboard

[Copy Reliable Values Only]

Copy the data values in the selection classified as reliable to the clipboard

[Copy Reliable and Doubtful Values Only]

Copy the data values in the selection classified as reliable and doubtful to the clipboard

[Copy Times Only]

Copy the selected date / time in the selection to clipboard

[Paste]

Paste the data from the clipboard into the selected fields

[Clear]

Delete the data values in the selection

[Clear Doubtfuls]

Delete the data values in the selection classified as doubtful

[Clear Unreliables]

Delete the data values in the selection classified as unreliable

[Block Fill Missing Data]

Fill the selected fields with the last value available value in the same column

[Lineair Fill Missing Data]

Apply lineair interpolation when filling in the selected fields

[Fill Missing Data from Clipboard]

Fill in the selected fields with data copied to the clipboard

[Set maximum fill gap]

Set the maximum gap size to be interpolated

[Shift Values in Time]

Moves the selected values in time

[Apply Transformation]

Change the selected values using a regular expression

[Apply Calibration]

Undo trend deviance of the selected values using a calibration
timeseries

[Trend to value]

Trends a value to a given target level

...

[Edit Time]

Edit an existing date/time for which a value already has been entered

[Insert Time]

Insert a date/time for which a value can be entered

[Remove Time]

Remove a date/time. NOTE You can only remove a date/time if you have just inserted one using the Insert Time option and if you have not yet applied the change. Once stored in the database the time cannot be removed. If you need to remove values you can set it to missing using the clear option. The time will remain.

Chart edit functionality

It is possible to edit timeseries directly in the chart (when in edit mode). To do this a user must first select the timeseries the user wants to edit. Selecting a timeseries can be done by:

...