When you do your work with a spreadsheet, make sure it is well organized, and always hand in an example of your calculations. Use the attached spreadsheet (Wellfunc.xls) to calculate W(u). Recognize that the following calculations are estimations as they are subject to the assumptions inherant in the equations we apply. 1. An industrial food-manufacturing operation wishes to expand, and it requires an improved water supply. They propose to construct a fully penetrating well in an infinite, horizontal, confined, homogeneous, isotropic aquifer, and they plan to pump at a constant rate of 20 L/s. If T = 1.3 x 10-2 m²/s, and S is known to range between 1.2 and 2.1 (x 104), make the following calculations. a. Considering the maximum and minimum S values, calculate the range of drawdown that would be expected at the property boundary for the manufacturing facility, 100 m from the pumping well at times of 5, 15, 100, 200 and 400 min after the start of pumping. Plot the values on a log-log graph of ho-h vs t to compare drawdown for both values of S. b. The environmental regulator has imposed a limitation on the drawdown from any well to prevent impacts to surrounding groundwater users. The drawdown limit is a maximum of 1.0 m at a distance of 250 m, after ten days of pumping. Is this well likely to be in compliance with the regulation? C. Estimate the impact of pumping at intermediate distances by calculating the range of drawdown for the max and min S that would occur at distances 10 m, 15 m, 60 m, and 500 m from the pumping well ten days after the start of pumping. Plot the values on a semi-log graph of ho-h vs r (r on the log scale). Determine the distance range beyond which drawdown is not likely to violate the regulation mentioned above in '1b'. euler= 0.577216 term term number coefficient u 1/u 1 1 5.00E-03 W(u) 2.00E+02 4.73E+00 2 -0.25 u 1 2 3 W(u) 4 5 6 7 8 9 3 0.055556 x 1.E-15 33.9616 33.2684 4 -0.01042 5 0.001667 6 -0.00023 7 2.83E-05 8 -3.1E-06 9 3.06E-07 10 -2.8E-08 11 2.28E-09 12 -1.7E-10 13 1.24E-11 14 -8.2E-13 15 5.1E-14 16 -3E-15 x 1.E-02 17 1.65E-16 x 1.E-01 18 -8.7E-18 X 32.8629 31.8821 31.7643 x 1.E-14 31.6590 30.9658 30.5604 30.2727 30.0495 29.8672 29.7131 29.5795 29.4618 x 1.E-13 29.3564 28.6632 28.2578 27.9701 27.7470 27.5646 27.4105 27.2769 27.1592 x 1.E-12 27.0538 26.3607 25.9552 25.6675 25.4444 25.2620 25.1079 24.9744 24.8566 x 1.E-11 24.7512 24.0581 23.6526 23.3649 23.1418 22.9595 22.8053 22.6718 22.5540 x 1.E-10 22.4486 21.7555 21.3500 21.0623 20.8392 20.6569 20.5027 20.3692 20.2514 x 1.E-09 20.1461 19.4529 19.0474 18.7598 18.5366 18.3543 18.2001 18.0666 17.9488 x 1.E-08 17.8435 17.1503 16.7449 16.4572 16.2340 16.0517 15.8976 15.7640 15.6462 x 1.E-07 15.5409 14.8477 14.4423 14.1546 13.9314 13.7491 13.5950 13.4614 13.3437 x 1.E-06 13.2383 12.5451 12.1397 11.8520 11.6289 11.4465 11.2924 11.1589 11.0411 x 1.E-05 10.9357 10.2426 9.8371 9.5495 9.3263 9.1440 8.9899 8.8563 8.7386 x 1.E-04 8.6332 7.9402 7.5348 7.2472 7.0242 6.8420 6.6879 6.5545 6.4368 x 1.E-03 6.3315 5.6394 5.2349 4.9482 4.7261 4.5448 4.3916 4.2591 4.1423 4.0379 3.3547 2.9591 2.6813 2.4679 2.2953 2.1508 2.0269 1.9187 1.8229 1.2227 0.9057 0.7024 0.5598 0.4544 0.3738 0.3106 0.2602 1 0.219384 0.048901 0.013048 0.003779 0.001148 0.000360 0.000116 32.5753 32.3521 32.1698 32.0157 19 4.33E-19 20 -2.1E-20 21 9.32E-22 22 -4E-23 23 1.68E-24 24 -6.7E-26 1/u 1 2 3 W(u) 4 5 6 7 8 9 x 1.E-01 0.007017 0.001148 0.008574 0.024915 0.048901 0.078333 0.111308 0.146413 0.182664 x 1.E+00 0.2194 0.5598 0.8289 1.0443 1.2227 1.3745 1.5066 1.6234 1.7281 25 2.58E-27 x 1.E+01 1.8229 2.4679 2.8570 3.1365 x 1.E+02 4.0379 4.7261 5.1299 5.4167 x 1.E+03 6.3315 7.0242 7.4295 7.7171 7.9402 8.1225 8.2766 8.4101 x 1.E+04 8.6332 9.3263 9.7318 10.0194 10.2426 10.4249 10.5790 10.7126 10.8304 x 1.E+05 10.9357 11.6289 12.0343 12.3220 12.5451 12.7275 12.8816 13.0152 13.1329 x 1.E+06 13.2383 13.9314 14.3369 14.6246 14.8477 15.0301 15.1842 15.3177 15.4355 x 1.E+07 15.5409 16.2340 16.6395 16.9272 17.1503 17.3326 17.4868 17.6203 17.7381 x 1.E+08 17.8435 18.5366 18.9421 19.2298 19.4529 19.6352 19.7894 19.9229 20.0407 x 1.E+09 20.1461 20.8392 21.2447 21.5323 21.7555 21.9378 22.0920 22.2255 22.3433 x 1.E+10 22.4486 23.1418 23.5472 23.8349 24.0581 24.2404 24.3945 24.5281 24.6459 x 1.E+11 24.7512 25.4444 25.8498 26.1375 26.3607 26.5430 26.6971 26.8307 26.9484 x 1.E+12 27.0538 27.7470 28.1524 28.4401 28.6632 28.8456 28.9997 29.1332 29.2510 x 1.E+13 29.3564 30.0495 30.4550 30.7427 30.9658 31.1482 31.3023 31.4358 31.5536 x 1.E+14 31.6590 32.3521 32.7576 33.0453 33.2684 33.4507 33.6049 33.7384 33.8562 x 1.E+15 33.9616 34.6547 35.0602 35.3479 35.5710 35.7533 35.9075 36.0410 36.1588 3.3547 3.5337 3.6855 5.6394 5.8214 5.9753 3.8173 3.9337 6.1086 6.2263 8.5279
When you do your work with a spreadsheet, make sure it is well organized, and always hand in an example of your calculations. Use the attached spreadsheet (Wellfunc.xls) to calculate W(u). Recognize that the following calculations are estimations as they are subject to the assumptions inherant in the equations we apply. 1. An industrial food-manufacturing operation wishes to expand, and it requires an improved water supply. They propose to construct a fully penetrating well in an infinite, horizontal, confined, homogeneous, isotropic aquifer, and they plan to pump at a constant rate of 20 L/s. If T = 1.3 x 10-2 m²/s, and S is known to range between 1.2 and 2.1 (x 104), make the following calculations. a. Considering the maximum and minimum S values, calculate the range of drawdown that would be expected at the property boundary for the manufacturing facility, 100 m from the pumping well at times of 5, 15, 100, 200 and 400 min after the start of pumping. Plot the values on a log-log graph of ho-h vs t to compare drawdown for both values of S. b. The environmental regulator has imposed a limitation on the drawdown from any well to prevent impacts to surrounding groundwater users. The drawdown limit is a maximum of 1.0 m at a distance of 250 m, after ten days of pumping. Is this well likely to be in compliance with the regulation? C. Estimate the impact of pumping at intermediate distances by calculating the range of drawdown for the max and min S that would occur at distances 10 m, 15 m, 60 m, and 500 m from the pumping well ten days after the start of pumping. Plot the values on a semi-log graph of ho-h vs r (r on the log scale). Determine the distance range beyond which drawdown is not likely to violate the regulation mentioned above in '1b'. euler= 0.577216 term term number coefficient u 1/u 1 1 5.00E-03 W(u) 2.00E+02 4.73E+00 2 -0.25 u 1 2 3 W(u) 4 5 6 7 8 9 3 0.055556 x 1.E-15 33.9616 33.2684 4 -0.01042 5 0.001667 6 -0.00023 7 2.83E-05 8 -3.1E-06 9 3.06E-07 10 -2.8E-08 11 2.28E-09 12 -1.7E-10 13 1.24E-11 14 -8.2E-13 15 5.1E-14 16 -3E-15 x 1.E-02 17 1.65E-16 x 1.E-01 18 -8.7E-18 X 32.8629 31.8821 31.7643 x 1.E-14 31.6590 30.9658 30.5604 30.2727 30.0495 29.8672 29.7131 29.5795 29.4618 x 1.E-13 29.3564 28.6632 28.2578 27.9701 27.7470 27.5646 27.4105 27.2769 27.1592 x 1.E-12 27.0538 26.3607 25.9552 25.6675 25.4444 25.2620 25.1079 24.9744 24.8566 x 1.E-11 24.7512 24.0581 23.6526 23.3649 23.1418 22.9595 22.8053 22.6718 22.5540 x 1.E-10 22.4486 21.7555 21.3500 21.0623 20.8392 20.6569 20.5027 20.3692 20.2514 x 1.E-09 20.1461 19.4529 19.0474 18.7598 18.5366 18.3543 18.2001 18.0666 17.9488 x 1.E-08 17.8435 17.1503 16.7449 16.4572 16.2340 16.0517 15.8976 15.7640 15.6462 x 1.E-07 15.5409 14.8477 14.4423 14.1546 13.9314 13.7491 13.5950 13.4614 13.3437 x 1.E-06 13.2383 12.5451 12.1397 11.8520 11.6289 11.4465 11.2924 11.1589 11.0411 x 1.E-05 10.9357 10.2426 9.8371 9.5495 9.3263 9.1440 8.9899 8.8563 8.7386 x 1.E-04 8.6332 7.9402 7.5348 7.2472 7.0242 6.8420 6.6879 6.5545 6.4368 x 1.E-03 6.3315 5.6394 5.2349 4.9482 4.7261 4.5448 4.3916 4.2591 4.1423 4.0379 3.3547 2.9591 2.6813 2.4679 2.2953 2.1508 2.0269 1.9187 1.8229 1.2227 0.9057 0.7024 0.5598 0.4544 0.3738 0.3106 0.2602 1 0.219384 0.048901 0.013048 0.003779 0.001148 0.000360 0.000116 32.5753 32.3521 32.1698 32.0157 19 4.33E-19 20 -2.1E-20 21 9.32E-22 22 -4E-23 23 1.68E-24 24 -6.7E-26 1/u 1 2 3 W(u) 4 5 6 7 8 9 x 1.E-01 0.007017 0.001148 0.008574 0.024915 0.048901 0.078333 0.111308 0.146413 0.182664 x 1.E+00 0.2194 0.5598 0.8289 1.0443 1.2227 1.3745 1.5066 1.6234 1.7281 25 2.58E-27 x 1.E+01 1.8229 2.4679 2.8570 3.1365 x 1.E+02 4.0379 4.7261 5.1299 5.4167 x 1.E+03 6.3315 7.0242 7.4295 7.7171 7.9402 8.1225 8.2766 8.4101 x 1.E+04 8.6332 9.3263 9.7318 10.0194 10.2426 10.4249 10.5790 10.7126 10.8304 x 1.E+05 10.9357 11.6289 12.0343 12.3220 12.5451 12.7275 12.8816 13.0152 13.1329 x 1.E+06 13.2383 13.9314 14.3369 14.6246 14.8477 15.0301 15.1842 15.3177 15.4355 x 1.E+07 15.5409 16.2340 16.6395 16.9272 17.1503 17.3326 17.4868 17.6203 17.7381 x 1.E+08 17.8435 18.5366 18.9421 19.2298 19.4529 19.6352 19.7894 19.9229 20.0407 x 1.E+09 20.1461 20.8392 21.2447 21.5323 21.7555 21.9378 22.0920 22.2255 22.3433 x 1.E+10 22.4486 23.1418 23.5472 23.8349 24.0581 24.2404 24.3945 24.5281 24.6459 x 1.E+11 24.7512 25.4444 25.8498 26.1375 26.3607 26.5430 26.6971 26.8307 26.9484 x 1.E+12 27.0538 27.7470 28.1524 28.4401 28.6632 28.8456 28.9997 29.1332 29.2510 x 1.E+13 29.3564 30.0495 30.4550 30.7427 30.9658 31.1482 31.3023 31.4358 31.5536 x 1.E+14 31.6590 32.3521 32.7576 33.0453 33.2684 33.4507 33.6049 33.7384 33.8562 x 1.E+15 33.9616 34.6547 35.0602 35.3479 35.5710 35.7533 35.9075 36.0410 36.1588 3.3547 3.5337 3.6855 5.6394 5.8214 5.9753 3.8173 3.9337 6.1086 6.2263 8.5279
Applications and Investigations in Earth Science (9th Edition)
9th Edition
ISBN:9780134746241
Author:Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Publisher:Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Chapter1: The Study Of Minerals
Section: Chapter Questions
Problem 1LR
Related questions
Question
Please answer each question in detail. Please ensure it is 100% done by human, please do not use AI or chatgpt.

