|
‘不知道 是否正确?- Sub 左洞上台阶()
- Dim c, a0, a1, a2, a3, k, c1, z As Double
- Dim l, l1, h, h1, h2, h3 As Double
- Dim X, y, x1, x2, x3, x4, x5, y1, y2, y3, y4, y5 As Double
- Dim w1, w2, w4, w5 As Double
- Dim k1, k2, k3 As Double
-
- Dim she As Object
- Dim m As Integer, Ks As Double
-
- Const pi = 3.14159265358979
- Const a = 72.215
- Const ai = 62.36
- Const aa = 73.246
- Const R = 2500
- Const R2 = 8.3405
- k = InputBox("请输入里程")
- For Each she In Sheets
- m = m + 1
- Ks = Choose(m, k, k - 6, k - 2 * 6, k - 3 * 6)
- With she
- .[C5] = Application.Text(Ks, "\左洞洞衬砌 K0\+000.00")
- .Name = Application.Text(Ks, "\ K0\+000.00")
-
- If Ks <= 3859.351 Then
- h = 240.1 + ((Ks - 3680.649) / 89.351) ^ 2 * 0.2
-
- ElseIf Ks <= 4753.034 Then
- l1 = Ks - 3859.351
- h = 240.898 + l1 * 0.00894
-
- ElseIf k <= 4922.966 Then
- h = 248.883 + (Ks - 4753.034) * 0.00894 + ((Ks - 4753.034) / 84.966) ^ 2 * 0.435
- End If
- h1 = h + 2.74
- .Range("d9") = h1 '或h?
- h2 = h + R2 / (2 ^ 0.5)
- .Range("d10") = h2
- h3 = h + R2
- .Range("d11") = h3
-
- 'k1的计算过程
- End With
- Next
- End Sub
复制代码 |
|