You can use Excel to plot graph for cooper-jacob straight line analysis

1. A test is conducted on a water supply well in lowa to determine aquifer hydraulic properties, test for boundary conditions, and determine aquifer yield. For just over 24 hours, the well is pumped at a rate of 1.1167 m3/min. Water level data are collected at a well located 60.96 m away from the pumping well in an on-site observation well. The aquifer is thought to be confined, and both wells are screened across the entire unit, which is 12.19 m thick. Data collected during the test are provided in Table 1. Using the time-drawdown data from the pumping test provided in Table 1 and the Cooper-Jacob Straight line analysis for time-drawdown data as presented in the lectures. Notes: the required equations are contained in the lecture notes and the appropriate graph paper is provided below; feel free to use a spreadsheet program. Be careful to ensure that your units are all in agreement when applying any of the equations and be sure to show all of your calculation work. A. Determine whether or not a boundary is reached during the test. If one has been reached, identify the type of boundary and the time and drawdown at which the boundary first affects the water levels. If a boundary is not identified, indicate how you are aware a boundary is not present. B. Estimate the drawdown after 30 days of pumping considering the data collected between 0 and 100 minutes, and between 800 and 1440 minutes. How do they differ? C. Calculate the transmissivity (T) and storativity (S) of the aquifer assuming that it responds as a confined aquifer during the test. Be sure to show your calculations. D. Using parameters calculated above and provided in the question description, and ignoring any possible boundary conditions, use the Theis equation to determine what pumping rate would be required to have a water level decline of just 50 cm (0.50 m) at the observation well 30 days into the test. Table 1. Time-drawdown data for onsite observation well. Elapsed Time Min Water Level Elapsed Time Water Level Water Level Elapsed Time Min m Water Level m 3.49 3.49 Elapsed Time Min 760 770 m Min 380 390 m 0 3.63 3.64 1140 1150 3.74 3.75 10 3.07 3.12 3.17 3.20 20 1160 400 410 780 790 3.64 3.64 30 1170 3.50 3.50 3.51 3.51 3.75 3.75 3.76 3.76 800 1180 40 50 3.23 3.25 420 430 3.65 3.65 810 1190 60 3.26 440 1200 70 3.28 3.29 450 460 3.51 3.52 3.52 820 830 840 3.65 3.65 3.66 1210 1220 3.76 3.76 3.77 80 470 90 100 110 850 860 1230 1240 3.77 3.77 480 3.30 3.31 3.32 3.33 3.34 3.35 3.53 3.53 3.54 3.54 3.66 3.66 3.67 3.67 120 490 500 510 520 1250 1260 1270 1280 870 880 890 900 910 920 930 3.77 3.78 3.78 3.78 3.54 3.55 130 140 150 160 170 3.67 3.67 3.68 3.68 530 3.36 3.36 3.55 3.56 1290 1300 1310 3.79 3.79 540 3.37 550 3.56 3.68 3.79 180 940 3.38 3.39 560 570 3.56 3.57 3.69 3.69 3.79 3.79 190 950 200 3.80 3.39 3.40 580 590 210 1320 1330 1340 1350 1360 1370 960 970 980 990 3.80 3.69 3.69 3.70 3.70 220 3.40 3.41 600 610 3.80 3.80 230 240 250 620 630 1000 1010 1380 1390 3.42 3.42 3.43 3.43 3.44 3.44 3.70 3.71 3.71 3.71 3.57 3.58 3.58 3.58 3.59 3.59 3.59 3.60 3.60 3.60 3.61 3.61 3.61 3.62 3.62 3.80 3.81 3.81 3.81 640 650 260 270 280 290 300 1400 1410 660 1020 1030 1040 1050 1060 3.72 3.72 1420 1430 3.81 3.82 670 680 1440 3.82 3.45 3.45 3.46 3.47 3.47 1070 1080 310 320 330 340 690 700 710 720 730 740 750 1090 1100 3.72 3.72 3.73 3.73 3.73 3.74 3.74 3.74 350 360 370 3.47 3.48 3.48 3.62 3.63 1110 1120 3.63 1130