Transcribed Image Text:When you do your work with a spreadsheet, make sure it is well organized, and always hand in an
example of your calculations. Use the attached spreadsheet (Wellfunc.xls) to calculate W(u). Recognize
that the following calculations are estimations as they are subject to the assumptions inherant in the
equations we apply.
1. An industrial food-manufacturing operation wishes to expand, and it requires an improved water
supply. They propose to construct a fully penetrating well in an infinite, horizontal, confined,
homogeneous, isotropic aquifer, and they plan to pump at a constant rate of 20 L/s. If T = 1.3 x 10-2
m²/s, and S is known to range between 1.2 and 2.1 (x 104), make the following calculations.
a. Considering the maximum and minimum S values, calculate the range of drawdown that
would be expected at the property boundary for the manufacturing facility, 100 m from the
pumping well at times of 5, 15, 100, 200 and 400 min after the start of pumping. Plot the
values on a log-log graph of ho-h vs t to compare drawdown for both values of S.
b. The environmental regulator has imposed a limitation on the drawdown from any well to
prevent impacts to surrounding groundwater users. The drawdown limit is a maximum of
1.0 m at a distance of 250 m, after ten days of pumping. Is this well likely to be in
compliance with the regulation?
C.
Estimate the impact of pumping at intermediate distances by calculating the range of
drawdown for the max and min S that would occur at distances 10 m, 15 m, 60 m, and 500
m from the pumping well ten days after the start of pumping. Plot the values on a semi-log
graph of ho-h vs r (r on the log scale). Determine the distance range beyond which
drawdown is not likely to violate the regulation mentioned above in '1b'.

