|
Item -
|
Notes -
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Author
|
This spread sheet was created to
accompany an article by Anthony Luscre K8ZT to assist in choosing a new call
sign. All Rights are reserved and no claims of accuracy are guaranteed.
Please contact author at k8zt@arrl.net
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Locked
pages
|
All areas, except data entry
areas, have been Protected to prevent accidental changes. For those knowledge
of spread sheets, feel free to unprotect sheets and make changes as necessary
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Callsign
Comparison Worksheet
|
The main sheet, where you enter
your calls and ratings.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CW Char
|
Worksheet to calculate Number of
CW Characters.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CW
Weight
|
Worksheet to calculate Weighted
Total Length of CW Characters.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Weighted
Values for Character Counts
|
CW Character Count and CW
Character Weighted Totals are each multiplied by a constant to more better
fit them into 1 to 10 range of self rated values in the other categories. If
you would like you can change these values on their respective worksheets (see
Locked Pages above).
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Entering
Information
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Callsign
|
Enter up to 10 call signs of
your choice here. Do not use slashes or other characters only numbers and
letters.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# of
Characters
|
Calculates total number of
letters and numbers in each of your callsigns
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# of CW
Elements
|
Calculates total number of dits
and dahs in letters and numbers in each of your callsigns
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Weighted
Length of Characters
|
Calculates weighted totals. Each
dit counts as one and each dah counts as three.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Visual
Appearance
|
Rate each of your calls from 1
(best) to 10(least) on how will it look on a QSL card or on vehicle license
plates. You may rate more than one with same number.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Letter
Clarity
|
Rate each of your calls from 1
(best) to 10(least) on how on letter pronunciation clarity (without
phonetics). For example, the letters B, D, and E, tend to sound alike,
whereas letters like R, X, and O have their own unique sounds and are easier
to distinguish.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Phonetic
Clarity
|
Rate each call on how the call
sign sounds phonetically and how easy each phonetic is to pronounce
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CW
Emphasis Letters
|
emphasis letters for DX pileups
in CW and SSB. Hard consonants sound best on SSB at the end of a call sign,
and a call sign ending with a dah is considered preferable in CW, but some
letters, such as K, can be mistaken for prosigns (K = invitation to transmit,
the “go ahead” signal) instead of the last letter of a call sign
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SSB Emphasis Letters
|
see above under CW Emphasis
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CW
Rhythm
|
I put various call signs into my keyer’s memory and played them
back at various speeds to rank their desirability. Use the 1 to 10 scale here
also.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total
|
Total Score for all categories
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Average
|
Average Score for all categories
|
|
|
|
|
|
|
|
|
|
|
|
|
|