Instructions on how to use Cooper-Jacob XL V2.

1) Enter your data in the Data Worksheet.

The distance to the pumping well, the pumping rate,
and the static water level must be entered in the cells as indicated.
Note that the units used are metres for distance, m3 for volume, and days for time.
All the other information can be changed as required.
For instance you could rename 'Project' to 'Client'.

2) Enter the time (GMT) of the beginning of the pumping test in cell D14.
The rest of column D is calculated automatically from the time since
the pumping test started (in minutes) which you need to enter in column E.
Enter the water level, discharge and conductivity data in Columns F, G & H respectively.
Note that the discharge in Column G is for reference only.
You need to enter an average pumping rate into cell M4.

3) All other data will be calculated automatically.

4) Check the data in the Chart sheet which shows water level and conductivity readings.
If necessary, adjust the data ranges using Chart - Source Data - Series.

5) Go to the Analysis sheet and adjust the red line to fit the data.
If necessary, adjust the data ranges using Chart - Source Data - Series.
The calculated drawdown and %age error calculated in the Data Sheet
will be adjusted automatically when you move the line.
Note that the data points change from a circle to a square if u>0.05.

6) Go to the Print sheet and adjust the scales of the graph if required.
Note that all the information you entered in the Data sheet
are transferred automatically to the Print sheet.
If necessary, adjust the data ranges using Chart - Source Data - Series.

7) Note that the T & S calculations are carried out in a hidden sheet called 'Calcs'.
A storativity value will be calculated for observation wells that are greater than 3 metres
from the pumping well. If your data is from a pumping well,
use the radius of the well as the distance to the pumping well.

Disclaimer : Note that this workbook is provided as is,

and that it is your responsibility to check your work
and any conclusions that you draw from the data.

If you suspect or discover any errors in this workbook,

or want to suggest ideas on how it can be improved
please contact Andreas on info@geosearch.co.uk

To check for updates of this workbook or download

other hydrogeological & geophysical software visit:
http://www.geosearch.co.uk/
and click on Resources.
 Example 4.4.2 Constant Rate Test
Contractor: Contractor Distance to pumping well: 60.0 m
Contract No.: Contract No. Pumping rate: 2,500.0 m3/d
Local ID: Local ID Static water level: 0.00 m
Locality: Todd (2005) Groundwater Hydrology Measurement datum: Top of casing
Well site geologist: Site geologist Pump on: 1/1/2020 8:00
PM representative: PM representative Pump off: 1/1/2020 21:50
Name of well: Example 4.4.2 Measured by: Contractor
Well depth: ? erpreted by: Hydrogeologist
'file:///conversion/tmp/activity_task_scratch/590103155.xlsx'#$Data 1

Data Date Time Time Water level Discharge Cond. Drawdown Calculated Error Included
# dd/mm (GMT) (min) (m) (L/sec) (μS/cm) (m) Drawdown % in analysis
1 01/01 8:01:00 1.0 0.20 0.20 0.17
2 01/01 ### 1.5 0.27 0.27 0.24
3 01/01 ### 2.0 0.30 0.30 0.29
4 01/01 ### 2.5 0.34 0.34 0.33
5 01/01 ### 3.0 0.37 0.37 0.36
6 01/01 ### 4.0 0.41 0.41 0.41
7 01/01 ### 5.0 0.45 0.45 0.45 0.1 yes
8 01/01 ### 6.0 0.48 0.48 0.48 0.2 yes
9 01/01 ### 8.0 0.53 0.53 0.53 0.2 yes
10 01/01 ### 10.0 0.57 0.57 0.57 0.1 yes
11 01/01 ### 12.0 0.60 0.60 0.60 0.2 yes
12 01/01 ### 14.0 0.63 0.63 0.63 0.3 yes
13 01/01 ### 18.0 0.67 0.67 0.67 0.3 yes
14 01/01 ### 24.0 0.72 0.72 0.72 0.2 yes
15 01/01 ### 30.0 0.76 0.76 0.76 0.1 yes
16 01/01 ### 40.0 0.81 0.81 0.81 0.0 yes
17 01/01 ### 50.0 0.85 0.85 0.85 0.1 yes
18 01/01 ### 60.0 0.90 0.90 0.88 2.1 yes
19 01/01 ### 80.0 0.93 0.93 0.93 0.1 yes
20 01/01 ### 100.0 0.96 0.96 0.97 1.0 yes
21 01/01 ### 120.0 1.00 1.00 1.00 0.1 yes
22 01/01 ### 150.0 1.04 1.04 1.04 0.0 yes
23 01/01 ### 180.0 1.07 1.07 1.07 0.1 yes
24 01/01 ### 210.0 1.10 1.10 1.10 0.2 yes
25 01/01 ### 240.0 1.12 1.12 1.12 0.1 yes
 Example 4.4.2 Constant Rate Test