Transcribed Image Text:euler= 0.577216
term
term
number coefficient
u
1/u
1
1
5.00E-03
W(u)
2.00E+02 4.73E+00
2
-0.25
u
1
2
3
W(u)
4
5
6
7
8
9
3 0.055556
x 1.E-15 33.9616
33.2684
4 -0.01042
5 0.001667
6 -0.00023
7 2.83E-05
8 -3.1E-06
9 3.06E-07
10 -2.8E-08
11 2.28E-09
12 -1.7E-10
13 1.24E-11
14 -8.2E-13
15
5.1E-14
16
-3E-15
x 1.E-02
17 1.65E-16
x 1.E-01
18 -8.7E-18
X
32.8629
31.8821 31.7643
x 1.E-14 31.6590 30.9658 30.5604 30.2727 30.0495 29.8672 29.7131 29.5795 29.4618
x 1.E-13 29.3564 28.6632 28.2578 27.9701 27.7470 27.5646 27.4105 27.2769 27.1592
x 1.E-12 27.0538 26.3607 25.9552 25.6675 25.4444 25.2620 25.1079 24.9744 24.8566
x 1.E-11 24.7512 24.0581 23.6526 23.3649 23.1418 22.9595 22.8053 22.6718 22.5540
x 1.E-10 22.4486 21.7555 21.3500 21.0623 20.8392 20.6569 20.5027 20.3692 20.2514
x 1.E-09 20.1461 19.4529 19.0474 18.7598 18.5366 18.3543 18.2001 18.0666 17.9488
x 1.E-08 17.8435 17.1503 16.7449 16.4572 16.2340 16.0517 15.8976 15.7640 15.6462
x 1.E-07 15.5409 14.8477 14.4423 14.1546 13.9314 13.7491 13.5950 13.4614 13.3437
x 1.E-06 13.2383 12.5451 12.1397 11.8520 11.6289 11.4465 11.2924 11.1589 11.0411
x 1.E-05 10.9357 10.2426 9.8371 9.5495 9.3263 9.1440 8.9899 8.8563 8.7386
x 1.E-04 8.6332 7.9402 7.5348 7.2472 7.0242 6.8420 6.6879 6.5545 6.4368
x 1.E-03 6.3315 5.6394 5.2349 4.9482 4.7261 4.5448 4.3916 4.2591 4.1423
4.0379 3.3547 2.9591 2.6813 2.4679 2.2953 2.1508 2.0269 1.9187
1.8229 1.2227 0.9057 0.7024 0.5598 0.4544 0.3738 0.3106 0.2602
1 0.219384 0.048901 0.013048 0.003779 0.001148 0.000360 0.000116
32.5753 32.3521
32.1698
32.0157
19 4.33E-19
20 -2.1E-20
21 9.32E-22
22
-4E-23
23 1.68E-24
24
-6.7E-26
1/u
1
2
3
W(u)
4
5
6
7
8
9
x 1.E-01 0.007017 0.001148 0.008574 0.024915 0.048901 0.078333 0.111308 0.146413 0.182664
x 1.E+00 0.2194 0.5598 0.8289 1.0443 1.2227 1.3745 1.5066 1.6234 1.7281
25 2.58E-27
x 1.E+01 1.8229 2.4679
2.8570 3.1365
x 1.E+02 4.0379 4.7261 5.1299 5.4167
x 1.E+03 6.3315 7.0242 7.4295 7.7171 7.9402 8.1225 8.2766 8.4101
x 1.E+04 8.6332 9.3263 9.7318 10.0194 10.2426 10.4249 10.5790 10.7126 10.8304
x 1.E+05 10.9357 11.6289 12.0343 12.3220 12.5451 12.7275 12.8816 13.0152 13.1329
x 1.E+06 13.2383 13.9314 14.3369 14.6246 14.8477 15.0301 15.1842 15.3177 15.4355
x 1.E+07
15.5409 16.2340 16.6395 16.9272 17.1503 17.3326 17.4868 17.6203 17.7381
x 1.E+08 17.8435 18.5366 18.9421 19.2298 19.4529 19.6352 19.7894 19.9229 20.0407
x 1.E+09 20.1461 20.8392 21.2447 21.5323 21.7555 21.9378 22.0920 22.2255 22.3433
x 1.E+10 22.4486 23.1418 23.5472 23.8349 24.0581 24.2404 24.3945 24.5281 24.6459
x 1.E+11 24.7512 25.4444 25.8498 26.1375 26.3607 26.5430 26.6971 26.8307 26.9484
x 1.E+12 27.0538 27.7470 28.1524 28.4401 28.6632 28.8456 28.9997 29.1332 29.2510
x 1.E+13 29.3564 30.0495 30.4550 30.7427 30.9658 31.1482 31.3023 31.4358 31.5536
x 1.E+14 31.6590 32.3521 32.7576 33.0453 33.2684 33.4507 33.6049 33.7384 33.8562
x 1.E+15 33.9616 34.6547 35.0602 35.3479 35.5710 35.7533 35.9075 36.0410 36.1588
3.3547 3.5337 3.6855
5.6394 5.8214 5.9753
3.8173
3.9337
6.1086
6.2263
8.5279
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 3 images

