| A | B | C | D | |
|---|---|---|---|---|
1 | Item - | Notes - | ||
2 | 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 | ||
3 | Make a copy (File...Make Copy) to have your own editable copy of this spreadsheet | |||
4 | Locked pages | All areas, except data entry areas, have been Protected to prevent accidental changes. For those with knowledge of spread sheets, feel free to unprotect sheets and make changes as necessary | ||
5 | Callsign Comparison Worksheet | The main sheet, where you enter your calls and ratings. | ||
6 | Callsigns | Enter up to 10 call signs of your choice here. Do not use slashes or other characters only numbers and letters. | ||
7 | These are automatically calculated based on callsigns you enter | # of CW Elements | Calculates total number of dits and dahs in letters and numbers in each of your callsigns | 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. |
8 | CW Weight | Calculates total number of dits and dahs in letters and numbers in each of your callsigns | ||
9 | Weighted Values for Character Counts | Calculates weighted totals. Each dit counts as one and each dah counts as three. | ||
10 | Entering Subjective Rating Information | 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. | |
11 | 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. | ||
12 | Phonetic Clarity | Rate each call on how the call sign sounds phonetically and how easy each phonetic is to pronounce | ||
13 | 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 | ||
14 | SSB Emphasis Letters | see above under CW Emphasis | ||
15 | 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. | ||
16 | Total | Total Score for all categories | The Lower the Score the Better | |
17 | Average | Average Score for all categories | ||