Re: WAS Report Like DXCC Report


If you are using LOTW, all the WAS reports are there at a button click.
And the WAS reports look a lot alike the DXCC reports in LOTW.
DXK is a great program. I am 2 states shy of 10 band WAS needing one more
state on 10M and 6M.
Tracking on the tool that will issue the awards and endorsement made it

73 Mike K9MK

-----Original Message-----
From: [] On Behalf Of Dave AA6YQ
Sent: Monday, June 29, 2020 12:56 PM
Subject: Re: [DXLab] WAS Report Like DXCC Report

+ AA6YQ comments below

How would I go about writing a report for WAS that looks like the DXCC
report? I can create one in Excel from the individual
reports, but it would be nice to have one in the DXCC report format so I
could see readily what I was missing.

+ Customizing DXKeeper's progress reports is generally limited to filtering
the Log Page Display before invoking them, which you can
if desired automate with a script.

+ For complete freedom in WAS report generation, make copy of your Log file,
and then direct Excel to open the QSOs and WASProgress
tables in your Log. The columns in the QSOs table are documented here:


+ The WASProgress table has one row for each US state. There's a column for
Mixed, and a column for each band valid for WAS credit.
Each cell is either blank (meaning "no logged QSO") or contains one of these

W - worked

R - worked and requested

C - confirmed

S - confirmed, and included in a WAS submission

V - WAS award credit granted.


Dave, AA6YQ

Join to automatically receive all group messages.