Reply To: !

[upsidedown]

@GREENcar

I have counted the letters in your post and computed this tabulation:

A B C  D E  F G H  I  K L  M N  O  P Q R S  T  U V W Y
9 1 10 3 27 4 3 12 12 1 10 3 14 17 3 1 9 13 16 5 1 3 5

Here are IoC values, rounded to four decimal places, computed from portions of the above letter frequencies (e.g. A,B,C means I computed the IoC of your message after removing all letters that are not A, B, or C):

A:         1.0000
A,B:       0.8000
A,B,C:     0.4263
A,B,...,G: 0.2782
A,B,...,M: 0.1398
A,B,...,Y: 0.0675

I suggest that you test your spreadsheet on each of these cases until you find one that differs (hopefully early on). You can then try to compute the same value by hand (with the aid of a calculator) and see what’s gone wrong.