This exercise demonstrates the Data Trend Correction feature in AquiferTest. The AquiferTest project for this exercise is already created; the exercise deals specifically with the aspect of adding a data trend correction to the drawdown values and is based on a Pumping Test consisting of one fully penetrating pumping well, pumping at 0.001 m3/s for 30,000 s. Drawdown is observed at an observation well located 10 meters away.
For more information about trend corrections in AquiferTest, please see Data Pre-Processing.
NOTE: Data Trend Correction Tools are only available in the AquiferTest Pro edition.
In this section of the Exercise, you will open an existing project and review the pumping test data:
 Start AquiferTest and click on the (Open other project...) button. If AquiferTest is already open, select File > Open from the main menu.
 Browse to the folder "C:\Users\Public\Documents\AquiferTest Pro\Exercises\", and select the project: TrendEffects.HYT
 Click [Open].
 Select the Water Levels tab. Take a moment to review the time - drawdown data for Well 2 that was observed for this pumping test.
 Select the Analysis tab and the Analysis Graph. Make note of the results obtained for Transmissivity and Storativity, using Theis analysis.
In this section of the Exercise, you will add a trend correction to the observed drawdown measurements.
 Return to the Water Levels tab. Add a Data correction, by clicking on the “down” arrow beside the Add Data Correction button, and selecting Trend Correction.
The Calculate Trend dialog will appear, as shown in the image below:
 In the Observation well drop-down menu, select Well 2 (your observation well)
 Click the "Click here to import the data from a file." link above the data table.
 Browse to the folder: "C:\Users\Public\Documents\AquiferTest Pro\Exercises\SupportingFiles" and locate the file Trenddata.xls. This file contains daily measurements of time (s) vs. water level (m) data, recorded by a logger, for 42 days.
 Click [Open]. You will see the data points displayed in the table and the calculated trend line appear on a graph to the right of the table.
Below the graph you will see the calculated Trend coefficient displayed. (If this is not visible, click on the Click here to refresh the graph and update the results link below the graph).
At the bottom of the dialog, there will be a label indicating whether the trend is statistically significant, which is determined by the results of a t-test. In this example, the calculated trend coefficient is -2.58 E-7 m/s (or -2.22 cm/day). The negative sign indicates that the water levels tend to RISE by 2.22 cm/day. The trend is significant; as such, the drawdown values should be corrected with the trend coefficient.
 Click [OK] to close the dialog.
 The correction data has been imported and the Time/Water Level table now has two new columns - Trend correction, and Corrected drawdown used in analysis. Click and drag the separator between the table and the graph to see all of the columns.
The Corrected drawdown column values are calculated using the trend coefficient and the elapsed time. To obtain the corrected drawdown, the Trend Correction value is added to the observed drawdown. In this example, the Corrected Drawdown is slightly greater than the observed drawdown.
 Switch to the Analysis tab.
 Click the Fit icon to autofit the data to the type curve. Note of the update aquifer parameter values. In this example, the values only changed marginally, since the change in drawdown since the calculated trend was relatively small.
 Click the Reports tab. A Trend report may be printed from the water level branch of the navigator tree in the Reports tab. This report will display the trend data with corresponding graph, and the t-test statistics. An example is shown below.
This concludes the exercise. The next exercise will demonstrate barometric correction of water level data. You have the option to exit the program or to continue on to the next exercise.