Page 1 of 1

USCA - US County Award

Posted: 03 May 2025, 14:44
by it9gsf
Hello!

This is Fabio, IT9GSF. Some weeks ago I started to study Log4OM. I was using MacLoggerDX and coming back to Windows is due to
the very good presentations I see on Youtube with some of best italian DXers and old well known amateurs as Luciano, I0JBL.

I've already started and configured the software (CAT, remote CAT, QRZ.COM, etc.) and, even if the system is slower than the Mac based
MacLoggerDX (I have a log with 90K QSOs) I think I will extensively use Log4OM for its potential.

What I don't understand yet is how to print a list of an award request, or how to generate a file (excel?) with all QSO/CFMS/QSL listed.
Is it possible to generate an excel file or a printable list?

Is there a tutorial about this topic? I didn't find it!

A pratical example for me could be not a DXCC example but an example on the USCA, the US Counties Award, now resumed by MARAC, the Mobile
Amateurs Radio Award Club, after the death of the CQ Magazine.

Your help, with samples, will be very appreciated! I think I have almost 3000 counties worked in my log!

THANK YOU!

73 de fabio, IT9GSF.

Re: USCA - US County Award

Posted: 03 May 2025, 15:32
by G4POP
QSL Manager

Use filters for award refs

add filters for confirmation types - Received = Yes (Or)

Click Excel button at bottom when filtered to your requirements

Re: USCA - US County Award

Posted: 03 May 2025, 16:14
by it9gsf
Hi Terry!
Thank you for the answer. I have tried to do as you wrote but this way I obtain a file with a list of all confirmed QSOs.
I need only one confirmed contact listed per county.
The counts are large so it is not easy to erase duplicate counties listed (or how to do that in excel?).

Regards,
Fabio, IT9GSF.

Re: USCA - US County Award

Posted: 03 May 2025, 18:19
by G4POP
Sort by country dxcc in excel and bulk delete unwanted QSO's