Hi to all,
Past week-end the frequencies had the great CQWW CW contest... I try to partecipate for the first time.
But, at one point, I would like to know the score... Fortunately, I was using the wonderfull CQRLog along with its SQLConsole!
So, I used this "little" SQL query to have the total... I copy it here the SQL command if someone had the same need:
SELECT (SEL.EU + SELDUE.NOEU*3)PUNTI_QSO, W.WAZ,D.ENT, ((SEL.EU + SELDUE.NOEU*3) * (W.WAZ + D.ENT))TOTALE
FROM (SELECT COUNT(*)EU FROM view_cqrlog_main_by_qsodate
WHERE QSODATE >= '2020-11-28' AND QSODATE <= '2020-11-29'
and cont = 'EU' AND DXCC_REF <> 'I')SEL,
(SELECT COUNT(*)NOEU FROM view_cqrlog_main_by_qsodate
WHERE QSODATE >= '2020-11-28' AND QSODATE <= '2020-11-29'
and cont <> 'EU')SELDUE,
(SELECT COUNT(*)WAZ FROM
(SELECT WAZ FROM view_cqrlog_main_by_qsodate
WHERE QSODATE >= '2020-11-28' AND QSODATE <= '2020-11-29'
GROUP BY WAZ)x)W,
(SELECT COUNT(*)ENT FROM
(SELECT DXCC_REF FROM view_cqrlog_main_by_qsodate
WHERE QSODATE >= '2020-11-28' AND QSODATE <= '2020-11-29'
GROUP BY DXCC_REF)n)D
It's clear that is in Italian and I am excluding my country by typing "I": OMs from other country must change this value and OMs outside from Europe should change "EU" according to their location...
The result is a total of points, the number of entity, the number of zones and the great total.
It's would be nice if should be implemented in the program as a standard inquiry :-)
Best 73,
Franco IK7XJA
HI Franco!
Thanks for SQL!
Perhaps SQL console should have "save my sql" option?
There are so many contests and so many ways to count score that it would be quite a job to cover them all. Specially when cqrlog is not a contest program. There are better ones designed just for contest working needs.
Cqrlog has simple "contest notepad" to keep track of serial numbering, contest messages and basic duplicate checking. Also the latest version compiled from GitHub source has basic cabrillo export. It counts qsos and displays worked dxcc countries but does not try to count scrore.
That is mainly for "sunday contester" like me.
I have used it in many contests (just <100 qsos always) and now with cabrillo export it has made living quite easy.
Serious contesters should how ever use N1MM or similar programs for proper contest support.
--
Saku
OH1KH
Hi dear Saku, I'm also a Sunday contester like you :-)
I've just saved the query in the SQL console and I share it here and on my site for friends needing it... just to say that CQRLog is a nice and powerful logging software.
Thanks again, and best 73
Franco IK7XJA