ANSDIMAT+ > Data input (Editor) >

Data loading

<< Click to Display Table of Contents >>

Navigation:  ANSDIMAT+ > Data input (Editor) >

ANSDIMAT+ > Data input (Editor) >

Data loading

The dialog window "Data loading" is used for 1) importing data in ASCII format (e.g. import from AKVA-MP data logger), 2) formatting, editing and processing the data 3) data export in ANSDIMAT Editor for interpretation. This window also allows to bring and process data from the clipboard. Processing data includes: conversion of hydraulic heads to drawdown or recovery water levels, changing time period for aquifer tests and reducing the number of measurements.

The loaded data are plotted on the right part of the dialog window. The upper plot shows all loaded measurements, while the lower plot presents the data that were selected for import into ANSDIMAT Editor. Data selection for importing is performed either in the "Data" tab or directly on the upper plot.

Text on both plots refers to the number of plotted points. For the upper plot this is the total number of measurements and the number of measurements within the selected range. For the lower plot this number corresponds to the reduced number of points (if applied).

The dialog window is opened by pressing the button "Data loading", located in the tab "Options" of dialog widnow "Editor...").

 

Explanatory table for key buttons on the upper plot

Left mouse within the plot window

Enters time for the first measurement. The green line moves to the nearest measurement. When the option "Auto" in column "Time" it unchecked, the line moves to the mouse cursor location.

Right mouse within the plot window

Enters time for the last measurement. The red line moves to the nearest measurement.

Left mouse + SHIFT within the plot window

Selection of static water level. The blue line moves to the nearest measurement. When the option "Auto" in column "Time" it unchecked, the line moves to the mouse cursor location.

LEFT (RIGHT) + CTRL

Enters the time for the first measurement. The green line moves left or right from the current measurement.

LEFT (RIGHT) + ALT

Enters the time for the last measurement. The red line moves left or right from the current measurement.

LEFT (RIGHT) + SHIFT

Selection of static water level. The blue line moves left or right from the current measurement.

 

 

Tab "Data" of dialog window "Data loading".

 

Explanatory table for tabs "Data"

Frame "File name"


Selection of data file and format


Options "Akva-MP file"

This is the ASCII file (*.TXT) that is downloaded from AKVA-MP data logger. Result files from other types of pressure transducers need to be converted into AKVA-MP format or into the format of arbitrary file (see below) before loading into this dialog window.

 

AKVA-MP file format:

1) First row - information only;

2) The measurements are imported starting from the 2-nd row for the following fields: date, time, measurement for logger 1, measurements for logger 2, logger 3, logger 4.

3) Each row contains one time measurement.

 

Aquifer test ID: 101; Date and time: 28.07.2014 11:52:09; Type: Logariphmic; Measurement period: Min.: 26;

28.07.2014 11:52:39        0.000000        6.721112        0.000000        0.000000

28.07.2014 11:52:49        0.000000        6.720602        0.000000        0.000000

28.07.2014 11:52:59        0.000000        6.720375        0.000000        0.000000

28.07.2014 11:53:09        0.000000        6.719646        0.000000        0.000000

28.07.2014 11:53:19        0.000000        6.680510        0.000000        0.000000

28.07.2014 11:53:29        0.000000        5.682927        0.000000        0.000000

28.07.2014 11:53:39        0.000000        4.932810        0.000000        0.000000

 

 

List "Logger 1", "Logger 2"

Selection of data logger for uploading the data

Option "Arbitrary file"

Loads ASCII files of arbitrary formats with several extensions (*.TXT, *.CSV, *.DAT, *.TXT). The file must contain columns with time (or with date and time) and measurements, where one row must contain only one time and only one measurement. The file may contain any number of information rows.

 

Example of file in *.CSV format:

 

Location:

GP_811

LEVEL

UNIT: m

Offset: 0,000000 m

TEMPERATURE

UNIT: °C

Date;Time;ms;LEVEL;TEMPERATURE

01.10.2017;13:33:51;0;10,277;11,852

01.10.2017;13:33:53;0;10,272;11,848

01.10.2017;13:33:55;0;10,276;11,844

01.10.2017;13:33:57;0;10,279;11,840

01.10.2017;13:33:59;0;10,278;11,836

01.10.2017;13:34:01;0;10,276;11,832

01.10.2017;13:34:03;0;10,278;11,827

01.10.2017;13:34:05;0;10,276;11,824

01.10.2017;13:34:07;0;10,275;11,819

 

Dialog window "Data file"

 

The table in dialog window "Data file" displays the first 20 rows of the uploaded file. The lists on the left part of the dialog window are defining where the data are to be uploaded. Lists from top to bottom:

Selection between three-columns file format (date, time, measurement) or two-columns format (time, measurement). For the latter case relative time can be used.  

Selection of column with date

Selection of column with time

Selection of column with measurement

Selection of row with the first measurement

 

Date format: DD.MM.YYYY (eg, 28.03.2018)

