Editing Data

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="de0993d8-0c99-4e6a-81f5-0f456b269276"><ac:plain-text-body><![CDATA[

[Select All]

Select all data displayed in the editor

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="a74caf16-6dff-4f20-a2ab-d75c2065806b"><ac:plain-text-body><![CDATA[

[Select Column]

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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="319ede5e-9a83-4442-a22c-0de59efff61a"><ac:plain-text-body><![CDATA[

[Select Row]

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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f2e625cc-c648-42ea-b528-71de156c5ee8"><ac:plain-text-body><![CDATA[

[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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="ab8af8fd-7770-4876-af37-20ab4a67ef12"><ac:plain-text-body><![CDATA[

[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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="8e96e727-a228-4bcb-a259-b6731989ad03"><ac:plain-text-body><![CDATA[

[Expand Selection]

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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="488b4e89-23b8-45ce-8a50-d167f2cd8f82"><ac:plain-text-body><![CDATA[

[Edit Value]

The cell on which the cursor is place can be edited

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="09f8e52a-8cc7-44b6-b5e7-7b04deb50e24"><ac:plain-text-body><![CDATA[

[Cut]

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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="2c5fc798-191a-4869-b7d3-fb21bda2b526"><ac:plain-text-body><![CDATA[

[Copy]

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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="e4133872-48b2-4dd7-a586-5a2342eda909"><ac:plain-text-body><![CDATA[

[Copy Values Only]

Copy the data values in the selection to the clipboard

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="9be7df68-6cb3-48e9-bdaa-6843d94570d4"><ac:plain-text-body><![CDATA[

[Copy Reliable Values Only]

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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="0aec4240-05f5-421e-af8b-92cfb828fd00"><ac:plain-text-body><![CDATA[

[Copy Reliable and Doubtful Values Only]

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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d613d39e-8f40-4364-a98d-067d7eb796d5"><ac:plain-text-body><![CDATA[

[Copy Times Only]

Copy the selected date / time in the selection to clipboard

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="7f694072-ae4e-4572-8258-43df8613576a"><ac:plain-text-body><![CDATA[

[Paste]

Paste the data from the clipboard into the selected fields

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="6334556f-8090-4d1e-ac06-0e19d2244886"><ac:plain-text-body><![CDATA[

[Clear]

Delete the data values in the selection

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d264b589-4c1d-42c0-869b-51be2f09e878"><ac:plain-text-body><![CDATA[

[Clear Doubtfuls]

Delete the data values in the selection classified as doubtful

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="be661347-cc1f-4f46-80de-fff33342341c"><ac:plain-text-body><![CDATA[

[Clear Unreliables]

Delete the data values in the selection classified as unreliable

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d3af3420-30d1-46f7-bf9c-75beb3506068"><ac:plain-text-body><![CDATA[

[Block Fill Missing Data]

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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="2883634d-3f5b-49af-b0d1-b245e4bcf650"><ac:plain-text-body><![CDATA[

[Lineair Fill Missing Data]

Apply lineair interpolation when filling in the selected fields

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="06514090-39e7-479a-acad-8d28c8fd4355"><ac:plain-text-body><![CDATA[

[Fill Missing Data from Clipboard]

Fill in the selected fields with data copied to the clipboard

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="3837057a-da09-49a1-8748-96bc12896c19"><ac:plain-text-body><![CDATA[

[Set maximum fill gap]

Set the maximum gap size to be interpolated

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="54a0d2c8-46bf-4a34-9259-d9595339c152"><ac:plain-text-body><![CDATA[

[[Shift Values in Time

FEWSDOC:Shift Values in Time]]

Moves the selected values in time

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="c0f3eecd-cc21-427d-97dc-8898e2a98cfd"><ac:plain-text-body><![CDATA[

[[Apply Transformation

FEWSDOC:Apply Transformation]]

Change the selected values using a regular expression

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="88200f96-292a-4dd3-9e2d-5e6cffcadfa1"><ac:plain-text-body><![CDATA[

[Edit Time]

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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="e1839f13-d583-431c-b46e-349cf8b55bc2"><ac:plain-text-body><![CDATA[

[Insert Time]

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

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="2e1a9d51-586c-4bc6-b2fa-a30c9719de99"><ac:plain-text-body><![CDATA[

[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.

]]></ac:plain-text-body></ac:structured-macro>