Sub 非稳定流承压水干扰井群法()
Dim tt, h, k, uu, t, rj, r, w As Double
Dim n, nj As Integer
Dim q(1 To 50), xc(1 To 50), yc(1 To 50), xj(1 To 50), yj(1 To 50), sj(1 To 50) As Double
tt = Sheet2.Cells(2, 1).Value
n = Sheet2.Cells(2, 2).Value
h = Sheet2.Cells(2, 3).Value
k = Sheet2.Cells(2, 4).Value
t = Sheet2.Cells(2, 5).Value
uu = Sheet2.Cells(2, 6).Value
rj = Sheet2.Cells(2, 7).Value
nj = Sheet2.Cells(2, 8).Value
For i = 1 To n
xc(i) = Sheet2.Cells(5 + i, 1).Value
yc(i) = Sheet2.Cells(5 + i, 2).Value
q(i) = Sheet2.Cells(5 + i, 3).Value
Next i
For i = 1 To nj
xj(i) = Sheet2.Cells(5 + i, 5).Value
yj(i) = Sheet2.Cells(5 + i, 6).Value
Next i
For i = 1 To 50
Sheet2.Cells(i + 5, 8).Value = ""
Next i
'--------------------Theis计算-------------------------
For i = 1 To nj
sq = 0
For j = 1 To n
xx = xj(i) - xc(j)
yy = yj(i) - yc(j)
r = Sqr(xx * xx + yy * yy) + rj
Call wu(uu, t, tt, r, w) '--调用Theis井函数--
sq = sq + q(j) * w / (2 * k * 3.14)
Next j
sj(i) = sq / (2 * h)
Next i
'-----------Excel 输出-----------
For i = 1 To nj
Sheet2.Cells(i + 5, 8).Value = sj(i)
Next i
End Sub
Sub 非稳定流潜水干扰井群法()
Dim tt, h, k, uu, t, rj, r, w As Double
Dim n, nj As Integer
Dim q(1 To 50), xc(1 To 50), yc(1 To 50), xj(1 To 50), yj(1 To 50), sj(1 To 50) As Double
tt = Sheet2.Cells(2, 1).Value
n = Sheet2.Cells(2, 2).Value
h = Sheet2.Cells(2, 3).Value
k = Sheet2.Cells(2, 4).Value
t = Sheet2.Cells(2, 5).Value
uu = Sheet2.Cells(2, 6).Value
rj = Sheet2.Cells(2, 7).Value
nj = Sheet2.Cells(2, 8).Value
For i = 1 To n
xc(i) = Sheet2.Cells(5 + i, 1).Value
yc(i) = Sheet2.Cells(5 + i, 2).Value
q(i) = Sheet2.Cells(5 + i, 3).Value
Next i
For i = 1 To nj
xj(i) = Sheet2.Cells(5 + i, 5).Value
yj(i) = Sheet2.Cells(5 + i, 6).Value
Next i
For i = 1 To 50
Sheet2.Cells(i + 5, 8).Value = ""
Next i
'--------------------Theis计算-------------------------
For i = 1 To nj
sq = 0
For j = 1 To n
xx = xj(i) - xc(j)
yy = yj(i) - yc(j)
r = Sqr(xx * xx + yy * yy) + rj
Call wu(uu, t, tt, r, w) '--调用Theis井函数--
sq = sq + q(j) * w / (2 * k * 3.14)
Next j
sj(i) = h - Sqr(h * h - sq)
Next i
'-----------Excel 输出-----------
For i = 1 To nj
Sheet2.Cells(i + 5, 8).Value = sj(i)
Next i
End Sub |