Well, for pairs, there are 6 ways to be dealt them: 4 choices for the first card times 3 choices for the second card divided by 2 (so you don't count AsAd and AdAs as different hands).

For suited hands there are four ways they can be dealt (one for each suit).

For off-suited hands there are 12 ways they can be dealt (four choices for the first card times 3 offsuited matches for each).

So, put the KS list in your spreadsheet and for each pair use a factor of 6, for each suited hand use a factor of 4 and for each unsuited (non-pair) hand use a factor of 12.