|
楼主 |
发表于 2014-9-28 22:22
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
20000000卦测试代码如下:- Public Sub byglcs() '变爻概率测试
- Dim t%, d%, r%, i%, j%, k&, scs%, ys1%, ys2%, js(0 To 6) As Long, n%, ti! '天、地、人、蓍草数、余数、计数
- ti = Timer
- For k = 1 To 20000000 '两千万卦测试
- n = 0 '累计变爻数
- For i = 1 To 6 '六爻成一卦
- scs = 49: r = 0
- Randomize
- For j = 1 To 3 '三变成一爻
- r = r + 1
- t = Int((scs - 1 - 1) * Rnd()) + 1
- d = scs - 1 - t
- ys1 = t Mod 4: If ys1 = 0 Then ys1 = 4
- ys2 = d Mod 4: If ys2 = 0 Then ys2 = 4
- t = t - ys1
- d = d - ys2
- r = r + ys1 + ys2
- scs = t + d
- Next j
- If scs / 4 = 6 Or scs / 4 = 9 Then n = n + 1
- Next i
- js(n) = js(n) + 1
- Next k
- Sheets("概率测试").Range("c11").Resize(7) = Application.Transpose(js)
- MsgBox "用时:" & Format(Timer - ti, "0.0000") & "秒", , "友情提示"
- End Sub
复制代码 |
|