Recommended textbooks for you

Applications and Investigations in Earth Science …
Earth Science
ISBN:
9780134746241
Author:
Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Publisher:
PEARSON

Exercises for Weather & Climate (9th Edition)
Earth Science
ISBN:
9780134041360
Author:
Greg Carbone
Publisher:
PEARSON

Environmental Science
Earth Science
ISBN:
9781260153125
Author:
William P Cunningham Prof., Mary Ann Cunningham Professor
Publisher:
McGraw-Hill Education

Applications and Investigations in Earth Science …
Earth Science
ISBN:
9780134746241
Author:
Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Publisher:
PEARSON

Exercises for Weather & Climate (9th Edition)
Earth Science
ISBN:
9780134041360
Author:
Greg Carbone
Publisher:
PEARSON

Environmental Science
Earth Science
ISBN:
9781260153125
Author:
William P Cunningham Prof., Mary Ann Cunningham Professor
Publisher:
McGraw-Hill Education

Earth Science (15th Edition)
Earth Science
ISBN:
9780134543536
Author:
Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Publisher:
PEARSON

Environmental Science (MindTap Course List)
Earth Science
ISBN:
9781337569613
Author:
G. Tyler Miller, Scott Spoolman
Publisher:
Cengage Learning

Physical Geology
Earth Science
ISBN:
9781259916823
Author:
Plummer, Charles C., CARLSON, Diane H., Hammersley, Lisa
Publisher:
Mcgraw-hill Education,