by lawitcher1 » Mon Dec 07, 2015 6:04 pm
Thanks, that worked perfectly. You predicted perfectly what I did, and I DID learn from it. Here is a quirk that now needs to be addressed. I was informed (after the calculations were done) that cell A5 CAN be added as a duplicate under certain conditions, that being that the same person (call sign) can work any of the six bands (160m, 80m,40m,20m, 15m & 10m) on phone and get a credit (multiplier) for each band. The same also applies when using CW. If there is a duplicate for that call sign on these parameters, then it would NOT be counted. Here is a copy of the rules enhancements that were mailed to me tis morning:
MULTIPLIERS:
A. California Stations:
Count U.S. states (50) and Canadian areas (8): MR, QC, ON, MB, SK, AB, BC and NT where:
• MR = Maritime provinces plus Newfoundland and Labrador (NB, NL, NS, PE) • NT = Northern Territories (NT, NU, YT)
Maximum of 58 Multipliers
Note: Although the “CA” abbreviation is not used as a multiplier in this contest, the first valid CA county logged will count as the multiplier for California. California stations must log all CA contacts with their 4-letter county abbreviation; everything else as two letters, including DX for all stations outside of the U.S. and Canada.
B. Non-California Stations
Count all 58 California Counties for a maximum of 58 multipliers.
SCORE:
The final score is the total number of QSO Points multiplied by the total number of multipliers (58 maximum).
QSO Points = (CW Qs x 3 pts) + (Phone Qs x 2 pts)
Final Score = QSO Points x Multipliers
MODES: CW, Phone
BANDS: 160, 80, 40, 20, 15 and 10 meters.
Stations may be worked once on CW and once on Phone on each band.
Since I screwed up the color in the cells in columns K, L & M, would you also be kind enough to point me in the right direction to repair them. I was trying to get the duplicates to highlight.