Contractor: Contractor Distance to pumping well: 60.0 m
Contract No.: Contract No. Pumping rate: 2,500.0 m3/d
Local ID: Local ID Static water level: 0.00 m
Locality: Todd (2005) Groundwater Hydrology Measurement datum: Top of casing
Well site geologist: Site geologist Pump on: 1/1/2020 8:00
PM representative: PM representative Pump off: 1/1/2020 21:50
Name of well: Example 4.4.2 Measured by: Contractor
Well depth: ? erpreted by: Hydrogeologist
'file:///conversion/tmp/activity_task_scratch/590103155.xlsx'#$Data 1

Data Date Time Time Water level Discharge Cond. Drawdown Calculated Error Included
# dd/mm (GMT) (min) (m) (L/sec) (μS/cm) (m) Drawdown % in analysis
 Example 4.4.2 Constant Rate Test
Contractor: Contractor Distance to pumping well: 60.0 m
Contract No.: Contract No. Pumping rate: 2,500.0 m3/d
Local ID: Local ID Static water level: 0.00 m
Locality: Todd (2005) Groundwater Hydrology Measurement datum: Top of casing
Well site geologist: Site geologist Pump on: 1/1/2020 8:00
PM representative: PM representative Pump off: 1/1/2020 21:50
Name of well: Example 4.4.2 Measured by: Contractor
Well depth: ? erpreted by: Hydrogeologist
'file:///conversion/tmp/activity_task_scratch/590103155.xlsx'#$Data 1

Data Date Time Time Water level Discharge Cond. Drawdown Calculated Error Included
# dd/mm (GMT) (min) (m) (L/sec) (μS/cm) (m) Drawdown % in analysis
 Example 4.4.2 Constant Rate Test
Contractor: Contractor Distance to pumping well: 60.0 m
Contract No.: Contract No. Pumping rate: 2,500.0 m3/d
Local ID: Local ID Static water level: 0.00 m
Locality: Todd (2005) Groundwater Hydrology Measurement datum: Top of casing
Well site geologist: Site geologist Pump on: 1/1/2020 8:00
PM representative: PM representative Pump off: 1/1/2020 21:50
Name of well: Example 4.4.2 Measured by: Contractor
Well depth: ? erpreted by: Hydrogeologist
'file:///conversion/tmp/activity_task_scratch/590103155.xlsx'#$Data 1

Data Date Time Time Water level Discharge Cond. Drawdown Calculated Error Included
# dd/mm (GMT) (min) (m) (L/sec) (μS/cm) (m) Drawdown % in analysis
 Example 4.4.2 Constant Rate Test
Time

0 50 100 150 200 250 300

0.00

0.20

0.40
Drawdown

0.60

0.80

1.00

1.20

Pumping Water Level (used in interpretation) Pumping Water Level (not used in interpretation)
 Straight Line Pumping Test Analysis (Cooper & Jakob, 1946)
Note that this method does not apply to points when u > 0.05, to the left of the dotted line

Time
0.1 T0 = 0.3755 mins 1 10 100 1000 y1 y2
0.00 0.17 1.21

0.20

0.40

0.60
Drawdown

x1 1
Δs' = 0.3997 x2 400
0.80
Sensitivity 100

Δs' = 0.3997
T0 = 0.3755 mins
1.00

Straight Line Pumping Test

Analysis (Cooper & Jakob, 1946).
Note that this method does not
1.20 apply to points when u > 0.05, to
the left of the dotted line. Adjust the
best fit line, using x-coordinates &
the scroll bars.
1.40
 Straight Line Pumping Test Analysis (Cooper & Jakob, 1946)
Note that this method does not apply to points when u > 0.05, to the left of the dotted line

Time
0.1 1 10 100 1000
0.00

0.20

0.40

0.60
Drawdown

0.80

1.00

1.20

1.40
 Example 4.4.2 Constant Rate Test
Contractor: Contractor Distance to pumping well: 60 m
Contract No.: Contract No. Pumping rate: 2500 m3/d
Local ID: Local ID Static water level: 0 m
Locality: Todd (2005) Groundwater Hydrology Measurement datum: Top of casing
Well site geologist: Site geologist Pump on: 01/01/2020 08:00
PM representative: PM representative Pump off: 01/01/2020 21:50
Name of well: Example 4.4.2 Measured by: Contractor
Well depth: ? Interpreted by: Hydrogeologist

Transmissivity: 1,144.7 m2/d Mean Fitting Error: 0.29 %

Storativity: 1.9E-04

Straight Line Pumping Test Analysis (Cooper & Jakob, 1946)

Note that this method does not apply to data when u > 0.05, to the left
of the dotted line
and that Storativity cannot
Time be calculated without observation wells
0.1 1 10 100 1000
0.00

0.20

0.40
Drawdown

0.60

0.80

1.00

1.20

1.40

Best Fit Line u = 0.05 Conductivity

'file:///conversion/tmp/activity_task_scratch/590103155.xlsx'#$Print