LoTW Statistics Compare routine?

Need help? - Post here and we will find a solution for you.
User avatar
ac5aa
Advanced Class
Posts: 77
Joined: 14 Jan 2016, 19:45
Location: Austin, TX

LoTW Statistics Compare routine?

Post by ac5aa » 22 Jan 2016, 21:38

Has anyone written software to compare the LoTW award statistics listing to the Log4OM database with the idea of allowing the user to reconcile them? As a new user, I'm having to crawl through the chart and the Log4OM Awards listing one mode at a time to compare and see where I'm missing 5-6 country counts so that I can get them to agree. It doesn't help that the Statistics are presented for only one band/mode at a time rather than in the same format as the LoTW listing where all the info about one country is listed on one line. Just wondering. I'd rather be hamming than trying to get my data straightened out! :-)

73, Duane
73, Duane AC5AA

User avatar
W7DRM
Log4OM Alpha Team
Posts: 583
Joined: 19 Feb 2014, 19:44

Re: LoTW Statistics Compare routine?

Post by W7DRM » 22 Jan 2016, 21:54

Duane,

Are you creating more work for me? :o

Let me ponder this...

Doug - W7DRM

User avatar
ac5aa
Advanced Class
Posts: 77
Joined: 14 Jan 2016, 19:45
Location: Austin, TX

Re: LoTW Statistics Compare routine?

Post by ac5aa » 22 Jan 2016, 22:07

Sorry, Doug! I had no idea where this one would splatter! An alternative might be to have the ability to print an awards listing formatted the same as the ARRL's LoTW one - that would certainly speed the process of checking one against the other.

73, Duane
73, Duane AC5AA

User avatar
IW3HMH
Site Admin
Posts: 2378
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: LoTW Statistics Compare routine?

Post by IW3HMH » 02 Feb 2016, 09:52

Any reference to this award export format?
Daniele Pistollato - IW3HMH

User avatar
ac5aa
Advanced Class
Posts: 77
Joined: 14 Jan 2016, 19:45
Location: Austin, TX

Re: LoTW Statistics Compare routine?

Post by ac5aa » 04 Feb 2016, 22:07

Hi Daniele, You can view this by:

Log into LoTW
Select "Awards" button
Select "DXCC Award Account"
At the bottom of that page, click "View Award Credit Matrix"
Click the "No Scroll" button to see the entire table of results

My entire file is too large so I've truncated it to the first page so you can get an idea . . . It can be sorted either by the prefix or by the entity. I just left it in the default "prefix sort."

73, Duane
Attachments
AC5AA Logbook DXCC Award Account.pdf
(95.95 KiB) Downloaded 77 times
73, Duane AC5AA

User avatar
W7DRM
Log4OM Alpha Team
Posts: 583
Joined: 19 Feb 2014, 19:44

Re: LoTW Statistics Compare routine?

Post by W7DRM » 04 Feb 2016, 23:25

Duane,

Have you tried the Statistics and Awards window, Country/QSO status grid tab? It displays the three modes Ph, CW, Dig for each band (column across) and for each country (row down) in one view.
Country_QSOGrid.jpg
Country_QSOGrid.jpg (152.45 KiB) Viewed 2580 times
Doug - W7DRM

G3ZSS
Log4OM Beta Team
Posts: 145
Joined: 21 Jan 2013, 15:32

Re: LoTW Statistics Compare routine?

Post by G3ZSS » 04 Feb 2016, 23:32

Interestingly I used to use DX4WIN before becoming a LOG4OM convert. AD1C had a great routine for comparing LOTW with your DX4WIN log. It required you to do an ADIF download of your DXCC records from LOTW and then comparing with your own log. You can get an idea of AD1C's work at http://dx4win.ad1c.us/lotw/index.html. I believe you are looking for something similar for LOG4OM?
73 Peter G3ZSS
73 Peter G3ZSS

User avatar
ac5aa
Advanced Class
Posts: 77
Joined: 14 Jan 2016, 19:45
Location: Austin, TX

Re: LoTW Statistics Compare routine?

Post by ac5aa » 05 Feb 2016, 03:59

Yes, Peter - I'm moving from DX4WIN to Log4OM and am very familiar with Jim, AD1C's fine work for that logger. He has singlehandedly kept it alive for many people. I used Doug's software for getting a start on this problem of setting Log4OM to match my current status, but it is a very difficult process for any QSO's credited in the 1990's or earlier. This is because the DXCC desk didn't log the actual date of the QSO which was credited for the award. Makes getting the log in sync a bit of a manual mess. I was hoping to at least get a listing that could be scanned as quickly as the LOTW downloaded table, if nothing "automatic" could be created. I'm beginning to think I'm the only one with this problem, but then that's OK. I'm enjoying learning Log4OM and "reshaping my head" to work with it.
73, Duane AC5AA

User avatar
ac5aa
Advanced Class
Posts: 77
Joined: 14 Jan 2016, 19:45
Location: Austin, TX

Re: LoTW Statistics Compare routine?

Post by ac5aa » 05 Feb 2016, 04:04

Thanks, Doug - I'll give that a shot tomorrow and see if that helps.
73, Duane AC5AA

User avatar
ac5aa
Advanced Class
Posts: 77
Joined: 14 Jan 2016, 19:45
Location: Austin, TX

Re: LoTW Statistics Compare routine?

Post by ac5aa » 05 Feb 2016, 16:55

Yes, Doug - the Country/QSO status tab does present what I need. And I can click on a particular band/mode and pull up the QSO's that contribute to it. I struggle a little with the Y and V distinction for received QSL's - not the definitions, but just that they look so similar. DX4WIN uses an asterisk * to indicate that the confirmation has been submitted and credited, which makes the grid a lot easier to pick out ones that still need focus either to work or get confirmations. Just a different style, and I'm sure I'll get accustomed to this format. Thanks for the suggestion!
73, Duane AC5AA

Post Reply