[Dx4win] Procedure? Count of QSOs by Band/mode?

[k2dbk at k2dbk.com]

The only way that I can think of to do it entirely using DX4WIN is to do a filter for that specific band and mode then look at Filter->Count. This means you have to manually go through each possible combination of band/mode, which is going to be painful. Jim, AD1C, may have something easier up his sleeve.

If you're good with Excel, you could open a logbook window that's been configured to include the band & mode, use "write to file" (which created a CSV file) then play around with it in Excel.

What I did was to export the file from a logbook report, then manipulate it using Linux tools. The exact steps will depend on specifically what your logbook report looks like, but here's something to get your started if you are comfortable using the Linux command line:

cut -f4,5 -d, temp.csv | sort | uniq -c  | sort

Here's what each piece does:

1) cut -f4,5 -d, temp.csv		Extract only columns 4 & 5 from my CSV file which for me are the columns with band and mode. The -d, says that the file is comma delimited, and temp.csv is the name of my file.

The "|" says to pass that to the next step;

2) Sort that output. This makes it so that everything is sorted such that all combinations of band,mode are next to each other. In other words, you'll have 20m, SSB all in a row, 15m,CW all together, etc. This is necessary for the next step;

3) Display a line consisting of the number of times each band,mode instance appears in the file.

4) Sort again which this time results in the results being displayed with the least frequent band/mode combination first and most frequent last.

I can tell you that it took far less time to actually do that than to write this up. 😊 

73,

David, K2DBK

-----Original Message-----
From: dx4win-bounces at mailman.qth.net <dx4win-bounces at mailman.qth.net> On Behalf Of jmaass at k8nd.com
Sent: Tuesday, April 22, 2025 7:02 PM
To: DX4WIN at mailman.qth.net
Subject: [Dx4win] Procedure? Count of QSOs by Band/mode?

Is there a way to generate a list of the number of QSOs in the log for each band/mode?

73,  Jeff  K8ND  PJ2ND
______________________________________________________________
DX4WIN mailing list
Home: http://mailman.qth.net/mailman/listinfo/dx4win
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:DX4WIN at mailman.qth.net

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html