US Worked All Counties CQ USA-CA) award

[EA3GCV]

Hello Tom,

Please find attached a report which automatically selects all QSOs having the US county and confirmed either by QSL card, LoTW or eQSL. Unzip then copy the US Counties.spq file in the QUERIES folder. Opern Swisslog and go to View / Logbook (select view) then load this query and perform the following steps:

• Select the mode/band combination by means of the auto filters in case you need to select any specific band/mode. Otherwise go to next step.
  
• Select the FIRST County of the listing: Press the penultimate button in toolbar to select the First/Last QSO in a group then select the SUB-REGION field from the left side and move it to the right side (the group field). Only the Sub-Region field must be in the Group fields section, If there are other fields remove them. Make sure the FIRST option is checked.
  
• Press OK and the listing will contain the first County for the selected band/mode combination.
  
• Export QSO (press the fifth button starting from left) and select "Microsoft Excel". Check the Export column headers option and open it in Excel.
  
• Remove the fields not required by the CQ award such as QSL-R, LOTW-R, eQSL-R, EQSLAG and Registry Internal Nr. Save the file then send it to the award manager.
  

Best 73