USCA - US County Award

Post Reply
it9gsf
Novice Class
Posts: 7
Joined: 30 Apr 2025, 06:49

USCA - US County Award

Post 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.
User avatar
G4POP
Log4OM Alpha Team
Posts: 11586
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: USCA - US County Award

Post 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
73 Terry G4POP
it9gsf
Novice Class
Posts: 7
Joined: 30 Apr 2025, 06:49

Re: USCA - US County Award

Post 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.
User avatar
G4POP
Log4OM Alpha Team
Posts: 11586
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: USCA - US County Award

Post by G4POP »

Sort by country dxcc in excel and bulk delete unwanted QSO's
73 Terry G4POP
Post Reply