|
本帖最后由 yjh_27 于 2019-6-13 12:55 编辑
暴力计算100个- Sub aa()
- arr = [b2:n2]
- ReDim brr(1 To 65000, 1 To UBound(arr, 2) + 1) '计算100个结果,可修改
- i12 = 200 \ arr(1, 1)
- If i12 > 9 Then i12 = 9
- For i1 = 0 To i12
- he1 = i1 * arr(1, 1)
- i22 = (200 - he1) \ arr(1, 2)
- If i22 > 9 Then i22 = 9
- For i2 = 0 To i22
- he2 = he1 + i2 * arr(1, 2)
- i32 = (200 - he2) \ arr(1, 3)
- If i32 > 9 Then i32 = 9
- For i3 = 0 To i32
- he3 = he2 + i3 * arr(1, 3)
- i42 = (200 - he3) \ arr(1, 4)
- If i42 > 9 Then i42 = 9
- For i4 = 0 To i42
- he4 = he3 + i4 * arr(1, 4)
- i52 = (200 - he4) \ arr(1, 5)
- If i52 > 9 Then i52 = 9
- For i5 = 0 To i52
- he5 = he4 + i5 * arr(1, 5)
- i62 = (200 - he5) \ arr(1, 6)
- If i62 > 9 Then i62 = 9
- For i6 = 0 To i62
- he6 = he5 + i6 * arr(1, 6)
- i72 = (200 - he6) \ arr(1, 7)
- If i72 > 9 Then i72 = 9
- For i7 = 0 To i72
- he7 = he6 + i7 * arr(1, 7)
- i82 = (200 - he7) \ arr(1, 8)
- If i82 > 9 Then i82 = 9
- For i8 = 0 To i82
- he8 = he7 + i8 * arr(1, 8)
- i92 = (200 - he8) \ arr(1, 9)
- If i92 > 9 Then i92 = 9
- For i9 = 0 To i92
- he9 = he8 + i9 * arr(1, 9)
- i102 = (200 - he9) \ arr(1, 10)
- If i102 > 9 Then i102 = 9
- For i10 = 0 To i102
- he10 = he9 + i10 * arr(1, 10)
- i112 = (200 - he10) \ arr(1, 11)
- If i112 > 9 Then i112 = 9
- For i11 = 0 To i112
- he11 = he10 + i11 * arr(1, 11)
- i122 = (200 - he11) \ arr(1, 12)
- If i122 > 9 Then i122 = 9
- For i12 = 0 To i122
- he12 = he11 + i12 * arr(1, 12)
- i132 = (200 - he12) \ arr(1, 13)
- If i132 > 9 Then i132 = 9
- For i13 = 0 To i132
- he = he12 + i13 * arr(1, 13)
- If he >= 199 And he <= 200 Then
- ii = ii + 1
- brr(ii, 1) = i1
- brr(ii, 2) = i2
- brr(ii, 3) = i3
- brr(ii, 4) = i4
- brr(ii, 5) = i5
- brr(ii, 6) = i6
- brr(ii, 7) = i7
- brr(ii, 8) = i8
- brr(ii, 9) = i9
- brr(ii, 10) = i10
- brr(ii, 11) = i11
- brr(ii, 12) = i12
- brr(ii, 13) = i13
- brr(ii, 14) = he
- If ii = UBound(brr) Then GoTo 100
- End If
- Next
- Next
- Next
- Next
- Next
- Next
- Next
- Next
- Next
- Next
- Next
- Next
- Next
- 100:
- Range("b5").Resize(ii, 14) = brr
- End Sub
复制代码 |
|