Page 1 of 1

Marathon Scoring

Posted: Mon 16. Nov 2015, 16:35
by 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?

Re: Marathon Scoring

Posted: Mon 16. Nov 2015, 23:37
by 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)