Advanced Software for
|Developed and Sold by HydroSOLVE, Inc.|
|The World's LEADING Aquifer Test Analysis Software Since 1989!|
The AQTESOLV for Windows Import Wizard is a versatile tool for for importing test data from a delimited text file. You will use the Import Wizard most frequently to import time and drawdown readings from a data logger file; however, it also can import rate data for a pumping well.
The following instructions describe how to use the AQTESOLV for Windows Import Wizard to import observation well data (time and drawdown readings) from a generic delimited text file or data logger file. The same general procedure also applies to importing rate data for a pumping well.
Start the AQTESOLV for Windows application (v. 3.0 or higher) and follow the steps below.
Click Browse to locate and select a file to import. After selecting the file, click View Import File to view its contents.
Be default, the imported data overwrite any readings contained in the AQTESOLV for Windows data set. Override this behavior by selecting the option to Append observations from import file to data set.
AQTESOLV for Windows automatically scans the import file to identify the No. of Columns and Starting Row for data contained in the file. Click Select Starting Row to modify the number of columns and starting row.
Enter Data Columns To Import that match the structure of your import file. Typically, you will select elapsed time and displacement values to import. The Import Wizard also allows you to import time recorded as date and clock time values when an elapsed time column is not available. For example, if your data logger file contains a total of five data columns with elapsed time in column 3 and water-level displacement in column 5, enter the values shown below.
The Weight column is optional; if your file does not contain weights for the readings, AQTESOLV for Windows assigns a default value of 1.0 for each reading.
The Pre-Filter Operations allow you to perform common transformations on the data. For example, to convert water levels or depths contained in the import file to displacement (drawdown) values, subtract the static water level or depth from all of the readings in the file. You can perform this transformation by selecting the option in Time Filters group to subtract a constant from the displacement values and entering the static water level or depth (see example below). Other useful options allow you to multiply time and displacement values by a constant. For example, to convert negative displacements to positive values, check the option for multiplying displacement values and enter a constant of -1.
Click Filters to choose options for filtering data imported from the file. Select Retain change in log time >= minimum to retain a fixed number of readings per log cycle time. For example, to retain 10 readings per log cycle, enter a value of 0.1 (=1/10) for this option. Other options allow you to specify a retention interval (e.g., retain every fifth observation), a minimum change in displacement for retaining observations (i.e., discard readings until the change in displacement exceeds the minimum value), and a time window for applying the filters. You can select more than one filter option for your import file.