Time format: HH:MM:SS (eg, 14:36:52). Relative time is entered in days (for example, 1.375 means 1 day and 9 hours).

 

After pressing the "ОК" button, the file will be uploaded into the dialog window "Data loading".

Frame "Data and well"


Data selection for the import in Editor


Options "Pumping", "Recovery", "Rate"

Selection of data types for import in Editor

List "Well"

List of wells for data upload. When the option "Rate" is checked, pumping well needs to be selected from the list. Other uploaded data will be linked to the selected well.

List "Time"

Time units (i.e. days, hours, minutes or seconds. After change of time units in this list, all corresponding fields and  plots will be automatically re-calculated.

Check box "Water column height"

When this option is checked (default), imported measurements reflect thickness of water above the sensor. Water thickness decreases during pumping and increases during water injection or recovery.

When this option is unchecked, measurements reflect the depth of the water table in a well from specified reference level (e.g. Top of Collar). These numbers increase during pumping and decrease during recovery.

Frame "Trimming"


Reducing the number of measurements before exporting them in Editor. This option can be used when frequency of recorded measurements is excessive and needs to be reduced.


Option "Logarithmic scale"

Trimming is performed in logarithmic scale with a multiplier coefficient that is entered in the field "Multiplier"

Field "Multiplier"

Multiplier coefficient for data trimming in logarithmic scale

List "Step"

The data are reduced with a constant step. The maximum step is 1000. The step size can be either entered manually or selected from the list.

Frame "Limits"


Defines the range of input data for their export in Editor. Defines the static water level.


Fields "Start", "Finish" и "Level"

Shows the sequence number of a measurement and the corresponding time and value of measurement. Time and value automatically change when changing the sequence number. The data are plotted on the right part of the dialog window as the green vertical line (start), the red vertical line (finish) and the blue horizontal line (static water level). These lines can be moved using mouse and keyboard buttons (see the table above).

Field "Start"

Defines the initial time for to export in Editor. The time may or may not be equal the exact time of measurements (option "Auto"). When time is selected based on sequence number of measurements, it can start from the 2nd measurement, in order to have the  exported measured relative times higher than 0. The first relative time is always 0. The selected time is shown on the plot as a green line.

Field "Finish"

Defines sequence number for the last measurement to export in Editor. The selected time is shown on the plot by a red line.

Field "level"

Defines squence number for the measurement that will be taken as the initial (static) water level fro conversion of water levels (or hydraulic heads) into drawdown or recovery levels. This field is not used during pumping rate data uploads. The selected static water level is displayed on the plot as a blue horizontal line. 

Option "Auto" for Field  "Time"

When this option is checked, the start time is selected based on measurements and it is equal to one of the measurement times. When this option is off, the start time must be entered manually and it may be different from one of the measurement times (e.g. when pumping test starts between the times that are recorded by a logger)

Option "Auto" for Field "Value"

When this option is checked, the static water level is the same as one of the measured water levels. If a different (from measured) water level has to be entered, the option "Auto" must be switched off. 

Button "Calculate drawdown"


Calculates and plots drawdowns based on the uploaded data. The plotted data can be exported to ANSDIMAT editor using the button "Insert data". Normally plotted drawdowns would be higher, than 0. negative drawdowns on the plot are highlighted in red.

Button "Insert data"


Inserts the data into the table "t-s" in tab Editor "Data input". For time series of drawdown, recovery or pumping rate, the data need to be inserted separately.

Button "lg t" on the upper plot


The button switches time on the plots to either logarithmic or linear scales

 

 

 

Tabs "Table" and "Plot" of the dialog window "Data loading...".

 

Explanatory table for tabs "Table" и "Plot"

Tab "Table"


The table contains data that are plotted in the tab "Plot". The data are loaded from a file or the clipboard


Information window above the data table

Text window, where information is pasted from the upper lines of the uploaded file, if specified during upload process. This field is empty if the table is filled in from the clipboard.

Column "No"

Measurement sequence number

Column "Date"

Date of measurement. This field is not filled in when data are uploaded from the clipboard

Column "Time"

Time of measurement. Time units can be changed in the list "Time" of tab "Data". When a file is uploaded, this column is automatically filled in from the values in "Date" column. The first time is always 0.

Column "Value"

Column contains either water level (also hydraulic head, water thickness etc.) or pumping rate data

Button "Paste"

Pastes a table from the clipboard. The table must contain two columns: relative time and measurement value. The table must have more than three rows. Prior to copying the table from the clipboard, time units need to be selected from list "Time" of tab "Data"

Tab "Plot "


Settings for plots


Field "Minimum"

The minimum value of coordinate axes

Field "Maximum"

The maximum value of coordinate axes

Field "Decimal digits"

Number of decimal digits for axes labels

Field "Number of grid lines"

Number of tick marks/grid lines for axes

Button "Default"

Assigns default settings for axes

Frame "Points"

Size and colour for point symbols

Button "Redraw"

Applies modified settings