香港新浪網 MySinaBlog
Emily | 29th Oct 2006, 11:52 AM | General | (7097 Reads)

統計1-49 數字組合數量

EH 問題

排列組合1-49號碼, 任選6個不重複, Combin(49,6)=13983816 種排列方式

最小的總和是1 +2 +3 +4+ 5+ 6 = 21, 最大的總和是44+45+46+47+48+49=279 都只有一種排列

請問如何計算另外其他合22-278 的排列數目, 例如合是101,共有58446種排列

 

 (閱讀全文)

Emily | 20th Oct 2006, 18:03 PM | General | (1008 Reads)

趣味性的 Bug: Characters.Count

Sub CharCounts()
    
    Dim i As Long
    
    With ActiveCell
        Debug.Print .Characters.Text, .Characters.Count
        
        For i = 1 To .Characters.Count
            Debug.Print .Characters(i, 1).Caption, .Characters(i, 1).Count
        Next i
    End With
    
End Sub


 

 (閱讀全文)

Emily | 2nd Oct 2006, 00:10 AM | General | (1410 Reads)

Regular Expression Laboratory

If you are a developer or just concerned with text processing tasks, the Regular Expression Laboratory is a tool that you need. In fact, you felt that you need a program like this but could not formalize your needs. We have done this job for you. Now you can construct your regular expressions with much ease and test them by applying to an arbitrary text.

Details and Download: http://www.silveragesoftware.com/rxl.html

 

另外由 Ming 提供的 The Python Regular Expression Debugger

Ref: Regular Expression


Emily | 1st Oct 2006, 19:30 PM | API / Add-in | (2529 Reads)

Change Color when Mouse On Cell

A nice API code from Ivan F Moala but it will affect Excel performance

 (閱讀全文)