'计算排名
Function SortAry(ary, desc)
KeepChecking = TRUE
Do Until KeepChecking = FALSE
KeepChecking = FALSE
For I = 0 to UBound(ary)
If I = UBound(ary) Then Exit For
If desc Then
If ary(I) < ary(I+1) Then
FirstValue = ary(I)
SecondValue = ary(I+1)
ary(I) = SecondValue
ary(I+1) = FirstValue
KeepChecking = TRUE
End If
Else
If ary(I) > ary(I+1) Then
FirstValue = ary(I)
SecondValue = ary(I+1)
ary(I) = SecondValue
ary(I+1) = FirstValue
KeepChecking = TRUE
End If
End If
Next
Loop
SortAry = ary
End Function
Function GetKeyInAry(ary, value)
key = 0
For I = 0 to UBound(ary)
If ary(I) = value Then
key = I + 1
Exit For
End If
Next
GetKeyInAry = key
End Function