Single Well Process

Single-Well Process

The application accepts a Solinst © .lev or .xle file or a Global Water © .csv file.
Double-click on the white file box to open the file selection dialog.
Using a .csv file not from a Global Water will likely cause errors.
When the file successfully loads, a table and graph will appear in the area of the right-hand side of the screen.
To plot data, click on the column header in the table that you want to plot, then click the Plot button under the graph.
Modifications to the table will be reflected in later processing steps and plotting

Sometimes data contains outliers, shifts, or extreme values that can interfere with other aspects of the data processing
This toolset can be skipped if your data does not contain any major spikes or offsets

Trim Extrema can be used to remove outliers that go beyond the y values of the rest of the data.
This tool trims the data based on the y-limits that you set (Min. and Max. allowed values).
This is best for removing spikes and is preferred to the Remove Spikes tool if possible.

Remove Spikes can take out data outliers using moving window functions.
it will remove values that go beyond the set number of standard deviations for the set window
Larger windows include more data and generally will remove fewer spikes
Smaller numbers of standard deviations will remove smaller and more spikes
Be careful, this tool can significantly change your data

Remove spikes and or outliers in data before using this or the tool will think they are shifts.
IF there is a major shift or jump (change point) in your data, you can use this to remove it
It works best if you estimate the size of your jump and set your tolerance to just below that value
Works best if the shift is much larger than other changes in your data.

Barometric pressure is needed to remove barometric pressure from the absolute pressure of the nonvented pressure transducer
This interface is very similar to that of selecting a well file. It was designed for .xle files.
As of right now, barometer data are required, even if the data are from a vented transducer.

This button aligns the well data to the barometric data, so that the measurement frequencies are identical.
It defaults to a measurement frequency of 60 minutes, but that frequency can be adjusted.
Clicking the Align Datasets button will create the well-baro table on the right side of the application window.
The corrected water level data will be in the corrwl file.
An automatic plot will be made showing the raw water level, raw barometric pressure data, and the corrected water level.
If the automatic plot gets messed up, just click the Align Datasets button again. Note that this will clear any changes you made to the table.
If the transducer is a Global Water, then barometric pressure will not be removed.

Manual measurements help fix any drift in transducer readings, and allows for applying real-world elevations to the relative measurements in transducer data.
For this step, you can either enter two manual readings using the Manual Entry tab or upload a .csv file of manual readings using the Data Input tab.

Input the date, then the time of the two manual measurements
Ideally, the manual measurements should be near the end and beginning of the transducer file
For data entry depth to water should be input as positive below ground surface, and negative if above ground surface

Make sure your .csv file includes a column with the date-time of the manual measurement, the manual measurement, and column with a location id (integer)
Your .csv file must have a row with column names on the first line
items in your locationid column must be integers
Match columns in your .csv file to their respective fields using the dropdown boxes provided.
Dropdown boxes should populate automatically with the names of the columns in your .csv

This aligns the closest manual measurement with the closest transducer measurements and compares the start and finish between the two
The fix drift button will use the manual measurements in the previous step to fix any linear drift in the transducers
Linear drift is assumed, and this tool does not fix nonlinear errors produced by the transducer.
High drift values likely indicate an issue with the transducer or the manual measurements
See the Fix Drift Equations page for an in-depth explanation of how this process works.

Input elevation of the ground surface (not measurement point, unless the measurement point is at ground surface)
Input stickup, which is the distance from the ground surface to the measurement point.
Click the button to calculate the elevation

This button will open a dialog to save the final csv file