Marathon Scoring

[K6LE]

I am trying to keep track of my CQ Marathon score as the year progresses but haven't figured out how to get the total Zones worked for the year.

Any hints?

[DL2RUM]

You are right, a direct custom query is missing.

First idea:

• ADIF export all QSOs from this year
• Create a new log file
• ADIf import these QSOs
• Use the CQ window

Other way: Use a SQLite tool and run this query:

Code: Select all

select distinct cq from logbook where datetime >= '2015-01-01' order by cast(cq as integer)

To see the first worked station use:

Code: Select all

select cq,callsign from logbook where datetime >= '2015-01-01' group by cast(cq as integer)